summaryrefslogtreecommitdiff
path: root/httemplate/search/svc_fiber.html
blob: 0cb735c960124659f875fc3191a249d1ec092978 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
<& elements/svc_Common.html,
  'title'       => 'Fiber Search Results',
  'name'        => 'fiber services',
  'query'       => $query,
  'count_query' => $query->{'count_query'},
  'redirect'    => $link,
  'header'      => [ '#',
                     'OLT',
                     'Shelf/Card/Port',
                     'ONT',
                     'Model',
                     'Serial',
                     FS::UI::Web::cust_header($cgi->param('cust_fields')),
                   ],
  'fields'      => [ 'svcnum',
                     'oltname',
                     sub { my $svc = shift;
                           join('-', $svc->shelf, $svc->card, $svc->olt_port)
                     },
                     'ont_id',
                     'ont_description',
                     'ont_serial',
                     \&FS::UI::Web::cust_fields,
                   ],
  'links'       => [ $link,
                     '',
                     '',
                     $link,
                     $link,
                     $link,
                     FS::UI::Web::cust_links($cgi->param('cust_fields')),
                   ],
  'align'       => 'rlllll'.  FS::UI::Web::cust_aligns(),
  'color'       => [ 
                     ('') x 6,
                     FS::UI::Web::cust_colors(),
                   ],
  'style'       => [ 
                     ('') x 6,
                     FS::UI::Web::cust_styles(),
                   ],

&>
<%init>

die "access denied" unless
  $FS::CurrentUser::CurrentUser->access_right([ 'Services: Fiber',
                                                'List services'
                                              ]);

my $conf = new FS::Conf;

my %search_hash;
if ( $cgi->param('magic') eq 'unlinked' ) {
  %search_hash = ( 'unlinked' => 1 );
} else {
  foreach (qw( custnum agentnum svcpart cust_fields
               ont_typenum oltnum shelf olt_port card vlan )) {
    $search_hash{$_} = $cgi->param($_) if defined($cgi->param($_));
  }
}

my $query = FS::svc_fiber->search(\%search_hash);
$query->{addl_from} .= ' LEFT JOIN fiber_olt USING (oltnum) ';
$query->{select} .= ', oltname';

my $link = [ $p.'view/svc_fiber.cgi?', 'svcnum' ];

</%init>