3 # $Id: svc_acct_sm.cgi,v 1.1 2001-07-30 07:36:04 ivan Exp $
5 # Usage: svc_acct_sm.cgi {svcnum} | pkgnum{pkgnum}-svcpart{svcpart}
6 # http://server.name/path/svc_acct_sm.cgi? {svcnum} | pkgnum{pkgnum}-svcpart{svcpart}
8 # use {svcnum} for edit, pkgnum{pkgnum}-svcpart{svcpart} for add
10 # should error out in a more CGI-friendly way, and should have more error checking (sigh).
12 # ivan@voicenet.com 97-jan-5
14 # added debugging code; fixed CPU-sucking problem with trying to edit an (unaudited) mail alias (no pkgnum)
16 # ivan@voicenet.com 97-may-7
19 # ivan@voicenet.com 97-jun-4
21 # uid selection across _CUSTOMER_, not just _PACKAGE_
23 # ( i need to be rewritten with fast searches)
25 # ivan@voicenet.com 97-oct-3
27 # added fast searches in some of the places where it is sorely needed...
28 # I see DBI::mysql in your future...
29 # ivan@voicenet.com 97-oct-23
31 # rewrite ivan@sisd.com 98-mar-15
33 # /var/spool/freeside/conf/domain ivan@sisd.com 98-jul-26
35 # $Log: svc_acct_sm.cgi,v $
36 # Revision 1.1 2001-07-30 07:36:04 ivan
39 # Revision 1.9 1999/02/28 00:03:38 ivan
40 # removed misleading comments
42 # Revision 1.8 1999/02/07 09:59:24 ivan
43 # more mod_perl fixes, and bugfixes Peter Wemm sent via email
45 # Revision 1.7 1999/01/19 05:13:45 ivan
46 # for mod_perl: no more top-level my() variables; use vars instead
47 # also the last s/create/new/;
49 # Revision 1.6 1999/01/18 09:41:34 ivan
50 # all $cgi->header calls now include ( '-expires' => 'now' ) for mod_perl
53 # Revision 1.5 1998/12/30 23:03:24 ivan
54 # bugfixes; fields isn't exported by derived classes
56 # Revision 1.4 1998/12/23 02:58:45 ivan
57 # $cgi->keywords instead of $cgi->query_string
59 # Revision 1.3 1998/12/17 06:17:11 ivan
60 # fix double // in relative URLs, s/CGI::Base/CGI/;
62 # Revision 1.2 1998/12/16 05:19:15 ivan
67 use vars qw( $conf $cgi $mydomain $action $svcnum $svc_acct_sm $pkgnum $svcpart
68 $part_svc $query %username %domain $p1 $domuser $domsvc $domuid );
70 use CGI::Carp qw(fatalsToBrowser);
71 use FS::UID qw(cgisuidsetup);
72 use FS::CGI qw(header popurl);
73 use FS::Record qw(qsearch qsearchs fields);
81 $mydomain = $conf->config('domain');
83 if ( $cgi->param('error') ) {
84 $svc_acct_sm = new FS::svc_acct_sm ( {
85 map { $_, scalar($cgi->param($_)) } fields('svc_acct_sm')
87 $svcnum = $svc_acct_sm->svcnum;
88 $pkgnum = $cgi->param('pkgnum');
89 $svcpart = $cgi->param('svcpart');
90 $part_svc=qsearchs('part_svc',{'svcpart'=>$svcpart});
91 die "No part_svc entry!" unless $part_svc;
93 my($query) = $cgi->keywords;
94 if ( $query =~ /^(\d+)$/ ) { #editing
96 $svc_acct_sm=qsearchs('svc_acct_sm',{'svcnum'=>$svcnum})
97 or die "Unknown (svc_acct_sm) svcnum!";
99 my($cust_svc)=qsearchs('cust_svc',{'svcnum'=>$svcnum})
100 or die "Unknown (cust_svc) svcnum!";
102 $pkgnum=$cust_svc->pkgnum;
103 $svcpart=$cust_svc->svcpart;
105 $part_svc=qsearchs('part_svc',{'svcpart'=>$svcpart});
106 die "No part_svc entry!" unless $part_svc;
110 $svc_acct_sm = new FS::svc_acct_sm({});
112 foreach $_ (split(/-/,$query)) { #get & untaint pkgnum & svcpart
113 $pkgnum=$1 if /^pkgnum(\d+)$/;
114 $svcpart=$1 if /^svcpart(\d+)$/;
116 $part_svc=qsearchs('part_svc',{'svcpart'=>$svcpart});
117 die "No part_svc entry!" unless $part_svc;
121 #set fixed and default fields from part_svc
123 foreach $field ( fields('svc_acct_sm') ) {
124 if ( $part_svc->getfield('svc_acct_sm__'. $field. '_flag') ne '' ) {
125 $svc_acct_sm->setfield($field,$part_svc->getfield('svc_acct_sm__'. $field) );
131 $action = $svc_acct_sm->svcnum ? 'Edit' : 'Add';
135 #find all possible uids (and usernames)
137 my($u_part_svc,@u_acct_svcparts);
138 foreach $u_part_svc ( qsearch('part_svc',{'svcdb'=>'svc_acct'}) ) {
139 push @u_acct_svcparts,$u_part_svc->getfield('svcpart');
142 my($cust_pkg)=qsearchs('cust_pkg',{'pkgnum'=>$pkgnum});
143 my($custnum)=$cust_pkg->getfield('custnum');
145 foreach $i_cust_pkg ( qsearch('cust_pkg',{'custnum'=>$custnum}) ) {
146 my($cust_pkgnum)=$i_cust_pkg->getfield('pkgnum');
148 foreach $acct_svcpart (@u_acct_svcparts) { #now find the corresponding
149 #record(s) in cust_svc ( for this
152 foreach $i_cust_svc ( qsearch('cust_svc',{'pkgnum'=>$cust_pkgnum,'svcpart'=>$acct_svcpart}) ) {
153 my($svc_acct)=qsearchs('svc_acct',{'svcnum'=>$i_cust_svc->getfield('svcnum')});
154 $username{$svc_acct->getfield('uid')}=$svc_acct->getfield('username');
159 #find all possible domains (and domsvc's)
161 my($d_part_svc,@d_acct_svcparts);
162 foreach $d_part_svc ( qsearch('part_svc',{'svcdb'=>'svc_domain'}) ) {
163 push @d_acct_svcparts,$d_part_svc->getfield('svcpart');
166 foreach $i_cust_pkg ( qsearch('cust_pkg',{'custnum'=>$custnum}) ) {
167 my($cust_pkgnum)=$i_cust_pkg->getfield('pkgnum');
169 foreach $acct_svcpart (@d_acct_svcparts) {
171 foreach $i_cust_svc ( qsearch('cust_svc',{'pkgnum'=>$cust_pkgnum,'svcpart'=>$acct_svcpart}) ) {
172 my($svc_domain)=qsearch('svc_domain',{'svcnum'=>$i_cust_svc->getfield('svcnum')});
173 $domain{$svc_domain->getfield('svcnum')}=$svc_domain->getfield('domain');
178 } elsif ( $action eq 'Edit' ) {
180 my($svc_acct)=qsearchs('svc_acct',{'uid'=>$svc_acct_sm->domuid});
181 $username{$svc_acct_sm->uid} = $svc_acct->username;
183 my($svc_domain)=qsearchs('svc_domain',{'svcnum'=>$svc_acct_sm->domsvc});
184 $domain{$svc_acct_sm->domsvc} = $svc_domain->domain;
187 die "\$action eq Add, but \$pkgnum is null!\n";
191 print $cgi->header( '-expires' => 'now' ), header("Mail Alias $action", '');
193 print qq!<FONT SIZE="+1" COLOR="#ff0000">Error: !, $cgi->param('error'),
195 if $cgi->param('error');
197 print qq!<FORM ACTION="${p1}process/svc_acct_sm.cgi" METHOD=POST>!;
205 print qq!<INPUT TYPE="hidden" NAME="svcnum" VALUE="$svcnum">!;
206 print qq!Service #<FONT SIZE=+1><B>!, $svcnum ? $svcnum : " (NEW)", "</B></FONT>";
209 print qq!<INPUT TYPE="hidden" NAME="pkgnum" VALUE="$pkgnum">!;
212 print qq!<INPUT TYPE="hidden" NAME="svcpart" VALUE="$svcpart">!;
214 ($domuser,$domsvc,$domuid)=(
215 $svc_acct_sm->domuser,
216 $svc_acct_sm->domsvc,
217 $svc_acct_sm->domuid,
221 print qq!\n\nMail to <INPUT TYPE="text" NAME="domuser" VALUE="$domuser"> <I>( * for anything )</I>!;
224 print qq! \@ <SELECT NAME="domsvc" SIZE=1>!;
225 foreach $_ (keys %domain) {
226 print "<OPTION", $_ eq $domsvc ? " SELECTED" : "",
227 qq! VALUE="$_">$domain{$_}!;
232 print qq!\nforwards to <SELECT NAME="domuid" SIZE=1>!;
233 foreach $_ (keys %username) {
234 print "<OPTION", ($_ eq $domuid) ? " SELECTED" : "",
235 qq! VALUE="$_">$username{$_}!;
237 print "</SELECT>\@$mydomain mailbox.";
242 print qq!<CENTER><INPUT TYPE="submit" VALUE="Submit"></CENTER>!;