-<!-- mason kludge -->
-
<%
my %search;
%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;
+ my $conf = new FS::Conf;
%>
-
-<%= header('Agent Listing', menubar(
+<%= include("/elements/header.html",'Agent Listing', menubar(
'Main Menu' => $p,
'Agent Types' => $p. 'browse/agent_type.cgi',
# 'Add new agent' => '../edit/agent.cgi'
<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>
+ <% if ( $conf->config('ticket_system') ) { %>
+ <TH>Ticketing</TH>
+ <% } %>
+ <TH><FONT SIZE=-1>Payment Gateway Overrides</FONT></TH>
<TH><FONT SIZE=-1>Freq.</FONT></TH>
<TH><FONT SIZE=-1>Prog.</FONT></TH>
</TR>
$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>
<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 %>
+ </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 %>
+ </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 %>
+ </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 %>
+ </FONT>
+ </TH>
+ <TD>
+ <% if ( $num_cancel ) { %>
+ <A HREF="<%= $cust_main_link %>&showcancelledcustomers=1&cancelled=1"><% } %>cancelled<% if ( $num_cancel ) { %></A><% } %>
+ </TD>
+ </TR>
+ </TABLE>
+ </TD>
- <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>
+ <TABLE CELLSPACING=0 CELLPADDING=0>
+ <TR>
+ <TH ALIGN="right" WIDTH="40%">
+ <FONT COLOR="#00CC00">
+ <%= my $num_active_pkg = $agent->num_active_cust_pkg %>
+ </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 %>
+ </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 %>
+ </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>-->
+
+ </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>
+
+ <% if ( $conf->config('ticket_system') ) { %>
+
+ <TD>
+ <% if ( $agent->ticketing_queueid ) { %>
+ Queue: <%= $agent->ticketing_queueid %>: <%= $agent->ticketing_queue %><BR>
+ <% } %>
+ </TD>
+
+ <% } %>
+
+ <TD>
+ <TABLE CELLSPACING=0 CELLPADDING=0>
+ <% foreach my $override (
+ # sort { } want taxclass-full stuff first? and default cards (empty cardtype)
+ qsearch('agent_payment_gateway', { 'agentnum' => $agent->agentnum } )
+ ) {
+ %>
+ <TR>
+ <TD>
+ <%= $override->cardtype || 'Default' %> to <%= $override->payment_gateway->gateway_module %> (<%= $override->payment_gateway->gateway_username %>)
+ <%= $override->taxclass
+ ? ' for '. $override->taxclass. ' only'
+ : ''
+ %>
+ <FONT SIZE=-1><A HREF="<%=$p%>misc/delete-agent_payment_gateway.cgi?<%= 'XXXoverridenum' %>">(delete)</A></FONT>
+ </TD>
+ </TR>
+ <% } %>
+ <TR>
+ <TD><FONT SIZE=-1><A HREF="<%=$p%>edit/agent_payment_gateway.html?agentnum=<%= $agent->agentnum %>">(add override)</A></FONT></TD>
+ </TR>
+ </TABLE>
+ </TD>
+
<TD><%= $agent->freq %></TD>
<TD><%= $agent->prog %></TD>
+
</TR>
<% } %>