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