if (isset($_REQUEST["key"])) {
switch (strtolower($_REQUEST["key"])) {
case "emp":
$OUTPUT = slctEmployee();
break;
case "slip":
$OUTPUT = slip($_REQUEST);
break;
case "export to spreadsheet":
$OUTPUT = export($_REQUEST);
break;
default:
$OUTPUT = slctDate();
}
} else {
$OUTPUT = slctDate();
}
# display output
require "template.php";
function slctEmployee()
{
db_connect();
#check what we have permission to
$get_perm = "SELECT payroll_groups FROM users WHERE username = '******'USER_NAME']}' LIMIT 1";
$run_perm = db_exec($get_perm) or errDie("Unable to get payroll groups permission information.");
if (pg_numrows($run_perm) > 0) {
$parr = pg_fetch_array($run_perm);
if (strlen($parr['payroll_groups']) > 0) {
$pay_grps = explode(",", $parr['payroll_groups']);
if (is_array($pay_grps)) {
$egsearch = " AND (emp_group = '" . implode("' OR emp_group = '", $pay_grps) . "')";
function slip($_POST)
{
# get vars
extract($_POST);
# validate input
require_lib("validate");
$v = new validate();
if (isset($from_day)) {
$v->isOk($from_day, "num", 1, 2, "Invalid from Date day.");
$v->isOk($from_month, "num", 1, 2, "Invalid from Date month.");
$v->isOk($from_year, "num", 1, 4, "Invalid from Date Year.");
$v->isOk($to_day, "num", 1, 2, "Invalid to Date day.");
$v->isOk($to_month, "num", 1, 2, "Invalid to Date month.");
$v->isOk($to_year, "num", 1, 4, "Invalid to Date Year.");
# mix dates
$fromdate = $from_year . "-" . $from_month . "-" . $from_day;
$todate = $to_year . "-" . $to_month . "-" . $to_day;
if (!checkdate($from_month, $from_day, $from_year)) {
$v->isOk($fromdate, "num", 1, 1, "Invalid from date.");
}
if (!checkdate($to_month, $to_day, $to_year)) {
$v->isOk($todate, "num", 1, 1, "Invalid to date.");
}
}
$v->isOk($empnum, "num", 1, 14, "Invalid employee selected.");
# display errors, if any
if ($v->isError()) {
$confirmCust = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirmCust .= "<li class='err'>" . $e["msg"] . "</li>";
}
$confirmCust .= "<p><input type='button' onClick='JavaScript:history.back();' value='« Correct submission'>";
return $confirmCust;
}
# get employee details
db_connect();
if ($empnum != "0") {
$empw = "empnum='{$empnum}' AND";
}
if (!isset($empw)) {
$empw = "";
}
#check what we have permission to
$get_perm = "SELECT payroll_groups FROM users WHERE username = '******'USER_NAME']}' LIMIT 1";
$run_perm = db_exec($get_perm) or errDie("Unable to get payroll groups permission information.");
if (pg_numrows($run_perm) > 0) {
$parr = pg_fetch_array($run_perm);
if (strlen($parr['payroll_groups']) > 0) {
$pay_grps = explode(",", $parr['payroll_groups']);
if (is_array($pay_grps)) {
$egsearch = " AND (emp_group = '" . implode("' OR emp_group = '", $pay_grps) . "')";
}
} else {
$egsearch = "AND false";
}
}
$sql = "SELECT empnum FROM employees WHERE div = '" . USER_DIV . "' {$egsearch} ORDER BY sname";
$empRslt = db_exec($sql) or errDie("Unable to select employees from database.");
if (pg_numrows($empRslt) > 0) {
$empsarr = array();
while ($arr = pg_fetch_array($empRslt)) {
$empsarr[] = "empnum='{$arr['empnum']}'";
}
$empsearch = " AND (" . implode(" OR ", $empsarr) . ")";
} else {
$empsearch = " AND FALSE";
}
$sql = "SELECT * FROM salr WHERE {$empw} saldate >= '{$fromdate}' AND saldate <= '{$todate}' {$empsearch} AND div = '" . USER_DIV . "'";
$pRslt = db_exec($sql) or errDie("Unable to select employee payments from database.");
if (!isset($mon)) {
$mon = 0;
}
$mon += 0;
$mon += 0;
$mon += 0;
$mon += 0;
if (pg_numrows($pRslt) < 1) {
return "<li class='err'> - Employee payment not found for period {$fromdate} - {$todate}.</li>" . slctDate();
}
$mon += 0;
if (pg_numrows($pRslt) > 0) {
$slip = "\n\t\t\t<center>\n\t\t\t<h3>Salaries Reversed in period {$fromdate} - {$todate}</h3>\n\t\t\t<table " . TMPL_tblDflts . " width='85%'>\n\t\t\t\t<tr>\n\t\t\t\t\t<th>Employee</th>\n\t\t\t\t\t<th>Gross Salary</th>\n\t\t\t\t\t<th>Commission</th>\n\t\t\t\t\t<th>Low or interest free loan</th>\n\t\t\t\t\t<th>UIF</th>\n\t\t\t\t\t<th>PAYE</th>\n\t\t\t\t\t<th>Deductions</th>\n\t\t\t\t\t<th>Nett Income</th>\n\t\t\t\t\t<th colspan='2'>Options</th>\n\t\t\t\t</tr>";
# totals
$totgross = 0;
$totcomm = 0;
$totins = 0;
$totuif = 0;
$totpaye = 0;
$totded = 0;
$totsal = 0;
$i = 0;
while ($pay = pg_fetch_array($pRslt)) {
# get employee details
db_connect();
$sql = "SELECT fnames, sname FROM employees WHERE empnum='{$pay['empnum']}' AND div = '" . USER_DIV . "'";
$empRslt = db_exec($sql) or errDie("Unable to select employees from database.");
if (pg_numrows($empRslt) < 1) {
#check previous employees first ...
$get_prev = "SELECT fnames, sname FROM lemployees WHERE empnum='{$pay['empnum']}' AND div = '" . USER_DIV . "'";
$empRslt = db_exec($get_prev) or errDie("Unable to get employee information.");
$showstat = "(Left Company)";
// return "Invalid employee ID.";
} else {
$showstat = "";
}
$emp = pg_fetch_array($empRslt);
# Calculate gross salary from nettpay
$gross = round($pay['salary'] - $pay['totallow'] - $pay['comm'] + $pay['totded'] + $pay['uif'] + $pay['paye'] + $pay['loanins'], 2);
$slip .= "\n <tr class='" . bg_class() . "'>\n \t<td>{$emp['fnames']} {$emp['sname']} {$showstat}</td>\n \t<td nowrap>" . CUR . " " . sprint("{$gross}") . "</td>\n \t<td nowrap>" . CUR . " " . sprint("{$pay['comm']}") . "</td>\n \t<td nowrap>" . CUR . " " . sprint("{$pay['loanins']}") . "</td>\n \t<td nowrap>" . CUR . " " . sprint("{$pay['uif']}") . "</td>\n \t<td nowrap>" . CUR . " " . sprint("{$pay['paye']}") . "</td>\n \t<td nowrap>" . CUR . " " . sprint("{$pay['totded']}") . "</td>\n \t<td nowrap>" . CUR . " " . sprint("{$pay['salary']}") . "</td>\n \t<td><a target='_blank' href='payslip-print.php?rev=t&id={$pay['id']}'>Print</a></td>\n </tr>";
$totgross += $gross;
$totcomm += $pay['comm'];
$totins += $pay['loanins'];
$totuif += $pay['uif'];
$totpaye += $pay['paye'];
$totded += $pay['totded'];
$totsal += $pay['salary'];
}
# Format the totals
$totgross = sprint($totgross);
$totcomm = sprint($totcomm);
$totins = sprint($totins);
$totuif = sprint($totuif);
$totpaye = sprint($totpaye);
$totded = sprint($totded);
$totsal = sprint($totsal);
$slip .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td><b>Total</b></td>\n\t\t\t\t\t<td nowrap><b>" . CUR . " {$totgross}</b></td>\n\t\t\t\t\t<td nowrap><b>" . CUR . " {$totcomm}</b></td>\n\t\t\t\t\t<td nowrap><b>" . CUR . " {$totins}</b></td>\n\t\t\t\t\t<td nowrap><b>" . CUR . " {$totuif}</b></td>\n\t\t\t\t\t<td nowrap><b>" . CUR . " {$totpaye}</b></td>\n\t\t\t\t\t<td nowrap><b>" . CUR . " {$totded}</b></td>\n\t\t\t\t\t<td nowrap><b>" . CUR . " {$totsal}</b></td>\n\t\t\t\t\t<td colspan=2></td>\n\t\t\t\t</tr>\n\t\t\t</table>";
} else {
return "<li> - There are no salary reversed for the selected period {$fromdate} - {$todate}";
}
# layout
$slip .= "<br>" . mkQuickLinks(ql("../admin-employee-add.php", "Add Employee"));
return $slip;
}
