public function classroomattendance(ClassroomSession $ClassroomSessionModel, $id)
{
# code...
$session = $ClassroomSessionModel->inCurrentSemester()->with('classroom')->findOrFail($id);
// if($session->wiziq_status=='completed' && !ClassroomSessionAttendance::where('classroom_session_id', $session->id)->count()) {
// $this->generateReport($session);
// }
$attendances = ClassroomSessionAttendance::where('classroom_session_id', $session->id)->orderBy('teacher_id', 'desc')->get();
return view('teachers::profile.classrooms.attendance', compact('attendances', 'session'));
}
public function show(ClassroomSession $ClassroomSessionModel, $id)
{
$session = $ClassroomSessionModel->inCurrentSemester()->with('classroom')->findOrFail($id);
// if($session->wiziq_status=='completed' && !ClassroomSessionAttendance::where('classroom_session_id', $session->id)->count()) {
// $this->generateReport($session);
// }
$attendances = ClassroomSessionAttendance::where('classroom_session_id', $session->id)->orderBy('teacher_id', 'desc')->get();
$attendancesCount = ClassroomSessionAttendance::selectRaw('SUM(IF(valid=0 ,1,0)) AS absent , SUM(IF(valid=1 ,1,0)) AS attend')->where('classroom_session_id', $session->id)->orderBy('teacher_id', 'desc')->first();
return view('classrooms::sessions.show', compact('attendances', 'session', 'attendancesCount'));
}
