/** * Fetches all the entries for perticular sessional * * @param Acad_Model_Test_Sessional * @return array Acad_Model_Test_Sessional */ public function fetchAll(Acad_Model_Test_Sessional $sessional) { //$logger = Zend_Registry::get('logger'); $sql = $this->getDbTable()->getDefaultAdapter()->select()->from($this->getDbTable()->info('name'))->joinInner('subject', '`test_info`.`subject_code` = `subject`.`subject_code`', 'subject_name')->where('department_id = ?', $sessional->getDepartment_id())->where('test_type_id = ?', $sessional->getTest_type_id()); //->where('date_of_conduct > CURRENT_DATE'); if ($sessional->getTest_id()) { $sql->where('test_id =?', $sessional->getTest_id()); } if ($sessional->getSemester_id()) { $sql->where('semester_id = ?', $sessional->getSemester_id()); } $resultSet = $sql->query()->fetchAll(); //$logger->debug($resultSet); if ($resultSet != NULL) { $entries = array(); foreach ($resultSet as $row) { $entry = new Acad_Model_Test_Sessional(); $entry->setOptions($row)->setMapper($this); $entries[] = $entry; } return $entries; } else { return null; } }