/**
  * return courses of the given school
  * This Method is used in user Registration
  * @return Response
  */
 public function getCourseFromSchool(Request $request)
 {
     if (!isset($request->school)) {
         return;
     }
     //Validate the Request
     $this->validate($request, ['school' => 'required']);
     $courseSchool = CourseSchool::where('school_id', $request->school)->orderBy('course_id')->get();
     foreach ($courseSchool as $key => $value) {
         //$course[] ='<option value="'.$value->id.'">'.$value->course->name . " ". $value->course->division.'</option>';
         $course[$key]['course_school_id'] = $value->id;
         $course[$key]['course'] = $value->course->id;
         $course[$key]['name'] = $value->course->name;
         $course[$key]['division'] = $value->course->division;
     }
     if (isset($course)) {
         return collect($course)->toJson();
     } else {
         return;
     }
 }
 /**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index()
 {
     if (Auth::user()->hasRole('Staff')) {
         $staffTimetable = StaffTimetable::where('staff_id', Auth::user()->id)->orderBy('period')->get();
         return view('timetable/timetable')->with('staffTimetable', $staffTimetable);
     }
     if (Auth::user()->hasRole('Student')) {
         $studentTimetable = StudentTimetable::where('course_school_id', Auth::user()->details->course_school_id)->orderBy('period')->get();
         return view('timetable/timetable')->with('studentTimetable', $studentTimetable);
     }
     if (Auth::user()->hasRole('Foundation') || Auth::user()->hasRole('SuperAdmin')) {
         $courseSchool = CourseSchool::where('school_id', Auth::user()->school_id)->orderBy('course_id')->get();
         foreach ($courseSchool as $key => $value) {
             $course[$key]['course_school_id'] = $value->id;
             $course[$key]['course'] = $value->course->id;
             $course[$key]['name'] = $value->course->name;
             $course[$key]['division'] = $value->course->division;
         }
         if (isset($course)) {
             return view('timetable/timetable')->with('Course', $course);
         }
     }
     return redirect('home');
 }
 /**
  * Get the course
  */
 public function school()
 {
     return CourseSchool::find($this->course_school_id)->school();
 }