X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=reporting%2Frep209.php;h=767270fc742bafa8b2c34544b4ed8d3de076002c;hb=7fae690528df9b851fba309b71bf7c3b961c9dd9;hp=b6b88a4572ee85b310b3493d5109b019c5594441;hpb=8ea6c4dd0d9b31b3456d012b0c94339b801bee0c;p=fa-stable.git diff --git a/reporting/rep209.php b/reporting/rep209.php index b6b88a45..767270fc 100644 --- a/reporting/rep209.php +++ b/reporting/rep209.php @@ -31,7 +31,8 @@ print_po(); //---------------------------------------------------------------------------------------------------- function get_po($order_no) { - $sql = "SELECT ".TB_PREF."purch_orders.*, ".TB_PREF."suppliers.supp_name, ".TB_PREF."suppliers.supp_account_no, + $sql = "SELECT ".TB_PREF."purch_orders.*, ".TB_PREF."suppliers.supp_name, " + .TB_PREF."suppliers.rep_lang, ".TB_PREF."suppliers.supp_account_no, ".TB_PREF."suppliers.curr_code, ".TB_PREF."suppliers.payment_terms, ".TB_PREF."locations.location_name, ".TB_PREF."suppliers.email, ".TB_PREF."suppliers.address, ".TB_PREF."suppliers.contact FROM ".TB_PREF."purch_orders, ".TB_PREF."suppliers, ".TB_PREF."locations @@ -83,6 +84,7 @@ function print_po() if ($email == 0) { $rep = new FrontReport(_('PURCHASE ORDER'), "PurchaseOrderBulk", user_pagesize()); + $rep->SetHeaderType('Header2'); $rep->currency = $cur; $rep->Font(); $rep->Info($params, $cols, null, $aligns); @@ -97,6 +99,7 @@ function print_po() if ($email == 1) { $rep = new FrontReport("", "", user_pagesize()); + $rep->SetHeaderType('Header2'); $rep->currency = $cur; $rep->Font(); $rep->title = _('PURCHASE ORDER'); @@ -105,7 +108,8 @@ function print_po() } else $rep->title = _('PURCHASE ORDER'); - $rep->Header2($myrow, null, $myrow, $baccount, 8); + $rep->SetCommonData($myrow, null, $myrow, $baccount, ST_PURCHORDER); + $rep->NewPage(); $result = get_po_details($i); $SubTotal = 0; @@ -139,7 +143,7 @@ function print_po() $rep->TextCol(6, 7, $DisplayNet, -2); $rep->NewLine(1); if ($rep->row < $rep->bottomMargin + (15 * $rep->lineHeight)) - $rep->Header2($myrow, $branch, $myrow, $baccount, 8); + $rep->NewPage(); } if ($myrow['comments'] != "") { @@ -150,15 +154,8 @@ function print_po() $rep->row = $rep->bottomMargin + (15 * $rep->lineHeight); $linetype = true; - $doctype = 8; - if ($rep->currency != $myrow['curr_code']) - { - include($path_to_root . "/reporting/includes/doctext2.inc"); - } - else - { - include($path_to_root . "/reporting/includes/doctext.inc"); - } + $doctype = ST_PURCHORDER; + include($path_to_root . "/reporting/includes/doctext.inc"); $rep->TextCol(3, 6, $doc_Sub_total, -2); $rep->TextCol(6, 7, $DisplaySubTot, -2); @@ -167,6 +164,12 @@ function print_po() $rep->Font('bold'); $rep->TextCol(3, 6, $doc_TOTAL_PO, - 2); $rep->TextCol(6, 7, $DisplayTotal, -2); + $words = price_in_words($SubTotal, ST_PURCHORDER); + if ($words != "") + { + $rep->NewLine(1); + $rep->TextCol(1, 7, $myrow['curr_code'] . ": " . $words, - 2); + } $rep->Font(); if ($email == 1) {