ReceiveController.php 11 KB

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