X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fbrowse%2Fagent.cgi;h=f389342972feb4619e9754b9cdd78fb730ee57b3;hp=44343e15c427f1eb33e4a31cd88e2ff1bb55010e;hb=657742d1118c350120ecac455ae013f1deed5b83;hpb=c3e5b694f98b424f9fe68b76450d1464ba7a0fec
diff --git a/httemplate/browse/agent.cgi b/httemplate/browse/agent.cgi
index 44343e15c..f38934297 100755
--- a/httemplate/browse/agent.cgi
+++ b/httemplate/browse/agent.cgi
@@ -10,29 +10,6 @@
%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(
@@ -55,7 +32,7 @@ full offerings (via their type).
<%= table() %>