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