PackageController.php 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298
  1. <?php
  2. namespace App\Http\Controllers\api\thirdPart\goodscan;
  3. use App\Events\WeighedEvent;
  4. use App\Http\Controllers\LogisticNumberFeatureController;
  5. use App\Jobs\WeightUpdateInstantBill;
  6. use App\MeasuringMachine;
  7. use App\OracleDOCOrderHeader;
  8. use App\Order;
  9. use App\OrderPackage;
  10. use App\Services\LogService;
  11. use App\Services\OrderService;
  12. use App\Waybill;
  13. use Carbon\Carbon;
  14. use Illuminate\Http\Request;
  15. use Illuminate\Support\Facades\Validator;
  16. class PackageController
  17. {
  18. public function new_(Request $request)
  19. {
  20. app('LogService')->log(__METHOD__,'GoodScan weightApi add'.__FUNCTION__,json_encode($request->getContent()));
  21. $requestInput = [];
  22. foreach ($request->input() as $key=>$item) {
  23. $requestInput[strtolower($key)] = $item;
  24. }
  25. $errors = $this->validatorWeight($requestInput)->errors(); // 参数校验
  26. $weight = $requestInput['weight']??'';
  27. if($weight == '-9.9'){ // 称重异常校验
  28. app('LogService')->log(__METHOD__,'GoodScan weightApi (Error)'.__FUNCTION__,'异方接口称重伤上传异常[异常值为-9.9,电子秤故障或未连接]'.json_encode($request->getContent()));
  29. return json_encode(['code'=>500,'error'=>'weight=-9.9']);
  30. }
  31. if(count($errors) > 0){
  32. app('LogService')->log(__METHOD__,'error'.__FUNCTION__,json_encode($request->getContent()).'||'.json_encode($errors),null);
  33. return json_encode(['code'=>500,'error'=>$errors]);
  34. }
  35. /**
  36. * @var MeasuringMachine $measuringMachine
  37. * @var OrderPackage $orderPackage
  38. * @var OracleDOCOrderHeader $orderHeader
  39. * @var Order $order
  40. */
  41. $measuringMachine = $this->getMeasuringMachine($requestInput['hid']); // 返回设备并启动
  42. $orderPackage=$this->getOrderPackageByLogisticNumber($requestInput['code']); // 查询WAS是否有对应的包裹信息
  43. if($orderPackage){
  44. $result = $this->updateOrderPackage($orderPackage,$requestInput,$measuringMachine); // 更新包裹信息
  45. if($result){
  46. return json_encode($result);
  47. }
  48. }else{
  49. try {
  50. $orderHeader = $this->findOrderHeaderByLogisticNumber($requestInput['code']);// 查询WMS是否有对应的包裹信息
  51. if (!$orderHeader) {
  52. return json_encode(['code' => 500, 'error' => '保存时发生错误(未在WMS中找到订单)!'], JSON_UNESCAPED_UNICODE);
  53. }
  54. $order = $this->createOrderByOrderHeader($orderHeader);
  55. $orderPackage = $this->getOrderPackage($requestInput, $measuringMachine, $order);// 返回包裹对象
  56. $this->syncOrderPackageLogistic($orderPackage);// 同步包裹订单的承运商
  57. } catch (\Exception $e) {
  58. app('LogService')->log(__METHOD__,__FUNCTION__,'GoodScan weightApi (Error)'.json_encode($request->getContent()).'||'.json_encode($orderPackage),null);
  59. return json_encode(["code"=>500,"error"=>"写入WMS失败!"],JSON_UNESCAPED_UNICODE);
  60. }
  61. }
  62. if(!empty($orderPackage->order)){
  63. Waybill::setWeightByOrderCode($orderPackage->order->code,$orderPackage->weight);
  64. }
  65. $orderPackage->loadMissing('measuringMachine');
  66. event(new WeighedEvent($orderPackage));
  67. dispatch(new WeightUpdateInstantBill($orderPackage));
  68. $response=["code"=>0,'error'=>'upload success'];
  69. app('LogService')->log(__METHOD__,__FUNCTION__,"异方下发写入包裹成功:".json_encode($request->getContent()).'||'.json_encode($response),null);
  70. return json_encode($response,JSON_UNESCAPED_UNICODE);
  71. }
  72. /**
  73. * @param string $hid
  74. * @return \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Eloquent\Model
  75. */
  76. public function getMeasuringMachine($hid)
  77. {
  78. /** @var MeasuringMachine $measuringMachine */
  79. $measuringMachine = MeasuringMachine::query()->firstOrCreate(['code'=>$hid]); // 称重设备
  80. $measuringMachine->turnOn();
  81. $measuringMachine->turnOffInMinutes(30);
  82. return $measuringMachine;
  83. }
  84. public function validatorWeight(array $request)
  85. {
  86. return Validator::make($request, [
  87. 'code' => ['required', 'max:191'],
  88. 'l' => ['required', 'numeric', 'min:0'],
  89. 'w' => ['required', 'numeric', 'min:0'],
  90. 'h' => ['required', 'numeric', 'min:0'],
  91. 'weight' => ['required', 'numeric', 'min:0'],
  92. 'hid' => ['required', 'string', 'min:0'],
  93. 'picture' => ['nullable'],
  94. ], [
  95. 'required' => ':attribute 为必填项',
  96. 'max' => ':attribute 字符过多或数值过大',
  97. 'min' => ':attribute 不得为负',
  98. 'numeric' => ':attribute 应为数字',
  99. 'string' => ':attribute 应为字符串',
  100. ], []);
  101. }
  102. /**
  103. * @param OrderPackage $orderPackage
  104. * @param array $params
  105. * @param MeasuringMachine $measuringMachine
  106. * @return array
  107. */
  108. public function updateOrderPackage(&$orderPackage,$params,$measuringMachine) //更新包裹信息 前往处理活动波次
  109. {
  110. $edges=$this->getEdges($params);
  111. $req_date=\Illuminate\Support\Carbon::now()->format(\Illuminate\Support\Carbon::DEFAULT_TO_STRING_FORMAT);
  112. $orderPackage->weight=$params['weight'];
  113. $orderPackage->measuring_machine_id=$measuringMachine->id;
  114. $orderPackage->length=$edges[0];
  115. $orderPackage->width=$edges[1];
  116. $orderPackage->height=$edges[2];
  117. $orderPackage->weighed_at=$req_date;
  118. $orderPackage->bulk=$edges[0]*$edges[1]*$edges[2]/1000;
  119. if($orderPackage->isActivityBatch()){
  120. $response=$this->activityWaveNoProcessing($orderPackage);
  121. if($response)return $response;
  122. }
  123. $orderPackage->save();
  124. return[];
  125. }
  126. /**
  127. * @param OrderPackage $orderPackage
  128. * @return array
  129. */
  130. public function activityWaveNoProcessing(&$orderPackage) //处理活动波次
  131. {
  132. $fluxController = new \App\Http\Controllers\api\thirdPart\flux\PackageController();
  133. if($orderPackage->isActivityBatch()){
  134. app('LogService')->log(__METHOD__,__FUNCTION__,"依波次号同步所有包裹:".json_encode($orderPackage),null);
  135. $params = [
  136. 'weight'=>$orderPackage['weight'] ?? null,
  137. 'length'=>$orderPackage['length'] ?? null,
  138. 'width'=>$orderPackage['width'] ?? null,
  139. 'height'=>$orderPackage['height'] ?? null,
  140. 'bulk'=>$orderPackage['bulk'] ?? null,
  141. 'measuring_machine_id'=>$orderPackage['measuring_machine_id'] ?? null,
  142. 'weighed_at'=>$orderPackage['weighed_at'] ?? null,
  143. 'paper_box_id'=>$orderPackage['paper_box_id'] ?? null,
  144. ];
  145. OrderPackage::query()->where('batch_number',$orderPackage['batch_number'])->update($params);
  146. $result=$fluxController->markWMSOnBatch($orderPackage['batch_number'], $orderPackage['weight']);
  147. if(!$result['result']){
  148. $orderPackage->uploaded_to_wms="异常";
  149. }
  150. }else{
  151. app('LogService')->log(__METHOD__,__FUNCTION__,"GoodScan 写入包裹至WMS:".json_encode($orderPackage),null);
  152. try{
  153. $result=$fluxController->accomplishToWMS($orderPackage);
  154. if ($result['result'])
  155. $orderPackage->uploaded_to_wms="是";
  156. else
  157. $orderPackage->uploaded_to_wms="异常";
  158. }catch (\Exception $e){
  159. $orderPackage->uploaded_to_wms="否";
  160. }
  161. }
  162. $response=$this->saveOrderPackage($orderPackage);
  163. return $response??[];
  164. }
  165. /**
  166. * @param OrderPackage $orderPackage
  167. * @return array
  168. */
  169. public function saveOrderPackage(&$orderPackage) //保存修改并
  170. {
  171. try {
  172. $logisticNumberController = new LogisticNumberFeatureController();
  173. if (!$orderPackage->order) {
  174. $orderPackage->order = new Order();
  175. }
  176. if (!$orderPackage->order->logistic) {
  177. $orderPackage->order->logistic = $logisticNumberController->getLogisticByFeatures($orderPackage->logistic_number);
  178. }
  179. $orderPackage->save();
  180. return [];
  181. } catch (\Exception $e) {
  182. $response=["msg"=>'称重下发修改时发生错误!',json_encode($e),'code'=>500,'data'=>null];
  183. app('LogService')->log(__METHOD__,'GoodScan weightApi (Error)'.__FUNCTION__,json_encode($orderPackage).'||'.json_encode($e),null);
  184. return $response;
  185. }
  186. }
  187. /**
  188. * @param string $logisticNumber
  189. * @return \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Eloquent\Model|object|null
  190. */
  191. public function getOrderPackageByLogisticNumber($logisticNumber)
  192. {
  193. return OrderPackage::query()
  194. ->with(['order'=>function($query){
  195. $query->with('owner','logistic');
  196. }])
  197. ->where('logistic_number',$logisticNumber)
  198. ->first();
  199. }
  200. /**
  201. * @param string $logisticNumber
  202. * @return \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Eloquent\Model|object|null
  203. */
  204. public function findOrderHeaderByLogisticNumber($logisticNumber)
  205. {
  206. return OracleDOCOrderHeader::query()->with('actAllocationDetails','oracleBASCode')
  207. ->whereHas('actAllocationDetails',function($query)use($logisticNumber){
  208. $query->where('picktotraceid',$logisticNumber);
  209. })
  210. // ->orWhere('soreference5',$logisticNumber)
  211. ->first();
  212. }
  213. /**
  214. * @param OracleDOCOrderHeader $orderHeader
  215. * @return \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Eloquent\Model
  216. */
  217. public function createOrderByOrderHeader($orderHeader)
  218. {
  219. /** @var OrderService $orderService */
  220. $orderService=app(OrderService::class);
  221. $order_create_params=$orderService->getParamByOrderHeader($orderHeader);
  222. $order = $orderService->first(['code'=>$orderHeader->orderno]);
  223. if($order)return $order;
  224. $order = $orderService->createOrder($order_create_params);
  225. app('LogService')->log(__METHOD__,__FUNCTION__,'GoodScan 创建Order',json_encode($order)." || ".$orderHeader);
  226. return $order;
  227. }
  228. /**
  229. * @param array $requestInput
  230. * @param MeasuringMachine $measuringMachine
  231. * @param Order $order
  232. * @return \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Eloquent\Model|object|null
  233. */
  234. public function getOrderPackage($requestInput,$measuringMachine,$order)
  235. {
  236. // $weighed_at =$requestInput['time']??Carbon::now();
  237. $weighed_at =Carbon::now();
  238. $edges=$this->getEdges($requestInput);
  239. OrderPackage::query()->create([
  240. 'order_id'=>$order->id,
  241. 'logistic_number'=>$requestInput['code'],
  242. 'measuring_machine_id'=>$measuringMachine->id,
  243. 'weight'=>$requestInput['weight'],
  244. 'length'=>$edges[0],
  245. 'width'=>$edges[1],
  246. 'height'=>$edges[2],
  247. 'bulk'=>$edges[0]*$edges[1]*$edges[2],
  248. 'weighed_at'=>$weighed_at,
  249. 'status'=>"无",
  250. ]);
  251. return $this->getOrderPackageByLogisticNumber($requestInput['code']);
  252. }
  253. /**
  254. * @param array $requestInput
  255. * @return array
  256. */
  257. public function getEdges($requestInput)
  258. {
  259. $edges = [$requestInput['l']??0,$requestInput['w']??0,$requestInput['h']??0];
  260. rsort($edges);
  261. return $edges;
  262. }
  263. /**
  264. * @param $orderPackage
  265. */
  266. public function syncOrderPackageLogistic(&$orderPackage) // 同步订单承运商
  267. {
  268. $logisticNumberController = new LogisticNumberFeatureController();
  269. if (!$orderPackage->order) {
  270. $orderPackage->order = new Order();
  271. }
  272. if (!$orderPackage->order->logistic) {
  273. $orderPackage->order->logistic = $logisticNumberController->getLogisticByFeatures($orderPackage->logistic_number);
  274. }
  275. $orderPackage->save();
  276. }
  277. }