phpstock/app/admin/controller/Check.php

<?php

namespace app\admin\controller;

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

class Check extends BaseController
{
public $post = "";
public function __construct(App $app)
{
    parent::__construct($app);
    $this->post=$this->request->post();
    $token = isset($this->post['token']) ? trim($this->post['token']) : "";
    if($token==""){
        return error_show(101,'token不能为空');
    }
    $effetc = VerifyTokens($token);
    if(!empty($effetc) && $effetc['code']!=0){
        return error_show($effetc['code'],$effetc['message']);
    }
}
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 = ['a.is_del' => 0,'b.is_del'=>0];
    $start= isset($this->post['start']) && $this->post['start'] !== "" ? $this->post['start']:"";
    if ($start !="") {
        $where['"a.addtime"']=Db::raw(">= '{$start}'");
    }
    $end = isset($this->post['end']) && $this->post['end'] !== "" ? $this->post['end'] :"";
    if($end !=""){
        $where['"a.addtime"'] = Db::raw("<= '{$end}'");
    }
    $check_code = isset($this->post['check_code']) && $this->post['check_code'] !== "" ? trim($this->post['check_code']) : "";
    if ($check_code !== "") {
        $where['a.check_code'] = Db::raw("like '%$check_code%'");
    }
    $wsm_code = isset($this->post['wsm_code']) && $this->post['wsm_code'] !== "" ? trim($this->post['wsm_code']) : "";
    if ($wsm_code  !== "") {
        $where['a.wsm_code'] =  Db::raw("like '%$wsm_code%'");
    }
    $apply_name = isset($this->post['apply_name']) && $this->post['apply_name'] !== "" ? trim($this->post['apply_name']) : "";
    if ($apply_name !== "") {
        $where['a.apply_name'] = $apply_name;
    }
    $type = isset($this->post['type']) && $this->post['type'] !== "" ? trim($this->post['type']) : "";
    if ($type !== "") {
        $where['a.type'] = $type;
    }
    $apply_id = isset($this->post['apply_id']) && $this->post['apply_id'] !== "" ? intval($this->post['apply_id']) : "";
    if ($apply_id!== "") {
        $where['a.apply_id'] = $apply_id;
    }
    $status= isset($this->post['status']) && $this->post['status'] !== "" ? intval($this->post['status']) : "";
    if ($status !== "") {
        $where['a.status '] = $status;
    }
    $count = Db::name('good_check')->alias('a')->join("warehouse_info b","a.wsm_code = b.wsm_code","left")
        ->join("supplier v","v.code=b.supplierNo","left")
        ->where($where)->count();
    $total = ceil($count / $size);
    $page = $page <= $total ? $page : $total;
    $list = Db::name('good_check')->alias('a')->join("warehouse_info b","a.wsm_code = b.wsm_code","left")
        ->join("supplier v","v.code=b.supplierNo","left")
        ->field("a.status,a.apply_id,a.apply_name,a.type,a.addtime,a.wsm_code,a.check_code,b.name,a.id,v.name as 'caname',v.code")->where($where)->page($page,$size)->order("a.id desc")->select();
    $data=[];
    foreach ($list as $key=>$value){
        $value['rename'] ='';
        if($value['apply_id']!=0){
            $depart = Db::name("depart_user")->alias("a")->leftJoin("company_item b","a.itemid = b.id")->where(['a.uid'=>$value['apply_id'],'a.is_del'=>0])
                ->column('b.name');
            $value['rename'] =implode(",",$depart);
        }
        $data[] = $value;
    }
    return app_show(0,"获取成功",['count'=>$count,'list'=>$list]);
    }
