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]]; $bkcode = isset($this->post['bk_code']) && $this->post['bk_code']!="" ? trim($this->post['bk_code']):""; if($bkcode!=""){ $where[]=['bkcode',"like", "%{$bkcode}%"]; } $status = isset($this->post['status']) && $this->post['status']!=="" ? intval($this->post['status']):""; if($status!==""){ // $where['status'] = $status; $where[]=['status',"=", $status]; } $cgdNo = isset($this->post['cgdNo']) && $this->post['cgdNo']!="" ? trim($this->post['cgdNo']) :""; if($cgdNo!=""){ //$where['cgdNo'] = Db::Raw("like '%{$cgdNo}%'"); $where[]=['cgdNo',"like", "%{$cgdNo}%"]; } $apply_name = isset($this->post['apply_name']) && $this->post['apply_name']!="" ? trim($this->post['apply_name']):""; if($apply_name!=""){ // $where['cgder'] =Db::Raw("like '%{$apply_name}%'"); $where[]=['cgder',"like", "%{$apply_name}%"]; } $wsm_code = isset($this->post['wsm_code']) && $this->post['wsm_code']!="" ? trim($this->post['wsm_code']):""; if($wsm_code!=""){ // $where['wsm_code'] = $wsm_code; $where[]=['wsm_code',"=", $wsm_code]; } $wsm_in_code = isset($this->post['wsm_in_code']) && $this->post['wsm_in_code']!="" ? trim($this->post['wsm_in_code']):""; if($wsm_in_code!=""){ $incode = Db::name("purchease_in")->where(["wsm_in_code"=>Db::raw(" like %{$wsm_in_code}%"),"is_del"=>0])->column("cgdNo"); if(empty($incode)){ return error_show(1004,"未找到有关入库单信息"); } $where[]=['cgdNo',"in", $incode]; } $good_name = isset($this->post['good_name']) && $this->post['good_name']!="" ? trim($this->post['good_name']):""; if($good_name!=""){ //$where['good_name'] = Db::raw(" like %{$good_name}%"); $where[]=['good_name',"like", "%{$good_name}%"]; } $good_code = isset($this->post['good_code']) && $this->post['good_code']!="" ? trim($this->post['good_code']) :""; if($good_code!=""){ // $where['good_code'] = Db::raw(" like %{$good_code}%"); $where[]=['good_code',"like", "%{$good_code}%"]; } $supplierNo = isset($this->post['supplierNo']) && $this->post['supplierNo']!="" ? trim($this->post['supplierNo']) :""; if($supplierNo!=""){ // $where['good_code'] = Db::raw(" like %{$good_code}%"); $where[]=['supplierNo',"like", "%{$supplierNo}%"]; } $wsm_supplierNo = isset($this->post['wsm_supplierNo']) && $this->post['wsm_supplierNo']!="" ? trim($this->post['wsm_supplierNo']) :""; if($wsm_supplierNo!=""){ $supplier = Db::name("supplier")->where(["code"=>$wsm_supplierNo])->find(); if(empty($supplier)){ return error_show(1004,"未找到供应商信息"); } $wsmcode = Db::name("warehouse_info")->where(["is_del"=>0,"supplierNo"=>$wsm_supplierNo])->column("wsm_code"); $where[]=['wsm_code',"in", $wsmcode]; } $start = isset($this->post['start']) && $this->post['start']!="" ?$this->post['start']:""; if($start!=""){ // $where['addtime'] = Db::raw(" >= '{$start}'"); $where[]=['addtime',">=", $start]; } $end = isset($this->post['end']) && $this->post['end']!="" ?$this->post['end']:""; if($end!=""){ $where[]=['addtime',"<=", $end]; } $last_start = isset($this->post['last_start']) && $this->post['last_start']!="" ?$this->post['last_start']:""; if($last_start!=""){ //$where['lasttime'] = Db::raw(" >= '{$last_start}'"); $where[]=['lasttime',">=", $last_start]; } $last_end = isset($this->post['last_end']) && $this->post['last_end']!="" ?$this->post['last_end']:""; if($last_end!=""){ //$where['lasttime'] = Db::raw(" <= '{$last_end}'"); $where[]=['lasttime',"<=", $last_end]; } $count=Db::name("purchease_order")->where($where)->count(); $total = ceil($count/$size); $page = $page >= $total ? $total : $page; $list = Db::name("purchease_order")->where($where)->page($page,$size)->order("addtime desc")->select(); $data=[]; foreach ($list as $value){ $value['wsm_name']=""; if($value['wsm_code']!=""){ $wsmcode = Db::name("warehouse_info")->alias("a")->leftJoin("supplier b","a.supplierNo=b.code") ->where(["a.wsm_code"=>$value['wsm_code']])->field("a.name as wsm_name,b.name,b.code")->find(); $value['wsm_name'] =isset($wsmcode['wsm_name']) ? $wsmcode['wsm_name']:""; $value['wsm_supplier'] =isset($wsmcode['name']) ? $wsmcode['name']:""; $value['wsm_supplierNo'] =isset($wsmcode['code']) ? $wsmcode['code']:""; } $inorder= Db::name("purchease_in")->where(['cgdNo'=>$value['cgdNo'],"is_del"=>0])->select(); $value['child']=empty($inorder)? [] : $inorder; $data[]=$value; } return app_show(0,"获取成功",["list"=>$list ,"count"=>$count]); } public function info(){ $cgdNo = isset($this->post['cgdNo']) && $this->post['cgdNo']!="" ?trim($this->post['cgdNo']):""; if($cgdNo==""){ return error_show(1004,"参数cgdNo 不能为空"); } $data = Db::name("purchease_order")->where(["cgdNo"=>$cgdNo,"is_del"=>0])->find(); if(empty($data)){ return error_show(1004,"未找到数据"); } $im = Db::name('purchease_back')->where(['cgdNo'=>$data['cgdNo'],'is_del'=>0])->select(); //$var = Db::name('purchease_in')->where(['cgdNo'=>$data['cgdNo'],'is_del'=>0])->select(); $dom = Db::name("purchease_diff")->where(['cgdNo'=>$data['cgdNo'],'is_del'=>0])->select(); $goon = Db::name('good')->where(['good_code'=>$data['good_code']])->field("cat_id")->find(); if(empty($goon)){ return error_show(1002,"未找到商品数据"); } $int= isset($goon['cat_id']) && $goon['cat_id'] !=0 ? made($goon['cat_id']):[]; $data['wsm_name']=""; if($data['wsm_code']!=""){ $wsmcode = Db::name("warehouse_info")->alias("a")->leftJoin("supplier b","a.supplierNo=b.code") ->leftJoin("warehouse_addr c","a.wsm_code=c.wsm_code and c.is_del=0") ->where(["a.wsm_code"=>$data['wsm_code']])->field("a.name as wsm_name,b.name,b.code,c.wsm_name as wsm_contactor,c.wsm_mobile,c.wsm_addr,c.addr_code")->find(); $data['wsm_name'] =isset($wsmcode['wsm_name']) ? $wsmcode['wsm_name']:""; $data['wsm_supplier'] =isset($wsmcode['name']) ? $wsmcode['name']:""; $data['wsm_supplierNo'] =isset($wsmcode['code']) ? $wsmcode['code']:""; $data['wsm_contactor'] =isset($wsmcode['wsm_contactor']) ? $wsmcode['wsm_contactor']:""; $data['wsm_mobile'] =isset($wsmcode['wsm_mobile']) ? $wsmcode['wsm_mobile']:""; // $data['wsm_addr'] =isset($wsmcode['wsm_addr']) ? $wsmcode['wsm_addr']:""; $data['addr_code'] =isset($wsmcode['addr_code']) ? $wsmcode['addr_code']:""; $data['wsm_addr'] =isset($wsmcode['addr_code']) ? GetAddr($wsmcode['addr_code']):""; $data['wsm_addr'].=isset($wsmcode['wsm_addr']) ? $wsmcode['wsm_addr']:""; $inorder= Db::name("purchease_in")->where(['cgdNo'=>$data['cgdNo'],"is_del"=>0])->select(); $data['child']=empty($inorder)? [] : $inorder; } $feed = Db::name("purchease_feedback")->where(['bkcode'=>$data['bkcode'],'is_del'=>0])->find(); $data['feedback'] = []; if(!empty($feed)){ $feed['wsm_name']=""; if($feed['warehouse']!=""){ $wsmcode = Db::name("warehouse_info")->alias("a")->leftJoin("supplier b","a.supplierNo=b.code") ->where(["a.wsm_code"=>$feed['warehouse']])->field("a.name as wsm_name,b.name,b.code")->find(); $feed['wsm_name'] =isset($wsmcode['wsm_name']) ? $wsmcode['wsm_name']:""; $feed['wsm_supplier'] =isset($wsmcode['name']) ? $wsmcode['name']:""; $feed['wsm_supplierNo'] =isset($wsmcode['code']) ? $wsmcode['code']:""; } if($feed['supplier']!=""){ $supplie = Db::name("supplier")->where(['code'=>$feed['supplier'],"is_del"=>0])->find(); $feed['supplier_name'] =isset($supplie['name']) ? $supplie['name']:""; } $data['feedback'] = $feed; $data['can'] = $int; $data['var'] = $dom; //$data['info'] = $var; $data['item'] = $im; } return app_show(0,"获取成功",$data); } public function edit(){ $cgdNo = isset($this->post['cgdNo']) && $this->post['cgdNo']!="" ?trim($this->post['cgdNo']):""; if($cgdNo==""){ return error_show(1004,"参数cgdNo 不能为空"); } $data = Db::name("purchease_order")->where(["cgdNo"=>$cgdNo,"is_del"=>0])->find(); if(empty($data)){ return error_show(1004,"未找到数据"); } $order = ["order_code"=>$cgdNo,"status"=> $data['status'] ,"action_remark"=>$this->post['remark'],"action_type"=>"edit"]; $wsm_code = isset($this->post['wsm_code'])&&$this->post['wsm_code']!=""? trim($this->post['wsm_code']):""; if($wsm_code!=""){ $ware = Db::name("warehouse_info")->where(["wsm_code"=>$wsm_code,"is_del"=>0])->find(); if(empty($ware)){ return error_show(1004,"未找到仓库信息"); } // $good = Db::name("good_stock")->where(["wsm_code"=>$wsm_code,"good_type_code"=>$data['good_type_code'],"is_del"=>0])->find(); // if(empty($good)){ // return error_show(1004,"未找到仓库下商品信息"); // } $data['wsm_code'] = $wsm_code; } $cgdid = isset($this->post['cgder_id'])&&$this->post['cgder_id']!=""?intval($this->post['cgder_id']):""; if($cgdid!=''){ $cgduser = GetInfoById($this->post['token'],["id"=>$cgdid]); if((!empty($cgduser) && $cgduser['code']!=0) ||empty($cgduser) ){ return error_show($cgduser['code'],$cgduser['message']); } $userinfo = $cgduser['data']; $data['cgder_id'] = $cgdid; $data['cgder'] = $userinfo['nickname']; } $good_num = isset($this->post['good_num'])&&$this->post['good_num']!=""?intval($this->post['good_num']):""; if($good_num!=""){ $data['good_num'] = $good_num; } $good_price = isset($this->post['good_price'])&&$this->post['good_price']!=""?$this->post['good_price']:""; if($good_price!=""){ $data['good_price'] = $good_price; } // $total_fee = isset($this->post['total_fee'])&&$this->post['total_fee']!=""?$this->post['total_fee']:""; // if($total_fee!=""){ // $data['total_fee'] = $total_fee; // } $pakge_fee = isset($this->post['pakge_fee'])&&$this->post['pakge_fee']!=""?$this->post['pakge_fee']:""; if($pakge_fee!=""){ $data['pakge_fee'] = $pakge_fee; } $cert_fee = isset($this->post['cert_fee'])&&$this->post['cert_fee']!=""?$this->post['cert_fee']:""; if($cert_fee!=""){ $data['cert_fee'] = $cert_fee; } $open_fee = isset($this->post['open_fee'])&&$this->post['open_fee']!=""?$this->post['open_fee']:""; if($open_fee!=""){ $data['open_fee'] = $open_fee; } $delivery_fee = isset($this->post['delivery_fee'])&&$this->post['delivery_fee']!=""?$this->post['delivery_fee']:""; if($delivery_fee!=""){ $data['delivery_fee'] = $delivery_fee; } $mark_fee = isset($this->post['mark_fee'])&&$this->post['mark_fee']!=""?$this->post['mark_fee']:""; if($mark_fee!=""){ $data['mark_fee'] = $mark_fee; } $teach_fee = isset($this->post['teach_fee'])&&$this->post['teach_fee']!=""?$this->post['teach_fee']:""; if($teach_fee!=""){ $data['teach_fee'] = $teach_fee; } $nake_fee = isset($this->post['nake_fee'])&&$this->post['nake_fee']!=""?$this->post['nake_fee']:""; if($nake_fee!=""){ $data['nake_fee'] = $nake_fee; } $weight = isset($this->post['weight'])&&$this->post['weight']!=""?$this->post['weight']:""; if($weight!=""){ $data['weight'] = $weight; } $diff_weight = isset($this->post['diff_weight'])&&$this->post['diff_weight']!=""?$this->post['diff_weight']:""; if($diff_weight!=""){ $data['diff_weight'] = $diff_weight; } $diff_fee = isset($this->post['diff_fee'])&&$this->post['diff_fee']!=""?$this->post['diff_fee']:""; if($diff_fee!=""){ $data['diff_fee'] = $diff_fee; } $supplierNo = isset($this->post['supplierNo'])&&$this->post['supplierNo']!=""?trim($this->post['supplierNo']) :""; if($supplierNo!=""){ $supplier =Db::name("supplier")->where(['code'=>$supplierNo])->find(); if(empty($supplier)){ return error_show(1004,"未找到供应商信息"); } $data['supplierNo'] = $supplierNo; $data['supplier_name'] = $supplier['name']; } $remark = isset($this->post['remark'])&&$this->post['remark']!=""?trim($this->post['remark']):""; if($remark!=""){ $data['remark'] = $remark; } $data['good_price'] = round(($data['pakge_fee']+$data['weight']*$data['gold_price']+$data['nake_fee']+$data['mark_fee']+$data['cert_fee']+$data['open_fee']/$data['good_num'] +$data['teach_fee']*$data['weight']+$data['delivery_fee']),2); $data['total_fee'] = round($data['good_price']*$data['good_num'],2); $data['updatetime'] =date("Y-m-d H:i:s"); $upd=Db::name("purchease_order")->save($data); if($upd){ ActionLog::logAdd($this->post['token'],$order,'cgd',$data['status'],$this->post); return app_show(0,"更新成功"); }else{ return error_show(1004,'更新失败'); } } public function status(){ $cgdNo = isset($this->post['cgdNo']) && $this->post['cgdNo']!="" ?trim($this->post['cgdNo']):""; if($cgdNo==""){ return error_show(1004,"参数cgdNo 不能为空"); } $data = Db::name("purchease_order")->where(["cgdNo"=>$cgdNo,"is_del"=>0])->find(); if(empty($data)){ return error_show(1004,"未找到数据"); } $remark= isset($this->post['remark']) && $this->post['remark']!="" ?trim($this->post['remark']):""; $status = isset($this->post['status'])&&$this->post['status']!==""? intval($this->post['status']):""; if($status===""){ return error_show(1004,"参数status 不能为空"); } if($data['send_status']>1 && $status==0){ return error_show(1004,"采购单发货中无法取消"); } $order = ["order_code"=>$cgdNo,"status"=> $data['status'] ,"action_remark"=>$remark,"action_type"=>"status"]; $data['status'] = $status; $data['remark'] = $remark; $data['updatetime'] =date("Y-m-d H:i:s"); $upd=Db::name("purchease_order")->save($data); if($upd){ ActionLog::logAdd($this->post['token'],$order,'cgd',$status,$this->post); return app_show(0,"更新成功"); }else{ return error_show(1004,'更新失败'); } } public function diffcreat(){ $token = isset($this->post['token']) && $this->post['token'] !=="" ?trim($this->post['token']):""; //$cgdNo=makeNo("CG"); $cgdNo = $this->post['cgdNo'] && $this->post['cgdNo'] !=="" ? trim($this->post['cgdNo']) :""; if($cgdNo==""){ return error_show(1002,"参数good_code不能为空"); } $cg = Db::name('purchease_order')->where(['cgdNo'=>$cgdNo,'is_del'=>0])->find(); if($cg==""){ return error_show(1002,"未找到采购单数据"); } $gd= Db::name('good')->where(['good_code'=>$cg['good_code']])->find(); if($gd==""){ return error_show(1002,"未找到商品数据"); } $diff_weight = isset($this->post['diff_weight']) && $this->post['diff_weight'] !=="" ? trim($this->post['diff_weight']) :""; if($diff_weight==""){ return error_show(1002,"参数diff_weight不能为空"); } $apply_id =GetUserInfo($token); if(empty($apply_id)||$apply_id['code']!=0){ return error_show(1002,"申请人数据不存在"); } $rid= isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : ""; $rname= isset($apply_id["data"]['nickname']) ? $apply_id["data"]['nickname'] : ""; $diff_price = $diff_weight*$cg['gold_price']; // $status = isset($this->post['status']) && $this->post['status'] !=="" ? intval($this->post['status']) :""; $data=[ "cgdNo"=>$cgdNo, "good_code"=>$cg['good_type_code'], "good_kode"=>$cg['good_code'], "good_name"=>$cg['good_name'], "sale_price"=>$cg['good_price'], "good_weight"=>$cg['weight'], "good_num"=>$cg['good_num'], "apply_id"=>$rid, "apply_name"=>$rname, "diff_weight"=>$diff_weight, "diff_price"=>$diff_price, "gold_price"=>$cg['gold_price'], "status"=>1, "is_del"=>0, "addtime"=>date("Y-m-d H:i:s"), "updatetime"=>date("Y-m-d H:i:s") ]; Db::startTrans(); try{ $item = Db::name("purchease_diff")->insert($data); if($item){ $stm = ["order_code"=>$cgdNo,"status"=>1,"action_remark"=>'',"action_type"=>"create"]; ActionLog::logAdd($this->post['token'],$stm,"BKD",1,$stm); if($cg['order_type']==2){ $order = Db::name("sale")->where(["orderCode"=>$cg['bkcode']])->find(); if(empty($order)){ Db::rollback(); return error_show(1002,"未找到确认单信息"); } $data=[ "orderCode"=>$cg['bkcode'], "good_code"=>$cg['good_type_code'], "good_kode"=>$cg['good_code'], "good_name"=>$cg['good_name'], "diff_weight"=>$diff_weight, "diff_price"=>$diff_weight*$cg['gold_price'], "gold_price"=>$cg['gold_price'], "status"=>1, "addtime"=>date("Y-m-d H:i:s"), "updatetime"=>date("Y-m-d H:i:s") ]; $cgd = Db::name('sale_diff')->insert($data); if($cgd){ $sto = ["order_code"=>$cg['bkcode'],"status"=>1,"action_remark"=>'',"action_type"=>"create"]; ActionLog::logAdd($this->post['token'],$sto,"BKD",1,$sto); Db::commit(); return error_show(0,"新建成功"); }else{ Db::rollback(); return error_show(1002,"新建失败"); } } Db::commit(); return error_show(0,"新建成功"); }else{ Db::rollback(); return error_show(1002,"新建失败"); } }catch (\Exception $e){ Db::rollback(); return error_show(1002,$e->getMessage()); } } public function difflist(){ $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]]; $cgdNo = isset($this->post['cgdNo']) && $this->post['cgdNo']!="" ? trim($this->post['cgdNo']):""; if($cgdNo!=""){ $where[]=['a.cgdNo',"like", "%$cgdNo%"]; } $status = isset($this->post['status']) && $this->post['status'] !==""? intval($this->post['status']):""; if($status!==""){ $where[]=['a.status',"=",$status]; } $start= isset($this->post['start']) && $this->post['start'] !== "" ? $this->post['start']:""; if ($start !="") { $where[]= ["a.addtime",'>=',$start]; } $end = isset($this->post['end']) && $this->post['end'] !== "" ? $this->post['end'] :""; if($end !=""){ $where[]= ["a.addtime",'<=',$end]; } $apply_name = isset($this->post['apply_name']) && $this->post['apply_name'] !==""? intval($this->post['apply_name']):""; if($apply_name!==""){ $where[]=['a.apply_name',"like","%$apply_name%"]; } $count = Db::name('purchease_diff')->alias('a')->join("good b","b.good_code=a.good_kode","left") ->where($where)->count(); $total = ceil($count/$size); $page = $page >= $total ? $total : $page; $list = Db::name('purchease_diff')->alias('a')->join("good b","b.good_code=a.good_kode","left") ->where($where)->page($page,$size)->order("a.addtime desc")->field("a.*,b.cat_id")->select(); $data=[]; foreach ($list as $value){ $value['can']= isset($value['cat_id']) && $value['cat_id'] !=0 ? made($value['cat_id']):[]; $data[]=$value; } return app_show(0,"获取成功",['list'=>$data,'count'=>$count]); } public function diffinfo(){ $id = isset($this->post['id']) && $this->post['id'] !=="" ? trim($this->post['id']) :""; if($id==""){ return error_show(1002,"参数id 不能为空"); } $idinf = Db::name('purchease_diff')->where(['id'=>$id,'is_del'=>0])->find(); if($idinf==false){ return error_show(1002,"未找到采购工差单数据"); } $dn = Db::name('purchease_order')->where(['cgdNo'=>$idinf['cgdNo'],'is_del'=>0])->field('order_type')->find(); $goon = Db::name('good')->where(['good_code'=>$idinf['good_kode']])->find(); if(empty($goon)){ return error_show(1002,"未找到商品数据"); } $int= isset($goon['cat_id']) && $goon['cat_id'] !=0 ? made($goon['cat_id']):[]; $idinf['can']=$int; $idinf['order_type']=$dn['order_type']; return app_show(0,"获取成功",$idinf); } public function diffstatu(){ $id = isset($this->post['id']) && $this->post['id'] !=="" ? intval($this->post['id']) :""; if($id==""){ return error_show(1002,"参数id不能为空"); } $dio = Db::name('purchease_diff')->where(['id'=>$id,'is_del'=>0])->find(); if(empty($dio)){ return error_show(1002,"退货订单未找到"); } $cgd = Db::name("purchease_order")->where(['cgdNo'=>$dio['cgdNo']])->find(); if(empty($cgd)){ return error_show(1002,"采购单未找到"); } $status = isset($this->post['status']) && $this->post['status'] !=="" ? intval($this->post['status']) :""; if($status===""){ return error_show(1002,"参数status不能为空"); } $temp = $dio['status']; $dio['status']=$status; $dio['updatetime']=date("Y-m-d H:i:s"); $item = Db::name("purchease_diff")->update($dio); if ($item){ $sto = ["order_code"=>$id,"status"=>$temp,"action_remark"=>'',"action_type"=>"create"]; ActionLog::logAdd($this->post['token'],$sto,"cgd",$dio['status'],$sto); return error_show(0,"更新成功"); }else{ return error_show(1002,"更新失败"); } } }