function confirm($_POST)
{
# get vars
$_POST = var_makesafe($_POST);
extract($_POST);
if (isset($back)) {
return slctEmployee();
}
$annual += 0;
$bonus = 0;
$abonus += 0;
$mpaye_amount += 0;
# validate input
require_lib("validate");
$v = new validate();
if (isset($account)) {
$v->isOk($account, "num", 1, 9, "Invalid ledger account.");
}
$v->isOk($empnum, "num", 1, 9, "Invalid employee number.");
$v->isOk($accid, "num", 1, 9, "Invalid bank number.");
$v->isOk($MON, "num", 1, 2, "Invalid month.");
$v->isOk($abonus, "float", 1, 11, "Invalid bonus.");
$v->isOk($mpaye_amount, "float", 1, 40, "Invalid manual PAYE amount.");
$v->isOk($all_travel, "float", 1, 11, "Invalid travel allowance.");
$v->isOk($comp_pension, "float", 1, 11, "Invalid company pension.");
$v->isOk($comp_medical, "float", 1, 11, "Invalid company medical.");
$v->isOk($emp_pension, "float", 1, 11, "Invalid employee pension.");
$v->isOk($emp_medical, "float", 1, 11, "Invalid employee medical.");
$v->isOk($comp_provident, "float", 1, 11, "Invalid company provident.");
$v->isOk($emp_provident, "float", 1, 11, "Invalid employee provident.");
//$v->isOk ($comp_uif, "float", 1, 11, "Invalid company uif.");
//$v->isOk ($emp_uif, "float", 1, 11, "Invalid employee uif.");
$v->isOk($comp_other, "float", 1, 11, "Invalid company other.");
$v->isOk($emp_other, "float", 1, 11, "Invalid employee other.");
$v->isOk($comp_ret, "float", 1, 11, "Invalid company ret.");
$v->isOk($emp_ret, "float", 1, 11, "Invalid employee ret.");
$v->isOk($basic_sal, "float", 1, 11, "Invalid basic salary.");
$v->isOk($commission, "float", 0, 11, "Invalid commision.");
$v->isOk($loaninstall, "float", 0, 11, "Invalid loan installment.");
$v->isOk($loanint, "float", 0, 11, "Invalid loan interest.");
if ($divisor != 1 && round($divisor, 2) != round(52 / 12, 2) && round($divisor) != round(26 / 12, 2)) {
//$v->addError("", "Invalid pay period (DIVIS).");
}
if ($saltyp == 'd' || $saltyp == 'h') {
$salnarr = array("d" => "Days", "h" => "Hours");
$salntype = $salnarr[$saltyp];
$v->isOk($multi, "float", 1, 5, "Invalid number of {$salntype}.");
if ($multi < 1) {
$v->addError("", "Error : Employee cannot be paid for {$multi} {$salntype}.");
}
}
if (isset($allowances)) {
foreach ($allowances as $key => $value) {
$v->isOk($allowances[$key], "float", 0, 11, "Invalid allowance amount " . ($key + 1) . ".");
}
}
if (isset($deductid)) {
foreach ($deductid as $key => $value) {
$v->isOk($deductid[$key], "num", 1, 9, "Invalid deductions ID.");
}
}
if (isset($deductions)) {
foreach ($deductions as $key => $value) {
$v->isOk($deductions[$key], "float", 0, 11, "Invalid deduction amount" . ($key + 1) . ".");
}
}
if (isset($allowid)) {
foreach ($allowid as $key => $value) {
$v->isOk($allowid[$key], "num", 1, 9, "Invalid allowance ID.");
}
}
if (isset($allowtax)) {
foreach ($allowtax as $key => $value) {
$v->isOk($allowtax[$key], "string", 1, 3, "Invalid allowance tax option" . ($key + 1) . ".");
}
}
if (!isset($pday)) {
$pday = "";
}
$date = $year . "-" . $mon . "-" . $day;
$pdate = mkdate($year, $MON, $pday);
if (!checkdate($mon, $day, $year)) {
$v->isOk($date, "num", 1, 1, "Invalid date .");
}
# display errors, if any
if ($v->isError()) {
$confirmCust = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirmCust .= "<li class='err'>" . $e["msg"] . "</li>";
}
return $confirmCust . process($_POST);
}
$basic_sal_save = $basic_sal;
global $global_empnum;
$global_empnum = $empnum;
db_conn('cubit');
$sql = "SELECT * FROM employees WHERE empnum='{$empnum}' AND div = '" . USER_DIV . "'";
$empRslt = db_exec($sql) or errDie("Unable to select employees from database.");
if (pg_numrows($empRslt) < 1) {
return "Invalid employee ID.";
}
$myEmp = pg_fetch_array($empRslt);
if ($myEmp['payprd'] == "d") {
$Sl = "SELECT * FROM salpaid WHERE empnum='{$empnum}' AND month='{$mm}' AND week='{$pday}' AND cyear='" . EMP_YEAR . "'";
$Ri = db_exec($Sl);
$paid = pg_num_rows($Ri);
$Sl = "SELECT * FROM salr WHERE empnum='{$empnum}' AND month='{$mm}' AND week='{$pday}' AND cyear='" . EMP_YEAR . "'";
$Ri = db_exec($Sl);
$upaid = pg_num_rows($Ri);
$upaid += 0;
$paid -= $upaid;
} elseif ($myEmp['payprd'] == "w") {
$yy = date("Y");
$mm = $MON;
$mm += 0;
$Sl = "SELECT * FROM salpaid WHERE empnum='{$empnum}' AND month='{$mm}' AND week='{$week}' AND cyear='" . EMP_YEAR . "'";
$Ri = db_exec($Sl);
$paid = pg_num_rows($Ri);
$Sl = "SELECT * FROM salr WHERE empnum='{$empnum}' AND month='{$mm}' AND week='{$week}' AND cyear='" . EMP_YEAR . "'";
$Ri = db_exec($Sl);
$upaid = pg_num_rows($Ri);
$upaid += 0;
$paid -= $upaid;
} else {
if ($myEmp['payprd'] == "f") {
$yy = date("Y");
$mm = $MON;
$mm += 0;
$Sl = "SELECT * FROM salpaid WHERE empnum='{$empnum}' AND month='{$mm}' AND week='{$week}' AND cyear='" . EMP_YEAR . "'";
$Ri = db_exec($Sl);
$paid = pg_num_rows($Ri);
$Sl = "SELECT * FROM salr WHERE empnum='{$empnum}' AND month='{$mm}' AND week='{$week}' AND cyear='" . EMP_YEAR . "'";
$Ri = db_exec($Sl);
$upaid = pg_num_rows($Ri);
$upaid += 0;
$paid -= $upaid;
}
}
if (isset($paid) && $paid > 0) {
return process($_POST, "<li class='err'>You have already processed a salary for that period.</li>");
}
$salconacc = gethook("accnum", "salacc", "name", "salaries control");
$salconacc_orig = gethook("accnum", "salacc", "name", "salaries control original");
if ($salconacc != $salconacc_orig) {
block_check($salconacc);
}
block_check($uifbal = gethook("accnum", "salacc", "name", "uifbal"));
block_check($intrec = gethook("accnum", "salacc", "name", "interestreceived"));
block_check($sdlbal = gethook("accnum", "salacc", "name", "sdlbal"));
block_check($pa = gethook("accnum", "salacc", "name", "pension"));
block_check($ma = gethook("accnum", "salacc", "name", "medical"));
block_check($cash_account = gethook("accnum", "salacc", "name", "cash"));
block_check($retire = gethook("accnum", "salacc", "name", "retire"));
block_check($provident = gethook("accnum", "salacc", "name", "provident"));
block_check($commacc = gethook("accnum", "salacc", "name", "Commission"));
block_check($abonusacc = gethook("accnum", "salacc", "name", "Bonus"));
block_check($payeacc = gethook("accnum", "salacc", "name", "PAYE"));
block_check($uifacc = gethook("accnum", "salacc", "name", "UIF"));
block_check($providente = $myEmp["expacc_provident"]);
block_check($retiree = $myEmp["expacc_ret"]);
block_check($pax = $myEmp["expacc_pension"]);
block_check($uifexp = $myEmp["expacc_uif"]);
block_check($max = $myEmp["expacc_medical"]);
block_check($dedgenerale = $myEmp["expacc_other"]);
block_check($sdlexp = $myEmp["expacc_sdl"]);
block_check($salacc = $myEmp["expacc_salwages"]);
block_check($reimbursexp = $myEmp["expacc_reimburs"]);
if (($loanexp = $myEmp["expacc_loan"]) > 0) {
block_check($loanexp);
}
if (isset($allowaccs)) {
foreach ($allowaccs as $checkacc) {
block_check($checkacc);
}
}
if (isset($dedaccs)) {
foreach ($dedaccs as $k => $checkacc) {
block_check($checkacc);
}
}
finish_block_check();
/* check if hire date before pay date */
explodeDate($myEmp["hiredate"], $hd_year, $hd_month, $hd_day);
$MONempyear = getYearOfEmpMon($MON);
switch ($myEmp["payprd"]) {
case "m":
$extra = false;
break;
case "d":
$extra = $hd_year == $MONempyear && $hd_month == $MON && $pday < $hd_day;
break;
case "w":
case "f":
$extra = $hd_year == $MONempyear && $hd_month == $MON && $weekends[$week] < $hd_day;
break;
}
if ($hd_year > $MONempyear || $hd_year == $MONempyear && $hd_month > $MON || $extra) {
return process($_POST, "<li class='err'>Employee was not employed in the period\n\t\t\trequested.</li>");
}
# The Paye
$tyear = 12;
switch ($myEmp["payprd"]) {
case 'm':
$tyear = 12;
break;
case 'w':
$tyear = 52;
break;
case 'f':
$tyear = 26;
break;
case 'd':
$tyear = 5 * 52;
break;
}
if ($myEmp["saltyp"] != "h") {
if ($myEmp["saltyp"] == "w") {
$perhr = sprint($basic_sal / $wh_actual);
} else {
$perhr = sprint($basic_sal * $tyear / ($myEmp['hpweek'] * 52));
}
} else {
$perhr = $basic_sal;
}
$overamt = $novert * ($perhr * $myEmp['novert']);
$overamt += $hovert * ($perhr * $myEmp['hovert']);
$overamt = sprint($overamt);
# Multiply basic_sal add overtime
if (isset($multi)) {
$basic_sal = sprint($basic_sal * $multi);
//$tyear = ($tyear/$multi);
} else {
$basic_sal = $basic_sal;
}
# Zero if not specified
$commission = $commission + 0;
$loaninstall = $loaninstall + 0;
//$basic_sal=$basic_sal+$commission;
$all_before = "";
$all_after = "";
$all_beforeamount = 0;
$all_afteramount = 0;
if (isset($allowtax)) {
foreach ($allowtax as $key => $perc) {
if ($perc == "Yes" and $allowances[$key] > 0) {
$all_before .= "<tr class='" . bg_class() . "'><td>{$allowname[$key]}</td><td>" . CUR . " {$allowances[$key]}</td></tr>";
$all_beforeamount = $all_beforeamount + $allowances[$key];
} elseif ($allowances[$key] > 0) {
$all_after .= "<tr class='" . bg_class() . "'><td>{$allowname[$key]}</td><td>" . CUR . " {$allowances[$key]}</td></tr>";
$all_afteramount = $all_afteramount + $allowances[$key];
}
}
}
$subsistence = "";
$subs_taxable = 0;
$subs_total = 0;
$i = 0;
if (isset($subsname)) {
if (isset($subs_exch) && $subs_exch == 0) {
$subs_exch = 1;
}
foreach ($subsname as $sid => $sn) {
if ($subsrep[$sid] == "yes") {
//2012
$nontax = $subsdays[$sid] * ($subsmeal[$sid] == "yes" ? 303 : 93);
$subs_total += $subsamt[$sid];
} else {
//2012
//TODO
// outside republic, 215 dollars
$nontax = $subsdays[$sid] * (215 / $subs_exch);
$subs_total += $subsamt[$sid] * $subs_exch;
}
$tmp = $subsamt[$sid] - $nontax;
if ($tmp > 0) {
$subs_taxable += $tmp / $divisor;
}
$subsistence .= "\n\t\t\t\t<input type='hidden' name='subsname[{$sid}]' value='{$subsname[$sid]}'>\n\t\t\t\t<input type='hidden' name='subsacc[{$sid}]' value='{$subsacc[$sid]}'>\n\t\t\t\t<input type='hidden' name='subsamt[{$sid}]' value='{$subsamt[$sid]}'>\n\t\t\t\t<input type='hidden' name='subsrep[{$sid}]' value='{$subsrep[$sid]}'>\n\t\t\t\t<input type='hidden' name='subsmeal[{$sid}]' value='{$subsmeal[$sid]}'>\n\t\t\t\t<input type='hidden' name='subsdays[{$sid}]' value='{$subsdays[$sid]}'>\n\t\t\t\t<!--<tr bgcolor='" . bgcolor($i) . "'>\n\t\t\t\t\t<td>{$subsname[$sid]}</td>\n\t\t\t\t\t<td>" . CUR . " {$subsamt[$sid]}</td>\n\t\t\t\t\t<td>{$subsdays[$sid]}</td>\n\t\t\t\t</tr>-->";
}
if (false && !empty($subsistence)) {
$subsistence = "\n\t\t\t<tr><td colspan='20'>\n\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<th colspan='3'>Subsistence Allowances</th>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<th>Name</th>\n\t\t\t\t<th>Amount</th>\n\t\t\t\t<th>Days</th>\n\t\t\t</tr>\n\t\t\t{$subsistence}\n\t\t\t</table>\n\t\t\t</td></tr>";
}
}
$de_before = "";
$de_after = "";
$de_beforeamount = 0;
$de_afteramount = 0;
$de_beforeamount_emp = 0;
$de_afteramount_emp = 0;
if (isset($deducttax)) {
foreach ($deducttax as $key => $perc) {
if ($perc == "Yes" and $deductions[$key] > 0) {
$de_before .= "\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>{$deductname[$key]}</td>\n\t\t\t\t\t\t<td>" . CUR . " {$deductions[$key]}</td>\n\t\t\t\t\t\t<!--<td>" . CUR . " {$employer_deductions[$key]}</td>//-->\n\t\t\t\t\t</tr>";
$de_beforeamount = $de_beforeamount + $deductions[$key] + $employer_deductions[$key];
$de_beforeamount_emp += $employer_deductions[$key];
} elseif ($deductions[$key] > 0) {
$de_after .= "\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>{$deductname[$key]}</td>\n\t\t\t\t\t\t<td>" . CUR . " {$deductions[$key]}</td>\n\t\t\t\t\t\t<!--<td>" . CUR . " {$employer_deductions[$key]}</td>//-->\n\t\t\t\t\t</tr>";
$de_afteramount = $de_afteramount + $deductions[$key] + $employer_deductions[$key];
$de_afteramount_emp += $employer_deductions[$key];
}
}
}
$de_before .= "";
$de_after .= "";
if ($all_beforeamount > 0) {
$all_before = "<tr><th colspan='2'>Allowances</th></tr>" . $all_before;
}
if ($all_afteramount > 0) {
$all_after = "<tr><th colspan='2'>Allowances</th></tr>" . $all_after;
}
if ($de_beforeamount > 0) {
$de_before = "<tr><th colspan='2'>Deductions</th></tr>" . $de_before;
} else {
$de_before = "";
}
if ($de_afteramount > 0) {
$de_after = "<tr><th colspan='2'>Deductions</th></tr>" . $de_after;
} else {
$de_after = "";
}
// calculate age of employee (if intl., ie has passport num only), act asif under 65
if (!empty($myEmp["idnum"])) {
$bd_year = 1900 + substr($myEmp["idnum"], 0, 2);
$bd_month = substr($myEmp["idnum"], 2, 2);
$bd_day = substr($myEmp["idnum"], 4, 2);
/* get the current financial year */
db_conn("core");
$sql = "SELECT yrname FROM active";
$rslt = db_exec($sql) or errDie("Error fetching financial year.");
if (pg_num_rows($rslt) < 1) {
return "Please run quick setup first.";
}
$fin_year = substr(pg_fetch_result($rslt, 0, 0), 1);
if (!checkdate($bd_month, $bd_day, $bd_year)) {
return "<li class='err'>Please <a href='../admin-employee-edit.php?empnum={$myEmp['empnum']}'>change</a> employees ID Number to valid ID Number</li>" . process($_POST);
}
$sql = "SELECT EXTRACT('year' FROM AGE('{$fin_year}-02-28', '{$bd_year}-{$bd_month}-{$bd_day}'))";
$rslt = db_exec($sql) or errDie("Error calculating age at financial year end.");
$age = pg_fetch_result($rslt, 0, 0);
} else {
$age = 1;
}
// calculate loan fringe benefit amount for this month
if (!empty($myEmp["loanamt"]) && $myEmp["gotloan"] == "t" && $myEmp["loanamt"] > 0) {
$loanpart = $loaninstall / $myEmp["loanamt"];
$fringe_loan = sprint($myEmp["loanfringe"] * $loanpart);
} else {
$fringe_loan = "0.00";
}
payedbg("sal/annum: {$myEmp['basic_sal_annum']}<br />", false);
payedbg("divisor: {$divisor}<br />", false);
//2012
// calculate motor car fringe benefit
if ($myEmp["fringe_car1"] > 0) {
$deduct_perc = 0;
// Employee has travel allowance?
if ($myEmp["all_travel"] > 0) {
$deduct_perc = 0.0325;
} else {
$deduct_perc = 0.035;
}
$fringe_car1 = $myEmp["fringe_car1"] * $deduct_perc;
}
// Second fringe car will always be 3.25%
if ($myEmp["fringe_car2"] > 0) {
$fringe_car2 = $myEmp["fringe_car2"] * 0.0325;
}
$fringe_car1 = sprint($fringe_car1);
$fringe_car2 = sprint($fringe_car2);
payedbg("fringe_car1: {$fringe_car1}<br />", false);
payedbg("fringe_car2: {$fringe_car2}<br />", false);
// calc medical fringe benefits
if ($comp_medical > 0) {
// calculate dependants after first one
$tmp_deps = $myEmp["emp_meddeps"] - 2;
if ($tmp_deps < 0) {
$tmp_deps = 0;
}
//2009
// calculate paragraph 12A amount
//first 2 dependants are 530 each (1060) rest is 320 each.
//$p12A_amt = ($myEmp["emp_meddeps"] > 1 ? 1060 : 530) + ($tmp_deps * 320);
//2010
// calculate paragraph 12A amount
//first 2 dependants are 625 each (1250) rest is 380 each.
//$p12A_amt = ($myEmp["emp_meddeps"] > 1 ? 1250 : 625) + ($tmp_deps * 380);
//2011
// calculate paragraph 12A amount
//first 2 dependants are 670 each (1340) rest is 410 each.
//$p12A_amt = ($myEmp["emp_meddeps"] > 1 ? 1340 : 820) + ($tmp_deps * 410);
//2012
// calculate paragraph 12A amount
//first 2 dependants are 230 each (460) rest is 154 each.
$p12A_amt = ($myEmp["emp_meddeps"] > 1 ? 460 : 230) + $tmp_deps * 154;
// calculate taxable fringe benefit amount
$fringe_medical = sprint($comp_medical - $p12A_amt / $divisor);
if ($fringe_medical < 0) {
$fringe_medical = 0;
}
} else {
$fringe_medical = 0;
}
payedbg("medical fringe: {$fringe_medical}<br />", false);
// calculate total fringe benefits
$tot_fringe = $fringe_medical + $fringe_car1 + $fringe_car2 + $fringe_loan + $comp_other + $comp_ret + $de_beforeamount_emp + $de_afteramount_emp + $subs_taxable;
// subsistance
if (isset($fringeid)) {
foreach ($fringeid as $key => $value) {
$fringebens[$key] = sprint($fringebens[$key]);
$tot_fringe += $fringebens[$key];
}
}
vsprint($tot_fringe);
payedbg("total fringe: {$tot_fringe}<br />", false);
if ($emp_pension > $basic_sal * 7.5 / 100) {
$emp_mpension = $basic_sal * 7.5 / 100;
} else {
$emp_mpension = $emp_pension;
}
$max_ret = $myEmp["basic_sal_annum"] * 7.5 / 100 > 1750 ? $myEmp["basic_sal_annum"] * 7.5 / 100 : 1750;
// calculate total gross salary
$grossal = $basic_sal + $commission + $abonus + $overamt + $bonus + $annual + $all_beforeamount + $all_travel * 0.8 - $de_beforeamount;
// deductions deducted before paye (non taxible)
$grossal_2 = $grossal;
$taxed_all = $all_afteramount + $all_travel * 0.8;
$grossal_nodedall = $basic_sal + $overamt + $bonus + $annual + $all_travel;
#UIF HAX
$uif_grosssal = $grossal;
// pension/provident/ra: calculate deduction amounts, limiting them to maximum amount and only deducting
// ONE of them for taxable income
if ($comp_pension + $emp_pension > 0) {
$tmp = ($grossal_2 + $tot_fringe) * $tyear;
$maxallowed = $tmp * 0.075 > 1750 ? $tmp * 0.075 : 1750;
if ($emp_mpension > $maxallowed) {
$tmp_ded = $maxallowed;
} else {
$tmp_ded = $emp_mpension;
}
$grossal -= $tmp_ded;
payedbg("pension maxded (-gross): {$tmp_ded}<br />", false);
}
if ($comp_ret + $emp_ret > 0) {
$tmp = ($grossal_2 + $tot_fringe) * $tyear;
// if their is a pension contributions the percentage is 0
if ($comp_pension + $emp_pension + $comp_provident + $emp_provident > 0) {
$PERC = 0;
} else {
$PERC = 0.15;
}
$maxallowed = $tmp * $PERC > 1750 ? $tmp * $PERC : 1750;
$maxallowed = $maxallowed > 3500 - $emp_pension * $divisor * 12 ? $maxallowed : 3500 - $emp_pension * 12;
if (($emp_ret + $comp_ret) * $divisor > $maxallowed / 12) {
$tmp_ded = $maxallowed / 12 / $divisor;
} else {
$tmp_ded = $emp_ret + $comp_ret;
}
$grossal -= $tmp_ded;
payedbg("retfund maxded (-gross): {$tmp_ded}<br />", false);
}
// calculate total paye salary
// just remove annual this month, and add annual divided by 12
// because paye is calculate for full twelve months and therefore
// paye salary is average received each month
$paye_salary = $grossal - $annual + $tot_fringe;
// total fringe benefits;
//print "--------- $uif_grossal - $annual + $tot_fringe;----------<br>";
#UIF HAX
$uif_paye_salary = $uif_grosssal - $annual + $tot_fringe;
/* calculate uif */
$tmp_remun = $paye_salary + $annual - $commission - $abonus;
#UIF HAX
$uif_tmp_remun = $uif_paye_salary + $annual - $commission - $abonus;
// $comp_uif = sprint($tmp_remun * ($myEmp["comp_uif"] / 100));
// $emp_uif = sprint($tmp_remun * ($myEmp["emp_uif"] / 100));
#UIF HAX
$comp_uif = sprint($uif_tmp_remun * ($myEmp["comp_uif"] / 100));
$emp_uif = sprint($uif_tmp_remun * ($myEmp["emp_uif"] / 100));
$uifmax = getCSetting("UIF_MAX");
if ($emp_uif > $uifmax) {
$emp_uif = sprint($uifmax);
}
if ($comp_uif > $uifmax) {
$comp_uif = sprint($uifmax);
}
/* calculate sdl */
$tmp_remun = $paye_salary + $annual;
if (getCSetting("SDLPAYABLE") == "y") {
$tmp_sdl = $tmp_remun;
if ($age > 65) {
$tmp_sdl -= $comp_medical;
}
$comp_sdl = $tmp_sdl * ($myEmp["comp_sdl"] / 100);
} else {
$comp_sdl = 0;
}
// a little hack, apparently the grossal is displayed wrong, in a strictly opinion based evodamion
$grossal += $comp_ret;
// add rest of travel allowance
$grossal += $all_travel * 0.2;
if (isset($mpaye)) {
$paye = $mpaye_amount;
} else {
// calculate paye (take age of 65+ threshold into account)
//2008
// if ( ($age >= 65 && ($paye_salary * $tyear) < 69000) || ($paye_salary * $tyear) < 43000 ) {
//2009
// if ( ($age >= 65 && ($paye_salary * $tyear) < 74000) || ($paye_salary * $tyear) < 46000 ) {
//2010
// if ( ($age >= 65 && ($paye_salary * $tyear) < 84200) || ($paye_salary * $tyear) < 54200 ) {
//2011
// if ( ($age >= 65 && ($paye_salary * $tyear) < 88528) || ($paye_salary * $tyear) < 57000 ) {
//2012
if ($age >= 65 && $age < 75 && $paye_salary * $tyear < 99056 || $age >= 75 && $paye_salary * $tyear < 110889 || $paye_salary * $tyear < 63556) {
$paye = "0.00";
} else {
if ($myEmp["payprd"] == "w" || $myEmp["payprd"] == "f") {
$paye_prd = "{$MON}:{$week}";
} else {
if ($myEmp["payprd"] == "d") {
$paye_prd = "{$MON}:{$pday}";
} else {
$paye_prd = "{$MON}";
}
}
payedbg("paye salary: {$paye_salary}<br />", false);
$paye = calculate_paye($myEmp, $paye_prd, $paye_salary, $tyear, $age);
if ($annual > 0) {
$tmp_bonpaye = calculate_paye($myEmp, $paye_prd, $paye_salary + $annual / 12, $tyear, $age);
$paye += $tmp_bonpaye * $tyear - $paye * $tyear;
}
}
}
// fringe benefits
$i = 0;
$fringes = "";
$fringes_desc = "";
if (isset($fringebens)) {
foreach ($fringebens as $key => $value) {
if ($fringebens[$key] > 0) {
$fringes_desc .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>{$fringename[$key]}</td>\n\t\t\t\t\t<td>" . CUR . " {$fringebens[$key]}</td>\n\t\t\t\t</tr>";
$fringes .= "\n\t\t\t\t\t<input type='hidden' name='fringebens[]' value='{$fringebens[$key]}'>\n\t\t\t\t\t<input type='hidden' name='fringeid[]' value='{$fringeid[$key]}'>\n\t\t\t\t\t<input type='hidden' name='fringename[]' value='{$fringename[$key]}'>\n\t\t\t\t\t<input type='hidden' name='fringeaccs[]' value='{$fringeaccs[$key]}'>";
}
}
}
if (!empty($fringes_desc)) {
$fringes_desc = "<tr><th colspan='2'>Fringe Benefits</th></tr>{$fringes_desc}";
}
$allow = "";
# Get allowances names and value from array
if (isset($allowances)) {
foreach ($allowances as $key => $value) {
if ($allowances[$key] > 0) {
$allow .= "\n\t\t\t\t\t<input type='hidden' size='10' name='allowname[]' value='{$allowname[$key]}'>\n\t\t\t\t\t<input type='hidden' size='10' name='allowid[]' value='{$allowid[$key]}'>\n\t\t\t\t\t<input type='hidden' size='10' name='allowances[]' value='{$allowances[$key]}'>\n\t\t\t\t\t<input type='hidden' size='10' name='allowtax[]' value='{$allowtax[$key]}'>\n\t\t\t\t\t<input type='hidden' name='allowaccs[]' value='{$allowaccs[$key]}'>";
}
}
}
$deduct = "";
if (isset($deductions)) {
foreach ($deductions as $key => $value) {
if ($deductions[$key] > 0) {
$deduct .= "\n\t\t\t\t\t<input type='hidden' size='10' name='deductname[]' value='{$deductname[$key]}'>\n\t\t\t\t\t<input type='hidden' size='10' name='deductid[]' value='{$deductid[$key]}'>\n\t\t\t\t\t<input type='hidden' size='10' name='deductions[]' value='{$deductions[$key]}'>\n\t\t\t\t\t<input type='hidden' size='10' name='employer_deductions[]' value='{$employer_deductions[$key]}'>\n\t\t\t\t\t<input type='hidden' size='10' name='deducttax[]' value='{$deducttax[$key]}'>\n\t\t\t\t\t<input type='hidden' name='dedaccs[]' value='{$dedaccs[$key]}'>";
}
}
}
$nonretfunding = $basic_sal - $paye - $loaninstall - $de_afteramount + $de_afteramount_emp + $all_afteramount - $emp_pension - $emp_medical - $emp_uif - $emp_provident;
/*$ret_max = (1800>($nonretfunding*0.15)) ? 1800 : ($nonretfunding*0.15);
if ( $comp_ret + $emp_ret > $ret_max ) {
$comp_ret = $ret_max - $emp_ret;
if ( $comp_ret < 0 ) {
$comp_ret = 0;
$emp_ret = $ret_max;
}
}*/
$nettpay = $basic_sal + $overamt - $paye + $commission + $abonus - $loaninstall - $de_beforeamount - $de_afteramount + $all_afteramount + $all_beforeamount - $emp_pension - $emp_medical - $emp_ret - $emp_uif - $emp_provident - $emp_other + $annual + $bonus + $all_travel - $myEmp["fringe_car1_contrib"] - $myEmp["fringe_car2_contrib"] + $subs_total;
$nettpay = sprint($nettpay);
if (isset($rbsa)) {
$nettpay += array_sum($rbsa);
$nettpay = sprint($nettpay);
}
$rt = "";
db_conn("cubit");
$Sl = "SELECT * FROM cubit.rbs ORDER BY name";
$Ri = db_exec($Sl) or errDie("Unable to get data.");
$i = 0;
if (pg_num_rows($Ri) > 0) {
while ($td = pg_fetch_array($Ri)) {
if (!isset($rbsa[$td['id']]) || $rbsa[$td['id']] < 1) {
continue;
}
$rbsa[$td['id']] = sprint($rbsa[$td['id']]);
if ($i == 0) {
$rt = "<tr><th colspan=2>Reimbursements</th></tr>";
}
$rt .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td><input type='hidden' name='rbs[{$td['id']}]' value='{$td['id']}'>{$td['name']}</td>\n\t\t\t\t\t<td>" . CUR . " <input type='hidden' name='rbsa[{$td['id']}]' value='" . $rbsa[$td['id']] . "'>" . $rbsa[$td['id']] . "</td>\n\t\t\t\t</tr>";
$i++;
}
} else {
$rt .= "<tr class='" . bg_class() . "'><td colspan='2'>There are no reimbursements</td></tr>";
}
db_conn("cubit");
# Get bank account name
$sql = "SELECT * FROM bankacct WHERE bankid = '{$accid}' AND div = '" . USER_DIV . "'";
$bankRslt = db_exec($sql);
$bank = pg_fetch_array($bankRslt);
$basic_sal = sprint($basic_sal);
$commission = sprint($commission);
$abonus = sprint($abonus);
$overamt = sprint($overamt);
$paye = sprint($paye);
$nettpay = sprint($nettpay);
if ($myEmp['paytype'] == "Cash") {
$paydetails = "<tr class='" . bg_class() . "'><td colspan=2>Pay Salary Cash</td></tr>";
} else {
$paydetails = "<tr class='" . bg_class() . "'><td>Bank Account</td><td>{$bank['accname']}</td></tr>";
}
vsprint($bonus);
vsprint($annual);
vsprint($comp_pension);
vsprint($emp_medical);
vsprint($comp_medical);
vsprint($comp_ret);
vsprint($emp_ret);
vsprint($loaninstall);
vsprint($emp_pension);
vsprint($fringe_medical);
if (!isset($account)) {
$account = 0;
} else {
db_conn('core');
$Sl = "SELECT * FROM accounts WHERE accid='{$account}'";
$Ri = db_exec($Sl);
$ad = pg_fetch_array($Ri);
$paydetails = "<tr class='" . bg_class() . "'><td>Ledger Account</td><td>{$ad['accname']}</td></tr>";
}
if ($myEmp['payprd'] == "w") {
$row = "\n\t\t\t<tr class='" . bg_class() . "'><td>Period</td><td>{$week}</td></tr>\n\t\t\t<input type='hidden' name='week' value='{$week}'>\n\t\t\t<input type='hidden' name='pday' value='0' />";
} else {
if ($myEmp['payprd'] == "f") {
$row = "\n\t\t\t<tr class='" . bg_class() . "'><td>Period</td><td>{$week}</td></tr>\n\t\t\t<input type='hidden' name='week' value='{$week}'>\n\t\t\t<input type='hidden' name='pday' value='0' />";
} else {
if ($myEmp["payprd"] == "d") {
$row = "\n\t\t\t<tr class='" . bg_class() . "'><td>Day of Payment</td><td>{$pday}</td></tr>\n\t\t\t<input type='hidden' name='week' value='0'>\n\t\t\t<input type='hidden' name='pday' value='{$pday}' />";
} else {
$row = "\n\t\t\t<input type='hidden' name='week' value='0'>\n\t\t\t<input type='hidden' name='pday' value='0' />";
}
}
}
$grossal = sprint($grossal);
$OUTPUT = "\n\t <form action='" . SELF . "' method='POST'>\n\t <table " . TMPL_tblDflts . " width='300'>\n\t\t\t<tr>\n\t\t\t\t<td><input type='submit' name='back' value='« Correction' /></td>\n\t\t\t\t<td align='right'><input type='submit' value='Write »'></td>\n\t\t\t</tr>\n\t\t\t<input type='hidden' name='proc_day' value='{$day}' />\n\t\t\t<input type='hidden' name='proc_month' value='{$mon}' />\n\t\t\t<input type='hidden' name='proc_year' value='{$year}' />\n\t\t\t<input type='hidden' name='key' value='pack'>\n\t\t\t<input type='hidden' name='grossal' value='{$grossal}'>\n\t\t\t<input type='hidden' name='grossal_nodedall' value='{$grossal_nodedall}'>\n\t\t\t<input type='hidden' name='empnum' value='{$empnum}'>\n\t\t\t<input type='hidden' name='account' value='{$account}'>\n\t\t\t<input type='hidden' name='MON' value={$MON}>\n\t\t\t<input type='hidden' name='basic_sal' value='{$basic_sal_save}'>\n\t\t\t<input type='hidden' name='multi' value='{$multi}'>\n\t\t\t<input type='hidden' name='tyear' value='{$tyear}'>\n\t\t\t<input type='hidden' name='commission' value='{$commission}'>\n\t\t\t<input type='hidden' name='abonus' value='{$abonus}'>\n\t\t\t<input type='hidden' name='overamt' value='{$overamt}'>\n\t\t\t<input type='hidden' name='loaninstall' value='{$loaninstall}'>\n\t\t\t<input type='hidden' name='paye' value='{$paye}'>\n\t\t\t<input type='hidden' name='accid' value='{$accid}'>\n\t\t\t<input type='hidden' name='income' value='{$nettpay}'>\n\t\t\t<input type='hidden' name='bonus' value='{$bonus}'>\n\t\t\t<input type='hidden' name='all_travel' value='{$all_travel}'>\n\t\t\t<input type='hidden' name='comp_pension' value='{$comp_pension}'>\n\t\t\t<input type='hidden' name='emp_pension' value='{$emp_pension}'>\n\t\t\t<input type='hidden' name='comp_medical' value='{$comp_medical}'>\n\t\t\t<input type='hidden' name='emp_medical' value='{$emp_medical}'>\n\t\t\t<input type='hidden' name='comp_ret' value='{$comp_ret}'>\n\t\t\t<input type='hidden' name='emp_ret' value='{$emp_ret}'>\n\t\t\t<input type='hidden' name='comp_uif' value='{$comp_uif}'>\n\t\t\t<input type='hidden' name='emp_uif' value='{$emp_uif}'>\n\t\t\t<input type='hidden' name='comp_sdl' value='{$comp_sdl}'>\n\t\t\t<input type='hidden' name='comp_other' value='{$comp_other}'>\n\t\t\t<input type='hidden' name='emp_other' value='{$emp_other}'>\n\t\t\t<input type='hidden' name='comp_provident' value='{$comp_provident}'>\n\t\t\t<input type='hidden' name='emp_provident' value='{$emp_provident}'>\n\t\t\t<input type='hidden' name='paye_salary' value='{$paye_salary}'>\n\t\t\t<input type='hidden' name='day' value='{$day}'>\n\t\t\t<input type='hidden' name='mon' value='{$mon}'>\n\t\t\t<input type='hidden' name='year' value='{$year}'>\n\t\t\t<input type='hidden' name='novert' value='{$novert}'>\n\t\t\t<input type='hidden' name='hovert' value='{$hovert}'>\n\t\t\t<input type='hidden' name='annual' value='{$annual}'>\n\t\t\t<input type='hidden' name='week' value='{$week}'>\n\t\t\t<input type='hidden' name='fringe_medical' value='{$fringe_medical}'>\n\t\t\t<input type='hidden' name='fringe_tot' value='{$tot_fringe}'>\n\t\t\t<input type='hidden' name='fringe_car1' value='{$fringe_car1}'>\n\t\t\t<input type='hidden' name='fringe_car2' value='{$fringe_car2}'>\n\t\t\t<input type='hidden' name='fringe_loan' value='{$fringe_loan}'>\n\t\t\t<input type='hidden' name='process_comp_deductions' value='{$process_comp_deductions}'>\n\t\t\t<input type='hidden' name='taxed_all' value='{$taxed_all}' />\n\t\t\t<input type='hidden' name='printslip' value='{$printslip}' />\n\t\t\t" . (isset($subs_exch) ? "<input type='hidden' name='subs_exch' value='{$subs_exch}'>" : "") . "\n\t\t\t{$fringes}\n\t\t\t{$allow}\n\t\t\t{$deduct}\n\t\t\t<tr>\n\t\t\t\t<th colspan='2'>Salary Details</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Basic salary</td>\n\t\t\t\t<td>" . CUR . " {$basic_sal}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Annual Bonus</td>\n\t\t\t\t<!--<td>Special Bonus/Additional Salary</td>-->\n\t\t\t\t<td>" . CUR . " {$abonus}</td>\n\t\t\t</tr>\n\t\t\t<!--<tr class='bg-odd'>\n\t\t\t\t<td>Bonus(Annual Payments)</td>\n\t\t\t\t<td>" . CUR . " {$annual}</td>\n\t\t\t</tr>-->\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Commission</td>\n\t\t\t\t<td>" . CUR . " {$commission}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Travel Allowance</td>\n\t\t\t\t<td>" . CUR . " {$all_travel}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Pension: Company Contribution</td>\n\t\t\t\t<td>" . CUR . " {$comp_pension}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Pension: Employee Deduction</td>\n\t\t\t\t<td>" . CUR . " {$emp_pension}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Provident Fund: Company Contribution</td>\n\t\t\t\t<td>" . CUR . " {$comp_provident}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Provident Fund: Employee Deduction</td>\n\t\t\t\t<td>" . CUR . " {$emp_provident}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>UIF: Company Contribution</td>\n\t\t\t\t<td>" . CUR . " {$comp_uif}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>UIF: Employee Deduction</td>\n\t\t\t\t<td>" . CUR . " {$emp_uif}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Retirement Annuity: Company Contribution</td>\n\t\t\t\t<td>" . CUR . " {$comp_ret}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Retirement Annuity: Employee Deduction</td>\n\t\t\t\t<td>" . CUR . " {$emp_ret}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Medical Contribution: Company</td>\n\t\t\t\t<td>" . CUR . " {$comp_medical}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Medical Contribution: Employee</td>\n\t\t\t\t<td>" . CUR . " {$emp_medical}</td>\n\t\t\t</tr>\n\t\t\t<br />\n\t\t\t<!--\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Other: Company Contribution</td>\n\t\t\t\t<td>" . CUR . " {$comp_other}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Other: Employee Deduction</td>\n\t\t\t\t<td>" . CUR . " {$emp_other}</td>\n\t\t\t</tr>\n\t\t\t//-->\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Overtime</td>\n\t\t\t\t<td>" . CUR . " {$overamt}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Medical Fringe Benefit</td>\n\t\t\t\t<td>" . CUR . " {$fringe_medical}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Motorcar 1 Fringe Benefit</td>\n\t\t\t\t<td>" . CUR . " {$fringe_car1}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Motorcar 1 Contribution for Use</td>\n\t\t\t\t<td>" . CUR . " {$myEmp['fringe_car1_contrib']}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Motorcar 2 Fringe Benefit</td>\n\t\t\t\t<td>" . CUR . " {$fringe_car2}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Motorcar 2 Contribution for Use</td>\n\t\t\t\t<td>" . CUR . " {$myEmp['fringe_car2_contrib']}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Loan Interest Fringe Benefit</td>\n\t\t\t\t<td>" . CUR . " {$fringe_loan}</td>\n\t\t\t</tr>\n\t\t\t{$fringes_desc}\n\t\t\t{$all_before}\n\t\t\t{$de_before}\n\t\t\t<tr>\n\t\t\t\t<th colspan='2'>Gross Salary</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Gross Salary</td>\n\t\t\t\t<td>" . CUR . " {$grossal}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>SITE/PAYE</td>\n\t\t\t\t<td>" . CUR . " {$paye}</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<th colspan='2'>Loans</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Loan Instalment</td>\n\t\t\t\t<td>" . CUR . " {$loaninstall}</td>\n\t\t\t</tr>\n\t\t\t{$all_after}\n\t\t\t{$subsistence}\n\t\t\t{$de_after}\n\t\t\t<tr>\n\t\t\t\t<th colspan='2'>Nett Pay</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Nett Pay + Reimbursements</td>\n\t\t\t\t<td>" . CUR . " {$nettpay}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Amount Paid now</td>\n\t\t\t\t<td><input type='text' size='10' name='paidamount' value='0'></td>\n\t\t\t</tr>\n\t\t\t{$paydetails}\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Date</td>\n\t\t\t\t<td>{$date}</td>\n\t\t\t</tr>\n\t\t\t{$row}\n\t\t\t{$rt}\n\t\t\t<tr>\n\t\t\t\t<td><input type='submit' name='back' value='« Correction' /></td>\n\t\t\t\t<td align='right'><input type='submit' value='Write »'></td>\n\t\t\t</tr>\n\t\t</table>\n\t\t</form>";
return $OUTPUT;
}
function bracket_calcpaye_old($age, $paye_salary, $tyear)
{
payedbg("bcalc - age: {$age}<br />");
payedbg("bcalc - paye_salary: {$paye_salary}<br />");
payedbg("bcalc - tyear: {$tyear}<br />");
/* get PAYE bracket percentages */
if (($tables = tabiast($paye_salary * $tyear)) === false) {
errDie("The PAYE bracket for " . CUR . " {$paye_salary} does not exist (\$).");
} else {
list($payeperc, $payex, $min, $max) = $tables;
}
//2008
// Get paye rebate
// $rebate = 7740;
// if ( $age >= 65 ) {
// $rebate += 4680;
// }
//2009
// Get paye rebate
// $rebate = 8280;
// if ( $age >= 65 ) {
// $rebate += 5040;
// }
//2010
// Get paye rebate
// $rebate = 9756;
// if ( $age >= 65 ) {
// $rebate += 5400;
// }
//2011
// Get paye rebate
// $rebate = 10260;
// if ( $age >= 65 ) {
// $rebate += 5675;
// }
//2012
// Get paye rebate
$rebate = 11440;
if ($age >= 65) {
$rebate += 6390;
}
if ($age >= 75) {
$rebate += 2130;
}
if ($min > 0) {
--$min;
}
$paye = ($paye_salary * $tyear - $min) * $payeperc / 100;
$paye = $paye + $payex - $rebate;
if ($paye < 0) {
$paye = 0;
}
payedbg("bcalc - result: {$paye}<br />");
return $paye;
}
