| 123456789101112131415161718192021222324252627282930313233 |
- <?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);
- }
- }
|