| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101 |
- <?php
- namespace App\Services;
- use App\OracleActAllocationDetails;
- use App\OracleDOCOrderDetail;
- use App\OracleDOCOrderHeader;
- use App\Order;
- use App\OrderPackage;
- use App\OrderPackageCommodities;
- use Tightenco\Collect\Support\Arr;
- class OrderPackageService
- {
- public function __construct()
- {
- app()->bind('orderPackageCommoditiesService', OrderPackageCommoditiesService::class);
- }
- public function createdByOrder(Order $order)
- {
- $orderPackageCommoditiesService = app('orderPackageCommoditiesService');
- $actAllocationCount = OracleActAllocationDetails::where('OrderNo', $order['code'])->count();
- $orderHeader = OracleDOCOrderHeader::where('OrderNo', $order['code'])->first();
- $orderDetailCount = OracleDOCOrderDetail::where('OrderNo', $order['code'])->count();
- $logistic_number = null;
- if ($actAllocationCount == 0) { // 通过oracle Order Detail
- $logistic_number = $orderHeader['soreference5'];
- if ($orderDetailCount == 0) {return null;}
- if ($logistic_number == null || $logistic_number == '*') { return null; }
- $orderPackage = OrderPackage::create(['order_id' => $order['id'], 'logistic_number' => $logistic_number]);
- $orderPackageCommoditiesService->basedOnOracleDetailsStore($orderHeader['orderno'], $orderPackage);
- } else if ($actAllocationCount > 0) {
- $count = OracleActAllocationDetails::where('OrderNo', $order['code'])->whereNull('picktotraceid')->count();
- if ($count > 0) { // 快递单号为空
- if (($orderHeader['soreference5'] ?? false) && $orderHeader['soreference5'] == '*') { return null; }
- $logistic_number = $orderHeader['soreference5'];
- $orderPackage = OrderPackage::create(['order_id' => $order['id'], 'logistic_number' => $logistic_number]);
- $orderPackageCommoditiesService->basedOnOracleDetailsStore($order, $orderPackage);
- } else {
- $ActAllocationDetails = OracleActAllocationDetails::where('orderno', $order['code'])->get();
- foreach ($ActAllocationDetails as $detail) {
- $logistic_number = $detail['picktotraceid'];
- if ($logistic_number == null || $logistic_number == '*') {
- $logistic_number = $orderHeader['soreference5'];
- if ($logistic_number == null || $logistic_number == '*') {return null;}
- $orderPackage = OrderPackage::where(['order_id' => $order['id'], 'logistic_number' => $logistic_number])->first();
- if($orderPackage)continue;
- $orderPackage = OrderPackage::create(['order_id' => $order['id'], 'logistic_number' => $logistic_number]);
- $orderPackageCommoditiesService->basedOnActAllocationDetailsStoreByOrderNo($order['code'], $orderPackage);
- continue;
- }
- $orderPackage = OrderPackage::where(['order_id' => $order['id'], 'logistic_number' => $logistic_number])->first();
- if ($orderPackage) {continue;}
- $orderPackage = OrderPackage::create(['order_id' => $order['id'], 'logistic_number' => $logistic_number]);
- $orderPackageCommoditiesService->basedOnActAllocationDetailsStore($orderPackage);
- }
- }
- }else{
- $this->updateOrderPackageInfo($order);
- }
- return OrderPackage::with(['commodities' => function ($query) {
- return $query->with(['commodity']);
- }])->get();
- }
- public function updateOrderPackageInfo(Order $order)
- {
- $orderHeader = OracleDOCOrderHeader::where('orderNo', $order['code'])->first();
- if ($orderHeader['oracleBASCode_codename_c'] == $order['wam_status']) {
- return;
- }
- $orderPackages = OrderPackage::where('order_id', $order['id'])->get();
- $orderPackageCommodities = OrderPackageCommodities::with('commodity')->whereIn('order_package_id', data_get($orderPackages, '*.id'))->get();
- $actAllocationDetails = OracleActAllocationDetails::where('orderNo', $order['client_code'])->get();
- if (count($orderPackageCommodities) < count($actAllocationDetails)) {
- $actAllocationDetails = $actAllocationDetails->reject(function($value,$key) use (&$orderPackageCommodities){
- $bool = false;
- $count = 0;
- $orderPackageCommodities->reject(function($value1,$key1)use($value,&$bool,$count){
- if($count>0){return false;}
- if($value1->commodity['sku'] == $value['sku'] && $value1['amount'] == intval($value['qty']) ){
- $bool = true;
- $count++;
- return true;
- }else{
- return false;
- }
- });
- return $bool;
- });
- }
- $orderPackageCommoditiesService = app('orderPackageCommoditiesService');
- $orderPackageCommoditiesService->basedOnActAllocationDetail($order, $orderHeader, $actAllocationDetails);
- $order['wam_status'] = $orderHeader['oracleBASCode_codename_c'];
- $order->save();
- }
- }
|