Optimize "Customer has a referring customer" condition, RT#74452
[freeside.git] / httemplate / browse / cable_provider.html
1 <& elements/browse.html,
2      'title'              => 'Cable providers',
3      'html_init'          => $html_init,
4      'name'               => 'providers',
5      'disableable'        => 1,
6      'disabled_statuspos' => 1,
7      'query'              => { 'table'     => 'cable_provider',
8                                'hashref'   => {},
9                                'order_by' => 'ORDER BY provider',
10                              },
11      'count_query'        => $count_query,
12      'header'             => $header,
13      'fields'             => $fields,
14      'links'              => $links,
15 &>
16 <%init>
17
18 die "access denied"
19   unless $FS::CurrentUser::CurrentUser->access_right('Configuration');
20
21 my $html_init =
22   qq!<A HREF="${p}edit/cable_provider.html"><I>Add a provider</I></A><BR><BR>!;
23
24 my $count_query = 'SELECT COUNT(*) FROM cable_provider';
25
26 my $link = [ $p.'edit/cable_provider.html?', 'providernum' ];
27
28 my $header = [ 'Provider' ];
29 my $fields = [ 'provider' ];
30 my $links  = [ $link ];
31
32 </%init>