/** * 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]); }