MultiWhere.php 1.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950
  1. <?php
  2. /**
  3. * User: Mike
  4. * Email: m@9026.com
  5. * Date: 2017/1/12
  6. * Time: 17:52
  7. */
  8. namespace App\Repositories\User\Criteria;
  9. use App\Repositories\Base\Criteria;
  10. use App\Repositories\Contracts\RepositoryInterface as Repository;
  11. class MultiWhere extends Criteria {
  12. private $search = [];
  13. /**
  14. * MultiWhere constructor.
  15. * @param array $search
  16. *
  17. */
  18. public function __construct(array $search)
  19. {
  20. $this->search = $search;
  21. }
  22. /**
  23. * @param $model
  24. * @param RepositoryInterface $repository
  25. * @return mixed
  26. */
  27. public function apply($model, Repository $repository)
  28. {
  29. if(isset($this->search['keyword']) && $this->search['keyword']) {
  30. $model = $model->where('bank_name','like','%'.$this->search['keyword'].'%')
  31. ->orWhere('bank_number','like','%'.$this->search['keyword'].'%')
  32. ->orWhere('bank_phone','like','%'.$this->search['keyword'].'%')
  33. ->orWhereHas('user', function ($query) {
  34. $query->where('nickname','like','%'.$this->search['keyword'].'%');
  35. })
  36. ;
  37. }
  38. return $model->with('user');
  39. }
  40. }