From 66f3e64a797432504fc66cbf6fe712e4576fdbeb Mon Sep 17 00:00:00 2001 From: ivan Date: Fri, 29 Dec 2006 08:29:21 +0000 Subject: [PATCH] this is unused, replaced by search/pay_batch.cgi --- httemplate/browse/pay_batch.cgi | 54 ----------------------------------------- 1 file changed, 54 deletions(-) delete mode 100755 httemplate/browse/pay_batch.cgi diff --git a/httemplate/browse/pay_batch.cgi b/httemplate/browse/pay_batch.cgi deleted file mode 100755 index 66c86d676..000000000 --- a/httemplate/browse/pay_batch.cgi +++ /dev/null @@ -1,54 +0,0 @@ - -<%= include("/elements/header.html","Credit card batches", menubar( 'Main Menu' => $p,)) %> - -

- -<% - my %statusmap = ('I'=>'In Transit', 'O'=>'Open', 'R'=>'Resolved'); -%> - -
-<%= &table() %> - - Batch - First Download - Last Upload - Item Count - Amount - Status - - -<% -foreach my $pay_batch ( sort { $b->batchnum <=> $a->batchnum } - qsearch('pay_batch', {} ) -) { - - my $statement = "SELECT SUM(amount) from cust_pay_batch WHERE batchnum=" . - $pay_batch->batchnum; - 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 WHERE batchnum=" . - $pay_batch->batchnum; - 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]; - -%> - - - <%= $pay_batch->batchnum %> - <%= $pay_batch->download ? time2str("%a %b %e %T %Y", $pay_batch->download) : '' %> - <%= $pay_batch->upload ? time2str("%a %b %e %T %Y", $pay_batch->upload) : '' %> - <%= $cards %> - <%= $total %> - <%= $statusmap{$pay_batch->status} %> - - -<% } %> - - - - -- 2.11.0