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