baoshi-was/app/Services/LogisticService.php

<?php

namespace App\Services;

use App\Logistic;
use App\OracleBasCustomer;
use Carbon\Carbon;
use Illuminate\Support\Facades\Auth;

Class LogisticService
{
    public function getSelection($column = ['id','name']){
        return Logistic::query()->select($column)->get();
    }


    public function getWASLogisticsByWMSOrderHeaders($WMSOrderHeaders){
        $carrierIds = [];
        foreach ($WMSOrderHeaders as $WMSOrderHeader) {
            $carrierIds [] = $WMSOrderHeader->carrierid;
        }
        $carrierIds = array_unique($carrierIds);
        $carrierIds = array_diff($carrierIds,['*','',null]);
        $logistics = Logistic::query()->whereIn('code',$carrierIds)->get();
        $insert_params = [];
        if(count($carrierIds) > count($logistics)){
            $logistics_fillter= data_get($logistics,'*.code');
            $logisticDiff = array_diff($carrierIds, $logistics_fillter);
            $basCustomers = OracleBasCustomer::query()->where('Customer_Type','CA')->whereIn('CustomerID',$logisticDiff)->get();
            foreach ($basCustomers as $basCustomer){
                $fillable = ['name' => $basCustomer['descr_c'], 'code' => $basCustomer['customerid']];
                array_push($insert_params,$fillable);
            }
        }
        try {
            if(count($insert_params) > 0){
                Logistic::query()->insert($insert_params);
                LogService::log(__METHOD__,__FUNCTION__,'批量创建 logistic'.count($insert_params).json_encode($insert_params));
            }
        } catch (\Exception $e) {
            LogService::log(__METHOD__,__FUNCTION__,'创建失败 logistic error' .json_encode($insert_params). $e->getMessage().$e->getTraceAsString());
        } finally {
           return  $logistics = Logistic::query()->whereIn('code',$carrierIds)->get();
        }
    }



    public function firstOrCreate(array $params, array $values = null){
        $logistic = Logistic::query();
        if ($values)return $logistic->firstOrCreate($params, $values);
        return $logistic->firstOrCreate($params);
    }

    public function getByWmsOrders($orderHeaders){
        $codes = data_get($orderHeaders,'*.userdefine1');
        $codes = array_unique($codes);
        $codes = array_diff($codes,['','*',null]);
        if(!$codes){return [];}
        $logistics = Logistic::query()->whereIn('code',$codes)->get();

        if($logistics->count() < $codes){
            $codes = array_diff($codes,data_get($logistics,'*.code'));
            $logistic_list = $this->createLogisticByCarrierIds($codes);
            $logistics = $logistics->concat($logistic_list);
        }
        return $logistics;
    }

    public function createLogisticByCarrierIds($codes){
        if(!$codes){return [];}
        $baseCustomers = OracleBasCustomer::query()
            ->where('Customer_Type','CA')
            ->whereIn('CustomerID',$codes)
            ->get();

        $insert_params = [];
        $created_at = Carbon::now()->format('Y-m-d H:i:s');
        foreach ($baseCustomers as $baseCustomer) {
            $insert_params[] = [
                'code' => $baseCustomer['customerid'],
                'name' => $baseCustomer['descr_c'],
                'created_at' => $created_at
            ];
        }
        try {
            if(count($insert_params) > 0){
                $this->insert($insert_params);
                LogService::log(__METHOD__, __FUNCTION__, '批量创建 owner error' . count($insert_params) . json_encode($insert_params) );
            }
        } catch (\Exception $e) {
            LogService::log(__METHOD__, __FUNCTION__, '批量创建 owner error' . json_encode($insert_params) . "||".$e->getMessage() . '||' . $e->getTraceAsString() );
        } finally {
            return Logistic::query()->whereIn('code',$codes)->get();
        }
    }

    public function insert(array $params){
        return Logistic::query()->insert($params);
    }


}