3 # $Id: svc_acct_sm.cgi,v 1.3 1998-12-17 06:17:11 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 # Note: Should be run setuid freeside as user nobody.
12 # should error out in a more CGI-friendly way, and should have more error checking (sigh).
14 # ivan@voicenet.com 97-jan-5
16 # added debugging code; fixed CPU-sucking problem with trying to edit an (unaudited) mail alias (no pkgnum)
18 # ivan@voicenet.com 97-may-7
21 # ivan@voicenet.com 97-jun-4
23 # uid selection across _CUSTOMER_, not just _PACKAGE_
25 # ( i need to be rewritten with fast searches)
27 # ivan@voicenet.com 97-oct-3
29 # added fast searches in some of the places where it is sorely needed...
30 # I see DBI::mysql in your future...
31 # ivan@voicenet.com 97-oct-23
33 # rewrite ivan@sisd.com 98-mar-15
35 # /var/spool/freeside/conf/domain ivan@sisd.com 98-jul-26
37 # $Log: svc_acct_sm.cgi,v $
38 # Revision 1.3 1998-12-17 06:17:11 ivan
39 # fix double // in relative URLs, s/CGI::Base/CGI/;
41 # Revision 1.2 1998/12/16 05:19:15 ivan
48 use CGI::Carp qw(fatalsToBrowser);
49 use FS::UID qw(cgisuidsetup);
50 use FS::CGI qw(header popurl);
51 use FS::Record qw(qsearch qsearchs);
52 use FS::svc_acct_sm qw(fields);
59 my $mydomain = $conf->config('domain');
61 my($action,$svcnum,$svc_acct_sm,$pkgnum,$svcpart,$part_svc);
62 if ( $cgi->query_string =~ /^(\d+)$/ ) { #editing
65 $svc_acct_sm=qsearchs('svc_acct_sm',{'svcnum'=>$svcnum})
66 or die "Unknown (svc_acct_sm) svcnum!";
68 my($cust_svc)=qsearchs('cust_svc',{'svcnum'=>$svcnum})
69 or die "Unknown (cust_svc) svcnum!";
71 $pkgnum=$cust_svc->pkgnum;
72 $svcpart=$cust_svc->svcpart;
74 $part_svc=qsearchs('part_svc',{'svcpart'=>$svcpart});
75 die "No part_svc entry!" unless $part_svc;
81 $svc_acct_sm=create FS::svc_acct_sm({});
83 foreach $_ (split(/-/,$cgi->query_string)) { #get & untaint pkgnum & svcpart
84 $pkgnum=$1 if /^pkgnum(\d+)$/;
85 $svcpart=$1 if /^svcpart(\d+)$/;
87 $part_svc=qsearchs('part_svc',{'svcpart'=>$svcpart});
88 die "No part_svc entry!" unless $part_svc;
92 #set fixed and default fields from part_svc
94 foreach $field ( fields('svc_acct_sm') ) {
95 if ( $part_svc->getfield('svc_acct_sm__'. $field. '_flag') ne '' ) {
96 $svc_acct_sm->setfield($field,$part_svc->getfield('svc_acct_sm__'. $field) );
104 my(%username,%domain);
107 #find all possible uids (and usernames)
109 my($u_part_svc,@u_acct_svcparts);
110 foreach $u_part_svc ( qsearch('part_svc',{'svcdb'=>'svc_acct'}) ) {
111 push @u_acct_svcparts,$u_part_svc->getfield('svcpart');
114 my($cust_pkg)=qsearchs('cust_pkg',{'pkgnum'=>$pkgnum});
115 my($custnum)=$cust_pkg->getfield('custnum');
117 foreach $i_cust_pkg ( qsearch('cust_pkg',{'custnum'=>$custnum}) ) {
118 my($cust_pkgnum)=$i_cust_pkg->getfield('pkgnum');
120 foreach $acct_svcpart (@u_acct_svcparts) { #now find the corresponding
121 #record(s) in cust_svc ( for this
124 foreach $i_cust_svc ( qsearch('cust_svc',{'pkgnum'=>$cust_pkgnum,'svcpart'=>$acct_svcpart}) ) {
125 my($svc_acct)=qsearchs('svc_acct',{'svcnum'=>$i_cust_svc->getfield('svcnum')});
126 $username{$svc_acct->getfield('uid')}=$svc_acct->getfield('username');
131 #find all possible domains (and domsvc's)
133 my($d_part_svc,@d_acct_svcparts);
134 foreach $d_part_svc ( qsearch('part_svc',{'svcdb'=>'svc_domain'}) ) {
135 push @d_acct_svcparts,$d_part_svc->getfield('svcpart');
138 foreach $i_cust_pkg ( qsearch('cust_pkg',{'custnum'=>$custnum}) ) {
139 my($cust_pkgnum)=$i_cust_pkg->getfield('pkgnum');
141 foreach $acct_svcpart (@d_acct_svcparts) {
143 foreach $i_cust_svc ( qsearch('cust_svc',{'pkgnum'=>$cust_pkgnum,'svcpart'=>$acct_svcpart}) ) {
144 my($svc_domain)=qsearch('svc_domain',{'svcnum'=>$i_cust_svc->getfield('svcnum')});
145 $domain{$svc_domain->getfield('svcnum')}=$svc_domain->getfield('domain');
150 } elsif ( $action eq 'Edit' ) {
152 my($svc_acct)=qsearchs('svc_acct',{'uid'=>$svc_acct_sm->domuid});
153 $username{$svc_acct_sm->uid} = $svc_acct->username;
155 my($svc_domain)=qsearchs('svc_domain',{'svcnum'=>$svc_acct_sm->domsvc});
156 $domain{$svc_acct_sm->domsvc} = $svc_domain->domain;
159 die "\$action eq Add, but \$pkgnum is null!\n";
163 print $cgi->header, header("Mail Alias $action", ''), <<END;
164 <FORM ACTION="${p1}process/svc_acct_sm.cgi" METHOD=POST>
173 print qq!<INPUT TYPE="hidden" NAME="svcnum" VALUE="$svcnum">!;
174 print qq!Service #<FONT SIZE=+1><B>!, $svcnum ? $svcnum : " (NEW)", "</B></FONT>";
177 print qq!<INPUT TYPE="hidden" NAME="pkgnum" VALUE="$pkgnum">!;
180 print qq!<INPUT TYPE="hidden" NAME="svcpart" VALUE="$svcpart">!;
182 my($domuser,$domsvc,$domuid)=(
183 $svc_acct_sm->domuser,
184 $svc_acct_sm->domsvc,
185 $svc_acct_sm->domuid,
189 print qq!\n\nMail to <INPUT TYPE="text" NAME="domuser" VALUE="$domuser"> <I>( * for anything )</I>!;
192 print qq! \@ <SELECT NAME="domsvc" SIZE=1>!;
193 foreach $_ (keys %domain) {
194 print "<OPTION", $_ eq $domsvc ? " SELECTED" : "", ">$_: $domain{$_}";
199 print qq!\nforwards to <SELECT NAME="domuid" SIZE=1>!;
200 foreach $_ (keys %username) {
201 print "<OPTION", ($_ eq $domuid) ? " SELECTED" : "", ">$_: $username{$_}";
203 print "</SELECT>\@$mydomain mailbox.";
208 print qq!<CENTER><INPUT TYPE="submit" VALUE="Submit"></CENTER>!;