From 5852be60417090454ef25acbce374567c36e0d92 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Thu, 7 Jan 2010 23:34:15 +0000 Subject: [PATCH] Rerun of Remittance --- purchasing/inquiry/supplier_inquiry.php | 4 ++-- purchasing/supplier_payment.php | 4 ++-- reporting/includes/doctext.inc | 2 +- reporting/includes/doctext2.inc | 2 +- reporting/includes/reporting.inc | 1 - reporting/includes/reports_classes.inc | 5 +++-- reporting/rep210.php | 8 +++++++- 7 files changed, 16 insertions(+), 10 deletions(-) diff --git a/purchasing/inquiry/supplier_inquiry.php b/purchasing/inquiry/supplier_inquiry.php index 0b23bd6..613db1e 100644 --- a/purchasing/inquiry/supplier_inquiry.php +++ b/purchasing/inquiry/supplier_inquiry.php @@ -147,8 +147,8 @@ function fmt_credit($row) function prt_link($row) { - if ($row['type'] == ST_SUPPAYMENT || $row['type'] == ST_BANKPAYMENT) - return print_document_link($row['trans_no'], _("Print Remittance"), true, $row['type'], ICON_PRINT); + if ($row['type'] == ST_SUPPAYMENT || $row['type'] == ST_BANKPAYMENT || $row['type'] == ST_SUPPCREDIT) + return print_document_link($row['trans_no']."-".$row['type'], _("Print Remittance"), true, ST_SUPPAYMENT, ICON_PRINT); } function check_overdue($row) diff --git a/purchasing/supplier_payment.php b/purchasing/supplier_payment.php index cb94548..0c8aa7d 100644 --- a/purchasing/supplier_payment.php +++ b/purchasing/supplier_payment.php @@ -70,8 +70,8 @@ if (isset($_GET['AddedID'])) display_notification_centered( _("Payment has been sucessfully entered")); - submenu_print(_("&Print This Remittance"), ST_SUPPAYMENT, $payment_id, 'prtopt'); - submenu_print(_("&Email This Remittance"), ST_SUPPAYMENT, $payment_id, null, 1); + submenu_print(_("&Print This Remittance"), ST_SUPPAYMENT, $payment_id."-".ST_SUPPAYMENT, 'prtopt'); + submenu_print(_("&Email This Remittance"), ST_SUPPAYMENT, $payment_id."-".ST_SUPPAYMENT, null, 1); display_note(get_gl_view_str(22, $payment_id, _("View the GL &Journal Entries for this Payment"))); diff --git a/reporting/includes/doctext.inc b/reporting/includes/doctext.inc index b2bcea2..955626b 100644 --- a/reporting/includes/doctext.inc +++ b/reporting/includes/doctext.inc @@ -115,7 +115,7 @@ if (isset($emailtype)) if (isset($header2type) || isset($linetype)) { $doc_Invoice_no = ($doctype==ST_CUSTDELIVERY ? _("Delivery Note No.") : - ($doctype == ST_SUPPAYMENT ? _("Payment No.") : + ($doctype == ST_SUPPAYMENT ? _("Remittance No.") : (($doctype==ST_SALESQUOTE || $doctype==ST_PURCHORDER || $doctype==ST_SALESORDER) ? _("Order no.") : ($doctype==ST_SALESINVOICE ? _("Invoice No.") : ($doctype==ST_WORKORDER ? _("Word Order No") : _("Credit No.")))))); $doc_Delivery_no = _("Delivery Note No."); diff --git a/reporting/includes/doctext2.inc b/reporting/includes/doctext2.inc index 0f53367..4899e46 100644 --- a/reporting/includes/doctext2.inc +++ b/reporting/includes/doctext2.inc @@ -114,7 +114,7 @@ if (isset($emailtype)) if (isset($header2type) || isset($linetype)) { $doc_Invoice_no = ($doctype==ST_CUSTDELIVERY ? "Delivery Note No." : - ($doctype == ST_SUPPAYMENT ? "Payment No." : + ($doctype == ST_SUPPAYMENT ? "Remittance No." : (($doctype == ST_SALESQUOTE || $doctype==ST_PURCHORDER || $doctype==ST_SALESORDER) ? "Order no." : ($doctype==ST_SALESINVOICE ? "Invoice No." : ($doctype == ST_WORKORDER ? "Work Order No" : "Credit No."))))); $doc_Delivery_no = "Delivery Note No."; diff --git a/reporting/includes/reporting.inc b/reporting/includes/reporting.inc index 0650c98..4ce4d14 100644 --- a/reporting/includes/reporting.inc +++ b/reporting/includes/reporting.inc @@ -78,7 +78,6 @@ function print_document_link($doc_no, $link_text, $link=true, $type_no, 'PARAM_4' => ''); break; case ST_SUPPAYMENT : - case ST_BANKPAYMENT : $rep = 210; // from, to, currency, bank acc, email, comments $ar = array( diff --git a/reporting/includes/reports_classes.inc b/reporting/includes/reports_classes.inc index 1aff546..cde5447 100644 --- a/reporting/includes/reports_classes.inc +++ b/reporting/includes/reports_classes.inc @@ -328,10 +328,11 @@ class BoxReports case 'REMITTANCE': $BP = _("BP"); $SP = _("SP"); + $CN = _("CN"); $ref = ($print_invoice_no == 1 ? "trans_no" : "reference"); $sql = "SELECT concat(".TB_PREF."supp_trans.trans_no, '-', - ".TB_PREF."supp_trans.type) AS TNO, concat(".TB_PREF."supp_trans.$ref, if (type=".ST_BANKPAYMENT.", ' $BP ', ' $SP '), ".TB_PREF."suppliers.supp_name) as IName - FROM ".TB_PREF."suppliers, ".TB_PREF."supp_trans WHERE (type=".ST_BANKPAYMENT." OR type=".ST_SUPPAYMENT.") AND ".TB_PREF."suppliers.supplier_id=".TB_PREF."supp_trans.supplier_id ORDER BY ".TB_PREF."supp_trans.trans_no DESC"; + ".TB_PREF."supp_trans.type) AS TNO, concat(".TB_PREF."supp_trans.$ref, if (type=".ST_BANKPAYMENT.", ' $BP ', if (type=".ST_SUPPAYMENT.", ' $SP ', ' $CN ')), ".TB_PREF."suppliers.supp_name) as IName + FROM ".TB_PREF."suppliers, ".TB_PREF."supp_trans WHERE (type=".ST_BANKPAYMENT." OR type=".ST_SUPPAYMENT." OR type=".ST_SUPPCREDIT.") AND ".TB_PREF."suppliers.supplier_id=".TB_PREF."supp_trans.supplier_id ORDER BY ".TB_PREF."supp_trans.trans_no DESC"; return combo_input($name, '', $sql, 'TNO', 'IName',array('order'=>false)); case 'ITEMS': diff --git a/reporting/rep210.php b/reporting/rep210.php index 1a99195..f25b792 100644 --- a/reporting/rep210.php +++ b/reporting/rep210.php @@ -98,7 +98,13 @@ function print_remittances() for ($i = $fno[0]; $i <= $tno[0]; $i++) { - for ($j = ST_BANKPAYMENT; $j <= ST_SUPPAYMENT; $j = ($j == ST_BANKPAYMENT ? ST_SUPPAYMENT : 999)) + if ($fno[0] == $tno[0]) + $types = array($fno[1]); + else + $types = array(ST_BANKPAYMENT, ST_SUPPAYMENT, ST_SUPPCREDIT); + foreach ($types as $j) + //for ($j = ST_BANKPAYMENT; $j <= ST_SUPPAYMENT; $j = ($j == ST_BANKPAYMENT ? ST_SUPPAYMENT : 999)) + //for ($j = $ft; $j <= $tt; $j = ($j == ST_BANKPAYMENT ? ST_SUPPAYMENT : 999)) { $myrow = get_remittance($j, $i); if (!$myrow) -- 2.30.2