public static function getCurrentSessionHolidays() { $session_startdate = Core_Model_DbTable_AcademicSession::getSessionStartDate(); $session_enddate = Core_Model_DbTable_AcademicSession::getSessionEndDate(); $sql = self::getDefaultAdapter()->select()->from('holiday', array('date_from', 'date_upto', 'purpose'))->where('date_from >= ? ', $session_startdate)->where('date_from <= CURRENT_DATE() '); $holiday = $sql->query()->fetchAll(); $dates = array(); $cnt = 0; foreach ($holiday as $key => $value) { $start_date = $value['date_from']; $end_date = $value['date_upto']; $objstart = new Zend_Date($start_date, Zend_Date::ISO_8601); $objenddate = new Zend_Date($end_date, Zend_Date::ISO_8601); while (!$objstart->isLater($objenddate)) { $dates[$cnt++] = $objstart->get(Zend_date::YEAR) . '-' . $objstart->get(Zend_date::MONTH) . '-' . $objstart->get(Zend_date::DAY) . '-' . $value['purpose']; $objstart->addDay(1); } $objstart = NULL; $objenddate = NULL; } return $dates; }