public function goodlist(){
    $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];
    $check_code = isset($this->post['check_code']) && $this->post['check_code'] !== "" ? intval($this->post['check_code']) : "";
    if ($check_code !== "") {
        $where['check_code'] = $check_code;
    }
    $count = Db::name('check_item')->where($where)->count();
    $total = ceil($count / $size);
    $page = $page >= $total ? $page : $total;
    $list = Db::name('check_item')->where($where)->page($page,$size)->select();
    return app_show(0,"获取成功",['count'=>$count,'list'=>$list]);
}
public function create(){
    $token =isset($this->post['token']) && $this->post['token'] !=="" ? trim($this->post['token']) :"";

    $wsm_code = isset($this->post['wsm_code']) && $this->post['wsm_code'] !=="" ? trim($this->post['wsm_code']):"";
    if($wsm_code==""){
        return error_show(1002,"盘点仓库编号不能为空");
    }
    $type = isset($this->post['type']) && $this->post['type'] !=="" ? intval($this->post['type']) :"";
    if($type==""){
        return error_show(1002,"盘点类型不能为空");
    }
    $check_code = makeNo("CK");
    $apply_id=GetUserInfo($token);
    if(empty($apply_id)||$apply_id['code']!=0){
        return error_show(1002,"申请人数据不存在");
    }
    $rm= isset($apply_id["data"]['id']) ?  $apply_id["data"]['id'] : "";
    $ri= isset($apply_name["data"]['nickname']) ?  $apply_name["data"]['nickname'] : "";
    $status = isset($this->post['status']) && $this->post['status'] !=="" ? intval($this->post['status']) :"0";
//    $dain=isset($this->post['good']) && $this->post['good'] !=="" ? trim($this->post['good']):"";
//    if($type==2){
//        if($dain==""||empty($dain)){
//            return error_show(1002,"商品不能为空");
//        }
//    }else{
//        if($type==1) {
//
//        $dain= Db::name("good_type")->alias("b")->join("good a","a.good_code = b.good_code","left")
//              ->join("good_stock c","c.good_type_code = b.type_code","left")->where(['c.wsm_code'=>$wsm_code,'b.is_del'=>0,'a.is_del'=>0])->where("c.is_del=0 or c.is_del is null")
//              ->field("b.type_code,a.good_name")->select();
//        //var_dump($dain);
//        }
//        if($dain==""){
//            return error_show(1003,"商品不能为空");
//        }
//    }
    Db::startTrans();
    try{
        $data=[
            "check_code"=>$check_code,
            "wsm_code"=>$wsm_code,
            "type"=>$type,
            "status"=>$status,
            "apply_id"=>$rm,
            "apply_name"=>$ri,
            "is_del"=>0,
            "addtime"=>date('Y-m-d H:i:s'),
            "updatetime"=>date("Y-m-d H:i:s")
        ];
        $da= Db::name('good_check')->insert($data,true);
//        $dio=[];
//        if($da>0){
//            foreach ($dain as $value){
//            $st=Db::name("good_type")->alias("b")->join("good a","a.good_code = b.good_code","left")
//                ->join("good_stock c","c.good_type_code = b.type_code","left")->where(['c.wsm_code'=>$wsm_code,'good_type_code'=>$value['type_code'],'b.is_del'=>0,'a.is_del'=>0])->where("c.is_del=0 or c.is_del is null")
//                ->field("b.type_code,a.good_name,c.wsm_code,c.wait_in_stock,c.wait_out_stock,c.usable_stock,c.good_type_code,a.original_price")->find();
//
//            $temp=[];
//            $temp['good_name']=$st['good_name'];
//            $temp['origin_price']=$st['original_price'];
//            $temp['good_type_code']=$st['good_type_code'];
//            $temp['origin_num']=$st['usable_stock'];
//            $temp['check_num']=0;
//            $temp['diff_num']=0;
//            $temp['status']=0;
//            $temp['remark']="";
//            $temp['is_del']=0;
//            $temp['check_time']=date('Y-m-d H:i:s');
//            $temp['check_code']=$check_code;
//            $temp['addtime']=date("Y-m-d H:i:s");
//            $temp['updatetime']=date("Y-m-d H:i:s");
//            $dio[] =$temp;
//            }
//            $in= Db::name('check_item')->insertAll($dio);
//        }
        if($da){
           Db::commit();
            return error_show(0,"盘点创建成功");
        }else{
            Db::rollback();
           return error_show(1002,"创建失败");
        }
    }catch (\Exception $e){
        Db::rollback();
        return error_show(1005,$e->getMessage());
   }
    }
