ComonQrd.php 13 KB

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