function slctacc($err = "")
{
extract($_POST);
db_conn(PRD_DB);
if (!isset($refnum)) {
$refnum = getrefnum();
}
// if (empty($jr_year)) {
// explodeDate(false, $jr_year, $jr_month, $jr_day);
// }
if (empty($dtaccid)) {
$dtaccid = false;
}
if (empty($ctaccid)) {
$ctaccid = false;
}
/** REFNUM **/
//Select Account <input align='right' type='button' onClick=\"popupSized('acc-new2.php?update_parent=yes','accounts','700','400');\" value='Add Account'>
if (!isset($yr_day)) {
$trans_date_setting = getCSetting("USE_TRANSACTION_DATE");
if (isset($trans_date_setting) and $trans_date_setting == "yes") {
$trans_date_value = getCSetting("TRANSACTION_DATE");
$date_arr = explode("-", $trans_date_value);
$jr_year = $date_arr[0];
$jr_month = $date_arr[1];
$jr_day = $date_arr[2];
} else {
$jr_year = date("Y");
$jr_month = date("m");
$jr_day = date("d");
}
}
$view = "\n\t\t<center>\n\t\t<h3> Journal transaction </h3>\n\t\t{$err}\n\t\t<form action='" . SELF . "' method='POST' name='form'>\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>Date</td>\n\t\t\t\t<td>" . mkDateSelect("jr", $jr_year, $jr_month, $jr_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" . TBL_BR . "\n\t\t\t<tr>\n\t\t\t\t<td align='center'>\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<td><h4>Debit</h4></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<th>Select Account <input align='right' type='button' onClick=\"window.open('acc-new2.php?update_parent=yes','accounts','width=700, height=400');\" value='New Account'></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 valign='center'>" . mkAccSelect("dtaccid", $dtaccid) . "</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 align='center'>\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<td><h4>Credit</h4></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<th>Select Account <input align='right' type='button' onClick=\"window.open('acc-new2.php?update_parent=yes','accounts','width=700, height=400');\" value='New Account'></th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr bgcolor='" . bgcolorc(0) . "'>\n\t\t\t\t\t\t\t<td valign='center'>" . mkAccSelect("ctaccid", $ctaccid) . "</td>\n\t\t\t\t\t\t\t<td><input name='details' type='submit' value='Enter Details >'></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</table>\n\t\t\t\t</td>\n\t\t\t</tr>\n\t\t</table>\n\t\t<br />\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<td align='center'>\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<td><h4>Debit</h4></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<th>Account number</th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr bgcolor='" . bgcolorc(0) . "'>\n\t\t\t\t\t\t\t<td valign='center'><input type='text' name='dtaccnum' size='20'></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 align='center'>\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<td><h4>Credit</h4></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<th>Account number</th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr bgcolor='" . bgcolorc(0) . "'>\n\t\t\t\t\t\t\t<td valign='center'><input type='text' name='ctaccnum' size='20'></td>\n\t\t\t\t\t\t\t<td><input type='submit' value='Enter Details >'></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</table>\n\t\t\t\t</td>\n\t\t\t</tr>\n\t\t</table>\n\t\t<br />\n\t\t</form>" . mkQuickLinks(ql("../reporting/index-reports.php", "Financials"), ql("../core/acc-new2.php", "Add New Account"), ql("trans-new.php", "Journal Transactions"));
return $view;
}
function get_current_setting()
{
db_connect();
$get_list = "SELECT * FROM non_purchases_account_list";
$run_list = db_exec($get_list) or errDie("Unable to get account lisit information.");
if (pg_numrows($run_list) > 0) {
$account_list = "\n\t\t\t<tr>\n\t\t\t\t<th>Account</th>\n\t\t\t\t<th>Options</th>\n\t\t\t</tr>";
while ($aarr = pg_fetch_array($run_list)) {
$account_list .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>{$aarr['accname']}</td>\n\t\t\t\t\t<td><input type='submit' name='remove[{$aarr['accid']}]' value='Remove'></td>\n\t\t\t\t</tr>";
}
}
$cur_setting = getCsetting("USE_NON_PURCHASES_ACCOUNTS");
$yes_setting = "";
$no_setting = "";
if (!isset($cur_setting) or strlen($cur_setting) < 1) {
$no_setting = "checked='yes'";
} else {
if ($cur_setting == "yes") {
$yes_setting = "checked";
} else {
$no_setting = "checked";
}
}
$display = "\n\t\t<h2>Accounts to Display for Non Stock Purchases</h2>\n\t\t<form action='" . SELF . "' method='POST'>\n\t\t\t<input type='hidden' name='key' value='confirm'>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<th>Use These Accounts Only</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>\n\t\t\t\t\t<input type='radio' name='setting' value='yes' {$yes_setting}> Yes\n\t\t\t\t\t<input type='radio' name='setting' value='no' {$no_setting}> No\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='save' value='Save'></td>\n\t\t\t</tr>\n\t\t</table>\n\t\t<br>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<th colspan='2'>Add Account</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td colspan='2'>" . mkAccSelect("newaccount", $newaccount) . " <input type='submit' name='add' value='Add Account'></td>\n\t\t\t</tr>\n\t\t\t<tr><td><br></td></tr>\n\t\t\t{$account_list}\n\t\t</table>\n\t\t</form>";
return $display;
}
function slctacc($err = "")
{
extract($_POST);
db_conn(PRD_DB);
$refnum = getrefnum();
if (empty($jr_year)) {
explodeDate(false, $jr_year, $jr_month, $jr_day);
}
if (empty($dtaccid)) {
$dtaccid = false;
}
if (empty($ctaccid)) {
$ctaccid = false;
}
/** REFNUM **/
$view = "\n\t\t\t\t<center>\n\t\t\t\t<h3> Journal transaction </h3>\n\t\t\t\t{$err}\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<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>Date</td>\n\t\t\t\t\t\t<td>" . mkDateSelect("jr", $jr_year, $jr_month, $jr_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>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" . TBL_BR . "\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td align='center'>\n\t\t\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t<td><h4>Debit</h4></td>\n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t<th>Select Account</th>\n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t\t\t<td valign='center'>" . mkAccSelect("dtaccid", $dtaccid) . "</td>\n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t</table>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td align='center'>\n\t\t\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t<td><h4>Credit</h4></td>\n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t<th>Select Account</th>\n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t<tr bgcolor='" . bgcolorc(0) . "'>\n\t\t\t\t\t\t\t\t\t<td valign='center'>" . mkAccSelect("ctaccid", $ctaccid) . "</td>\n\t\t\t\t\t\t\t\t\t<td><input name='details' type='submit' value='Enter Details >'></td>\n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t</table>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table>\n\t\t\t\t<br />\n\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td align='center'>\n\t\t\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t<td><h4>Debit</h4></td>\n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t<th>Account number</th>\n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t<tr bgcolor='" . bgcolorc(0) . "'>\n\t\t\t\t\t\t\t\t\t<td valign='center'><input type='text' name='dtaccnum' size='20'></td>\n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t</table>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td align='center'>\n\t\t\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t<td><h4>Credit</h4></td>\n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t<th>Account number</th>\n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t<tr bgcolor='" . bgcolorc(0) . "'>\n\t\t\t\t\t\t\t\t\t<td valign='center'><input type='text' name='ctaccnum' size='20'></td>\n\t\t\t\t\t\t\t\t\t<td><input type='submit' value='Enter Details >'></td>\n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t</table>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table>\n\t\t\t\t<br />\n\t\t\t\t</form>" . mkQuickLinks(ql("../reporting/index-reports.php", "Financials"), ql("../core/acc-new2.php", "Add New Account"), ql("../core/trans-new.php", "Journal Transactions"));
return $view;
}
function slctAcc()
{
core_connect();
$accnts = mkAccSelect("accid", 1, ACCTYPE_B);
// $sql = "SELECT * FROM accounts WHERE acctype ='B' AND div = '".USER_DIV."'";
// $accRslt = db_exec($sql);
// if(pg_numrows($accRslt) < 1){
// return "<li> ERROR : There are no accounts in the category selected.";
// }
// $accnts = "<select name='accid'>";
// while($acc = pg_fetch_array($accRslt)){
// # Check Disable
// if(isDisabled($acc['accid']))
// continue;
// $accnts .= "<option value='$acc[accid]'>$acc[accname]</option>";
// }
// $accnts .= "</select>";
// Layout
$slctAcc = "\n\t\t<h3>Set Petty Cash Account</h3>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t<form action='" . SELF . "' method='POST' name='form'>\n\t\t\t<input type='hidden' name='key' value='confirm'>\n\t\t\t<tr>\n\t\t\t\t<th colspan='2'>Select Account <input align='right' type='button' onClick=\"window.open('../core/acc-new2.php?update_parent=yes','accounts','width=700, height=400');\" value='New Account'></th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td colspan='2'>{$accnts}</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='Set Account »'></td>\n\t\t\t</tr>\n\t\t</table>\n\t\t</form>\n\t\t<p>\n\t\t<table " . TMPL_tblDflts . " width='100'>\n\t\t\t<tr>\n\t\t\t\t<th>Quick Links</th>\n\t\t\t</tr>\n\t\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t\t</table>";
return $slctAcc;
}
function add($_POST)
{
# Get vars
extract($_POST);
if (!isset($lnum)) {
$lnum = 1;
}
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($lnum, "num", 1, 30, "Invalid Number of ledger accounts.");
# 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;
}
$jump_bot = "";
if (isset($another)) {
$jump_bot = "\n\t\t\t<script>\n\t\t\t\twindow.location.hash='bottom';\n\t\t\t</script>";
$lnum++;
}
db_connect();
# bank accounts to choose from
$sql = "SELECT * FROM bankacct WHERE btype != 'int' AND div = '" . USER_DIV . "' ORDER BY accname ASC";
$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 (isset($bankid) and $bankid == $bank['bankid']) {
$banks .= "<option value='{$bank['bankid']}' selected>{$bank['accname']} - {$bank['bankname']} ({$bank['acctype']})</option>";
} else {
$banks .= "<option value='{$bank['bankid']}'>{$bank['accname']} - {$bank['bankname']} ({$bank['acctype']})</option>";
}
}
$banks .= "</select>";
# compose accounts list
$accounts = "";
for ($i = 0; $i < $lnum; $i++) {
if (!isset($accinv[$i])) {
$accinv[$i] = 0;
$accamt[$i] = 0;
$vatcode[$i] = 0;
$chrgvat[$i] = 'nov';
}
switch ($chrgvat[$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;
}
$glacc = mkAccSelect("accinv[]", $accinv[$i]);
# Accounts Drop down selections
// core_connect();
//
// $sql = "SELECT * FROM accounts WHERE div = '".USER_DIV."' ORDER BY accname";
// $accRslt = db_exec($sql);
// if(pg_numrows($accRslt) < 1){
// $glacc = "<li>There are no Income accounts yet in Cubit.</li>";
// }
// $glacc = "<select name='accinv[]' style='width: 167'>";
// while($acc = pg_fetch_array($accRslt)){
// # Check Disable
// if(isDisabled($acc['accid']))
// continue;
// $sel = ($acc['accid'] == $accinv[$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("Unable to get vat codes");
$Vatcodes = "<select name='vatcode[{$i}]'>";
while ($vd = pg_fetch_array($Ri)) {
if ($vatcode[$i] == $vd['id']) {
$sel = "selected";
} else {
if ($vd['del'] == "Yes" and strlen($vatcode[$i]) < 1) {
$sel = "selected";
} else {
$sel = "";
}
}
$Vatcodes .= "<option value='{$vd['id']}' {$sel}>{$vd['code']}</option>";
}
$Vatcodes .= "</select>";
$accounts .= "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>{$glacc}</td>\n\t\t\t\t<td align='center'>" . CUR . " <input type='text' size='8' name='accamt[]' value='{$accamt[$i]}'></td>\n\t\t\t\t<td>{$Vatcodes}</td>\n\t\t\t\t<td>\n\t\t\t\t\t<input type='radio' name='chrgvat[{$i}]' value='inc' {$chinc}>Inclusive \n\t\t\t\t\t<input type='radio' name='chrgvat[{$i}]' value='exc' {$chexc}>Exclusive \n\t\t\t\t\t<input type='radio' name='chrgvat[{$i}]' value='nov' {$chnov}>No VAT\n\t\t\t\t</td>\n\t\t\t</tr>";
}
$accounts .= "\n\t\t<tr class='" . bg_class() . "'>\n\t\t\t<td align='right'><b>Total:</b></td>\n\t\t\t<td align='right'>" . CUR . " " . sprint(array_sum($accamt)) . "</td>\n\t\t\t<td colspan='2'></td>\n\t\t</tr>";
# error control
if (!isset($errata)) {
$errata = "";
}
if (!isset($name)) {
$name = "";
$descript = "";
$cheqnum = "";
$reference = "";
}
if (!isset($date_day)) {
$trans_date_setting = getCSetting("USE_TRANSACTION_DATE");
if (isset($trans_date_setting) and $trans_date_setting == "yes") {
$trans_date_value = getCSetting("TRANSACTION_DATE");
$date_arr = explode("-", $trans_date_value);
$date_year = $date_arr[0];
$date_month = $date_arr[1];
$date_day = $date_arr[2];
} else {
if (isset($_SESSION["global_day"]) and strlen($_SESSION["global_day"]) > 0) {
$date_day = $_SESSION["global_day"];
} else {
$date_day = date("d");
}
if (isset($_SESSION["global_month"]) and strlen($_SESSION["global_month"]) > 0) {
$date_month = $_SESSION["global_month"];
} else {
$date_month = date("m");
}
if (isset($_SESSION["global_year"]) and strlen($_SESSION["global_year"]) > 0) {
$date_year = $_SESSION["global_year"];
} else {
$date_year = date("Y");
}
}
}
// Layout
$add = "\n\t\t<h3>New Bank Receipt</h3>\n\t\t{$errata}\n\t\t<table " . TMPL_tblDflts . ">\n\t\t<form action='" . SELF . "' method='POST' name='form'>\n\t\t\t<input type='hidden' name='key' value='confirm'>\n\t\t\t<input type='hidden' name='lnum' value='{$lnum}'>\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>Bank Account</td>\n\t\t\t\t<td>{$banks}</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("date", $date_year, $date_month, $date_day) . "</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Received from</td>\n\t\t\t\t<td valign='center'><input size='20' name='name' value='{$name}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Description</td>\n\t\t\t\t<td valign='center'><textarea col='20' rows='5' name='descript'>{$descript}</textarea></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Reference</td>\n\t\t\t\t<td valign='center'><input size='25' name='reference' value='{$reference}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Cheque Number</td>\n\t\t\t\t<td valign='center'><input size='20' name='cheqnum' value='{$cheqnum}'></td>\n\t\t\t</tr>\n\t\t\t<tr><td><br></td></tr>\n\t\t</table>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<th>Account <input align='right' type='button' onClick=\"window.open('../core/acc-new2.php?update_parent=yes','accounts','width=700, height=400');\" value='New Account'></th>\n\t\t\t\t<th>Amount</th>\n\t\t\t\t<th>Vat Code</th>\n\t\t\t\t<th>VAT</th>\n\t\t\t</tr>\n\t\t\t{$accounts}\n\t\t\t<tr><td><br></td></tr>\n\t\t\t<tr>\n\t\t\t\t<td><input type='submit' name='another' value='Add Another'></td>\n\t\t\t\t<td valign='center' align='right'><input type='submit' value='Confirm »'></td>\n\t\t\t</tr>\n\t\t</table>\n\t\t<p>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<th>Quick Links</th>\n\t\t\t</tr>\n\t\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t\t</table>\n\t\t<a name='bottom'>\n\t\t{$jump_bot}";
return $add;
}
function confirm($_POST)
{
# get vars
extract($_POST);
if (!isset($qty)) {
$qty = "1";
}
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($grpid, "num", 1, 50, "Invalid Asset Group id.");
$v->isOk($type_id, "num", 1, 50, "Invalid Type id.");
$v->isOk($qty, "num", 0, 10, "Invalid quantity.");
$v->isOk($serial, "string", 0, 20, "Invalid Serial[1] Number.");
$v->isOk($serial2, "string", 0, 30, "Invalid Serial[2] Number.");
$v->isOk($locat, "string", 1, 100, "Invalid location.");
$v->isOk($des, "string", 1, 255, "Invalid description.");
$v->isOk($details, "string", 0, 255, "Invalid Details.");
$v->isOk($units, "num", 1, 10, "Invalid units");
$v->isOk($amount, "float", 1, 255, "Invalid amount.");
$v->isOk($date_day, "num", 1, 2, "Invalid Date day.");
$v->isOk($date_month, "num", 1, 2, "Invalid Date month.");
$v->isOk($date_year, "num", 4, 4, "Invalid Date Year.");
$v->isOk($method, "string", 1, 255, "Invalid method.");
$v->isOk($dep_perc, "float", 1, 16, "Invalid Yearly Depreciation Percentage.");
$v->isOk($svdate_day, "num", 1, 2, "Invalid Next Service Date (day)");
$v->isOk($svdate_month, "num", 1, 2, "Invalid Next Service Date (month)");
$v->isOk($svdate_year, "num", 4, 4, "Invalid Next Service Date (year)");
/*
$v->isOk($cost_acc, "num", 1, 9, "Invalid cost account selection.");
$v->isOk($accdep_acc, "num", 1, 9, "Invalid accumulated depreciation account selection.");
$v->isOk($dep_acc, "num", 1, 9, "Invalid depreciation account selection.");
*/
if ($seryn == "yes" && empty($serial)) {
$v->addError("", "Serial field requires a value.");
} else {
if ($seryn == "no" && empty($qty)) {
$v->addError("", "Quantity field requires a value.");
}
}
if ($seryn == "yes") {
// Check for duplicate serials
if (!empty($serial)) {
$sql = "SELECT serial FROM cubit.assets WHERE serial='{$serial}'";
$dupser1_rslt = db_exec($sql) or errDie("Unable to retrieve asset serial.");
if (pg_num_rows($dupser1_rslt)) {
$v->addError(0, "First serial already exists in the system.");
}
}
if (!empty($serial2)) {
$sql = "SELECT serial2 FROM cubit.assets WHERE serial2='{$serial2}'";
$dupser2_rslt = db_exec($sql) or errDie("Unable to retrieve asset serial.");
if (pg_num_rows($dupser2_rslt)) {
$v->addError(0, "Second serial already exists in the system.");
}
}
}
/*
// Retrieve cost account
$sql = "
SELECT accid, topacc, accnum, accname FROM core.accounts
WHERE accid='$cost_acc'";
$cost_acc_rslt = db_exec($sql) or errDie("Unable to retrieve account.");
$cost_acc_data = pg_fetch_array($cost_acc_rslt);
// Retrieve Accumulated Depreciation
$sql = "
SELECT accid, topacc, accnum, accname FROM core.accounts
WHERE accid='$accdep_acc'";
$accdep_acc_rslt = db_exec($sql) or errDie("Unable to retrieve account.");
$accdep_acc_data = pg_fetch_array($accdep_acc_rslt);
// Retrieve Depreciation
$sql = "
SELECT accid, topacc, accnum, accname FROM core.accounts
WHERE accid='$dep_acc'";
$dep_acc_rslt = db_exec($sql) or errDie("Unable to retrieve account.");
$dep_acc_data = pg_fetch_array($dep_acc_rslt);
*/
# mix dates
$date = "{$date_day}-{$date_month}-{$date_year}";
// Service Date
$svdate = "{$svdate_day}-{$svdate_month}-{$svdate_year}";
if (!checkdate($date_month, $date_day, $date_year)) {
$v->isOk($date, "num", 1, 1, "Invalid date.");
}
if (!checkdate($svdate_month, $svdate_day, $svdate_year)) {
$v->isOk($svdate, "num", 1, 1, "Invalid Next Service Date.");
}
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class='err'>{$e['msg']}</li>";
}
return enter($confirm);
exit;
}
# Get group
db_connect();
$sql = "SELECT * FROM assetgrp WHERE grpid = '{$grpid}' AND div = '" . USER_DIV . "'";
$grpRslt = db_exec($sql);
$grp = pg_fetch_array($grpRslt);
if (!isset($accnt)) {
$accnt = "";
}
if ($method == 'purch') {
$vmethod = "Purchase Asset";
$accnt = "";
} else {
$vmethod = "Add Asset";
$accnt = "\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Contra Account <input align='right' type='button' onClick=\"window.open('core/acc-new2.php?update_parent=yes','accounts','width=700, height=400');\" value='New Account'></td>\r\n\t\t\t\t<td>" . mkAccSelect("accnt", $accnt) . "</td>\r\n\t\t\t</tr>";
}
if ($seryn == "yes") {
$serdisp = "\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Serial Number</td>\r\n\t\t\t\t<td><input type='hidden' name='serial' value='{$serial}'>{$serial}</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>2nd Serial Number</td>\r\n\t\t\t\t<td>\r\n\t\t\t\t\t<input type='hidden' name='serial2' value='{$serial2}'>\r\n\t\t\t\t\t{$serial2}\r\n\t\t\t\t</td>\r\n\t\t\t</tr>";
} else {
$serdisp = "\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Quantity</td>\r\n\t\t\t\t<td><input type='hidden' name='qty' value='{$qty}'>{$qty}</td>\r\n\t\t\t</tr>";
}
$sql = "SELECT name FROM cubit.asset_types WHERE id='{$type_id}'";
$at_rslt = db_exec($sql) or errDie("Unable to retrieve asset type.");
$type_name = pg_fetch_result($at_rslt, 0);
$confirm = "\r\n\t\t<h3>Confirm Asset</h3>\r\n\t\t<form action='" . SELF . "' method='POST' enctype='multipart/form-data' name='form'>\r\n\t\t\t<input type='hidden' name='key' value='write'>\r\n\t\t\t<input type='hidden' name='type_id' value='{$type_id}' />" . "\r\n\t<table cellpadding='0' cellspacing='0'>\r\n\t\t<tr valign='top'>\r\n\t\t\t<td>\r\n\t\t\t\t<table " . TMPL_tblDflts . ">\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<th colspan='2'>Asset Details</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>Group</td>\r\n\t\t\t\t\t\t<td><input type='hidden' name='grpid' value='{$grpid}'>{$grp['grpname']}</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>Type</td>\r\n\t\t\t\t\t\t<td>{$type_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>Location</td>\r\n\t\t\t\t\t\t<td><input type='hidden' name='locat' value='{$locat}'>{$locat}</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>Description</td>\r\n\t\t\t\t\t\t<td><input type='hidden' name='des' value='{$des}'>{$des}</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><input type='hidden' name='details' value='{$details}'>" . nl2br($details) . "</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>Billing Requirement Ratio</td>\r\n\t\t\t\t\t\t<td><input type='hidden' name='units' value='{$units}' />{$units}</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>Percentage of Yearly Depreciation</td>\r\n\t\t\t\t\t\t<td>\r\n\t\t\t\t\t\t\t<input type='hidden' name='dep_perc' value='{$dep_perc}' />\r\n\t\t\t\t\t\t\t{$dep_perc}%\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>Auto Monthly Depreciation</td>\r\n\t\t\t\t\t\t<td>\r\n\t\t\t\t\t\t\t<input type='hidden' name='dep_month' value='{$dep_month}' />\r\n\t\t\t\t\t\t\t" . ucfirst($dep_month) . "\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>Method</td>\r\n\t\t\t\t\t\t<td><input type='hidden' name='method' value='{$method}'>{$vmethod}</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t{$accnt}\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<th colspan='2'>Bought</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>\r\n\t\t\t\t\t\t\t<input type='hidden' name='date_year' value='{$date_year}' />\r\n\t\t\t\t\t\t\t<input type='hidden' name='date_month' value='{$date_month}' />\r\n\t\t\t\t\t\t\t<input type='hidden' name='date_day' value='{$date_day}' />\r\n\t\t\t\t\t\t\t{$date}\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>Amount</td>\r\n\t\t\t\t\t\t<td>\r\n\t\t\t\t\t\t\t<input type='hidden' name='amount' value='{$amount}'>" . CUR . " {$amount}\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>" . "\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t<th colspan='2'>Servicing</th>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>Next Service Date</td>\r\n\t\t\t\t\t\t\t<td>\r\n\t\t\t\t\t\t\t\t<input type='hidden' name='svdate_year' value='{$svdate_year}' />\r\n\t\t\t\t\t\t\t\t<input type='hidden' name='svdate_month' value='{$svdate_month}' />\r\n\t\t\t\t\t\t\t\t<input type='hidden' name='svdate_day' value='{$svdate_day}' />\r\n\t\t\t\t\t\t\t\t{$svdate}\r\n\t\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>Service Description</td>\r\n\t\t\t\t\t\t\t<td>\r\n\t\t\t\t\t\t\t\t<input type='hidden' name='sv_desc' value='{$sv_desc}' />\r\n\t\t\t\t\t\t\t\t{$sv_desc}\r\n\t\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t<th colspan='2'>Serial/Quantity</th>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<input type='hidden' name='seryn' value='{$seryn}'>\r\n\t\t\t\t\t\t{$serdisp}\r\n\t\t\t\t\t\t<tr><td><br></td></tr>\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t<th colspan='2'>Add Picture</th>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>Image Name</td>\r\n\t\t\t\t\t\t\t<td><input type='text' size='40' name='picupload_name'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>Image Location</td>\r\n\t\t\t\t\t\t\t<td><input type='file' name='picupload_image'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t<td><input type='submit' name='back' value='« Correction'></td>\r\n\t\t\t\t\t\t\t<td valign='bottom' align='right'><input type='submit' value='Write »'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t</table>\r\n\t\t\t\t</td>\r\n\t\t\t</tr>\r\n\t\t</form>\r\n\t\t</table>\r\n\t\t<p>\r\n\t\t<table border='0' cellpadding='2' cellspacing='1'>\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><a href='asset-view.php'>View Assets</a></td>\r\n\t\t\t</tr>\r\n\t\t\t<script>document.write(getQuicklinkSpecial());</script>\r\n\t\t</table>";
return $confirm;
}
function edit($cashid)
{
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($cashid, "num", 1, 4, "Invalid Petty Cash Requisition ID.");
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class='err'>{$e['msg']}</li>";
}
$confirm .= "<p><input type='button' onClick='JavaScript:history.back();' value='« Correct submission'>";
return $confirm;
}
# Connect to database
db_Connect();
$sql = "SELECT * FROM pettycashbook WHERE cashid = '{$cashid}' AND div = '" . USER_DIV . "'";
$cashRslt = db_exec($sql) or errDie("ERROR: Unable to retrieve cashbook entry details from database.", SELF);
if (pg_numrows($cashRslt) < 1) {
$OUTPUT = "<li class='err'>Requisistion not found in Cubit.</li>";
return $OUTPUT;
}
$cash = pg_fetch_array($cashRslt);
$accnts = mkAccSelect("accid", $cash['accid']);
// 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'] == $cash['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 month='" . (int) date("m") . "' 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>";
}
list($date_year, $date_month, $date_day) = explode("-", $cash['date']);
# Keep the charge vat option stable
if ($cash['chrgvat'] == "inc") {
$chin = "checked=yes";
$chex = "";
$chno = "";
} elseif ($cash['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" || $cash["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<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='{$cash['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'>{$cash['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='{$cash['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 valign='center' align='right' colspan='2'><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 slctacc($_POST, $err = "")
{
# Get vars
extract($_POST);
if (!isset($tnum)) {
$tnum = 1;
}
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($tnum, "num", 1, 3, "Invalid Number of transactions.");
if ($tnum < 1) {
$v->isOk("#error#", "num", 1, 1, " - Number of transactions must be at least one.");
}
# 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;
}
$jump_bot = "";
if (isset($another)) {
$jump_bot = "\n\t\t\t<script>\n\t\t\t\twindow.location.hash='bottom';\n\t\t\t</script>";
$tnum++;
}
if (!isset($refnum)) {
$refnum = getrefnum();
}
/*refnum*/
// Accounts (debit)
$view = "\n\t\t<center>\n\t\t<h3> Journal transactions </h3>\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<input type='hidden' name='vby' value='{$vby}'>\n\t\t\t<input type='hidden' name='tnum' value='{$tnum}'>\n\t\t<table " . TMPL_tblDflts . " align='center'>\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 <input align='right' type='button' onClick=\"window.open('acc-new2.php?update_parent=yes&set_key=slct','accounts','width=700, height=400');\" value='New Account'></th>\n\t\t\t\t<th>Credit <input align='right' type='button' onClick=\"window.open('acc-new2.php?update_parent=yes&set_key=slct','accounts','width=700, height=400');\" value='New Account'></th>\n\t\t\t\t<th>Amount</th>\n\t\t\t\t<th>Description</th>\n\t\t\t</tr>";
for ($i = 0; $i < $tnum; $i++) {
if (!isset($date_day[$i])) {
$trans_date_setting = getCSetting("USE_TRANSACTION_DATE");
if (isset($trans_date_setting) and $trans_date_setting == "yes") {
$trans_date_value = getCSetting("TRANSACTION_DATE");
$date_arr = explode("-", $trans_date_value);
$date_year[$i] = $date_arr[0];
$date_month[$i] = $date_arr[1];
$date_day[$i] = $date_arr[2];
} else {
$date_year[$i] = date("Y");
$date_month[$i] = date("m");
$date_day[$i] = date("d");
}
}
$view .= "\n\t\t\t<tr bgcolor=" . bgcolorg() . ">\n\t\t\t\t<td>" . mkDateSelecta("date", $i, $date_year[$i], $date_month[$i], $date_day[$i]) . "</td>\n\t\t\t\t<td><input type='text' size='5' name='refnum[{$i}]' value='{$refnum[$i]}'></td>\n\t\t\t\t<td valign='center'>";
core_connect();
$sql = "SELECT * FROM accounts WHERE div = '" . USER_DIV . "' ORDER BY {$vby} ASC";
$accRslt = db_exec($sql);
if (pg_numrows($accRslt) < 1) {
return "<li>There are No accounts in Cubit.</li>";
}
$dtaccid[$i] += 0;
$view .= mkAccSelect("dtaccid[{$i}]", $dtaccid[$i]);
$view .= "\n\t\t\t</td>\n\t\t\t<td valign='center'>";
$ctaccid[$i] += 0;
$view .= mkAccSelect("ctaccid[]", $ctaccid[$i]);
if (isset($amount[$i])) {
$a_val = $amount[$i];
} else {
$a_val = "";
}
if (isset($descript[$i])) {
$d_val = $descript[$i];
} else {
$d_val = "";
}
$view .= "\n\t\t\t\t</td>\n\t\t\t\t<td><input type='text' size='7' name='amount[]' value='{$a_val}'></td>\n\t\t\t\t<td><input type='text' size='20' name='descript[]' value='{$d_val}'></td>\n\t\t\t</tr>";
}
$view .= "\n\t\t<tr class='" . bg_class() . "'>\n\t\t\t<td colspan='4' align='right'><b>Total:</b></td>\n\t\t\t<td>" . CUR . " " . sprint(array_sum($amount)) . "</td>\n\t\t\t<td></td>\n\t\t</tr>";
$view .= "\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><input type='submit' name='another' value='Add Another'></td>\n\t\t\t\t<td valign='center' colspan='4' align='right'><input type='submit' value='Confirm »'></td>\n\t\t\t</tr>\n\t\t</form>\n\t\t</table>\n\t\t<a name='bottom'>\n\t\t{$jump_bot}\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<script>document.write(getQuicklinkSpecial());</script>\n\t\t</table>";
return $view;
}
function slctOpt()
{
extract($_POST);
if (!isset($refnum)) {
$refnum = "";
}
if (!isset($descript)) {
$descript = "";
}
if (!isset($numtran)) {
$numtran = "";
}
if (!isset($lname)) {
$lname = "";
}
# accounts drop downs
// core_connect();
//
// $dtacc = "<select name='dtaccid'>";
// $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;
// $dtacc .= "<option value='$acc[accid]'>$acc[topacc]/$acc[accnum] - $acc[accname]</option>";
// }
// $dtacc .= "</select>";
// $ctacc = "<select name='ctaccid'>";
// $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;
// $ctacc .= "<option value='$acc[accid]'>$acc[topacc]/$acc[accnum] - $acc[accname]</option>";
// }
// $ctacc .= "</select>";
// Options Layout
$Opts = "\r\n\t\t<center>\r\n\t\t<h3> New High Speed Input Ledger </h3>\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<table " . TMPL_tblDflts . " align='center'>\r\n\t\t\t<tr>\r\n\t\t\t\t<th colspan='3'>Details</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><input type='text' size='30' name='lname' value='{$lname}'></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<th><h4>Debit</h4></th>\r\n\t\t\t\t<th><h4>Credit</h4></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'>" . mkAccSelect("dtaccid", $dtaccid) . "</td>\r\n\t\t\t\t<td align='center'>" . mkAccSelect("ctaccid", $ctaccid) . "</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td colspan='2' align='center'><input align='right' type='button' onClick=\"window.open('../core/acc-new2.php?update_parent=yes','accounts','width=700, height=400');\" value='New Account'></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<th colspan='3'>Options</th>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Number of Entries</td>\r\n\t\t\t\t<td><input type='text' size='10' name='numtran' value='{$numtran}'></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Date Entry</td>\r\n\t\t\t\t<td><input type='radio' name='dateopt' value='system' checked='yes'>System <input type='radio' name='dateopt' value='user'>User Input</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Charge Vat </td>\r\n\t\t\t\t<td><input type='radio' name='chrgvat' value='yes'>Yes <input type='radio' name='chrgvat' value='no' checked='yes'>No</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<th colspan='3'>Description</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><input type='text' size='30' name='descript' value='{$descript}'></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td rowspan='3' valign='top'>Options</td>\r\n\t\t\t\t<td><input type='radio' name='desopt' value='emp' checked='yes'> Empty Input Box</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td><input type='radio' name='desopt' value='once'> Once Only Setting</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td><input type='radio' name='desopt' value='edit'> Default Editable</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<th colspan='3'>Reference Number</th>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Reference Number</td>\r\n\t\t\t\t<td><input type='text' size='10' name='refnum' value='{$refnum}'></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td rowspan='4' valign='top'>Options</td>\r\n\t\t\t\t<td><input type='radio' name='refopt' value='num' checked='yes'> Auto Number</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td><input type='radio' name=refopt value='emp'> Empty Input Box</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td><input type='radio' name='refopt' value='once'> Once Only Setting</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td><input type='radio' name='refopt' value='edit'> Default Editable Input</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 $Opts;
}
function slctacc()
{
extract($_POST);
if (!isset($refnum)) {
$refnum = getrefnum();
}
/*refnum*/
// if(!isset($date_year)){
// $date_year = date ("Y");
// $date_month = date("m");
// $date_day = date("d");
// }
$dtaccid += 0;
$ctaccid += 0;
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>";
}
$dtaccs = mkAccSelect("dtaccid", $dtaccid);
// $dtaccs = "<select name='dtaccid'>";
// while($acc = pg_fetch_array($accRslt)){
// # Check Disable
// if(isDisabled($acc['accid']))
// continue;
// if (isset($dtaccid) AND $dtaccid == $acc['accid']){
// $dtaccs .= "<option value='$acc[accid]' selected>$acc[topacc]/$acc[accnum] - $acc[accname]</option>";
// }else {
// $dtaccs .= "<option value='$acc[accid]'>$acc[topacc]/$acc[accnum] - $acc[accname]</option>";
// }
// }
// $dtaccs .= "</select>";
// $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>";
// }
//
$ctaccs = mkAccSelect("ctaccid", $ctaccid);
// $ctaccs = "<select name='ctaccid'>";
// while($acc = pg_fetch_array($accRslt)){
// # Check Disable
// if(isDisabled($acc['accid']))
// continue;
// if (isset($ctaccid) AND $ctaccid == $acc['accid']){
// $ctaccs .= "<option value='$acc[accid]' selected>$acc[topacc]/$acc[accnum] - $acc[accname]</option>";
// }else {
// $ctaccs .= "<option value='$acc[accid]'>$acc[topacc]/$acc[accnum] - $acc[accname]</option>";
// }
// }
// $ctaccs .= "</select>";
if (!isset($date_day)) {
$trans_date_setting = getCSetting("USE_TRANSACTION_DATE");
if (isset($trans_date_setting) and $trans_date_setting == "yes") {
$trans_date_value = getCSetting("TRANSACTION_DATE");
$date_arr = explode("-", $trans_date_value);
$date_year = $date_arr[0];
$date_month = $date_arr[1];
$date_day = $date_arr[2];
} else {
$date_year = date("Y");
$date_month = date("m");
$date_day = date("d");
}
}
// Accounts (debit)
$view = "\n\t\t<center>\n\t\t<h3>Add Recurring Transaction</h3>\n\t\t<br><br>\n\t\t<form action='" . SELF . "' method='POST' name='form'>\n\t\t\t<input type='hidden' name='key' value='details'>\n\t\t<table " . TMPL_tblDflts . " align='center'>\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>Date</td>\n\t\t\t\t<td>" . mkDateSelect("date", $date_year, $date_month, $date_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><td><br></td></tr>\n\t\t\t<tr>\n\t\t\t\t<td align='center'>\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<td><h4>Debit</h4></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<th>Select Account <input align='right' type='button' onClick=\"window.open('acc-new2.php?update_parent=yes','accounts','width=700, height=400');\" value='New Account'></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 valign='center'>{$dtaccs}</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 align='center'>\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<td><h4>Credit</h4></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<th>Select Account <input align='right' type='button' onClick=\"window.open('acc-new2.php?update_parent=yes','accounts','width=700, height=400');\" value='New Account'></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 valign='center'>{$ctaccs}</td>\n\t\t\t\t\t\t\t<td><input name='detail' type='submit' value='Enter Details >'></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</table>\n\t\t\t\t</td>\n\t\t\t</tr>\n\t\t</table>\n\t\t<br><br><br>\n\t\t<table " . TMPL_tblDflts . " align='center'>\n\t\t\t<tr>\n\t\t\t\t<td align='center'>\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<td><h4>Debit</h4></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<th>Account number</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 valign='center'><input type='text' name='dtaccnum' size='20'></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 align='center'>\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<td><h4>Credit</h4></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<th>Account number</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 valign='center'><input type='text' name='ctaccnum' size='20'></td>\n\t\t\t\t\t\t\t<td><input type='submit' value='Enter Details >'></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</table>\n\t\t\t\t</td>\n\t\t\t</tr>\n\t\t</table>\n\t\t<br>\n\t\t<input type='button' value='< Go Back' onClick='javascript:history.back();'>\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='rectrans-view.php'>View Recurring Transactions</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\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 $view;
}
function slctacc($_POST, $err = "")
{
extract($_POST);
if (!isset($refnum)) {
$refnum = getrefnum();
}
/*refnum*/
// Accounts (debit)
$view = "\n\t\t<center>\n\t\t<h3>Add Journal transactions to batch </h3>\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<table " . TMPL_tblDflts . " align='center'>\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 <input align='right' type='button' onClick=\"window.open('acc-new2.php?update_parent=yes','accounts','width=700, height=400');\" value='New Account'></th>\n\t\t\t\t<th>Credit <input align='right' type='button' onClick=\"window.open('acc-new2.php?update_parent=yes','accounts','width=700, height=400');\" value='New Account'></th>\n\t\t\t\t<th>Amount</th>\n\t\t\t\t<th>Description</th>\n\t\t\t</tr>";
for ($i = 0; $i != 20; $i++) {
// if (!isset($date_year[$i])){
// $date_year[$i] = date("Y");
// $date_month[$i] = date("m");
// $date_day[$i] = date ("d");
// }
if (!isset($date_year[$i])) {
$trans_date_setting = getCSetting("USE_TRANSACTION_DATE");
if (isset($trans_date_setting) and $trans_date_setting == "yes") {
$trans_date_value = getCSetting("TRANSACTION_DATE");
$date_arr = explode("-", $trans_date_value);
$date_year[$i] = $date_arr[0];
$date_month[$i] = $date_arr[1];
$date_day[$i] = $date_arr[2];
} else {
$date_year[$i] = date("Y");
$date_month[$i] = date("m");
$date_day[$i] = date("d");
}
}
$view .= "\n\t\t\t<tr bgcolor=" . bgcolorg() . ">\n\t\t\t\t<td>" . mkDateSelecta("date", $i, $date_year[$i], $date_month[$i], $date_day[$i]) . "</td>\n\t\t\t\t<td><input type='text' size='5' name='refnum[]' value='{$refnum[$i]}'></td>\n\t\t\t\t<td valign='center'>";
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>";
}
if (isset($dtaccid[$i])) {
$aval = $dtaccid[$i];
} else {
$aval = 0;
}
$view .= mkAccSelect("dtaccid[]", $aval);
// $view .= "<select name='dtaccid[]' style='width: 230'>";
// while($acc = pg_fetch_array($accRslt)){
// # Check Disable
// if(isDisabled($acc['accid']))
// continue;
// if($acc['accid'] == $aval) {
// $sel = "selected";
// } else {
// $sel = "";
// }
// $view .= "<option value='$acc[accid]' $sel>$acc[accname]</option>";
// }
// $view .= "</select>";
$view .= "\n\t\t\t</td>\n\t\t\t<td valign='center'>";
// $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>";
// }
if (isset($ctaccid[$i])) {
$aval = $ctaccid[$i];
} else {
$aval = 0;
}
$view .= mkAccSelect("ctaccid[]", $aval);
// $view .= "<select name='ctaccid[]' style='width: 230'>";
// while($acc = pg_fetch_array($accRslt)){
// # Check Disable
// if(isDisabled($acc['accid']))
// continue;
// if($aval == $acc['accid']) {
// $sel = "selected";
// } else {
// $sel = "";
// }
// $view .= "<option value='$acc[accid]' $sel>$acc[accname]</option>";
// }
// $view .= "</select>";
if (isset($amount[$i])) {
$aval = $amount[$i];
} else {
$aval = "";
}
if (isset($descript[$i])) {
$dval = $descript[$i];
} else {
$dval = "";
}
$view .= "\n\t\t\t\t</td>\n\t\t\t\t<td><input type='text' size='7' name='amount[]' value='{$aval}'></td>\n\t\t\t\t<td><input type='text' size='20' name='descript[]' value='{$dval}'></td>\n\t\t\t</tr>";
}
$view .= "\n\t\t\t<tr>\n\t\t\t\t<td></td>\n\t\t\t\t<td valign='center' colspan='4' align='right'><input type='submit' value='Confirm »'></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='batch-view.php'>View batch Entries</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 Transaction</td>\n\t\t\t</tr>\n\t\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t\t</table>";
return $view;
}
function get_items($_POST, $err = "")
{
extract($_POST);
$old_entries = "";
$new_entry = "";
$i = 0;
$total = 0;
$counter = 0;
db_connect();
#get all entries currently in db
$get_entries = "SELECT * FROM purch_batch_entries ORDER BY id DESC";
$run_entries = db_exec($get_entries) or errDie("Unable to get batch entries.");
if (pg_numrows($run_entries) > 0) {
$old_entries = "\n\t\t\t<tr>\n\t\t\t\t<td colspan='9' align='right'><input type='submit' name='remall' value='Select All'></td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<th>Supplier</th>\n\t\t\t\t<th>Item Account</th>\n\t\t\t\t<th>Date</th>\n\t\t\t\t<th>VAT Code</th>\n\t\t\t\t<th>Supp. Inv. No.</th>\n\t\t\t\t<th>Description</th>\n\t\t\t\t<th>Qty</th>\n\t\t\t\t<th>Unit Price (Incl. VAT)</th>\n\t\t\t\t<th>Remove</th>\n\t\t\t</tr>";
while ($earr = pg_fetch_array($run_entries)) {
#supplier drop
db_connect();
$get_supp = "SELECT * FROM suppliers WHERE supid = '{$earr['supplier']}' LIMIT 1";
$run_supp = db_exec($get_supp) or errDie("Unable to get supplier information.");
if (pg_numrows($run_supp) < 1) {
unset($_POST["new"]);
$showsupplier = "Supplier Not Found.";
} else {
$sarr = pg_fetch_array($run_supp);
$showsupplier = "{$sarr['supname']}";
}
#get account drop
core_connect();
$sql = "SELECT * FROM accounts WHERE accid = '{$earr['account']}' LIMIT 1";
$accRslt = db_exec($sql);
if (pg_numrows($accRslt) < 1) {
unset($_POST["new"]);
$showaccount = "Account Not Found.";
} else {
$aarr = pg_fetch_array($accRslt);
$showaccount = "{$aarr['topacc']}/{$aarr['accnum']} - {$aarr['accname']}";
}
#get vatcode information
db_connect();
$Sl = "SELECT * FROM vatcodes WHERE id = '{$earr['vatcode']}' LIMIT 1";
$Ri = db_exec($Sl) or errDie("Unable to get vat codes");
if (pg_numrows($Ri) < 1) {
$showvatcode = "Vatcode Not Found.";
} else {
$varr = pg_fetch_array($Ri);
$showvatcode = $varr['code'];
}
$parr = explode("-", $earr['pdate']);
$dates_year = $parr[0];
$dates_month = $parr[1];
$dates_day = $parr[2];
if (isset($remall)) {
$removetick = "checked=yes";
} else {
$removetick = "";
}
// <input type='hidden' name='suppliers[$i]' value='$earr[supplier]'>
// <input type='hidden' name='accounts[$i]' value='$earr[account]'>
// <input type='hidden' name='dates_year[$i]' value='$dates_year'>
// <input type='hidden' name='dates_month[$i]' value='$dates_month'>
// <input type='hidden' name='dates_day[$i]' value='$dates_day'>
// <input type='hidden' name='vatcodes[$i]' value='$earr[vatcode]'>
// <input type='hidden' name='supinvs[$i]' value='$earr[supinv]'>
// <input type='hidden' name='descriptions[$i]' value='$earr[description]'>
// <input type='hidden' name='qtys[$i]' value='$earr[qty]'>
// <input type='hidden' name='prices[$i]' value='$earr[price]'>
$old_entries .= "\n\t\t\t\t<input type='hidden' name='ids[{$i}]' value='{$earr['id']}'>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>{$showsupplier}</td>\n\t\t\t\t\t<td>{$showaccount}</td>\n\t\t\t\t\t<td nowrap>{$dates_year}-{$dates_month}-{$dates_day}</td>\n\t\t\t\t\t<td>{$showvatcode}</td>\n\t\t\t\t\t<td>{$earr['supinv']}</td>\n\t\t\t\t\t<td>{$earr['description']}</td>\n\t\t\t\t\t<td>{$earr['qty']}</td>\n\t\t\t\t\t<td>" . CUR . " {$earr['price']}</td>\n\t\t\t\t\t<td><input type='checkbox' name='remids[{$i}]' value='{$earr['id']}' {$removetick}></td>\n\t\t\t\t</tr>";
$i++;
$counter++;
$total = $total + $earr['qty'] * $earr['price'];
if ($counter == 20) {
$old_entries .= "\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td colspan='9' align='right'><input type='submit' name='process' value='Process'></td>\n\t\t\t\t\t</tr>";
$counter = 0;
}
}
$total = sprint($total);
$old_entries .= "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td colspan='5'></td>\n\t\t\t\t<th colspan='2'>Total</th>\n\t\t\t\t<th align='left'>" . CUR . " {$total}</th>\n\t\t\t\t<td></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='rem_selected' value='Remove Selected'></td>\n\t\t\t</tr>";
}
$new = "";
#generate new field
if (isset($new)) {
// if(!isset($))
// $ = "";
// $supplier
// $account
// if(!isset($date_year) OR (strlen($date_year) < 4))
// $date_year = date("Y");
// if(!isset($date_month) OR (strlen($date_month) < 2))
// $date_month = date("m");
// if(!isset($date_day) OR (strlen($date_day) < 2))
// $date_day = date("d");
if (!isset($date_day)) {
$trans_date_setting = getCSetting("USE_TRANSACTION_DATE");
if (isset($trans_date_setting) and $trans_date_setting == "yes") {
$trans_date_value = getCSetting("TRANSACTION_DATE");
$date_arr = explode("-", $trans_date_value);
$date_year = $date_arr[0];
$date_month = $date_arr[1];
$date_day = $date_arr[2];
} else {
$date_year = date("Y");
$date_month = date("m");
$date_day = date("d");
}
}
if (!isset($vatcode)) {
$vatcode = "";
}
if (!isset($supinv)) {
$supinv = "";
}
if (!isset($description)) {
$description = "";
}
if (!isset($qty)) {
$qty = "";
}
if (!isset($price)) {
$price = "";
}
#get supplier drop
db_connect();
$get_supp = "SELECT * FROM suppliers WHERE div = '" . USER_DIV . "' AND ((length(blocked) < 3) OR (blocked IS NULL)) ";
$run_supp = db_exec($get_supp) or errDie("Unable to get supplier information.");
if (pg_numrows($run_supp) < 1) {
unset($_POST["new"]);
return "<li class='err'>No Suppliers Found.</li><br>" . mkQuickLinks(ql("supp-new.php", "Add Supplier"), ql("supp-view.php", "View Suppliers"), ql("purchase-new.php", "Add Purchase"), ql("purchase-view.php", "View Purchases"), ql("nons-purchase-new.php", "Add Non-Stock Purchase"), ql("nons-purchase-view.php", "View Non-Stock Purchases"));
// return get_items ($_POST,"<li class='err'>No Suppliers Found.</li>");
} else {
$supplier_drop = "<select name='supplier'>";
while ($sarr = pg_fetch_array($run_supp)) {
if (isset($supplier) and $supplier == $sarr['supid']) {
$supplier_drop .= "<option value='{$sarr['supid']}' selected>{$sarr['supname']}</option>";
} else {
$supplier_drop .= "<option value='{$sarr['supid']}'>{$sarr['supname']}</option>";
}
}
$supplier_drop .= "</select>";
}
#get account drop
core_connect();
$sql = "SELECT * FROM accounts WHERE div = '" . USER_DIV . "' ORDER BY accname ASC";
$accRslt = db_exec($sql);
if (pg_numrows($accRslt) < 1) {
unset($_POST["new"]);
return get_items($_POST, "<li class='err'>There are No accounts in Cubit.</li>");
}
$accounts_drop = mkAccSelect("account", $account);
// $accounts_drop = "<select name='account'>";
// while($acc = pg_fetch_array($accRslt)){
// # Check Disable
// if(isDisabled($acc['accid']))
// continue;
// if(isset($account) AND ($account == $acc['accid'])){
// $accounts_drop .= "<option value='$acc[accid]' selected>$acc[topacc]/$acc[accnum] - $acc[accname]</option>";
// }else {
// $accounts_drop .= "<option value='$acc[accid]'>$acc[topacc]/$acc[accnum] - $acc[accname]</option>";
// }
// }
// $accounts_drop .= "</select>";
#get vatcode information
db_connect();
$Sl = "SELECT * FROM vatcodes ORDER BY code";
$Ri = db_exec($Sl) or errDie("Unable to get vat codes");
$vatcodes_drop = "\n\t\t\t<select name='vatcode'>\n\t\t\t\t<option value='0'>Select</option>";
while ($vd = pg_fetch_array($Ri)) {
if ($vatcode == $vd['id']) {
$vatcodes_drop .= "<option value='{$vd['id']}' selected>{$vd['code']}</option>";
} else {
$vatcodes_drop .= "<option value='{$vd['id']}'>{$vd['code']}</option>";
}
}
$vatcodes_drop .= "</select>";
#get the projects
$get_pros = "SELECT * FROM projects WHERE project_name != 'No Project' ORDER BY project_name";
$run_pros = db_exec($get_pros) or errDie("Unable to get project information.");
if (pg_numrows($run_pros) < 1) {
$project_drop = "<li class='err'>No Projects Found.</li>";
} else {
$parr = pg_fetch_array($run_pros);
$project_drop = "<select name='project'>";
}
$costs = "";
$get_newpros = "SELECT * FROM purch_batch_entries_newcostcenters";
$run_newpros = db_exec($get_newpros) or errDie("Unable to get cost center listing");
if (pg_numrows($run_newpros) < 1) {
$projects = array();
} else {
while ($parr = pg_fetch_array($run_newpros)) {
$costs .= "\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td colspan='2'>\n\t\t\t\t\t\t\t<input type='text' size='15' name='old_project[{$parr['id']}]' value='{$parr['project']}'>\n\t\t\t\t\t\t\t<input type='text' size='15' name='old_costcenter[{$parr['id']}]' value='{$parr['costcenter']}'>\n\t\t\t\t\t\t\t<input type='text' size='15' name='old_costperc[{$parr['id']}]' value='{$parr['costperc']}'>\n\t\t\t\t\t\t\t<input type='checkbox' name='remcost' value='{$parr['id']}' onChange='document.form.submit();'> (Remove)\n\t\t\t\t\t\t</td>\n\t\t\t\t\t</tr>";
}
}
if (!isset($newproject) or strlen($newproject) < 1) {
$showproject = "value='Project ' onFocus=\"value=''\"";
} else {
$showproject = "value='{$newproject}'";
}
if (!isset($newcostcenter) or strlen($newcostcenter) < 1) {
$showcostcenter = "value='Cost Center' onFocus=\"value=''\"";
} else {
$showcostcenter = "value='{$newcostcenter}'";
}
if (!isset($newcostperc) or strlen($newcostperc) < 1) {
$showcostperc = "value='100'";
} else {
$showcostperc = "value='{$newcostperc}'";
}
$csetting = getsetting("CC_USE");
if ($csetting == "use") {
$showcostcenters = "\n\t\t\t<tr>\n\t\t\t\t<th colspan='2'>Cost Center</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td colspan='2' nowrap>\n\t\t\t\t\t<input type='text' size='15' name='newproject' {$showproject}>\n\t\t\t\t\t<input type='text' size='15' name='newcostcenter' {$showcostcenter}>\n\t\t\t\t\t<input type='text' size='4' name='newcostperc' {$showcostperc}> Percent\n\t\t\t\t</td>\n\t\t\t</tr>\n\t\t\t{$costs}";
} else {
$showcostcenters = "";
}
$new_entry .= "\n\t\t\t<tr>\n\t\t\t\t<th>Supplier</th>\n\t\t\t\t<th colspan='3'>Item Account <input align='right' type='button' onClick=\"window.open('core/acc-new2.php?update_parent=yes','accounts','width=700, height=400');\" value='New Account'></th>\n\t\t\t\t<th>Date</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>{$supplier_drop}</td>\n\t\t\t\t<td colspan='3'>{$accounts_drop}</td>\n\t\t\t\t<td nowrap>" . mkDateSelect("date", $date_year, $date_month, $date_day) . "</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<th>Supp. Inv. No.</th>\n\t\t\t\t<th>Description</th>\n\t\t\t\t<th>Qty</th>\n\t\t\t\t<th>Unit Price (Incl. VAT)</th>\n\t\t\t\t<th>VAT Code</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td><input type='text' size='5' name='supinv' value='{$supinv}'></td>\n\t\t\t\t<td><input type='text' size='25' name='description' value='{$description}'></td>\n\t\t\t\t<td><input type='text' size='5' name='qty' value='{$qty}'></td>\n\t\t\t\t<td><input type='text' size='15' name='price' value='{$price}'></td>\n\t\t\t\t<td>{$vatcodes_drop}</td>\n\t\t\t</tr>\n\t\t\t{$showcostcenters}";
}
$showsetting = getsetting("CC_USE");
$display = "\n\t\t<h2>Batch Creditor Non-Stock Invoices</h2>\n\t\t{$err}\n\t\t<br>\n\t\t<form action='" . SELF . "' method='POST' name='form'>\n\t\t\t<input type='hidden' name='key' value='save'>\n\t\t<table " . TMPL_tblDflts . " width='95%'>\n\t\t\t{$new_entry}\n\t\t\t<td><input type='submit' name='update' value='Add Item'></td>\n\t\t\t" . TBL_BR . "\n\t\t</table>\n\t\t<table " . TMPL_tblDflts . " width='95%'>\n\t\t\t{$old_entries}\n\t\t\t" . TBL_BR . "\n\t\t\t<tr>\n\t\t\t\t<td colspan='9' align='right'><input type='submit' name='process' value='Process'></td>\n\t\t\t</tr>\n\t\t</table>\n\t\t</form>\n\t\t<p>" . mkQuickLinks(ql("purchase-new.php", "Add Purchase"), ql("purchase-view.php", "View Purchases"), ql("nons-purchase-new.php", "Add Non-Stock Purchase"), ql("nons-purchase-view.php", "View Non-Stock Purchases"));
return $display;
}
function enter($_POST, $error = "")
{
# Get vars
extract($_POST);
if (!isset($number)) {
$number = 1;
}
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($bankid, "num", 1, 20, "Invalid Bank ID.");
$v->isOk($number, "num", 1, 3, "Invalid number of entries.");
# 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;
}
$jump_bot = "";
if (isset($another)) {
$jump_bot = "\n\t\t\t<script>\n\t\t\t\twindow.location.hash='bottom';\n\t\t\t</script>";
$number++;
}
# Accounts Drop down
core_connect();
$glacc = mkAccSelect("accinv[]", 1);
// $glacc = "<select name='accinv[]'>";
// $sql = "SELECT * FROM accounts WHERE div = '".USER_DIV."'";
// $accRslt = db_exec($sql);
// if(pg_numrows($accRslt) < 1){
// return "<li> There are no accounts yet in Cubit.</li>";
// }
// while($acc = pg_fetch_array($accRslt)){
// # Check Disable
// if(isDisabled($acc['accid']))
// continue;
// $glacc .= "<option value='$acc[accid]'>$acc[accname]</option>";
// }
// $glacc .= "</select>";
# Get bank acc details
$bankRslt = get("cubit", "*", "bankacct", "bankid", $bankid);
$bank = pg_fetch_array($bankRslt);
$vatarr = array("nov" => "No VAT", "inc" => "Inclusive", "exc" => "Exclusive");
// Layout
$enter = "\n\t\t<center>\n\t\t<h3>Type in Bank statement</h3>\n\t\t<form action='" . SELF . "' method='POST' name='form'>\n\t\t\t<input type='hidden' name='key' value='confirm'>\n\t\t\t<input type='hidden' name='bankid' value='{$bankid}'>\n\t\t\t<input type='hidden' name='number' value='{$number}'>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<td colspan='4'>{$error}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<th align='center' colspan='10'>Bank Account : <b>({$bank['accnum']}) {$bank['accname']}</b></th>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<th>Date</th>\n\t\t\t\t<th>Paid to/Received from</th>\n\t\t\t\t<th>Transaction type</th>\n\t\t\t\t<th>Transaction Description</th>\n\t\t\t\t<th>Reference</th>\n\t\t\t\t<th>Cheque Number</th>\n\t\t\t\t<th>Amount</th>\n\t\t\t\t<th>VAT</th>\n\t\t\t\t<th>VAT Code</th>\n\t\t\t\t<th>Contra Account <input align='right' type='button' onClick=\"window.open('../core/acc-new2.php?update_parent=yes','accounts','width=700, height=400');\" value='New Account'></th>\n\t\t\t</tr>";
for ($i = 0; $i < $number; $i++) {
if (!isset($date[$i])) {
$date[$i] = false;
}
if (strlen($date[$i]) < 1) {
$trans_date_setting = getCSetting("USE_TRANSACTION_DATE");
if (isset($trans_date_setting) and $trans_date_setting == "yes") {
$trans_date_value = getCSetting("TRANSACTION_DATE");
$date_arr = explode("-", $trans_date_value);
$o_year[$i] = $date_arr[0];
$o_month[$i] = $date_arr[1];
$o_day[$i] = $date_arr[2];
$date[$i] = "{$o_year[$i]}-{$o_month[$i]}-{$o_day[$i]}-";
} else {
if (!isset($o_day[$i]) or strlen($o_day[$i]) < 1) {
if (isset($_SESSION["global_day"]) and strlen($_SESSION["global_day"]) > 0) {
$o_day[$i] = $_SESSION["global_day"];
} else {
$o_day[$i] = date("d");
}
if (isset($_SESSION["global_month"]) and strlen($_SESSION["global_month"]) > 0) {
$o_month[$i] = $_SESSION["global_month"];
} else {
$o_month[$i] = date("m");
}
if (isset($_SESSION["global_year"]) and strlen($_SESSION["global_year"]) > 0) {
$o_year[$i] = $_SESSION["global_year"];
} else {
$o_year[$i] = date("Y");
}
}
$date[$i] = "{$o_year[$i]}-{$o_month[$i]}-{$o_day[$i]}-";
}
}
explodeDate($date[$i], $o_year[$i], $o_month[$i], $o_day[$i]);
if (!isset($to[$i])) {
$to[$i] = "";
$trantype[$i] = "";
$descript[$i] = "";
$ref[$i] = "";
$cheqnum[$i] = "";
$amount[$i] = "";
$chrgvat[$i] = "";
$accinv[$i] = "";
}
switch (strtolower($trantype[$i])) {
case "deposit":
$ch1 = "selected";
$ch2 = "";
break;
case "withdrawal":
$ch1 = "";
$ch2 = "selected";
break;
default:
$ch1 = "";
$ch2 = "selected";
break;
}
$vatsel = extlib_cpsel("chrgvat[]", $vatarr, $chrgvat[$i]);
$glacc = mkAccSelect("accinv[]", $accinv[$i]);
# Accounts Drop down
// core_connect();
// $glacc = "<select name='accinv[]'>";
// $sql = "SELECT * FROM accounts WHERE div = '".USER_DIV."' ORDER BY accname";
// $accRslt = db_exec($sql);
// if(pg_numrows($accRslt) < 1){
// return "<li> There are no accounts yet in Cubit.</li>";
// }
// while($acc = pg_fetch_array($accRslt)){
// # Check Disable
// if(isDisabled($acc['accid']))
// continue;
// $sel = "";
// if($acc['accid'] == $accinv[$i]) $sel = "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[]'>";
while ($vd = pg_fetch_array($Ri)) {
$vats .= "<option value='{$vd['id']}'>{$vd['code']}</option>";
}
$vats .= "</select>";
$enter .= "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td align='center' nowrap='t'>" . mkDateSelectA("o", $i, $o_year[$i], $o_month[$i], $o_day[$i]) . "</td>\n\t\t\t\t<td align='center'><input type='text' name='to[]' value='{$to[$i]}'></td>\n\t\t\t\t<td align='center'>\n\t\t\t\t\t<select name='trantype[]'>\n\t\t\t\t\t\t<option value='Withdrawal' {$ch2}>Payment</option>\n\t\t\t\t\t\t<option value='Deposit' {$ch1}>Receipt</option>\n\t\t\t\t\t</select>\n\t\t\t\t</td>\n\t\t\t\t<td align='center'><input type='text' name='descript[]' value='{$descript[$i]}'></td>\n\t\t\t\t<td align='center'><input type='text' name='ref[]' value='{$ref[$i]}' size=7></td>\n\t\t\t\t<td align='center'><input type='text' name='cheqnum[]' value='{$cheqnum[$i]}' size='7'></td>\n\t\t\t\t<td align='center'>\n\t\t\t\t\t<table>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td>" . CUR . "</td>\n\t\t\t\t\t\t\t<td><input type='text' name='amount[]' value='{$amount[$i]}' size='8'></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 align='center'>{$vatsel}</td>\n\t\t\t\t<td align='center'>{$vats}</td>\n\t\t\t\t<td align='center'>{$glacc}</td>\n\t\t\t</tr>";
}
$total_amount = 0;
$payment_list = array_keys($trantype, "Deposit");
foreach ($payment_list as $each => $own) {
$total_amount += $amount[$own];
}
$receipt_list = array_keys($trantype, "Withdrawal");
foreach ($receipt_list as $each => $own) {
$total_amount -= $amount[$own];
}
$enter .= "\n\t\t<tr class='" . bg_class() . "'>\n\t\t\t<td colspan='6' align='right'><b>Total:</b></td>\n\t\t\t<td align='right'>" . CUR . " " . sprint($total_amount) . "</td>\n\t\t\t<td colspan='3'></td>\n\t\t</tr>";
$enter .= "\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><input type='submit' name='another' value='Add Another'></td>\n\t\t\t\t\t<td colspan='4' align='right'><input type='submit' value='Confirm »'></td>\n\t\t\t\t</tr>\n\t\t\t</table>\n\t\t\t</form>\n\t\t<p>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<th>Quick Links</th>\n\t\t\t</tr>\n\t\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t\t</table>\n\t\t<a name='bottom'>\n\t\t{$jump_bot}";
return $enter;
}
function slctacc($_POST, $err = "")
{
extract($_POST);
$translist = "";
if (!isset($total)) {
$total = 1;
}
if (!isset($refnum)) {
$refnum = getrefnum();
}
$jump_bot = "";
if (isset($more)) {
$jump_bot = "\n\t\t\t<script>\n\t\t\t\twindow.location.hash='bottom';\n\t\t\t</script>";
$total++;
}
if (!isset($date_year)) {
$trans_date_setting = getCSetting("USE_TRANSACTION_DATE");
if (isset($trans_date_setting) and $trans_date_setting == "yes") {
$trans_date_value = getCSetting("TRANSACTION_DATE");
$date_arr = explode("-", $trans_date_value);
$date_year = $date_arr[0];
$date_month = $date_arr[1];
$date_day = $date_arr[2];
} else {
$date_year = date("Y");
$date_month = date("m");
$date_day = date("d");
}
}
for ($i = 0; $i != $total; $i++) {
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>";
}
$dtaccid[$i] += 0;
$dtamount[$i] += 0;
$ctamount[$i] += 0;
$translist .= "\n\t\t\t<tr bgcolor=" . bgcolorg() . ">\n\t\t\t\t<td valign='center'>" . mkAccSelect("accid[]", $accid[$i]) . "</td>\n\t\t\t\t<td><input type='text' size='20' name='descript[]' value='{$descript[$i]}'></td>\n\t\t\t\t<td><input type='text' size='7' name='dtamount[]' value='{$dtamount[$i]}'></td>\n\t\t\t\t<td><input type='text' size='7' name='ctamount[]' value='{$ctamount[$i]}'></td>\n\t\t\t</tr>";
}
$translist .= "\n\t\t<tr class='" . bg_class() . "'>\n\t\t\t<td colspan='2' align='right'><b>Total:</b></td>\n\t\t\t<td>" . CUR . " " . sprint(array_sum($dtamount)) . "</td>\n\t\t\t<td>" . CUR . " " . sprint(array_sum($ctamount)) . "</td>\n\t\t</tr>";
// Accounts (debit)
$view = "\n\t\t<center>\n\t\t<h3>Process Multiple Account Journal Transactions</h3>\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<input type='hidden' name='total' value='{$total}'>\n\t\t<table " . TMPL_tblDflts . " align='center'>\n\t\t\t<tr>\n\t\t\t\t<th>Transaction Date</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td align='center'>" . mkDateSelect("date", $date_year, $date_month, $date_day) . "</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<th>Select Contra Account</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>" . mkAccSelect("account", $account) . "</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<th>Reference Number</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td align='center'><input type='text' size='5' name='refnum' value='{$refnum}'></td>\n\t\t\t</tr>\n\t\t\t" . TBL_BR . "\n\t\t</table>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<th>Account <input align='right' type='button' onClick=\"window.open('acc-new2.php?update_parent=yes','accounts','width=700, height=400');\" value='New Account'></th>\n\t\t\t\t<th>Description</th>\n\t\t\t\t<th>Debit</th>\n\t\t\t\t<th>Credit</th>\n\t\t\t</tr>\n\t\t\t{$translist}\n\t\t\t<tr>\n\t\t\t\t<td colspan='3'><input type='submit' name='more' value='Add Another'></td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td valign='center' colspan='4' align='right'><input type='submit' name='confirm' value='Confirm »'></td>\n\t\t\t</tr>\n\t\t</table>\n\t\t</form>\n\t\t<a name='bottom'>\n\t\t{$jump_bot}\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='batch-view.php'>View batch Entries</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 Transaction</td>\n\t\t\t</tr>\n\t\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t\t</table>";
return $view;
}
function add()
{
global $_POST;
extract($_POST);
# Accounts Drop down selections
core_connect();
if (isset($account) && strlen($account) > 0) {
$accinv = $account;
}
$glacc = mkAccSelect("accinv", $accinv);
# 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 = "There are no Income accounts yet in Cubit.";
// }
// while($acc = pg_fetch_array($accRslt)){
// # Check Disable
// if(isDisabled($acc['accid']))
// continue;
// if((isset($accinv) && ($accinv == $acc['accid'])) ||
// (isset($account) && ($account == $acc['accid']))) {
// $sel = "selected";
// } else {
// $sel = "";
// }
// $glacc .= "<option value='$acc[accid]' $sel>$acc[accname]</option>";
// }
// $glacc .= "</select>";
if (!isset($name)) {
$bankid = 0;
$name = "";
$descript = "";
$cheqnum = "";
$amount = "";
$reference = "";
}
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 ($bankid == $acc['bankid']) {
$bank .= "<option value='{$acc['bankid']}' selected>{$acc['accname']} - {$acc['bankname']} ({$acc['acctype']})</option>";
} else {
$bank .= "<option value='{$acc['bankid']}'>{$acc['accname']} - {$acc['bankname']} ({$acc['acctype']})</option>";
}
}
$bank .= "</select>";
if (!isset($vatcode)) {
$vatcode = "";
}
if (!isset($chrgvat)) {
$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<select name='vatcode'>\n\t\t\t<option value='0'>Select</option>";
while ($vd = pg_fetch_array($Ri)) {
if ($vatcode == $vd['id']) {
$sel = "selected";
} else {
if ($vd['del'] == "Yes" and strlen($vatcode) < 1) {
$sel = "selected";
} else {
$sel = "";
}
}
$Vatcodes .= "<option value='{$vd['id']}' {$sel}>{$vd['code']}</option>";
}
$Vatcodes .= "</select>";
if (!isset($date_day)) {
$trans_date_setting = getCSetting("USE_TRANSACTION_DATE");
if (isset($trans_date_setting) and $trans_date_setting == "yes") {
$trans_date_value = getCSetting("TRANSACTION_DATE");
$date_arr = explode("-", $trans_date_value);
$date_year = $date_arr[0];
$date_month = $date_arr[1];
$date_day = $date_arr[2];
} else {
#check if the global date is set .... else set it manually
if (isset($_SESSION["global_day"]) and strlen($_SESSION["global_day"]) > 0) {
$date_day = $_SESSION["global_day"];
} else {
$date_day = date("d");
}
if (isset($_SESSION["global_month"]) and strlen($_SESSION["global_month"]) > 0) {
$date_month = $_SESSION["global_month"];
} else {
$date_month = date("m");
}
if (isset($_SESSION["global_year"]) and strlen($_SESSION["global_year"]) > 0) {
$date_year = $_SESSION["global_year"];
} else {
$date_year = date("Y");
}
}
}
$cvat1 = "";
$cvat2 = "";
$cvat3 = "";
if ($chrgvat == "inc") {
$cvat1 = "checked='yes'";
} elseif ($chrgvat == "exc") {
$cvat2 = "checked='yes'";
} else {
$cvat3 = "checked='yes'";
}
# layout
$add = "\n\t\t<h3>New Bank Payment</h3>\n\t\t<table " . TMPL_tblDflts . " width='80%'>\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>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>Bank Account</td>\n\t\t\t\t<td valign='center'>{$bank}</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("date", $date_year, $date_month, $date_day) . " DD-MM-YYYY</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Paid to</td>\n\t\t\t\t<td valign='center'><input size='20' name='name' value='{$name}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td valign='top'>Description</td>\n\t\t\t\t<td valign='center'><textarea col='18' rows='3' name='descript'>{$descript}</textarea></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Reference</td>\n\t\t\t\t<td valign='center'><input type='text' size='25' name='reference' value='{$reference}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Cheque Number</td>\n\t\t\t\t<td valign='center'><input size='20' name='cheqnum' value='{$cheqnum}'></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='10' name='amount' value='{$amount}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>VAT </td>\n\t\t\t\t<td><input type='radio' name='chrgvat' value='inc' {$cvat1}>Inclusive <input type='radio' name='chrgvat' value='exc' {$cvat2}>Exclusive <input type='radio' name='chrgvat' value='nov' {$cvat3}>No VAT</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 class='" . bg_class() . "'>\n\t\t\t\t<td valign='top'>Select Contra Account <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\t<td>{$glacc}</td>\n\t\t\t</tr>\n\t\t\t<tr><td><br></td></tr>\n\t\t\t<tr>\n\t\t\t\t<td><input type='submit' name='back' value='« Correction'></td>\n\t\t\t\t<td valign='center' align='right'><input type='submit' value='Confirm »'></td>\n\t\t\t</tr>\n\t\t</form>\n\t\t</table>";
# main table (layout with menu)
$OUTPUT = "\n\t\t<center>\n\t\t<table width='100%'>\n\t\t\t<tr>\n\t\t\t\t<td width='65%' align='left'>{$add}</td>\n\t\t\t\t<td valign='top' align='center'>\n\t\t\t\t\t<table " . TMPL_tblDflts . " width='65%'>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th>Quick Links</th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t\t\t\t\t</table>\n\t\t\t\t</td>\n\t\t\t</tr>\n\t\t</table>";
return $OUTPUT;
}
function add($errors = "")
{
global $_POST;
extract($_POST);
$fields["name"] = "";
$fields["det"] = "";
$fields["amount"] = "";
$fields["chrgvat"] = "inc";
$fields["vatcode"] = "";
$fields["accid"] = "";
foreach ($fields as $var_name => $value) {
if (!isset(${$var_name})) {
${$var_name} = $value;
}
}
core_connect();
$accnts = mkAccSelect("accid", $accid);
// $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'> 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;
//
// if ($accid == $acc["accid"]) {
// $selected = "selected";
// } else {
// $selected = "";
// }
//
// $accnts .= "<option value='$acc[accid]' $selected>$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 month='" . (int) date("m") . "' 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 "\n\t\t\t<li class='err'> There are no Petty Cash funds available.</li>\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<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td><a href='petty-trans.php'>Transfer funds to petty cash account</a></td>\n\t\t\t\t</tr>\n\t\t\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t\t\t</table>";
}
// Vat Inclusive ?
if ($chrgvat == "exc") {
$vat_exc = "checked";
$vat_inc = "";
} else {
$vat_exc = "";
$vat_inc = "checked";
}
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<select name='vatcode'>\n\t\t\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>";
if (!isset($date_day)) {
$trans_date_setting = getCSetting("USE_TRANSACTION_DATE");
if (isset($trans_date_setting) and $trans_date_setting == "yes") {
$trans_date_value = getCSetting("TRANSACTION_DATE");
$date_arr = explode("-", $trans_date_value);
$date_year = $date_arr[0];
$date_month = $date_arr[1];
$date_day = $date_arr[2];
} else {
$date_year = date("Y");
$date_month = date("m");
$date_day = date("d");
}
}
// Layout
$add = "\n\t\t<h3>Add Petty Cash Requisistion</h3>\n\t\t<table " . TMPL_tblDflts . " width='600'>\n\t\t<form action='" . SELF . "' method='POST' name='form'>\n\t\t\t<input type='hidden' name='key' value='confirm'>\n\t\t\t<tr>\n\t\t\t\t<td colspan='2'>{$errors}</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<th>Field</th>\n\t\t\t\t<th>Value</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Date</td>\n\t\t\t\t<td>" . mkDateSelect("date", $date_year, $date_month, $date_day) . "</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Paid to</td>\n\t\t\t\t<td valign='center'><input size='20' name='name' value='{$name}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Details</td>\n\t\t\t\t<td valign='center'><textarea cols='18' rows='2' name='det'>{$det}</textarea></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Available Funds</td>\n\t\t\t\t<td><input type='hidden' name='bal' value='{$accb['bal']}'>" . CUR . " {$accb['bal']}</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='10' name='amount' value='{$amount}'></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 valign='center'>\n\t\t\t\t\tYes <input type='radio' size='7' name='chrgvat' value='inc' {$vat_inc}>\n\t\t\t\t\tNo <input type='radio' size='7' name='chrgvat' value='exc' {$vat_exc}>\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>VAT Code</td>\n\t\t\t\t<td>{$Vatcodes}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Account Paid to <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\t<td>{$accnts}</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td><br></td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td valign='center' align='right' colspan='2'><input type='submit' value='Confirm »'></td>\n\t\t\t</tr>\n\t\t</table>\n\t\t<p>\n\t\t<table " . TMPL_tblDflts . " 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><a href='pettycashbook-view.php'>View Petty Cash Requisitions</a></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td><a href='../main.php'>Main Menu</a></td>\n\t\t\t</tr>\n\t\t</table>";
return $add;
}
function edit($_GET)
{
# Get vars
extract($_GET);
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($ledgid, "num", 1, 20, "Invalid Input Ledger Number.");
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class='err'>" . $e["msg"] . "</li>";
}
$confirm .= "<p><input type='button' onClick='JavaScript:history.back();' value='« Correct submission'>";
return $confirm;
}
# Get ledger settings
core_connect();
$sql = "SELECT * FROM in_ledgers WHERE ledgid='{$ledgid}' AND div = '" . USER_DIV . "'";
$ledRslt = db_exec($sql);
if (pg_numrows($ledRslt) < 1) {
return "<li>Invalid Input Ledger Number.</li>";
}
$led = pg_fetch_array($ledRslt);
# accounts drop downs
core_connect();
# keep the charge vat option stable
if ($led['chrgvat'] == 'yes') {
$chrgy = "checked=yes";
$chrgn = "";
} else {
$chrgy = "";
$chrgn = "checked=yes";
}
# keep the date option stable
if ($led['dateopt'] == 'system') {
$dates = "checked=yes";
$dateu = "";
} else {
$dates = "";
$dateu = "checked=yes";
}
# keep the description option stable
$num = "";
$emp = "";
$once = "";
$edit = "";
${$led}['desopt'] = "checked=yes";
# keep the refnum option stable
$numr = "";
$empr = "";
$oncer = "";
$editr = "";
$led['refopt'] .= "r";
${$led}['refopt'] = "checked=yes";
/* End Toggle Options */
// Options Layout
$Opts = "\r\n\t\t<center>\r\n\t\t<h3> High Speed Input Ledger Edit </h3>\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='ledgid' value='{$ledgid}'>\r\n\t\t<table " . TMPL_tblDflts . " align='center'>\r\n\t\t\t<tr>\r\n\t\t\t\t<th colspan='3'>Details</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><input type='text' size='30' name='lname' value='{$led['lname']}'></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<th><h4>Debit</h4></th>\r\n\t\t\t\t<th><h4>Credit</h4></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'>" . mkAccSelect("dtaccid", $led['dtaccid']) . "</td>\r\n\t\t\t\t<td align='center'>" . mkAccSelect("ctaccid", $led['ctaccid']) . "</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<th colspan='3'>Options</th>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Number of Entries</td>\r\n\t\t\t\t<td><input type='text' size='10' name='numtran' value='{$led['numtran']}'></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Date Entry</td>\r\n\t\t\t\t<td><input type='radio' name='dateopt' value='system' {$dates}>System <input type='radio' name='dateopt' value='user' {$dateu}>User Input</td>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Charge Vat </td>\r\n\t\t\t\t<td><input type='radio' name='chrgvat' value='yes' {$chrgy}>Yes <input type='radio' name='chrgvat' value='no' {$chrgn}>No</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<th colspan='3'>Description</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><input type='text' size='30' name='descript' value='{$led['descript']}'></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td rowspan='3' valign='top'>Options</td>\r\n\t\t\t\t<td><input type='radio' name='desopt' value='emp' {$emp}> Empty Input Box</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td><input type='radio' name='desopt' value='once' {$once}> Once Only Setting</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td><input type='radio' name='desopt' value='edit' {$edit}> Default Editable</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<th colspan='3'>Reference Number</th>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>Reference Number</td>\r\n\t\t\t\t<td><input type='text' size='10' name='refnum' value='{$led['refnum']}'></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td rowspan='4' valign='top'>Options</td>\r\n\t\t\t\t<td><input type='radio' name='refopt' value='num' {$numr}> Auto Number</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td><input type='radio' name='refopt' value='emp' {$empr}> Empty Input Box</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td><input type='radio' name='refopt' value='once' {$oncer}> Once Only Setting</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td><input type='radio' name='refopt' value='edit' {$editr}> Default Editable Input</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 $Opts;
}
function details($_POST)
{
# Get vars
extract($_POST);
if (!isset($numcont)) {
$numcont = 1;
}
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($date_day, "num", 1, 2, "Invalid to Date day.");
$v->isOk($date_month, "num", 1, 2, "Invalid to Date month.");
$v->isOk($date_year, "num", 1, 4, "Invalid to Date Year.");
$date = $date_day . "-" . $date_month . "-" . $date_year;
if (!checkdate($date_month, $date_day, $date_year)) {
$v->isOk($date, "num", 1, 1, "Invalid date.");
}
$v->isOk($accid, "num", 1, 50, "Invalid Account to be Debited.");
$v->isOk($tran, "string", 1, 3, "Invalid type of transaction.");
$v->isOk($numcont, "num", 1, 10, "Invalid number of contra accounts.");
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class='err'>" . $e["msg"] . "</li>";
}
return $confirm . slctacc($_POST);
}
$blocked_date_from = getCSetting("BLOCKED_FROM");
$blocked_date_to = getCSetting("BLOCKED_TO");
if (strtotime($date) >= strtotime($blocked_date_from) and strtotime($date) <= 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>";
}
# get account
$accRs = get("core", "*", "accounts", "accid", $accid);
$macc = pg_fetch_array($accRs);
$temprefnum = getrefnum();
/*refnum*/
$jump_bot = "";
if (isset($another)) {
$jump_bot = "\n\t\t\t<script>\n\t\t\t\twindow.location.hash='bottom';\n\t\t\t</script>";
$numcont++;
}
// Deatils
$details = "\n\t\t<p>\n\t\t<h3> Journal transactions details</h3>\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='accid' value='{$accid}'>\n\t\t\t<input type='hidden' name='tran' value='{$tran}'>\n\t\t\t<input type='hidden' name='numcont' value='{$numcont}'>\n\t\t\t<input type='hidden' name='date_day' value='{$date_day}'>\n\t\t\t<input type='hidden' name='date_month' value='{$date_month}'>\n\t\t\t<input type='hidden' name='date_year' value='{$date_year}'>\n\t\t<table " . TMPL_tblDflts . ">\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 <input align='right' type='button' onClick=\"window.open('acc-new2.php?update_parent=yes&set_key=details','accounts','width=700, height=400');\" value='New Account'></th>\n\t\t\t\t<th>Credit <input align='right' type='button' onClick=\"window.open('acc-new2.php?update_parent=yes&set_key=details','accounts','width=700, height=400');\" value='New Account'></th>\n\t\t\t\t<th>Amount</th>\n\t\t\t\t<th>Description</th>\n\t\t\t</tr>";
for ($i = 0; $i != $numcont; $i++) {
if (isset($amount[$i])) {
$ta = $amount[$i];
} else {
$ta = "";
}
if (isset($descript[$i])) {
$da = $descript[$i];
} else {
$da = "";
}
if (!isset($caccid[$i])) {
$tc = 0;
} else {
$tc = $caccid[$i];
}
if (!isset($each_day[$i])) {
$each_day[$i] = $date_day;
$each_month[$i] = $date_month;
$each_year[$i] = $date_year;
}
if (!isset($refnum[$i])) {
$refnum[$i] = $temprefnum;
}
# details
$details .= "\n\t\t\t<tr bgcolor=" . bgcolorg() . ">\n\t\t\t\t<td>" . mkDateSelecta("each", $i, $each_year[$i], $each_month[$i], $each_day[$i]) . "</td>\n\t\t\t\t<td align='center'><input type='text' size='5' name='refnum[]' value='{$refnum[$i]}'></td>";
core_connect();
$sql = "SELECT * FROM accounts WHERE accid != '{$accid}' AND 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>";
}
$accs = mkAccSelect("caccid[]", $tc);
// $accs = "<select name='caccid[]'>";
// while($acc = pg_fetch_array($accRslt)){
// # Check Disable
// if(isDisabled($acc['accid']))
// continue;
// if($tc == $acc['accid']) {
// $sel = "selected";
// } else {
// $sel = "";
// }
// $accs .= "<option value='$acc[accid]' $sel>$acc[topacc]/$acc[accnum] - $acc[accname]</option>";
// }
// $accs .= "</select>";
if ($tran == 'dt') {
$accts = "<td>{$macc['topacc']}/{$macc['accnum']} - {$macc['accname']}</td><td>{$accs}</td>";
} else {
$accts = "<td>{$accs}</td><td>{$macc['topacc']}/{$macc['accnum']} - {$macc['accname']}</td>";
}
$details .= "\n\t\t\t\t{$accts}\n\t\t\t\t<td><input type='text' size='7' name='amount[]' value='{$ta}'></td>\n\t\t\t\t<td><input type='text' size='20' name='descript[]' value='{$da}'></td>\n\t\t\t</tr>";
}
$details .= "\n\t\t<tr class='" . bg_class() . "'>\n\t\t\t<td colspan='4' align='right'><b>Total:</b></td>\n\t\t\t<td>" . CUR . " " . sprint(array_sum($amount)) . "</td>\n\t\t\t<td></td>\n\t\t</tr>";
$details .= "\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><input type='submit' name='another' value='Add Another'></td>\n\t\t\t\t<td valign='center' colspan='2' align='right'><input type='submit' value='Confirm »'></td>\n\t\t\t</tr>\n\t\t</form>\n\t\t</table>\n\t\t<a name='bottom'>\n\t\t{$jump_bot}\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='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 $details;
}
function confirmDeduct($_POST)
{
# get vars
extract($_POST);
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($deduction, "string", 1, 100, "Invalid deduction name.");
$v->isOk($creditor, "string", 1, 100, "Invalid creditor name.");
$v->isOk($refno, "string", 1, 20, "Invalid reference number.");
$v->isOk($catid, "string", 1, 20, "Invalid Category number.");
$v->isOk($details, "string", 0, 100, "Invalid creditor details.");
$v->isOk($taxable, "string", 1, 3, "Invalid taxablility option.");
$v->isOk($type, "string", 1, 15, "Invalid type.");
# display errors, if any
if ($v->isError()) {
$confirmCust = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirmCust .= "<li class='err'>" . $e["msg"] . "</li>";
}
$confirmCust .= "<p><input type='button' onClick='JavaScript:history.back();' value='« Correct submission'>";
return $confirmCust;
}
# connect to db
core_connect();
// $dedacc= "<select name='accid' style='width: 230'>";
// $sql = "SELECT * FROM accounts WHERE catid = '$catid' AND div = '".USER_DIV."'";
// $accRslt = db_exec($sql);
// $numrows = pg_numrows($accRslt);
// if(empty($numrows)){
// $paid = "There are no Balance accounts yet in Cubit.";
// }else{
// $prevtop = "";
// while($acc = pg_fetch_array($accRslt)){
// if(isb($acc['accid'])) {
// continue;
// }
// if ( $acc["topacc"] == $prevtop && $acc["accnum"] != "000" ) {
// $x = " - $acc[topacc]/$acc[accnum]";
// } else {
// $x = "$acc[topacc]/$acc[accnum]";
// $prevtop = $acc["topacc"];
// }
// if (isset($accid) AND $accid == $acc['accid']){
// $dedacc .= "<option value='$acc[accid]' selected>$x $acc[accname]</option>";
// }else {
// $dedacc .= "<option value='$acc[accid]'>$x $acc[accname]</option>";
// }
// }
// }
// $dedacc .= "</select>";
// Expense account
// $expacc = "<select name='expaccid' style='width: 230'>";
// $sql = "SELECT * FROM accounts WHERE (catid='E10' OR catid='I10')AND div='".USER_DIV."'";
// $expRslt = db_exec($sql);
// $prevtop = "";
// while($acc = pg_fetch_array($expRslt)) {
// if(isb($acc['accid'])) {
// continue;
// }
// if ( $acc["topacc"] == $prevtop && $acc["accnum"] != "000" ) {
// $x = " - $acc[topacc]/$acc[accnum]";
// } else {
// $x = "$acc[topacc]/$acc[accnum]";
// $prevtop = $acc["topacc"];
// }
// if (isset ($expaccid) AND $expaccid == $acc['accid']){
// $expacc .= "<option value='$acc[accid]' selected>$x $acc[accname]</option>";
// }else {
// $expacc .= "<option value='$acc[accid]'>$x $acc[accname]</option>";
// }
// }
if (isset($type) and $type == "Percentage") {
# get current scales added
foreach ($scale_from as $each => $own) {
$own += 0;
$scale_to[$each] += 0;
$scale_amount[$each] += 0;
# check for zero values
if ($scale_to[$each] == "0" or $scale_amount[$each] == "0") {
continue;
}
# first value can be zero, but cant then be greater than the to value
if ($own >= $scale_to[$each]) {
continue;
}
if (isset($remove_scale) and is_array($remove_scale)) {
$rem = array_keys($remove_scale);
if ($each == $rem[0]) {
continue;
}
}
$scales_hidden .= "\n\t\t\t\t<input type='hidden' name='scale_from[]' value='{$own}'>\n\t\t\t\t<input type='hidden' name='scale_to[]' value='{$scale_to[$each]}'>\n\t\t\t\t<input type='hidden' name='scale_amount[]' value='{$scale_amount[$each]}'>";
$scales_list .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>{$own}</td>\n\t\t\t\t\t<td>{$scale_to[$each]}</td>\n\t\t\t\t\t<td>{$scale_amount[$each]} <input type='submit' name='remove_scale[{$each}]' value='Remove'></td>\n\t\t\t\t</tr>";
}
# check for cross linked pairs
if (!isset($new_scale_from) or !isset($new_scale_to) or !isset($new_scale_amount) or empty($new_scale_from) or empty($new_scale_to) or empty($new_scale_amount) or search_scale_array($scale_from, $scale_to, $new_scale_from) or search_scale_array($scale_from, $scale_to, $new_scale_to)) {
$scale_error = "<tr><td colspan='3'><li class='err'>Duplicate Or Overlapping Scale Exists</li></td></tr>";
} else {
$scale_error = "";
$scales_hidden .= "\n\t\t\t\t<input type='hidden' name='scale_from[]' value='{$new_scale_from}'>\n\t\t\t\t<input type='hidden' name='scale_to[]' value='{$new_scale_to}'>\n\t\t\t\t<input type='hidden' name='scale_amount[]' value='{$new_scale_amount}'>";
$scales_list .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>{$new_scale_from}</td>\n\t\t\t\t\t<td>{$new_scale_to}</td>\n\t\t\t\t\t<td>{$new_scale_amount} <input type='submit' name='remove_scale[" . ($each + 1) . "]' value='Remove'></td>\n\t\t\t\t</tr>";
}
$scales_display = "\n\t\t\t{$scales_hidden}\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<th colspan='3'>Percentage Deduction Scales</th>\n\t\t\t</tr>\n\t\t\t{$scale_error}\n\t\t\t<tr>\n\t\t\t\t<th>From Amount</th>\n\t\t\t\t<th>To Amount</th>\n\t\t\t\t<th>Percentage</th>\n\t\t\t</tr>\n\t\t\t{$scales_list}\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td><input type='text' size='5' name='new_scale_from'></td>\n\t\t\t\t<td><input type='text' size='5' name='new_scale_to'></td>\n\t\t\t\t<td>\n\t\t\t\t\t<input type='text' size='5' name='new_scale_amount'>\n\t\t\t\t\t<input type='submit' name='submit_scale' value='Add'>\n\t\t\t\t</td>\n\t\t\t</tr>";
} else {
$scales_display = "";
}
$confirmDeduct = "\n\t\t<h3>Confirm new Salary Deduction</h3>\n\t\t<form action='" . SELF . "' method='POST'>\n\t\t\t<input type='hidden' name='key' value='write'>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<input type='hidden' name='deduction' value='{$deduction}'>\n\t\t\t<input type='hidden' name='creditor' value='{$creditor}'>\n\t\t\t<input type='hidden' name='refno' value='{$refno}'>\n\t\t\t<input type='hidden' name='details' value='{$details}'>\n\t\t\t<input type='hidden' name='taxable' value='{$taxable}'>\n\t\t\t<input type='hidden' name='type' value='{$type}'>\n\t\t\t<input type='hidden' name='catid' value='{$catid}'>\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>Name of deduction</td>\n\t\t\t\t<td align='center'>{$deduction}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Creditor name</td>\n\t\t\t\t<td align='center'>{$creditor}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Reference no.</td>\n\t\t\t\t<td align='center'>{$refno}</td>\n\t\t\t</tr>";
if ($creditor == "In House") {
$confirmDeduct .= "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Expense Account</td>\n\t\t\t\t<td align='center'>" . mkAccSelect("expaccid", $expaccid, ACCTYPE_IE) . "</td>\n\t\t\t</tr>\n\t\t\t<input type='hidden' name='accid' value='0'>";
} else {
$confirmDeduct .= "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Creditor Account</td>\n\t\t\t\t<td align='center'>" . mkAccSelect("accid", $accid, ACCTYPE_B) . "</td>\n\t\t\t</tr>\n\t\t\t<input type='hidden' name='expaccid' value='0'>";
}
$confirmDeduct .= "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Creditor details</td>\n\t\t\t\t<td align='center'>{$details}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Deduct Before PAYE</td>\n\t\t\t\t<td align='center'>{$taxable}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Deduction Type</td>\n\t\t\t\t<td align='center'>{$type}</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td colspan='2' align='right'><input type='submit' name='submit_ded' value='Write »'></td>\n\t\t\t</tr>\n\t\t</table>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t{$scales_display}\n\t\t</table>\n\t\t</form>" . mkQuickLinks(ql("../admin-employee-add.php", "Add Employee"), ql("../admin-employee-view.php", "View Employees"));
return $confirmDeduct;
}
function enterDeduct($refno)
{
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($refno, "string", 1, 20, "Invalid reference number.");
# display errors, if any
if ($v->isError()) {
$confirmCust = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirmCust .= "<li class='err'>" . $e["msg"] . "</li>";
}
$confirmCust .= "<p><input type='button' onClick='JavaScript:history.back();' value='« Correct submission'>";
return $confirmCust;
}
# get deduction info
db_connect();
$sql = "SELECT * FROM salded WHERE refno='{$refno}' AND div = '" . USER_DIV . "'";
$salRslt = db_exec($sql) or errDie("Unable to select salary deduction info from database.");
if (pg_numrows($salRslt) < 1) {
return "Invalid reference number.";
}
$mySal = pg_fetch_array($salRslt);
core_connect();
// $dedacc = "<select name='accid' style='width: 230'>";
// $sql = "SELECT * FROM accounts WHERE (catid='E10' OR catid='I10') AND div = '".USER_DIV."'";
// $accRslt = db_exec($sql);
// $numrows = pg_numrows($accRslt);
// if(empty($numrows)){
// $paid = "There are no Balance accounts yet in Cubit.";
// }else{
// while($acc = pg_fetch_array($accRslt)){
// if ( $acc["accid"] == $mySal["accid"] ) {
// $sel = "selected";
// } else {
// $sel = "";
// }
// $dedacc .= "<option $sel value='$acc[accid]'>$acc[accname]</option>";
// }
// }
// $dedacc .= "</select>";
$arrtype = array("Amount" => "Amount", "Percentage" => "Percentage");
$seltype = extlib_cpsel("type", $arrtype, $mySal["type"]);
$check1 = "";
$check2 = "";
if (isset($mySal["type"]) and $mySal["type"] == "Percentage") {
$check2 = "checked='yes'";
} else {
$check1 = "checked='yes'";
}
if ($mySal['creditor'] == "In House") {
$accountsdrop = mkAccSelect("accid", $accid, ACCTYPE_IE);
} else {
$accountsdrop = mkAccSelect("accid", $accid, ACCTYPE_B);
}
$enterDeduct = "\n\t\t<script>\n\t\t\tfunction inHouse() {\n\t\t\t\tfrm = getObjectById('dedfrm');\n\t\t\t\tfrm.creditor.value='In House';\n\t\t\t\tfrm.details.value='In House';\n\t\t\t}\n\t\t</script>\n\t\t<h3>Edit salary deduction</h3>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t<form id='dedfrm' action='" . SELF . "' method='POST'>\n\t\t\t<input type='hidden' name='key' value='confirm'>\n\t\t\t<input type='hidden' name='refno' value='{$refno}'>\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>Name of deduction</td>\n\t\t\t\t<td align='center'><input type='text' size='20' name='deduction' value='{$mySal['deduction']}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Creditor name</td>\n\t\t\t\t<td align='center'><input type='hidden' name='creditor' value='{$mySal['creditor']}'>{$mySal['creditor']}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Reference no.</td>\n\t\t\t\t<td align='center'>{$mySal['refno']}</td>\n\t\t\t</tr>";
if ($mySal['creditor'] == "In House") {
$enterDeduct .= "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Expense Account</td>\n\t\t\t\t<td align='center'>" . mkAccSelect("expaccid", $expaccid, ACCTYPE_IE) . "</td>\n\t\t\t</tr>\n\t\t\t<input type='hidden' name='accid' value='0'>";
} else {
$enterDeduct .= "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Creditor Account</td>\n\t\t\t\t<td align='center'>" . mkAccSelect("accid", $accid, ACCTYPE_B) . "</td>\n\t\t\t</tr>\n\t\t\t<input type='hidden' name='expaccid' value='0'>";
}
$enterDeduct .= "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Creditor details</td>\n\t\t\t\t<td align='center'><input type='text' size='20' name='details' value='{$mySal['details']}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Deduction Type</td>\n\t\t\t\t<td>\n\t\t\t\t\t<input type='radio' name='type' value='Amount' {$check1}> Amount\n\t\t\t\t\t<input type='radio' name='type' value='Percentage' {$check2}> Percent\n\t\t\t\t</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td colspan='2' align='right'><input type='submit' value='Confirm »'></td>\n\t\t\t</tr>\n\t\t</form>\n\t\t</table>" . mkQuickLinks(ql("../admin-employee-add.php", "Add Employee"), ql("../admin-employee-view.php", "View Employees"));
return $enterDeduct;
}
function add($_POST, $err = "")
{
# Get vars
extract($_POST);
if (!isset($rnum)) {
$rnum = 1;
}
if ($rnum < 1) {
return "<li class='err'> - Invalid number of requisitions</li>";
}
core_connect();
# Check available funds
$cashacc = gethook("accnum", "bankacc", "name", "Petty Cash");
$sql = "SELECT (debit - credit) as bal FROM trial_bal WHERE accid = '{$cashacc}' AND month='" . (int) date("m") . "' 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>";
}
$jump_bot = "";
if (isset($another)) {
$jump_bot = "\n\t\t\t<script>\n\t\t\t\twindow.location.hash='bottom';\n\t\t\t</script>";
$rnum++;
}
$reqs = "";
for ($i = 0; $i < $rnum; $i++) {
core_connect();
$check1 = "";
$check2 = "";
$check3 = "";
if (isset($chrgvat[$i]) and $chrgvat[$i] == "nov") {
$check3 = "checked='yes'";
} elseif (isset($chrgvat[$i]) and $chrgvat[$i] == "exc") {
$check2 = "checked='yes'";
} else {
$check1 = "checked='yes'";
}
if (!isset($o_day[$i])) {
$trans_date_setting = getCSetting("USE_TRANSACTION_DATE");
if (isset($trans_date_setting) and $trans_date_setting == "yes") {
$trans_date_value = getCSetting("TRANSACTION_DATE");
$date_arr = explode("-", $trans_date_value);
$o_year[$i] = $date_arr[0];
$o_month[$i] = $date_arr[1];
$o_day[$i] = $date_arr[2];
} else {
$o_year[$i] = date("Y");
$o_month[$i] = date("m");
$o_day[$i] = date("d");
}
}
$reqs .= "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td nowrap>" . mkDateSelectA("o", $i, $o_year[$i], $o_month[$i], $o_day[$i]) . "</td>\n\t\t\t\t<td><input type='text' size='20' name='name[]' value='{$name[$i]}'></td>\n\t\t\t\t<td nowrap valign='center'>" . CUR . " <input type='text' size='6' name='amount[]' value='{$amount[$i]}'></td>\n\t\t\t\t<td><input type='text' size='26' name='details[]' value='{$details[$i]}'></td>\n\t\t\t\t<td valign='center'>\n\t\t\t\t\t<input type='radio' size='7' name='chrgvat[{$i}]' value='inc' {$check1}> Yes<br>\n\t\t\t\t\t<input type='radio' size='7' name='chrgvat[{$i}]' value='exc' {$check2}> No<br>\n\t\t\t\t\t<input type='radio' size='7' name='chrgvat[{$i}]' value='nov' {$check3}> No VAT\n\t\t\t\t</td>\n\t\t\t\t<td>" . mkAccSelect("accid[{$i}]", $accid[$i]) . "</td>\n\t\t\t</tr>";
}
$reqs .= "\n\t\t<tr class='" . bg_class() . "'>\n\t\t\t<td colspan='2' align='right'><b>Total:</b></td>\n\t\t\t<td>" . CUR . " " . sprint(array_sum($amount)) . "</td>\n\t\t\t<td colspan='3'></td>\n\t\t</tr>";
// Layout
$add = "\n\t\t<h3>Add Petty Cash Requisistions</h3>\n\t\t<form action='" . SELF . "' method='POST' name='form'>\n\t\t<table " . TMPL_tblDflts . " width='300'>\n\t\t\t<input type='hidden' name='key' value='confirm'>\n\t\t\t<input type='hidden' size='3' name='rnum' value='{$rnum}'>\n\t\t\t<tr>\n\t\t\t\t<td colspan='2'>{$err}</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<th>Field</th>\n\t\t\t\t<th>Value</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Available Funds</td>\n\t\t\t\t<td><input type='hidden' name='bal' value='{$accb['bal']}'>" . CUR . " {$accb['bal']}</td>\n\t\t\t</tr>\n\t\t</table>\n\t\t<p>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<th>Date</th>\n\t\t\t\t<th>Paid to</th>\n\t\t\t\t<th>Amount</th>\n\t\t\t\t<th>Details</th>\n\t\t\t\t<th>VAT Inclusive</th>\n\t\t\t\t<th>Account Paid to <input align='right' type='button' onClick=\"window.open('../core/acc-new2.php?update_parent=yes','accounts','width=700, height=400');\" value='New Account'></th>\n\t\t\t</tr>\n\t\t\t{$reqs}\n\t\t\t<tr><td><br></td></tr>\n\t\t\t<tr>\n\t\t\t\t<td><input type='submit' name='another' value='Add Another'></td>\n\t\t\t\t<td valign='center'><input type='submit' value='Confirm >'></td>\n\t\t\t</tr>\n\t\t</table>\n\t\t<a name='bottom'>\n\t\t{$jump_bot}\n\t\t<p>\n\t\t<table " . TMPL_tblDflts . " 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><a href='pettycashbook-view.php'>View Petty Cash Requisitions</a></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td><a href='../main.php'>Main Menu</a></td>\n\t\t\t</tr>\n\t\t</table>";
return $add;
}
function enter($_POST)
{
$shownewaccount = "";
extract($_POST);
if (isset($ledger) && $ledger != "sel") {
$ledgers = $ledger . "<input type='hidden' name='ledger' value='{$ledger}'>";
if ($ledger == "Customer Ledger") {
db_conn('cubit');
$Sl = "SELECT cusnum,accno,surname FROM customers WHERE location='loc' ORDER BY surname";
$Ri = db_exec($Sl) or errDie("Unable to select customer");
$accounts = "\n\t\t\t\t<select name='account' onchange='if (this.value==\"multi\") document.form.submit();'>\n\t\t\t\t\t<option value='sel'>Select Customer</option>\n\t\t\t\t\t<option value='multi'>Multiple Customers/One Receipt</option>";
while ($data = pg_fetch_array($Ri)) {
if (isset($account) && $account == $data['cusnum']) {
$sel = "selected";
} else {
$sel = "";
}
$accounts .= "<option value='{$data['cusnum']}' {$sel}>{$data['surname']}</option>";
}
$accounts .= "</select>";
} elseif ($ledger == "Employee Ledger") {
db_conn('cubit');
$Sl = "SELECT empnum,sname,fnames FROM employees ORDER BY sname,fnames";
$Ri = db_exec($Sl) or errDie("Unable to get employee data.");
$accounts = "\n\t\t\t\t<select name='account'>\n\t\t\t\t\t<option value='sel'>Select Employee</option>";
while ($data = pg_fetch_array($Ri)) {
if (isset($account) && $account == $data['empnum']) {
$sel = "selected";
} else {
$sel = "";
}
$accounts .= "<option value='{$data['empnum']}' {$sel}>{$data['sname']}, {$data['fnames']}</option>";
}
$accounts .= "</select>";
} elseif ($ledger == "General Ledger") {
$shownewaccount = "<input align='right' type='button' onClick=\"window.open('../core/acc-new2.php?update_parent=yes','accounts','width=700, height=400');\" value='New Account'>";
db_conn('core');
$Sl = "SELECT accid,accname,topacc,accnum FROM trial_bal WHERE period='" . PRD_DB . "' ORDER BY topacc,accnum";
$Ri = db_exec($Sl) or errDie("Unable to get accounts.");
$accounts = mkAccSelect("account", $account);
// $accounts = "
// <select name='account'>
// <option value='sel'>Select Account</option>";
// while($data = pg_fetch_array($Ri)) {
// if(isb($data['accid'])) {
// continue;
// }
// if(isset($account) && $account == $data['accid']) {
// $sel = "selected";
// } else {
// $sel = "";
// }
// $accounts .= "<option value='$data[accid]' $sel>$data[topacc]/$data[accnum] $data[accname]</option>";
// }
// $accounts .= "</select>";
} elseif ($ledger == "Inventory Ledger") {
db_conn('cubit');
$Sl = "SELECT stkid,stkcod FROM stock ORDER BY stkcod";
$Ri = db_exec($Sl) or errDie("unable to get stock.");
$accounts = "\n\t\t\t\t<select name='account'>\n\t\t\t\t\t<option value='sel'>Select Stock</option>";
while ($data = pg_fetch_array($Ri)) {
if (isset($account) && $account == $data['stkid']) {
$sel = "selected";
} else {
$sel = "";
}
$accounts .= "<option value='{$data['stkid']}' {$sel}>{$data['stkcod']}</option>";
}
$accounts .= "</select>";
} elseif ($ledger == "Supplier Ledger") {
db_conn('cubit');
$Sl = "SELECT supid,supname FROM suppliers WHERE location='loc' ORDER BY supname";
$Ri = db_exec($Sl) or errDie("unable to get suppliers.");
$accounts = "\n\t\t\t\t<select name='account'>\n\t\t\t\t\t<option value='sel'>Select Supplier</option>";
while ($data = pg_fetch_array($Ri)) {
if (isset($account) && $account == $data['supid']) {
$sel = "selected";
} else {
$sel = "";
}
$accounts .= "<option value='{$data['supid']}' {$sel}>{$data['supname']}</option>";
}
$accounts .= "</select>";
}
if ($ledger == "Employee Ledger") {
$types = "\n\t\t\t\t<select name='type' onChange='javascript:document.form.submit();'>\n\t\t\t\t\t<option value='sel'>Select Type</option>\n\t\t\t\t\t<option value='payment'>Payment</option>\n\t\t\t\t</select>";
} else {
$types = "\n\t\t\t\t<select name='type' onChange='javascript:document.form.submit();'>\n\t\t\t\t\t<option value='sel'>Select Type</option>\n\t\t\t\t\t<option value='payment'>Payment</option>\n\t\t\t\t\t<option value='receipt'>Receipt</option>\n\t\t\t\t</select>";
}
} else {
$ledgers = "\n\t\t\t<select name='ledger' onChange='javascript:document.form.submit();'>\n\t\t\t\t<option value='sel'>Select Ledger</option>\n\t\t\t\t<option value='Customer Ledger'>Customer Ledger</option>\n\t\t\t\t<option value='Employee Ledger'>Employee Ledger</option>\n\t\t\t\t<option value='General Ledger'>General Ledger</option>\n\t\t\t\t<option value='Inventory Ledger'>Inventory Ledger</option>\n\t\t\t\t<option value='Supplier Ledger'>Supplier Ledger</option>\n\t\t\t</select>";
$accounts = "";
$types = "";
}
if (isset($ledger) && $ledger == "Customer Ledger" && isset($account) && $account == "multi") {
header("Location: bank-recpt-multi-debtor.php");
exit;
} else {
if (isset($ledger) && $ledger != "sel" && isset($account) && $account != "sel" && isset($type) && $type != "sel") {
if ($ledger == "Customer Ledger") {
if ($type == "payment") {
header("Location: bank-pay-cus.php?cusnum={$account}");
exit;
} elseif ($type == "receipt") {
header("Location: bank-recpt-inv.php?cusnum={$account}&e=yes");
exit;
}
} elseif ($ledger == "Employee Ledger") {
if ($type == "payment") {
header("Location: ../salwages/employee-pay.php?id={$account}&bankpay=t");
exit;
}
} elseif ($ledger == "General Ledger") {
if ($type == "payment") {
header("Location: bank-pay-add.php?account={$account}");
exit;
} elseif ($type == "receipt") {
header("Location: bank-recpt-add.php?account={$account}");
exit;
}
} elseif ($ledger == "Supplier Ledger") {
if ($type == "payment") {
header("Location: bank-pay-supp.php?supid={$account}&e=yes");
exit;
} elseif ($type == "receipt") {
header("Location: bank-recpt-supp.php?account={$account}&e=yes");
exit;
}
} elseif ($ledger == "Inventory Ledger") {
if ($type == "payment") {
header("Location: stock-tran.php?account={$account}&type=payment&e=yes");
exit;
} elseif ($type == "receipt") {
header("Location: stock-tran.php?account={$account}&type=receipt&e=yes");
exit;
}
}
}
}
$out = "\n\t\t<h3>Cashbook Entry</h3>\n\t\t<table border='0' cellpadding='1' cellspacing='1'>\n\t\t<form action='" . SELF . "' method='POST' name='form'>\n\t\t\t<tr>\n\t\t\t\t<th>Select Ledger</th>\n\t\t\t\t<th>Select Account {$shownewaccount}</th>\n\t\t\t\t<th>Type</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>{$ledgers}</td>\n\t\t\t\t<td>{$accounts}</td>\n\t\t\t\t<td>{$types}</td>\n\t\t\t</tr>\n\t\t</form>\n\t\t</table>";
return $out;
}
function add($_POST)
{
extract($_POST);
if (!isset($name)) {
$bankid = 0;
$laccid = 0;
$day = date("d");
$mon = date("m");
$year = date("Y");
$name = "Petty Cash";
$descript = "";
$cheqnum = "";
$amount = "";
$frm = "";
}
if (!isset($laccid)) {
$laccid = 0;
}
if (!isset($bankid)) {
$bankid = 0;
}
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);
# Accounts Drop down selections
core_connect();
$sql = "SELECT * FROM accounts WHERE div = '" . USER_DIV . "' ORDER BY topacc,accnum ASC";
$laccRslt = db_exec($sql);
if (pg_numrows($laccRslt) < 1) {
return "<li class='err'> There are no accounts yet in Cubit.</li>";
}
$glacc = mkAccSelect("laccid", $laccid);
// $glacc = "<select name='laccid'>";
// while($lacc = pg_fetch_array($laccRslt)){
// # Check Disable
// if(isDisabled($lacc['accid']))
// continue;
// if($laccid == $lacc['accid']) {
// $sel = "selected";
// } else {
// $sel = "";
// }
// $glacc .= "<option value='$lacc[accid]' $sel>$lacc[topacc]/$lacc[accnum] - $lacc[accname]</option>";
// }
// $glacc .= "</select>";
db_connect();
$sql = "SELECT * FROM bankacct WHERE btype != 'int' AND div = '" . USER_DIV . "' ORDER BY bankname,branchname";
$banks = db_exec($sql);
if (pg_numrows($banks) < 1) {
return "\n\t\t\t<li class='err'> There are no bank accounts yet on the Database.</li>\n\t\t\t<p><input type='button' onClick='JavaScript:history.back();' value='« Correct Selection'>";
}
$banksel = "<select name='bankid'>";
while ($bacc = pg_fetch_array($banks)) {
if ($bacc['bankid'] == $bankid) {
$sel = "selected";
} else {
$sel = "";
}
$banksel .= "<option value='{$bacc['bankid']}' {$sel}>{$bacc['accname']} - {$bacc['bankname']} ({$bacc['acctype']})</option>";
}
$banksel .= "</select>";
if ($frm == "gl") {
$c1 = "";
$c2 = "checked=yes";
} else {
$c1 = "checked=yes";
$c2 = "";
}
if (!isset($date_day)) {
$trans_date_setting = getCSetting("USE_TRANSACTION_DATE");
if (isset($trans_date_setting) and $trans_date_setting == "yes") {
$trans_date_value = getCSetting("TRANSACTION_DATE");
$date_arr = explode("-", $trans_date_value);
$date_year = $date_arr[0];
$date_month = $date_arr[1];
$date_day = $date_arr[2];
} else {
$date_year = date("Y");
$date_month = date("m");
$date_day = date("d");
}
}
// Layout
$add = "\n\t\t<h3>Funds transfer to Petty cash</h3>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t<form action='" . SELF . "' method='POST' name='form'>\n\t\t\t<input type='hidden' name='key' value='confirm'>\n\t\t\t<tr>\n\t\t\t\t<th width='40%'>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><input type='radio' name='frm' value='bnk' {$c1}>From Bank Account</td>\n\t\t\t\t<td>{$banksel}</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td><input type='radio' name='frm' value='gl' {$c2}>From Account <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\t<td>{$glacc}</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("date", $date_year, $date_month, $date_day) . "</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Paid to</td>\n\t\t\t\t<td valign='center'><input size='20' name='name' value='{$name}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Description</td>\n\t\t\t\t<td valign='center'><textarea cols='18' rows='2' name='descript'>{$descript}</textarea></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Cheque Number</td>\n\t\t\t\t<td valign='center'><input size='10' name='cheqnum' value='{$cheqnum}'></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='10' name='amount' value='{$amount}'></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>Petty Cash Account</td>\n\t\t\t\t<td><input type='hidden' name='accinv' value='{$acc['accid']}'>{$acc['topacc']}/{$acc['accnum']} - {$acc['accname']}</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></td>\n\t\t\t\t<td valign='center' align='right'><input type='submit' value='Confirm »'></td>\n\t\t\t</tr>\n\t\t</table>";
# main table (layout with menu)
$OUTPUT = "\n\t\t<center>\n\t\t<table width='100%'>\n\t\t\t<tr>\n\t\t\t\t<td width='65%' align='left'>{$add}</td>\n\t\t\t\t<td valign='top' align='center'>\n\t\t\t\t\t<table " . TMPL_tblDflts . " width='65%'>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th>Quick Links</th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t\t\t\t\t</table>\n\t\t\t\t</td>\n\t\t\t</tr>\n\t\t</table>";
return $OUTPUT;
}
