From 00aed756e1449f4d0847b1d05f96208d607b4711 Mon Sep 17 00:00:00 2001
From: jeff <jeff>
Date: Wed, 19 Dec 2007 21:05:37 +0000
Subject: add options for balance over/under to advanced customer report

---
 httemplate/search/cust_main.html | 15 ++++++++++++++-
 1 file changed, 14 insertions(+), 1 deletion(-)

(limited to 'httemplate/search/cust_main.html')

diff --git a/httemplate/search/cust_main.html b/httemplate/search/cust_main.html
index 1889b6c82..00fd1531a 100755
--- a/httemplate/search/cust_main.html
+++ b/httemplate/search/cust_main.html
@@ -68,6 +68,15 @@ foreach my $field (qw( signupdate )) {
 
 }
 
+##
+# amounts
+##
+
+my $balance_sql = FS::cust_main->balance_sql();
+
+push @where, map { s/current_balance/$balance_sql/; $_ }
+                 FS::UI::Web::parse_lt_gt($cgi, 'current_balance');
+
 ##
 # setup queries, subs, etc. for the search
 ##
@@ -83,7 +92,11 @@ my $addl_from = 'LEFT JOIN cust_pkg USING ( custnum  ) ';
 
 my $count_query = "SELECT COUNT(*) FROM cust_main $extra_sql";
 
-my $select = '*';
+my $select = join(', ', 
+               'cust_main.custnum',
+               FS::UI::Web::cust_sql_fields($cgi->param('cust_fields')),
+             );
+
 my (@extra_headers) = ();
 my (@extra_fields) = ();
 
-- 
cgit v1.2.1