X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Fpay_batch.cgi;h=6d571b42fdb5794f132c96bcbae4f90503f25159;hb=dc1891ff9a6e6c4b4545fe7f786af6bd0f28b2cf;hp=cb217179938b68f73066cf857009d29e079dd917;hpb=9509e5bfb7f9331303153cac24d7bfecbe2ea9f1;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' ];