1 package FS::cust_main::Billing_Realtime;
4 use vars qw( $conf $DEBUG $me );
5 use vars qw( $realtime_bop_decline_quiet ); #ugh
7 use Business::CreditCard 0.28;
9 use FS::Record qw( qsearch qsearchs );
10 use FS::Misc qw( send_email );
13 use FS::cust_pay_pending;
17 $realtime_bop_decline_quiet = 0;
19 # 1 is mostly method/subroutine entry and options
20 # 2 traces progress of some operations
21 # 3 is even more information including possibly sensitive data
23 $me = '[FS::cust_main::Billing_Realtime]';
26 our $BOP_TESTING_SUCCESS = 1;
28 install_callback FS::UID sub {
30 #yes, need it for stuff below (prolly should be cached)
35 FS::cust_main::Billing_Realtime - Realtime billing mixin for cust_main
41 These methods are available on FS::cust_main objects.
47 =item realtime_collect [ OPTION => VALUE ... ]
49 Attempt to collect the customer's current balance with a realtime credit
50 card, electronic check, or phone bill transaction (see realtime_bop() below).
52 Returns the result of realtime_bop(): nothing, an error message, or a
53 hashref of state information for a third-party transaction.
55 Available options are: I<method>, I<amount>, I<description>, I<invnum>, I<quiet>, I<paynum_ref>, I<payunique>, I<session_id>, I<pkgnum>
57 I<method> is one of: I<CC>, I<ECHECK> and I<LEC>. If none is specified
58 then it is deduced from the customer record.
60 If no I<amount> is specified, then the customer balance is used.
62 The additional options I<payname>, I<address1>, I<address2>, I<city>, I<state>,
63 I<zip>, I<payinfo> and I<paydate> are also available. Any of these options,
64 if set, will override the value from the customer record.
66 I<description> is a free-text field passed to the gateway. It defaults to
67 the value defined by the business-onlinepayment-description configuration
68 option, or "Internet services" if that is unset.
70 If an I<invnum> is specified, this payment (if successful) is applied to the
73 I<apply> will automatically apply a resulting payment.
75 I<quiet> can be set true to suppress email decline notices.
77 I<paynum_ref> can be set to a scalar reference. It will be filled in with the
78 resulting paynum, if any.
80 I<payunique> is a unique identifier for this payment.
82 I<session_id> is a session identifier associated with this payment.
84 I<depend_jobnum> allows payment capture to unlock export jobs
88 sub realtime_collect {
89 my( $self, %options ) = @_;
91 local($DEBUG) = $FS::cust_main::DEBUG if $FS::cust_main::DEBUG > $DEBUG;
94 warn "$me realtime_collect:\n";
95 warn " $_ => $options{$_}\n" foreach keys %options;
98 $options{amount} = $self->balance unless exists( $options{amount} );
99 $options{method} = FS::payby->payby2bop($self->payby)
100 unless exists( $options{method} );
102 return $self->realtime_bop({%options});
106 =item realtime_bop { [ ARG => VALUE ... ] }
108 Runs a realtime credit card, ACH (electronic check) or phone bill transaction
109 via a Business::OnlinePayment realtime gateway. See
110 L<http://420.am/business-onlinepayment> for supported gateways.
112 Required arguments in the hashref are I<method>, and I<amount>
114 Available methods are: I<CC>, I<ECHECK>, I<LEC>, and I<PAYPAL>
116 Available optional arguments are: I<description>, I<invnum>, I<apply>, I<quiet>, I<paynum_ref>, I<payunique>, I<session_id>
118 The additional options I<payname>, I<address1>, I<address2>, I<city>, I<state>,
119 I<zip>, I<payinfo> and I<paydate> are also available. Any of these options,
120 if set, will override the value from the customer record.
122 I<description> is a free-text field passed to the gateway. It defaults to
123 the value defined by the business-onlinepayment-description configuration
124 option, or "Internet services" if that is unset.
126 If an I<invnum> is specified, this payment (if successful) is applied to the
127 specified invoice. If the customer has exactly one open invoice, that
128 invoice number will be assumed. If you don't specify an I<invnum> you might
129 want to call the B<apply_payments> method or set the I<apply> option.
131 I<apply> can be set to true to apply a resulting payment.
133 I<quiet> can be set true to surpress email decline notices.
135 I<paynum_ref> can be set to a scalar reference. It will be filled in with the
136 resulting paynum, if any.
138 I<payunique> is a unique identifier for this payment.
140 I<session_id> is a session identifier associated with this payment.
142 I<depend_jobnum> allows payment capture to unlock export jobs
144 I<discount_term> attempts to take a discount by prepaying for discount_term.
145 The payment will fail if I<amount> is incorrect for this discount term.
147 A direct (Business::OnlinePayment) transaction will return nothing on success,
148 or an error message on failure.
150 A third-party transaction will return a hashref containing:
152 - popup_url: the URL to which a browser should be redirected to complete
154 - collectitems: an arrayref of name-value pairs to be posted to popup_url.
155 - reference: a reference ID for the transaction, to show the customer.
157 (moved from cust_bill) (probably should get realtime_{card,ach,lec} here too)
161 # some helper routines
162 sub _bop_recurring_billing {
163 my( $self, %opt ) = @_;
165 my $method = scalar($conf->config('credit_card-recurring_billing_flag'));
167 if ( defined($method) && $method eq 'transaction_is_recur' ) {
169 return 1 if $opt{'trans_is_recur'};
173 # return 1 if the payinfo has been used for another payment
174 return $self->payinfo_used($opt{'payinfo'}); # in payinfo_Mixin
182 sub _payment_gateway {
183 my ($self, $options) = @_;
185 if ( $options->{'selfservice'} ) {
186 my $gatewaynum = FS::Conf->new->config('selfservice-payment_gateway');
188 return $options->{payment_gateway} ||=
189 qsearchs('payment_gateway', { gatewaynum => $gatewaynum });
193 if ( $options->{'fake_gatewaynum'} ) {
194 $options->{payment_gateway} =
195 qsearchs('payment_gateway',
196 { 'gatewaynum' => $options->{'fake_gatewaynum'}, }
200 $options->{payment_gateway} = $self->agent->payment_gateway( %$options )
201 unless exists($options->{payment_gateway});
203 $options->{payment_gateway};
207 my ($self, $options) = @_;
210 'login' => $options->{payment_gateway}->gateway_username,
211 'password' => $options->{payment_gateway}->gateway_password,
216 my ($self, $options) = @_;
218 $options->{payment_gateway}->gatewaynum
219 ? $options->{payment_gateway}->options
220 : @{ $options->{payment_gateway}->get('options') };
225 my ($self, $options) = @_;
227 unless ( $options->{'description'} ) {
228 if ( $conf->exists('business-onlinepayment-description') ) {
229 my $dtempl = $conf->config('business-onlinepayment-description');
231 my $agent = $self->agent->agent;
233 $options->{'description'} = eval qq("$dtempl");
235 $options->{'description'} = 'Internet services';
239 $options->{payinfo} = $self->payinfo unless exists( $options->{payinfo} );
241 # Default invoice number if the customer has exactly one open invoice.
242 if( ! $options->{'invnum'} ) {
243 $options->{'invnum'} = '';
244 my @open = $self->open_cust_bill;
245 $options->{'invnum'} = $open[0]->invnum if scalar(@open) == 1;
248 $options->{payname} = $self->payname unless exists( $options->{payname} );
252 my ($self, $options) = @_;
255 my $payip = exists($options->{'payip'}) ? $options->{'payip'} : $self->payip;
256 $content{customer_ip} = $payip if length($payip);
258 $content{invoice_number} = $options->{'invnum'}
259 if exists($options->{'invnum'}) && length($options->{'invnum'});
261 $content{email_customer} =
262 ( $conf->exists('business-onlinepayment-email_customer')
263 || $conf->exists('business-onlinepayment-email-override') );
265 my ($payname, $payfirst, $paylast);
266 if ( $options->{payname} && $options->{method} ne 'ECHECK' ) {
267 ($payname = $options->{payname}) =~
268 /^\s*([\w \,\.\-\']*)?\s+([\w\,\.\-\']+)\s*$/
269 or return "Illegal payname $payname";
270 ($payfirst, $paylast) = ($1, $2);
272 $payfirst = $self->getfield('first');
273 $paylast = $self->getfield('last');
274 $payname = "$payfirst $paylast";
277 $content{last_name} = $paylast;
278 $content{first_name} = $payfirst;
280 $content{name} = $payname;
282 $content{address} = exists($options->{'address1'})
283 ? $options->{'address1'}
285 my $address2 = exists($options->{'address2'})
286 ? $options->{'address2'}
288 $content{address} .= ", ". $address2 if length($address2);
290 $content{city} = exists($options->{city})
293 $content{state} = exists($options->{state})
296 $content{zip} = exists($options->{zip})
299 $content{country} = exists($options->{country})
300 ? $options->{country}
303 #3.0 is a good a time as any to get rid of this... add a config to pass it
304 # if anyone still needs it
305 #$content{referer} = 'http://cleanwhisker.420.am/';
307 $content{phone} = $self->daytime || $self->night;
309 my $currency = $conf->exists('business-onlinepayment-currency')
310 && $conf->config('business-onlinepayment-currency');
311 $content{currency} = $currency if $currency;
316 my %bop_method2payby = (
326 local($DEBUG) = $FS::cust_main::DEBUG if $FS::cust_main::DEBUG > $DEBUG;
329 if (ref($_[0]) eq 'HASH') {
332 my ( $method, $amount ) = ( shift, shift );
334 $options{method} = $method;
335 $options{amount} = $amount;
340 # optional credit card surcharge
343 my $cc_surcharge = 0;
344 my $cc_surcharge_pct = 0;
345 $cc_surcharge_pct = $conf->config('credit-card-surcharge-percentage')
346 if $conf->config('credit-card-surcharge-percentage')
347 && $options{method} eq 'CC';
349 # always add cc surcharge if called from event
350 if($options{'cc_surcharge_from_event'} && $cc_surcharge_pct > 0) {
351 $cc_surcharge = $options{'amount'} * $cc_surcharge_pct / 100;
352 $options{'amount'} += $cc_surcharge;
353 $options{'amount'} = sprintf("%.2f", $options{'amount'}); # round (again)?
355 elsif($cc_surcharge_pct > 0) { # we're called not from event (i.e. from a
356 # payment screen), so consider the given
357 # amount as post-surcharge
358 $cc_surcharge = $options{'amount'} - ($options{'amount'} / ( 1 + $cc_surcharge_pct/100 ));
361 $cc_surcharge = sprintf("%.2f",$cc_surcharge) if $cc_surcharge > 0;
362 $options{'cc_surcharge'} = $cc_surcharge;
366 warn "$me realtime_bop (new): $options{method} $options{amount}\n";
367 warn " cc_surcharge = $cc_surcharge\n";
370 warn " $_ => $options{$_}\n" foreach keys %options;
373 return $self->fake_bop(\%options) if $options{'fake'};
375 $self->_bop_defaults(\%options);
378 # set trans_is_recur based on invnum if there is one
381 my $trans_is_recur = 0;
382 if ( $options{'invnum'} ) {
384 my $cust_bill = qsearchs('cust_bill', { 'invnum' => $options{'invnum'} } );
385 die "invnum ". $options{'invnum'}. " not found" unless $cust_bill;
391 $cust_bill->cust_bill_pkg;
394 if grep { $_->freq ne '0' } @part_pkg;
402 my $payment_gateway = $self->_payment_gateway( \%options );
403 my $namespace = $payment_gateway->gateway_namespace;
405 eval "use $namespace";
409 # check for banned credit card/ACH
412 my $ban = FS::banned_pay->ban_search(
413 'payby' => $bop_method2payby{$options{method}},
414 'payinfo' => $options{payinfo},
416 return "Banned credit card" if $ban && $ban->bantype ne 'warn';
419 # check for term discount validity
422 my $discount_term = $options{discount_term};
423 if ( $discount_term ) {
424 my $bill = ($self->cust_bill)[-1]
425 or return "Can't apply a term discount to an unbilled customer";
426 my $plan = FS::discount_plan->new(
428 months => $discount_term
429 ) or return "No discount available for term '$discount_term'";
431 if ( $plan->discounted_total != $options{amount} ) {
432 return "Incorrect term prepayment amount (term $discount_term, amount $options{amount}, requires ".$plan->discounted_total.")";
440 my $bop_content = $self->_bop_content(\%options);
441 return $bop_content unless ref($bop_content);
443 my @invoicing_list = $self->invoicing_list_emailonly;
444 if ( $conf->exists('emailinvoiceautoalways')
445 || $conf->exists('emailinvoiceauto') && ! @invoicing_list
446 || ( $conf->exists('emailinvoiceonly') && ! @invoicing_list ) ) {
447 push @invoicing_list, $self->all_emails;
450 my $email = ($conf->exists('business-onlinepayment-email-override'))
451 ? $conf->config('business-onlinepayment-email-override')
452 : $invoicing_list[0];
457 if ( $namespace eq 'Business::OnlinePayment' ) {
459 if ( $options{method} eq 'CC' ) {
461 $content{card_number} = $options{payinfo};
462 $paydate = exists($options{'paydate'})
463 ? $options{'paydate'}
465 $paydate =~ /^\d{2}(\d{2})[\/\-](\d+)[\/\-]\d+$/;
466 $content{expiration} = "$2/$1";
468 my $paycvv = exists($options{'paycvv'})
471 $content{cvv2} = $paycvv
474 my $paystart_month = exists($options{'paystart_month'})
475 ? $options{'paystart_month'}
476 : $self->paystart_month;
478 my $paystart_year = exists($options{'paystart_year'})
479 ? $options{'paystart_year'}
480 : $self->paystart_year;
482 $content{card_start} = "$paystart_month/$paystart_year"
483 if $paystart_month && $paystart_year;
485 my $payissue = exists($options{'payissue'})
486 ? $options{'payissue'}
488 $content{issue_number} = $payissue if $payissue;
490 if ( $self->_bop_recurring_billing(
491 'payinfo' => $options{'payinfo'},
492 'trans_is_recur' => $trans_is_recur,
496 $content{recurring_billing} = 'YES';
497 $content{acct_code} = 'rebill'
498 if $conf->exists('credit_card-recurring_billing_acct_code');
501 } elsif ( $options{method} eq 'ECHECK' ){
503 ( $content{account_number}, $content{routing_code} ) =
504 split('@', $options{payinfo});
505 $content{bank_name} = $options{payname};
506 $content{bank_state} = exists($options{'paystate'})
507 ? $options{'paystate'}
508 : $self->getfield('paystate');
509 $content{account_type}=
510 (exists($options{'paytype'}) && $options{'paytype'})
511 ? uc($options{'paytype'})
512 : uc($self->getfield('paytype')) || 'PERSONAL CHECKING';
514 if ( $content{account_type} =~ /BUSINESS/i && $self->company ) {
515 $content{account_name} = $self->company;
517 $content{account_name} = $self->getfield('first'). ' '.
518 $self->getfield('last');
521 $content{customer_org} = $self->company ? 'B' : 'I';
522 $content{state_id} = exists($options{'stateid'})
523 ? $options{'stateid'}
524 : $self->getfield('stateid');
525 $content{state_id_state} = exists($options{'stateid_state'})
526 ? $options{'stateid_state'}
527 : $self->getfield('stateid_state');
528 $content{customer_ssn} = exists($options{'ss'})
532 } elsif ( $options{method} eq 'LEC' ) {
533 $content{phone} = $options{payinfo};
535 die "unknown method ". $options{method};
538 } elsif ( $namespace eq 'Business::OnlineThirdPartyPayment' ) {
541 die "unknown namespace $namespace";
548 my $balance = exists( $options{'balance'} )
549 ? $options{'balance'}
552 warn "claiming mutex on customer ". $self->custnum. "\n" if $DEBUG > 1;
553 $self->select_for_update; #mutex ... just until we get our pending record in
554 warn "obtained mutex on customer ". $self->custnum. "\n" if $DEBUG > 1;
556 #the checks here are intended to catch concurrent payments
557 #double-form-submission prevention is taken care of in cust_pay_pending::check
560 return "The customer's balance has changed; $options{method} transaction aborted."
561 if $self->balance < $balance;
563 #also check and make sure there aren't *other* pending payments for this cust
565 my @pending = qsearch('cust_pay_pending', {
566 'custnum' => $self->custnum,
567 'status' => { op=>'!=', value=>'done' }
570 #for third-party payments only, remove pending payments if they're in the
571 #'thirdparty' (waiting for customer action) state.
572 if ( $namespace eq 'Business::OnlineThirdPartyPayment' ) {
573 foreach ( grep { $_->status eq 'thirdparty' } @pending ) {
574 my $error = $_->delete;
575 warn "error deleting unfinished third-party payment ".
576 $_->paypendingnum . ": $error\n"
579 @pending = grep { $_->status ne 'thirdparty' } @pending;
582 return "A payment is already being processed for this customer (".
583 join(', ', map 'paypendingnum '. $_->paypendingnum, @pending ).
584 "); $options{method} transaction aborted."
587 #okay, good to go, if we're a duplicate, cust_pay_pending will kick us out
589 my $cust_pay_pending = new FS::cust_pay_pending {
590 'custnum' => $self->custnum,
591 'paid' => $options{amount},
593 'payby' => $bop_method2payby{$options{method}},
594 'payinfo' => $options{payinfo},
595 'paymask' => $options{paymask},
596 'paydate' => $paydate,
597 'recurring_billing' => $content{recurring_billing},
598 'pkgnum' => $options{'pkgnum'},
600 'gatewaynum' => $payment_gateway->gatewaynum || '',
601 'session_id' => $options{session_id} || '',
602 'jobnum' => $options{depend_jobnum} || '',
604 $cust_pay_pending->payunique( $options{payunique} )
605 if defined($options{payunique}) && length($options{payunique});
607 warn "inserting cust_pay_pending record for customer ". $self->custnum. "\n"
609 my $cpp_new_err = $cust_pay_pending->insert; #mutex lost when this is inserted
610 return $cpp_new_err if $cpp_new_err;
612 warn "inserted cust_pay_pending record for customer ". $self->custnum. "\n"
614 warn Dumper($cust_pay_pending) if $DEBUG > 2;
616 my( $action1, $action2 ) =
617 split( /\s*\,\s*/, $payment_gateway->gateway_action );
619 my $transaction = new $namespace( $payment_gateway->gateway_module,
620 $self->_bop_options(\%options),
623 $transaction->content(
624 'type' => $options{method},
625 $self->_bop_auth(\%options),
626 'action' => $action1,
627 'description' => $options{'description'},
628 'amount' => $options{amount},
629 #'invoice_number' => $options{'invnum'},
630 'customer_id' => $self->custnum,
632 'reference' => $cust_pay_pending->paypendingnum, #for now
633 'callback_url' => $payment_gateway->gateway_callback_url,
634 'cancel_url' => $payment_gateway->gateway_cancel_url,
639 $cust_pay_pending->status('pending');
640 my $cpp_pending_err = $cust_pay_pending->replace;
641 return $cpp_pending_err if $cpp_pending_err;
643 warn Dumper($transaction) if $DEBUG > 2;
645 unless ( $BOP_TESTING ) {
646 $transaction->test_transaction(1)
647 if $conf->exists('business-onlinepayment-test_transaction');
648 $transaction->submit();
650 if ( $BOP_TESTING_SUCCESS ) {
651 $transaction->is_success(1);
652 $transaction->authorization('fake auth');
654 $transaction->is_success(0);
655 $transaction->error_message('fake failure');
659 if ( $transaction->is_success() && $namespace eq 'Business::OnlineThirdPartyPayment' ) {
661 $cust_pay_pending->status('thirdparty');
662 my $cpp_err = $cust_pay_pending->replace;
663 return { error => $cpp_err } if $cpp_err;
664 return { reference => $cust_pay_pending->paypendingnum,
665 map { $_ => $transaction->$_ } qw ( popup_url collectitems ) };
667 } elsif ( $transaction->is_success() && $action2 ) {
669 $cust_pay_pending->status('authorized');
670 my $cpp_authorized_err = $cust_pay_pending->replace;
671 return $cpp_authorized_err if $cpp_authorized_err;
673 my $auth = $transaction->authorization;
674 my $ordernum = $transaction->can('order_number')
675 ? $transaction->order_number
679 new Business::OnlinePayment( $payment_gateway->gateway_module,
680 $self->_bop_options(\%options),
685 type => $options{method},
687 $self->_bop_auth(\%options),
688 order_number => $ordernum,
689 amount => $options{amount},
690 authorization => $auth,
691 description => $options{'description'},
694 foreach my $field (qw( authorization_source_code returned_ACI
695 transaction_identifier validation_code
696 transaction_sequence_num local_transaction_date
697 local_transaction_time AVS_result_code )) {
698 $capture{$field} = $transaction->$field() if $transaction->can($field);
701 $capture->content( %capture );
703 $capture->test_transaction(1)
704 if $conf->exists('business-onlinepayment-test_transaction');
707 unless ( $capture->is_success ) {
708 my $e = "Authorization successful but capture failed, custnum #".
709 $self->custnum. ': '. $capture->result_code.
710 ": ". $capture->error_message;
718 # remove paycvv after initial transaction
721 #false laziness w/misc/process/payment.cgi - check both to make sure working
723 if ( length($self->paycvv)
724 && ! grep { $_ eq cardtype($options{payinfo}) } $conf->config('cvv-save')
726 my $error = $self->remove_cvv;
728 warn "WARNING: error removing cvv: $error\n";
737 if ( $transaction->can('card_token') && $transaction->card_token ) {
739 if ( $options{'payinfo'} eq $self->payinfo ) {
740 $self->payinfo($transaction->card_token);
741 my $error = $self->replace;
743 warn "WARNING: error storing token: $error, but proceeding anyway\n";
753 $self->_realtime_bop_result( $cust_pay_pending, $transaction, %options );
765 if (ref($_[0]) eq 'HASH') {
768 my ( $method, $amount ) = ( shift, shift );
770 $options{method} = $method;
771 $options{amount} = $amount;
774 if ( $options{'fake_failure'} ) {
775 return "Error: No error; test failure requested with fake_failure";
778 my $cust_pay = new FS::cust_pay ( {
779 'custnum' => $self->custnum,
780 'invnum' => $options{'invnum'},
781 'paid' => $options{amount},
783 'payby' => $bop_method2payby{$options{method}},
784 #'payinfo' => $payinfo,
785 'payinfo' => '4111111111111111',
786 #'paydate' => $paydate,
787 'paydate' => '2012-05-01',
788 'processor' => 'FakeProcessor',
790 'order_number' => '32',
792 $cust_pay->payunique( $options{payunique} ) if length($options{payunique});
795 warn "fake_bop\n cust_pay: ". Dumper($cust_pay) . "\n options: ";
796 warn " $_ => $options{$_}\n" foreach keys %options;
799 my $error = $cust_pay->insert($options{'manual'} ? ( 'manual' => 1 ) : () );
802 $cust_pay->invnum(''); #try again with no specific invnum
803 my $error2 = $cust_pay->insert( $options{'manual'} ?
804 ( 'manual' => 1 ) : ()
807 # gah, even with transactions.
808 my $e = 'WARNING: Card/ACH debited but database not updated - '.
809 "error inserting (fake!) payment: $error2".
810 " (previously tried insert with invnum #$options{'invnum'}" .
817 if ( $options{'paynum_ref'} ) {
818 ${ $options{'paynum_ref'} } = $cust_pay->paynum;
826 # item _realtime_bop_result CUST_PAY_PENDING, BOP_OBJECT [ OPTION => VALUE ... ]
828 # Wraps up processing of a realtime credit card, ACH (electronic check) or
829 # phone bill transaction.
831 sub _realtime_bop_result {
832 my( $self, $cust_pay_pending, $transaction, %options ) = @_;
834 local($DEBUG) = $FS::cust_main::DEBUG if $FS::cust_main::DEBUG > $DEBUG;
837 warn "$me _realtime_bop_result: pending transaction ".
838 $cust_pay_pending->paypendingnum. "\n";
839 warn " $_ => $options{$_}\n" foreach keys %options;
842 my $payment_gateway = $options{payment_gateway}
843 or return "no payment gateway in arguments to _realtime_bop_result";
845 $cust_pay_pending->status($transaction->is_success() ? 'captured' : 'declined');
846 my $cpp_captured_err = $cust_pay_pending->replace;
847 return $cpp_captured_err if $cpp_captured_err;
849 if ( $transaction->is_success() ) {
851 my $order_number = $transaction->order_number
852 if $transaction->can('order_number');
854 my $cust_pay = new FS::cust_pay ( {
855 'custnum' => $self->custnum,
856 'invnum' => $options{'invnum'},
857 'paid' => $cust_pay_pending->paid,
859 'payby' => $cust_pay_pending->payby,
860 'payinfo' => $options{'payinfo'},
861 'paymask' => $options{'paymask'},
862 'paydate' => $cust_pay_pending->paydate,
863 'pkgnum' => $cust_pay_pending->pkgnum,
864 'discount_term' => $options{'discount_term'},
865 'gatewaynum' => ($payment_gateway->gatewaynum || ''),
866 'processor' => $payment_gateway->gateway_module,
867 'auth' => $transaction->authorization,
868 'order_number' => $order_number || '',
871 #doesn't hurt to know, even though the dup check is in cust_pay_pending now
872 $cust_pay->payunique( $options{payunique} )
873 if defined($options{payunique}) && length($options{payunique});
875 my $oldAutoCommit = $FS::UID::AutoCommit;
876 local $FS::UID::AutoCommit = 0;
879 #start a transaction, insert the cust_pay and set cust_pay_pending.status to done in a single transction
881 my $error = $cust_pay->insert($options{'manual'} ? ( 'manual' => 1 ) : () );
884 $dbh->rollback or die $dbh->errstr if $oldAutoCommit;
885 $cust_pay->invnum(''); #try again with no specific invnum
886 $cust_pay->paynum('');
887 my $error2 = $cust_pay->insert( $options{'manual'} ?
888 ( 'manual' => 1 ) : ()
891 # gah. but at least we have a record of the state we had to abort in
892 # from cust_pay_pending now.
893 $dbh->rollback or die $dbh->errstr if $oldAutoCommit;
894 my $e = "WARNING: $options{method} captured but payment not recorded -".
895 " error inserting payment (". $payment_gateway->gateway_module.
897 " (previously tried insert with invnum #$options{'invnum'}" .
898 ": $error ) - pending payment saved as paypendingnum ".
899 $cust_pay_pending->paypendingnum. "\n";
905 my $jobnum = $cust_pay_pending->jobnum;
907 my $placeholder = qsearchs( 'queue', { 'jobnum' => $jobnum } );
909 unless ( $placeholder ) {
910 $dbh->rollback or die $dbh->errstr if $oldAutoCommit;
911 my $e = "WARNING: $options{method} captured but job $jobnum not ".
912 "found for paypendingnum ". $cust_pay_pending->paypendingnum. "\n";
917 $error = $placeholder->delete;
920 $dbh->rollback or die $dbh->errstr if $oldAutoCommit;
921 my $e = "WARNING: $options{method} captured but could not delete ".
922 "job $jobnum for paypendingnum ".
923 $cust_pay_pending->paypendingnum. ": $error\n";
930 if ( $options{'paynum_ref'} ) {
931 ${ $options{'paynum_ref'} } = $cust_pay->paynum;
934 $cust_pay_pending->status('done');
935 $cust_pay_pending->statustext('captured');
936 $cust_pay_pending->paynum($cust_pay->paynum);
937 my $cpp_done_err = $cust_pay_pending->replace;
939 if ( $cpp_done_err ) {
941 $dbh->rollback or die $dbh->errstr if $oldAutoCommit;
942 my $e = "WARNING: $options{method} captured but payment not recorded - ".
943 "error updating status for paypendingnum ".
944 $cust_pay_pending->paypendingnum. ": $cpp_done_err \n";
950 $dbh->commit or die $dbh->errstr if $oldAutoCommit;
952 if ( $options{'apply'} ) {
953 my $apply_error = $self->apply_payments_and_credits;
954 if ( $apply_error ) {
955 warn "WARNING: error applying payment: $apply_error\n";
956 #but we still should return no error cause the payment otherwise went
961 # have a CC surcharge portion --> one-time charge
962 if ( $options{'cc_surcharge'} > 0 ) {
963 # XXX: this whole block needs to be in a transaction?
966 $invnum = $options{'invnum'} if $options{'invnum'};
967 unless ( $invnum ) { # probably from a payment screen
968 # do we have any open invoices? pick earliest
969 # uses the fact that cust_main->cust_bill sorts by date ascending
970 my @open = $self->open_cust_bill;
971 $invnum = $open[0]->invnum if scalar(@open);
974 unless ( $invnum ) { # still nothing? pick last closed invoice
975 # again uses fact that cust_main->cust_bill sorts by date ascending
976 my @closed = $self->cust_bill;
977 $invnum = $closed[$#closed]->invnum if scalar(@closed);
981 # XXX: unlikely case - pre-paying before any invoices generated
982 # what it should do is create a new invoice and pick it
983 warn 'CC SURCHARGE AND NO INVOICES PICKED TO APPLY IT!';
988 my $charge_error = $self->charge({
989 'amount' => $options{'cc_surcharge'},
990 'pkg' => 'Credit Card Surcharge',
992 'cust_pkg_ref' => \$cust_pkg,
995 warn 'Unable to add CC surcharge cust_pkg';
999 $cust_pkg->setup(time);
1000 my $cp_error = $cust_pkg->replace;
1002 warn 'Unable to set setup time on cust_pkg for cc surcharge';
1006 my $cust_bill = qsearchs('cust_bill', { 'invnum' => $invnum });
1007 unless ( $cust_bill ) {
1008 warn "race condition + invoice deletion just happened";
1013 $cust_bill->add_cc_surcharge($cust_pkg->pkgnum,$options{'cc_surcharge'});
1015 warn "cannot add CC surcharge to invoice #$invnum: $grand_error"
1019 return ''; #no error
1025 my $perror = $payment_gateway->gateway_module. " error: ".
1026 $transaction->error_message;
1028 my $jobnum = $cust_pay_pending->jobnum;
1030 my $placeholder = qsearchs( 'queue', { 'jobnum' => $jobnum } );
1032 if ( $placeholder ) {
1033 my $error = $placeholder->depended_delete;
1034 $error ||= $placeholder->delete;
1035 warn "error removing provisioning jobs after declined paypendingnum ".
1036 $cust_pay_pending->paypendingnum. ": $error\n";
1038 my $e = "error finding job $jobnum for declined paypendingnum ".
1039 $cust_pay_pending->paypendingnum. "\n";
1045 unless ( $transaction->error_message ) {
1048 if ( $transaction->can('response_page') ) {
1050 'page' => ( $transaction->can('response_page')
1051 ? $transaction->response_page
1054 'code' => ( $transaction->can('response_code')
1055 ? $transaction->response_code
1058 'headers' => ( $transaction->can('response_headers')
1059 ? $transaction->response_headers
1065 "No additional debugging information available for ".
1066 $payment_gateway->gateway_module;
1069 $perror .= "No error_message returned from ".
1070 $payment_gateway->gateway_module. " -- ".
1071 ( ref($t_response) ? Dumper($t_response) : $t_response );
1075 if ( !$options{'quiet'} && !$realtime_bop_decline_quiet
1076 && $conf->exists('emaildecline', $self->agentnum)
1077 && grep { $_ ne 'POST' } $self->invoicing_list
1078 && ! grep { $transaction->error_message =~ /$_/ }
1079 $conf->config('emaildecline-exclude', $self->agentnum)
1082 # Send a decline alert to the customer.
1083 my $msgnum = $conf->config('decline_msgnum', $self->agentnum);
1086 # include the raw error message in the transaction state
1087 $cust_pay_pending->setfield('error', $transaction->error_message);
1088 my $msg_template = qsearchs('msg_template', { msgnum => $msgnum });
1089 $error = $msg_template->send( 'cust_main' => $self,
1090 'object' => $cust_pay_pending );
1094 my @templ = $conf->config('declinetemplate');
1095 my $template = new Text::Template (
1097 SOURCE => [ map "$_\n", @templ ],
1098 ) or return "($perror) can't create template: $Text::Template::ERROR";
1099 $template->compile()
1100 or return "($perror) can't compile template: $Text::Template::ERROR";
1104 scalar( $conf->config('company_name', $self->agentnum ) ),
1105 'company_address' =>
1106 join("\n", $conf->config('company_address', $self->agentnum ) ),
1107 'error' => $transaction->error_message,
1110 my $error = send_email(
1111 'from' => $conf->invoice_from_full( $self->agentnum ),
1112 'to' => [ grep { $_ ne 'POST' } $self->invoicing_list ],
1113 'subject' => 'Your payment could not be processed',
1114 'body' => [ $template->fill_in(HASH => $templ_hash) ],
1118 $perror .= " (also received error sending decline notification: $error)"
1123 $cust_pay_pending->status('done');
1124 $cust_pay_pending->statustext("declined: $perror");
1125 my $cpp_done_err = $cust_pay_pending->replace;
1126 if ( $cpp_done_err ) {
1127 my $e = "WARNING: $options{method} declined but pending payment not ".
1128 "resolved - error updating status for paypendingnum ".
1129 $cust_pay_pending->paypendingnum. ": $cpp_done_err \n";
1131 $perror = "$e ($perror)";
1139 =item realtime_botpp_capture CUST_PAY_PENDING [ OPTION => VALUE ... ]
1141 Verifies successful third party processing of a realtime credit card,
1142 ACH (electronic check) or phone bill transaction via a
1143 Business::OnlineThirdPartyPayment realtime gateway. See
1144 L<http://420.am/business-onlinethirdpartypayment> for supported gateways.
1146 Available options are: I<description>, I<invnum>, I<quiet>, I<paynum_ref>, I<payunique>
1148 The additional options I<payname>, I<city>, I<state>,
1149 I<zip>, I<payinfo> and I<paydate> are also available. Any of these options,
1150 if set, will override the value from the customer record.
1152 I<description> is a free-text field passed to the gateway. It defaults to
1153 "Internet services".
1155 If an I<invnum> is specified, this payment (if successful) is applied to the
1156 specified invoice. If you don't specify an I<invnum> you might want to
1157 call the B<apply_payments> method.
1159 I<quiet> can be set true to surpress email decline notices.
1161 I<paynum_ref> can be set to a scalar reference. It will be filled in with the
1162 resulting paynum, if any.
1164 I<payunique> is a unique identifier for this payment.
1166 Returns a hashref containing elements bill_error (which will be undefined
1167 upon success) and session_id of any associated session.
1171 sub realtime_botpp_capture {
1172 my( $self, $cust_pay_pending, %options ) = @_;
1174 local($DEBUG) = $FS::cust_main::DEBUG if $FS::cust_main::DEBUG > $DEBUG;
1177 warn "$me realtime_botpp_capture: pending transaction $cust_pay_pending\n";
1178 warn " $_ => $options{$_}\n" foreach keys %options;
1181 eval "use Business::OnlineThirdPartyPayment";
1185 # select the gateway
1188 my $method = FS::payby->payby2bop($cust_pay_pending->payby);
1190 my $payment_gateway;
1191 my $gatewaynum = $cust_pay_pending->getfield('gatewaynum');
1192 $payment_gateway = $gatewaynum ? qsearchs( 'payment_gateway',
1193 { gatewaynum => $gatewaynum }
1195 : $self->agent->payment_gateway( 'method' => $method,
1196 # 'invnum' => $cust_pay_pending->invnum,
1197 # 'payinfo' => $cust_pay_pending->payinfo,
1200 $options{payment_gateway} = $payment_gateway; # for the helper subs
1206 my @invoicing_list = $self->invoicing_list_emailonly;
1207 if ( $conf->exists('emailinvoiceautoalways')
1208 || $conf->exists('emailinvoiceauto') && ! @invoicing_list
1209 || ( $conf->exists('emailinvoiceonly') && ! @invoicing_list ) ) {
1210 push @invoicing_list, $self->all_emails;
1213 my $email = ($conf->exists('business-onlinepayment-email-override'))
1214 ? $conf->config('business-onlinepayment-email-override')
1215 : $invoicing_list[0];
1219 $content{email_customer} =
1220 ( $conf->exists('business-onlinepayment-email_customer')
1221 || $conf->exists('business-onlinepayment-email-override') );
1224 # run transaction(s)
1228 new Business::OnlineThirdPartyPayment( $payment_gateway->gateway_module,
1229 $self->_bop_options(\%options),
1232 $transaction->reference({ %options });
1234 $transaction->content(
1236 $self->_bop_auth(\%options),
1237 'action' => 'Post Authorization',
1238 'description' => $options{'description'},
1239 'amount' => $cust_pay_pending->paid,
1240 #'invoice_number' => $options{'invnum'},
1241 'customer_id' => $self->custnum,
1243 #3.0 is a good a time as any to get rid of this... add a config to pass it
1244 # if anyone still needs it
1245 #'referer' => 'http://cleanwhisker.420.am/',
1247 'reference' => $cust_pay_pending->paypendingnum,
1249 'phone' => $self->daytime || $self->night,
1251 # plus whatever is required for bogus capture avoidance
1254 $transaction->submit();
1257 $self->_realtime_bop_result( $cust_pay_pending, $transaction, %options );
1259 if ( $options{'apply'} ) {
1260 my $apply_error = $self->apply_payments_and_credits;
1261 if ( $apply_error ) {
1262 warn "WARNING: error applying payment: $apply_error\n";
1267 bill_error => $error,
1268 session_id => $cust_pay_pending->session_id,
1273 =item default_payment_gateway
1275 DEPRECATED -- use agent->payment_gateway
1279 sub default_payment_gateway {
1280 my( $self, $method ) = @_;
1282 die "Real-time processing not enabled\n"
1283 unless $conf->exists('business-onlinepayment');
1285 #warn "default_payment_gateway deprecated -- use agent->payment_gateway\n";
1288 my $bop_config = 'business-onlinepayment';
1289 $bop_config .= '-ach'
1290 if $method =~ /^(ECHECK|CHEK)$/ && $conf->exists($bop_config. '-ach');
1291 my ( $processor, $login, $password, $action, @bop_options ) =
1292 $conf->config($bop_config);
1293 $action ||= 'normal authorization';
1294 pop @bop_options if scalar(@bop_options) % 2 && $bop_options[-1] =~ /^\s*$/;
1295 die "No real-time processor is enabled - ".
1296 "did you set the business-onlinepayment configuration value?\n"
1299 ( $processor, $login, $password, $action, @bop_options )
1302 =item realtime_refund_bop METHOD [ OPTION => VALUE ... ]
1304 Refunds a realtime credit card, ACH (electronic check) or phone bill transaction
1305 via a Business::OnlinePayment realtime gateway. See
1306 L<http://420.am/business-onlinepayment> for supported gateways.
1308 Available methods are: I<CC>, I<ECHECK> and I<LEC>
1310 Available options are: I<amount>, I<reason>, I<paynum>, I<paydate>
1312 Most gateways require a reference to an original payment transaction to refund,
1313 so you probably need to specify a I<paynum>.
1315 I<amount> defaults to the original amount of the payment if not specified.
1317 I<reason> specifies a reason for the refund.
1319 I<paydate> specifies the expiration date for a credit card overriding the
1320 value from the customer record or the payment record. Specified as yyyy-mm-dd
1322 Implementation note: If I<amount> is unspecified or equal to the amount of the
1323 orignal payment, first an attempt is made to "void" the transaction via
1324 the gateway (to cancel a not-yet settled transaction) and then if that fails,
1325 the normal attempt is made to "refund" ("credit") the transaction via the
1326 gateway is attempted. No attempt to "void" the transaction is made if the
1327 gateway has introspection data and doesn't support void.
1329 #The additional options I<payname>, I<address1>, I<address2>, I<city>, I<state>,
1330 #I<zip>, I<payinfo> and I<paydate> are also available. Any of these options,
1331 #if set, will override the value from the customer record.
1333 #If an I<invnum> is specified, this payment (if successful) is applied to the
1334 #specified invoice. If you don't specify an I<invnum> you might want to
1335 #call the B<apply_payments> method.
1339 #some false laziness w/realtime_bop, not enough to make it worth merging
1340 #but some useful small subs should be pulled out
1341 sub realtime_refund_bop {
1344 local($DEBUG) = $FS::cust_main::DEBUG if $FS::cust_main::DEBUG > $DEBUG;
1347 if (ref($_[0]) eq 'HASH') {
1348 %options = %{$_[0]};
1352 $options{method} = $method;
1356 warn "$me realtime_refund_bop (new): $options{method} refund\n";
1357 warn " $_ => $options{$_}\n" foreach keys %options;
1361 # look up the original payment and optionally a gateway for that payment
1365 my $amount = $options{'amount'};
1367 my( $processor, $login, $password, @bop_options, $namespace ) ;
1368 my( $auth, $order_number ) = ( '', '', '' );
1369 my $gatewaynum = '';
1371 if ( $options{'paynum'} ) {
1373 warn " paynum: $options{paynum}\n" if $DEBUG > 1;
1374 $cust_pay = qsearchs('cust_pay', { paynum=>$options{'paynum'} } )
1375 or return "Unknown paynum $options{'paynum'}";
1376 $amount ||= $cust_pay->paid;
1378 if ( $cust_pay->get('processor') ) {
1379 ($gatewaynum, $processor, $auth, $order_number) =
1381 $cust_pay->gatewaynum,
1382 $cust_pay->processor,
1384 $cust_pay->order_number,
1387 # this payment wasn't upgraded, which probably means this won't work,
1389 $cust_pay->paybatch =~ /^((\d+)\-)?(\w+):\s*([\w\-\/ ]*)(:([\w\-]+))?$/
1390 or return "Can't parse paybatch for paynum $options{'paynum'}: ".
1391 $cust_pay->paybatch;
1392 ( $gatewaynum, $processor, $auth, $order_number ) = ( $2, $3, $4, $6 );
1395 if ( $gatewaynum ) { #gateway for the payment to be refunded
1397 my $payment_gateway =
1398 qsearchs('payment_gateway', { 'gatewaynum' => $gatewaynum } );
1399 die "payment gateway $gatewaynum not found"
1400 unless $payment_gateway;
1402 $processor = $payment_gateway->gateway_module;
1403 $login = $payment_gateway->gateway_username;
1404 $password = $payment_gateway->gateway_password;
1405 $namespace = $payment_gateway->gateway_namespace;
1406 @bop_options = $payment_gateway->options;
1408 } else { #try the default gateway
1411 my $payment_gateway =
1412 $self->agent->payment_gateway('method' => $options{method});
1414 ( $conf_processor, $login, $password, $namespace ) =
1415 map { my $method = "gateway_$_"; $payment_gateway->$method }
1416 qw( module username password namespace );
1418 @bop_options = $payment_gateway->gatewaynum
1419 ? $payment_gateway->options
1420 : @{ $payment_gateway->get('options') };
1422 return "processor of payment $options{'paynum'} $processor does not".
1423 " match default processor $conf_processor"
1424 unless $processor eq $conf_processor;
1429 } else { # didn't specify a paynum, so look for agent gateway overrides
1430 # like a normal transaction
1432 my $payment_gateway =
1433 $self->agent->payment_gateway( 'method' => $options{method},
1434 #'payinfo' => $payinfo,
1436 my( $processor, $login, $password, $namespace ) =
1437 map { my $method = "gateway_$_"; $payment_gateway->$method }
1438 qw( module username password namespace );
1440 my @bop_options = $payment_gateway->gatewaynum
1441 ? $payment_gateway->options
1442 : @{ $payment_gateway->get('options') };
1445 return "neither amount nor paynum specified" unless $amount;
1447 eval "use $namespace";
1451 'type' => $options{method},
1453 'password' => $password,
1454 'order_number' => $order_number,
1455 'amount' => $amount,
1457 #3.0 is a good a time as any to get rid of this... add a config to pass it
1458 # if anyone still needs it
1459 #'referer' => 'http://cleanwhisker.420.am/',
1461 $content{authorization} = $auth
1462 if length($auth); #echeck/ACH transactions have an order # but no auth
1463 #(at least with authorize.net)
1465 my $currency = $conf->exists('business-onlinepayment-currency')
1466 && $conf->config('business-onlinepayment-currency');
1467 $content{currency} = $currency if $currency;
1469 my $disable_void_after;
1470 if ($conf->exists('disable_void_after')
1471 && $conf->config('disable_void_after') =~ /^(\d+)$/) {
1472 $disable_void_after = $1;
1475 #first try void if applicable
1476 my $void = new Business::OnlinePayment( $processor, @bop_options );
1479 if ($void->can('info')) {
1481 $paytype = 'ECHECK' if $cust_pay && $cust_pay->payby eq 'CHEK';
1482 $paytype = 'CC' if $cust_pay && $cust_pay->payby eq 'CARD';
1483 my %supported_actions = $void->info('supported_actions');
1485 if ( %supported_actions && $paytype
1486 && defined($supported_actions{$paytype})
1487 && !grep{ $_ eq 'Void' } @{$supported_actions{$paytype}} );
1490 if ( $cust_pay && $cust_pay->paid == $amount
1492 ( not defined($disable_void_after) )
1493 || ( time < ($cust_pay->_date + $disable_void_after ) )
1497 warn " attempting void\n" if $DEBUG > 1;
1498 if ( $void->can('info') ) {
1499 if ( $cust_pay->payby eq 'CARD'
1500 && $void->info('CC_void_requires_card') )
1502 $content{'card_number'} = $cust_pay->payinfo;
1503 } elsif ( $cust_pay->payby eq 'CHEK'
1504 && $void->info('ECHECK_void_requires_account') )
1506 ( $content{'account_number'}, $content{'routing_code'} ) =
1507 split('@', $cust_pay->payinfo);
1508 $content{'name'} = $self->get('first'). ' '. $self->get('last');
1511 $void->content( 'action' => 'void', %content );
1512 $void->test_transaction(1)
1513 if $conf->exists('business-onlinepayment-test_transaction');
1515 if ( $void->is_success ) {
1516 my $error = $cust_pay->void($options{'reason'});
1518 # gah, even with transactions.
1519 my $e = 'WARNING: Card/ACH voided but database not updated - '.
1520 "error voiding payment: $error";
1524 warn " void successful\n" if $DEBUG > 1;
1529 warn " void unsuccessful, trying refund\n"
1533 my $address = $self->address1;
1534 $address .= ", ". $self->address2 if $self->address2;
1536 my($payname, $payfirst, $paylast);
1537 if ( $self->payname && $options{method} ne 'ECHECK' ) {
1538 $payname = $self->payname;
1539 $payname =~ /^\s*([\w \,\.\-\']*)?\s+([\w\,\.\-\']+)\s*$/
1540 or return "Illegal payname $payname";
1541 ($payfirst, $paylast) = ($1, $2);
1543 $payfirst = $self->getfield('first');
1544 $paylast = $self->getfield('last');
1545 $payname = "$payfirst $paylast";
1548 my @invoicing_list = $self->invoicing_list_emailonly;
1549 if ( $conf->exists('emailinvoiceautoalways')
1550 || $conf->exists('emailinvoiceauto') && ! @invoicing_list
1551 || ( $conf->exists('emailinvoiceonly') && ! @invoicing_list ) ) {
1552 push @invoicing_list, $self->all_emails;
1555 my $email = ($conf->exists('business-onlinepayment-email-override'))
1556 ? $conf->config('business-onlinepayment-email-override')
1557 : $invoicing_list[0];
1559 my $payip = exists($options{'payip'})
1562 $content{customer_ip} = $payip
1566 if ( $options{method} eq 'CC' ) {
1569 $content{card_number} = $payinfo = $cust_pay->payinfo;
1570 (exists($options{'paydate'}) ? $options{'paydate'} : $cust_pay->paydate)
1571 =~ /^\d{2}(\d{2})[\/\-](\d+)[\/\-]\d+$/ &&
1572 ($content{expiration} = "$2/$1"); # where available
1574 $content{card_number} = $payinfo = $self->payinfo;
1575 (exists($options{'paydate'}) ? $options{'paydate'} : $self->paydate)
1576 =~ /^\d{2}(\d{2})[\/\-](\d+)[\/\-]\d+$/;
1577 $content{expiration} = "$2/$1";
1580 } elsif ( $options{method} eq 'ECHECK' ) {
1583 $payinfo = $cust_pay->payinfo;
1585 $payinfo = $self->payinfo;
1587 ( $content{account_number}, $content{routing_code} )= split('@', $payinfo );
1588 $content{bank_name} = $self->payname;
1589 $content{account_type} = 'CHECKING';
1590 $content{account_name} = $payname;
1591 $content{customer_org} = $self->company ? 'B' : 'I';
1592 $content{customer_ssn} = $self->ss;
1593 } elsif ( $options{method} eq 'LEC' ) {
1594 $content{phone} = $payinfo = $self->payinfo;
1598 my $refund = new Business::OnlinePayment( $processor, @bop_options );
1599 my %sub_content = $refund->content(
1600 'action' => 'credit',
1601 'customer_id' => $self->custnum,
1602 'last_name' => $paylast,
1603 'first_name' => $payfirst,
1605 'address' => $address,
1606 'city' => $self->city,
1607 'state' => $self->state,
1608 'zip' => $self->zip,
1609 'country' => $self->country,
1611 'phone' => $self->daytime || $self->night,
1614 warn join('', map { " $_ => $sub_content{$_}\n" } keys %sub_content )
1616 $refund->test_transaction(1)
1617 if $conf->exists('business-onlinepayment-test_transaction');
1620 return "$processor error: ". $refund->error_message
1621 unless $refund->is_success();
1623 $order_number = $refund->order_number if $refund->can('order_number');
1625 # change this to just use $cust_pay->delete_cust_bill_pay?
1626 while ( $cust_pay && $cust_pay->unapplied < $amount ) {
1627 my @cust_bill_pay = $cust_pay->cust_bill_pay;
1628 last unless @cust_bill_pay;
1629 my $cust_bill_pay = pop @cust_bill_pay;
1630 my $error = $cust_bill_pay->delete;
1634 my $cust_refund = new FS::cust_refund ( {
1635 'custnum' => $self->custnum,
1636 'paynum' => $options{'paynum'},
1637 'refund' => $amount,
1639 'payby' => $bop_method2payby{$options{method}},
1640 'payinfo' => $payinfo,
1641 'reason' => $options{'reason'} || 'card or ACH refund',
1642 'gatewaynum' => $gatewaynum, # may be null
1643 'processor' => $processor,
1644 'auth' => $refund->authorization,
1645 'order_number' => $order_number,
1647 my $error = $cust_refund->insert;
1649 $cust_refund->paynum(''); #try again with no specific paynum
1650 my $error2 = $cust_refund->insert;
1652 # gah, even with transactions.
1653 my $e = 'WARNING: Card/ACH refunded but database not updated - '.
1654 "error inserting refund ($processor): $error2".
1655 " (previously tried insert with paynum #$options{'paynum'}" .
1674 L<FS::cust_main>, L<FS::cust_main::Billing>