X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Fpay_batch.cgi;h=6d571b42fdb5794f132c96bcbae4f90503f25159;hb=38458c0c9135228828b5a477ed1710ef687ec3d3;hp=cb217179938b68f73066cf857009d29e079dd917;hpb=5e05724a635a22776f1b973f5d7e77989da4e048;p=freeside.git diff --git a/httemplate/search/pay_batch.cgi b/httemplate/search/pay_batch.cgi index cb2171799..6d571b42f 100755 --- a/httemplate/search/pay_batch.cgi +++ b/httemplate/search/pay_batch.cgi @@ -3,7 +3,8 @@ 'name_singular' => 'batch', 'query' => { 'table' => 'pay_batch', 'hashref' => $hashref, - 'extra_sql' => "$extra_sql ORDER BY batchnum DESC", + 'extra_sql' => $extra_sql, + 'order_by' => 'ORDER BY batchnum DESC', }, 'count_query' => "$count_query $extra_sql", 'header' => [ 'Batch', @@ -97,12 +98,12 @@ my($begin, $end) = ( '', '' ); my @where; if ( $cgi->param('beginning') && $cgi->param('beginning') =~ /^([ 0-9\-\/]{0,10})$/ ) { - $begin = str2time($1); + $begin = parse_datetime($1); push @where, "download >= $begin"; } if ( $cgi->param('ending') && $cgi->param('ending') =~ /^([ 0-9\-\/]{0,10})$/ ) { - $end = str2time($1) + 86399; + $end = parse_datetime($1) + 86399; push @where, "download < $end"; } @@ -125,6 +126,6 @@ push @where, my $extra_sql = scalar(@where) ? 'WHERE ' . join(' AND ', @where) : ''; -my $link = [ "${p}search/cust_pay_batch.cgi?batchnum=", 'batchnum' ]; +my $link = [ "${p}search/cust_pay_batch.cgi?dcln=1;batchnum=", 'batchnum' ];