/** * Display a listing of the resource. * * @return Response */ public function index() { if (Request::get('q')) { $records = User::select('id', 'name', 'email', DB::raw("MATCH(name, email) AGAINST (? IN BOOLEAN MODE) AS score"))->whereRaw("MATCH(name, email) AGAINST (? IN BOOLEAN MODE)")->setBindings([Request::get('q'), Request::get('q')])->orderBy('score', 'desc')->paginate(10); } else { $records = User::paginate(10); } return view('back::scope.system.users.index', compact('records')); }