#
#
#
#
require "settings.php";
if ($_POST) {
if ($_POST["key"] == "confirm") {
# confirm entered data
$OUTPUT = confirmPaye($_POST);
} elseif ($_POST["key"] == "write") {
# write to database
$OUTPUT = writePaye($_POST);
}
} else {
# enter info to change
$OUTPUT = editPaye($_GET);
}
require "template.php";
##
# Functions
##
# enter info to change
function editPaye($_GET)
{
$id = preg_replace("/[^\\d]/", "", substr($_GET["id"], 0, 9));
# connect to db
db_connect();
# get info
$sql = "SELECT * FROM paye WHERE id='{$id}'";
$payeRslt = db_exec($sql) or errDie("Unable to select paye bracket from database.", SELF);
if (pg_numrows($payeRslt) > 0) {
function writePaye($_POST)
{
# Get vars
foreach ($_POST as $key => $value) {
${$key} = $value;
}
if (isset($back)) {
return editPaye($_POST);
}
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($id, "num", 1, 20, "Invalid PAYE ID.");
$v->isOk($min, "float", 1, 20, "Invalid min amount.");
$v->isOk($max, "float", 1, 20, "Invalid max amount.");
$v->isOk($percentage, "float", 1, 10, "Invalid percentage.");
$v->isOk($extra, "float", 1, 20, "Invalid exstra amount.");
# display errors, if any
if ($v->isError()) {
$confirmCust = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirmCust .= "<li class=err>" . $e["msg"];
}
$confirmCust .= "<p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>";
return $confirmCust;
}
# connect to db
db_connect();
# commit PAYE changes to db
$sql = "UPDATE paye SET min='{$min}', max='{$max}', percentage='{$percentage}',extra='{$extra}' WHERE id='{$id}'";
$payeRslt = db_exec($sql) or errDie("Unable to commit PAYE bracket changes to database.", SELF);
$writePaye = "<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "' width='50%'>\r\n\t<tr><th>PAYE bracket successfully edited</th></tr>\r\n\t<tr class=datacell><td>PAYE bracket (R {$min} - " . CUR . " {$max}) has been successfully edited.</td></tr>\r\n\t</table>\r\n\t<p>\r\n\t<table border=0 cellpadding='2' cellspacing='1'>\r\n\t<tr><th>Quick Links</th></tr>\r\n\t<tr bgcolor='#88BBFF'><td><a href='paye-add.php'>Add Paye</a></td></tr>\r\n\t<tr bgcolor='#88BBFF'><td><a href='paye-view.php'>View Paye</a></td></tr>\r\n\t<tr bgcolor='#88BBFF'><td><a href='employee-resources.php'>Employee Resources</a></td></tr>\r\n\t<script>document.write(getQuicklinkSpecial());</script>\r\n\t<tr bgcolor='#88BBFF'><td><a href='../main.php'>Main Menu</a></td></tr>\r\n\t</table>";
return $writePaye;
}
