OrderRejectingStatusService.php 4.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109
  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. OrderDetail::query()->updateOrCreate(
  27. ['order_id' => $order->id,],
  28. ['rejecting_status' => $rejecting_status,'is_new_rejecting' => $rejecting_status === '无' ? '无' : '有']
  29. );
  30. }
  31. public function getOrderRejectingStatus(Order $order): string
  32. {
  33. $rejected_bill_item_map = $this->getRejectedBillMaps($order);
  34. $order_commodity_map = $this->getOrderCommodityMap($order);
  35. return $this->computerRejectingStatus($rejected_bill_item_map, $order_commodity_map);
  36. }
  37. private function getRejectedBillItems(Order $order)
  38. {
  39. $query = OrderIssueRejectedBill::query()->select('logistic_number_return')->where('order_id', $order->id);
  40. $query = RejectedBill::query()->select('id')->whereIn('logistic_number_return', $query);
  41. return RejectedBillItem::query()->with('quality')->whereIn('id_rejected_bill', $query)->get();
  42. }
  43. private function getRejectedBillMaps($order): array
  44. {
  45. $rejected_bill_items = $this->getRejectedBillItems($order);
  46. $map = [];
  47. if(count($rejected_bill_items) == 0) return $map;
  48. foreach ($rejected_bill_items as $item) {
  49. $code = $item->barcode_goods;
  50. $amount = $item->amount;
  51. if (!Commodity::query()->where("sku", $code)->where('owner_id', $order->owner_id)->exists()) {
  52. $query = CommodityBarcode::query()->select('commodity_id')->where('code', $code);
  53. $commodity = Commodity::query()->where('owner_id', $order->owner_id)->whereIn('id', $query)->first();
  54. if ($commodity) $code = $commodity->sku;
  55. }
  56. $quality_name = $item->quality->name;
  57. if ($map[$code][$quality_name] ?? false) $map[$code][$quality_name] += $amount;
  58. else $map[$code][$quality_name] = $amount;
  59. }
  60. return $map;
  61. }
  62. private function getOrderCommodityMap(Order $order): array
  63. {
  64. $map = [];
  65. $order->packages->each(function ($package) use ($order, &$map) {
  66. $package->commodities->map(function ($item) use ($order, &$map) {
  67. $sku = $item->commodity->sku ?? null;
  68. if ($sku) {
  69. $amount = $item->amount;
  70. empty($map[$sku]) ? $map[$sku] = $amount : $map[$sku] += $amount;
  71. }
  72. });
  73. });
  74. return $map;
  75. }
  76. private function computerRejectingStatus(array $rejected_bill_item_map, array $order_commodity_map): string
  77. {
  78. //未退回,差异退回,全部退回,超量退回,部分退回
  79. if (count($rejected_bill_item_map) == 0) return "未退回";
  80. $equal = 0; // 相等sku
  81. $portion = 0; // 相等的sku
  82. foreach ($rejected_bill_item_map as $key => $map) {
  83. if (isset($map['残次']) && $map['残次'] > 0) return "差异退回";
  84. if (empty($order_commodity_map[$key])) return "差异退回";
  85. if (isset($map['正品']) && isset($order_commodity_map[$key])) {
  86. if ($map['正品'] < $order_commodity_map[$key]) $portion += 1;
  87. if ($map['正品'] > $order_commodity_map[$key]) return "超量退回";
  88. if ($map['正品'] == $order_commodity_map[$key]) $equal += 1;
  89. }
  90. }
  91. if ($equal == count($rejected_bill_item_map)
  92. && $equal == count($rejected_bill_item_map)
  93. && $portion == 0) return "全部退回"; // 全部退回
  94. if ($portion > 0) return "部分退回";
  95. if (count(array_diff_key($rejected_bill_item_map, $order_commodity_map)) > 0) return '部分退回';
  96. if (count(array_diff_key($order_commodity_map, $rejected_bill_item_map)) > 0) return '差异退回';
  97. return "无";
  98. }
  99. }