<%= header("Pending credit card batch", menubar( 'Main Menu' => $p,)) %>
Download batch in format


Upload results
Filename
Format

<% my $statement = "SELECT SUM(amount) from cust_pay_batch"; my $sth = dbh->prepare($statement) or die dbh->errstr. "doing $statement"; $sth->execute or die "Error executing \"$statement\": ". $sth->errstr; my $total = $sth->fetchrow_arrayref->[0]; my $c_statement = "SELECT COUNT(*) from cust_pay_batch"; my $c_sth = dbh->prepare($c_statement) or die dbh->errstr. "doing $c_statement"; $c_sth->execute or die "Error executing \"$c_statement\": ". $c_sth->errstr; my $cards = $c_sth->fetchrow_arrayref->[0]; %> <%= $cards %> credit card payments batched
$<%= sprintf("%.2f", $total) %> total in pending batch

<%= &table() %> # inv# Customer Card name Card Exp Amount <% foreach my $cust_pay_batch ( sort { $a->paybatchnum <=> $b->paybatchnum } qsearch('cust_pay_batch', {} ) ) { my $cardnum = $cust_pay_batch->cardnum; #$cardnum =~ s/.{4}$/xxxx/; $cardnum = 'x'x(length($cardnum)-4). substr($cardnum,(length($cardnum)-4)); $cust_pay_batch->exp =~ /^\d{2}(\d{2})[\/\-](\d+)[\/\-]\d+$/; my( $mon, $year ) = ( $2, $1 ); $mon = "0$mon" if $mon < 10; my $exp = "$mon/$year"; %> <%= $cust_pay_batch->paybatchnum %> <%= $cust_pay_batch->invnum %> <%= $cust_pay_batch->custnum %> <%= $cust_pay_batch->get('last'). ', '. $cust_pay_batch->first %> <%= $cust_pay_batch->payname %> <%= $cardnum %> <%= $exp %> $<%= $cust_pay_batch->amount %> <% } %>