X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fbrowse%2Fagent.cgi;h=32c68f834317e33efd68184b198bc2319b7e8d5e;hb=c67822780e9f915a3df47943bd65689536dc9442;hp=adeb78dbd552c63a55cb72901d025c4a2f7721be;hpb=a68758a95e760e50ad99a2a2e0885d2aa9cf907a;p=freeside.git
diff --git a/httemplate/browse/agent.cgi b/httemplate/browse/agent.cgi
index adeb78dbd..32c68f834 100755
--- a/httemplate/browse/agent.cgi
+++ b/httemplate/browse/agent.cgi
@@ -2,28 +2,13 @@
<%
- #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;
+ my %search;
+ if ( $cgi->param('showdisabled')
+ || !dbdef->table('agent')->column('disabled') ) {
+ %search = ();
+ } else {
+ %search = ( 'disabled' => '' );
+ }
%>
@@ -36,11 +21,23 @@ Agents are resellers of your service. Agents may be limited to a subset of your
full offerings (via their type).
Add a new agent
+<% if ( dbdef->table('agent')->column('disabled') ) { %>
+ <%= $cgi->param('showdisabled')
+ ? do { $cgi->param('showdisabled', 0);
+ '( hide disabled agents )'; }
+ : do { $cgi->param('showdisabled', 1);
+ '( show disabled agents )'; }
+ %>
+<% } %>
+
<%= table() %>
+ <%= 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 ) { %><% } %> + | +