phpstock/app/admin/controller/Supplier.php

<?php

namespace app\admin\controller;

use app\BaseController;
use think\App;
use think\facade\Db;

class Supplier extends BaseController
{
public $post = "";
public function __construct(App $app){
    parent::__construct($app);
    $this->post = $this->request->post();
}
public function list(){
    $page = isset($this->post['page']) && $this->post['page'] != "" ? intval($this->post['page']) : 1;
    $size = isset($this->post['size']) && $this->post['size'] != "" ? intval($this->post['size']) : 10;
    $where = ['is_del'=>0];
    $name = isset($this->post['name']) && $this->post['name'] !== "" ? trim($this->post['name']) : "";
    if ($name !== "") {
        $where['name'] = ["like", "%{name}%"];
    }
    $code = isset($this->post['code']) && $this->post['code'] !== "" ? trim($this->post['code']) : "";
    if ($code !== "") {
        $where['code'] = ["like", "%{code}%"];
    }
    $source = isset($this->post['source']) && $this->post['source'] !== "" ? trim($this->post['source']) : "";
    if ($source !== "") {
        $where['source'] = ["like", "%{source}%"];
    }
    $area = isset($this->post['area']) && $this->post['area'] !== "" ? trim($this->post['area']) : "";
    if ($area !== "") {
        $where['area'] = ["like", "%{area}%"];
    }
    $city = isset($this->post['city']) && $this->post['city'] !== "" ? trim($this->post['city']) : "";
    if ($city !== "") {
        $where['city'] = ["like", "%{city}%"];
    }
    $nature = isset($this->post['nature']) && $this->post['nature'] !== "" ? trim($this->post['nature']) : "";
    if ($nature !== "") {
        $where['nature'] = ["like", "%{nature}%"];
    }
    $legaler = isset($this->post['legaler']) && $this->post['legaler'] !== "" ? trim($this->post['legaler']) : "";
    if ($legaler !== "") {
        $where['legaler'] = ["like", "%{legaler}%"];
    }
    $addr = isset($this->post['addr']) && $this->post['addr'] !== "" ? trim($this->post['addr']) : "";
    if ($addr !== "") {
        $where['addr'] = ["like", "%{addr}%"];
    }
    $count = Db::name("supplier")->where($where)->count();
    $total = ceil($count/$size);
    $page = $page >= $total ? $total : $page;
    $list = Db::name('supplier')->where($where)->page($page,$size)->select();
    return app_show(0,"获取成功",["list"=>$list,'count'=>$count]);
}
public function create(){
    $name = isset($this->post['name']) && $this->post['name'] !=="" ? trim($this->post['name']) :"";
    if($name==""){
        return error_show(1002,"数据标题不能为空");
    }
    $rename = Db::name('supplier')->where(['is_del' => 0, 'name' => $name])->find();
    if (!empty($rename)) {
        return error_show(1002, "公司名称已存在");
    }
    $code = rand(0000,9999);
    $str = sprintf("%04d",$code);
    $tr="GYS-".date("Ymd")."-".$str;
    $source= isset($this->post['source']) && $this->post['source']!==""? trim($this->post['source']) :"";
    if($source==""){
        return error_show(1002,"供应商来源不能为空");
    }
    $type = isset($this->post['type']) && $this->post['type']!==""? trim($this->post['type']) :"";
    if($type==""){
        return error_show(1002,"申请类型不能为空");
    }
    $area = isset($this->post['area']) && $this->post['area']!==""? trim($this->post['area']) :"";
    if($area==""){
        return error_show(1002,"大区不能为空");
    }
    $city = isset($this->post['city']) && $this->post['city']!==""? trim($this->post['city']) :"";
    if($city==""){
        return error_show(1002,"城市不能为空");
    }
    $nature = isset($this->post['nature']) && $this->post['nature']!==""? trim($this->post['nature']) :"";
    if($nature==""){
        return error_show(1002,"公司类型不能为空");
    }
    $ticket_type = isset($this->post['ticket_type']) && $this->post['ticket_type']!==""? trim($this->post['ticket_type']) :"";
    if($ticket_type==""){
        return error_show(1002,"回款方式不能为空");
    }
    $legaler = isset($this->post['legaler']) && $this->post['legaler']!==""? trim($this->post['legaler']) :"";
    if($legaler==""){
        return error_show(1002,"法人不能为空");
    }
    $addr = isset($this->post['addr']) && $this->post['addr']!==""? trim($this->post['addr']) :"";
    if($addr==""){
        return error_show(1002,"地址不能为空");
    }
    $data=[
        "name"=>$name,"source"=>$source,"code"=>$tr,
        "type"=>$type,"area"=>$area,"city"=>$city,
        "nature"=>$nature,"legaler"=>$legaler,"addr"=>$addr,
        "is_del"=>0,"ticket_type"=>$ticket_type,
        "addtime"=>date('Y-m-d H:i:s'),
        "updatetime"=>date("Y-m-d H:i:s"),
    ];
    $join = Db::name('supplier')->insert($data);
    return $join? error_show(0,"添加成功") :error_show(1002,"添加失败");
}
public function edit(){
    $id = isset($this->post['id']) && $this->post['id'] !==""? trim($this->post['id']):"";
    $ion = Db::name('supplier')->where(['id'=>$id,'is_del'=>0])->find();
    if(empty($ion)){
        return error_show(1004,"供应商不存在");
    }
    $name = isset($this->post['name']) && $this->post['name']!=="" ? $this->post['name']:"";
    if($name==""){
        return error_show(1002,'数据标题不能为空');
    }
    $rename =Db::name('supplier')->where(['name'=>$name,'is_del'=>0])->where('id','<>',$id)->find();
    if(!empty($rename)){
        return error_show(1004,"数据标题已存在");
    }
    $source = isset($this->post['source']) && $this->post['source'] !==""? $this->post['source']:"";
    if($source==""){
        return error_show(1002,"供应商来源不能为空");
    }
    $type = isset($this->post['type']) && $this->post['type']!==""? trim($this->post['type']) :"";
    if($type==""){
        return error_show(1002,"申请类型不能为空");
    }
    $area = isset($this->post['area']) && $this->post['area']!==""? trim($this->post['area']) :"";
    if($area==""){
        return error_show(1002,"大区不能为空");
    }
    $city = isset($this->post['city']) && $this->post['city']!==""? trim($this->post['city']) :"";
    if($city==""){
        return error_show(1002,"城市不能为空");
    }
    $nature = isset($this->post['nature']) && $this->post['nature']!==""? trim($this->post['nature']) :"";
    if($nature==""){
        return error_show(1002,"公司类型不能为空");
    }
    $legaler = isset($this->post['legaler']) && $this->post['legaler']!==""? trim($this->post['legaler']) :"";
    if($legaler==""){
        return error_show(1002,"法人不能为空");
    }
    $addr = isset($this->post['addr']) && $this->post['addr']!==""? trim($this->post['addr']) :"";
    if($addr==""){
        return error_show(1002,"地址不能为空");
    }
    $vmp=[
        "id"=>$id,"legaler"=>$legaler,
        "name"=>$name,"source"=>$source,
        "type"=>$type,"area"=>$area,"city"=>$city,
        "nature"=>$nature,"addr"=>$addr,
        "is_del"=>0,"addtime"=>date('Y-m-d H:i:s'),
        "updatetime"=>date("Y-m-d H:i:s")
    ];
    $ed = Db::name('supplier')->where(['is_del'=>0,'id'=>$id])->save($vmp);
    return $ed ? error_show(0,"编辑成功") : error_show(1002,"编辑失败");
}
public function selec(){
    $id= isset($this->post['id']) && $this->post['id'] !==""? intval($this->post['id']) :"";
    if($id==""){
        return error_show(1002,"供应商不存在");
    }
    $se = Db::name('supplier')->where(['id'=>$id,'is_del'=>0])->find();
    return app_show(0,"获取成功",$se);
}

}