public function indexAction() { $dbtable = new Acad_Model_DbTable_StudentAttendance2(); $result = $dbtable->stats('CSE', 'BTECH'); echo "<pre>"; print_r($result); }
/** * An semesterwise overview of student attendance. * @param Acad_Model_Department $department * @param string $programme * @param date_string $date_from * @param date_string $date_upto * @param int $semester */ public function fetchAttendance(Acad_Model_Department $department, $programme = NULL, $date_from = NULL, $date_upto = NULL, $semester = null) { $dept = $department->getDepartment(); $studentAttendance = new Acad_Model_DbTable_StudentAttendance2(); $order = array('semester_id', 'subject_mode_id', 'subject_code', 'group_id'); $rawResult = $studentAttendance->stats($dept, $programme, $semester, null, null, null, $date_from, $date_upto, true, $order); $processed = array(); foreach ($rawResult as $department_id => $attendanceList) { foreach ($attendanceList as $key => $attendance) { $subjectCode = $attendance['subject_code']; $subjectMode = $attendance['subject_mode_id']; $group_id = $attendance['group_id']; $semester_id = $attendance['semester_id']; unset($attendance['subject_code']); unset($attendance['subject_mode_id']); unset($attendance['group_id']); unset($attendance['semester_id']); $processed[$semester_id][$subjectMode][$subjectCode][$group_id][] = $attendance; } } return $processed; }