blob: c59ba9d370c35bd7c1ef2c3938894f613e3001eb (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
<% $pay_batch->export_batch(%opt) %><%init>
#http_header('Content-Type' => 'text/comma-separated-values' ); #IE chokes
http_header('Content-Type' => 'text/plain' ); # not necessarily correct...
my $batchnum;
if ( $cgi->param('batchnum') =~ /^(\d+)$/ ) {
$batchnum = $1;
} else {
die "No batch number (bad URL) \n";
}
my %opt;
if ( $cgi->param('gatewaynum') =~ /^(\d+)$/ ) {
my $gateway = FS::payment_gateway->by_key($1);
die "gatewaynum $1 not found" unless $gateway;
$opt{'gateway'} = $gateway;
}
elsif ( $cgi->param('format') =~ /^([\w\- ]+)$/ ) {
$opt{'format'} = $1;
}
my $credit_transactions = "EXISTS (SELECT 1 FROM cust_pay_batch WHERE batchnum = $batchnum AND paycode = 'C') AS arecredits";
my $pay_batch = qsearchs({ 'select' => "*, $credit_transactions",
'table' => 'pay_batch',
'hashref' => { batchnum => $batchnum },
});
die "Batch not found: '$batchnum'" if !$pay_batch;
</%init>
|
