function slctacc($_POST)
{
# Get vars
extract($_POST);
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($lname, "string", 1, 255, "Invalid Ledger Name.");
$v->isOk($dtaccid, "num", 1, 50, "Invalid Account to be Debited.");
$v->isOk($ctaccid, "num", 1, 50, "Invalid Account to be Credited.");
$v->isOk($chrgvat, "string", 1, 4, "Invalid charge vat option.");
$v->isOk($numtran, "num", 1, 20, "Invalid Number on entries.");
$v->isOk($dateopt, "string", 1, 10, "Invalid date entry option.");
$v->isOk($desopt, "string", 1, 5, "Invalid Description option.");
if ($desopt == 'once') {
$v->isOk($descript, "string", 1, 255, "Invalid Description.");
} else {
$v->isOk($descript, "string", 0, 255, "Invalid Description.");
}
$v->isOk($refopt, "string", 1, 5, "Invalid Reference number option.");
if ($refopt == 'once') {
$v->isOk($refnum, "string", 1, 255, "Invalid Reference number.");
} else {
$v->isOk($refnum, "string", 0, 255, "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>";
}
return error($_POST, $confirm);
#$confirm .= "<p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>";
#return $confirm;
}
# uppercase first letter of name
$lname = ucfirst($lname);
# Account numbers
$dtaccRs = get("core", "*", "accounts", "accid", $dtaccid);
$dtacc = pg_fetch_array($dtaccRs);
$ctaccRs = get("core", "*", "accounts", "accid", $ctaccid);
$ctacc = pg_fetch_array($ctaccRs);
db_conn("core");
$vatacc = "<select name='vataccid'>";
$sql = "SELECT * FROM accounts WHERE div = '" . USER_DIV . "' ORDER BY accname ASC";
$accRslt = db_exec($sql);
if (pg_numrows($accRslt) < 1) {
return "<li>There are No accounts in Cubit.</li>";
}
while ($acc = pg_fetch_array($accRslt)) {
# Check Disable
if (isDisabled($acc['accid'])) {
continue;
}
$vatacc .= "<option value='{$acc['accid']}'>{$acc['topacc']}/{$acc['accnum']} - {$acc['accname']}</option>";
}
$vatacc .= "</select>";
// Details
$slctacc = "\r\n\t\t<center>\r\n\t\t<h3> New High Speed Input Ledger </h3>\r\n\t\t<h2>Select Vat Accounts</h2>\r\n\t\t<form action='" . SELF . "' method='POST' name='form'>\r\n\t\t\t<input type='hidden' name='key' value='details'>\r\n\t\t\t<input type='hidden' name='lname' value='{$lname}'>\r\n\t\t\t<input type='hidden' name='dtaccid' value='{$dtaccid}'>\r\n\t\t\t<input type='hidden' name='ctaccid' value='{$ctaccid}'>\r\n\t\t\t<input type='hidden' name='chrgvat' value='{$chrgvat}'>\r\n\t\t\t<input type='hidden' name='numtran' value='{$numtran}'>\r\n\t\t\t<input type='hidden' name='dateopt' value='{$dateopt}'>\r\n\t\t\t<input type='hidden' name='descript' value='{$descript}'>\r\n\t\t\t<input type='hidden' name='desopt' value='{$desopt}'>\r\n\t\t\t<input type='hidden' name='refnum' value='{$refnum}'>\r\n\t\t\t<input type='hidden' name='refopt' value='{$refopt}'>\r\n\t\t<table " . TMPL_tblDflts . " align='center'>\r\n\t\t\t<tr>\r\n\t\t\t\t<th>Option</th>\r\n\t\t\t\t<th>Value</th>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Ledger Name</td>\r\n\t\t\t\t<td>{$lname}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td valign='top'>Vat Deductable Account</td>\r\n\t\t\t\t<td><input type='radio' name='vatdedacc' value='{$dtaccid}' checked='yes'>{$dtacc['topacc']}/{$dtacc['accnum']} - {$dtacc['accname']}<br><input type='radio' name='vatdedacc' value='{$ctaccid}'>{$ctacc['topacc']}/{$ctacc['accnum']} - {$ctacc['accname']}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Vat Account</td>\r\n\t\t\t\t<td>{$vatacc}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Vat Inclusive </td>\r\n\t\t\t\t<td><input type='radio' size='20' name='vatinc' value='yes' checked='yes'>Yes(Amount Includes Vat) <input type='radio' size='20' name='vatinc' value='no'>No(Add Vat to Amount)</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr><td><br></td></tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td align='right'><input type='button' value='« Back' onClick='javascript:history.back()'></td>\r\n\t\t\t\t<td align='right'><input type='submit' value='Continue »'></td>\r\n\t\t\t</tr>\r\n\t\t</table>\r\n\t\t</form>\r\n\t\t<p>\r\n\t\t<table border=0 cellpadding='2' cellspacing='1' width=15%>\r\n\t\t\t<tr>\r\n\t\t\t\t<th>Quick Links</th>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td align='center'><a href='ledger-view.php'>View High Speed Input Ledgers</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td align='center'><a href='../main.php'>Main Menu</td>\r\n\t\t\t</tr>\r\n\t\t</table>";
return $slctacc;
}
function add()
{
extract($_REQUEST);
$qry = new dbSelect("batch_cashbook", "cubit", grp(m("where", wgrp(m("cashid", "{$id}")))));
$qry->run();
if ($qry->num_rows() <= 0) {
invalid_use("Invalid batch cashbook entry.");
}
$bcb = $qry->fetch_array();
if ($bcb["chrgvat"] == "exc") {
$bcb["amount"] -= $bcb["vat"];
}
extract($bcb, EXTR_SKIP);
core_connect();
$accs = qryAccounts();
if ($accs->num_rows() <= 0) {
$glacc = "There are no Income accounts in Cubit.";
}
$glacc = "<select name='accinv'>";
while ($acc = $accs->fetch_array()) {
if (isDisabled($acc['accid'])) {
continue;
}
if ($accinv == $acc['accid']) {
$sel = "selected";
} else {
$sel = "";
}
$glacc .= "<option value='{$acc['accid']}' {$sel}>{$acc['accname']}</option>";
}
$glacc .= "</select>";
$OUT = "\n\t\t\t\t<h3>Edit Bank Receipt</h3>\n\t\t\t\t<table " . TMPL_tblDflts . " width='100%'>\n\t\t\t\t<form action='" . SELF . "' method='POST' name='form'>\n\t\t\t\t\t<input type='hidden' name='key' value='confirm'>\n\t\t\t\t\t<input type='hidden' name='id' value='{$id}'>\n\t\t\t\t\t<input type='hidden' name='vat' value='{$bcb['vat']}' />\n\t\t\t\t\t<input type='hidden' name='orig_vatcode' value='{$bcb['vatcode']}' />\n\t\t\t\t\t<input type='hidden' name='orig_chrgvat' value='{$bcb['chrgvat']}' />\n\t\t\t\t\t<input type='hidden' name='orig_amount' value='{$bcb['amount']}' />\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<th>Field</th>\n\t\t\t\t\t\t<th>Value</th>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Bank Account</td>\n\t\t\t\t\t\t<td valign='center'>\n\t\t\t\t\t\t\t<select name='bankid'>";
db_connect();
$qry->setTable("bankacct", "cubit");
$qry->setOpt(grp(m("where", "btype!='int' AND div='" . USER_DIV . "'")));
$qry->run();
if ($qry->num_rows() <= 0) {
return "<li class='err'> There are no accounts held at the selected Bank.\n\t\t\t<p><input type='button' onClick='JavaScript:history.back();' value='« Correct Selection'>";
}
while ($acc = $qry->fetch_array()) {
if (isset($bankid) && $bankid == $acc['bankid']) {
$sel = "selected";
} else {
$sel = "";
}
$OUT .= "<option value='{$acc['bankid']}' {$sel}>{$acc['accname']} - {$acc['bankname']} ({$acc['acctype']})</option>";
}
if (!isset($name)) {
$name = "";
$descript = "";
$cheqnum = "";
$amount = "";
$chrgvat = "";
}
db_conn('cubit');
$Sl = "SELECT * FROM vatcodes ORDER BY code";
$Ri = db_exec($Sl) or errDie("Unable to get vat codes");
$Vatcodes = "\n\t\t\t<select name='vatcode'>\n\t\t\t\t<option value='0'>Select</option>";
$vacs = qryVatcode();
$Vatcodes = db_mksel($vacs, "vatcode", $vatcode, "#id", "#code", "0:Select");
list($o_year, $o_month, $o_day) = explode('-', $date);
$sel1 = "";
$sel2 = "";
$sel3 = "";
if ($chrgvat == "inc") {
$sel1 = "checked=yes";
} else {
if ($chrgvat == "exc") {
$sel2 = "checked=yes";
} else {
if ($chrgvat == "nov") {
$sel3 = "checked=yes";
} else {
$sel1 = "checked=yes";
}
}
}
$OUT .= "\n\t\t</select>\n\t\t</td>\n\t</tr>\n\t<tr class='" . bg_class() . "'>\n\t\t<td>Date</td>\n\t\t<td>\n\t\t\t" . mkDateSelect("o", $o_year, $o_month, $o_day) . "\n\t\t</td>\n\t</tr>\n\t<tr class='" . bg_class() . "'>\n\t\t<td>Received from</td>\n\t\t<td valign='center'><input size='20' name='name' value='{$name}'></td>\n\t</tr>\n\t<tr class='" . bg_class() . "'>\n\t\t<td>Description</td>\n\t\t<td valign='center'><textarea col='18' rows='3' name='descript'>{$descript}</textarea></td>\n\t</tr>\n\t<tr class='" . bg_class() . "'>\n\t\t<td>Reference</td>\n\t\t<td valign='center'><input size='20' name='reference' value='{$reference}'></td>\n\t</tr>\n\t<tr class='" . bg_class() . "'>\n\t\t<td>Cheque Number</td>\n\t\t<td valign='center'><input size='20' name='cheqnum' value='{$cheqnum}'></td>\n\t</tr>\n\t<tr class='" . bg_class() . "'>\n\t\t<td>Amount</td>\n\t\t<td valign='center'>" . CUR . " <input type='text' size='10' name='amount' value='" . sprint($amount) . "'></td>\n\t</tr>\n\t<tr class='" . bg_class() . "'>\n\t\t<td>VAT </td>\n\t\t<td>\n\t\t\t<input type='radio' name='chrgvat' value='inc' {$sel1}>Inclusive \n\t\t\t<input type='radio' name='chrgvat' value='exc' {$sel2}>Exclusive \n\t\t\t<input type='radio' name='chrgvat' value='nov' {$sel3}>No VAT\n\t\t</td>\n\t</tr>\n\t<tr class='" . bg_class() . "'>\n\t\t<td>VAT Code</td>\n\t\t<td>{$Vatcodes}</td>\n\t</tr>\n\t<tr class='" . bg_class() . "'>\n\t\t<td valign='top'>Select Contra Account</td>\n\t\t<td>{$glacc}</td>\n\t</tr>\n\t<tr>\n\t\t<td> </td>\n\t\t<td valign='center' align='right'><input type='submit' value='Confirm »'></td>\n\t</tr>\n\t</table>";
# main table (layout with menu)
$OUT .= mkQuickLinks();
return $OUT;
}
function slctacc($_GET)
{
extract($_GET);
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($cusnum, "num", 1, 50, "Invalid customer id.");
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class='err'>-" . $e["msg"] . "</li>";
}
return $confirm;
}
# refnum
$refnum = getrefnum();
# Select customer
db_connect();
$sql = "SELECT * FROM customers WHERE cusnum = '{$cusnum}' AND div = '" . USER_DIV . "'";
$custRslt = db_exec($sql) or errDie("Unable to access databse.", SELF);
if (pg_numrows($custRslt) < 1) {
return "<li> Invalid Customer ID.</li>";
} else {
$cust = pg_fetch_array($custRslt);
}
# Accounts drop down
core_connect();
$accounts = "<select name='accid'>";
$sql = "SELECT * FROM accounts WHERE div = '" . USER_DIV . "' ORDER BY accname ASC";
$accRslt = db_exec($sql);
if (pg_numrows($accRslt) < 1) {
return "<li>There are No accounts in Cubit.</li>";
}
while ($acc = pg_fetch_array($accRslt)) {
$sel = "";
if (isset($cacc)) {
if ($cacc == $acc['accid']) {
$sel = "selected";
}
}
# Check Disable
if (isDisabled($acc['accid'])) {
continue;
}
$accounts .= "<option value='{$acc['accid']}' {$sel}>{$acc['accname']}</option>";
}
$accounts .= "</select>";
$entd = "";
$entc = "checked=yes";
if (isset($tran)) {
if ($tran == "dt") {
$entd = "checked=yes";
$entc = "";
}
}
// Accounts (debit)
$view = "\n\t\t\t<h3> Journal transaction </h3>\n\t\t\t<form action='" . SELF . "' method='POST' name='form'>\n\t\t\t\t<input type='hidden' name='key' value='details'>\n\t\t\t\t<input type='hidden' name='cusnum' value='{$cusnum}'>\n\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t<tr>\n\t\t\t\t\t<th>Field</th>\n\t\t\t\t\t<th>Value</th>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Account Number</td>\n\t\t\t\t\t<td>{$cust['accno']}</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Customer</td>\n\t\t\t\t\t<td>{$cust['cusname']} {$cust['surname']}</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Date</td>\n\t\t\t\t\t<td>" . mkDateSelect("date") . "</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Reference Number</td>\n\t\t\t\t\t<td><input type='text' size='10' name='refnum' value='" . $refnum++ . "'></td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Entry Type</td>\n\t\t\t\t\t<td><input type='radio' name='entry' value='DT' {$entd}> Debit | <input type='radio' name='entry' value='CT' {$entc}>Credit</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td rowspan='2'>Cotra Account</td>\n\t\t\t\t\t<td>{$accounts} <input name='details' type='submit' value='Enter Details'></td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<!-- Rowspan -->\n\t\t\t\t\t<td><input type='text' name='accnum' size='20'> <input type='submit' value='Enter Details'></td>\n\t\t\t\t</tr>\n\t\t\t</table>\n\t\t\t<p>\n\t\t\t<input type='button' value='Go Back' onClick='javascript:history.back();'>\n\t\t\t</form>\n\t\t\t<table border='0' cellpadding='2' cellspacing='1' width='15%'>\n\t\t\t\t" . TBL_BR . "\n\t\t\t\t<tr>\n\t\t\t\t\t<th>Quick Links</th>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td align='center'><a href='trans-new.php'>Journal Transactions</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td align='center'><a href='../customers-view.php'>View Customers</a></td>\n\t\t\t\t</tr>\n\t\t\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t\t\t</table>";
return $view;
}
function enter2($_POST)
{
extract($_POST);
$description = safe($description);
$pn = safe($pn);
$type = safe($type);
$action = safe($action);
if ($action == "Customer Payment" && $pn == "-") {
return "<li class='err'>You cannot have a 'Payment from customer' on your statement for a negative amount.</li>" . enter($_POST);
}
if ($action == "Supplier Payment" && $pn == "+") {
return "<li class='err'>You cannot have a 'Payment to supplier' on your statement for a positive amount.</li>" . enter($_POST);
}
if ($action == "Insert into cashbook") {
$details = "\r\n\t\t\t<select name='account'>\r\n\t\t\t\t<option value=''>Select Account</option>";
db_conn('core');
$Sl = "SELECT * FROM accounts WHERE div = '" . USER_DIV . "' ORDER BY accname";
$Rl = db_exec($Sl) or errDie("Unable to get account data.");
if (pg_numrows($Rl) < 1) {
return "<li>There are No accounts in Cubit.";
}
while ($ad = pg_fetch_array($Rl)) {
if (isDisabled($ad['accid'])) {
continue;
}
$details .= "<option value='{$ad['accid']}'>{$ad['accname']}</option>";
}
$details .= "</select>";
} elseif ($action == "Customer Payment") {
db_conn('cubit');
$Sl = "SELECT cusnum,surname FROM customers WHERE div='" . USER_DIV . "' AND location='loc' ORDER BY surname";
$Rl = db_exec($Sl) or errDie("Unable to get customers.");
$details = "\r\n\t\t\t<select name='account'>\r\n\t\t\t\t<option value='0'>Select Customer</option>";
while ($cd = pg_fetch_array($Rl)) {
$details .= "<option value='{$cd['cusnum']}'>{$cd['surname']}</option>";
}
$details .= "</select>";
} elseif ($action == "Supplier Payment") {
db_conn('cubit');
$Sl = "SELECT supid,supname FROM suppliers WHERE div='" . USER_DIV . "' AND location='loc' ORDER BY supname";
$Rl = db_exec($Sl) or errDie("Unable to get suppliers.");
$details = "\r\n\t\t\t<select name='account'>\r\n\t\t\t\t<option value=0>Select Supplier</option>";
while ($cd = pg_fetch_array($Rl)) {
$details .= "<option value='{$cd['supid']}'>{$cd['supname']}</option>";
}
$details .= "</select>";
} elseif ($action == "Ignore") {
$details = "<input type=hidden name=account value=0>";
} elseif ($action == "Delete") {
$details = "<input type=hidden name=account value=0>";
}
$out = "\r\n\t\t<h3>Add statement description details</h3>\r\n\t\t<table " . TMPL_tblDflts . ">\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='description' value='{$description}'>\r\n\t\t\t<input type='hidden' name='pn' value='{$pn}'>\r\n\t\t\t<input type='hidden' name='type' value='{$type}'>\r\n\t\t\t<input type='hidden' name='action' value='{$action}'>\r\n\t\t\t<tr>\r\n\t\t\t\t<th colspan='2'>Details</th>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Description</td>\r\n\t\t\t\t<td>{$description}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>+/-</td>\r\n\t\t\t\t<td>{$pn}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Type</td>\r\n\t\t\t\t<td>{$type}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Action</td>\r\n\t\t\t\t<td>{$action}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Action Details</td>\r\n\t\t\t\t<td>{$details}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr><td><br></td></tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td colspan='2' align='right'><input type='submit' value='Confirm »'></td>\r\n\t\t\t</tr>\r\n\t\t</form>\r\n\t\t</table>";
return $out;
}
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;
}
$prd += 0;
# get Order info
db_conn($prd);
$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
# currency
$currs = getSymbol($pur['fcid']);
$curr = $currs['symbol'];
$currsel = "{$currs['symbol']} - {$currs['descrip']}";
/* --- Start Drop Downs --- */
# format date
list($pyear, $pmon, $pday) = explode("-", $pur['pdate']);
list($dyear, $dmon, $dday) = explode("-", $pur['ddate']);
$stkacc = "<select name='stkacc[]'>";
core_connect();
$sql = "SELECT * FROM accounts WHERE div = '" . USER_DIV . "' ORDER BY accname ASC";
$accRslt = db_exec($sql);
if (pg_numrows($accRslt) < 1) {
return "<li>There are No accounts in Cubit.";
}
while ($acc = pg_fetch_array($accRslt)) {
# Check Disable
if (isDisabled($acc['accid'])) {
continue;
}
$stkacc .= "<option value='{$acc['accid']}'>{$acc['topacc']}/{$acc['accnum']} - {$acc['accname']}</option>";
}
$stkacc .= "</select>";
# get selected supplier info
db_connect();
$sql = "SELECT * FROM suppliers WHERE supid = '{$pur['supid']}' AND div = '" . USER_DIV . "'";
$supRslt = db_exec($sql) or errDie("Unable to get supplier");
if (pg_numrows($supRslt) < 1) {
$error = "<li class='err'> Supplier not Found.</li>";
$confirm .= "{$error}<p><input type='button' onClick='JavaScript:history.back();' value='« Correct submission'>";
return $confirm;
}
$sup = pg_fetch_array($supRslt);
/* --- End Drop Downs --- */
/* --- 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 RETURNED</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_conn($prd);
$sql = "SELECT *, (qty - rqty) as qty FROM nons_purint_items WHERE purid = '{$purid}' AND (qty - rqty) > 0 AND div = '" . USER_DIV . "'";
$stkdRslt = db_exec($sql);
while ($stkd = pg_fetch_array($stkdRslt)) {
$stkacc = "<input type='hidden' name='stkacc[]' value='{$stkd['accid']}'>";
# put in product
$products .= "\n\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t\t<td><input type='hidden' name='ids[]' value='{$stkd['id']}'>{$stkd['cod']}</td>\n\t\t\t\t\t\t\t\t<td>{$stkd['des']}</td>\n\t\t\t\t\t\t\t\t<td><input type='hidden' name='qts[]' value='{$stkd['qty']}'><input type='text' size='5' name='qtys[]' value='{$stkd['qty']}'></td>\n\t\t\t\t\t\t\t\t<td nowrap>{$pur['curr']} {$stkd['cunitcost']} or </td>\n\t\t\t\t\t\t\t\t<td nowrap>" . CUR . " {$stkd['unitcost']}</td>\n\t\t\t\t\t\t\t\t<td>{$pur['curr']} {$stkd['duty']} or </td>\n\t\t\t\t\t\t\t\t<td>{$stkd['dutyp']}%</td>\n\t\t\t\t\t\t\t\t<td nowrap>{$pur['curr']} {$stkd['amt']}</td>\n\t\t\t\t\t\t\t\t{$stkacc}\n\t\t\t\t\t\t\t</tr>";
}
$products .= "</table>";
/* --- End Products Display --- */
/* -- Final Layout -- */
$details = "\n\t\t\t\t\t<center>\n\t\t\t\t\t<h3>Return International Non-Stock Order</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='confirm'>\n\t\t\t\t\t\t<input type='hidden' name='purid' value='{$purid}'>\n\t\t\t\t\t\t<input type='hidden' name='prd' value='{$prd}'>\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>Account</td>\n\t\t\t\t\t\t\t\t\t\t<td>{$sup['supno']}</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</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<input type='hidden' name='refno' size='10' value='{$pur['refno']}'>\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<input type='hidden' size='2' name='dday' maxlength='2' value='{$dday}'>\n\t\t\t\t\t\t\t\t\t<input type='hidden' size='2' name='dmon' maxlength='2' value='{$dmon}'>\n\t\t\t\t\t\t\t\t\t<input type='hidden' size='4' name='dyear' maxlength='4' value='{$dyear}'>\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<p>\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='25%'>Quick Links</th>\n\t\t\t\t\t\t\t\t\t\t<th width='25%'>Remarks</th>\n\t\t\t\t\t\t\t\t\t\t<td rowspan='5' valign='top' width='50%'>{$error}</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' nowrap>{$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' nowrap>{$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' nowrap>{$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' nowrap>{$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='submit' name='upBtn' value='Confirm'></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;
}
$clr = 'green';
$hint = 'aktif';
$icon = 'checkmark';
} else {
//tidak aktif
$clr = 'red';
$hint = 'tidak aktif';
$icon = 'blocked';
}
// <td align="center">'.getFieldArr('id_departemen','kon_logindepartemen','id_login',$res['id_login']).'</td>
$out .= '<tr>
<td align="center">' . $res['nama'] . '</td>
<td align="center">' . $res['username'] . '</td>
<td align="center">' . $res['level'] . '</td>
<td align="center">
<button ' . isDisabled('user', 'u') . ' onclick="aktifkan(' . $res['id_login'] . ');" class="fg-white bg-' . $clr . '" data-hint="' . $hint . '"><i class="icon-' . $icon . '"></i></button>
</td>
' . $btn . '
</tr>';
// $nox++;
}
} else {
#kosong
$out .= '<tr align="center">
<td colspan=9 ><span style="color:red;text-align:center;">
... data tidak ditemukan...</span></td></tr>';
}
#link paging
$out .= '<tr class="info"><td colspan=9>' . $obj->anchors . '</td></tr>';
$out .= '<tr class="info"><td colspan=9>' . $obj->total . '</td></tr>';
break;
function slctacc($_GET, $err = "")
{
extract($_GET);
if (!isset($refnu)) {
$refnum = getrefnum();
}
# Select customer
db_connect();
$get_cust = "SELECT * FROM customers WHERE blocked = 'no'";
$run_cust = db_exec($get_cust) or errDie("Unable to get customers information.");
if (pg_numrows($run_cust) < 1) {
return "No Valid Customers Found.";
}
$cust_drop = "<select name='cusnum'>";
while ($carr = pg_fetch_array($run_cust)) {
if (isset($cusnum) and $cusnum == $carr['cusnum']) {
$cust_drop .= "<option value='{$carr['cusnum']}' selected>{$carr['accno']} {$carr['surname']}</option>";
} else {
$cust_drop .= "<option value='{$carr['cusnum']}'>{$carr['accno']} {$carr['surname']}</option>";
}
}
$cust_drop .= "</select>";
# Accounts drop down
core_connect();
$accounts = "<select name='accid'>";
$sql = "SELECT * FROM accounts WHERE div = '" . USER_DIV . "' ORDER BY accname ASC";
$accRslt = db_exec($sql);
if (pg_numrows($accRslt) < 1) {
return "<li>There are No accounts in Cubit.</li>";
}
while ($acc = pg_fetch_array($accRslt)) {
$sel = "";
if (isset($cacc)) {
if ($cacc == $acc['accid']) {
$sel = "selected";
}
}
# Check Disable
if (isDisabled($acc['accid'])) {
continue;
}
$accounts .= "<option value='{$acc['accid']}' {$sel}>{$acc['accname']}</option>";
}
$accounts .= "</select>";
$entd = "";
$entc = "checked=yes";
if (isset($tran)) {
if ($tran == "dt") {
$entd = "checked=yes";
$entc = "";
}
}
if (!isset($ct_year)) {
$ct_year = date("Y");
$ct_month = date("m");
$ct_day = date("d");
}
db_connect();
$get_batch = "SELECT * FROM cust_trans_batch ORDER BY proc_date, cusnum";
$run_batch = db_exec($get_batch) or errDie("Unable to get batch customer transaction information.");
if (pg_numrows($run_batch) < 1) {
$show_batch_listing = "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td colspan='9'>No entries Found.</td>\n\t\t\t</tr>";
} else {
$show_batch_listing = "";
while ($barr = pg_fetch_array($run_batch)) {
db_connect();
$get_cust = "SELECT accno, surname FROM customers WHERE cusnum = '{$barr['cusnum']}' LIMIT 1";
$run_cust = db_exec($get_cust) or errDie("Unable to get customer information.");
$showcusnum = "(" . pg_fetch_result($run_cust, 0, 0) . ") " . pg_fetch_result($run_cust, 0, 1);
if (isset($barr['chrg_vat']) and $barr['chrg_vat'] != "0") {
$get_vatcode = "SELECT vat_amount FROM vatcodes WHERE id = '{$barr['vatcode']}' LIMIT 1";
$run_vatcode = db_exec($get_vatcode) or errDie("Unable to get vat code information.");
if (pg_numrows($run_vatcode) < 1) {
#vatcode not found ....
return "<li class='err'>Unable to get vat code information.</li>";
}
$vd = pg_fetch_array($run_vatcode);
if ($barr['chrg_vat'] == "inc") {
$vatamt = sprint($barr['amount'] * ($vd['vat_amount'] / (100 + $vd['vat_amount'])));
$showamount = sprint($barr['amount'] - $vatamt);
$showvat = sprint($vatamt) . " (Inclusive)";
} else {
$showamount = sprint($barr['amount']);
$vatamt = $barr['amount'] / 100 * $vd['vat_amount'];
$showvat = sprint($vatamt) . " (Exclusive)";
}
} else {
#vat not set
$showamount = sprint($barr['amount']);
$showvat = CUR . " " . sprint(0) . " (No VAT)";
}
core_connect();
$get_acc = "SELECT accname FROM accounts WHERE accid = '{$barr['contra_account']}' LIMIT 1";
$run_acc = db_exec($get_acc) or errDie("Unable to get account information.");
$showaccount = pg_fetch_result($run_acc, 0, 0);
$show_batch_listing .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>{$showcusnum}</td>\n\t\t\t\t\t<td>{$barr['proc_date']}</td>\n\t\t\t\t\t<td>{$barr['ref_num']}</td>\n\t\t\t\t\t<td>{$barr['entry_type']}</td>\n\t\t\t\t\t<td>{$showaccount}</td>\n\t\t\t\t\t<td>{$showamount}</td>\n\t\t\t\t\t<td>{$showvat}</td>\n\t\t\t\t\t<td><input type='checkbox' name='rem_trans[{$barr['id']}]' value='yes'></td>\n\t\t\t\t\t<td><input type='checkbox' name='proc_trans[{$barr['id']}]' value='yes' checked='yes'></td>\n\t\t\t\t</tr>";
$totamount += $showamount;
$totvatamt += $showvat;
}
$show_batch_listing .= "\n\t\t\t<tr>\n\t\t\t\t<td colspan='3'></td>\n\t\t\t\t<th colspan='2'>TOTALS:</td>\n\t\t\t\t<td nowrap class='" . bg_class() . "'>" . CUR . " {$totamount}</td>\n\t\t\t\t<td nowrap class='" . bg_class() . "'>" . CUR . " {$totvatamt}</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td colspan='3'></td>\n\t\t\t\t<th colspan='2'>TOTAL INC VAT</th>\n\t\t\t\t<td nowrap class='" . bg_class() . "' colspan='2'>" . CUR . " " . sprint($totamount + $totvatamt) . "</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 colspan='9' align='right'><input type='submit' name='remove_entries' value='Remove Selected'></td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td colspan='9' align='right'><input type='submit' name='process_batch' value='Process Selected Entries'></td>\n\t\t\t</tr>";
}
db_connect();
#get vat codes for dropdown
$get_vatc = "SELECT * FROM vatcodes ORDER BY code";
$run_vatc = db_exec($get_vatc) or errDie("Unable to get vat codes information.");
if (pg_numrows($run_vatc) < 1) {
$vatcode_drop = "<input type='hidden' name='vatcode' value=''>";
} else {
$vatcode_drop = "<select name='vatcode'>";
while ($varr = pg_fetch_array($run_vatc)) {
if (isset($vatcode) and $vatcode == $varr['id']) {
$vatcode_drop .= "<option value='{$varr['id']}' selected>{$varr['code']} {$varr['description']}</option>";
} else {
$vatcode_drop .= "<option value='{$varr['id']}'>{$varr['code']} {$varr['description']}</option>";
}
}
$vatcode_drop .= "</select>";
}
// Accounts (debit)
$view = "\n\t\t<h3>Multiple Journal Transaction </h3>\n\t\t<form action='" . SELF . "' method='POST' name='form0' enctype='multipart/form-data'>\n\t\t\t<input type='hidden' name='key' value='import'>\n\t\t\t<input type='file' name='import_file'>\n\t\t\t<input type='submit' value='Import File'>\n\t\t</form>\n\t\t<form action='" . SELF . "' method='POST' name='form'>\n\t\t\t{$err}\n\t\t\t<input type='hidden' name='key' value='details'>\n\t\t<table " . TMPL_tblDflts . ">\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>Customer</td>\n\t\t\t\t<td>{$cust_drop}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Date</td>\n\t\t\t\t<td>" . mkDateSelect("ct", $ct_year, $ct_month, $ct_day) . "</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Reference Number</td>\n\t\t\t\t<td><input type='text' size='10' name='refnum' value='" . $refnum++ . "'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Entry Type</td>\n\t\t\t\t<td>\n\t\t\t\t\t<li class='err'>This will debit/credit the customer account selected</li>\n\t\t\t\t\t<input type='radio' name='entry' value='DT' {$entd}> Debit | <input type='radio' name='entry' value='CT' {$entc}>Credit</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td rowspan='2'>Contra Account</td>\n\t\t\t\t<td>{$accounts} <input name='details' type='submit' value='Enter Details'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<!-- Rowspan -->\n\t\t\t\t<td><input type='text' name='accnum' size='20'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Charge VAT</td>\n\t\t\t\t<td>\n\t\t\t\t\t{$vatcode_drop}\n\t\t\t\t\t<input type='radio' name='vatinc' value='inc'> Inclusive \n\t\t\t\t\t<input type='radio' name='vatinc' value='excl' checked='yes'> Exclusive \n\t\t\t\t\t<input type='radio' name='vatinc' value='0'> No VAT\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>Amount</td>\n\t\t\t\t<td valign='center'>" . CUR . " <input type='text' size='20' name='amount' value='{$amount}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Transaction Details</td>\n\t\t\t\t<td valign='center'><textarea cols='40' rows='4' name='details'>{$details}</textarea></td>\n\t\t\t</tr>\n\t\t\t" . TBL_BR . "\n\t\t\t<tr>\n\t\t\t\t<td colspan='2' align='right'><input type='submit' name='add_batch' value='Add To Batch'></td>\n\t\t\t</tr>\n\t\t\t" . TBL_BR . "\n\t\t</table>\n\t\t<table " . TMPL_tblDflts . " width='90%'>\n\t\t\t<tr>\n\t\t\t\t<th>Customer Number</th>\n\t\t\t\t<th>Process Date</th>\n\t\t\t\t<th>Reference Number</th>\n\t\t\t\t<th>Entry Type</th>\n\t\t\t\t<th>Contra Account</th>\n\t\t\t\t<th>Amount</th>\n\t\t\t\t<th>VAT</th>\n\t\t\t\t<th>Remove</th>\n\t\t\t\t<th>Process</th>\n\t\t\t</tr>\n\t\t\t{$show_batch_listing}\n\t\t\t" . TBL_BR . "\n\t\t</table>" . mkQuickLinks(ql("trans-new.php", "Journal Transactions"), ql("../customers-view.php", "View Customers"));
return $view;
}
function slctVatacc($_POST, $err = "")
{
extract($_POST);
if (isset($back)) {
if (isset($details)) {
return $confirm . "</li>" . details($_POST);
} else {
return $confirm . "</li>" . details2($_POST);
}
}
require_lib("validate");
$v = new validate();
$v->isOk($ctaccid, "num", 1, 50, "Invalid Account to be Credited.");
$v->isOk($dtaccid, "num", 1, 50, "Invalid Account to be Debited.");
$v->isOk($refnum, "num", 1, 10, "Invalid Reference number.");
$v->isOk($amount, "float", 1, 20, "Invalid Amount.");
$v->isOk($details, "string", 0, 255, "Invalid Details.");
$v->isOk($author, "string", 1, 30, "Invalid Authorising person name.");
$v->isOk($chrgvat, "string", 1, 4, "Invalid charge vat option.");
$v->isOk($date, "date", 1, 1, "Invalid date.");
if ($v->isError()) {
$err = $v->genErrors();
if (isset($details)) {
return details($_POST, $err);
} else {
return details2($_POST, $err);
}
}
if (!isset($vatinc)) {
$vatinc = "";
$vatdedacc = "";
$vataccid = 0;
}
if ($vatdedacc == "{$ctaccid}") {
$dsel1 = "";
$dsel2 = "checked=yes";
} else {
$dsel1 = "checked=yes";
$dsel2 = "";
}
if ($vatinc == "no") {
$vatsel1 = "";
$vatsel2 = "checked=yes";
} else {
$vatsel2 = "";
$vatsel1 = "checked=yes";
}
# Account numbers
$dtaccRs = get("core", "*", "accounts", "accid", $dtaccid);
$dtacc = pg_fetch_array($dtaccRs);
$ctaccRs = get("core", "*", "accounts", "accid", $ctaccid);
$ctacc = pg_fetch_array($ctaccRs);
db_conn('core');
$vatacc = "<select name='vataccid'>";
$sql = "SELECT * FROM accounts WHERE div = '" . USER_DIV . "' ORDER BY accname ASC";
$accRslt = db_exec($sql);
if (pg_numrows($accRslt) < 1) {
return "<li>There are No accounts in Cubit.</li>";
}
while ($acc = pg_fetch_array($accRslt)) {
# Check Disable
if (isDisabled($acc['accid'])) {
continue;
}
if ($vataccid == $acc['accid']) {
$sel = "selected";
} else {
$sel = "";
}
$vatacc .= "<option value='{$acc['accid']}' {$sel}>{$acc['topacc']}/{$acc['accnum']} - {$acc['accname']}</option>";
}
$vatacc .= "</select>";
db_conn('cubit');
if (!isset($vatcode)) {
$Sl = "SELECT * FROM vatcodes WHERE del='Yes'";
$Ri = db_exec($Sl) or errDie("Unable to get data.");
$vd = pg_fetch_array($Ri);
$vatcode = $vd['id'];
}
if (!isset($vatcode)) {
$vatcode = 0;
}
$Sl = "SELECT * FROM vatcodes ORDER BY code";
$Ri = db_exec($Sl) or errDie("Unable to get vat codes");
$Vatcodes = "<select name='vatcode'>";
while ($vd = pg_fetch_array($Ri)) {
if ($vd['id'] == $vatcode) {
$sel = "selected";
} else {
$sel = "";
}
$Vatcodes .= "<option value='{$vd['id']}' {$sel}>{$vd['code']}</option>";
}
$Vatcodes .= "</select>";
// Details
$slctacc = "\n\t\t\t\t\t<center>\n\t\t\t\t\t<h3>Journal Transaction VAT Details</h3>\n\t\t\t\t\t<h4>Select VAT Accounts</h4>\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='confirm' />\n\t\t\t\t\t\t<input type='hidden' name='dtaccid' value='{$dtaccid}' />\n\t\t\t\t\t\t<input type='hidden' name='ctaccid' value='{$ctaccid}' />\n\t\t\t\t\t\t<input type='hidden' name='dtaccname' value='{$dtacc['accname']}' />\n\t\t\t\t\t\t<input type='hidden' name='ctaccname' value='{$ctacc['accname']}' />\n\t\t\t\t\t\t<input type='hidden' name='date' value='{$date}' />\n\t\t\t\t\t\t<input type='hidden' name='refnum' value='{$refnum}' />\n\t\t\t\t\t\t<input type='hidden' name='amount' value='{$amount}' />\n\t\t\t\t\t\t<input type='hidden' name='details' value='{$details}' />\n\t\t\t\t\t\t<input type='hidden' name='author' value='{$author}' />\n\t\t\t\t\t\t<input type='hidden' name='chrgvat' value='{$chrgvat}' />\n\t\t\t\t\t\t<input type='hidden' name='jr_day' value='{$jr_day}' />\n\t\t\t\t\t\t<input type='hidden' name='jr_month' value='{$jr_month}' />\n\t\t\t\t\t\t<input type='hidden' name='jr_year' value='{$jr_year}' />\n\t\t\t\t\t\t<input type='hidden' name='vat' value='' />\n\t\t\t\t \t<table " . TMPL_tblDflts . " width='500'>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td width='50%'><h3>Debit</h3></td>\n\t\t\t\t\t\t\t<td width='50%'><h3>Credit</h3></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>{$dtacc['topacc']}/{$dtacc['accnum']} - {$dtacc['accname']}</td>\n\t\t\t\t\t\t\t<td>{$ctacc['topacc']}/{$ctacc['accnum']} - {$ctacc['accname']}</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 class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td valign='top'>VAT Deductable Account</td>\n\t\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t\t<input type='radio' name='vatdedacc' value='{$dtaccid}' {$dsel1} />{$dtacc['topacc']}/{$dtacc['accnum']} - {$dtacc['accname']}<br />\n\t\t\t\t\t\t\t\t<input type='radio' name='vatdedacc' value='{$ctaccid}' {$dsel2} />{$ctacc['topacc']}/{$ctacc['accnum']} - {$ctacc['accname']}\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>VAT Account</td>\n\t\t\t\t\t\t\t<td>{$vatacc}</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>VAT Inclusive </td>\n\t\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t\t<input type='radio' size='20' name='vatinc' value='yes' {$vatsel1} />Yes (Amount Includes VAT) \n\t\t\t\t\t\t\t\t<input type='radio' size='20' name='vatinc' value='no' {$vatsel2} />No(Add VAT to Amount)\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>VAT Code</td>\n\t\t\t\t\t\t\t<td>{$Vatcodes}</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><input type='submit' name='back' value='« Correction'></td>\n\t\t\t\t\t\t\t<td align='right'><input type='submit' value='Confirm »'></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</table>\n\t\t\t\t\t</form>" . mkQuickLinks(ql("../reporting/index-reports.php", "Financials"), ql("../core/trans-new.php", "Journal Transactions"));
return $slctacc;
}
function slctVatacc($_POST)
{
// Sanity Checking
# Get vars
foreach ($_POST as $key => $value) {
${$key} = $value;
}
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($ctaccid, "num", 1, 50, "Invalid Account to be Credited.");
$v->isOk($dtaccid, "num", 1, 50, "Invalid Account to be Debited.");
$v->isOk($refnum, "num", 1, 10, "Invalid Reference number.");
$v->isOk($amount, "float", 1, 20, "Invalid Amount.");
$v->isOk($details, "string", 0, 255, "Invalid Details.");
$v->isOk($author, "string", 1, 30, "Invalid Authorising person name.");
$v->isOk($chrgvat, "string", 1, 4, "Invalid charge vat option.");
$datea = explode("-", $date);
if (count($datea) == 3) {
if (!checkdate($datea[1], $datea[0], $datea[2])) {
$v->isOk($date, "num", 1, 1, "Invalid date.");
}
} else {
$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"];
}
$confirm .= "<p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>";
return $confirm;
}
# Account numbers
$dtaccRs = get("core", "*", "accounts", "accid", $dtaccid);
$dtacc = pg_fetch_array($dtaccRs);
$ctaccRs = get("core", "*", "accounts", "accid", $ctaccid);
$ctacc = pg_fetch_array($ctaccRs);
$vatacc = "<select name='vataccid'>";
$sql = "SELECT * FROM accounts WHERE div = '" . USER_DIV . "' ORDER BY accname ASC";
$accRslt = db_exec($sql);
if (pg_numrows($accRslt) < 1) {
return "<li>There are No accounts in Cubit.";
}
while ($acc = pg_fetch_array($accRslt)) {
# Check Disable
if (isDisabled($acc['accid'])) {
continue;
}
$vatacc .= "<option value='{$acc['accid']}'>{$acc['topacc']}/{$acc['accnum']} - {$acc['accname']}</option>";
}
$vatacc .= "</select>";
// Details
$slctacc = "<center><h3>Journal Transaction VAT Details</h3>\n\t<h4>Select VAT Accounts</h4>\n\t<form action='" . SELF . "' method=post name=form>\n\t<input type=hidden name=key value=confirm>\n\t<input type=hidden name='dtaccid' value='{$dtaccid}'>\n\t<input type=hidden name='ctaccid' value='{$ctaccid}'>\n\t<input type=hidden name=dtaccname value='{$dtacc['accname']}'>\n\t<input type=hidden name=ctaccname value='{$ctacc['accname']}'>\n\t<input type=hidden name=date value='{$date}'>\n\t<input type=hidden name=refnum value='{$refnum}'>\n\t<input type=hidden name=amount value='{$amount}'>\n\t<input type=hidden name=details value='{$details}'>\n\t<input type=hidden name=author value='{$author}'>\n\t<input type=hidden name=chrgvat value='{$chrgvat}'>\n \t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "' align=center width=500>\n\t<tr><td width=50%><h3>Debit</h3></td><td width=50%><h3>Credit</h3></td></tr>\n <tr class='bg-odd'><td>{$dtacc['topacc']}/{$dtacc['accnum']} - {$dtacc['accname']}</td><td>{$ctacc['topacc']}/{$ctacc['accnum']} - {$ctacc['accname']}</td></tr>\n\t<tr><td><br></td></tr>\n\t<tr class='bg-even'><td valign=top>VAT Deductable Account</td><td><input type=radio name=vatdedacc value='{$dtaccid}' checked=yes>{$dtacc['topacc']}/{$dtacc['accnum']} - {$dtacc['accname']}<br><input type=radio name=vatdedacc value='{$ctaccid}'>{$ctacc['topacc']}/{$ctacc['accnum']} - {$ctacc['accname']}</td></tr>\n\t<tr class='bg-odd'><td>VAT Account</td><td>{$vatacc}</td></tr>\n\t<tr class='bg-even'><td>VAT Inclusive </td><td><input type=radio size=20 name=vatinc value=yes checked=yes>Yes(Amount Includes VAT) <input type=radio size=20 name=vatinc value=no>No(Add VAT to Amount)</td></tr>\n\t<tr><td><br></td></tr>\n\t<tr><td align=right><input type=button value='« Back' onClick='javascript:history.back()'></td><td align=right><input type=submit value='Continue »'></td></tr>\n\t</table></form>\n\t<p>\n\t<table border=0 cellpadding='2' cellspacing='1' width=15%>\n\t\t<tr><th>Quick Links</th></tr>\n\t\t<tr class='bg-odd'><td align=center><a href='ledger-view.php'>View High Speed Input Ledgers</td></tr>\n\t\t<tr class='bg-odd'><td align=center><a href='../main.php'>Main Menu</td></tr>\n\t</table>";
return $slctacc;
}
$curKat = '';
while ($res = mysql_fetch_assoc($result)) {
if ($res['kategorirekening'] != $curKat) {
$ss = 'SELECT replid,nama,RPAD(kode,6,0)kode from keu_kategorirekening where replid=' . $res['kategorirekening'];
$ee = mysql_query($ss);
$rr = mysql_fetch_assoc($ee);
$out .= '<tr class="bg-lightTeal">
<td align="right"><b>' . $rr['kode'] . '</b></td>
<td colspan="3"><b>' . $rr['nama'] . '</b></td>
</tr>';
}
$btn = '<td align="center">
<button data-hint="ubah" ' . isDisabled($menu, 'u') . ' class="button" onclick="viewFR(' . $res['replid'] . ');">
<i class="icon-pencil on-left"></i>
</button>
<button data-hint="hapus" ' . isDisabled($menu, 'd') . ' class="button" onclick="del(' . $res['replid'] . ');">
<i class="icon-remove on-left"></i>
</button>
</td>';
$out .= '<tr>
<td class="text-right">' . $res['kode'] . '</td>
<td>' . $res['nama'] . '</td>
<td>' . $res['keterangan'] . '</td>
' . $btn . '
</tr>';
$curKat = $res['kategorirekening'];
$nox++;
}
} else {
#kosong
$out .= '<tr align="center">
function confirm($_POST)
{
# Get vars
extract($_POST);
if (isset($back)) {
return number($_POST);
}
$blocked_date_from = getCSetting("BLOCKED_FROM");
$blocked_date_to = getCSetting("BLOCKED_TO");
# validate input
require_lib("validate");
$v = new validate();
foreach ($amount as $key => $value) {
if ($amount[$key] > 0) {
if (isDisabled($ctaccid[$key])) {
return custconfirm($_POST);
}
if (isDisabled($dtaccid[$key])) {
return custconfirm($_POST);
}
$v->isOk($ctaccid[$key], "num", 1, 50, "Invalid Account to be Credited.[{$key}]");
$v->isOk($dtaccid[$key], "num", 1, 50, "Invalid Account to be Debited.[{$key}]");
$v->isOk($refnum[$key], "num", 1, 10, "Invalid Reference number.[{$key}]");
$v->isOk($amount[$key], "float", 1, 20, "Invalid Amount.[{$key}]");
$v->isOk($descript[$key], "string", 0, 255, "Invalid Details.[{$key}]");
$date[$key] = $date_day[$key] . "-" . $date_month[$key] . "-" . $date_year[$key];
if (!checkdate($date_month[$key], $date_day[$key], $date_year[$key])) {
$v->isOk($date[$key], "num", 1, 1, "Invalid date.");
}
// if ($amount[$key] <= 0){
// return slctacc($_POST,"<li class='err'>Invalid Amount To Process.</li>");
// }
if (strtotime($date[$key]) >= strtotime($blocked_date_from) and strtotime($date[$key]) <= strtotime($blocked_date_to) and !user_is_admin(USER_ID)) {
return "<li class='err'>Period Range Is Blocked. Only an administrator can process entries within this period.</li>";
}
}
}
# 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 slctacc($_POST, $confirm);
}
# accnums
foreach ($amount as $key => $value) {
if ($amount[$key] > 0) {
# get account to be debited
$dtaccRs = get("core", "*", "accounts", "accid", $dtaccid[$key]);
if (pg_numrows($dtaccRs) < 1) {
return "<li> Accounts to be debited does not exist.</li>";
}
$dtacc[$key] = pg_fetch_array($dtaccRs);
# get account to be credited
$ctaccRs = get("core", "*", "accounts", "accid", $ctaccid[$key]);
if (pg_numrows($ctaccRs) < 1) {
return "<li> Accounts to be credited does not exist.</li>";
}
$ctacc[$key] = pg_fetch_array($ctaccRs);
}
}
$confirm = "\n\t\t<center>\n\t\t<h3>Multiple Journal transactions</h3>\n\t\t<h4>Confirm entry</h4>\n\t\t<form action='" . SELF . "' method='POST'>\n\t\t\t<input type='hidden' name='key' value='write'>\n\t\t\t<input type='hidden' name='vby' value='{$vby}'>\n\t\t\t<input type='hidden' name='tnum' value='{$tnum}'>\n\t\t<table " . TMPL_tblDflts . " width='700'>\n\t\t\t<tr>\n\t\t\t\t<th>Date</th>\n\t\t\t\t<th>Ref num</th>\n\t\t\t\t<th>Debit</th>\n\t\t\t\t<th>Credit</th>\n\t\t\t\t<th>Amount</th>\n\t\t\t\t<th>Description</th>\n\t\t\t</tr>";
$trans = "";
foreach ($amount as $key => $value) {
if ($amount[$key] > 0) {
$trans .= "\n\t\t\t\t<tr bgcolor=" . bgcolorg() . ">\n\t\t\t\t\t<input type='hidden' name='date_day[]' value='{$date_day[$key]}'>\n\t\t\t\t\t<input type='hidden' name='date_month[]' value='{$date_month[$key]}'>\n\t\t\t\t\t<input type='hidden' name='date_year[]' value='{$date_year[$key]}'>\n\t\t\t\t\t<td><input type='hidden' size='10' name='date[]' value='{$date[$key]}'>{$date[$key]}</td>\n\t\t\t\t\t<td><input type='hidden' size='10' name='refnum[]' value='{$refnum[$key]}'>{$refnum[$key]}</td>\n\t\t\t\t\t<td valign='center'><input type='hidden' name='dtaccid[]' value='" . $dtacc[$key]['accid'] . "'>" . $dtacc[$key]['accname'] . "</td>\n\t\t\t\t\t<td valign='center'><input type='hidden' name='ctaccid[]' value='" . $ctacc[$key]['accid'] . "'>" . $ctacc[$key]['accname'] . "</td>\n\t\t\t\t\t<td><input type='hidden' name='amount[]' value='{$amount[$key]}'>" . CUR . " {$amount[$key]}</td>\n\t\t\t\t\t<td><input type='hidden' name='descript[]' value ='{$descript[$key]}'>{$descript[$key]}</td>\n\t\t\t\t</tr>";
}
}
if (strlen($trans) < 5) {
return slctacc($_POST, "<li class='err'>Please enter full transaction details.</li><br>");
}
$confirm .= "\n\t\t\t{$trans}\n\t\t\t<tr><td><br></td></tr>\n\t\t\t<tr>\n\t\t\t\t<td><input type='submit' name='back' value='« Correction'></td>\n\t\t\t\t<td align='right' colspan='4'><input type='submit' value='Write »'></td>\n\t\t\t</tr>\n\t\t</form>\n\t\t</table>\n\t\t<table border='0' cellpadding='2' cellspacing='1' width='15%'>\n\t\t\t<tr><td><br></td></tr>\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='datacell'>\n\t\t\t\t<td align='center'><a href='../reporting/index-reports.php'>Financials</a></td>\n\t\t\t</tr>\n\t\t\t<tr class='datacell'>\n\t\t\t\t<td align='center'><a href='trans-new.php'>Journal Transactions</td>\n\t\t\t</tr>\n\t\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t\t</table>";
return $confirm;
}
function error($_POST, $err = "")
{
# get vars
extract($_POST);
core_connect();
$sql = "SELECT * FROM accounts WHERE div = '" . USER_DIV . "' ORDER BY accname ASC";
$accRslt = db_exec($sql);
if (pg_numrows($accRslt) < 1) {
return "<li> ERROR : There are no accounts in the category selected.</li>";
}
$accnts = "<select name='accid'>";
while ($acc = pg_fetch_array($accRslt)) {
# Check Disable
if (isDisabled($acc['accid'])) {
continue;
}
$sel = "";
if ($acc['accid'] == $accid) {
$sel = "selected";
}
$accnts .= "<option value='{$acc['accid']}' {$sel}>{$acc['accname']}</option>";
}
$accnts .= "</select>";
# check available funds
$cashacc = gethook("accnum", "bankacc", "name", "Petty Cash");
core_connect();
$sql = "SELECT (debit - credit) as bal FROM trial_bal WHERE accid = '{$cashacc}' AND div = '" . USER_DIV . "'";
$accbRslt = db_exec($sql);
if (pg_numrows($accbRslt) < 1) {
return "<li class='err'> Petty Cash Account not found.</li>";
}
$accb = pg_fetch_array($accbRslt);
$accb['bal'] = sprint($accb['bal']);
# mourn if the is no money
if ($accb['bal'] < 1) {
return "<li> There are no Petty Cash funds available.</li>";
}
# Keep the charge vat option stable
if ($chrgvat == "inc") {
$chin = "checked=yes";
$chex = "";
$chno = "";
} elseif ($chrgvat == "exc") {
$chin = "";
$chex = "checked=yes";
$chno = "";
} else {
$chin = "";
$chex = "";
$chno = "checked=yes";
}
db_conn('cubit');
$Sl = "SELECT * FROM vatcodes ORDER BY code";
$Ri = db_exec($Sl) or errDie("Unable to get vat codes");
$Vatcodes = "<select name='vatcode'>\r\n\t<option value='0'>Select</option>";
while ($vd = pg_fetch_array($Ri)) {
if ($vd['del'] == "Yes" || $vatcode == $vd["id"]) {
$sel = "selected";
} else {
$sel = "";
}
$Vatcodes .= "<option value='{$vd['id']}' {$sel}>{$vd['code']}</option>";
}
$Vatcodes .= "</select>";
// Layout
$add = "\r\n\t\t\t\t<h3>Edit Petty Cash Requisistion</h3>\r\n\t\t\t\t<table " . TMPL_tblDflts . " width='300'>\r\n\t\t\t\t<form action='" . SELF . "' method='POST' name='form'>\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='cashid' value='{$cashid}'>\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>\r\n\t\t\t\t\t\t<th>Field</th>\r\n\t\t\t\t\t\t<th>Value</th>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t<td>Date</td>\r\n\t\t\t\t\t\t<td>" . mkDateSelect("date", $date_year, $date_month, $date_day) . "</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t<td>Paid to</td>\r\n\t\t\t\t\t\t<td valign='center'><input size='20' name='name' value='{$name}'></td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t<td>Details</td>\r\n\t\t\t\t\t\t<td valign='center'><textarea cols='18' rows='2' name='det'>{$det}</textarea></td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t<td>Available Funds</td>\r\n\t\t\t\t\t\t<td><input type='hidden' name='bal' value='{$accb['bal']}'>" . CUR . " {$accb['bal']}</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t<td>Amount</td>\r\n\t\t\t\t\t\t<td valign='center'>" . CUR . " <input type='text' size='10' name='amount' value='{$amount}'></td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t<td>VAT Inclusive</td>\r\n\t\t\t\t\t\t<td valign='center'>\r\n\t\t\t\t\t\t\tYes <input type='radio' size='7' name='chrgvat' value='inc' {$chin}>\r\n\t\t\t\t\t\t\tNo <input type='radio' size='7' name='chrgvat' value='exc' {$chex}>\r\n\t\t\t\t\t\t\tNo VAT <input type='radio' size='7' name='chrgvat' value='nov' {$chno}>\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t<td>VAT Code</td>\r\n\t\t\t\t\t\t<td>{$Vatcodes}</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t<td>Account Paid to</td>\r\n\t\t\t\t\t\t<td>{$accnts}</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td><br></td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td></td>\r\n\t\t\t\t\t\t<td valign='center' colspan='2' align='right'><input type='submit' value='Confirm »'></td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t</table>\r\n\t\t\t\t<p>\r\n\t\t\t\t<table " . TMPL_tblDflts . " width='15%'>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<th>Quick Links</th>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t<td><a href='pettycashbook-view.php'>View Petty Cash Requisitions</a></td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t<td><a href='../main.php'>Main Menu</a></td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t</table>";
return $add;
}
function confirm_actions($_POST)
{
extract($_POST);
if (!isset($bankid)) {
return enter_actions($_POST);
}
if (!isset($next)) {
return enter_actions($_POST);
}
$bankid += 0;
db_conn('cubit');
$Sl = "SELECT * FROM bankacct WHERE bankid='{$bankid}'";
$Ri = db_exec($Sl) or errDie("unable to get data.");
if (pg_num_rows($Ri) < 1) {
return enter_actions($_POST);
}
$bd = pg_fetch_array($Ri);
/*
db_conn('core');
$Sl="SELECT accid FROM accounts WHERE accname='Bank Charges' AND div = '".USER_DIV."' AND acctype='E'";
$Rl=db_exec($Sl) or errDie("Unable to get account data.");
if(pg_numrows($Rl) > 0){
$ad=pg_fetch_array($Rl);
$bc=$ad['accid'];
} else {
$bc=0;
}
$Sl="SELECT accid FROM accounts WHERE accname='Interest Paid' AND div = '".USER_DIV."' AND acctype='E'";
$Rl=db_exec($Sl) or errDie("Unable to get account data.");
if(pg_numrows($Rl) > 0){
$ad=pg_fetch_array($Rl);
$ip=$ad['accid'];
} else {
$ip=0;
}
$Sl="SELECT accid FROM accounts WHERE accname='Travel Expenses' AND div = '".USER_DIV."' AND acctype='E'";
$Rl=db_exec($Sl) or errDie("Unable to get account data.");
if(pg_numrows($Rl) > 0){
$ad=pg_fetch_array($Rl);
$te=$ad['accid'];
} else {
$te=0;
}
*/
$i = 0;
db_conn('cubit');
$Sl = "SELECT * FROM statement_settings";
$Ri = db_exec($Sl) or errDie("Unable to get settings.");
$sd = pg_fetch_array($Ri);
if ($sd['ad'] == "num") {
$num = true;
$ord = "ORDER BY topacc,accnum";
} else {
$num = false;
$ord = "ORDER BY accname";
}
$Sl = "SELECT * FROM statement_data WHERE account='{$bankid}' ORDER BY date";
$Ri = db_exec($Sl) or errDie("unable to get data.");
$out = "\n\t\t<h3>Please select the action you want to take.({$bd['bankname']} - {$bd['accname']})</h3>\n\t\t<li class='err'>Please note: Payments are in red.</li>\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_actions2'>\n\t\t\t<input type='hidden' name='bankid' value='{$bankid}'>\n\t\t\t<tr>\n\t\t\t\t<th>Date</th>\n\t\t\t\t<th>Amount</th>\n\t\t\t\t<th>Description</th>\n\t\t\t\t<th>From/To</th>\n\t\t\t\t<th>VAT Inc</th>\n\t\t\t\t<th>Vat Code</th>\n\t\t\t\t<th>Contra Account/Action</th>\n\t\t\t\t<th>Cheque</th>\n\t\t\t</tr>";
while ($data = pg_fetch_array($Ri)) {
$vatcode_drop = "<input type='hidden' name='vatcode[]' value=''>";
extract($data);
$vch = "";
if ($amount > 0) {
$trantype = "deposit";
} else {
$trantype = "withdrawal";
}
$pamount = sprint(abs($amount));
$cheqnum = $contra;
$cheqnum += 0;
$action = $actions[$id];
if ($action == "0") {
return enter_actions($_POST, "<li class='err'>Please Select An Option For All Accounts</li>");
}
if ($action == "c" || $action == "cr") {
if ($bank == "Standard Bank" && ($ex2 == "##" || $description == "OVERDRAFT LEDGER FEE")) {
$vch = "checked";
}
db_conn('core');
$Accounts = "\n\t\t\t\t<select name='accounts[{$id}]'>\n\t\t\t\t\t<option value='0'>Select Account</option>";
$Sl = "SELECT * FROM accounts WHERE div = '" . USER_DIV . "' {$ord}";
$Rl = db_exec($Sl) or errDie("Unable to get account data.");
if (pg_numrows($Rl) < 1) {
return "<li>There are No accounts in Cubit.</li>";
}
$hook = isrefa($description, $contra);
if ($hook == 0) {
$hook = isaref($pamount, $description, $contra, $trantype);
}
if (isset($accounts[$id])) {
$hook = $accounts[$id];
}
while ($acc = pg_fetch_array($Rl)) {
if (isDisabled($acc['accid'])) {
continue;
}
if ($acc['accid'] == $hook) {
$sel = "selected";
} else {
$sel = "";
}
if ($num) {
$acc['accname'] = $acc['topacc'] . "/" . $acc['accnum'];
}
$Accounts .= "<option value='{$acc['accid']}' {$sel}>{$acc['accname']}</option>";
}
$Accounts .= "</select>";
$details = $Accounts;
#make vat code drop
$vatcode_drop = "<select name='vatcode[{$id}]'>";
$get_vats = "SELECT * FROM vatcodes ORDER BY code";
$run_vats = db_exec($get_vats) or errDie("Unable to get vat code information.");
if (pg_numrows($run_vats) < 1) {
$vatcode_drop .= "<option value='01'>Select Vatcode</option>";
} else {
while ($varr = pg_fetch_array($run_vats)) {
$vatcode_drop .= "<option value='{$varr['id']}'>{$varr['code']}</option>";
}
}
$vatcode_drop .= "</select>";
} elseif ($action == "r") {
db_conn('cubit');
$Sl = "SELECT * FROM cashbook WHERE trantype='{$trantype}' AND amount='{$pamount}' AND banked='no' AND bankid='{$bankid}' AND rid!=333";
$Rl = db_exec($Sl) or errDie("Unable to get cashbook data.");
if (pg_num_rows($Rl) > 0) {
$car = "<select name='recon[{$id}]'>";
if (pg_num_rows($Rl) > 1) {
$car .= "<option value='0'>Select Entry</option>";
}
while ($cd = pg_fetch_array($Rl)) {
$car .= "<option value='{$cd['cashid']}'>Entry on {$cd['date']}, {$cd['descript']}</option>";
}
$car .= "</select>";
$details = "{$car}";
} else {
$details = "";
}
} elseif ($action == "d") {
$details = "Delete";
} elseif ($action == "i") {
$details = "Ignore";
} elseif ($action == "cp") {
db_conn('cubit');
$Sl = "SELECT cusnum,surname FROM customers WHERE div='" . USER_DIV . "' AND location='loc' ORDER BY surname";
$Rl = db_exec($Sl) or errDie("Unable to get customers.");
$details = "\n\t\t\t\t<select name='customers[{$id}]'>\n\t\t\t\t\t<option value='0'>Select Customer</option>";
$clientid = isrefcp($description, $contra);
while ($cd = pg_fetch_array($Rl)) {
$sel = "";
if ($clientid == 0) {
$find = strpos(strtolower($description), strtolower($cd['surname']));
if (!($find === false)) {
$sel = "selected";
}
$find = strpos(strtolower($contra), strtolower($cd['surname']));
if (!($find === false)) {
$sel = "selected";
}
} else {
if ($cd['cusnum'] == $clientid) {
$sel = "selected";
}
}
if (isset($customers[$id]) && $customers[$id] == $cd['cusnum']) {
$sel = "selected";
}
$details .= "<option value='{$cd['cusnum']}' {$sel}>{$cd['surname']}</option>";
}
$details .= "</select>";
} elseif ($action == "sp") {
db_conn('cubit');
$Sl = "SELECT supid,supname FROM suppliers WHERE div='" . USER_DIV . "' AND location='loc' ORDER BY supname";
$Rl = db_exec($Sl) or errDie("Unable to get customers.");
$details = "\n\t\t\t\t<select name='suppliers[{$id}]'>\n\t\t\t\t\t<option value='0'>Select Supplier</option>";
$supid = isrefsp($description, $contra);
while ($cd = pg_fetch_array($Rl)) {
$sel = "";
if ($supid == 0) {
$find = strpos(strtolower($description), strtolower($cd['supname']));
if (!($find === false)) {
$sel = "selected";
}
$find = strpos(strtolower($contra), strtolower($cd['supname']));
if (!($find === false)) {
$sel = "selected";
}
} else {
if ($cd['supid'] == $supid) {
$sel = "selected";
}
}
if (isset($suppliers[$id]) && $suppliers[$id] == $cd['supid']) {
$sel = "selected";
}
$details .= "<option value='{$cd['supid']}' {$sel}>{$cd['supname']}</option>";
}
$details .= "</select>";
}
if (!isset($day[$id])) {
$dates = explode("-", $date);
} else {
$dates[2] = $day[$id];
$dates[1] = $mon[$id];
$dates[0] = $year[$id];
}
if ($amount < 0) {
$e1 = "<li class='err'></li>";
} else {
$e1 = "<li></li>";
}
if (isset($descriptions[$id])) {
$description = $descriptions[$id];
if (isset($vats[$id]) && $vats[$id] != "No") {
$vch = "checked";
} else {
$vch = "";
}
}
if (isset($contras[$id])) {
$contra = $contras[$id];
}
if ($action == "d" || $action == "i") {
$out .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>\n\t\t\t\t\t\t<table border='0' cellpadding='0' cellspacing='0'>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<input type='hidden' name='actions[{$id}]' value='{$action}'>\n\t\t\t\t\t\t\t\t<td>{$dates['2']}</td>\n\t\t\t\t\t\t\t\t<td>-</td>\n\t\t\t\t\t\t\t\t<td>{$dates['1']}</td>\n\t\t\t\t\t\t\t\t<td>-</td>\n\t\t\t\t\t\t\t\t<td>{$dates['0']}</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t</table>\n\t\t\t\t\t</td>\n\t\t\t\t\t<td>\n\t\t\t\t\t\t<table>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>{$e1}</td>\n\t\t\t\t\t\t\t\t<td>{$pamount}</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t</table>\n\t\t\t\t\t</td>\n\t\t\t\t\t<td>{$description}</td>\n\t\t\t\t\t<td>{$contra}</td>\n\t\t\t\t\t<td></td>\n\t\t\t\t\t<td>{$details}</td>\n\t\t\t\t\t<td></td>\n\t\t\t\t</tr>";
} else {
$out .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>\n\t\t\t\t\t\t<table border='0' cellpadding='0' cellspacing='0'>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<input type='hidden' name='actions[{$id}]' value='{$action}'>\n\t\t\t\t\t\t\t\t<td><input type='text' size='2' name='day[{$id}]' value='{$dates['2']}'></td>\n\t\t\t\t\t\t\t\t<td>-</td>\n\t\t\t\t\t\t\t\t<td><input type='text' size='2' name='mon[{$id}]' value='{$dates['1']}'></td>\n\t\t\t\t\t\t\t\t<td>-</td>\n\t\t\t\t\t\t\t\t<td><input type='text' size='4' name='year[{$id}]' value='{$dates['0']}'></td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t</table>\n\t\t\t\t\t</td>\n\t\t\t\t\t<td>\n\t\t\t\t\t\t<table>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>{$e1}</td>\n\t\t\t\t\t\t\t\t<td><input type='hidden' size='8' name='amounts[{$id}]' value='{$pamount}'>{$pamount}</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t</table>\n\t\t\t\t\t</td>\n\t\t\t\t\t<td><input type='text' size='30' name='descriptions[{$id}]' value='{$description}'></td>\n\t\t\t\t\t<td><input type='text' size='30' name='contras[{$id}]' value='{$contra}'></td>\n\t\t\t\t\t<td><input type='checkbox' name='vats[{$id}]' {$vch}></td>\n\t\t\t\t\t<td>{$vatcode_drop}</td>\n\t\t\t\t\t<td>{$details}</td>\n\t\t\t\t\t<td><input type='text' size='5' name='cheque[{$id}]' value=''></td>\n\t\t\t\t</tr>";
}
$i++;
}
$out .= "\n\t\t\t<tr><td><br></td></tr>\n\t\t\t<tr>\n\t\t\t\t<td><input type='submit' name='back' value='« Correction'></td>\n\t\t\t\t<td colspan='4' align='right'><input type='submit' name='next' value='Confirm »'></td>\n\t\t\t</tr>\n\t\t</form>\n\t\t</table>";
return $out;
}
function slctVatAcc($_POST)
{
# Get vars
extract($_POST);
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($ctaccid, "num", 1, 50, "Invalid Account to be Credited.");
$v->isOk($dtaccid, "num", 1, 50, "Invalid Account to be Debited.");
$v->isOk($refnum, "num", 1, 10, "Invalid Reference number.");
$v->isOk($amount, "float", 1, 20, "Invalid Amount.");
$v->isOk($details, "string", 0, 255, "Invalid Details.");
$v->isOk($author, "string", 1, 30, "Invalid Authorising person name.");
$datea = explode("-", $date);
if (count($datea) == 3) {
if (!checkdate($datea[1], $datea[0], $datea[2])) {
$v->isOk($date, "num", 1, 1, "Invalid date.");
}
} else {
$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>";
}
return details($_POST, $confirm);
}
# account numbers
$dtaccRs = get("core", "*", "accounts", "accid", $dtaccid);
$dtacc = pg_fetch_array($dtaccRs);
$ctaccRs = get("core", "*", "accounts", "accid", $ctaccid);
$ctacc = pg_fetch_array($ctaccRs);
db_conn('core');
$vatacc = "<select name='vataccid'>";
$sql = "SELECT * FROM accounts WHERE div = '" . USER_DIV . "' ORDER BY accname ASC";
$accRslt = db_exec($sql);
if (pg_numrows($accRslt) < 1) {
return "<li>There are No accounts in Cubit.</li>";
}
while ($acc = pg_fetch_array($accRslt)) {
# Check Disable
if (isDisabled($acc['accid'])) {
continue;
}
$vatacc .= "<option value='{$acc['accid']}'>{$acc['topacc']}/{$acc['accnum']} - {$acc['accname']}</option>";
}
$vatacc .= "</select>";
db_conn('cubit');
if (!isset($vatcode)) {
$Sl = "SELECT * FROM vatcodes WHERE del='Yes'";
$Ri = db_exec($Sl) or errDie("Unable to get data.");
$vd = pg_fetch_array($Ri);
$vatcode = $vd['id'];
}
if (!isset($vatcode)) {
$vatcode = 0;
}
$Sl = "SELECT * FROM vatcodes ORDER BY code";
$Ri = db_exec($Sl) or errDie("Unable to get vat codes");
$Vatcodes = "<select name='vatcode'>";
while ($vd = pg_fetch_array($Ri)) {
if ($vd['id'] == $vatcode) {
$sel = "selected";
} else {
$sel = "";
}
$Vatcodes .= "<option value='{$vd['id']}' {$sel}>{$vd['code']}</option>";
}
$Vatcodes .= "</select>";
// Details
$slctacc = "\n\t\t<center>\n\t\t<h3> Record Recurring Transaction </h3>\n\t\t<h2>Select VAT Accounts</h2>\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='dtaccid' value='{$dtaccid}'>\n\t\t\t<input type='hidden' name='ctaccid' value='{$ctaccid}'>\n\t\t\t<input type='hidden' name='date' value='{$date}'>\n\t\t\t<input type='hidden' name='refnum' value='{$refnum}'>\n\t\t\t<input type='hidden' name='amount' value='{$amount}'>\n\t\t\t<input type='hidden' name='chrgvat' value='{$chrgvat}'>\n\t\t\t<input type='hidden' name='details' value='{$details}'>\n\t\t\t<input type='hidden' name='author' value='{$author}'>\n\t\t<table " . TMPL_tblDflts . " align='center'>\n\t\t\t<tr>\n\t\t\t\t<th>Option</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 valign='top'>VAT Deductable Account</td>\n\t\t\t\t<td><input type='radio' name='vatdedacc' value='{$dtaccid}' checked='yes'>{$dtacc['topacc']}/{$dtacc['accnum']} - {$dtacc['accname']}<br><input type='radio' name='vatdedacc' value='{$ctaccid}'>{$ctacc['topacc']}/{$ctacc['accnum']} - {$ctacc['accname']}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>VAT Account</td>\n\t\t\t\t<td>{$vatacc}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>VAT Inclusive </td>\n\t\t\t\t<td><input type='radio' size='20' name='vatinc' value='yes' checked='yes'>Yes(Amount Includes VAT) <input type='radio' size='20' name='vatinc' value='no'>No(Add VAT to Amount)</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>VAT Code</td>\n\t\t\t\t<td>{$Vatcodes}</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 align='right'><input type='button' value='« Back' onClick='javascript:history.back()'></td>\n\t\t\t\t<td align='right'><input type='submit' value='Continue »'></td>\n\t\t\t</tr>\n\t\t</table>\n\t\t</form>\n\t\t<p>\n\t\t<table border=0 cellpadding='2' cellspacing='1' width=15%>\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 align='center'><a href='../reporting/index-reports.php'>Financials</a></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td align='center'><a href='ledger-view.php'>View High Speed Input Ledgers</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td align='center'><a href='../main.php'>Main Menu</td>\n\t\t\t</tr>\n\t\t</table>";
return $slctacc;
}
function add($_GET)
{
//global $_GET;
# Get vars
extract($_GET);
if (!isset($id) or strlen($id) < 1) {
return "Invalid use of module";
}
$id += 0;
db_connect();
#get the amount and number of entries
$get_info = "SELECT * FROM batch_cashbook WHERE cashid = '{$id}' LIMIT 1";
$run_info = db_exec($get_info) or errDie("Unable to get batch information");
if (pg_numrows($run_info) < 1) {
return "Invalid use of module";
}
$arr = pg_fetch_array($run_info);
$amount = $arr['amount'];
#get amount of accounts ..
$accs = explode("|", $arr['amounts']);
$newaccs = array();
foreach ($accs as $temp) {
if (strlen($temp) > 0) {
$newaccs[] = $temp;
}
}
$lnum = sizeof($newaccs);
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($lnum, "num", 1, 30, "Invalid Number of ledger accounts.");
$v->isOk($amount, "float", 1, 10, "Invalid amount.");
# 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($arr['bankid']) or strlen($arr['bankid']) < 1) {
$bankid = 0;
} else {
$bankid = $arr['bankid'];
}
db_connect();
# bank accounts to choose from
$sql = "SELECT * FROM bankacct WHERE btype != 'int' AND div = '" . USER_DIV . "' ORDER BY bankname,branchname";
$bankRs = db_exec($sql);
if (pg_numrows($bankRs) < 1) {
return "<li class='err'> There are no accounts held at the selected Bank.\n\t\t<p><input type='button onClick='JavaScript:history.back();' value='« Correct Selection'>";
}
$banks = "<select name=bankid>";
while ($bank = pg_fetch_array($bankRs)) {
if ($bank['bankid'] == $bankid) {
$sel = "selected";
} else {
$sel = "";
}
$banks .= "<option value={$bank['bankid']} {$sel}>{$bank['accname']} - {$bank['bankname']} ({$bank['acctype']})</option>";
}
$banks .= "</select>";
############################[ Set Some Vars ]###########################
if (strlen($arr['date']) < 1) {
$date = date("Y-m-d");
} else {
$date = $arr['date'];
}
$db_date = $date;
$date_arr = explode("-", $db_date);
$date_year = $date_arr[0];
$date_month = $date_arr[1];
$date_day = $date_arr[2];
if (!isset($arr['name']) or strlen($arr['name']) < 1) {
$name = "";
} else {
$name = $arr['name'];
}
if (!isset($arr['descript']) or strlen($arr['descript']) < 1) {
$descript = "";
} else {
$descript = $arr['descript'];
}
if (!isset($arr['cheqnum']) or strlen($arr['cheqnum']) < 1) {
$cheqnum = "";
} else {
$cheqnum = $arr['cheqnum'];
}
if (!isset($arr['reference']) or strlen($arr['reference']) < 1) {
$reference = "";
} else {
$reference = $arr['reference'];
}
#########################################################################
######################[ Clear Vars ]########################
$accs_arr = explode("|", $arr['accids']);
$new_accs_arr = array();
foreach ($accs_arr as $temp) {
if (strlen($temp) > 0) {
$new_accs_arr[] = $temp;
}
}
$amounts_arr = explode("|", $arr['amounts']);
$new_amounts_arr = array();
foreach ($amounts_arr as $temp) {
if (strlen($temp) > 0) {
$new_amounts_arr[] = $temp;
}
}
$vatcodes_arr = explode("|", $arr['vatcodes']);
$new_vatcodes_arr = array();
foreach ($vatcodes_arr as $temp) {
if (strlen($temp) > 0) {
$new_vatcodes_arr[] = $temp;
}
}
$chrgvats_arr = explode("|", $arr['chrgvats']);
$new_chrgvats_arr = array();
foreach ($chrgvats_arr as $temp) {
if (strlen($temp) > 0) {
$new_chrgvats_arr[] = $temp;
}
}
###########################################################
# compose accounts list
$accounts = "";
for ($i = 0; $i < $lnum; $i++) {
switch ($new_chrgvats_arr[$i]) {
case "nov":
$chexc = "";
$chinc = "";
$chnov = "checked=yes";
break;
case "inc":
$chexc = "";
$chinc = "checked=yes";
$chnov = "";
break;
case "exc":
$chexc = "checked=yes";
$chinc = "";
$chnov = "";
break;
default:
$chexc = "";
$chinc = "";
$chnov = "checked=yes";
break;
}
# Accounts Drop down selections
core_connect();
$sql = "SELECT * FROM accounts WHERE div = '" . USER_DIV . "' ORDER BY accname ASC";
$accRslt = db_exec($sql);
if (pg_numrows($accRslt) < 1) {
$glacc = "<li>There are no Income accounts yet in Cubit.";
}
$glacc = "<select name='accinv[]' style='width: 167'>";
while ($acc = pg_fetch_array($accRslt)) {
# Check Disable
if (isDisabled($acc['accid'])) {
continue;
}
$sel = $acc['accid'] == $new_accs_arr[$i] ? "selected" : "";
$glacc .= "<option value='{$acc['accid']}' {$sel}>{$acc['accname']}</option>";
}
$glacc .= "</select>";
db_conn('cubit');
$Sl = "SELECT * FROM vatcodes ORDER BY code";
$Ri = db_exec($Sl) or errDie("cant get vat data.");
$vats = "<select name=vatcode[]>\n\t\t\t<option value='0'>Select VAT Code</option>";
// var_dump($new_vat_arr);
while ($vd = pg_fetch_array($Ri)) {
if ($vd['id'] == $new_vatcodes_arr[$i]) {
$sel = "selected";
} else {
$sel = "";
}
$vats .= "<option value='{$vd['id']}' {$sel}>{$vd['code']}</option>";
}
$vats .= "</select>";
$new_amounts_arr[$i] = sprint($new_amounts_arr[$i]);
$accounts .= "\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>{$glacc}</td>\n\t\t\t\t\t\t<td align='center'>" . CUR . " <input type='text' size='8' name='accamt[]' value='{$new_amounts_arr[$i]}'></td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type='radio' name='chrgvat[{$i}]' value='inc' {$chinc}>Inclusive \n\t\t\t\t\t\t\t<input type='radio' name='chrgvat[{$i}]' value='exc' {$chexc}>Exclusive \n\t\t\t\t\t\t\t<input type='radio' name='chrgvat[{$i}]' value='nov' {$chnov}>No VAT\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td>{$vats}</td>\n\t\t\t\t\t</tr>";
}
if (!isset($errata)) {
$errata = "";
}
// $amount = sprint ($amount);
// Layout
$add = "\n\t\t\t<h3>New Bank Payment</h3>\n\t\t\t{$errata}\n\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<form action='" . SELF . "' method='POST' name='form'>\n\t\t\t\t<input type='hidden' name='key' value='confirm'>\n\t\t\t\t<input type='hidden' name='id' value='{$id}'>\n\t\t\t\t<input type='hidden' name='lnum' value='{$lnum}'>\n\t\t\t\t<input type='hidden' name='amount' value='{$amount}'>\n\t\t\t\t<tr>\n\t\t\t\t\t<td colspan='2'></td>\n\t\t\t\t</tr>\n\t\t\t\t<tr>\n\t\t\t\t\t<th>Field</th>\n\t\t\t\t\t<th>Value</th>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Bank Account</td>\n\t\t\t\t\t<td>{$banks}</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Date</td>\n\t\t\t\t\t<td>" . mkDateSelect("date", $date_year, $date_month, $date_day) . "</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Paid to</td>\n\t\t\t\t\t<td valign='center'><input size='20' name='name' value='{$name}'></td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Description</td>\n\t\t\t\t\t<td valign='center'><textarea col='20' rows='5' name='descript'>{$descript}</textarea></td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Reference</td>\n\t\t\t\t\t<td valign='center'><input size='25' name='reference' value='{$reference}'></td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Cheque Number</td>\n\t\t\t\t\t<td valign='center'><input size='20' name='cheqnum' value='{$cheqnum}'></td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Amount</td>\n\t\t\t\t\t<td valign='center'>" . CUR . " {$amount}</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr><td><br></td></tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td colspan='2'>Select Accounts Involved</td>\n\t\t\t\t<tr>\n\t\t\t\t<tr>\n\t\t\t\t\t<th>Account</th>\n\t\t\t\t\t<th>Amount</th>\n\t\t\t\t\t<th>VAT</th>\n\t\t\t\t\t<th>VAT Code</th>\n\t\t\t\t</tr>\n\t\t\t\t{$accounts}\n\t\t\t\t<tr><td><br></td></tr>\n\t\t\t\t<tr>\n\t\t\t\t\t<td><input type='submit' name='back' value='« Correction'></td>\n\t\t\t\t\t<td valign='center' align='right'><input type='submit' value='Confirm »'></td>\n\t\t\t\t</tr>\n\t\t\t</table>\n\t\t\t<p>\n\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t<tr>\n\t\t\t\t\t<th>Quick Links</th>\n\t\t\t\t</tr>\n\t\t\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t\t\t</table>";
return $add;
}
function slctacc($_GET)
{
extract($_GET);
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($cusnum, "num", 1, 50, "Invalid customer id.");
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class='err'>-" . $e["msg"] . "</li>";
}
return $confirm;
}
$refnum = getrefnum();
/*refnum*/
# Select customer
db_connect();
$sql = "SELECT * FROM customers WHERE cusnum = '{$cusnum}' AND div = '" . USER_DIV . "'";
$custRslt = db_exec($sql) or errDie("Unable to access databse.", SELF);
if (pg_numrows($custRslt) < 1) {
return "<li class='err'>Invalid customer ID, or customer has been blocked.</li>";
} else {
$cust = pg_fetch_array($custRslt);
}
# Accounts drop down
core_connect();
$accounts = "<select name='accid'>";
$sql = "SELECT * FROM accounts WHERE div = '" . USER_DIV . "' ORDER BY accname ASC";
$accRslt = db_exec($sql);
if (pg_numrows($accRslt) < 1) {
return "<li>There are No accounts in Cubit.</li>";
}
while ($acc = pg_fetch_array($accRslt)) {
$sel = "";
if (isset($cacc)) {
if ($cacc == $acc['accid']) {
$sel = "selected";
}
}
# Check Disable
if (isDisabled($acc['accid'])) {
continue;
}
$accounts .= "<option value='{$acc['accid']}' {$sel}>{$acc['accname']}</option>";
}
$accounts .= "</select>";
$entd = "";
$entc = "checked=yes";
if (isset($tran)) {
if ($tran == "dt") {
$entd = "checked=yes";
$entc = "";
}
}
// Accounts (debit)
$view = "\n\t\t\t\t<h3> Journal transaction </h3>\n\t\t\t\t<form action='" . SELF . "' method='POST' name='form'>\n\t\t\t\t\t<input type='hidden' name='key' value='details'>\n\t\t\t\t\t<input type='hidden' name='cusnum' value='{$cusnum}'>\n\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<th>Field</th>\n\t\t\t\t\t\t<th>Value</th>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Account Number</td>\n\t\t\t\t\t\t<td>{$cust['accno']}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Customer</td>\n\t\t\t\t\t\t<td>{$cust['cusname']} {$cust['surname']}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Date</td>\n\t\t\t\t\t\t<td>" . mkDateSelect("ct") . "</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Reference Number</td>\n\t\t\t\t\t\t<td><input type='text' size='10' name='refnum' value='" . $refnum++ . "'></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Entry Type</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<li class='err'>This will debit/credit the customer account selected</li>\n\t\t\t\t\t\t\t<input type='radio' name='entry' value='DT' {$entd}> Debit | <input type='radio' name='entry' value='CT' {$entc}>Credit\n\t\t\t\t\t\t</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td rowspan='2'>Contra Account</td>\n\t\t\t\t\t\t<td>{$accounts} <input name='details' type='submit' value='Enter Details'></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<!-- Rowspan -->\n\t\t\t\t\t\t<td><input type='text' name='accnum' size='20'> <input type='submit' value='Enter Details'></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td colspan='2' class='err'>This journal entry does not take VAT into consideration.<br />\n\t\t\t\t\t\t\tVAT will have to be Journalised as an additionally entry.</td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table>" . mkQuickLinks(ql("../core/trans-new.php", "Journal Transactions"), ql("../customers-view.php", "View Customers"));
return $view;
}
function edit($_GET)
{
# Get vars
extract($_GET);
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($stkid, "num", 1, 50, "Invalid stock id.");
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class='err'>-" . $e["msg"] . "</li>";
}
return $confirm;
}
# Select Stock
db_connect();
$sql = "SELECT * FROM stock WHERE stkid = '{$stkid}' AND div = '" . USER_DIV . "'";
$stkRslt = db_exec($sql) or errDie("Unable to access databse.", SELF);
if (pg_numrows($stkRslt) < 1) {
return "<li> Invalid Stock ID.</li>";
} else {
$stk = pg_fetch_array($stkRslt);
}
if (!isset($unitnum)) {
# Get stock vars
extract($stk);
$unitnum = 1;
$cost = 1;
$det = "";
} else {
$entry = $tipo;
}
# Get warehouse name
db_conn("exten");
$sql = "SELECT whname FROM warehouses WHERE whid = '{$whid}' AND div = '" . USER_DIV . "'";
$whRslt = db_exec($sql);
$wh = pg_fetch_array($whRslt);
# connect to db
core_connect();
$caccdrop = "<select name='cacc'>";
$sql = "SELECT * FROM accounts WHERE div = '" . USER_DIV . "' ORDER BY accname ASC";
$accRslt = db_exec($sql);
if (pg_numrows($accRslt) < 1) {
return "<li class='err'>There are no Balance accounts yet in Cubit.</li>";
} else {
while ($acc = pg_fetch_array($accRslt)) {
# Check Disable
if (isDisabled($acc['accid'])) {
continue;
}
$sel = "";
if (isset($cacc) && $cacc == $acc['accid']) {
$sel = "selected";
}
$caccdrop .= "<option value='{$acc['accid']}' {$sel}>{$acc['accname']}</option>";
}
}
$caccdrop .= "</select>";
$tinc = "";
$tdec = "checked=yes";
if (isset($entry) && ($entry == "inc" || $entry == "Increase")) {
$tinc = "checked=yes";
$tdec = "";
}
if (!isset($date_day)) {
$date_day = date("d");
}
if (!isset($date_month)) {
$date_month = date("m");
}
if (!isset($date_year)) {
$date_year = date("Y");
}
// Layout
$edit = "\n\t\t\t<h3>Stock Balance Transaction</h3>\n\t\t\t<form action='" . SELF . "' method='POST'>\n\t\t\t\t<input type='hidden' name='key' value='confirm'>\n\t\t\t\t<input type='hidden' name='stkid' value='{$stkid}'>\n\t\t\t\t<input type='hidden' name='whid' value='{$whid}'>\n\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t<tr>\n\t\t\t\t\t<th>Field</th>\n\t\t\t\t\t<th>Value</th>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Store</td>\n\t\t\t\t\t<td>{$wh['whname']}</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Stock code</td>\n\t\t\t\t\t<td>{$stk['stkcod']}</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Stock description</td>\n\t\t\t\t\t<td>" . nl2br($stk['stkdes']) . "</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Type</td>\n\t\t\t\t\t<td valign='center'><input type='radio' name='tipo' value='Increase' {$tinc}>Increase Stock | <input type='radio' name='tipo' value='Decrease' {$tdec}>Decrease Stock</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Date</td>\n\t\t\t\t\t<td>" . mkDateSelect("date", $date_year, $date_month, $date_day) . "</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Number of Units</td>\n\t\t\t\t\t<td><input type='text' size='5' name='unitnum' value='{$unitnum}'></td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td valign='top'>Details</td>\n\t\t\t\t\t<td><textarea name='det' rows='3' cols='18'>{$det}</textarea></td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Cost Amount per Unit (Stock Increase Only)</td>\n\t\t\t\t\t<td>" . CUR . " <input type='text' size='10' name='cost' value='{$cost}'></td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>Contra Account</td>\n\t\t\t\t\t<td>{$caccdrop}</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr><td><br></td></tr>\n\t\t\t\t<tr>\n\t\t\t\t\t<td></td>\n\t\t\t\t\t<td align='right'><input type='submit' value='Confirm »'></td>\n\t\t\t\t</tr>\n\t\t\t</form>\n\t\t\t</table>" . mkQuickLinks(ql("stock-add.php", "Add Stock"), ql("stock-view.php", "View Stock"));
return $edit;
}
function add()
{
extract($_REQUEST);
$id += 0;
$Sl = "SELECT * FROM cubit.batch_cashbook WHERE cashid='{$id}'";
$Ri = db_exec($Sl);
if (pg_num_rows($Ri) < 1) {
return "Invalid";
}
$bcb = pg_fetch_array($Ri);
if ($bcb["chrgvat"] == "exc") {
$bcb["amount"] -= $bcb["vat"];
}
extract($bcb, EXTR_SKIP);
# Accounts Drop down selections
core_connect();
# Income accounts ($inc)
$glacc = "<select name='accinv'>";
$sql = "SELECT * FROM accounts WHERE div = '" . USER_DIV . "' ORDER BY accname ASC";
$accRslt = db_exec($sql);
$numrows = pg_numrows($accRslt);
if (empty($numrows)) {
$glacc = "<li class='err'>There are no Income accounts yet in Cubit.</li>";
}
$account = $accinv;
while ($acc = pg_fetch_array($accRslt)) {
# Check Disable
if (isDisabled($acc['accid'])) {
continue;
}
if (isset($account) && $account == $acc['accid']) {
$sel = "selected";
} else {
$sel = "";
}
$glacc .= "<option value='{$acc['accid']}' {$sel}>{$acc['accname']}</option>";
}
$glacc .= "</select>";
db_connect();
$sql = "SELECT * FROM bankacct WHERE btype != 'int' AND div = '" . USER_DIV . "'";
$banks = db_exec($sql);
if (pg_numrows($banks) < 1) {
return "<li class='err'> There are no accounts held at the selected Bank.</li>\n\t\t<p><input type='button' onClick='JavaScript:history.back();' value='« Correct Selection'>";
}
$bank = "<select name='bankid'>";
while ($acc = pg_fetch_array($banks)) {
if (isset($bankid) && $bankid == $acc['bankid']) {
$sel = "selected";
} else {
$sel = "";
}
$bank .= "<option value={$acc['bankid']} {$sel}>{$acc['accname']} - {$acc['bankname']} ({$acc['acctype']})</option>";
}
$bank .= "</select>";
if (!isset($name)) {
$name = "";
$descript = "";
$reference = "";
$cheqnum = "";
$amount = "";
$vatcodes = "2";
}
db_conn('cubit');
$Sl = "SELECT * FROM vatcodes ORDER BY code";
$Ri = db_exec($Sl) or errDie("Unable to get vat codes");
$Vatcodes = "<select name=vatcode>\n\t<option value='0'>Select</option>";
while ($vd = pg_fetch_array($Ri)) {
if ($vd['id'] == $vatcode) {
$sel = "selected";
} else {
$sel = "";
}
$Vatcodes .= "<option value='{$vd['id']}' {$sel}>{$vd['code']}</option>";
}
$Vatcodes .= "</select>";
explodeDate($date, $o_year, $o_month, $o_day);
$sel1 = "";
$sel2 = "";
$sel3 = "";
if ($chrgvat == "inc") {
$sel1 = "checked=yes";
} else {
if ($chrgvat == "exc") {
$sel2 = "checked=yes";
} else {
if ($chrgvat == "nov") {
$sel3 = "checked=yes";
} else {
$sel1 = "checked=yes";
}
}
}
# layout
$add = "\n\t\t\t\t<h3>Edit Bank Payment</h3>\n\t\t\t\t<form action='" . SELF . "' method='POST' name='form'>\n\t\t\t\t\t<input type='hidden' name='key' value='confirm' />\n\t\t\t\t\t<input type='hidden' name='id' value='{$id}' />\n\t\t\t\t\t<input type='hidden' name='vat' value='{$bcb['vat']}' />\n\t\t\t\t\t<input type='hidden' name='orig_vatcode' value='{$bcb['vatcode']}' />\n\t\t\t\t\t<input type='hidden' name='orig_chrgvat' value='{$bcb['chrgvat']}' />\n\t\t\t\t\t<input type='hidden' name='orig_amount' value='{$bcb['amount']}' />\n\t\t\t\t<table " . TMPL_tblDflts . " width='80%'>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<th>Field</th>\n\t\t\t\t\t\t<th>Value</th>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Bank Account</td>\n\t\t\t\t\t\t<td valign='center'>{$bank}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Date</td>\n\t\t\t\t\t\t<td>" . mkDateSelect("o", $o_year, $o_month, $o_day) . "</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Paid to</td>\n\t\t\t\t\t\t<td valign='center'><input size='20' name='name' value='{$name}'></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td valign='top'>Description</td>\n\t\t\t\t\t\t<td valign='center'><textarea col='18' rows='3' name='descript'>{$descript}</textarea></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td valign='top'>Reference</td>\n\t\t\t\t\t\t<td valign='center'><input size='20' name='reference' value='{$reference}'></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Cheque Number</td>\n\t\t\t\t\t\t<td valign='center'><input size='20' name='cheqnum' value='{$cheqnum}'></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>Amount</td>\n\t\t\t\t\t\t<td valign='center'>" . CUR . " <input type='text' size='10' name='amount' value='" . sprint($amount) . "'></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>VAT </td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type='radio' name='chrgvat' value='inc' {$sel1}>Inclusive \n\t\t\t\t\t\t\t<input type='radio' name='chrgvat' value='exc' {$sel2}>Exclusive \n\t\t\t\t\t\t\t<input type='radio' name='chrgvat' value='nov' {$sel3}>No VAT\n\t\t\t\t\t\t</td>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td>VAT Code</td>\n\t\t\t\t\t\t<td>{$Vatcodes}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td valign=top>Select Contra Account</td>\n\t\t\t\t\t\t<td>{$glacc}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td> </td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input type='button' onClick='javascript:history.back();' value='« Correction'> </td>\n\t\t\t\t\t\t<td valign='center' align='right'><input type='submit' value='Confirm »'></td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table>";
# main table (layout with menu)
$OUTPUT = "\n\t\t\t\t\t<center>\n\t\t\t\t\t<table width=100%>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td width=65% align='left'>{$add}</td>\n\t\t\t\t\t\t\t<td valign='top' align='center'>" . mkQuickLinks() . "\n\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</table>";
return $OUTPUT;
}
<?php
isMenu($modul, 'user');
?>
<script src="controllers/c_user.js"></script>
<script src="../js/metro/metro-button-set.js"></script>
<script src="../js/metro/metro-hint.js"></script>
<h4 style="color:white;">User</h4>
<div id="loadarea"></div>
<button onclick="viewFR('');" <?php
echo isDisabled('user', 'c');
?>
data-hint="Tambah Data" id="tambahBC"><span class="icon-plus-2"></span> </button>
<table class="table hovered bordered striped">
<thead>
<tr style="color:white;"class="info">
<th class="text-center">Nama</th>
<th class="text-center">Username</th>
<th class="text-center">Level</th>
<th class="text-center">Status</th>
<th class="text-center">Aksi</th>
</tr>
<tr xstyle="display:none;" id="cariTR" class="selected">
<th class="text-center"><div class="input-control text"><input class="cari" placeholder="cari ..." id="namaS" name="namaS"></div></th>
<th class="text-center"><div class="input-control text"><input class="cari" placeholder="cari ..." id="usernameS" name="usernameS"></div></th>
<th class="text-center"><div class="input-control select">
<select class="text-center cari" data-hint="level" id="levelS" name="levelS"></select>
</div></th>
<th class="text-center"><div class="input-control select">
function details($_POST, $error = "")
{
# get vars
foreach ($_POST as $key => $value) {
${$key} = $value;
}
# Validate input
require_lib("validate");
$v = new validate();
$v->isOk($purid, "num", 1, 20, "Invalid Non-Stock Order number.");
if (isset($ctyp) && $ctyp == 's') {
$v->isOk($supid, "num", 1, 20, "Invalid supplier account number.");
} elseif (isset($ctyp) && $ctyp == 'c') {
$v->isOk($deptid, "num", 1, 20, "Invalid Department.");
}
# display errors, if any
if ($v->isError()) {
$errors = $v->getErrors();
foreach ($errors as $e) {
$error .= "<li class=err>" . $e["msg"];
}
return slct($_POST, $error);
$confirm = "{$error}<p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>";
return $confirm;
}
# Get Order info
db_connect();
$sql = "SELECT * FROM nons_purchases 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>{$purid}</b> has already been received.";
$error .= "<p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>";
return $error;
}
/* --- Start Drop Downs --- */
# days drop downs
$days = array("30" => "30", "60" => "60", "90" => "90", "120" => "120");
$termssel = extlib_cpsel("terms", $days, $pur['terms']);
# format date
list($pyear, $pmon, $pday) = explode("-", $pur['pdate']);
$supacc = "<select name='supacc'>";
core_connect();
$sql = "SELECT * FROM accounts WHERE div = '" . USER_DIV . "' ORDER BY accname ASC";
$accRslt = db_exec($sql);
if (pg_numrows($accRslt) < 1) {
return "<li>There are No accounts in Cubit.";
}
while ($acc = pg_fetch_array($accRslt)) {
# Check Disable
if (isDisabled($acc['accid'])) {
continue;
}
$supacc .= "<option value='{$acc['accid']}'>{$acc['topacc']}/{$acc['accnum']} - {$acc['accname']}</option>";
}
$supacc .= "</select>";
# Get selected supplier info
db_connect();
$hide = "";
if (isset($ctyp) && $ctyp == 's') {
$sql = "SELECT * FROM suppliers WHERE supid = '{$supid}' AND div = '" . USER_DIV . "'";
$supRslt = db_exec($sql) or errDie("Unable to get supplier");
if (pg_numrows($supRslt) < 1) {
$error = "<li class=err> Supplier not Found.";
$confirm .= "{$error}<p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>";
return $confirm;
} else {
$sup = pg_fetch_array($supRslt);
$pur['supplier'] = $sup['supname'];
$pur['supaddr'] = $sup['supaddr'];
$supacc = $sup['supno'];
$hide = "<input type=hidden name=supid value='{$supid}'><input type=hidden name=ctyp value='{$ctyp}'>";
}
} elseif (isset($ctyp) && $ctyp == 'c') {
db_conn("exten");
$sql = "SELECT * FROM departments WHERE deptid = '{$deptid}'";
$deptRslt = db_exec($sql) or errDie("Unable to view customers");
if (pg_numrows($deptRslt) < 1) {
$error = "<li class=err> Department not Found.";
$confirm .= "{$error}<p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>";
return $confirm;
} else {
$dept = pg_fetch_array($deptRslt);
$supacc = "{$dept['deptname']} - Cash on Hand";
$hide = "<input type=hidden name=deptid value='{$deptid}'><input type=hidden name=ctyp value='{$ctyp}'>";
}
} elseif (isset($ctyp) && $ctyp == 'p') {
core_connect();
# Get Petty cash account
$cashacc = gethook("accnum", "bankacc", "name", "Petty Cash");
# Get account name for thy lame User's Sake
$accRslt = get("core", "*", "accounts", "accid", $cashacc);
if (pg_numrows($accRslt) < 1) {
return "<li class=err> Petty Cash Account not found.";
}
$acc = pg_fetch_array($accRslt);
$supacc = "{$acc['topacc']}/{$acc['accnum']} - {$acc['accname']}";
$hide = "<input type=hidden name=supacc value='{$cashacc}'><input type=hidden name=ctyp value='{$ctyp}'>";
}
/* --- End Drop Downs --- */
/* --- Start Products Display --- */
# select all products
$products = "\n\t<table cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "' border=0 width=100%>\n\t<tr><th>ITEM NUMBER</th><th>DESCRIPTION</th><th>QTY RECEIVED</th><th>UNIT PRICE</th><th>DELIVERY DATE</th><th>AMOUNT</th><tr>";
# get selected stock in this Order
db_connect();
$sql = "SELECT *, (qty - rqty) as qty FROM nons_pur_items WHERE purid = '{$purid}' AND (qty - rqty) > 0 AND div = '" . USER_DIV . "'";
$stkdRslt = db_exec($sql);
$i = 0;
$key = 0;
while ($stkd = pg_fetch_array($stkdRslt)) {
# keep track of selected stock amounts
$amts[$i] = $stkd['amt'];
$i++;
list($syear, $smon, $sday) = explode("-", $stkd['ddate']);
# put in product
$products .= "<tr class='bg-odd'><td><input type=hidden size=4 name=cod[] value='{$stkd['cod']}'>{$stkd['cod']}</td><td>{$stkd['des']}</td><td><input type=hidden name=qts[] value='{$stkd['qty']}'><input type=text size=5 name=qtys[] value='{$stkd['qty']}'></td><td><input type=hidden size=4 name=unitcost[] value='{$stkd['unitcost']}'>{$stkd['unitcost']}</td><td>{$sday}-{$smon}-{$syear}</td><td>" . CUR . " {$stkd['amt']}</td></tr>";
$key++;
}
# look above(if i = 0 then there are no products)
if ($i == 0) {
$done = "";
}
$products .= "</table>";
/* --- End Products Display --- */
/* --- Start Some calculations --- */
# Get subtotal
$SUBTOT = sprint($pur['subtot']);
# Get Total
$TOTAL = sprint($pur['total']);
# Get vat
$VAT = sprint($pur['vat']);
/* --- End Some calculations --- */
db_conn('cubit');
$Sql = "SELECT * FROM assets WHERE (id = '{$pur['assid']}' AND div = '" . USER_DIV . "')";
$Rslt = db_exec($Sql) or errDie("Unable to access database.");
if (pg_numrows($Rslt) < 1) {
return "<li class=err> - Asset not Found";
}
$asset = pg_fetch_array($Rslt);
/* -- Final Layout -- */
$details = "<center><h3>Non-Stock Asset Order received</h3>\n\t<form action='" . SELF . "' method=post name=form>\n\t<input type=hidden name=key value=update>\n\t<input type=hidden name=purid value='{$purid}'>\n\t{$hide}\n\t<table cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "' border=0 width=95%>\n\t<tr><td valign=top>\n\t\t<table cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "' border=0>\n\t\t\t<tr><th colspan=2> Supplier Details </th></tr>\n\t\t\t<tr class='bg-odd'><td>Supplier</td><td valign=center>{$pur['supplier']}</td></tr>\n\t\t\t<tr class='bg-even'><td>Supplier Address</td><td valign=center><pre>{$pur['supaddr']}</pre></td></tr>\n\t\t\t<tr class='bg-odd' " . ass("Select the account you wish to Credit") . "><td>Account</td><td>{$supacc}</td></tr>\n\t\t</table>\n\t</td><td valign=top align=right>\n\t\t<table cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "' border=0>\n\t\t\t<tr><th colspan=2> Non-Stock Order Details </th></tr>\n\t\t\t<tr class='bg-even'><td>Asset</td><td valign=center>{$asset['des']}</td></tr>\n\t\t\t<tr class='bg-odd'><td>Non-Stock Order No.</td><td valign=center>{$pur['purnum']}</td></tr>\n\t\t\t<tr class='bg-even'><td>Delivery Ref No.</td><td valign=center><input type=text name=refno size=10 value='{$pur['refno']}'></td></tr>\n\t\t\t<tr class='bg-odd'><td>Terms</td><td valign=center>{$pur['terms']} Days</td></tr>\n\t\t\t<tr class='bg-even'><td>Date</td><td valign=center><input type=text size=2 name=pday maxlength=2 value='{$pday}'>-<input type=text size=2 name=pmon maxlength=2 value='{$pmon}'>-<input type=text size=4 name=pyear maxlength=4 value='{$pyear}'> DD-MM-YYYY</td></tr>\n\t\t\t<tr class='bg-odd'><td>VAT Inclusive</td><td valign=center>{$pur['vatinc']}</td></tr>\n\t\t\t<tr class='bg-even'><td>Delivery Charges</td><td valign=center>" . CUR . " <input type=text name=shipchrg size=10 value='{$pur['shipchrg']}'></td></tr>\n\t\t</table>\n\t</td></tr>\n\t<tr><td><br></td></tr>\n\t<tr><td colspan=2>{$products}</td></tr>\n\t<tr><td>\n\t\t<p>\n\t\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\n\t\t\t<tr><th width=25%>Quick Links</th><th width=25%>Remarks</th><td rowspan=5 valign=top width=50%>{$error}</td></tr>\n\t\t\t<tr><td class='bg-odd'><a href='nons-purchase-new.php'>New Order</a></td><td class='bg-odd' rowspan=4 align=center valign=top><textarea name=remarks rows=4 cols=20>{$pur['remarks']}</textarea></td></tr>\n\t\t\t<tr class='bg-odd'><td><a href='nons-purchase-view.php'>View Orders</a></td></tr>\n\t\t\t<script>document.write(getQuicklinkSpecial());</script>\n\n\t\t</table>\n\t</td><td align=right>\n\t\t<table cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "' border=0 width=80%>\n\t\t\t<tr class='bg-odd'><td>SUBTOTAL</td><td align=right>" . CUR . " {$SUBTOT}</td></tr>\n\t\t\t<tr class='bg-even'><td>Delivery Charges</td><td align=right>" . CUR . " {$pur['shipping']}</td></tr>\n\t\t\t<tr class='bg-odd'><td>VAT @ " . TAX_VAT . " %</td><td align=right>" . CUR . " {$pur['vat']}</td></tr>\n\t\t\t<tr class='bg-even'><th>GRAND TOTAL</th><td align=right>" . CUR . " {$TOTAL}</td></tr>\n\t\t</table>\n\t</td></tr>\n\t<tr><td align=right><input type=button value='« Back' onClick='javascript:history.back()'> | <input type=submit name='upBtn' value='Write'></td></tr>\n\t</table></form>\n\t</center>";
return $details;
}
public static function output($post)
{
global $woocommerce, $post, $wpdb, $wp_roles, $order, $inicis_payment;
$woocommerce->payment_gateways();
$order = new WC_Order($post->ID);
$payment_method = get_post_meta($order->id, '_payment_method', true);
$tid = get_post_meta($order->id, 'inicis_paymethod_tid', true);
$vbank_refund_add = get_post_meta($order->id, 'inicis_paymethod_vbank_add', true);
$vbank_noti_received = get_post_meta($order->id, 'inicis_vbank_noti_received', true);
$url = admin_url('post.php?post=' . $order->id . '&action=edit');
?>
<style type="text/css">
#mb_inipay {
border-bottom: 1px solid #dfdfdf;
margin:0 -12px;
padding-bottom:10px;
}
#mb_inipay_sub {
padding: 0px 12px;
}
.mb_inipay_h4 {
margin:0px!important;
}
.mb_inipay_wide {
width:100%;
}
.mb_inipay_note {
padding: 10px;
background: #efefef;
position: relative;
margin-top: 10px;
}
.mb_inipay_note p {
margin: 0;
padding: 0;
word-wrap: break-word;
}
</style>
<script type="text/javascript">
function checkIsJSON(value) {
try {
JSON.parse(value);
return true;
} catch (ex) {
return false;
}
}
function sleep(milliseconds) {
var start = new Date().getTime();
for (var i = 0; i < 1e7; i++) {
if ((new Date().getTime() - start) > milliseconds){
break;
}
}
}
function onClickCancelRequest(){
if(confirm("정말 취소 처리하시겠습니까?\n\n처리 이후에 이전 상태로 되돌릴 수 없습니다. 입금 통보 전에 취소하시는 경우이기 때문에 고객의 요청이 아니라면 취소 처리시 주의하여 주세요.")) {
var data = {
action: "<?php
echo 'refund_request_' . $payment_method;
?>
",
order_id: "<?php
echo $post->ID;
?>
",
refund_request: "<?php
echo wp_create_nonce('refund_request');
?>
"
};
jQuery("[name='refund-request']").attr('disabled','true');
jQuery("[name='refund-request']").attr('value', "<?php
echo __("처리중...", "inicis_payment");
?>
");
jQuery.post(ajaxurl, data, function(response) {
if (response) {
if (checkIsJSON(response)) {
response = JSON.parse(response);
}
if (response.success == 'true' || response.success) {
alert(response.data);
location.reload();
} else {
alert(response.data);
jQuery("[name='refund-request']").removeAttr('disabled');
jQuery("[name='refund-request']").attr('value', "취소하기");
}
} else {
alert('취소요청 결과를 수신하지 못하였습니다.\n처리 결과 확인을 위해 영수증을 확인해 보시기 바랍니다.');
jQuery("[name='refund-request']").removeAttr('disabled');
jQuery("[name='refund-request']").attr('value', "취소하기");
}
});
} else {
return;
}
}
function onClickRefundRequest(){
if(confirm("정말 환불 처리하시겠습니까?\n\n처리 이후에 이전 상태로 되돌릴 수 없습니다. 신중하게 선택해주세요.")) {
var data = {
action: "<?php
echo $payment_method;
?>
_order_cancelled",
post_id: "<?php
echo $post->ID;
?>
",
inicis_vbank_refund_request: "<?php
echo wp_create_nonce('inicis_vbank_refund_request');
?>
"
};
jQuery("[name='vbank-refund-request']").attr('disabled','true');
jQuery("[name='vbank-refund-request']").attr('value', "<?php
echo __("처리중...", "inicis_payment");
?>
");
jQuery.post(ajaxurl, data, function(response) {
if (response) {
if (checkIsJSON(response)) {
response = JSON.parse(response);
}
if (response.success == 'true' || response.success) {
alert(response.data);
location.reload();
} else {
alert(response.data);
jQuery("[name='vbank-refund-request']").removeAttr('disabled');
jQuery("[name='vbank-refund-request']").attr('value', "<?php
echo __('환불하기', 'inicis_payment');
?>
");
}
} else {
alert("<?php
echo __('환불 처리가 실패되었습니다!\\n\\n다시 시도해 주세요!\\n\\n계속 동일 증상 발생시 주문상태를 확인해주세요!', 'inicis_payment');
?>
");
jQuery("[name='vbank-refund-request']").removeAttr('disabled');
jQuery("[name='vbank-refund-request']").attr('value', "<?php
echo __('환불하기', 'inicis_payment');
?>
");
}
});
} else {
return;
}
}
function checkReceipt(){
window.open("https://iniweb.inicis.com/app/publication/apReceipt.jsp?noMethod=1&noTid=<?php
echo get_post_meta($post->ID, 'inicis_paymethod_tid', true);
?>
");
}
function onVbankRefundAdd() {
if(confirm("환불 정보를 등록하시겠습니까?")) {
if (jQuery("#_order_refund_bankcode").val() != "-1" && jQuery("#_order_refund_vacc_num").val() != "" && jQuery("#_order_refund_vacc_name").val() != "" && jQuery("#_order_refund_reason").val() != "") {
jQuery("[name='vbank-refund-request-vacc-add']").attr('disabled', 'true');
jQuery("[name='vbank-refund-request-vacc-add']").val('처리중...');
jQuery.ajax({
type: 'POST',
dataType: 'text',
url: '<?php
echo home_url() . '/wc-api/WC_Gateway_Inicis_Vbank?type=vbank_refund_add';
?>
',
data: {
action: 'vbank_refund_add',
orderid: '<?php
echo $post->ID;
?>
',
refund_bankcode: jQuery("#_order_refund_bankcode").val(),
refund_vaccnum: jQuery("#_order_refund_vacc_num").val(),
refund_vaccname: jQuery("#_order_refund_vacc_name").val(),
refund_reason: jQuery("#_order_refund_reason").val(),
refund_wpnonce: '<?php
echo wp_create_nonce('inicis_vbank_refund_add');
?>
'
},
success: function (data, textStatus, jqXHR) {
if (data.match("success")) {
alert('환불 정보 등록이 완료되었습니다.\n\n환불 정보를 확인하신 후 환불처리를 진행해 주시기 바랍니다.');
location.href = '<?php
echo $url;
?>
';
} else {
alert('관리자에게 문의하여주세요.\n\n에러 메시지 : \n' + data);
jQuery("[name='vbank-refund-request-vacc-add']").removeAttr("disabled");
jQuery("[name='vbank-refund-request-vacc-add']").val('정보등록');
location.href = '<?php
echo $url;
?>
';
}
}
});
} else {
alert("환불 정보를 등록을 위한 값이 지정되지 않았습니다.\n\n - 환불은행, 계좌번호, 계좌주명, 취소사유를 확인하여 입력하여 주세요.");
return;
}
}
}
function onVbankRefundModify() {
if(confirm("환불 정보를 수정하시겠습니까?")) {
if (jQuery("#_order_refund_bankcode").val() != "-1" && jQuery("#_order_refund_vacc_num").val() != "" && jQuery("#_order_refund_vacc_name").val() != "" && jQuery("#_order_refund_reason").val() != "") {
jQuery("[name='vbank-refund-request-vacc-modify']").attr('disabled', 'true');
jQuery("[name='vbank-refund-request-vacc-modify']").val('처리중...');
jQuery.ajax({
type: 'POST',
dataType: 'text',
url: '<?php
echo home_url() . '/wc-api/WC_Gateway_Inicis_Vbank?type=vbank_refund_modify';
?>
',
data: {
action: 'vbank_refund_modify',
orderid: '<?php
echo $post->ID;
?>
',
refund_bankcode: jQuery("#_order_refund_bankcode").val(),
refund_vaccnum: jQuery("#_order_refund_vacc_num").val(),
refund_vaccname: jQuery("#_order_refund_vacc_name").val(),
refund_reason: jQuery("#_order_refund_reason").val(),
refund_wpnonce: '<?php
echo wp_create_nonce('inicis_vbank_refund_modify');
?>
'
},
success: function (data, textStatus, jqXHR) {
if (data.match("success")) {
alert('환불 정보 수정이 완료되었습니다.\n\n환불 정보를 확인하신 후 환불처리를 진행해 주시기 바랍니다.');
location.href = '<?php
echo $url;
?>
';
} else {
alert('관리자에게 문의하여주세요.\n\n에러 메시지 : \n' + data);
jQuery("[name='vbank-refund-request-vacc-modify']").removeAttr("disabled");
jQuery("[name='vbank-refund-request-vacc-modify']").val('정보등록');
location.href = '<?php
echo $url;
?>
';
}
}
});
} else {
alert("환불 정보 수정을 위한 값이 지정되지 않았습니다.\n\n - 환불은행, 계좌번호, 계좌주명, 취소사유를 확인하여 입력하여 주세요.");
return;
}
}
}
</script>
<?php
$vbank_refund_bankcode = get_post_meta($post->ID, 'vbank_refund_bankcode', true);
$vbank_refund_vaccnum = get_post_meta($post->ID, 'vbank_refund_vaccnum', true);
$vbank_refund_vaccname = get_post_meta($post->ID, 'vbank_refund_vaccname', true);
$vbank_refund_reason = get_post_meta($post->ID, 'vbank_refund_reason', true);
function isSelected($num, $val)
{
if ($num == $val) {
echo " selected";
} else {
return;
}
}
function isDisabled()
{
global $post;
$vbank_refunded = get_post_meta($post->ID, 'inicis_paymethod_vbank_refunded', true);
if ($vbank_refunded == 'yes') {
echo ' disabled';
}
}
?>
<?php
if ($vbank_noti_received == 'yes') {
?>
<div class="mb_inipay_note">
<p>이니시스 가상계좌 환불처리는 전액환불만 가능하며, 전액환불이 불가한 경우, 별도로 환불절차를 진행하시기 바랍니다. 가상계좌로 환불 처리를 진행하시는 경우, 이니시스 계약에 따라 환불 수수료가 부과됩니다.</p>
</div>
<div id="mb_inipay" class="total_row">
<div id="mb_inipay_sub">
<div id="mb_inipay_group" class="totals_group">
<p class="wide"><h4 class="mb_inipay_h4"><label for="_order_refund_bankcode">환불 은행(코드)</label>
</h4>
<select id="_order_refund_bankcode" name="_order_refund_bankcode" class="mb_inipay_wide"
title="환불처리할 은행을 선택해주세요."<?php
isDisabled();
?>
>
<option value="-1"<?php
isSelected('-1', $vbank_refund_bankcode);
?>
>===== [ 선택 ] =====
</option>
<option value="02"<?php
isSelected('02', $vbank_refund_bankcode);
?>
>산업(02)</option>
<option value="03"<?php
isSelected('03', $vbank_refund_bankcode);
?>
>기업(03)</option>
<option value="04"<?php
isSelected('04', $vbank_refund_bankcode);
?>
>국민(04)</option>
<option value="05"<?php
isSelected('05', $vbank_refund_bankcode);
?>
>외환(05)</option>
<option value="06"<?php
isSelected('06', $vbank_refund_bankcode);
?>
>국민(주택)(06)</option>
<option value="07"<?php
isSelected('07', $vbank_refund_bankcode);
?>
>수협(07)</option>
<option value="11"<?php
isSelected('11', $vbank_refund_bankcode);
?>
>농협(11)</option>
<option value="12"<?php
isSelected('12', $vbank_refund_bankcode);
?>
>농협(12)</option>
<option value="16"<?php
isSelected('16', $vbank_refund_bankcode);
?>
>농협(축협)(16)</option>
<option value="20"<?php
isSelected('20', $vbank_refund_bankcode);
?>
>우리(20)</option>
<option value="21"<?php
isSelected('21', $vbank_refund_bankcode);
?>
>조흥(21)</option>
<option value="23"<?php
isSelected('23', $vbank_refund_bankcode);
?>
>제일(23)</option>
<option value="25"<?php
isSelected('25', $vbank_refund_bankcode);
?>
>서울(25)</option>
<option value="26"<?php
isSelected('26', $vbank_refund_bankcode);
?>
>신한(26)</option>
<option value="27"<?php
isSelected('27', $vbank_refund_bankcode);
?>
>한미(27)</option>
<option value="31"<?php
isSelected('31', $vbank_refund_bankcode);
?>
>대구(31)</option>
<option value="32"<?php
isSelected('32', $vbank_refund_bankcode);
?>
>부산(32)</option>
<option value="34"<?php
isSelected('34', $vbank_refund_bankcode);
?>
>광주(34)</option>
<option value="35"<?php
isSelected('35', $vbank_refund_bankcode);
?>
>제주(35)</option>
<option value="37"<?php
isSelected('37', $vbank_refund_bankcode);
?>
>전북(37)</option>
<option value="38"<?php
isSelected('38', $vbank_refund_bankcode);
?>
>강원(38)</option>
<option value="39"<?php
isSelected('39', $vbank_refund_bankcode);
?>
>경남(39)</option>
<option value="41"<?php
isSelected('41', $vbank_refund_bankcode);
?>
>비씨(41)</option>
<option value="45"<?php
isSelected('45', $vbank_refund_bankcode);
?>
>새마을(45)</option>
<option value="48"<?php
isSelected('48', $vbank_refund_bankcode);
?>
>신협(48)</option>
<option value="50"<?php
isSelected('50', $vbank_refund_bankcode);
?>
>상호저축은행(50)</option>
<option value="53"<?php
isSelected('53', $vbank_refund_bankcode);
?>
>씨티(53)</option>
<option value="54"<?php
isSelected('54', $vbank_refund_bankcode);
?>
>홍콩상하이은행(54)</option>
<option value="55"<?php
isSelected('55', $vbank_refund_bankcode);
?>
>도이치(55)</option>
<option value="56"<?php
isSelected('56', $vbank_refund_bankcode);
?>
>ABN암로(56)</option>
<option value="70"<?php
isSelected('70', $vbank_refund_bankcode);
?>
>신안상호(70)</option>
<option value="71"<?php
isSelected('71', $vbank_refund_bankcode);
?>
>우체국(71)</option>
<option value="81"<?php
isSelected('81', $vbank_refund_bankcode);
?>
>하나(81)</option>
<option value="87"<?php
isSelected('87', $vbank_refund_bankcode);
?>
>신세계(87)</option>
<option value="88"<?php
isSelected('88', $vbank_refund_bankcode);
?>
>신한(88)</option>
</select>
</p>
<p class="wide"><h4 class="mb_inipay_h4"><label for="_order_refund_vacc_num">환불 계좌번호</label>
</h4>
<input type="text" class="mb_inipay_wide" id="_order_refund_vacc_num"
name="_order_refund_vacc_num" placeholder="번호(숫자)만 입력하세요."
value="<?php
echo $vbank_refund_vaccnum;
?>
"
title="결제 플러그인 설정에서 배송회사 이름을 지정할수 있습니다."<?php
isDisabled();
?>
></p>
<p class="wide"><h4 class="mb_inipay_h4"><label for="_order_refund_vacc_name">환불 계좌주명</label>
</h4>
<input type="text" class="mb_inipay_wide" id="_order_refund_vacc_name"
name="_order_refund_vacc_name" placeholder="환불 계좌주명"
value="<?php
echo $vbank_refund_vaccname;
?>
" title="배송시 사용된 송장 번호를 입력해주세요."<?php
isDisabled();
?>
></p>
<p class="wide"><h4 class="mb_inipay_h4"><label for="_order_refund_reason">취소 사유</label></h4>
<input type="text" class="mb_inipay_wide" id="_order_refund_reason" name="_order_refund_reason"
placeholder="취소 사유" value="<?php
echo $vbank_refund_reason;
?>
"
title="취소 사유를 입력해주세요."<?php
isDisabled();
?>
></p>
</div>
</div>
</div>
<?php
}
echo '<p class="order-info">';
if (apply_filters('ifw_is_admin_refundable_' . $payment_method, false, $order)) {
if ($vbank_noti_received == 'yes') {
if ($vbank_refund_add == 'yes') {
echo '<input style="margin-right:10px" type="button" class="button button-primary tips" id="ifw-refund-request" name="vbank-refund-request-vacc-modify" value="' . __('정보수정', 'inicis_payment') . '" onClick="javascript:onVbankRefundModify();" title="이니시스 가상계좌 환불정보를 수정합니다." data-tip="환불정보 수정">';
echo '<input style="margin-right:10px" type="button" class="button button-primary tips" id="ifw-refund-request" name="vbank-refund-request" value="' . __('환불하기', 'inicis_payment') . '" onClick="javascript:onClickRefundRequest();" title="이니시스 가상계좌 환불 처리를 수행합니다." data-tip="환불하기">';
} else {
echo '<input style="margin-right:10px" type="button" class="button button-primary tips" id="ifw-refund-request" name="vbank-refund-request-vacc-add" value="' . __('정보등록', 'inicis_payment') . '" onClick="javascript:onVbankRefundAdd();" title="가상계좌 무통장입금 환불처리를 위한 환불정보를 등록합니다." data-tip="환불정보 등록">';
echo '<input style="margin-right:10px" type="button" class="button button-primary tips" id="ifw-refund-request" name="vbank-refund-request" value="' . __('환불하기', 'inicis_payment') . '" title="이니시스 가상계좌 환불 처리를 수행할 수 없습니다. 먼저 환불정보를 등록하셔야 환불처리를 할 수 있습니다." data-tip="환불하기" disabled>';
}
} else {
echo '<input style="margin-right:10px" type="button" class="button button-primary tips" id="ifw-refund-request" name="refund-request" value="' . __('취소하기', 'inicis_payment') . '" onClick="javascript:onClickCancelRequest();" title="이니시스 가상계좌 가상계좌 입금전 취소 처리를 수행합니다." data-tip="가상계좌 입금전 취소하기">';
}
}
if (!empty($tid)) {
echo '<input type="button" class="button button-primary tips" id="ifw-check-receipt" name="refund-request-check-receipt" value="' . __('영수증 확인', 'inicis_payment') . '" onClick="javascript:checkReceipt();" data-tip="영수증 확인">';
}
echo '</p>';
}
function printEdit()
{
global $prefs;
$admin = allowed($this->getDataInt('id_case'), 'a');
// FIXME
$edit = allowed($this->getDataInt('id_case'), 'e');
// FIXME
$write = allowed($this->getDataInt('id_case'), 'w');
// FIXME (put in constructor)
// FIXME: not sure whether this works as previously
$dis = isDisabled(!($admin || $edit));
echo '<table class="tbl_usr_dtl" width="99%">' . "\n";
echo '<tr><td>';
echo f_err_star('date_start') . _T('fu_input_date_start');
echo "</td>\n";
echo "<td>";
$name = $admin || $edit ? 'start' : '';
echo get_date_inputs($name, $this->data['date_start'], false);
echo ' ' . _T('time_input_time_at') . ' ';
echo get_time_inputs($name, $this->data['date_start']);
echo "</td>\n";
echo "</tr>\n";
echo "<tr><td>";
echo f_err_star('date_end') . ($prefs['time_intervals'] == 'absolute' ? _T('fu_input_date_end') : _T('fu_input_time_length'));
echo "</td>\n";
echo '<td>';
if ($prefs['time_intervals'] == 'absolute') {
// Buggy code, so isolated most important cases
if ($this->data['id_followup'] == 0) {
$name = 'end';
} elseif ($edit) {
$name = 'end';
} else {
// user can 'finish' entering data
$name = $admin || $edit && $this->data['date_end'] == '0000-00-00 00:00:00' ? 'end' : '';
}
echo get_date_inputs($name, $this->data['date_end']);
echo ' ';
echo _T('time_input_time_at') . ' ';
echo get_time_inputs($name, $this->data['date_end']);
} else {
$name = '';
// Buggy code, so isolated most important cases
if ($this->getDataInt('id_followup') == 0) {
$name = 'delta';
} elseif ($edit) {
$name = 'delta';
} else {
// user can 'finish' entering data
$name = $admin || $edit && $this->getDataString('date_end') == '0000-00-00 00:00:00' ? 'delta' : '';
}
if (empty($_SESSION['errors'])) {
$interval = $this->getDataString('date_end') != '0000-00-00 00:00:00' ? strtotime($this->getDataString('date_end')) - strtotime($this->getDataString('date_start')) : 0;
echo get_time_interval_inputs($name, $interval);
} else {
echo get_time_interval_inputs_from_array($name, $this->data);
}
}
echo "</td>\n";
echo "</tr>\n";
// Show 'conclusion' options
if ($this->show_conclusion) {
$kws_conclusion = get_keywords_in_group_name('conclusion');
$kws_result = get_keywords_in_group_name('_crimresults');
echo "<tr>\n";
echo "<td>" . _Ti('fu_input_conclusion') . "</td>\n";
echo '<td>';
// Result
if (read_meta('case_result') == 'yes') {
echo '<select ' . $dis . ' name="result" size="1" class="sel_frm">' . "\n";
$default = '';
if ($this->data['result']) {
$default = $this->data['result'];
}
foreach ($kws_result as $kw) {
$sel = isSelected($kw['name'] == $default);
echo '<option ' . $sel . ' value="' . $kw['name'] . '">' . _T(remove_number_prefix($kw['title'])) . "</option>\n";
}
echo "</select><br/>\n";
}
// Conclusion
echo '<select ' . $dis . ' name="conclusion" size="1" class="sel_frm">' . "\n";
$default = '';
if ($this->data['conclusion']) {
$default = $this->data['conclusion'];
}
foreach ($kws_conclusion as $kw) {
$sel = isSelected($kw['name'] == $default);
echo '<option ' . $sel . ' value="' . $kw['name'] . '">' . _T(remove_number_prefix($kw['title'])) . "</option>\n";
}
echo "</select>\n";
echo "</td>\n";
echo "</tr>\n";
// If guilty, what sentence?
$kws_sentence = get_keywords_in_group_name('sentence');
echo "<tr>\n";
echo "<td>" . _Ti('fu_input_sentence') . "</td>\n";
echo '<td>';
echo '<select ' . $dis . ' name="sentence" size="1" class="sel_frm">' . "\n";
$default = '';
if ($this->data['sentence']) {
$default = $this->data['sentence'];
}
echo "<!-- " . $default . " -->\n";
foreach ($kws_sentence as $kw) {
$sel = $kw['name'] == $default ? ' selected="selected"' : '';
echo '<option ' . $sel . ' value="' . $kw['name'] . '">' . _T(remove_number_prefix($kw['title']), array('currency' => read_meta('currency'))) . "</option>\n";
}
echo "</select>\n";
// If sentence, for how much?
echo '<input type="text" name="sentence_val" size="10" value="' . $this->data['sentence_val'] . '" />';
echo "</td>\n";
echo "</tr>\n";
}
if (_request('submit') == 'set_status' || is_status_change($this->getDataString('type'))) {
// Change status
echo "<tr>\n";
echo "<td>" . _T('case_input_status') . "</td>\n";
echo "<td>";
echo '<input type="hidden" name="type" value="' . $this->getDataString('type') . '" />' . "\n";
echo _T('kw_followups_' . $this->data['type'] . '_title');
echo "</td>\n";
echo "</tr>\n";
} elseif (_request('submit') == 'set_stage' || $this->getDataString('type') == 'stage_change') {
// Change stage
echo "<tr>\n";
echo "<td>" . _T('fu_input_next_stage') . "</td>\n";
echo "<td>";
echo '<input type="hidden" name="type" value="' . $this->getDataString('type') . '" />' . "\n";
// This is to compensate an old bug, when 'case stage' was not stored in fu.description
// and therefore editing a follow-up would not give correct information.
// Bug was in CVS of 0.4.3 between 19-20 April 2005. Should not affect many people.
if ($s = $this->getDataString('new_stage')) {
echo '<input type="hidden" name="new_stage" value="' . $s . '" />' . "\n";
echo _Tkw('stage', $s);
} else {
echo "New stage information not available";
}
echo "</td>\n";
echo "</tr>\n";
if ($s = $this->getDataString('new_stage')) {
// Update stage keywords (if any)
$stage = get_kw_from_name('stage', $s);
$id_stage = $stage['id_keyword'];
show_edit_keywords_form('stage', $this->data['id_case'], $id_stage);
}
} elseif ($this->getDataString('type') == 'assignment' || $this->getDataString('type') == 'unassignment') {
// Do not allow assignment/un-assignment follow-ups to be changed
echo "<tr>\n";
echo "<td>" . _T('fu_input_next_stage') . "</td>\n";
echo "<td>";
echo '<input type="hidden" name="type" value="' . $this->getDataString('type') . '" />' . "\n";
echo _Tkw('followups', $this->getDataString('type'));
echo "</td>\n";
echo "</tr>\n";
} else {
// The usual follow-up
echo "<tr>\n";
echo "<td>" . _T('fu_input_type') . "</td>\n";
echo "<td>";
echo '<select ' . $dis . ' name="type" size="1" class="sel_frm">' . "\n";
$default_fu = get_suggest_in_group_name('followups');
$futype_kws = get_keywords_in_group_name('followups');
$kw_found = false;
foreach ($futype_kws as $kw) {
$sel = isSelected($kw['name'] == $default_fu);
if ($sel) {
$kw_found = true;
}
echo '<option value="' . $kw['name'] . '"' . $sel . '>' . _T(remove_number_prefix($kw['title'])) . "</option>\n";
}
// Exotic case where the FU keyword was hidden by the administrator,
// but an old follow-up using that keyword is being edited.
if (!$kw_found) {
echo '<option selected="selected" value="' . $default_fu . '">' . _Tkw('followups', $default_fu) . "</option>\n";
}
echo "</select>\n";
echo "</td>\n";
echo "</tr>\n";
}
// Keywords (if any)
show_edit_keywords_form('followup', $this->getDataInt('id_followup'));
// Description
echo "<tr>\n";
echo '<td valign="top">' . f_err_star('description') . _T('fu_input_description') . "</td>\n";
echo '<td>';
if ($this->getDataString('type') == 'assignment' || $this->getDataString('type') == 'unassignment') {
// Do not allow edit of assignment
echo '<input type="hidden" name="description" value="' . $this->getDataString('description') . '" />' . "\n";
echo get_fu_description($this->data);
} else {
echo '<textarea ' . $dis . ' name="description" rows="15" cols="60" class="frm_tarea">';
echo clean_output($this->getDataString('description'));
echo "</textarea>";
}
echo "</td></tr>\n";
// Sum billed field
if ($this->show_sum_billed == "yes") {
echo '<tr>';
echo '<td>' . _T('fu_input_sum_billed') . "</td>\n";
echo '<td>';
echo '<input ' . $dis . ' name="sumbilled" ' . 'value="' . clean_output($this->getDataString('sumbilled')) . '" ' . 'class="search_form_txt" size="10" />';
// [ML] If we do this we may as well make a function
// out of it, but not sure where to place it :-)
// This code is also in config_site.php
$currency = read_meta('currency');
if (empty($currency)) {
$current_lang = $GLOBALS['lang'];
$GLOBALS['lang'] = read_meta('default_language');
$currency = _T('currency_default_format');
$GLOBALS['lang'] = $current_lang;
}
echo htmlspecialchars($currency);
echo "</td></tr>\n";
}
echo "</table>\n\n";
// XXX FIXME: Should probably be in some function "is_system_fu"
// or even "is_deletable"
if ($this->getDataInt('id_followup') && allowed($this->data['id_case'], 'a') && !(is_status_change($this->data['type']) || $this->data['type'] == 'assignment' || $this->data['type'] == 'unassignment')) {
$checked = $this->getDataString('hidden') == 'Y' ? ' checked="checked" ' : '';
echo '<p class="normal_text">';
echo '<input type="checkbox"' . $checked . ' name="delete" id="box_delete" />';
echo '<label for="box_delete">' . _T('fu_info_delete') . '</label>';
echo "</p>\n";
}
// Add followup appointment
if (!_request('followup')) {
echo "<!-- Add appointment? -->\n";
echo '<p class="normal_text">';
echo '<input type="checkbox" name="add_appointment" id="box_new_app" onclick="display_block(\'new_app\', \'flip\')" />';
echo '<label for="box_new_app">' . _T('fu_info_add_future_activity') . '</label>';
echo "</p>\n";
echo '<div id="new_app" style="display: none;">';
echo '<table class="tbl_usr_dtl" width="99%">' . "\n";
echo "<!-- Start time -->\n\t\t<tr><td>";
echo _T('time_input_date_start');
echo "</td><td>";
echo get_date_inputs('app_start', $this->data['app_start_time'], false);
echo ' ' . _T('time_input_time_at') . ' ';
echo get_time_inputs('app_start', $this->data['app_start_time']);
echo f_err_star('app_start_time');
echo "</td></tr>\n";
echo "<!-- End time -->\n\t\t<tr><td>";
echo $prefs['time_intervals'] == 'absolute' ? _T('time_input_date_end') : _T('app_input_time_length');
echo "</td><td>";
if ($prefs['time_intervals'] == 'absolute') {
echo get_date_inputs('app_end', $this->data['app_end_time']);
echo ' ' . _T('time_input_time_at') . ' ';
echo get_time_inputs('app_end', $this->data['app_end_time']);
echo f_err_star('app_end_time');
} else {
$interval = $this->data['app_end_time'] != '0000-00-00 00:00:00' ? strtotime($this->data['app_end_time']) - strtotime($this->data['app_start_time']) : 0;
// echo _T('calendar_info_time') . ' ';
echo get_time_interval_inputs('app_delta', $interval);
echo f_err_star('app_end_time');
}
echo "</td></tr>\n";
/* [ML] Removing, not useful for now
echo "<!-- Reminder -->\n\t\t<tr><td>";
echo (($prefs['time_intervals'] == 'absolute') ? _T('app_input_reminder_time') : _T('app_input_reminder_offset'));
echo "</td><td>";
if ($prefs['time_intervals'] == 'absolute') {
echo get_date_inputs('app_reminder', $this->data['app_reminder']);
echo ' ' . _T('time_input_time_at') . ' ';
echo get_time_inputs('app_reminder', $this->data['app_reminder']);
echo f_err_star('app_reminder');
} else {
$interval = ( ($this->data['app_end_time']!='0000-00-00 00:00:00') ?
strtotime($this->data['app_start_time']) - strtotime($this->data['app_reminder']) : 0);
// echo _T('calendar_info_time') . ' ';
echo get_time_interval_inputs('app_rem_offset', $interval);
echo " " . _T('time_info_before_start');
echo f_err_star('app_reminder');
}
echo "</td></tr>\n";
*/
// TODO: [ML] a bit of testing to see if this survives an error on new case
// I suspect it doesn't..
echo "<!-- Appointment title -->\n\t\t<tr><td>";
echo f_err_star('app_title') . _T('app_input_title');
echo "</td><td>";
echo '<input type="text" ' . $dis . ' name="app_title" size="50" value="';
echo clean_output($this->getDataString('app_title')) . '" class="search_form_txt" />';
echo "</td></tr>\n";
echo "<!-- Appointment type -->\n\t\t<tr><td>";
echo _T('app_input_type');
echo "</td><td>";
echo '<select ' . $dis . ' name="app_type" size="1" class="sel_frm">';
global $system_kwg;
if ($_SESSION['fu_app_data']['type']) {
$default_app = $_SESSION['fu_app_data']['type'];
} else {
$app_kwg = get_kwg_from_name('appointments');
$default_app = $app_kwg['suggest'];
}
$opts = array();
foreach ($system_kwg['appointments']['keywords'] as $kw) {
$opts[$kw['name']] = _T(remove_number_prefix($kw['title']));
}
asort($opts);
foreach ($opts as $k => $opt) {
$sel = isSelected($k == $default_app);
echo "<option value='{$k}'{$sel}>{$opt}</option>\n";
}
echo '</select>';
echo "</td></tr>\n";
echo "<!-- Appointment description -->\n";
echo "<tr><td valign=\"top\">";
echo _T('app_input_description');
echo "</td><td>";
echo '<textarea ' . $dis . ' name="app_description" rows="5" cols="60" class="frm_tarea">';
echo clean_output($this->getDataString('app_description'));
echo '</textarea>';
echo "</td></tr>\n";
echo "</table>\n";
echo "</div>\n";
}
}
function slctacc($_GET)
{
foreach ($_GET as $key => $value) {
${$key} = $value;
}
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($supid, "num", 1, 50, "Invalid supplier id.");
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class=err>-" . $e["msg"] . "<br>";
}
return $confirm;
}
$refnum = getrefnum();
/*refnum*/
# Select supplier
db_connect();
$sql = "SELECT * FROM suppliers WHERE supid = '{$supid}' AND div = '" . USER_DIV . "'";
$suppRslt = db_exec($sql) or errDie("Unable to access databse.", SELF);
if (pg_numrows($suppRslt) < 1) {
return "<li> Invalid supplier ID.";
} else {
$supp = pg_fetch_array($suppRslt);
}
# Accounts drop down
core_connect();
$accounts = "<select name=accid>";
$sql = "SELECT * FROM accounts WHERE div = '" . USER_DIV . "' ORDER BY accname ASC";
$accRslt = db_exec($sql);
if (pg_numrows($accRslt) < 1) {
return "<li>There are No accounts in Cubit.";
}
while ($acc = pg_fetch_array($accRslt)) {
$sel = "";
if (isset($cacc)) {
if ($cacc == $acc['accid']) {
$sel = "selected";
}
}
# Check Disable
if (isDisabled($acc['accid'])) {
continue;
}
$accounts .= "<option value='{$acc['accid']}' {$sel}>{$acc['accname']}</option>";
}
$accounts .= "</select>";
# get entry type
$entd = "";
$entc = "checked=yes";
if (isset($tran)) {
if ($tran == "dt") {
$entd = "checked=yes";
$entc = "";
}
}
// Accounts (debit)
$view = "<h3> Journal transaction </h3>\n\t<form action='" . SELF . "' method=post name=form>\n\t<input type=hidden name=key value=details>\n\t<input type=hidden name=supid value='{$supid}'>\n\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\n\t\t<tr><th>Field</th><th>Value</th></tr>\n\t\t<tr class='bg-odd'><td>Supplier Number</td><td>{$supp['supno']}</td></tr>\n\t\t<tr class='bg-even'><td>Supplier</td><td>{$supp['supname']}</td></tr>\n\t\t<tr class='bg-odd'><td>Date</td><td>" . mkDateSelect("date") . "</td></tr>\n\t\t<tr class='bg-even'><td>Reference Number</td><td><input type=text size=10 name=refnum value='" . $refnum++ . "'></td></tr>\n\t\t<tr class='bg-odd'><td>Entry Type</td><td><input type=radio name=entry value=DT {$entd}> Debit | <input type=radio name=entry value=CT {$entc}>Credit</td></tr>\n\t\t<tr class='bg-even'><td rowspan=2>Contra Account</td><td>{$accounts} <input name=details type=submit value='Enter Details'></td></tr>\n\t\t<tr class='bg-odd'><!-- Rowspan --><td><input type=text name=accnum size=20> <input type=submit value='Enter Details'></td></tr>\n\t</table>\n\t<p>\n\t<input type=button value='Go Back' onClick='javascript:history.back();'>\n\t</form>\n\t<table border=0 cellpadding='2' cellspacing='1' width=15%>\n\t\t<tr><th>Quick Links</th></tr>\n\t\t<tr class=datacell><td align=center><a href='trans-new.php'>Journal Transactions</td></tr>\n\t\t<tr class='bg-odd'><td align=center><a href='../supp-view.php'>View Suppliers</a></td></tr>\n\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t</table>";
return $view;
}
}
$recpage = 10;
//jumlah data per halaman
$aksi = 'tampil';
$subaksi = '';
$obj = new pagination_class($sql, $starting, $recpage, $aksi, $subaksi);
$result = $obj->result;
$jum = mysql_num_rows($result);
$out = '';
if ($jum != 0) {
while ($res = mysql_fetch_assoc($result)) {
$btn = '<td align="center">
<button ' . isDisabled($mnu, 'u') . ' data-hint="ubah" class="button" onclick="viewFR(' . $res['id_modul'] . ');">
<i class="icon-pencil on-left"></i>
</button>
<button ' . isDisabled($mnu, 'd') . ' data-hint="hapus" class="button" onclick="del(' . $res['id_modul'] . ');">
<i class="icon-remove on-left"></i>
</td>';
$out .= '<tr>
<td>' . $res['grupmodul'] . '</td>
<td>' . $res['modul'] . '</td>
<td>' . $res['link'] . '</td>
<td><button class="bg-' . $res['warna'] . '"></button> ' . $res['warna'] . '</td>
<td><i class="icon-' . $res['icon'] . '"></i> ' . $res['icon'] . '</td>
<td>' . $res['size'] . '</td>
' . $btn . '
</tr>';
}
} else {
#kosong
$out .= '<tr align="center">
function get_setting_info($_POST, $err = "")
{
extract($_POST);
db_connect();
$get_settings = "SELECT * FROM credit_note_accounts ORDER BY accid";
$run_settings = db_exec($get_settings) or errDie("Unable to get credit note information.");
if (pg_numrows($run_settings) < 1) {
$accs = array();
} else {
$accs = array();
while ($arr = pg_fetch_array($run_settings)) {
$accs[] = $arr['accid'];
}
}
if (!isset($sortmethod)) {
$sortmethod = "nameacc";
}
if (!isset($vatacc)) {
$vatacc = getCSetting("CRED_NOTE_VAT_ACC");
}
if (!isset($vatacc) or strlen($vatacc) < 1) {
$vatacc = 0;
}
$sel1 = "";
$sel2 = "";
if ($sortmethod == "accname") {
$sel2 = "checked='yes'";
$sqlfilter = "ORDER BY topacc,accnum";
} else {
$sel1 = "checked='yes'";
$sqlfilter = "ORDER BY accname,topacc";
}
db_conn("core");
$get_accs = "SELECT * FROM accounts {$sqlfilter}";
$run_accs = db_exec($get_accs) or errDie("Unable to get accounts information");
if (pg_numrows($run_accs) < 1) {
return "<li class='err'>No Accounts Found. Please Add At Least One Account First.</li>";
}
$account_listing = "";
while ($acc_arr = pg_fetch_array($run_accs)) {
$show = "";
if (in_array($acc_arr['accid'], $accs)) {
$show = "checked='yes'";
}
if ($sortmethod == "accname") {
$show_acc = "{$acc_arr['topacc']}/{$acc_arr['accnum']} - {$acc_arr['accname']}";
} else {
$show_acc = "{$acc_arr['accname']} - {$acc_arr['topacc']}/{$acc_arr['accnum']}";
}
$account_listing .= "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>{$show_acc}</td>\n\t\t\t\t<td><input type='checkbox' name='show_account[{$acc_arr['accid']}]' value='yes' {$show}></td>\n\t\t\t</tr>";
}
$get_vaccs = "SELECT accid,accname,topacc,accnum FROM accounts ORDER BY accname";
$run_vaccs = db_exec($get_vaccs) or errDie("Unable to get vat account information.");
if (pg_numrows($run_vaccs) < 1) {
$vataccdrop = "<input type='hidden' name='' value=''>";
} else {
$vataccdrop = "<select name='vatacc'>";
while ($aarr = pg_fetch_array($run_vaccs)) {
if (isDisabled($aarr['accid'])) {
continue;
}
if ($vatacc == $aarr['accid']) {
$vataccdrop .= "<option value='{$aarr['accid']}' selected>{$aarr['topacc']}/{$aarr['accnum']} - {$aarr['accname']}</option>";
} else {
$vataccdrop .= "<option value='{$aarr['accid']}'>{$aarr['topacc']}/{$aarr['accnum']} - {$aarr['accname']}</option>";
}
}
$vataccdrop .= "</select>";
}
$display = "\n\t\t<h2>Select Accounts To Display On General Credit Note</h2>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t{$err}\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<th>Select Account To Use As VAT Account</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>{$vataccdrop}</td>\n\t\t\t</tr>\n\t\t\t" . TBL_BR . "\n\t\t\t<tr>\n\t\t\t\t<td><input align='right' type='button' onClick=\"window.open('../core/acc-new2.php?update_parent=yes','accounts','width=700, height=400');\" value='New Account'></td>\n\t\t\t</tr>\n\t\t\t" . TBL_BR . "\n\t\t\t<tr>\n\t\t\t\t<th>Sort By</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td><input type='radio' name='sortmethod' value='nameacc' {$sel1} onChange='document.form.submit();'> Account Name - Account Number</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td><input type='radio' name='sortmethod' value='accname' {$sel2} onChange='document.form.submit();'> Account Number - Account Name</td>\n\t\t\t</tr>\n\t\t\t" . TBL_BR . "\n\t\t\t<tr>\n\t\t\t\t<th>Accounts</th>\n\t\t\t\t<th>Show</th>\n\t\t\t</tr>\n\t\t\t{$account_listing}\n\t\t\t" . TBL_BR . "\n\t\t\t<tr>\n\t\t\t\t<td colspan='2' align='right'><input type='submit' value='Accept'></td>\n\t\t\t</tr>\n\t\t</form>\n\t\t</table>";
return $display;
}
if ($i == $res['urutan']) {
$nox .= '<option selected="selected" value="' . $i . '">' . $i . '</option>';
} else {
$nox .= '<option value="' . $i . '">' . $i . '</option>';
}
}
$nox .= '</select></span>';
// <button data-hint="detail" onclick="viewFR(\'aksi\','.$res['id_'.$mnu].');">
$btn = '<td align="center">
<button ' . isDisabled($mnu, 'u') . ' data-hint="detail" onclick="viewFR(\'levelaksi\',' . $res['id_' . $mnu] . ');">
<i class="icon-zoom-in"></i>
</button>
<button ' . isDisabled($mnu, 'u') . ' data-hint="ubah" onclick="viewFR(\'level\',' . $res['id_' . $mnu] . ');">
<i class="icon-pencil"></i>
</button>
<button ' . isDisabled($mnu, 'd') . ' data-hint="hapus" onclick="del(' . $res['id_' . $mnu] . ');">
<i class="icon-remove"></i>
</button>
</td>';
$out .= '<tr>
<td align="center">' . $nox . '</td>
<td align="center">' . $res['level'] . '</td>
<td align="center">' . $res['keterangan'] . '</td>
' . $btn . '
</tr>';
$nox++;
}
} else {
#kosong
$out .= '<tr align="center">
<td colspan=9 ><span style="color:red;text-align:center;">
<?php
$mnu = 'modul';
isMenu($modul, $mnu);
?>
<script src="controllers/c_modul.js"></script>
<script src="js/metro/metro-button-set.js"></script>
<script src="js/metro/metro-hint.js"></script>
<nav class="breadcrumbs">
<ul>
<button <?php
echo isDisabled($mnu, 'c');
?>
class="place-left" data-hint="Tambah Data" id="tambahBC"><span class="icon-plus-2"></span> </button>
<li><a href="grup-modul">Grup Modul</a></li>
<li class="active"><a href="#"><b>Modul</b></a></li>
<li><a href="grup-menu">Grup Menu</a></li>
<li><a href="menu">Menu</a></li>
</ul>
</nav>
<table class="table hovered bordered striped">
<thead>
<tr style="color:white;"class="info">
<th class="text-center">Grup Modul</th>
<th class="text-center">Modul</th>
<th class="text-center">Link</th>
<th class="text-center">warna</th>
<th class="text-center">icon</th>
<script src="controllers/c_level.js"></script>
<script src="../js/metro/metro-button-set.js"></script>
<script src="../js/metro/metro-hint.js"></script>
<h4 style="color:white;">Level</h4>
<div id="loadarea"></div>
<button <?php
isDisabled('level', 'c');
?>
data-hint="Tambah Data" xclass="large" id="tambahBC"><span class="icon-plus-2"></span> </button>
<button <?php
isDisabled('level', 's');
?>
data-hint="Field Pencarian" xclass="large" id="cariBC"><span class="icon-search"></span> </button>
<table class="table hovered bordered striped">
<thead>
<tr style="color:white;"class="info">
<th class="text-center">No.</th>
<th class="text-center">level </th>
<th class="text-center">keterangan</th>
<th class="text-center">Aksi</th>
</tr>
<tr style="display:none;" id="cariTR" class="selected">
<th class="text-center"></th>
<th class="text-center"><input placeholder="level" id="levelS" name="levelS"></th>
<th class="text-center"><input placeholder="keterangan" id="keteranganS" name="keteranganS"></th>
<th class="text-center"></th>
</tr>
</thead>
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 Purchase number.");
if (isset($ctyp) && $ctyp == 's') {
$v->isOk($supid, "num", 1, 20, "Invalid supplier account number.");
} elseif (isset($ctyp) && $ctyp == 'c') {
$v->isOk($deptid, "num", 1, 20, "Invalid Department.");
}
# display errors, if any
if ($v->isError()) {
$errors = $v->getErrors();
foreach ($errors as $e) {
$error .= "<li class='err'>" . $e["msg"] . "</li>";
}
return slct($_POST, $error);
$confirm = "{$error}<p><input type='button' onClick='JavaScript:history.back();' value='« Correct submission'>";
return $confirm;
}
# Get purchase info
db_connect();
$sql = "SELECT * FROM nons_purchases WHERE purid = '{$purid}' AND div = '" . USER_DIV . "'";
$purRslt = db_exec($sql) or errDie("Unable to get purchase information");
if (pg_numrows($purRslt) < 1) {
return "<li class='err'>purchase Not Found</li>";
}
$pur = pg_fetch_array($purRslt);
# check if purchase has been printed
if ($pur['received'] == "y") {
$error = "<li class='err'> Error : purchase number <b>{$purid}</b> has already been received.</li>";
$error .= "<p><input type='button' onClick='JavaScript:history.back();' value='« Correct submission'>";
return $error;
}
/* --- Start Drop Downs --- */
# days drop downs
$days = array("30" => "30", "60" => "60", "90" => "90", "120" => "120");
$termssel = extlib_cpsel("terms", $days, $pur['terms']);
# format date
list($p_year, $p_month, $p_day) = explode("-", $pur['pdate']);
$supacc = "<select name='supacc'>";
core_connect();
$sql = "SELECT * FROM accounts WHERE div = '" . USER_DIV . "' ORDER BY accname ASC";
$accRslt = db_exec($sql);
if (pg_numrows($accRslt) < 1) {
return "<li>There are No accounts in Cubit.</li>";
}
while ($acc = pg_fetch_array($accRslt)) {
# Check Disable
if (isDisabled($acc['accid'])) {
continue;
}
$supacc .= "<option value='{$acc['accid']}'>{$acc['topacc']}/{$acc['accnum']} - {$acc['accname']}</option>";
}
$supacc .= "</select>";
# Get selected supplier info
db_connect();
$hide = "";
if (isset($ctyp) && $ctyp == 's') {
$sql = "SELECT * FROM suppliers WHERE supid = '{$supid}' AND div = '" . USER_DIV . "'";
$supRslt = db_exec($sql) or errDie("Unable to get supplier");
if (pg_numrows($supRslt) < 1) {
$error = "<li class='err'> Supplier not Found.</li>";
$confirm .= "{$error}<p><input type='button' onClick='JavaScript:history.back();' value='« Correct submission'>";
return $confirm;
} else {
$sup = pg_fetch_array($supRslt);
$pur['supplier'] = $sup['supname'];
$pur['supaddr'] = $sup['supaddr'];
$supacc = $sup['supno'];
$hide = "<input type='hidden' name='supid' value='{$supid}'><input type='hidden' name='ctyp' value='{$ctyp}'>";
}
} elseif (isset($ctyp) && $ctyp == 'c') {
db_conn("exten");
$sql = "SELECT * FROM departments WHERE deptid = '{$deptid}'";
$deptRslt = db_exec($sql) or errDie("Unable to view customers");
if (pg_numrows($deptRslt) < 1) {
$error = "<li class='err'> Department not Found.</li>";
$confirm .= "{$error}<p><input type='button' onClick='JavaScript:history.back();' value='« Correct submission'>";
return $confirm;
} else {
$dept = pg_fetch_array($deptRslt);
$supacc = "{$dept['deptname']} - Cash on Hand";
$hide = "<input type='hidden' name='deptid' value='{$deptid}'><input type='hidden' name='ctyp' value='{$ctyp}'>";
}
} elseif (isset($ctyp) && $ctyp == 'p') {
core_connect();
# Get Petty cash account
$cashacc = gethook("accnum", "bankacc", "name", "Petty Cash");
# Get account name for thy lame User's Sake
$accRslt = get("core", "*", "accounts", "accid", $cashacc);
if (pg_numrows($accRslt) < 1) {
return "<li class='err'> Petty Cash Account not found.</li>";
}
$acc = pg_fetch_array($accRslt);
$supacc = "{$acc['topacc']}/{$acc['accnum']} - {$acc['accname']}";
$hide = "<input type='hidden' name='supacc' value='{$cashacc}'><input type='hidden' name='ctyp' value='{$ctyp}'>";
}
/* --- End Drop Downs --- */
/* --- Start Products Display --- */
# select all products
$products = "\n\t\t<table " . TMPL_tblDflts . " width='100%'>\n\t\t\t<tr>\n\t\t\t\t<th>ITEM NUMBER</th>\n\t\t\t\t<th>DESCRIPTION</th>\n\t\t\t\t<th>QTY RECEIVED</th>\n\t\t\t\t<th>UNIT PRICE</th>\n\t\t\t\t<th>DELIVERY DATE</th>\n\t\t\t\t<th>AMOUNT</th>\n\t\t\t<tr>";
# get selected stock in this purchase
db_connect();
$sql = "SELECT *, (qty - rqty) as qty FROM nons_pur_items WHERE purid = '{$purid}' AND (qty - rqty) > 0 AND div = '" . USER_DIV . "'";
$stkdRslt = db_exec($sql);
$i = 0;
$key = 0;
while ($stkd = pg_fetch_array($stkdRslt)) {
# keep track of selected stock amounts
$amts[$i] = $stkd['amt'];
$i++;
list($syear, $smon, $sday) = explode("-", $stkd['ddate']);
# put in product
$products .= "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td><input type='hidden' size='4' name='cod[]' value='{$stkd['cod']}'>{$stkd['cod']}</td>\n\t\t\t\t<td>{$stkd['des']}</td>\n\t\t\t\t<td><input type='hidden' name='qts[]' value='{$stkd['qty']}'><input type='text' size='5' name='qtys[]' value='{$stkd['qty']}'></td>\n\t\t\t\t<td nowrap><input type='hidden' size='4' name='unitcost[]' value='{$stkd['unitcost']}'>" . CUR . " {$stkd['unitcost']}</td>\n\t\t\t\t<td>{$sday}-{$smon}-{$syear}</td>\n\t\t\t\t<td nowrap>" . CUR . " {$stkd['amt']}</td>\n\t\t\t</tr>";
$key++;
}
# look above(if i = 0 then there are no products)
if ($i == 0) {
$done = "";
}
$products .= "</table>";
/* --- End Products Display --- */
/* --- Start Some calculations --- */
# Get subtotal
$SUBTOT = sprint($pur['subtot']);
# Get Total
$TOTAL = sprint($pur['total']);
# Get vat
$VAT = sprint($pur['vat']);
/* --- End Some calculations --- */
/* -- Final Layout -- */
$details = "\n\t\t<center>\n\t\t<h3>Non-Stock Purchase received</h3>\n\t\t<form action='" . SELF . "' method='POST' name='form'>\n\t\t<input type='hidden' name='key' value='update'>\n\t\t<input type='hidden' name='purid' value='{$purid}'>\n\t\t<input type='hidden' name='shipchrg' value='0'>\n\t\t{$hide}\n\t\t<table " . TMPL_tblDflts . " width='95%'>\n\t\t\t<tr>\n\t\t\t\t<td valign='top'>\n\t\t\t\t\t<table " . TMPL_tblDflts . ">\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>Supplier</td>\n\t\t\t\t\t\t\t<td valign='center'>{$pur['supplier']}</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 Address</td>\n\t\t\t\t\t\t\t<td valign='center'><pre>{$pur['supaddr']}</pre></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "' " . ass("Select the account you wish to Credit") . ">\n\t\t\t\t\t\t\t<td>Account</td>\n\t\t\t\t\t\t\t<td>{$supacc}</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 valign='top' align='right'>\n\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th colspan='2'> Non-Stock Purchase 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>Non-Stock Purchase No.</td>\n\t\t\t\t\t\t\t<td valign='center'>{$pur['purnum']}</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>Delivery Ref No.</td>\n\t\t\t\t\t\t\t<td valign='center'><input type='text' name='refno' size='10' value='{$pur['refno']}'></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>Terms</td>\n\t\t\t\t\t\t\t<td valign='center'>{$pur['terms']} Days</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>Date</td>\n\t\t\t\t\t\t\t<td valign='center'>" . mkDateSelect("p", $p_year, $p_month, $p_day) . "</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>VAT Inclusive</td>\n\t\t\t\t\t\t\t<td valign='center'>{$pur['vatinc']}</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\t<tr><td><br></td></tr>\n\t\t\t<tr>\n\t\t\t\t<td colspan='2'>{$products}</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td>\n\t\t\t\t\t<p>\n\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th width='25%'>Quick Links</th>\n\t\t\t\t\t\t\t<th width='25%'>Remarks</th>\n\t\t\t\t\t\t\t<td rowspan='5' valign='top' width='50%'>{$error}</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 class='" . bg_class() . "'><a href='nons-purchase-new.php'>New purchase</a></td>\n\t\t\t\t\t\t\t<td class='" . bg_class() . "' rowspan='4' align='center' valign='top'><textarea name='remarks' rows='4' cols='20'>{$pur['remarks']}</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><a href='nons-purchase-view.php'>View purchases</a></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t\t\t\t\t</table>\n\t\t\t\t</td>\n\t\t\t\t<td align='right'>\n\t\t\t\t\t<table " . TMPL_tblDflts . " width='80%'>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>SUBTOTAL</td>\n\t\t\t\t\t\t\t<td align='right' nowrap>" . CUR . " {$SUBTOT}</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>VAT @ " . TAX_VAT . " %</td>\n\t\t\t\t\t\t\t<td align='right' nowrap>" . CUR . " {$pur['vat']}</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<th>GRAND TOTAL</th>\n\t\t\t\t\t\t\t<td align='right' nowrap>" . CUR . " {$TOTAL}</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\t<tr>\n\t\t\t\t<td align='right'><input type='submit' name='upBtn' value='Write'></td>\n\t\t\t</tr>\n\t\t</table>\n\t\t</form>\n\t\t</center>";
return $details;
}
<?php
isMenu($modul, 'grupmenu');
?>
<script src="controllers/c_grupmenu.js"></script>
<script src="js/metro/metro-button-set.js"></script>
<script src="js/metro/metro-hint.js"></script>
<nav class="breadcrumbs">
<ul>
<button <?php
echo isDisabled('grupmenu', 'c');
?>
class="place-left" data-hint="Tambah Data" id="tambahBC"><span class="icon-plus-2"></span> </button>
<li><a href="grup-modul">Grup Modul</a></li>
<li><a href="modul">Modul</a></li>
<li class="active"><a href="#"><b>Grup Menu</b></a></li>
<li><a href="menu">Menu</a></li>
</ul>
</nav>
<table class="table hovered bordered striped">
<thead>
<tr style="color:white;"class="info">
<th class="text-center">Grup Modul</th>
<th class="text-center">Modul</th>
<th class="text-center">Grup Menu</th>
<th class="text-center">Kategori</th>
<th class="text-center">Aksi</th>
</tr>
