baoshi-was/app/Services/InventoryService.php

<?php


namespace App\Services;

use App\Commodity;
use App\Http\Controllers\Controller;
use App\Inventory;
use App\inventoryDailyLog;
use App\InventoryDailyLoggingOwner;
use App\InventoryMission;
use App\OraccleBasCustomer;
use App\OracleActTransactionLog;
use App\Owner;
use App\Services\common\QueryService;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Gate;

class InventoryService
{

    //库存体积条件
    private function conditionQueryDailyLog(array $param){
        $inventoryDailyLogs = InventoryDailyLog::query()->with(['owner','commodity'=>function($query){
            $query->with('barcodes');
        }])->orderByDesc('id');
        $columnQueryRules=[
            'owner_id' => ['multi' => ','],
            'created_at_start' => ['alias' => 'created_at' , 'startDate' => ' 00:00:00'],
            'created_at_end' => ['alias' => 'created_at' , 'endDate' => ' 23:59:59'],
        ];
        $inventoryDailyLogs = app(QueryService::class)->query($param,$inventoryDailyLogs,$columnQueryRules);
        return $inventoryDailyLogs;

    }

    //库存体积
    public function getInventoryDailyLog(array $param){
        return $this->conditionQueryDailyLog($param)->paginate($param['paginate'] ?? 50);
    }

    //获取开启监听记录货主
    public function getInventoryDailyLoggingOwner($column = ['id','owner_id'], $status = "启用"){
        if (!is_array($column)) {
            $column = [$column];
        }
        return InventoryDailyLoggingOwner::query()->select($column)->where('status',$status)->get();
    }

    //录入监听记录货主
    public function firstOrCreate($param,$column = null){
        if ($column)return InventoryDailyLoggingOwner::query()->firstOrCreate($param,$column);
        return InventoryDailyLoggingOwner::query()->firstOrCreate($param);
    }
}