function con_data($_POST)
{
# get vars
foreach ($_POST as $key => $value) {
${$key} = $value;
}
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($name, "string", 1, 20, "Invalid Name.");
$v->isOk($surname, "string", 0, 20, "Invalid Surname.");
$v->isOk($tel, "phone", 0, 10, "Invalid Tel.");
# display errors, if any
if ($v->isError()) {
$confirmCust = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirmCust .= "<li class=err>" . $e["msg"] . "</li>";
}
return enter_err($_POST, $confirmCust);
exit;
$confirmCust .= "<p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>";
return $confirmCust;
}
$con_data = "<h3>Confirm contact details</h3>\r\n\t<table cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\r\n\t<form action='" . SELF . "' method=post>\r\n\t<input type=hidden name=key value=write>\r\n\t<input type=hidden name=name value='{$name}'>\r\n\t<input type=hidden name=surname value='{$surname}'>\r\n\t<input type=hidden name=tel value='{$tel}'>\r\n\t<input type=hidden name=id value='{$id}'>\r\n\t<tr><th colspan=2>Personal details</th></tr>\r\n\t<tr class='bg-odd'><td>Name</td><td align=center>{$name}</td></tr>\r\n\t<tr class='bg-even'><td>Surname</td><td align=center>{$surname}</td></tr>\r\n\t<tr class='bg-even'><td>Tel</td><td align=center>{$tel}</td></tr>\r\n\t<tr><td colspan=2 align=right><input type=submit value='Write »'></td></tr>\r\n\t</form>\r\n\t</table>\r\n\t<p>\r\n\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\r\n\t<tr><th>Quick Links</th></tr>\r\n\t<tr class='bg-odd'><td><a href='list_consdel.php'>List contacts</a></td></tr>\r\n </table>";
return $con_data;
}
function write_mail($_POST)
{
//$date = date("Y-m-d H:i:s");
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($email, "email", 1, 20, "Invalid email address.");
$v->isOk($msg, "string", 0, 1000, "Invalid text of msg max is 1000.");
# display errors, if any
if ($v->isError()) {
$confirmCust = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirmCust .= "<li class=err>" . $e["msg"] . "</li>";
}
return enter_err($_POST, $confirmCust);
exit;
$confirmCust .= "<p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>";
return $confirmCust;
}
/*db_conn('cubit');
$S1 = "INSERT INTO document(name,surname,tel,date) VALUES ('$name','$surname','$tel','$date')";
$Ri = db_exec($S1) or errDie("Unable to insert document.");*/
$write_mail = "<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "' width='50%'>\r\n\t<tr><th>Document added</th></tr>\r\n\t<tr class=datacell><td>{$email} has been added to Cubit.</td></tr>\r\n\t</table>\r\n\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\r\n\t</table>\r\n\t <p><table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\r\n\t<tr><th>Quick Links</th></tr>\r\n\t<tr class='bg-odd'><td><a href='tdocview.php'>View a list of the document</a></td></tr>\r\n\t</table>";
return $write_mail;
}
function confirm($_POST)
{
# get vars
foreach ($_POST as $key => $value) {
${$key} = $value;
}
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($accno, "string", 1, 20, "Invalid Account number.");
$v->isOk($surname, "string", 1, 255, "Invalid surname/company.");
$v->isOk($title, "string", 1, 10, "Invalid title.");
$v->isOk($init, "string", 1, 10, "Invalid initials.");
$v->isOk($firstname, "string", 1, 255, "Invalid Customer name.");
$v->isOk($catid, "num", 1, 255, "Invalid Category.");
$v->isOk($clasid, "num", 1, 255, "Invalid Classification.");
$v->isOk($paddr, "string", 1, 255, "Invalid Postal Address.");
$v->isOk($daddr, "string", 1, 255, "Invalid Delivery Address.");
$v->isOk($contname, "string", 1, 255, "Invalid contact name.");
$v->isOk($bustel, "string", 1, 20, "Invalid Bussines telephone.");
$v->isOk($hometel, "string", 1, 20, "Invalid Home telephone.");
$v->isOk($cellno, "string", 0, 20, "Invalid Cell number.");
$v->isOk($faxno, "string", 0, 20, "Invalid Fax number.");
$v->isOk($email, "email", 0, 255, "Invalid email name.");
$v->isOk($saleterm, "num", 1, 20, "Invalid Sale Term.");
$v->isOk($traddisc, "float", 0, 20, "Invalid trade discount.");
$v->isOk($setdisc, "float", 0, 20, "Invalid settlement discount.");
$v->isOk($listid, "num", 1, 20, "Invalid price list.");
$v->isOk($chrgint, "float", 0, 20, "Invalid Charge interest.");
$v->isOk($overdue, "float", 0, 20, "Invalid overdue.");
$v->isOk($chrgvat, "string", 1, 4, "Invalid charge vat.");
$v->isOk($vatinc, "string", 1, 3, "Invalid vat inclusive selection.");
$v->isOk($credterm, "num", 0, 20, "Invalid Credit term.");
# mix date
$odate = $oday . "-" . $omon . "-" . $oyear;
if (!checkdate($omon, $oday, $oyear)) {
$v->isOk($odate, "num", 1, 1, "Invalid account open date.");
}
$v->isOk($credlimit, "float", 0, 20, "Invalid credit limit.");
$v->isOk($block, "string", 1, 3, "Invalid Block acc selection.");
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class=err>" . $e["msg"];
}
return enter_err($_POST, $confirm);
exit;
$confirm .= "<p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>";
return $confirm;
}
// get drop down info
db_conn("toms");
# get Category
$sql = "SELECT * FROM categories WHERE catid = '{$catid}'";
$catRslt = db_exec($sql);
if (pg_numrows($catRslt) < 1) {
$category = "<li class=err>Category not Found.";
} else {
$cat = pg_fetch_array($catRslt);
$category = $cat['category'];
}
# get Classification
$sql = "SELECT * FROM class WHERE clasid = '{$clasid}'";
$clasRslt = db_exec($sql);
if (pg_numrows($clasRslt) < 1) {
$class = "<li class=err>Class not Found.";
} else {
$clas = pg_fetch_array($clasRslt);
$class = $clas['classname'];
}
# get Price List
$sql = "SELECT * FROM pricelist WHERE listid = '{$listid}'";
$listRslt = db_exec($sql);
if (pg_numrows($listRslt) < 1) {
$pricelist = "<li class=err>Class not Found.";
} else {
$list = pg_fetch_array($listRslt);
$plist = $list['listname'];
}
$confirm = "<h3>Confirm Customer</h3>\r\n\t<form action='" . SELF . "' method=post>\r\n\t<table cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\r\n\t<input type=hidden name=key value=write>\r\n\t<input type=hidden name=accno value='{$accno}'>\r\n\t<input type=hidden name=surname value='{$surname}'>\r\n\t<input type=hidden name=title value='{$title}'>\r\n\t<input type=hidden name=init value='{$init}'>\r\n\t<input type=hidden name=firstname value='{$firstname}'>\r\n\t<input type=hidden name=catid value='{$catid}'>\r\n\t<input type=hidden name=clasid value='{$clasid}'>\r\n\t<input type=hidden name=paddr value='{$paddr}'>\r\n\t<input type=hidden name=daddr value='{$daddr}'>\r\n\t<input type=hidden name=contname value='{$contname}'>\r\n\t<input type=hidden name=bustel value='{$bustel}'>\r\n\t<input type=hidden name=hometel value='{$hometel}'>\r\n\t<input type=hidden name=cellno value='{$cellno}'>\r\n\t<input type=hidden name=faxno value='{$faxno}'>\r\n\t<input type=hidden name=email value='{$email}'>\r\n\t<input type=hidden name=saleterm value='{$saleterm}'>\r\n\t<input type=hidden name=traddisc value='{$traddisc}'>\r\n\t<input type=hidden name=setdisc value='{$setdisc}'>\r\n\t<input type=hidden name=listid value='{$listid}'>\r\n\t<input type=hidden name=chrgint value='{$chrgint}'>\r\n\t<input type=hidden name=overdue value='{$overdue}'>\r\n\t<input type=hidden name=chrgvat value='{$chrgvat}'>\r\n\t<input type=hidden name=vatinc value='{$vatinc}'>\r\n\t<input type=hidden name=credterm value='{$credterm}'>\r\n\t<input type=hidden name=odate value='{$odate}'>\r\n\t<input type=hidden name=credlimit value='{$credlimit}'>\r\n\t<input type=hidden name=block value='{$block}'>\r\n\t<tr><th>Field</th><th>Value</th></tr>\r\n\t<tr class='bg-odd'><td>Acc No</td><td>{$accno}</td></tr>\r\n\t<tr class='bg-odd'><td>Surname/Company</td><td>{$surname}</td></tr>\r\n\t<tr class='bg-odd'><td>Title</td><td>{$title}</td></tr>\r\n\t<tr class='bg-odd'><td>Initials</td><td>{$init}</td></tr>\r\n\t<tr class='bg-odd'><td>First Name</td><td>{$firstname}</td></tr>\r\n\t<tr class='bg-odd'><td>Category</td><td>{$category}</td></tr>\r\n\t<tr class='bg-odd'><td>Classification</td><td>{$class}</td></tr>\r\n\t<tr class='bg-odd'><td>Postal Address</td><td><pre>{$paddr}</pre></td></tr>\r\n\t<tr class='bg-odd'><td>Delivery Address</td><td><pre>{$daddr}</pre></td></tr>\r\n\t<tr class='bg-odd'><td>Contact Name</td><td>{$contname}</td></tr>\r\n\t<tr class='bg-odd'><td>Business Tel.</td><td>{$bustel}</td></tr>\r\n\t<tr class='bg-odd'><td>Home Tel.</td><td>{$hometel}</td></tr>\r\n\t<tr class='bg-odd'><td>Cell No.</td><td>{$cellno}</td></tr>\r\n\t<tr class='bg-odd'><td>Fax No.</td><td>{$faxno}</td></tr>\r\n\t<tr class='bg-odd'><td>E-mail</td><td>{$email}</td></tr>\r\n\t<tr class='bg-odd'><td>Sale Term</td><td>{$saleterm}</td></tr>\r\n\t<tr class='bg-odd'><td>Trade Discount</td><td>{$traddisc}</td></tr>\r\n\t<tr class='bg-odd'><td>Settlement Discount</td><td>{$setdisc}</td></tr>\r\n\t<tr class='bg-odd'><td>Price List</td><td>{$plist}</td></tr>\r\n\t<tr class='bg-odd'><td>Charge Interest</td><td>{$chrgint}</td></tr>\r\n\t<tr class='bg-odd'><td>Overdue</td><td>{$overdue}</td></tr>\r\n\t<tr class='bg-odd'><td>Charge Vat</td><td>{$chrgvat}</td></tr>\r\n\t<tr class='bg-odd'><td>Vat Inclusive</td><td>{$vatinc}</td></tr>\r\n\t<tr class='bg-odd'><td>Account Open Date</td><td>{$odate}</td></tr>\r\n\t<tr class='bg-odd'><td>Credit Term</td><td>{$credterm}</td></tr>\r\n\t<tr class='bg-odd'><td>Credit Limit</td><td>{$credlimit}</td></tr>\r\n\t<tr class='bg-odd'><td>Block Account</td><td>{$block}</td></tr>\r\n\t<tr><td colspan=2 align=right><input type=submit value='Confirm »'></td></tr>\r\n\t</table></form>\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 class='bg-odd'><td><a href='cust-view.php'>View Customers</a></td></tr>\r\n\t<tr class='bg-odd'><td><a href='index.php'>Index</a></td></tr>\r\n\t<tr class='bg-odd'><td><a href='toms-settings.php'>Settings</a></td></tr>\r\n\t<tr class='bg-odd'><td><a href='../main.php'>Main Menu</a></td></tr>\r\n\t</table>";
return $confirm;
}
function write($_POST)
{
# get vars
foreach ($_POST as $key => $value) {
${$key} = $value;
}
if (isset($back)) {
return enter_err($_POST);
}
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($des, "string", 1, 255, "Invalid decription.");
$v->isOk($amount, "float", 1, 255, "Invalid amount.");
$v->isOk($bdate, "string", 10, 10, "Invalid Date .");
$v->isOk($funds, "string", 1, 255, "Invalid method.");
# 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;
}
//$date = date("Y-m-d");
$date = $bdate;
db_connect();
if ($funds == "out") {
$amount = $amount * -1;
}
$Sl = "INSERT INTO cf(description, date, amount, div) VALUES ('{$des}','{$date}','{$amount}', '" . USER_DIV . "')";
$Rs = db_exec($Sl) or errDie("Unable to add supplier to the system.", SELF);
if (pg_cmdtuples($Rs) < 1) {
return "<li class=err>Unable to add entry to database.</li>";
}
$write = "<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "' width='50%'>\n\t<tr><th>Cash flow budget entry added to the system</th></tr>\n\t<tr class=datacell><td>New cash flow budget entry has been added to the system.</td></tr>\n\t</table>\n\t<p>\n\t<table border=0 cellpadding='2' cellspacing='1'>\n\t<tr><th>Quick Links</th></tr>\n\t<tr class='bg-odd'><td><a href='cfe-add.php'>New cash flow budget entry</a></td></tr>\n\t<tr class='bg-odd'><td><a href='cfe-view.php'>View cash flow budget entries</a></td></tr>\n\t<script>document.write(getQuicklinkSpecial());</script>\n\t</table>";
return $write;
}
function con_data($_POST)
{
# get vars
foreach ($_POST as $key => $value) {
${$key} = $value;
}
//confirm inserted data
# validate input
require_lib("validate");
$v = new validate();
# Limit field lengths as per database settings
$v->isOk($grpname, "string", 1, 15, "Invalid group name.");
$v->isOk($unit, "string", 1, 15, "Invalid group unit.");
# display errors, if any
if ($v->isError()) {
$theseErrors = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$theseErrors .= "<li class=err>" . $e["msg"] . "</li>";
}
//get errors
return enter_err($_POST, $theseErrors);
exit;
$theseErrors .= "<p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>";
return $theseErrors;
}
$con_data = "<h3>Confirm Group Details</h3>\r\n\t\t<table cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\r\n\t\t<form action='" . SELF . "' method=post>\r\n\t\t<input type=hidden name=key value='write'>\r\n\t\t<input type=hidden name=grpname value='{$grpname}'>\r\n\t\t<input type=hidden name=unit value='{$unit}'>\r\n\t\t\r\n\t\t<tr><th colspan=2>Group Details</th></tr>\r\n\t\t<tr class='bg-odd'><td>Group name</td><td align=center>{$grpname}</td></tr>\r\n\t\t<tr class='bg-odd'><td>Group unit</td><td align=center>{$unit}</td></tr>\r\n\t\t<tr><td colspan=2 align=left><input type=submit value='Write »'></td></tr>\r\n\t</form>\r\n\t</table>";
return $con_data;
}
function con_data($_POST)
{
# get vars
foreach ($_POST as $key => $value) {
${$key} = $value;
}
//confirm inserted data
# validate input
require_lib("validate");
$v = new validate();
# Limit field lengths as per database settings
$v->isOk($username, "string", 0, 20, "Invalid username name.");
$v->isOk($name, "string", 1, 20, "Invalid name.");
$v->isOk($email, "email", 1, 30, "Invalid email address.");
$v->isOk($cell, "string", 1, 20, "Invalid mobile no.");
$v->isOk($Cons, "string", 2, 3, "Invalid private.");
$v->isOk($Grps, "string", 2, 3, "Invalid groups .");
# display errors, if any
if ($v->isError()) {
$theseErrors = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$theseErrors .= "<li class=err>" . $e["msg"] . "</li>";
}
//get errors
return enter_err($_POST, $theseErrors);
exit;
$theseErrors .= "<p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>";
return $theseErrors;
}
$con_data = "<h3>Confirm User Details</h3>\r\n\t\t<table cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\r\n\t\t<form action='" . SELF . "' method=post>\r\n\t\t<input type=hidden name=key value='write'>\r\n\t\t<input type=hidden name=username value='{$username}'>\r\n\t\t<input type=hidden name=name value='{$name}'>\r\n\t\t<input type=hidden name=email value='{$email}'>\r\n\t\t<input type=hidden name=cell value='{$cell}'>\r\n\t\t<input type=hidden name=Cons value='{$Cons}'>\r\n\t\t<input type=hidden name=Grps value='{$Grps}'>\r\n\t\t\r\n\t\t\r\n\t\t<tr><th colspan=2>User Details</th></tr>\r\n\t\t<tr class='bg-odd'><td>Username</td><td align=center>{$username}</td></tr>\r\n\t\t<tr class='bg-odd'><td>Name</td><td align=center>{$name}</td></tr>\r\n\t\t<tr class='bg-odd'><td>Email</td><td align=center>{$email}</td></tr>\r\n\t\t<tr class='bg-odd'><td>Cellphone</td><td align=center>{$cell}</td></tr>\r\n\t\t<tr class='bg-even'><td>Private</td><td align=center>{$Cons}</td></tr>\r\n\t \t<tr class='bg-odd'><td>Initial Group</td><td align=center>{$Grps}</td></tr>\r\n\t\t<tr><td colspan=2 align=left><input type=submit value='Write »'></td></tr>\r\n\t</form>\r\n\t</table>";
return $con_data;
}
function write($_POST)
{
# get vars
foreach ($_POST as $key => $value) {
${$key} = $value;
}
if (isset($back)) {
return enter_err($_POST);
}
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($cusnum, "num", 1, 255, "Invalid Department.");
$v->isOk($branch_name, "string", 1, 255, "Invalid branch name.");
$v->isOk($branch_descrip, "string", 0, 255, "Invalid branch description.");
# 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;
}
db_conn("cubit");
$insert_sql = "UPDATE customer_branches SET branch_name = '{$branch_name}', branch_descrip = '{$branch_descrip}' WHERE cusnum = '{$cusnum}' AND div = '" . USER_DIV . "' AND id = '{$editid}'";
$run_insert = db_exec($insert_sql);
return "<script>\n\t\t\twindow.close ();\n\t\t</script>";
// return "Branch added";
}
function con_data($_POST)
{
# get vars
foreach ($_POST as $key => $value) {
${$key} = $value;
}
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($docref, "string", 0, 255, "Invalid Document reference.");
$v->isOk($docname, "string", 1, 255, "Invalid Document name.");
$date = $day . "-" . $mon . "-" . $year;
if (!checkdate($mon, $day, $year)) {
$v->isOk($date, "num", 1, 1, "Invalid date.");
}
$v->isOk($descrip, "string", 0, 255, "Invalid Document Description.");
# display errors, if any
if ($v->isError()) {
$confirmCust = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirmCust .= "<li class=err>" . $e["msg"] . "</li>";
}
return enter_err($_POST, $confirmCust);
exit;
$confirmCust .= "<p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>";
return $confirmCust;
}
$con_data = "<h3>Confirm Document details</h3>\r\n\t<table cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\r\n\t<form action='" . SELF . "' method=post>\r\n\t<input type=hidden name=key value=write>\r\n\t<input type=hidden name=docref value='{$docref}'>\r\n\t<input type=hidden name=docname value='{$docname}'>\r\n\t<input type=hidden name=day value='{$day}'>\r\n\t<input type=hidden name=mon value='{$mon}'>\r\n\t<input type=hidden name=year value='{$year}'>\r\n\t<input type=hidden name=descrip value='{$descrip}'>\r\n \t\r\n\t<tr><th>Field</th><th>Value</th></tr>\r\n\t<tr class='bg-odd'><td>Ref</td><td>{$docref}</td></tr>\r\n\t<tr class='bg-even'><td>Document Name</td><td>{$docname}</td></tr>\r\n\t<tr class='bg-even'><td>Date</td><td align=center>{$date}</td></tr>\r\n\t<tr class='bg-even'><td>Description</td><td>{$descrip}</td></tr>\r\n\t<tr><td colspan=2 align=right><input type=submit value='Write »'></td></tr>\r\n\t</form>\r\n\t</table>\r\n\t<p>\r\n\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\r\n\t<tr><th>Quick Links</th></tr>\r\n\t<tr class='bg-odd'><td><a href='list_consdel.php'>List Documents</a></td></tr>\r\n </table>";
return $con_data;
}
function write($_POST)
{
# Get vars
extract($_POST);
if (isset($back)) {
return enter_err($_POST);
}
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($deptid, "num", 1, 255, "Invalid Department.");
$v->isOk($supno, "string", 1, 255, "Invalid supplier number.");
$v->isOk($supname, "string", 1, 255, "Invalid supplier name.");
$v->isOk($loc, "string", 1, 3, "Invalid Type.");
$v->isOk($fcid, "num", 1, 30, "Invalid Currency.");
$v->isOk($supaddr, "string", 1, 255, "Invalid supplier address.");
$v->isOk($contname, "string", 1, 255, "Invalid contact name.");
$v->isOk($tel, "string", 1, 20, "Invalid tel no.");
$v->isOk($fax, "string", 0, 20, "Invalid fax no.");
$v->isOk($listid, "num", 1, 20, "Invalid price list.");
$v->isOk($bee_training, "string", 0, 255, "Invalid BEE Status");
$v->isOk($comments, "string", 0, 255, "Invalid Notes");
# 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;
}
db_conn('cubit');
$Sl = "SELECT * FROM suppliers WHERE supno='{$supno}'";
$Ri = db_exec($Sl) or errDie("Unable to get data.");
if (pg_num_rows($Ri) > 0) {
return enter_err($_POST, "<li class='err'>There is already a supplier with that number.</li>");
}
# Connect to db
db_connect();
$curr = getSymbol($fcid);
if (!pglib_transaction("BEGIN")) {
return "<li class='err'>Unable to add supplier to database. (TB)</li>";
}
# Write to db
$sql = "INSERT INTO suppliers(deptid, supno, supname, location, fcid, currency, supaddr, contname, tel, fax, listid, balance, fbalance, div, bee_training, comments)\r\n\tVALUES ('{$deptid}', '{$supno}', '{$supname}', '{$loc}', '{$fcid}', '{$curr['symbol']}', '{$supaddr}', '{$contname}', '{$tel}', '{$fax}', '{$listid}', 0, 0, '" . USER_DIV . "', '{$bee_training}', '{$comments}')";
$supRslt = db_exec($sql) or errDie("Unable to add supplier to the system.", SELF);
if (pg_cmdtuples($supRslt) < 1) {
return "<li class='err'>Unable to add supplier to database.</li>";
}
if (($supp_id = pglib_lastid("suppliers", "supid")) == 0) {
return "<li class='err'>Unable to add supplier to contact list.</li>";
}
# Check if should be added to contact list
db_connect();
$sql = "INSERT INTO cons (name,surname,comp,ref,tell,cell,fax,hadd,padd,date,supp_id,con,by,div)\r\n\tVALUES ('{$contname}','{$supname}','','Supplier','{$tel}','','{$fax}','{$supaddr}','',CURRENT_DATE, '{$supp_id}', 'No', '" . USER_NAME . "','" . USER_DIV . "')";
$rslt = db_exec($sql) or errDie("Unable to add supplier to contact list.", SELF);
if (!pglib_transaction("COMMIT")) {
return "<li class='err'>Unable to add supplier to database. (TC)</li>";
}
$Date = date("Y-m-d");
db_conn('audit');
$Sl = "SELECT * FROM closedprd ORDER BY id";
$Ri = db_exec($Sl);
while ($pd = pg_fetch_array($Ri)) {
db_conn($pd['prdnum']);
$Sl = "INSERT INTO suppledger(supid,contra,edate,sdate,eref,descript,credit,debit,div,dbalance,cbalance) VALUES \r\n\t\t('{$supp_id}','0','{$Date}','{$Date}','0','Balance','0','0','" . USER_DIV . "','0','0')";
$Rj = db_exec($Sl) or errDie("Unable to insert cust balances");
}
if (isset($crm)) {
header("Location: crm/tokens-new.php?value={$supname}");
exit;
}
if ($re != "no") {
db_conn('cubit');
$re += 0;
$Sl = "UPDATE purchases SET supid='{$supp_id}' WHERE purid='{$re}'";
$Ri = db_exec($Sl);
//print $Sl;exit;
header("Location: purchase-new.php?purid={$re}&cont=1&letters=");
exit;
}
$write = "\r\n\t\t\t\t<table " . TMPL_tblDflts . " width='50%'>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<th>Supplier added to the system</th>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t<td>New Supplier <b>{$supname}</b>, has been successfully added to the system.</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t</table>\r\n\t\t\t\t<p>\r\n\t\t\t\t<table border=0 cellpadding='2' cellspacing='1'>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<th>Quick Links</th>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t<td><a href='supp-new.php'>Add Supplier</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t<td><a href='supp-view.php'>View Suppliers</a></td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t<td><a href='main.php'>Main Menu</a></td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t</table>";
return $write;
}
function confirm($_POST)
{
# get vars
foreach ($_POST as $key => $value) {
${$key} = $value;
}
# validate input
require_lib("validate");
$v = new validate();
/*$v->isOk ($deptid, "num", 1, 255, "Invalid Department.");
$v->isOk ($supno, "string", 1, 255, "Invalid supplier number.");
$v->isOk ($supname, "string", 1, 255, "Invalid supplier name.");
$v->isOk ($supaddr, "string", 1, 255, "Invalid supplier address.");
$v->isOk ($contname, "string", 1, 255, "Invalid contact name.");
$v->isOk ($tel, "string", 1, 20, "Invalid tel no.");
$v->isOk ($fax, "string", 0, 20, "Invalid fax no.");
$v->isOk ($email, "email", 0, 255, "Invalid e-mail address.");
$v->isOk ($bankname, "string", 1, 255, "Invalid bank name.");
$v->isOk ($branname, "string", 0, 255, "Invalid branch name.");
$v->isOk ($brancode, "num", 1, 255, "Invalid branch code.");
$v->isOk ($bankaccno, "num", 1, 255, "Invalid bank account number.");*/
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class=err>" . $e["msg"];
}
return enter_err($_POST, $confirm);
exit;
$confirm .= "<p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>";
return $confirm;
}
# get department
db_conn("cubit");
$Sl = "SELECT * FROM deptscripts WHERE script = '{$script}'";
$Rs = db_exec($Sl);
if (pg_numrows($Rs) < 1) {
return "<li class=err>Script not Found.";
} else {
$dept = pg_fetch_array($Rs);
$deptid = $dept['dept'];
}
if (pg_numrows($Rs) > 1) {
return "<li class=err>Script Found more than once.";
}
$Sl = "SELECT * FROM depts WHERE deptid = '{$deptid}'";
$Rs = db_exec($Sl);
if (pg_numrows($Rs) < 1) {
return "<li class=err>Department not Found.";
} else {
$dept = pg_fetch_array($Rs);
$deptname = $dept['dept'];
}
if (pg_numrows($Rs) > 1) {
return "<li class=err>Department Found more than once.";
}
$depts = ext_dbsel('dept', 'depts', 'deptid', 'dept', 'There are no departments');
$confirm = "<h3>Access</h3>\r\n\t<form action='" . SELF . "' method=post>\r\n\t<table cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\r\n\t<input type=hidden name=key value=write>\r\n\t<input type=hidden name=script value='{$script}'>\r\n\t<table cellpadding=0 cellspacing=0>\r\n\t<tr valign=top><td>\r\n\t\t<table cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\r\n\t\t<tr><th colspan=2>Script Details</th></tr>\r\n\t\t<tr class='bg-even'><td>Department</td><td>{$deptname}</td></tr>\r\n\t\t<tr><th colspan=2>Move To</th></tr>\r\n\t\t<tr class='bg-even'><td>Department</td><td>{$depts}</td></tr>\r\n\t\t</table>\r\n\t</td></tr>\r\n\t<tr><td colspan=2 align=right><input type=submit value='Write »'></td></tr>\r\n\t\t</table></form>\r\n\t</td></tr>\r\n\t</table>";
return $confirm;
}
