From: Ivan Kohler <ivan@freeside.biz>
Date: Mon, 17 Feb 2014 01:31:17 +0000 (-0800)
Subject: credit limit for CDR prerating, RT#27267
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=73ee20538afd112bfdf2a1fa39db58811e464172

credit limit for CDR prerating, RT#27267
---

diff --git a/httemplate/search/cust_main_credit_limit.html b/httemplate/search/cust_main_credit_limit.html
index b2a0c9bc4..902dbbc0a 100644
--- a/httemplate/search/cust_main_credit_limit.html
+++ b/httemplate/search/cust_main_credit_limit.html
@@ -1,11 +1,7 @@
 <& elements/search.html,
      'title'         => 'Credit limit incidents',
      'name_singular' => 'incident',
-     'query'         => { table     => 'cust_main_credit_limit',
-                          hashref   => \%hash,
-                          extra_sql => " AND $dates_sql ",
-                          order_by  => 'ORDER BY _date ASC',
-                        },
+     'query'         => $query,
      'count_query'   => "SELECT COUNT(*) FROM cust_main_credit_limit",
      'header'        => [ 'Date',
 
@@ -60,4 +56,11 @@ if ( $cgi->param('custnum') =~ /^(\d+)$/ ) {
   $count_query .= " AND custnum = $1";
 }
 
+my $query = {
+  table     => 'cust_main_credit_limit',
+  hashref   => \%hash,
+  extra_sql => ( keys(%hash) ? ' AND ' : ' WHERE ' ). $dates_sql,
+  order_by  => 'ORDER BY _date ASC',
+};
+
 </%init>