X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep107.php;h=1288e5173e6a0fa90192d049ee7b7c606978bd90;hb=19be59309583e17fe486bfd3327ecf5e444dac75;hp=653347e8a1ffc6f36f339c17afe43d5763d8b32d;hpb=da8311619dd73feae101d246a1957b972e00cbd2;p=fa-stable.git diff --git a/reporting/rep107.php b/reporting/rep107.php index 653347e8..1288e517 100644 --- a/reporting/rep107.php +++ b/reporting/rep107.php @@ -24,36 +24,37 @@ print_invoices(); function print_invoices() { global $path_to_root; - + include_once($path_to_root . "reporting/includes/pdf_report.inc"); - + $from = $_POST['PARAM_0']; $to = $_POST['PARAM_1']; $currency = $_POST['PARAM_2']; $bankaccount = $_POST['PARAM_3']; - $email = $_POST['PARAM_4']; - $comments = $_POST['PARAM_5']; + $email = $_POST['PARAM_4']; + $paylink = $_POST['PARAM_5']; + $comments = $_POST['PARAM_6']; if ($from == null) $from = 0; if ($to == null) $to = 0; - $dec =user_price_dec(); - + $dec = user_price_dec(); + $fno = explode("-", $from); $tno = explode("-", $to); $cols = array(4, 60, 225, 300, 325, 385, 450, 515); - // $headers in doctext.inc + // $headers in doctext.inc $aligns = array('left', 'left', 'right', 'left', 'right', 'right', 'right'); - + $params = array('comments' => $comments, 'bankaccount' => $bankaccount); - + $baccount = get_bank_account($params['bankaccount']); $cur = get_company_Pref('curr_default'); - + if ($email == 0) { $rep = new FrontReport(_('INVOICE'), "InvoiceBulk.pdf", user_pagesize()); @@ -66,12 +67,16 @@ function print_invoices() { for ($j = 10; $j <= 11; $j++) { + if (isset($_POST['PARAM_7']) && $_POST['PARAM_7'] != $j) + continue; if (!exists_customer_trans($j, $i)) continue; + $sign = $j==10 ? 1 : -1; $myrow = get_customer_trans($i, $j); $branch = get_branch($myrow["branch_code"]); + $branch['disable_branch'] = $paylink; // helper if ($j == 10) - $sales_order = get_sales_order($myrow["order_"]); + $sales_order = get_sales_order_header($myrow["order_"]); else $sales_order = null; if ($email == 1) @@ -84,29 +89,30 @@ function print_invoices() $rep->title = _('INVOICE'); $rep->filename = "Invoice" . $myrow['reference'] . ".pdf"; } - else + else { $rep->title = _('CREDIT NOTE'); $rep->filename = "CreditNote" . $myrow['reference'] . ".pdf"; - } + } $rep->Info($params, $cols, null, $aligns); } else $rep->title = ($j == 10) ? _('INVOICE') : _('CREDIT NOTE'); $rep->Header2($myrow, $branch, $sales_order, $baccount, $j); - + $result = get_customer_trans_details($j, $i); $SubTotal = 0; while ($myrow2=db_fetch($result)) { - $Net = ((1 - $myrow2["discount_percent"]) * $myrow2["FullUnitPrice"] * -$myrow2["quantity"]); + $Net = round($sign * ((1 - $myrow2["discount_percent"]) * $myrow2["unit_price"] * $myrow2["quantity"]), + user_price_dec()); $SubTotal += $Net; - $DisplayPrice = number_format2($myrow2["FullUnitPrice"],$dec); - $DisplayQty = number_format2(-$myrow2["quantity"],user_qty_dec()); + $DisplayPrice = number_format2($myrow2["unit_price"],$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 + 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); @@ -116,33 +122,33 @@ function print_invoices() $rep->TextCol(5, 6, $DisplayDiscount, -2); $rep->TextCol(6, 7, $DisplayNet, -2); $rep->NewLine(1); - if ($rep->row < $rep->bottomMargin + (15 * $rep->lineHeight)) - $rep->Header2($myrow, $branch, $sales_order, $baccount); + if ($rep->row < $rep->bottomMargin + (15 * $rep->lineHeight)) + $rep->Header2($myrow, $branch, $sales_order, $baccount,$j); } - + $comments = get_comments($j, $i); if ($comments && db_num_rows($comments)) - { + { $rep->NewLine(); - while ($comment=db_fetch($comments)) + while ($comment=db_fetch($comments)) $rep->TextColLines(0, 6, $comment['memo_'], -2); - } - + } + $DisplaySubTot = number_format2($SubTotal,$dec); - $DisplayFreight = number_format2($myrow["ov_freight"],$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); $rep->TextCol(6, 7, $DisplaySubTot, -2); $rep->NewLine(); @@ -150,38 +156,40 @@ function print_invoices() $rep->TextCol(6, 7, $DisplayFreight, -2); $rep->NewLine(); $tax_items = get_customer_trans_tax_details($j, $i); - while ($tax_item = db_fetch($tax_items)) + while ($tax_item = db_fetch($tax_items)) { - $DisplayTax = number_format2($tax_item['amount'], $dec); + $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'] . + $rep->TextCol(3, 7, $doc_Included . " " . $tax_item['tax_type_name'] . " (" . $tax_item['rate'] . "%) " . $doc_Amount . ":" . $DisplayTax, -2); - } + } else { - $rep->TextCol(3, 6, $tax_item['tax_type_name'] . " (" . + $rep->TextCol(3, 6, $tax_item['tax_type_name'] . " (" . $tax_item['rate'] . "%)", -2); $rep->TextCol(6, 7, $DisplayTax, -2); - } + } $rep->NewLine(); } $rep->NewLine(); - $DisplayTotal = number_format2($myrow["ov_freight"] + $myrow["ov_gst"] + - $myrow["ov_amount"],$dec); - $rep->Font('bold'); + $DisplayTotal = number_format2($sign*($myrow["ov_freight"] + $myrow["ov_gst"] + + $myrow["ov_amount"]+$myrow["ov_freight_tax"]),$dec); + $rep->Font('bold'); $rep->TextCol(3, 6, $doc_TOTAL_INVOICE, - 2); - $rep->TextCol(6, 7, $DisplayTotal, -2); - $rep->Font(); + $rep->TextCol(6, 7, $DisplayTotal, -2); + $rep->Font(); if ($email == 1) { + $myrow['dimension_id'] = $paylink; // helper for pmt link if ($myrow['email'] == '') { $myrow['email'] = $branch['email']; $myrow['DebtorName'] = $branch['br_name']; } $rep->End($email, $doc_Invoice_no . " " . $myrow['reference'], $myrow, $j); - } + } } } if ($email == 0)