Esempio n. 1
0
 /**
  * Display the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function show($id)
 {
     $school = School::findOrFail($id);
     $registrations = Pupil::join('registration', 'pupil.id', '=', 'registration.pupil_id')->join('circle', 'registration.circle_id', '=', 'circle.id')->join('subject', 'circle.subject_id', '=', 'subject.id')->where('pupil.school_id', $school->id)->where('circle.year', SessionData::getYear())->get();
     return view('school.show', ['school' => $school, 'registrations' => $registrations]);
 }