LessonTeacherCriteria.php 2.4 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879
  1. <?php
  2. namespace App\Repositories\Criteria\School;
  3. use Illuminate\Http\Request;
  4. use Prettus\Repository\Contracts\CriteriaInterface;
  5. use Prettus\Repository\Contracts\RepositoryInterface;
  6. /**
  7. * Class LessonCriteria.
  8. *
  9. * @package namespace App\Repositories\Criteria\School;
  10. */
  11. class LessonTeacherCriteria implements CriteriaInterface
  12. {
  13. private $request;
  14. public function __construct(Request $request = null)
  15. {
  16. if (is_null($request)) {
  17. $this->request = \request();
  18. } else {
  19. $this->request = $request;
  20. }
  21. }
  22. /**
  23. * Apply criteria in query repository
  24. *
  25. * @param string $model
  26. * @param RepositoryInterface $repository
  27. *
  28. * @return mixed
  29. */
  30. public function apply($model, RepositoryInterface $repository)
  31. {
  32. if ($this->request->filled('term_id')) {
  33. $term_id = $this->request->get('term_id');
  34. $model = $model->where('term_id', '=', $term_id);
  35. }
  36. if ($this->request->filled('lesson_name')) {
  37. $lesson_name = $this->request->get('lesson_name');
  38. $model = $model->whereHas('lesson', function ($query) use ($lesson_name) {
  39. return $query->where('name', 'like', "%{$lesson_name}%");
  40. });
  41. }
  42. if ($this->request->filled('teacher_id')) {
  43. $teacher_id = $this->request->get('teacher_id');
  44. $model = $model->where('teacher_id', '=', $teacher_id);
  45. }
  46. if ($this->request->filled('teacher_name')) {
  47. $teacher_name = $this->request->get('teacher_name');
  48. $model = $model->whereHas('teacher', function ($query) use ($teacher_name) {
  49. return $query->where('name', 'like', "%{$teacher_name}%");
  50. });
  51. }
  52. if ($this->request->filled('grade_name')) {
  53. $grade_name = $this->request->get('grade_name');
  54. $model = $model->whereHas('grade', function ($query) use ($grade_name) {
  55. return $query->where('name', 'like', "%{$grade_name}%");
  56. });
  57. }
  58. if ($this->request->filled('status')) {
  59. $status = $this->request->get('status');
  60. $model = $model->where('status', '=', $status);
  61. }
  62. $model = $model->where('term_id', $this->request->header('term-id'));
  63. $model = $model->orderByDesc('id');
  64. return $model;
  65. }
  66. }