function view($VARS = array(), $err = "")
{
extract($VARS);
if (!isset($accid)) {
$accid = "";
}
$vars = array("bankname", "branchname", "loc", "fcid", "branchcode", "accname", "accnum", "cardnum", "mon", "year", "lastdigits", "cardname", "cardtyp", "details");
$vard = array("cardtyp" => "Visa", "mon" => date("m"), "year" => date("Y"));
foreach ($vars as $key => $val) {
if (!isset(${$val})) {
${$val} = isset($vard[$val]) ? $vard[$val] : "";
}
}
if (strlen($lastdigits) < 1) {
$lastdigits = "000";
}
db_connect();
# Locations drop down
$locs = array("loc" => "Local", "int" => "International");
$locsel = extlib_cpsel("loc", $locs, $loc);
# currency drop down
$currsel = ext_unddbsel("fcid", "currency", "fcid", "descrip", "There are is no currency found in Cubit, please add currency first.", $fcid);
$chm = "";
$chv = "";
$cho = "";
if ($cardtyp == 'Visa') {
$chv = "checked=yes";
} elseif ($cardtyp == 'Mastercard') {
$chm = "checked=yes";
} else {
$cho = "checked=yes";
}
core_connect();
$sql = "SELECT * FROM accounts WHERE acctype = 'B' AND div = '" . USER_DIV . "' ORDER BY accname";
$accRslt = db_exec($sql) or errDie("Could not retrieve accounts from Cubit.", SELF);
if (pg_numrows($accRslt) < 1) {
return "<li> There are no balance accouts in Cubit.";
}
$accs = "<select name='accid'>";
while ($acc = pg_fetch_array($accRslt)) {
if (isbank($acc['accid'])) {
continue;
}
if (isb($acc['accid'])) {
continue;
}
if ($accid == $acc['accid']) {
$accs .= "<option value='{$acc['accid']}' selected>{$acc['accname']}</option>";
} else {
$accs .= "<option value='{$acc['accid']}'>{$acc['accname']}</option>";
}
}
$accs .= "</select>";
//layout
$view = "\n\t\t<h3>Add New Credit Card Account</h3>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t<form action='" . SELF . "' method='POST' name='form'>\n\t\t\t<input type='hidden' name='key' value='confirm'>\n\t\t\t<tr>\n\t\t\t\t<td colspan='2'>{$err}</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<th>Field</th>\n\t\t\t\t<th>Value</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>" . REQ . "Bank Name</td>\n\t\t\t\t<td><input type='text' size='20' name='bankname' value='{$bankname}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>" . REQ . "Type</td>\n\t\t\t\t<td>{$locsel}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>" . REQ . "Currency</td>\n\t\t\t\t<td>{$currsel}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>" . REQ . "Branch Name</td>\n\t\t\t\t<td><input type='text' size='20' name='branchname' value='{$branchname}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>" . REQ . "Branch Code</td>\n\t\t\t\t<td><input type='text' size='20' name='branchcode' value='{$branchcode}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>" . REQ . "Account Name</td>\n\t\t\t\t<td><input type='text' size='20' name='accname' maxlength='50' value='{$accname}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>" . REQ . "Account Number</td>\n\t\t\t\t<td><input type='text' size='20' name='accnum' value='{$accnum}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>" . REQ . "Ledger Account</td>\n\t\t\t\t<td>{$accs}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>" . REQ . "Card Number</td>\n\t\t\t\t<td><input type='text' size='25' name='cardnum' maxlength='16' value='{$cardnum}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>" . REQ . "Expiry Date</td>\n\t\t\t\t<td>\n\t\t\t\t\t<input type='text' size='2' name='mon' maxlength='2' value='{$mon}'>-\n\t\t\t\t\t<input type='text' size='4' name='year' maxlength='4' value='{$year}'>MM-YYYY\n\t\t\t\t</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>" . REQ . "Last 3 Digits at back of Card</td>\n\t\t\t\t<td><input type='text' size='3' maxlength='3' name='lastdigits' value='{$lastdigits}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Card Type</td>\n\t\t\t\t<td><input type='radio' name='cardtyp' value='Visa' {$chv}>Visa <input type='radio' name='cardtyp' value='Mastercard' {$chm}> Mastercard <input type='radio' name='cardtyp' value='other' {$cho}>Other: <input type='text' name='cardname' value='{$cardname}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>" . REQ . "Details</td>\n\t\t\t\t<td><textarea cols='20' rows='3' name='details'>{$details}</textarea></td>\n\t\t\t</tr>\n\t\t\t<tr><td><br></td></tr>\n\t\t\t<tr>\n\t\t\t\t<td><input type='button' value='« Cancel' onClick='javascript:history.back();'></td>\n\t\t\t\t<td><input type='submit' value='Confirm »'></td>\n\t\t\t</tr>\n\t\t</form>\n\t\t</table>\n\t\t<p>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<th>Quick Links</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td><a href='../core/acc-new2.php'>Add Ledger Account</a></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td><a href='../main.php'>Main Menu</a></td>\n\t\t\t</tr>\n\t\t</table>";
return $view;
}
function view($VARS = array(), $err = "")
{
foreach ($VARS as $key => $vals) {
${$key} = $vals;
}
$vars = array("bankname", "branchname", "loc", "fcid", "branchcode", "accname", "accnum", "cardnum", "mon", "year", "lastdigits", "cardname", "cardtyp", "details");
$vard = array("cardtyp" => "Visa", "mon" => date("m"), "year" => date("Y"));
foreach ($vars as $key => $val) {
if (!isset(${$val})) {
${$val} = isset($vard[$val]) ? $vard[$val] : "";
}
}
if (strlen($lastdigits) < 1) {
$lastdigits = "000";
}
db_connect();
# Locations drop down
$locs = array("loc" => "Local", "int" => "International");
$locsel = extlib_cpsel("loc", $locs, $loc);
# currency drop down
$currsel = ext_unddbsel("fcid", "currency", "fcid", "descrip", "There are is no currency found in Cubit, please add currency first.", "");
$chm = "";
$chv = "";
$cho = "";
if ($cardtyp == 'Visa') {
$chv = "checked=yes";
} elseif ($cardtyp == 'Mastercard') {
$chm = "checked=yes";
} else {
$cho = "checked=yes";
}
core_connect();
$sql = "SELECT * FROM accounts WHERE acctype = 'B' AND div = '" . USER_DIV . "' ORDER BY accname";
$accRslt = db_exec($sql) or errDie("Could not retrieve accounts from Cubit.", SELF);
if (pg_numrows($accRslt) < 1) {
return "<li> There are no balance accouts in Cubit.";
}
$accs = "<select name=accid>";
while ($acc = pg_fetch_array($accRslt)) {
if (isbank($acc['accid'])) {
continue;
}
if (isb($acc['accid'])) {
continue;
}
$accs .= "<option value='{$acc['accid']}'>{$acc['accname']}</option>";
}
$accs .= "</select>";
//layout
$view = "\n\t<h3>Add New Petrol Card Account</h3>\n\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\n\t<form action='" . SELF . "' method=post name=form>\n\t<input type=hidden name=key value=confirm>\n\t<tr><td colspan=2>{$err}</td></tr>\n\t<tr><th>Field</th><th>Value</th></tr>\n\t<tr class='bg-odd'><td>" . REQ . "Bank Name</td><td ><input type=text size=20 name=bankname value='{$bankname}'></td></tr>\n\t<tr class='bg-even'><td>" . REQ . "Type</td><td>{$locsel}</td></tr>\n\t<tr class='bg-odd'><td>" . REQ . "Currency</td><td>{$currsel}</td></tr>\n\t<tr class='bg-even'><td>" . REQ . "Branch Name</td><td ><input type=text size=20 name=branchname value='{$branchname}'></td></tr>\n\t<tr class='bg-odd'><td>" . REQ . "Branch Code</td><td ><input type=text size=20 name=branchcode value='{$branchcode}'></td></tr>\n\t<tr class='bg-even'><td>" . REQ . "Account Name</td><td ><input type=text size=20 name=accname maxlength=50 value='{$accname}'></td></tr>\n\t<tr class='bg-odd'><td>" . REQ . "Account Number</td><td ><input type=text size=20 name=accnum value='{$accnum}'></td></tr>\n\t<tr class='bg-even'><td>" . REQ . "Ledger Account</td><td>{$accs}</td></tr>\n\t<tr class='bg-odd'><td>" . REQ . "Card Number</td><td ><input type=text size=25 name=cardnum maxlength=16 value='{$cardnum}'></td></tr>\n\t<tr class='bg-even'><td>" . REQ . "Expiry Date</td><td><input type=text size=2 name=mon maxlength=2 value='{$mon}'>-<input type=text size=4 name=year maxlength=4 value='{$year}'>MM-YYYY</td></tr>\n\t<tr class='bg-odd'><td>" . REQ . "Last 3 Digits at back of Card</td><td ><input type=text size=3 maxlength=3 name=lastdigits value='{$lastdigits}'></td></tr>\n\t<tr class='bg-even'><td>Card Type</td><td><input type=radio name=cardtyp value=Visa {$chv}>Visa <input type=radio name=cardtyp value='Mastercard' {$chm}> Mastercard <input type=radio name=cardtyp value='other' {$cho}>Other: <input type=text name=cardname value='{$cardname}'></td>\n\t<tr class='bg-odd'><td>" . REQ . "Details</td><td ><textarea cols=20 rows=3 name=details>{$details}</textarea></td></tr>\n\t<tr><td><br></td></tr>\n\t<tr><td><input type=button value='« Cancel' onClick='javascript:history.back();'></td><td ><input type=submit value='Confirm »'></td></tr>\n\t</form>\n\t</table>\n\t<p>\n\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\n\t\t<tr><th>Quick Links</th></tr>\n\t\t<tr class='bg-odd'><td><a href='../core/acc-new2.php'>Add Ledger Account</a></td></tr>\n\t\t<tr class='bg-odd'><td><a href='../main.php'>Main Menu</a></td></tr>\n\t</table>";
return $view;
}
function view($acctype = "", $bankname = "", $loc = "", $branchname = "", $branchcode = "", $accname = "", $accnum = "", $details = "", $err = "")
{
db_connect();
# Locations drop down
$locs = array("loc" => "Local", "int" => "International");
$locsel = extlib_cpsel("loc", $locs, $loc);
# currency drop down
$currsel = ext_unddbsel("fcid", "currency", "fcid", "descrip", "There are is no currency found in Cubit, please add currency first.", "");
//layout
$view = "\n\t\t<h3>Add New Bank Account</h3>\n\t\t<table " . TMPL_tblDflts . " width='300'>\n\t\t<form action='" . SELF . "' method='POST' name='form'>\n\t\t\t<input type='hidden' name='key' value='confirm'>\n\t\t\t{$err}\n\t\t\t<tr>\n\t\t\t\t<th>Field</th>\n\t\t\t\t<th>Value</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>" . REQ . "Type of Account</td>\n\t\t\t\t<td valign='center'><input type='text' size='20' name='acctype' value='{$acctype}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>" . REQ . "Bank Name</td>\n\t\t\t\t<td valign='center'><input type='text' size='20' name='bankname' value='{$bankname}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>" . REQ . "Type</td>\n\t\t\t\t<td>{$locsel}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>" . REQ . "Currency</td>\n\t\t\t\t<td>{$currsel}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>" . REQ . "Branch Name</td>\n\t\t\t\t<td valign='center'><input type='text' size='20' name='branchname' value='{$branchname}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>" . REQ . "Branch Code</td>\n\t\t\t\t<td valign='center'><input type='text' size='20' name='branchcode' value='{$branchcode}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>" . REQ . "Account Name</td>\n\t\t\t\t<td valign='center'><input type='text' size='20' name='accname' maxlength='50' value='{$accname}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>" . REQ . "Account Number</td>\n\t\t\t\t<td valign='center'><input type='text' size='20' name='accnum' value='{$accnum}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>" . REQ . "Account Category</td>\n\t\t\t\t<td>\n\t\t\t\t\t<select name='catid'>";
core_connect();
$sql = "SELECT * FROM balance WHERE div = '" . USER_DIV . "' ORDER BY catname";
$catRslt = db_exec($sql) or errDie("Could not retrieve Categories Information from the Database.", SELF);
$rows = pg_numrows($catRslt);
if ($rows < 1) {
return "There are no Account Categories under Balance";
}
while ($cat = pg_fetch_array($catRslt)) {
$view .= "<option value='{$cat['catid']}'>{$cat['catname']}</option>";
}
$view .= "\n\t\t\t\t\t</select>\n\t\t\t\t</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>" . REQ . "Details</td>\n\t\t\t\t<td valign='center'><textarea cols='20' rows='5' name='details'>{$details}</textarea></td></tr>\n\t\t\t<tr>\n\t\t\t\t<td></td>\n\t\t\t\t<td valign='center' align='right'><input type='submit' value='Confirm »'></td>\n\t\t\t</tr>\n\t\t</form>\n\t\t</table>\n\t\t<p>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<th>Quick Links</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td><a href='../core/acc-new2.php'>Add Ledger Account</a></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td><a href='../main.php'>Main Menu</a></td>\n\t\t\t</tr>\n\t\t</table>";
return $view;
}
function editAccnt($bankid)
{
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($bankid, "num", 1, 4, "Invalid Bank Account ID.");
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class=err>" . $e["msg"];
}
$confirm .= "<p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>";
return $confirm;
}
// Connect to database
db_Connect();
$sql = "SELECT * FROM bankacct WHERE bankid='{$bankid}' AND div = '" . USER_DIV . "'";
$bankRslt = db_exec($sql) or errDie("ERROR: Unable to retrieve bank account details from database.", SELF);
$numrows = pg_numrows($bankRslt);
if ($numrows < 1) {
$OUTPUT = "<li> - Invalid Bank account ID.";
return $OUTPUT;
}
$accnt = pg_fetch_array($bankRslt);
if (strlen($accnt['accname']) < 20) {
$size = 20;
} else {
$size = strlen($accnt['accname']);
}
// Get Bank account [the traditional way re: hook of hook]
core_connect();
$sql = "SELECT * FROM bankacc WHERE accid = '{$bankid}' AND div = '" . USER_DIV . "'";
$Rslt = db_exec($sql) or errDie("Unable to retrieve bank account link from Cubit", SELF);
# check if link exists
if (pg_numrows($Rslt) < 1) {
return "<li class=err> ERROR : The bank account that you selected doesn't appear to have an account linked to it.";
}
$bank = pg_fetch_array($Rslt);
$bankaccid = $bank["accnum"];
# Check account balance
$sql = "SELECT * FROM trial_bal WHERE period='" . PRD_DB . "' AND accid = '{$bankaccid}' AND debit > 0 OR accid = '{$bankaccid}' AND credit > 0";
$accRslt = db_exec($sql);
if (pg_numrows($accRslt) > 0) {
$acc = pg_fetch_array($accRslt);
$account = "<input type=hidden name='glacc' value='{$acc['accid']}'>{$acc['accname']}";
} else {
core_connect();
# income accounts ($inc)
$account = "<select name='glacc'>";
$sql = "SELECT * FROM accounts WHERE acctype ='B'";
$accRslt = db_exec($sql);
$numrows = pg_numrows($accRslt);
if (empty($numrows)) {
return "<li> - There are no accounts yet in Cubit. Please set up accounts first.";
}
while ($acc = pg_fetch_array($accRslt)) {
if ($acc['accid'] == $bankaccid) {
$sal = "selected";
} else {
$sal = "";
}
$account .= "<option value='{$acc['accid']}' {$sal}>{$acc['accname']}</option>";
}
$account .= "</select>";
}
$cardname = "";
$chm = "";
$chv = "";
$cho = "";
if ($accnt['cardtype'] == 'Visa') {
$chv = "checked=yes";
} elseif ($accnt['cardtype'] == 'Mastercard') {
$chm = "checked=yes";
} else {
$cho = "checked=yes";
$cardname = $accnt['cardtype'];
}
db_connect();
# Locations drop down
$locs = array("loc" => "Local", "int" => "International");
$locsel = extlib_cpsel("loc", $locs, $accnt['btype']);
# currency drop down
$currsel = ext_unddbsel("fcid", "currency", "fcid", "descrip", "There are is no currency found in Cubit, please add currency first.", $accnt['fcid']);
// Set up table to display in
$OUTPUT = "\n\t<h3>Edit Bank Account</h3>\n\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\n\t<form action='" . SELF . "' method=post name=form>\n\t<input type=hidden name=key value=confirm>\n\t<input type=hidden name=bankid value={$bankid}>\n\t<tr><th>Field</th><th>Value</th></tr>\n\t<tr class='bg-odd'><td>Type of Account</td><td valign=center><input type=hidden size=20 name=acctype value='{$accnt['acctype']}'>{$accnt['acctype']}</td></tr>\n\t<tr class='bg-even'><td>Bank Name</td><td valign=center><input type=text size=20 name=bankname value='{$accnt['bankname']}'></td></tr>\n\t<tr class='bg-odd'><td>Type</td><td>{$locsel}</td></tr>\n\t<tr class='bg-even'><td>Currency</td><td>{$currsel}</td></tr>\n\t<tr class='bg-odd'><td>Branch Name</td><td valign=center><input type=text size=20 name=branchname value='{$accnt['branchname']}'></td></tr>\n\t<tr class='bg-even'><td>Branch Code</td><td valign=center><input type=text size=20 name=branchcode value='{$accnt['branchcode']}'></td></tr>\n\t<tr class='bg-odd'><td>Account Name</td><td valign=center><input type=text size='{$size}' name=accname value='{$accnt['accname']}'></td></tr>\n\t<tr class='bg-even'><td>Account Number</td><td valign=center><input type=text name=accnum value='{$accnt['accnum']}'></td></tr>\n\t<tr class='bg-odd'><td>Ledger Account</td><td valign=center>{$account}</td></tr>\n\t<tr class='bg-even'><td>Card Number</td><td ><input type=text size=25 name=cardnum maxlength=16 value='{$accnt['cardnum']}'></td></tr>\n\t<tr class='bg-odd'><td>Expiry Date</td><td><input type=text size=2 name=mon maxlength=2 value='{$accnt['mon']}'>-<input type=text size=4 name=year maxlength=4 value='{$accnt['year']}'>MM-YYYY</td></tr>\n\t<tr class='bg-even'><td>Last 3 Digits at back of Card</td><td ><input type=text size=3 maxlength=3 name=lastdigits value='{$accnt['digits']}'></td></tr>\n\t<tr class='bg-odd'><td>Card Type</td><td><input type=radio name=cardtyp value=Visa {$chv}>Visa <input type=radio name=cardtyp value='Mastercard' {$chm}> Mastercard <input type=radio name=cardtyp value='other' {$cho}>Other: <input type=text name=cardname value='{$cardname}'></td>\n\t<tr class='bg-even'><td>Details</td><td valign=center><textarea cols=20 rows=5 name=details>{$accnt['details']}</textarea></td></tr>\n\t<tr><td><input type=button value='< Cancel' onClick='javascript:history.back();'></td><td valign=center><input type=submit value='Confirm >'></td></tr>\n\t</form>\n\t</table>\n\t<p>\n\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\n\t\t\t<tr><th>Quick Links</th></tr>\n\t\t<tr class='bg-odd'><td><a href='bankacct-view.php'>View Bank Accounts</a></td></tr>\n\t\t\t<tr class='bg-odd'><td><a href='../main.php'>Main Menu</a></td></tr>\n\t</table>";
// all template to display the info and die
require "../template.php";
}
function details($_POST, $error = "")
{
# Get vars
extract($_POST);
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($purid, "num", 1, 20, "Invalid Non-Stock Order number.");
# display errors, if any
if ($v->isError()) {
$errors = $v->getErrors();
foreach ($errors as $e) {
$error .= "<li class='err'>" . $e["msg"] . "</li>";
}
$confirm .= "{$error}<p><input type='button' onClick='JavaScript:history.back();' value='« Correct submission'>";
return $confirm;
}
# Get Order info
db_connect();
$sql = "SELECT * FROM nons_purch_int WHERE purid = '{$purid}' AND div = '" . USER_DIV . "'";
$purRslt = db_exec($sql) or errDie("Unable to get Order information");
if (pg_numrows($purRslt) < 1) {
return "<li class='err'>purchase Not Found</li>";
}
$pur = pg_fetch_array($purRslt);
# check if Order has been printed
if ($pur['received'] == "y") {
$error = "<li class='err'> Error : Order number <b>{$pur['purnum']}</b> has already been received.</li>";
$error .= "<p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>";
return $error;
}
/* --- Start Products Display --- */
# Products layout
$products = "\n\t\t\t\t\t<table " . TMPL_tblDflts . " width='100%'>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th>ITEM NUMBER</th>\n\t\t\t\t\t\t\t<th>DESCRIPTION</th>\n\t\t\t\t\t\t\t<th>QTY</th>\n\t\t\t\t\t\t\t<th colspan='2'>UNIT PRICE</th>\n\t\t\t\t\t\t\t<th colspan='2'>DUTY</th>\n\t\t\t\t\t\t\t<th>LINE TOTAL</th>\n\t\t\t\t\t\t<tr>";
# get selected stock in this Order
db_connect();
$sql = "SELECT * FROM nons_purint_items WHERE purid = '{$purid}' AND div = '" . USER_DIV . "'";
$stkdRslt = db_exec($sql);
while ($stkd = pg_fetch_array($stkdRslt)) {
# put in product
$products .= "\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>{$stkd['cod']}</td>\n\t\t\t\t\t\t\t<td>{$stkd['des']}</td>\n\t\t\t\t\t\t\t<td>{$stkd['qty']}</td>\n\t\t\t\t\t\t\t<td nowrap>{$pur['curr']} {$stkd['cunitcost']} or </td>\n\t\t\t\t\t\t\t<td nowrap>" . CUR . " {$stkd['unitcost']}</td>\n\t\t\t\t\t\t\t<td nowrap>{$pur['curr']} {$stkd['duty']} or </td>\n\t\t\t\t\t\t\t<td>{$stkd['dutyp']}%</td>\n\t\t\t\t\t\t\t<td nowrap>{$pur['curr']} {$stkd['amt']}</td>\n\t\t\t\t\t\t</tr>";
//$products .="<tr class='bg-odd'><td>$stkd[cod]</td><td>$stkd[des]</td><td>$stkd[qty]</td><td>$stkd[unitcost]</td><td>$dday-$dmon-$dyear</td><td>$pur[curr] $stkd[amt]</td></tr>";
}
$products .= "</table>";
/* --- End Products Display --- */
/* --- Start Some calculations --- */
# Get subtotal
$SUBTOT = sprint($pur['subtot']);
# Get Total
$TOTAL = sprint($pur['total']);
# Get tax
$tax = sprint($pur['tax']);
/* --- End Some calculations --- */
$currsel = ext_unddbsel("fcid", "currency", "fcid", "descrip", "No currencies were found in cubit, please add a currency first.", null);
# format date
list($pyear, $pmon, $pday) = explode("-", $pur['pdate']);
list($dyear, $dmon, $dday) = explode("-", $pur['ddate']);
/* -- Final Layout -- */
$details = "\n\t\t\t\t\t<center>\n\t\t\t\t\t<h3>International Non-Stock Order Cancel</h3>\n\t\t\t\t\t<form action='" . SELF . "' method='POST' name='form'>\n\t\t\t\t\t\t<input type='hidden' name='key' value='update'>\n\t\t\t\t\t\t<input type='hidden' name='purid' value='{$purid}'>\n\t\t\t\t\t<table " . TMPL_tblDflts . " width='95%'>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td valign='top'>\n\t\t\t\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t<th colspan='2'> Supplier Details </th>\n\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t\t\t\t<td>Supplier</td>\n\t\t\t\t\t\t\t\t\t\t<td valign='center'>{$pur['supplier']}</td>\n\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t\t\t\t<td>Supplier Address</td>\n\t\t\t\t\t\t\t\t\t\t<td valign='center'><pre>{$pur['supaddr']}</pre></td>\n\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t</table>\n\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t<td valign='top' align='right'>\n\t\t\t\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t<th colspan='2'> Non-Stock Order Details </th>\n\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t\t\t\t<td>Non-Stock Order No.</td>\n\t\t\t\t\t\t\t\t\t\t<td valign='center'>{$pur['purnum']}</td>\n\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t\t\t\t<td>Order No.</td>\n\t\t\t\t\t\t\t\t\t\t<td valign='center'>{$pur['ordernum']}</td>\n\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t\t\t\t<td>Terms</td>\n\t\t\t\t\t\t\t\t\t\t<td valign='center'>{$pur['terms']} Days</td>\n\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t\t\t\t<td>Date</td>\n\t\t\t\t\t\t\t\t\t\t<td valign='center'>{$pday}-{$pmon}-{$pyear}</td>\n\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t\t\t\t<td>Foreign Currency</td>\n\t\t\t\t\t\t\t\t\t\t<td valign='center'>{$currsel} Exchange rate {$pur['curr']} {$pur['xrate']}</td>\n\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t\t\t\t<td>Tax</td>\n\t\t\t\t\t\t\t\t\t\t<td valign='center'>{$pur['curr']} {$pur['tax']}</td>\n\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t\t\t\t<td>Shipping Charges</td>\n\t\t\t\t\t\t\t\t\t\t<td valign='center'>{$pur['curr']} {$pur['shipchrg']}</td>\n\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t\t\t\t<td>Delivery Date</td>\n\t\t\t\t\t\t\t\t\t\t<td valign='center'>{$dday}-{$dmon}-{$dyear}</td>\n\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t</table>\n\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr><td><br></td></tr>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td colspan='2'>{$products}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t<th width='40%'>Quick Links</th>\n\t\t\t\t\t\t\t\t\t\t<th width='45%'>Remarks</th>\n\t\t\t\t\t\t\t\t\t\t<td rowspan='5' valign='top' width='15%'><br></td>\n\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t<td class='" . bg_class() . "'><a href='nons-purch-int-new.php'>New International Non-Stock Order</a></td>\n\t\t\t\t\t\t\t\t\t\t<td class='" . bg_class() . "' rowspan='4' align='center' valign='top'>" . nl2br($pur['remarks']) . "</td>\n\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t\t\t\t<td><a href='nons-purch-int-view.php'>View International Non-Stock Orders</a></td>\n\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t\t\t\t\t\t\t\t</table>\n\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t<td align='right'>\n\t\t\t\t\t\t\t\t<table " . TMPL_tblDflts . " width='80%'>\n\t\t\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t\t\t\t<td>SUBTOTAL</td>\n\t\t\t\t\t\t\t\t\t\t<td align='right'>{$pur['curr']} {$pur['subtot']}</td>\n\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t\t\t\t<td>Delivery Charges</td>\n\t\t\t\t\t\t\t\t\t\t<td align='right'>{$pur['curr']} {$pur['shipping']}</td>\n\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t\t\t\t<td>Tax </td>\n\t\t\t\t\t\t\t\t\t\t<td align='right'>{$pur['curr']} {$pur['tax']}</td>\n\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t\t\t\t<th>GRAND TOTAL</th>\n\t\t\t\t\t\t\t\t\t\t<td align='right'>{$pur['curr']} {$pur['total']}</td>\n\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t</table>\n\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td align='right'><input type='button' value='« Back' onClick='javascript:history.back()'> | <input type='submit' name='upBtn' value='Write'></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</table>\n\t\t\t\t\t</form>\n\t\t\t\t\t</center>";
return $details;
}
function editAccnt($bankid)
{
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($bankid, "num", 1, 4, "Invalid Bank Account ID.");
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class='err'>" . $e["msg"] . "</li>";
}
$confirm .= "<p><input type='button' onClick='JavaScript:history.back();' value='« Correct submission'>";
return $confirm;
}
// Connect to database
Db_Connect();
$sql = "SELECT * FROM bankacct WHERE bankid='{$bankid}' AND div = '" . USER_DIV . "'";
$bankRslt = db_exec($sql) or errDie("ERROR: Unable to retrieve bank account details from database.", SELF);
$numrows = pg_numrows($bankRslt);
if ($numrows < 1) {
$OUTPUT = "<li> - Invalid Bank account ID.";
return $OUTPUT;
}
global $_POST;
extract($_POST);
$accnt = pg_fetch_array($bankRslt);
if (isset($accname)) {
$accnt['accname'] = $accname;
$accnt['acctype'] = $acctype;
$accnt['bankname'] = $bankname;
$accnt['branchname'] = $branchname;
$accnt['branchcode'] = $branchcode;
$accnt['accnum'] = $accnum;
$accnt['details'] = $details;
$accnt['btype'] = $loc;
}
if (strlen($accnt['accname']) < 20) {
$size = 20;
} else {
$size = strlen($accnt['accname']);
}
// Get Bank account [the traditional way re: hook of hook]
core_connect();
$sql = "SELECT * FROM bankacc WHERE accid = '{$bankid}' AND div = '" . USER_DIV . "'";
$Rslt = db_exec($sql) or errDie("Unable to retrieve bank account link from Cubit", SELF);
# check if link exists
if (pg_numrows($Rslt) < 1) {
return "<li class='err'> ERROR : The bank account that you selected doesn't appear to have an account linked to it.";
}
$bank = pg_fetch_array($Rslt);
$bankaccid = $bank["accnum"];
# Check account balance
$sql = "SELECT * FROM trial_bal WHERE period='" . PRD_DB . "' AND accid = '{$bankaccid}' AND debit > 0 OR accid = '{$bankaccid}' AND credit > 0";
$accRslt = db_exec($sql);
if (pg_numrows($accRslt) > 0) {
$acc = pg_fetch_array($accRslt);
$account = "<input type='hidden' name='glacc' value='{$acc['accid']}'>{$acc['accname']}";
} else {
core_connect();
# income accounts ($inc)
$account = "<select name='glacc'>";
$sql = "SELECT * FROM accounts WHERE acctype ='B' ORDER BY accname";
$accRslt = db_exec($sql);
$numrows = pg_numrows($accRslt);
if (empty($numrows)) {
return "<li> - There are no accounts yet in Cubit. Please set up accounts first.</li>";
}
while ($acc = pg_fetch_array($accRslt)) {
if (isb($acc['accid'])) {
continue;
}
if ($acc['accid'] == $bankaccid) {
$sal = "selected";
} else {
$sal = "";
}
$account .= "<option value='{$acc['accid']}' {$sal}>{$acc['accname']}</option>";
}
$account .= "</select>";
}
db_connect();
# Locations drop down
$locs = array("loc" => "Local", "int" => "International");
$locsel = extlib_cpsel("loc", $locs, $accnt['btype']);
# currency drop down
$currsel = ext_unddbsel("fcid", "currency", "fcid", "descrip", "There are is no currency found in Cubit, please add currency first.", $accnt['fcid']);
// Set up table to display in
$OUTPUT = "\n\t\t<h3>Edit Bank Account</h3>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t<form action='" . SELF . "' method='POST' name='form'>\n\t\t\t<input type='hidden' name='key' value='confirm'>\n\t\t\t<input type='hidden' name='bankid' value='{$bankid}'>\n\t\t\t<tr>\n\t\t\t\t<th>Field</th>\n\t\t\t\t<th>Value</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Type of Account</td>\n\t\t\t\t<td valign='center'><input type='text' size='20' name='acctype' value='{$accnt['acctype']}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Bank Name</td>\n\t\t\t\t<td valign='center'><input type='text' size='20' name='bankname' value='{$accnt['bankname']}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Type</td>\n\t\t\t\t<td>{$locsel}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Currency</td>\n\t\t\t\t<td>{$currsel}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Branch Name</td>\n\t\t\t\t<td valign='center'><input type='text' size='20' name='branchname' value='{$accnt['branchname']}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Branch Code</td>\n\t\t\t\t<td valign='center'><input type='text' size='20' name='branchcode' value='{$accnt['branchcode']}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Account Name</td>\n\t\t\t\t<td valign='center'><input type='text' size='{$size}' name='accname' value='{$accnt['accname']}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Account Number</td>\n\t\t\t\t<td valign='center'><input type='text' name='accnum' value='{$accnt['accnum']}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Ledger Account</td>\n\t\t\t\t<td valign='center'>{$account}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Details</td>\n\t\t\t\t<td valign='center'><textarea cols='20' rows='5' name='details'>{$accnt['details']}</textarea></td></tr>\n\t\t\t<tr>\n\t\t\t\t<td></td>\n\t\t\t\t<td valign='center' align='right'><input type='submit' value='Confirm »'></td>\n\t\t\t</tr>\n\t\t</form>\n\t\t</table>\n\t\t<p>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<th>Quick Links</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td><a href='bankacct-view.php'>View Bank Accounts</a></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td><a href='../main.php'>Main Menu</a></td>\n\t\t\t</tr>\n\t\t</table>";
return $OUTPUT;
}
function edit_err($_POST, $err = "")
{
# get vars
extract($_POST);
# Departments
db_conn("exten");
$depts = "<select name='deptid'>";
$sql = "SELECT * FROM departments WHERE div = '" . USER_DIV . "' ORDER BY deptname ASC";
$deptRslt = db_exec($sql);
if (pg_numrows($deptRslt) < 1) {
return "<li>There are no Price lists in Cubit.</li>";
} else {
while ($dept = pg_fetch_array($deptRslt)) {
if ($dept['deptid'] == $deptid) {
$sel = "selected";
} else {
$sel = "";
}
$depts .= "<option value='{$dept['deptid']}' {$sel}>{$dept['deptname']}</option>";
}
}
$depts .= "</select>";
# Get Pricelists
$pricelists = "<select name='listid' style='width: 120'>";
$sql = "SELECT * FROM spricelist WHERE div = '" . USER_DIV . "' ORDER BY listname ASC";
$listRslt = db_exec($sql);
if (pg_numrows($listRslt) < 1) {
return "<li>There are no Price lists in Cubit.</li>";
} else {
while ($list = pg_fetch_array($listRslt)) {
if ($list['listid'] == $listid) {
$sel = "selected";
} else {
$sel = "";
}
$pricelists .= "<option value='{$list['listid']}' {$sel}>{$list['listname']}</option>";
}
}
$pricelists .= "</select>";
db_connect();
if (!isset($location)) {
$location = "";
}
# Locations drop down
$locs = array("loc" => "Local", "int" => "International");
$locsel = extlib_cpsel("loc", $locs, $location);
# Currency drop down
$currsel = ext_unddbsel("fcid", "currency", "fcid", "descrip", "There are is no currency found in Cubit, please add currency first.", $fcid);
if (isset($bee_status) and $bee_status == "no") {
$sel1 = "";
$sel2 = "checked=yes";
} else {
$sel1 = "checked=yes";
$sel2 = "";
}
//Get supplier groups
$get_grps = "SELECT * FROM supp_groups ORDER BY groupname";
$run_grps = db_exec($get_grps) or errDie("Unable to get supplier group information.");
if (pg_numrows($run_grps) < 1) {
return "Unable to get supplier group information. Please add a supplier group.";
} else {
$supp_grpdrop = "<select name='supp_grp'>";
while ($garr = pg_fetch_array($run_grps)) {
if ($garr['id'] == $supp_grp) {
$supp_grpdrop .= "<option value='{$garr['id']}' selected>{$garr['groupname']}</option>";
} else {
$supp_grpdrop .= "<option value='{$garr['id']}'>{$garr['groupname']}</option>";
}
}
$supp_grpdrop .= "</select>";
}
// Retrieve teams
$sql = "SELECT * FROM crm.teams WHERE id = '{$team_id}' LIMIT 1";
$team_rslt = db_exec($sql) or errDie("Unable to retrieve teams.");
$team_data = pg_fetch_array($team_rslt);
$team_sel = "{$team_data['name']}";
if (!isset($team_sel)) {
$team_sel = "";
}
$setdayssel1 = "";
$setdayssel2 = "";
$setdayssel3 = "";
$setdayssel4 = "";
$setdayssel5 = "";
if (isset($setdays) and $setdays == "0") {
$setdayssel1 = "selected";
}
if (isset($setdays) and $setdays == "1") {
$setdayssel2 = "selected";
}
if (isset($setdays) and $setdays == "7") {
$setdayssel3 = "selected";
}
if (isset($setdays) and $setdays == "15") {
$setdayssel4 = "selected";
}
if (isset($setdays) and $setdays == "25") {
$setdayssel5 = "selected";
}
$setdays_drop = "\r\n\t\t<select name='setdays'>\r\n\t\t\t<option {$setdayssel1} value='0'>Last Day Of The Month</option>\r\n\t\t\t<option {$setdayssel2} value='1'>1st Day Of The Month</option>\r\n\t\t\t<option {$setdayssel3} value='7'>7th Of The Month</option>\r\n\t\t\t<option {$setdayssel4} value='15'>15th Of The Month</option>\r\n\t\t\t<option {$setdayssel5} value='25'>25th Of The Month</option>\r\n\t\t</select>";
$enter = "\r\n\t\t<h3>Edit Supplier</h3>\r\n\t\t<form action='" . SELF . "' method='POST'>\r\n\t\t\t<input type='hidden' name='key' value='confirm'>\r\n\t\t\t<input type='hidden' name='supid' value='{$supid}'>\r\n\t\t\t<input type='hidden' name='team_id' value='{$team_id}' />\r\n\t\t<table cellpadding='0' cellspacing='0'>\r\n\t\t\t<tr>\r\n\t\t\t\t<td colspan='2'>{$err}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr valign='top'>\r\n\t\t\t\t<td>\r\n\t\t\t\t\t<table " . TMPL_tblDflts . ">\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t<th colspan='2'>Supplier Details</th>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>" . REQ . "Department</td>\r\n\t\t\t\t\t\t\t<td>{$depts}</td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>" . REQ . "Supplier No</td>\r\n\t\t\t\t\t\t\t<td><input type='text' size='10' name='supno' value='{$supno}'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>" . REQ . "Supplier/Name</td>\r\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='supname' value='{$supname}'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>" . REQ . "Registration/ID</td>\r\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='registration' value='{$registration}'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>Branch</td>\r\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='branch' value='{$branch}'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>" . REQ . "Type</td>\r\n\t\t\t\t\t\t\t<td>{$locsel}</td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>" . REQ . "Currency</td>\r\n\t\t\t\t\t\t\t<td>{$currsel}</td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>" . REQ . "VAT Number</td>\r\n\t\t\t\t\t\t\t<td><input type='text' size='21' name='vatnum' value='{$vatnum}'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>" . REQ . "Address</td>\r\n\t\t\t\t\t\t\t<td><textarea name='supaddr' rows='5' cols='18'>{$supaddr}</textarea></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>Postal Address</td>\r\n\t\t\t\t\t\t\t<td><textarea name='suppostaddr' rows='5' cols='18'>{$suppostaddr}</textarea></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>" . REQ . "Contact Name</td>\r\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='contname' value='{$contname}'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>" . REQ . "Tel No.</td>\r\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='tel' value='{$tel}'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>Fax No.</td>\r\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='fax' value='{$fax}'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>Cell No.</td>\r\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='cell' value='{$cell}'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>E-mail</td>\r\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='email' value='{$email}'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>Web Address</td>\r\n\t\t\t\t\t\t\t<td>http://<input type='text' size='30' name='url' value='{$url}'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>" . REQ . "Price List</td>\r\n\t\t\t\t\t\t\t<td>{$pricelists}</td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>Supplier Group</td>\r\n\t\t\t\t\t\t\t<td>{$supp_grpdrop}</td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>Status BEE</td>\r\n\t\t\t\t\t\t\t<td>Yes <input type='radio' name='bee_status' value='yes' {$sel1}> No <input type='radio' name='bee_status' value='no' {$sel2}></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>Team Permissions</td>\r\n\t\t\t\t\t\t\t<td>{$team_sel}</td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t</table>\r\n\t\t\t\t</td>\r\n\t\t\t\t<td>\r\n\t\t\t\t\t<table " . TMPL_tblDflts . ">\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<th colspan='2'> Bank Details</th>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>Bank </td>\r\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='bankname' value='{$bankname}'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>Branch</td>\r\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='branname' value='{$branname}'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>Branch Code</td>\r\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='brancode' value='{$brancode}'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>Account Name</td>\r\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='bankaccname' value='{$bankaccname}'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>Account Type</td>\r\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='bankacctype' value='{$bankacctype}'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>Account Number</td>\r\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='bankaccno' value='{$bankaccno}'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>Reference</td>\r\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='reference' value='{$reference}'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>Settlement Discount %</td>\r\n\t\t\t\t\t\t\t<td><input type='text' name='setdisc' value='{$setdisc}'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>Statement Day</td>\r\n\t\t\t\t\t\t\t<td>{$setdays_drop}</td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>Comments</td>\r\n\t\t\t\t\t\t\t<td><textarea name='comments' rows='5' cols='18'>{$comments}</textarea></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t" . TBL_BR . "\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t<td colspan='2' align='right'><input type='submit' value='Confirm »'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t" . TBL_BR . "\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t<td colspan='2' align='right'>\r\n\t\t\t\t\t\t\t\t<table border='0' cellpadding='2' cellspacing='1'>\r\n\t\t\t\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t\t\t\t<th>Quick Links</th>\r\n\t\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t\t\t\t<td><a href='supp-view.php'>View Suppliers</a></td>\r\n\t\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t\t\t\t<td><a href='main.php'>Main Menu</a></td>\r\n\t\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t</table>\r\n\t\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t</table>\r\n\t\t\t\t\t</form>\r\n\t\t\t\t</td>\r\n\t\t\t</tr>\r\n\t\t</table>";
return $enter;
}
function enter($errors = "")
{
global $_POST;
extract($_POST);
$fields = array();
$fields["re"] = "no";
$fields["deptid"] = "";
$fields["supno"] = "";
$fields["supname"] = "";
$fields["supbranch"] = "";
$fields["loc"] = "";
$fields["fcid"] = "";
$fields["vatnum"] = "";
$fields["supaddr"] = "";
$fields["suppostaddr"] = "";
$fields["contname"] = "";
$fields["tel"] = "";
$fields["fax"] = "";
$fields["cell"] = "";
$fields["email"] = "";
$fields["url"] = "";
$fields["listid"] = "";
$fields["bee_status"] = "";
$fields["comments"] = "";
$fields["bankname"] = "";
$fields["branname"] = "";
$fields["brancode"] = "";
$fields["bankaccno"] = "";
$fields["bankacctype"] = "";
$fields["bankaccname"] = "";
$fields["reference"] = "";
$fields["lead_source"] = "";
$fields["team_id"] = 0;
$fields["registration"] = "";
$fields["supp_grp"] = "";
$fields["setdisc"] = "0";
$fields["setdays"] = "1";
extract($fields, EXTR_SKIP);
# Select previous year database
db_connect();
$lastid = pglib_lastid("suppliers", "supid");
# get last account number
$sql = "SELECT supno FROM suppliers WHERE supid = '{$lastid}' AND div = '" . USER_DIV . "'";
$accRslt = db_exec($sql);
if (pg_numrows($accRslt) < 1) {
do {
$lastid--;
# get last account number
$sql = "SELECT supno FROM suppliers WHERE supid = '{$lastid}' AND div = '" . USER_DIV . "'";
$accRslt = db_exec($sql);
if (pg_numrows($accRslt) < 1) {
$supno = "";
$nsupno = "";
} else {
$acc = pg_fetch_array($accRslt);
$supno = $acc['supno'];
}
} while (strlen($supno) < 1 && $lastid > 1);
} else {
$acc = pg_fetch_array($accRslt);
$supno = $acc['supno'];
}
# Check if we got $supno(if not skip this)
if (strlen($supno) > 0) {
# Get the next account number
$num = preg_replace("/[^\\d]+/", "", $supno);
$num++;
$chars = preg_replace("/[\\d]/", "", $supno);
$nsupno = $chars . $num;
} else {
$nsupno = 1;
}
# Departments
db_conn("exten");
$depts = "<select name='deptid'>";
$sql = "SELECT * FROM departments WHERE div = '" . USER_DIV . "' ORDER BY deptname ASC";
$deptRslt = db_exec($sql);
if (pg_numrows($deptRslt) < 1) {
return "<li>There are no Price lists in Cubit.</li>";
} else {
while ($dept = pg_fetch_array($deptRslt)) {
if ($dept["deptid"] == $deptid) {
$sel = "selected";
} else {
$sel = "";
}
$depts .= "<option value='{$dept['deptid']}' {$sel}>{$dept['deptname']}</option>";
}
}
$depts .= "</select>";
# Get pricelist
$pricelists = "<select name='listid' style='width: 120'>";
$sql = "SELECT * FROM spricelist WHERE div = '" . USER_DIV . "' ORDER BY listname ASC";
$listRslt = db_exec($sql);
if (pg_numrows($listRslt) < 1) {
return "<li>There are no Price lists in Cubit.</li>";
} else {
while ($list = pg_fetch_array($listRslt)) {
if ($list["listid"] == $listid) {
$sel = "selected";
} else {
$sel = "";
}
$pricelists .= "<option value='{$list['listid']}' {$sel}>{$list['listname']}</option>";
}
}
$pricelists .= "</select>";
db_connect();
# Locations drop down
$locs = array("loc" => "Local", "int" => "International");
$locsel = extlib_cpsel("loc", $locs, $loc);
# Currency drop down
$currsel = ext_unddbsel("fcid", "currency", "fcid", "descrip", "There are is no currency found in Cubit, please add currency first.", $fcid);
global $_GET;
extract($_GET);
if (isset($crm)) {
$ex = "<input type='hidden' name='crm' value=''>";
} else {
$ex = "";
}
if (!isset($re)) {
$re = "no";
}
$select_source = extlib_cpsel("lead_source", crm_get_leadsrc(-1), $lead_source);
if (isset($bee_status) and $bee_status == "no") {
$sel1 = "";
$sel2 = "checked=yes";
} else {
$sel1 = "checked=yes";
$sel2 = "";
}
// Retrieve teams
$sql = "SELECT * FROM crm.teams ORDER BY name ASC";
$team_rslt = db_exec($sql) or errDie("Unable to retrieve teams.");
$team_sel = "<select name='team_id'>";
$team_sel .= "<option value='0'>[None]</option>";
while ($team_data = pg_fetch_array($team_rslt)) {
if ($team_id == $team_data["id"]) {
$sel = "selected";
} else {
$sel = "";
}
$team_sel .= "<option value='{$team_data['id']}' {$sel}>{$team_data['name']}</option>";
}
$team_sel .= "</select>";
//Get supplier groups
$get_grps = "SELECT * FROM supp_groups ORDER BY groupname";
$run_grps = db_exec($get_grps) or errDie("Unable to get supplier group information.");
if (pg_numrows($run_grps) < 1) {
return "Unable to get supplier group information. Please add a supplier group.";
} else {
$supp_grpdrop = "<select name='supp_grp'>";
while ($garr = pg_fetch_array($run_grps)) {
if ($garr['id'] == $supp_grp) {
$supp_grpdrop .= "<option value='{$garr['id']}' selected>{$garr['groupname']}</option>";
} else {
$supp_grpdrop .= "<option value='{$garr['id']}'>{$garr['groupname']}</option>";
}
}
$supp_grpdrop .= "</select>";
}
$setdayssel1 = "";
$setdayssel2 = "";
$setdayssel3 = "";
$setdayssel4 = "";
$setdayssel5 = "";
if (isset($setdays) and $setdays == "0") {
$setdayssel1 = "selected";
}
if (isset($setdays) and $setdays == "1") {
$setdayssel2 = "selected";
}
if (isset($setdays) and $setdays == "7") {
$setdayssel3 = "selected";
}
if (isset($setdays) and $setdays == "15") {
$setdayssel4 = "selected";
}
if (isset($setdays) and $setdays == "25") {
$setdayssel5 = "selected";
}
if (isset($setdays) and $setdays == "60") {
$setdayssel6 = "selected";
}
$setdays_drop = "\n\t\t<select name='setdays'>\n\t\t\t<option {$setdayssel1} value='0'>Last Day Of The Month</option>\n\t\t\t<option {$setdayssel2} value='1'>1st Day Of The Month</option>\n\t\t\t<option {$setdayssel3} value='7'>7th Of The Month</option>\n\t\t\t<option {$setdayssel4} value='15'>15th Of The Month</option>\n\t\t\t<option {$setdayssel5} value='25'>25th Of The Month</option>\n\t\t\t<option {$setdayssel6} value='60'>End Of Next Month</option>\n\t\t</select>";
// Layout
$enter = "\n\t\t<h3>Add Supplier</h3>\n\t\t<form action='" . SELF . "' method='POST'>\n\t\t<table cellpadding='0' cellspacing='0'>\n\t\t\t<tr>\n\t\t\t\t<td colspan='2'>{$errors}</td>\n\t\t\t</tr>\n\t\t\t<tr valign='top'>\n\t\t\t\t<td>\n\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t\t<input type='hidden' name='key' value='confirm'>\n\t\t\t\t\t\t<input type='hidden' name='re' value='{$re}'>\n\t\t\t\t\t\t{$ex}\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th colspan='2'>Supplier Details</th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>" . REQ . "Department</td>\n\t\t\t\t\t\t\t<td>{$depts}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>" . REQ . "Supplier No</td>\n\t\t\t\t\t\t\t<td><input type='text' size='10' name='supno' value='{$nsupno}' /></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>" . REQ . "Supplier/Name</td>\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='supname' value='{$supname}' /></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>" . REQ . "Registration/ID</td>\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='registration' value='{$registration}'></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Branch</td>\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='supbranch' value='{$supbranch}' /></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>" . REQ . "Type</td>\n\t\t\t\t\t\t\t<td>{$locsel}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>" . REQ . "Currency</td>\n\t\t\t\t\t\t\t<td>{$currsel}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>" . REQ . "VAT Number</td>\n\t\t\t\t\t\t\t<td><input type='text' size='21' name='vatnum' value='{$vatnum}' /></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>" . REQ . "Address</td>\n\t\t\t\t\t\t\t<td><textarea name='supaddr' rows='4' cols='25'>{$supaddr}</textarea></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Postal Address</td>\n\t\t\t\t\t\t\t<td><textarea name='suppostaddr' rows='4' cols='25'>{$suppostaddr}</textarea></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>" . REQ . "Contact Name</td>\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='contname' value='{$contname}' /></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>" . REQ . "Tel No.</td>\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='tel' value='{$tel}' /></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Fax No.</td>\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='fax' value='{$fax}' /></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Cell No.</td>\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='cell' value='{$cell}' /></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>E-mail</td>\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='email' value='{$email}' /></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Web Address</td>\n\t\t\t\t\t\t\t<td>http://<input type='text' size='30' name='url' value='{$url}' /></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>" . REQ . "Price List</td>\n\t\t\t\t\t\t\t<td>{$pricelists}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Supplier Group</td>\n\t\t\t\t\t\t\t<td>{$supp_grpdrop}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Status BEE</td>\n\t\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t\tYes <input type='radio' name='bee_status' value='yes' {$sel1}>\n\t\t\t\t\t\t\t\tNo <input type='radio' name='bee_status' value='no' {$sel2}>\n\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Team Permissions</td>\n\t\t\t\t\t\t\t<td>{$team_sel}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</table>\n\t\t\t\t</td>\n\t\t\t\t<td>\n\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<th colspan='2'>Bank Details</th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Bank</td>\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='bankname' value='{$bankname}' /></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Branch</td>\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='branname' value='{$branname}' /></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Branch Code</td>\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='brancode' value='{$brancode}' /></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Account Name</td>\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='bankaccname' value='{$bankaccname}' /></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Account Type</td>\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='bankacctype' value='{$bankacctype}' /></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Account Number</td>\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='bankaccno' value='{$bankaccno}' /></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Reference</td>\n\t\t\t\t\t\t\t<td><input type='text' size='20' name='reference' value='{$reference}' /></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Lead Source</td>\n\t\t\t\t\t\t\t<td>{$select_source}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>" . REQ . " Settlement Discount %</td>\n\t\t\t\t\t\t\t<td><input type='text' name='setdisc' value='{$setdisc}'></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>" . REQ . " Statement Day</td>\n\t\t\t\t\t\t\t<td>{$setdays_drop}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Comments</td>\n\t\t\t\t\t\t\t<td><textarea name='comments' rows='5' cols='18'>{$comments}</textarea></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t" . TBL_BR . "\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td colspan='2' align='right'>\n\t\t\t\t\t\t\t\t<input type='submit' value='Confirm »'>\n\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t" . TBL_BR . "\n\t\t\t\t\t</form>\n\t\t\t\t\t\t<tr><td colspan='2'>\n\t\t\t\t\t\t<tr><td colspan='2' align='right'>\n\t\t\t\t\t<table border=0 cellpadding='2' cellspacing='1'>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th>Quick Links</th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td><a href='supp-view.php'>View Suppliers</a></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td><a href='main.php'>Main Menu</a></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</table>\n\t\t\t\t</td>\n\t\t\t</tr>\n\t\t</table>\n\t\t</td></tr>\n\t\t</table>";
return $enter;
}
function enter_err($_POST, $err = "")
{
# get vars
extract($_POST);
# Departments
db_conn("exten");
$depts = "<select name='deptid'>";
$sql = "SELECT * FROM departments WHERE div = '" . USER_DIV . "' ORDER BY deptname ASC";
$deptRslt = db_exec($sql);
if (pg_numrows($deptRslt) < 1) {
return "<li>There are no Price lists in Cubit.</li>";
} else {
while ($dept = pg_fetch_array($deptRslt)) {
if ($dept['deptid'] == $deptid) {
$sel = "selected";
} else {
$sel = "";
}
$depts .= "<option value='{$dept['deptid']}' {$sel}>{$dept['deptname']}</option>";
}
}
$depts .= "</select>";
# Get Pricelists
$pricelists = "<select name='listid' style='width: 120'>";
$sql = "SELECT * FROM spricelist WHERE div = '" . USER_DIV . "' ORDER BY listname ASC";
$listRslt = db_exec($sql);
if (pg_numrows($listRslt) < 1) {
return "<li>There are no Price lists in Cubit.";
} else {
while ($list = pg_fetch_array($listRslt)) {
if ($list['listid'] == $listid) {
$sel = "selected";
} else {
$sel = "";
}
$pricelists .= "<option value='{$list['listid']}' {$sel}>{$list['listname']}</option>";
}
}
$pricelists .= "</select>";
db_connect();
# Locations drop down
$locs = array("loc" => "Local", "int" => "International");
$locsel = extlib_cpsel("loc", $locs, $loc);
# Currency drop down
$currsel = ext_unddbsel("fcid", "currency", "fcid", "descrip", "There are is no currency found in Cubit, please add currency first.", $fcid);
if (isset($crm)) {
$ex = "<input type='hidden' name='crm' value=''>";
} else {
$ex = "";
}
if (isset($bee_training) and $bee_training == "no") {
$sel1 = "";
$sel2 = "checked=yes";
} else {
$sel1 = "checked=yes";
$sel2 = "";
}
$enter = "\r\n\t\t\t\t<h3>Add Training Provider</h3>\r\n\t\t\t\t<form action='" . SELF . "' method='POST'>\r\n\t\t\t\t\t<input type='hidden' name='key' value='confirm'>\r\n\t\t\t\t\t<input type='hidden' name='re' value='{$re}'>\r\n\t\t\t\t\t{$ex}\r\n\t\t\t\t<table cellpadding='0' cellspacing='0'>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td colspan='2'>{$err}</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr valign='top'>\r\n\t\t\t\t\t\t<td>\r\n\t\t\t\t\t\t\t<table " . TMPL_tblDflts . ">\r\n\t\t\t\t\t\t\t\t<tr><th colspan='2'>Training Provider Details</th></tr>\r\n\t\t\t\t\t\t\t\t<tr bgcolor='" . bgcolor() . "'>\r\n\t\t\t\t\t\t\t\t\t<td>" . REQ . "Department</td>\r\n\t\t\t\t\t\t\t\t\t<td>{$depts}</td>\r\n\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t<tr bgcolor='" . bgcolor() . "'>\r\n\t\t\t\t\t\t\t\t\t<td>" . REQ . "Supplier No</td>\r\n\t\t\t\t\t\t\t\t\t<td><input type='text' size='10' name='supno' value='{$supno}'></td>\r\n\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t<tr bgcolor='" . bgcolor() . "'>\r\n\t\t\t\t\t\t\t\t\t<td>" . REQ . "Name</td>\r\n\t\t\t\t\t\t\t\t\t<td><input type='text' size='20' name='supname' value='{$supname}'></td>\r\n\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t<tr bgcolor='" . bgcolor() . "'>\r\n\t\t\t\t\t\t\t\t\t<td>" . REQ . "Type</td>\r\n\t\t\t\t\t\t\t\t\t<td>{$locsel}</td>\r\n\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t<tr bgcolor='" . bgcolor() . "'>\r\n\t\t\t\t\t\t\t\t\t<td>" . REQ . "Currency</td>\r\n\t\t\t\t\t\t\t\t\t<td>{$currsel}</td>\r\n\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t<tr bgcolor='" . bgcolor() . "'>\r\n\t\t\t\t\t\t\t\t\t<td>" . REQ . "Address</td>\r\n\t\t\t\t\t\t\t\t\t<td><textarea name='supaddr' rows='5' cols='18'>{$supaddr}</textarea></td>\r\n\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t<tr bgcolor='" . bgcolor() . "'>\r\n\t\t\t\t\t\t\t\t\t<td>" . REQ . "Contact Name</td>\r\n\t\t\t\t\t\t\t\t\t<td><input type='text' size='20' name='contname' value='{$contname}'></td>\r\n\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t<tr bgcolor='" . bgcolor() . "'>\r\n\t\t\t\t\t\t\t\t\t<td>" . REQ . "Tel No.</td>\r\n\t\t\t\t\t\t\t\t\t<td><input type='text' size='20' name='tel' value='{$tel}'></td>\r\n\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t<tr bgcolor='" . bgcolor() . "'>\r\n\t\t\t\t\t\t\t\t\t<td>Fax No.</td>\r\n\t\t\t\t\t\t\t\t\t<td><input type='text' size='20' name='fax' value='{$fax}'></td>\r\n\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t<tr bgcolor='" . bgcolor() . "'>\r\n\t\t\t\t\t\t\t\t\t<td>" . REQ . "Price List</td>\r\n\t\t\t\t\t\t\t\t\t<td>{$pricelists}</td>\r\n\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t<tr bgcolor='" . bgcolor() . "'>\r\n\t\t\t\t\t\t\t\t\t<td>Training BEE</td>\r\n\t\t\t\t\t\t\t\t\t<td>Yes <input type='radio' name='bee_training' value='yes' {$sel1}> No <input type='radio' name='bee_training' value='no' {$sel2}></td>\r\n\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t<tr bgcolor='" . bgcolor() . "'>\r\n\t\t\t\t\t\t\t\t\t<td>Notes</td>\r\n\t\t\t\t\t\t\t\t\t<td><textarea cols='25' rows='4' name='comments'>{$comments}</textarea></td>\r\n\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t" . TBL_BR . "\r\n\t\t\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t\t\t<td colspan='2' align='right'><input type='submit' value='Confirm »'></td>\r\n\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t" . TBL_BR . "\r\n\t\t\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t\t\t<td colspan='2' align='right'>\r\n\t\t\t\t\t\t\t\t\t\t<table border=0 cellpadding='2' cellspacing='1'>\r\n\t\t\t\t\t\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<th>Quick Links</th>\r\n\t\t\t\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t\t\t\t\t\t>td><a href='supp-view.php'>View Suppliers</a></td>\r\n\t\t\t\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<td><a href='main.php'>Main Menu</a></td>\r\n\t\t\t\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t\t\t</table>\r\n\t\t\t\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t</table>\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t</form>\r\n\t\t\t\t</table>";
return $enter;
}
