4 use vars qw( @ISA $conf $Debug $import );
7 use Time::Local qw(timelocal_nocheck);
10 use Business::CreditCard;
11 use FS::UID qw( getotaker dbh );
12 use FS::Record qw( qsearchs qsearch dbdef );
15 use FS::cust_bill_pkg;
18 use FS::part_referral;
19 use FS::cust_main_county;
21 use FS::cust_main_invoice;
22 use FS::cust_credit_bill;
23 use FS::cust_bill_pay;
24 use FS::prepay_credit;
27 use FS::part_bill_event;
28 use FS::cust_bill_event;
29 use FS::cust_tax_exempt;
31 use FS::Msgcat qw(gettext);
33 @ISA = qw( FS::Record );
40 #ask FS::UID to run this stuff for us later
41 $FS::UID::callback{'FS::cust_main'} = sub {
43 #yes, need it for stuff below (prolly should be cached)
48 my ( $hashref, $cache ) = @_;
49 if ( exists $hashref->{'pkgnum'} ) {
50 # #@{ $self->{'_pkgnum'} } = ();
51 my $subcache = $cache->subcache( 'pkgnum', 'cust_pkg', $hashref->{custnum});
52 $self->{'_pkgnum'} = $subcache;
53 #push @{ $self->{'_pkgnum'} },
54 FS::cust_pkg->new_or_cached($hashref, $subcache) if $hashref->{pkgnum};
60 FS::cust_main - Object methods for cust_main records
66 $record = new FS::cust_main \%hash;
67 $record = new FS::cust_main { 'column' => 'value' };
69 $error = $record->insert;
71 $error = $new_record->replace($old_record);
73 $error = $record->delete;
75 $error = $record->check;
77 @cust_pkg = $record->all_pkgs;
79 @cust_pkg = $record->ncancelled_pkgs;
81 @cust_pkg = $record->suspended_pkgs;
83 $error = $record->bill;
84 $error = $record->bill %options;
85 $error = $record->bill 'time' => $time;
87 $error = $record->collect;
88 $error = $record->collect %options;
89 $error = $record->collect 'invoice_time' => $time,
90 'batch_card' => 'yes',
91 'report_badcard' => 'yes',
96 An FS::cust_main object represents a customer. FS::cust_main inherits from
97 FS::Record. The following fields are currently supported:
101 =item custnum - primary key (assigned automatically for new customers)
103 =item agentnum - agent (see L<FS::agent>)
105 =item refnum - Advertising source (see L<FS::part_referral>)
111 =item ss - social security number (optional)
113 =item company - (optional)
117 =item address2 - (optional)
121 =item county - (optional, see L<FS::cust_main_county>)
123 =item state - (see L<FS::cust_main_county>)
127 =item country - (see L<FS::cust_main_county>)
129 =item daytime - phone (optional)
131 =item night - phone (optional)
133 =item fax - phone (optional)
135 =item ship_first - name
137 =item ship_last - name
139 =item ship_company - (optional)
143 =item ship_address2 - (optional)
147 =item ship_county - (optional, see L<FS::cust_main_county>)
149 =item ship_state - (see L<FS::cust_main_county>)
153 =item ship_country - (see L<FS::cust_main_county>)
155 =item ship_daytime - phone (optional)
157 =item ship_night - phone (optional)
159 =item ship_fax - phone (optional)
161 =item payby - `CARD' (credit cards), `CHEK' (electronic check), `LECB' (Phone bill billing), `BILL' (billing), `COMP' (free), or `PREPAY' (special billing type: applies a credit - see L<FS::prepay_credit> and sets billing type to BILL)
163 =item payinfo - card number, P.O., comp issuer (4-8 lowercase alphanumerics; think username) or prepayment identifier (see L<FS::prepay_credit>)
165 =item paydate - expiration date, mm/yyyy, m/yyyy, mm/yy or m/yy
167 =item payname - name on card or billing name
169 =item tax - tax exempt, empty or `Y'
171 =item otaker - order taker (assigned automatically, see L<FS::UID>)
173 =item comments - comments (optional)
183 Creates a new customer. To add the customer to the database, see L<"insert">.
185 Note that this stores the hash reference, not a distinct copy of the hash it
186 points to. You can ask the object for a copy with the I<hash> method.
190 sub table { 'cust_main'; }
192 =item insert [ CUST_PKG_HASHREF [ , INVOICING_LIST_ARYREF ] ]
194 Adds this customer to the database. If there is an error, returns the error,
195 otherwise returns false.
197 CUST_PKG_HASHREF: If you pass a Tie::RefHash data structure to the insert
198 method containing FS::cust_pkg and FS::svc_I<tablename> objects, all records
199 are inserted atomicly, or the transaction is rolled back. Passing an empty
200 hash reference is equivalent to not supplying this parameter. There should be
201 a better explanation of this, but until then, here's an example:
204 tie %hash, 'Tie::RefHash'; #this part is important
206 $cust_pkg => [ $svc_acct ],
209 $cust_main->insert( \%hash );
211 INVOICING_LIST_ARYREF: If you pass an arrarref to the insert method, it will
212 be set as the invoicing list (see L<"invoicing_list">). Errors return as
213 expected and rollback the entire transaction; it is not necessary to call
214 check_invoicing_list first. The invoicing_list is set after the records in the
215 CUST_PKG_HASHREF above are inserted, so it is now possible to set an
216 invoicing_list destination to the newly-created svc_acct. Here's an example:
218 $cust_main->insert( {}, [ $email, 'POST' ] );
224 my $cust_pkgs = @_ ? shift : {};
225 my $invoicing_list = @_ ? shift : '';
227 local $SIG{HUP} = 'IGNORE';
228 local $SIG{INT} = 'IGNORE';
229 local $SIG{QUIT} = 'IGNORE';
230 local $SIG{TERM} = 'IGNORE';
231 local $SIG{TSTP} = 'IGNORE';
232 local $SIG{PIPE} = 'IGNORE';
234 my $oldAutoCommit = $FS::UID::AutoCommit;
235 local $FS::UID::AutoCommit = 0;
240 if ( $self->payby eq 'PREPAY' ) {
241 $self->payby('BILL');
242 my $prepay_credit = qsearchs(
244 { 'identifier' => $self->payinfo },
248 warn "WARNING: can't find pre-found prepay_credit: ". $self->payinfo
249 unless $prepay_credit;
250 $amount = $prepay_credit->amount;
251 $seconds = $prepay_credit->seconds;
252 my $error = $prepay_credit->delete;
254 $dbh->rollback if $oldAutoCommit;
255 return "removing prepay_credit (transaction rolled back): $error";
259 my $error = $self->SUPER::insert;
261 $dbh->rollback if $oldAutoCommit;
262 #return "inserting cust_main record (transaction rolled back): $error";
267 if ( $invoicing_list ) {
268 $error = $self->check_invoicing_list( $invoicing_list );
270 $dbh->rollback if $oldAutoCommit;
271 return "checking invoicing_list (transaction rolled back): $error";
273 $self->invoicing_list( $invoicing_list );
277 foreach my $cust_pkg ( keys %$cust_pkgs ) {
278 $cust_pkg->custnum( $self->custnum );
279 $error = $cust_pkg->insert;
281 $dbh->rollback if $oldAutoCommit;
282 return "inserting cust_pkg (transaction rolled back): $error";
284 foreach my $svc_something ( @{$cust_pkgs->{$cust_pkg}} ) {
285 $svc_something->pkgnum( $cust_pkg->pkgnum );
286 if ( $seconds && $svc_something->isa('FS::svc_acct') ) {
287 $svc_something->seconds( $svc_something->seconds + $seconds );
290 $error = $svc_something->insert;
292 $dbh->rollback if $oldAutoCommit;
293 #return "inserting svc_ (transaction rolled back): $error";
300 $dbh->rollback if $oldAutoCommit;
301 return "No svc_acct record to apply pre-paid time";
305 my $cust_credit = new FS::cust_credit {
306 'custnum' => $self->custnum,
309 $error = $cust_credit->insert;
311 $dbh->rollback if $oldAutoCommit;
312 return "inserting credit (transaction rolled back): $error";
316 #false laziness with sub replace
317 my $queue = new FS::queue { 'job' => 'FS::cust_main::append_fuzzyfiles' };
318 $error = $queue->insert($self->getfield('last'), $self->company);
320 $dbh->rollback if $oldAutoCommit;
321 return "queueing job (transaction rolled back): $error";
324 if ( defined $self->dbdef_table->column('ship_last') && $self->ship_last ) {
325 $queue = new FS::queue { 'job' => 'FS::cust_main::append_fuzzyfiles' };
326 $error = $queue->insert($self->getfield('last'), $self->company);
328 $dbh->rollback if $oldAutoCommit;
329 return "queueing job (transaction rolled back): $error";
334 $dbh->commit or die $dbh->errstr if $oldAutoCommit;
339 =item delete NEW_CUSTNUM
341 This deletes the customer. If there is an error, returns the error, otherwise
344 This will completely remove all traces of the customer record. This is not
345 what you want when a customer cancels service; for that, cancel all of the
346 customer's packages (see L<FS::cust_pkg/cancel>).
348 If the customer has any uncancelled packages, you need to pass a new (valid)
349 customer number for those packages to be transferred to. Cancelled packages
350 will be deleted. Did I mention that this is NOT what you want when a customer
351 cancels service and that you really should be looking see L<FS::cust_pkg/cancel>?
353 You can't delete a customer with invoices (see L<FS::cust_bill>),
354 or credits (see L<FS::cust_credit>), payments (see L<FS::cust_pay>) or
355 refunds (see L<FS::cust_refund>).
362 local $SIG{HUP} = 'IGNORE';
363 local $SIG{INT} = 'IGNORE';
364 local $SIG{QUIT} = 'IGNORE';
365 local $SIG{TERM} = 'IGNORE';
366 local $SIG{TSTP} = 'IGNORE';
367 local $SIG{PIPE} = 'IGNORE';
369 my $oldAutoCommit = $FS::UID::AutoCommit;
370 local $FS::UID::AutoCommit = 0;
373 if ( qsearch( 'cust_bill', { 'custnum' => $self->custnum } ) ) {
374 $dbh->rollback if $oldAutoCommit;
375 return "Can't delete a customer with invoices";
377 if ( qsearch( 'cust_credit', { 'custnum' => $self->custnum } ) ) {
378 $dbh->rollback if $oldAutoCommit;
379 return "Can't delete a customer with credits";
381 if ( qsearch( 'cust_pay', { 'custnum' => $self->custnum } ) ) {
382 $dbh->rollback if $oldAutoCommit;
383 return "Can't delete a customer with payments";
385 if ( qsearch( 'cust_refund', { 'custnum' => $self->custnum } ) ) {
386 $dbh->rollback if $oldAutoCommit;
387 return "Can't delete a customer with refunds";
390 my @cust_pkg = $self->ncancelled_pkgs;
392 my $new_custnum = shift;
393 unless ( qsearchs( 'cust_main', { 'custnum' => $new_custnum } ) ) {
394 $dbh->rollback if $oldAutoCommit;
395 return "Invalid new customer number: $new_custnum";
397 foreach my $cust_pkg ( @cust_pkg ) {
398 my %hash = $cust_pkg->hash;
399 $hash{'custnum'} = $new_custnum;
400 my $new_cust_pkg = new FS::cust_pkg ( \%hash );
401 my $error = $new_cust_pkg->replace($cust_pkg);
403 $dbh->rollback if $oldAutoCommit;
408 my @cancelled_cust_pkg = $self->all_pkgs;
409 foreach my $cust_pkg ( @cancelled_cust_pkg ) {
410 my $error = $cust_pkg->delete;
412 $dbh->rollback if $oldAutoCommit;
417 foreach my $cust_main_invoice ( #(email invoice destinations, not invoices)
418 qsearch( 'cust_main_invoice', { 'custnum' => $self->custnum } )
420 my $error = $cust_main_invoice->delete;
422 $dbh->rollback if $oldAutoCommit;
427 my $error = $self->SUPER::delete;
429 $dbh->rollback if $oldAutoCommit;
433 $dbh->commit or die $dbh->errstr if $oldAutoCommit;
438 =item replace OLD_RECORD [ INVOICING_LIST_ARYREF ]
440 Replaces the OLD_RECORD with this one in the database. If there is an error,
441 returns the error, otherwise returns false.
443 INVOICING_LIST_ARYREF: If you pass an arrarref to the insert method, it will
444 be set as the invoicing list (see L<"invoicing_list">). Errors return as
445 expected and rollback the entire transaction; it is not necessary to call
446 check_invoicing_list first. Here's an example:
448 $new_cust_main->replace( $old_cust_main, [ $email, 'POST' ] );
457 local $SIG{HUP} = 'IGNORE';
458 local $SIG{INT} = 'IGNORE';
459 local $SIG{QUIT} = 'IGNORE';
460 local $SIG{TERM} = 'IGNORE';
461 local $SIG{TSTP} = 'IGNORE';
462 local $SIG{PIPE} = 'IGNORE';
464 my $oldAutoCommit = $FS::UID::AutoCommit;
465 local $FS::UID::AutoCommit = 0;
468 my $error = $self->SUPER::replace($old);
471 $dbh->rollback if $oldAutoCommit;
475 if ( @param ) { # INVOICING_LIST_ARYREF
476 my $invoicing_list = shift @param;
477 $error = $self->check_invoicing_list( $invoicing_list );
479 $dbh->rollback if $oldAutoCommit;
482 $self->invoicing_list( $invoicing_list );
485 if ( $self->payby =~ /^(CARD|CHEK|LECB)$/ &&
486 grep { $self->get($_) ne $old->get($_) } qw(payinfo paydate payname) ) {
487 # card info has changed, want to retry realtime_card invoice events
488 #false laziness w/collect
489 foreach my $cust_bill_event (
491 #$_->part_bill_event->plan eq 'realtime-card'
492 $_->part_bill_event->eventcode =~
493 /^\$cust_bill\->realtime_(card|ach|lec)\(\);$/
494 && $_->status eq 'done'
497 map { $_->cust_bill_event }
498 grep { $_->cust_bill_event }
499 $self->open_cust_bill
502 my $error = $cust_bill_event->retry;
504 $dbh->rollback if $oldAutoCommit;
505 return "error scheduling invoice events for retry: $error";
512 #false laziness with sub insert
513 my $queue = new FS::queue { 'job' => 'FS::cust_main::append_fuzzyfiles' };
514 $error = $queue->insert($self->getfield('last'), $self->company);
516 $dbh->rollback if $oldAutoCommit;
517 return "queueing job (transaction rolled back): $error";
520 if ( defined $self->dbdef_table->column('ship_last') && $self->ship_last ) {
521 $queue = new FS::queue { 'job' => 'FS::cust_main::append_fuzzyfiles' };
522 $error = $queue->insert($self->getfield('last'), $self->company);
524 $dbh->rollback if $oldAutoCommit;
525 return "queueing job (transaction rolled back): $error";
530 $dbh->commit or die $dbh->errstr if $oldAutoCommit;
537 Checks all fields to make sure this is a valid customer record. If there is
538 an error, returns the error, otherwise returns false. Called by the insert
546 #warn "BEFORE: \n". $self->_dump;
549 $self->ut_numbern('custnum')
550 || $self->ut_number('agentnum')
551 || $self->ut_number('refnum')
552 || $self->ut_name('last')
553 || $self->ut_name('first')
554 || $self->ut_textn('company')
555 || $self->ut_text('address1')
556 || $self->ut_textn('address2')
557 || $self->ut_text('city')
558 || $self->ut_textn('county')
559 || $self->ut_textn('state')
560 || $self->ut_country('country')
561 || $self->ut_anything('comments')
562 || $self->ut_numbern('referral_custnum')
564 #barf. need message catalogs. i18n. etc.
565 $error .= "Please select a advertising source."
566 if $error =~ /^Illegal or empty \(numeric\) refnum: /;
567 return $error if $error;
569 return "Unknown agent"
570 unless qsearchs( 'agent', { 'agentnum' => $self->agentnum } );
572 return "Unknown refnum"
573 unless qsearchs( 'part_referral', { 'refnum' => $self->refnum } );
575 return "Unknown referring custnum ". $self->referral_custnum
576 unless ! $self->referral_custnum
577 || qsearchs( 'cust_main', { 'custnum' => $self->referral_custnum } );
579 if ( $self->ss eq '' ) {
584 $ss =~ /^(\d{3})(\d{2})(\d{4})$/
585 or return "Illegal social security number: ". $self->ss;
586 $self->ss("$1-$2-$3");
590 # bad idea to disable, causes billing to fail because of no tax rates later
591 # unless ( $import ) {
592 unless ( qsearch('cust_main_county', {
593 'country' => $self->country,
596 return "Unknown state/county/country: ".
597 $self->state. "/". $self->county. "/". $self->country
598 unless qsearch('cust_main_county',{
599 'state' => $self->state,
600 'county' => $self->county,
601 'country' => $self->country,
607 $self->ut_phonen('daytime', $self->country)
608 || $self->ut_phonen('night', $self->country)
609 || $self->ut_phonen('fax', $self->country)
610 || $self->ut_zip('zip', $self->country)
612 return $error if $error;
615 last first company address1 address2 city county state zip
616 country daytime night fax
619 if ( defined $self->dbdef_table->column('ship_last') ) {
620 if ( scalar ( grep { $self->getfield($_) ne $self->getfield("ship_$_") }
622 && scalar ( grep { $self->getfield("ship_$_") ne '' } @addfields )
626 $self->ut_name('ship_last')
627 || $self->ut_name('ship_first')
628 || $self->ut_textn('ship_company')
629 || $self->ut_text('ship_address1')
630 || $self->ut_textn('ship_address2')
631 || $self->ut_text('ship_city')
632 || $self->ut_textn('ship_county')
633 || $self->ut_textn('ship_state')
634 || $self->ut_country('ship_country')
636 return $error if $error;
638 #false laziness with above
639 unless ( qsearchs('cust_main_county', {
640 'country' => $self->ship_country,
643 return "Unknown ship_state/ship_county/ship_country: ".
644 $self->ship_state. "/". $self->ship_county. "/". $self->ship_country
645 unless qsearchs('cust_main_county',{
646 'state' => $self->ship_state,
647 'county' => $self->ship_county,
648 'country' => $self->ship_country,
654 $self->ut_phonen('ship_daytime', $self->ship_country)
655 || $self->ut_phonen('ship_night', $self->ship_country)
656 || $self->ut_phonen('ship_fax', $self->ship_country)
657 || $self->ut_zip('ship_zip', $self->ship_country)
659 return $error if $error;
661 } else { # ship_ info eq billing info, so don't store dup info in database
662 $self->setfield("ship_$_", '')
663 foreach qw( last first company address1 address2 city county state zip
664 country daytime night fax );
668 $self->payby =~ /^(CARD|CHEK|LECB|BILL|COMP|PREPAY)$/
669 or return "Illegal payby: ". $self->payby;
672 if ( $self->payby eq 'CARD' ) {
674 my $payinfo = $self->payinfo;
676 $payinfo =~ /^(\d{13,16})$/
677 or return gettext('invalid_card'); # . ": ". $self->payinfo;
679 $self->payinfo($payinfo);
681 or return gettext('invalid_card'); # . ": ". $self->payinfo;
682 return gettext('unknown_card_type')
683 if cardtype($self->payinfo) eq "Unknown";
685 } elsif ( $self->payby eq 'CHEK' ) {
687 my $payinfo = $self->payinfo;
688 $payinfo =~ s/[^\d\@]//g;
689 $payinfo =~ /^(\d+)\@(\d{9})$/ or return 'invalid echeck account@aba';
691 $self->payinfo($payinfo);
693 } elsif ( $self->payby eq 'LECB' ) {
695 my $payinfo = $self->payinfo;
697 $payinfo =~ /^1?(\d{10})$/ or return 'invalid btn billing telephone number';
699 $self->payinfo($payinfo);
701 } elsif ( $self->payby eq 'BILL' ) {
703 $error = $self->ut_textn('payinfo');
704 return "Illegal P.O. number: ". $self->payinfo if $error;
706 } elsif ( $self->payby eq 'COMP' ) {
708 $error = $self->ut_textn('payinfo');
709 return "Illegal comp account issuer: ". $self->payinfo if $error;
711 } elsif ( $self->payby eq 'PREPAY' ) {
713 my $payinfo = $self->payinfo;
714 $payinfo =~ s/\W//g; #anything else would just confuse things
715 $self->payinfo($payinfo);
716 $error = $self->ut_alpha('payinfo');
717 return "Illegal prepayment identifier: ". $self->payinfo if $error;
718 return "Unknown prepayment identifier"
719 unless qsearchs('prepay_credit', { 'identifier' => $self->payinfo } );
723 if ( $self->paydate eq '' || $self->paydate eq '-' ) {
724 return "Expriation date required"
725 unless $self->payby =~ /^(BILL|PREPAY|CHEK|LECB)$/;
728 $self->paydate =~ /^(\d{1,2})[\/\-](\d{2}(\d{2})?)$/
729 or return "Illegal expiration date: ". $self->paydate;
730 my $y = length($2) == 4 ? $2 : "20$2";
731 $self->paydate("$y-$1-01");
732 my($nowm,$nowy)=(localtime(time))[4,5]; $nowm++; $nowy+=1900;
733 return gettext('expired_card')
734 if !$import && ( $y<$nowy || ( $y==$nowy && $1<$nowm ) );
737 if ( $self->payname eq '' && $self->payby ne 'CHEK' &&
738 ( ! $conf->exists('require_cardname') || $self->payby ne 'CARD' ) ) {
739 $self->payname( $self->first. " ". $self->getfield('last') );
741 $self->payname =~ /^([\w \,\.\-\']+)$/
742 or return gettext('illegal_name'). " payname: ". $self->payname;
746 $self->tax =~ /^(Y?)$/ or return "Illegal tax: ". $self->tax;
749 $self->otaker(getotaker);
751 #warn "AFTER: \n". $self->_dump;
758 Returns all packages (see L<FS::cust_pkg>) for this customer.
764 if ( $self->{'_pkgnum'} ) {
765 values %{ $self->{'_pkgnum'}->cache };
767 qsearch( 'cust_pkg', { 'custnum' => $self->custnum });
771 =item ncancelled_pkgs
773 Returns all non-cancelled packages (see L<FS::cust_pkg>) for this customer.
777 sub ncancelled_pkgs {
779 if ( $self->{'_pkgnum'} ) {
780 grep { ! $_->getfield('cancel') } values %{ $self->{'_pkgnum'}->cache };
782 @{ [ # force list context
783 qsearch( 'cust_pkg', {
784 'custnum' => $self->custnum,
787 qsearch( 'cust_pkg', {
788 'custnum' => $self->custnum,
797 Returns all suspended packages (see L<FS::cust_pkg>) for this customer.
803 grep { $_->susp } $self->ncancelled_pkgs;
806 =item unflagged_suspended_pkgs
808 Returns all unflagged suspended packages (see L<FS::cust_pkg>) for this
809 customer (thouse packages without the `manual_flag' set).
813 sub unflagged_suspended_pkgs {
815 return $self->suspended_pkgs
816 unless dbdef->table('cust_pkg')->column('manual_flag');
817 grep { ! $_->manual_flag } $self->suspended_pkgs;
820 =item unsuspended_pkgs
822 Returns all unsuspended (and uncancelled) packages (see L<FS::cust_pkg>) for
827 sub unsuspended_pkgs {
829 grep { ! $_->susp } $self->ncancelled_pkgs;
834 Unsuspends all unflagged suspended packages (see L</unflagged_suspended_pkgs>
835 and L<FS::cust_pkg>) for this customer. Always returns a list: an empty list
836 on success or a list of errors.
842 grep { $_->unsuspend } $self->suspended_pkgs;
847 Suspends all unsuspended packages (see L<FS::cust_pkg>) for this customer.
848 Always returns a list: an empty list on success or a list of errors.
854 grep { $_->suspend } $self->unsuspended_pkgs;
859 Cancels all uncancelled packages (see L<FS::cust_pkg>) for this customer.
860 Always returns a list: an empty list on success or a list of errors.
866 grep { $_->cancel } $self->ncancelled_pkgs;
871 Returns the agent (see L<FS::agent>) for this customer.
877 qsearchs( 'agent', { 'agentnum' => $self->agentnum } );
882 Generates invoices (see L<FS::cust_bill>) for this customer. Usually used in
883 conjunction with the collect method.
885 Options are passed as name-value pairs.
887 The only currently available option is `time', which bills the customer as if
888 it were that time. It is specified as a UNIX timestamp; see
889 L<perlfunc/"time">). Also see L<Time::Local> and L<Date::Parse> for conversion
890 functions. For example:
894 $cust_main->bill( 'time' => str2time('April 20th, 2001') );
896 If there is an error, returns the error, otherwise returns false.
901 my( $self, %options ) = @_;
902 my $time = $options{'time'} || time;
907 local $SIG{HUP} = 'IGNORE';
908 local $SIG{INT} = 'IGNORE';
909 local $SIG{QUIT} = 'IGNORE';
910 local $SIG{TERM} = 'IGNORE';
911 local $SIG{TSTP} = 'IGNORE';
912 local $SIG{PIPE} = 'IGNORE';
914 my $oldAutoCommit = $FS::UID::AutoCommit;
915 local $FS::UID::AutoCommit = 0;
918 # find the packages which are due for billing, find out how much they are
919 # & generate invoice database.
921 my( $total_setup, $total_recur ) = ( 0, 0 );
922 #my( $taxable_setup, $taxable_recur ) = ( 0, 0 );
923 my @cust_bill_pkg = ();
925 #my $taxable_charged = 0;##
928 foreach my $cust_pkg (
929 qsearch('cust_pkg', { 'custnum' => $self->custnum } )
932 #NO!! next if $cust_pkg->cancel;
933 next if $cust_pkg->getfield('cancel');
935 #? to avoid use of uninitialized value errors... ?
936 $cust_pkg->setfield('bill', '')
937 unless defined($cust_pkg->bill);
939 my $part_pkg = $cust_pkg->part_pkg;
941 #so we don't modify cust_pkg record unnecessarily
942 my $cust_pkg_mod_flag = 0;
943 my %hash = $cust_pkg->hash;
944 my $old_cust_pkg = new FS::cust_pkg \%hash;
948 unless ( $cust_pkg->setup ) {
949 my $setup_prog = $part_pkg->getfield('setup');
950 $setup_prog =~ /^(.*)$/ or do {
951 $dbh->rollback if $oldAutoCommit;
952 return "Illegal setup for pkgpart ". $part_pkg->pkgpart.
956 $setup_prog = '0' if $setup_prog =~ /^\s*$/;
959 ##$cpt->permit(); #what is necessary?
960 #$cpt->share(qw( $cust_pkg )); #can $cpt now use $cust_pkg methods?
961 #$setup = $cpt->reval($setup_prog);
962 $setup = eval $setup_prog;
963 unless ( defined($setup) ) {
964 $dbh->rollback if $oldAutoCommit;
965 return "Error eval-ing part_pkg->setup pkgpart ". $part_pkg->pkgpart.
966 "(expression $setup_prog): $@";
968 $cust_pkg->setfield('setup',$time);
969 $cust_pkg_mod_flag=1;
975 if ( $part_pkg->getfield('freq') > 0 &&
976 ! $cust_pkg->getfield('susp') &&
977 ( $cust_pkg->getfield('bill') || 0 ) <= $time
979 my $recur_prog = $part_pkg->getfield('recur');
980 $recur_prog =~ /^(.*)$/ or do {
981 $dbh->rollback if $oldAutoCommit;
982 return "Illegal recur for pkgpart ". $part_pkg->pkgpart.
986 $recur_prog = '0' if $recur_prog =~ /^\s*$/;
988 # shared with $recur_prog
989 $sdate = $cust_pkg->bill || $cust_pkg->setup || $time;
992 ##$cpt->permit(); #what is necessary?
993 #$cpt->share(qw( $cust_pkg )); #can $cpt now use $cust_pkg methods?
994 #$recur = $cpt->reval($recur_prog);
995 $recur = eval $recur_prog;
996 unless ( defined($recur) ) {
997 $dbh->rollback if $oldAutoCommit;
998 return "Error eval-ing part_pkg->recur pkgpart ". $part_pkg->pkgpart.
999 "(expression $recur_prog): $@";
1001 #change this bit to use Date::Manip? CAREFUL with timezones (see
1002 # mailing list archive)
1003 my ($sec,$min,$hour,$mday,$mon,$year) =
1004 (localtime($sdate) )[0,1,2,3,4,5];
1006 #pro-rating magic - if $recur_prog fiddles $sdate, want to use that
1007 # only for figuring next bill date, nothing else, so, reset $sdate again
1009 $sdate = $cust_pkg->bill || $cust_pkg->setup || $time;
1010 $cust_pkg->last_bill($sdate)
1011 if $cust_pkg->dbdef_table->column('last_bill');
1013 $mon += $part_pkg->freq;
1014 until ( $mon < 12 ) { $mon -= 12; $year++; }
1015 $cust_pkg->setfield('bill',
1016 timelocal_nocheck($sec,$min,$hour,$mday,$mon,$year));
1017 $cust_pkg_mod_flag = 1;
1020 warn "\$setup is undefined" unless defined($setup);
1021 warn "\$recur is undefined" unless defined($recur);
1022 warn "\$cust_pkg->bill is undefined" unless defined($cust_pkg->bill);
1024 my $taxable_charged = 0;
1025 if ( $cust_pkg_mod_flag ) {
1026 $error=$cust_pkg->replace($old_cust_pkg);
1027 if ( $error ) { #just in case
1028 $dbh->rollback if $oldAutoCommit;
1029 return "Error modifying pkgnum ". $cust_pkg->pkgnum. ": $error";
1031 $setup = sprintf( "%.2f", $setup );
1032 $recur = sprintf( "%.2f", $recur );
1034 $dbh->rollback if $oldAutoCommit;
1035 return "negative setup $setup for pkgnum ". $cust_pkg->pkgnum;
1038 $dbh->rollback if $oldAutoCommit;
1039 return "negative recur $recur for pkgnum ". $cust_pkg->pkgnum;
1041 if ( $setup > 0 || $recur > 0 ) {
1042 my $cust_bill_pkg = new FS::cust_bill_pkg ({
1043 'pkgnum' => $cust_pkg->pkgnum,
1047 'edate' => $cust_pkg->bill,
1049 push @cust_bill_pkg, $cust_bill_pkg;
1050 $total_setup += $setup;
1051 $total_recur += $recur;
1052 $taxable_charged += $setup
1053 unless $part_pkg->setuptax =~ /^Y$/i;
1054 $taxable_charged += $recur
1055 unless $part_pkg->recurtax =~ /^Y$/i;
1057 unless ( $self->tax =~ /Y/i
1058 || $self->payby eq 'COMP'
1059 || $taxable_charged == 0 ) {
1061 my $cust_main_county = qsearchs('cust_main_county',{
1062 'state' => $self->state,
1063 'county' => $self->county,
1064 'country' => $self->country,
1065 'taxclass' => $part_pkg->taxclass,
1067 $cust_main_county ||= qsearchs('cust_main_county',{
1068 'state' => $self->state,
1069 'county' => $self->county,
1070 'country' => $self->country,
1073 unless ( $cust_main_county ) {
1074 $dbh->rollback if $oldAutoCommit;
1076 "fatal: can't find tax rate for state/county/country/taxclass ".
1077 join('/', ( map $self->$_(), qw(state county country) ),
1078 $part_pkg->taxclass ). "\n";
1081 if ( $cust_main_county->exempt_amount ) {
1082 my ($mon,$year) = (localtime($sdate) )[4,5];
1084 my $freq = $part_pkg->freq || 1;
1085 my $taxable_per_month = sprintf("%.2f", $taxable_charged / $freq );
1086 foreach my $which_month ( 1 .. $freq ) {
1088 'custnum' => $self->custnum,
1089 'taxnum' => $cust_main_county->taxnum,
1090 'year' => 1900+$year,
1093 #until ( $mon < 12 ) { $mon -= 12; $year++; }
1094 until ( $mon < 13 ) { $mon -= 12; $year++; }
1095 my $cust_tax_exempt =
1096 qsearchs('cust_tax_exempt', \%hash)
1097 || new FS::cust_tax_exempt( { %hash, 'amount' => 0 } );
1098 my $remaining_exemption = sprintf("%.2f",
1099 $cust_main_county->exempt_amount - $cust_tax_exempt->amount );
1100 if ( $remaining_exemption > 0 ) {
1101 my $addl = $remaining_exemption > $taxable_per_month
1102 ? $taxable_per_month
1103 : $remaining_exemption;
1104 $taxable_charged -= $addl;
1105 my $new_cust_tax_exempt = new FS::cust_tax_exempt ( {
1106 $cust_tax_exempt->hash,
1107 'amount' => sprintf("%.2f", $cust_tax_exempt->amount + $addl),
1109 $error = $new_cust_tax_exempt->exemptnum
1110 ? $new_cust_tax_exempt->replace($cust_tax_exempt)
1111 : $new_cust_tax_exempt->insert;
1113 $dbh->rollback if $oldAutoCommit;
1114 return "fatal: can't update cust_tax_exempt: $error";
1117 } # if $remaining_exemption > 0
1119 } #foreach $which_month
1121 } #if $cust_main_county->exempt_amount
1123 $taxable_charged = sprintf( "%.2f", $taxable_charged);
1124 $tax += $taxable_charged * $cust_main_county->tax / 100
1126 } #unless $self->tax =~ /Y/i
1127 # || $self->payby eq 'COMP'
1128 # || $taxable_charged == 0
1130 } #if $setup > 0 || $recur > 0
1132 } #if $cust_pkg_mod_flag
1134 } #foreach my $cust_pkg
1136 my $charged = sprintf( "%.2f", $total_setup + $total_recur );
1137 # my $taxable_charged = sprintf( "%.2f", $taxable_setup + $taxable_recur );
1139 unless ( @cust_bill_pkg ) { #don't create invoices with no line items
1140 $dbh->commit or die $dbh->errstr if $oldAutoCommit;
1144 # unless ( $self->tax =~ /Y/i
1145 # || $self->payby eq 'COMP'
1146 # || $taxable_charged == 0 ) {
1147 # my $cust_main_county = qsearchs('cust_main_county',{
1148 # 'state' => $self->state,
1149 # 'county' => $self->county,
1150 # 'country' => $self->country,
1151 # } ) or die "fatal: can't find tax rate for state/county/country ".
1152 # $self->state. "/". $self->county. "/". $self->country. "\n";
1153 # my $tax = sprintf( "%.2f",
1154 # $taxable_charged * ( $cust_main_county->getfield('tax') / 100 )
1157 $tax = sprintf("%.2f", $tax);
1159 $charged = sprintf( "%.2f", $charged+$tax );
1161 my $cust_bill_pkg = new FS::cust_bill_pkg ({
1168 push @cust_bill_pkg, $cust_bill_pkg;
1172 my $cust_bill = new FS::cust_bill ( {
1173 'custnum' => $self->custnum,
1175 'charged' => $charged,
1177 $error = $cust_bill->insert;
1179 $dbh->rollback if $oldAutoCommit;
1180 return "can't create invoice for customer #". $self->custnum. ": $error";
1183 my $invnum = $cust_bill->invnum;
1185 foreach $cust_bill_pkg ( @cust_bill_pkg ) {
1187 $cust_bill_pkg->invnum($invnum);
1188 $error = $cust_bill_pkg->insert;
1190 $dbh->rollback if $oldAutoCommit;
1191 return "can't create invoice line item for customer #". $self->custnum.
1196 $dbh->commit or die $dbh->errstr if $oldAutoCommit;
1200 =item collect OPTIONS
1202 (Attempt to) collect money for this customer's outstanding invoices (see
1203 L<FS::cust_bill>). Usually used after the bill method.
1205 Depending on the value of `payby', this may print an invoice (`BILL'), charge
1206 a credit card (`CARD'), or just add any necessary (pseudo-)payment (`COMP').
1208 Most actions are now triggered by invoice events; see L<FS::part_bill_event>
1209 and the invoice events web interface.
1211 If there is an error, returns the error, otherwise returns false.
1213 Options are passed as name-value pairs.
1215 Currently available options are:
1217 invoice_time - Use this time when deciding when to print invoices and
1218 late notices on those invoices. The default is now. It is specified as a UNIX timestamp; see L<perlfunc/"time">). Also see L<Time::Local> and L<Date::Parse>
1219 for conversion functions.
1221 retry_card - Retry cards even when not scheduled by invoice events.
1223 batch_card - This option is deprecated. See the invoice events web interface
1224 to control whether cards are batched or run against a realtime gateway.
1226 report_badcard - This option is deprecated.
1228 force_print - This option is deprecated; see the invoice events web interface.
1233 my( $self, %options ) = @_;
1234 my $invoice_time = $options{'invoice_time'} || time;
1237 local $SIG{HUP} = 'IGNORE';
1238 local $SIG{INT} = 'IGNORE';
1239 local $SIG{QUIT} = 'IGNORE';
1240 local $SIG{TERM} = 'IGNORE';
1241 local $SIG{TSTP} = 'IGNORE';
1242 local $SIG{PIPE} = 'IGNORE';
1244 my $oldAutoCommit = $FS::UID::AutoCommit;
1245 local $FS::UID::AutoCommit = 0;
1248 my $balance = $self->balance;
1249 warn "collect customer". $self->custnum. ": balance $balance" if $Debug;
1250 unless ( $balance > 0 ) { #redundant?????
1251 $dbh->rollback if $oldAutoCommit; #hmm
1255 if ( exists($options{'retry_card'}) && $options{'retry_card'} ) {
1256 #false laziness w/replace
1257 foreach my $cust_bill_event (
1259 #$_->part_bill_event->plan eq 'realtime-card'
1260 $_->part_bill_event->eventcode eq '$cust_bill->realtime_card();'
1261 && $_->status eq 'done'
1264 map { $_->cust_bill_event }
1265 grep { $_->cust_bill_event }
1266 $self->open_cust_bill
1268 my $error = $cust_bill_event->retry;
1270 $dbh->rollback if $oldAutoCommit;
1271 return "error scheduling invoice events for retry: $error";
1277 foreach my $cust_bill ( $self->cust_bill ) {
1279 #this has to be before next's
1280 my $amount = sprintf( "%.2f", $balance < $cust_bill->owed
1284 $balance = sprintf( "%.2f", $balance - $amount );
1286 next unless $cust_bill->owed > 0;
1288 # don't try to charge for the same invoice if it's already in a batch
1289 #next if qsearchs( 'cust_pay_batch', { 'invnum' => $cust_bill->invnum } );
1291 warn "invnum ". $cust_bill->invnum. " (owed ". $cust_bill->owed. ", amount $amount, balance $balance)" if $Debug;
1293 next unless $amount > 0;
1296 foreach my $part_bill_event (
1297 sort { $a->seconds <=> $b->seconds
1298 || $a->weight <=> $b->weight
1299 || $a->eventpart <=> $b->eventpart }
1300 grep { $_->seconds <= ( $invoice_time - $cust_bill->_date )
1301 && ! qsearchs( 'cust_bill_event', {
1302 'invnum' => $cust_bill->invnum,
1303 'eventpart' => $_->eventpart,
1307 qsearch('part_bill_event', { 'payby' => $self->payby,
1308 'disabled' => '', } )
1311 last unless $cust_bill->owed > 0; #don't run subsequent events if owed=0
1313 warn "calling invoice event (". $part_bill_event->eventcode. ")\n"
1315 my $cust_main = $self; #for callback
1316 my $error = eval $part_bill_event->eventcode;
1319 my $statustext = '';
1323 } elsif ( $error ) {
1325 $statustext = $error;
1330 #add cust_bill_event
1331 my $cust_bill_event = new FS::cust_bill_event {
1332 'invnum' => $cust_bill->invnum,
1333 'eventpart' => $part_bill_event->eventpart,
1334 #'_date' => $invoice_time,
1336 'status' => $status,
1337 'statustext' => $statustext,
1339 $error = $cust_bill_event->insert;
1341 #$dbh->rollback if $oldAutoCommit;
1342 #return "error: $error";
1344 # gah, even with transactions.
1345 $dbh->commit if $oldAutoCommit; #well.
1346 my $e = 'WARNING: Event run but database not updated - '.
1347 'error inserting cust_bill_event, invnum #'. $cust_bill->invnum.
1348 ', eventpart '. $part_bill_event->eventpart.
1359 $dbh->commit or die $dbh->errstr if $oldAutoCommit;
1366 Returns the total owed for this customer on all invoices
1367 (see L<FS::cust_bill/owed>).
1373 $self->total_owed_date(2145859200); #12/31/2037
1376 =item total_owed_date TIME
1378 Returns the total owed for this customer on all invoices with date earlier than
1379 TIME. TIME is specified as a UNIX timestamp; see L<perlfunc/"time">). Also
1380 see L<Time::Local> and L<Date::Parse> for conversion functions.
1384 sub total_owed_date {
1388 foreach my $cust_bill (
1389 grep { $_->_date <= $time }
1390 qsearch('cust_bill', { 'custnum' => $self->custnum, } )
1392 $total_bill += $cust_bill->owed;
1394 sprintf( "%.2f", $total_bill );
1399 Applies (see L<FS::cust_credit_bill>) unapplied credits (see L<FS::cust_credit>)
1400 to outstanding invoice balances in chronological order and returns the value
1401 of any remaining unapplied credits available for refund
1402 (see L<FS::cust_refund>).
1409 return 0 unless $self->total_credited;
1411 my @credits = sort { $b->_date <=> $a->_date} (grep { $_->credited > 0 }
1412 qsearch('cust_credit', { 'custnum' => $self->custnum } ) );
1414 my @invoices = sort { $a->_date <=> $b->_date} (grep { $_->owed > 0 }
1415 qsearch('cust_bill', { 'custnum' => $self->custnum } ) );
1419 foreach my $cust_bill ( @invoices ) {
1422 if ( !defined($credit) || $credit->credited == 0) {
1423 $credit = pop @credits or last;
1426 if ($cust_bill->owed >= $credit->credited) {
1427 $amount=$credit->credited;
1429 $amount=$cust_bill->owed;
1432 my $cust_credit_bill = new FS::cust_credit_bill ( {
1433 'crednum' => $credit->crednum,
1434 'invnum' => $cust_bill->invnum,
1435 'amount' => $amount,
1437 my $error = $cust_credit_bill->insert;
1438 die $error if $error;
1440 redo if ($cust_bill->owed > 0);
1444 return $self->total_credited;
1447 =item apply_payments
1449 Applies (see L<FS::cust_bill_pay>) unapplied payments (see L<FS::cust_pay>)
1450 to outstanding invoice balances in chronological order.
1452 #and returns the value of any remaining unapplied payments.
1456 sub apply_payments {
1461 my @payments = sort { $b->_date <=> $a->_date } ( grep { $_->unapplied > 0 }
1462 qsearch('cust_pay', { 'custnum' => $self->custnum } ) );
1464 my @invoices = sort { $a->_date <=> $b->_date} (grep { $_->owed > 0 }
1465 qsearch('cust_bill', { 'custnum' => $self->custnum } ) );
1469 foreach my $cust_bill ( @invoices ) {
1472 if ( !defined($payment) || $payment->unapplied == 0 ) {
1473 $payment = pop @payments or last;
1476 if ( $cust_bill->owed >= $payment->unapplied ) {
1477 $amount = $payment->unapplied;
1479 $amount = $cust_bill->owed;
1482 my $cust_bill_pay = new FS::cust_bill_pay ( {
1483 'paynum' => $payment->paynum,
1484 'invnum' => $cust_bill->invnum,
1485 'amount' => $amount,
1487 my $error = $cust_bill_pay->insert;
1488 die $error if $error;
1490 redo if ( $cust_bill->owed > 0);
1494 return $self->total_unapplied_payments;
1497 =item total_credited
1499 Returns the total outstanding credit (see L<FS::cust_credit>) for this
1500 customer. See L<FS::cust_credit/credited>.
1504 sub total_credited {
1506 my $total_credit = 0;
1507 foreach my $cust_credit ( qsearch('cust_credit', {
1508 'custnum' => $self->custnum,
1510 $total_credit += $cust_credit->credited;
1512 sprintf( "%.2f", $total_credit );
1515 =item total_unapplied_payments
1517 Returns the total unapplied payments (see L<FS::cust_pay>) for this customer.
1518 See L<FS::cust_pay/unapplied>.
1522 sub total_unapplied_payments {
1524 my $total_unapplied = 0;
1525 foreach my $cust_pay ( qsearch('cust_pay', {
1526 'custnum' => $self->custnum,
1528 $total_unapplied += $cust_pay->unapplied;
1530 sprintf( "%.2f", $total_unapplied );
1535 Returns the balance for this customer (total_owed minus total_credited
1536 minus total_unapplied_payments).
1543 $self->total_owed - $self->total_credited - $self->total_unapplied_payments
1547 =item balance_date TIME
1549 Returns the balance for this customer, only considering invoices with date
1550 earlier than TIME (total_owed_date minus total_credited minus
1551 total_unapplied_payments). TIME is specified as a UNIX timestamp; see
1552 L<perlfunc/"time">). Also see L<Time::Local> and L<Date::Parse> for conversion
1561 $self->total_owed_date($time)
1562 - $self->total_credited
1563 - $self->total_unapplied_payments
1567 =item invoicing_list [ ARRAYREF ]
1569 If an arguement is given, sets these email addresses as invoice recipients
1570 (see L<FS::cust_main_invoice>). Errors are not fatal and are not reported
1571 (except as warnings), so use check_invoicing_list first.
1573 Returns a list of email addresses (with svcnum entries expanded).
1575 Note: You can clear the invoicing list by passing an empty ARRAYREF. You can
1576 check it without disturbing anything by passing nothing.
1578 This interface may change in the future.
1582 sub invoicing_list {
1583 my( $self, $arrayref ) = @_;
1585 my @cust_main_invoice;
1586 if ( $self->custnum ) {
1587 @cust_main_invoice =
1588 qsearch( 'cust_main_invoice', { 'custnum' => $self->custnum } );
1590 @cust_main_invoice = ();
1592 foreach my $cust_main_invoice ( @cust_main_invoice ) {
1593 #warn $cust_main_invoice->destnum;
1594 unless ( grep { $cust_main_invoice->address eq $_ } @{$arrayref} ) {
1595 #warn $cust_main_invoice->destnum;
1596 my $error = $cust_main_invoice->delete;
1597 warn $error if $error;
1600 if ( $self->custnum ) {
1601 @cust_main_invoice =
1602 qsearch( 'cust_main_invoice', { 'custnum' => $self->custnum } );
1604 @cust_main_invoice = ();
1606 my %seen = map { $_->address => 1 } @cust_main_invoice;
1607 foreach my $address ( @{$arrayref} ) {
1608 next if exists $seen{$address} && $seen{$address};
1609 $seen{$address} = 1;
1610 my $cust_main_invoice = new FS::cust_main_invoice ( {
1611 'custnum' => $self->custnum,
1614 my $error = $cust_main_invoice->insert;
1615 warn $error if $error;
1618 if ( $self->custnum ) {
1620 qsearch( 'cust_main_invoice', { 'custnum' => $self->custnum } );
1626 =item check_invoicing_list ARRAYREF
1628 Checks these arguements as valid input for the invoicing_list method. If there
1629 is an error, returns the error, otherwise returns false.
1633 sub check_invoicing_list {
1634 my( $self, $arrayref ) = @_;
1635 foreach my $address ( @{$arrayref} ) {
1636 my $cust_main_invoice = new FS::cust_main_invoice ( {
1637 'custnum' => $self->custnum,
1640 my $error = $self->custnum
1641 ? $cust_main_invoice->check
1642 : $cust_main_invoice->checkdest
1644 return $error if $error;
1649 =item set_default_invoicing_list
1651 Sets the invoicing list to all accounts associated with this customer,
1652 overwriting any previous invoicing list.
1656 sub set_default_invoicing_list {
1658 $self->invoicing_list($self->all_emails);
1663 Returns the email addresses of all accounts provisioned for this customer.
1670 foreach my $cust_pkg ( $self->all_pkgs ) {
1671 my @cust_svc = qsearch('cust_svc', { 'pkgnum' => $cust_pkg->pkgnum } );
1673 map { qsearchs('svc_acct', { 'svcnum' => $_->svcnum } ) }
1674 grep { qsearchs('svc_acct', { 'svcnum' => $_->svcnum } ) }
1676 $list{$_}=1 foreach map { $_->email } @svc_acct;
1681 =item invoicing_list_addpost
1683 Adds postal invoicing to this customer. If this customer is already configured
1684 to receive postal invoices, does nothing.
1688 sub invoicing_list_addpost {
1690 return if grep { $_ eq 'POST' } $self->invoicing_list;
1691 my @invoicing_list = $self->invoicing_list;
1692 push @invoicing_list, 'POST';
1693 $self->invoicing_list(\@invoicing_list);
1696 =item referral_cust_main [ DEPTH [ EXCLUDE_HASHREF ] ]
1698 Returns an array of customers referred by this customer (referral_custnum set
1699 to this custnum). If DEPTH is given, recurses up to the given depth, returning
1700 customers referred by customers referred by this customer and so on, inclusive.
1701 The default behavior is DEPTH 1 (no recursion).
1705 sub referral_cust_main {
1707 my $depth = @_ ? shift : 1;
1708 my $exclude = @_ ? shift : {};
1711 map { $exclude->{$_->custnum}++; $_; }
1712 grep { ! $exclude->{ $_->custnum } }
1713 qsearch( 'cust_main', { 'referral_custnum' => $self->custnum } );
1717 map { $_->referral_cust_main($depth-1, $exclude) }
1724 =item referral_cust_main_ncancelled
1726 Same as referral_cust_main, except only returns customers with uncancelled
1731 sub referral_cust_main_ncancelled {
1733 grep { scalar($_->ncancelled_pkgs) } $self->referral_cust_main;
1736 =item referral_cust_pkg [ DEPTH ]
1738 Like referral_cust_main, except returns a flat list of all unsuspended (and
1739 uncancelled) packages for each customer. The number of items in this list may
1740 be useful for comission calculations (perhaps after a C<grep { my $pkgpart = $_->pkgpart; grep { $_ == $pkgpart } @commission_worthy_pkgparts> } $cust_main-> ).
1744 sub referral_cust_pkg {
1746 my $depth = @_ ? shift : 1;
1748 map { $_->unsuspended_pkgs }
1749 grep { $_->unsuspended_pkgs }
1750 $self->referral_cust_main($depth);
1753 =item credit AMOUNT, REASON
1755 Applies a credit to this customer. If there is an error, returns the error,
1756 otherwise returns false.
1761 my( $self, $amount, $reason ) = @_;
1762 my $cust_credit = new FS::cust_credit {
1763 'custnum' => $self->custnum,
1764 'amount' => $amount,
1765 'reason' => $reason,
1767 $cust_credit->insert;
1770 =item charge AMOUNT [ PKG [ COMMENT [ TAXCLASS ] ] ]
1772 Creates a one-time charge for this customer. If there is an error, returns
1773 the error, otherwise returns false.
1778 my ( $self, $amount ) = ( shift, shift );
1779 my $pkg = @_ ? shift : 'One-time charge';
1780 my $comment = @_ ? shift : '$'. sprintf("%.2f",$amount);
1781 my $taxclass = @_ ? shift : '';
1783 local $SIG{HUP} = 'IGNORE';
1784 local $SIG{INT} = 'IGNORE';
1785 local $SIG{QUIT} = 'IGNORE';
1786 local $SIG{TERM} = 'IGNORE';
1787 local $SIG{TSTP} = 'IGNORE';
1788 local $SIG{PIPE} = 'IGNORE';
1790 my $oldAutoCommit = $FS::UID::AutoCommit;
1791 local $FS::UID::AutoCommit = 0;
1794 my $part_pkg = new FS::part_pkg ( {
1796 'comment' => $comment,
1801 'taxclass' => $taxclass,
1804 my $error = $part_pkg->insert;
1806 $dbh->rollback if $oldAutoCommit;
1810 my $pkgpart = $part_pkg->pkgpart;
1811 my %type_pkgs = ( 'typenum' => $self->agent->typenum, 'pkgpart' => $pkgpart );
1812 unless ( qsearchs('type_pkgs', \%type_pkgs ) ) {
1813 my $type_pkgs = new FS::type_pkgs \%type_pkgs;
1814 $error = $type_pkgs->insert;
1816 $dbh->rollback if $oldAutoCommit;
1821 my $cust_pkg = new FS::cust_pkg ( {
1822 'custnum' => $self->custnum,
1823 'pkgpart' => $pkgpart,
1826 $error = $cust_pkg->insert;
1828 $dbh->rollback if $oldAutoCommit;
1832 $dbh->commit or die $dbh->errstr if $oldAutoCommit;
1839 Returns all the invoices (see L<FS::cust_bill>) for this customer.
1845 sort { $a->_date <=> $b->_date }
1846 qsearch('cust_bill', { 'custnum' => $self->custnum, } )
1849 =item open_cust_bill
1851 Returns all the open (owed > 0) invoices (see L<FS::cust_bill>) for this
1856 sub open_cust_bill {
1858 grep { $_->owed > 0 } $self->cust_bill;
1867 =item check_and_rebuild_fuzzyfiles
1871 sub check_and_rebuild_fuzzyfiles {
1872 my $dir = $FS::UID::conf_dir. "cache.". $FS::UID::datasrc;
1873 -e "$dir/cust_main.last" && -e "$dir/cust_main.company"
1874 or &rebuild_fuzzyfiles;
1877 =item rebuild_fuzzyfiles
1881 sub rebuild_fuzzyfiles {
1883 use Fcntl qw(:flock);
1885 my $dir = $FS::UID::conf_dir. "cache.". $FS::UID::datasrc;
1889 open(LASTLOCK,">>$dir/cust_main.last")
1890 or die "can't open $dir/cust_main.last: $!";
1891 flock(LASTLOCK,LOCK_EX)
1892 or die "can't lock $dir/cust_main.last: $!";
1894 my @all_last = map $_->getfield('last'), qsearch('cust_main', {});
1896 grep $_, map $_->getfield('ship_last'), qsearch('cust_main',{})
1897 if defined dbdef->table('cust_main')->column('ship_last');
1899 open (LASTCACHE,">$dir/cust_main.last.tmp")
1900 or die "can't open $dir/cust_main.last.tmp: $!";
1901 print LASTCACHE join("\n", @all_last), "\n";
1902 close LASTCACHE or die "can't close $dir/cust_main.last.tmp: $!";
1904 rename "$dir/cust_main.last.tmp", "$dir/cust_main.last";
1909 open(COMPANYLOCK,">>$dir/cust_main.company")
1910 or die "can't open $dir/cust_main.company: $!";
1911 flock(COMPANYLOCK,LOCK_EX)
1912 or die "can't lock $dir/cust_main.company: $!";
1914 my @all_company = grep $_ ne '', map $_->company, qsearch('cust_main',{});
1916 grep $_ ne '', map $_->ship_company, qsearch('cust_main', {})
1917 if defined dbdef->table('cust_main')->column('ship_last');
1919 open (COMPANYCACHE,">$dir/cust_main.company.tmp")
1920 or die "can't open $dir/cust_main.company.tmp: $!";
1921 print COMPANYCACHE join("\n", @all_company), "\n";
1922 close COMPANYCACHE or die "can't close $dir/cust_main.company.tmp: $!";
1924 rename "$dir/cust_main.company.tmp", "$dir/cust_main.company";
1934 my $dir = $FS::UID::conf_dir. "cache.". $FS::UID::datasrc;
1935 open(LASTCACHE,"<$dir/cust_main.last")
1936 or die "can't open $dir/cust_main.last: $!";
1937 my @array = map { chomp; $_; } <LASTCACHE>;
1947 my $dir = $FS::UID::conf_dir. "cache.". $FS::UID::datasrc;
1948 open(COMPANYCACHE,"<$dir/cust_main.company")
1949 or die "can't open $dir/cust_main.last: $!";
1950 my @array = map { chomp; $_; } <COMPANYCACHE>;
1955 =item append_fuzzyfiles LASTNAME COMPANY
1959 sub append_fuzzyfiles {
1960 my( $last, $company ) = @_;
1962 &check_and_rebuild_fuzzyfiles;
1964 use Fcntl qw(:flock);
1966 my $dir = $FS::UID::conf_dir. "cache.". $FS::UID::datasrc;
1970 open(LAST,">>$dir/cust_main.last")
1971 or die "can't open $dir/cust_main.last: $!";
1973 or die "can't lock $dir/cust_main.last: $!";
1975 print LAST "$last\n";
1978 or die "can't unlock $dir/cust_main.last: $!";
1984 open(COMPANY,">>$dir/cust_main.company")
1985 or die "can't open $dir/cust_main.company: $!";
1986 flock(COMPANY,LOCK_EX)
1987 or die "can't lock $dir/cust_main.company: $!";
1989 print COMPANY "$company\n";
1991 flock(COMPANY,LOCK_UN)
1992 or die "can't unlock $dir/cust_main.company: $!";
2006 #warn join('-',keys %$param);
2007 my $fh = $param->{filehandle};
2008 my $agentnum = $param->{agentnum};
2009 my $refnum = $param->{refnum};
2010 my $pkgpart = $param->{pkgpart};
2011 my @fields = @{$param->{fields}};
2013 eval "use Date::Parse;";
2015 eval "use Text::CSV_XS;";
2018 my $csv = new Text::CSV_XS;
2025 local $SIG{HUP} = 'IGNORE';
2026 local $SIG{INT} = 'IGNORE';
2027 local $SIG{QUIT} = 'IGNORE';
2028 local $SIG{TERM} = 'IGNORE';
2029 local $SIG{TSTP} = 'IGNORE';
2030 local $SIG{PIPE} = 'IGNORE';
2032 my $oldAutoCommit = $FS::UID::AutoCommit;
2033 local $FS::UID::AutoCommit = 0;
2036 #while ( $columns = $csv->getline($fh) ) {
2038 while ( defined($line=<$fh>) ) {
2040 $csv->parse($line) or do {
2041 $dbh->rollback if $oldAutoCommit;
2042 return "can't parse: ". $csv->error_input();
2045 my @columns = $csv->fields();
2046 #warn join('-',@columns);
2049 agentnum => $agentnum,
2051 country => 'US', #default
2052 payby => 'BILL', #default
2053 paydate => '12/2037', #default
2055 my $billtime = time;
2056 my %cust_pkg = ( pkgpart => $pkgpart );
2057 foreach my $field ( @fields ) {
2058 if ( $field =~ /^cust_pkg\.(setup|bill|susp|expire|cancel)$/ ) {
2059 #$cust_pkg{$1} = str2time( shift @$columns );
2060 if ( $1 eq 'setup' ) {
2061 $billtime = str2time(shift @columns);
2063 $cust_pkg{$1} = str2time( shift @columns );
2066 #$cust_main{$field} = shift @$columns;
2067 $cust_main{$field} = shift @columns;
2071 my $cust_pkg = new FS::cust_pkg ( \%cust_pkg ) if $pkgpart;
2072 my $cust_main = new FS::cust_main ( \%cust_main );
2074 tie my %hash, 'Tie::RefHash'; #this part is important
2075 $hash{$cust_pkg} = [] if $pkgpart;
2076 my $error = $cust_main->insert( \%hash );
2079 $dbh->rollback if $oldAutoCommit;
2080 return "can't insert customer for $line: $error";
2083 #false laziness w/bill.cgi
2084 $error = $cust_main->bill( 'time' => $billtime );
2086 $dbh->rollback if $oldAutoCommit;
2087 return "can't bill customer for $line: $error";
2090 $cust_main->apply_payments;
2091 $cust_main->apply_credits;
2093 $error = $cust_main->collect();
2095 $dbh->rollback if $oldAutoCommit;
2096 return "can't collect customer for $line: $error";
2102 $dbh->commit or die $dbh->errstr if $oldAutoCommit;
2104 return "Empty file!" unless $imported;
2116 #warn join('-',keys %$param);
2117 my $fh = $param->{filehandle};
2118 my @fields = @{$param->{fields}};
2120 eval "use Date::Parse;";
2122 eval "use Text::CSV_XS;";
2125 my $csv = new Text::CSV_XS;
2132 local $SIG{HUP} = 'IGNORE';
2133 local $SIG{INT} = 'IGNORE';
2134 local $SIG{QUIT} = 'IGNORE';
2135 local $SIG{TERM} = 'IGNORE';
2136 local $SIG{TSTP} = 'IGNORE';
2137 local $SIG{PIPE} = 'IGNORE';
2139 my $oldAutoCommit = $FS::UID::AutoCommit;
2140 local $FS::UID::AutoCommit = 0;
2143 #while ( $columns = $csv->getline($fh) ) {
2145 while ( defined($line=<$fh>) ) {
2147 $csv->parse($line) or do {
2148 $dbh->rollback if $oldAutoCommit;
2149 return "can't parse: ". $csv->error_input();
2152 my @columns = $csv->fields();
2153 #warn join('-',@columns);
2156 foreach my $field ( @fields ) {
2157 $row{$field} = shift @columns;
2160 my $cust_main = qsearchs('cust_main', { 'custnum' => $row{'custnum'} } );
2161 unless ( $cust_main ) {
2162 $dbh->rollback if $oldAutoCommit;
2163 return "unknown custnum $row{'custnum'}";
2166 if ( $row{'amount'} > 0 ) {
2167 my $error = $cust_main->charge($row{'amount'}, $row{'pkg'});
2169 $dbh->rollback if $oldAutoCommit;
2173 } elsif ( $row{'amount'} < 0 ) {
2174 my $error = $cust_main->credit( sprintf( "%.2f", 0-$row{'amount'} ),
2177 $dbh->rollback if $oldAutoCommit;
2187 $dbh->commit or die $dbh->errstr if $oldAutoCommit;
2189 return "Empty file!" unless $imported;
2201 The delete method should possibly take an FS::cust_main object reference
2202 instead of a scalar customer number.
2204 Bill and collect options should probably be passed as references instead of a
2207 There should probably be a configuration file with a list of allowed credit
2210 No multiple currency support (probably a larger project than just this module).
2214 L<FS::Record>, L<FS::cust_pkg>, L<FS::cust_bill>, L<FS::cust_credit>
2215 L<FS::agent>, L<FS::part_referral>, L<FS::cust_main_county>,
2216 L<FS::cust_main_invoice>, L<FS::UID>, schema.html from the base documentation.