ReceiveController.php 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260
  1. <?php
  2. namespace App\Http\Controllers\Api\thirdPart\flux;
  3. use App\Batch;
  4. use App\Events\WmsReceiveNewEvent;
  5. use App\Http\Controllers\Controller;
  6. use App\Order;
  7. use App\OrderBarcode;
  8. use App\RejectedBill;
  9. use App\RejectedBillItem;
  10. use App\SkuNew;
  11. use App\WMSReflectReceive;
  12. use App\WMSReflectReceiveSku;
  13. use Illuminate\Http\Request;
  14. use Illuminate\Support\Facades\Auth;
  15. use Illuminate\Support\Facades\Validator;
  16. use Zttp\Zttp;
  17. class ReceiveController extends Controller
  18. {
  19. /**
  20. * 收货任务下发
  21. */
  22. public function new_(Request $request)
  23. {
  24. $errors=$this->validatorForNew($request->all())->errors();
  25. if(count($errors)>0){
  26. $this->log(__METHOD__, 'error' . __FUNCTION__, json_encode($request->all()));
  27. (new Controller())->log(__METHOD__,'error_'.__FUNCTION__,'fields wrong, see Errors report please.'.'|'.json_encode($request).'|'.json_encode($errors));
  28. return response()->json(['response'=>['flag'=>'W','message'=>'fields wrong, see Errors report please.',
  29. 'errors'=>$errors]])
  30. ->setEncodingOptions(JSON_UNESCAPED_UNICODE);
  31. }
  32. $receiveInputs=$request->input('request');
  33. foreach ($receiveInputs as $receiveInput){
  34. $isRepeated=WMSReflectReceive::where('ASNNO',$receiveInput['ASNNO'])->first();
  35. if($isRepeated){
  36. (new Controller())->log(__METHOD__,'error_'.__FUNCTION__,'ASNNO重复'.'|'.json_encode($request).'|'.json_encode($errors));
  37. return response()->json(['response'=>['flag'=>'N','code'=>'6666','message'=>'ASNNO重复']])
  38. ->setEncodingOptions(JSON_UNESCAPED_UNICODE);
  39. }
  40. $receive=new WMSReflectReceive($receiveInput);
  41. $receive->save();
  42. // $skus=[];
  43. foreach ($receiveInput['SKU_LIST'] as $skuInput){
  44. $sku=new WMSReflectReceiveSku($skuInput);
  45. $receive->skus()->save($sku);
  46. // $skus[]=$sku;
  47. }
  48. event(new WmsReceiveNewEvent($receive['ASNREFERENCE3'],$receive));
  49. }
  50. return response()->json(['response'=>['flag'=>'Y','code'=>'0000','message'=>'正确接收']])
  51. ->setEncodingOptions(JSON_UNESCAPED_UNICODE);
  52. }
  53. protected function validatorForNew(array $data)
  54. {
  55. return Validator::make($data, [
  56. 'request' => ['required', 'array', 'min:1'],
  57. 'request.*.ASNNO' => ['required', 'string', 'max:191'],
  58. 'request.*.WAREHOUSEID' => ['required', 'string', 'max:191'],
  59. 'request.*.CUSTOMERID' => ['required', 'string', 'max:191'],
  60. 'request.*.ASNTYPE' => ['nullable', 'string', 'max:191'],
  61. 'request.*.ASNREFERENCE1' => ['required', 'string', 'max:191'],
  62. 'request.*.ASNREFERENCE2' => ['nullable', 'string', 'max:191'],
  63. 'request.*.ASNREFERENCE3' => ['required', 'string', 'max:191'],
  64. 'request.*.ASNSTATUS' => ['nullable', 'string', 'max:191'],
  65. 'request.*.NOTES' => ['nullable', 'string', 'max:191'],
  66. 'request.*.USERDEFINE1' => ['nullable', 'string', 'max:191'],
  67. 'request.*.USERDEFINE2' => ['nullable', 'string', 'max:191'],
  68. 'request.*.USERDEFINE3' => ['nullable', 'string', 'max:191'],
  69. 'request.*.SKU_LIST' => ['required', 'array', 'min:1'],
  70. 'request.*.SKU_LIST.*.ASNLINENO' => ['nullable', 'string', 'max:191'],
  71. 'request.*.SKU_LIST.*.SKU' => ['required', 'string', 'max:191'],
  72. 'request.*.SKU_LIST.*.ALTERNATE_SKU1' => ['required', 'string', 'max:191'],
  73. 'request.*.SKU_LIST.*.SKUDESCRC' => ['nullable', 'string', 'max:191'],
  74. 'request.*.SKU_LIST.*.EXPECTEDQTY_EACH' => ['nullable', 'string', 'max:191'],
  75. 'request.*.SKU_LIST.*.UOM' => ['nullable', 'string', 'max:191'],
  76. 'request.*.SKU_LIST.*.LINESTATUS' => ['nullable', 'string', 'max:191'],
  77. 'request.*.SKU_LIST.*.LOTATT05' => ['nullable', 'string', 'max:191'],
  78. 'request.*.SKU_LIST.*.USERDEFINE4' => ['nullable', 'string', 'max:191'],
  79. 'request.*.SKU_LIST.*.USERDEFINE5' => ['nullable', 'string', 'max:191'],
  80. 'request.*.SKU_LIST.*.USERDEFINE6' => ['nullable', 'string', 'max:191'],
  81. ],[],[
  82. 'request.ASNNO' => 'ASNNO',
  83. 'request.*.WAREHOUSEID' => 'WAREHOUSEID',
  84. 'request.*.CUSTOMERID' => 'CUSTOMERID',
  85. 'request.*.ASNTYPE' => 'ASNTYPE',
  86. 'request.*.ASNREFERENCE1' => 'ASNREFERENCE1',
  87. 'request.*.ASNREFERENCE2' => 'ASNREFERENCE2',
  88. 'request.*.ASNREFERENCE3' => 'ASNREFERENCE3',
  89. 'request.*.ASNSTATUS' => 'ASNSTATUS',
  90. 'request.*.NOTES' => 'NOTES',
  91. 'request.*.USERDEFINE1' => 'USERDEFINE1',
  92. 'request.*.USERDEFINE2' => 'USERDEFINE2',
  93. 'request.*.USERDEFINE3' => 'USERDEFINE3',
  94. 'request.*.SKU_LIST' => 'SKU_LIST',
  95. 'request.*.SKU_LIST.*.ASNLINENO' => 'SKU_LIST.ASNLINENO',
  96. 'request.*.SKU_LIST.*.SKU' => 'SKU_LIST.SKU',
  97. 'request.*.SKU_LIST.*.ALTERNATE_SKU1' => 'SKU_LIST.ALTERNATE_SKU1',
  98. 'request.*.SKU_LIST.*.SKUDESCRC' => 'SKU_LIST.SKUDESCRC',
  99. 'request.*.SKU_LIST.*.EXPECTEDQTY_EACH' => 'SKU_LIST.EXPECTEDQTY_EACH',
  100. 'request.*.SKU_LIST.*.UOM' => 'SKU_LIST.UOM',
  101. 'request.*.SKU_LIST.*.LINESTATUS' => 'SKU_LIST.LINESTATUS',
  102. 'request.*.SKU_LIST.*.LOTATT05' => 'SKU_LIST.LOTATT05',
  103. 'request.*.SKU_LIST.*.USERDEFINE4' => 'SKU_LIST.USERDEFINE4',
  104. 'request.*.SKU_LIST.*.USERDEFINE5' => 'SKU_LIST.USERDEFINE5',
  105. 'request.*.SKU_LIST.*.USERDEFINE6' => 'SKU_LIST.USERDEFINE6',
  106. ]);
  107. }
  108. /**
  109. * 入库回传给WMS
  110. * @param RejectedBill $rejectedBill
  111. * @return bool
  112. */
  113. static public function accomplishToWMS(RejectedBill $rejectedBill)
  114. {
  115. $bill=$rejectedBill;
  116. $wmsReceiveds=WMSReflectReceive::where('ASNREFERENCE3',$rejectedBill['logistic_number_return'])
  117. ->where('is_uploaded',0)->get();
  118. if($wmsReceiveds->isEmpty()){
  119. (new Controller())->log(__METHOD__,'error_'.__FUNCTION__,'没有WMS入库单');
  120. return false;
  121. }
  122. $items=$bill->items()->get();
  123. $amountsItem=(function()use($items){
  124. $result=[];
  125. $items->each(function($item)use(&$result){
  126. $result[$item['id']]= $item['amount'];
  127. });
  128. return $result;
  129. })();
  130. $success=true;
  131. $wmsReceiveds->each(function ($wmsReceived)use(&$bill,&$amountsItem,$items,&$success){
  132. if(!$bill && $bill['is_loaded']!=0)return;
  133. $wmsSkus=$wmsReceived->skus()->get();
  134. $orderNumberCode=$wmsReceived['ASNREFERENCE1']??$bill['order_number'];
  135. $amountsSku=(function()use($wmsSkus){
  136. $result=[];
  137. $wmsSkus->each(function($sku)use(&$result){
  138. $result[$sku['id']]= $sku['EXPECTEDQTY_EACH'];
  139. });
  140. return $result;
  141. })();
  142. $skuStrList=[];
  143. $customerCode=$bill->owner()->first()['code'];
  144. $wmsSkus->each(function(WMSReflectReceiveSku $sku)use(&$items,&$skuList,&$amountsItem,&$amountsSku,&$skuStrList,$wmsReceived,$customerCode){
  145. $items->each(function(RejectedBillItem $item)use(&$sku,&$amountsItem,&$amountsSku,&$skuStrList,$wmsReceived,$customerCode){
  146. if($item['barcode_goods']!=$sku['ALTERNATE_SKU1'])return;
  147. if($amountsItem[$item['id']]==0||$amountsSku[$sku['id']]==0)return;
  148. $uploadingAmount=(function()use(&$item,&$sku,&$amountsItem,&$amountsSku){
  149. if($amountsItem[$item['id']]>$amountsSku[$sku['id']]){
  150. $amountsItem[$item['id']]-=$amountsSku[$sku['id']];
  151. $amount= $amountsSku[$sku['id']];
  152. $amountsSku[$sku['id']]=0;
  153. return $amount;
  154. }
  155. if($amountsItem[$item['id']]<$amountsSku[$sku['id']]){
  156. $amount=$amountsItem[$item['id']];
  157. $amountsSku[$sku['id']]-=$amount;
  158. $amountsItem[$item['id']]=0;
  159. return $amount;
  160. }
  161. $amount=$amountsItem[$item['id']];
  162. $amountsItem[$item['id']]=0;
  163. $amountsSku[$sku['id']]=0;
  164. return $amount;
  165. })();
  166. if($item['is_loaded']=='已入库'){return;}
  167. $STATUS=$item['id_quality_label']==1?'ZP':'CC';
  168. $STATUS_code=$item['id_quality_label']==1?'01':'02';
  169. $skuStr="
  170. {
  171. \"ORDERNUMBERCODE\": \"{$wmsReceived['ASNNO']}\",
  172. \"ASNLINENO\": \"{$sku['ASNLINENO']}\",
  173. \"SKUCODE\": \"{$sku['SKU']}\",
  174. \"QUANTITY\": \"{$uploadingAmount}\",
  175. \"LOTATT04\": \"{$sku['LOTATT04']}\",
  176. \"LOTATT05\": \"{$sku['LOTATT05']}\",
  177. \"STATUS\": \"{$STATUS}\",
  178. \"PRODUCTION DATE\": \"{$item['made_at']}\",
  179. \"EXPIRATION DATE\": \"{$item['validity_at']}\",
  180. \"USERDEFINE1\": \"{$customerCode}{$STATUS_code}\",
  181. \"USERDEFINE2\": \"\",
  182. \"USERDEFINE3\": \"\",
  183. \"UNIQUE_CODE_LIST\": [".
  184. // {
  185. // \"ORDERNUMBERCODE\": \"{$wmsReceived['ASNNO']}\",
  186. // \"SKUCODE\": \"{$sku['SKU']}\",
  187. // \"STATUS\": \"{$STATUS}\",
  188. // \"PRODUCTION DATE\": \"{$item['made_at']}\",
  189. // \"EXPIRATION DATE\": \"{$item['validity_at']}\",
  190. // \"LOTATT05\": \"{$sku['LOTATT05']}\",
  191. // \"UNIQUE_CODE\": \"\"
  192. // }
  193. "]
  194. }
  195. ";
  196. $skuStrList[]=$skuStr;
  197. });
  198. });
  199. if(count($skuStrList)==0)return;
  200. $skuStrList = implode(',',$skuStrList);
  201. $json="
  202. {
  203. \"request\": [
  204. {
  205. \"ORDERNUMBERCODE\": \"{$wmsReceived['ASNNO']}\",
  206. \"CUSTOMERID\": \"{$customerCode}\",
  207. \"ASNTYPE\": \"{$wmsReceived['ASNTYPE']}\",
  208. \"ASNREFERENCE1\": \"{$orderNumberCode}\",
  209. \"ADDWHO\": \"WCS\",
  210. \"USERDEFINE1\": \"\",
  211. \"USERDEFINE2\": \"\",
  212. \"USERDEFINE3\": \"\",
  213. \"SKU_LIST\": [{$skuStrList}]
  214. }
  215. ]
  216. }
  217. ";
  218. $sendingJson = json_decode($json,true);
  219. $url=url(config('api.flux.receive.new'));
  220. $response = Zttp::post($url, $sendingJson);
  221. $noIssues=true;
  222. $json = $response->json();
  223. (new Controller())->log(__METHOD__,__FUNCTION__,$response->body().'|'.json_encode($sendingJson));
  224. if(!$json||!isset($json['Response'])||!$json['Response']['return']['returnFlag']=='1'){
  225. $noIssues=false;
  226. }
  227. if($json&&isset($json['Response'])){
  228. if($json['Response']['return']['returnFlag']=='2'){
  229. return true;
  230. }
  231. if(isset($json['Response']['return']['returnDesc'])&&strpos($json['Response']['return']['returnDesc'],'唯一约束')!==false){
  232. (new Controller())->log(__METHOD__,'error_'.__FUNCTION__,$response->body().'|'.json_encode($sendingJson));
  233. return true;
  234. }
  235. if(isset($json['Response']['return']['errordescr'])&&strpos($json['Response']['return']['errordescr'],'已完成')!==false){
  236. (new Controller())->log(__METHOD__,'error_'.__FUNCTION__,$response->body().'|'.json_encode($sendingJson));
  237. return true;
  238. }
  239. }
  240. if($noIssues&&$json['Response']['return']['returnFlag']=='1'){
  241. $wmsReceived['is_uploaded']=1;
  242. $wmsReceived->save();
  243. return true;
  244. }else{
  245. $success=false;
  246. (new Controller())->log(__METHOD__,'error_'.__FUNCTION__,$response->body().'|'.json_encode($sendingJson));
  247. }
  248. });
  249. return $success;
  250. }
  251. }