X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Fcust_pay_batch.cgi;h=8022d46668100eb5857ea522cd785f392c972602;hb=073169e80bea0560b64e468a76121bf837de34f3;hp=fec3dfdeb4559c6440f86ede5cff4872c013e6b5;hpb=590603ecaea3184f64530755a76626be8205da49;p=freeside.git diff --git a/httemplate/search/cust_pay_batch.cgi b/httemplate/search/cust_pay_batch.cgi index fec3dfdeb..8022d4666 100755 --- a/httemplate/search/cust_pay_batch.cgi +++ b/httemplate/search/cust_pay_batch.cgi @@ -1,10 +1,12 @@ <% include('elements/search.html', 'title' => 'Batch payment details', 'name' => 'batch details', - 'menubar' => ['Main Menu' => $p,], 'query' => $sql_query, 'count_query' => $count_query, - 'html_init' => $pay_batch ? $html_init : '', + 'html_init' => $pay_batch ? + include('elements/cust_pay_batch_top.html', + 'pay_batch' => $pay_batch + ) : '', 'header' => [ '#', 'Inv #', 'Customer', @@ -58,9 +60,16 @@ %> <%init> +my $conf = new FS::Conf; + die "access denied" unless $FS::CurrentUser::CurrentUser->access_right('Financial reports') - || $FS::CurrentUser::CurrentUser->access_right('Process batches'); + || $FS::CurrentUser::CurrentUser->access_right('Process batches') + || ( $cgi->param('custnum') + && ( $conf->exists('batch-enable') + || $conf->config('batch-enable_payby') + ) + ); my( $count_query, $sql_query ); my $hashref = {}; @@ -75,6 +84,14 @@ if ( $cgi->param('batchnum') && $cgi->param('batchnum') =~ /^(\d+)$/ ) { $batchnum = $pay_batch->batchnum; } +if ( $cgi->param('custnum') && $cgi->param('custnum') =~ /^(\d+)$/ ) { + push @search, "custnum = $1"; +} + +if ( $cgi->param('status') && $cgi->param('status') =~ /^(\w)$/ ) { + push @search, "pay_batch.status = '$1'"; +} + if ( $cgi->param('payby') ) { $cgi->param('payby') =~ /^(CARD|CHEK)$/ or die "illegal payby " . $cgi->param('payby'); @@ -111,67 +128,7 @@ $sql_query = "SELECT paybatchnum,invnum,custnum,cpb.last,cpb.first," . my $html_init = ''; if ( $pay_batch ) { - my $conf = new FS::Conf; - my $fixed = $conf->config('batch-fixed_format-'. $pay_batch->payby); - if ( - $pay_batch->status eq 'O' - || ( $pay_batch->status eq 'I' - && $FS::CurrentUser::CurrentUser->access_right('Reprocess batches') - ) - ) { - $html_init .= qq!
!; - if ( $fixed ) { - $html_init .= qq!!; - } else { - $html_init .= qq!Download batch in format !; - } - $html_init .= qq!

!; - } - - if ( - $pay_batch->status eq 'I' - || ( $pay_batch->status eq 'R' - && $FS::CurrentUser::CurrentUser->access_right('Reprocess batches') - ) - ) { - $html_init .= qq!
!. - qq!Upload results
!. - qq!Filename
!; - if ( $fixed ) { - $html_init .= qq!!; - } else { - $html_init .= qq!Format
!; - } - $html_init .= qq!!; - $html_init .= '

'; - } - -} - -if ($pay_batch) { - my $sth = dbh->prepare($count_query) or die dbh->errstr. "doing $count_query"; - $sth->execute or die "Error executing \"$count_query\": ". $sth->errstr; - my $cards = $sth->fetchrow_arrayref->[0]; - - my $st = "SELECT SUM(amount) from cust_pay_batch WHERE batchnum=". $batchnum; - $sth = dbh->prepare($st) or die dbh->errstr. "doing $st"; - $sth->execute or die "Error executing \"$st\": ". $sth->errstr; - my $total = $sth->fetchrow_arrayref->[0]; - - $html_init .= "$cards credit card payments batched
\$" . - sprintf("%.2f", $total) ." total in batch
"; + $html_init = include('elements/cust_pay_batch_top.html', + 'pay_batch' => $pay_batch); } -