baoshi-was/app/Services/ProcurementService.php

<?php

namespace App\Services;

use App\Owner;
use App\Procurement;
use App\Services\common\QueryService;
use Illuminate\Support\Facades\Auth;
use App\Traits\ServiceAppAop;


class ProcurementService
{
    use ServiceAppAop;

    private function conditionQuery(array $param){
        $owner_ids=app('UserService')->getPermittingOwnerIds(auth()->user());
        $procurements = Procurement::with(['initiator','ownerMaterial.material','ownerMaterial.owner'=>function($query)use($owner_ids){
            $query->with('customer')->whereIn('id',$owner_ids);
        }]);
        $columnQueryRules=[
            'owner_id' => ['multi' => ','],
            'material_id' => ['multi' => ','],
            'supplier_id' => ['multi' => ','],
            'company_name' => ['like' => ','],
            'created_at_start' => ['alias' => 'created_at' , 'startDate' => ':00'],
            'created_at_end' => ['alias' => 'created_at' , 'endDate' => ':59'],
        ];
        $procurements = app(QueryService::class)->query($param,$procurements,$columnQueryRules,"procurements");
        return $procurements;
    }

    public function paginate(array $param){
        $procurements = $this->conditionQuery($param);
        return $procurements->paginate($param['paginate'] ?? 50);
    }
}