1 package FS::cust_main::Billing_Realtime;
4 use vars qw( $conf $DEBUG $me );
5 use vars qw( $realtime_bop_decline_quiet ); #ugh
8 use Business::CreditCard 0.35;
9 use FS::UID qw( dbh myconnect );
10 use FS::Record qw( qsearch qsearchs );
13 use FS::cust_pay_pending;
14 use FS::cust_bill_pay;
17 use FS::payment_gateway;
19 $realtime_bop_decline_quiet = 0;
21 # 1 is mostly method/subroutine entry and options
22 # 2 traces progress of some operations
23 # 3 is even more information including possibly sensitive data
25 $me = '[FS::cust_main::Billing_Realtime]';
28 our $BOP_TESTING_SUCCESS = 1;
30 install_callback FS::UID sub {
32 #yes, need it for stuff below (prolly should be cached)
37 FS::cust_main::Billing_Realtime - Realtime billing mixin for cust_main
43 These methods are available on FS::cust_main objects.
49 =item realtime_cust_payby
53 sub realtime_cust_payby {
54 my( $self, %options ) = @_;
56 local($DEBUG) = $FS::cust_main::DEBUG if $FS::cust_main::DEBUG > $DEBUG;
58 $options{amount} = $self->balance unless exists( $options{amount} );
60 my @cust_payby = $self->cust_payby('CARD','CHEK');
63 foreach my $cust_payby (@cust_payby) {
64 $error = $cust_payby->realtime_bop( %options, );
68 #XXX what about the earlier errors?
74 =item realtime_collect [ OPTION => VALUE ... ]
76 Attempt to collect the customer's current balance with a realtime credit
77 card or electronic check transaction (see realtime_bop() below).
79 Returns the result of realtime_bop(): nothing, an error message, or a
80 hashref of state information for a third-party transaction.
82 Available options are: I<method>, I<amount>, I<description>, I<invnum>, I<quiet>, I<paynum_ref>, I<payunique>, I<session_id>, I<pkgnum>
84 I<method> is one of: I<CC> or I<ECHECK>. If none is specified
85 then it is deduced from the customer record.
87 If no I<amount> is specified, then the customer balance is used.
89 The additional options I<payname>, I<address1>, I<address2>, I<city>, I<state>,
90 I<zip>, I<payinfo> and I<paydate> are also available. Any of these options,
91 if set, will override the value from the customer record.
93 I<description> is a free-text field passed to the gateway. It defaults to
94 the value defined by the business-onlinepayment-description configuration
95 option, or "Internet services" if that is unset.
97 If an I<invnum> is specified, this payment (if successful) is applied to the
100 I<apply> will automatically apply a resulting payment.
102 I<quiet> can be set true to suppress email decline notices.
104 I<paynum_ref> can be set to a scalar reference. It will be filled in with the
105 resulting paynum, if any.
107 I<payunique> is a unique identifier for this payment.
109 I<session_id> is a session identifier associated with this payment.
111 I<depend_jobnum> allows payment capture to unlock export jobs
115 # Currently only used by ClientAPI
116 sub realtime_collect {
117 my( $self, %options ) = @_;
119 local($DEBUG) = $FS::cust_main::DEBUG if $FS::cust_main::DEBUG > $DEBUG;
122 warn "$me realtime_collect:\n";
123 warn " $_ => $options{$_}\n" foreach keys %options;
126 $options{amount} = $self->balance unless exists( $options{amount} );
127 return '' unless $options{amount} > 0;
129 return $self->realtime_bop({%options});
133 =item realtime_bop { [ ARG => VALUE ... ] }
135 Runs a realtime credit card or ACH (electronic check) transaction
136 via a Business::OnlinePayment realtime gateway. See
137 L<http://420.am/business-onlinepayment> for supported gateways.
139 Required arguments in the hashref are I<amount> and either
140 I<cust_payby> or I<method>, I<payinfo> and (as applicable for method)
141 I<payname>, I<address1>, I<address2>, I<city>, I<state>, I<zip> and I<paydate>.
143 Available methods are: I<CC>, I<ECHECK>, or I<PAYPAL>
145 Available optional arguments are: I<description>, I<invnum>, I<apply>, I<quiet>, I<paynum_ref>, I<payunique>, I<session_id>
147 I<description> is a free-text field passed to the gateway. It defaults to
148 the value defined by the business-onlinepayment-description configuration
149 option, or "Internet services" if that is unset.
151 If an I<invnum> is specified, this payment (if successful) is applied to the
152 specified invoice. If the customer has exactly one open invoice, that
153 invoice number will be assumed. If you don't specify an I<invnum> you might
154 want to call the B<apply_payments> method or set the I<apply> option.
156 I<no_invnum> can be set to true to prevent that default invnum from being set.
158 I<apply> can be set to true to run B<apply_payments_and_credits> on success.
160 I<no_auto_apply> can be set to true to set that flag on the resulting payment
161 (prevents payment from being applied by B<apply_payments> or B<apply_payments_and_credits>,
162 but will still be applied if I<invnum> exists...use with I<no_invnum> for intended effect.)
164 I<quiet> can be set true to surpress email decline notices.
166 I<paynum_ref> can be set to a scalar reference. It will be filled in with the
167 resulting paynum, if any.
169 I<payunique> is a unique identifier for this payment.
171 I<session_id> is a session identifier associated with this payment.
173 I<depend_jobnum> allows payment capture to unlock export jobs
175 I<discount_term> attempts to take a discount by prepaying for discount_term.
176 The payment will fail if I<amount> is incorrect for this discount term.
178 A direct (Business::OnlinePayment) transaction will return nothing on success,
179 or an error message on failure.
181 A third-party transaction will return a hashref containing:
183 - popup_url: the URL to which a browser should be redirected to complete
185 - collectitems: an arrayref of name-value pairs to be posted to popup_url.
186 - reference: a reference ID for the transaction, to show the customer.
188 (moved from cust_bill) (probably should get realtime_{card,ach,lec} here too)
192 # some helper routines
194 # _bop_recurring_billing: Checks whether this payment should have the
195 # recurring_billing flag used by some B:OP interfaces (IPPay, PlugnPay,
196 # vSecure, etc.). This works in two different modes:
197 # - actual_oncard (default): treat the payment as recurring if the customer
198 # has made a payment using this card before.
199 # - transaction_is_recur: treat the payment as recurring if the invoice
200 # being paid has any recurring package charges.
202 sub _bop_recurring_billing {
203 my( $self, %opt ) = @_;
205 my $method = scalar($conf->config('credit_card-recurring_billing_flag'));
207 if ( defined($method) && $method eq 'transaction_is_recur' ) {
209 return 1 if $opt{'trans_is_recur'};
213 # return 1 if the payinfo has been used for another payment
214 return $self->payinfo_used($opt{'payinfo'}); # in payinfo_Mixin
222 #can run safely as class method if opt payment_gateway already exists
223 sub _payment_gateway {
224 my ($self, $options) = @_;
226 if ( $options->{'fake_gatewaynum'} ) {
227 $options->{payment_gateway} =
228 qsearchs('payment_gateway',
229 { 'gatewaynum' => $options->{'fake_gatewaynum'}, }
233 $options->{payment_gateway} = $self->agent->payment_gateway( %$options )
234 unless exists($options->{payment_gateway});
236 $options->{payment_gateway};
244 'login' => $options->{payment_gateway}->gateway_username,
245 'password' => $options->{payment_gateway}->gateway_password,
253 $options->{payment_gateway}->gatewaynum
254 ? $options->{payment_gateway}->options
255 : @{ $options->{payment_gateway}->get('options') };
260 my ($self, $options) = @_;
262 unless ( $options->{'description'} ) {
263 if ( $conf->exists('business-onlinepayment-description') ) {
264 my $dtempl = $conf->config('business-onlinepayment-description');
266 my $agent = $self->agent->agent;
268 $options->{'description'} = eval qq("$dtempl");
270 $options->{'description'} = 'Internet services';
274 # Default invoice number if the customer has exactly one open invoice.
275 unless ( $options->{'invnum'} || $options->{'no_invnum'} ) {
276 $options->{'invnum'} = '';
277 my @open = $self->open_cust_bill;
278 $options->{'invnum'} = $open[0]->invnum if scalar(@open) == 1;
284 sub _bop_cust_payby_options {
286 my $cust_payby = $options->{'cust_payby'};
289 $options->{'method'} = FS::payby->payby2bop( $cust_payby->payby );
291 if ($cust_payby->payby =~ /^(CARD|DCRD)$/) {
292 # false laziness with cust_payby->check
293 # which might not have been run yet
295 if ( $cust_payby->paydate =~ /^(\d{1,2})[\/\-](\d{2}(\d{2})?)$/ ) {
296 ( $m, $y ) = ( $1, length($2) == 4 ? $2 : "20$2" );
297 } elsif ( $cust_payby->paydate =~ /^19(\d{2})[\/\-](\d{1,2})[\/\-]\d+$/ ) {
298 ( $m, $y ) = ( $2, "19$1" );
299 } elsif ( $cust_payby->paydate =~ /^(20)?(\d{2})[\/\-](\d{1,2})[\/\-]\d+$/ ) {
300 ( $m, $y ) = ( $3, "20$2" );
302 return "Illegal expiration date: ". $cust_payby->paydate;
304 $m = sprintf('%02d',$m);
305 $options->{paydate} = "$y-$m-01";
307 $options->{paydate} = '';
310 $options->{$_} = $cust_payby->$_()
311 for qw( payinfo paycvv paymask paystart_month paystart_year
312 payissue payname paystate paytype payip );
314 if ( $cust_payby->locationnum ) {
315 my $cust_location = $cust_payby->cust_location;
316 $options->{$_} = $cust_location->$_() for qw( address1 address2 city state zip );
321 # can be called as class method,
322 # but can't load default name/phone fields as class method
324 my ($self, $options) = @_;
327 my $payip = $options->{'payip'};
328 $content{customer_ip} = $payip if length($payip);
330 $content{invoice_number} = $options->{'invnum'}
331 if exists($options->{'invnum'}) && length($options->{'invnum'});
333 $content{email_customer} =
334 ( $conf->exists('business-onlinepayment-email_customer')
335 || $conf->exists('business-onlinepayment-email-override') );
337 my ($payname, $payfirst, $paylast);
338 if ( $options->{payname} && $options->{method} ne 'ECHECK' ) {
339 ($payname = $options->{payname}) =~
340 /^\s*([\w \,\.\-\']*)?\s+([\w\,\.\-\']+)\s*$/
341 or return "Illegal payname $payname";
342 ($payfirst, $paylast) = ($1, $2);
343 } elsif (ref($self)) { # can't set payname if called as class method
344 $payfirst = $self->getfield('first');
345 $paylast = $self->getfield('last');
346 $payname = "$payfirst $paylast";
349 $content{last_name} = $paylast if $paylast;
350 $content{first_name} = $payfirst if $payfirst;
352 $content{name} = $payname if $payname;
354 $content{address} = $options->{'address1'};
355 my $address2 = $options->{'address2'};
356 $content{address} .= ", ". $address2 if length($address2);
358 $content{city} = $options->{'city'};
359 $content{state} = $options->{'state'};
360 $content{zip} = $options->{'zip'};
361 $content{country} = $options->{'country'};
363 # can't set phone if called as class method
364 $content{phone} = $self->daytime || $self->night
367 my $currency = $conf->exists('business-onlinepayment-currency')
368 && $conf->config('business-onlinepayment-currency');
369 $content{currency} = $currency if $currency;
374 # updates payinfo and cust_payby options with token from transaction
375 # can be called as a class method
377 my ($self,$transaction,$options) = @_;
378 if ( $transaction->can('card_token')
379 and $transaction->card_token
380 and !$self->tokenized($options->{'payinfo'})
382 $options->{'payinfo'} = $transaction->card_token;
383 $options->{'cust_payby'}->payinfo($transaction->card_token) if $options->{'cust_payby'};
384 return $transaction->card_token;
389 my %bop_method2payby = (
398 confess "Can't call realtime_bop within another transaction ".
399 '($FS::UID::AutoCommit is false)'
400 unless $FS::UID::AutoCommit;
402 local($DEBUG) = $FS::cust_main::DEBUG if $FS::cust_main::DEBUG > $DEBUG;
404 my $log = FS::Log->new('FS::cust_main::Billing_Realtime::realtime_bop');
407 if (ref($_[0]) eq 'HASH') {
410 my ( $method, $amount ) = ( shift, shift );
412 $options{method} = $method;
413 $options{amount} = $amount;
416 # set fields from passed cust_payby
417 _bop_cust_payby_options(\%options);
419 # possibly run a separate transaction to tokenize card number,
420 # so that we never store tokenized card info in cust_pay_pending
421 if (($options{method} eq 'CC') && !$self->tokenized($options{'payinfo'})) {
422 my $token_error = $self->realtime_tokenize(\%options);
423 return $token_error if $token_error;
424 # in theory, all cust_payby will be tokenized during original save,
425 # so we shouldn't get here with opt cust_payby...but just in case...
426 if ($options{'cust_payby'} && $self->tokenized($options{'payinfo'})) {
427 $token_error = $options{'cust_payby'}->replace;
428 return $token_error if $token_error;
430 return "Cannot tokenize card info"
431 if $conf->exists('no_saved_cardnumbers') && !$self->tokenized($options{'payinfo'});
435 # optional credit card surcharge
438 my $cc_surcharge = 0;
439 my $cc_surcharge_pct = 0;
440 $cc_surcharge_pct = $conf->config('credit-card-surcharge-percentage', $self->agentnum)
441 if $conf->config('credit-card-surcharge-percentage', $self->agentnum)
442 && $options{method} eq 'CC';
444 # always add cc surcharge if called from event
445 if($options{'cc_surcharge_from_event'} && $cc_surcharge_pct > 0) {
446 $cc_surcharge = $options{'amount'} * $cc_surcharge_pct / 100;
447 $options{'amount'} += $cc_surcharge;
448 $options{'amount'} = sprintf("%.2f", $options{'amount'}); # round (again)?
450 elsif($cc_surcharge_pct > 0) { # we're called not from event (i.e. from a
451 # payment screen), so consider the given
452 # amount as post-surcharge
453 $cc_surcharge = $options{'amount'} - ($options{'amount'} / ( 1 + $cc_surcharge_pct/100 ));
456 $cc_surcharge = sprintf("%.2f",$cc_surcharge) if $cc_surcharge > 0;
457 $options{'cc_surcharge'} = $cc_surcharge;
461 warn "$me realtime_bop (new): $options{method} $options{amount}\n";
462 warn " cc_surcharge = $cc_surcharge\n";
465 warn " $_ => $options{$_}\n" foreach keys %options;
468 return $self->fake_bop(\%options) if $options{'fake'};
470 $self->_bop_defaults(\%options);
472 return "Missing payinfo"
473 unless $options{'payinfo'};
476 # set trans_is_recur based on invnum if there is one
479 my $trans_is_recur = 0;
480 if ( $options{'invnum'} ) {
482 my $cust_bill = qsearchs('cust_bill', { 'invnum' => $options{'invnum'} } );
483 die "invnum ". $options{'invnum'}. " not found" unless $cust_bill;
489 $cust_bill->cust_bill_pkg;
492 if grep { $_->freq ne '0' } @part_pkg;
500 my $payment_gateway = $self->_payment_gateway( \%options );
501 my $namespace = $payment_gateway->gateway_namespace;
503 eval "use $namespace";
507 # check for banned credit card/ACH
510 my $ban = FS::banned_pay->ban_search(
511 'payby' => $bop_method2payby{$options{method}},
512 'payinfo' => $options{payinfo},
514 return "Banned credit card" if $ban && $ban->bantype ne 'warn';
517 # check for term discount validity
520 my $discount_term = $options{discount_term};
521 if ( $discount_term ) {
522 my $bill = ($self->cust_bill)[-1]
523 or return "Can't apply a term discount to an unbilled customer";
524 my $plan = FS::discount_plan->new(
526 months => $discount_term
527 ) or return "No discount available for term '$discount_term'";
529 if ( $plan->discounted_total != $options{amount} ) {
530 return "Incorrect term prepayment amount (term $discount_term, amount $options{amount}, requires ".$plan->discounted_total.")";
538 my $bop_content = $self->_bop_content(\%options);
539 return $bop_content unless ref($bop_content);
541 my @invoicing_list = $self->invoicing_list_emailonly;
542 if ( $conf->exists('emailinvoiceautoalways')
543 || $conf->exists('emailinvoiceauto') && ! @invoicing_list
544 || ( $conf->exists('emailinvoiceonly') && ! @invoicing_list ) ) {
545 push @invoicing_list, $self->all_emails;
548 my $email = ($conf->exists('business-onlinepayment-email-override'))
549 ? $conf->config('business-onlinepayment-email-override')
550 : $invoicing_list[0];
555 if ( $namespace eq 'Business::OnlinePayment' ) {
557 if ( $options{method} eq 'CC' ) {
559 $content{card_number} = $options{payinfo};
560 $paydate = $options{'paydate'};
561 $paydate =~ /^\d{2}(\d{2})[\/\-](\d+)[\/\-]\d+$/;
562 $content{expiration} = "$2/$1";
564 $content{cvv2} = $options{'paycvv'}
565 if length($options{'paycvv'});
567 my $paystart_month = $options{'paystart_month'};
568 my $paystart_year = $options{'paystart_year'};
569 $content{card_start} = "$paystart_month/$paystart_year"
570 if $paystart_month && $paystart_year;
572 my $payissue = $options{'payissue'};
573 $content{issue_number} = $payissue if $payissue;
575 if ( $self->_bop_recurring_billing(
576 'payinfo' => $options{'payinfo'},
577 'trans_is_recur' => $trans_is_recur,
581 $content{recurring_billing} = 'YES';
582 $content{acct_code} = 'rebill'
583 if $conf->exists('credit_card-recurring_billing_acct_code');
586 } elsif ( $options{method} eq 'ECHECK' ){
588 ( $content{account_number}, $content{routing_code} ) =
589 split('@', $options{payinfo});
590 $content{bank_name} = $options{payname};
591 $content{bank_state} = $options{'paystate'};
592 $content{account_type}= uc($options{'paytype'}) || 'PERSONAL CHECKING';
594 $content{company} = $self->company if $self->company;
596 if ( $content{account_type} =~ /BUSINESS/i && $self->company ) {
597 $content{account_name} = $self->company;
599 $content{account_name} = $self->getfield('first'). ' '.
600 $self->getfield('last');
603 $content{customer_org} = $self->company ? 'B' : 'I';
604 $content{state_id} = exists($options{'stateid'})
605 ? $options{'stateid'}
606 : $self->getfield('stateid');
607 $content{state_id_state} = exists($options{'stateid_state'})
608 ? $options{'stateid_state'}
609 : $self->getfield('stateid_state');
610 $content{customer_ssn} = exists($options{'ss'})
615 die "unknown method ". $options{method};
618 } elsif ( $namespace eq 'Business::OnlineThirdPartyPayment' ) {
621 die "unknown namespace $namespace";
628 my $balance = exists( $options{'balance'} )
629 ? $options{'balance'}
632 warn "claiming mutex on customer ". $self->custnum. "\n" if $DEBUG > 1;
633 $self->select_for_update; #mutex ... just until we get our pending record in
634 warn "obtained mutex on customer ". $self->custnum. "\n" if $DEBUG > 1;
636 #the checks here are intended to catch concurrent payments
637 #double-form-submission prevention is taken care of in cust_pay_pending::check
640 return "The customer's balance has changed; $options{method} transaction aborted."
641 if $self->balance < $balance;
643 #also check and make sure there aren't *other* pending payments for this cust
645 my @pending = qsearch('cust_pay_pending', {
646 'custnum' => $self->custnum,
647 'status' => { op=>'!=', value=>'done' }
650 #for third-party payments only, remove pending payments if they're in the
651 #'thirdparty' (waiting for customer action) state.
652 if ( $namespace eq 'Business::OnlineThirdPartyPayment' ) {
653 foreach ( grep { $_->status eq 'thirdparty' } @pending ) {
654 my $error = $_->delete;
655 warn "error deleting unfinished third-party payment ".
656 $_->paypendingnum . ": $error\n"
659 @pending = grep { $_->status ne 'thirdparty' } @pending;
662 return "A payment is already being processed for this customer (".
663 join(', ', map 'paypendingnum '. $_->paypendingnum, @pending ).
664 "); $options{method} transaction aborted."
667 #okay, good to go, if we're a duplicate, cust_pay_pending will kick us out
669 my $cust_pay_pending = new FS::cust_pay_pending {
670 'custnum' => $self->custnum,
671 'paid' => $options{amount},
673 'payby' => $bop_method2payby{$options{method}},
674 'payinfo' => $options{payinfo},
675 'paymask' => $options{paymask},
676 'paydate' => $paydate,
677 'recurring_billing' => $content{recurring_billing},
678 'pkgnum' => $options{'pkgnum'},
680 'gatewaynum' => $payment_gateway->gatewaynum || '',
681 'session_id' => $options{session_id} || '',
682 'jobnum' => $options{depend_jobnum} || '',
684 $cust_pay_pending->payunique( $options{payunique} )
685 if defined($options{payunique}) && length($options{payunique});
687 warn "inserting cust_pay_pending record for customer ". $self->custnum. "\n"
689 my $cpp_new_err = $cust_pay_pending->insert; #mutex lost when this is inserted
690 return $cpp_new_err if $cpp_new_err;
692 warn "inserted cust_pay_pending record for customer ". $self->custnum. "\n"
694 warn Dumper($cust_pay_pending) if $DEBUG > 2;
696 my( $action1, $action2 ) =
697 split( /\s*\,\s*/, $payment_gateway->gateway_action );
699 my $transaction = new $namespace( $payment_gateway->gateway_module,
700 _bop_options(\%options),
703 $transaction->content(
704 'type' => $options{method},
705 _bop_auth(\%options),
706 'action' => $action1,
707 'description' => $options{'description'},
708 'amount' => $options{amount},
709 #'invoice_number' => $options{'invnum'},
710 'customer_id' => $self->custnum,
712 'reference' => $cust_pay_pending->paypendingnum, #for now
713 'callback_url' => $payment_gateway->gateway_callback_url,
714 'cancel_url' => $payment_gateway->gateway_cancel_url,
719 $cust_pay_pending->status('pending');
720 my $cpp_pending_err = $cust_pay_pending->replace;
721 return $cpp_pending_err if $cpp_pending_err;
723 warn Dumper($transaction) if $DEBUG > 2;
725 unless ( $BOP_TESTING ) {
726 $transaction->test_transaction(1)
727 if $conf->exists('business-onlinepayment-test_transaction');
728 $transaction->submit();
730 if ( $BOP_TESTING_SUCCESS ) {
731 $transaction->is_success(1);
732 $transaction->authorization('fake auth');
734 $transaction->is_success(0);
735 $transaction->error_message('fake failure');
739 if ( $transaction->is_success() && $namespace eq 'Business::OnlineThirdPartyPayment' ) {
741 $cust_pay_pending->status('thirdparty');
742 my $cpp_err = $cust_pay_pending->replace;
743 return { error => $cpp_err } if $cpp_err;
744 return { reference => $cust_pay_pending->paypendingnum,
745 map { $_ => $transaction->$_ } qw ( popup_url collectitems ) };
747 } elsif ( $transaction->is_success() && $action2 ) {
749 $cust_pay_pending->status('authorized');
750 my $cpp_authorized_err = $cust_pay_pending->replace;
751 return $cpp_authorized_err if $cpp_authorized_err;
753 my $auth = $transaction->authorization;
754 my $ordernum = $transaction->can('order_number')
755 ? $transaction->order_number
759 new Business::OnlinePayment( $payment_gateway->gateway_module,
760 _bop_options(\%options),
765 type => $options{method},
767 _bop_auth(\%options),
768 order_number => $ordernum,
769 amount => $options{amount},
770 authorization => $auth,
771 description => $options{'description'},
774 foreach my $field (qw( authorization_source_code returned_ACI
775 transaction_identifier validation_code
776 transaction_sequence_num local_transaction_date
777 local_transaction_time AVS_result_code )) {
778 $capture{$field} = $transaction->$field() if $transaction->can($field);
781 $capture->content( %capture );
783 $capture->test_transaction(1)
784 if $conf->exists('business-onlinepayment-test_transaction');
787 unless ( $capture->is_success ) {
788 my $e = "Authorization successful but capture failed, custnum #".
789 $self->custnum. ': '. $capture->result_code.
790 ": ". $capture->error_message;
798 # remove paycvv after initial transaction
801 # compare to FS::cust_main::save_cust_payby - check both to make sure working correctly
802 if ( length($options{'paycvv'})
803 && ! grep { $_ eq cardtype($options{payinfo}) } $conf->config('cvv-save')
805 my $error = $self->remove_cvv_from_cust_payby($options{payinfo});
807 $log->critical('Error removing cvv for cust '.$self->custnum.': '.$error);
808 #not returning error, should at least attempt to handle results of an otherwise valid transaction
809 warn "WARNING: error removing cvv: $error\n";
817 # This block will only run if the B::OP module supports card_token but not the Tokenize transaction;
818 # if that never happens, we should get rid of it (as it has the potential to store real card numbers on error)
819 if (my $card_token = $self->_tokenize_card($transaction,\%options)) {
820 # cpp will be replaced in _realtime_bop_result
821 $cust_pay_pending->payinfo($card_token);
822 if ($options{'cust_payby'} and my $error = $options{'cust_payby'}->replace) {
823 $log->critical('Error storing token for cust '.$self->custnum.', cust_payby '.$options{'cust_payby'}->custpaybynum.': '.$error);
824 #not returning error, should at least attempt to handle results of an otherwise valid transaction
825 #this leaves real card number in cust_payby, but can't do much else if cust_payby won't replace
833 $self->_realtime_bop_result( $cust_pay_pending, $transaction, %options );
845 if (ref($_[0]) eq 'HASH') {
848 my ( $method, $amount ) = ( shift, shift );
850 $options{method} = $method;
851 $options{amount} = $amount;
854 if ( $options{'fake_failure'} ) {
855 return "Error: No error; test failure requested with fake_failure";
858 my $cust_pay = new FS::cust_pay ( {
859 'custnum' => $self->custnum,
860 'invnum' => $options{'invnum'},
861 'paid' => $options{amount},
863 'payby' => $bop_method2payby{$options{method}},
864 'payinfo' => '4111111111111111',
865 'paydate' => '2012-05-01',
866 'processor' => 'FakeProcessor',
868 'order_number' => '32',
870 $cust_pay->payunique( $options{payunique} ) if length($options{payunique});
873 warn "fake_bop\n cust_pay: ". Dumper($cust_pay) . "\n options: ";
874 warn " $_ => $options{$_}\n" foreach keys %options;
877 my $error = $cust_pay->insert($options{'manual'} ? ( 'manual' => 1 ) : () );
880 $cust_pay->invnum(''); #try again with no specific invnum
881 my $error2 = $cust_pay->insert( $options{'manual'} ?
882 ( 'manual' => 1 ) : ()
885 # gah, even with transactions.
886 my $e = 'WARNING: Card/ACH debited but database not updated - '.
887 "error inserting (fake!) payment: $error2".
888 " (previously tried insert with invnum #$options{'invnum'}" .
895 if ( $options{'paynum_ref'} ) {
896 ${ $options{'paynum_ref'} } = $cust_pay->paynum;
904 # item _realtime_bop_result CUST_PAY_PENDING, BOP_OBJECT [ OPTION => VALUE ... ]
906 # Wraps up processing of a realtime credit card or ACH (electronic check)
909 sub _realtime_bop_result {
910 my( $self, $cust_pay_pending, $transaction, %options ) = @_;
912 local($DEBUG) = $FS::cust_main::DEBUG if $FS::cust_main::DEBUG > $DEBUG;
915 warn "$me _realtime_bop_result: pending transaction ".
916 $cust_pay_pending->paypendingnum. "\n";
917 warn " $_ => $options{$_}\n" foreach keys %options;
920 my $payment_gateway = $options{payment_gateway}
921 or return "no payment gateway in arguments to _realtime_bop_result";
923 $cust_pay_pending->status($transaction->is_success() ? 'captured' : 'declined');
924 my $cpp_captured_err = $cust_pay_pending->replace; #also saves post-transaction tokenization, if that happens
925 return $cpp_captured_err if $cpp_captured_err;
927 if ( $transaction->is_success() ) {
929 my $order_number = $transaction->order_number
930 if $transaction->can('order_number');
932 my $cust_pay = new FS::cust_pay ( {
933 'custnum' => $self->custnum,
934 'invnum' => $options{'invnum'},
935 'paid' => $cust_pay_pending->paid,
937 'payby' => $cust_pay_pending->payby,
938 'payinfo' => $options{'payinfo'},
939 'paymask' => $options{'paymask'} || $cust_pay_pending->paymask,
940 'paydate' => $cust_pay_pending->paydate,
941 'pkgnum' => $cust_pay_pending->pkgnum,
942 'discount_term' => $options{'discount_term'},
943 'gatewaynum' => ($payment_gateway->gatewaynum || ''),
944 'processor' => $payment_gateway->gateway_module,
945 'auth' => $transaction->authorization,
946 'order_number' => $order_number || '',
947 'no_auto_apply' => $options{'no_auto_apply'} ? 'Y' : '',
949 #doesn't hurt to know, even though the dup check is in cust_pay_pending now
950 $cust_pay->payunique( $options{payunique} )
951 if defined($options{payunique}) && length($options{payunique});
953 my $oldAutoCommit = $FS::UID::AutoCommit;
954 local $FS::UID::AutoCommit = 0;
957 #start a transaction, insert the cust_pay and set cust_pay_pending.status to done in a single transction
959 my $error = $cust_pay->insert($options{'manual'} ? ( 'manual' => 1 ) : () );
962 $dbh->rollback or die $dbh->errstr if $oldAutoCommit;
963 $cust_pay->invnum(''); #try again with no specific invnum
964 $cust_pay->paynum('');
965 my $error2 = $cust_pay->insert( $options{'manual'} ?
966 ( 'manual' => 1 ) : ()
969 # gah. but at least we have a record of the state we had to abort in
970 # from cust_pay_pending now.
971 $dbh->rollback or die $dbh->errstr if $oldAutoCommit;
972 my $e = "WARNING: $options{method} captured but payment not recorded -".
973 " error inserting payment (". $payment_gateway->gateway_module.
975 " (previously tried insert with invnum #$options{'invnum'}" .
976 ": $error ) - pending payment saved as paypendingnum ".
977 $cust_pay_pending->paypendingnum. "\n";
983 my $jobnum = $cust_pay_pending->jobnum;
985 my $placeholder = qsearchs( 'queue', { 'jobnum' => $jobnum } );
987 unless ( $placeholder ) {
988 $dbh->rollback or die $dbh->errstr if $oldAutoCommit;
989 my $e = "WARNING: $options{method} captured but job $jobnum not ".
990 "found for paypendingnum ". $cust_pay_pending->paypendingnum. "\n";
995 $error = $placeholder->delete;
998 $dbh->rollback or die $dbh->errstr if $oldAutoCommit;
999 my $e = "WARNING: $options{method} captured but could not delete ".
1000 "job $jobnum for paypendingnum ".
1001 $cust_pay_pending->paypendingnum. ": $error\n";
1006 $cust_pay_pending->set('jobnum','');
1010 if ( $options{'paynum_ref'} ) {
1011 ${ $options{'paynum_ref'} } = $cust_pay->paynum;
1014 $cust_pay_pending->status('done');
1015 $cust_pay_pending->statustext('captured');
1016 $cust_pay_pending->paynum($cust_pay->paynum);
1017 my $cpp_done_err = $cust_pay_pending->replace;
1019 if ( $cpp_done_err ) {
1021 $dbh->rollback or die $dbh->errstr if $oldAutoCommit;
1022 my $e = "WARNING: $options{method} captured but payment not recorded - ".
1023 "error updating status for paypendingnum ".
1024 $cust_pay_pending->paypendingnum. ": $cpp_done_err \n";
1030 $dbh->commit or die $dbh->errstr if $oldAutoCommit;
1032 if ( $options{'apply'} ) {
1033 my $apply_error = $self->apply_payments_and_credits;
1034 if ( $apply_error ) {
1035 warn "WARNING: error applying payment: $apply_error\n";
1036 #but we still should return no error cause the payment otherwise went
1041 # have a CC surcharge portion --> one-time charge
1042 if ( $options{'cc_surcharge'} > 0 ) {
1043 # XXX: this whole block needs to be in a transaction?
1046 $invnum = $options{'invnum'} if $options{'invnum'};
1047 unless ( $invnum ) { # probably from a payment screen
1048 # do we have any open invoices? pick earliest
1049 # uses the fact that cust_main->cust_bill sorts by date ascending
1050 my @open = $self->open_cust_bill;
1051 $invnum = $open[0]->invnum if scalar(@open);
1054 unless ( $invnum ) { # still nothing? pick last closed invoice
1055 # again uses fact that cust_main->cust_bill sorts by date ascending
1056 my @closed = $self->cust_bill;
1057 $invnum = $closed[$#closed]->invnum if scalar(@closed);
1060 unless ( $invnum ) {
1061 # XXX: unlikely case - pre-paying before any invoices generated
1062 # what it should do is create a new invoice and pick it
1063 warn 'CC SURCHARGE AND NO INVOICES PICKED TO APPLY IT!';
1068 my $charge_error = $self->charge({
1069 'amount' => $options{'cc_surcharge'},
1070 'pkg' => 'Credit Card Surcharge',
1072 'cust_pkg_ref' => \$cust_pkg,
1075 warn 'Unable to add CC surcharge cust_pkg';
1079 $cust_pkg->setup(time);
1080 my $cp_error = $cust_pkg->replace;
1082 warn 'Unable to set setup time on cust_pkg for cc surcharge';
1086 my $cust_bill = qsearchs('cust_bill', { 'invnum' => $invnum });
1087 unless ( $cust_bill ) {
1088 warn "race condition + invoice deletion just happened";
1093 $cust_bill->add_cc_surcharge($cust_pkg->pkgnum,$options{'cc_surcharge'});
1095 warn "cannot add CC surcharge to invoice #$invnum: $grand_error"
1099 return ''; #no error
1105 my $perror = $transaction->error_message;
1106 #$payment_gateway->gateway_module. " error: ".
1107 # removed for conciseness
1109 my $jobnum = $cust_pay_pending->jobnum;
1111 my $placeholder = qsearchs( 'queue', { 'jobnum' => $jobnum } );
1113 if ( $placeholder ) {
1114 my $error = $placeholder->depended_delete;
1115 $error ||= $placeholder->delete;
1116 $cust_pay_pending->set('jobnum','');
1117 warn "error removing provisioning jobs after declined paypendingnum ".
1118 $cust_pay_pending->paypendingnum. ": $error\n" if $error;
1120 my $e = "error finding job $jobnum for declined paypendingnum ".
1121 $cust_pay_pending->paypendingnum. "\n";
1127 unless ( $transaction->error_message ) {
1130 if ( $transaction->can('response_page') ) {
1132 'page' => ( $transaction->can('response_page')
1133 ? $transaction->response_page
1136 'code' => ( $transaction->can('response_code')
1137 ? $transaction->response_code
1140 'headers' => ( $transaction->can('response_headers')
1141 ? $transaction->response_headers
1147 "No additional debugging information available for ".
1148 $payment_gateway->gateway_module;
1151 $perror .= "No error_message returned from ".
1152 $payment_gateway->gateway_module. " -- ".
1153 ( ref($t_response) ? Dumper($t_response) : $t_response );
1157 if ( !$options{'quiet'} && !$realtime_bop_decline_quiet
1158 && $conf->exists('emaildecline', $self->agentnum)
1159 && grep { $_ ne 'POST' } $self->invoicing_list
1160 && ! grep { $transaction->error_message =~ /$_/ }
1161 $conf->config('emaildecline-exclude', $self->agentnum)
1164 # Send a decline alert to the customer.
1165 my $msgnum = $conf->config('decline_msgnum', $self->agentnum);
1168 # include the raw error message in the transaction state
1169 $cust_pay_pending->setfield('error', $transaction->error_message);
1170 my $msg_template = qsearchs('msg_template', { msgnum => $msgnum });
1171 $error = $msg_template->send( 'cust_main' => $self,
1172 'object' => $cust_pay_pending );
1176 $perror .= " (also received error sending decline notification: $error)"
1181 $cust_pay_pending->status('done');
1182 $cust_pay_pending->statustext($perror);
1183 #'declined:': no, that's failure_status
1184 if ( $transaction->can('failure_status') ) {
1185 $cust_pay_pending->failure_status( $transaction->failure_status );
1187 my $cpp_done_err = $cust_pay_pending->replace;
1188 if ( $cpp_done_err ) {
1189 my $e = "WARNING: $options{method} declined but pending payment not ".
1190 "resolved - error updating status for paypendingnum ".
1191 $cust_pay_pending->paypendingnum. ": $cpp_done_err \n";
1193 $perror = "$e ($perror)";
1201 =item realtime_botpp_capture CUST_PAY_PENDING [ OPTION => VALUE ... ]
1203 Verifies successful third party processing of a realtime credit card or
1204 ACH (electronic check) transaction via a
1205 Business::OnlineThirdPartyPayment realtime gateway. See
1206 L<http://420.am/business-onlinethirdpartypayment> for supported gateways.
1208 Available options are: I<description>, I<invnum>, I<quiet>, I<paynum_ref>, I<payunique>
1210 The additional options I<payname>, I<city>, I<state>,
1211 I<zip>, I<payinfo> and I<paydate> are also available. Any of these options,
1212 if set, will override the value from the customer record.
1214 I<description> is a free-text field passed to the gateway. It defaults to
1215 "Internet services".
1217 If an I<invnum> is specified, this payment (if successful) is applied to the
1218 specified invoice. If you don't specify an I<invnum> you might want to
1219 call the B<apply_payments> method.
1221 I<quiet> can be set true to surpress email decline notices.
1223 I<paynum_ref> can be set to a scalar reference. It will be filled in with the
1224 resulting paynum, if any.
1226 I<payunique> is a unique identifier for this payment.
1228 Returns a hashref containing elements bill_error (which will be undefined
1229 upon success) and session_id of any associated session.
1233 sub realtime_botpp_capture {
1234 my( $self, $cust_pay_pending, %options ) = @_;
1236 local($DEBUG) = $FS::cust_main::DEBUG if $FS::cust_main::DEBUG > $DEBUG;
1239 warn "$me realtime_botpp_capture: pending transaction $cust_pay_pending\n";
1240 warn " $_ => $options{$_}\n" foreach keys %options;
1243 eval "use Business::OnlineThirdPartyPayment";
1247 # select the gateway
1250 my $method = FS::payby->payby2bop($cust_pay_pending->payby);
1252 my $payment_gateway;
1253 my $gatewaynum = $cust_pay_pending->getfield('gatewaynum');
1254 $payment_gateway = $gatewaynum ? qsearchs( 'payment_gateway',
1255 { gatewaynum => $gatewaynum }
1257 : $self->agent->payment_gateway( 'method' => $method,
1258 # 'invnum' => $cust_pay_pending->invnum,
1259 # 'payinfo' => $cust_pay_pending->payinfo,
1262 $options{payment_gateway} = $payment_gateway; # for the helper subs
1268 my @invoicing_list = $self->invoicing_list_emailonly;
1269 if ( $conf->exists('emailinvoiceautoalways')
1270 || $conf->exists('emailinvoiceauto') && ! @invoicing_list
1271 || ( $conf->exists('emailinvoiceonly') && ! @invoicing_list ) ) {
1272 push @invoicing_list, $self->all_emails;
1275 my $email = ($conf->exists('business-onlinepayment-email-override'))
1276 ? $conf->config('business-onlinepayment-email-override')
1277 : $invoicing_list[0];
1281 $content{email_customer} =
1282 ( $conf->exists('business-onlinepayment-email_customer')
1283 || $conf->exists('business-onlinepayment-email-override') );
1286 # run transaction(s)
1290 new Business::OnlineThirdPartyPayment( $payment_gateway->gateway_module,
1291 _bop_options(\%options),
1294 $transaction->reference({ %options });
1296 $transaction->content(
1298 _bop_auth(\%options),
1299 'action' => 'Post Authorization',
1300 'description' => $options{'description'},
1301 'amount' => $cust_pay_pending->paid,
1302 #'invoice_number' => $options{'invnum'},
1303 'customer_id' => $self->custnum,
1304 'reference' => $cust_pay_pending->paypendingnum,
1306 'phone' => $self->daytime || $self->night,
1308 # plus whatever is required for bogus capture avoidance
1311 $transaction->submit();
1314 $self->_realtime_bop_result( $cust_pay_pending, $transaction, %options );
1316 if ( $options{'apply'} ) {
1317 my $apply_error = $self->apply_payments_and_credits;
1318 if ( $apply_error ) {
1319 warn "WARNING: error applying payment: $apply_error\n";
1324 bill_error => $error,
1325 session_id => $cust_pay_pending->session_id,
1330 =item default_payment_gateway
1332 DEPRECATED -- use agent->payment_gateway
1336 sub default_payment_gateway {
1337 my( $self, $method ) = @_;
1339 die "Real-time processing not enabled\n"
1340 unless $conf->exists('business-onlinepayment');
1342 #warn "default_payment_gateway deprecated -- use agent->payment_gateway\n";
1345 my $bop_config = 'business-onlinepayment';
1346 $bop_config .= '-ach'
1347 if $method =~ /^(ECHECK|CHEK)$/ && $conf->exists($bop_config. '-ach');
1348 my ( $processor, $login, $password, $action, @bop_options ) =
1349 $conf->config($bop_config);
1350 $action ||= 'normal authorization';
1351 pop @bop_options if scalar(@bop_options) % 2 && $bop_options[-1] =~ /^\s*$/;
1352 die "No real-time processor is enabled - ".
1353 "did you set the business-onlinepayment configuration value?\n"
1356 ( $processor, $login, $password, $action, @bop_options )
1359 =item realtime_refund_bop METHOD [ OPTION => VALUE ... ]
1361 Refunds a realtime credit card or ACH (electronic check) transaction
1362 via a Business::OnlinePayment realtime gateway. See
1363 L<http://420.am/business-onlinepayment> for supported gateways.
1365 Available methods are: I<CC> or I<ECHECK>
1367 Available options are: I<amount>, I<reasonnum>, I<paynum>, I<paydate>
1369 Most gateways require a reference to an original payment transaction to refund,
1370 so you probably need to specify a I<paynum>.
1372 I<amount> defaults to the original amount of the payment if not specified.
1374 I<reasonnum> specified an existing refund reason for the refund
1376 I<paydate> specifies the expiration date for a credit card overriding the
1377 value from the customer record or the payment record. Specified as yyyy-mm-dd
1379 Implementation note: If I<amount> is unspecified or equal to the amount of the
1380 orignal payment, first an attempt is made to "void" the transaction via
1381 the gateway (to cancel a not-yet settled transaction) and then if that fails,
1382 the normal attempt is made to "refund" ("credit") the transaction via the
1383 gateway is attempted. No attempt to "void" the transaction is made if the
1384 gateway has introspection data and doesn't support void.
1386 #The additional options I<payname>, I<address1>, I<address2>, I<city>, I<state>,
1387 #I<zip>, I<payinfo> and I<paydate> are also available. Any of these options,
1388 #if set, will override the value from the customer record.
1390 #If an I<invnum> is specified, this payment (if successful) is applied to the
1391 #specified invoice. If you don't specify an I<invnum> you might want to
1392 #call the B<apply_payments> method.
1396 #some false laziness w/realtime_bop, not enough to make it worth merging
1397 #but some useful small subs should be pulled out
1398 sub realtime_refund_bop {
1401 local($DEBUG) = $FS::cust_main::DEBUG if $FS::cust_main::DEBUG > $DEBUG;
1404 if (ref($_[0]) eq 'HASH') {
1405 %options = %{$_[0]};
1409 $options{method} = $method;
1413 warn "$me realtime_refund_bop (new): $options{method} refund\n";
1414 warn " $_ => $options{$_}\n" foreach keys %options;
1417 return "No reason specified" unless $options{'reasonnum'} =~ /^\d+$/;
1422 # look up the original payment and optionally a gateway for that payment
1426 my $amount = $options{'amount'};
1428 my( $processor, $login, $password, @bop_options, $namespace ) ;
1429 my( $auth, $order_number ) = ( '', '', '' );
1430 my $gatewaynum = '';
1432 if ( $options{'paynum'} ) {
1434 warn " paynum: $options{paynum}\n" if $DEBUG > 1;
1435 $cust_pay = qsearchs('cust_pay', { paynum=>$options{'paynum'} } )
1436 or return "Unknown paynum $options{'paynum'}";
1437 $amount ||= $cust_pay->paid;
1439 my @cust_bill_pay = qsearch('cust_bill_pay', { paynum=>$cust_pay->paynum });
1440 $content{'invoice_number'} = $cust_bill_pay[0]->invnum if @cust_bill_pay;
1442 if ( $cust_pay->get('processor') ) {
1443 ($gatewaynum, $processor, $auth, $order_number) =
1445 $cust_pay->gatewaynum,
1446 $cust_pay->processor,
1448 $cust_pay->order_number,
1451 # this payment wasn't upgraded, which probably means this won't work,
1453 $cust_pay->paybatch =~ /^((\d+)\-)?(\w+):\s*([\w\-\/ ]*)(:([\w\-]+))?$/
1454 or return "Can't parse paybatch for paynum $options{'paynum'}: ".
1455 $cust_pay->paybatch;
1456 ( $gatewaynum, $processor, $auth, $order_number ) = ( $2, $3, $4, $6 );
1459 if ( $gatewaynum ) { #gateway for the payment to be refunded
1461 my $payment_gateway =
1462 qsearchs('payment_gateway', { 'gatewaynum' => $gatewaynum } );
1463 die "payment gateway $gatewaynum not found"
1464 unless $payment_gateway;
1466 $processor = $payment_gateway->gateway_module;
1467 $login = $payment_gateway->gateway_username;
1468 $password = $payment_gateway->gateway_password;
1469 $namespace = $payment_gateway->gateway_namespace;
1470 @bop_options = $payment_gateway->options;
1472 } else { #try the default gateway
1475 my $payment_gateway =
1476 $self->agent->payment_gateway('method' => $options{method});
1478 ( $conf_processor, $login, $password, $namespace ) =
1479 map { my $method = "gateway_$_"; $payment_gateway->$method }
1480 qw( module username password namespace );
1482 @bop_options = $payment_gateway->gatewaynum
1483 ? $payment_gateway->options
1484 : @{ $payment_gateway->get('options') };
1486 return "processor of payment $options{'paynum'} $processor does not".
1487 " match default processor $conf_processor"
1488 unless $processor eq $conf_processor;
1493 } else { # didn't specify a paynum, so look for agent gateway overrides
1494 # like a normal transaction
1496 my $payment_gateway =
1497 $self->agent->payment_gateway( 'method' => $options{method},
1498 #'payinfo' => $payinfo,
1500 my( $processor, $login, $password, $namespace ) =
1501 map { my $method = "gateway_$_"; $payment_gateway->$method }
1502 qw( module username password namespace );
1504 my @bop_options = $payment_gateway->gatewaynum
1505 ? $payment_gateway->options
1506 : @{ $payment_gateway->get('options') };
1509 return "neither amount nor paynum specified" unless $amount;
1511 eval "use $namespace";
1516 'type' => $options{method},
1518 'password' => $password,
1519 'order_number' => $order_number,
1520 'amount' => $amount,
1522 $content{authorization} = $auth
1523 if length($auth); #echeck/ACH transactions have an order # but no auth
1524 #(at least with authorize.net)
1526 my $currency = $conf->exists('business-onlinepayment-currency')
1527 && $conf->config('business-onlinepayment-currency');
1528 $content{currency} = $currency if $currency;
1530 my $disable_void_after;
1531 if ($conf->exists('disable_void_after')
1532 && $conf->config('disable_void_after') =~ /^(\d+)$/) {
1533 $disable_void_after = $1;
1536 #first try void if applicable
1537 my $void = new Business::OnlinePayment( $processor, @bop_options );
1540 if ($void->can('info')) {
1542 $paytype = 'ECHECK' if $cust_pay && $cust_pay->payby eq 'CHEK';
1543 $paytype = 'CC' if $cust_pay && $cust_pay->payby eq 'CARD';
1544 my %supported_actions = $void->info('supported_actions');
1546 if ( %supported_actions && $paytype
1547 && defined($supported_actions{$paytype})
1548 && !grep{ $_ eq 'Void' } @{$supported_actions{$paytype}} );
1551 if ( $cust_pay && $cust_pay->paid == $amount
1553 ( not defined($disable_void_after) )
1554 || ( time < ($cust_pay->_date + $disable_void_after ) )
1558 warn " attempting void\n" if $DEBUG > 1;
1559 if ( $void->can('info') ) {
1560 if ( $cust_pay->payby eq 'CARD'
1561 && $void->info('CC_void_requires_card') )
1563 $content{'card_number'} = $cust_pay->payinfo;
1564 } elsif ( $cust_pay->payby eq 'CHEK'
1565 && $void->info('ECHECK_void_requires_account') )
1567 ( $content{'account_number'}, $content{'routing_code'} ) =
1568 split('@', $cust_pay->payinfo);
1569 $content{'name'} = $self->get('first'). ' '. $self->get('last');
1572 $void->content( 'action' => 'void', %content );
1573 $void->test_transaction(1)
1574 if $conf->exists('business-onlinepayment-test_transaction');
1576 if ( $void->is_success ) {
1577 # specified as a refund reason, but now we want a payment void reason
1578 # extract just the reason text, let cust_pay::void handle new_or_existing
1579 my $reason = qsearchs('reason',{ 'reasonnum' => $options{'reasonnum'} });
1581 $error = 'Reason could not be loaded' unless $reason;
1582 $error = $cust_pay->void($reason->reason) unless $error;
1584 # gah, even with transactions.
1585 my $e = 'WARNING: Card/ACH voided but database not updated - '.
1586 "error voiding payment: $error";
1590 warn " void successful\n" if $DEBUG > 1;
1595 warn " void unsuccessful, trying refund\n"
1599 my $address = $self->address1;
1600 $address .= ", ". $self->address2 if $self->address2;
1602 my($payname, $payfirst, $paylast);
1603 if ( $self->payname && $options{method} ne 'ECHECK' ) {
1604 $payname = $self->payname;
1605 $payname =~ /^\s*([\w \,\.\-\']*)?\s+([\w\,\.\-\']+)\s*$/
1606 or return "Illegal payname $payname";
1607 ($payfirst, $paylast) = ($1, $2);
1609 $payfirst = $self->getfield('first');
1610 $paylast = $self->getfield('last');
1611 $payname = "$payfirst $paylast";
1614 my @invoicing_list = $self->invoicing_list_emailonly;
1615 if ( $conf->exists('emailinvoiceautoalways')
1616 || $conf->exists('emailinvoiceauto') && ! @invoicing_list
1617 || ( $conf->exists('emailinvoiceonly') && ! @invoicing_list ) ) {
1618 push @invoicing_list, $self->all_emails;
1621 my $email = ($conf->exists('business-onlinepayment-email-override'))
1622 ? $conf->config('business-onlinepayment-email-override')
1623 : $invoicing_list[0];
1625 my $payip = exists($options{'payip'})
1628 $content{customer_ip} = $payip
1632 if ( $options{method} eq 'CC' ) {
1635 $content{card_number} = $payinfo = $cust_pay->payinfo;
1636 (exists($options{'paydate'}) ? $options{'paydate'} : $cust_pay->paydate)
1637 =~ /^\d{2}(\d{2})[\/\-](\d+)[\/\-]\d+$/ &&
1638 ($content{expiration} = "$2/$1"); # where available
1640 $content{card_number} = $payinfo = $self->payinfo;
1641 (exists($options{'paydate'}) ? $options{'paydate'} : $self->paydate)
1642 =~ /^\d{2}(\d{2})[\/\-](\d+)[\/\-]\d+$/;
1643 $content{expiration} = "$2/$1";
1646 } elsif ( $options{method} eq 'ECHECK' ) {
1649 $payinfo = $cust_pay->payinfo;
1651 $payinfo = $self->payinfo;
1653 ( $content{account_number}, $content{routing_code} )= split('@', $payinfo );
1654 $content{bank_name} = $self->payname;
1655 $content{account_type} = 'CHECKING';
1656 $content{account_name} = $payname;
1657 $content{customer_org} = $self->company ? 'B' : 'I';
1658 $content{customer_ssn} = $self->ss;
1663 my $refund = new Business::OnlinePayment( $processor, @bop_options );
1664 my %sub_content = $refund->content(
1665 'action' => 'credit',
1666 'customer_id' => $self->custnum,
1667 'last_name' => $paylast,
1668 'first_name' => $payfirst,
1670 'address' => $address,
1671 'city' => $self->city,
1672 'state' => $self->state,
1673 'zip' => $self->zip,
1674 'country' => $self->country,
1676 'phone' => $self->daytime || $self->night,
1679 warn join('', map { " $_ => $sub_content{$_}\n" } keys %sub_content )
1681 $refund->test_transaction(1)
1682 if $conf->exists('business-onlinepayment-test_transaction');
1685 return "$processor error: ". $refund->error_message
1686 unless $refund->is_success();
1688 $order_number = $refund->order_number if $refund->can('order_number');
1690 # change this to just use $cust_pay->delete_cust_bill_pay?
1691 while ( $cust_pay && $cust_pay->unapplied < $amount ) {
1692 my @cust_bill_pay = $cust_pay->cust_bill_pay;
1693 last unless @cust_bill_pay;
1694 my $cust_bill_pay = pop @cust_bill_pay;
1695 my $error = $cust_bill_pay->delete;
1699 my $cust_refund = new FS::cust_refund ( {
1700 'custnum' => $self->custnum,
1701 'paynum' => $options{'paynum'},
1702 'source_paynum' => $options{'paynum'},
1703 'refund' => $amount,
1705 'payby' => $bop_method2payby{$options{method}},
1706 'payinfo' => $payinfo,
1707 'reasonnum' => $options{'reasonnum'},
1708 'gatewaynum' => $gatewaynum, # may be null
1709 'processor' => $processor,
1710 'auth' => $refund->authorization,
1711 'order_number' => $order_number,
1713 my $error = $cust_refund->insert;
1715 $cust_refund->paynum(''); #try again with no specific paynum
1716 $cust_refund->source_paynum('');
1717 my $error2 = $cust_refund->insert;
1719 # gah, even with transactions.
1720 my $e = 'WARNING: Card/ACH refunded but database not updated - '.
1721 "error inserting refund ($processor): $error2".
1722 " (previously tried insert with paynum #$options{'paynum'}" .
1733 =item realtime_verify_bop [ OPTION => VALUE ... ]
1735 Runs an authorization-only transaction for $1 against this credit card (if
1736 successful, immediatly reverses the authorization).
1738 Returns the empty string if the authorization was sucessful, or an error
1741 Option I<cust_payby> should be passed, even if it's not yet been inserted.
1742 Object will be tokenized if possible, but that change will not be
1743 updated in database (must be inserted/replaced afterwards.)
1745 Currently only succeeds for Business::OnlinePayment CC transactions.
1749 #some false laziness w/realtime_bop and realtime_refund_bop, not enough to make
1750 #it worth merging but some useful small subs should be pulled out
1751 sub realtime_verify_bop {
1754 local($DEBUG) = $FS::cust_main::DEBUG if $FS::cust_main::DEBUG > $DEBUG;
1755 my $log = FS::Log->new('FS::cust_main::Billing_Realtime::realtime_verify_bop');
1758 if (ref($_[0]) eq 'HASH') {
1759 %options = %{$_[0]};
1765 warn "$me realtime_verify_bop\n";
1766 warn " $_ => $options{$_}\n" foreach keys %options;
1769 # set fields from passed cust_payby
1770 return "No cust_payby" unless $options{'cust_payby'};
1771 _bop_cust_payby_options(\%options);
1773 # possibly run a separate transaction to tokenize card number,
1774 # so that we never store tokenized card info in cust_pay_pending
1775 if (($options{method} eq 'CC') && !$self->tokenized($options{'payinfo'})) {
1776 my $token_error = $self->realtime_tokenize(\%options);
1777 return $token_error if $token_error;
1778 #important that we not replace cust_payby here,
1779 #because cust_payby->replace uses realtime_verify_bop!
1780 return "Cannot tokenize card info"
1781 if $conf->exists('no_saved_cardnumbers') && !$self->tokenized($options{'payinfo'});
1788 my $payment_gateway = $self->_payment_gateway( \%options );
1789 my $namespace = $payment_gateway->gateway_namespace;
1791 eval "use $namespace";
1795 # check for banned credit card/ACH
1798 my $ban = FS::banned_pay->ban_search(
1799 'payby' => $bop_method2payby{'CC'},
1800 'payinfo' => $options{payinfo},
1802 return "Banned credit card" if $ban && $ban->bantype ne 'warn';
1808 my $bop_content = $self->_bop_content(\%options);
1809 return $bop_content unless ref($bop_content);
1811 my @invoicing_list = $self->invoicing_list_emailonly;
1812 if ( $conf->exists('emailinvoiceautoalways')
1813 || $conf->exists('emailinvoiceauto') && ! @invoicing_list
1814 || ( $conf->exists('emailinvoiceonly') && ! @invoicing_list ) ) {
1815 push @invoicing_list, $self->all_emails;
1818 my $email = ($conf->exists('business-onlinepayment-email-override'))
1819 ? $conf->config('business-onlinepayment-email-override')
1820 : $invoicing_list[0];
1825 if ( $namespace eq 'Business::OnlinePayment' ) {
1827 if ( $options{method} eq 'CC' ) {
1829 $content{card_number} = $options{payinfo};
1830 $paydate = $options{'paydate'};
1831 $paydate =~ /^\d{2}(\d{2})[\/\-](\d+)[\/\-]\d+$/;
1832 $content{expiration} = "$2/$1";
1834 $content{cvv2} = $options{'paycvv'}
1835 if length($options{'paycvv'});
1837 my $paystart_month = $options{'paystart_month'};
1838 my $paystart_year = $options{'paystart_year'};
1840 $content{card_start} = "$paystart_month/$paystart_year"
1841 if $paystart_month && $paystart_year;
1843 my $payissue = $options{'payissue'};
1844 $content{issue_number} = $payissue if $payissue;
1846 } elsif ( $options{method} eq 'ECHECK' ){
1847 #cannot verify, move along (though it shouldn't be called...)
1850 return "unknown method ". $options{method};
1852 } elsif ( $namespace eq 'Business::OnlineThirdPartyPayment' ) {
1853 #cannot verify, move along
1856 return "unknown namespace $namespace";
1860 # run transaction(s)
1864 my $transaction; #need this back so we can do _tokenize_card
1866 # don't mutex the customer here, because they might be uncommitted. and
1867 # this is only verification. it doesn't matter if they have other
1868 # unfinished verifications.
1870 my $cust_pay_pending = new FS::cust_pay_pending {
1871 'custnum_pending' => 1,
1874 'payby' => $bop_method2payby{'CC'},
1875 'payinfo' => $options{payinfo},
1876 'paymask' => $options{paymask},
1877 'paydate' => $paydate,
1878 'pkgnum' => $options{'pkgnum'},
1880 'gatewaynum' => $payment_gateway->gatewaynum || '',
1881 'session_id' => $options{session_id} || '',
1883 $cust_pay_pending->payunique( $options{payunique} )
1884 if defined($options{payunique}) && length($options{payunique});
1887 # open a separate handle for creating/updating the cust_pay_pending
1889 local $FS::UID::dbh = myconnect();
1890 local $FS::UID::AutoCommit = 1;
1892 # if this is an existing customer (and we can tell now because
1893 # this is a fresh transaction), it's safe to assign their custnum
1894 # to the cust_pay_pending record, and then the verification attempt
1895 # will remain linked to them even if it fails.
1896 if ( FS::cust_main->by_key($self->custnum) ) {
1897 $cust_pay_pending->set('custnum', $self->custnum);
1900 warn "inserting cust_pay_pending record for customer ". $self->custnum. "\n"
1903 # if this fails, just return; everything else will still allow the
1904 # cust_pay_pending to have its custnum set later
1905 my $cpp_new_err = $cust_pay_pending->insert;
1906 return $cpp_new_err if $cpp_new_err;
1908 warn "inserted cust_pay_pending record for customer ". $self->custnum. "\n"
1910 warn Dumper($cust_pay_pending) if $DEBUG > 2;
1912 $transaction = new $namespace( $payment_gateway->gateway_module,
1913 _bop_options(\%options),
1916 $transaction->content(
1918 _bop_auth(\%options),
1919 'action' => 'Authorization Only',
1920 'description' => $options{'description'},
1922 'customer_id' => $self->custnum,
1924 'reference' => $cust_pay_pending->paypendingnum, #for now
1929 $cust_pay_pending->status('pending');
1930 my $cpp_pending_err = $cust_pay_pending->replace;
1931 return $cpp_pending_err if $cpp_pending_err;
1933 warn Dumper($transaction) if $DEBUG > 2;
1935 unless ( $BOP_TESTING ) {
1936 $transaction->test_transaction(1)
1937 if $conf->exists('business-onlinepayment-test_transaction');
1938 $transaction->submit();
1940 if ( $BOP_TESTING_SUCCESS ) {
1941 $transaction->is_success(1);
1942 $transaction->authorization('fake auth');
1944 $transaction->is_success(0);
1945 $transaction->error_message('fake failure');
1949 if ( $transaction->is_success() ) {
1951 $cust_pay_pending->status('authorized');
1952 my $cpp_authorized_err = $cust_pay_pending->replace;
1953 return $cpp_authorized_err if $cpp_authorized_err;
1955 my $auth = $transaction->authorization;
1956 my $ordernum = $transaction->can('order_number')
1957 ? $transaction->order_number
1960 my $reverse = new $namespace( $payment_gateway->gateway_module,
1961 _bop_options(\%options),
1964 $reverse->content( 'action' => 'Reverse Authorization',
1965 _bop_auth(\%options),
1969 'authorization' => $transaction->authorization,
1970 'order_number' => $ordernum,
1973 'result_code' => $transaction->result_code,
1974 'txn_date' => $transaction->txn_date,
1978 $reverse->test_transaction(1)
1979 if $conf->exists('business-onlinepayment-test_transaction');
1982 if ( $reverse->is_success ) {
1984 $cust_pay_pending->status('done');
1985 $cust_pay_pending->statustext('reversed');
1986 my $cpp_reversed_err = $cust_pay_pending->replace;
1987 return $cpp_reversed_err if $cpp_reversed_err;
1991 my $e = "Authorization successful but reversal failed, custnum #".
1992 $self->custnum. ': '. $reverse->result_code.
1993 ": ". $reverse->error_message;
2000 ### Address Verification ###
2002 # Single-letter codes vary by cardtype.
2004 # Erring on the side of accepting cards if avs is not available,
2005 # only rejecting if avs occurred and there's been an explicit mismatch
2007 # Charts below taken from vSecure documentation,
2008 # shows codes for Amex/Dscv/MC/Visa
2010 # ACCEPTABLE AVS RESPONSES:
2011 # Both Address and 5-digit postal code match Y A Y Y
2012 # Both address and 9-digit postal code match Y A X Y
2013 # United Kingdom – Address and postal code match _ _ _ F
2014 # International transaction – Address and postal code match _ _ _ D/M
2016 # ACCEPTABLE, BUT ISSUE A WARNING:
2017 # Ineligible transaction; or message contains a content error _ _ _ E
2018 # System unavailable; retry R U R R
2019 # Information unavailable U W U U
2020 # Issuer does not support AVS S U S S
2021 # AVS is not applicable _ _ _ S
2022 # Incompatible formats – Not verified _ _ _ C
2023 # Incompatible formats – Address not verified; postal code matches _ _ _ P
2024 # International transaction – address not verified _ G _ G/I
2026 # UNACCEPTABLE AVS RESPONSES:
2027 # Only Address matches A Y A A
2028 # Only 5-digit postal code matches Z Z Z Z
2029 # Only 9-digit postal code matches Z Z W W
2030 # Neither address nor postal code matches N N N N
2032 if (my $avscode = uc($transaction->avs_code)) {
2034 # map codes to accept/warn/reject
2036 'American Express card' => {
2045 'Discover card' => {
2084 my $cardtype = cardtype($content{card_number});
2085 if ($avs->{$cardtype}) {
2086 my $avsact = $avs->{$cardtype}->{$avscode};
2088 if ($avsact eq 'r') {
2089 return "AVS code verification failed, cardtype $cardtype, code $avscode";
2090 } elsif ($avsact eq 'w') {
2091 $warning = "AVS did not occur, cardtype $cardtype, code $avscode";
2092 } elsif (!$avsact) {
2093 $warning = "AVS code unknown, cardtype $cardtype, code $avscode";
2094 } # else $avsact eq 'a'
2096 $log->warning($warning);
2099 } # else $cardtype avs handling not implemented
2100 } # else !$transaction->avs_code
2102 } else { # is not success
2104 # status is 'done' not 'declined', as in _realtime_bop_result
2105 $cust_pay_pending->status('done');
2106 $error = $transaction->error_message || 'Unknown error';
2107 $cust_pay_pending->statustext($error);
2108 # could also record failure_status here,
2109 # but it's not supported by B::OP::vSecureProcessing...
2110 # need a B::OP module with (reverse) auth only to test it with
2111 my $cpp_declined_err = $cust_pay_pending->replace;
2112 return $cpp_declined_err if $cpp_declined_err;
2116 } # end of IMMEDIATE; we now have our $error and $transaction
2119 # Save the custnum (as part of the main transaction, so it can reference
2123 if (!$cust_pay_pending->custnum) {
2124 $cust_pay_pending->set('custnum', $self->custnum);
2125 my $set_custnum_err = $cust_pay_pending->replace;
2126 if ($set_custnum_err) {
2127 $log->error($set_custnum_err);
2128 $error ||= $set_custnum_err;
2129 # but if there was a real verification error also, return that one
2134 # remove paycvv here? need to find out if a reversed auth
2135 # counts as an initial transaction for paycvv retention requirements
2142 # This block will only run if the B::OP module supports card_token but not the Tokenize transaction;
2143 # if that never happens, we should get rid of it (as it has the potential to store real card numbers on error)
2144 if (my $card_token = $self->_tokenize_card($transaction,\%options)) {
2145 $cust_pay_pending->payinfo($card_token);
2146 my $cpp_token_err = $cust_pay_pending->replace;
2147 #this leaves real card number in cust_pay_pending, but can't do much else if cpp won't replace
2148 return $cpp_token_err if $cpp_token_err;
2149 #important that we not replace cust_payby here,
2150 #because cust_payby->replace uses realtime_verify_bop!
2157 # $error contains the transaction error_message, if is_success was false.
2163 =item realtime_tokenize [ OPTION => VALUE ... ]
2165 If possible and necessary, runs a tokenize transaction.
2166 In order to be possible, a credit card cust_payby record
2167 must be passed and a Business::OnlinePayment gateway capable
2168 of Tokenize transactions must be configured for this user.
2169 Is only necessary if payinfo is not yet tokenized.
2171 Returns the empty string if the authorization was sucessful
2172 or was not possible/necessary (thus allowing this to be safely called with
2173 non-tokenizable records/gateways, without having to perform separate tests),
2174 or an error message otherwise.
2176 Option I<cust_payby> may be passed, even if it's not yet been inserted.
2177 Object will be tokenized if possible, but that change will not be
2178 updated in database (must be inserted/replaced afterwards.)
2180 Otherwise, options I<method>, I<payinfo> and other cust_payby fields
2181 may be passed. If options are passed as a hashref, I<payinfo>
2182 will be updated as appropriate in the passed hashref.
2184 Can be run as a class method if option I<payment_gateway> is passed,
2185 but default customer id/name/phone can't be set in that case. This
2186 is really only intended for tokenizing old records on upgrade.
2190 # careful--might be run as a class method
2191 sub realtime_tokenize {
2194 local($DEBUG) = $FS::cust_main::DEBUG if $FS::cust_main::DEBUG > $DEBUG;
2195 my $log = FS::Log->new('FS::cust_main::Billing_Realtime::realtime_tokenize');
2198 my $outoptions; #for returning cust_payby/payinfo
2199 if (ref($_[0]) eq 'HASH') {
2200 %options = %{$_[0]};
2201 $outoptions = $_[0];
2204 $outoptions = \%options;
2207 # set fields from passed cust_payby
2208 _bop_cust_payby_options(\%options);
2209 return '' unless $options{method} eq 'CC';
2210 return '' if $self->tokenized($options{payinfo}); #already tokenized
2216 $options{'nofatal'} = 1;
2217 my $payment_gateway = $self->_payment_gateway( \%options );
2218 return '' unless $payment_gateway;
2219 my $namespace = $payment_gateway->gateway_namespace;
2220 return '' unless $namespace eq 'Business::OnlinePayment';
2222 eval "use $namespace";
2226 # check for tokenize ability
2229 my $transaction = new $namespace( $payment_gateway->gateway_module,
2230 _bop_options(\%options),
2233 return '' unless $transaction->can('info');
2235 my %supported_actions = $transaction->info('supported_actions');
2236 return '' unless $supported_actions{'CC'}
2237 && grep /^Tokenize$/, @{$supported_actions{'CC'}};
2240 # check for banned credit card/ACH
2243 my $ban = FS::banned_pay->ban_search(
2244 'payby' => $bop_method2payby{'CC'},
2245 'payinfo' => $options{payinfo},
2247 return "Banned credit card" if $ban && $ban->bantype ne 'warn';
2253 ### Currently, cardfortress only keys in on card number and exp date.
2254 ### We pass everything we'd pass to a normal transaction,
2255 ### for ease of current and future development,
2256 ### but note, when tokenizing old records, we may only have access to payinfo/paydate
2258 my $bop_content = $self->_bop_content(\%options);
2259 return $bop_content unless ref($bop_content);
2264 $content{card_number} = $options{payinfo};
2265 $paydate = $options{'paydate'};
2266 $paydate =~ /^\d{2}(\d{2})[\/\-](\d+)[\/\-]\d+$/;
2267 $content{expiration} = "$2/$1";
2269 $content{cvv2} = $options{'paycvv'}
2270 if length($options{'paycvv'});
2272 my $paystart_month = $options{'paystart_month'};
2273 my $paystart_year = $options{'paystart_year'};
2275 $content{card_start} = "$paystart_month/$paystart_year"
2276 if $paystart_month && $paystart_year;
2278 my $payissue = $options{'payissue'};
2279 $content{issue_number} = $payissue if $payissue;
2281 $content{customer_id} = $self->custnum
2290 # no cust_pay_pending---this is not a financial transaction
2292 $transaction->content(
2294 _bop_auth(\%options),
2295 'action' => 'Tokenize',
2296 'description' => $options{'description'},
2301 # no $BOP_TESTING handling for this
2302 $transaction->test_transaction(1)
2303 if $conf->exists('business-onlinepayment-test_transaction');
2304 $transaction->submit();
2306 if ( $transaction->card_token() ) { # no is_success flag
2308 # realtime_tokenize should not clear paycvv at this time. it might be
2309 # needed for the first transaction, and a tokenize isn't actually a
2310 # transaction that hits the gateway. at some point in the future, card
2311 # fortress should take on the "store paycvv until first transaction"
2312 # functionality and we should fix this in freeside, but i that's a bigger
2313 # project for another time.
2315 #important that we not replace cust_payby here,
2316 #because cust_payby->replace uses realtime_tokenize!
2317 $self->_tokenize_card($transaction,$outoptions);
2321 $error = $transaction->error_message || 'Unknown error when tokenizing card';
2330 =item tokenized PAYINFO
2332 Convenience wrapper for L<FS::payinfo_Mixin/tokenized>
2334 PAYINFO is required.
2336 Can be run as class or object method, never loads from object.
2342 my $payinfo = shift;
2343 FS::cust_pay->tokenized($payinfo);
2346 =item token_check [ quiet => 1, queue => 1, daily => 1 ]
2348 NOT A METHOD. Acts on all customers. Placed here because it makes
2349 use of module-internal methods, and to keep everything that uses
2350 Billing::OnlinePayment all in one place.
2352 Tokenizes all tokenizable card numbers from payinfo in cust_payby and
2353 CARD transactions in cust_pay_pending, cust_pay, cust_pay_void and cust_refund.
2355 If the I<queue> flag is set, newly tokenized records will be immediately
2356 committed, regardless of AutoCommit, so as to release the mutex on the record.
2358 If all configured gateways have the ability to tokenize, detection of an
2359 untokenizable record will cause a fatal error. However, if the I<queue> flag
2360 is set, this will instead cause a critical error to be recorded in the log,
2361 and any other tokenizable records will still be committed.
2363 If the I<daily> flag is also set, detection of existing untokenized records will
2364 record a critical error in the system log (because they should have never appeared
2365 in the first place.) Tokenization will still be attempted.
2367 If any configured gateways do NOT have the ability to tokenize, or if a
2368 default gateway is not configured, then untokenized records are not considered
2369 a threat, and no critical errors will be generated in the log.
2374 #acts on all customers
2376 my $debug = !$opt{'quiet'} || $DEBUG;
2378 warn "token_check called with opts\n".Dumper(\%opt) if $debug;
2380 # force some explicitness when invoking this method
2381 die "token_check must run with queue flag if run with daily flag"
2382 if $opt{'daily'} && !$opt{'queue'};
2384 my $conf = FS::Conf->new;
2386 my $log = FS::Log->new('FS::cust_main::Billing_Realtime::token_check');
2388 my $cache = {}; #cache for module info
2390 # look for a gateway that can't tokenize
2391 my $require_tokenized = 1;
2392 foreach my $gateway (
2393 FS::payment_gateway->all_gateways(
2400 # no default gateway, no promise to tokenize
2401 # can just load other gateways as-needeed below
2402 $require_tokenized = 0;
2405 my $info = _token_check_gateway_info($cache,$gateway);
2406 die $info unless ref($info); # means it's an error message
2407 unless ($info->{'can_tokenize'}) {
2408 # a configured gateway can't tokenize, that's all we need to know right now
2409 # can just load other gateways as-needeed below
2410 $require_tokenized = 0;
2415 warn "REQUIRE TOKENIZED" if $require_tokenized && $debug;
2417 # upgrade does not call this with autocommit turned on,
2418 # and autocommit will be ignored if opt queue is set,
2419 # but might as well be thorough...
2420 my $oldAutoCommit = $FS::UID::AutoCommit;
2421 local $FS::UID::AutoCommit = 0;
2424 # for retrieving data in chunks
2428 ### Tokenize cust_payby
2433 while (my $custnum = _token_check_next_recnum($dbh,'cust_main',$step,\$offset,\@recnums)) {
2434 my $cust_main = FS::cust_main->by_key($custnum);
2435 my $payment_gateway;
2436 foreach my $cust_payby ($cust_main->cust_payby('CARD','DCRD')) {
2438 # see if it's already tokenized
2439 if ($cust_payby->tokenized) {
2440 warn "cust_payby ".$cust_payby->get($cust_payby->primary_key)." already tokenized" if $debug;
2444 if ($require_tokenized && $opt{'daily'}) {
2445 $log->critical("Untokenized card number detected in cust_payby ".$cust_payby->custpaybynum);
2446 $dbh->commit or die $dbh->errstr; # commit log message
2449 # only load gateway if we need to, and only need to load it once
2450 my $payment_gateway ||= $cust_main->_payment_gateway({
2453 'nofatal' => 1, # handle lack of gateway smoothly below
2455 unless ($payment_gateway) {
2456 # no reason to have untokenized card numbers saved if no gateway,
2457 # but only a problem if we expected everyone to tokenize card numbers
2458 unless ($require_tokenized) {
2459 warn "Skipping cust_payby for cust_main ".$cust_main->custnum.", no payment gateway" if $debug;
2460 next CUSTLOOP; # can skip rest of customer
2462 my $error = "No gateway found for custnum ".$cust_main->custnum;
2463 if ($opt{'queue'}) {
2464 $log->critical($error);
2465 $dbh->commit or die $dbh->errstr; # commit error message
2466 next; # not next CUSTLOOP, want to record error for every cust_payby
2468 $dbh->rollback if $oldAutoCommit;
2472 my $info = _token_check_gateway_info($cache,$payment_gateway);
2473 unless (ref($info)) {
2474 # only throws error if Business::OnlinePayment won't load,
2475 # which is just cause to abort this whole process, even if queue
2476 $dbh->rollback if $oldAutoCommit;
2477 die $info; # error message
2479 # no fail here--a configured gateway can't tokenize, so be it
2480 unless ($info->{'can_tokenize'}) {
2481 warn "Skipping ".$cust_main->custnum." cannot tokenize" if $debug;
2486 $cust_payby = $cust_payby->select_for_update;
2488 'payment_gateway' => $payment_gateway,
2489 'cust_payby' => $cust_payby,
2491 my $error = $cust_main->realtime_tokenize(\%tokenopts);
2492 if ($cust_payby->tokenized) { # implies no error
2493 $error = $cust_payby->replace;
2495 $error ||= 'Unknown error';
2498 $error = "Error tokenizing cust_payby ".$cust_payby->custpaybynum.": ".$error;
2499 if ($opt{'queue'}) {
2500 $log->critical($error);
2501 $dbh->commit or die $dbh->errstr; # commit log message, release mutex
2502 next; # not next CUSTLOOP, want to record error for every cust_payby
2504 $dbh->rollback if $oldAutoCommit;
2507 $dbh->commit or die $dbh->errstr if $opt{'queue'}; # release mutex
2508 warn "TOKENIZED cust_payby ".$cust_payby->get($cust_payby->primary_key) if $debug;
2510 warn "cust_payby upgraded for custnum ".$cust_main->custnum if $debug;
2514 ### Tokenize/mask transaction tables
2516 # allow tokenization of closed cust_pay/cust_refund records
2517 local $FS::payinfo_Mixin::allow_closed_replace = 1;
2520 # $cust_pay_pending->replace, $cust_pay->replace, $cust_pay_void->replace, $cust_refund->replace all run here
2521 foreach my $table ( qw(cust_pay_pending cust_pay cust_pay_void cust_refund) ) {
2522 warn "Checking $table" if $debug;
2524 # FS::Cursor does not seem to work over multiple commits (gives cursor not found errors)
2525 # loading only record ids, then loading individual records one at a time
2526 my $tclass = 'FS::'.$table;
2530 while (my $recnum = _token_check_next_recnum($dbh,$table,$step,\$offset,\@recnums)) {
2531 my $record = $tclass->by_key($recnum);
2532 if (FS::cust_main::Billing_Realtime->tokenized($record->payinfo)) {
2533 warn "Skipping tokenized record for $table ".$record->get($record->primary_key) if $debug;
2536 if (!$record->payinfo) { #shouldn't happen, but at least it's not a card number
2537 warn "Skipping blank payinfo for $table ".$record->get($record->primary_key) if $debug;
2540 if ($record->payinfo =~ /N\/A/) { # ??? Not sure why we do this, but it's not a card number
2541 warn "Skipping NA payinfo for $table ".$record->get($record->primary_key) if $debug;
2545 if ($require_tokenized && $opt{'daily'}) {
2546 $log->critical("Untokenized card number detected in $table ".$record->get($record->primary_key));
2547 $dbh->commit or die $dbh->errstr; # commit log message
2550 # don't use customer agent gateway here, use the gatewaynum specified by the record
2551 my $gateway = FS::payment_gateway->by_key_or_default(
2555 'gatewaynum' => $record->gatewaynum || '',
2558 # means no default gateway, no promise to tokenize, can skip
2559 warn "Skipping missing gateway for $table ".$record->get($record->primary_key) if $debug;
2563 my $info = _token_check_gateway_info($cache,$gateway);
2564 unless (ref($info)) {
2565 # only throws error if Business::OnlinePayment won't load,
2566 # which is just cause to abort this whole process, even if queue
2567 $dbh->rollback if $oldAutoCommit;
2568 die $info; # error message
2571 # a configured gateway can't tokenize, move along
2572 unless ($info->{'can_tokenize'}) {
2573 warn "Skipping, cannot tokenize $table ".$record->get($record->primary_key) if $debug;
2577 my $cust_main = $record->cust_main;
2579 # might happen for cust_pay_pending from failed verify records,
2580 # in which case we attempt tokenization without cust_main
2581 # everything else should absolutely have a cust_main
2582 if ($table eq 'cust_pay_pending' && $record->{'custnum_pending'}) {
2583 warn "ATTEMPTING GATEWAY-ONLY TOKENIZE" if $debug;
2585 my $error = "Could not load cust_main for $table ".$record->get($record->primary_key);
2586 if ($opt{'queue'}) {
2587 $log->critical($error);
2588 $dbh->commit or die $dbh->errstr; # commit log message
2591 $dbh->rollback if $oldAutoCommit;
2596 # if we got this far, time to mutex
2597 $record = $record->select_for_update;
2599 # no clear record of name/address/etc used for transaction,
2600 # but will load name/phone/id from customer if run as an object method,
2601 # so we try that if we can
2603 'payment_gateway' => $gateway,
2605 'payinfo' => $record->payinfo,
2606 'paydate' => $record->paydate,
2608 my $error = $cust_main
2609 ? $cust_main->realtime_tokenize(\%tokenopts)
2610 : FS::cust_main::Billing_Realtime->realtime_tokenize(\%tokenopts);
2611 if (FS::cust_main::Billing_Realtime->tokenized($tokenopts{'payinfo'})) { # implies no error
2612 $record->payinfo($tokenopts{'payinfo'});
2613 $error = $record->replace;
2615 $error ||= 'Unknown error';
2618 $error = "Error tokenizing $table ".$record->get($record->primary_key).": ".$error;
2619 if ($opt{'queue'}) {
2620 $log->critical($error);
2621 $dbh->commit or die $dbh->errstr; # commit log message, release mutex
2624 $dbh->rollback if $oldAutoCommit;
2627 $dbh->commit or die $dbh->errstr if $opt{'queue'}; # release mutex
2628 warn "TOKENIZED $table ".$record->get($record->primary_key) if $debug;
2633 $dbh->commit or die $dbh->errstr if $oldAutoCommit;
2639 sub _token_check_next_recnum {
2640 my ($dbh,$table,$step,$offset,$recnums) = @_;
2641 my $recnum = shift @$recnums;
2642 return $recnum if $recnum;
2643 my $tclass = 'FS::'.$table;
2644 my $sth = $dbh->prepare('SELECT '.$tclass->primary_key.' FROM '.$table.' ORDER BY '.$tclass->primary_key.' LIMIT '.$step.' OFFSET '.$$offset) or die $dbh->errstr;
2645 $sth->execute() or die $sth->errstr;
2647 while (my $rec = $sth->fetchrow_hashref) {
2648 push @$recnums, $rec->{$tclass->primary_key};
2652 return shift @$recnums;
2656 sub _token_check_gateway_info {
2657 my ($cache,$payment_gateway) = @_;
2659 return $cache->{$payment_gateway->gateway_module}
2660 if $cache->{$payment_gateway->gateway_module};
2663 $cache->{$payment_gateway->gateway_module} = $info;
2665 my $namespace = $payment_gateway->gateway_namespace;
2666 return $info unless $namespace eq 'Business::OnlinePayment';
2667 $info->{'is_bop'} = 1;
2669 # only need to load this once,
2670 # don't want to load if nothing is_bop
2671 unless ($cache->{'Business::OnlinePayment'}) {
2672 eval "use $namespace";
2673 return "Error initializing Business:OnlinePayment: ".$@ if $@;
2674 $cache->{'Business::OnlinePayment'} = 1;
2677 my $transaction = new $namespace( $payment_gateway->gateway_module,
2678 _bop_options({ 'payment_gateway' => $payment_gateway }),
2681 return $info unless $transaction->can('info');
2682 $info->{'can_info'} = 1;
2684 my %supported_actions = $transaction->info('supported_actions');
2685 $info->{'can_tokenize'} = 1
2686 if $supported_actions{'CC'}
2687 && grep /^Tokenize$/, @{$supported_actions{'CC'}};
2689 # not using this any more, but for future reference...
2690 $info->{'void_requires_card'} = 1
2691 if $transaction->info('CC_void_requires_card');
2702 L<FS::cust_main>, L<FS::cust_main::Billing>