Advertisement
Guest User

Untitled

a guest
Mar 29th, 2017
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. function scopeSearch($query,IlluminateHttpRequest $request){
  2. if($request->has('role')) {
  3. $role = Role::find($request->get('role'));
  4. $usersID = $role->users()->pluck('id')->toArray();
  5. $query->whereIn('id',$usersID);
  6. }
  7.  
  8. if($request->has('id')) {
  9. $query->where('id','like','%'.$request->get('id').'%');
  10. }
  11.  
  12. if($request->has('name')) {
  13. $query->where('name','like','%'.$request->get('name').'%');
  14. }
  15.  
  16. if($request->has('email')) {
  17. $query->where('email','like','%'.$request->get('email').'%');
  18. }
  19.  
  20. if($request->has('phone')) {
  21. $query->where('phone','like','%'.$request->get('phone').'%');
  22. }
  23.  
  24. return $query;
  25. }
  26.  
  27. /**
  28. * Список пользователей
  29. *
  30. * @param Request $request
  31. * @return IlluminateHttpJsonResponse
  32. */
  33. function index(Request $request)
  34. {
  35. $user = User::search($request)->paginate(50);
  36.  
  37. return response()->json($user);
  38. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement