VideoCriteria.php 1.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
  1. <?php
  2. namespace App\Repositories\Criteria\Course;
  3. use Illuminate\Http\Request;
  4. use Prettus\Repository\Contracts\CriteriaInterface;
  5. use Prettus\Repository\Contracts\RepositoryInterface;
  6. /**
  7. * Class CourseVideoCriteria.
  8. *
  9. * @package namespace App\Repositories\Criteria;
  10. */
  11. class VideoCriteria implements CriteriaInterface
  12. {
  13. public function __construct(Request $request = null)
  14. {
  15. if (is_null($request)) {
  16. $this->request = \request();
  17. } else {
  18. $this->request = $request;
  19. }
  20. }
  21. /**
  22. * Apply criteria in query repository
  23. *
  24. * @param string $model
  25. * @param RepositoryInterface $repository
  26. *
  27. * @return mixed
  28. */
  29. public function apply($model, RepositoryInterface $repository)
  30. {
  31. if ($this->request->filled('title')) {
  32. $title = $this->request->get('title');
  33. $model = $model->where('title', 'like', "%{$title}%");
  34. }
  35. if ($this->request->filled('status')) {
  36. $status = $this->request->get('status', false);
  37. $model = $model->where('status', '=', $status);
  38. }
  39. if ($this->request->filled('course_id')) {
  40. $course_id = $this->request->get('course_id');
  41. $model = $model->where('course_id', '=', $course_id);
  42. }
  43. if ($this->request->filled('course_chapter_id')) {
  44. $course_chapter_id = $this->request->get('course_chapter_id');
  45. $model = $model->where('course_chapter_id', '=', $course_chapter_id);
  46. }
  47. if (!$this->request->filled('orderBy')) {
  48. $model = $model->orderByDesc('sort')->orderBy('id');
  49. }
  50. return $model;
  51. }
  52. }