WeightBaseController.php 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345
  1. <?php
  2. namespace App\Http\Controllers\api\thirdPart\weight;
  3. use App\Events\WeighedEvent;
  4. use App\Jobs\WeightUpdateInstantBill;
  5. use App\MeasuringMachine;
  6. use App\OracleActAllocationDetails;
  7. use App\OracleDOCOrderHeader;
  8. use App\OrderPackage;
  9. use App\Services\OrderService;
  10. use Carbon\Carbon;
  11. use Illuminate\Database\Eloquent\Builder;
  12. use Illuminate\Http\Request;
  13. class WeightBaseController
  14. {
  15. protected $weight = ''; // 重量
  16. protected $length = ''; // 长
  17. protected $width = ''; // 宽
  18. protected $height = ''; // 高
  19. protected $code = ''; // 快递单号
  20. protected $weight_at = ''; // 称重时间
  21. protected $hid = ''; // 称重设备id
  22. protected $name = ''; // 名称
  23. public function new(Request $request)
  24. {
  25. app('LogService')->log(__METHOD__, $this->name, "记录上传日志:" . json_encode($request->all()) . '||' , null);
  26. $errors = $this->validator($request);
  27. if(count($errors)){
  28. return $this->validatorErrors($errors);
  29. }
  30. return $this->weightOrderPackage($request);
  31. }
  32. public function weightOrderPackage(Request $request)
  33. {
  34. /**
  35. * @var OrderPackage $orderPackage
  36. * @var MeasuringMachine $measuringMachine
  37. */
  38. // 1、转化数据
  39. $params = $this->conversionRequest($request);
  40. // 2.获取快递单号
  41. $logistic_number = $this->getCodeValue($params);
  42. // 3、获取称重设备
  43. $measuringMachine = $this->getMeasuringMachine($params);
  44. // 4、快递单号对应的OrderPackage
  45. $orderPackage = $this->getOrderPackageByCode($logistic_number);
  46. if (is_null($orderPackage)) {
  47. /** @var OracleDOCOrderHeader $orderHeader */
  48. $orderHeader = $this->findOrderHeaderByLogisticNumber($logistic_number);
  49. if (is_null($orderHeader)) {
  50. app('LogService')->log(__METHOD__, $this->name, 'WMSOrderHeaderNotFind (Error)',$logistic_number , null);
  51. return $this->getNotFindOrderHeaderMessage($params, $orderPackage);
  52. }
  53. try {
  54. $order = $this->createOrderByOrderHeader($orderHeader);
  55. $orderPackage = $this->createOrderPackage($params, $measuringMachine, $order);
  56. } catch (\Exception $e) {
  57. app('LogService')->log(__METHOD__, $this->name, '写入WAS失败! (Error)',$logistic_number , null);
  58. return json_encode(["success" => false, "message" => "写入WAS失败!"], JSON_UNESCAPED_UNICODE);
  59. }
  60. }
  61. // 5、更新包裹信息
  62. $bool = $this->updateOrderPackage($orderPackage, $params, $measuringMachine);
  63. if (!$bool) return $this->getUpdatePackageMessage($orderPackage);
  64. // 6、处理波次信息
  65. try {
  66. $this->activityWaveNoProcessing($orderPackage);
  67. } catch (\Exception $e) {
  68. app('LogService')->log(__METHOD__, $this->name, 'weightApi (Error)', json_encode($orderPackage) . '||' . json_encode($e), null);
  69. return $this->getWeightMessage($orderPackage, $e);
  70. }
  71. // 7、称重完成之后操作
  72. $this->afterApply($orderPackage);
  73. $response = $this->getSuccessMessage($params, $orderPackage);
  74. app('LogService')->log(__METHOD__, $this->name, "下发写入包裹成功:" . json_encode($request->getContent()) . '||' . json_encode($response), null);
  75. return json_encode($response, JSON_UNESCAPED_UNICODE);
  76. }
  77. // region ---数据转化
  78. public function conversionRequest(Request $request)
  79. {
  80. // 1、转化数据
  81. $params = [];
  82. foreach ($request->input() as $key => $item) {
  83. $params[strtolower($key)] = $item;
  84. }
  85. return $params;
  86. }
  87. // endregion
  88. // region ---称重完成之后的操作
  89. // 后续操作
  90. public function afterApply(OrderPackage $orderPackage)
  91. {
  92. $orderPackage->loadMissing(['order' => function ($query) {
  93. $query->with('owner', 'logistic');
  94. }, 'measuringMachine', 'paperBox']);
  95. event(new WeighedEvent($orderPackage));
  96. dispatch(new WeightUpdateInstantBill($orderPackage));
  97. }
  98. // endregion
  99. // region ---消息返回
  100. // 返回称重成功信息
  101. public function getSuccessMessage($params, $orderPackage): array
  102. {
  103. return ['success' => true, 'message' => '称重成功'];
  104. }
  105. // 返回包裹未找到异常
  106. public function getNotFindOrderPackageMessage($params, $orderPackage): string
  107. {
  108. return json_encode(['success' => false, 'message' => '未找打包裹信息', JSON_UNESCAPED_UNICODE]);
  109. }
  110. // 返回富勒信息未找到异常
  111. public function getNotFindOrderHeaderMessage($params, $orderPackage): string
  112. {
  113. return json_encode(['success' => false, 'message' => '富勒信息未找到'], JSON_UNESCAPED_UNICODE);
  114. }
  115. // 返回称重下发错误
  116. public function getWeightMessage($orderPackage, $e)
  117. {
  118. return json_encode(['success' => false, 'message' => $e->getMessage], JSON_UNESCAPED_UNICODE);
  119. }
  120. public function getUpdatePackageMessage($orderPackage)
  121. {
  122. return json_encode(['success' => false, 'message' => '更新包裹信息出现异常'], JSON_UNESCAPED_UNICODE);
  123. }
  124. // endregion
  125. // region ---参数校验
  126. public function validator(Request $request): array
  127. {
  128. return [];
  129. }
  130. public function validatorErrors($errors)
  131. {
  132. return json_encode(['success' => false, 'message' => '更新包裹信息出现异常'.json_encode($errors)],JSON_UNESCAPED_UNICODE);
  133. }
  134. // endregion
  135. // region ---参数获取
  136. // 重量
  137. public function getWeightValue($params)
  138. {
  139. return $this->getValue($this->width, $params);
  140. }
  141. // 高
  142. public function getHeightValue($params)
  143. {
  144. return $this->getValue($this->height, $params);
  145. }
  146. // 长
  147. public function getLengthValue($params)
  148. {
  149. return $this->getValue($this->length, $params);
  150. }
  151. // 宽
  152. public function getWidthValue($params)
  153. {
  154. return $this->getValue($this->width, $params);
  155. }
  156. // 快递单号
  157. public function getCodeValue($params)
  158. {
  159. return $this->getValue($this->code, $params);
  160. }
  161. // 称重时间
  162. public function getWeightAtValue($params)
  163. {
  164. return $this->getValue($this->weight_at, $params);
  165. }
  166. // 获取参数
  167. public function getValue($name, $param)
  168. {
  169. $names = explode(',', $name);
  170. $value = array_reduce($names, function ($data, $key) {
  171. if (isset($data[$key])) $data = $data[$key];
  172. else $data = [];
  173. return $data;
  174. }, $param);
  175. if (is_array($value) && count($value) == 0) return null;
  176. return $value;
  177. }
  178. // 排序参数
  179. public function getEdges($params): array
  180. {
  181. $length = $this->getLengthValue($params);
  182. $height = $this->getHeightValue($params);
  183. $width = $this->getWidthValue($params);
  184. $edges = [$length ?? 0, $width ?? 0, $height ?? 0];
  185. rsort($edges);
  186. return $edges;
  187. }
  188. // endregion
  189. // region ---包裹
  190. // 获取包裹
  191. public function getOrderPackageByCode($code)
  192. {
  193. return OrderPackage::query()
  194. ->with(['order' => function ($query) {
  195. /** @var Builder $query */
  196. $query->with('owner', 'logistic');
  197. }])->where('logistic_number', $code)->first();
  198. }
  199. // 更新包裹
  200. public function updateOrderPackage(OrderPackage $orderPackage, $params, $measuringMachine)
  201. {
  202. $edges = $this->getEdges($params);
  203. $req_date = Carbon::now();
  204. $orderPackage['weight'] = $this->getWeightValue($params);
  205. $orderPackage['measuring_machine_id'] = $measuringMachine['id'];
  206. $orderPackage['length'] = $edges[0];
  207. $orderPackage['width'] = $edges[1];
  208. $orderPackage['height'] = $edges[2];
  209. $orderPackage['weighed_at'] = $req_date;
  210. $orderPackage['bulk'] = $edges[0] * $edges[1] * $edges[2] / 1000;
  211. if ($orderPackage->isActivityBatch()) {
  212. $result = $this->activityWaveNoProcessing($orderPackage);
  213. if (!$result) return false;
  214. }
  215. return $orderPackage->save();
  216. }
  217. // 创建包裹信息
  218. public function createOrderPackage($params, $measuringMachine, $order)
  219. {
  220. $weighed_at = Carbon::now();
  221. $edges = $this->getEdges($params);
  222. OrderPackage::query()->create([
  223. 'order_id' => $order->id,
  224. 'logistic_number' => $this->getCodeValue($params),
  225. 'measuring_machine_id' => $measuringMachine->id,
  226. 'weight' => $this->getWeightValue($params),
  227. 'length' => $edges[0],
  228. 'width' => $edges[1],
  229. 'height' => $edges[2],
  230. 'bulk' => $edges[0] * $edges[1] * $edges[2],
  231. 'weighed_at' => $weighed_at,
  232. 'status' => "无",
  233. ]);
  234. return $this->getOrderPackageByCode($this->getCodeValue($params));
  235. }
  236. // endregion
  237. // region ---称重设备
  238. // 获取称重设备
  239. public function getMeasuringMachine($params): MeasuringMachine
  240. {
  241. $hid = $this->getValue($this->hid, $params);
  242. /** @var MeasuringMachine $measuringMachine */
  243. $measuringMachine = MeasuringMachine::query()->firstOrCreate(['code' => $hid]); // 称重设备
  244. $measuringMachine->turnOn();
  245. $measuringMachine->turnOffInMinutes(30);
  246. return $measuringMachine;
  247. }
  248. // endregion
  249. // region ---wms操作
  250. // 获取orderHeader
  251. public function findOrderHeaderByLogisticNumber($code)
  252. {
  253. $query = OracleActAllocationDetails::query()->select('OrderNO')->where('PickToTraceId', $code);
  254. return OracleDOCOrderHeader::query()->with('actAllocationDetails', 'oracleBASCode')->whereIn('OrderNO', $query)->first();
  255. }
  256. // 根据WMS订单信息创建订单信息
  257. public function createOrderByOrderHeader($orderHeader)
  258. {
  259. /** @var OrderService $orderService */
  260. $orderService = app('OrderService');
  261. $order_create_params = $orderService->getParamByOrderHeader($orderHeader);
  262. $order = $orderService->first(['code' => $orderHeader->orderno]);
  263. if ($order) return $order;
  264. $order = $orderService->createOrder($order_create_params);
  265. app('LogService')->log(__METHOD__, $this->name, ' 创建Order', json_encode($order) . " || " . $orderHeader);
  266. return $order;
  267. }
  268. //处理活动波次
  269. public function activityWaveNoProcessing(&$orderPackage)
  270. {
  271. $fluxController = new \App\Http\Controllers\api\thirdPart\flux\PackageController();
  272. if ($orderPackage->isActivityBatch()) {
  273. app('LogService')->log(__METHOD__, $this->name . " 依波次号同步所有包裹:", json_encode($orderPackage), null);
  274. OrderPackage::query()->where('batch_number', $orderPackage['batch_number'])->update([
  275. 'weight' => $orderPackage['weight'] ?? null,
  276. 'length' => $orderPackage['length'] ?? null,
  277. 'width' => $orderPackage['width'] ?? null,
  278. 'height' => $orderPackage['height'] ?? null,
  279. 'bulk' => $orderPackage['bulk'] ?? null,
  280. 'measuring_machine_id' => $orderPackage['measuring_machine_id'] ?? null,
  281. 'weighed_at' => $orderPackage['weighed_at'] ?? null,
  282. 'paper_box_id' => $orderPackage['paper_box_id'] ?? null,
  283. ]);
  284. $result = $fluxController->markWMSOnBatch($orderPackage['batch_number'], $orderPackage['weight']);
  285. if (!$result['result']) {
  286. $orderPackage->uploaded_to_wms = "异常";
  287. }
  288. } else {
  289. app('LogService')->log(__METHOD__, $this->name . " 写入包裹至WMS:", json_encode($orderPackage), null);
  290. try {
  291. $result = $fluxController->accomplishToWMS($orderPackage);
  292. if ($result['result'] == 'success') $orderPackage->uploaded_to_wms = "是";
  293. else $orderPackage->uploaded_to_wms = "异常";
  294. } catch (\Exception $e) {
  295. $orderPackage->uploaded_to_wms = "否";
  296. }
  297. }
  298. return $orderPackage->save();
  299. }
  300. // endregion
  301. }