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