cxinv/app/admin/controller/Payment.php

<?php
declare (strict_types = 1);

namespace app\admin\controller;

use app\admin\BaseController;
use app\admin\model\ReportCode;
use think\App;use think\Exception;
use think\facade\Config;
use think\facade\Db;
use think\facade\Validate;

class Payment extends BaseController
{
    protected $invoiceType;

    protected $invName;
//
//    发票状态，取值范围：
//
//    正常：valid
//    已作废：invalidated
//    已红冲：reversed
    protected $invStatus=[0=>"待验证","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 ";
         $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['startTime']))
         :"";
        $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.=" and `b`.`addtime` >= '{$startTime}'";
        }
        if($endTime!=""){
            $condition.=" and `b`.`addtime` <= '{$endTime}'";
        }

        if($supplierNo!=""){
            $condition.=" and `a`.`supplierNo` = '$supplierNo'";
        }
         if($supplierName!=""){
            $condition.=" and `a`.`supplierName` like '%$supplierName%'";
        }
        if($companyNo!=""){
            $condition.=" and (`a`.`companyNo` = '$companyNo')";
        }
        $relaComNo= isset($post['relaComNo'])&&$post['relaComNo']!="" ? trim($post['relaComNo']) :"";
         if($relaComNo!=""){
            $condition.=" and (`a`.`companyNo` = '$relaComNo' or `a`.`supplierNo` = '$relaComNo')";
        }

        if($payNo!=""){
            $condition.=" and `a`.`payNo` like '%{$payNo}%'";
        }
         if($dzNo!=""){
            $condition.=" and `b`.`dzNo` like '%{$dzNo}%'";
        }
        if($apply!=""){
            $condition .=" and b.apply_name like '%{$apply}%'";
        }
        if($paystatus!=""){
            $condition .=" and `b`.`status` = {$paystatus}";
        }
        $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`.`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();
       $data=[];
        foreach ($list as $key=>$value){
            $value['ordeNum'] = Db::name("pay_info")->where([["payNo","=",$value["payNo"]],["is_del","=",0]])->count();
            $data[]=$value;
        }
        return app_show(0,"获取成功",["list"=>$data,"count"=>$count]);
    }
    /**
     *对账单列表
     * @return \think\Response
     */
    public function payList()
    {
        $post = $this->post;
        $condition = [["is_del","=",0]];
//        $check = checkRole($this->roleid,49);
//        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['startTime']))
         :"";
        $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($paystatus!=""){
//             $condition[]=["pay_status","=",$paystatus];
//        }
//        if($inv_status!=""){
//            $condition[]=["inv_status","=",$inv_status];
//        }
        if($status!=""){
            $condition[]=["status","=",$status];
        }
        $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();
       $data=[];
        foreach ($list as $key=>$value){
            $value['ordeNum'] = Db::name("pay_info")->where([["payNo","=",$value["payNo"]],["is_del","=",0]])->count();
            $tag =Db::name("tag_log")->alias("a")->leftJoin("order_tag b","a.tag_id=b.id")->where
            (["code"=>$value['payNo'],"a.status"=>1])->column("b.tag_name,a.tag_img,a.tag_remark","b.type");
            $value['inv_tag_name']=$tag[2]['tag_name']??'';
            $value['pay_tag_name']=$tag[1]['tag_name']??'';
            $value['pay_tag_img']=$tag[1]['tag_img']??'';
            $value['inv_tag_img']=$tag[2]['tag_img']??'';
            $value['inv_tag_remark']=$tag[2]['tag_remark']??'';
            $value['pay_tag_remark']=$tag[1]['tag_remark']??'';
            $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");
        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,"采购单数据业务公司不一致");
        }

       $payNo = makeNo("PAY");
        Db::startTrans();
        try {
            $data=[];
            $paydata=[
                "payNo"=>$payNo,
                "apply_id"=>$this->uid,
                "apply_name"=>$this->uname,
                "total_fee"=>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){
               $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'];
                $report=ReportCode::where(["cgdNo"=>$value['sequenceNo']])->find();
                if($report)$report->setField("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,"采购单数据供应商不一致");
        }
        $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],"payNo"=>$payNo,"is_del"=>0])->findOrEmpty();
       	    if(!empty($hpinv)) return error_show(1004,"对账单存在未解除的回票申请单");
       }
        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){
                     $cgdup =Db::name("cgd_info")->where(["sequenceNo"=>$cgdNo,"status"=>1])->update(['status'=>0,"updatetime"=>date("Y-m-d H:i:s")]);
                       if($cgdup==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();
               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,"对账单已审核通过");
       }
       $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])){
               	 $cgdup =Db::name("cgd_info")->where(["sequenceNo"=>$cgdNo,"status"=>1])->update(['status'=>0,"updatetime"=>date("Y-m-d H:i:s")]);
	               if($cgdup==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();
            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{
            $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])){
                    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($status==5){//审核驳回 扣减对账付款中的金额 返回到待付金额中
                    $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();
                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],['is_del',"=",0]];

