/** * Show the application dashboard to the user. * * @return Response */ public function index() { $doctors = doctors::join('specializations', 'specializations.id', '=', 'doctors.specialization_id_fk')->where('is_active', '!=', '0')->get(); $forapproval = doctors::join('specializations', 'specializations.id', '=', 'doctors.specialization_id_fk')->where('is_active', '=', '0')->get(); $specializations = specializations::all(); $institutions = institutions::all(); return view('doctors', compact('doctors', 'forapproval', 'specializations', 'institutions')); }