X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep109.php;h=8b22697ad9a52a0a153d08fe22a1760c0ecba751;hb=8d0b87e3e7dcf325fd55fe5f8c6fb3b8b45ffaa1;hp=181a0344ecbf582bb5a55d531e989fe1fa7e74f5;hpb=91a637fe74ce0d78b9b4ce099b42449da87c6e71;p=fa-stable.git diff --git a/reporting/rep109.php b/reporting/rep109.php index 181a0344..8b22697a 100644 --- a/reporting/rep109.php +++ b/reporting/rep109.php @@ -33,7 +33,7 @@ $print_as_quote = 0; function print_sales_orders() { - global $path_to_root, $print_as_quote; + global $path_to_root, $print_as_quote, $no_zero_lines_amount; include_once($path_to_root . "/reporting/includes/pdf_report.inc"); @@ -43,11 +43,11 @@ function print_sales_orders() $email = $_POST['PARAM_3']; $print_as_quote = $_POST['PARAM_4']; $comments = $_POST['PARAM_5']; + $orientation = $_POST['PARAM_6']; - if ($from == null) - $from = 0; - if ($to == null) - $to = 0; + if (!$from || !$to) return; + + $orientation = ($orientation ? 'L' : 'P'); $dec = user_price_dec(); $cols = array(4, 60, 225, 300, 325, 385, 450, 515); @@ -62,27 +62,25 @@ function print_sales_orders() if ($email == 0) { if ($print_as_quote == 0) - $rep = new FrontReport(_("SALES ORDER"), "SalesOrderBulk", user_pagesize()); + $rep = new FrontReport(_("SALES ORDER"), "SalesOrderBulk", user_pagesize(), 9, $orientation); else - $rep = new FrontReport(_("QUOTE"), "QuoteBulk", user_pagesize()); - $rep->SetHeaderType('Header2'); - $rep->currency = $cur; - $rep->Font(); - $rep->Info($params, $cols, null, $aligns); + $rep = new FrontReport(_("QUOTE"), "QuoteBulk", user_pagesize(), 9, $orientation); } + if ($orientation == 'L') + recalculate_cols($cols); for ($i = $from; $i <= $to; $i++) { $myrow = get_sales_order_header($i, ST_SALESORDER); + if ($currency != ALL_TEXT && $myrow['curr_code'] != $currency) { + continue; + } $baccount = get_default_bank_account($myrow['curr_code']); $params['bankaccount'] = $baccount['id']; $branch = get_branch($myrow["branch_code"]); if ($email == 1) { - $rep = new FrontReport("", "", user_pagesize()); - $rep->SetHeaderType('Header2'); - $rep->currency = $cur; - $rep->Font(); + $rep = new FrontReport("", "", user_pagesize(), 9, $orientation); if ($print_as_quote == 1) { $rep->title = _('QUOTE'); @@ -93,12 +91,15 @@ function print_sales_orders() $rep->title = _("SALES ORDER"); $rep->filename = "SalesOrder" . $i . ".pdf"; } - $rep->Info($params, $cols, null, $aligns); } else $rep->title = ($print_as_quote==1 ? _("QUOTE") : _("SALES ORDER")); + $rep->SetHeaderType('Header2'); + $rep->currency = $cur; + $rep->Font(); + $rep->Info($params, $cols, null, $aligns); - $contacts = get_branch_contacts($branch['branch_code'], 'order', $branch['debtor_no']); + $contacts = get_branch_contacts($branch['branch_code'], 'order', $branch['debtor_no'], true); $rep->SetCommonData($myrow, $branch, $myrow, $baccount, ST_SALESORDER, $contacts); $rep->NewPage(); @@ -124,11 +125,14 @@ function print_sales_orders() $rep->TextColLines(1, 2, $myrow2['description'], -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); + if ($Net != 0.0 || !is_service($myrow2['mb_flag']) || !isset($no_zero_lines_amount) || $no_zero_lines_amount == 0) + { + $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->row = $newrow; //$rep->NewLine(1); if ($rep->row < $rep->bottomMargin + (15 * $rep->lineHeight))