5 if ( $cgi->param('showdisabled') ) {
8 %search = ( 'disabled' => '' );
11 my @part_pkg = qsearch('part_pkg', \%search );
12 my $total = scalar(@part_pkg);
15 my %num_active_cust_pkg = ();
16 my( $suspended_sth, $canceled_sth ) = ( '', '' );
17 if ( $cgi->param('active') ) {
18 my $active_sth = dbh->prepare(
19 'SELECT COUNT(*) FROM cust_pkg WHERE pkgpart = ?'.
20 ' AND ( cancel IS NULL OR cancel = 0 )'.
21 ' AND ( susp IS NULL OR susp = 0 )'
23 foreach my $part_pkg ( @part_pkg ) {
24 $active_sth->execute($part_pkg->pkgpart) or die $active_sth->errstr;
25 $num_active_cust_pkg{$part_pkg->pkgpart} =
26 $active_sth->fetchrow_arrayref->[0];
29 $num_active_cust_pkg{$b->pkgpart} <=> $num_active_cust_pkg{$a->pkgpart};
32 $suspended_sth = dbh->prepare(
33 'SELECT COUNT(*) FROM cust_pkg WHERE pkgpart = ?'.
34 ' AND ( cancel IS NULL OR cancel = 0 )'.
35 ' AND susp IS NOT NULL AND susp != 0'
38 $canceled_sth = dbh->prepare(
39 'SELECT COUNT(*) FROM cust_pkg WHERE pkgpart = ?'.
40 ' AND cancel IS NOT NULL AND cancel != 0'
44 $sortby = sub { $a->pkgpart <=> $b->pkgpart; };
47 my $conf = new FS::Conf;
48 my $taxclasses = $conf->exists('enable_taxclasses');
51 <%= include("/elements/header.html","Package Definition Listing",menubar( 'Main Menu' => $p )) %>
52 <% unless ( $cgi->param('active') ) { %>
53 One or more service definitions are grouped together into a package
54 definition and given pricing information. Customers purchase packages
55 rather than purchase services directly.<BR><BR>
56 <A HREF="<%= $p %>edit/part_pkg.cgi"><I>Add a new package definition</I></A>
60 <%= $total %> package definitions
61 <% if ( $cgi->param('showdisabled') ) { $cgi->param('showdisabled', 0); %>
62 ( <a href="<%= $cgi->self_url %>">hide disabled packages</a> )
63 <% } else { $cgi->param('showdisabled', 1); %>
64 ( <a href="<%= $cgi->self_url %>">show disabled packages</a> )
67 <% my $colspan = $cgi->param('showdisabled') ? 2 : 3; %>
71 <TH COLSPAN=<%= $colspan %>>Package</TH>
73 <% if ( $cgi->param('active') ) { %>
74 <TH><FONT SIZE=-1>Customer<BR>packages</FONT></TH>
76 <TH><FONT SIZE=-1>Freq.</FONT></TH>
77 <% if ( $taxclasses ) { %>
78 <TH><FONT SIZE=-1>Taxclass</FONT></TH>
80 <TH><FONT SIZE=-1>Plan</FONT></TH>
81 <TH><FONT SIZE=-1>Data</FONT></TH>
83 <TH><FONT SIZE=-1>Quan.</FONT></TH>
84 <% if ( dbdef->table('pkg_svc')->column('primary_svc') ) { %>
85 <TH><FONT SIZE=-1>Primary</FONT></TH>
91 foreach my $part_pkg ( sort $sortby @part_pkg ) {
92 my @pkg_svc = $part_pkg->pkg_svc;
93 my($rowspan)=scalar(@pkg_svc);
95 if ( $part_pkg->plan ) {
96 $plandata = $part_pkg->plandata;
97 $plandata =~ s/^(\w+)=/$1 /mg;
98 $plandata =~ s/\n/<BR>/g;
100 $part_pkg->plan('(legacy)');
101 $plandata = "Setup ". $part_pkg->setup.
102 "<BR>Recur ". $part_pkg->recur;
106 <TD ROWSPAN=<%= $rowspan %>><A HREF="<%=$p%>edit/part_pkg.cgi?<%= $part_pkg->pkgpart %>"><%= $part_pkg->pkgpart %></A></TD>
108 <% unless ( $cgi->param('showdisabled') ) { %>
109 <TD ROWSPAN=<%= $rowspan %>>
110 <% if ( $part_pkg->disabled ) { %>
116 <TD ROWSPAN=<%= $rowspan %>><A HREF="<%=$p%>edit/part_pkg.cgi?<%= $part_pkg->pkgpart %>"><%= $part_pkg->pkg %></A></TD>
117 <TD ROWSPAN=<%= $rowspan %>><%= $part_pkg->comment %></TD>
119 <% if ( $cgi->param('active') ) { %>
120 <TD ROWSPAN=<%= $rowspan %>>
121 <FONT COLOR="#00CC00"><B><%= $num_active_cust_pkg{$part_pkg->pkgpart} %></B></FONT> <A HREF="<%=$p%>search/cust_pkg.cgi?magic=active;pkgpart=<%= $part_pkg->pkgpart %>">active</A><BR>
123 <% $suspended_sth->execute( $part_pkg->pkgpart )
124 or die $suspended_sth->errstr;
125 my $num_suspended = $suspended_sth->fetchrow_arrayref->[0];
127 <FONT COLOR="#FF9900"><B><%= $num_suspended %></B></FONT> <A HREF="<%=$p%>search/cust_pkg.cgi?magic=suspended;pkgpart=<%= $part_pkg->pkgpart %>">suspended</A><BR>
129 <% $canceled_sth->execute( $part_pkg->pkgpart )
130 or die $canceled_sth->errstr;
131 my $num_canceled = $canceled_sth->fetchrow_arrayref->[0];
133 <FONT COLOR="#FF0000"><B><%= $num_canceled %></B></FONT> <A HREF="<%=$p%>search/cust_pkg.cgi?magic=canceled;pkgpart=<%= $part_pkg->pkgpart %>">canceled</A>
137 <TD ROWSPAN=<%= $rowspan %>><%= $part_pkg->freq_pretty %></TD>
139 <% if ( $taxclasses ) { %>
140 <TD ROWSPAN=<%= $rowspan %>><%= $part_pkg->taxclass || ' ' %></TD>
143 <TD ROWSPAN=<%= $rowspan %>><%= $part_pkg->plan %></TD>
144 <TD ROWSPAN=<%= $rowspan %>><%= $plandata %></TD>
148 foreach my $pkg_svc ( @pkg_svc ) {
149 my($svcpart)=$pkg_svc->getfield('svcpart');
150 my($part_svc) = qsearchs('part_svc',{'svcpart'=> $svcpart });
151 print $n,qq!<TD><A HREF="${p}edit/part_svc.cgi?$svcpart">!,
152 $part_svc->getfield('svc'),"</A></TD><TD>",
153 $pkg_svc->getfield('quantity'),"</TD>";
154 if ( dbdef->table('pkg_svc')->column('primary_svc') ) {
156 print 'PRIMARY' if $pkg_svc->primary_svc =~ /^Y/i;