public function index(Request $request) { // canOne(['view.students.students', 'contact.students.students'] // dd(Auth::user()->canOne(['notes.index.quran','elements.index.quran'])); $users = User::select('users.*')->with('quran_subjects', 'quran_students')->join('role_user', 'users.id', '=', 'role_user.user_id')->join('roles', function ($join) { $join->on('role_user.role_id', '=', 'roles.id')->where('roles.name', 'LIKE', '%القرآن الكريم%'); }); if ($request->has('name')) { $users->where('users.id', $request->input('name')); } elseif ($request->has('mobile')) { $users->where('mobile', $request->input('mobile')); } $users = $users->paginate(20); // return ($users); $names = User::select('users.*')->with('quran_subjects', 'quran_students')->join('role_user', 'users.id', '=', 'role_user.user_id')->join('roles', function ($join) { $join->on('role_user.role_id', '=', 'roles.id')->where('roles.name', 'LIKE', '%القرآن الكريم%'); })->pluck('name', 'id')->toArray(); $mobiles = User::pluck('mobile', 'id')->toArray(); return view('quran::evaluators.index', compact('users', 'names', 'mobiles')); }