StoreController.php 7.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164
  1. <?php
  2. namespace App\Http\Controllers\Api\thirdPart\flux;
  3. use App\Http\Controllers\Controller;
  4. use App\RejectedBillItem;
  5. use App\Store;
  6. use App\WMSReflectReceive;
  7. use App\WMSReflectReceiveSku;
  8. use Illuminate\Http\Request;
  9. use Illuminate\Support\Facades\Validator;
  10. use Zttp\Zttp;
  11. class StoreController extends Controller
  12. {
  13. /**
  14. * 入库回传给WMS
  15. * @param Store $store
  16. * @return bool
  17. */
  18. public function accomplishToWMS(Store $store)
  19. {
  20. $wmsReceiveds=WMSReflectReceive::where('ASNREFERENCE3',$store['asn_code'])
  21. ->where('is_uploaded',0)->get();
  22. if($wmsReceiveds->isEmpty()){
  23. (new Controller())->log(__METHOD__,'error_'.__FUNCTION__,'没有WMS入库单');
  24. return false;
  25. }
  26. $items=$store->items()->get();
  27. $amountsItem=(function()use($items){
  28. $result=[];
  29. $items->each(function($item)use(&$result){
  30. $result[$item['id']]= $item['amount'];
  31. });
  32. return $result;
  33. })();
  34. $success=true;
  35. $wmsReceiveds->each(function ($wmsReceived)use(&$store,&$amountsItem,$items,&$success){
  36. if(!$store && $store['is_loaded']!=0)return;
  37. $wmsSkus=$wmsReceived->skus()->get();
  38. $orderNumberCode=$wmsReceived['ASNREFERENCE1']??$store['order_number'];
  39. $amountsSku=(function()use($wmsSkus){
  40. $result=[];
  41. $wmsSkus->each(function($sku)use(&$result){
  42. $result[$sku['id']]= $sku['EXPECTEDQTY_EACH'];
  43. });
  44. return $result;
  45. })();
  46. $skuStrList=[];
  47. $customerCode=$store->owner()->first()['code'];
  48. $wmsSkus->each(function(WMSReflectReceiveSku $sku)use(&$items,&$skuList,&$amountsItem,&$amountsSku,&$skuStrList,$wmsReceived,$customerCode){
  49. $items->each(function(RejectedBillItem $item)use(&$sku,&$amountsItem,&$amountsSku,&$skuStrList,$wmsReceived,$customerCode){
  50. if($item['barcode_goods']!=$sku['ALTERNATE_SKU1'])return;
  51. if($amountsItem[$item['id']]==0||$amountsSku[$sku['id']]==0)return;
  52. $uploadingAmount=(function()use(&$item,&$sku,&$amountsItem,&$amountsSku){
  53. if($amountsItem[$item['id']]>$amountsSku[$sku['id']]){
  54. $amountsItem[$item['id']]-=$amountsSku[$sku['id']];
  55. $amount= $amountsSku[$sku['id']];
  56. $amountsSku[$sku['id']]=0;
  57. return $amount;
  58. }
  59. if($amountsItem[$item['id']]<$amountsSku[$sku['id']]){
  60. $amount=$amountsItem[$item['id']];
  61. $amountsSku[$sku['id']]-=$amount;
  62. $amountsItem[$item['id']]=0;
  63. return $amount;
  64. }
  65. $amount=$amountsItem[$item['id']];
  66. $amountsItem[$item['id']]=0;
  67. $amountsSku[$sku['id']]=0;
  68. return $amount;
  69. })();
  70. if($item['is_loaded']=='已入库'){return;}
  71. $STATUS=$item['id_quality_label']==1?'ZP':'CC';
  72. $STATUS_code=$item['id_quality_label']==1?'01':'02';
  73. $skuStr="
  74. {
  75. \"ORDERNUMBERCODE\": \"{$wmsReceived['ASNNO']}\",
  76. \"ASNLINENO\": \"{$sku['ASNLINENO']}\",
  77. \"SKUCODE\": \"{$sku['SKU']}\",
  78. \"QUANTITY\": \"{$uploadingAmount}\",
  79. \"LOTATT04\": \"{$sku['LOTATT04']}\",
  80. \"LOTATT05\": \"{$sku['LOTATT05']}\",
  81. \"STATUS\": \"{$STATUS}\",
  82. \"PRODUCTION DATE\": \"{$item['made_at']}\",
  83. \"EXPIRATION DATE\": \"{$item['validity_at']}\",
  84. \"USERDEFINE1\": \"{$customerCode}{$STATUS_code}\",
  85. \"USERDEFINE2\": \"\",
  86. \"USERDEFINE3\": \"\",
  87. \"UNIQUE_CODE_LIST\": [".
  88. // {
  89. // \"ORDERNUMBERCODE\": \"{$wmsReceived['ASNNO']}\",
  90. // \"SKUCODE\": \"{$sku['SKU']}\",
  91. // \"STATUS\": \"{$STATUS}\",
  92. // \"PRODUCTION DATE\": \"{$item['made_at']}\",
  93. // \"EXPIRATION DATE\": \"{$item['validity_at']}\",
  94. // \"LOTATT05\": \"{$sku['LOTATT05']}\",
  95. // \"UNIQUE_CODE\": \"\"
  96. // }
  97. "]
  98. }
  99. ";
  100. $skuStrList[]=$skuStr;
  101. });
  102. });
  103. if(count($skuStrList)==0)return;
  104. $skuStrList = implode(',',$skuStrList);
  105. $json="
  106. {
  107. \"request\": [
  108. {
  109. \"ORDERNUMBERCODE\": \"{$wmsReceived['ASNNO']}\",
  110. \"CUSTOMERID\": \"{$customerCode}\",
  111. \"ASNTYPE\": \"{$wmsReceived['ASNTYPE']}\",
  112. \"ASNREFERENCE1\": \"{$orderNumberCode}\",
  113. \"ADDWHO\": \"WCS\",
  114. \"USERDEFINE1\": \"\",
  115. \"USERDEFINE2\": \"\",
  116. \"USERDEFINE3\": \"\",
  117. \"SKU_LIST\": [{$skuStrList}]
  118. }
  119. ]
  120. }
  121. ";
  122. $sendingJson = json_decode($json,true);
  123. $url=url(config('api.flux.receive.new'));
  124. $response = Zttp::post($url, $sendingJson);
  125. $noIssues=true;
  126. $json = $response->json();
  127. (new Controller())->log(__METHOD__,__FUNCTION__,$response->body().'|'.json_encode($sendingJson));
  128. if(!$json||!isset($json['Response'])||!$json['Response']['return']['returnFlag']=='1'){
  129. $noIssues=false;
  130. }
  131. if($json&&isset($json['Response'])){
  132. if($json['Response']['return']['returnFlag']=='2'){
  133. return true;
  134. }
  135. if(isset($json['Response']['return']['returnDesc'])&&strpos($json['Response']['return']['returnDesc'],'唯一约束')!==false){
  136. (new Controller())->log(__METHOD__,'error_'.__FUNCTION__,$response->body().'|'.json_encode($sendingJson));
  137. return true;
  138. }
  139. if(isset($json['Response']['return']['errordescr'])&&strpos($json['Response']['return']['errordescr'],'已完成')!==false){
  140. (new Controller())->log(__METHOD__,'error_'.__FUNCTION__,$response->body().'|'.json_encode($sendingJson));
  141. return true;
  142. }
  143. }
  144. if($noIssues&&$json['Response']['return']['returnFlag']=='1'){
  145. $wmsReceived['is_uploaded']=1;
  146. $wmsReceived->save();
  147. return true;
  148. }else{
  149. $success=false;
  150. (new Controller())->log(__METHOD__,'error_'.__FUNCTION__,$response->body().'|'.json_encode($sendingJson));
  151. }
  152. });
  153. return $success;
  154. }
  155. }