function printOrd($_POST, $pure = false)
{
extract($_POST);
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($from_day, "num", 1, 2, "Invalid from Date day.");
$v->isOk($from_month, "num", 1, 2, "Invalid from Date month.");
$v->isOk($from_year, "num", 1, 4, "Invalid from Date Year.");
$v->isOk($to_day, "num", 1, 2, "Invalid to Date day.");
$v->isOk($to_month, "num", 1, 2, "Invalid to Date month.");
$v->isOk($to_year, "num", 1, 4, "Invalid to Date Year.");
# mix dates
$fromdate = $from_year . "-" . $from_month . "-" . $from_day;
$todate = $to_year . "-" . $to_month . "-" . $to_day;
if (!checkdate($from_month, $from_day, $from_year)) {
$v->isOk($fromdate, "num", 1, 1, "Invalid from date.");
}
if (!checkdate($to_month, $to_day, $to_year)) {
$v->isOk($todate, "num", 1, 1, "Invalid to date.");
}
require_lib("docman");
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class='err'>-" . $e["msg"] . "</li>";
}
return $confirm;
}
# Set up table to display in
$printOrd = "";
if (!$pure) {
$printOrd .= "\n\t\t\t\t\t\t<center>\n\t\t\t\t\t\t<h3>View International Stock Purchases</h3>";
}
$printOrd .= "\n\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th>Purchase No.</th>\n\t\t\t\t\t\t\t<th>Purchase Date</th>\n\t\t\t\t\t\t\t<th>Received Date</th>\n\t\t\t\t\t\t\t<th>Supplier</th>\n\t\t\t\t\t\t\t<th>Sub Total</th>\n\t\t\t\t\t\t\t<th>Shipping Charges</th>\n\t\t\t\t\t\t\t<th>Tax</th>\n\t\t\t\t\t\t\t<th colspan='2'>Total Cost Amount</th>\n\t\t\t\t\t\t\t<th>Documents</th>\n\t\t\t\t\t\t\t<th colspan='5'>Options</th>\n\t\t\t\t\t\t</tr>";
# connect to database
db_connect();
# Query server
$i = 0;
$sql = "SELECT * FROM purch_int WHERE pdate >= '{$fromdate}' AND pdate <= '{$todate}' AND div = '" . USER_DIV . "' ORDER BY pdate DESC";
$stkpRslt = db_exec($sql) or errDie("Unable to retrieve stock purchases from database.");
if (pg_numrows($stkpRslt) < 1) {
return "\n\t\t\t\t<li class='err'> There are no previous stock purchases.</li>" . mkQuickLinks(ql("purch-int-new.php", "New International Order"), ql("purch-int-view.php", "View International Orders"), ql("stock-view.php", "View Stock"));
}
while ($stkp = pg_fetch_array($stkpRslt)) {
# Date format
$date = explode("-", $stkp['pdate']);
$date = $date[2] . "-" . $date[1] . "-" . $date[0];
$ddate = explode("-", $stkp["ddate"]);
$ddate = "{$ddate['2']}-{$ddate['1']}-{$ddate['0']}";
# Get supplier
db_connect();
$sql = "SELECT supname,currency FROM suppliers WHERE supid = '{$stkp['supid']}' AND div = '" . USER_DIV . "'";
$supRslt = db_exec($sql);
if (pg_numrows($supRslt) < 1) {
$sup['supname'] = "<li class='err'>Supplier not found";
$sup['currency'] = "";
} else {
$sup = pg_fetch_array($supRslt);
}
# Calculate the Sub-Total
$subtot = sprint($stkp['total'] - $stkp['shipchrg']);
$stkp['tax'] = sprint($stkp['tax']);
$stkp['shipchrg'] = sprint($stkp['shipchrg']);
# Get documents
$docs = doclib_getdocs("ipur", $stkp['purnum']);
$sp4 = " ";
$printOrd .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>{$stkp['purnum']}</td>\n\t\t\t\t\t<td>{$date}</td>\n\t\t\t\t\t<td>{$ddate}</td>\n\t\t\t\t\t<td>{$sup['supname']}</td>\n\t\t\t\t\t<td align='right' nowrap>{$stkp['curr']} {$subtot}</td>\n\t\t\t\t\t<td align='right' nowrap>{$stkp['curr']} {$stkp['shipchrg']}</td>\n\t\t\t\t\t<td align='right' nowrap>{$stkp['curr']} {$stkp['tax']}</td>\n\t\t\t\t\t<td align='right' nowrap>{$sp4} {$stkp['curr']} {$stkp['total']}</td>\n\t\t\t\t\t<td align='right' nowrap>{$sp4} " . CUR . " {$stkp['fbalance']}</td>\n\t\t\t\t\t<td>{$docs}</td>\n\t\t\t\t\t<td><a href='javascript: printer(\"purch-int-det.php?purid={$stkp['purid']}\");'>Print</a></td>";
if ($stkp['received'] != "y" && $subtot == 0) {
$printOrd .= "\n\t\t\t\t\t<td colspan='2' align='center'><a href='purch-int-new.php?purid={$stkp['purid']}&cont=1&letters=&done='>Edit</a></td>\n\t\t\t\t\t<td><br></td>\n\t\t\t\t\t<td><a href='purch-int-cancel.php?purid={$stkp['purid']}'>Cancel</a></td>\n\t\t\t\t</tr>";
} elseif ($stkp['received'] != 'y') {
$recinv = "<br>";
if ($stkp['invcd'] != 'y') {
$recinv = "<a href='purch-int-recinvcd.php?purid={$stkp['purid']}'>Record Invoice</a>";
}
$printOrd .= "\n\t\t\t\t\t<td><a href='purch-int-new.php?purid={$stkp['purid']}&cont=1&letters=&done='>Edit</a></td>\n\t\t\t\t\t<td><a href='purch-int-recv.php?purid={$stkp['purid']}'>Received</a></td>\n\t\t\t\t\t<td>{$recinv}</td>\n\t\t\t\t\t<td><a href='purch-int-cancel.php?purid={$stkp['purid']}'>Cancel</a></td>\n\t\t\t\t</tr>";
} else {
$recinv = "<br>";
if ($stkp['invcd'] != 'y') {
$recinv = "<a href='purch-int-recinvcd.php?purid={$stkp['purid']}'>Record Invoice</a>";
}
$printOrd .= "\n\t\t\t\t\t<td colspan='2'>Received</td>\n\t\t\t\t\t<td>{$recinv}</td>\n\t\t\t\t\t<td><br></td>\n\t\t\t\t</tr>";
}
$i++;
}
if (!$pure) {
$printOrd .= "\n\t\t" . TBL_BR . "\n\t\t<form action='" . SELF . "' method='POST'>\n\t\t\t<input type='hidden' name='key' value='export'>\n\t\t\t<input type='hidden' name='from_day' value='{$from_day}'>\n\t\t\t<input type='hidden' name='from_month' value='{$from_month}'>\n\t\t\t<input type='hidden' name='from_year' value='{$from_year}'>\n\t\t\t<input type='hidden' name='to_day' value='{$to_day}'>\n\t\t\t<input type='hidden' name='to_month' value='{$to_month}'>\n\t\t\t<input type='hidden' name='to_year' value='{$to_year}'>\n\t\t\t<tr>\n\t\t\t\t<td colspan='3'><input type='submit' value='Export to Spreadsheet'></td>\n\t\t\t</tr>\n\t\t</form>";
}
if (!$pure) {
$printOrd .= "\n\t\t</table>";
}
if (!$pure) {
$printOrd .= mkQuickLinks(ql("purch-int-new.php", "New International Purchase"), ql("stock-report.php", "Stock Control Reports"), ql("stock-view.php", "View Stock"));
}
return $printOrd;
}
function printInvoice($_POST)
{
# get vars
extract($_POST);
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($from_day, "num", 1, 2, "Invalid from Date day.");
$v->isOk($from_month, "num", 1, 2, "Invalid from Date month.");
$v->isOk($from_year, "num", 1, 4, "Invalid from Date Year.");
$v->isOk($to_day, "num", 1, 2, "Invalid to Date day.");
$v->isOk($to_month, "num", 1, 2, "Invalid to Date month.");
$v->isOk($to_year, "num", 1, 4, "Invalid to Date Year.");
# mix dates
$fromdate = $from_year . "-" . $from_month . "-" . $from_day;
$todate = $to_year . "-" . $to_month . "-" . $to_day;
if (!checkdate($from_month, $from_day, $from_year)) {
$v->isOk($fromdate, "num", 1, 1, "Invalid from date.");
}
if (!checkdate($to_month, $to_day, $to_year)) {
$v->isOk($todate, "num", 1, 1, "Invalid to date.");
}
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class='err'>{$e['msg']}</li>";
}
return $confirm;
}
# Set up table to display in
$printOrd = "\r\n\t\t<center>\r\n\t\t<h3>View Non-Stock Invoices</h3>\r\n\t\t<table " . TMPL_tblDflts . ">\r\n\t\t<form action='invoice-proc.php' method='GET'>\r\n\t\t\t<input type='hidden' name='t' value='i'>\r\n\t\t\t<tr>\r\n\t\t\t\t<th>Invoice Num</th>\r\n\t\t\t\t<th>Proforma Inv No.</th>\r\n\t\t\t\t<th>Invoice Date</th>\r\n\t\t\t\t<th>Customer</th>\r\n\t\t\t\t<th>Total</th>\r\n\t\t\t\t<th>Documents</th>\r\n\t\t\t\t<th colspan='6'>Options</th>\r\n\t\t\t</tr>";
# connect to database
db_connect();
# Query server
$i = 0;
$tot_subtot = 0;
$tot_total = 0;
$sql = "SELECT * FROM nons_invoices WHERE typ = 'inv' AND sdate >= '{$fromdate}' \tAND sdate <= '{$todate}' \tAND div = '" . USER_DIV . "' AND balance = 0 AND done = 'y' ORDER BY invnum";
$nonstksRslt = db_exec($sql) or errDie("Unable to retrieve invoices from database.");
if (pg_numrows($nonstksRslt) < 1) {
return "<li> There are no non stock invoices found.</li>";
}
// Retrieve the PDF reprints
db_conn("cubit");
$sql = "SELECT filename FROM template_settings WHERE template='reprints' AND div='" . USER_DIV . "'";
$tsRslt = db_exec($sql) or errDie("Unable to retrieve template settings from Cubit.");
$template = pg_fetch_result($tsRslt, 0);
while ($nonstks = pg_fetch_array($nonstksRslt)) {
# date format
$date = explode("-", $nonstks['odate']);
$date = $date[2] . "-" . $date[1] . "-" . $date[0];
// compute the totals
if ($nonstks["xrate"] == 0.0) {
$tot_subtot += $nonstks["subtot"];
$tot_total += $nonstks["total"];
} else {
$tot_subtot += $nonstks["subtot"] * $nonstks["xrate"];
$tot_total += $nonstks["total"] * $nonstks["xrate"];
}
if ($nonstks['invnum'] == 0) {
$nonstks['invnum'] = $nonstks['invid'];
}
$det = "nons-invoice-det.php";
$edit = "nons-invoice-new.php";
$print = "nons-invoice-print.php";
$reprint = "nons-invoice-reprint.php";
$note = "nons-invoice-note.php";
if ($template == "default") {
$template = "nons-invoice-pdf-reprint.php";
} elseif ($template == "new") {
$template = "pdf-tax-invoice.php";
}
$reprpdf = $template;
$cur = CUR;
if ($nonstks['location'] == 'int') {
$det = "nons-intinvoice-det.php";
$edit = "nons-intinvoice-new.php";
$print = "nons-intinvoice-print.php";
$note = "nons-intinvoice-note.php";
if ($template == "default") {
$template = "nons-intinvoice-pdf-reprint.php";
} elseif ($template == "new") {
$template = "pdf-tax-invoice.php";
}
$reprpdf = $template;
$note = "nons-intinvoice-note.php";
$cur = $nonstks['currency'];
}
# Get documents
$docs = doclib_getdocs("ninv", $nonstks['invnum']);
if ($nonstks['accepted'] == " " && $nonstks['done'] != "y") {
$chbox = "<input type=checkbox name='evs[{$nonstks['invid']}]' value='{$nonstks['invid']}' checked=yes>";
} else {
$chbox = "";
}
$printOrd .= "\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td>{$nonstks['invnum']}</td>\r\n\t\t\t\t<td>{$nonstks['docref']}</td>\r\n\t\t\t\t<td>{$date}</td>\r\n\t\t\t\t<td>{$nonstks['cusname']}</td>\r\n\t\t\t\t<td align=right>{$cur} {$nonstks['total']}</td>\r\n\t\t\t\t<td>{$docs}</td>\r\n\t\t\t\t<td>{$chbox}</td>\r\n\t\t\t\t<td><a href='{$det}?invid={$nonstks['invid']}'>Details</a></td>";
if ($nonstks['done'] != "y" && $nonstks["subtot"] == 0) {
$printOrd .= "\r\n\t\t\t\t\t<td><a href='{$edit}?invid={$nonstks['invid']}&cont=1'>Edit</a></td>\r\n\t\t\t\t\t<td><a href='?key=delete_confirm&invid={$nonstks['invid']}'>Delete</a></td>\r\n\t\t\t\t</tr>";
} elseif ($nonstks['done'] != "y") {
$printOrd .= "\r\n\t\t\t\t\t<td><a href='{$edit}?invid={$nonstks['invid']}&cont=1'>Edit</a></td>\r\n\t\t\t\t\t<td><a href='?key=delete_confirm&invid={$nonstks['invid']}'>Delete</a></td>\r\n\t\t\t\t\t<td><a href=# onClick=printer('{$print}?invid={$nonstks['invid']}&type=nons')>Process</a></td>\r\n\t\t\t\t</tr>";
} else {
$cn = "";
$printOrd .= "\r\n\t\t\t\t\t<td>{$cn}</td>\r\n\t\t\t\t\t<td><a target='_blank' href='{$reprint}?invid={$nonstks['invid']}&type=nonsreprint'>Reprint</a></td>\r\n\t\t\t\t\t<td><a href='pdf/{$reprpdf}?invid={$nonstks['invid']}&type=nonsreprint' target=_blank>Reprint in PDF</a></td>\r\n\t\t\t\t\t<td><input type=checkbox name='evs[{$nonstks['invid']}]'></td>\r\n\t\t\t\t</tr>";
}
$i++;
}
$tot_total = sprint($tot_total);
$printOrd .= "\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td colspan='4'>Totals</td>\r\n\t\t\t\t<td align='right'>" . CUR . " {$tot_total}</td>\r\n\t\t\t\t<td colspan='4' align='right'><input type='submit' value='Process Selected' name='print'></td>\r\n\t\t\t\t<td colspan='3' align='right'><input type='submit' value='Email Selected' name='email'></td>\r\n\t\t\t</tr>\r\n\t\t</table>\r\n\t <p>\r\n\t\t<table " . TMPL_tblDflts . ">\r\n\t <tr><td><br></td></tr>\r\n\t <tr>\r\n\t \t<th>Quick Links</th>\r\n\t </tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td><a href='nons-invoice-new.php'>New Non-Stock Invoices</a></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t<td><a href='main.php'>Main Menu</a></td>\r\n\t\t\t</tr>\r\n\t\t</table>";
return $printOrd;
}
function printNote($_POST)
{
# Get vars
extract($_POST);
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($from_day, "num", 1, 2, "Invalid from Date day.");
$v->isOk($from_month, "num", 1, 2, "Invalid from Date month.");
$v->isOk($from_year, "num", 1, 4, "Invalid from Date Year.");
$v->isOk($to_day, "num", 1, 2, "Invalid to Date day.");
$v->isOk($to_month, "num", 1, 2, "Invalid to Date month.");
$v->isOk($to_year, "num", 1, 4, "Invalid to Date Year.");
# Mix dates
$fromdate = $from_year . "-" . $from_month . "-" . $from_day;
$todate = $to_year . "-" . $to_month . "-" . $to_day;
if (!checkdate($from_month, $from_day, $from_year)) {
$v->isOk($fromdate, "num", 1, 1, "Invalid from date.");
}
if (!checkdate($to_month, $to_day, $to_year)) {
$v->isOk($todate, "num", 1, 1, "Invalid to date.");
}
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class='err'>-" . $e["msg"] . "<br>";
}
return $confirm;
}
# Set up table to display in
$printNote = "\n\t\t\t\t\t<h3>Non Stock Credit notes</h3>\n\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th>Credit Note No.</th>\n\t\t\t\t\t\t\t<th>Invoice No.</th>\n\t\t\t\t\t\t\t<th>Date</th>\n\t\t\t\t\t\t\t<th>Customer Name</th>\n\t\t\t\t\t\t\t<th>Grand Total</th>\n\t\t\t\t\t\t\t<th>Documents</th>\n\t\t\t\t\t\t\t<th colspan='3'>Options</th>\n\t\t\t\t\t\t</tr>";
# connect to database
db_connect();
# Query server
$i = 0;
$tot1 = 0;
$sql = "SELECT * FROM nons_inv_notes WHERE date >= '{$fromdate}' AND date <= '{$todate}' AND div = '" . USER_DIV . "' ORDER BY noteid DESC";
$noteRslt = db_exec($sql) or errDie("Unable to retrieve invoices from database.");
if (pg_numrows($noteRslt) < 1) {
$printNote = "<li>No previous credit notes.";
} else {
while ($note = pg_fetch_array($noteRslt)) {
$note['total'] = sprint($note['total']);
$tot1 = $tot1 + $note['total'];
# Format date
$note['date'] = explode("-", $note['date']);
$note['date'] = $note['date'][2] . "-" . $note['date'][1] . "-" . $note['date'][0];
$cur = CUR;
if ($note['location'] == 'int') {
$cur = $note['currency'];
}
# Get documents
$docs = doclib_getdocs("note", $note['notenum']);
$printNote .= "\n\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t\t<td>{$note['notenum']}</td>\n\t\t\t\t\t\t\t\t<td>{$note['invnum']}</td>\n\t\t\t\t\t\t\t\t<td align='center'>{$note['date']}</td>\n\t\t\t\t\t\t\t\t<td>{$note['cusname']}</td>\n\t\t\t\t\t\t\t\t<td align='right'>{$cur} {$note['total']}</td>\n\t\t\t\t\t\t\t\t<td>{$docs}</td>\n\t\t\t\t\t\t\t\t<td><a href='nons-invoice-note-det.php?noteid={$note['noteid']}'>Details</a></td>\n\t\t\t\t\t\t\t\t<td><a href='nons-invoice-note-reprint.php?noteid={$note['noteid']}' target=_blank>Reprint</a></td>\n\t\t\t\t\t\t\t</tr>";
$i++;
}
}
$tot1 = sprint($tot1);
// Layout
if ($tot1 > 0) {
$printNote .= "\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td colspan='4'>Totals:{$i}</td>\n\t\t\t\t\t\t\t<td align='right'>{$cur} {$tot1}</td>\n\t\t\t\t\t\t\t<td align='right'></td>\n\t\t\t\t\t\t</tr>";
}
$printNote .= "\n\t\t\t\t\t</table>\n\t\t\t\t<p>\n\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t<tr><td><br></td></tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<th>Quick Links</th>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t\t\t\t</table>";
return $printNote;
}
function printInv($_POST)
{
# get vars
extract($_POST);
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($from_day, "num", 1, 2, "Invalid from Date day.");
$v->isOk($from_month, "num", 1, 2, "Invalid from Date month.");
$v->isOk($from_year, "num", 1, 4, "Invalid from Date Year.");
$v->isOk($to_day, "num", 1, 2, "Invalid to Date day.");
$v->isOk($to_month, "num", 1, 2, "Invalid to Date month.");
$v->isOk($to_year, "num", 1, 4, "Invalid to Date Year.");
# mix dates
$fromdate = $from_year . "-" . $from_month . "-" . $from_day;
$todate = $to_year . "-" . $to_month . "-" . $to_day;
if (!checkdate($from_month, $from_day, $from_year)) {
$v->isOk($fromdate, "num", 1, 1, "Invalid from date.");
}
if (!checkdate($to_month, $to_day, $to_year)) {
$v->isOk($todate, "num", 1, 1, "Invalid to date.");
}
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class='err'>{$e['msg']}</li>";
}
return $confirm;
}
$accnum = remval($accnum);
if (strlen($accnum) > 0) {
db_conn('cubit');
$Sl = "SELECT * FROM customers WHERE lower(accno)=lower('{$accnum}')";
$Ri = db_exec($Sl);
if (pg_num_rows($Ri) < 1) {
return "<li class='err'>Invalid account number</li>" . slct();
}
$cd = pg_fetch_array($Ri);
$cusnum = $cd['cusnum'];
}
# Set up table to display in
$printInv = "\n\t\t<h3>Paid Invoices</h3>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<th>Department</th>\n\t\t\t\t<th>Invoice No.</th>\n\t\t\t\t<th>Proforma Inv No.</th>\n\t\t\t\t<th>Invoice Date</th>\n\t\t\t\t<th>Customer Name</th>\n\t\t\t\t<th>Order No</th>\n\t\t\t\t<th>Customer Order No</th>\n\t\t\t\t<th>Grand Total</th>\n\t\t\t\t<th>Documents</th>\n\t\t\t\t<th colspan='5'>Options</th>\n\t\t\t</tr>";
// Retrieve template setting
db_conn("cubit");
$sql = "SELECT filename FROM template_settings WHERE template='invoices'";
$tsRslt = db_exec($sql) or errDie("Unable to retrieve template settings from Cubit.");
$template = pg_fetch_result($tsRslt, 0);
if ($template == "invoice-print.php") {
$repr = "invoice-reprint-prd.php";
} else {
$repr = $template;
}
db_conn("cubit");
$sql = "SELECT filename FROM template_settings WHERE template='reprints'";
$tsRslt = db_exec($sql) or errDie("Unable to retrieve template settings from Cubit.");
$template = pg_fetch_result($tsRslt, 0);
if ($template == "new") {
$pdf_repr = "pdf/pdf-tax-invoice.php";
} else {
$pdf_repr = "pdf/invoice-pdf-reprint-prd.php";
}
# Query server
$i = 0;
$tot1 = 0;
$tot2 = 0;
if (isset($all)) {
# Connect to database
db_connect();
$queries = array();
for ($i = 1; $i <= 12; $i++) {
$schema = (int) $i;
$queries[] = "SELECT *,'{$schema}' AS query_schema FROM \"{$schema}\".invoices WHERE done = 'y' AND odate >= '{$fromdate}' AND odate <= '{$todate}' AND div = '" . USER_DIV . "'";
}
$query = implode(" UNION ", $queries);
$query .= " ORDER BY invid DESC";
} else {
# Connect to database
db_connect();
$queries = array();
for ($i = 1; $i <= 12; $i++) {
$schema = (int) $i;
$queries[] = "SELECT *,'{$schema}' AS query_schema FROM \"{$schema}\".invoices WHERE done = 'y' AND cusnum = '{$cusnum}' AND odate >= '{$fromdate}' AND odate <= '{$todate}' AND div = '" . USER_DIV . "'";
}
$query = implode(" UNION ", $queries);
$query .= " ORDER BY invid DESC";
}
$invRslt = db_exec($query) or errDie("Unable to retrieve invoices from database.");
if (pg_numrows($invRslt) < 1) {
$printInv = "<li class='err'>No previous finished invoices found.</li>";
} else {
while ($inv = pg_fetch_array($invRslt)) {
$prd = $inv["query_schema"];
$inv['total'] = sprint($inv['total']);
$inv['balance'] = sprint($inv['balance']);
$tot1 = $tot1 + $inv['total'];
$tot2 = $tot2 + $inv['balance'];
# format date
$inv['odate'] = explode("-", $inv['odate']);
$inv['odate'] = $inv['odate'][2] . "-" . $inv['odate'][1] . "-" . $inv['odate'][0];
# Get documents
$docs = doclib_getdocs("inv", $inv['invnum']);
$sp4 = " ";
$bcurr = CUR;
$det = "invoice-details-prd.php";
$reprint = "<td><a target=_blank href='{$repr}?type=invpaidreprint&invid={$inv['invid']}&prd={$prd}'>Reprint</a></td>";
$note = "<td><a target=_blank href='invoice-note-prd.php?invid={$inv['invid']}&prd={$prd}'>Credit Note</a></td>";
if ($inv['location'] == 'int') {
$bcurr = $inv['currency'];
$det = "intinvoice-details-prd.php";
$reprint = "<td><a target='_blank' href='intinvoice-reprint-prd.php?invid={$inv['invid']}&prd={$prd}'>Reprint</a></td>";
$note = "";
}
$delnote = "<td><a target='_blank' href='invoice-delnote-prd.php?invid={$inv['invid']}&prd={$prd}'>Delivery Note</a></td>";
$printInv .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>{$inv['deptname']}</td>\n\t\t\t\t\t<td>{$inv['invnum']}</td>\n\t\t\t\t\t<td>{$inv['docref']}</td>\n\t\t\t\t\t<td align='center'>{$inv['odate']}</td>\n\t\t\t\t\t<td>{$inv['cusname']} {$inv['surname']}</td>\n\t\t\t\t\t<td align='right'>{$inv['ordno']}</td>\n\t\t\t\t\t<td align='right'>{$inv['cordno']}</td>\n\t\t\t\t\t<td align='right' nowrap>{$bcurr} {$inv['total']}</td>\n\t\t\t\t\t<td>{$docs}</td>\n\t\t\t\t\t<td><a href='{$det}?invid={$inv['invid']}&prd={$prd}'>Details</a></td>\n\t\t\t\t\t</td>{$reprint}</td>\n\t\t\t\t\t<td><a href='{$pdf_repr}?invid={$inv['invid']}&prd={$prd}&type=invpaidreprint' target='_blank'>Reprint in PDF</a></td>\n\t\t\t\t\t{$note}\n\t\t\t\t\t{$delnote}\n\t\t\t\t</tr>";
$i++;
}
}
$tot1 = sprint($tot1);
$tot2 = sprint($tot2);
// Layout
if ($tot1 > 0) {
$printInv .= "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td colspan='7'>Totals:{$i}</td>\n\t\t\t\t<td align='right'>{$tot1}</td>\n\t\t\t\t<td align='right' colspan='6'></td>\n\t\t\t</tr>";
}
$printInv .= "\n\t\t</table>\n\t\t<p>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t" . TBL_BR . "\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='invoice-canc-view.php'>View Cancelled Invoices</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td><a href='invoice-unf-view.php'>View Incomplete Invoices</td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td><a href='cust-credit-stockinv.php'>New Invoice</td>\n\t\t\t</tr>\n\t\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t\t</table>";
return $printInv;
}
function printPurch($_POST)
{
extract($_POST);
# validate input
require_lib("validate");
$v = new validate();
# mix dates
$fromdate = $from_year . "-" . $from_month . "-" . $from_day;
$todate = $to_year . "-" . $to_month . "-" . $to_day;
$v->isOk($fromdate, "date", 1, 1, "Invalid From Date.");
$v->isOk($todate, "date", 1, 1, "Invalid To Date.");
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class='err'>{$e['msg']}</li>";
}
return $confirm;
}
$check1 = "";
$check2 = "";
if (!isset($filter) or $filter == "summary") {
$check1 = "checked='yes'";
} else {
$check2 = "checked='yes'";
}
$ocheck1 = "";
$ocheck2 = "";
if (!isset($order) or $order == "date") {
$ocheck1 = "checked='yes'";
} else {
$ocheck2 = "checked='yes'";
}
# Set up table to display in
$printOrd = "\n\t\t<center>\n\t\t<form action='" . SELF . "' method='POST' name='form1'>\n\t\t\t<input type='hidden' name='key' value='export'>\n\t\t\t<input type='hidden' name='fday' value='{$from_day}'>\n\t\t\t<input type='hidden' name='fmon' value='{$from_month}'>\n\t\t\t<input type='hidden' name='fyear' value='{$from_year}'>\n\t\t\t<input type='hidden' name='today' value='{$to_day}'>\n\t\t\t<input type='hidden' name='tomon' value='{$to_month}'>\n\t\t\t<input type='hidden' name='toyear' value='{$to_year}'>\n\n\t\t\t<input type='hidden' name='from_day' value='{$from_day}'>\n\t\t\t<input type='hidden' name='from_month' value='{$from_month}'>\n\t\t\t<input type='hidden' name='from_year' value='{$from_year}'>\n\t\t\t<input type='hidden' name='to_day' value='{$to_day}'>\n\t\t\t<input type='hidden' name='to_month' value='{$to_month}'>\n\t\t\t<input type='hidden' name='to_year' value='{$to_year}'>\n\n\t\t<h3>View Stock Orders</h3>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<th colspan='2'>Filter</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td><input type='radio' name='filter' value='summary' {$check1} onClick=\"document.form1.submit();\"> Summary</td>\n\t\t\t\t<td><input type='radio' name='filter' value='detailed' {$check2} onClick=\"document.form1.submit();\"> Detailed</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'>Order</th>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td><input type='radio' name='order' value='date' {$ocheck1} onClick=\"document.form1.submit();\"> Date</td>\n\t\t\t\t<td><input type='radio' name='order' value='numeric' {$ocheck2} onClick=\"document.form1.submit();\"> Numeric</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>No.</th>\n\t\t\t\t<th>Order No.</th>\n\t\t\t\t<th>Supp Inv No.</th>\n\t\t\t\t<th>Order Date</th>\n\t\t\t\t<th>Supplier</th>\n\t\t\t\t<th>Sub Total</th>\n\t\t\t\t<th>Delivery Charges</th>\n\t\t\t\t<th>Vat</th>\n\t\t\t\t<th>Total</th>\n\t\t\t\t<th>Documents</th>\n\t\t\t\t<th colspan='8'>Options</th>\n\t\t\t</tr>";
# connect to database
db_connect();
$supsql = "";
if (isset($supplier) and $supplier != 0) {
$supsql = " AND supid = '{$supplier}'";
}
# Query server
$i = 0;
$tot1 = 0;
$tot2 = 0;
$tot3 = 0;
$tot4 = 0;
if (isset($order) and $order == "numeric") {
$orderby = "purnum::integer";
} else {
$orderby = "pdate";
}
$sql = "SELECT * FROM purchases WHERE pdate >= '{$fromdate}' AND pdate <= '{$todate}' AND div = '" . USER_DIV . "' {$supsql} ORDER BY {$orderby} DESC";
$stkpRslt = db_exec($sql) or errDie("Unable to retrieve stock purchases from database.");
if (pg_numrows($stkpRslt) < 1) {
return "\n\t\t\t<li class='err'> No Stock Orders Could be Found.</li><br>" . mkQuickLinks(ql("purchase-new.php", "New Order"), ql("stock-view.php", "View Stock"));
} else {
while ($stkp = pg_fetch_array($stkpRslt)) {
# Date format
$date = explode("-", $stkp['pdate']);
$date = $date[2] . "-" . $date[1] . "-" . $date[0];
# Calculate the Sub-Total
$stkp['total'] = sprint($stkp['total']);
$stkp['shipchrg'] = sprint($stkp['shipping']);
$subtot = $stkp['subtot'];
$subtot = sprint($subtot);
$vat = sprint($stkp['vat']);
$tot1 = sprint($tot1 + $subtot);
$tot2 = sprint($tot2 + $stkp['shipchrg']);
$tot3 = sprint($tot3 + $stkp['total']);
$tot4 = sprint($tot4 + $vat);
# Get documents
$docs = doclib_getdocs("pur", $stkp['purnum']);
# Alternate bgcolor
$printOrd .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>{$stkp['purnum']}</td>\n\t\t\t\t\t<td>{$stkp['ordernum']}</td>\n\t\t\t\t\t<td>{$stkp['supinv']}</td>\n\t\t\t\t\t<td>{$date}</td>\n\t\t\t\t\t<td>{$stkp['supname']}</td>\n\t\t\t\t\t<td align='right'>" . CUR . " {$subtot}</td>\n\t\t\t\t\t<td align='right'>" . CUR . " {$stkp['shipchrg']}</td>\n\t\t\t\t\t<td align='right'>" . CUR . " {$vat}</td>\n\t\t\t\t\t<td align='right'>" . CUR . " {$stkp['total']}</td>\n\t\t\t\t\t<td>{$docs}</td>\n\t\t\t\t\t<td><a href='purch-det.php?purid={$stkp['purid']}'>Details</a></td>\n\t\t\t\t\t<td><a href='purch-cancel.php?purid={$stkp['purid']}'>Delete</td>\n\t\t\t\t\t<td><a href='javascript: printer(\"purch-print.php?purid={$stkp['purid']}\");'>Print</a></td>";
$edit = "purchase-new.php";
$recv = "purch-recv.php";
$complt = "<a href='purch-complete.php?purid={$stkp['purid']}'>Complete</a>";
$recinv = "<a href='purch-recinvcd.php?purid={$stkp['purid']}'>Record Invoice</a>";
if ($stkp['invcd'] == 'y') {
$recinv = "Invoice Recorded";
}
if ($stkp['cash'] == 'y') {
$edit = "purchase-new-cash.php";
$recv = "purch-recv-cash.php";
$complt = "<br>";
$recinv = "";
}
// <td><input type='checkbox' name='email_sel[$stkp[purid]]' value='$stkp[supid]'></td>
if ($stkp['received'] != "y" && $subtot == 0) {
$printOrd .= "\n\t\t\t\t\t\t<td><a href='{$edit}?purid={$stkp['purid']}&cont=1'>Edit</a></td>\n\t\t\t\t\t\t<td> </td>\n\t\t\t\t\t\t<td><a href='purch-cancel.php?purid={$stkp['purid']}'>Cancel</a></td>\n\t\t\t\t\t\t<td></td>\n\t\t\t\t\t</tr>";
} elseif ($stkp['received'] != "y") {
if ($stkp['edit'] != 1 && $stkp['apprv'] != 'y' && $stkp['invcd'] != 'y') {
$printOrd .= "\n\t\t\t\t\t\t\t<td><a href='{$edit}?purid={$stkp['purid']}&cont=1'>Edit</a></td>\n\t\t\t\t\t\t\t<td><a href='purch-apprv.php?purid={$stkp['purid']}'>Approve</a></td>\n\t\t\t\t\t\t\t<td><a href='purch-cancel.php?purid={$stkp['purid']}'>Cancel</a></td>\n\t\t\t\t\t\t</tr>";
} elseif ($stkp['edit'] != 1 && $stkp['apprv'] == 'y') {
if (getSetting("PURCH_APPRV") == 'napprv' && $stkp['invcd'] != 'y') {
$printOrd .= "\n\t\t\t\t\t\t<td><a href='{$edit}?purid={$stkp['purid']}&cont=1'>Edit</a></td>\n\t\t\t\t\t\t<td><a href='purch-cancel.php?purid={$stkp['purid']}'>Cancel</a></td>";
} else {
$printOrd .= "<td> <a href='{$edit}?purid={$stkp['purid']}&cont=1'>Edit</a></td>";
}
if ($stkp['rsubtot'] > 0) {
$rec = "";
} elseif ($stkp['iamount'] > 0) {
$rec = "";
} else {
$rec = "<a href='{$recv}?purid={$stkp['purid']}&invoice=no'>Receive & Record Invoice</a>";
}
$printOrd .= "\n\t\t\t\t\t\t\t<td><a href='{$recv}?purid={$stkp['purid']}'>Received</a></td>\n\t\t\t\t\t\t\t<td>{$recinv}</td>\n\t\t\t\t\t\t\t<td>{$rec}</td>\n\t\t\t\t\t\t</tr>";
} else {
$printOrd .= "\n\t\t\t\t\t\t\t<td><a href='{$recv}?purid={$stkp['purid']}'>Received</a></td>\n\t\t\t\t\t\t\t<td>{$recinv}</td>\n\t\t\t\t\t\t\t<td>{$complt}</td>\n\t\t\t\t\t\t</tr>";
}
} else {
if ($stkp['invcd'] != 'y') {
$printOrd .= "<td colspan='3'>{$recinv}</td></tr>";
} else {
$printOrd .= "<td colspan='3'><br></td></tr>";
}
}
db_connect();
if (isset($filter) and $filter == "detailed") {
$stockcodes = array();
$get_codes = "SELECT * FROM suppstock WHERE suppid = '{$stkp['supid']}' ORDER BY stkid";
$run_codes = db_exec($get_codes) or errDie("Unable to get supplier stock code information");
if (pg_numrows($run_codes) > 0) {
while ($codarr = pg_fetch_array($run_codes)) {
if (strlen($codarr['stkcod']) > 0) {
$stockcodes[$codarr['stkid']]['stkcod'] = $codarr['stkcod'];
}
if (strlen($codarr['stkdes']) > 0) {
$stockcodes[$codarr['stkid']]['stkdes'] = $codarr['stkdes'];
}
}
}
$get_items = "SELECT * FROM pur_items WHERE purid = '{$stkp['purid']}'";
$run_items = db_exec($get_items) or errDie("Unable to get stock items information.");
if (pg_numrows($run_items) > 0) {
$printOrd .= "\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<th colspan='4'></th>\n\t\t\t\t\t\t\t<th>Code</th>\n\t\t\t\t\t\t\t<th>Description</th>\n\t\t\t\t\t\t\t<th>Quantity</th>\n\t\t\t\t\t\t\t<th>Unit Cost</th>\n\t\t\t\t\t\t\t<th>Total</th>\n\t\t\t\t\t\t</tr>";
while ($piarr = pg_fetch_array($run_items)) {
$get_stock = "SELECT * FROM stock WHERE stkid = '{$piarr['stkid']}' LIMIT 1";
$run_stock = db_exec($get_stock) or errDie("Unable to get stock informarion.");
if (pg_numrows($run_stock) > 0) {
$stk = pg_fetch_array($run_stock);
if (isset($stockcodes[$stk['stkid']]['stkcod'])) {
$stk['stkcod'] = $stockcodes[$stk['stkid']]['stkcod'];
}
if (isset($stockcodes[$stk['stkid']]['stkdes'])) {
$stk['stkdes'] = $stockcodes[$stk['stkid']]['stkdes'];
}
}
$printOrd .= "\n\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t\t<td colspan='4'></td>\n\t\t\t\t\t\t\t\t<td>{$stk['stkcod']}</td>\n\t\t\t\t\t\t\t\t<td>{$stk['stkdes']}</td>\n\t\t\t\t\t\t\t\t<td>{$piarr['qty']}</td>\n\t\t\t\t\t\t\t\t<td>{$piarr['unitcost']}</td>\n\t\t\t\t\t\t\t\t<td>{$piarr['amt']}</td>\n\t\t\t\t\t\t\t</tr>";
}
$printOrd .= "\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th>No.</th>\n\t\t\t\t\t\t\t<th>Order No.</th>\n\t\t\t\t\t\t\t<th>Supp Inv No.</th>\n\t\t\t\t\t\t\t<th>Order Date</th>\n\t\t\t\t\t\t\t<th>Supplier</th>\n\t\t\t\t\t\t\t<th>Sub Total</th>\n\t\t\t\t\t\t\t<th>Delivery Charges</th>\n\t\t\t\t\t\t\t<th>Vat</th>\n\t\t\t\t\t\t\t<th>Total</th>\n\t\t\t\t\t\t</tr>";
}
}
$i++;
}
}
$printOrd .= "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td colspan='5'>Totals</td>\n\t\t\t\t<td align='right' nowrap='t'>" . CUR . " {$tot1}</td>\n\t\t\t\t<td align='right' nowrap='t'>" . CUR . " {$tot2}</td>\n\t\t\t\t<td align='right' nowrap='t'>" . CUR . " {$tot4}</td>\n\t\t\t\t<td align='right' nowrap='t'>" . CUR . " {$tot3}</td>\n\t\t\t\t<td colspan='8'> </td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td colspan='17' align='right'><input type='submit' name='export' value='Export to Spreadsheet'></td>\n\t\t\t</tr>\n\t\t</table>" . mkQuickLinks(ql("purchase-new.php", "New Order"), ql("stock-view.php", "View Stock"));
return $printOrd;
}
function printNote($_POST)
{
# Get vars
extract($_POST);
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($from_day, "num", 1, 2, "Invalid from Date day.");
$v->isOk($from_month, "num", 1, 2, "Invalid from Date month.");
$v->isOk($from_year, "num", 1, 4, "Invalid from Date Year.");
$v->isOk($to_day, "num", 1, 2, "Invalid to Date day.");
$v->isOk($to_month, "num", 1, 2, "Invalid to Date month.");
$v->isOk($to_year, "num", 1, 4, "Invalid to Date Year.");
# Mix dates
$fromdate = $from_year . "-" . $from_month . "-" . $from_day;
$todate = $to_year . "-" . $to_month . "-" . $to_day;
if (!checkdate($from_month, $from_day, $from_year)) {
$v->isOk($fromdate, "num", 1, 1, "Invalid from date.");
}
if (!checkdate($to_month, $to_day, $to_year)) {
$v->isOk($todate, "num", 1, 1, "Invalid to date.");
}
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class='err'>-" . $e["msg"] . "</li>";
}
return $confirm;
}
# Set up table to display in
$printNote = "\n\t\t<h3>Credit notes</h3>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<th>Department</th>\n\t\t\t\t<th>Sales Person</th>\n\t\t\t\t<th>Credit Note No.</th>\n\t\t\t\t<th>Invoice No.</th>\n\t\t\t\t<th>Invoice Date</th>\n\t\t\t\t<th>Customer Name</th>\n\t\t\t\t<th>Order No</th>\n\t\t\t\t<th>Grand Total</th>\n\t\t\t\t<th>Documents</th>\n\t\t\t\t<th colspan='3'>Options</th>\n\t\t\t</tr>";
# Connect to database
db_connect();
$month = (int) $from_month;
$yearcheck = $from_year;
$date_arr = array();
$flag = TRUE;
while ($flag) {
if ($month == 13) {
$month = 1;
$yearcheck++;
}
#add month to array
$date_arr[] = $month;
if ($month == $to_month && $yearcheck == $to_year) {
$flag = FALSE;
}
$month++;
}
$date_arr = array_unique($date_arr);
$queries = array();
# this is no good ... to_month CAN be less than from_month
# for ($i = $from_month; $i <= $to_month; $i++) {
foreach ($date_arr as $i) {
$schema = (int) $i;
$queries[] = "SELECT *,'{$schema}' AS query_schema FROM \"{$schema}\".inv_notes WHERE odate >= '{$fromdate}' AND odate <= '{$todate}' AND div = '" . USER_DIV . "'";
}
$query = implode(" UNION ", $queries);
$query .= " ORDER BY noteid DESC";
# Query server
$i = 0;
$tot1 = 0;
$sql = " ORDER BY noteid DESC";
$noteRslt = db_exec($query) or errDie("Unable to retrieve invoices from database.");
if (pg_numrows($noteRslt) < 1) {
$printNote = "<li class='err'>No previous credit notes found.</li>";
} else {
while ($note = pg_fetch_array($noteRslt)) {
$prd = $note["query_schema"];
$note['total'] = sprint($note['total']);
$tot1 = $tot1 + $note['total'];
# Format date
$note['odate'] = explode("-", $note['odate']);
$note['odate'] = $note['odate'][2] . "-" . $note['odate'][1] . "-" . $note['odate'][0];
# Get documents
$docs = doclib_getdocs("note", $note['notenum']);
$rep = "invoice-note-reprint.php";
$curr = CUR;
if ($note['location'] == 'int') {
$rep = "intinvoice-note-reprint.php";
$curr = $note['currency'];
}
$printNote .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>{$note['deptname']}</td>\n\t\t\t\t\t<td>{$note['salespn']}</td>\n\t\t\t\t\t<td>{$note['notenum']}</td>\n\t\t\t\t\t<td>{$note['invnum']}</td>\n\t\t\t\t\t<td align='center'>{$note['odate']}</td>\n\t\t\t\t\t<td>{$note['surname']}</td>\n\t\t\t\t\t<td align='right'>{$note['ordno']}</td>\n\t\t\t\t\t<td align='right'>{$curr} {$note['total']}</td>\n\t\t\t\t\t<td>{$docs}</td>\n\t\t\t\t\t<td><a href='{$rep}?noteid={$note['noteid']}&prd={$prd}&reprint=yes' target='_blank'>Details</a></td>\n\t\t\t\t</tr>";
$i++;
}
}
$tot1 = sprint($tot1);
// Layout
if ($tot1 > 0) {
$printNote .= "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td colspan='7'>Totals:{$i}</td>\n\t\t\t\t<td align='right'>" . CUR . " {$tot1}</td>\n\t\t\t\t<td colspan='2'> </td>\n\t\t\t</tr>";
}
$printNote .= "\n\t\t</table>\n\t\t<p>\n\t\t<table " . TMPL_tblDflts . ">\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<script>document.write(getQuicklinkSpecial());</script>\n\t\t</table>";
return $printNote;
}
function printPurch($_POST)
{
# get vars
foreach ($_POST as $key => $value) {
${$key} = $value;
}
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($fday, "num", 1, 2, "Invalid from Date day.");
$v->isOk($fmon, "num", 1, 2, "Invalid from Date month.");
$v->isOk($fyear, "num", 1, 4, "Invalid from Date Year.");
$v->isOk($today, "num", 1, 2, "Invalid to Date day.");
$v->isOk($tomon, "num", 1, 2, "Invalid to Date month.");
$v->isOk($toyear, "num", 1, 4, "Invalid to Date Year.");
# mix dates
$fromdate = $fyear . "-" . $fmon . "-" . $fday;
$todate = $toyear . "-" . $tomon . "-" . $today;
if (!checkdate($fmon, $fday, $fyear)) {
$v->isOk($fromdate, "num", 1, 1, "Invalid from date.");
}
if (!checkdate($tomon, $today, $toyear)) {
$v->isOk($todate, "num", 1, 1, "Invalid to date.");
}
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class=err>-" . $e["msg"] . "<br>";
}
return $confirm;
}
# Set up table to display in
$printOrd = "<center>\r\n\t<h3>Received Non-Stock Orders</h3>\r\n\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\r\n\t<tr><th>Purchase No.</th><th>Purchase Date</th><th>Supplier</th><th>Sub Total</th><th>Delivery Charges</th><th>Vat</th><th>Total</th><th>Delevery Reference No.</th><th>Documents</th><th colspan=5>Options</th></tr>";
# connect to database
db_conn($prd);
# Query server
$i = 0;
$tot1 = 0;
$tot2 = 0;
$tot3 = 0;
$tot4 = 0;
$sql = "SELECT * FROM nons_purchases WHERE pdate >= '{$fromdate}' AND pdate <= '{$todate}' AND done = 'y' AND div = '" . USER_DIV . "' ORDER BY pdate DESC";
$stkpRslt = db_exec($sql) or errDie("Unable to retrieve stock Non-Stock Orders from database.");
if (pg_numrows($stkpRslt) < 1) {
return "<li> There are no stock Non-Stock Orders found.\r\n\t\t<p>\r\n\t\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\r\n\t\t\t<tr><td><br></td></tr>\r\n\t\t\t<tr><th>Quick Links</th></tr>\r\n\t\t\t<tr class='bg-odd'><td><a href='nons-purchase-new.php'>New Non-Stock Order</a></td></tr>\r\n\t\t\t<script>document.write(getQuicklinkSpecial());</script>\r\n\t\t\t<tr class='bg-odd'><td><a href='stock-report.php'>Stock Control Reports</a></td></tr>\r\n\t\t\t<tr class='bg-even'><td><a href='stock-view.php'>View Stock</a></td></tr>\r\n\t\t\t<tr class='bg-odd'><td><a href='main.php'>Main Menu</a></td></tr>\r\n\t\t</table>";
}
while ($stkp = pg_fetch_array($stkpRslt)) {
# date format
$date = explode("-", $stkp['pdate']);
$date = $date[2] . "-" . $date[1] . "-" . $date[0];
# calculate the Sub-Total
$stkp['total'] = sprint($stkp['total']);
$stkp['shipchrg'] = sprint($stkp['shipping']);
$subtot = $stkp['subtot'];
$subtot = sprint($subtot);
$tot1 = sprint($tot1 + $subtot);
$tot2 = sprint($tot2 + $stkp['shipchrg']);
$tot3 = sprint($tot3 + $stkp['total']);
$vat = $stkp['vat'];
$tot4 = sprint($tot4 + $vat);
# Get documents
$docs = doclib_getdocs("npur", $stkp['purnum']);
$printOrd .= "<tr class='" . bg_class() . "'><td>{$stkp['purnum']}</td><td>{$date}</td><td>{$stkp['supplier']}</td><td align=right>" . CUR . " {$subtot}</td><td align=right>" . CUR . " {$stkp['shipchrg']}</td><td align=right>" . CUR . " {$vat}</td><td align=right>" . CUR . " {$stkp['total']}</td><td>{$stkp['refno']}</td><td>{$docs}</td>";
if ($stkp['returned'] != 'y') {
$printOrd .= "<td><a href='nons-purch-return.php?purid={$stkp['purid']}&prd={$prd}'>Return</a></td><td><a href='nons-purch-det-prd.php?purid={$stkp['purid']}&prd={$prd}'>Details</a></td></tr>";
} else {
$printOrd .= "<td><br></td><td><a href='nons-purch-det-prd.php?purid={$stkp['purid']}&prd={$prd}'>Details</a></td></tr>";
}
$i++;
}
$printOrd .= "<tr class='" . bg_class() . "'><td colspan=3>Totals</td><td align=right>" . CUR . " {$tot1}</td><td align=right>" . CUR . " {$tot2}</td><td align=right>" . CUR . " {$tot4}</td><td align=right>" . CUR . " {$tot3}</td></tr>\r\n\t</table>\r\n <p>\r\n\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\r\n <tr><td><br></td></tr>\r\n <tr><th>Quick Links</th></tr>\r\n\t\t<tr class='bg-odd'><td><a href='nons-purchase-new.php'>New Non-Stock Order</a></td></tr>\r\n\t\t<tr class='bg-odd'><td><a href='main.php'>Main Menu</a></td></tr>\r\n\t</table>";
return $printOrd;
}
function printPurch($_POST, $pure = false)
{
# get vars
extract($_POST);
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($from_day, "num", 1, 2, "Invalid from Date day.");
$v->isOk($from_month, "num", 1, 2, "Invalid from Date month.");
$v->isOk($from_year, "num", 1, 4, "Invalid from Date Year.");
$v->isOk($to_day, "num", 1, 2, "Invalid to Date day.");
$v->isOk($to_month, "num", 1, 2, "Invalid to Date month.");
$v->isOk($to_year, "num", 1, 4, "Invalid to Date Year.");
# mix dates
$fromdate = $from_year . "-" . $from_month . "-" . $from_day;
$todate = $to_year . "-" . $to_month . "-" . $to_day;
if (!checkdate($from_month, $from_day, $from_year)) {
$v->isOk($fromdate, "num", 1, 1, "Invalid from date.");
}
if (!checkdate($to_month, $to_day, $to_year)) {
$v->isOk($todate, "num", 1, 1, "Invalid to date.");
}
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class='err'>-" . $e["msg"] . "<br>";
}
return $confirm;
}
require_lib("docman");
# Set up table to display in
$printOrd = "";
if (!$pure) {
$printOrd = "\n\t\t<center>\n\t\t<h3>View Non-Stock Orders</h3>";
}
$printOrd .= "\n\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th>Purchase No.</th>\n\t\t\t\t\t\t\t<th>Supplier Inv</th>\n\t\t\t\t\t\t\t<th>Purchase Date</th>\n\t\t\t\t\t\t\t<th>Supplier</th>\n\t\t\t\t\t\t\t<th>Sub Total</th>\n\t\t\t\t\t\t\t<th>Delivery Charges</th>\n\t\t\t\t\t\t\t<th>Vat</th><th>Total</th>\n\t\t\t\t\t\t\t<th>Documents</th>\n\t\t\t\t\t\t\t<th colspan='5'>Options</th>\n\t\t\t\t\t\t</tr>";
# connect to database
db_connect();
$Sl = "SELECT supid,supname FROM suppliers";
$Ri = db_exec($Sl) or errDie("Unable to get data.");
while ($data = pg_fetch_array($Ri)) {
$sn[$data['supid']] = $data['supname'];
}
# Query server
$i = 0;
$tot1 = 0;
$tot2 = 0;
$tot3 = 0;
$tot4 = 0;
$sql = "SELECT * FROM nons_purchases WHERE pdate >= '{$fromdate}' AND pdate <= '{$todate}' AND div = '" . USER_DIV . "' ORDER BY pdate DESC";
$stkpRslt = db_exec($sql) or errDie("Unable to retrieve Orders from database.");
if (pg_numrows($stkpRslt) < 1) {
return "<li class='err'> No Non Stock Purchases Could Be Found For The Selected Period.</li>";
}
while ($stkp = pg_fetch_array($stkpRslt)) {
# date format
$date = explode("-", $stkp['pdate']);
$date = $date[2] . "-" . $date[1] . "-" . $date[0];
# calculate the Sub-Total
$stkp['total'] = sprint($stkp['total']);
$stkp['shipchrg'] = sprint($stkp['shipping']);
$subtot = $stkp['subtot'];
$subtot = sprint($subtot);
$vat = sprint($stkp['vat']);
$tot1 = sprint($tot1 + $subtot);
$tot2 = sprint($tot2 + $stkp['shipchrg']);
$tot3 = sprint($tot3 + $stkp['total']);
$tot4 = sprint($tot4 + $vat);
# Get documents
$docs = doclib_getdocs("npur", $stkp['purnum']);
$edit = "nons-purchase-new.php";
$det = "nons-purch-det.php";
$recv = "nons-purch-recv.php";
if ($stkp['spurnum'] > 0) {
$edit = "lnons-purch-new.php";
$det = "lnons-purch-det.php";
$recv = "lnons-purch-recv.php";
}
if ($stkp['assid'] > 0) {
$edit = "nonsa-purchase-new.php";
$det = "nonsa-purch-det.php";
$recv = "nonsa-purch-recv.php";
}
if ($stkp['ctyp'] == "s" && isset($sn[$stkp['supplier']])) {
$stkp['supplier'] = $sn[$stkp['supplier']];
}
$printOrd .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>{$stkp['purnum']}</td>\n\t\t\t\t\t<td>{$stkp['supinv']}</td>\n\t\t\t\t\t<td>{$date}</td>\n\t\t\t\t\t<td>{$stkp['supplier']}</td>\n\t\t\t\t\t<td align='right'>" . CUR . " {$subtot}</td>\n\t\t\t\t\t<td align='right'>" . CUR . " {$stkp['shipchrg']}</td>\n\t\t\t\t\t<td align='right'>" . CUR . " {$vat}</td>\n\t\t\t\t\t<td align='right'>" . CUR . " {$stkp['total']}</td>\n\t\t\t\t\t<td>{$docs}</td>\n\t\t\t\t\t<td><a href='{$det}?purid={$stkp['purid']}'>Details</a></td>\n\t\t\t\t\t<td><a href='javascript: printer(\"nons-purch-print.php?purid={$stkp['purid']}\");'>Print</a></td>";
if ($stkp['received'] != "y" && $subtot == 0) {
$printOrd .= "\n\t\t\t\t\t<td><a href='{$edit}?purid={$stkp['purid']}&cont=1'>Edit</a></td>\n\t\t\t\t\t<td></td>\n\t\t\t\t\t<td><a href='nons-purch-cancel.php?purid={$stkp['purid']}'>Cancel</a></td>\n\t\t\t\t</tr>";
} elseif ($stkp['received'] != "y") {
$printOrd .= "\n\t\t\t\t\t<td><a href='{$edit}?purid={$stkp['purid']}&cont=1'>Edit</a></td>\n\t\t\t\t\t<td><a href='{$recv}?purid={$stkp['purid']}'>Received</a></td>\n\t\t\t\t\t<td><a href='nons-purch-cancel.php?purid={$stkp['purid']}'>Cancel</a></td>\n\t\t\t\t</tr>";
} else {
$printOrd .= "\n\t\t\t\t\t<td colspan='3'><br></td>\n\t\t\t\t</tr>";
}
$i++;
}
$printOrd .= "\n\t<tr class='" . bg_class() . "'>\n\t\t<td colspan='4'>Totals</td>\n\t\t<td align='right'>" . CUR . " {$tot1}</td>\n\t\t<td align='right'>" . CUR . " {$tot2}</td>\n\t\t<td align='right'>" . CUR . " {$tot4}</td>\n\t\t<td align='right'>" . CUR . " {$tot3}</td>\n\t</tr>";
if (!$pure) {
$printOrd .= "\n\t\t" . TBL_BR . "\n\t\t<form action='" . SELF . "' method='POST'>\n\t\t\t<input type='hidden' name='key' value='export'>\n\t\t\t<input type='hidden' name='from_day' value='{$from_day}'>\n\t\t\t<input type='hidden' name='from_month' value='{$from_month}'>\n\t\t\t<input type='hidden' name='from_year' value='{$from_year}'>\n\t\t\t<input type='hidden' name='to_day' value='{$to_day}'>\n\t\t\t<input type='hidden' name='to_month' value='{$to_month}'>\n\t\t\t<input type='hidden' name='to_year' value='{$to_year}'>\n\t\t\t<tr>\n\t\t\t\t<td colspan='4'><input type='submit' value='Export to Spreadsheet'></td>\n\t\t\t</tr>\n\t\t</form>";
}
$printOrd .= "\n\t</table>";
return $printOrd;
}
function printPurch($_POST)
{
# get vars
extract($_POST);
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($from_day, "num", 1, 2, "Invalid from Date day.");
$v->isOk($from_month, "num", 1, 2, "Invalid from Date month.");
$v->isOk($from_year, "num", 1, 4, "Invalid from Date Year.");
$v->isOk($to_day, "num", 1, 2, "Invalid to Date day.");
$v->isOk($to_month, "num", 1, 2, "Invalid to Date month.");
$v->isOk($to_year, "num", 1, 4, "Invalid to Date Year.");
# mix dates
$fromdate = $from_year . "-" . $from_month . "-" . $from_day;
$todate = $to_year . "-" . $to_month . "-" . $to_day;
if (!checkdate($from_month, $from_day, $from_year)) {
$v->isOk($fromdate, "num", 1, 1, "Invalid from date.");
}
if (!checkdate($to_month, $to_day, $to_year)) {
$v->isOk($todate, "num", 1, 1, "Invalid to date.");
}
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class=err>-" . $e["msg"] . "<br>";
}
return $confirm;
}
# Set up table to display in
$printOrd = "\n\t\t\t\t\t<center>\n\t\t\t\t\t<h3>Received Non-Stock Orders</h3>\n\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<th>Purchase No.</th>\n\t\t\t\t\t\t<th>Purchase Date</th>\n\t\t\t\t\t\t<th>Supplier</th>\n\t\t\t\t\t\t<th>Sub Total</th>\n\t\t\t\t\t\t<th>Delivery Charges</th>\n\t\t\t\t\t\t<th>Vat</th>\n\t\t\t\t\t\t<th>Total</th>\n\t\t\t\t\t\t<th>Delivery Reference No.</th>\n\t\t\t\t\t\t<th>Documents</th>\n\t\t\t\t\t\t<th colspan='5'>Options</th>\n\t\t\t\t\t</tr>";
# Connect to database
db_connect();
$queries = array();
for ($i = 1; $i <= 12; $i++) {
$schema = (int) $i;
$queries[] = "SELECT *,'{$schema}' AS query_schema FROM \"{$schema}\".nons_purchases WHERE pdate >= '{$fromdate}' AND pdate <= '{$todate}' AND done = 'y' AND div = '" . USER_DIV . "'";
}
$query = implode(" UNION ", $queries);
$query .= " ORDER BY pdate DESC";
# Query server
$i = 0;
$tot1 = 0;
$tot2 = 0;
$tot3 = 0;
$tot4 = 0;
$stkpRslt = db_exec($query) or errDie("Unable to retrieve stock Non-Stock Orders from database.");
if (pg_numrows($stkpRslt) < 1) {
return "\n\t\t\t\t\t<li class='err'> No Non-Stock Orders found.</li>\n\t\t\t\t\t<p>\n\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th>Quick Links</th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td><a href='nons-purchase-new.php'>New Non-Stock Order</a></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td><a href='stock-report.php'>Stock Control Reports</a></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td><a href='stock-view.php'>View Stock</a></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t\t\t\t\t</table>";
}
while ($stkp = pg_fetch_array($stkpRslt)) {
$prd = $stkp["query_schema"];
# date format
$date = explode("-", $stkp['pdate']);
$date = $date[2] . "-" . $date[1] . "-" . $date[0];
# calculate the Sub-Total
$stkp['total'] = sprint($stkp['total']);
$stkp['shipchrg'] = sprint($stkp['shipping']);
$subtot = $stkp['subtot'];
$subtot = sprint($subtot);
$tot1 = sprint($tot1 + $subtot);
$tot2 = sprint($tot2 + $stkp['shipchrg']);
$tot3 = sprint($tot3 + $stkp['total']);
$vat = $stkp['vat'];
$tot4 = sprint($tot4 + $vat);
# Get documents
$docs = doclib_getdocs("npur", $stkp['purnum']);
$printOrd .= "\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>{$stkp['purnum']}</td>\n\t\t\t\t\t\t\t<td>{$date}</td>\n\t\t\t\t\t\t\t<td>{$stkp['supplier']}</td>\n\t\t\t\t\t\t\t<td align='right'>" . CUR . " {$subtot}</td>\n\t\t\t\t\t\t\t<td align='right'>" . CUR . " {$stkp['shipchrg']}</td>\n\t\t\t\t\t\t\t<td align='right'>" . CUR . " {$vat}</td>\n\t\t\t\t\t\t\t<td align='right'>" . CUR . " {$stkp['total']}</td>\n\t\t\t\t\t\t\t<td>{$stkp['refno']}</td>\n\t\t\t\t\t\t\t<td>{$docs}</td>";
if ($stkp['returned'] != 'y' and $stkp['is_asset'] != "yes") {
$printOrd .= "\n\t\t\t\t\t\t\t<td><a href='nons-purch-return.php?purid={$stkp['purid']}&prd={$prd}'>Return</a></td>\n\t\t\t\t\t\t\t<td><a href='nons-purch-det-prd.php?purid={$stkp['purid']}&prd={$prd}'>Details</a></td>\n\t\t\t\t\t\t\t<td><a target='_blank' href='nons-purch-recv-print.php?purid={$stkp['purid']}&prd={$prd}'>Print</a></td>\n\t\t\t\t\t\t</tr>";
} else {
$printOrd .= "\n\t\t\t\t\t\t\t<td><br></td>\n\t\t\t\t\t\t\t<td><a href='nons-purch-det-prd.php?purid={$stkp['purid']}&prd={$prd}'>Details</a></td>\n\t\t\t\t\t\t</tr>";
}
$i++;
}
$printOrd .= "\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td colspan=3>Totals</td>\n\t\t\t\t\t\t\t<td align=right>" . CUR . " {$tot1}</td>\n\t\t\t\t\t\t\t<td align=right>" . CUR . " {$tot2}</td>\n\t\t\t\t\t\t\t<td align=right>" . CUR . " {$tot4}</td>\n\t\t\t\t\t\t\t<td align=right>" . CUR . " {$tot3}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr><td><br></td></tr>\n\t\t\t\t\t\t<form action='" . SELF . "' method='POST'>\n\t\t\t\t\t\t<input type='hidden' name='key' value='export'>\n\t\t\t\t\t\t<input type='hidden' name='prd' value='{$prd}'>\n\t\t\t\t\t\t<input type='hidden' name='fday' value='{$from_day}'>\n\t\t\t\t\t\t<input type='hidden' name='fmon' value='{$from_month}'>\n\t\t\t\t\t\t<input type='hidden' name='fyear' value='{$from_year}'>\n\t\t\t\t\t\t<input type='hidden' name='today' value='{$to_day}'>\n\t\t\t\t\t\t<input type='hidden' name='tomon' value='{$to_month}'>\n\t\t\t\t\t\t<input type='hidden' name='toyear' value='{$to_year}'>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td colspan='4'><input type=submit value='Export to Spreadsheet'></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</table>\n\t\t\t\t <p>\n\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t <tr><td><br></td></tr>\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\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td><a href='nons-purchase-new.php'>New Non-Stock Order</a></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td><a href='main.php'>Main Menu</a></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</table>";
return $printOrd;
}
function printPurch($_POST)
{
# get vars
extract($_POST);
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($from_day, "num", 1, 2, "Invalid from Date day.");
$v->isOk($from_month, "num", 1, 2, "Invalid from Date month.");
$v->isOk($from_year, "num", 1, 4, "Invalid from Date Year.");
$v->isOk($to_day, "num", 1, 2, "Invalid to Date day.");
$v->isOk($to_month, "num", 1, 2, "Invalid to Date month.");
$v->isOk($to_year, "num", 1, 4, "Invalid to Date Year.");
# mix dates
$fromdate = $from_year . "-" . $from_month . "-" . $from_day;
$todate = $to_year . "-" . $to_month . "-" . $to_day;
if (!checkdate($from_month, $from_day, $from_year)) {
$v->isOk($fromdate, "num", 1, 1, "Invalid from date.");
}
if (!checkdate($to_month, $to_day, $to_year)) {
$v->isOk($todate, "num", 1, 1, "Invalid to date.");
}
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class='err'>-" . $e["msg"] . "</li>";
}
return $confirm;
}
# Set up table to display in
$printOrd = "\n\t\t\t\t\t<center>\n\t\t\t\t\t<h3>View International Non-Stock Orders</h3>\n\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th>Purchase No.</th>\n\t\t\t\t\t\t\t<th>Purchase Date</th>\n\t\t\t\t\t\t\t<th>Supplier</th>\n\t\t\t\t\t\t\t<th>Sub Total</th>\n\t\t\t\t\t\t\t<th>Delivery Charges</th>\n\t\t\t\t\t\t\t<th>Vat</th>\n\t\t\t\t\t\t\t<th>Total</th>\n\t\t\t\t\t\t\t<th>Documents</th>\n\t\t\t\t\t\t\t<th colspan='5'>Options</th>\n\t\t\t\t\t\t</tr>";
# connect to database
db_connect();
# Query server
$i = 0;
$tot1 = 0;
$tot2 = 0;
$tot3 = 0;
$tot4 = 0;
$sql = "SELECT * FROM nons_purch_int WHERE pdate >= '{$fromdate}' AND pdate <= '{$todate}' AND div = '" . USER_DIV . "' ORDER BY pdate DESC";
$stkpRslt = db_exec($sql) or errDie("Unable to retrieve Orders from database.");
if (pg_numrows($stkpRslt) < 1) {
return "\n\t\t\t\t\t<li> There are no Orders found.</li><p>\n\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th>Quick Links</th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td><a href='nons-purch-int-new.php'>New International Non-Stock Orders</a></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t\t\t\t\t</table>";
}
while ($stkp = pg_fetch_array($stkpRslt)) {
# date format
$date = explode("-", $stkp['pdate']);
$date = $date[2] . "-" . $date[1] . "-" . $date[0];
# Get documents
$docs = doclib_getdocs("npur", $stkp['purnum']);
$edit = "nons-purch-int-new.php";
$det = "nons-purch-int-print.php";
$recv = "nons-purch-int-recv.php";
$printOrd .= "\n\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t\t<td>{$stkp['purnum']}</td>\n\t\t\t\t\t\t\t\t<td>{$date}</td>\n\t\t\t\t\t\t\t\t<td>{$stkp['supplier']}</td>\n\t\t\t\t\t\t\t\t<td align='right'>{$stkp['curr']} {$stkp['subtot']}</td>\n\t\t\t\t\t\t\t\t<td align='right'>{$stkp['curr']} {$stkp['shipchrg']}</td>\n\t\t\t\t\t\t\t\t<td align='right'>{$stkp['curr']} {$stkp['tax']}</td>\n\t\t\t\t\t\t\t\t<td align='right'>{$stkp['curr']} {$stkp['total']}</td><td>{$docs}</td>\n\t\t\t\t\t\t\t\t<td><a href='{$det}?purid={$stkp['purid']}'>Details</a></td>\n\t\t\t\t\t\t\t\t<td><a target='_blank' href='{$det}?purid={$stkp['purid']}'>Print</a></td>";
if ($stkp['received'] != "y" && $stkp['subtot'] == 0) {
$printOrd .= "\n\t\t\t\t\t\t\t\t<td><a href='{$edit}?purid={$stkp['purid']}&cont=1'>Edit</a></td>\n\t\t\t\t\t\t\t\t<td><a href='nons-purch-int-cancel.php?purid={$stkp['purid']}'>Cancel</a></td>\n\t\t\t\t\t\t\t</tr>";
} elseif ($stkp['received'] != "y") {
$printOrd .= "\n\t\t\t\t\t\t\t\t<td><a href='{$edit}?purid={$stkp['purid']}&cont=1'>Edit</a></td>\n\t\t\t\t\t\t\t\t<td><a href='{$recv}?purid={$stkp['purid']}'>Received</a></td>\n\t\t\t\t\t\t\t\t<td><a href='nons-purch-int-cancel.php?purid={$stkp['purid']}'>Cancel</a></td>\n\t\t\t\t\t\t\t</tr>";
} else {
$printOrd .= "\n\t\t\t\t\t\t\t\t<td colspan='3'><br></td>\n\t\t\t\t\t\t\t</tr>";
}
$i++;
}
$printOrd .= "\n\t\t\t\t\t\t</table>\n\t\t\t\t\t <p>\n\t\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t <tr><td><br></td></tr>\n\t\t\t\t\t <tr>\n\t\t\t\t\t \t<th>Quick Links</th>\n\t\t\t\t\t </tr>\n\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t\t<td><a href='nons-purch-int-new.php'>New International Non-Stock Order</a></td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t\t<td><a href='main.php'>Main Menu</a></td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t</table>";
return $printOrd;
}
function printInvoice($_POST)
{
extract($_POST);
require_lib("validate");
$v = new validate();
$v->isOk($from_day, "num", 1, 2, "Invalid from Date day.");
$v->isOk($from_month, "num", 1, 2, "Invalid from Date month.");
$v->isOk($from_year, "num", 1, 4, "Invalid from Date Year.");
$v->isOk($to_day, "num", 1, 2, "Invalid to Date day.");
$v->isOk($to_month, "num", 1, 2, "Invalid to Date month.");
$v->isOk($to_year, "num", 1, 4, "Invalid to Date Year.");
$fromdate = mkdate($from_year, $from_month, $from_day);
$todate = mkdate($to_year, $to_month, $to_day);
$v->isOk($fromdate, "date", 1, 1, "Invalid from date.");
$v->isOk($todate, "date", 1, 1, "Invalid to date.");
if ($v->isError()) {
$err = $v->genErrors();
return $err;
}
# Set up table to display in
$printOrd = "\n\t\t<center>\n\t\t<h3>View Non-Stock Invoices</h3>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t<form action='invoice-proc.php' method='POST'>\n\t\t\t<input type='hidden' name='t' value='i'>\n\t\t\t<tr>\n\t\t\t\t<th>Invoice Num</th>\n\t\t\t\t<th>Proforma Inv No.</th>\n\t\t\t\t<th>Invoice Date</th>\n\t\t\t\t<th>Customer</th>\n\t\t\t\t<th>Total</th>\n\t\t\t\t<th>Documents</th>\n\t\t\t\t<th colspan=6>Options</th>\n\t\t\t</tr>";
# connect to database
db_connect();
# Query server
$i = 0;
$tot_subtot = 0;
$tot_total = 0;
$cust_search = "";
if (isset($customer) and $customer != "0") {
$cust_search = "AND cusname = '{$customer}'";
}
$sql = "SELECT * FROM nons_invoices WHERE typ = 'inv' AND sdate >= '{$fromdate}' \tAND sdate <= '{$todate}' AND div = '" . USER_DIV . "' AND balance > 0 {$cust_search} ORDER BY invnum";
$nonstksRslt = db_exec($sql) or errDie("Unable to retrieve invoices from database.");
if (pg_numrows($nonstksRslt) < 1) {
return "\n\t\t\t<li class='err'> No Non Stock Invoices Could Be Found.</li>\n\t\t\t<p>\n\t\t\t<table border='0' cellpadding='2' cellspacing='1'>\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='nons-invoice-new.php'>New Non Stock Invoice</a></td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td><a href='nons-invoice-view.php'>View Non Stock Invoices</a></td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td><a href='main.php'>Main Menu</a></td>\n\t\t\t\t</tr>\n\t\t\t</table>";
}
// Retrieve the PDF reprints
db_conn("cubit");
$sql = "SELECT filename FROM template_settings WHERE template='reprints' AND div='" . USER_DIV . "'";
$tsRslt = db_exec($sql) or errDie("Unable to retrieve template settings from Cubit.");
$template = pg_fetch_result($tsRslt, 0);
while ($nonstks = pg_fetch_array($nonstksRslt)) {
// compute the totals
if ($nonstks["xrate"] == 0.0) {
$tot_subtot += $nonstks["subtot"];
$tot_total += $nonstks["total"];
} else {
$tot_subtot += $nonstks["subtot"] * $nonstks["xrate"];
$tot_total += $nonstks["total"] * $nonstks["xrate"];
}
# calculate the Sub-Total
if ($nonstks['invnum'] == 0) {
$nonstks['invnum'] = $nonstks['invid'];
}
$det = "nons-invoice-det.php";
$edit = "nons-invoice-new.php";
$print = "nons-invoice-print.php";
$reprint = "nons-invoice-reprint.php";
$note = "nons-invoice-note.php";
if ($template == "default") {
$template = "nons-invoice-pdf-reprint.php";
} elseif ($template == "new") {
$template = "pdf-tax-invoice.php";
}
$reprpdf = $template;
$cur = CUR;
if ($nonstks['location'] == 'int') {
$det = "nons-intinvoice-det.php";
$edit = "nons-intinvoice-new.php";
$print = "nons-intinvoice-print.php";
$note = "nons-intinvoice-note.php";
if ($template == "default") {
$template = "nons-intinvoice-pdf-reprint.php";
} elseif ($template == "new") {
$template = "pdf-tax-invoice.php";
}
$reprpdf = $template;
$note = "nons-intinvoice-note.php";
$cur = $nonstks['currency'];
}
# Get documents
$docs = doclib_getdocs("ninv", $nonstks['invnum']);
if ($nonstks['accepted'] == " " && $nonstks['done'] != "y") {
$chbox = "<input type=checkbox name='evs[{$nonstks['invid']}]' value='{$nonstks['invid']}' checked=yes>";
} else {
$chbox = "";
}
$printOrd .= "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>{$nonstks['invnum']}</td>\n\t\t\t\t<td>{$nonstks['docref']}</td>\n\t\t\t\t<td>{$nonstks['odate']}</td>\n\t\t\t\t<td>{$nonstks['cusname']}</td>\n\t\t\t\t<td align='right'>{$cur} {$nonstks['total']}</td>\n\t\t\t\t<td>{$docs}</td>\n\t\t\t\t<td>{$chbox}</td>\n\t\t\t\t<td><a href='{$det}?invid={$nonstks['invid']}'>Details</a></td>";
if ($nonstks['done'] != "y" && $nonstks["subtot"] == 0) {
$printOrd .= "\n\t\t\t\t\t<td><a href='{$edit}?invid={$nonstks['invid']}&cont=1'>Edit</a></td>\n\t\t\t\t\t<td><a href='?key=delete_confirm&invid={$nonstks['invid']}'>Delete</a></td>\n\t\t\t\t</tr>";
} elseif ($nonstks['done'] != "y") {
$printOrd .= "\n\t\t\t\t\t<td><a href='{$edit}?invid={$nonstks['invid']}&cont=1'>Edit</a></td>\n\t\t\t\t\t<td><a href='?key=delete_confirm&invid={$nonstks['invid']}'>Delete</a></td>\n\t\t\t\t\t<td><a href=# onClick=printer('{$print}?invid={$nonstks['invid']}&type=nons')>Process</a></td>\n\t\t\t\t</tr>";
} else {
$cn = "";
if ($nonstks['accepted'] != "note") {
if (isset($mode) && $mode == "creditnote") {
$cn = "<input type='button' onClick=\"printer('{$note}?invid={$nonstks['invid']}&type=nonsnote');\" value='Credit Note'>";
} else {
$cn = "<a href='#' onClick=printer('{$note}?invid={$nonstks['invid']}&type=nonsnote')>Credit Note</a>";
}
}
$printOrd .= "\n\t\t\t\t\t<td>{$cn}</td>\n\t\t\t\t\t<td><a href='#' onClick=printer('{$reprint}?invid={$nonstks['invid']}&type=nonsreprint')>Reprint</a></td>\n\t\t\t\t\t<td><a href='pdf/{$reprpdf}?invid={$nonstks['invid']}&type=nonsreprint' target='_blank'>Reprint in PDF</a></td>\n\t\t\t\t\t<td><input type='checkbox' name='evs[{$nonstks['invid']}]'></td>\n\t\t\t\t</tr>";
}
}
$tot_total = sprint($tot_total);
$printOrd .= "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td colspan='4'>Totals</td>\n\t\t\t\t<td align='right'>" . CUR . " {$tot_total}</td>\n\t\t\t\t<td colspan='4' align='right'>\n\t\t\t\t\t<input type='submit' value='Delete Batch' name='btndelete' />\n\t\t\t\t\t<input type='submit' value='Process Selected' name='print' />\n\t\t\t\t</td>\n\t\t\t\t<td colspan='3' align='right'><input type='submit' value='Email Selected' name='email'></td>\n\t\t\t</tr>\n\t\t</table>\n\t\t</form><p>" . mkQuickLinks(ql("nons-invoice-new.php", "New Non-Stock Invoice"));
return $printOrd;
}
function printOrd($_POST)
{
# get vars
extract($_POST);
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($from_day, "num", 1, 2, "Invalid from Date day.");
$v->isOk($from_month, "num", 1, 2, "Invalid from Date month.");
$v->isOk($from_year, "num", 1, 4, "Invalid from Date Year.");
$v->isOk($to_day, "num", 1, 2, "Invalid to Date day.");
$v->isOk($to_month, "num", 1, 2, "Invalid to Date month.");
$v->isOk($to_year, "num", 1, 4, "Invalid to Date Year.");
# mix dates
$fromdate = $from_year . "-" . $from_month . "-" . $from_day;
$todate = $to_year . "-" . $to_month . "-" . $to_day;
if (!checkdate($from_month, $from_day, $from_year)) {
$v->isOk($fromdate, "num", 1, 1, "Invalid from date.");
}
if (!checkdate($to_month, $to_day, $to_year)) {
$v->isOk($todate, "num", 1, 1, "Invalid to date.");
}
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class='err'>-" . $e["msg"] . "</li";
}
return $confirm;
}
# Set up table to display in
$printOrd = "\r\n\t\t\t\t\t<center>\r\n\t\t\t <h3>Received International Stock Orders</h3>\r\n\t\t\t <table " . TMPL_tblDflts . ">\r\n\t\t\t \t <tr>\r\n\t\t\t \t \t<th>Order No.</th>\r\n\t\t\t \t \t<th>Order Date</th>\r\n\t\t\t \t \t<th>Supplier</th>\r\n\t\t\t \t \t<th>Sub Total</th>\r\n\t\t\t \t \t<th>Shipping Charges</th>\r\n\t\t\t \t \t<th>Tax</th>\r\n\t\t\t \t \t<th colspan='2'>Total</th>\r\n\t\t\t \t \t<th>Delivery Reference No.</th>\r\n\t\t\t \t \t<th>Documents</th>\r\n\t\t\t \t \t<th colspan='5'>Options</th>\r\n\t\t\t \t </tr>";
# Connect to database
db_connect();
$queries = array();
for ($i = $from_month; $i <= $to_month; $i++) {
$schema = (int) $i;
$queries[] = "SELECT *,'{$schema}' AS query_schema FROM \"{$schema}\".purch_int WHERE pdate >= '{$fromdate}' AND pdate <= '{$todate}' AND done = 'y' AND div = '" . USER_DIV . "'";
}
$query = implode(" UNION ", $queries);
$query .= " ORDER BY pdate DESC";
# Query server
$i = 0;
$stkpRslt = db_exec($query) or errDie("Unable to retrieve stock Orders from database.");
if (pg_numrows($stkpRslt) < 1) {
return "<li> There are no stock Orders found.</li>" . mkQuickLinks(ql("purch-int-new.php", "New International Order"), ql("stock-view.php", "View Stock"));
}
while ($stkp = pg_fetch_array($stkpRslt)) {
# date format
$date = explode("-", $stkp['pdate']);
$prd = $stkp["query_schema"];
$date = $date[2] . "-" . $date[1] . "-" . $date[0];
# Get supplier
db_connect();
$sql = "SELECT supname FROM suppliers WHERE supid = '{$stkp['supid']}' AND div = '" . USER_DIV . "'";
$supRslt = db_exec($sql);
if (pg_numrows($supRslt) < 1) {
$sup['supname'] = "<li class='err'>Supplier not found.</li>";
} else {
$sup = pg_fetch_array($supRslt);
}
# Calculate the Sub-Total
$subtot = sprint($stkp['total'] - $stkp['shipchrg']);
$stkp['tax'] = sprint($stkp['tax']);
$stkp['shipchrg'] = sprint($stkp['shipchrg']);
# Get documents
$docs = doclib_getdocs("ipur", $stkp['purnum']);
$sp4 = " ";
#clear var
$stkp['fbalance'] = sprint($stkp['fbalance']);
$stkp['total'] = sprint(sprint($stkp['total']));
$printOrd .= "\r\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t\t<td>{$stkp['purnum']}</td>\r\n\t\t\t\t\t\t\t<td>{$date}</td>\r\n\t\t\t\t\t\t\t<td>{$sup['supname']}</td>\r\n\t\t\t\t\t\t\t<td align='right'>{$stkp['curr']} {$subtot}</td>\r\n\t\t\t\t\t\t\t<td align='right'>{$stkp['curr']} {$stkp['shipchrg']}</td>\r\n\t\t\t\t\t\t\t<td align='right'>{$stkp['curr']} {$stkp['tax']}</td>\r\n\t\t\t\t\t\t\t<td align='right'>{$stkp['curr']} {$stkp['total']}</td>\r\n\t\t\t\t\t\t\t<td align='right'>{$sp4} " . CUR . " {$stkp['fbalance']}</td>\r\n\t\t\t\t\t\t\t<td>{$stkp['refno']}</td>\r\n\t\t\t\t\t\t\t<td>{$docs}</td>";
if ($stkp['returned'] != 'y' && returnable($stkp['purnum'])) {
$printOrd .= "<td><a href='purch-int-return.php?purid={$stkp['purid']}&prd={$prd}'>Return</a></td>";
} else {
$printOrd .= "<td><br></td>";
}
if ($stkp['rsubtot'] > 0) {
$printOrd .= "<td><a href='purch-int-recnote.php?purid={$stkp['purid']}&prd={$prd}'>Record Credit Note</a></td>";
} else {
$printOrd .= "<td><br></td>";
}
$printOrd .= "<td><a href='purch-int-det-prd.php?purid={$stkp['purid']}&prd={$prd}'>Details</a></td></tr>";
$i++;
}
$printOrd .= "\r\n\t\t\t\t\t<tr><td><br></td></tr>\r\n\t\t\t\t\t<form action='" . SELF . "' method='POST'>\r\n\t\t\t\t\t\t<input type='hidden' name='key' value='export'>\r\n\t\t\t\t\t\t<input type='hidden' name='prd' value='{$prd}'>\r\n\t\t\t\t\t\t<input type='hidden' name='fday' value='{$from_day}'>\r\n\t\t\t\t\t\t<input type='hidden' name='fmon' value='{$from_month}'>\r\n\t\t\t\t\t\t<input type='hidden' name='fyear' value='{$from_year}'>\r\n\t\t\t\t\t\t<input type='hidden' name='today' value='{$to_day}'>\r\n\t\t\t\t\t\t<input type='hidden' name='tomon' value='{$to_month}'>\r\n\t\t\t\t\t\t<input type='hidden' name='toyear' value='{$to_year}'>\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t<td colspan='3'><input type='submit' value='Export to Spreadsheet'></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t</form>\r\n\t\t\t\t\t</table>" . mkQuickLinks(ql("purch-int-new.php", "New International Order"), ql("stock-view.php", "View Stock"));
return $printOrd;
}
function printPurch($_POST, $pure = false)
{
extract($_POST);
require_lib("validate");
$v = new validate();
$v->isOk($from_day, "num", 1, 2, "Invalid from Date day.");
$v->isOk($from_month, "num", 1, 2, "Invalid from Date month.");
$v->isOk($from_year, "num", 1, 4, "Invalid from Date Year.");
$v->isOk($to_day, "num", 1, 2, "Invalid to Date day.");
$v->isOk($to_month, "num", 1, 2, "Invalid to Date month.");
$v->isOk($to_year, "num", 1, 4, "Invalid to Date Year.");
$fromdate = $from_year . "-" . $from_month . "-" . $from_day;
$todate = $to_year . "-" . $to_month . "-" . $to_day;
if (!checkdate($from_month, $from_day, $from_year)) {
$v->isOk($fromdate, "num", 1, 1, "Invalid from date.");
}
if (!checkdate($to_month, $to_day, $to_year)) {
$v->isOk($todate, "num", 1, 1, "Invalid to date.");
}
if ($v->isError()) {
return $v->genErrors();
}
require_lib("docman");
$OUT = "";
if (!$pure) {
$OUT .= "\n\t\t<center>\n\t\t<h3>Received Stock Orders</h3>";
}
$OUT .= "\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<th>Purchase No.</th>\n\t\t\t\t<th>Order No.</th>\n\t\t\t\t<th>Supp Inv No.</th>\n\t\t\t\t<th>Order Date</th>\n\t\t\t\t<th>Received Date</th>\n\t\t\t\t<th>Supplier</th>\n\t\t\t\t<th>Sub Total</th>\n\t\t\t\t<th>Delivery Charges</th>\n\t\t\t\t<th>VAT</th>\n\t\t\t\t<th>Total</th>\n\t\t\t\t<th>Delivery Reference No.</th>\n\t\t\t\t<th>Documents</th>\n\t\t\t\t<th colspan='5'>Options</th>\n\t\t\t</tr>";
$i = 0;
$tot1 = 0;
$tot2 = 0;
$tot3 = 0;
$tot4 = 0;
$supsql = "";
if (isset($supplier) and $supplier != 0) {
$supsql = " AND supid = '{$supplier}'";
}
/* build the sql */
$queries = array();
for ($i = 1; $i <= 12; $i++) {
$schema = (int) $i;
$queries[] = "SELECT *,'{$schema}' AS query_schema FROM \"{$schema}\".purchases WHERE pdate >= '{$fromdate}' AND pdate <= '{$todate}' AND done = 'y' AND div = '" . USER_DIV . "' {$supsql}";
}
$sql = implode(" UNION ", $queries) . " ORDER BY pdate DESC";
$qry = new dbQuery(DB_SQL, $sql);
$qry->run();
if ($qry->num_rows() < 1) {
return "<li class='err'> No Received Stock Orders found.</li><br>";
}
while ($stkp = $qry->fetch_array()) {
$prd = $stkp["query_schema"];
/* calculate the subtotal */
$stkp['total'] = sprint($stkp['total']);
$stkp['shipchrg'] = sprint($stkp['shipping']);
$subtot = $stkp['subtot'];
$subtot = sprint($subtot);
/* add the totals */
$tot1 = sprint($tot1 + $subtot);
$tot2 = sprint($tot2 + $stkp['shipchrg']);
$tot3 = sprint($tot3 + $stkp['total']);
$tot4 = sprint($tot4 + $stkp["vat"]);
$docs = doclib_getdocs("pur", $stkp['purnum']);
$docs .= " <a href='#' onClick=\"printer('purch-recv.php?key=recv_print&purid={$stkp['purid']}');\">GRN</a>";
$OUT .= "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>{$stkp['purnum']}</td>\n\t\t\t\t<td>{$stkp['ordernum']}</td>\n\t\t\t\t<td>{$stkp['supinv']}</td>\n\t\t\t\t<td>{$stkp['pdate']}</td>\n\t\t\t\t<td>{$stkp['ddate']}</td>\n\t\t\t\t<td>{$stkp['supname']}</td>\n\t\t\t\t<td align='right' nowrap>" . CUR . " {$subtot}</td>\n\t\t\t\t<td align='right' nowrap>" . CUR . " {$stkp['shipchrg']}</td>\n\t\t\t\t<td align='right' nowrap>" . CUR . " {$stkp['vat']}</td>\n\t\t\t\t<td align='right' nowrap>" . CUR . " {$stkp['total']}</td>\n\t\t\t\t<td>{$stkp['refno']}</td>\n\t\t\t\t<td>{$docs}</td>";
if ($stkp['returned'] != 'y') {
$OUT .= "<td><a href='purch-return.php?purid={$stkp['purid']}&prd={$prd}'>Return</a></td>";
} else {
$OUT .= "<td> </td>";
}
if ($stkp['rsubtot'] > 0) {
$OUT .= "<td><a href='purch-recnote.php?purid={$stkp['purid']}&prd={$prd}'>Record Credit Note</a></td>";
} else {
$OUT .= "<td> </td>";
}
$OUT .= "\n\t\t\t\t<td><a href='purch-det-prd.php?purid={$stkp['purid']}&prd={$prd}'>Details</a></td>\n\t\t\t\t<td><a target='_blank' href='purch-recv-print.php?purid={$stkp['purid']}&prd={$prd}'>Print</a></td>\n\t\t\t</tr>";
}
$OUT .= "\n\t\t<tr class='" . bg_class() . "'>\n\t\t\t<td colspan='6'>Totals</td>\n\t\t\t<td align='right' nowrap>" . CUR . " {$tot1}</td>\n\t\t\t<td align='right' nowrap>" . CUR . " {$tot2}</td>\n\t\t\t<td align='right' nowrap>" . CUR . " {$tot4}</td>\n\t\t\t<td align='right' nowrap>" . CUR . " {$tot3}</td>\n\t\t</tr>";
if (!$pure) {
$OUT .= "\n\t\t\t" . TBL_BR . "\n\t\t\t<form action='" . SELF . "' method='POST'>\n\t\t\t\t<input type='hidden' name='key' value='export' />\n\t\t\t\t<input type='hidden' name='prd' value='{$prd}' />\n\t\t\t\t<input type='hidden' name='from_day' value='{$from_day}' />\n\t\t\t\t<input type='hidden' name='from_month' value='{$from_month}' />\n\t\t\t\t<input type='hidden' name='from_year' value='{$from_year}' />\n\t\t\t\t<input type='hidden' name='to_day' value='{$to_day}' />\n\t\t\t\t<input type='hidden' name='to_month' value='{$to_month}' />\n\t\t\t\t<input type='hidden' name='to_year' value='{$to_year}' />\n\t\t\t\t<tr>\n\t\t\t\t\t<td colspan='4'><input type='submit' value='Export to Spreadsheet'></td>\n\t\t\t\t</tr>\n\t\t\t</form>";
}
$OUT .= "</table>";
return $OUT;
}
function printPurch($_POST)
{
extract($_POST);
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($from_day, "num", 1, 2, "Invalid from Date day.");
$v->isOk($from_month, "num", 1, 2, "Invalid from Date month.");
$v->isOk($from_year, "num", 1, 4, "Invalid from Date Year.");
$v->isOk($to_day, "num", 1, 2, "Invalid to Date day.");
$v->isOk($to_month, "num", 1, 2, "Invalid to Date month.");
$v->isOk($to_year, "num", 1, 4, "Invalid to Date Year.");
# mix dates
$fromdate = $from_year . "-" . $from_month . "-" . $from_day;
$todate = $to_year . "-" . $to_month . "-" . $to_day;
if (!checkdate($from_month, $from_day, $from_year)) {
$v->isOk($fromdate, "num", 1, 1, "Invalid from date.");
}
if (!checkdate($to_month, $to_day, $to_year)) {
$v->isOk($todate, "num", 1, 1, "Invalid to date.");
}
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class='err'>{$e['msg']}</li>";
}
return $confirm;
}
# Set up table to display in
$printOrd = "\n\t\t<center>\n\t\t<form action='" . SELF . "' method='POST'>\n\t\t\t<input type='hidden' name='key' value='export'>\n\t\t\t<input type='hidden' name='fday' value='{$from_day}'>\n\t\t\t<input type='hidden' name='fmon' value='{$from_month}'>\n\t\t\t<input type='hidden' name='fyear' value='{$from_year}'>\n\t\t\t<input type='hidden' name='today' value='{$to_day}'>\n\t\t\t<input type='hidden' name='tomon' value='{$to_month}'>\n\t\t\t<input type='hidden' name='toyear' value='{$to_year}'>\n\t\t<h3>View Stock Orders</h3>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<th>No.</th>\n\t\t\t\t<th>Order No.</th>\n\t\t\t\t<th>Supp Inv No.</th>\n\t\t\t\t<th>Order Date</th>\n\t\t\t\t<th>Supplier</th>\n\t\t\t\t<th>Sub Total</th>\n\t\t\t\t<th>Delivery Charges</th>\n\t\t\t\t<th>Vat</th>\n\t\t\t\t<th>Total</th>\n\t\t\t\t<th>Documents</th>\n\t\t\t</tr>";
# connect to database
db_connect();
# Query server
$i = 0;
$tot1 = 0;
$tot2 = 0;
$tot3 = 0;
$tot4 = 0;
$supsql = "";
if (isset($supplier) and $supplier != 0) {
$supsql = " AND supid = '{$supplier}'";
}
$sql = "SELECT * FROM cancelled_purch WHERE pdate >= '{$fromdate}' AND pdate <= '{$todate}' AND div = '" . USER_DIV . "' {$supsql} ORDER BY pdate DESC";
$stkpRslt = db_exec($sql) or errDie("Unable to retrieve stock purchases from database.");
if (pg_numrows($stkpRslt) < 1) {
return "\n\t\t\t<li class='err'> No stock Orders found</li><br>\n\t\t\t<table border='0' cellpadding='2' cellspacing='1'>\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='purchase-new.php'>New Order</a></td>\n\t\t\t\t</tr>\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td><a href='purchase-view.php'>View Purchases</a></td>\n\t\t\t\t</tr>\n\t\t\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t\t\t</table>";
} else {
while ($stkp = pg_fetch_array($stkpRslt)) {
# Date format
$date = explode("-", $stkp['pdate']);
$date = $date[2] . "-" . $date[1] . "-" . $date[0];
# Calculate the Sub-Total
$stkp['total'] = sprint($stkp['total']);
$stkp['shipchrg'] = sprint($stkp['shipping']);
$subtot = $stkp['subtot'];
$subtot = sprint($subtot);
$vat = sprint($stkp['vat']);
$tot1 = sprint($tot1 + $subtot);
$tot2 = sprint($tot2 + $stkp['shipchrg']);
$tot3 = sprint($tot3 + $stkp['total']);
$tot4 = sprint($tot4 + $vat);
# Get documents
$docs = doclib_getdocs("pur", $stkp['purnum']);
$printOrd .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>{$stkp['purnum']}</td>\n\t\t\t\t\t<td>{$stkp['ordernum']}</td>\n\t\t\t\t\t<td>{$stkp['supinv']}</td>\n\t\t\t\t\t<td>{$date}</td>\n\t\t\t\t\t<td>{$stkp['supname']}</td>\n\t\t\t\t\t<td align='right'>" . CUR . " {$subtot}</td>\n\t\t\t\t\t<td align='right'>" . CUR . " {$stkp['shipchrg']}</td>\n\t\t\t\t\t<td align='right'>" . CUR . " {$vat}</td>\n\t\t\t\t\t<td align='right'>" . CUR . " {$stkp['total']}</td>\n\t\t\t\t\t<td>{$docs}</td>\n\t\t\t\t\t<td><a href='purch-canc-print.php?purid={$stkp['purid']}'>Print</a></td>";
$i++;
}
}
$printOrd .= "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td colspan='5'>Totals</td>\n\t\t\t\t<td align='right'>" . CUR . " {$tot1}</td>\n\t\t\t\t<td align='right'>" . CUR . " {$tot2}</td>\n\t\t\t\t<td align='right'>" . CUR . " {$tot4}</td>\n\t\t\t\t<td align='right'>" . CUR . " {$tot3}</td>\n\t\t\t\t<td colspan='8'> </td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td colspan='17' align='right'><input type='submit' value='Export to Spreadsheet'></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><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='" . bg_class() . "'>\n\t\t\t\t<td><a href='purchase-new.php'>New Order</a></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td><a href='stock-report.php'>Stock Control Reports</a></td>\n\t\t\t</tr>\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td><a href='stock-view.php'>View Stock</a></td>\n\t\t\t</tr>\n\t\t\t<script>document.write(getQuicklinkSpecial());</script>\n\t\t</table>";
return $printOrd;
}
function printInv($_POST)
{
# get vars
extract($_POST);
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($from_day, "num", 1, 2, "Invalid from Date day.");
$v->isOk($from_month, "num", 1, 2, "Invalid from Date month.");
$v->isOk($from_year, "num", 1, 4, "Invalid from Date Year.");
$v->isOk($to_day, "num", 1, 2, "Invalid to Date day.");
$v->isOk($to_month, "num", 1, 2, "Invalid to Date month.");
$v->isOk($to_year, "num", 1, 4, "Invalid to Date Year.");
# mix dates
$fromdate = $from_year . "-" . $from_month . "-" . $from_day;
$todate = $to_year . "-" . $to_month . "-" . $to_day;
if (!checkdate($from_month, $from_day, $from_year)) {
$v->isOk($fromdate, "num", 1, 1, "Invalid from date.");
}
if (!checkdate($to_month, $to_day, $to_year)) {
$v->isOk($todate, "num", 1, 1, "Invalid to date.");
}
# display errors, if any
if ($v->isError()) {
$confirm = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirm .= "<li class='err'>-" . $e["msg"] . "</li>";
}
return $confirm;
}
$accnum = remval($accnum);
if (strlen($accnum) > 0) {
db_conn('cubit');
$Sl = "SELECT * FROM customers WHERE lower(accno)=lower('{$accnum}')";
$Ri = db_exec($Sl);
if (pg_num_rows($Ri) < 1) {
return "<li class='err'>Invalid account number</li>" . slct();
}
$cd = pg_fetch_array($Ri);
$cusnum = $cd['cusnum'];
}
/* make named r2s snapshop */
r2sListSet("invoice_stk_view");
# Set up table to display in
$printInv = "\n\t\t<h3>View invoices. Date Range {$fromdate} to {$todate}</h3>\n\t\t<form action='invoice-proc.php' method='GET'>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<th>Department</th>\n\t\t\t\t<th>No.</th>\n\t\t\t\t<th>Invoice Date</th>\n\t\t\t\t<th>Customer Name</th>\n\t\t\t\t<th>Order No</th>\n\t\t\t\t<th>Customer Order No</th>\n\t\t\t\t<th>Grand Total</th>\n\t\t\t\t<th colspan='2'>Balance</th>\n\t\t\t\t<th>Documents</th>\n\t\t\t\t<th colspan='6'>Options</th>\n\t\t\t</tr>";
# connect to database
db_connect();
# Query server
$i = 0;
$tot1 = 0;
$tot2 = 0;
if (isset($all)) {
$sql = "SELECT * FROM invoices WHERE done = 'y' AND odate>='{$fromdate}' AND odate <= '{$todate}' AND div = '" . USER_DIV . "' ORDER BY invid DESC";
} else {
$sql = "SELECT * FROM invoices WHERE done = 'y' AND odate>='{$fromdate}' AND odate <= '{$todate}' AND cusnum = {$cusnum} AND div = '" . USER_DIV . "' ORDER BY invid DESC";
}
$invRslt = db_exec($sql) or errDie("Unable to retrieve invoices from database.");
// Retrieve the reprint setting
db_conn("cubit");
$sql = "SELECT filename FROM template_settings WHERE template='reprints' AND div='" . USER_DIV . "'";
$tsRslt = db_exec($sql) or errDie("Unable to retrieve template settings from Cubit.");
$template = pg_fetch_result($tsRslt, 0);
if (pg_numrows($invRslt) < 1) {
$printInv = "<li class='err'> No Outstanding Invoices found for the selected customer.</li><br>";
} else {
while ($inv = pg_fetch_array($invRslt)) {
$inv['total'] = sprint($inv['total']);
$inv['balance'] = sprint($inv['balance']);
$tot1 = $tot1 + $inv['total'];
$tot2 = $tot2 + $inv['balance'];
# Get documents
$docs = doclib_getdocs("inv", $inv['invnum']);
# Format date
$inv['odate'] = explode("-", $inv['odate']);
$inv['odate'] = $inv['odate'][2] . "-" . $inv['odate'][1] . "-" . $inv['odate'][0];
if ($inv['printed'] == "n") {
$Dis = "TI {$inv['invid']}";
} else {
$Dis = "{$inv['invnum']}";
}
$det = "invoice-details.php";
$print = "invoice-print.php";
$edit = "cust-credit-stockinv.php";
$reprint = "invoice-reprint.php";
if (isset($mode) && $mode == "creditnote") {
$note = "<input type='button' onClick='document.location.href=\"invoice-note.php?invid={$inv['invid']}\";' value='Credit Note'>";
} else {
$note = "<a href='invoice-note.php?invid={$inv['invid']}'>Credit Note</a>";
}
if ($template == "default") {
$template = "invoice-pdf-reprint.php";
} elseif ($template == "new") {
$template = "pdf-tax-invoice.php";
}
$pdfreprint = $template;
$chbox = "<input type=checkbox name='invids[]' value='{$inv['invid']}' checked=yes>";
if ($inv['location'] == 'int') {
$det = "intinvoice-details.php";
$print = "intinvoice-print.php";
$edit = "intinvoice-new.php";
$reprint = "intinvoice-reprint.php";
if (isset($mode) && $mode == "creditnote") {
$note = "<input type='button' onClick='document.location.href=\"intinvoice-note.php?invid={$inv['invid']}\";' value='Credit Note'>";
} else {
$note = "<a href='intinvoice-note.php?invid={$inv['invid']}'>Credit Note</a>";
}
if ($template == "default") {
$template = "intinvoice-pdf-reprint.php";
} elseif ($template == "new") {
$template = "pdf-tax-invoice.php";
}
$pdfreprint = $template;
$chbox = "<br>";
}
if ($inv['serd'] == 'n') {
$chbox = "";
}
$sp4 = " ";
$fbal = "{$sp4}--{$sp4}";
$bcurr = CUR;
if ($inv['location'] == 'int') {
$fbal = "{$sp4} {$inv['currency']} {$inv['fbalance']}";
$bcurr = $inv['currency'];
}
//<a href='invoice-email.php?invid=$inv[invid]'>Email</a>
$printInv .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>{$inv['deptname']}</td>\n\t\t\t\t\t<td>{$Dis}</td>\n\t\t\t\t\t<td align='center'>{$inv['odate']}</td>\n\t\t\t\t\t<td>{$inv['cusname']} {$inv['surname']}</td>\n\t\t\t\t\t<td align='right'>{$inv['ordno']}</td>\n\t\t\t\t\t<td align='right'>{$inv['cordno']}</td>\n\t\t\t\t\t<td align='right' nowrap>{$bcurr} {$inv['total']}</td>\n\t\t\t\t\t<td align='right' nowrap>" . CUR . " {$inv['balance']}</td>\n\t\t\t\t\t<td align='right' nowrap> {$fbal}</td>\n\t\t\t\t\t<td>{$docs}</td>\n\t\t\t\t\t<td><a href='{$det}?invid={$inv['invid']}'>Details</a></td>\n\t\t\t\t\t<td><input type='checkbox' name='evs[{$inv['invid']}]'></td>";
if ($inv['printed'] == "n") {
$printInv .= "\n\t\t\t\t\t\t<td><a href='{$edit}?invid={$inv['invid']}&cont=1&letters='>Edit</a></td>\n\t\t\t\t\t\t<td><a target='_blank' href='{$print}?invid={$inv['invid']}'>Process</a></td>\n\t\t\t\t\t\t<td align='center'>{$chbox}</td>\n\t\t\t\t\t\t<td> </td>\n\t\t\t\t\t</tr>";
} else {
db_conn($inv["prd"]);
$sql = "SELECT * FROM inv_notes WHERE invid='{$inv['invid']}'";
$note_rslt = db_exec($sql) or errDie("Unable to retrieve credit notes from Cubit.");
if (!pg_num_rows($note_rslt)) {
$delnote = "<td><a target='_blank' href='invoice-delnote.php?invid={$inv['invid']}'>Delivery Note</a></td>";
} else {
$delnote = "<td> </td>";
}
if (round($inv['total'], 0) != round($inv['nbal'], 0)) {
$printInv .= "\n\t\t\t\t\t\t\t<td>{$note}</td>\n\t\t\t\t\t\t\t<td><a target='_blank' href='{$reprint}?invid={$inv['invid']}&type=invreprint'>Reprint</a></td>\n\t\t\t\t\t\t\t<td><a href='pdf/{$pdfreprint}?invid={$inv['invid']}&type=invreprint' target='_blank'>Reprint in PDF</a></td>\n\t\t\t\t\t\t\t{$delnote}\n\t\t\t\t\t\t</tr>";
} else {
$printInv .= "\n\t\t\t\t\t\t\t<td>Settled</td>\n\t\t\t\t\t\t\t<td><a target='_blank' href='{$reprint}?invid={$inv['invid']}&type=invreprint'>Reprint</a></td>\n\t\t\t\t\t\t\t<td><a href='pdf/{$pdfreprint}?invid={$inv['invid']}&type=invreprint' target='_blank'>Reprint in PDF</a></td>\n\t\t\t\t\t\t\t{$delnote}\n\t\t\t\t\t\t</tr>";
}
}
$i++;
}
}
$tot1 = sprint($tot1);
$tot2 = sprint($tot2);
// $bgColor = bgcolor($i);
// Layout
if ($i > 0) {
$printInv .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td colspan='6'>Totals:{$i}</td>\n\t\t\t\t\t<td align='right' nowrap>" . CUR . " {$tot1}</td>\n\t\t\t\t\t<td align='right' nowrap>" . CUR . " {$tot2}</td>\n\t\t\t\t\t<td colspan='3'><br></td>\n\t\t\t\t\t<td colspan='3' align='right'><input type='submit' value='Email Selected' name='email'>\n\t\t\t\t\t</td><td colspan='10' align='right'><input type='submit' value='Process Selected' name='proc'></td>\n\t\t\t\t</tr>\n\t\t\t</table>";
}
$printInv .= "\n\t\t</table>\n\t\t</form>";
return $printInv;
}
function find_invoice($invnum)
{
if (!isset($invnum) or strlen($invnum) < 1) {
$invnum = 0;
} else {
$invnum = trim($invnum);
}
###############################################[ NORMAL INVOICES ]#############################################
$normalInv = "\n\t\t<h3>Invoices</h3>\n\t\t<tr>\n\t\t\t<th>Department</th>\n\t\t\t<th>No.</th>\n\t\t\t<th>Invoice Date</th>\n\t\t\t<th>Customer Name</th>\n\t\t\t<th>Order No</th>\n\t\t\t<th>Customer Order No</th>\n\t\t\t<th>Grand Total</th>\n\t\t\t<th colspan='2'>Balance</th>\n\t\t\t<th>Documents</th>\n\t\t\t<th colspan='6'>Options</th>\n\t\t</tr>";
# connect to database
db_connect();
# Query server
$i = 0;
$tot1 = 0;
$tot2 = 0;
$sql = "SELECT * FROM invoices WHERE done = 'y' AND invnum = '{$invnum}' AND div = '" . USER_DIV . "' ORDER BY invid DESC";
$invRslt = db_exec($sql) or errDie("Unable to retrieve invoices from database.");
// Retrieve the reprint setting
db_conn("cubit");
$sql = "SELECT filename FROM template_settings WHERE template='reprints' AND div='" . USER_DIV . "'";
$tsRslt = db_exec($sql) or errDie("Unable to retrieve template settings from Cubit.");
$template = pg_fetch_result($tsRslt, 0);
if (pg_numrows($invRslt) < 1) {
$normalInv = "<li class='err'> No Outstanding Invoices found for the selected customer.</li><br>";
} else {
while ($inv = pg_fetch_array($invRslt)) {
$inv['total'] = sprint($inv['total']);
$inv['balance'] = sprint($inv['balance']);
$tot1 = $tot1 + $inv['total'];
$tot2 = $tot2 + $inv['balance'];
# Get documents
$docs = doclib_getdocs("inv", $inv['invnum']);
# Format date
$inv['odate'] = explode("-", $inv['odate']);
$inv['odate'] = $inv['odate'][2] . "-" . $inv['odate'][1] . "-" . $inv['odate'][0];
if ($inv['printed'] == "n") {
$Dis = "TI {$inv['invid']}";
} else {
$Dis = "{$inv['invnum']}";
}
$det = "invoice-details.php";
$print = "invoice-print.php";
$edit = "cust-credit-stockinv.php";
$reprint = "invoice-reprint.php";
if (isset($mode) && $mode == "creditnote") {
$note = "<input type='button' onClick='document.location.href=\"invoice-note.php?invid={$inv['invid']}\";' value='Credit Note'>";
} else {
$note = "<a href='invoice-note.php?invid={$inv['invid']}'>Credit Note</a>";
}
if ($template == "default") {
$template = "invoice-pdf-reprint.php";
} elseif ($template == "new") {
$template = "pdf-tax-invoice.php";
}
$pdfreprint = $template;
$chbox = "<input type=checkbox name='invids[]' value='{$inv['invid']}' checked=yes>";
if ($inv['location'] == 'int') {
$det = "intinvoice-details.php";
$print = "intinvoice-print.php";
$edit = "intinvoice-new.php";
$reprint = "intinvoice-reprint.php";
if (isset($mode) && $mode == "creditnote") {
$note = "<input type='button' onClick='document.location.href=\"intinvoice-note.php?invid={$inv['invid']}\";' value='Credit Note'>";
} else {
$note = "<a href='intinvoice-note.php?invid={$inv['invid']}'>Credit Note</a>";
}
if ($template == "default") {
$template = "intinvoice-pdf-reprint.php";
} elseif ($template == "new") {
$template = "pdf-tax-invoice.php";
}
$pdfreprint = $template;
$chbox = "<br>";
}
if ($inv['serd'] == 'n') {
$chbox = "";
}
$sp4 = " ";
$fbal = "{$sp4}--{$sp4}";
$bcurr = CUR;
if ($inv['location'] == 'int') {
$fbal = "{$sp4} {$inv['currency']} {$inv['fbalance']}";
$bcurr = $inv['currency'];
}
//<a href='invoice-email.php?invid=$inv[invid]'>Email</a>
$normalInv .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>{$inv['deptname']}</td>\n\t\t\t\t\t<td>{$Dis}</td>\n\t\t\t\t\t<td align='center'>{$inv['odate']}</td>\n\t\t\t\t\t<td>{$inv['cusname']} {$inv['surname']}</td>\n\t\t\t\t\t<td align='right'>{$inv['ordno']}</td>\n\t\t\t\t\t<td align='right'>{$inv['cordno']}</td>\n\t\t\t\t\t<td align='right' nowrap>{$bcurr} {$inv['total']}</td>\n\t\t\t\t\t<td align='right' nowrap>" . CUR . " {$inv['balance']}</td>\n\t\t\t\t\t<td align='right' nowrap> {$fbal}</td>\n\t\t\t\t\t<td>{$docs}</td>\n\t\t\t\t\t<td><a target='_blank' href='{$det}?invid={$inv['invid']}'>Details</a></td>";
if ($inv['printed'] == "n") {
$normalInv .= "\n\t\t\t\t\t\t<td><a href='{$edit}?invid={$inv['invid']}&cont=1&letters='>Edit</a></td>\n\t\t\t\t\t\t<td><a target='_blank' href='{$print}?invid={$inv['invid']}'>Process</a></td>\n\t\t\t\t\t\t<td align='center'>{$chbox}</td>\n\t\t\t\t\t\t<td> </td>\n\t\t\t\t\t</tr>";
} else {
db_conn($inv["prd"]);
$sql = "SELECT * FROM inv_notes WHERE invid='{$inv['invid']}'";
$note_rslt = db_exec($sql) or errDie("Unable to retrieve credit notes from Cubit.");
if (!pg_num_rows($note_rslt)) {
$delnote = "<td><a target='_blank' href='invoice-delnote.php?invid={$inv['invid']}'>Delivery Note</a></td>";
} else {
$delnote = "<td> </td>";
}
if (round($inv['total'], 0) != round($inv['nbal'], 0)) {
$normalInv .= "\n\t\t\t\t\t\t\t<td>{$note}</td>\n\t\t\t\t\t\t\t<td><a target='_blank' href='{$reprint}?invid={$inv['invid']}&type=invreprint'>Reprint</a></td>\n\t\t\t\t\t\t\t<td><a href='pdf/{$pdfreprint}?invid={$inv['invid']}&type=invreprint' target='_blank'>Reprint in PDF</a></td>\n\t\t\t\t\t\t\t{$delnote}\n\t\t\t\t\t\t</tr>";
} else {
$normalInv .= "\n\t\t\t\t\t\t\t<td>Settled</td>\n\t\t\t\t\t\t\t<td><a target='_blank' href='{$reprint}?invid={$inv['invid']}&type=invreprint'>Reprint</a></td>\n\t\t\t\t\t\t\t<td><a href='pdf/{$pdfreprint}?invid={$inv['invid']}&type=invreprint' target='_blank'>Reprint in PDF</a></td>\n\t\t\t\t\t\t\t{$delnote}\n\t\t\t\t\t\t</tr>";
}
}
$i++;
}
return $normalInv;
}
##############################################[ /NORMAL INVOICES ]####################################################
################################################[ PAID INVOICES ]#####################################################
# Set up table to display in
$paidInv = "\n\t\t<h3>Paid Invoices</h3>\n\t\t<tr>\n\t\t\t<th>Department</th>\n\t\t\t<th>Invoice No.</th>\n\t\t\t<th>Proforma Inv No.</th>\n\t\t\t<th>Invoice Date</th>\n\t\t\t<th>Customer Name</th>\n\t\t\t<th>Order No</th>\n\t\t\t<th>Customer Order No</th>\n\t\t\t<th>Grand Total</th>\n\t\t\t<th>Documents</th>\n\t\t\t<th colspan='5'>Options</th>\n\t\t</tr>";
// Retrieve template setting
db_conn("cubit");
$sql = "SELECT filename FROM template_settings WHERE template='invoices'";
$tsRslt = db_exec($sql) or errDie("Unable to retrieve template settings from Cubit.");
$template = pg_fetch_result($tsRslt, 0);
if ($template == "invoice-print.php") {
$repr = "invoice-reprint-prd.php";
} else {
$repr = $template;
}
db_conn("cubit");
$sql = "SELECT filename FROM template_settings WHERE template='reprints'";
$tsRslt = db_exec($sql) or errDie("Unable to retrieve template settings from Cubit.");
$template = pg_fetch_result($tsRslt, 0);
if ($template == "new") {
$pdf_repr = "pdf/pdf-tax-invoice.php";
} else {
$pdf_repr = "pdf/invoice-pdf-reprint-prd.php";
}
# Query server
$i = 0;
$tot1 = 0;
$tot2 = 0;
# Connect to database
db_connect();
$queries = array();
for ($i = 1; $i <= 12; $i++) {
$schema = (int) $i;
$queries[] = "SELECT *,'{$schema}' AS query_schema FROM \"{$schema}\".invoices WHERE done = 'y' AND invnum = '{$invnum}' AND div = '" . USER_DIV . "'";
}
$query = implode(" UNION ", $queries);
$query .= " ORDER BY invid DESC";
$invRslt = db_exec($query) or errDie("Unable to retrieve invoices from database.");
if (pg_numrows($invRslt) < 1) {
$paidInv = "<li class='err'>No previous finished invoices found.</li>";
} else {
while ($inv = pg_fetch_array($invRslt)) {
$prd = $inv["query_schema"];
$inv['total'] = sprint($inv['total']);
$inv['balance'] = sprint($inv['balance']);
$tot1 = $tot1 + $inv['total'];
$tot2 = $tot2 + $inv['balance'];
# format date
$inv['odate'] = explode("-", $inv['odate']);
$inv['odate'] = $inv['odate'][2] . "-" . $inv['odate'][1] . "-" . $inv['odate'][0];
# Get documents
$docs = doclib_getdocs("inv", $inv['invnum']);
$sp4 = " ";
$bcurr = CUR;
$det = "invoice-details-prd.php";
$reprint = "<td><a target='_blank' href='{$repr}?type=invpaidreprint&invid={$inv['invid']}&prd={$prd}'>Reprint</a></td>";
$note = "<td><a target='_blank' href='invoice-note-prd.php?invid={$inv['invid']}&prd={$prd}'>Credit Note</a></td>";
if ($inv['location'] == 'int') {
$bcurr = $inv['currency'];
$det = "intinvoice-details-prd.php";
$reprint = "<td><a target='_blank' href='intinvoice-reprint-prd.php?invid={$inv['invid']}&prd={$prd}'>Reprint</a></td>";
$note = "";
}
$delnote = "<td><a target='_blank' href='invoice-delnote-prd.php?invid={$inv['invid']}&prd={$prd}'>Delivery Note</a></td>";
$paidInv .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>{$inv['deptname']}</td>\n\t\t\t\t\t<td>{$inv['invnum']}</td>\n\t\t\t\t\t<td>{$inv['docref']}</td>\n\t\t\t\t\t<td align='center'>{$inv['odate']}</td>\n\t\t\t\t\t<td>{$inv['cusname']} {$inv['surname']}</td>\n\t\t\t\t\t<td align='right'>{$inv['ordno']}</td>\n\t\t\t\t\t<td align='right'>{$inv['cordno']}</td>\n\t\t\t\t\t<td align='right' nowrap>{$bcurr} {$inv['total']}</td>\n\t\t\t\t\t<td>{$docs}</td>\n\t\t\t\t\t<td><a target='_blank' href='{$det}?invid={$inv['invid']}&prd={$prd}'>Details</a></td>\n\t\t\t\t\t</td>{$reprint}</td>\n\t\t\t\t\t<td><a href='{$pdf_repr}?invid={$inv['invid']}&prd={$prd}&type=invpaidreprint' target='_blank'>Reprint in PDF</a></td>\n\t\t\t\t\t{$note}\n\t\t\t\t\t{$delnote}\n\t\t\t\t</tr>";
$i++;
}
return $paidInv;
}
################################################[ /PAID INVOICES ]####################################################
#############################################[ INCOMPLETE INVOICES ]##################################################
# Set up table to display in
$unfInv = "\n\t\t<h3>Incomplete Invoices</h3>\n\t\t<tr>\n\t\t\t<th>Username</th>\n\t\t\t<th>Department</th>\n\t\t\t<th>Sales Person</th>\n\t\t\t<th>Invoice No.</th>\n\t\t\t<th>Invoice Date</th>\n\t\t\t<th>Customer Name</th>\n\t\t\t<th>Order No</th>\n\t\t\t<th>Grand Total</th>\n\t\t\t<th colspan='4'>Options</th>\n\t\t</tr>";
# connect to database
db_connect();
# Query server
$i = 0;
$totgrd = 0;
$sql = "SELECT * FROM invoices WHERE done = 'n' AND printed ='n' AND invnum = '{$invnum}' AND div = '" . USER_DIV . "' ORDER BY invid DESC";
$invRslt = db_exec($sql) or errDie("Unable to retrieve invoices from database.");
if (pg_numrows($invRslt) < 1) {
$unfInv = "<li>No Incomplete Invoices Found.</li>";
} else {
while ($inv = pg_fetch_array($invRslt)) {
# format date
$inv['odate'] = explode("-", $inv['odate']);
$inv['odate'] = $inv['odate'][2] . "-" . $inv['odate'][1] . "-" . $inv['odate'][0];
$cont = "cust-credit-stockinv.php";
if ($inv['location'] == 'int') {
$cont = "intinvoice-new.php";
}
$sp4 = " ";
$bcurr = CUR;
if ($inv['location'] == 'int') {
$bcurr = $inv['currency'];
}
if (isset($button) && $button == "selall") {
$checked = "checked='checked'";
} else {
$checked = "";
}
$inv['total'] = sprint($inv['total']);
$unfInv .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>{$inv['username']}</td>\n\t\t\t\t\t<td>{$inv['deptname']}</td>\n\t\t\t\t\t<td>{$inv['salespn']}</td>\n\t\t\t\t\t<td>TI {$inv['invid']}</td>\n\t\t\t\t\t<td align='center'>{$inv['odate']}</td>\n\t\t\t\t\t<td>{$inv['cusname']} {$inv['surname']}</td>\n\t\t\t\t\t<td align='right'>{$inv['ordno']}</td>\n\t\t\t\t\t<td>{$bcurr} {$inv['total']}</td>\n\t\t\t\t\t<td><a href='{$cont}?invid={$inv['invid']}&cont=true&letters=&done='>Continue</a></td>\n\t\t\t\t\t<td><a href='invoice-unf-cancel.php?invid={$inv['invid']}'>Cancel</a></td>\n\t\t\t\t</tr>";
$totgrd += $inv['total'];
$i++;
}
return $unfInv;
}
############################################[ /INCOMPLETE INVOICES ]##################################################
#############################################[ UNPROCESSED POS INVOICES ]###################################################
# Set up table to display in
$unposInv = "\n\t\t<h3>Unprocessed Point of Sale Invoices</h3>\n\t\t<tr>\n\t\t\t<th>Department</th>\n\t\t\t<th>Sales Person</th>\n\t\t\t<th>Inv No.</th>\n\t\t\t<th>Invoice Date</th>\n\t\t\t<th>Customer</th>\n\t\t\t<th>Grand Total</th>\n\t\t\t<th colspan='4'>Options</th>\n\t\t\t<th> </th>\t\n\t\t</tr>";
# connect to database
db_connect();
# Query server
$i = 0;
$tot1 = 0;
$sql = "SELECT invid, total, odate, deptname, salespn, cusname, printed, balance,cusnum FROM pinvoices WHERE invnum = '{$invnum}' OR invid = '{$invnum}' AND div = '" . USER_DIV . "' ORDER BY invid DESC";
$invRslt = db_exec($sql) or errDie("Unable to retrieve invoices from database.");
if (pg_numrows($invRslt) < 1) {
$unposInv = "<li class='err'>No Point of Sale Invoices found for the selected date range.</li>" . slct();
} else {
while ($inv = pg_fetch_array($invRslt)) {
$inv['total'] = sprint($inv['total']);
$tot1 = $tot1 + $inv['total'];
# format date
$inv['odate'] = explode("-", $inv['odate']);
$inv['odate'] = $inv['odate'][2] . "-" . $inv['odate'][1] . "-" . $inv['odate'][0];
if ($inv['cusnum'] != "0") {
#overwrite the default cusname
$get_cust = "SELECT surname FROM customers WHERE cusnum = '{$inv['cusnum']}' LIMIT 1";
$run_cust = db_exec($get_cust) or errDie("Unable to get customer information.");
if (pg_numrows($run_cust) == 1) {
$arr = pg_fetch_array($run_cust);
$inv['cusname'] = $arr['surname'];
}
}
$unposInv .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>{$inv['deptname']}</td>\n\t\t\t\t\t<td>{$inv['salespn']}</td>\n\t\t\t\t\t<td>TP {$inv['invid']}</td>\n\t\t\t\t\t<td align='center'>{$inv['odate']}</td>\n\t\t\t\t\t<td>{$inv['cusname']}</td>\n\t\t\t\t\t<td align=right>" . CUR . " {$inv['total']}</td>\n\t\t\t\t\t<td><a target='_blank' href='pos-invoice-details.php?invid={$inv['invid']}'>Details</a></td>";
if ($inv['printed'] == "n") {
$unposInv .= "\n\t\t\t\t\t<td><a href='pos-invoice-new.php?invid={$inv['invid']}&cont=1'>Edit</a></td>\n\t\t\t\t\t<td><a href='?invid={$inv['invid']}&key=delete_confirm'>Delete</a></td>\n\t\t\t\t\t<td><a target='_blank' href='pos-invoice-print.php?invid={$inv['invid']}'>Process</a></td>";
} else {
$unposInv .= "\n\t\t\t\t\t<td></td>\n\t\t\t\t\t<td>\n\t\t\t\t\t\t<a target='_blank' href='pos-invoice-reprint.php?invid={$inv['invid']}'>Reprint</a>\n\t\t\t\t\t</td>";
}
if (isset($button) && $button == "allsel") {
$checked = "checked='checked'";
} else {
$checked = "";
}
$unposInv .= "\n\t\t\t\t</tr>";
$i++;
}
return $unposInv;
}
#############################################[ /UNPROCESSED POS INVOICES ]###################################################
#############################################[ PROCESSED POS INVOICES ]###################################################
# Set up table to display in
$posInv = "\n\t\t<h3>Processed Point of Sale Invoices</h3>\n \t<tr>\n \t\t<th>Department</th>\n \t\t<th>Sales Person</th>\n \t\t<th>Invoice No.</th>\n \t\t<th>Invoice Date</th>\n \t\t<th>Customer Name</th>\n \t\t<th>Grand Total</th>\n \t\t<th colspan='4'>Options</th>\n \t</tr>";
# Connect to database
db_connect();
$queries = array();
for ($i = 1; $i <= 12; $i++) {
$schema = (int) $i;
$queries[] = "SELECT *,'{$schema}' AS query_schema FROM \"{$schema}\".pinvoices WHERE done = 'y' AND invnum = '{$invnum}' OR invid = '{$invnum}' AND div = '" . USER_DIV . "'";
}
$query = implode(" UNION ", $queries);
$query .= " ORDER BY invnum DESC";
# Query server
$i = 0;
$tot1 = 0;
$tot2 = 0;
$invRslt = db_exec($query) or errDie("Unable to retrieve invoices from database.");
if (pg_numrows($invRslt) < 1) {
$posInv = "<li>No previous finished invoices.</li>";
} else {
while ($inv = pg_fetch_array($invRslt)) {
$prd = $inv["query_schema"];
$inv['total'] = sprint($inv['total']);
$inv['balance'] = sprint($inv['balance']);
$tot1 = $tot1 + ($inv['total'] - $inv['rounding']);
$tot2 = $tot2 + $inv['balance'];
# format date
$inv['odate'] = explode("-", $inv['odate']);
$inv['odate'] = $inv['odate'][2] . "-" . $inv['odate'][1] . "-" . $inv['odate'][0];
if ($inv['cusnum'] != "0") {
#then get the actual customer
db_connect();
$get_cus = "SELECT * FROM customers WHERE cusnum = '{$inv['cusnum']}' LIMIT 1";
$run_cus = db_exec($get_cus) or errDie("Unable to get customer information");
if (pg_numrows($run_cus) < 1) {
#do nothing
} else {
$carr = pg_fetch_array($run_cus);
$inv['cusname'] = "{$carr['cusname']} {$carr['surname']}";
}
}
$total = sprint($inv['total'] - $inv['rounding']);
$posInv .= "\n\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t<td>{$inv['deptname']}</td>\n\t\t\t\t\t<td>{$inv['salespn']}</td>\n\t\t\t\t\t<td>{$inv['invnum']}</td>\n\t\t\t\t\t<td align='center'>{$inv['odate']}</td>\n\t\t\t\t\t<td>{$inv['cusname']} {$inv['surname']}</td>\n\t\t\t\t\t<td align='right'>" . CUR . " {$total}</td>";
if (round($inv['total'], 0) != round($inv['nbal'], 0)) {
$posInv .= "\n\t\t\t\t\t<td><a href='pos-invoice-note.php?invid={$inv['invid']}&prd={$prd}'>Credit Note</a></td>";
} else {
$posInv .= "\n\t\t\t\t\t<td><br></td>";
}
$posInv .= "\n\t\t\t\t\t<td><a target='_blank' href='pos-invoice-details-prd.php?invid={$inv['invid']}&prd={$prd}'>Details</a></td>\n\t\t\t\t\t<td><a target='_blank' href='pos-invoice-reprint-prd.php?invid={$inv['invid']}&prd={$prd}'>Reprint</a></td>\n\t\t\t\t\t<td><a target='_blank' href='pos-slip.php?invid={$inv['invid']}&prd={$prd}'>Slip</a></td>\n\t\t\t\t</tr>";
$i++;
}
return $posInv;
}
#############################################[ /PROCESSED POS INVOICES ]###################################################
#############################################[ /NON STOCK INVOICES ]###################################################
# Set up table to display in
$nonsOrd = "\n\t\t<h3>Non-Stock Invoices</h3>\n\t\t<tr>\n\t\t\t<th>Invoice Num</th>\n\t\t\t<th>Proforma Inv No.</th>\n\t\t\t<th>Invoice Date</th>\n\t\t\t<th>Customer</th>\n\t\t\t<th>Total</th>\n\t\t\t<th>Documents</th>\n\t\t\t<th colspan=6>Options</th>\n\t\t</tr>";
# connect to database
db_connect();
# Query server
$i = 0;
$tot_subtot = 0;
$tot_total = 0;
$sql = "SELECT * FROM nons_invoices WHERE typ = 'inv' AND invnum = '{$invnum}' OR invid = '{$invnum}' AND div = '" . USER_DIV . "' AND balance > 0 ORDER BY invnum";
$nonstksRslt = db_exec($sql) or errDie("Unable to retrieve invoices from database.");
if (pg_numrows($nonstksRslt) < 1) {
$nonsOrd = "<li class='err'> No Non Stock Invoices Found.</li>";
}
// Retrieve the PDF reprints
db_conn("cubit");
$sql = "SELECT filename FROM template_settings WHERE template='reprints' AND div='" . USER_DIV . "'";
$tsRslt = db_exec($sql) or errDie("Unable to retrieve template settings from Cubit.");
$template = pg_fetch_result($tsRslt, 0);
while ($nonstks = pg_fetch_array($nonstksRslt)) {
// compute the totals
if ($nonstks["xrate"] == 0.0) {
$tot_subtot += $nonstks["subtot"];
$tot_total += $nonstks["total"];
} else {
$tot_subtot += $nonstks["subtot"] * $nonstks["xrate"];
$tot_total += $nonstks["total"] * $nonstks["xrate"];
}
# calculate the Sub-Total
if ($nonstks['invnum'] == 0) {
$nonstks['invnum'] = $nonstks['invid'];
}
$det = "nons-invoice-det.php";
$edit = "nons-invoice-new.php";
$print = "nons-invoice-print.php";
$reprint = "nons-invoice-reprint.php";
$note = "nons-invoice-note.php";
if ($template == "default") {
$template = "nons-invoice-pdf-reprint.php";
} elseif ($template == "new") {
$template = "pdf-tax-invoice.php";
}
$reprpdf = $template;
$cur = CUR;
if ($nonstks['location'] == 'int') {
$det = "nons-intinvoice-det.php";
$edit = "nons-intinvoice-new.php";
$print = "nons-intinvoice-print.php";
$note = "nons-intinvoice-note.php";
if ($template == "default") {
$template = "nons-intinvoice-pdf-reprint.php";
} elseif ($template == "new") {
$template = "pdf-tax-invoice.php";
}
$reprpdf = $template;
$note = "nons-intinvoice-note.php";
$cur = $nonstks['currency'];
}
# Get documents
$docs = doclib_getdocs("ninv", $nonstks['invnum']);
if ($nonstks['accepted'] == " " && $nonstks['done'] != "y") {
$chbox = "<input type='checkbox' name='evs[{$nonstks['invid']}]' value='{$nonstks['invid']}' checked='yes'>";
} else {
$chbox = "";
}
$nonsOrd .= "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>{$nonstks['invnum']}</td>\n\t\t\t\t<td>{$nonstks['docref']}</td>\n\t\t\t\t<td>{$nonstks['odate']}</td>\n\t\t\t\t<td>{$nonstks['cusname']}</td>\n\t\t\t\t<td align='right'>{$cur} {$nonstks['total']}</td>\n\t\t\t\t<td>{$docs}</td>\n\t\t\t\t<td>{$chbox}</td>\n\t\t\t\t<td><a href='{$det}?invid={$nonstks['invid']}'>Details</a></td>";
if ($nonstks['done'] != "y" && $nonstks["subtot"] == 0) {
$nonsOrd .= "\n\t\t\t\t\t<td><a href='{$edit}?invid={$nonstks['invid']}&cont=1'>Edit</a></td>\n\t\t\t\t\t<td><a href='?key=delete_confirm&invid={$nonstks['invid']}'>Delete</a></td>\n\t\t\t\t</tr>";
} elseif ($nonstks['done'] != "y") {
$nonsOrd .= "\n\t\t\t\t\t<td><a href='{$edit}?invid={$nonstks['invid']}&cont=1'>Edit</a></td>\n\t\t\t\t\t<td><a href='?key=delete_confirm&invid={$nonstks['invid']}'>Delete</a></td>\n\t\t\t\t\t<td><a href=# onClick=printer('{$print}?invid={$nonstks['invid']}&type=nons')>Process</a></td>\n\t\t\t\t</tr>";
} else {
$cn = "";
if ($nonstks['accepted'] != "note") {
if (isset($mode) && $mode == "creditnote") {
$cn = "<input type='button' onClick=\"printer('{$note}?invid={$nonstks['invid']}&type=nonsnote');\" value='Credit Note'>";
} else {
$cn = "<a href='#' onClick=printer('{$note}?invid={$nonstks['invid']}&type=nonsnote')>Credit Note</a>";
}
}
$nonsOrd .= "\n\t\t\t\t\t<td>{$cn}</td>\n\t\t\t\t\t<td><a href='#' onClick=printer('{$reprint}?invid={$nonstks['invid']}&type=nonsreprint')>Reprint</a></td>\n\t\t\t\t\t<td><a href='pdf/{$reprpdf}?invid={$nonstks['invid']}&type=nonsreprint' target='_blank'>Reprint in PDF</a></td>\n\t\t\t\t</tr>";
}
return $nonsOrd;
}
#############################################[ /NON STOCK INVOICES ]###################################################
############################################[ PAID NON STOCK INVOICES ]################################################
$paidnonsOrd = "\n\t\t<h3>Paid Non-Stock Invoices</h3>\n\t\t<tr>\n\t\t\t<th>Invoice Num</th>\n\t\t\t<th>Proforma Inv No.</th>\n\t\t\t<th>Invoice Date</th>\n\t\t\t<th>Customer</th>\n\t\t\t<th>Total</th>\n\t\t\t<th>Documents</th>\n\t\t\t<th colspan='6'>Options</th>\n\t\t</tr>";
# connect to database
db_connect();
# Query server
$i = 0;
$tot_subtot = 0;
$tot_total = 0;
$sql = "SELECT * FROM nons_invoices WHERE typ = 'inv' AND invnum = '{$invnum}' OR invid = '{$invnum}' AND div = '" . USER_DIV . "' AND balance = 0 AND done = 'y' ORDER BY invnum";
$nonstksRslt = db_exec($sql) or errDie("Unable to retrieve invoices from database.");
if (pg_numrows($nonstksRslt) < 1) {
$paidnonsOrd = "<li> There are no non stock invoices found.</li>";
}
// Retrieve the PDF reprints
db_conn("cubit");
$sql = "SELECT filename FROM template_settings WHERE template='reprints' AND div='" . USER_DIV . "'";
$tsRslt = db_exec($sql) or errDie("Unable to retrieve template settings from Cubit.");
$template = pg_fetch_result($tsRslt, 0);
while ($nonstks = pg_fetch_array($nonstksRslt)) {
# date format
$date = explode("-", $nonstks['odate']);
$date = $date[2] . "-" . $date[1] . "-" . $date[0];
// compute the totals
if ($nonstks["xrate"] == 0.0) {
$tot_subtot += $nonstks["subtot"];
$tot_total += $nonstks["total"];
} else {
$tot_subtot += $nonstks["subtot"] * $nonstks["xrate"];
$tot_total += $nonstks["total"] * $nonstks["xrate"];
}
if ($nonstks['invnum'] == 0) {
$nonstks['invnum'] = $nonstks['invid'];
}
$det = "nons-invoice-det.php";
$edit = "nons-invoice-new.php";
$print = "nons-invoice-print.php";
$reprint = "nons-invoice-reprint.php";
$note = "nons-invoice-note.php";
if ($template == "default") {
$template = "nons-invoice-pdf-reprint.php";
} elseif ($template == "new") {
$template = "pdf-tax-invoice.php";
}
$reprpdf = $template;
$cur = CUR;
if ($nonstks['location'] == 'int') {
$det = "nons-intinvoice-det.php";
$edit = "nons-intinvoice-new.php";
$print = "nons-intinvoice-print.php";
$note = "nons-intinvoice-note.php";
if ($template == "default") {
$template = "nons-intinvoice-pdf-reprint.php";
} elseif ($template == "new") {
$template = "pdf-tax-invoice.php";
}
$reprpdf = $template;
$note = "nons-intinvoice-note.php";
$cur = $nonstks['currency'];
}
# Get documents
$docs = doclib_getdocs("ninv", $nonstks['invnum']);
if ($nonstks['accepted'] == " " && $nonstks['done'] != "y") {
$chbox = "<input type=checkbox name='evs[{$nonstks['invid']}]' value='{$nonstks['invid']}' checked=yes>";
} else {
$chbox = "";
}
$paidnonsOrd .= "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>{$nonstks['invnum']}</td>\n\t\t\t\t<td>{$nonstks['docref']}</td>\n\t\t\t\t<td>{$date}</td>\n\t\t\t\t<td>{$nonstks['cusname']}</td>\n\t\t\t\t<td align=right>{$cur} {$nonstks['total']}</td>\n\t\t\t\t<td>{$docs}</td>\n\t\t\t\t<td>{$chbox}</td>\n\t\t\t\t<td><a href='{$det}?invid={$nonstks['invid']}'>Details</a></td>";
if ($nonstks['done'] != "y" && $nonstks["subtot"] == 0) {
$paidnonsOrd .= "\n\t\t\t\t\t<td><a href='{$edit}?invid={$nonstks['invid']}&cont=1'>Edit</a></td>\n\t\t\t\t\t<td><a href='?key=delete_confirm&invid={$nonstks['invid']}'>Delete</a></td>\n\t\t\t\t</tr>";
} elseif ($nonstks['done'] != "y") {
$paidnonsOrd .= "\n\t\t\t\t\t<td><a href='{$edit}?invid={$nonstks['invid']}&cont=1'>Edit</a></td>\n\t\t\t\t\t<td><a href='?key=delete_confirm&invid={$nonstks['invid']}'>Delete</a></td>\n\t\t\t\t\t<td><a href=# onClick=printer('{$print}?invid={$nonstks['invid']}&type=nons')>Process</a></td>\n\t\t\t\t</tr>";
} else {
$cn = "";
$paidnonsOrd .= "\n\t\t\t\t\t<td>{$cn}</td>\n\t\t\t\t\t<td><a target='_blank' href='{$reprint}?invid={$nonstks['invid']}&type=nonsreprint'>Reprint</a></td>\n\t\t\t\t\t<td><a href='pdf/{$reprpdf}?invid={$nonstks['invid']}&type=nonsreprint' target='_blank'>Reprint in PDF</a></td>\n\t\t\t\t\t<td><input type='checkbox' name='evs[{$nonstks['invid']}]'></td>\n\t\t\t\t</tr>";
}
return $paidnonsOrd;
}
############################################[ /PAID NON STOCK INVOICES ]################################################
##########################################[ INCOMPLETE NON STOCK INVOICES ]#############################################
$unfnonsOrd = "\n\t\t<h3>Incomplete Non-Stock Invoices</h3>\n\t\t<tr>\n\t\t\t<th>Invoice Num</th>\n\t\t\t<th>Proforma Inv No.</th>\n\t\t\t<th>Invoice Date</th>\n\t\t\t<th>Customer</th>\n\t\t\t<th>Total</th>\n\t\t\t<th colspan='2'>Options</th>\n\t\t</tr>";
# connect to database
db_connect();
# Query server
$i = 0;
$tot_subtot = 0;
$tot_total = 0;
$sql = "SELECT * FROM nons_invoices WHERE typ = 'inv' AND div = '" . USER_DIV . "' AND invnum = '{$invnum}' OR invid = '{$invnum}' AND done = 'n' ORDER BY invnum";
$nonstksRslt = db_exec($sql) or errDie("Unable to retrieve invoices from database.");
if (pg_numrows($nonstksRslt) < 1) {
$unfnonsOrd = "<li> There are no incomplete non stock invoices found.</li>";
}
while ($nonstks = pg_fetch_array($nonstksRslt)) {
# date format
$date = explode("-", $nonstks['sdate']);
$date = $date[2] . "-" . $date[1] . "-" . $date[0];
// compute the totals
if ($nonstks["xrate"] == 0.0) {
$tot_subtot += $nonstks["subtot"];
$tot_total += $nonstks["total"];
} else {
$tot_subtot += $nonstks["subtot"] * $nonstks["xrate"];
$tot_total += $nonstks["total"] * $nonstks["xrate"];
}
# calculate the Sub-Total
if ($nonstks['invnum'] == 0) {
$nonstks['invnum'] = $nonstks['invid'];
}
if (isset($nonstks['multiline']) and $nonstks['multiline'] == "yes") {
$edit = "nons-multiline-invoice-new.php";
} else {
$edit = "nons-invoice-new.php";
}
$cur = CUR;
$unfnonsOrd .= "\n\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t<td>{$nonstks['invnum']}</td>\n\t\t\t\t<td>{$nonstks['docref']}</td>\n\t\t\t\t<td>{$date}</td>\n\t\t\t\t<td>{$nonstks['cusname']}</td>\n\t\t\t\t<td align='right'>{$cur} {$nonstks['total']}</td>\n\t\t\t\t<td><a href='{$edit}?invid={$nonstks['invid']}&cont=1'>Continue</a></td>\n\t\t\t</tr>";
return $unfnonsOrd;
}
##########################################[ /INCOMPLETE NON STOCK INVOICES ]############################################
}
