enable CardFortress in test database, #71513

[freeside.git] / httemplate / search / cust_main_credit_limit.html

diff --git a/httemplate/search/cust_main_credit_limit.html b/httemplate/search/cust_main_credit_limit.html
index b2a0c9b..902dbbc 100644 (file)
--- 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>