%= header("Pending credit card batch", menubar( 'Main Menu' => $p,)) %>
<%= &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 %> | 
<% } %>