X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fbrowse%2Fagent.cgi;h=fd360ab3c43fc35c5d3319a0ef339a9b7e06dc33;hb=6ed5d51b3a72e2935dd5d084c9e24567150b03ca;hp=af32887205aba75c53a3b22eab79743d68ef5ee5;hpb=3913f6d159b5b8110061690b7c97642c27abf7eb;p=freeside.git

diff --git a/httemplate/browse/agent.cgi b/httemplate/browse/agent.cgi
index af3288720..fd360ab3c 100755
--- a/httemplate/browse/agent.cgi
+++ b/httemplate/browse/agent.cgi
@@ -1,5 +1,3 @@
-<!-- mason kludge -->
-
 <%
 
   my %search;
@@ -10,31 +8,7 @@
     %search = ( 'disabled' => '' );
   }
 
-  #bad false laziness with search/cust_main.cgi (also needs fixing up for
-  #old mysql)
-  my $ncancelled = "
-     0 < ( SELECT COUNT(*) FROM cust_pkg
-                  WHERE cust_pkg.custnum = cust_main.custnum
-                    AND ( cust_pkg.cancel IS NULL
-                          OR cust_pkg.cancel = 0
-                        )
-              )
-       OR 0 = ( SELECT COUNT(*) FROM cust_pkg
-                  WHERE cust_pkg.custnum = cust_main.custnum
-              )
-  ";
-
-  my $ncancelled_sth = dbh->prepare("SELECT COUNT(*) FROM cust_main
-                                       WHERE agentnum = ?
-                                         AND ( $ncancelled )         ")
-    or die dbh->errstr;
-
-  my $total_sth = dbh->prepare("SELECT COUNT(*) FROM cust_main
-                                  WHERE agentnum = ?           ")
-    or die dbh->errstr;
-
 %>
-
 <%= header('Agent Listing', menubar(
   'Main Menu'   => $p,
   'Agent Types' => $p. 'browse/agent_type.cgi',
@@ -58,6 +32,10 @@ full offerings (via their type).<BR><BR>
   <TH COLSPAN=<%= ( $cgi->param('showdisabled') || !dbdef->table('agent')->column('disabled') ) ? 2 : 3 %>>Agent</TH>
   <TH>Type</TH>
   <TH>Customers</TH>
+  <TH><FONT SIZE=-1>Customer<BR>packages</FONT></TH>
+  <TH>Reports</TH>
+  <TH>Registration codes</TH>
+  <TH>Prepaid cards</TH>
   <TH><FONT SIZE=-1>Freq.</FONT></TH>
   <TH><FONT SIZE=-1>Prog.</FONT></TH>
 </TR>
@@ -70,17 +48,11 @@ foreach my $agent ( sort {
   $a->getfield('agent') cmp $b->getfield('agent')
 } qsearch('agent', \%search ) ) {
 
-  $ncancelled_sth->execute($agent->agentnum) or die $ncancelled_sth->errstr;
-  my $num_ncancelled = $ncancelled_sth->fetchrow_arrayref->[0];
-
-  $total_sth->execute($agent->agentnum) or die $total_sth->errstr;
-  my $num_total = $total_sth->fetchrow_arrayref->[0];
-
-  my $num_cancelled = $num_total - $num_ncancelled;
-
   my $cust_main_link = $p. 'search/cust_main.cgi?agentnum_on=1&'.
                        'agentnum='. $agent->agentnum;
 
+  my $cust_pkg_link = $p. 'search/cust_pkg.cgi?agentnum='. $agent->agentnum;
+
 %>
 
       <TR>
@@ -94,34 +66,117 @@ foreach my $agent ( sort {
         <TD><A HREF="<%=$p%>edit/agent.cgi?<%= $agent->agentnum %>">
           <%= $agent->agent %></A></TD>
         <TD><A HREF="<%=$p%>edit/agent_type.cgi?<%= $agent->typenum %>"><%= $agent->agent_type->atype %></A></TD>
+
+        <TD>
+          <TABLE CELLSPACING=0 CELLPADDING=0>
+            <TR>
+              <TH ALIGN="right" WIDTH="40%">
+                <%= my $num_prospect = $agent->num_prospect_cust_main %>&nbsp;
+              </TH>
+              <TD>
+                <% if ( $num_prospect ) { %>
+                  <A HREF="<%= $cust_main_link %>&prospect=1"><% } %>prospects<% if ($num_prospect ) { %></A><% } %>
+              <TD>
+            </TR>
+            <TR>
+              <TH ALIGN="right" WIDTH="40%">
+                <FONT COLOR="#00CC00">
+                  <%= my $num_active = $agent->num_active_cust_main %>&nbsp;
+                </FONT>
+              </TH>
+              <TD>
+                <% if ( $num_active ) { %>
+                  <A HREF="<%= $cust_main_link %>&active=1"><% } %>active<% if ( $num_active ) { %></A><% } %>
+              </TD>
+            </TR>
+            <TR>
+              <TH ALIGN="right" WIDTH="40%">
+                <FONT COLOR="#FF9900">
+                  <%= my $num_susp = $agent->num_susp_cust_main %>&nbsp;
+                </FONT>
+              </TH>
+              <TD>
+                <% if ( $num_susp ) { %>
+                  <A HREF="<%= $cust_main_link %>&suspended=1"><% } %>suspended<% if ( $num_susp ) { %></A><% } %>
+              </TD>
+            </TR>
+            <TR>
+              <TH ALIGN="right" WIDTH="40%">
+                <FONT COLOR="#FF0000">
+                  <%= my $num_cancel = $agent->num_cancel_cust_main %>&nbsp;
+                </FONT>
+              </TH>
+              <TD>
+                <% if ( $num_cancel ) { %>
+                  <A HREF="<%= $cust_main_link %>&showcancelledcustomers=1&cancelled=1"><% } %>cancelled<% if ( $num_cancel ) { %></A><% } %>
+              </TD>
+            </TR>
+          </TABLE>
+        </TD>
+
         <TD>
+          <TABLE CELLSPACING=0 CELLPADDING=0>
+            <TR>
+              <TH ALIGN="right" WIDTH="40%">
+                <FONT COLOR="#00CC00">
+                  <%= my $num_active_pkg = $agent->num_active_cust_pkg %>&nbsp;
+                </FONT>
+              </TH>
+              <TD>
+                <% if ( $num_active_pkg ) { %>
+                  <A HREF="<%= $cust_pkg_link %>&magic=active"><% } %>active<% if ( $num_active_pkg ) { %></A><% } %>
+              </TD>
+            </TR>
+            <TR>
+              <TH ALIGN="right" WIDTH="40%">
+                <FONT COLOR="#FF9900">
+                  <%= my $num_susp_pkg = $agent->num_susp_cust_pkg %>&nbsp;
+                </FONT>
+              </TH>
+              <TD>
+                <% if ( $num_susp_pkg ) { %>
+                  <A HREF="<%= $cust_pkg_link %>&magic=suspended"><% } %>suspended<% if ( $num_susp_pkg ) { %></A><% } %>
+              </TD>
+            </TR>
+            <TR>
+              <TH ALIGN="right" WIDTH="40%">
+                <FONT COLOR="#FF0000">
+                  <%= my $num_cancel_pkg = $agent->num_cancel_cust_pkg %>&nbsp;
+                </FONT>
+              </TH>
+              <TD>
+                <% if ( $num_cancel_pkg ) { %>
+                  <A HREF="<%= $cust_pkg_link %>&magic=cancelled"><% } %>cancelled<% if ( $num_cancel_pkg ) { %></A><% } %>
+              </TD>
+            </TR>
+          </TABLE>
+        </TD>
+
+        <TD>
+          <A HREF="<%= $p %>search/report_cust_pay.html?agentnum=<%= $agent->agentnum %>">Payments</A>
+          <BR><A HREF="<%= $p %>search/report_cust_credit.html?agentnum=<%= $agent->agentnum %>">Credits</A>
+          <BR><A HREF="<%= $p %>search/report_receivables.cgi?agentnum=<%= $agent->agentnum %>">A/R Aging</A>
+          <!--<BR><A HREF="<%= $p %>search/money_time.cgi?agentnum=<%= $agent->agentnum %>">Sales/Credits/Receipts</A>-->
 
-          <B>
-            <%= my $num_prospect = $agent->num_prospect_cust_main %>
-          </B>
-          <% if ( $num_prospect ) { %>
-            <A HREF="<%= $cust_main_link %>&prospect=1"><% } %>prospects<% if ($num_prospect ) { %></A><% } %>
-
-          <BR><FONT COLOR="#00CC00"><B>
-            <%= my $num_active = $agent->num_active_cust_main %>
-          </B></FONT>
-          <% if ( $num_active ) { %>
-            <A HREF="<%= $cust_main_link %>&active=1"><% } %>active<% if ( $num_active ) { %></A><% } %>
-
-          <BR><FONT COLOR="#FF9900"><B>
-            <%= my $num_susp = $agent->num_susp_cust_main %>
-          </B></FONT>
-          <% if ( $num_susp ) { %>
-            <A HREF="<%= $cust_main_link %>&suspended=1"><% } %>suspended<% if ( $num_susp ) { %></A><% } %>
-
-          <BR><FONT COLOR="#FF0000"><B>
-            <%= my $num_cancel = $agent->num_cancel_cust_main %>
-          </B></FONT>
-          <% if ( $num_cancel ) { %>
-            <A HREF="<%= $cust_main_link %>&showcancelledcustomers=1&cancelled=1"><% } %>cancelled<% if ( $num_cancel ) { %></A><% } %>
         </TD>
+
+        <TD>
+          <%= my $num_reg_code = $agent->num_reg_code %>
+          <% if ( $num_reg_code ) { %>
+            <A HREF="<%=$p%>search/reg_code.html?agentnum=<%= $agent->agentnum %>"><% } %>Unused<% if ( $num_reg_code ) { %></A><% } %>
+          <BR><A HREF="<%=$p%>edit/reg_code.cgi?agentnum=<%= $agent->agentnum %>">Generate codes</A>
+        </TD>
+
+        <TD>
+          <%= my $num_prepay_credit = $agent->num_prepay_credit %>
+          <% if ( $num_prepay_credit ) { %>
+            <A HREF="<%=$p%>search/prepay_credit.html?agentnum=<%= $agent->agentnum %>"><% } %>Unused<% if ( $num_prepay_credit ) { %></A><% } %>
+          <BR><A HREF="<%=$p%>edit/prepay_credit.cgi?agentnum=<%= $agent->agentnum %>">Generate cards</A>
+        </TD>
+
         <TD><%= $agent->freq %></TD>
         <TD><%= $agent->prog %></TD>
+
       </TR>
 
 <% } %>