request = \request(); } else { $this->request = $request; } } /** * Apply criteria in query repository * * @param string $model * @param RepositoryInterface $repository * * @return mixed */ public function apply($model, RepositoryInterface $repository) { if ($this->request->filled('name')) { $name = $this->request->get('name'); $model = $model->where('name', 'like', "%{$name}%"); } if ($this->request->filled('term_id')) { $term_id = $this->request->get('term_id'); $model = $model->where('term_id', '=', $term_id); } if ($this->request->filled('category_id')) { $category_id = $this->request->get('category_id'); $model = $model->where('category_id', '=', $category_id); } if ($this->request->filled('teacher_id')) { $teacher_id = $this->request->get('teacher_id'); $model = $model->where('teacher_id', '=', $teacher_id); } if ($this->request->filled('no')) { $no = $this->request->get('no'); $model = $model->where('no', 'like', "%{$no}%"); } if ($this->request->filled('status')) { $status = $this->request->get('status'); $model = $model->where('status', '=', $status); } $model = $model->orderByDesc('id'); return $model; } }