{

extract($_GET);

$invoices = explode(",",$evs);

if(isset($t)) {

$ex = "<input type='hidden' name='t' value='t'>";

} else {

$ex = "";

}

if (!isset($message)) {

$message = "PDF Invoice Attached.";

}

$out = "

<h3>Confirm Invoices to be e-mailed</h3>

<form action='".SELF."' method='POST'>

$ex

<input type='hidden' name='key' value='print'>

<table ".TMPL_tblDflts.">

<tr>

<th>Message:</th>

<td class='".bg_class()."'><textarea name='message' cols='40' rows='4'>$message</textarea></td>

</tr>

</table>

<br />

<br />

<table ".TMPL_tblDflts.">

<tr>

<th>Inv Num</th>

<th>Customer</th>

<th>Email Address</th>

</tr>";

$i = 0;

db_conn('cubit');

foreach($invoices as $id) {

$id += 0;

if(!isset($t)) {

$Sl = "SELECT invnum,cusnum FROM invoices WHERE invid='$id'";

$Ri = db_exec($Sl);

} else {

$Sl = "SELECT invnum,cusid AS cusnum FROM nons_invoices WHERE invid='$id'";

$Ri = db_exec($Sl);

}

$idd = pg_fetch_array($Ri);

$idd['cusnum'] += 0;

$Sl = "SELECT surname,email FROM customers WHERE cusnum='$idd[cusnum]'";

$Ri = db_exec($Sl);

$cd = pg_fetch_array($Ri);

$out .= "

<tr class='".bg_class()."'>

<td>$idd[invnum]</td>

<td>$cd[surname]</td>

<td><input type='text' name='email[$idd[cusnum]]' value='$cd[email]' size='30'></td>

</tr>

<input type='hidden' name='evs[]' value='$id'>";

$i++;

}

$out .= "

<tr>

<td colspan='3' align='right'><input type='submit' value='Send Emails &raquo;'></td>

</tr>

</form>

</table>";

return $out;

{

extract($_POST);

$out = "

<h3>Results</h3>

<table ".TMPL_tblDflts.">

<tr>

<th>Inv Num</th>

<th>Customer</th>

<th>Email Address</th>

<th>Result</th>

</tr>";

$i = 0;

db_conn('cubit');

foreach($evs as $id) {

$id += 0;

if(!isset($t)) {

$Sl = "SELECT invnum,cusnum FROM invoices WHERE invid='$id'";

$Ri = db_exec($Sl);

} else {

$Sl = "SELECT invnum,cusid AS cusnum FROM nons_invoices WHERE invid='$id'";

$Ri = db_exec($Sl);

}

$idd = pg_fetch_array($Ri);

$idd['cusnum'] += 0;

$Sl = "SELECT surname,email FROM customers WHERE cusnum='$idd[cusnum]'";

$Ri = db_exec($Sl);

$cd = pg_fetch_array($Ri);

if(!isset($t)) {

$out .= "

<tr class='".bg_class()."'>

<td>$idd[invnum]</td>

<td>$cd[surname]</td>

<td>".$email[$idd["cusnum"]]."</td>

<td>".sendvoice($id, "genpdf",$email[$idd["cusnum"]], $message)."</td>

</tr>";

} else {

$out .= "

<tr class='".bg_class()."'>

<td>$idd[invnum]</td>

<td>$cd[surname]</td>

<td>".$email[$idd["cusnum"]]."</td>

<td>".sendvoice($id, "gennonspdf",$email[$idd["cusnum"]], $message)."</td>

</tr>";

}

$i++;

}

$out .= "</table>";

return $out;

{

$es = qryEmailSettings();

if(strlen($es['smtp_host'])<1) {

r2sListSet("emailsettings");

header("Location: email-settings.php");

exit;

}

require_lib("validate");

$v = new validate ();

$v->isOk ($invid, "num", 1, 20, "Invalid invoice number.");

if ($v->isError ()) {

$err = "";

$errors = $v->getErrors();

foreach ($errors as $e) {

$err .= "<li class='err'>".$e["msg"]."</li>";

}

$confirm .= "<p><input type='button' onClick='JavaScript:history.back();' value='&laquo; Correct submission'>";

return $confirm;

}

# Get invoice info

if ( $invfunc == "genpdf" ) {

db_conn("cubit");

$sql = "SELECT cusnum, printed, invnum FROM invoices WHERE invid = '$invid' AND div = '".USER_DIV."'";

$invRslt = db_exec ($sql) or errDie ("Unable to get invoice information");

if (pg_numrows ($invRslt) < 1) {

return "<i class='err'>Not Found</i>";

}

$inv = pg_fetch_array($invRslt);

# Check if invoice has been printed

if($inv['printed'] != "y"){

$error = "<li class='err'> Error : Invoice number <b>$invid</b> has not been printed yet.";

$error .= "<p><input type='button' onClick='JavaScript:history.back();' value='&laquo; Correct submission'>";

return $error;

}

} else {

$sql = "SELECT cusid AS cusnum, invnum FROM nons_invoices WHERE invid = '$invid' AND div = '".USER_DIV."'";

$invRslt = db_exec ($sql) or errDie ("Unable to get invoice information");

if (pg_numrows ($invRslt) < 1) {

return "<i class='err'>Not Found</i>";

}

$inv = pg_fetch_array($invRslt);

}

$invnum = $inv['invnum'];

$Sl = "SELECT * FROM customers WHERE cusnum='$inv[cusnum]'";

$Ri = db_exec($Sl);

$cd = pg_fetch_array($Ri);

if(strlen($email) <1) {

return "This customer does not have an email address";

}

$body = $message;

$send_cc = "";

$send_bcc = "";

$smtp_data['signature'] = $es['sig'];

$smtp_data['smtp_from'] = $es['fromname'];

$smtp_data['smtp_reply'] = $es['reply'];

$smtp_data['smtp_host'] = $es['smtp_host'];

$smtp_data['smtp_auth'] = $es['smtp_auth'];

$smtp_data['smtp_user'] = $es['smtp_user'];

$smtp_data['smtp_pass'] = $es['smtp_pass'];

// build msg body

$body = "$body\n\n$smtp_data[signature]";

// determine whether or not here is an attachment

//$has_attachment = is_uploaded_file($attachment["tmp_name"]);

$has_attachment = true;

// modify message and create content_type header depending on whether or not an attachment was posted

if ( $has_attachment == false ) {

$content_type = "text/html;charset=US-ASCII";

$transfer_encoding = "8bit";

} else { // has attachment

$content_type = "multipart/mixed";

// create the main body

$body_text = "Content-Type: text/plain; charset=US-ASCII\n";

$body_text .= "Content-Transfer-Encoding: base64\n";

$body_text .= "\n" . chunk_split(base64_encode($body));

// get the attachment data

$attachment = Array();

$attachment["data"] = $invfunc($invid);

$attachment["name"] = "invoice$invnum.pdf";

// delete the temporary file

$attachment["data"] = chunk_split(base64_encode($attachment["data"]));

$attachment["headers"] = "Content-Type: application/x-pdf; name=\"$attachment[name]\"\n";

$attachment["headers"] .= "Content-Transfer-Encoding: base64\n";

$attachment["headers"] .= "Content-Disposition: attachment; filename=\"$attachment[name]\"\n";

$attachment["data"] = "$attachment[headers]\n$attachment[data]";

// generate a unique boundary ( md5 of filename + ":=" + filesize )

$boundary = md5($attachment["name"]) . "=:" . strlen($attachment["data"]);

$content_type .= "; boundary=\"$boundary\"";

// put together the body

$body = "\n--$boundary\n$body_text\n\n--$boundary\n$attachment[data]\n\n--$boundary--\n";

}

// build headers

$headers[] = "From: $smtp_data[smtp_from]";

$headers[] = "To: $email";

$headers[] = "Reply-To: $smtp_data[smtp_reply]";

$headers[] = "X-Mailer: Cubit Mail";

$headers[] = "Return-Path: $smtp_data[smtp_reply]";

$headers[] = "Content-Type: $content_type";

//$headers[] = "cc: $send_cc";

//$headers[] = "bcc: $send_bcc";

// create the mime header if should

if ( $has_attachment == TRUE ) {

$headers[] = "MIME-Version: 1.0";

}

// create the header variable (it is done this way, to make management of headers easier, since there

// may be no tabs and unnecesary whitespace in mail headers)

//$headers[] = "\n"; // add another new line to finish the headers

$headers = implode("\n", $headers);

//return "done";

// send the message

$sendmail = & new clsSMTPMail;

$OUTPUT = $sendmail->sendMessages($smtp_data["smtp_host"], 25, $smtp_data["smtp_auth"], $smtp_data["smtp_user"],

$smtp_data["smtp_pass"],$email, $smtp_data["smtp_from"], "Invoice: $inv[invnum]", $body, $headers);

/*if ( mail($send_to, $subject, $body, $headers) == TRUE )

$OUTPUT = "Successfully sent mail to $send_to.<br>";

else

$OUTPUT = "Error sending mail.<br>";*/

return $OUTPUT;

{

global $set_mainFont;

$showvat = TRUE;

$pdf = &new Cezpdf;

$pdf->selectFont($set_mainFont);

// Validate

require_lib("validate");

$v = new Validate();

$v->isOk($invid, "num", 1, 20, "Invalid invoice number.");

// Any errors?

if ($v->isError()) {

$err = "";

$errors = $v->getErrors();

foreach ($errors as $e) {

$err .= "<li class='err'>$e[msg]</li>";

}

$OUTPUT = $confirm;

require("../template.php");

}

// Invoice info

db_conn("cubit");

$sql = "SELECT * FROM invoices WHERE invid='$invid' AND DIV='".USER_DIV."'";

$invRslt = db_exec($sql) or errDie("Unable to retrieve invoice info.");

if (pg_num_rows($invRslt) < 1) {

return "<li class='err'>Not found</li>";

}

$inv = pg_fetch_array($invRslt);

db_conn("cubit");

$sql = "SELECT symbol FROM currency WHERE fcid='$inv[fcid]'";

$curRslt = db_exec($sql) or errDie("Unable to retrieve currency from Cubit.");

$curr = pg_fetch_result($curRslt, 0);

if (!$curr) $curr = CUR;

// Check if stock was selected

db_conn("cubit");

$sql = "SELECT stkid FROM inv_items WHERE invid='$invid' AND DIV='".USER_DIV."'";

$cRslt = db_exec($sql) or errDie("Unable to retrieve invoice info.");

if (pg_num_rows($cRslt) < 1) {

$error = "<li class='err'>Invoice number <b>$invid</b> has no items</li>";

$OUTPUT = $error;

}

// Only needs to be blank, we're manually adding text

$heading = array ( array("") );

// Company info ----------------------------------------------------------

db_conn("cubit");

$sql = "SELECT * FROM compinfo WHERE div='".USER_DIV."'";

$ciRslt = db_exec($sql) or errDie("Unable to retrieve company info from Cubit.");

$comp = pg_fetch_array($ciRslt);

// Banking information ---------------------------------------------------

// $bnkData = qryBankAcct(getdSetting("BANK_DET"));

$bnkData = qryBankAcct($inv['bankid']);

$compinfo = array();

$compinfo[] = array ($comp["addr1"], $comp["paddr1"]);

$compinfo[] = array (pdf_lstr($comp["addr2"], 35), pdf_lstr($comp["paddr2"], 35));

$compinfo[] = array (pdf_lstr($comp["addr3"], 35), pdf_lstr($comp["paddr3"], 35));

$compinfo[] = array (pdf_lstr($comp["addr4"], 35), "$comp[postcode]");

$compinfo[] = array ("<b>REG: </b>$comp[regnum]", "<b>$bnkData[bankname]</b>");

$compinfo[] = array ("<b>VAT REG: </b>$comp[vatnum]", "<b>Branch: </b>$bnkData[branchname]");

$compinfo[] = array ("<b>Tel:</b> $comp[tel]", "<b>Branch Code: </b>$bnkData[branchcode]");

$compinfo[] = array ("<b>Fax:</b> $comp[fax]", "<b>Acc Num: </b>$bnkData[accnum]");

// Date ------------------------------------------------------------------

$date = array (

array ("<b>Date</b>"),

array ($inv['odate'])

);

// Document info ---------------------------------------------------------

db_conn('cubit');

$Sl = "SELECT * FROM settings WHERE constant='SALES'";

$Ri = db_exec($Sl) or errDie("Unable to get settings.");

$data = pg_fetch_array($Ri);

db_conn('cubit');

$Sl = "SELECT * FROM settings WHERE constant='SALES'";

$Ri = db_exec($Sl) or errDie("Unable to get settings.");

$data = pg_fetch_array($Ri);

if($data['value']=="Yes") {

$sp = "<b>Sales Person: </b>$inv[salespn]";

} else {

$sp = "";

}

$docinfo = array (

array ("<b>Invoice No:</b> $inv[invnum]"),

array ("<b>Proforma Inv No:</b> $inv[docref]"),

array ("<b>Sales Order No:</b> $inv[ordno]"),

array ("<b>Account no: </b>$cusData[accno]"),

array ("$sp")

);

if (isset($salespn)) {

$docinfo[] = array("<b>Sales Person:</b> $salespn");

}

// Retrieve the customer information -------------------------------------

db_conn("cubit");

$sql = "SELECT * FROM customers WHERE cusnum='$inv[cusnum]'";

$cusRslt = db_exec($sql) or errDie("Unable to retrieve customer information from Cubit.");

$cusData = pg_fetch_array($cusRslt);

// Customer info ---------------------------------------------------------

$invoice_to = array(

array ("")

);

$cusinfo = array (

array ("<b>$inv[surname]</b>")

);

$cusaddr = explode("\n", $cusData['addr1']);

foreach ( $cusaddr as $v ) {

$cusinfo[] = array(pdf_lstr($v, 40));

}

// $cusinfo[] = array("<b>Account no: </b>$cusData[accno]");

$cuspaddr = array (

array("<b>Postal Address</b>"),

);

$paddr = explode("\n", $cusData["paddr1"]);

foreach ($paddr as $addr) {

$cuspaddr[] = array($addr);

}

$cusdaddr = array (

array ("<b>Delivery Address:</b>"),

);

if($inv['branch'] == 0){

$branchname = "Head Office";

$cusaddr = explode("\n", $cusData['addr1']);

}else {

$get_addr = "SELECT * FROM customer_branches WHERE id = '$inv[branch]' LIMIT 1";

$run_addr = db_exec($get_addr);

if (pg_numrows($run_addr) < 1) {

$cusaddr = Array ();

$branchname = "Head Office";

} else {

$barr = pg_fetch_array($run_addr);

$cusaddr = explode("\n", $barr['branch_descrip']);

$branchname = $barr['branch_name'];

}

}

$cusdaddr[] = array(pdf_lstr("Branch : $branchname", 30));

$del_addr = explode("\n", $inv["del_addr"]);

foreach ($del_addr as $addr ) {

$cusdaddr[] = array(pdf_lstr($addr, 30));

}

// Registration numbers --------------------------------------------------

$regnos = array (

array (

"<b>VAT No:</b>",

"<b>Order No:</b>",

"<b>Delivery Date:</b>"

),

array (

"$inv[cusvatno]",

"$inv[cordno]",

"$inv[deldate]"

)

);

// Items display ---------------------------------------------------------

$items = array ();

db_conn("cubit");

$sql = "SELECT * FROM inv_items WHERE invid='$invid' AND DIV='".USER_DIV."'";

$stkdRslt = db_exec($sql);

while ($stkd = pg_fetch_array($stkdRslt)) {

// Get warehouse

db_conn("exten");

$sql = "SELECT * FROM warehouses WHERE whid='$stkd[whid]' AND DIV='".USER_DIV."'";

$whRslt = db_exec($sql);

$wh = pg_fetch_array($whRslt);

// Get stock in this warehouse

db_conn("cubit");

$sql = "SELECT * FROM stock WHERE stkid='$stkd[stkid]' AND DIV='".USER_DIV."'";

$stkRslt = db_exec($sql);

$stk = pg_fetch_array($stkRslt);

$sp = "";

// Check Tax Excempt

db_conn("cubit");

$sql = "SELECT zero FROM vatcodes WHERE id='$stkd[vatcode]'";

$zRslt = db_exec($sql) or errDie("Unable to retrieve vat code from Cubit.");

$vatex = pg_fetch_result($zRslt, 0);

if($vatex == "Yes"){

$ex = "#";

} else {

$ex = "";

}

$sql = "SELECT * FROM vatcodes WHERE id='$stkd[vatcode]'";

$runsql = db_exec($sql) or errDie("Unable to retrieve vat code from Cubit.");

if(pg_numrows($runsql) < 1){

return "Invalid VAT code entered";

}

$vd = pg_fetch_array($runsql);

if((TAX_VAT != $vd['vat_amount']) AND ($vd['vat_amount'] != "0.00")){

$showvat = FALSE;

}

// keep track of discounts

//$disc += $stkd['disc'];

if ($stkd["account"] > 0) {

$description = $stkd["description"];

} else {

$description = $stk["stkdes"];

}

// Remove any new lines from the description

$ar_desc = explode("\n", $description);

$description = implode(" ", $ar_desc);

$items[] = array(

"Code" => makewidth($pdf, 75, 12, $stk['stkcod']),

"Description" => makewidth($pdf, 175, 12, $ex.strip_tags($description)),

"Qty" => $stkd['qty'],

"Unit Price" => $curr.$stkd['unitcost'],

"Unit Discount" => $curr.$stkd['disc'],

"Amount" => $curr.$stkd['amt']

);

}

$inv["comm"] = fixparag(&$pdf, 3, 520, 11, $inv["comm"]);

/*$inv["comm"] = preg_replace("/[\n]/", " ", $inv["comm"]);

$lines = array();

$txtleft = $inv["comm"];

$done = false;

while (count($lines) < 3 && !$done) {

$mc = maxwidth(&$pdf, 520, 11, $txtleft);

// run until end of a word.

while ($txtleft[$mc - 1] != ' ' && $mc < strlen($txtleft)) ++$mc;

if ($mc == strlen($txtleft)) {

$done = true;

}

$lines[] = substr($txtleft, 0, $mc);

$txtleft = substr($txtleft, $mc);

}

if (strlen($txtleft) > 0) {

$lines[2] .= "...";

}

$inv["comm"] = preg_replace("/ /", " ", implode("\n", $lines));*/

// Comment ---------------------------------------------------------------

$comment = array (

array ("<i>VAT Exempt Indicator : #</i>"),

array ($inv["comm"])

);

// Box for signature -----------------------------------------------------

$sign = array (

array ("<b>Terms:</b> $inv[terms] days"),

array (''),

array ("<b>Received in good order by:</b> ____________________"),

array (''),

// We aren't using a monospace font, so just a lot of spaces until it

// is aligned nicely.

array (" ".

"<b>Date:</b> ____________________")

);

// Totals ----------------------------------------------------------------

if (!isset($showvat))

$showvat = TRUE;

if($showvat == TRUE){

$vat14 = AT14;

}else {

$vat14 = "";

}

$totals = array (

array ("1" => "<b>Subtotal:</b> ", "2"=>$curr."$inv[subtot]"),

array ("1" => "<b>Trade Discount:</b> ", "2"=>$curr."$inv[discount]"),

array ("1" => "<b>Delivery Charge:</b> ", "2"=>$curr."$inv[delivery]"),

array ("1" => "<b>VAT $vat14:</b> ", "2"=>$curr."$inv[vat]"),

array ("1" => "<b>Total Incl VAT:</b> ", "2"=>$curr."$inv[total]")

);

$totCols = array (

"1" => array("width"=>90),

"2" => array("justification"=>"right")

);

$ic = 0;

while ( ++$ic * 22 < count($items) );

// Draw the pages, determine by the amount of items how many pages

// if items > 20 start a new page

$items_print = Array ();

for ($i = 0; $i < $ic; $i++) {

if ( $i ) $pdf->ezNewPage();

// Page number -------------------------------------------------------

$pagenr = array (

array ("<b>Page number</b>"),

array ($i + 1)

);

// Heading

$heading_pos = drawTable(&$pdf, $heading, 0, 0, 520, 5);

drawText(&$pdf, "<b>$comp[compname]</b>", 18, 18, ($heading_pos['y']/2)+6);

drawText(&$pdf, "<b>Tax Invoice</b>", 20, $heading_pos['x']-120, ($heading_pos['y']/2)+9);

// Should we display reprint on the invoice

if ($type == "invreprint") {

drawText(&$pdf, "<b>Reprint</b>", 12, $heading_pos['x']-70, ($heading_pos['y']/2)+22);

}

$compinfo_pos = drawTable(&$pdf, $compinfo, 0, $heading_pos['y'], 320, 8);

$date_pos = drawTable(&$pdf, $date, $compinfo_pos['x'], $heading_pos['y'] , 100, 3);

$pagenr_pos = drawTable(&$pdf, $pagenr, $date_pos['x'], $heading_pos['y'], 100, 3);

$docinfo_pos = drawTable(&$pdf, $docinfo, $compinfo_pos['x'], $date_pos['y'], 200, 5);

$invoice_to_pos = drawTable(&$pdf, $invoice_to, 0, $compinfo_pos['y'], 520, 2);

drawText(&$pdf, "<b>Tax Invoice to:</b>", 12, (520/2)-45, $invoice_to_pos['y']-7);

$cusinfo_pos = drawTable(&$pdf, $cusinfo, 0, $invoice_to_pos['y'], 173, 8);

$cuspaddr_pos = drawTable(&$pdf, $cuspaddr, $cusinfo_pos['x'], $invoice_to_pos['y'], 173, 8);

$cusdaddr_pos = drawTable(&$pdf, $cusdaddr, $cuspaddr_pos['x'], $invoice_to_pos['y'], 174, 8);

$regnos_pos = drawTable(&$pdf, $regnos, 0, $cusinfo_pos['y'], 520, 2);

$items_start = ($i * 22);

if ($i) $items_start++;

if ($items_start >= (count($items) - 22)) {

$items_end = count($items) - 1;

} else {

$items_end = ($i + 1) * 22;

}

$items_print = array();

for ($j = $items_start; $j <= $items_end; $j++) {

$items_print[$j] = $items[$j];

}

$cols = array(

"Code" => array("width"=>80),

"Description" => array("width"=>180),

"Qty" => array("width"=>33),

"Unit Price" => array("width"=>80, "justification"=>"right"),

"Unit Discount" => array("width"=>67, "justification"=>"right"),

"Amount" => array("width"=>80, "justification"=>"right")

);

$items_pos = drawTable(&$pdf, $items_print, 0, $regnos_pos['y']+2, 520, 22, $cols, 1);

$comment_pos = drawTable(&$pdf, $comment, 0, $items_pos['y'], 520, 2);

$sign_pos = drawTable(&$pdf, $sign, 0, $comment_pos['y'], 320, 5);

$totals_pos = drawTable(&$pdf, $totals, $sign_pos['x'], $comment_pos['y'], 200, 5, $totCols);

}

return $pdf->output();

{

global $set_mainFont;

$showvat = TRUE;

$pdf = &new Cezpdf;

$pdf->selectFont($set_mainFont);

// Validate

require_lib("validate");

$v = new Validate();

$v->isOk($invid, "num", 1, 20, "Invalid invoice number.");

// Any errors?

if ($v->isError()) {

$err = "";

$errors = $v->getErrors();

foreach ($errors as $e) {

$err .= "<li class='err'>$e[msg]</li>";

}

$OUTPUT = $confirm;

require("../template.php");

}

// Invoice info

db_conn("cubit");

$sql = "SELECT * FROM nons_invoices WHERE invid='$invid' AND DIV='".USER_DIV."'";

$invRslt = db_exec($sql) or errDie("Unable to retrieve invoice info.");

//die ($sql);

if (pg_num_rows($invRslt) == 0) {

return "<li class='err'>Not found</li>";

}

$inv = pg_fetch_array($invRslt);

db_conn("cubit");

$sql = "SELECT symbol FROM currency WHERE fcid='$inv[fcid]'";

$curRslt = db_exec($sql) or errDie("Unable to retrieve currency from Cubit.");

$curr = pg_fetch_result($curRslt, 0);

if (!$curr) $curr = CUR;

// Only needs to be blank, we're manually adding text

$heading = array ( array("") );

// Company info ----------------------------------------------------------

db_conn("cubit");

$sql = "SELECT * FROM compinfo WHERE div='".USER_DIV."'";

$ciRslt = db_exec($sql) or errDie("Unable to retrieve company info from Cubit.");

$comp = pg_fetch_array($ciRslt);

// $bnkData = qryBankAcct(getdSetting("BANK_DET"));

$bnkData = qryBankAcct($inv['bankid']);

$compinfo = array();

$compinfo[] = array (pdf_lstr($comp["addr1"], 35), pdf_lstr($comp["paddr1"], 35));

$compinfo[] = array (pdf_lstr($comp["addr2"], 35), pdf_lstr($comp["paddr2"], 35));

$compinfo[] = array (pdf_lstr($comp["addr3"], 35), pdf_lstr($comp["paddr3"], 35));

$compinfo[] = array (pdf_lstr($comp["addr4"], 35), "$comp[postcode]");

$compinfo[] = array ("<b>REG: </b>$comp[regnum]", "<b>$bnkData[bankname]</b>");

$compinfo[] = array ("<b>VAT REG: </b>$comp[vatnum]", "<b>Branch: </b>$bnkData[branchname]");

$compinfo[] = array ("<b>Tel:</b> $comp[tel]", "<b>Branch Code: </b>$bnkData[branchcode]");

$compinfo[] = array ("<b>Fax:</b> $comp[fax]", "<b>Acc Num: </b>$bnkData[accnum]");

// Date ------------------------------------------------------------------

$date = array (

array ("<b>Date</b>"),

array ($inv['odate'])

);

// Document info ---------------------------------------------------------

db_conn('cubit');

$Sl = "SELECT * FROM settings WHERE constant='SALES'";

$Ri = db_exec($Sl) or errDie("Unable to get settings.");

$data = pg_fetch_array($Ri);

if($data['value']=="Yes") {

$sp = "<b>Sales Person: </b>$inv[salespn]";

} else {

$sp = "";

}

// Customer info ---------------------------------------------------------

if ($inv["cusid"] != 0) {

db_conn("cubit");

$sql = "SELECT * FROM customers WHERE cusnum='$inv[cusid]'";

$cusRslt = db_exec($sql) or errDie("Unable to retrieve customer information from Cubit.");

$cusData = pg_fetch_array($cusRslt);

} else {

$cusData["surname"] = $inv["cusname"];

$cusData["addr1"] = $inv["cusaddr"];

$cusData["paddr1"] = $inv["cusaddr"];

$cusData["del_addr1"] = "";

$cusData["accno"] = "";

}

$docinfo = array (

array ("<b>Invoice No:</b> $inv[invnum]"),

array ("<b>Proforma Inv No:</b> $inv[docref]"),

array ("<b>Account no: </b>$cusData[accno]"),

array ("$sp")

);

$invoice_to = array(

array ("")

);

$cusinfo = array (

array ("<b>$cusData[surname]</b>")

);

$cusaddr = explode("\n", $cusData['addr1']);

foreach ( $cusaddr as $v ) {

$cusinfo[] = array(pdf_lstr($v, 40));

}

// $cusinfo[] = array("<b>Account no: </b>$cusData[accno]");

$cuspaddr = array (

array ("<b>Postal Address</b>")

);

$paddr = explode("\n", $cusData["paddr1"]);

foreach ($paddr as $addr) {

$cuspaddr[] = array("$addr");

}

$cusdaddr = array (

array ("<b>Delivery Address:</b>"),

);

$cusaddr = explode("\n", $cusData['del_addr1']);

foreach ( $cusaddr as $v ) {

$cusdaddr[] = array(pdf_lstr($v, 40));

}

// Registration numbers --------------------------------------------------

$regnos = array (

array (

"<b>VAT No:</b>",

"<b>Order No:</b>"

),

array (

"$inv[cusvatno]",

"$inv[cordno]"

)

);

// Items display ---------------------------------------------------------

$items = array ();

db_conn("cubit");

$sql = "SELECT * FROM nons_inv_items WHERE invid='$invid' AND DIV='".USER_DIV."'";

$stkdRslt = db_exec($sql);

while ($stkd = pg_fetch_array($stkdRslt)) {

// Check Tax Excempt

db_conn("cubit");

$sql = "SELECT zero FROM vatcodes WHERE id='$stkd[vatex]'";

$zRslt = db_exec($sql) or errDie("Unable to retrieve vat code from Cubit.");

$vatex = pg_fetch_result($zRslt, 0);

if($vatex == "Yes"){

$ex = "#";

} else {

$ex = "";

}

$sql = "SELECT * FROM vatcodes WHERE id='$stkd[vatex]'";

$runsql = db_exec($sql) or errDie("Unable to retrieve vat code from Cubit.");

if(pg_numrows($runsql) < 1){

return "Invalid VAT code entered";

}

$vd = pg_fetch_array($runsql);

if((TAX_VAT != $vd['vat_amount']) AND ($vd['vat_amount'] != "0.00")){

$showvat = FALSE;

}

$items[] = array(

"Description" => makewidth($pdf, 305, 12, $ex.strip_tags($stkd["description"])),

"Qty" => $stkd['qty'],

"Unit Price" => $curr.$stkd['unitcost'],

"Amount" => $curr.$stkd['amt']

);

}

// Comment ---------------------------------------------------------------

$comment = array (

array("<i>VAT Exempt Indicator: #</i>"),

array($inv["remarks"])

);

// Box to sign in --------------------------------------------------------

$sign = array (

array ("<b>Terms:</b> $inv[terms]"),

array (''),

array ("<b>Received in good order by:</b> ____________________"),

array (''),

// We aren't using a monospace font, so just a lot of spaces until it is aligned nicely.

array (" <b>Date:</b> ____________________")

);

// Totals ----------------------------------------------------------------

if (!isset($showvat))

$showvat = TRUE;

if($showvat == TRUE){

$vat14 = AT14;

}else {

$vat14 = "";

}

$totals = array (

array ("1" => "<b>Subtotal:</b> ", "2" => $curr."$inv[subtot]"),

array ("1" => "<b>VAT $vat14:</b> ", "2" => $curr."$inv[vat]"),

array ("1" => "<b>Total Incl VAT:</b> ", "2" => $curr."$inv[total]")

);

$totCols = array (

"1" => array("width"=>90),

"2" => array("justification"=>"right")

);

$ic = 0;

while ( ++$ic * 20 < count($items) );

// Draw the pages, determine by the amount of items how many pages

// if items > 20 start a new page

$items_print = Array ();

for ($i = 0; $i < $ic; $i++) {

if ( $i ) $pdf->ezNewPage();

// Page number -------------------------------------------------------

$pagenr = array (

array ("<b>Page number</b>"),

array ($i + 1)

);

// Heading

$heading_pos = drawTable(&$pdf, $heading, 0, 0, 520, 5);

drawText(&$pdf, "<b>$comp[compname]</b>", 18, 18, ($heading_pos['y']/2)+6);

drawText(&$pdf, "<b>Tax Invoice</b>", 18, $heading_pos['x']-120, ($heading_pos['y']/2)+9);

// Should we display reprint on the invoice

if (isset($type) AND $type == "nonsreprint") {

drawText(&$pdf, "<b>Reprint</b>", 12, $heading_pos['x']-70, ($heading_pos['y']/2)+22);

}

$compinfo_pos = drawTable(&$pdf, $compinfo, 0, $heading_pos['y'], 320, 8);