"待验证","1"=>'正常',"2"=>'已作废',"3"=>'已红冲']; public function __construct(App $app) { parent::__construct($app); $invoice =Config::get("invoiceType"); $this->invoiceType = $invoice['invoiceName']; $this->invName = $invoice['invoiceType']; } /** *付款详细列表 * @return \think\Response */ public function paymentList() { $post = $this->post; $condition = [["a.is_del","=",0],['pay_type','=',$post['pay_type']??1]]; $check = checkRole($this->roleid,[79,119]); if($check){ $condition[]=["b.apply_id","=",$this->uid]; } $startTime= isset($post['startTime'])&&$post['startTime']!="" ? date("Y-m-d 00:00:00",strtotime($post['startTime'])) :""; $endTime= isset($post['endTime'])&&$post['endTime']!="" ? date("Y-m-d 23:59:59",strtotime($post['endTime'])) :""; $supplierNo= isset($post['supplierNo'])&&$post['supplierNo']!="" ? trim($post['supplierNo']) :""; $supplierName= isset($post['supplierName'])&&$post['supplierName']!="" ? trim($post['supplierName']) :""; $companyNo= isset($post['companyNo'])&&$post['companyNo']!="" ? trim($post['companyNo']) :""; $payNo= isset($post['payNo'])&&$post['payNo']!="" ? trim($post['payNo']) :""; $apply= isset($post['apply_name'])&&$post['apply_name']!="" ? trim($post['apply_name']) :""; $paystatus= isset($post['status'])&&$post['status']!="" ? $post['status'] :""; $dzNo= isset($post['dzNo'])&&$post['dzNo']!="" ? trim($post['dzNo']) :""; if($startTime!=""){ $condition[]=['b.addtime','>=',$startTime]; } if($endTime!=""){ $condition[]=['b.addtime','<=',$endTime]; } if($supplierNo!=""){ $condition[]=['a.supplierNo','=',$supplierNo]; } if($supplierName!=""){ $condition[]=['a.supplierName','like',"%$supplierName%"]; } if($companyNo!=""){ $condition[]=['a.companyNo','=',$companyNo]; } $relaComNo= isset($post['relaComNo'])&&$post['relaComNo']!="" ? trim($post['relaComNo']) :""; if($relaComNo!=""){ $condition[]=['a.companyNo|a.supplierNo','=',$relaComNo]; } if($payNo!=""){ $condition[]=['a.payNo','like',"%$payNo%"]; } if($dzNo!=""){ $condition[]=['b.dzNo','like',"%$dzNo%"]; } if($apply!=""){ $condition[]=['b.apply_name','like',"%$apply%"]; } if($paystatus!=""){ $condition[]=['b.status','=',$paystatus]; } if(isset($post['is_comon'])&&$post['is_comon']!=='') $condition []=['is_comon','=',$post['is_comon']]; $page = isset($post['page'])&&$post['page']!="" ? intval($post['page']) :1; $size = isset($post['size'])&&$post['size']!="" ? intval($post['size']) :10; $count = Db::name("pay_payment")->alias('b') ->join("pay a","`a`.`payNo` = `b`.`payNo` AND b.is_del = 0 ",'left') ->where($condition)->count(); $total = ceil($count/$size)>1 ? ceil($count/$size) : 1; $page = $page>=$total?intval($total):$page; $list = Db::name("pay_payment")->alias('b') ->join("pay a","`a`.`payNo` = `b`.`payNo` AND ( `b`.`is_del` = 0 ) ",'left') ->where($condition)->page(intval($page),$size)->order("b.addtime desc") ->field(" `b`.`id` AS `id`, `a`.`payNo` AS `payNo`, `a`.`supplierNo`, `a`.`supplierName`, `a`.`apay_fee` , `a`.`total_fee` AS `total_fee`, `b`.`apply_name`, `b`.`apply_id`, `a`.`is_comon`, `a`.`winv_fee` , `a`.`ainv_fee` , `a`.`wpay_fee` , `a`.`pay_status` , `a`.`inv_status` , `b`.`pay_fee` AS `dpay_fee`, `b`.`return_img`, `b`.`return_time`, `b`.`status` AS `dstatus`, `a`.`status`, `a`.`remark` AS `remark`, `b`.`addtime` , `a`.`companyNo` , `a`.`companyName` , `b`.`dzNo` AS `dzNo` ")->select()->toArray(); //校验是否开通了供应商账号 $supp_account = check_has_account_by_supplierNos(array_unique(array_column($list,'supplierNo'))); $data=[]; foreach ($list as $key=>$value){ $value['ordeNum'] = Db::name("pay_info")->where([["payNo","=",$value["payNo"]],["is_del","=",0]])->count(); $value['has_account'] = (int)isset($supp_account['data'][$value['supplierNo']]); $data[]=$value; } return app_show(0,"获取成功",["list"=>$data,"count"=>$count]); } /** *对账单列表 * @return \think\Response */ public function payList() { $post = $this->post; $condition = [["is_del","=",0],['pay_type','=',$post['pay_type']??1]]; $check = checkRole($this->roleid,[77,117]); if($check){ $condition[]=["apply_id","=",$this->uid]; } $startTime= isset($post['startTime'])&&$post['startTime']!="" ? date("Y-m-d 00:00:00",strtotime($post['startTime'])) :""; $endTime= isset($post['endTime'])&&$post['endTime']!="" ? date("Y-m-d 23:59:59",strtotime($post['endTime'])) :""; $supplierNo= isset($post['supplierNo'])&&$post['supplierNo']!="" ? trim($post['supplierNo']) :""; $supplierName= isset($post['supplierName'])&&$post['supplierName']!="" ? trim($post['supplierName']) :""; $payNo= isset($post['payNo'])&&$post['payNo']!="" ? trim($post['payNo']) :""; $paystatus= isset($post['pay_status'])&&$post['pay_status']!="" ? $post['pay_status'] :""; $inv_status= isset($post['inv_status'])&&$post['inv_status']!="" ? $post['inv_status'] :""; $status= isset($post['status'])&&$post['status']!="" ? $post['status'] :""; $tag_id= isset($post['tag_id'])&&$post['tag_id']!=="" ? intval($post['tag_id']) :""; if($tag_id!==''){ if($tag_id==1) $condition[]=["inv_tag","=",1]; if($tag_id==2) $condition[]=["pay_tag","=",1]; if($tag_id==3) $condition[]=["pay_tag|inv_tag","=",1]; if($tag_id==4) $condition[]=["pay_tag&inv_tag","=",1]; } if($startTime!=""){ $condition[]=["addtime",">=",$startTime]; } if($endTime!=""){ $condition[]=["addtime","<=",$endTime]; } if($supplierNo!=""){ $condition[]=["supplierNo","like","%$supplierNo%"]; } if($supplierName!=""){ $condition[]=["supplierName","like","%$supplierName%"]; } if($payNo!=""){ $condition[]=["payNo","like","%$payNo%"]; } if($inv_status!==''){ if($inv_status==0){ $condition[]=["inv_status","<>",3]; }else{ $condition[]=["inv_status","=",$inv_status]; } } if($paystatus!==''){ if($paystatus==0){ $condition[]=["pay_status","<>",3]; }else{ $condition[]=["pay_status","=",$paystatus]; } } $companyNo = isset($post['companyNo'])&&$post['companyNo']!=''?trim($post['companyNo']):''; if($companyNo!==''){ $condition[]=["companyNo","=",$companyNo]; } $relaComNo= isset($post['relaComNo'])&&$post['relaComNo']!="" ? trim($post['relaComNo']) :""; if($relaComNo!=""){ $condition[]=["companyNo|supplierNo","=",$relaComNo]; } $companyName = isset($post['companyName'])&&$post['companyName']!=''?trim($post['companyName']):''; if($companyName !=''){ $condition[]=["companyName","like","%$companyName%"]; } if($status!=""){ $condition[]=["status","=",$status]; } if(isset($post['is_comon'])&&$post['is_comon']!=='') $condition []=['is_comon','=',$post['is_comon']]; $page = isset($post['page'])&&$post['page']!="" ? intval($post['page']) :1; $size = isset($post['size'])&&$post['size']!="" ? intval($post['size']) :10; $count = Db::name("pay")->where($condition)->count(); $total = ceil($count/$size)>1 ? ceil($count/$size) : 1; $page = $page>=$total?intval($total):$page; $list = Db::name("pay")->where($condition)->page(intval($page),$size)->order("addtime desc")->select()->toArray(); //校验是否开通了供应商账号 $supp_account = check_has_account_by_supplierNos(array_unique(array_column($list,'supplierNo'))); $data=[]; foreach ($list as $key=>$value){ $value['ordeNum'] = Db::name("pay_info")->where([["payNo","=",$value["payNo"]],["is_del","=",0],['status','=',1]])->count(); $value['inv_tag_name']=''; $value['pay_tag_name']=''; $value['pay_tag_img']=''; $value['inv_tag_id']='0'; $value['pay_tag_id']='0'; $value['pay_tag_remark']=''; $value['inv_tag_img']=''; $value['inv_tag_remark']=''; if($value['pay_tag']==1 || $value['inv_tag']==1){ $tag =Db::name('tag_log')->alias('a')->leftJoin('order_tag b','a.tag_id=b.id')->where (['code'=>$value['payNo'],"a.status"=>[1,2]])->order('a.id desc')->column('a.id,b.tag_name,a.tag_img,a .tag_remark','b.type'); if($value['inv_tag']==1){ $value['inv_tag_name']=$tag[2]['tag_name']??''; $value['inv_tag_id']=$tag[2]['id']??'0'; $value['inv_tag_img']=$tag[2]['tag_img']??''; $value['inv_tag_remark']=$tag[2]['tag_remark']??''; } if($value['pay_tag']==1){ $value['pay_tag_id']=$tag[1]['id']??'0'; $value['pay_tag_name']=$tag[1]['tag_name']??''; $value['pay_tag_img']=$tag[1]['tag_img']??''; $value['pay_tag_remark']=$tag[1]['tag_remark']??''; } } $value['has_account'] = (int)isset($supp_account['data'][$value['supplierNo']]); $data[]=$value; } return app_show(0,"获取成功",["list"=>$data,"count"=>$count]); } /** * 新建对账付款数据 * @return \think\Response */ public function PayAdd() { $post = $this->post; $cids = isset($post['cids'])&&$post['cids']!="" ? trim($post['cids']) :""; if($cids==""){ return error_show(1003,"参数cids不能为空"); } $cgdall =Db::name("cgd_info")->where(["id"=>explode(",",$cids)])->select()->toArray(); if(empty($cgdall)){ return error_show(1003,"采购单数据不能为空"); } $statusAll = array_column($cgdall,"status"); $isComonAll = array_unique(array_column($cgdall,'is_comon')) ; if(count($isComonAll)>1){ return error_show(1003,"采购单业务类型不一致"); } if(in_array(1,$statusAll)){ return error_show(1003,'采购单存在已对账数据'); } if(in_array(2,$statusAll)){ return error_show(1003,"采购单存在不核算数据"); } $supplierNo= array_column($cgdall,"supplierNo"); $supplierName= array_column($cgdall,"supplierName"); if(count(array_unique($supplierNo))>1){ return error_show(1003,"采购单数据供应商不一致"); } $companyNo= array_column($cgdall,"companyNo"); $companyName= array_column($cgdall,"companyName"); if(count(array_unique($companyNo))>1){ return error_show(1003,"采购单数据业务公司不一致"); } if ($this->level == 2) { //判断是否开通供应商账号 $temp = check_has_account_by_supplierNos([$supplierNo[0]]); if (isset($temp['data'][$supplierNo[0]])) return error_show(1004, '该供应商已经开通账号，不允许当前账号操作'); } $goodNo= array_column($cgdall,'goodNo'); $good_info = \app\admin\model\Good::where(['spuCode'=>$goodNo])->column("status","spuCode"); $payNo = makeNo("PAY"); Db::startTrans(); try { $data=[]; $paydata=[ "payNo"=>$payNo, "apply_id"=>$this->uid, "apply_name"=>$this->uname, "total_fee"=>0, "is_comon"=>$isComonAll[0], "supplierNo"=>$supplierNo[0], "supplierName"=>$supplierName[0], "companyNo"=>$companyNo[0], "companyName"=>$companyName[0], "wpay_fee"=>0, "apay_fee"=>0, "ainv_fee"=>0, "winv_fee"=>0, "remark"=>"", "status"=>1, "addtime"=>date("Y-m-d H:i:s"), "updatetime"=>date("Y-m-d H:i:s"), ]; foreach ($cgdall as $key=>$value){ if(!isset($good_info[$value['goodNo']])|| $good_info[$value['goodNo']]==0){ Db::rollback(); return error_show(1004,"采购单商品{$value['goodNo']}商品未确认开票类目"); } $temp=[]; $temp['cgdNo']=$value['sequenceNo']; $temp['total_fee']=$value['totalPrice']; $temp['apay_fee']=round($value['apay_fee'],2); $temp['wpay_fee']=round($value['wpay_fee'],2); $temp['winv_fee']=round($value['winv_fee'],2); $temp['ainv_fee']=round($value['ainv_fee'],2); $temp['payNo']=$payNo; $temp['addtime']=date("Y-m-d H:i:s"); $temp['updatetime']=date("Y-m-d H:i:s"); $data[]=$temp; $paydata['total_fee']+= $temp['total_fee']; $paydata['apay_fee']+= $temp['apay_fee']; $paydata['wpay_fee']+= $temp['wpay_fee']; $paydata['ainv_fee']+= $temp['ainv_fee']; $paydata['winv_fee']+= $temp['winv_fee']; } ReportCode::where(['cgdNo'=>array_column($cgdall,"sequenceNo")])->update(['payNo'=>$payNo]); $paydata['total_fee']= round($paydata['total_fee'],2); $paydata['apay_fee']= round($paydata['apay_fee'],2); $paydata['wpay_fee']= round($paydata['wpay_fee'],2); $paydata['ainv_fee']= round($paydata['ainv_fee'],2); $paydata['winv_fee']= round($paydata['winv_fee'],2); $info = Db::name("pay_info")->insertAll($data); if($info!=0){ $payDA=Db::name("pay")->insert($paydata); if($payDA){ $cgddup= Db::name("cgd_info")->where("id","in",$cids)->save(['status'=>1,"updatetime"=>date("Y-m-d H:i:s")]); if($cgddup){ Db::commit(); return app_show(0,"添加成功",["payNo"=>$payNo]); } } } Db::rollback(); return error_show(1003,"添加失败"); }catch(\Exception $e){ Db::rollback(); return error_show(1003,$e->getMessage()); } } /**对账单未审核前可需改编辑 * @return \think\response\Json|void * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\DbException * @throws \think\db\exception\ModelNotFoundException * @throws \think\exception\DbException */ public function PaySave() { $post = $this->post; $cids = isset($post['cids'])&&$post['cids']!="" ? trim($post['cids']) :""; if($cids==""){ return error_show(1003,"参数cids不能为空"); } $payNo = isset($post['payNo'])&&$post['payNo']!="" ? trim($post['payNo']) :""; if($payNo==""){ return error_show(1003,"参数 payNo 不能为空"); } $payinfo = Db::name("pay")->where(["payNo"=>$payNo,"is_del"=>0])->find(); if($payinfo==false){ return error_show(1003,"未找到对账单数据"); } if($payinfo['status']!=1){ return error_show(1003,"对账单已提交审核"); } $cgdall =Db::name("cgd_info")->where(["id"=>explode(",",$cids)])->select()->toArray(); if(empty($cgdall)){ return error_show(1003,"采购单数据不能为空"); } $supplierNo= array_column($cgdall,"supplierNo"); $supplierName= array_column($cgdall,"supplierName"); if(count(array_unique($supplierNo))>1){ return error_show(1003,"采购单数据供应商不一致"); } if ($this->level == 2) { //判断是否开通供应商账号 $temp = check_has_account_by_supplierNos([$payinfo['supplierNo']]); if (isset($temp['data'][$payinfo['supplierNo']])) return error_show(1004, '该供应商已经开通账号，不允许当前账号操作'); } $companyNo= array_column($cgdall,"companyNo"); $companyName= array_column($cgdall,"companyName"); if(count(array_unique($companyNo))>1){ return error_show(1003,"采购单数据业务公司不一致"); } $cgdArr=array_column($cgdall,"sequenceNo"); $cgdNo = Db::name("pay_info")->where([["payNo","=",$payNo],["is_del","=",0]])->column("cgdNo"); $add=[]; $remove=[]; if(!empty($cgdNo)){ $remove = array_diff($cgdNo,$cgdArr); $add = array_diff($cgdArr,$cgdNo); } Db::startTrans(); try { $data=[]; $paydata=[ "supplierNo"=>$supplierNo[0], "supplierName"=>$supplierName[0], "companyNo"=>$companyNo[0], "companyName"=>$companyName[0], "wpay_fee"=>0, "apay_fee"=>0, "ainv_fee"=>0, "winv_fee"=>0, "total_fee"=>0, "updatetime"=>date("Y-m-d H:i:s") ]; foreach ($cgdall as $key=>$value){ if(!empty($add)&& in_array($value['sequenceNo'],$add)){ $temp=[]; $temp['cgdNo']=$value['sequenceNo']; $temp['total_fee']=$value['totalPrice']; $temp['apay_fee']=round($value['apay_fee'],2); $temp['wpay_fee']=round($value['wpay_fee'],2); $temp['winv_fee']=round($value['winv_fee'],2); $temp['ainv_fee']=round($value['ainv_fee'],2); $temp['payNo']=$payNo; $temp['addtime']=date("Y-m-d H:i:s"); $temp['updatetime']=date("Y-m-d H:i:s"); $data[]=$temp; $report=ReportCode::where(["cgdNo"=>$value['sequenceNo']])->find(); if($report)$report->setField("payNo",$payNo); } $paydata['total_fee']+= $value['totalPrice']; $paydata['apay_fee']+= $value['apay_fee']; $paydata['wpay_fee']+= $value['wpay_fee']; $paydata['ainv_fee']+= $value['ainv_fee']; $paydata['winv_fee']+= $value['winv_fee']; } $paydata['total_fee']= round($paydata['total_fee'],2); $paydata['apay_fee']= round($paydata['apay_fee'],2); $paydata['wpay_fee']= round($paydata['wpay_fee'],2); $paydata['ainv_fee']= round($paydata['ainv_fee'],2); $paydata['winv_fee']= round($paydata['winv_fee'],2); $payDA=Db::name("pay")->where($payinfo)->update($paydata); if($payDA){ if(!empty($remove)){ foreach ($remove as $value){ $report=ReportCode::where(["cgdNo"=>$value])->find(); if($report)$report->rmField("payNo",$payNo); } $payrm = Db::name("pay_info")->where(["cgdNo"=>$remove,"is_del"=>0])->update(["is_del"=>1,"updatetime"=>date("Y-m-d H:i:s")]); if($payrm==false){ Db::rollback(); return error_show(1004,"修改失败"); } $cgdrm= Db::name("cgd_info")->where([["sequenceNo","in",$remove],["status","=",1]])->save(['status'=>0, "updatetime"=>date("Y-m-d H:i:s")]); if($cgdrm==false){ Db::rollback(); return error_show(1005,"修改失败"); } } if(!empty($add)){ $cgddup= Db::name("cgd_info")->where([["sequenceNo","in",$add],["status","=",0]])->save(['status'=>1, "updatetime"=>date("Y-m-d H:i:s")]); if($cgddup==false){ Db::rollback(); return error_show(1006,"修改失败"); } } if(!empty($data)){ $info = Db::name("pay_info")->insertAll($data); if($info==false){ Db::rollback(); return error_show(1003,"修改失败"); } } Db::commit(); return app_show(0,"修改成功",["payNo"=>$payNo]); } Db::rollback(); return error_show(1007,"添加失败"); }catch(\Exception $e){ Db::rollback(); return error_show(1003,$e->getMessage()); } } /** * 对账付款状态审核 status 0 待提交 1 待买方审核 2 审核成功 3驳回 4 对账单撤销，释放采购单数据 * @param \think\Request $request * @return \think\Response */ public function PayStatus() { $post = $this->post; $payNo = isset($post['payNo']) && $post['payNo']!="" ? trim($post['payNo']):""; if($payNo==""){ return error_show(1004,"参数payNo不能为空"); } $status= isset($post['status']) && $post['status']!=="" ? trim($post['status']):""; if($status===""){ return error_show(1004,"参数status不能为空"); } $data = Db::name("pay")->where([["payNo","=",$payNo],["is_del","=",0]])->find(); if($data==false){ return error_show(1004,"未能找到对应数据"); } $remark = isset($post['remark']) && $post['remark']!=""? trim($post['remark']):""; $cgdNo = Db::name("pay_info")->where(["payNo"=>$payNo,"is_del"=>0])->column("cgdNo"); if(empty($cgdNo)){ return error_show(1004,"未能找到对应对账数据"); } if($status==4){ $stages = Db::name("pay_payment")->where(['status'=>[0,1,2,3,4],"payNo"=>$payNo,"is_del"=>0]) ->findOrEmpty(); if(!empty($stages)) return error_show(1004,"对账单存在未解除的付款申请单"); $hpinv = Db::name("pay_invoice")->where(['status'=>[0,1,2,3,4,9,11,12],"payNo"=>$payNo,"is_del"=>0])->findOrEmpty(); if(!empty($hpinv)) return error_show(1004,"对账单存在未解除的回票申请单"); if($data['inv_tag']==1)$this->error("存在回票标签未解除"); if($data['pay_tag']==1)$this->error("存在付款标签未解除"); if($data['is_comon']==1){ $invoceAr=InvoicePay::where(["payNo"=>$payNo])->column("invNo"); if(!empty($invoceAr)){ $ist= InvoicePool::where([["invNo","in",$invoceAr],["status","in",[0,1,2,3,4]]])->select() ->isEmpty(); if($ist==false)$this->error('通用订单存在开票申请未解除'); } } } Db::startTrans(); try{ $update=[ "status"=>$status, "remark"=>$remark, "updatetime"=>date("Y-m-d H:i:s") ]; $result = Db::name("pay")->where("payNo","=",$payNo)->update($update); if($result){ if($status==3 || $status==4){ if($data['pay_type']==1){ CgdInfo::where(['sequenceNo'=>$cgdNo,'status'=>1])->update(['status'=>0, 'updatetime'=>date('Y-m-d H:i:s')]); }else{ \app\admin\model\Track::where(["TrackCode"=>$cgdNo,"status"=>1])->update(["status"=>0]); } $payinfoup =Db::name("pay_info")->where(["payNo"=>$payNo,"is_del"=>0])->update(['status'=>0,"updatetime"=>date("Y-m-d H:i:s")]); if($payinfoup==false){ Db::rollback(); return error_show(1004,"对账驳回失败"); } foreach ($cgdNo as $value){ $report=ReportCode::where(["cgdNo"=>$value])->find(); if($report)$report->rmField("payNo",$payNo); } } Db::commit(); if(($status==3 || $status==4)&&$data['is_comon']==1){ event("comonOrder",["payNo"=>$payNo,"type"=>"check"]); } return app_show(0,"状态更新成功"); } Db::rollback(); return error_show(1004,"状态更新失败"); }catch (\Exception $e){ Db::rollback(); return error_show(1004,$e->getMessage()); } } /**删除未审核完成的对账单 * @return \think\response\Json|void * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\DbException * @throws \think\db\exception\ModelNotFoundException */ public function payDel(){ $post = $this->post; $payNo = isset($post['payNo']) && $post['payNo']!="" ? trim($post['payNo']):""; if($payNo==""){ return error_show(1004,"参数payNo不能为空"); } $data = Db::name("pay")->where([["payNo","=",$payNo],["is_del","=",0]])->find(); if($data==false){ return error_show(1004,"未能找到对应数据"); } if($data['status']==2){ return error_show(1004,"对账单已审核通过"); } if ($this->level == 2) { //判断是否开通供应商账号 $temp = check_has_account_by_supplierNos([$data['supplierNo']]); if (isset($temp['data'][$data['supplierNo']])) return error_show(1004, '该供应商已经开通账号，不允许当前账号操作'); } $cgdNo = Db::name("pay_info")->where(["payNo"=>$payNo,"is_del"=>0])->column("cgdNo"); if(empty($cgdNo)){ return error_show(1004,"未能找到对应对账数据"); } Db::startTrans(); try{ $payDel = ["is_del"=>1,"updatetime"=>date("Y-m-d H:i:s")]; $pay =Db::name("pay")->where($data)->update($payDel); if($pay){ $infoup =Db::name("pay_info")->where(["cgdNo"=>$cgdNo,"payNo"=>$payNo,"is_del"=>0])->update($payDel); if($infoup==false){ Db::rollback(); return error_show(1004,"对账删除失败"); } if(in_array($data['status'],[0,1,2])){ if($data['pay_type']==1){ CgdInfo::where(['sequenceNo'=>$cgdNo,'status'=>1])->update(['status'=>0, 'updatetime'=>date('Y-m-d H:i:s')]); }else{ \app\admin\model\Track::where(['TrackCode'=>$cgdNo,'status'=>1])->update(['status'=>0]); } } foreach ($cgdNo as $value){ $report=ReportCode::where(["cgdNo"=>$value])->find(); if($report)$report->rmField("payNo",$payNo); } Db::commit(); return error_show(0,"对账删除成功"); } Db::rollback(); return error_show(1004,"对账删除失败"); }catch (\Exception $e){ Db::rollback(); return error_show(1004,$e->getMessage()); } } /** * * @param int $id * @return \think\Response */ public function stageAdd() { $post = $this->post; $payNo = isset($post['payNo'])&& $post['payNo']!="" ? trim($post['payNo']) :""; if($payNo==""){ return error_show(1004,"参数payNo 不能为空"); } $payinfo =Db::name("pay")->where(["payNo"=>$payNo,"is_del"=>0])->find(); if($payinfo==false){ return error_show(1004,"未找到对账信息"); } $cgdNo =Db::name("pay_info")->where(["payNo"=>$payNo,"is_del"=>0])->column("cgdNo"); if(empty($cgdNo)) return error_show(1004,"未找到对账数据信息"); if($payinfo['status']!=2){ return error_show(1004,"对账未审核完成"); } $pay_fee = isset($post['pay_fee'])&& $post['pay_fee']!="" ? floatval($post['pay_fee']) :""; if($pay_fee==""){ return error_show(1004,"参数 pay_fee 不能为空或零"); } if($payinfo['wpay_fee']< $pay_fee){ return error_show(1004,"对账单未付金额不足"); } $dzno=makeNo("DZ"); Db::startTrans(); try { $ment =[ "payNo"=>$payNo, "dzNo"=>$dzno, "apply_id"=>$this->uid, "apply_name"=>$this->uname, "pay_fee"=>$pay_fee, "return_img"=>'', "status"=>1, "addtime"=>date("Y-m-d H:i:s"), "updatetime"=>date("Y-m-d H:i:s") ]; $payment =Db::name("pay_payment")->insert($ment); if($payment){ $update=[ "pay_fee"=> round($payinfo['pay_fee']+$pay_fee,2), "wpay_fee"=> round($payinfo['wpay_fee']-$pay_fee,2), "updatetime"=>date("Y-m-d H:i:s") ]; $payup = Db::name("pay")->where($payinfo)->update($update); if($payup){ foreach ($cgdNo as $value){ $report=ReportCode::where(["cgdNo"=>$value])->find(); if($report)$report->setField("DzNo",$dzno); } Db::commit(); return app_show(0,"付款申请添加成功",["dzNo"=>$dzno]); } } Db::rollback(); return error_show(1004,"付款申请添加失败"); }catch (\Exception $e){ Db::rollback(); return error_show(1005,$e->getMessage()); } } /** * 付款申请审核状态 * 付款审核状态 0待发起 1待业务审核 2带财务审核 3待回执 4付款完成 5 付款已退 6 业务驳回 7 财务驳回 * @param int $id * @return \think\Response */ public function stageStatus() { $post = $this->post; $dzNo = isset($post['dzNo'])&& $post['dzNo']!="" ? trim($post['dzNo']) :""; if($dzNo==""){ return error_show(1004,"参数 dzNo 不能为空"); } $status = isset($post['status'])&& $post['status']!="" ? intval($post['status']) :""; if($status==""){ return error_show(1004,"参数status 不能为空"); } if(!in_array($status,[0,1,2,3,4,5,6,7])){ return error_show(1004,"参数status 无效值"); } $payment= Db::name("pay_payment")->where([['dzNo',"=",$dzNo],['is_del',"=",0]])->find(); if($payment==false){ return error_show(1005,"未找到付款申请信息"); } $payinfo= Db::name("pay")->where([['payNo',"=",$payment['payNo']],['is_del',"=",0]])->find(); if($payinfo==false){ return error_show(1005,"未找到对账信息"); } if($payinfo['status']!=2){ return error_show(1005,"对账信息未完成审核"); } $cgdNo =Db::name("pay_info")->where(["payNo"=>$payment['payNo'],"is_del"=>0])->column("cgdNo"); if(empty($cgdNo)) return error_show(1004,"未找到对账数据信息"); $remark = isset($post['remark'])? trim($post['remark']) :""; $image = isset($post['return_image'])? trim($post['return_image']) :""; $return_time = isset($post['return_time'])? trim($post['return_time']) :date("Y-m-d H:i:s"); if($status==4){ if($image=="")return error_show(1005,"付款回单图片不能为空"); if($return_time=="")return error_show(1005,"付款回单时间不能为空"); if($payinfo['pay_fee']< $payment['pay_fee'])return error_show(1005,"对账付款申请金额有误，请确认对账申请金额"); } Db::startTrans(); try{ $payment= Db::name('pay_payment')->where([['dzNo','=',$dzNo],['is_del','=',0]])->lock(true)->find(); $mentupdate =["status"=>$status,"remark"=>$remark,"return_img"=>$image,"updatetime"=>date("Y-m-d H:i:s")]; if($status==3) $mentupdate['return_time'] = $return_time; $payup=Db::name("pay_payment")->where($payment)->update($mentupdate); if($payup){ if (in_array($status,[4,5,6,7])){ if($payinfo['pay_fee']<$payment['pay_fee']) throw new Exception("对账单付款中金额不足"); if($status==4){ //审核通过 扣减对账付款中的金额 添加到已付金额 $payupdate =[ "apay_fee"=>$payinfo['apay_fee']+$payment['pay_fee'], "pay_fee"=>$payinfo['pay_fee']-$payment['pay_fee'], "pay_status" => ($payinfo['pay_fee']-$payment['pay_fee'])==0 && $payinfo['wpay_fee']==0 ?3:2, "updatetime" => date("Y-m-d H:i:s") ]; } if(in_array($status,[5,6,7])){//审核驳回 扣减对账付款中的金额 返回到待付金额中 $payupdate =[ "wpay_fee"=>$payinfo['wpay_fee']+$payment['pay_fee'], "pay_fee"=>$payinfo['pay_fee']-$payment['pay_fee'], "pay_status" => $payinfo['apay_fee']==0 ?1:2, "updatetime" => date("Y-m-d H:i:s") ]; foreach ($cgdNo as $value){ $report=ReportCode::where(["cgdNo"=>$value])->find(); if($report)$report->rmField("DzNo",$dzNo); } } $pay = Db::name("pay")->where($payinfo)->update($payupdate); if($pay==false){ Db::rollback(); return error_show(1003,"对账状态修改失败"); } } Db::commit(); if($payinfo['is_comon']==1 && $status==4){ event("comonOrder",["payNo"=>$payinfo['payNo'],"pay_fee"=>$payment['pay_fee'],"type"=>"pay"]); } return app_show(0,"状态修改成功"); }else{ Db::rollback(); return error_show(1003,"状态修改失败"); } }catch (\Exception $e){ Db::rollback(); return error_show(1008,$e->getMessage()); } } /**对账申请删除 * @return \think\response\Json|void * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\DbException * @throws \think\db\exception\ModelNotFoundException */ public function stageDel(){ $post = $this->post; $dzNo = isset($post['dzNo'])&& $post['dzNo']!="" ? trim($post['dzNo']) :""; if($dzNo==""){ return error_show(1004,"参数 dzNo 不能为空"); } $payment= Db::name("pay_payment")->where([['dzNo',"=",$dzNo],['is_del',"=",0]])->find(); if($payment==false){ return error_show(1005,"未找到付款申请信息"); } $payinfo= Db::name("pay")->where([['payNo',"=",$payment['payNo']],['is_del',"=",0]])->find(); if($payinfo==false){ return error_show(1005,"未找到付款信息"); } $cgdNo =Db::name("pay_info")->where(["payNo"=>$payment['payNo'],"is_del"=>0])->column("cgdNo"); if(empty($cgdNo)) return error_show(1004,"未找到对账数据信息"); Db::startTrans(); try{ $paym = Db::name("pay_payment")->where($payment)->update(["is_del"=>1,"updatetime"=>date("Y-m-d H:i:s")]); if($paym){ if(in_array($payment['status'],[1,2,3,4])){ if(in_array($payment['status'],[1,2,3])){ $payinfo['wpay_fee']+=$payment['pay_fee']; $payinfo['pay_fee']-=$payment['pay_fee']; $payinfo['updatetime']=date("Y-m-d H:i:s"); } if($payment['status']==4){ $payinfo['wpay_fee']+=$payment['pay_fee']; $payinfo['apay_fee']-=$payment['pay_fee']; $payinfo['pay_status']=$payinfo['apay_fee']==0? 1 : 2 ; $payinfo['updatetime']=date("Y-m-d H:i:s"); foreach ($cgdNo as $value){ $report=ReportCode::where(["cgdNo"=>$value])->find(); if($report)$report->rmField("DzNo",$dzNo); } } $pay = Db::name("pay")->save($payinfo); if($pay==false){ Db::rollback(); return error_show(1003,"对账状态修改失败"); } } Db::commit(); return app_show(0,"对账申请删除成功"); } }catch (\Exception $e){ Db::rollback(); return error_show(1003,$e->getMessage()); } } /** * 采购单列表 * @param \think\Request $request * @param int $id * @return \think\Response */ public function CgdList() { $post = $this->post; $condition = [["cgdSource|cgdType","<>",1],['a.is_del',"=",0]]; $check = checkRole($this->roleid,[76,116]); if($check){ $condition []=["ownerid","=",$this->uid]; } $sequenceNo = isset($post['sequenceNo']) && $post['sequenceNo']!='' ? trim($post['sequenceNo']) :""; if($sequenceNo!=""){ $condition []=["a.sequenceNo","like","%$sequenceNo%"]; } $Total = isset($post['total']) && $post['total']!='' ? trim($post['total']) :''; if($Total!=''){ $condition []=['totalPrice',$Total==1?"=":'>',0]; } $orderCode = isset($post['qrdCode']) && $post['qrdCode']!='' ? trim($post['qrdCode']) :""; if($orderCode!=""){ $condition []=["qrdCode","like","%$orderCode%"]; } $status = isset($post['status']) && $post['status']!=='' ? intval($post['status']) :""; $cgd_status = isset($post['cgd_status']) && $post['cgd_status']!=='' ? intval($post['cgd_status']) :""; if($cgd_status!==''){ $condition[]=['cgd_status','=',$cgd_status]; } if($status!==""){ if($status!==''){ if($status==3){ $condition[]=["a.status","<>",2]; }else{ $condition[]=["a.status","=",$status]; } } } $companyNo = isset($post['companyNo']) && $post['companyNo']!='' ? trim($post['companyNo']) :""; if($companyNo!=""){ $condition []=["companyNo","=",$companyNo]; } $payNo=isset($post['payNo']) && $post['payNo'] != '' ? trim($post['payNo']) : ''; if ($payNo != '') { $condition []=[ 'payNo' ,'like' , "%$payNo%" ]; } $cxCode = isset($post['cxCode'])&&$post['cxCode']!==''?trim($post['cxCode']):''; if($cxCode!==''){ $condition[]=["cxCode","=",$cxCode]; } $relaComNo= isset($post['relaComNo'])&&$post['relaComNo']!="" ? trim($post['relaComNo']) :""; if($relaComNo!=""){ $condition[]=["companyNo|supplierNo","=",$relaComNo]; } $companyName = isset($post['companyName']) && $post['companyName']!='' ? trim($post['companyName']) :""; if($companyName!=""){ $condition []=["companyName","like","%$companyName%"]; } $bkCode = isset($post['bkCode']) && $post['bkCode']!='' ? trim($post['bkCode']) :""; if($bkCode!=""){ $condition []=["bkCode","like","%$bkCode%"]; } $goodNo = isset($post['goodNo']) && $post['goodNo']!='' ? trim($post['goodNo']) :""; if($goodNo!=""){ $condition []=["goodNo","like","%$goodNo%"]; } $goodName = isset($post['goodName']) && $post['goodName']!='' ? trim($post['goodName']) :""; if($goodName!=""){ $condition []=["goodName","like","%$goodName%"]; } $supplierName = isset($post['supplierName']) && $post['supplierName']!='' ? trim($post['supplierName']) :""; if($supplierName!=""){ $condition []=["supplierName","like","%$supplierName%"]; } $supplierNo = isset($post['supplierNo']) && $post['supplierNo']!='' ? trim($post['supplierNo']) :""; if($supplierNo!=""){ $condition []=["supplierNo","=",$supplierNo]; } $start=isset($post['start'])&& $post['start']!=''?trim($post['start']):""; $end=isset($post['end'])&& $post['end']!=''?trim($post['end']):""; if($start!='') $condition []=["cgdTime",">=",date("Y-m-d 00:00:00",strtotime($start))]; if($end!='') $condition []=["cgdTime","<=",date("Y-m-d 23:59:59",strtotime($end))]; $cgder= isset($post['cgder']) && $post['cgder']!='' ? trim($post['cgder']) :""; if($cgder!='') $condition []=["ownerName","like","%$cgder%"]; $cgderid= isset($post['cgderid']) && $post['cgderid']!='' ? trim($post['cgderid']) :""; if($cgderid!='') $condition []=["ownerid","=",$cgderid]; $cgdtype= isset($post['cgdtype']) && $post['cgdtype']!='' ? intval($post['cgdtype']) :""; if($cgdtype!='') $condition []=["cgdType","=",$cgdtype]; $cgdsource= isset($post['cgdsource']) && $post['cgdsource']!=='' ? intval($post['cgdsource']) :""; if($cgdsource!=='') $condition []=["cgdSource","=",$cgdsource]; $sendstatus= isset($post['sendstatus']) && $post['sendstatus']!='' ? intval($post['sendstatus']) :""; if($sendstatus!='') $condition []=["qrdSend","=",$sendstatus]; if(isset($post['is_comon'])&&$post['is_comon']!=='') $condition []=["is_comon","=",$post['is_comon']]; $page = isset($post['page'])&&$post['page']!="" ? intval($post['page']) :0; $size = isset($post['size'])&&$post['size']!="" ? intval($post['size']) :10; $list = CgdInfo::alias("a") ->leftJoin("pay_info b","a.sequenceNo=b.cgdNo and b.is_del=0 and b.status=1") ->where($condition) ->order("a.id","desc") ->field("a.*,b.payNo") ->paginate (["list_rows"=>$size,"page"=>$page])->each(function(&$item){ $item['orderTax'] = OrderCategory::where(['code' => $item['sequenceNo'], 'spuCode' => $item['goodNo']]) ->field(['cat_code', 'cat_name', 'merge_code', 'short_name', 'tax', 'inv_good_name'])->findOrEmpty(); $item['catInfo'] = json_decode($item['catInfo'],true); }); //校验是否开通了供应商账号 $supplierAr=array_unique(array_column($list->items(),'supplierNo')); $supp_account = check_has_account_by_supplierNos($supplierAr); $payArr=Db::name('supplier_info')->whereIn('code',$supplierAr)->column('pay_method','code'); foreach ($list->items() as &$value){ $value["pay_type"]=$payArr[$value['supplierNo']]??""; $value['goodNum'] =$value['goodNum']- $value['thNum']; $value['sendNum'] =$value['sendNum']- $value['thNum']; $value['has_account'] = (int)isset($supp_account['data'][$value['supplierNo']]); $value['inv_tag_name']=''; $value['pay_tag_name']=''; $value['pay_tag_img']=''; $value['inv_tag_id']='0'; $value['pay_tag_id']='0'; $value['pay_tag_remark']=''; $value['inv_tag_img']=''; $value['inv_tag_remark']=''; if($value['pay_tag']==1 || $value['inv_tag']==1){ $tag =Db::name('tag_log')->alias('a')->leftJoin('order_tag b','a.tag_id=b.id')->where (['code'=>$value['sequenceNo'],'a.status'=>[5,6]])->order('a.id desc')->column('a.id,b.tag_name,a.tag_img,a .tag_remark','b.type'); if($value['inv_tag']==1){ $value['inv_tag_name']=$tag[6]['tag_name']??''; $value['inv_tag_id']=$tag[6]['id']??'0'; $value['inv_tag_img']=$tag[6]['tag_img']??''; $value['inv_tag_remark']=$tag[6]['tag_remark']??''; } if($value['pay_tag']==1){ $value['pay_tag_id']=$tag[5]['id']??'0'; $value['pay_tag_name']=$tag[5]['tag_name']??''; $value['pay_tag_img']=$tag[5]['tag_img']??''; $value['pay_tag_remark']=$tag[5]['tag_remark']??''; } } } return app_show(0,"获取成功",["list"=>$list->items(),"count"=>$list->total()]); } public function cgdQuery(){ $post = $this->request->only(["cgdNoArr"=>[],"qrdNoArr"=>[],"status"=>"","cgd_status"=>"","is_comon"=>"","relaComNo"=>'',"companyNo"=>"","supplierNo"=>""],"post"); $valid=Validate::rule([ "cgdNoArr|采购单编号集合"=>"requireWithout:qrdNoArr|array", "qrdNoArr|销售单编号集合"=>"requireWithout:cgdNoArr|array", "status|采购单对账状态"=>"number|in:0,1,2,3", "cgd_status|采购单状态"=>"number|in:0,1,2,3,4", "is_comon|是否通用订单"=>"number|in:0,1", ]); if($valid->check($post)==false) return error_show(1004,$valid->getError()); if(!empty($post['qrdNoArr'])){ $cgdNo = Db::name("qrd_info")->where(["sequenceNo"=>$post['qrdNoArr']])->column("cgdNo"); $post["cgdNoArr"]=array_merge($post["cgdNoArr"],$cgdNo); } $condition = [["cgdSource|cgdType","<>",1],['is_del',"=",0],["sequenceNo","in",$post["cgdNoArr"]]]; $companyNo = isset($post['companyNo']) && $post['companyNo']!='' ? trim($post['companyNo']) :""; if($companyNo!=""){ $condition []=["companyNo","=",$companyNo]; } $Total=isset($post['total']) && $post['total'] != '' ? trim($post['total']) : ''; if ($Total != '') { $condition []=[ 'totalPrice' , $Total == 1 ? '=' : '>' , 0 ]; } if($post['cgd_status']!==''){ $condition []=[ 'cgd_status' , '=' , $post['cgd_status'] ]; } if(isset($post['is_comon'])&& $post['is_comon']!=='') $condition []=['is_comon','=',$post['is_comon']]; $relaComNo= isset($post['relaComNo'])&&$post['relaComNo']!="" ? trim($post['relaComNo']) :""; if($relaComNo!=""){ $condition[]=["companyNo|supplierNo","=",$relaComNo]; } $supplierNo = isset($post['supplierNo']) && $post['supplierNo']!='' ? trim($post['supplierNo']) :""; if($supplierNo!=""){ $condition []=["supplierNo","=",$supplierNo]; } $status = isset($post['status']) && $post['status']!=='' ? intval($post['status']) :""; if($status!==''){ if($status==3){ $condition[]=["status","<>",2]; }else{ $condition[]=["status","=",$status]; } } $list = Db::name("cgd_info")->where($condition)->order('createdTime desc')->select()->toArray(); $payArr=Db::name('supplier_info')->whereIn('code',array_unique(array_column($list,'supplierNo')))->column('pay_method','code'); foreach ($list as &$value){ $value['pay_type']=$payArr[$value['supplierNo']]??''; $value['goodNum'] =$value['goodNum']- $value['thNum']; $value['sendNum'] =$value['sendNum']- $value['thNum']; $value['inv_tag_name']=''; $value['pay_tag_name']=''; $value['pay_tag_img']=''; $value['inv_tag_id']='0'; $value['pay_tag_id']='0'; $value['pay_tag_remark']=''; $value['inv_tag_img']=''; $value['inv_tag_remark']=''; if($value['pay_tag']==1 || $value['inv_tag']==1){ $tag =Db::name('tag_log')->alias('a')->leftJoin('order_tag b','a.tag_id=b.id')->where (['code'=>$value['sequenceNo'],'a.status'=>[5,6]])->order('a.id desc')->column('a.id,b.tag_name,a.tag_img,a .tag_remark','b.type'); if($value['inv_tag']==1){ $value['inv_tag_name']=$tag[6]['tag_name']??''; $value['inv_tag_id']=$tag[6]['id']??'0'; $value['inv_tag_img']=$tag[6]['tag_img']??''; $value['inv_tag_remark']=$tag[6]['tag_remark']??''; } if($value['pay_tag']==1){ $value['pay_tag_id']=$tag[5]['id']??'0'; $value['pay_tag_name']=$tag[5]['tag_name']??''; $value['pay_tag_img']=$tag[5]['tag_img']??''; $value['pay_tag_remark']=$tag[5]['tag_remark']??''; } } } return app_show(0,"获取成功",$list); } //采购单信息 public function cgdinfo(){ $post=$this->post; $sequenceNo = isset($post['sequenceNo']) && $post['sequenceNo']!='' ? trim($post['sequenceNo']) :""; if($sequenceNo==''){ return error_show(1004,"参数 sequenceNo 不能为空"); } $cgdinfo = Db::name("cgd_info")->where(["sequenceNo"=>$sequenceNo])->findOrEmpty(); if(empty($cgdinfo)){ return error_show(1004,"采购单信息未找到"); } $cgdinfo['catInfo'] = json_decode($cgdinfo['catInfo'],true); $payinfo =Db::name("pay_info")->alias("a")->leftJoin("pay b","a.payNo=b.payNo") ->where(["a.is_del"=>0,"b.is_del"=>0,"a.cgdNo"=>$sequenceNo])->field("b.inv_status,b.pay_status,b.status") ->find(); $cgdinfo['pay_type']=Db::name('supplier_info')->where('code',$cgdinfo['supplierNo'])->value('pay_method',''); $cgdinfo["cgd_pay_status"]=$payinfo['pay_status']??1; $cgdinfo["cgd_inv_status"]=$payinfo['inv_status']??1; $cgdinfo["pay_status"]=$payinfo['status']??0; $cgdinfo['goodNum'] =$cgdinfo['goodNum']- $cgdinfo['thNum']; $cgdinfo['sendNum'] =$cgdinfo['sendNum']- $cgdinfo['thNum']; $cgdinfo['child']=[]; $cgdinfo['orderTax']= OrderCategory::where(['code' => $cgdinfo['sequenceNo'], 'spuCode' => $cgdinfo['goodNo']]) ->field(['cat_code', 'cat_name', 'merge_code', 'short_name', 'tax', 'inv_good_name'])->findOrEmpty(); $list=(new GoodCombind())->where("spuCode",$cgdinfo['goodNo'])->visible(["child"])->with(["child"]) ->select(); if($list->isEmpty()==false){ $cgdinfo['child']=array_column($list->toArray(),'child'); foreach ($cgdinfo['child'] as &$value){ $value['orderTax'] = OrderCategory::where(['code' => $cgdinfo['sequenceNo'], 'spuCode' => $value['spuCode']]) ->field(['cat_code', 'cat_name', 'merge_code', 'short_name', 'tax', 'inv_good_name'])->findOrEmpty(); } } $cgdinfo['inv_tag_name']=''; $cgdinfo['pay_tag_name']=''; $cgdinfo['pay_tag_img']=''; $cgdinfo['inv_tag_id']='0'; $cgdinfo['pay_tag_id']='0'; $cgdinfo['pay_tag_remark']=''; $cgdinfo['inv_tag_img']=''; $cgdinfo['inv_tag_remark']=''; if($cgdinfo['pay_tag']==1 || $cgdinfo['inv_tag']==1){ $tag =Db::name('tag_log')->alias('a')->leftJoin('order_tag b','a.tag_id=b.id')->where (['code'=>$cgdinfo['sequenceNo'],'a.status'=>[5,6]])->order('a.id desc')->column('a.id,b.tag_name,a.tag_img,a .tag_remark','b.type'); if($cgdinfo['inv_tag']==1){ $cgdinfo['inv_tag_name']=$tag[6]['tag_name']??''; $cgdinfo['inv_tag_id']=$tag[6]['id']??'0'; $cgdinfo['inv_tag_img']=$tag[6]['tag_img']??''; $cgdinfo['inv_tag_remark']=$tag[6]['tag_remark']??''; } if($cgdinfo['pay_tag']==1){ $cgdinfo['pay_tag_id']=$tag[5]['id']??'0'; $cgdinfo['pay_tag_name']=$tag[5]['tag_name']??''; $cgdinfo['pay_tag_img']=$tag[5]['tag_img']??''; $cgdinfo['pay_tag_remark']=$tag[5]['tag_remark']??''; } } return app_show(0,"获取成功",$cgdinfo); } //todo public function PayInfo() { $post = $this->post; $payNo =isset($post['payNo'])&&$post['payNo']!='' ? trim($post['payNo']):""; if($payNo==""){ return error_show(1004,"参数 payNo 不能为空"); } $payinfo =Db::name("pay")->where(["payNo"=>$payNo,"is_del"=>0])->find(); if($payinfo==false){ return error_show(1004,"对账单数据未找到"); } if($payinfo['pay_type']==1){ $pay =Db::name("pay_info")->alias("a")->leftJoin("cgd_info b","a.cgdNo=b.sequenceNo") ->where(["a.is_del"=>0,"b.is_del"=>0,"a.payNo"=>$payNo])->field("b.*") ->select()->toArray(); foreach ($pay as &$value){ $value['orderTax'] = OrderCategory::where(["code"=>$value['sequenceNo'],"spuCode"=>$value['goodNo']]) ->field(['cat_code', 'cat_name', 'merge_code', 'short_name', 'tax', 'inv_good_name'])->findOrEmpty(); $value['catInfo'] = json_decode($value['catInfo'],true); $value['goodNum'] =$value['goodNum']- $value['thNum']; $value['sendNum'] =$value['sendNum']- $value['thNum']; if($payinfo['is_comon']==1){ $value['qrdCode'] = (new \app\admin\model\ComonOrder())->where(['cgdNo'=>$value['sequenceNo']])->value("orderCode",''); } } }else{ $pay =Db::name('pay_info')->alias('a') ->leftJoin('track b','a.cgdNo=b.TrackCode') ->leftJoin('fhd_child c','b.outChildCode=c.outChildCode') ->where(['a.is_del'=>0,"a.status"=>1,'a.payNo'=>$payNo]) ->field('b.*,c.outCode,c.good_name,c.spuCode,c.post_name,c.post_code') ->select()->toArray(); } $payinfo['pay_type']=Db::name('supplier_info')->where('code',$payinfo['supplierNo'])->value('pay_method',''); $payinfo['inv_tag_name']=''; $payinfo['pay_tag_name']=''; $payinfo['pay_tag_img']=''; $payinfo['inv_tag_id']='0'; $payinfo['pay_tag_id']='0'; $payinfo['pay_tag_remark']=''; $payinfo['inv_tag_img']=''; $payinfo['inv_tag_remark']=''; if($payinfo['pay_tag']==1 || $payinfo['inv_tag']==1){ $tag =Db::name('tag_log')->alias('a')->leftJoin('order_tag b','a.tag_id=b.id')->where (['code'=>$payNo,"a.status"=>[1,2]])->order('id desc')->column('a.id,b.tag_name,a.tag_img,a .tag_remark','b.type'); if($payinfo['inv_tag']==1){ $payinfo['inv_tag_name']=$tag[2]['tag_name']??''; $payinfo['inv_tag_id']=$tag[2]['id']??'0'; $payinfo['inv_tag_img']=$tag[2]['tag_img']??''; $payinfo['inv_tag_remark']=$tag[2]['tag_remark']??''; } if($payinfo['pay_tag']==1){ $payinfo['pay_tag_id']=$tag[1]['id']??'0'; $payinfo['pay_tag_name']=$tag[1]['tag_name']??''; $payinfo['pay_tag_img']=$tag[1]['tag_img']??''; $payinfo['pay_tag_remark']=$tag[1]['tag_remark']??''; } } $payinfo['cgdlist'] = $pay; return app_show(0,"获取成功",$payinfo); } public function DzInfo() { $post = $this->post; $DzNo =isset($post['DzNo'])&&$post['DzNo']!='' ? trim($post['DzNo']):""; if($DzNo==""){ return error_show(1004,"参数 DzNo 不能为空"); } $payinfo =Db::name("pay_payment")->where(["dzNo"=>$DzNo,"is_del"=>0])->find(); if($payinfo==false){ return error_show(1004,"对账单付款申请数据未找到"); } $pay =Db::name("pay")->where(["payNo"=>$payinfo['payNo'],"is_del"=>0])->find(); if($pay==false){ return error_show(1004,"对账单数据未找到"); } $payinfo['pay_apply_id'] = $pay['apply_id']??''; $payinfo['pay_apply_name'] = $pay['apply_name']??''; $payinfo['supplierNo'] = $pay['supplierNo']??''; $payinfo['supplierName'] = $pay['supplierName']??''; $payinfo['companyNo'] = $pay['companyNo']??''; $payinfo['companyName'] = $pay['companyName']??''; $payinfo['total_fee'] = $pay['total_fee']??''; return app_show(0,"获取成功",$payinfo); } /**发票新建添加 * @return \think\response\Json|void * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\DbException * @throws \think\db\exception\ModelNotFoundException * @throws \think\exception\DbException */ public function invAdd(){ $post = $this->post; $payNo = isset($post['payNo'])&&$post['payNo']!='' ? $post['payNo']:""; if($payNo==""){ return error_show(1004,"参数 payNo 不能为空"); } $payinfo =Db::name("pay")->where(["payNo"=>$payNo,"is_del"=>0])->find(); if($payinfo==false){ return error_show(1004,"对账单数据未找到"); } if($payinfo['winv_fee']<=0) return error_show(1004,"对账单数据未开票金额为0"); if ($this->level == 2) { //判断是否开通供应商账号 $temp = check_has_account_by_supplierNos([$payinfo['supplierNo']]); if (isset($temp['data'][$payinfo['supplierNo']])) return error_show(1004, '该供应商已经开通账号，不允许当前账号操作'); } // $result=$this->checkSupplier($payinfo['supplierNo']); // if($result['code']!=0){ // return error_show($result['code'],$result['message']); // } if($payinfo['status']!=2){ return error_show(1004,"对账单数据未完成审核"); } $invArr=isset($post['invArr']) && !empty($post['invArr']) ? $post['invArr'] :''; if($invArr==''|| empty($invArr)){ return error_show(1004,"参数 invArr 不能为空"); } $daList=[]; foreach ($invArr as $item){ if(!isset($item['invType'])||$item['invType']=='') return error_show(1004,"参数 invType 不能为空"); // if(in_array($item['invoiceType'],['fully_digitalized_special_electronic','fully_digitalized_normal_electronic']) && $item['invType']!=1){ // return error_show(1004,"全电发票暂不支持图片识别"); // } if($item['invType']==1){ if(!isset($item['invoiceType'])||$item['invoiceType']=='') return error_show(1004,"参数 invoiceType 不能为空"); if (!in_array($item['invoiceType'],$this->invName)) return error_show(1004,"发票类型有误"); //全电票没有发票代码 if(!in_array($item['invoiceType'],['fully_digitalized_special_electronic','fully_digitalized_normal_electronic'])){ if(!isset($item['invCode'])||$item['invCode']=='') return error_show(1004,"参数 invCode 不能为空"); } if(!isset($item['invNumber'])||$item['invNumber']=='') return error_show(1004,"参数 invNumber 不能为空"); if(!isset($item['invoiceType'])||$item['invoiceType']=='') return error_show(1004,"参数 invoiceType 不能为空"); if(!isset($item['open_time'])||$item['open_time']=='') return error_show(1004,"参数 open_time 不能为空"); if(!isset($item['subtotal_amount'])||$item['subtotal_amount']=='') return error_show(1004,"参数 subtotal_amount 不能为空"); $invamount=0; if(in_array($item['invoiceType'],['fully_digitalized_special_electronic','fully_digitalized_normal_electronic'])){ $invamount = $item['subtotal_amount']??0; $item['subtotal_amount']=0; } //普票需要校验码 if(in_array($item['invoiceType'],['normal','roll',"toll",'electronic'])){ if(!isset($item['checkNumber'])||$item['checkNumber']=='') return error_show(1004,"参数 checkNumber 不能为空"); } } if($item['invType']==2){ if(!isset($item['inv_img'])||$item['inv_img']=='') return error_show(1004,"参数 inv_img 不能为空"); if(!isset($item['invName'])||$item['invName']=='') return error_show(1004,"参数 invName 不能为空"); } if($item['invType']==3){ if(!isset($item['inv_img'])||$item['inv_img']=='') return error_show(1004,"参数 inv_img 不能为空"); if(!isset($item['invName'])||$item['invName']=='') return error_show(1004,"参数 invName 不能为空"); } $hpNo=makeNo("hp"); $data=[ "payNo"=>$payNo, "hpNo"=>$hpNo, "apply_id"=>$this->uid, "apply_name"=>$this->uname, "inv_fee"=> 0,//核算金额 "inv_subtotal_amount"=> $item['subtotal_amount']??0, //票面金额 "inv_amount"=> $invamount, //票面金额 "invType"=> $item['invType'], "invoiceType"=>$item['invoiceType']??"", "inv_img"=>$item['inv_img']??'', "invName"=>$item['invName']??'', "invoiceNumber"=>$item['invNumber']??'', "invoiceCode"=>$item['invCode']??'', "status"=>$item['invType']==2 ?0:1, "checkNumber"=>$item['checkNumber']??'', "open_time"=>isset($item['open_time'])&&$item['open_time']!=''? date("Y-m-d",strtotime($item['open_time'])):'', "addtime"=>date("Y-m-d H:i:s"), "updatetime"=>date("Y-m-d H:i:s") ]; $daList[]=$data; } if(empty($daList)) return error_show(1004,"录入数据不能为空"); $cgdNo =Db::name("pay_info")->where(["payNo"=>$payNo,"is_del"=>0])->column("cgdNo"); if(empty($cgdNo)) return error_show(1004,"未找到对账数据信息"); Db::startTrans(); try{ $inadd =Db::name("pay_invoice")->insertAll($daList); if ($inadd){ foreach ($cgdNo as $value){ $report=ReportCode::where(["cgdNo"=>$value])->find(); if($report)$report->setField("hpNo",$hpNo); } Db::commit(); return app_show(0,"回票新建成功"); } Db::rollback(); return error_show(1004,"回票申请新建失败"); }catch (\Exception $e){ Db::rollback(); return error_show(1004,$e->getMessage()); } } //批量添加发票信息 public function invAddBatchByImport() { try { $param = $this->request->only(['list', 'companyNo', 'is_comon'], 'post', 'trim'); $validate = Validate::rule([ 'list' => 'require|array|max:100', 'companyNo|卖出方公司编号' => 'require|max:255|checkCompanyNo:', 'is_comon|是否通用对账' => 'require|number|in:0,1', ]); $validate->extend('checkCompanyNo', function ($val, $rule, $da) { $tmp = Db::name('user_role') ->field('id,status') ->where(['is_del' => 0, 'uid' => $this->uid, 'companyNo' => $val]) ->findOrEmpty(); if (empty($tmp)) return '账号尚未绑定当前公司'; if ($tmp['status'] == 0) return '当前公司已禁用'; return true; }); if (!$validate->check($param)) throw new Exception($validate->getError()); $val = Validate::rule([ 'payNo|对账编号' => 'require|max:255', 'invoiceType|发票类型' => 'require|in:' . implode(',', array_values($this->invName)), 'invoiceCode|发票代码' => 'max:255|checkInvoiceCode:', 'invoiceNumber|发票号码' => 'require|max:255', 'inv_subtotal_amount|发票税前金额' => 'require|float|max:9999999.99', 'open_time|开票日期' => 'require|date', 'checkNumber|校验码' => 'checkNumberCallback:', ]); $val->extend('checkNumberCallback', function ($val, $rule, $da) { if (in_array($da['invoiceType'], ['special', 'normal', 'roll', 'special_electronic', 'electronic', 'toll'])) { if (empty($val)) return '电子票时校验码必填'; } return true; }); $val->extend('checkInvoiceCode', function ($val, $rule, $da) { if (in_array($da['invoiceType'], ['special', 'normal', 'roll', 'special_electronic', 'electronic', 'toll'])) { if (empty($val)) return '发票代码必填'; } return true; }); //所有的payNo(对账编码) $payNo = array_column($param['list'], 'payNo'); $payinfo = Db::name('pay') ->where('is_del', 0) ->whereIn('payNo', $payNo) ->column('id,payNo,supplierNo,supplierName,status,is_comon', 'payNo'); $Supp=[]; if ($this->level == 2) { //判断是否开通供应商账号 $suppArr=array_unique(array_column($payinfo,'supplierNo')); $temp = check_has_account_by_supplierNos(array_unique(array_column($payinfo,"supplierNo"))); $Supp = $temp['data']??[]; } //$da_insert 批量新增的数据，$payNo_hpNo对账编码=>回票编码 $da_insert = $payNo_hpNo = []; $date = date('Y-m-d H:i:s'); $unique=[]; $diesa=[]; foreach ($param['list'] as $item) { if (!$val->check($item)) throw new Exception($val->getError()); if(in_array($item['invoiceNumber'],$unique))throw new Exception("{$item['invoiceNumber']} 发票重复提交"); $unique[]=$item['invoiceNumber']; if (!isset($payinfo[$item['payNo']])) throw new Exception('对账单数据未找到'); if ($payinfo[$item['payNo']]['status'] != 2) throw new Exception('对账单数据未完成审核'); if($payinfo[$item['payNo']]['is_comon'] != $param['is_comon']){ $diesa[]=$item['payNo']; } if ($this->level == 2) { if ( isset($Supp[$payinfo[$item['payNo']]['supplierNo']])) throw new Exception("该供应商{$payinfo[$item['payNo']]['supplierName']}已经开通账号，不允许当前账号操作"); } $invamount=0; if(in_array($item['invoiceType'],['fully_digitalized_special_electronic','fully_digitalized_normal_electronic'])){ $invamount = $item['inv_subtotal_amount']??0; $item['inv_subtotal_amount']=0; } $hpNo = makeNo('hp'); $da_insert[] = [ 'payNo' => $item['payNo'], 'hpNo' => $hpNo, 'apply_id' => $this->uid, 'apply_name' => $this->uname, 'inv_fee' => 0,//核算金额 'inv_subtotal_amount' => $item['inv_subtotal_amount'] ?? 0, //票面金额 'inv_amount' => $invamount, //票面金额 'invType' => 1, 'invoiceType' => $item['invoiceType'], 'inv_img' => '', 'invName' => '', 'invoiceNumber' => $item['invoiceNumber'], 'invoiceCode' => $item['invoiceCode'], 'status' => 1, 'checkNumber' => $item['checkNumber'], 'open_time' => date('Y-m-d', strtotime($item['open_time'])), 'addtime' => $date, 'updatetime' => $date ]; $payNo_hpNo[$item['payNo']] = $hpNo; } if(empty($diesa)==false){ $this->error("对账单不符合对账要求",10004,$diesa); } $cgdNo = Db::name('pay_info') ->where('is_del', 0) ->whereIn('payNo', $payNo) ->column('cgdNo', 'payNo'); if (empty($cgdNo)) throw new Exception('未找到对账数据信息'); Db::startTrans(); try { Db::name('pay_invoice')->insertAll($da_insert); foreach ($cgdNo as $payNoTmp => $cgdNoTmp) { Db::name('report_code') ->where('cgdNo', $cgdNoTmp) ->update(['hpNo' => $payNo_hpNo[$payNoTmp]]); } Db::commit(); return app_show(0, '回票新建成功'); } catch (Exception $e) { Db::rollback(); return error_show(1004, '回票新建失败,' . $e->getMessage()); } } catch (Exception $exception) { return error_show(1005, $exception->getMessage()); } } /** * 发票审核状态 //发票验证通过 才会扣减待开票金额 失败的开票申请不用处理 * // 1待系统验证 2 买方公司审核 3带买方公司认证 4 认证成功 5验证失败 6买方审核驳回 7 认证失败 8 回票流程终止 9 验证超次数 10 回票已退 * 11 待关联订单 12 订单关联完毕待财务审核 13 订单关联完毕财务驳回 * @return \think\response\Json|void * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\DbException * @throws \think\db\exception\ModelNotFoundException * @throws \think\exception\DbException */ public function invStatus(){ $param = $this->request->param(["hpNo"=>"","status"=>"","remark"=>"","ItemRemark"=>[]],"post","trim"); $valid = Validate::rule(["hpNo|回票申请编号"=>"require|max:255","status"=>"require|number|in:1,2,3,4,6,7,8,13"]); if(!$valid->check($param))$this->error($valid->getError()); $info = PayInvoice::where(["hpNo"=>$param['hpNo'],"is_del"=>0])->findOrEmpty(); if ($info->isEmpty())$this->error("未找到回票申请信息"); $payinfo = Pay::where(['payNo'=>$info['payNo'],"is_del"=>0])->findOrEmpty(); if ($payinfo->isEmpty())$this->error("未找到对账单信息"); if($payinfo['status']!=2&&$param['status']==3)$this->error("对账信息未完成审核"); if($payinfo['inv_fee']< $info['inv_fee']) $this->error("回票金额不能大于对账单回票金额"); $invup =['remark'=>$param['remark'],'updatetime'=>date('Y-m-d H:i:s')]; if($param['status']==3) $invup['check_time']=date("Y-m-d H:i:s"); if(in_array($info['invoiceType'],['normal','electronic','toll','roll']) && $param['status']==3){ $param['status']=4; //普票无需认证 } $invup['status']=$param['status']; Db::startTrans(); try { $save=$info->save($invup); if($save){ if($param['status']==4){ Pay::addAinv($info['payNo'],$info->inv_fee); } if($param['status']==3){ if (!empty($param['ItemRemark'])){ (new InvoiceOrder)->saveAll($param['ItemRemark']); }; } if(in_array($param['status'],[5,6,7,8,13])){ Pay::subInv($info['payNo'],$info->inv_fee); if($param['status']==13||$param['status']==7)\app\admin\model\InvoiceItem::rmInvoice($param['hpNo']); event("reportCode",["param"=>["key"=>"hpNo","value"=>$param['hpNo']],"type"=>"sub"]); } }else throw new \Exception("回票审核失败"); Db::commit(); }catch (\Exception $e){ Db::rollback(); $this->error($e->getMessage()); } $this->success("回票审核成功"); } // public function invStatus(){ // $post = $this->post; // $hpNo = isset($post['hpNo'])&& $post['hpNo']!="" ? trim($post['hpNo']) :""; // if($hpNo==""){ // return error_show(1004,"参数 hpNo 不能为空"); // } // $status = isset($post['status'])&& $post['status']!="" ? intval($post['status']) :""; // if($status==""){ // return error_show(1004,"参数status 不能为空"); // } //// if(!in_array($status,[0,1,2,3,4,5,6,7,8,9,10,11,12])){ //// return error_show(1004,"参数status 无效值"); //// } // if(!in_array($status,[0,1,2,3,4,5,6,7])){ // return error_show(1004,"参数status 无效值"); // } // $payment= Db::name("pay_invoice")->where([['hpNo',"=",$hpNo],['is_del',"=",0]])->find(); // // if($payment==false){ // return error_show(1005,"未找到回票申请信息"); // } // $payinfo= Db::name("pay")->where([['payNo',"=",$payment['payNo']],['is_del',"=",0]])->find(); // // if($payinfo==false){ // return error_show(1005,"未找到对账信息"); // } // if($payinfo['status']!=2){ // return error_show(1005,"对账信息未完成审核"); // } // $cgdNo =Db::name("pay_info")->where(["payNo"=>$payment['payNo'],"is_del"=>0])->column("cgdNo"); // if(empty($cgdNo)) return error_show(1004,"未找到对账数据信息"); // if($payinfo['inv_fee']< $payment['inv_fee'])return error_show(1005,"对账回票申请金额有误，请确认回票申请金额"); // $remark = $post['remark']??''; // Db::startTrans(); // try { // Db::name('pay_invoice')->where([['hpNo','=',$hpNo],['is_del','=',0]])->lock(true)->find(); // $invup =["remark"=>$remark,"updatetime"=>date("Y-m-d H:i:s")]; // if($status==3) $invup['check_time']=date("Y-m-d H:i:s"); // if(in_array($payment['invoiceType'],['normal','electronic','toll','roll']) && $status==3){ // $status=4; //普票无需认证 // } // $invup['status']=$status; // $inv =Db::name("pay_invoice")->where($payment)->update($invup); // if($inv){ // if($status==4){ // $payupdate =[ // "ainv_fee"=>$payinfo['ainv_fee']+$payment['inv_fee'], // "inv_fee"=>$payinfo['inv_fee']-$payment['inv_fee'], // "inv_status" => ($payinfo['inv_fee']-$payment['inv_fee'])==0 && $payinfo['winv_fee']==0?3:2, // "updatetime" => date("Y-m-d H:i:s") // ]; // $pay =Db::name("pay")->where($payinfo)->update($payupdate); // if($pay==false){ // Db::rollback(); // return error_show(1003,"回票申请状态更新失败"); // } // } // if($status==6 || $status==5|| $status==7){ // $payupdate =[ // "winv_fee"=>$payinfo['winv_fee']+$payment['inv_fee'], // "inv_fee"=>$payinfo['inv_fee']-$payment['inv_fee'], // "inv_status" => ($payinfo['inv_fee']-$payment['inv_fee'])==0 && $payinfo['ainv_fee']==0?1:2, // "updatetime" => date("Y-m-d H:i:s") // ]; // $pay =Db::name("pay")->where($payinfo)->update($payupdate); // if($pay==false){ // Db::rollback(); // return error_show(1003,"回票申请状态更新失败"); // } // foreach ($cgdNo as $value){ // $report=ReportCode::where(["cgdNo"=>$value])->find(); // if($report)$report->rmField("hpNo",$hpNo); // } // } // Db::commit(); // return app_show(0,"回票申请更新成功"); // }throw new \Exception("回票申请状态更新失败"); // }catch (\Exception $e){ // Db::rollback(); // return error_show(1004,$e->getMessage()); // } // // } /**发票列表识别 * @param int $id * @return \think\Response */ public function InvList() { $post = $this->post; $condition = [["a.is_del","=",0 ],['a.invType','<>',4 ],["b.is_del","=",0 ],['pay_type','=',$post['pay_type']??1]]; $invtype = isset($post['invType'])&&$post['invType']!='' ? intval($post['invType']):""; $check = checkRole($this->roleid,[82,120]); if($check){ $condition []=["a.apply_id","=",$this->uid]; } if ($invtype!=''){ $condition[]=["a.invType","=",$invtype]; } $companyNo = isset($post['companyNo'])&&$post['companyNo']!='' ? trim($post['companyNo']):""; if($companyNo!=""){ $condition[]=["b.companyNo","=",$companyNo]; } $relaComNo= isset($post['relaComNo'])&&$post['relaComNo']!="" ? trim($post['relaComNo']) :""; if($relaComNo!=""){ $condition[]=["b.companyNo|b.supplierNo","=",$relaComNo]; } $supplierNo = isset($post['supplierNo'])&&$post['supplierNo']!='' ? trim($post['supplierNo']):""; if($supplierNo!=""){ $condition[]=["b.supplierNo","=",$supplierNo]; } $hpNo = isset($post['hpNo'])&&$post['hpNo']!='' ? trim($post['hpNo']):""; if ($hpNo!=''){ $condition[]=["a.hpNo","like","%$hpNo%"]; } $payNo = isset($post['payNo'])&&$post['payNo']!='' ? trim($post['payNo']):""; if ($payNo!=''){ $condition[]=["a.payNo","like","%$payNo%"]; } $invoiceType = isset($post['invoiceType'])&&$post['invoiceType']!='' ? intval($post['invoiceType']):""; if ($invoiceType!=''){ $condition[]=["a.invoiceType","=",$invoiceType]; } $status = isset($post['status'])&&$post['status']!=="" ? intval($post['status']):""; if($status!==""){ $condition[]=["a.status","=",$status]; } $invNumber = isset($post['invNumber'])&&$post['invNumber']!="" ? trim($post['invNumber']):""; if($invNumber!=''){ $condition[]=["invoiceNumber","=",$invNumber]; } $checkApi = isset($post['checkApi'])&&$post['checkApi']!="" ? intval($post['checkApi']):""; if($checkApi!==''){ $condition[]=["checkApi","=",$checkApi]; } $invCode = isset($post['invCode'])&&$post['invCode']!="" ? trim($post['invCode']):""; if($invCode!=''){ $condition[]=["invoiceCode","=",$invCode]; } $start = isset($post['start']) && $post['start']!="" ? $post['start'] :""; if($start!=""){ $condition[]=["a.addtime",">=",$start." 00:00:00"]; } $end = isset($post['end']) && $post['end']!="" ? $post['end'] :""; if($end!=""){ $condition[]=["a.addtime","<=",$end." 23:59:59"]; } $open_start = isset($post['open_start']) && $post['open_start']!="" ? $post['open_start'] :""; if($open_start!=""){ $condition[]=["a.open_time",">=",$open_start]; } $open_end = isset($post['open_end']) && $post['open_end']!="" ? $post['open_end'] :""; if($open_end!=""){ $condition[]=["a.open_time","<=",$open_end]; } $apply_id = isset($post['apply_id']) && $post['apply_id']!="" ? $post['apply_id'] :""; if($apply_id!=""){ $condition[]=["a.apply_id","=",$apply_id]; } $apply_name = isset($post['apply_name']) && $post['apply_name']!="" ? trim($post['apply_name']):""; if($apply_name!=""){ $condition[]=["a.apply_name","like","%$apply_name%"]; } if(isset($post['is_comon'])&&$post['is_comon']!=='') $condition []=['is_comon','=',$post['is_comon']]; $page = isset($post['page'])&&$post['page']!="" ? intval($post['page']):1; $size = isset($post['size'])&&$post['size']!="" ? intval($post['size']):10; $count =Db::name("pay_invoice") ->alias("a") ->leftJoin("pay b","a.payNo=b.payNo") ->where($condition) ->count(); $total = ceil($count/$size); $page = $page>$total? intval($total):$page; $list = Db::name("pay_invoice") ->alias("a") ->leftJoin("pay b", "a.payNo=b.payNo") ->field("a.*,b.supplierNo,b.supplierName,b.companyName,b.is_comon,b.companyNo") ->where($condition) ->page($page,$size) ->order("addtime desc") ->select() ->toArray(); //校验是否开通了供应商账号 $supp_account = check_has_account_by_supplierNos(array_unique(array_column($list,'supplierNo'))); $inv_fee=$inv_subtotal_amount = $total = 0; foreach ($list as &$value){ $invoinfo =InvoiceInfo::where(["hpNo"=>$value['hpNo'],"status"=>1])->find(); $value['buyer_name'] = $invoinfo['buyer_name']??""; $value['buyer_id'] = $invoinfo['buyer_id']??""; $value['buyer_address'] = $invoinfo['buyer_address']??""; $value['buyer_bank'] = $invoinfo['buyer_bank']??""; $value['seller_name'] = $invoinfo['seller_name']??""; $value['seller_id'] = $invoinfo['seller_id']??""; $value['seller_address'] = $invoinfo['seller_address']??""; $value['seller_bank'] = $invoinfo['seller_bank']??""; $value['subtotal_amount'] = $invoinfo['subtotal_amount']??""; $value['subtotal_tax'] = $invoinfo['subtotal_tax']??""; $value['total'] = $invoinfo['total']??""; $value['receiver'] = $invoinfo['receiver']??""; $value['issuer'] = $invoinfo['issuer']??""; $value['reivewer'] = $invoinfo['reivewer']??""; $value['remarks'] = $invoinfo['remarks']??""; $value['invoiceType_cn'] = $this->invoiceType[$value['invoiceType']]??''; $value['invStatus_cn'] = $this->invStatus[$value['invStatus']]??''; $value['item_list'] = $invoinfo['item_list']??[]; $value['has_account'] = (int)isset($supp_account['data'][$value['supplierNo']]); if($value['status']==4){ $inv_fee += $value['inv_fee']; $inv_subtotal_amount += intval($value['inv_subtotal_amount']??0); $total += intval($value['total']??0); } } //结算invlist这个接口当用payNo筛选的时候，返回列表里需要加一项统计筛选后列表的inv_subtotal_amount、total字段的和 // $inv_fee=$inv_subtotal_amount = $total = 0; // if ($payNo != '') { // $inv_subtotal_amount = round(array_sum(array_column($list, 'inv_subtotal_amount')), 2); // $total = round(array_sum(array_column($list, 'total')), 2); // } return app_show(0, "获取成功", [ "count" => $count, "list" => $list, 'inv_subtotal_amount' => $inv_subtotal_amount, 'total' => $total, "inv_fee"=>$inv_fee ]); } /**发票删除 * @return \think\response\Json|void * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\DbException * @throws \think\db\exception\ModelNotFoundException */ public function invDel(){ $post = $this->post; $hpNo = isset($post['hpNo'])&&$post['hpNo']!="" ? trim($post['hpNo']) :""; if ($hpNo==""){ return error_show(1004,"参数 hpNo 不能为空"); } $payinv =Db::name("pay_invoice")->where(["hpNo"=>$hpNo,"is_del"=>0])->find(); if($payinv==false){ return error_show(1004,"对账单回票申请未找到数据"); } $payinfo= Db::name("pay")->where([['payNo',"=",$payinv['payNo']],['is_del',"=",0]])->find(); if($payinfo==false){ return error_show(1005,"未找到对账信息"); } if ($this->level == 2) { //判断是否开通供应商账号 $temp = check_has_account_by_supplierNos([$payinfo['supplierNo']]); if (isset($temp['data'][$payinfo['supplierNo']])) return error_show(1004, '该供应商已经开通账号，不允许当前账号操作'); } if($payinfo['status']!=2){ return error_show(1005,"对账信息未完成审核"); } $cgdNo =Db::name("pay_info")->where(["payNo"=>$payinv['payNo'],"is_del"=>0])->column("cgdNo"); if(empty($cgdNo)) return error_show(1004,"未找到对账数据信息"); Db::startTrans(); try{ $update=["status"=>8,"updatetime"=>date("Y-m-d H:i:s")]; //删除状态 流程终止 $invup =Db::name("pay_invoice")->where($payinv)->update($update); if($invup){ if($payinv['status']==4){ if($payinfo['ainv_fee']< $payinv['inv_fee']){ Db::rollback(); return error_show(1005,"对账回票申请金额有误，请确认回票申请金额"); } $payupdate =[ "ainv_fee"=>$payinfo['ainv_fee']-$payinv['inv_fee'], "winv_fee"=>$payinfo['winv_fee']+$payinv['inv_fee'], "inv_status" => ($payinfo['ainv_fee']-$payinv['inv_fee'])==0?1:2, "updatetime" => date("Y-m-d H:i:s") ]; $pay =Db::name("pay")->where($payinfo)->update($payupdate); if($pay==false){ Db::rollback(); return error_show(1003,"删除失败"); } foreach ($cgdNo as $value){ $report=ReportCode::where(["cgdNo"=>$value])->find(); if($report)$report->rmField("hpNo",$hpNo); } } if(in_array($payinv['status'], [1,2,3,11,12])){ if($payinfo['inv_fee']< $payinv['inv_fee']){ Db::rollback(); return error_show(1005,"对账回票申请金额有误，请确认回票申请金额"); } Pay::subInv($payinfo['payNo'],$payinv['inv_fee']); if(in_array($payinv['status'], [2,3,12])) \app\admin\model\InvoiceItem::rmInvoice($param['hpNo']); foreach ($cgdNo as $value){ $report=ReportCode::where(["cgdNo"=>$value])->find(); if($report)$report->rmField("hpNo",$hpNo); } } Db::commit(); return app_show(0,"删除成功"); } }catch (\Exception $e){ Db::rollback(); return error_show(1003,$e->getMessage()); } } public function HpInfo(){ $post = $this->post; $hpNo = isset($post['hpNo'])&&$post['hpNo']!="" ? trim($post['hpNo']) :""; if ($hpNo==""){ return error_show(1004,"参数 hpNo 不能为空"); } $payinv =Db::name("pay_invoice")->where(["hpNo"=>$hpNo,"is_del"=>0])->find(); if($payinv==false){ return error_show(1004,"对账单回票申请未找到数据"); } $payinfo= Db::name("pay")->where([['payNo',"=",$payinv['payNo']],['is_del',"=",0]])->find(); if($payinfo==false){ return error_show(1005,"未找到对账信息"); } $payinv['pay_apply_id'] = $payinfo['apply_id']??''; $payinv['pay_apply_name'] = $payinfo['apply_name']??''; $payinv['supplierNo'] = $payinfo['supplierNo']??''; $payinv['supplierName'] = $payinfo['supplierName']??''; $payinv['companyNo'] = $payinfo['companyNo']??''; $payinv['companyName'] = $payinfo['companyName']??''; $payinv['total_fee'] = $payinfo['total_fee']??''; $invinfo =InvoiceInfo::where(["hpNo"=>$hpNo])->findOrEmpty(); $payinv['invoiceType_cn'] = $this->invoiceType[$payinv['invoiceType']]??''; $payinv['invStatus_cn'] = $this->invStatus[$payinv['invStatus']]??''; $payinv["info"]=$invinfo; return app_show(0,'获取成功',$payinv); } /** * @return \think\response\Json|void * @throws \think\db\exception\DbException */ public function UnPay(){ $post = $this->post; $codeNo = isset($post['id'])&&$post['id']!=="" ? trim($post['id']) :''; if($codeNo===""){ return error_show(1004,'参数 id 不能为空'); } $update = Db::name('cgd_info')->where("id","in",$codeNo)->update(['status'=>2,"updatetime"=>date("Y-m-d H:i:s")]); if($update){ return app_show(0,'更新成功'); }else{ return error_show(1004,'更新失败'); } } /** * @return \think\|\think\response\Json|void */ public function ticketInfo(){ $num =isset($this->post['number'])&&$this->post['number']!=''?trim($this->post['number']):""; if($num==''){ return error_show(1004,'参数 number 不能为空'); } $condition=[]; $condition[]=["number","=",$num]; $invNo = isset($this->post['invNo'])&&$this->post['invNo']!=''?trim($this->post['invNo']):""; if($invNo!=='')$condition[]=["hpNo","=",$invNo]; $info =InvoiceInfo::where($condition)->findOrEmpty(); return empty($info)?error_show(1005,"为找到数据"):app_show(0,"获取成功",$info); } /** * @return \think\response\Json|void * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\DbException * @throws \think\db\exception\ModelNotFoundException */ public function hpinvList(){ $post=$this->request->only(["hpNo"=>"","page"=>1,"size"=>15],"post","trim"); $where=[]; if($post["hpNo"]!="") $where[]=["hpNo","=",$post['hpNo']]; $count=InvoiceInfo::where($where)->count(); $total =ceil($count/$post['size']); $page= $post['page']>$total ? intval($total):intval($post['page']); $list = InvoiceInfo::where($where) ->page($page,intval($post['size'])) ->order("id desc") ->select()->toArray(); foreach ($list as &$value){ $value['type_name'] = $this->invoiceType[$value['type']]??""; } return app_show(0,"获取成功",["list"=>$list,"count"=>$count]); } public function hpinvReturn(){ $param =$this->request->only(["hpNo"=>"","reason"=>""],"post","trim"); $valide=Validate::rule([ "hpNo|回票编号"=>"require|max:255", "reason|申请原因"=>"require|max:255" ]); if($valide->check($param)==false)return error_show(1004,$valide->getError()); $hpinfo =Db::name("pay_invoice")->where([["hpNo","=",$param['hpNo']],["is_del","=",0]])->findOrEmpty(); if(empty($hpinfo)) return error_show(1004,"回票信息未找到"); $payinfo =Db::name("pay")->where(["payNo"=>$hpinfo['payNo'],"is_del"=>0])->find(); if($payinfo==false){ return error_show(1004,"对账单数据未找到"); } if ($this->level == 2) { //判断是否开通供应商账号 $temp = check_has_account_by_supplierNos([$payinfo['supplierNo']]); if (isset($temp['data'][$payinfo['supplierNo']])) return error_show(1004, '该供应商已经开通账号，不允许当前账号操作'); } if($hpinfo['status']!=4)return error_show(1004,"回票信息流程未完成"); $isR=Db::name("pay_return")->where(["orderCode"=>$param['hpNo'],"status"=>[1,2],"is_del"=>0])->findOrEmpty(); if(!empty($isR))return error_show(1004,"回票信息退票流程已存在"); $returnCode =makeNo("RP"); $data = [ "returnCode"=>$returnCode, "returnType"=>1, "payNo"=>$hpinfo['payNo'], "orderCode"=>$param['hpNo'], "reason"=>$param['reason'], "returnImg"=>'', "remark"=>'', "status"=>1, "apply_id"=>$this->uid, "apply_name"=>$this->uname, "is_del"=>0, "addtime"=>date("Y-m-d H:i:s"), "updatetime"=>date("Y-m-d H:i:s"), ]; $insert=Db::name("pay_return")->insert($data); if($insert){ return app_show(0,"退票申请新建成功",$returnCode); }else{ return error_show(1004,"退票申请新建失败"); } } public function hpinvReturnList(){ $param =$this->request->only(["relaComNo"=>"","companyNo"=>"","supplierNo"=>"","start"=>"","end"=>"","returnCode"=>"", "status"=>"","hpNo"=>"","is_comon"=>"","payNo"=>"","pay_type"=>"","page"=>1,"size"=>15],"post","trim"); $condition=[["a.is_del","=",0],['a.returnType',"=",1],['pay_type','=',$param['pay_type']?:1]]; $check = checkRole($this->roleid,[132,130]); if($check){ $condition []=["a.apply_id","=",$this->uid]; } if($param['relaComNo']!="") $condition[]=["b.companyNo|b.supplierNo","=",$param['relaComNo']]; if($param['companyNo']!="") $condition[]=["b.companyNo","=",$param['companyNo']]; if($param['supplierNo']!="") $condition[]=["b.supplierNo","=",$param['supplierNo']]; if($param['start']!="") $condition[]=["a.addtime",">=",date("Y-m-d H:i:s",strtotime($param['start']))]; if($param['end']!="") $condition[]=["a.addtime","<=",date("Y-m-d 23:59:59",strtotime($param['end']))]; if($param['status']!="") $condition[]=["a.status","=",$param['status']]; if($param['is_comon']!="") $condition[]=["b.is_comon","=",$param['is_comon']]; if($param['hpNo']!="") $condition[]=["a.orderCode","like","%{$param['hpNo']}%"]; if($param['returnCode']!="") $condition[]=["a.returnCode","like","%{$param['returnCode']}%"]; if($param['payNo']!="") $condition[]=["a.payNo","like","%{$param['payNo']}%"]; if(isset($param['is_comon'])&&$param['is_comon']!=='') $condition []=['is_comon','=',$param['is_comon']]; $count = Db::name("pay_return") ->alias("a") ->leftJoin("pay b", "a.payNo=b.payNo and b.is_del=0") ->leftJoin("pay_invoice c", "a.orderCode=c.hpNo") ->where($condition) ->count(); $total = ceil($count / $param['size']); $page = $param['page'] >= $total ? intval($total) : intval($param['page']); $list = Db::name("pay_return") ->alias("a") ->leftJoin("pay b", "a.payNo=b.payNo and b.is_del=0") ->leftJoin("pay_invoice c", "a.orderCode=c.hpNo") ->where($condition) ->page($page, intval($param['size'])) ->order('id desc') ->field("a.*,b.is_comon,b.supplierNo,b.supplierName,b.companyNo,b.companyName,b.total_fee,b.ainv_fee,b.winv_fee,b.inv_fee,c.inv_fee pay_inv_fee") ->select() ->toArray(); //校验是否开通了供应商账号 $supp_account = check_has_account_by_supplierNos(array_unique(array_column($list, 'supplierNo'))); foreach ($list as &$value) { $value['has_account'] = (int)isset($supp_account['data'][$value['supplierNo']]); $value['inv_number']= \app\admin\model\InvoiceInfo::where(["hpNo"=>$value['orderCode']])->value("number",''); } return app_show(0,"获取成功",["list"=>$list,"count"=>$count]); } public function hpinvReturnStatus(){ $param =$this->request->only(["returnCode"=>"","status"=>"","remark"=>"","returnImg"=>""],"post","trim"); $valide=Validate::rule([ "returnCode|退票申请编号"=>"require|max:255", "status|状态"=>"require|number|in:1,2,3", ]); if($valide->check($param)==false)return error_show(1004,$valide->getError()); $returninfo =Db::name("pay_return")->where(["is_del"=>0,"returnCode"=>$param['returnCode']])->findOrEmpty(); if(empty($returninfo))return error_show(1004,"退票详情未找到"); Db::startTrans(); try{ $update=[ "status"=>$param['status'], "remark"=>$param['remark'], "returnImg"=>$param['returnImg'], "updatetime"=>date("Y-m-d H:i:s") ]; $up =Db::name("pay_return")->where($returninfo)->update($update); if($up==false)throw new Exception("退票申请审核失败"); if($param['status']==2){ $invinfo =Db::name('pay_invoice')->where(['hpNo'=>$returninfo['orderCode'],'is_del'=>0])->findOrEmpty(); if(empty($invinfo))throw new Exception('回票详情未找到'); $pay =Db::name('pay')->where(['payNo'=>$returninfo['payNo'],'is_del'=>0])->findOrEmpty(); if(empty($pay))throw new Exception('对账详情未找到'); $invup =Db::name('pay_invoice')->where($invinfo)->update(['status'=>10,'updatetime'=>date('Y-m-d H:i:s')]); if($invup==false)throw new Exception('回票更新失败'); Pay::subAinv($returninfo['payNo'],$invinfo['inv_fee']); \app\admin\model\InvoiceItem::rmInvoice($returninfo['orderCode'],2); } Db::commit(); }catch (\Exception $e){ Db::rollback(); return error_show(1005,$e->getMessage()); } $this->success("退票申请审核成功"); } public function hpinvReturnInfo(){ $param = $this->request->only(["returnCode"=>""],"post","trim"); $valide=Validate::rule([ "returnCode|退票申请编号"=>"require|max:255", ]); if($valide->check($param)==false)return error_show(1004,$valide->getError()); $info = Db::name("pay_return")->alias("a") ->leftJoin("pay b","a.payNo=b.payNo and b.is_del=0") ->leftJoin("pay_invoice c","a.orderCode=c.hpNo") ->where(['returnCode'=>$param['returnCode']]) ->field("a.*,b.supplierNo,b.supplierName,b.companyNo,b.companyName,c.check_remark,b.total_fee,b.ainv_fee,b.winv_fee,b.inv_fee,c.inv_fee pay_inv_fee") ->findOrEmpty(); return app_show(0,"退票申请获取成功",$info); } //付款退回 public function stageReturn(){ $param =$this->request->only(["dzNo"=>"","reason"=>""],"post","trim"); $valide=Validate::rule([ "dzNo|付款编号"=>"require|max:255", "reason|申请原因"=>"require|max:255" ]); if($valide->check($param)==false)return error_show(1004,$valide->getError()); $hpinfo =Db::name("pay_payment")->where([["dzNo","=",$param['dzNo']],["is_del","=",0]])->findOrEmpty(); if(empty($hpinfo)) return error_show(1004,"付款信息未找到"); $payinfo =Db::name("pay")->where(["payNo"=>$hpinfo['payNo'],"is_del"=>0])->find(); if($payinfo==false){ return error_show(1004,"对账单数据未找到"); } if ($this->level == 2 && $payinfo['is_comon']==0) { //判断是否开通供应商账号 $temp = check_has_account_by_supplierNos([$payinfo['supplierNo']]); if (isset($temp['data'][$payinfo['supplierNo']])) return error_show(1004, '该供应商已经开通账号，不允许当前账号操作'); } if(!in_array($hpinfo['status'],[3,4]))return error_show(1004,"付款信息流程未完成"); $isR=Db::name("pay_return")->where(["orderCode"=>$param['dzNo'],"status"=>[1,2],"is_del"=>0])->findOrEmpty(); if(!empty($isR))return error_show(1004,"付款信息退款流程已存在"); $returnCode =makeNo("RP"); $data = [ "returnCode"=>$returnCode, "returnType"=>2, "payNo"=>$hpinfo['payNo'], "orderCode"=>$param['dzNo'], "reason"=>$param['reason'], "returnImg"=>'', "remark"=>'', "status"=>1, "apply_id"=>$this->uid, "apply_name"=>$this->uname, "is_del"=>0, "addtime"=>date("Y-m-d H:i:s"), "updatetime"=>date("Y-m-d H:i:s"), ]; $insert=Db::name("pay_return")->insert($data); if($insert){ return app_show(0,"退款申请新建成功",$returnCode); }else{ return error_show(1004,"退款申请新建失败"); } } public function stageReturnList(){ $param =$this->request->only(["relaComNo"=>"","companyNo"=>"","supplierNo"=>"","start"=>"","end"=>"","returnCode"=>"","payNo"=>"", "status"=>"","dzNo"=>"","pay_type"=>"","is_comon"=>"","page"=>1,"size"=>15],"post","trim"); $condition=[["a.is_del","=",0],['a.returnType',"=",2],['pay_type','=',$param['pay_type']?:1]]; $check = checkRole($this->roleid,[131,129]); if($check){ $condition []=["a.apply_id","=",$this->uid]; } if($param['relaComNo']!="") $condition[]=["b.companyNo|b.supplierNo","=",$param['relaComNo']]; if($param['companyNo']!="") $condition[]=["b.companyNo","=",$param['companyNo']]; if($param['supplierNo']!="") $condition[]=["b.supplierNo","=",$param['supplierNo']]; if($param['start']!="") $condition[]=["a.addtime",">=",date("Y-m-d H:i:s",strtotime($param['start']))]; if($param['end']!="") $condition[]=["a.addtime","<=",date("Y-m-d 23:59:59",strtotime($param['end']))]; if($param['status']!="") $condition[]=["a.status","=",$param['status']]; if($param['dzNo']!="") $condition[]=["a.orderCode","like","%{$param['dzNo']}%"]; if($param['returnCode']!="") $condition[]=["a.returnCode","like","%{$param['returnCode']}%"]; if($param['payNo']!="") $condition[]=["a.payNo","like","%{$param['payNo']}%"]; if(isset($param['is_comon'])&&$param['is_comon']!=='') $condition []=['is_comon','=',$param['is_comon']]; $count = Db::name("pay_return") ->alias("a") ->leftJoin("pay b", "a.payNo=b.payNo and b.is_del=0") ->leftJoin("pay_payment c", "a.orderCode=c.dzNo") ->where($condition) ->count(); $total = ceil($count / $param['size']); $page = $param['page'] >= $total ? intval($total) : intval($param['page']); $list = Db::name("pay_return") ->alias("a") ->leftJoin("pay b", "a.payNo=b.payNo and b.is_del=0") ->leftJoin("pay_payment c", "a.orderCode=c.dzNo") ->where($condition) ->page($page, intval($param['size'])) ->order('id desc') ->field("a.*,b.supplierNo,b.is_comon,b.supplierName,b.companyNo,b.companyName,b.total_fee,b.apay_fee,b.wpay_fee,b.pay_fee,c.pay_fee pay_pay_fee") ->select() ->toArray(); //校验是否开通了供应商账号 $supp_account = check_has_account_by_supplierNos(array_unique(array_column($list, 'supplierNo'))); foreach ($list as &$value) { $value['has_account'] = (int)isset($supp_account['data'][$value['supplierNo']]); } return app_show(0,"获取成功",["list"=>$list,"count"=>$count]); } public function stageReturnStatus(){ $param =$this->request->only(["returnCode"=>"","status"=>"","remark"=>"","returnImg"=>""],"post","trim"); $valide=Validate::rule([ "returnCode|退票申请编号"=>"require|max:255", "status|状态"=>"require|number|in:1,2,3", ]); if($valide->check($param)==false)return error_show(1004,$valide->getError()); $returninfo =Db::name("pay_return")->where(["is_del"=>0,"returnCode"=>$param['returnCode']])->findOrEmpty(); if(empty($returninfo))return error_show(1004,"退票详情未找到"); Db::startTrans(); try{ if($param['status']==2){ $invinfo =Db::name("pay_payment")->where(["dzNo"=>$returninfo['orderCode'],"is_del"=>0])->findOrEmpty(); if(empty($invinfo))throw new Exception("付款详情未找到"); $pay =Db::name("pay")->where(["payNo"=>$returninfo['payNo'],"is_del"=>0])->findOrEmpty(); if(empty($pay))throw new Exception("对账详情未找到"); $invup =Db::name("pay_payment")->where($invinfo)->update(["status"=>5,"updatetime"=>date("Y-m-d H:i:s")]); if($invup==false)throw new Exception("付款更新失败"); if($pay['apay_fee']<$invinfo['pay_fee'])throw new Exception('已付款金额不足'); $paydata=[ "apay_fee"=>$pay['apay_fee']-$invinfo['pay_fee'], "wpay_fee"=>$pay['wpay_fee']+$invinfo['pay_fee'], "pay_status" => $pay['pay_fee']==0 &&($pay['apay_fee']-$invinfo['pay_fee'])==0?1:2, "updatetime" => date("Y-m-d H:i:s") ]; $oayup =Db::name("pay")->where($pay)->update($paydata); if($oayup==false)throw new Exception("对账更新失败"); } $update=[ "status"=>$param['status'], "remark"=>$param['remark'], "returnImg"=>$param['returnImg'], "updatetime"=>date("Y-m-d H:i:s") ]; $up =Db::name("pay_return")->where($returninfo)->update($update); if($up==false)throw new Exception("退款申请审核失败"); Db::commit(); if($param['status']==2 && $pay['is_comon']==1){ event('comonOrder', ['payNo' => $pay['payNo'], 'pay_fee' => $invinfo['pay_fee'], 'type' => 'repay']); } return app_show(0,"退款申请审核成功"); }catch (\Exception $e){ Db::rollback(); return error_show(1005,$e->getMessage()); } } public function stageReturnInfo(){ $param = $this->request->only(["returnCode"=>""],"post","trim"); $valide=Validate::rule([ "returnCode|退票申请编号"=>"require|max:255", ]); if($valide->check($param)==false)return error_show(1004,$valide->getError()); $info = Db::name("pay_return")->alias("a") ->leftJoin("pay b","a.payNo=b.payNo and b.is_del=0") ->leftJoin("pay_payment c","a.orderCode=c.dzNo") ->where(['returnCode'=>$param['returnCode']]) ->field("a.*,b.supplierNo,b.supplierName,b.companyNo,b.companyName,b.total_fee,b.apay_fee,b.wpay_fee,b.pay_fee,c.pay_fee pay_pay_fee") ->findOrEmpty(); return app_show(0,"退款申请获取成功",$info); } /**批量上传待认证发票 * @param hpNo array 回票申请编号集合 必传 * @param relaComNo string 业务公司编号 企业账户 * @param companyNo string 业务公司编号 超管账户 * @return \think\response\Json|void */ //回票申请批量认证 public function hpBatchImport() { $post = $this->request->only(["list" => [], "relaComNo" => "", "companyNo" => ""], "post"); $valid = Validate::rule([ "list|回票申请编号集合" => "require|array|max:100", "relaComNo|关联公司" => "requireWithout:companyNo|max:255", "companyNo|公司编号" => "requireWithout:relaComNo|max:255", ]); if ($valid->check($post) == false) return error_show(1004, $valid->getError()); $companyNo = $post["relaComNo"] ?: $post['companyNo']; $payArr = Db::name("pay_invoice") ->alias("a") ->leftJoin("pay b", "a.payNo=b.payNo") ->where(['a.is_del' => 0, 'b.is_del' => 0]) ->whereIn('a.hpNo', array_column($post['list'], 'hpNo')) ->column("a.id,a.payNo,a.hpNo,a.invoiceType,a.inv_fee as invoice_fee,a.status,b.inv_status,b.inv_fee,b.companyNo,b.ainv_fee,b.winv_fee,a.hpNo", "a.hpNo"); $val_hpNo = Validate::rule([ 'hpNo|回票申请编号' => 'require', 'status|审核状态' => 'require|number|in:4,7', 'remark|审核备注' => 'requireIf:status,7|max:255' ]); $unique=[]; foreach ($post['list'] as $item) { if (!$val_hpNo->check($item)) return error_show(1004, $val_hpNo->getError()); if(in_array($item['hpNo'],$unique))return error_show(1004, "{$item['hpNo']} 发票重复提交"); $unique[]=$item['hpNo']; } Db::startTrans(); try { $pay_invoice_allow = []; foreach ($post['list'] as $val) { if (!$val_hpNo->check($val)) throw new \Exception($val_hpNo->getError()); if (!isset($payArr[$val['hpNo']])) throw new \Exception("{$val['hpNo']}记录不存在"); $value = $payArr[$val['hpNo']]; $payinfo = Db::name("pay")->where(["payNo"=>$payArr[$val['hpNo']]['payNo'],"status"=>2,"is_del"=>0])->findOrEmpty(); if(empty($payinfo)) throw new Exception("{$value['hpNo']}对账信息有误"); if ($payinfo['companyNo'] == '') throw new Exception("{$value['hpNo']}对账信息有误"); if ($payinfo['companyNo'] != $companyNo) throw new Exception("{$value['hpNo']}不属于当前业务公司发票"); if ($value['status'] != '3') throw new Exception("{$value['hpNo']}状态有误"); if ($value['invoice_fee'] > $payinfo['inv_fee']) throw new Exception("{$value['hpNo']}对账单开票中金额不足"); if ($val['status'] == 4) { Pay::addAinv($payArr[$val['hpNo']]['payNo'],$value['invoice_fee']); $pay_invoice_allow[] = $value['id']; } else { Pay::subInv($payArr[$val['hpNo']]['payNo'],$value['invoice_fee']); Db::name("pay_invoice") ->where(["id" => $value['id'], "status" => 3, "is_del" => 0]) ->update(["status" => $val['status'], "updatetime" => date("Y-m-d H:i:s"), 'remark' =>$val['remark']]); } } if ($pay_invoice_allow) Db::name("pay_invoice")->where(["id" => $pay_invoice_allow, "status" => 3, "is_del" => 0])->update(["status" => 4, "updatetime" =>date("Y-m-d H:i:s")]); // if ($update == false) throw new Exception("回票申请状态更新失败"); Db::commit(); return app_show(0, "回票申请认证成功"); } catch (\Exception $e) { Db::rollback(); return error_show(1004, $e->getMessage()); } } /** * 导出对账单采购单信息 */ public function payCgdExport(){ $param = $this->request->only(["payNo"=>""],"post","trim"); $valide=Validate::rule([ "payNo|对账申请编号"=>"require|max:255", ]); if($valide->check($param)==false)return error_show(1004,$valide->getError()); $payinfo =Db::name("pay")->where(["payNo"=>$param['payNo'],"is_del"=>0,"pay_type"=>1])->findOrEmpty(); if(empty($payinfo)) return error_show(1005,'对账单信息未找到'); $cgdlist =Db::name("pay_info")->alias("a") ->leftJoin("cgd_info b","a.cgdNo=b.sequenceNo") ->leftJoin("order_category c","a.cgdNo=c.code and order_type=2") ->leftJoin("good d","c.spuCode =d.spuCode") ->where(["a.payNo"=>$param['payNo'],"a.status"=>1,"a.is_del"=>0]) ->field("a.payNo'对账单号',b.sequenceNo '采购单编号',b.qrdCode '销售单编号',b.supplierName '供货商',b.companyName '业务公司', b.goodUnit '单位',(b.goodNum-b.thNum) '商品数量',b.goodPrice'商品单价',b.totalPrice'总货款', if(b.cxCode='',b.qrdCode,b.cxCode) 销售主单号,b.goodNo 商品编码,b.goodName 商品名称,c.cat_name 货物和劳务名称,c.merge_code 商品开票类目,c.short_name 商品和服务分类简称, c.tax/100 开票税率,c.inv_good_name 开票商品名称,if(b.open_type =1,'原商品开票',if(b.open_type =2,'子商品开票','')) 开票类型") ->select()->toArray(); if(empty($cgdlist))$cgdlist=["暂无数据"=>'']; else{ array_walk($cgdlist, function (&$item) { $item['采购单可关联金额']= bcsub($item['总货款'],InvoiceOrder::getInvoiceOrderTotalFee($item['采购单编号']),2); }); } excelExport("{$param['payNo']}对账采购单详情",array_keys($cgdlist[0]),$cgdlist); } /** 导出对账单采购单信息 */ public function payTrackExport(){ $param = $this->request->only(['payNo'=>''],'post','trim'); $valide=Validate::rule([ 'payNo|对账申请编号'=>'require|max:255', ]); if($valide->check($param)==false)return error_show(1004,$valide->getError()); $payinfo =Db::name('pay')->where(['payNo'=>$param['payNo'],'is_del'=>0,'pay_type'=>2])->findOrEmpty(); if(empty($payinfo)) return error_show(1005,'对账单信息未找到'); $cgdlist =Pay::alias("e") ->leftJoin("pay_info a","a.payNo=e.payNo and a.status=1 and a.is_del=0") ->leftJoin("track b","a.cgdNo=b.TrackCode") ->leftJoin("fhd_child c","c.outChildCode=b.outChildCode") ->where(['e.payNo'=>$param['payNo']]) ->field("a.payNo 对账单号, e.total_fee 对账单总金额, e.status 对账单状态, e.apply_name 对账单创建人, e.addtime 对账单创建时间, b.TrackCode 发货运单号, b.outChildCode 发货工单号, c.outCode 发货单号, c.num 发货数量, b.orderCode 销售单号, b.cgdNo 采购单号, c.order_source 订单来源, c.order_type 商品类型, c.good_name 商品名称, b.supplierNo 物流供应商编号, b.supplierName 物流供应商名称, b.companyNo 业务公司编号, b.companyName 业务公司名称, b.post_fee 物流费, b.apply_name 运费单创建人, b.create_time 运费单创建时间") ->withAttr("对账单状态",function ($v){ return Pay::$status[$v]??""; }) ->withAttr('订单来源',function ($v){ return FhdChild::$order_source[$v]??''; }) ->withAttr('商品类型',function ($v){ return FhdChild::$order_type[$v]??''; }) ->select()->toArray(); // $this->success("",$cgdlist); if(empty($cgdlist))$cgdlist=['暂无数据'=>'']; excelExport("{$param['payNo']}对账运费单详情",array_keys($cgdlist[0]),$cgdlist); } // /**校验供应商下面是否有操作账户 // * @param $supplierNo 供应商账户 // * @return array // */ // private function checkSupplier($supplierNo){ // $companyinfo = UserHandle("/userCompanyBasicList", ["companyNo" =>$supplierNo]); // if ($companyinfo['code'] != 0) return ["code"=>$companyinfo['code'],"message"=> $companyinfo['message']]; // if (!empty($companyinfo['data']) && $companyinfo['data']['count'] > 0) { // return ["code"=>1004,"message"=> "供应商公司存在操作账户,请用供应商账户操作"]; // } // else{ // return ["code"=>0,"message"=> "业务账户可操作"]; // } // } }