1 package FS::ClientAPI::MyAccount;
6 use Digest::MD5 qw(md5_hex);
8 use Business::CreditCard;
10 use FS::CGI qw(small_custview); #doh
12 use FS::UI::bytecount;
14 use FS::Record qw(qsearch qsearchs);
15 use FS::Msgcat qw(gettext);
16 use FS::Misc qw(card_types);
17 use FS::ClientAPI_SessionCache;
24 use FS::cust_main_county;
28 #false laziness with FS::cust_main
30 eval "use Time::Local;";
31 die "Time::Local minimum version 1.05 required with Perl versions before 5.6"
32 if $] < 5.006 && !defined($Time::Local::VERSION);
33 eval "use Time::Local qw(timelocal_nocheck);";
36 use vars qw( @cust_main_editable_fields );
37 @cust_main_editable_fields = qw(
38 first last company address1 address2 city
39 county state zip country daytime night fax
40 ship_first ship_last ship_company ship_address1 ship_address2 ship_city
41 ship_state ship_zip ship_country ship_daytime ship_night ship_fax
42 payby payinfo payname paystart_month paystart_year payissue payip
45 use subs qw(_provision);
48 $cache ||= new FS::ClientAPI_SessionCache( {
49 'namespace' => 'FS::ClientAPI::MyAccount',
53 #false laziness w/FS::ClientAPI::passwd::passwd
57 my $svc_domain = qsearchs('svc_domain', { 'domain' => $p->{'domain'} } )
58 or return { error => 'Domain '. $p->{'domain'}. ' not found' };
60 my $svc_acct = qsearchs( 'svc_acct', { 'username' => $p->{'username'},
61 'domsvc' => $svc_domain->svcnum, }
63 return { error => 'User not found.' } unless $svc_acct;
65 my $conf = new FS::Conf;
66 my $pkg_svc = $svc_acct->cust_svc->pkg_svc;
67 return { error => 'Only primary user may log in.' }
68 if $conf->exists('selfservice_server-primary_only')
69 && ( ! $pkg_svc || $pkg_svc->primary_svc ne 'Y' );
71 return { error => 'Incorrect password.' }
72 unless $svc_acct->check_password($p->{'password'});
75 'svcnum' => $svc_acct->svcnum,
78 my $cust_pkg = $svc_acct->cust_svc->cust_pkg;
80 my $cust_main = $cust_pkg->cust_main;
81 $session->{'custnum'} = $cust_main->custnum;
86 $session_id = md5_hex(md5_hex(time(). {}. rand(). $$))
87 } until ( ! defined _cache->get($session_id) ); #just in case
89 _cache->set( $session_id, $session, '1 hour' );
91 return { 'error' => '',
92 'session_id' => $session_id,
98 if ( $p->{'session_id'} ) {
99 _cache->remove($p->{'session_id'});
100 return { 'error' => '' };
102 return { 'error' => "Can't resume session" }; #better error message
109 my($context, $session, $custnum) = _custoragent_session_custnum($p);
110 return { 'error' => $session } if $context eq 'error';
113 if ( $custnum ) { #customer record
115 my $search = { 'custnum' => $custnum };
116 $search->{'agentnum'} = $session->{'agentnum'} if $context eq 'agent';
117 my $cust_main = qsearchs('cust_main', $search )
118 or return { 'error' => "unknown custnum $custnum" };
120 $return{balance} = $cust_main->balance;
124 invnum => $_->invnum,
125 date => time2str("%b %o, %Y", $_->_date),
128 } $cust_main->open_cust_bill;
129 $return{open_invoices} = \@open;
131 my $conf = new FS::Conf;
132 $return{small_custview} =
133 small_custview( $cust_main, $conf->config('countrydefault') );
135 $return{name} = $cust_main->first. ' '. $cust_main->get('last');
137 for (@cust_main_editable_fields) {
138 $return{$_} = $cust_main->get($_);
141 if ( $cust_main->payby =~ /^(CARD|DCRD)$/ ) {
142 $return{payinfo} = $cust_main->paymask;
143 @return{'month', 'year'} = $cust_main->paydate_monthyear;
146 $return{'invoicing_list'} =
147 join(', ', grep { $_ !~ /^(POST|FAX)$/ } $cust_main->invoicing_list );
148 $return{'postal_invoicing'} =
149 0 < ( grep { $_ eq 'POST' } $cust_main->invoicing_list );
151 } elsif ( $session->{'svcnum'} ) { #no customer record
153 my $svc_acct = qsearchs('svc_acct', { 'svcnum' => $session->{'svcnum'} } )
154 or die "unknown svcnum";
155 $return{name} = $svc_acct->email;
159 return { 'error' => 'Expired session' }; #XXX redirect to login w/this err!
163 return { 'error' => '',
164 'custnum' => $custnum,
172 my $session = _cache->get($p->{'session_id'})
173 or return { 'error' => "Can't resume session" }; #better error message
175 my $custnum = $session->{'custnum'}
176 or return { 'error' => "no customer record" };
178 my $cust_main = qsearchs('cust_main', { 'custnum' => $custnum } )
179 or return { 'error' => "unknown custnum $custnum" };
181 my $new = new FS::cust_main { $cust_main->hash };
182 $new->set( $_ => $p->{$_} )
183 foreach grep { exists $p->{$_} } @cust_main_editable_fields;
185 if ( $p->{'payby'} =~ /^(CARD|DCRD)$/ ) {
186 $new->paydate($p->{'year'}. '-'. $p->{'month'}. '-01');
187 if ( $new->payinfo eq $cust_main->paymask ) {
188 $new->payinfo($cust_main->payinfo);
190 $new->paycvv($p->{'paycvv'});
195 if ( exists $p->{'invoicing_list'} || exists $p->{'postal_invoicing'} ) {
196 #false laziness with httemplate/edit/process/cust_main.cgi
197 @invoicing_list = split( /\s*\,\s*/, $p->{'invoicing_list'} );
198 push @invoicing_list, 'POST' if $p->{'postal_invoicing'};
200 @invoicing_list = $cust_main->invoicing_list;
203 my $error = $new->replace($cust_main, \@invoicing_list);
204 return { 'error' => $error } if $error;
207 return { 'error' => '' };
212 my $session = _cache->get($p->{'session_id'})
213 or return { 'error' => "Can't resume session" }; #better error message
219 use vars qw($payment_info); #cache for performance
220 unless ( $payment_info ) {
222 my $conf = new FS::Conf;
223 my %states = map { $_->state => 1 }
224 qsearch('cust_main_county', {
225 'country' => $conf->config('countrydefault') || 'US'
230 #list all counties/states/countries
231 'cust_main_county' =>
232 [ map { $_->hashref } qsearch('cust_main_county', {}) ],
234 #shortcut for one-country folks
236 [ sort { $a cmp $b } keys %states ],
238 'card_types' => card_types(),
248 my %return = %$payment_info;
250 my $custnum = $session->{'custnum'};
252 my $cust_main = qsearchs('cust_main', { 'custnum' => $custnum } )
253 or return { 'error' => "unknown custnum $custnum" };
255 $return{balance} = $cust_main->balance;
257 $return{payname} = $cust_main->payname
258 || ( $cust_main->first. ' '. $cust_main->get('last') );
260 $return{$_} = $cust_main->get($_) for qw(address1 address2 city state zip);
262 $return{payby} = $cust_main->payby;
264 if ( $cust_main->payby =~ /^(CARD|DCRD)$/ ) {
265 $return{card_type} = cardtype($cust_main->payinfo);
266 $return{payinfo} = $cust_main->payinfo;
268 @return{'month', 'year'} = $cust_main->paydate_monthyear;
272 #doubleclick protection
274 $return{paybatch} = "webui-MyAccount-$_date-$$-". rand() * 2**32;
276 return { 'error' => '',
282 #some false laziness with httemplate/process/payment.cgi - look there for
283 #ACH and CVV support stuff
284 sub process_payment {
288 my $session = _cache->get($p->{'session_id'})
289 or return { 'error' => "Can't resume session" }; #better error message
293 my $custnum = $session->{'custnum'};
295 my $cust_main = qsearchs('cust_main', { 'custnum' => $custnum } )
296 or return { 'error' => "unknown custnum $custnum" };
298 $p->{'payname'} =~ /^([\w \,\.\-\']+)$/
299 or return { 'error' => gettext('illegal_name'). " payname: ". $p->{'payname'} };
302 $p->{'paybatch'} =~ /^([\w \!\@\#\$\%\&\(\)\-\+\;\:\'\"\,\.\?\/\=]*)$/
303 or return { 'error' => gettext('illegal_text'). " paybatch: ". $p->{'paybatch'} };
308 #if ( $payby eq 'CHEK' ) {
310 # $p->{'payinfo1'} =~ /^(\d+)$/
311 # or return { 'error' => "illegal account number ". $p->{'payinfo1'} };
313 # $p->{'payinfo2'} =~ /^(\d+)$/
314 # or return { 'error' => "illegal ABA/routing number ". $p->{'payinfo2'} };
316 # $payinfo = $payinfo1. '@'. $payinfo2;
318 #} elsif ( $payby eq 'CARD' ) {
320 $payinfo = $p->{'payinfo'};
322 $payinfo =~ /^(\d{13,16})$/
323 or return { 'error' => gettext('invalid_card') }; # . ": ". $self->payinfo
326 or return { 'error' => gettext('invalid_card') }; # . ": ". $self->payinfo
327 return { 'error' => gettext('unknown_card_type') }
328 if cardtype($payinfo) eq "Unknown";
330 if ( length($p->{'paycvv'}) && $p->{'paycvv'} !~ /^\s*$/ ) {
331 if ( cardtype($payinfo) eq 'American Express card' ) {
332 $p->{'paycvv'} =~ /^\s*(\d{4})\s*$/
333 or return { 'error' => "CVV2 (CID) for American Express cards is four digits." };
336 $p->{'paycvv'} =~ /^\s*(\d{3})\s*$/
337 or return { 'error' => "CVV2 (CVC2/CID) is three digits." };
343 # die "unknown payby $payby";
346 my $error = $cust_main->realtime_bop( 'CC', $p->{'amount'},
348 'payinfo' => $payinfo,
349 'paydate' => $p->{'year'}. '-'. $p->{'month'}. '-01',
350 'payname' => $payname,
351 'paybatch' => $paybatch,
353 map { $_ => $p->{$_} } qw( paystart_month paystart_year payissue payip
354 address1 address2 city state zip )
356 return { 'error' => $error } if $error;
358 $cust_main->apply_payments;
360 if ( $p->{'save'} ) {
361 my $new = new FS::cust_main { $cust_main->hash };
362 $new->set( $_ => $p->{$_} )
363 foreach qw( payname paystart_month paystart_year payissue payip
364 address1 address2 city state zip payinfo );
365 $new->set( 'paydate' => $p->{'year'}. '-'. $p->{'month'}. '-01' );
366 $new->set( 'payby' => $p->{'auto'} ? 'CARD' : 'DCRD' );
367 my $error = $new->replace($cust_main);
368 return { 'error' => $error } if $error;
372 return { 'error' => '' };
380 my $session = _cache->get($p->{'session_id'})
381 or return { 'error' => "Can't resume session" }; #better error message
385 my $custnum = $session->{'custnum'};
387 my $cust_main = qsearchs('cust_main', { 'custnum' => $custnum } )
388 or return { 'error' => "unknown custnum $custnum" };
390 my( $amount, $seconds, $upbytes, $downbytes, $totalbytes ) = ( 0, 0, 0, 0, 0 );
391 my $error = $cust_main->recharge_prepay( $p->{'prepaid_cardnum'},
399 return { 'error' => $error } if $error;
401 return { 'error' => '',
403 'seconds' => $seconds,
404 'duration' => duration_exact($seconds),
405 'upbytes' => $upbytes,
406 'upload' => FS::UI::bytecount::bytecount_unexact($upbytes),
407 'downbytes' => $downbytes,
408 'download' => FS::UI::bytecount::bytecount_unexact($downbytes),
409 'totalbytes'=> $totalbytes,
410 'totalload' => FS::UI::bytecount::bytecount_unexact($totalbytes),
417 my $session = _cache->get($p->{'session_id'})
418 or return { 'error' => "Can't resume session" }; #better error message
420 my $custnum = $session->{'custnum'};
422 my $invnum = $p->{'invnum'};
424 my $cust_bill = qsearchs('cust_bill', { 'invnum' => $invnum,
425 'custnum' => $custnum } )
426 or return { 'error' => "Can't find invnum" };
430 return { 'error' => '',
432 'invoice_text' => join('', $cust_bill->print_text ),
433 'invoice_html' => $cust_bill->print_html,
441 #sessioning for this? how do we get the session id to the backend invoice
442 # template so it can add it to the link, blah
444 my $templatename = $p->{'templatename'};
446 #false laziness-ish w/view/cust_bill-logo.cgi
448 my $conf = new FS::Conf;
449 if ( $templatename =~ /^([^\.\/]*)$/ && $conf->exists("logo_$1.png") ) {
450 $templatename = "_$1";
455 my $filename = "logo$templatename.png";
457 return { 'error' => '',
458 'logo' => $conf->config_binary($filename),
459 'content_type' => 'image/png', #should allow gif, jpg too
466 my $session = _cache->get($p->{'session_id'})
467 or return { 'error' => "Can't resume session" }; #better error message
469 my $custnum = $session->{'custnum'};
471 my $cust_main = qsearchs('cust_main', { 'custnum' => $custnum } )
472 or return { 'error' => "unknown custnum $custnum" };
474 my @cust_bill = $cust_main->cust_bill;
476 return { 'error' => '',
477 'invoices' => [ map { { 'invnum' => $_->invnum,
478 '_date' => $_->_date,
487 my $session = _cache->get($p->{'session_id'})
488 or return { 'error' => "Can't resume session" }; #better error message
490 my $custnum = $session->{'custnum'};
492 my $cust_main = qsearchs('cust_main', { 'custnum' => $custnum } )
493 or return { 'error' => "unknown custnum $custnum" };
495 my @errors = $cust_main->cancel( 'quiet'=>1 );
497 my $error = scalar(@errors) ? join(' / ', @errors) : '';
499 return { 'error' => $error };
506 my($context, $session, $custnum) = _custoragent_session_custnum($p);
507 return { 'error' => $session } if $context eq 'error';
509 my $search = { 'custnum' => $custnum };
510 $search->{'agentnum'} = $session->{'agentnum'} if $context eq 'agent';
511 my $cust_main = qsearchs('cust_main', $search )
512 or return { 'error' => "unknown custnum $custnum" };
514 #return { 'cust_pkg' => [ map { $_->hashref } $cust_main->ncancelled_pkgs ] };
516 my $conf = new FS::Conf;
518 { 'svcnum' => $session->{'svcnum'},
519 'custnum' => $custnum,
520 'cust_pkg' => [ map {
524 [ map $_->hashref, $_->available_part_svc ],
526 [ map { my $ref = { $_->hash,
527 label => [ $_->label ],
529 $ref->{_password} = $_->svc_x->_password
530 if $context eq 'agent'
531 && $conf->exists('agent-showpasswords')
532 && $_->part_svc->svcdb eq 'svc_acct';
537 } $cust_main->ncancelled_pkgs
540 small_custview( $cust_main, $conf->config('countrydefault') ),
548 my($context, $session, $custnum) = _custoragent_session_custnum($p);
549 return { 'error' => $session } if $context eq 'error';
551 my $search = { 'custnum' => $custnum };
552 $search->{'agentnum'} = $session->{'agentnum'} if $context eq 'agent';
553 my $cust_main = qsearchs('cust_main', $search )
554 or return { 'error' => "unknown custnum $custnum" };
557 #foreach my $cust_pkg ( $cust_main->ncancelled_pkgs ) {
558 foreach my $cust_pkg ( $p->{'ncancelled'}
559 ? $cust_main->ncancelled_pkgs
560 : $cust_main->unsuspended_pkgs ) {
561 push @cust_svc, @{[ $cust_pkg->cust_svc ]}; #@{[ ]} to force array context
563 @cust_svc = grep { $_->part_svc->svcdb eq $p->{'svcdb'} } @cust_svc
566 #@svc_x = sort { $a->domain cmp $b->domain || $a->username cmp $b->username }
570 #no#'svcnum' => $session->{'svcnum'},
571 'custnum' => $custnum,
573 my $svc_x = $_->svc_x;
574 my($label, $value) = $_->label;
575 my $part_pkg = $svc_x->cust_svc->cust_pkg->part_pkg;
577 { 'svcnum' => $_->svcnum,
580 'username' => $svc_x->username,
581 'email' => $svc_x->email,
582 'seconds' => $svc_x->seconds,
583 'upbytes' => FS::UI::bytecount::display_bytecount($svc_x->upbytes),
584 'downbytes' => FS::UI::bytecount::display_bytecount($svc_x->downbytes),
585 'totalbytes'=> FS::UI::bytecount::display_bytecount($svc_x->totalbytes),
586 'recharge_amount' => $part_pkg->option('recharge_amount', 1),
587 'recharge_seconds' => $part_pkg->option('recharge_seconds', 1),
588 'recharge_upbytes' => FS::UI::bytecount::display_bytecount($part_pkg->option('recharge_upbytes', 1)),
589 'recharge_downbytes' => FS::UI::bytecount::display_bytecount($part_pkg->option('recharge_downbytes', 1)),
590 'recharge_totalbytes' => FS::UI::bytecount::display_bytecount($part_pkg->option('recharge_totalbytes', 1)),
603 my($context, $session, $custnum) = _custoragent_session_custnum($p);
604 return { 'error' => $session } if $context eq 'error';
606 my $search = { 'svcnum' => $p->{'svcnum'} };
607 $search->{'agentnum'} = $session->{'agentnum'} if $context eq 'agent';
608 my $svc_acct = qsearchs ( 'svc_acct', $search );
609 return { 'error' => 'No service selected in list_svc_usage' }
612 my $freq = $svc_acct->cust_svc->cust_pkg->part_pkg->freq;
613 my $start = $svc_acct->cust_svc->cust_pkg->setup;
614 #my $end = $svc_acct->cust_svc->cust_pkg->bill; # or time?
617 unless($p->{beginning}){
618 $p->{beginning} = $svc_acct->cust_svc->cust_pkg->last_bill;
623 foreach my $part_export (
624 map { qsearch ( 'part_export', { 'exporttype' => $_ } ) }
625 qw (sqlradius sqlradius_withdomain')
628 push @usage, @ { $part_export->usage_sessions($p->{beginning},
634 #kinda false laziness with FS::cust_main::bill, but perhaps
635 #we should really change this bit to DateTime and DateTime::Duration
637 #change this bit to use Date::Manip? CAREFUL with timezones (see
638 # mailing list archive)
639 my ($nsec,$nmin,$nhour,$nmday,$nmon,$nyear) =
640 (localtime($p->{ending}) )[0,1,2,3,4,5];
641 my ($psec,$pmin,$phour,$pmday,$pmon,$pyear) =
642 (localtime($p->{beginning}) )[0,1,2,3,4,5];
644 if ( $freq =~ /^\d+$/ ) {
646 until ( $nmon < 12 ) { $nmon -= 12; $nyear++; }
648 until ( $pmon >= 0 ) { $pmon += 12; $pyear--; }
649 } elsif ( $freq =~ /^(\d+)w$/ ) {
651 $nmday += $weeks * 7;
652 $pmday -= $weeks * 7;
653 } elsif ( $freq =~ /^(\d+)d$/ ) {
657 } elsif ( $freq =~ /^(\d+)h$/ ) {
662 return { 'error' => "unparsable frequency: ". $freq };
665 my $previous = timelocal_nocheck($psec,$pmin,$phour,$pmday,$pmon,$pyear);
666 my $next = timelocal_nocheck($nsec,$nmin,$nhour,$nmday,$nmon,$nyear);
671 'svcnum' => $p->{svcnum},
672 'beginning' => $p->{beginning},
673 'ending' => $p->{ending},
674 'previous' => ($previous > $start) ? $previous : $start,
675 'next' => ($next < $end) ? $next : $end,
683 my($context, $session, $custnum) = _custoragent_session_custnum($p);
684 return { 'error' => $session } if $context eq 'error';
686 my $search = { 'custnum' => $custnum };
687 $search->{'agentnum'} = $session->{'agentnum'} if $context eq 'agent';
688 my $cust_main = qsearchs('cust_main', $search )
689 or return { 'error' => "unknown custnum $custnum" };
691 #false laziness w/ClientAPI/Signup.pm
693 my $cust_pkg = new FS::cust_pkg ( {
694 'custnum' => $custnum,
695 'pkgpart' => $p->{'pkgpart'},
697 my $error = $cust_pkg->check;
698 return { 'error' => $error } if $error;
701 unless ( $p->{'svcpart'} eq 'none' ) {
705 if ( $p->{'svcpart'} =~ /^(\d+)$/ ) {
707 my $part_svc = qsearchs('part_svc', { 'svcpart' => $svcpart } );
708 return { 'error' => "Unknown svcpart $svcpart" } unless $part_svc;
709 $svcdb = $part_svc->svcdb;
713 $svcpart ||= $cust_pkg->part_pkg->svcpart($svcdb);
716 'svc_acct' => [ qw( username domsvc _password sec_phrase popnum ) ],
717 'svc_domain' => [ qw( domain ) ],
718 'svc_external' => [ qw( id title ) ],
721 my $svc_x = "FS::$svcdb"->new( {
722 'svcpart' => $svcpart,
723 map { $_ => $p->{$_} } @{$fields{$svcdb}}
726 if ( $svcdb eq 'svc_acct' ) {
729 while ( length($p->{"snarf_machine$snarfnum"}) ) {
730 my $acct_snarf = new FS::acct_snarf ( {
731 'machine' => $p->{"snarf_machine$snarfnum"},
732 'protocol' => $p->{"snarf_protocol$snarfnum"},
733 'username' => $p->{"snarf_username$snarfnum"},
734 '_password' => $p->{"snarf_password$snarfnum"},
737 push @acct_snarf, $acct_snarf;
739 $svc_x->child_objects( \@acct_snarf );
742 my $y = $svc_x->setdefault; # arguably should be in new method
743 return { 'error' => $y } if $y && !ref($y);
745 $error = $svc_x->check;
746 return { 'error' => $error } if $error;
753 tie my %hash, 'Tie::RefHash';
754 %hash = ( $cust_pkg => \@svc );
756 $error = $cust_main->order_pkgs( \%hash, '', 'noexport' => 1 );
757 return { 'error' => $error } if $error;
759 my $conf = new FS::Conf;
760 if ( $conf->exists('signup_server-realtime') ) {
762 my $bill_error = _do_bop_realtime( $cust_main );
765 $cust_pkg->cancel('quiet'=>1);
775 return { error => '', pkgnum => $cust_pkg->pkgnum };
782 my($context, $session, $custnum) = _custoragent_session_custnum($p);
783 return { 'error' => $session } if $context eq 'error';
785 my $search = { 'custnum' => $custnum };
786 $search->{'agentnum'} = $session->{'agentnum'} if $context eq 'agent';
787 my $cust_main = qsearchs('cust_main', $search )
788 or return { 'error' => "unknown custnum $custnum" };
790 my $cust_pkg = qsearchs('cust_pkg', { 'pkgnum' => $p->{pkgnum} } )
791 or return { 'error' => "unknown package $p->{pkgnum}" };
794 my $error = FS::cust_pkg::order( $custnum,
800 my $conf = new FS::Conf;
801 if ( $conf->exists('signup_server-realtime') ) {
803 my $bill_error = _do_bop_realtime( $cust_main );
809 $newpkg[0]->reexport;
813 $newpkg[0]->reexport;
816 return { error => '', pkgnum => $cust_pkg->pkgnum };
823 my($context, $session, $custnum) = _custoragent_session_custnum($p);
824 return { 'error' => $session } if $context eq 'error';
826 my $search = { 'custnum' => $custnum };
827 $search->{'agentnum'} = $session->{'agentnum'} if $context eq 'agent';
828 my $cust_main = qsearchs('cust_main', $search )
829 or return { 'error' => "unknown custnum $custnum" };
831 my $cust_svc = qsearchs( 'cust_svc', { 'svcnum' => $p->{'svcnum'} } )
832 or return { 'error' => "unknown service " . $p->{'svcnum'} };
834 my $svc_x = $cust_svc->svc_x;
835 my $part_pkg = $cust_svc->cust_pkg->part_pkg;
838 map { $_ =~ /^recharge_(.*)$/; $1, $part_pkg->option($_, 1) }
839 qw ( recharge_seconds recharge_upbytes recharge_downbytes
840 recharge_totalbytes );
841 my $amount = $part_pkg->option('recharge_amount', 1);
843 my ($l, $v, $d) = $cust_svc->label; # blah
844 my $pkg = "Recharge $v";
846 my $bill_error = $cust_main->charge($amount, $pkg,
847 "time: $vhash{seconds}, up: $vhash{upbytes}," .
848 "down: $vhash{downbytes}, total: $vhash{totalbytes}",
849 $part_pkg->taxclass); #meh
851 my $conf = new FS::Conf;
852 if ( $conf->exists('signup_server-realtime') && !$bill_error ) {
854 $bill_error = _do_bop_realtime( $cust_main );
859 my $error = $svc_x->recharge (\%vhash);
860 return { 'error' => $error } if $error;
864 my $error = $bill_error;
865 $error ||= $svc_x->recharge (\%vhash);
866 return { 'error' => $error } if $error;
869 return { error => '', svc => $cust_svc->part_svc->svc };
873 sub _do_bop_realtime {
874 my ($cust_main) = @_;
876 my $old_balance = $cust_main->balance;
878 my $bill_error = $cust_main->bill;
880 $cust_main->apply_payments_and_credits;
881 $bill_error = $cust_main->collect('realtime' => 1);
883 if ( $cust_main->balance > $old_balance
884 && $cust_main->balance > 0
885 && $cust_main->payby !~ /^(BILL|DCRD|DCHK)$/ ) {
886 #this makes sense. credit is "un-doing" the invoice
887 $cust_main->credit( sprintf("%.2f", $cust_main->balance - $old_balance ),
888 'self-service decline' );
889 $cust_main->apply_credits( 'order' => 'newest' );
891 return { 'error' => '_decline', 'bill_error' => $bill_error };
899 my $session = _cache->get($p->{'session_id'})
900 or return { 'error' => "Can't resume session" }; #better error message
902 my $custnum = $session->{'custnum'};
904 my $cust_main = qsearchs('cust_main', { 'custnum' => $custnum } )
905 or return { 'error' => "unknown custnum $custnum" };
907 my $pkgnum = $p->{'pkgnum'};
909 my $cust_pkg = qsearchs('cust_pkg', { 'custnum' => $custnum,
910 'pkgnum' => $pkgnum, } )
911 or return { 'error' => "unknown pkgnum $pkgnum" };
913 my $error = $cust_pkg->cancel( 'quiet'=>1 );
914 return { 'error' => $error };
921 return { 'error' => gettext('passwords_dont_match') }
922 if $p->{'_password'} ne $p->{'_password2'};
923 return { 'error' => gettext('empty_password') }
924 unless length($p->{'_password'});
926 _provision( 'FS::svc_acct',
927 [qw(username _password)],
928 [qw(username _password)],
934 sub provision_external {
936 #_provision( 'FS::svc_external', [qw(id title)], [qw(id title)], $p, @_ );
937 _provision( 'FS::svc_external',
946 my( $class, $fields, $return_fields, $p ) = splice(@_, 0, 4);
948 my($context, $session, $custnum) = _custoragent_session_custnum($p);
949 return { 'error' => $session } if $context eq 'error';
951 my $search = { 'custnum' => $custnum };
952 $search->{'agentnum'} = $session->{'agentnum'} if $context eq 'agent';
953 my $cust_main = qsearchs('cust_main', $search )
954 or return { 'error' => "unknown custnum $custnum" };
956 my $pkgnum = $p->{'pkgnum'};
958 my $cust_pkg = qsearchs('cust_pkg', { 'custnum' => $custnum,
961 or return { 'error' => "unknown pkgnum $pkgnum" };
963 my $part_svc = qsearchs('part_svc', { 'svcpart' => $p->{'svcpart'} } )
964 or return { 'error' => "unknown svcpart $p->{'svcpart'}" };
966 my $svc_x = $class->new( {
967 'pkgnum' => $p->{'pkgnum'},
968 'svcpart' => $p->{'svcpart'},
969 map { $_ => $p->{$_} } @$fields
971 my $error = $svc_x->insert;
972 $svc_x = qsearchs($svc_x->table, { 'svcnum' => $svc_x->svcnum })
975 return { 'svc' => $part_svc->svc,
977 map { $_ => $svc_x->get($_) } @$return_fields
985 my($context, $session, $custnum) = _custoragent_session_custnum($p);
986 return { 'error' => $session } if $context eq 'error';
988 my $search = { 'custnum' => $custnum };
989 $search->{'agentnum'} = $session->{'agentnum'} if $context eq 'agent';
990 my $cust_main = qsearchs('cust_main', $search )
991 or return { 'error' => "unknown custnum $custnum" };
993 my $pkgnum = $p->{'pkgnum'};
995 my $cust_pkg = qsearchs('cust_pkg', { 'custnum' => $custnum,
998 or return { 'error' => "unknown pkgnum $pkgnum" };
1000 my $svcpart = $p->{'svcpart'};
1002 my $pkg_svc = qsearchs('pkg_svc', { 'pkgpart' => $cust_pkg->pkgpart,
1003 'svcpart' => $svcpart, } )
1004 or return { 'error' => "unknown svcpart $svcpart for pkgnum $pkgnum" };
1005 my $part_svc = $pkg_svc->part_svc;
1007 my $conf = new FS::Conf;
1010 'svc' => $part_svc->svc,
1011 'svcdb' => $part_svc->svcdb,
1012 'pkgnum' => $pkgnum,
1013 'svcpart' => $svcpart,
1014 'custnum' => $custnum,
1016 'security_phrase' => 0, #XXX !
1017 'svc_acct_pop' => [], #XXX !
1019 'init_popstate' => '',
1024 small_custview( $cust_main, $conf->config('countrydefault') ),
1030 sub unprovision_svc {
1033 my($context, $session, $custnum) = _custoragent_session_custnum($p);
1034 return { 'error' => $session } if $context eq 'error';
1036 my $search = { 'custnum' => $custnum };
1037 $search->{'agentnum'} = $session->{'agentnum'} if $context eq 'agent';
1038 my $cust_main = qsearchs('cust_main', $search )
1039 or return { 'error' => "unknown custnum $custnum" };
1041 my $svcnum = $p->{'svcnum'};
1043 my $cust_svc = qsearchs('cust_svc', { 'svcnum' => $svcnum, } )
1044 or return { 'error' => "unknown svcnum $svcnum" };
1046 return { 'error' => "Service $svcnum does not belong to customer $custnum" }
1047 unless $cust_svc->cust_pkg->custnum == $custnum;
1049 my $conf = new FS::Conf;
1051 return { 'svc' => $cust_svc->part_svc->svc,
1052 'error' => $cust_svc->cancel,
1054 small_custview( $cust_main, $conf->config('countrydefault') ),
1059 sub myaccount_passwd {
1061 my($context, $session, $custnum) = _custoragent_session_custnum($p);
1062 return { 'error' => $session } if $context eq 'error';
1064 return { 'error' => "New passwords don't match." }
1065 if $p->{'new_password'} ne $p->{'new_password2'};
1067 return { 'error' => 'Enter new password' }
1068 unless length($p->{'new_password'});
1070 #my $search = { 'custnum' => $custnum };
1071 #$search->{'agentnum'} = $session->{'agentnum'} if $context eq 'agent';
1072 $custnum =~ /^(\d+)$/ or die "illegal custnum";
1073 my $search = " AND custnum = $1";
1074 $search .= " AND agentnum = ". $session->{'agentnum'} if $context eq 'agent';
1076 my $svc_acct = qsearchs( {
1077 'table' => 'svc_acct',
1078 'addl_from' => 'LEFT JOIN cust_svc USING ( svcnum ) '.
1079 'LEFT JOIN cust_pkg USING ( pkgnum ) '.
1080 'LEFT JOIN cust_main USING ( custnum ) ',
1081 'hashref' => { 'svcnum' => $p->{'svcnum'}, },
1082 'extra_sql' => $search, #important
1084 or return { 'error' => "Service not found" };
1086 $svc_acct->_password($p->{'new_password'});
1087 my $error = $svc_acct->replace();
1089 my($label, $value) = $svc_acct->cust_svc->label;
1091 return { 'error' => $error,
1100 sub _custoragent_session_custnum {
1103 my($context, $session, $custnum);
1104 if ( $p->{'session_id'} ) {
1106 $context = 'customer';
1107 $session = _cache->get($p->{'session_id'})
1108 or return ( 'error' => "Can't resume session" ); #better error message
1109 $custnum = $session->{'custnum'};
1111 } elsif ( $p->{'agent_session_id'} ) {
1114 my $agent_cache = new FS::ClientAPI_SessionCache( {
1115 'namespace' => 'FS::ClientAPI::Agent',
1117 $session = $agent_cache->get($p->{'agent_session_id'})
1118 or return ( 'error' => "Can't resume session" ); #better error message
1119 $custnum = $p->{'custnum'};
1122 return ( 'error' => "Can't resume session" ); #better error message
1125 ($context, $session, $custnum);