本文整理汇总了PHP中Db_Connect函数的典型用法代码示例。如果您正苦于以下问题：PHP Db_Connect函数的具体用法？PHP Db_Connect怎么用？PHP Db_Connect使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了Db_Connect函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: confirm
function confirm($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 . "'";
$accntRslt = db_exec($sql) or errDie("ERROR: Unable to select Bank account details from database.", SELF);
$numrows = pg_numrows($accntRslt);
if ($numrows > 1) {
$OUTPUT = "There are more than one accounts with the same account ID.";
require "../template.php";
}
if ($numrows < 1) {
$OUTPUT = "<center>Invalid Bank Account ID.";
require "../template.php";
}
$accnt = pg_fetch_array($accntRslt);
$confirm = "\n \t<h3>Remove Bank Account from database</h3>\n <h4>Confirm entry</h4>\n <table " . TMPL_tblDflts . ">\n <form action='" . SELF . "' method='POST'>\n\t <input type='hidden' name='key' value=rem>\n\t <input type='hidden' name='bankid' value='{$bankid}'>\n\t <input type='hidden' name='acctype' value='{$accnt['acctype']}'>\n\t <input type='hidden' name='bankname' value='{$accnt['bankname']}'>\n\t <input type='hidden' name='branchname' value='{$accnt['branchname']}'>\n\t <input type='hidden' name='branchcode' value='{$accnt['branchcode']}'>\n\t <input type='hidden' name='accname' value='{$accnt['accname']}'>\n\t <input type='hidden' name='accnum' value='{$accnt['accnum']}'>\n\t <input type='hidden' name='details' value='{$accnt['details']}'>\n\t <tr>\n\t \t<th>Field</th>\n\t \t<th>Value</th>\n\t </tr>\n\t <tr class='" . bg_class() . "'>\n\t \t<td>Account Type</td>\n\t \t<td>{$accnt['acctype']}</td>\n\t </tr>\n\t <tr class='" . bg_class() . "'>\n\t \t<td>Bank Name</td>\n\t \t<td>{$accnt['bankname']}</td>\n\t </tr>\n\t <tr class='" . bg_class() . "'>\n\t \t<td>Branch Name</td>\n\t \t<td>{$accnt['branchname']}</td>\n\t </tr>\n\t <tr class='" . bg_class() . "'>\n\t \t<td>Branch Code</td>\n\t \t<td>{$accnt['branchcode']}</td>\n\t </tr>\n\t <tr class='" . bg_class() . "'>\n\t \t<td>Account Name</td>\n\t \t<td>{$accnt['accname']}</td>\n\t </tr>\n\t <tr class='" . bg_class() . "'>\n\t \t<td>Account Number</td>\n\t \t<td>{$accnt['accnum']}</td>\n\t </tr>\n\t <tr class='" . bg_class() . "'>\n\t \t<td>Details</td>\n\t \t<td>{$accnt['details']}</td>\n\t </tr>\n\t <tr>\n\t \t<td align='right'><input type='button' value='« Back' onClick='javascript:history.back()'></td>\n\t \t<td align='right'><input type='submit' value='Remove Bank Account »'></td>\n\t </tr>\n </form>\n </table>\n <p>\n <table " . TMPL_tblDflts . ">\n <tr>\n \t<th>Quick Links</th>\n </tr>\n <tr class='" . bg_class() . "'>\n \t<td><a href='bankacct-view.php'>View Bank Accounts</a></td>\n </tr>\n <script>document.write(getQuicklinkSpecial());</script>\n </table>";
return $confirm;
}示例2: confirm
function confirm($cashid)
{
global $_GET;
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($cashid, "num", 1, 20, "Invalid Reference number.");
# 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;
}
if (isset($_GET["type"]) and $_GET["type"] == "cash") {
$bou = "cashbook";
} else {
$bou = "batch_cashbook";
}
// Connect to database
Db_Connect();
$sql = "SELECT * FROM {$bou} WHERE cashid = '{$cashid}' AND div = '" . USER_DIV . "'";
$accntRslt = db_exec($sql) or errDie("ERROR: Unable to retrieve cashbook entry details from database.", SELF);
$accnt = pg_fetch_array($accntRslt);
$confirm = "\r\n\t\t\t\t\t<center>\r\n\t\t\t\t\t<table " . TMPL_tblDflts . " width='330'>\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t<td colspan='2'><h3>Entry Accounts</h3></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr><td><br></td></tr>\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t<th>Account</th>\r\n\t\t\t\t\t\t\t<th>Amount</th>\r\n\t\t\t\t\t\t\t<th>VAT</th>\r\n\t\t\t\t\t\t</tr>";
$accids = explode("|", $accnt['accids']);
unset($accids[0]);
$amounts = explode("|", $accnt['amounts']);
unset($amounts[0]);
$vats = explode("|", $accnt['vats']);
unset($vats[0]);
foreach ($amounts as $key => $amt) {
# get account name for the account involved
$AccRslt = get("core", "accname,topacc,accnum", "accounts", "accid", $accids[$key]);
$accinv = pg_fetch_array($AccRslt);
$amt = sprint($amt);
$confirm .= "\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "''>\r\n\t\t\t\t\t\t\t<td>{$accinv['topacc']}/{$accinv['accnum']} - {$accinv['accname']}</td>\r\n\t\t\t\t\t\t\t<td nowrap>" . CUR . " {$amt}</td>\r\n\t\t\t\t\t\t\t<td nowrap>" . CUR . " {$vats[$key]}</td>\r\n\t\t\t\t\t\t</tr>";
}
$confirm .= "\r\n\t\t\t\t\t\t<tr><td><br></td></tr>\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t<td colspan='2' align='center'><input type='button' value=' [X] Close ' onClick='javascript:window.close();'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t</table>";
return $confirm;
}示例3: edit
function edit($deptid)
{
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($deptid, "num", 1, 50, "Invalid User Department ID.");
# display errors, if any
if ($v->isError()) {
$theseErrors = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$theseErrors .= "<li class='err'>" . $e["msg"] . "</li>";
}
$theseErrors .= "<p><input type='button' onClick='JavaScript:history.back();' value='« Correct submission'>";
return $theseErrors;
}
// Connect to database
Db_Connect();
// Query server
$sql = "SELECT * FROM depts WHERE deptid = '{$deptid}'";
$depRslt = db_exec($sql) or errDie("ERROR: Unable to edit department.", SELF);
$dep = pg_fetch_array($depRslt);
$Out = "\n \t<table " . TMPL_tblDflts . " width='300'>\n \t<tr>\n \t\t<th colspan='2'>Select Permissions</th>\n \t</tr>";
$sql = "SELECT DISTINCT script, name FROM scripts ORDER by script";
$rslt = db_exec($sql);
$i = 0;
while ($scr = pg_fetch_array($rslt)) {
$Sql = "SELECT script FROM deptscripts WHERE dept = '{$deptid}' and script = '{$scr['name']}'";
$sRs = db_exec($Sql);
// print $Sql;
if (pg_numrows($sRs) > 0) {
$Ch = "checked";
} else {
$Ch = "";
}
$Out .= "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td colspan='2' nowrap><input type='checkbox' {$Ch} name='perm[]' value='{$scr['name']}'>" . strtoupper($scr['script']) . "</td>\n\t\t\t</tr>";
$i++;
}
$Out .= "</table>";
// Layout
$OUTPUT = "\n\t\t<h3>Edit User Department</h3>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t<form action='" . SELF . "' method='POST'>\n\t\t\t<input type='hidden' name='key' value='confirm'>\n\t\t\t<input type='hidden' name='deptid' value='{$deptid}'>\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='datacell'>\n\t\t\t\t<td>User Department</td>\n\t\t\t\t<td align='center'><input type='text' size='20' name='dept' value='{$dep['dept']}'></td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td><br></td>\n\t\t\t\t<td align='center'><input type=submit value='Commit changes'> <input type='reset' value='Reset form'></td>\n\t\t\t</tr>\n\t\t</table>\n\t\t{$Out}\n\t\t</form>\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<script>document.write(getQuicklinkSpecial());</script>\n\t\t</table>";
return $OUTPUT;
}示例4: printSet
function printSet()
{
// Connect to database
Db_Connect();
// Query server
$sql = "SELECT * FROM set WHERE div = '" . USER_DIV . "'";
$rslt = db_exec($sql) or errDie("ERROR: Unable to view settings", SELF);
// Die with custom error if failed
if (pg_numrows($rslt) < 1) {
$OUTPUT = "<li class=err> No Setting currently in database.";
} else {
// Set up table to display in
$OUTPUT = "\n\t\t<h3>View Current Settings</h3>\n\t\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "' width=300>\n\t\t<tr><th>Setting Type</th><th>Current Setting</th></tr>";
// display all settings
for ($i = 0; $set = pg_fetch_array($rslt); $i++) {
$OUTPUT .= "<tr class='" . bg_class() . "'><td>{$set['type']}</td><td>{$set['descript']}</td></tr>";
}
$OUTPUT .= "</table>";
}
$OUTPUT .= "\n\t<p>\n\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\n\t<tr><th>Quick Links</th></tr>\n\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t</table>";
return $OUTPUT;
}示例5: confirm
function confirm($cashid)
{
global $_GET;
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($cashid, "num", 1, 20, "Invalid Reference number.");
# 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;
}
if (isset($_GET["type"]) and $_GET["type"] == "cash") {
$bou = "cashbook";
} else {
$bou = "batch_cashbook";
}
// Connect to database
Db_Connect();
$sql = "SELECT * FROM {$bou} WHERE cashid = '{$cashid}' AND div = '" . USER_DIV . "'";
$accntRslt = db_exec($sql) or errDie("ERROR: Unable to retrieve cashbook entry details from database.", SELF);
$accnt = pg_fetch_array($accntRslt);
$confirm = "\n\t<center>\n\t<table " . TMPL_tblDflts . " width='300'>\n\t\t<tr>\n\t\t\t<td colspan='2'><h3>Mutliple Debtors</h3></td>\n\t\t</tr>\n\t\t" . TBL_BR . "\n\t\t<tr>\n\t\t\t<th>Customer Name</th>\n\t\t\t<th>Amount</th>\n\t\t</tr>";
$accids = explode(",", $accnt['multicusnum']);
$amounts = explode(",", $accnt['multicusamt']);
foreach ($amounts as $key => $amt) {
$ci = qryCustomer($accids[$key]);
$amt = sprint($amt);
$confirm .= "\n\t\t<tr class='bg-even''>\n\t\t\t<td>{$ci['surname']}, {$ci['cusname']}</td>\n\t\t\t<td>" . CUR . " {$amt}</td>\n\t\t</tr>";
}
$confirm .= "<tr><td><br></td></tr>\n\t<tr><td colspan=2 align=center><input type=button value=' [X] Close ' onClick='javascript:window.close();'></td></tr>\n\t</table>";
return $confirm;
}示例6: printDepts
function printDepts()
{
// Connect to database
Db_Connect();
// Query server
$sql = "SELECT * FROM depts ORDER BY dept";
$Rslt = db_exec($sql) or errDie("ERROR: Unable to view User Departments", SELF);
// Die with custom error if failed
if (pg_numrows($Rslt) < 1) {
$OUTPUT = "No User Departments currently in database.";
} else {
// Set up table to display in
$OUTPUT = "\n\t\t\t<h3>View Current User Departments</h3>\n\t\t\t<table " . TMPL_tblDflts . " width='300'>\n\t\t\t\t<tr>\n\t\t\t\t\t<th>User Department</th>\n\t\t\t\t\t<th colspan='2'>Options</th>\n\t\t\t\t</tr>";
// display all stock
for ($i = 0; $dep = pg_fetch_array($Rslt); $i++) {
$OUTPUT .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>{$dep['dept']}</td>\n\t\t\t\t\t<td><a href='admin-deptedit.php?deptid={$dep['deptid']}'>Edit</a></td>\n\t\t\t\t\t<td><a href='admin-deptrem.php?deptid={$dep['deptid']}'>Remove</td>\n\t\t\t\t</tr>";
}
$OUTPUT .= "</table>";
}
$OUTPUT .= "\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='admin-deptadd.php'>Add Department</a></td>\n\t\t\t</tr>\n\t\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t\t</table>";
// call template to display the info and die
return $OUTPUT;
}示例7: printUsers
function printUsers()
{
// Connect to database
Db_Connect();
// Query server
$sql = "SELECT * FROM users";
$prnUsrRslt = db_exec($sql) or errDie("ERROR: Unable to view users", SELF);
// Die with custom error if failed
$numrows = pg_numrows($prnUsrRslt);
if ($numrows < 1) {
$OUTPUT = "No users currently in database.";
} else {
// Set up table to display in
$OUTPUT = "\r\n\t\t<h3>View current users</h3>\r\n\r\n\t\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "' width=300>\r\n\t\t<tr><th>User ID</th><th>User name</th><th colspan=2 class=plain><br></th></tr>\r\n\t\t";
// display all stock
for ($i = 0; $i < $numrows; $i++) {
$myUsr = pg_fetch_array($prnUsrRslt);
$OUTPUT .= "<tr class='" . bg_class() . "'><td>{$myUsr['userid']}</td><td>{$myUsr['username']}</td><td><a href='admin-usredit.php?username={$myUsr['username']}'>Edit</a></td><td><a href='admin-usrrem.php?username={$myUsr['username']}'>Remove</td></tr>";
}
$OUTPUT .= "</table>";
}
// call template to display the info and die
return $OUTPUT;
}示例8: bank
function bank($_POST)
{
# Get vars
extract($_POST);
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($cashid, "num", 1, 4, "Invalid Reference number.");
# 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;
}
# Get cash book record
Db_Connect();
$sql = "SELECT * FROM cashbook WHERE cashid = '{$cashid}' AND div = '" . USER_DIV . "'";
$accntRslt = db_exec($sql) or errDie("ERROR: Unable to retrieve cashbook entry details from database11.", SELF);
if (pg_numrows($accntRslt) < 1) {
$OUTPUT = "<li clss='err'>The entry with reference number, <b>{$cashid}</b> was not found in Cubit.</li>";
return $OUTPUT;
}
$accnt = pg_fetch_array($accntRslt);
# get hook account number
core_connect();
$sql = "SELECT * FROM bankacc WHERE accid = '{$accnt['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.</li>";
}
$bank = pg_fetch_array($rslt);
# Date
$sdate = date("Y-m-d");
# If tis customer payment
if ($accnt['cusnum'] > 0) {
db_connect();
# Get invoice Ids and Amounts
$invids = explode("|", $accnt['rinvids']);
$amounts = explode("|", $accnt['amounts']);
$invprds = explode("|", $accnt['invprds']);
$rages = explode("|", $accnt['rages']);
# Return the amount that was surppose to be paid to invoices
foreach ($invids as $key => $invid) {
db_connect();
# Skip all nulls and check existance
if ($invids[$key] > 0 && ext_ex("invoices", "invid", $invids[$key]) && $invprds[$key] != 0) {
db_connect();
$sql = "UPDATE invoices SET balance = (balance + '{$amounts[$key]}'::numeric(13,2)) WHERE invid = '{$invids[$key]}' AND div = '" . USER_DIV . "'";
$payRslt = db_exec($sql) or errDie("Unable to update Invoice information in Cubit.", SELF);
} elseif ($invids[$key] > 0 && ext_ex("nons_invoices", "invid", $invids[$key]) && $invprds[$key] == 0) {
db_connect();
$sql = "UPDATE nons_invoices SET balance = (balance + '{$amounts[$key]}'::numeric(13,2)) WHERE invid = '{$invids[$key]}' AND div = '" . USER_DIV . "'";
$payRslt = db_exec($sql) or errDie("Unable to update Invoice information in Cubit.", SELF);
custDTA($amounts[$key], $accnt['cusnum'], $rages[$key]);
} elseif ($invids[$key] > 0) {
db_conn($invprds[$key]);
# check if invoice exitsts on prd
if (ext_ex("invoices", "invid", $invids[$key])) {
# if found, Move the invoice back
if (moveback($invids[$key], $invprds[$key], $amounts[$key])) {
}
}
}
}
# Begin updates
pglib_transaction("BEGIN") or errDie("Unable to start a database transaction.", SELF);
db_connect();
# Update the customer (make balance more)
$sql = "UPDATE customers SET balance = (balance + '{$accnt['amount']}'::numeric(13,2)) WHERE cusnum = '{$accnt['cusnum']}' AND div = '" . USER_DIV . "'";
$rslt = db_exec($sql) or errDie("Unable to update invoice in Cubit1.", SELF);
# Record the transaction on the statement
$sql = "\n\t\t\t\tINSERT INTO stmnt \n\t\t\t\t\t(cusnum, invid, amount, date, type, div, allocation_date) \n\t\t\t\tVALUES('{$accnt['cusnum']}', '0', '{$accnt['amount']}','{$sdate}', 'Cheque/Payment for Invoices Cancelled.', '" . USER_DIV . "', '{$accnt['date']}')";
$stmntRslt = db_exec($sql) or errDie("Unable to insert statement record in Cubit.", SELF);
# Delete cashbook ID
$sql = "DELETE FROM cashbook WHERE cashid='{$cashid}' AND div = '" . USER_DIV . "'";
$Rslt = db_exec($sql) or errDie("Unable to cancel cheque.", SELF);
if ($accnt['lcashid'] > 0) {
// Connect to database
db_Connect();
$sql = "SELECT * FROM cashbook WHERE cashid = '{$accnt['lcashid']}' AND div = '" . USER_DIV . "'";
$laccntRslt = db_exec($sql) or errDie("ERROR: Unable to retrieve cashbook entry details from database.2", SELF);
$laccnt = pg_fetch_array($laccntRslt);
$sql = "UPDATE bankacct SET fbalance = (fbalance + '{$laccnt['famount']}'::numeric(13,2)), balance = (balance + '{$laccnt['amount']}'::numeric(13,2)) WHERE bankid = '{$laccnt['bankid']}'";
$rslt = db_exec($sql) or errDie("Unable to update invoice in Cubit2.", SELF);
# Delete cashbook ID
$sql = "DELETE FROM cashbook WHERE cashid = '{$accnt['lcashid']}' AND div = '" . USER_DIV . "'";
$Rslt = db_exec($sql) or errDie("Unable to cancel cheque.", SELF);
}
# Commit updates
pglib_transaction("COMMIT") or errDie("Unable to commit a database transaction.", SELF);
# Make ledge record
custledger($accnt['cusnum'], $bank['accnum'], $sdate, "cancel", "Payment for Invoices Cancelled.", $accnt['amount'], "d");
$descript = $accnt['descript'] . " Cancelled";
$refnum = getrefnum();
$date = date("Y-m-d");
//.........这里部分代码省略.........
示例9: printSet
function printSet()
{
// Connect to database
Db_Connect();
// Query server
$sql = "SELECT * FROM set WHERE label = 'INT_TYPE'";
$rslt = db_exec($sql) or errDie("ERROR: Unable to view settings", SELF);
// Die with custom error if failed
if (pg_numrows($rslt) < 1) {
$OUTPUT = "<li class='err'> No Setting currently in database.";
} else {
// Set up table to display in
$OUTPUT = "\n\t\t\t<h3>Settings</h3>\n\t\t\t<table " . TMPL_tblDflts . " width='300'>\n\t\t\t\t<tr>\n\t\t\t\t\t<th>Setting Type</th>\n\t\t\t\t\t<th>Current Setting</th>\n\t\t\t\t</tr>";
$set = pg_fetch_array($rslt);
$OUTPUT .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>{$set['type']}</td>\n\t\t\t\t\t<td>{$set['descript']}</td>\n\t\t\t\t</tr>\n\t\t\t</table>";
}
$OUTPUT .= "\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<script>document.write(getQuicklinkSpecial());</script>\n\t\t</table>";
return $OUTPUT;
}示例10: editAccnt
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<script>document.write(getQuicklinkSpecial());</script>\n\t</table>";
require "../template.php";
}示例11: copyEntry
function copyEntry($cashid)
{
# Get cash book record
Db_Connect();
$sql = "SELECT * FROM cashbook WHERE cashid = '{$cashid}' AND div = '" . USER_DIV . "'";
$accntRslt = db_exec($sql) or errDie("ERROR: Unable to retrieve cashbook entry details from database11.", SELF);
$accnt_cp = pg_fetch_array($accntRslt);
if ($accnt_cp['trantype'] == "deposit") {
$trantype = "withdrawal";
} else {
$trantype = "deposit";
}
$sql = "\n\t\tINSERT INTO cashbook (\n\t\t\ttrantype, bankid, date, name, descript, \n\t\t\tcheqnum, amount, banked, accinv, lnk, supid, \n\t\t\tcusnum, rinvids, amounts, invprds, ids, purids, \n\t\t\tpamounts, pdates, div, accids, suprec, vat, \n\t\t\tchrgvat, vats, chrgvats, rages, famount, \n\t\t\tfpamounts, famounts, lcashid, fcid, \n\t\t\tcurrency, location, opt\n\t\t) VALUES (\n\t\t\t'{$trantype}', '{$accnt_cp['bankid']}', '{$accnt_cp['date']}', '{$accnt_cp['name']}', '{$accnt_cp['descript']} Returned, Unpaid', \n\t\t\t'{$accnt_cp['cheqnum']}', '{$accnt_cp['amount']}', '{$accnt_cp['banked']}', '{$accnt_cp['accinv']}', '{$accnt_cp['lnk']}', '{$accnt_cp['supid']}', \n\t\t\t'{$accnt_cp['cusnum']}', '{$accnt_cp['rinvids']}', '{$accnt_cp['amounts']}', '{$accnt_cp['invprds']}', '{$accnt_cp['ids']}', '{$accnt_cp['purids']}', \n\t\t\t'{$accnt_cp['pamounts']}', '{$accnt_cp['pdates']}', '{$accnt_cp['div']}', '{$accnt_cp['accids']}', '{$accnt_cp['suprec']}', '{$accnt_cp['vat']}', \n\t\t\t'{$accnt_cp['chrgvat']}', '{$accnt_cp['vats']}', '{$accnt_cp['chrgvats']}', '{$accnt_cp['rages']}', '{$accnt_cp['famount']}', \n\t\t\t'{$accnt_cp['fpamounts']}', '{$accnt_cp['famounts']}', '{$accnt_cp['lcashid']}', '{$accnt_cp['fcid']}', \n\t\t\t'{$accnt_cp['currency']}', '{$accnt_cp['location']}', 'n'\n\t\t)";
$accntRslt = db_exec($sql) or errDie("ERROR: Unable to insert cashbook entry details to database11.", SELF);
}示例12: bank
function bank($_POST)
{
//processes
db_connect();
# get vars
extract($_POST);
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($cashid, "num", 1, 4, "Invalid Reference number.");
$v->isOk($day, "num", 1, 2, "Invalid Date day.");
$v->isOk($mon, "num", 1, 2, "Invalid Date month.");
$v->isOk($year, "num", 1, 4, "Invalid Date Year.");
$date = $day . "-" . $mon . "-" . $year;
if (!checkdate($mon, $day, $year)) {
$v->isOk($date, "num", 1, 1, "Invalid date.");
}
# 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 cashbook WHERE cashid = '{$cashid}'";
$cashRslt = db_exec($sql) or errDie("ERROR: Unable to retrieve cashbook entry details from database.", SELF);
if (pg_numrows($cashRslt) < 1) {
$OUTPUT = "<li clss='err'>The cashbook record with reference number, <b>{$cashid}</b> was not found in Cubit.</li>";
return $OUTPUT;
}
$cash = pg_fetch_array($cashRslt);
# get hook account number
core_connect();
$sql = "SELECT * FROM bankacc WHERE accid = '{$cash['bankid']}'";
$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.</li>";
}
$banklnk = pg_fetch_array($rslt);
# date format
$date = explode("-", $date);
$date = $date[2] . "-" . $date[1] . "-" . $date[0];
# write the transaction
if ($cash['trantype'] == "deposit") {
# debit bank and credit the account involved
writetrans($banklnk['accnum'], $cash['accinv'], $date, $refnum, $cash['amount'], $cash['descript']);
} else {
# credit bank and debit the account involved
writetrans($cash['accinv'], $banklnk['accnum'], $date, $refnum, $cash['amount'], $cash['descript']);
}
# set records as banked
db_connect();
$sql = "UPDATE cashbook SET banked = 'yes' WHERE cashid='{$cashid}'";
$Rslt = db_exec($sql) or errDie("Unable to set bank deposit as banked in Cubit.", SELF);
# status report
$bank = "\r\n\t\t\t\t<table " . TMPL_tblDflts . " width='100%'>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<th>Cash Book</th>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='datacell'>\r\n\t\t\t\t\t\t<td>Cash Book Entry was successfully processed.</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t</table>";
# main table (layout with menu)
$OUTPUT = "\r\n\t\t\t\t\t<center>\r\n\t\t\t\t\t<table width='90%'>\r\n\t\t\t\t\t\t<tr valign='top'>\r\n\t\t\t\t\t\t\t<td width='60%'>{$bank}</td>\r\n\t\t\t\t\t\t\t<td align='center'>\r\n\t\t\t\t\t\t\t\t<table " . TMPL_tblDflts . " width='80%'>\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 Navigation</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='datacell'>\r\n\t\t\t\t\t\t\t\t\t\t<td align='center'><a href='cashbook-view.php'>View Cash Book</td>\r\n\t\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t\t<script>document.write(getQuicklinkSpecial());</script>\r\n\t\t\t\t\t\t\t\t\t<tr class='datacell'>\r\n\t\t\t\t\t\t\t\t\t\t<td align='center'><a href='../reporting/not-banked.php'>View Outstanding Cash Book Entries</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='datacell'>\r\n\t\t\t\t\t\t\t\t\t\t<td align='center'><a href='bank-pay-add.php'>Add bank Payment</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='datacell'>\r\n\t\t\t\t\t\t\t\t\t\t<td align='center'><a href='bank-recpt-add.php'>Add Bank Receipt</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>";
return $OUTPUT;
}示例13: rem
function rem($_POST)
{
# Get vars
extract($_POST);
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($deptid, "num", 1, 50, "Invalid User Department ID.");
# display errors, if any
if ($v->isError()) {
$theseErrors = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$theseErrors .= "<li class='err'>" . $e["msg"] . "</li>";
}
$theseErrors .= "<p><input type='button' onClick='JavaScript:history.back();' value='« Correct submission'>";
return $theseErrors;
}
// Connect to database
Db_Connect();
// Query server
$sql = "SELECT * FROM depts WHERE deptid = '{$deptid}'";
$depRslt = db_exec($sql) or errDie("ERROR: Unable to department.", SELF);
if (pg_numrows($depRslt) < 1) {
return "<li> - Invalid User Department ID";
}
$dep = pg_fetch_array($depRslt);
// Query server
$sql = "DELETE FROM depts WHERE deptid = '{$deptid}'";
$RemRslt = db_exec($sql) or errDie("ERROR: Unable to delete department: {$dep['dept']}", SELF);
// Die with custom error if failed
// Remove department access
$sql = "DELETE FROM deptscripts WHERE dept = '{$deptid}'";
$Rslt = db_exec($sql) or errDie("ERROR: Unable to delete access for User Department : {$dep['depts']}", SELF);
// Provide some info on status
$OUTPUT = "\n\t\t<table " . TMPL_tblDflts . " width='50%'>\n\t\t\t<tr>\n\t\t\t\t<th>User Department deleted from database</th>\n\t\t\t</tr>\n\t\t\t<tr class='datacell'>\n\t\t\t\t<td>User Department <b>{$dep['dept']}</b>, was successfully deleted.</td>\n\t\t\t</tr>\n\t\t</table>\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<script>document.write(getQuicklinkSpecial());</script>\n\t\t</table>";
return $OUTPUT;
}示例14: remUser
function remUser($username)
{
$username = substr($username, 0, 255);
// Chop off anything after 10 chars
// check content of variable
if (preg_match("/[^\\w\\s]/", $username)) {
// Alphanum & space chars, 4-10
$OUTPUT = "Invalid user name.";
} else {
// Connect to database
Db_Connect();
// Query server
$sql = "DELETE FROM users WHERE username='{$username}'";
$RemRslt = db_exec($sql) or errDie("ERROR: Unable to delete user: {$username}", SELF);
// Die with custom error if failed
if (pg_cmdtuples($RemRslt) < 1) {
return "Failed to delete user.";
}
// remove user access
$sql = "DELETE FROM userscripts WHERE username='{$username}'";
$Rslt = db_exec($sql) or errDie("ERROR: Unable to delete access for user: {$username}", SELF);
// Provide some info on status
$OUTPUT = "\n\t\t\t<table " . TMPL_tblDflts . " width='50%'>\n\t\t\t\t<tr>\n\t\t\t\t\t<th>User deleted from database</th>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='datacell'>\n\t\t\t\t\t<td>User, '{$username}', was successfully deleted.</td>\n\t\t\t\t</tr>\n\t\t\t</table>\n\t\t\t<table " . TMPL_tblDflts . ">\n\t\t <tr>\n\t\t \t<th>Quick Links</th>\n\t\t </tr>\n\t\t <script>document.write(getQuicklinkSpecial());</script>\n\t </table>";
}
return $OUTPUT;
}示例15: bank
function bank($_POST)
{
//processes
db_connect();
# get var ( bank[] )
foreach ($_POST as $key => $value) {
${$key} = $value;
}
# validate input
require_lib("validate");
$v = new validate();
foreach ($bank as $key => $value) {
$v->isOk($refnum[$key], "num", 1, 10, "Invalid Reference number.");
$v->isOk($day[$key], "num", 1, 2, "Invalid Date day.");
$v->isOk($mon[$key], "num", 1, 2, "Invalid Date month.");
$v->isOk($year[$key], "num", 1, 4, "Invalid Date Year.");
$date[$key] = $day[$key] . "-" . $mon[$key] . "-" . $year[$key];
if (!checkdate($mon[$key], $day[$key], $year[$key])) {
$v->isOk($date[$key], "num", 1, 1, "Invalid date.");
}
}
# 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;
}
# status for each deposit
$status = "";
# get deposits info
foreach ($bank as $key => $cashid) {
// Connect to database
Db_Connect();
$sql = "SELECT * FROM cashbook WHERE cashid = '{$cashid}'";
$cashRslt = db_exec($sql) or errDie("ERROR: Unable to retrieve cashbook entry details from database.", SELF);
if (pg_numrows($cashRslt) < 1) {
$OUTPUT = "<li clss=err>The cashbook record with reference number, <b>{$cashid}</b> was not found in Cubit.";
return $OUTPUT;
}
$cash = pg_fetch_array($cashRslt);
# get hook account number
core_connect();
$sql = "SELECT * FROM bankacc WHERE accid = '{$cash['bankid']}'";
$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.";
}
$banklnk = pg_fetch_array($rslt);
# date format
$date[$key] = explode("-", $date[$key]);
$date[$key] = $date[$key][2] . "-" . $date[$key][1] . "-" . $date[$key][0];
# write the transaction
if ($cash['trantype'] == "deposit") {
# debit bank and credit the account involved
writetrans($banklnk['accnum'], $cash['accinv'], $date[$key], $refnum[$key], $cash['amount'], $cash['descript']);
} else {
# credit bank and debit the account involved
writetrans($cash['accinv'], $banklnk['accnum'], $date[$key], $refnum[$key], $cash['amount'], $cash['descript']);
}
# set records as banked
db_connect();
$sql = "UPDATE cashbook SET banked = 'yes' WHERE cashid='{$cashid}'";
$Rslt = db_exec($sql) or errDie("Unable to set bank deposit as banked in Cubit.", SELF);
//status
$status .= "<tr class=datacell><td>Cash book entry <b> : {$cash['descript']} - R {$cash['amount']}</b></td></tr>";
}
# status report
$banked = "\r\n <table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "' width='100%'>\r\n <tr><th>Cash deposit/transfer record Banked</th></tr>\r\n {$status}\r\n </table>";
# main table (layout with menu)
$OUTPUT = "<center>\r\n <table width = 90%>\r\n <tr valign=top><td width=60%>{$banked}</td>\r\n <td align=center>\r\n <table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "' width=80%>\r\n <tr><th>Quick Nevigation</th></tr>\r\n <tr class=datacell><td align=center><a href='deposit-view.php'>Bank Another Deposit</td></tr>\r\n <tr class=datacell><td align=center><a href='cheq-new.php'>Add Cheque Record</td></tr>\r\n <tr class=datacell><td align=center><a href='cheq-view.php'>View Cheque Records</td></tr>\r\n <tr class=datacell><td align=center><a href='deposit-new.php'>Add Deposit Records</td></tr>\r\n <tr class=datacell><td align=center><a href='deposit-view.php'>View Deposit Records</td></tr>\r\n </table>\r\n </td></tr></table>";
return $OUTPUT;
}