sort by customer number on line item detail report, RT#26025
authorIvan Kohler <ivan@freeside.biz>
Mon, 18 Nov 2013 06:54:52 +0000 (22:54 -0800)
committerIvan Kohler <ivan@freeside.biz>
Mon, 18 Nov 2013 06:54:52 +0000 (22:54 -0800)
FS/FS/UI/Web.pm
httemplate/search/cust_bill_pkg.cgi

index d7f998b..e31ff14 100644 (file)
@@ -323,6 +323,14 @@ sub cust_header {
   @cust_header;
 }
 
+sub cust_sort_fields {
+  cust_header(@_);
+  #inefficientish, but tiny lists and only run once per page
+
+  map { $_ eq 'custnum' ? 'custnum' : '' } @cust_fields;
+
+}
+
 =item cust_sql_fields [ CUST_FIELDS_VALUE ]
 
 Returns a list of fields for the SELECT portion of an SQL query.
index d86641d..f87862a 100644 (file)
@@ -49,8 +49,9 @@
                    @currency,
                    'invnum',
                    '_date',
-                   #'pay_amount',
-                   #'credit_amount',
+                   '', #'pay_amount',
+                   '', #'credit_amount',
+                   FS::UI::Web::cust_sort_fields(),
                  ],
                  'links'       => [
                    @pkgnum_null,