OrganizationCriteria.php 2.5 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283
  1. <?php
  2. namespace App\Repositories\Criteria\Course;
  3. use App\Repositories\Enums\ModelStatusEnum;
  4. use Illuminate\Http\Request;
  5. use Prettus\Repository\Contracts\CriteriaInterface;
  6. use Prettus\Repository\Contracts\RepositoryInterface;
  7. /**
  8. * Class OrganizationCriteria.
  9. *
  10. * @package namespace App\Repositories\Criteria\Course;
  11. */
  12. class OrganizationCriteria implements CriteriaInterface
  13. {
  14. /**
  15. * Apply criteria in query repository
  16. *
  17. * @param string $model
  18. * @param RepositoryInterface $repository
  19. *
  20. * @return mixed
  21. */
  22. public function __construct(Request $request = null)
  23. {
  24. if (is_null($request)) {
  25. $this->request = \request();
  26. } else {
  27. $this->request = $request;
  28. }
  29. }
  30. /**
  31. * Apply criteria in query repository
  32. *
  33. * @param string $model
  34. * @param RepositoryInterface $repository
  35. *
  36. * @return mixed
  37. */
  38. public function apply($model, RepositoryInterface $repository)
  39. {
  40. if ($this->request->filled('name')) {
  41. $name = $this->request->get('name');
  42. $model = $model->where('name', 'like', "%{$name}%");
  43. }
  44. if ($this->request->filled('status')) {
  45. $status = $this->request->get('status');
  46. $model = $model->where('status', '=', $status);
  47. } else {
  48. $model = $model->where('status', '=', ModelStatusEnum::OK);
  49. }
  50. if ($this->request->filled('is_issue')) {
  51. $is_issue = $this->request->get('is_issue');
  52. $model = $model->where('is_issue', '=', $is_issue);
  53. }
  54. if ($this->request->filled('is_release')) {
  55. $is_release = $this->request->get('is_release');
  56. $model = $model->where('is_issue', '=', $is_release);
  57. }
  58. // if ($this->request->filled('category_id')) {
  59. // $category_id = $this->request->get('category_id', false);
  60. // $model = $model->where('category_id', '=', $category_id);
  61. // }
  62. if ($this->request->filled('is_teacher_me') && $this->request->get('is_teacher_me')) {
  63. $model = $model->where('coordinator_id', '=', login_user_id());
  64. }
  65. if ($this->request->filled('is_me') && $this->request->get('is_me')) {
  66. $model = $model->whereHas('student', function ($query) {
  67. return $query->where('user_id', login_user_id());
  68. });
  69. }
  70. $model = $model->orderByDesc('id');
  71. return $model;
  72. }
  73. }