1 <% include( 'elements/browse.html',
2 'title' => 'Access Numbers',
3 'html_init' => $html_init,
4 'name_singular' => 'access number',
6 'count_query' => $count_query,
31 unless $FS::CurrentUser::CurrentUser->access_right('Configuration');
34 <A HREF="${p}edit/svc_acct_pop.cgi"><I>Add new Access Number</I></A>
38 my $query = { 'select' => '*,
39 ( SELECT COUNT(*) FROM svc_acct
40 WHERE svc_acct.popnum = svc_acct_pop.popnum
43 'table' => 'svc_acct_pop',
44 #'hashref' => { 'disabled' => '' },
45 'extra_sql' => 'ORDER BY state, city, ac, exch, loc',
48 my $count_query = "SELECT COUNT(*) FROM svc_acct_pop"; # WHERE DISABLED IS NULL OR DISABLED = ''";
50 my $svc_acct_pop_link = [ $p.'edit/svc_acct_pop.cgi?', 'popnum' ];
52 my $svc_acct_link = $p. 'search/svc_acct.cgi?popnum=';
54 my $num_accounts_sub = sub {
55 my $svc_acct_pop = shift;
58 { 'data' => '<B><FONT COLOR="#00CC00">'.
59 $svc_acct_pop->get('num_accounts').
65 'link' => ( $svc_acct_pop->get('num_accounts')
66 ? $svc_acct_link. $svc_acct_pop->popnum