credit limit for CDR prerating, RT#27267

1 files changed, 8 insertions, 5 deletions

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>