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