public function create() { $sessions = ClassroomSession::with('classroom', 'classroom.subject')->whereHas('attendances', function ($query) { return $query->where('student_id', student()->id)->where('valid', 0); })->get(); $options = []; foreach ($sessions as $session) { $title = $session->classroom->code . " :: " . $session->classroom->subject->name . " :: " . $session->title; $options[$session->id] = $title; } return view("students::orders.sessionexcuses.create", compact('sessions', 'options')); }
public function exportteachertable(Request $request) { $sessions = ClassroomSession::with(['teacher', 'classroom', 'subject']); if ($request->has('teacher_id')) { $sessions->whereHas('teacher', function ($q) use($request) { $q->where('id', $request->input('teacher_id')); }); } $sessions = $sessions->get(); Excel::create('sessions', function ($excel) use($sessions) { $excel->sheet('teacher_table', function ($sheet) use($sessions) { $sheet->loadView('classrooms::reports.exportteachertable', compact('sessions', 'teachers')); }); })->download('xlsx'); }