5 use Date::Format qw(time2str);
6 use File::Temp qw(tempdir);
7 use Net::SFTP::Foreign;
8 use FS::UID qw(adminsuidsetup dbh);
9 use FS::Record qw(qsearch qsearchs);
14 use vars qw( $opt_a $opt_v );
17 #$Net::SFTP::Foreign::debug = -1;
21 freeside-eftca-upload [ -v ] user batchnum
22 freeside-eftca-upload -a [ -v ] user\n
25 my $user = shift or die &HELP_MESSAGE;
28 my $log = FS::Log->new('freeside-eftca-upload');
29 log_info( "EFT Canada upload started\n" );
36 my %criteria= ( 'status' => 'O', 'payby' => 'CHEK' );
37 $criteria{'type'} = 'DEBIT' unless FS::pay_batch->can_handle_electronic_refunds('eft_canada');
40 @batches = qsearch('pay_batch', \%criteria)
42 log_error_and_die ("Fatal database error: $@")
45 log_info_and_die( "Finished: No open batches found.\n" )
50 die &HELP_MESSAGE if !$batchnum;
53 eval { @batches = qsearchs('pay_batch', { batchnum => $batchnum } ); };
54 log_error_and_die("Fatal database error: $@")
57 log_error_and_die( "Can't find payment batch '$batchnum'\n" ) if !@batches;
59 if ($batches[0]->type eq "CREDIT") {
60 warn "running credit\n";
61 log_error_and_die( "Batch number $batchnum is a credit (batch refund) batch, and this format can not handle batch refunds.\n" )
62 unless FS::pay_batch->can_handle_electronic_refunds('eft_canada');
66 my $conf = new FS::Conf;
68 my $tmpdir = tempdir( CLEANUP => 1 ); #DIR=>somewhere?
70 foreach my $pay_batch (@batches) {
72 my $batchnum = $pay_batch->batchnum;
73 my $filename = time2str('%Y%m%d', time) . '-' . sprintf('%06d.csv',$batchnum);
74 log_info( "Exporting batch $batchnum to $filename...\n" );
75 my $text = $pay_batch->export_batch(format => 'eft_canada');
77 log_info( "Batch is empty, resolving..." );
80 open OUT, ">$tmpdir/$filename";
84 my @batchconf = $conf->config('batchconfig-eft_canada', $pay_batch->agentnum);
85 my $user = $batchconf[0]
86 or log_error_and_die( "no EFT Canada batch username configured\n" );
87 my $pass = $batchconf[1]
88 or log_error_and_die( "no EFT Canada batch password configured\n" );
90 my $host = 'ftp.eftcanada.com';
91 log_info( "Connecting to $user\@$host...\n" );
93 my $sftp = Net::SFTP::Foreign->new( host => $host,
98 log_error_and_die("failed to connect to '$user\@$host'\n(".$sftp->error.")\n")
101 $sftp->put("$tmpdir/$filename", "$filename")
102 or log_error_and_die( "failed to upload file (".$sftp->error.")\n" );
104 undef $sftp; #$sftp->disconnect;
106 # Auto-approve and close the batch. Some false laziness with manual_approve.
107 my $batchnum = $pay_batch->batchnum;
112 foreach my $cpb ( qsearch('cust_pay_batch', { 'batchnum' => $batchnum } )) {
113 $cpb->setfield('paid', $cpb->amount);
114 $error = $cpb->approve($batchnum);
118 log_error_and_die("Fatal database error: $@")
121 $error ||= $pay_batch->set_status('R');
122 log_error_and_die( "error closing batch $batchnum: $error\n\n" )
126 log_info( "Finished!\n" );
129 my $log_message = shift;
130 $log->info( $log_message );
131 print STDERR $log_message if $opt_v;
134 sub log_info_and_die {
135 my $log_message = shift;
136 $log->info( $log_message );
140 sub log_error_and_die {
141 my $log_message = shift;
142 $log->error( $log_message );
148 freeside-eftca-upload - Transmit a payment batch to EFT Canada via SFTP.
152 freeside-eftca-upload [ -a ] [ -v ] user batchnum
156 Command line tool to upload a payment batch to the EFT Canada gateway. The
157 batch will be exported to a comma-delimited file and transmitted via SFTP.
158 Use L<freeside-eftca-download> to retrieve the response file.
160 -a: Send all open batches, instead of specifying a batchnum.
164 user: freeside username
166 batchnum: pay_batch primary key