OrderRejectingStatusService.php 6.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154
  1. <?php
  2. namespace App\Services;
  3. use App\Commodity;
  4. use App\CommodityBarcode;
  5. use App\Order;
  6. use App\OrderDetail;
  7. use App\OrderIssueRejectedBill;
  8. use App\OrderIssueType;
  9. use App\RejectedBill;
  10. use App\RejectedBillItem;
  11. use App\WorkOrder;
  12. use App\WorkOrderDetail;
  13. class OrderRejectingStatusService
  14. {
  15. //计算退回件问题
  16. public function rejectedBillSyncRejectingStatus(RejectedBill $rejectedBill)
  17. {
  18. $query = OrderIssueRejectedBill::query()->select('order_id')->where('logistic_number_return', $rejectedBill->logistic_number_return);
  19. $order = Order::query()->whereIn('id', $query)->first();
  20. $this->syncRejectingStatus($order);
  21. }
  22. /**
  23. * 订单同步退回状态
  24. */
  25. public function syncRejectingStatus($order)
  26. {
  27. if (!$order) return;
  28. $rejecting_status = $this->getOrderRejectingStatus($order);
  29. $query = OrderDetail::query()->where('order_id', $order->id);
  30. $order_detail = $query->first();
  31. $is_new_rejecting = in_array($rejecting_status, ['无', '未退回']) ? '无' : '有';
  32. if (!$order_detail) {
  33. try {
  34. OrderDetail::query()->create(
  35. ['order_id' => $order->id, 'is_new_rejecting' => $is_new_rejecting, 'rejecting_status' => $rejecting_status]
  36. );
  37. } catch (\Exception $e) {
  38. LogService::log(__CLASS__, __METHOD__, $e->getMessage());
  39. }
  40. return;
  41. }
  42. if (in_array($order_detail->is_new_rejecting, ['有', '已处理']) && $rejecting_status != '无') {
  43. $query->update(['rejecting_status' => $rejecting_status]);
  44. } else {
  45. $query->update(['rejecting_status' => $rejecting_status, 'is_new_rejecting' => $is_new_rejecting]);
  46. }
  47. if ($rejecting_status == '全部退回') {
  48. $orderIssueTypeQuery = OrderIssueType::query()->select('id')->where('name','拦截');
  49. $workOrder = WorkOrder::query()->where('order_id',$order->id)
  50. ->whereIn('order_issue_type_id',$orderIssueTypeQuery)->where('status','!=',6)->first();
  51. if($workOrder){
  52. app(WorkOrderInterceptService::class)->autoReviewIntercept($workOrder);
  53. }
  54. }
  55. }
  56. public function getOrderRejectingStatus(Order $order): string
  57. {
  58. $rejected_bill_item_map = $this->getRejectedBillMaps($order);
  59. $order_commodity_map = $this->getOrderCommodityMap($order);
  60. return $this->computerRejectingStatus($rejected_bill_item_map, $order_commodity_map);
  61. }
  62. private function getRejectedBillItems(Order $order)
  63. {
  64. $orderIssueRejectedBills = OrderIssueRejectedBill::query()->select('logistic_number_return')->where('order_id', $order->id)->where('logistic_number_return', '!=', '')->get();
  65. $logistic_number_return = $orderIssueRejectedBills->map(function ($item) {
  66. return $item->logistic_number_return;
  67. })->toArray();
  68. $query = RejectedBill::query()->select('id')->whereIn('logistic_number_return', $logistic_number_return);
  69. return RejectedBillItem::query()->with('quality')->whereIn('id_rejected_bill', $query)->get();
  70. }
  71. private function getRejectedBillMaps($order): array
  72. {
  73. $rejected_bill_items = $this->getRejectedBillItems($order);
  74. $map = [];
  75. if (count($rejected_bill_items) == 0) return $map;
  76. foreach ($rejected_bill_items as $item) {
  77. $code = $item->barcode_goods;
  78. $amount = $item->amount;
  79. if (!Commodity::query()->where("sku", $code)->where('owner_id', $order->owner_id)->exists()) {
  80. $query = CommodityBarcode::query()->select('commodity_id')->where('code', $code);
  81. $commodity = Commodity::query()->where('owner_id', $order->owner_id)->whereIn('id', $query)->whereNotNull('sku')->first();
  82. if ($commodity) $code = $commodity->sku;
  83. }
  84. $quality_name = $item->quality->name;
  85. if ($map[$code][$quality_name] ?? false) $map[$code][$quality_name] += $amount;
  86. else $map[$code][$quality_name] = $amount;
  87. }
  88. return $map;
  89. }
  90. private function getOrderCommodityMap(Order $order): array
  91. {
  92. $map = [];
  93. $order->packages->each(function ($package) use ($order, &$map) {
  94. $package->commodities->map(function ($item) use ($order, &$map) {
  95. $sku = $item->commodity->sku ?? null;
  96. if ($sku) {
  97. $amount = $item->amount;
  98. empty($map[$sku]) ? $map[$sku] = $amount : $map[$sku] += $amount;
  99. }
  100. });
  101. });
  102. return $map;
  103. }
  104. private function computerRejectingStatus(array $rejected_bill_item_map, array $order_commodity_map): string
  105. {
  106. //未退回,差异退回,全部退回,超量退回,部分退回
  107. if (count($rejected_bill_item_map) == 0) return "未退回";
  108. $equal = 0; // 相等sku
  109. $portion = 0; // 相等的sku
  110. foreach ($rejected_bill_item_map as $key => $map) {
  111. if (isset($map['残次']) && $map['残次'] > 0) return "差异退回";
  112. if (empty($order_commodity_map[$key])) return "差异退回";
  113. if (isset($map['正品']) && isset($order_commodity_map[$key])) {
  114. if ($map['正品'] < $order_commodity_map[$key]) $portion += 1;
  115. if ($map['正品'] > $order_commodity_map[$key]) return "超量退回";
  116. if ($map['正品'] == $order_commodity_map[$key]) $equal += 1;
  117. }
  118. }
  119. if ($equal == count($rejected_bill_item_map)
  120. && $equal == count($order_commodity_map)
  121. && $portion == 0) return "全部退回"; // 全部退回
  122. if ($portion > 0) return "部分退回";
  123. if (count(array_diff_key($order_commodity_map, $rejected_bill_item_map)) > 0) return '部分退回';
  124. if (count(array_diff_key($rejected_bill_item_map, $order_commodity_map)) > 0) return '差异退回';
  125. if($this->isDiffReject($rejected_bill_item_map)) return '差异退回';
  126. return "无";
  127. }
  128. public function isDiffReject(array $rejected_bill_item_map): bool
  129. {
  130. // 只要有残次 正品 未知 都属于 差异退回
  131. $count = 0;
  132. foreach ($rejected_bill_item_map as $key => $map) {
  133. if( (isset($map['残次']) && $map['残次'] >0)
  134. || (isset($map['正品']) && $map['正品'] > 0 )
  135. || (isset($map['未知']) && $map['未知'] > 0 )){
  136. $count ++ ;
  137. }
  138. }
  139. return $count != 0;
  140. }
  141. }