improve performance of DID provisioning status report, RT10988

[freeside.git] / httemplate / misc / batch-cust_pay.html

diff --git a/httemplate/misc/batch-cust_pay.html b/httemplate/misc/batch-cust_pay.html
index 610f6e1..20ea92f 100644 (file)
--- a/httemplate/misc/batch-cust_pay.html
+++ b/httemplate/misc/batch-cust_pay.html
@@ -96,18 +96,21 @@ function select_discount_term(row, prefix) {
 die "access denied"
   unless $FS::CurrentUser::CurrentUser->access_right('Post payment batch');
 
+my $conf = new FS::Conf;
+my $money_char = $conf->config('money_char') || '$';
+
 my @header  = ( '', 'Amount', 'Check #' );
-my @fields  = ( sub {'$'}, 'paid', 'payinfo' );
+my @fields  = ( sub { "$money_char" }, 'paid', 'payinfo' );
 my @types   = ( 'immutable', '', '' );
 my @align   = ( 'c', 'r', 'r' );
 my @sizes   = ( 0, 8, 10 );
 my @colors  = ( '', '', '' );
 my %param   = ();
-my @footer  = ( '$', '_TOTAL', '' );
+my @footer  = ( "$money_char", '_TOTAL', '' );
 my @footer_align = ( 'c', 'r', 'r' );
 my $custnum_update_callback = '';
 
-if ( FS::Record->scalar_sql('SELECT count(*) FROM part_pkg_discount') ) {
+if ( FS::Record->scalar_sql('SELECT COUNT(*) FROM part_pkg_discount') ) {
   push @header, '';
   push @fields, 'discount_term';
   push @types, 'immutable';
@@ -128,4 +131,6 @@ push @colors, '#ff0000';
 push @footer, '';
 push @footer_align, '';
 
+$m->comp('/elements/handle_uri_query');
+
 </%init>