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 ($title = $this->request->get('title')) { $model = $model->where('title', 'like', "%{$title}%"); } if (($status = $this->request->get('status', false)) !== false) { $model = $model->where('status', '=', $status); } if ($course_id = $this->request->get('course_id')) { $model = $model->where('course_id', '=', $course_id); } if ($course_chapter_id = $this->request->get('course_chapter_id')) { $model = $model->where('course_chapter_id', '=', $course_chapter_id); } $model = $model->orderByDesc('sort')->orderBy('id'); return $model; } }