UserRepository.php 1.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647
  1. <?php
  2. /**
  3. * 用户管理
  4. * @author system
  5. * @version 1.0
  6. * @date 2018-05-14 13:25:12
  7. *
  8. */
  9. namespace App\Repositories\Album;
  10. use App\Repositories\Base\Repository;
  11. class UserRepository extends Repository {
  12. public function model() {
  13. return \App\Models\AlbumUserModel::class;
  14. }
  15. public function searchUser(array $search,array $orderby=['id'=>'desc'],$pagesize=10)
  16. {
  17. $currentQuery = $this->model;
  18. if(isset($search['keyword']) && ! empty($search['keyword'])) {
  19. $keywords = '%' . $search['keyword'] . '%';
  20. $currentQuery = $currentQuery->where(function ($query) use ($keywords) {
  21. $query->where('username' , 'like', $keywords)
  22. ->orwhere('phone', 'like', $keywords)
  23. ->orwhere('wechat_open_id', 'like', $keywords);
  24. });
  25. }
  26. // dd($orderby);
  27. $currentQuery = $currentQuery->where(function ($query) use ($search) {
  28. $query->where('store_id',$search['storeid']);
  29. });
  30. if($orderby && is_array($orderby)){
  31. foreach ($orderby AS $field => $value){
  32. //dd($orderby);
  33. $currentQuery = $currentQuery -> orderBy($field, $value);
  34. }
  35. }
  36. $currentQuery = $currentQuery->paginate($pagesize);
  37. return $currentQuery;
  38. }
  39. }