ComonQrd.php 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282
  1. <?php
  2. declare (strict_types = 1);
  3. namespace app\admin\listener;
  4. use app\admin\model\Assoc;use app\admin\model\InvoiceInfo;use app\admin\model\InvoicePay;use app\admin\model\InvoicePool;use app\admin\model\InvoiceTicket;use app\admin\model\Pay;use app\admin\model\PayInfo;use app\admin\model\PayInvoice;use app\admin\model\QrdInfo;
  5. class ComonQrd
  6. {
  7. protected function checkPay($data){
  8. $payinfo = Pay::where('payNo',$data['payNo'])->findOrEmpty();
  9. if($payinfo->isEmpty()) return;
  10. if($payinfo->is_comon!=1)return;
  11. $this->CheckComonOrder($payinfo);
  12. }
  13. public function CheckComonOrder($payinfo){
  14. if($payinfo->status==3||$payinfo->status==4 ){
  15. PayInfo::alias('a')
  16. ->leftJoin('ComonOrder b','a.cgdNo=b.cgdNo')
  17. ->where(['payNo'=>$payinfo->payNo,'is_del'=>0,'a.status'=>0])
  18. ->update(['b.status'=>0]);
  19. }else{
  20. if($payinfo->inv_status==3 &&$payinfo->pay_status==3){
  21. PayInfo::alias('a')
  22. ->leftJoin('ComonOrder b','a.cgdNo=b.cgdNo')
  23. ->where(['payNo'=>$payinfo->payNo,'is_del'=>0,'a.status'=>1])
  24. ->update(["b.status"=>2]);
  25. }elseif($payinfo->inv_status!=3|| $payinfo->pay_status!=3){
  26. PayInfo::alias('a')
  27. ->leftJoin('ComonOrder b','a.cgdNo=b.cgdNo')
  28. ->where(['payNo'=>$payinfo->payNo,'is_del'=>0,'a.status'=>1])
  29. ->update(['b.status'=>1]);
  30. }
  31. }
  32. }
  33. /**
  34. * 事件监听处理
  35. * @return mixed
  36. */
  37. public function handle($event)
  38. {
  39. // if($event['type']=="pay")$this->payComon($event);
  40. if($event['type']=="inv")$this->InvToPay($event);
  41. if($event['type']=="rinv")$this->InvToPay($event,false);
  42. // if($event['type']=="check")$this->checkPay($event);
  43. }
  44. public function InvToPay($data,$bool=True){
  45. $invinfo =InvoicePool::where(['invNo'=>$data['invNo']])->findOrEmpty();
  46. if($invinfo->isEmpty())return;
  47. if($bool){
  48. if($invinfo->status!=4 ||$invinfo->is_comon!=1 )return;
  49. $assoc_status=2;
  50. }else{
  51. $assoc_status=3;
  52. if(in_array($invinfo->status,[5,6,7,8,9])||$invinfo->is_comon!=1 )return;
  53. }
  54. $assoc = Assoc::where(["viceCode"=>$data['invNo'],"status"=>$assoc_status,"is_del"=>0,"type"=>1])->select();
  55. if($assoc->isEmpty()) return;
  56. $orderArr = QrdInfo::whereIn("sequenceNo",array_column($assoc->toArray(),"orderCode"))->select();
  57. if($orderArr->isEmpty())return;
  58. $payArr=array_column($assoc->toArray(),"cancel_fee","orderCode");
  59. $tag=[];
  60. $qrdSave=[];
  61. foreach ($orderArr as $item){
  62. if(!isset($payArr[$item->sequenceNo]))continue;
  63. $tag_temp=[
  64. 'code'=>$item->sequenceNo,
  65. 'tag_id'=>11,
  66. 'creater'=>'system',
  67. 'createrid'=>0,
  68. 'tag_fee'=>0,
  69. 'tag_img'=>'',
  70. "tag_code"=>$data['invNo'],
  71. 'status'=>$bool?1:0
  72. ];
  73. $qrd=[
  74. 'id'=>$item->id,
  75. 'wpay_fee'=>$item->wpay_fee,
  76. // 'apay_fee'=>$item->apay_fee,
  77. 'pay_status'=>$item->pay_status,
  78. 'pay_tag_fee'=>$item->pay_tag_fee,
  79. 'pay_tag' => 1
  80. ];
  81. if($bool){
  82. if($item->wpay_fee>$payArr[$item->sequenceNo]){
  83. $tag_temp['tag_fee']= $payArr[$item->sequenceNo];
  84. $qrd['pay_tag_fee'] =$item->pay_tag_fee+$payArr[$item->sequenceNo];
  85. $qrd['wpay_fee'] = $item->wpay_fee-$payArr[$item->sequenceNo];
  86. $qrd['pay_status'] = ($qrd['wpay_fee']==0 &&$item->pay_fee==0) ? 3:($qrd['apay_fee']==0?1:2);
  87. }else{
  88. $tag_temp['tag_fee'] =$item->wpay_fee;
  89. $qrd['pay_tag_fee'] =$item->pay_tag_fee+ $item->wpay_fee;
  90. $qrd['wpay_fee'] = 0;
  91. $qrd['pay_status'] = ($qrd['wpay_fee']==0 &&$item->pay_fee==0) ? 3:($qrd['apay_fee']==0?1:2);
  92. }
  93. }else{
  94. $tag_temp['tag_fee']= $payArr[$item->sequenceNo];
  95. $tag_fee = ($item->pay_tag_fee>$payArr[$item->sequenceNo])?$payArr[$item->sequenceNo]:$item->pay_tag_fee;
  96. $qrd['pay_tag_fee']=$item->pay_tag_fee-$tag_fee;
  97. $qrd['wpay_fee'] = $item->wpay_fee+$tag_fee;
  98. $qrd['pay_status'] = ($qrd['wpay_fee']==0 &&$item->pay_fee==0) ? 3:($qrd['apay_fee']==0?2:1);
  99. }
  100. $qrdSave[]=$qrd;
  101. $tag[]=$tag_temp;
  102. };
  103. (new \app\admin\model\QrdInfo)->saveAll($qrdSave);
  104. (new \app\admin\model\TagLog)->saveAll($tag);
  105. }
  106. protected function invComon($data){
  107. $invinfo =InvoicePool::where(['invNo'=>$data['invNo']])->findOrEmpty();
  108. if($invinfo->isEmpty())return;
  109. if($invinfo->status!=4 ||$invinfo->is_comon!=1 )return;
  110. $invpay =InvoicePay::where(['invNo'=>$data['invNo']])->findOrEmpty();
  111. if($invpay->isEmpty())return;
  112. if($invpay->status!=0 )return;
  113. $payinfo = Pay::where('payNo',$invpay['payNo'])->findOrEmpty();
  114. if($payinfo->isEmpty()) return;
  115. if($payinfo->is_comon!=1)return;
  116. if(!in_array($payinfo->status,[1,2]))return;
  117. $ticket =InvoiceTicket::where(["invNo"=>$data['invNo'],"type"=>0])->json(['item'])->findOrEmpty();
  118. if($ticket->isEmpty())return;
  119. $pay_fee=0;
  120. if($payinfo->winv_fee >=$invinfo->inv_value){
  121. $pay_fee = $invinfo->inv_value;
  122. }else{
  123. $pay_fee = $payinfo->winv_fee;
  124. }
  125. $payinvoice = [
  126. "payNo"=>$invpay['payNo'],
  127. "hpNo"=>makeNo("hp"),
  128. "apply_id"=>0,
  129. "apply_name"=>"system",
  130. "invType"=>$invinfo->open_type==3?1:3,
  131. "invoiceType"=>$invinfo->inv_type,
  132. "inv_fee"=>$pay_fee,
  133. "inv_subtotal_amount"=>$ticket->inv_subtotal,
  134. "inv_amount"=>$ticket->inv_total,
  135. "invStatus"=>1,
  136. "status"=>4,
  137. "check_time"=>date("Y-m-d H:i:s"),
  138. "open_time"=>$ticket->open_date,
  139. "invoiceNumber"=>$ticket->inv_number,
  140. "seller_check"=>1,
  141. "buyer_check"=>1,
  142. "invoiceCode"=>$ticket->inv_code,
  143. "checkNumber"=>$ticket->check_code,
  144. "checkApi"=>$data['checkApi']??0
  145. ];
  146. $payinfo->winv_fee = $payinfo->winv_fee-$pay_fee;
  147. $payinfo->ainv_fee = $payinfo->ainv_fee+$pay_fee;
  148. $payinfo->inv_status = ($payinfo->winv_fee==0 &&$payinfo->inv_fee==0)?3:($payinfo->ainv_fee==0?1:2);
  149. $this->CheckComonOrder($payinfo);
  150. $payinfo->save();
  151. PayInvoice::create($payinvoice);
  152. if(!empty($ticket->item)){
  153. $itemArr=[];
  154. foreach ($ticket->item as $item){
  155. $temp=[];
  156. $temp['name']=$item['XMMC'];
  157. $temp['unit']=$item['DW'];
  158. $temp['quantity']=$item['SPSL'];
  159. $temp['unit_price']=$item['DJ'];
  160. $temp['amount']=$item['JE'];
  161. $temp['tax']=$item['SE'];
  162. $temp['tax_rate']=strval($item['SL']*100)."%";
  163. $itemArr[]=$temp;
  164. }
  165. }
  166. $info=[
  167. 'payNo' =>$invpay['payNo'] ,
  168. 'hpNo' =>$payinvoice['hpNo'] ,
  169. 'type' =>$invinfo['inv_type'] ,
  170. 'number' =>$ticket->inv_number ,
  171. 'code' =>$ticket->inv_code ,
  172. 'check_code' =>$ticket->check_code ,
  173. 'issue_date' =>date('Ymd' ,strtotime($ticket->open_date)) ,
  174. 'buyer_name' =>$ticket->buyer_title ,
  175. 'buyer_id' =>$ticket->buyer_id ,
  176. 'buyer_address' =>$ticket->buyer_addr . $ticket->buyer_mobile ,
  177. 'buyer_bank' =>$ticket->buyer_bank . $ticket->buyer_bankNo ,
  178. 'seller_name' =>$ticket->seller_title ,
  179. 'seller_id' =>$ticket->seller_id ,
  180. 'seller_address' =>$ticket->seller_addr . $ticket->seller_mobile ,
  181. 'seller_bank' =>$ticket->seller_bank . $ticket->seller_bankNo ,
  182. 'subtotal_amount'=>$ticket->inv_subtotal ,
  183. 'subtotal_tax' =>$ticket->tax_fee ,
  184. 'total' =>$ticket->inv_total ,
  185. 'item_list' =>json_encode($itemArr,JSON_UNESCAPED_UNICODE) ,
  186. 'receiver' =>$ticket->reciver ,
  187. 'issuer' =>$ticket->issuer ,
  188. 'reviewer' =>$ticket->reviewer ,
  189. 'change_field' =>'' ,
  190. ];
  191. InvoiceInfo::create($info);
  192. $invpay->hpNo = $payinvoice['hpNo'];
  193. $invpay->status =1;
  194. $invpay->save();
  195. }
  196. public function payComon($data){
  197. $payinfo = Pay::where("payNo",$data['payNo'])->findOrEmpty();
  198. if($payinfo->isEmpty()) return;
  199. if($payinfo->is_comon!=1)return;
  200. if(!in_array($payinfo->status,[1,2]))return;
  201. $qrdNo = PayInfo::alias("a")->leftJoin("ComonOrder b","a.cgdNo=b.cgdNo")->where(["payNo"=>$data['payNo'],"is_del"=>0,"a.status"=>1])->column("orderCode");
  202. $qrdinfo = QrdInfo::where([["sequenceNo","in",$qrdNo],["wpay_fee",">",0]])->select();
  203. if($qrdinfo->isEmpty())return;
  204. $this->CheckComonOrder($payinfo);
  205. $tag=[];
  206. $qrdSave=[];
  207. foreach ($qrdinfo as $item){
  208. $tag_temp=[
  209. "code"=>$item->sequenceNo,
  210. "tag_id"=>10,
  211. "creater"=>"system",
  212. "createrid"=>0,
  213. "tag_fee"=>0,
  214. "tag_img"=>"",
  215. "status"=>1
  216. ];
  217. $qrd=[
  218. "id"=>$item->id,
  219. "wpay_fee"=>$item->wpay_fee,
  220. "apay_fee"=>$item->apay_fee,
  221. "pay_status"=>$item->pay_status,
  222. "pay_tag_fee"=>0,
  223. "pay_tag" => 1
  224. ];
  225. if($item->wpay_fee>$data['pay_fee']){
  226. $tag_temp['tag_fee'] = $data['pay_fee'];
  227. $qrd['pay_tag_fee'] = $data['pay_fee'];
  228. $qrd['wpay_fee'] = $item->wpay_fee-$data['pay_fee'];
  229. $qrd['apay_fee'] = $item->apay_fee+$data['pay_fee'];
  230. $qrd['pay_status'] = ($qrd['wpay_fee']==0 &&$item->pay_fee==0) ? 3:($qrd['apay_fee']==0?1:2);
  231. $data['pay_fee']=0;
  232. }else{
  233. $data['pay_fee']=$data['pay_fee']-$item->wpay_fee;
  234. $tag_temp['tag_fee'] =$item->wpay_fee;
  235. $qrd['pay_tag_fee'] = $item->wpay_fee;
  236. $qrd['wpay_fee'] = 0;
  237. $qrd['apay_fee'] = $item->apay_fee+$item->wpay_fee;
  238. $qrd['pay_status'] = ($qrd['wpay_fee']==0 &&$item->pay_fee==0) ? 3:($qrd['apay_fee']==0?1:2);
  239. }
  240. $qrdSave[]=$qrd;
  241. $tag[]=$tag_temp;
  242. if($data['pay_fee']==0) break;
  243. }
  244. (new \app\admin\model\QrdInfo)->saveAll($qrdSave);
  245. (new \app\admin\model\TagLog)->saveAll($tag);
  246. }
  247. //新开票完成 创建对应的标签;
  248. public function returnInv($data){
  249. $invinfo =InvoicePool::where(['invNo'=>$data['invNo'],"status"=>[5,6,7,8,9]])->findOrEmpty();
  250. if($invinfo->isEmpty())return;
  251. if($invinfo->is_comon!=1 )return;
  252. $invpay =InvoicePay::where(['invNo'=>$data['invNo']])->findOrEmpty();
  253. if($invpay->isEmpty())return;
  254. if($invpay->status!=1 )return;
  255. $payinfo = Pay::where('payNo',$invpay['payNo'])->findOrEmpty();
  256. if($payinfo->isEmpty()) return;
  257. if($payinfo->is_comon!=1)return;
  258. $payinvoice = PayInvoice::where(["hpNo"=>$invpay->hpNo,"status"=>4])->findOrEmpty();
  259. if($payinvoice->isEmpty())return;
  260. $payinvoice->status=10;
  261. $payinvoice->save();
  262. $payinfo->winv_fee = $payinfo->winv_fee+$payinvoice->inv_fee;
  263. $payinfo->ainv_fee = $payinfo->ainv_fee-$payinvoice->inv_fee;
  264. $payinfo->inv_status = ($payinfo->winv_fee==0 &&$payinfo->inv_fee==0)?3:($payinfo->ainv_fee==0?2:1);
  265. $this->CheckComonOrder($payinfo);
  266. $payinfo->save();
  267. $invpay->status =2;
  268. $invpay->save();
  269. }
  270. }