/** @Note : Not in use till now * All slave Department, Degree, Semesters */ public static function slaveInfo($masterDepartment, $currentSession = NULL, $degree = FALSE, $semester = FALSE) { $sql = self::getDefaultAdapter()->select()->distinct()->from(self::TABLE_NAME, 'department_id')->where('handled_by_dept = ?', $masterDepartment); if ($currentSession) { $sessionType = Core_Model_DbTable_AcademicSession::currentSessionType(); $sql->where('`semester_type_id` = ?', $sessionType); } if ($degree) { $sql->columns('degree_id'); } if ($semester) { $sql->columns('semester_id'); } return $sql->query()->fetchAll(); }
/** * Show information about current semester session */ public function getsessioninfoAction() { $request = $this->getRequest(); $format = $request->getParam('format', 'json'); $result = Core_Model_DbTable_AcademicSession::currentSessionInfo(); switch (strtolower($format)) { case 'json': $this->_helper->json($result); return; case 'select': /* echo '<select>'; echo '<option>Select one</option>'; foreach ( $result as $key => $row ) { echo '<option value="' . $row ['batch_start'] . '">' . $row ['batch_start'] . '</option>'; } echo '</select>';*/ return; default: $this->getResponse()->setException('Unsupported format request')->setHttpResponseCode(400); } }
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; }