//        $check = checkRole($this->roleid,46);
//        if($check){
//            $condition []=["ownerid","=",$this->uid];
//        }
        $sequenceNo = isset($post['sequenceNo']) && $post['sequenceNo']!='' ? trim($post['sequenceNo']) :"";
        if($sequenceNo!=""){
          $condition []=["sequenceNo","like","%$sequenceNo%"];
        }

         $orderCode = isset($post['qrdCode']) && $post['qrdCode']!='' ? trim($post['qrdCode']) :"";
        if($orderCode!=""){
          $condition []=["qrdCode","like","%$orderCode%"];
        }
        $status = isset($post['status']) && $post['status']!=='' ? intval($post['status']) :"";
        if($status!==""){
           if($status!==''){
            if($status==3){
                $condition[]=["status","<>",2];
            }else{
                 $condition[]=["status","=",$status];
            }

        }
        }
        $companyNo = isset($post['companyNo']) && $post['companyNo']!='' ? trim($post['companyNo']) :"";
        if($companyNo!=""){
          $condition []=["companyNo","=",$companyNo];
        }
         $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];
        }
		  $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 []=["sendStatus","=",$sendstatus];

        $page =  isset($post['page'])&&$post['page']!="" ? intval($post['page']) :0;
        $size =  isset($post['size'])&&$post['size']!="" ? intval($post['size']) :10;
        $count =  Db::name("cgd_info")->where($condition)->count();
        $total = ceil($count/$size);
        $page = $page>=$total?intval($total):$page;
        $list =  Db::name("cgd_info")->where($condition)->page($page,$size)->order('createdTime desc')->select()->toArray();
        foreach ($list as &$value){
        	$value['goodNum'] =$value['goodNum']- $value['thNum'];
        	$value['sendNum'] =$value['sendNum']- $value['thNum'];
        }
        return app_show(0,"获取成功",["list"=>$list,"count"=>$count]);
    }
    //采购单信息
    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["cgd_pay_status"]=$payinfo['pay_status']??1;
        $cgdinfo["cgd_inv_status"]=$payinfo['inv_status']??1;
        $cgdinfo["cgd_status"]=$payinfo['status']??0;
        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,"对账单数据未找到");
        }
           $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['catInfo'] = json_decode($value['catInfo'],true);
        }
        $tag =Db::name("tag_log")->alias("a")->leftJoin("order_tag b","a.tag_id=b.id")->where
            (["code"=>$payNo,"a.status"=>1])->column("b.tag_name,a.tag_img,a.tag_remark","b.type");
            $payinfo['inv_tag_name']=$tag[2]['tag_name']??'';
            $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['inv_tag_img']=$tag[2]['tag_img']??'';
            $payinfo['inv_tag_remark']=$tag[2]['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($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'], 'post', 'trim');

            $validate = Validate::rule([
                'list' => 'require|array|max:100',
                'companyNo|卖出方公司编号' => 'require|max:255|checkCompanyNo:',
            ]);
            $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|发票代码' => 'require|max:255',
                '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;
            });

            //所有的payNo(对账编码)
            $payNo = array_column($param['list'], 'payNo');

            $payinfo = Db::name('pay')
                ->where('is_del', 0)
                ->whereIn('payNo', $payNo)
                ->column('id,payNo,status', 'payNo');

            //$da_insert 批量新增的数据，$payNo_hpNo对账编码=>回票编码
            $da_insert = $payNo_hpNo = [];
            $date = date('Y-m-d H:i:s');
            foreach ($param['list'] as $item) {

                if (!$val->check($item)) throw new Exception($val->getError());

                if (!isset($payinfo[$item['payNo']])) throw new Exception('对账单数据未找到');
                if ($payinfo[$item['payNo']]['status'] != 2) throw new Exception('对账单数据未完成审核');
				$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;
            }

            $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());
        }
    }

    /**
	 * 发票审核状态
	 * 0 发票图片识别中 1待系统验证 2 买方公司审核3带买方公司认证 4 认证成功 5验证失败 6买方审核驳回 7 认证失败 8 回票流程终止 9 验证超次数 10 回票已退
     * @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(){
        $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 {

            if(in_array($payment['invoiceType'],['normal','electronic','toll','roll']) && $status==3){
                $status=4; //普票无需认证
            }
            $invup =["status"=>$status,"remark"=>$remark,"updatetime"=>date("Y-m-d H:i:s")];
            if($status==3) $invup['check_time']=date("Y-m-d H:i:s");
            $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,"回票申请更新成功");
            }
                     Db::rollback();
                    return error_show(1003,"回票申请状态更新失败");
        }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 ],["b.is_del","=",0 ]];
        $invtype = isset($post['invType'])&&$post['invType']!='' ? intval($post['invType']):"";
        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%"];
        }
        $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('a.id');
        $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.companyNo")
            ->where($condition)
            ->page($page, $size)
            ->order("addtime desc")
            ->select()
            ->toArray();

        foreach ($list as &$value){
            $invoinfo =Db::name("invoice_info")->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'] = isset($invoinfo['item_list']) &&$invoinfo['item_list']!='' ?json_decode($invoinfo['item_list'],true):"";
        }
        //结算invlist这个接口当用payNo筛选的时候，返回列表里需要加一项统计筛选后列表的inv_subtotal_amount、total字段的和
        $inv_subtotal_amount = $total = 0;
        if ($payNo != '') {
            $inv_subtotal_amount = round(Db::name("pay_invoice")
                ->alias("a")
                ->leftJoin("pay b", "a.payNo=b.payNo")
                ->where($condition)
                ->sum('a.inv_subtotal_amount'), 2);

            $sub_sql = Db::name("pay_invoice")
                ->alias("a")
                ->field('hpNo')
                ->leftJoin("pay b", "a.payNo=b.payNo")
                ->where($condition)
                ->buildSql();

            $total = round(Db::name("invoice_info")
                ->where(["status" => 1])
                ->where('hpNo in ' . $sub_sql)
                ->sum('total'), 2);
        }

        return app_show(0, "获取成功", [
            "count" => $count,
            "list" => $list,
            'inv_subtotal_amount' => $inv_subtotal_amount,
            'total' => $total
        ]);
    }

        /**发票删除
        * @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($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=["is_del"=>1,"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($payinv['status']==3){
                    if($payinfo['inv_fee']< $payinv['inv_fee']){
                        Db::rollback();
                        return error_show(1005,"对账回票申请金额有误，请确认回票申请金额");
                    }
                     $payupdate =[
                            "inv_fee"=>$payinfo['inv_fee']-$payinv['inv_fee'],
                            "winv_fee"=>$payinfo['winv_fee']+$payinv['inv_fee'],
                             "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,"删除成功");
            }
        }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 =Db::name("invoice_info")->where(["hpNo"=>$hpNo])->findOrEmpty();
        if(!empty($invinfo)){
            $invinfo['item_list'] =json_decode($invinfo['item_list'],true);
        }
         $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\
 * 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 =Db::name("invoice_info")->where($condition)->findOrEmpty();
			if(!empty($info)){
			$info['item_list']=json_decode($info['item_list'],true);
		}
		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=Db::name("invoice_info")->where($where)->count();
    	 $total =ceil($count/$post['size']);
    	 $page= $post['page']>$total ? intval($total):intval($post['page']);
    	 $list = Db::name("invoice_info")
    	 ->where($where)
    	 ->json(["item_list"])
    	 ->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,"回票信息未找到");
		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"=>"","payNo"=>"","page"=>1,"size"=>15],"post","trim");
		$condition=[["a.is_del","=",0],['a.returnType',"=",1]];
		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['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']}%"];

		$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.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();
		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{
			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("回票更新失败");

			$paydata=[
				 "ainv_fee"=>$pay['ainv_fee']-$invinfo['inv_fee'],
                  "winv_fee"=>$pay['winv_fee']+$invinfo['inv_fee'],
                  "inv_status" => $pay['inv_fee']==0 &&($pay['ainv_fee']-$invinfo['inv_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();
		return app_show(0,"退票申请审核成功");
		}catch (\Exception $e){
			Db::rollback();
			return error_show(1005,$e->getMessage());
		}

    }

     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,"付款信息未找到");
		if($hpinfo['status']!=3)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"=>"","page"=>1,"size"=>15],"post","trim");
		$condition=[["a.is_del","=",0],['a.returnType',"=",2]];
		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']}%"];

		$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.supplierName,b.companyNo,b.companyName,b.total_fee,b.apay_fee,b.wpay_fee,b.pay_fee,c.pay_fee pay_pay_fee")
		->select();
		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("付款更新失败");

			$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();
		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());
//		if(empty($post['hpNo'])) return error_show(1004,'回票申请编号集合不能为空');
        $companyNo = $post["relaComNo"] ?? $post['companyNo'];
//		if($companyNo =="") return error_show(1004,'业务公司编号不能为空');
        $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'
        ]);

        foreach ($post['list'] as $item) {
            if (!$val_hpNo->check($item)) throw new \Exception($val_hpNo->getError());
        }
//        if (empty($payArr)) return error_show(1004, '回票申请数据未找到');
        Db::startTrans();
        try {
            $pay_invoice_allow = [];

            $hpNo_item = array_column($post['list'], null, 'hpNo');

            $date = date('Y-m-d H:i:s');

            foreach ($post['list'] as $val) {

                if (!$val_hpNo->check($item)) throw new \Exception($val_hpNo->getError());
                if (!isset($payArr[$val['hpNo']])) throw new \Exception("{$val['hpNo']}记录不存在");

                $value = $payArr[$val['hpNo']];

                if ($value['companyNo'] == '') throw new Exception("{$value['hpNo']}对账信息有误");
                if ($value['companyNo'] != $companyNo) throw new Exception("{$value['hpNo']}不属于当前业务公司发票");
                if ($value['status'] != '3') throw new Exception("{$value['hpNo']}状态有误");
                if ($value['invoice_fee'] > $value['inv_fee']) throw new Exception("{$value['hpNo']}对账单开票中金额不足");

                if ($hpNo_item[$value['hpNo']]['status'] == 4) {
                    //审核通过
                    $payupdate = [
                        "ainv_fee" => $value['ainv_fee'] + $value['invoice_fee'],
                        "inv_fee" => $value['inv_fee'] - $value['invoice_fee'],
                        "inv_status" => ($value['inv_fee'] - $value['invoice_fee']) == 0 && $value['winv_fee'] == 0 ? 3 : 2,
                        "updatetime" => date("Y-m-d H:i:s")
                    ];

                    $pay_invoice_allow[] = $value['id'];

                } else {
                    //审核不通过
                    $payupdate = [
                        "winv_fee" => $value['winv_fee'] + $value['invoice_fee'],
                        "inv_fee" => $value['inv_fee'] - $value['invoice_fee'],
                        "inv_status" => ($value['inv_fee'] - $value['invoice_fee']) == 0 && $value['ainv_fee'] == 0 ? 1 : 2,
                        "updatetime" => $date
                    ];
//                        $pay_invoice_not_allow[]=$value['id'];
                    Db::name("pay_invoice")
                        ->where(["id" => $value['id'], "status" => 3, "is_del" => 0])
                        ->update(["status" => $hpNo_item[$value['hpNo']]['status'], "updatetime" => $date, 'remark' => $hpNo_item[$value['hpNo']]['remark']]);
                }
                $where = ['payNo' => $value['payNo'], "inv_status" => $value['inv_status'], "companyNo" => $companyNo, "status" => 2, "is_del" => 0];
                $pay = Db::name("pay")->where($where)->update($payupdate);
                if ($pay == false) throw new Exception("{$value['hpNo']}回票申请对账单状态更新失败");
//                    $invIdArr[] = $value['id'];
            }
//            }

            if ($pay_invoice_allow) Db::name("pay_invoice")->where(["id" => $pay_invoice_allow, "status" => 3, "is_del" => 0])->update(["status" => 4, "updatetime" => $date]);

//            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])->findOrEmpty();
		if(empty($payinfo)) return error_show(1005,'对账单信息未找到');
		$cgdlist =Db::name("pay_info")->alias("a")
		->leftJoin("cgd_info b","a.cgdNo=b.sequenceNo")
		->where(["a.payNo"=>$param['payNo'],"a.status"=>1,"a.is_del"=>0])
		->field("a.payNo'对账单号',b.sequenceNo '采购单编号',b.qrdCode '销售单编号',b.supplierName '供货商',b.companyName '业务公司',
		b.goodName '商品名称',b.goodUnit '单位',b.goodNum '商品数量',b.goodPrice'商品单价',b.totalPrice'总货款',b.tax '税率'")
		->select()
		->toArray();
		if(empty($cgdlist))$cgdlist=["暂无数据"=>''];

		excelExport("{$param['payNo']}对账采购单详情",array_keys($cgdlist[0]),$cgdlist);
	}

}