2 #<!-- $Id: svc_acct_sm.cgi,v 1.6 2001-10-30 14:54:07 ivan Exp $ -->
5 use vars qw( $conf $cgi $mydomain $action $svcnum $svc_acct_sm $pkgnum $svcpart
6 $part_svc $query %username %domain $p1 $domuser $domsvc $domuid );
8 use CGI::Carp qw(fatalsToBrowser);
9 use FS::UID qw(cgisuidsetup);
10 use FS::CGI qw(header popurl);
11 use FS::Record qw(qsearch qsearchs fields);
19 $mydomain = $conf->config('domain');
21 if ( $cgi->param('error') ) {
22 $svc_acct_sm = new FS::svc_acct_sm ( {
23 map { $_, scalar($cgi->param($_)) } fields('svc_acct_sm')
25 $svcnum = $svc_acct_sm->svcnum;
26 $pkgnum = $cgi->param('pkgnum');
27 $svcpart = $cgi->param('svcpart');
28 $part_svc=qsearchs('part_svc',{'svcpart'=>$svcpart});
29 die "No part_svc entry!" unless $part_svc;
31 my($query) = $cgi->keywords;
32 if ( $query =~ /^(\d+)$/ ) { #editing
34 $svc_acct_sm=qsearchs('svc_acct_sm',{'svcnum'=>$svcnum})
35 or die "Unknown (svc_acct_sm) svcnum!";
37 my($cust_svc)=qsearchs('cust_svc',{'svcnum'=>$svcnum})
38 or die "Unknown (cust_svc) svcnum!";
40 $pkgnum=$cust_svc->pkgnum;
41 $svcpart=$cust_svc->svcpart;
43 $part_svc=qsearchs('part_svc',{'svcpart'=>$svcpart});
44 die "No part_svc entry!" unless $part_svc;
48 $svc_acct_sm = new FS::svc_acct_sm({});
50 foreach $_ (split(/-/,$query)) { #get & untaint pkgnum & svcpart
51 $pkgnum=$1 if /^pkgnum(\d+)$/;
52 $svcpart=$1 if /^svcpart(\d+)$/;
54 $part_svc=qsearchs('part_svc',{'svcpart'=>$svcpart});
55 die "No part_svc entry!" unless $part_svc;
59 #set fixed and default fields from part_svc
60 foreach my $part_svc_column (
61 grep { $_->columnflag } $part_svc->all_part_svc_column
63 $svc_acct_sm->setfield( $part_svc_column->columnname,
64 $part_svc_column->columnvalue,
70 $action = $svc_acct_sm->svcnum ? 'Edit' : 'Add';
74 #find all possible uids (and usernames)
76 my @u_acct_svcparts = ();
77 foreach my $u_part_svc ( qsearch('part_svc',{'svcdb'=>'svc_acct'}) ) {
78 push @u_acct_svcparts,$u_part_svc->getfield('svcpart');
81 my($cust_pkg)=qsearchs('cust_pkg',{'pkgnum'=>$pkgnum});
82 my($custnum)=$cust_pkg->getfield('custnum');
84 foreach my $i_cust_pkg ( qsearch('cust_pkg',{'custnum'=>$custnum}) ) {
85 my($cust_pkgnum)=$i_cust_pkg->getfield('pkgnum');
87 foreach $acct_svcpart (@u_acct_svcparts) { #now find the corresponding
88 #record(s) in cust_svc ( for this
91 foreach $i_cust_svc ( qsearch('cust_svc',{'pkgnum'=>$cust_pkgnum,'svcpart'=>$acct_svcpart}) ) {
92 my($svc_acct)=qsearchs('svc_acct',{'svcnum'=>$i_cust_svc->getfield('svcnum')});
93 $username{$svc_acct->getfield('uid')}=$svc_acct->getfield('username');
98 #find all possible domains (and domsvc's)
100 my @d_acct_svcparts = ();
101 foreach my $d_part_svc ( qsearch('part_svc',{'svcdb'=>'svc_domain'}) ) {
102 push @d_acct_svcparts,$d_part_svc->getfield('svcpart');
106 foreach $i_cust_pkg ( qsearch('cust_pkg',{'custnum'=>$custnum}) ) {
107 my($cust_pkgnum)=$i_cust_pkg->getfield('pkgnum');
109 foreach $acct_svcpart (@d_acct_svcparts) {
111 foreach $i_cust_svc ( qsearch('cust_svc',{'pkgnum'=>$cust_pkgnum,'svcpart'=>$acct_svcpart}) ) {
112 my($svc_domain)=qsearch('svc_domain',{'svcnum'=>$i_cust_svc->getfield('svcnum')});
113 $domain{$svc_domain->getfield('svcnum')}=$svc_domain->getfield('domain');
118 } elsif ( $action eq 'Edit' ) {
120 my($svc_acct)=qsearchs('svc_acct',{'uid'=>$svc_acct_sm->domuid});
121 $username{$svc_acct_sm->uid} = $svc_acct->username;
123 my($svc_domain)=qsearchs('svc_domain',{'svcnum'=>$svc_acct_sm->domsvc});
124 $domain{$svc_acct_sm->domsvc} = $svc_domain->domain;
127 die "\$action eq Add, but \$pkgnum is null!\n";
131 print header("Mail Alias $action", '');
133 print qq!<FONT SIZE="+1" COLOR="#ff0000">Error: !, $cgi->param('error'),
135 if $cgi->param('error');
137 print qq!<FORM ACTION="${p1}process/svc_acct_sm.cgi" METHOD=POST>!;
145 print qq!<INPUT TYPE="hidden" NAME="svcnum" VALUE="$svcnum">!;
146 print qq!Service #<FONT SIZE=+1><B>!, $svcnum ? $svcnum : " (NEW)", "</B></FONT>";
149 print qq!<INPUT TYPE="hidden" NAME="pkgnum" VALUE="$pkgnum">!;
152 print qq!<INPUT TYPE="hidden" NAME="svcpart" VALUE="$svcpart">!;
154 ($domuser,$domsvc,$domuid)=(
155 $svc_acct_sm->domuser,
156 $svc_acct_sm->domsvc,
157 $svc_acct_sm->domuid,
161 print qq!\n\nMail to <INPUT TYPE="text" NAME="domuser" VALUE="$domuser"> <I>( * for anything )</I>!;
164 print qq! \@ <SELECT NAME="domsvc" SIZE=1>!;
165 foreach $_ (keys %domain) {
166 print "<OPTION", $_ eq $domsvc ? " SELECTED" : "",
167 qq! VALUE="$_">$domain{$_}!;
172 print qq!\nforwards to <SELECT NAME="domuid" SIZE=1>!;
173 foreach $_ (keys %username) {
174 print "<OPTION", ($_ eq $domuid) ? " SELECTED" : "",
175 qq! VALUE="$_">$username{$_}!;
177 print "</SELECT>\@$mydomain mailbox.";
182 print qq!<CENTER><INPUT TYPE="submit" VALUE="Submit"></CENTER>!;