public function run() { DB::table('specializations')->delete(); specializations::create(['name' => 'Drugstore Signatory']); specializations::create(['name' => 'Eye, Nose, Throat specialist']); specializations::create(['name' => 'Family Medicine']); specializations::create(['name' => 'General Practitioner']); specializations::create(['name' => 'Internist']); specializations::create(['name' => 'Cardiologist']); specializations::create(['name' => 'Diabetologist']); specializations::create(['name' => 'Endocrinologist']); specializations::create(['name' => 'Gastro-enterologist']); specializations::create(['name' => 'Nephrologist']); specializations::create(['name' => 'Midwife']); specializations::create(['name' => 'OB-Gynecologist']); specializations::create(['name' => 'Pediatrician']); specializations::create(['name' => 'Registered Nurse']); specializations::create(['name' => 'Surgeon']); specializations::create(['name' => 'Urologist']); specializations::create(['name' => 'AGRIVET']); specializations::create(['name' => 'GENERAL SURGERY']); specializations::create(['name' => 'RHU']); specializations::create(['name' => 'GENERIC']); specializations::create(['name' => 'IM-NEURO']); specializations::create(['name' => 'ROD']); specializations::create(['name' => 'ATTENDANCE']); }
/** * 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')); }
/** * Update the specified resource in storage. * * @param int $id * @return Response */ public function update(Request $request) { $input = $request->all(); $specialization = specializations::whereid($request->get('id'))->first(); $specialization->name = ucfirst($input['name']); if ($specialization->save()) { return Redirect::back()->withFlash_message(['msg' => ' Specialization successfully Updated', 'type' => 'success']); } return false; }