X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;ds=sidebyside;f=httemplate%2Fbrowse%2Fagent.cgi;h=c5c992704be6c08acb91096e9a4088a7eaad57b5;hb=101dd8d8fdca484a72e907efcfcef396e96b888d;hp=2eef5bb918f52b9f29311cdcb62fd2617e7c151e;hpb=c58132f6a26349d09744ef2b3b235dfb7c3757f6;p=freeside.git
diff --git a/httemplate/browse/agent.cgi b/httemplate/browse/agent.cgi
index 2eef5bb91..c5c992704 100755
--- a/httemplate/browse/agent.cgi
+++ b/httemplate/browse/agent.cgi
@@ -1,5 +1,3 @@
-
-
<%
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,9 @@ full offerings (via their type).
+ <%= my $num_prospect = $agent->num_prospect_cust_main %> + | ++ <% if ( $num_prospect ) { %> + <% } %>prospects<% if ($num_prospect ) { %><% } %> + | + |
---|---|---|
+ + <%= my $num_active = $agent->num_active_cust_main %> + + | ++ <% if ( $num_active ) { %> + <% } %>active<% if ( $num_active ) { %><% } %> + | +|
+ + <%= my $num_susp = $agent->num_susp_cust_main %> + + | ++ <% if ( $num_susp ) { %> + <% } %>suspended<% if ( $num_susp ) { %><% } %> + | +|
+ + <%= my $num_cancel = $agent->num_cancel_cust_main %> + + | ++ <% if ( $num_cancel ) { %> + <% } %>cancelled<% if ( $num_cancel ) { %><% } %> + | +