use Date::Format 'time2str';
use FS::Conf;
use Encode 'encode';
+use feature 'state';
my $conf;
my ($client_num, $shortname, $longname, $trans_code, $testmode, $i, $declined, $totaloffset);
'filetype' => 'fixed',
#this only really applies to Debit Detail, but we otherwise only need first char
'formatre' =>
- '^(.).{18}(.{4}).{3}(.).{11}(.{19}).{6}(.{30}).{17}(.{9})(.{18}).{6}(.{14}).{23}(.).{9}\r?$',
+ '^(.).{3}(.{10}).{5}(.{4}).{3}(.).{11}(.{19}).{6}(.{30}).{17}(.{9})(.{18}).{6}(.{14}).{23}(.).{9}\r?$',
'fields' => [ qw(
recordtype
+ clientnum
batchnum
subtype
paybatchnum
status
) ],
'hook' => sub {
- my $hash = shift;
- $hash->{'paid'} = sprintf("%.2f", $hash->{'paid'} / 100 );
- $hash->{'_date'} = time;
- $hash->{'payinfo'} =~ s/^(\S+).*/$1/; # these often have trailing spaces
- $hash->{'payinfo'} = $hash->{'payinfo'} . '@' . $hash->{'bank'};
+ # pull client_num from config and check it against what's in the batch
+ state $clientnum ||= do {
+ my $conf = FS::Conf->new;
+ my @config = $conf->config("batchconfig-RBC");
+ $config[0];
+ };
+
+ my $hash = shift;
+ $hash->{'paid'} = sprintf("%.2f", $hash->{'paid'} / 100 );
+ $hash->{'_date'} = time;
+ $hash->{'payinfo'} =~ s/^(\S+).*/$1/; # these often have trailing spaces
+ $hash->{'payinfo'} = $hash->{'payinfo'} . '@' . $hash->{'bank'};
+
+ if ( $clientnum and $hash->{clientnum} ne $clientnum ) {
+ die "RBC client number in batch (".$hash->{clientnum}.") does not ".
+ "match configuration.\n";
+ }
+ '';
},
'approved' => sub {
my $hash = shift;
- $hash->{'status'} eq ' '
+ ($hash->{'status'} eq ' ') || ($hash->{'status'} eq 'W');
},
'declined' => sub {
my $hash = shift;
my( $hash, $total, $line ) = @_;
return "Can't process Credit Detail Record, aborting import"
if ($hash->{'recordtype'} eq '2');
- $totaloffset = sprintf("%.2f", $totaloffset / 100 );
$total += $totaloffset;
$total = sprintf("%.2f", $total);
# We assume here that this is an 'All Records' or 'Input Records' report.
#we already declined it this run, no takebacks
if ($declined->{$hash->{'paybatchnum'}}) {
#file counts this as part of total, but we skip
- $totaloffset += $hash->{'paid'}
+ $totaloffset += sprintf("%.2f", $hash->{'paid'} / 100 )
if $hash->{'status'} eq ' '; #false laziness with 'approved' above
return 1;
}
}
$i++;
+
+ ## set to D for debit by default, then override to what cust_pay_batch has as payments may not have paycode.
+ my $debitorcredit = 'D';
+ $debitorcredit = $cust_pay_batch->paycode unless !$cust_pay_batch->paycode;
+
sprintf("%06u", $i).
- 'D'.
+ $debitorcredit.
sprintf("%3s",$trans_code).
sprintf("%10s",$client_num).
' '.
' '.
sprintf("%010.0f",$cust_pay_batch->amount*100).
' '.
- time2str("%Y%j", $pay_batch->download).
+ time2str("%Y%j", time + 86400).
sprintf("%-30.30s", encode('utf8', $cust_pay_batch->cust_main->first . ' ' .
$cust_pay_batch->cust_main->last)).
'E'. # English