/** * * Enter description here ... * @param Acad_Model_Department $dept * @param string $dateFrom * @param string $degree * @param int $semester */ public function fetchAttendanceDetail(Acad_Model_Department $dept, $dateFrom = null, $degree = null, $semester = null) { if (null == isset($dateFrom)) { $dateFrom = 'CURRENT_DATE'; } $select = $this->getDbTable()->getAdapter()->select()->from('period_attendance', array('staff_id', 'marked_date'))->join('timetable', '`period_attendance`.`timetable_id` = `timetable`.`timetable_id`', array('period.degree_id', 'period.semester_id', 'periods_covered', 'subject_code', 'subject_mode_id', 'group_id'))->join('period', '`timetable`.`period_id` = `period`.`period_id`', array())->where('`period_attendance`.period_date = ?', $dateFrom)->where('timetable.department_id = ?', $dept->getDepartment()); return $select->query()->fetchAll(); }
/** * 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; }
/** * Get Faculty Subjects in hand * @param Acad_Model_Member_Faculty $faculty * @param Acad_Model_Class|Acad_Model_Department $viewLevel = null * @param bool $showModes = null * @return array */ public function fetchInHandSubjects(Acad_Model_Member_Faculty $faculty, $viewLevel = NULL, $showModes = NULL) { $select = $this->getDbTable()->getAdapter()->select(); $select->distinct()->from('period_attendance2', array('subject_code', 'department_id', 'programme_id', 'semester_id'))->where('faculty_id = ?', $faculty->getMemberId()); if (isset($showModes)) { $select->columns('subject_mode_id'); } if ($viewLevel instanceof Acad_Model_Class) { $select->where('department_id = ?', $viewLevel->getDepartment())->where('programme_id = ?', $viewLevel->getProgramme_id())->where('semester_id = ?', $viewLevel->getSemester()); } elseif ($viewLevel instanceof Acad_Model_Department) { $select->where('department_id = ?', $viewLevel->getDepartment()); } return $select->query()->fetchAll(Zend_Db::FETCH_GROUP); }