3 # $Id: part_pkg.cgi,v 1.2 1998-11-21 07:00:32 ivan Exp $
5 # ivan@sisd.com 97-dec-5,9
7 # Changes to allow page to work at a relative position in server
8 # bmccane@maxbaud.net 98-apr-3
10 # lose background, FS::CGI ivan@sisd.com 98-sep-2
12 # $Log: part_pkg.cgi,v $
13 # Revision 1.2 1998-11-21 07:00:32 ivan
19 use FS::UID qw(cgisuidsetup swapuid);
20 use FS::Record qw(qsearch qsearchs);
21 use FS::CGI qw(header menubar popurl table);
30 print $cgi->header, header("Package Part Listing",menubar(
31 'Main Menu' => popurl(2),
32 'Add new package' => popurl(2). "/edit/part_pkg.cgi",
33 )), "One or more services are grouped together into a package and given",
34 " pricing information. Customers purchase packages, not services.<BR><BR>",
38 <TH COLSPAN=2>Package</TH>
40 <TH><FONT SIZE=-1>Setup Fee</FONT></TH>
41 <TH><FONT SIZE=-1>Freq.</FONT></TH>
42 <TH><FONT SIZE=-1>Recur. Fee</FONT></TH>
44 <TH><FONT SIZE=-1>Quan.</FONT></TH>
50 foreach $part_pkg ( sort {
51 $a->getfield('pkgpart') <=> $b->getfield('pkgpart')
52 } qsearch('part_pkg',{}) ) {
53 my($hashref)=$part_pkg->hashref;
54 my(@pkg_svc)=grep $_->getfield('quantity'),
55 qsearch('pkg_svc',{'pkgpart'=> $hashref->{pkgpart} });
56 my($rowspan)=scalar(@pkg_svc);
59 <TD ROWSPAN=$rowspan><A HREF="$p/edit/part_pkg.cgi?$hashref->{pkgpart}">
62 <TD ROWSPAN=$rowspan><A HREF="$p/edit/part_pkg.cgi?$hashref->{pkgpart}">$hashref->{pkg}</A></TD>
63 <TD ROWSPAN=$rowspan>$hashref->{comment}</TD>
64 <TD ROWSPAN=$rowspan>$hashref->{setup}</TD>
65 <TD ROWSPAN=$rowspan>$hashref->{freq}</TD>
66 <TD ROWSPAN=$rowspan>$hashref->{recur}</TD>
71 foreach $pkg_svc ( @pkg_svc ) {
72 my($svcpart)=$pkg_svc->getfield('svcpart');
73 my($part_svc) = qsearchs('part_svc',{'svcpart'=> $svcpart });
74 print $n,qq!<TD><A HREF="../edit/part_svc.cgi?$svcpart">!,
75 $part_svc->getfield('svc'),"</A></TD><TD>",
76 $pkg_svc->getfield('quantity'),"</TD></TR>\n";