function calendar() { global $mainframe; $db =& JFactory::getDBO(); if ($_REQUEST["month"] == '') { $month = date("m"); } else { $month = $_REQUEST["month"]; $months = strlen($month); if ($months == 2) { $month = $month; } else { $mth = 0; $month = $mth . $month; } } if ($_REQUEST["year"] == '') { $year = date("Y"); } else { $year = $_REQUEST["year"]; } $date = $year . "-" . $month . "-%"; $query = "select a.* from #__intranet_calendar as a where a.date like '" . $date . "'"; $db->setQuery($query); $rows = $db->loadObjectList(); $query = "select b.* from #__intranet_calendarweeklyoff as b where b.date like '" . $date . "'"; $db->setQuery($query); $rows1 = $db->loadObjectList(); if ($db->getErrorNum()) { echo $db->stderr(); return false; } IntranetHTML::calendar(&$rows, &$rows1); }
<?php defined('_JEXEC') or die('Restricted access'); $document =& JFactory::getDocument(); $document->addStyleSheet('components/com_intranet/css/intranet.css'); require_once JApplicationHelper::getPath('html'); $task = JRequest::getVar('task', '', "REQUEST"); switch ($task) { default: IntranetHTML::calendar(); break; case 'calendar': IntranetHTML::calendar(); break; case 'newattendance': newattendance(); break; case 'oldattendance': oldattendance(); break; case 'attendance': IntranetHTML::attendance(); break; case 'weeklyattendance': IntranetHTML::weeklyattendance(); break; case 'dailyattendance': IntranetHTML::dailyattendance(); break; case 'leaverequest': IntranetHTML::leaverequest();