1 package FS::ClientAPI::MyAccount;
6 use Digest::MD5 qw(md5_hex);
8 use Business::CreditCard;
10 use FS::CGI qw(small_custview); #doh
13 use FS::Record qw(qsearch qsearchs);
14 use FS::Msgcat qw(gettext);
15 use FS::Misc qw(card_types);
16 use FS::ClientAPI_SessionCache;
23 use FS::cust_main_county;
26 use vars qw( @cust_main_editable_fields );
27 @cust_main_editable_fields = qw(
28 first last company address1 address2 city
29 county state zip country daytime night fax
30 ship_first ship_last ship_company ship_address1 ship_address2 ship_city
31 ship_state ship_zip ship_country ship_daytime ship_night ship_fax
32 payby payinfo payname paystart_month paystart_year payissue payip
35 use subs qw(_provision);
38 $cache ||= new FS::ClientAPI_SessionCache( {
39 'namespace' => 'FS::ClientAPI::MyAccount',
43 #false laziness w/FS::ClientAPI::passwd::passwd
47 my $svc_domain = qsearchs('svc_domain', { 'domain' => $p->{'domain'} } )
48 or return { error => 'Domain '. $p->{'domain'}. ' not found' };
50 my $svc_acct = qsearchs( 'svc_acct', { 'username' => $p->{'username'},
51 'domsvc' => $svc_domain->svcnum, }
53 return { error => 'User not found.' } unless $svc_acct;
55 my $conf = new FS::Conf;
56 my $pkg_svc = $svc_acct->cust_svc->pkg_svc;
57 return { error => 'Only primary user may log in.' }
58 if $conf->exists('selfservice_server-primary_only')
59 && ( ! $pkg_svc || $pkg_svc->primary_svc ne 'Y' );
61 return { error => 'Incorrect password.' }
62 unless $svc_acct->check_password($p->{'password'});
65 'svcnum' => $svc_acct->svcnum,
68 my $cust_pkg = $svc_acct->cust_svc->cust_pkg;
70 my $cust_main = $cust_pkg->cust_main;
71 $session->{'custnum'} = $cust_main->custnum;
76 $session_id = md5_hex(md5_hex(time(). {}. rand(). $$))
77 } until ( ! defined _cache->get($session_id) ); #just in case
79 _cache->set( $session_id, $session, '1 hour' );
81 return { 'error' => '',
82 'session_id' => $session_id,
88 if ( $p->{'session_id'} ) {
89 _cache->remove($p->{'session_id'});
90 return { 'error' => '' };
92 return { 'error' => "Can't resume session" }; #better error message
99 my($context, $session, $custnum) = _custoragent_session_custnum($p);
100 return { 'error' => $session } if $context eq 'error';
103 if ( $custnum ) { #customer record
105 my $search = { 'custnum' => $custnum };
106 $search->{'agentnum'} = $session->{'agentnum'} if $context eq 'agent';
107 my $cust_main = qsearchs('cust_main', $search )
108 or return { 'error' => "unknown custnum $custnum" };
110 $return{balance} = $cust_main->balance;
114 invnum => $_->invnum,
115 date => time2str("%b %o, %Y", $_->_date),
118 } $cust_main->open_cust_bill;
119 $return{open_invoices} = \@open;
121 my $conf = new FS::Conf;
122 $return{small_custview} =
123 small_custview( $cust_main, $conf->config('countrydefault') );
125 $return{name} = $cust_main->first. ' '. $cust_main->get('last');
127 for (@cust_main_editable_fields) {
128 $return{$_} = $cust_main->get($_);
131 if ( $cust_main->payby =~ /^(CARD|DCRD)$/ ) {
132 $return{payinfo} = $cust_main->payinfo_masked;
133 @return{'month', 'year'} = $cust_main->paydate_monthyear;
136 $return{'invoicing_list'} =
137 join(', ', grep { $_ !~ /^(POST|FAX)$/ } $cust_main->invoicing_list );
138 $return{'postal_invoicing'} =
139 0 < ( grep { $_ eq 'POST' } $cust_main->invoicing_list );
141 } elsif ( $session->{'svcnum'} ) { #no customer record
143 my $svc_acct = qsearchs('svc_acct', { 'svcnum' => $session->{'svcnum'} } )
144 or die "unknown svcnum";
145 $return{name} = $svc_acct->email;
149 return { 'error' => 'Expired session' }; #XXX redirect to login w/this err!
153 return { 'error' => '',
154 'custnum' => $custnum,
162 my $session = _cache->get($p->{'session_id'})
163 or return { 'error' => "Can't resume session" }; #better error message
165 my $custnum = $session->{'custnum'}
166 or return { 'error' => "no customer record" };
168 my $cust_main = qsearchs('cust_main', { 'custnum' => $custnum } )
169 or return { 'error' => "unknown custnum $custnum" };
171 my $new = new FS::cust_main { $cust_main->hash };
172 $new->set( $_ => $p->{$_} )
173 foreach grep { exists $p->{$_} } @cust_main_editable_fields;
175 if ( $p->{'payby'} =~ /^(CARD|DCRD)$/ ) {
176 $new->paydate($p->{'year'}. '-'. $p->{'month'}. '-01');
177 if ( $new->payinfo eq $cust_main->payinfo_masked ) {
178 $new->payinfo($cust_main->payinfo);
180 $new->paycvv($p->{'paycvv'});
185 if ( exists $p->{'invoicing_list'} || exists $p->{'postal_invoicing'} ) {
186 #false laziness with httemplate/edit/process/cust_main.cgi
187 @invoicing_list = split( /\s*\,\s*/, $p->{'invoicing_list'} );
188 push @invoicing_list, 'POST' if $p->{'postal_invoicing'};
190 @invoicing_list = $cust_main->invoicing_list;
193 my $error = $new->replace($cust_main, \@invoicing_list);
194 return { 'error' => $error } if $error;
197 return { 'error' => '' };
202 my $session = _cache->get($p->{'session_id'})
203 or return { 'error' => "Can't resume session" }; #better error message
209 use vars qw($payment_info); #cache for performance
210 unless ( $payment_info ) {
212 my $conf = new FS::Conf;
213 my %states = map { $_->state => 1 }
214 qsearch('cust_main_county', {
215 'country' => $conf->config('countrydefault') || 'US'
220 #list all counties/states/countries
221 'cust_main_county' =>
222 [ map { $_->hashref } qsearch('cust_main_county', {}) ],
224 #shortcut for one-country folks
226 [ sort { $a cmp $b } keys %states ],
228 'card_types' => card_types(),
238 my %return = %$payment_info;
240 my $custnum = $session->{'custnum'};
242 my $cust_main = qsearchs('cust_main', { 'custnum' => $custnum } )
243 or return { 'error' => "unknown custnum $custnum" };
245 $return{balance} = $cust_main->balance;
247 $return{payname} = $cust_main->payname
248 || ( $cust_main->first. ' '. $cust_main->get('last') );
250 $return{$_} = $cust_main->get($_) for qw(address1 address2 city state zip);
252 $return{payby} = $cust_main->payby;
254 if ( $cust_main->payby =~ /^(CARD|DCRD)$/ ) {
255 $return{card_type} = cardtype($cust_main->payinfo);
256 $return{payinfo} = $cust_main->payinfo;
258 @return{'month', 'year'} = $cust_main->paydate_monthyear;
262 #doubleclick protection
264 $return{paybatch} = "webui-MyAccount-$_date-$$-". rand() * 2**32;
266 return { 'error' => '',
272 #some false laziness with httemplate/process/payment.cgi - look there for
273 #ACH and CVV support stuff
274 sub process_payment {
278 my $session = _cache->get($p->{'session_id'})
279 or return { 'error' => "Can't resume session" }; #better error message
283 my $custnum = $session->{'custnum'};
285 my $cust_main = qsearchs('cust_main', { 'custnum' => $custnum } )
286 or return { 'error' => "unknown custnum $custnum" };
288 $p->{'payname'} =~ /^([\w \,\.\-\']+)$/
289 or return { 'error' => gettext('illegal_name'). " payname: ". $p->{'payname'} };
292 $p->{'paybatch'} =~ /^([\w \!\@\#\$\%\&\(\)\-\+\;\:\'\"\,\.\?\/\=]*)$/
293 or return { 'error' => gettext('illegal_text'). " paybatch: ". $p->{'paybatch'} };
298 #if ( $payby eq 'CHEK' ) {
300 # $p->{'payinfo1'} =~ /^(\d+)$/
301 # or return { 'error' => "illegal account number ". $p->{'payinfo1'} };
303 # $p->{'payinfo2'} =~ /^(\d+)$/
304 # or return { 'error' => "illegal ABA/routing number ". $p->{'payinfo2'} };
306 # $payinfo = $payinfo1. '@'. $payinfo2;
308 #} elsif ( $payby eq 'CARD' ) {
310 $payinfo = $p->{'payinfo'};
312 $payinfo =~ /^(\d{13,16})$/
313 or return { 'error' => gettext('invalid_card') }; # . ": ". $self->payinfo
316 or return { 'error' => gettext('invalid_card') }; # . ": ". $self->payinfo
317 return { 'error' => gettext('unknown_card_type') }
318 if cardtype($payinfo) eq "Unknown";
320 if ( defined $cust_main->dbdef_table->column('paycvv') ) {
321 if ( length($p->{'paycvv'} ) ) {
322 if ( cardtype($payinfo) eq 'American Express card' ) {
323 $p->{'paycvv'} =~ /^(\d{4})$/
324 or return { 'error' => "CVV2 (CID) for American Express cards is four digits." };
327 $p->{'paycvv'} =~ /^(\d{3})$/
328 or return { 'error' => "CVV2 (CVC2/CID) is three digits." };
335 # die "unknown payby $payby";
338 my $error = $cust_main->realtime_bop( 'CC', $p->{'amount'},
340 'payinfo' => $payinfo,
341 'paydate' => $p->{'year'}. '-'. $p->{'month'}. '-01',
342 'payname' => $payname,
343 'paybatch' => $paybatch,
345 map { $_ => $p->{$_} } qw( paystart_month paystart_year payissue payip
346 address1 address2 city state zip )
348 return { 'error' => $error } if $error;
350 $cust_main->apply_payments;
352 if ( $p->{'save'} ) {
353 my $new = new FS::cust_main { $cust_main->hash };
354 $new->set( $_ => $p->{$_} )
355 foreach qw( payname paystart_month paystart_year payissue payip
356 address1 address2 city state zip payinfo );
357 $new->set( 'paydate' => $p->{'year'}. '-'. $p->{'month'}. '-01' );
358 $new->set( 'payby' => $p->{'auto'} ? 'CARD' : 'DCRD' );
359 my $error = $new->replace($cust_main);
360 return { 'error' => $error } if $error;
364 return { 'error' => '' };
372 my $session = _cache->get($p->{'session_id'})
373 or return { 'error' => "Can't resume session" }; #better error message
377 my $custnum = $session->{'custnum'};
379 my $cust_main = qsearchs('cust_main', { 'custnum' => $custnum } )
380 or return { 'error' => "unknown custnum $custnum" };
382 my( $amount, $seconds, $upbytes, $downbytes ) = ( 0, 0, 0, 0 );
383 my $error = $cust_main->recharge_prepay( $p->{'prepaid_cardnum'},
390 return { 'error' => $error } if $error;
392 return { 'error' => '',
394 'seconds' => $seconds,
395 'duration' => duration_exact($seconds),
396 'upbytes' => $upbytes,
397 'upload' => FS::UI::Web::bytecount_unexact($upbytes),
398 'downbytes'=> $downbytes,
399 'download' => FS::UI::Web::bytecount_unexact($downbytes),
406 my $session = _cache->get($p->{'session_id'})
407 or return { 'error' => "Can't resume session" }; #better error message
409 my $custnum = $session->{'custnum'};
411 my $invnum = $p->{'invnum'};
413 my $cust_bill = qsearchs('cust_bill', { 'invnum' => $invnum,
414 'custnum' => $custnum } )
415 or return { 'error' => "Can't find invnum" };
419 return { 'error' => '',
421 'invoice_text' => join('', $cust_bill->print_text ),
422 'invoice_html' => $cust_bill->print_html,
430 #sessioning for this? how do we get the session id to the backend invoice
431 # template so it can add it to the link, blah
433 my $templatename = $p->{'templatename'};
435 #false laziness-ish w/view/cust_bill-logo.cgi
437 my $conf = new FS::Conf;
438 if ( $templatename =~ /^([^\.\/]*)$/ && $conf->exists("logo_$1.png") ) {
439 $templatename = "_$1";
444 my $filename = "logo$templatename.png";
446 return { 'error' => '',
447 'logo' => $conf->config_binary($filename),
448 'content_type' => 'image/png', #should allow gif, jpg too
455 my $session = _cache->get($p->{'session_id'})
456 or return { 'error' => "Can't resume session" }; #better error message
458 my $custnum = $session->{'custnum'};
460 my $cust_main = qsearchs('cust_main', { 'custnum' => $custnum } )
461 or return { 'error' => "unknown custnum $custnum" };
463 my @cust_bill = $cust_main->cust_bill;
465 return { 'error' => '',
466 'invoices' => [ map { { 'invnum' => $_->invnum,
467 '_date' => $_->_date,
476 my $session = _cache->get($p->{'session_id'})
477 or return { 'error' => "Can't resume session" }; #better error message
479 my $custnum = $session->{'custnum'};
481 my $cust_main = qsearchs('cust_main', { 'custnum' => $custnum } )
482 or return { 'error' => "unknown custnum $custnum" };
484 my @errors = $cust_main->cancel( 'quiet'=>1 );
486 my $error = scalar(@errors) ? join(' / ', @errors) : '';
488 return { 'error' => $error };
495 my($context, $session, $custnum) = _custoragent_session_custnum($p);
496 return { 'error' => $session } if $context eq 'error';
498 my $search = { 'custnum' => $custnum };
499 $search->{'agentnum'} = $session->{'agentnum'} if $context eq 'agent';
500 my $cust_main = qsearchs('cust_main', $search )
501 or return { 'error' => "unknown custnum $custnum" };
503 #return { 'cust_pkg' => [ map { $_->hashref } $cust_main->ncancelled_pkgs ] };
505 my $conf = new FS::Conf;
507 { 'svcnum' => $session->{'svcnum'},
508 'custnum' => $custnum,
509 'cust_pkg' => [ map {
513 [ map $_->hashref, $_->available_part_svc ],
515 [ map { my $ref = { $_->hash,
516 label => [ $_->label ],
518 $ref->{_password} = $_->svc_x->_password
519 if $context eq 'agent'
520 && $conf->exists('agent-showpasswords')
521 && $_->part_svc->svcdb eq 'svc_acct';
526 } $cust_main->ncancelled_pkgs
529 small_custview( $cust_main, $conf->config('countrydefault') ),
539 my($context, $session, $custnum) = _custoragent_session_custnum($p);
540 return { 'error' => $session } if $context eq 'error';
542 my $search = { 'custnum' => $custnum };
543 $search->{'agentnum'} = $session->{'agentnum'} if $context eq 'agent';
544 my $cust_main = qsearchs('cust_main', $search )
545 or return { 'error' => "unknown custnum $custnum" };
548 #foreach my $cust_pkg ( $cust_main->ncancelled_pkgs ) {
549 foreach my $cust_pkg ( $p->{'ncancelled'}
550 ? $cust_main->ncancelled_pkgs
551 : $cust_main->unsuspended_pkgs ) {
552 push @cust_svc, @{[ $cust_pkg->cust_svc ]}; #@{[ ]} to force array context
554 @cust_svc = grep { $_->part_svc->svcdb eq $p->{'svcdb'} } @cust_svc
557 #@svc_x = sort { $a->domain cmp $b->domain || $a->username cmp $b->username }
561 #no#'svcnum' => $session->{'svcnum'},
562 'custnum' => $custnum,
564 my $svc_x = $_->svc_x;
565 my($label, $value) = $_->label;
567 { 'svcnum' => $_->svcnum,
570 'username' => $svc_x->username,
571 'email' => $svc_x->email,
572 'seconds' => $svc_x->seconds,
573 'upbytes' => $svc_x->upbytes,
574 'downbytes'=> $svc_x->downbytes,
587 my($context, $session, $custnum) = _custoragent_session_custnum($p);
588 return { 'error' => $session } if $context eq 'error';
590 my $search = { 'custnum' => $custnum };
591 $search->{'agentnum'} = $session->{'agentnum'} if $context eq 'agent';
592 my $cust_main = qsearchs('cust_main', $search )
593 or return { 'error' => "unknown custnum $custnum" };
595 #false laziness w/ClientAPI/Signup.pm
597 my $cust_pkg = new FS::cust_pkg ( {
598 'custnum' => $custnum,
599 'pkgpart' => $p->{'pkgpart'},
601 my $error = $cust_pkg->check;
602 return { 'error' => $error } if $error;
605 unless ( $p->{'svcpart'} eq 'none' ) {
609 if ( $p->{'svcpart'} =~ /^(\d+)$/ ) {
611 my $part_svc = qsearchs('part_svc', { 'svcpart' => $svcpart } );
612 return { 'error' => "Unknown svcpart $svcpart" } unless $part_svc;
613 $svcdb = $part_svc->svcdb;
617 $svcpart ||= $cust_pkg->part_pkg->svcpart($svcdb);
620 'svc_acct' => [ qw( username _password sec_phrase popnum ) ],
621 'svc_domain' => [ qw( domain ) ],
622 'svc_external' => [ qw( id title ) ],
625 my $svc_x = "FS::$svcdb"->new( {
626 'svcpart' => $svcpart,
627 map { $_ => $p->{$_} } @{$fields{$svcdb}}
630 if ( $svcdb eq 'svc_acct' ) {
633 while ( length($p->{"snarf_machine$snarfnum"}) ) {
634 my $acct_snarf = new FS::acct_snarf ( {
635 'machine' => $p->{"snarf_machine$snarfnum"},
636 'protocol' => $p->{"snarf_protocol$snarfnum"},
637 'username' => $p->{"snarf_username$snarfnum"},
638 '_password' => $p->{"snarf_password$snarfnum"},
641 push @acct_snarf, $acct_snarf;
643 $svc_x->child_objects( \@acct_snarf );
646 my $y = $svc_x->setdefault; # arguably should be in new method
647 return { 'error' => $y } if $y && !ref($y);
649 $error = $svc_x->check;
650 return { 'error' => $error } if $error;
657 tie my %hash, 'Tie::RefHash';
658 %hash = ( $cust_pkg => \@svc );
660 $error = $cust_main->order_pkgs( \%hash, '', 'noexport' => 1 );
661 return { 'error' => $error } if $error;
663 my $conf = new FS::Conf;
664 if ( $conf->exists('signup_server-realtime') ) {
666 my $old_balance = $cust_main->balance;
668 my $bill_error = $cust_main->bill;
669 $cust_main->apply_payments;
670 $cust_main->apply_credits;
671 $bill_error = $cust_main->collect('realtime' => 1);
673 if ( $cust_main->balance > $old_balance
674 && $cust_main->balance > 0
675 && $cust_main->payby !~ /^(BILL|DCRD|DCHK)$/ ) {
676 #this makes sense. credit is "un-doing" the invoice
677 $cust_main->credit( sprintf("%.2f", $cust_main->balance - $old_balance ),
678 'self-service decline' );
679 $cust_main->apply_credits( 'order' => 'newest' );
681 $cust_pkg->cancel('quiet'=>1);
682 return { 'error' => '_decline', 'bill_error' => $bill_error };
691 return { error => '', pkgnum => $cust_pkg->pkgnum };
697 my $session = _cache->get($p->{'session_id'})
698 or return { 'error' => "Can't resume session" }; #better error message
700 my $custnum = $session->{'custnum'};
702 my $cust_main = qsearchs('cust_main', { 'custnum' => $custnum } )
703 or return { 'error' => "unknown custnum $custnum" };
705 my $pkgnum = $p->{'pkgnum'};
707 my $cust_pkg = qsearchs('cust_pkg', { 'custnum' => $custnum,
708 'pkgnum' => $pkgnum, } )
709 or return { 'error' => "unknown pkgnum $pkgnum" };
711 my $error = $cust_pkg->cancel( 'quiet'=>1 );
712 return { 'error' => $error };
719 return { 'error' => gettext('passwords_dont_match') }
720 if $p->{'_password'} ne $p->{'_password2'};
721 return { 'error' => gettext('empty_password') }
722 unless length($p->{'_password'});
724 _provision( 'FS::svc_acct',
725 [qw(username _password)],
726 [qw(username _password)],
732 sub provision_external {
734 #_provision( 'FS::svc_external', [qw(id title)], [qw(id title)], $p, @_ );
735 _provision( 'FS::svc_external',
744 my( $class, $fields, $return_fields, $p ) = splice(@_, 0, 4);
746 my($context, $session, $custnum) = _custoragent_session_custnum($p);
747 return { 'error' => $session } if $context eq 'error';
749 my $search = { 'custnum' => $custnum };
750 $search->{'agentnum'} = $session->{'agentnum'} if $context eq 'agent';
751 my $cust_main = qsearchs('cust_main', $search )
752 or return { 'error' => "unknown custnum $custnum" };
754 my $pkgnum = $p->{'pkgnum'};
756 my $cust_pkg = qsearchs('cust_pkg', { 'custnum' => $custnum,
759 or return { 'error' => "unknown pkgnum $pkgnum" };
761 my $part_svc = qsearchs('part_svc', { 'svcpart' => $p->{'svcpart'} } )
762 or return { 'error' => "unknown svcpart $p->{'svcpart'}" };
764 my $svc_x = $class->new( {
765 'pkgnum' => $p->{'pkgnum'},
766 'svcpart' => $p->{'svcpart'},
767 map { $_ => $p->{$_} } @$fields
769 my $error = $svc_x->insert;
770 $svc_x = qsearchs($svc_x->table, { 'svcnum' => $svc_x->svcnum })
773 return { 'svc' => $part_svc->svc,
775 map { $_ => $svc_x->get($_) } @$return_fields
783 my($context, $session, $custnum) = _custoragent_session_custnum($p);
784 return { 'error' => $session } if $context eq 'error';
786 my $search = { 'custnum' => $custnum };
787 $search->{'agentnum'} = $session->{'agentnum'} if $context eq 'agent';
788 my $cust_main = qsearchs('cust_main', $search )
789 or return { 'error' => "unknown custnum $custnum" };
791 my $pkgnum = $p->{'pkgnum'};
793 my $cust_pkg = qsearchs('cust_pkg', { 'custnum' => $custnum,
796 or return { 'error' => "unknown pkgnum $pkgnum" };
798 my $svcpart = $p->{'svcpart'};
800 my $pkg_svc = qsearchs('pkg_svc', { 'pkgpart' => $cust_pkg->pkgpart,
801 'svcpart' => $svcpart, } )
802 or return { 'error' => "unknown svcpart $svcpart for pkgnum $pkgnum" };
803 my $part_svc = $pkg_svc->part_svc;
805 my $conf = new FS::Conf;
808 'svc' => $part_svc->svc,
809 'svcdb' => $part_svc->svcdb,
811 'svcpart' => $svcpart,
812 'custnum' => $custnum,
814 'security_phrase' => 0, #XXX !
815 'svc_acct_pop' => [], #XXX !
817 'init_popstate' => '',
822 small_custview( $cust_main, $conf->config('countrydefault') ),
828 sub unprovision_svc {
831 my($context, $session, $custnum) = _custoragent_session_custnum($p);
832 return { 'error' => $session } if $context eq 'error';
834 my $search = { 'custnum' => $custnum };
835 $search->{'agentnum'} = $session->{'agentnum'} if $context eq 'agent';
836 my $cust_main = qsearchs('cust_main', $search )
837 or return { 'error' => "unknown custnum $custnum" };
839 my $svcnum = $p->{'svcnum'};
841 my $cust_svc = qsearchs('cust_svc', { 'svcnum' => $svcnum, } )
842 or return { 'error' => "unknown svcnum $svcnum" };
844 return { 'error' => "Service $svcnum does not belong to customer $custnum" }
845 unless $cust_svc->cust_pkg->custnum == $custnum;
847 my $conf = new FS::Conf;
849 return { 'svc' => $cust_svc->part_svc->svc,
850 'error' => $cust_svc->cancel,
852 small_custview( $cust_main, $conf->config('countrydefault') ),
857 sub myaccount_passwd {
859 my($context, $session, $custnum) = _custoragent_session_custnum($p);
860 return { 'error' => $session } if $context eq 'error';
862 return { 'error' => "New passwords don't match." }
863 if $p->{'new_password'} ne $p->{'new_password2'};
865 return { 'error' => 'Enter new password' }
866 unless length($p->{'new_password'});
868 #my $search = { 'custnum' => $custnum };
869 #$search->{'agentnum'} = $session->{'agentnum'} if $context eq 'agent';
870 $custnum =~ /^(\d+)$/ or die "illegal custnum";
871 my $search = " AND custnum = $1";
872 $search .= " AND agentnum = ". $session->{'agentnum'} if $context eq 'agent';
874 my $svc_acct = qsearchs( {
875 'table' => 'svc_acct',
876 'addl_from' => 'LEFT JOIN cust_svc USING ( svcnum ) '.
877 'LEFT JOIN cust_pkg USING ( pkgnum ) '.
878 'LEFT JOIN cust_main USING ( custnum ) ',
879 'hashref' => { 'svcnum' => $p->{'svcnum'}, },
880 'extra_sql' => $search, #important
882 or return { 'error' => "Service not found" };
884 $svc_acct->_password($p->{'new_password'});
885 my $error = $svc_acct->replace();
887 my($label, $value) = $svc_acct->cust_svc->label;
889 return { 'error' => $error,
898 sub _custoragent_session_custnum {
901 my($context, $session, $custnum);
902 if ( $p->{'session_id'} ) {
904 $context = 'customer';
905 $session = _cache->get($p->{'session_id'})
906 or return ( 'error' => "Can't resume session" ); #better error message
907 $custnum = $session->{'custnum'};
909 } elsif ( $p->{'agent_session_id'} ) {
912 my $agent_cache = new FS::ClientAPI_SessionCache( {
913 'namespace' => 'FS::ClientAPI::Agent',
915 $session = $agent_cache->get($p->{'agent_session_id'})
916 or return ( 'error' => "Can't resume session" ); #better error message
917 $custnum = $p->{'custnum'};
920 return ( 'error' => "Can't resume session" ); #better error message
923 ($context, $session, $custnum);