/**
* 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;
}
}