public function info(){
    $id = isset($this->post['id']) && $this->post['id'] !=="" ? intval($this->post['id']) :"";
    if($id==""){
        return error_show(1002,"盘点单号不能为空");
    }
    $temp=[];
    $temp['good_name']="";
    $temp['origin_price']="";
    $temp['good_type_code']="";
    $temp['origin_num']=0;
    $temp['check_num']=0;
    $temp['diff_num']=0;
    $temp['status']=0;
    $temp['remark']="";
    $temp['is_del']=0;
    $temp['check_time']=date('Y-m-d H:i:s');
    $temp['addtime']=date("Y-m-d H:i:s");
    $temp['updatetime']=date("Y-m-d H:i:s");
    $fo = Db::name('good_check')->where(['id'=>$id,'is_del'=>0])->find();

    $fi = Db::name('check_item')->where(['check_code'=>$fo['check_code'],'is_del'=>0])->select();
    $fo['item']=$fi;
    if(empty($fo)){
        return error_show(1002,"未找到盘点编号");
    }else{
        return app_show(0,"获取成功",$fo);
    }
}
public function edit()
{
    $token =isset($this->post['token']) && $this->post['token'] !=="" ? trim($this->post['token']) :"";
    $id = isset($this->post['id']) && $this->post['id'] !== "" ? intval($this->post['id']) : "";
    $eid = Db::name('good_check')->where(['id' => $id, 'is_del' => 0])->find();
    if ($eid ==="") {
        return error_show(1002, "未找到盘点编号信息");
    }
    $wsm_code = isset($this->post['wsm_code']) && $this->post['wsm_code'] !== "" ? trim($this->post['wsm_code']) : "";
    if ($wsm_code == "") {
        return error_show(1002, "盘点仓库不能为空");
    }
    $type = isset($this->post['type']) && $this->post['type'] !== "" ? trim($this->post['type']) : "";
    if ($type == "") {
        return error_show(1002, "盘点类型不能为空");
    }
    $good_type_code = isset($this->post['good_type_code']) && $this->post['good_type_code'] !== "" ? trim($this->post['good_type_code']) : "";
    if ($good_type_code == "") {
        return error_show(1002, "商品属性不能为空");
    }
    $apply_id=GetUserInfo($token);
    if(empty($apply_id)||$apply_id['code']!=0){
        return error_show(1002,"申请人数据不存在");
    }
    $rm= isset($apply_id["data"]['id']) ?  $apply_id["data"]['id'] : "";
    $ri= isset($apply_name["data"]['nickname']) ?  $apply_name["data"]['nickname'] : "";
//    $dain=isset($this->post['good']) && $this->post['good'] !=="" ? $this->post['good']:"";
//    if($type==2){
//       // var_dump($dain);
//        if($dain==""||empty($dain)){
//            return error_show(1002,"商品不能为空");
//        }
//    }else{
//        if($type==1) {
//
//            $dain= Db::name("good_type")->alias("b")->join("good a","a.good_code = b.good_code","left")
//                ->join("good_stock c","c.good_type_code = b.type_code","left")->where(['c.wsm_code'=>$wsm_code,'b.is_del'=>0,'a.is_del'=>0])->where("c.is_del=0 or c.is_del is null")
//                ->field("b.type_code,a.good_name")->select();
//            //var_dump($dain);
//        }
//        if($dain==""){
//            return error_show(1003,"商品不能为空");
//        }
//    }
    Db::startTrans();
    try {
        $var = [
            "wsm_code" => $wsm_code,
            "type" => $type,
            "apply_id" => $rm,
            "apply_name" => $ri,
            "updatetime" => date("Y-m-d H:i:s")
        ];
        $up = Db::name('good_check')->where(['id'=>$id,'is_del' => 0])->save($var);
//            $dn =[];
//            if($up>0){
//                foreach ($dain as $value){
//                    $st=Db::name("good_type")->alias("b")->join("good a","a.good_code = b.good_code","left")
//                        ->join("good_stock c","c.good_type_code = b.type_code","left")->where(['c.wsm_code'=>$wsm_code,'good_type_code'=>$value['type_code'],'b.is_del'=>0,'a.is_del'=>0])->where("c.is_del=0 or c.is_del is null")
//                        ->field("b.type_code,a.good_name,c.wsm_code,c.wait_in_stock,c.wait_out_stock,c.usable_stock,c.good_type_code,a.original_price")->find();
//                    $temp=[];
//                    $temp['good_name']=$st['good_name'];
//                    $temp['origin_price']=$st['original_price'];
//                    $temp['good_type_code']=$st['good_type_code'];
//                    $temp['origin_num']=$st['usable_stock'];
//                    $temp['check_num']=0;
//                    $temp['diff_num']=0;
//                    $temp['status']=0;
//                    $temp['remark']="";
//                    $temp['is_del']=0;
//                    $temp['check_time']=date('Y-m-d H:i:s');
//                    $temp['check_code']=$eid['check_code'];
//                    $temp['addtime']=date("Y-m-d H:i:s");
//                    $temp['updatetime']=date("Y-m-d H:i:s");
//                    $dn[] =$temp;
//                }
//                $np = Db::name('check_item')->where(['check_code'=>$eid['check_code'],'is_del'=>0])->update(['is_del'=>1,'updatetime'=>date('Y-m-d H:i:s')]);
//               $io = db::name('check_item')->insertAll($up);
               // var_dump(Db::name('check_item')->getLastSql());
                if ($up) {
                    Db::commit();
                    return error_show(0, "盘点更新成功");
                }

        Db::rollback();
        return error_show(1003,"盘点更新失败");
    } catch (\Exception $e) {
        Db::rollback();
        return error_show(1005, $e->getMessage());
    }
}
public function dell(){
    $id = $this->post['id'] && $this->post['id'] !=="" ? intval($this->post['id']) :"";
    if($id===""){
        return  error_show(1004,"参数id不能为空");
    }
    $deln= Db::name('good_check')->where(['id'=>$id,'is_del'=>0])->find();
    if(empty($deln)){
        return error_show(1002,"未找到数据");
    }
    $sv = Db::name('good_check')->update(['id'=>$id,'is_del'=>1,'updatetime'=>date("Y-m-d H:i:s")]);
    if($sv){
        return error_show(0,"删除成功");
    }else{
        return error_show(1002,"删除失败");
    }
}
}