OrderRejectingStatusService.php 5.4 KB

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