X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep111.php;h=02c398153d77e29f1af1424a66956a69d9dbc233;hb=13367be8aaf5175295f7aab7160370458dad1824;hp=c70ac618080136fc6980bfe50a9592209f7ea49a;hpb=6a3e11b77872ecdc9a6390307943ada56ca7d17c;p=fa-stable.git diff --git a/reporting/rep111.php b/reporting/rep111.php index c70ac618..02c39815 100644 --- a/reporting/rep111.php +++ b/reporting/rep111.php @@ -31,7 +31,7 @@ print_sales_quotations(); function print_sales_quotations() { - global $path_to_root, $print_as_quote, $print_invoice_no; + global $path_to_root, $print_as_quote, $SysPrefs, $pic_height; include_once($path_to_root . "/reporting/includes/pdf_report.inc"); @@ -40,13 +40,17 @@ function print_sales_quotations() $currency = $_POST['PARAM_2']; $email = $_POST['PARAM_3']; $comments = $_POST['PARAM_4']; + $orientation = $_POST['PARAM_5']; - if ($from == null) - $from = 0; - if ($to == null) - $to = 0; + if (!$from || !$to) return; + + $orientation = ($orientation ? 'L' : 'P'); $dec = user_price_dec(); + $pictures = $SysPrefs->print_item_images_on_quote(); + // If you want a larger image, then increase $pic_height f.i. + // $pic_height += 25; + $cols = array(4, 60, 225, 300, 325, 385, 450, 515); // $headers in doctext.inc @@ -57,13 +61,9 @@ function print_sales_quotations() $cur = get_company_Pref('curr_default'); if ($email == 0) - { - $rep = new FrontReport(_("SALES QUOTATION"), "SalesQuotationBulk", user_pagesize()); - $rep->SetHeaderType('Header2'); - $rep->currency = $cur; - $rep->Font(); - $rep->Info($params, $cols, null, $aligns); - } + $rep = new FrontReport(_("SALES QUOTATION"), "SalesQuotationBulk", user_pagesize(), 9, $orientation); + if ($orientation == 'L') + recalculate_cols($cols); for ($i = $from; $i <= $to; $i++) { @@ -73,18 +73,18 @@ function print_sales_quotations() $branch = get_branch($myrow["branch_code"]); if ($email == 1) { - $rep = new FrontReport("", "", user_pagesize()); - $rep->SetHeaderType('Header2'); - $rep->currency = $cur; - $rep->Font(); - if ($print_invoice_no == 1) + $rep = new FrontReport("", "", user_pagesize(), 9, $orientation); + if ($SysPrefs->print_invoice_no() == 1) $rep->filename = "SalesQuotation" . $i . ".pdf"; else $rep->filename = "SalesQuotation" . $myrow['reference'] . ".pdf"; - $rep->Info($params, $cols, null, $aligns); } - $rep->title = _("SALES QUOTATION"); - $contacts = get_branch_contacts($branch['branch_code'], 'order', $branch['debtor_no']); + $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'], true); $rep->SetCommonData($myrow, $branch, $myrow, $baccount, ST_SALESQUOTE, $contacts); //$rep->headerFunc = 'Header2'; $rep->NewPage(); @@ -111,12 +111,29 @@ function print_sales_quotations() $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']) || !$SysPrefs->no_zero_lines_amount()) + { + $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; + + if ($pictures) + { + $image = company_path(). "/images/" . item_img_name($myrow2['stk_code']) . ".jpg"; + if (file_exists($image)) + { + //$rep->NewLine(); + if ($rep->row - $pic_height < $rep->bottomMargin) + $rep->NewPage(); + $rep->AddImage($image, $rep->cols[1], $rep->row - $pic_height, 0, $pic_height); + $rep->row -= $pic_height; + $rep->NewLine(); + } + } //$rep->NewLine(1); if ($rep->row < $rep->bottomMargin + (15 * $rep->lineHeight)) $rep->NewPage(); @@ -130,20 +147,18 @@ function print_sales_quotations() $DisplayFreight = number_format2($myrow["freight_cost"],$dec); $rep->row = $rep->bottomMargin + (15 * $rep->lineHeight); - $linetype = true; $doctype = ST_SALESQUOTE; - include($path_to_root . "/reporting/includes/doctext.inc"); - $rep->TextCol(3, 6, $doc_Sub_total, -2); + $rep->TextCol(3, 6, _("Sub-total"), -2); $rep->TextCol(6, 7, $DisplaySubTot, -2); $rep->NewLine(); - $rep->TextCol(3, 6, $doc_Shipping, -2); + $rep->TextCol(3, 6, _("Shipping"), -2); $rep->TextCol(6, 7, $DisplayFreight, -2); $rep->NewLine(); $DisplayTotal = number_format2($myrow["freight_cost"] + $SubTotal, $dec); if ($myrow['tax_included'] == 0) { - $rep->TextCol(3, 6, $doc_TOTAL_ORDER, - 2); + $rep->TextCol(3, 6, _("TOTAL ORDER EX VAT"), - 2); $rep->TextCol(6, 7, $DisplayTotal, -2); $rep->NewLine(); } @@ -161,7 +176,7 @@ function print_sales_quotations() if ($myrow['tax_included']) { - if (isset($alternative_tax_include_on_docs) && $alternative_tax_include_on_docs == 1) + if ($SysPrefs->alternative_tax_include_on_docs() == 1) { if ($first) { @@ -174,7 +189,7 @@ function print_sales_quotations() $first = false; } else - $rep->TextCol(3, 7, $doc_Included . " " . $tax_type_name . " " . $doc_Amount . ": " . $DisplayTax, -2); + $rep->TextCol(3, 7, _("Included") . " " . $tax_type_name . " " . _("Amount") . ": " . $DisplayTax, -2); } else { @@ -189,7 +204,7 @@ function print_sales_quotations() $DisplayTotal = number_format2($myrow["freight_cost"] + $SubTotal, $dec); $rep->Font('bold'); - $rep->TextCol(3, 6, $doc_TOTAL_ORDER2, - 2); + $rep->TextCol(3, 6, _("TOTAL ORDER VAT INCL."), - 2); $rep->TextCol(6, 7, $DisplayTotal, -2); $words = price_in_words($myrow["freight_cost"] + $SubTotal, ST_SALESQUOTE); if ($words != "") @@ -200,9 +215,9 @@ function print_sales_quotations() $rep->Font(); if ($email == 1) { - if ($print_invoice_no == 1) + if ($SysPrefs->print_invoice_no() == 1) $myrow['reference'] = $i; - $rep->End($email, $doc_Invoice_no . " " . $myrow['reference'], $myrow); + $rep->End($email); } } if ($email == 0)