123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509 |
- <?php
- namespace app\admin\controller;
- use app\admin\model\ActionLog;
- use think\App;
- use think\facade\Db;
- class Purch extends \app\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]];
- $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,"更新失败");
- }
- }
- }
|