RankingCriteria.php 2.6 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091
  1. <?php
  2. namespace App\Repositories\Criteria\Dwbs;
  3. use App\Repositories\Models\Base\Menu;
  4. use App\Repositories\Models\Base\User;
  5. use Illuminate\Http\Request;
  6. use Prettus\Repository\Contracts\CriteriaInterface;
  7. use Prettus\Repository\Contracts\RepositoryInterface;
  8. class RankingCriteria implements CriteriaInterface
  9. {
  10. /**
  11. * @var \Illuminate\Http\Request
  12. */
  13. protected $request;
  14. public function __construct(Request $request)
  15. {
  16. $this->request = $request;
  17. }
  18. /**
  19. * @param $model
  20. * @param RepositoryInterface $repository
  21. *
  22. * @return mixed
  23. */
  24. public function apply($model, RepositoryInterface $repository)
  25. {
  26. if ($this->request->filled('user_mobile')) {
  27. $val = $this->request->get('user_mobile');
  28. $ids = User::byMobileGetIds($val);
  29. $model = $model->whereIn('user_id', $ids);
  30. }
  31. if ($this->request->filled('user_nickname')) {
  32. $val = $this->request->get('user_nickname');
  33. $model = $model->whereHas('user', function ($query) use ($val) {
  34. return $query->where('nickname', 'like', "%{$val}%");
  35. });
  36. }
  37. if ($this->request->filled('day')) {
  38. $val = $this->request->get('day');
  39. $model = $model->where('day', '=', $val);
  40. }
  41. if ($this->request->filled('day_type')) {
  42. $val = $this->request->get('day_type');
  43. $model = $model->where('day_type', '=', $val);
  44. }
  45. if ($this->request->filled('name')) {
  46. $val = $this->request->get('name');
  47. $model = $model->where('name', 'like', "%{$val}%");
  48. }
  49. if ($this->request->filled('status')) {
  50. $status = $this->request->get('status');
  51. $model = $model->where('status', '=', $status);
  52. }
  53. if ($this->request->filled('ids')) {
  54. $ids = $this->request->get('ids');
  55. $model = $model->whereIn('id', $ids);
  56. }
  57. if (!$this->request->filled('orderBy')) {
  58. $model = $model->orderByDesc('id');
  59. }
  60. if (!isAdminModule()) {
  61. $model = $model->where('user_id', login_user_id());
  62. } else {
  63. if (Menu::checkUserIsBtn(151)) {
  64. //全部数据
  65. } elseif (Menu::checkUserIsBtn(150)) {
  66. $admin = login_admin();
  67. $model = $model->whereHas('user', function ($q) use ($admin) {
  68. return $q->where('kefu_tag', $admin['user_tag']);
  69. });
  70. } else {
  71. $model = $model->where('id', 0);
  72. }
  73. }
  74. return $model;
  75. }
  76. }