<?php

namespace App\Services;

use App\OracleDOCOrderDetail;
use App\OracleDOCOrderHeader;
use App\Owner;

Class OracleDOCOrderHeaderService
{

    function first(array $params){
        $order = OracleDOCOrderHeader::query();
        foreach ($params as $column => $value){
            $order->where($column, $value);
        }
        return $order->first();
    }
    public function 根据时间获取在这段时间内创建的WMS订单($startDate){
        /** @var OwnerService $ownerService */
        $ownerService = app('ownerService');
        $owners = $ownerService->获取订单跟踪的货主();
        $ownerIds = data_get($owners, '*.code');
        return OracleDOCOrderHeader::query()
            ->with(['oracleDOCOrderDetails', 'actAllocationDetails','oracleBASCode'])
            ->where('addtime', '>=', $startDate)
            ->whereIn('customerID', $ownerIds)
            ->get();
    }

    public function 根据时间获取在这段时间内更新的WMS订单($startDate){
        /** @var OwnerService $ownerService */
        $ownerService = app('ownerService');
        $owners = $ownerService->获取订单跟踪的货主();
        $ownerIds = data_get($owners, '*.code');
        return OracleDOCOrderHeader::query()
            ->with(['oracleDOCOrderDetails', 'actAllocationDetails','oracleBASCode'])
            ->where('EditTime','>=',$startDate)
            ->whereColumn('EditTime','<>','addtime')
            ->whereIn('customerID', $ownerIds)
            ->get();
    }

    public function getWmsOrderOnStartDateCreate($startDate){
        /** @var Owner $owners */
        $owners = app(OrderTrackingOwnerService::class)->getTrackingOrderOwner();
        return OracleDOCOrderHeader::query()
            ->with(['oracleDOCOrderDetails', 'actAllocationDetails','oracleBASCode'])
            ->where('addTime','>=',$startDate)
            ->whereIn('customerID',data_get($owners,'*.code'))
            ->get();
    }

    public function getWmsOrderOnStartDateEdit($startDate){
        /** @var Owner $owners */
        $owners = app(OrderTrackingOwnerService::class)->getTrackingOrderOwner();
        return OracleDOCOrderHeader::query()
            ->with(['oracleDOCOrderDetails', 'actAllocationDetails','oracleBASCode'])
            ->where('EditTime','>=',$startDate)
            ->whereColumn('EditTime','<>','addTime')
            ->whereIn('customerID',data_get($owners,'*.code'))
            ->get();
    }

}