# # # # 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; }