ReceiveController.php 13 KB

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