Customer Transaction Inquiry on Reference (partly) fixed.
authorJoe <joe.hunt.consulting@gmail.com>
Sat, 21 Oct 2023 22:25:51 +0000 (00:25 +0200)
committerJoe <joe.hunt.consulting@gmail.com>
Sat, 21 Oct 2023 22:25:51 +0000 (00:25 +0200)
sales/inquiry/customer_inquiry.php

index 20bd88a70b3ac9d78a2b3a5220eba72dde8b72a1..3c1ffd9594dfba71c60e9d44234b7a0971a7f697 100644 (file)
@@ -157,6 +157,8 @@ if (!isset($_POST['customer_id']))
 start_table(TABLESTYLE_NOBORDER);
 start_row();
 
+ref_cells(_("Reference:"), 'Ref', '', NULL, _('Enter reference fragment or leave empty'));
+
 if (!$page_nested)
        customer_list_cells(_("Select a customer: "), 'customer_id', null, true, true, false, true);
 
@@ -192,7 +194,7 @@ if (get_post('RefreshInquiry') || list_updated('filterType'))
 }
 //------------------------------------------------------------------------------------------------
 $sql = get_sql_for_customer_inquiry(get_post('TransAfterDate'), get_post('TransToDate'),
-       get_post('customer_id'), get_post('filterType'), check_value('show_voided'));
+       get_post('customer_id'), get_post('filterType'), check_value('show_voided'), get_post('Ref'));
 
 //------------------------------------------------------------------------------------------------
 //db_query("set @bal:=0");