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);
}
