function payslip()
{
global $mainframe;
$db =& JFactory::getDBO();
$filter_order = $mainframe->getUserStateFromRequest($option . 'filter_order', 'filter_order', 'id', 'cmd');
$filter_order_Dir = $mainframe->getUserStateFromRequest($option . 'filter_order_Dir', 'filter_order_Dir', '', 'word');
$filter_state = $mainframe->getUserStateFromRequest($option . 'filter_state', 'filter_state', '', 'word');
$users = $mainframe->getUserStateFromRequest($option . 'users', 'users', '', 'int');
$month = $mainframe->getUserStateFromRequest($option . 'month', 'month', '', 'int');
$year = $mainframe->getUserStateFromRequest($option . 'year', 'year', '', 'int');
$limit = $mainframe->getUserStateFromRequest('global.list.limit', 'limit', $mainframe->getCfg('list_limit'), 'int');
$limitstart = $mainframe->getUserStateFromRequest($option . '.limitstart', 'limitstart', 0, 'int');
$where = array();
if ($users) {
$where[] = 'users_id="' . $users . '"';
}
if ($month) {
$where[] = 'month="' . $month . '"';
}
if ($year) {
$where[] = 'year="' . $year . '"';
}
$where = count($where) ? ' WHERE ' . implode(' AND ', $where) : '';
if ($filter_order == 'id') {
$orderby = ' ORDER BY id';
} else {
$orderby = ' ORDER BY ' . $filter_order . ' ' . $filter_order_Dir . ', id';
}
// get the total number of records
$query = 'SELECT COUNT(*)' . ' FROM #__intranet_payslip' . $where;
$db->setQuery($query);
$total = $db->loadResult();
jimport('joomla.html.pagination');
$pageNav = new JPagination($total, $limitstart, $limit);
$query = "SELECT * FROM #__intranet_payslip" . $where . $orderby;
$db->setQuery($query, $pageNav->limitstart, $pageNav->limit);
$rows = $db->loadObjectList();
if ($db->getErrorNum()) {
echo $db->stderr();
return false;
}
// table ordering
$lists['order_Dir'] = $filter_order_Dir;
$lists['order'] = $filter_order;
// search filter
$lists['users'] = $users;
$lists['month'] = $month;
$lists['year'] = $year;
IntranetHTML::payslip(&$rows, &$pageNav, &$lists);
}
IntranetHTML::dailyattendance();
break;
case 'leaverequest':
IntranetHTML::leaverequest();
break;
case 'leaves':
IntranetHTML::leaves();
break;
case 'newrequest':
IntranetHTML::newrequest();
break;
case 'requestsave':
requestsave();
break;
case 'payslip':
IntranetHTML::payslip();
break;
}
function newattendance()
{
$db =& JFactory::getDBO();
$users_id = $_POST['users_id'];
$name = $_POST['name'];
$today_date = $_POST['today_date'];
$in_time = $_POST['in_time'];
$month = $_POST['month'];
$year = $_POST['year'];
$url = $_POST['url'];
$query = "insert into #__intranet_dailyattendance (`users_id`, `name`, `today_date`, `in_time`, `out_time`, `month`, `year`, `total_hours`) values ('{$users_id}', '{$name}', '{$today_date}', '{$in_time}', '', '{$month}', '{$year}', '')";
$db->setQuery($query);
$db->query();
