public function dashboard() { $doctor = auth()->user(); //Get last 10 reports assigned to this doctor $reports = Reports::count(); $doctorsIds = AssignedRole::where('role_id', 3)->lists('user_id'); $patientsIds = AssignedRole::where('role_id', 2)->lists('user_id'); //Get total of all $patients = User::whereIn('id', $patientsIds)->count(); $doctors = User::whereIn('id', $doctorsIds)->count(); $all_patients_details = User::whereIn('users.id', $patientsIds)->join('user_profiles', 'user_profiles.user_id', '=', 'users.id')->paginate(15); $all_doctors_details = User::whereIn('users.id', $doctorsIds)->leftJoin('doctors_specializations', 'doctors_specializations.id', '=', 'users.specialization_id')->paginate(15, ['*', 'users.name AS doctorName', 'users.id as user_id']); $data = ['total_doc' => $doctors, 'total_patients' => $patients, 'total_reports' => $reports, 'patients' => $all_patients_details, 'doctors' => $all_doctors_details]; return view('frontend.management.dashboard', $data); }