baoshi-was/app/Services/OrderService.php

<?php

namespace App\Services;


use App\Commodity;
use App\Logistic;
use App\OracleBasCustomer;
use App\OracleDOCOrderHeader;
use App\Order;
use App\OrderItems;
use App\Owner;
use App\Shop;

class OrderService
{
    public function __construct()
    {
        app()->bind("orderPackageService", OrderPackageService::class);
    }

    public function createOrFindBy($oracleOrderNo)
    {
        $order = Order::where('code', $oracleOrderNo)->first();
        $orderHeader = OracleDOCOrderHeader::where('OrderNo', trim($oracleOrderNo, "'"))->first();
        if ($orderHeader == null) {
            return null;
        }
        $orderHeadAttr = $orderHeader->toArray();
        if ($order == null) {

            $customer_name = $orderHeadAttr['oracleBASCustomer_descr_c'];
            $owner = Owner::firstOrCreate(['name' => $customer_name, 'code' => $orderHeadAttr['customerid']]);
            $owner_id = $owner->id;

            $shop_name = $orderHeadAttr['issuepartyname'];
            $shop_Id = null;
            if ($shop_name) {
                $shop = Shop::firstOrCreate(['name' => $shop_name, 'owner_id' => $owner_id]);
                $shop_Id = $shop->id;
            }

            $logistics = Logistic::where(['name' => $orderHeadAttr['carrierid']])->first();
            if ($logistics == null) {
                $oracleBasCustomer = OracleBasCustomer::where(['CustomerID' => $orderHeadAttr['carrierid'], 'Customer_Type' => 'CA'])->first();
                if ($oracleBasCustomer) {
                    $logistics = Logistic::firstOrCreate(['code' => $oracleBasCustomer->customerid, 'name' => $oracleBasCustomer->descr_c]);
                }
            }
            $logistics_id = null;
            if ($logistics) {
                $logistics_id = $logistics->id;
            }
            $arr = [
                'code' => $orderHeadAttr['orderno'],
                'owner_id' => $owner_id,
                'wms_status' => $orderHeadAttr['oracleBASCode_codename_c'],
                'created_at' => $orderHeadAttr['addtime'],
                'logistic_id' => $logistics_id,
                'shop_id' => $shop_Id,
                'consignee_name' => $orderHeadAttr['c_contact'],
                'consignee_phone' => $orderHeadAttr['c_tel2'],
                'province' => $orderHeadAttr['c_province'],
                'city' => $orderHeadAttr['c_city'],
                'district' => $orderHeadAttr['c_district'],
                'address' => $orderHeadAttr['c_address1'],
            ];
            $order = Order::create($arr);
        }
        $orderPackageService = app('orderPackageService');
        $orderPackageService->createOrFindBy($order, $orderHeader);
        return $order;
    }


}