<?php 

namespace App\Services; 

use App\Services\common\QueryService;
use App\StoreCheckingReceive;
use Illuminate\Database\Eloquent\Builder;

Class StoreCheckingReceiveService
{
    /**
     * @param Builder $query
     * @param array $params
     * @return Builder
     */
    private function conditionQuery(Builder $query,array $params){
        $columnQueryRules=[
            'created_at_start' => ['alias' => 'created_at' , 'startDate' => ' 00:00:00'],
            'created_at_end' => ['alias' => 'created_at' , 'endDate' => ' 23:59:59'],
            'owner_id' => ['multi' => ','],
            'id' => ['multi' => ',']
        ];
        return app(QueryService::class)->query($params,$query,$columnQueryRules);
    }

    public function paginate(array $params){
        $query = StoreCheckingReceive::query();
        $query->with('owner');
        $query = $this->conditionQuery($query, $params);
        return $query->paginate($params['paginate'] ?? 50);
    }


    public function create(array $params){
        return StoreCheckingReceive::query()->create($params);
    }

    public function find($id){
        return StoreCheckingReceive::query()->with(['storeCheckingReceiveItems'=>function($query){
            $query->with(['commodity'=>function($builder){
                $builder->with('barcodes');
            }]);
        }])->find($id);
    }
}