X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep107.php;h=d9f8aa22b5da82fc05eae1522b24960645008ac9;hb=9a6be31598b20ab95541e4c89db43ff56a105cc2;hp=7baef1a4daadcb783c316f9f3a6aca3f6684494c;hpb=0c1bcd8ce3c089d7ddb3722a097f8fc8417f41e6;p=fa-stable.git diff --git a/reporting/rep107.php b/reporting/rep107.php index 7baef1a4..d9f8aa22 100644 --- a/reporting/rep107.php +++ b/reporting/rep107.php @@ -1,5 +1,14 @@ . +***********************************************************************/ $page_security = 2; // ---------------------------------------------------------------- // $ Revision: 2.0 $ @@ -7,16 +16,15 @@ $page_security = 2; // date_: 2005-05-19 // Title: Print Invoices // ---------------------------------------------------------------- -$path_to_root="../"; +$path_to_root=".."; -include_once($path_to_root . "includes/session.inc"); -include_once($path_to_root . "includes/date_functions.inc"); -include_once($path_to_root . "includes/data_checks.inc"); -include_once($path_to_root . "sales/includes/sales_db.inc"); +include_once($path_to_root . "/includes/session.inc"); +include_once($path_to_root . "/includes/date_functions.inc"); +include_once($path_to_root . "/includes/data_checks.inc"); +include_once($path_to_root . "/sales/includes/sales_db.inc"); //---------------------------------------------------------------------------------------------------- -// trial_inquiry_controls(); print_invoices(); //---------------------------------------------------------------------------------------------------- @@ -25,7 +33,7 @@ function print_invoices() { global $path_to_root; - include_once($path_to_root . "reporting/includes/pdf_report.inc"); + include_once($path_to_root . "/reporting/includes/pdf_report.inc"); $from = $_POST['PARAM_0']; $to = $_POST['PARAM_1']; @@ -39,7 +47,7 @@ function print_invoices() $from = 0; if ($to == null) $to = 0; - $dec =user_price_dec(); + $dec = user_price_dec(); $fno = explode("-", $from); $tno = explode("-", $to); @@ -57,7 +65,7 @@ function print_invoices() if ($email == 0) { - $rep = new FrontReport(_('INVOICE'), "InvoiceBulk.pdf", user_pagesize()); + $rep = new FrontReport(_('INVOICE'), "InvoiceBulk", user_pagesize()); $rep->currency = $cur; $rep->Font(); $rep->Info($params, $cols, null, $aligns); @@ -104,23 +112,28 @@ function print_invoices() $SubTotal = 0; while ($myrow2=db_fetch($result)) { - $Net = $sign * ((1 - $myrow2["discount_percent"]) * $myrow2["unit_price"] * $myrow2["quantity"]); - $SubTotal += $Net; + $Net = round2($sign * ((1 - $myrow2["discount_percent"]) * $myrow2["unit_price"] * $myrow2["quantity"]), + user_price_dec()); + $SubTotal += $Net; $DisplayPrice = number_format2($myrow2["unit_price"],$dec); - $DisplayQty = number_format2($sign*$myrow2["quantity"],user_qty_dec()); + $DisplayQty = number_format2($sign*$myrow2["quantity"],get_qty_dec($myrow2['stock_id'])); $DisplayNet = number_format2($Net,$dec); if ($myrow2["discount_percent"]==0) $DisplayDiscount =""; else $DisplayDiscount = number_format2($myrow2["discount_percent"]*100,user_percent_dec()) . "%"; $rep->TextCol(0, 1, $myrow2['stock_id'], -2); - $rep->TextCol(1, 2, $myrow2['StockDescription'], -2); + $oldrow = $rep->row; + $rep->TextColLines(1, 2, $myrow2['StockDescription'], -2); + $newrow = $rep->row; + $rep->row = $oldrow; $rep->TextCol(2, 3, $DisplayQty, -2); $rep->TextCol(3, 4, $myrow2['units'], -2); $rep->TextCol(4, 5, $DisplayPrice, -2); $rep->TextCol(5, 6, $DisplayDiscount, -2); $rep->TextCol(6, 7, $DisplayNet, -2); - $rep->NewLine(1); + $rep->row = $newrow; + //$rep->NewLine(1); if ($rep->row < $rep->bottomMargin + (15 * $rep->lineHeight)) $rep->Header2($myrow, $branch, $sales_order, $baccount,$j); } @@ -136,16 +149,16 @@ function print_invoices() $DisplaySubTot = number_format2($SubTotal,$dec); $DisplayFreight = number_format2($sign*$myrow["ov_freight"],$dec); - $rep->row = $rep->bottomMargin + (15 * $rep->lineHeight); + $rep->row = $rep->bottomMargin + (15 * $rep->lineHeight); $linetype = true; $doctype = $j; if ($rep->currency != $myrow['curr_code']) { - include($path_to_root . "reporting/includes/doctext2.inc"); + include($path_to_root . "/reporting/includes/doctext2.inc"); } else { - include($path_to_root . "reporting/includes/doctext.inc"); + include($path_to_root . "/reporting/includes/doctext.inc"); } $rep->TextCol(3, 6, $doc_Sub_total, -2); @@ -154,11 +167,11 @@ function print_invoices() $rep->TextCol(3, 6, $doc_Shipping, -2); $rep->TextCol(6, 7, $DisplayFreight, -2); $rep->NewLine(); - $tax_items = get_customer_trans_tax_details($j, $i); + $tax_items = get_trans_tax_details($j, $i); while ($tax_item = db_fetch($tax_items)) { $DisplayTax = number_format2($sign*$tax_item['amount'], $dec); - + if ($tax_item['included_in_price']) { $rep->TextCol(3, 7, $doc_Included . " " . $tax_item['tax_type_name'] .