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
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
|
<%
my $conf = new FS::Conf;
my($query)=$cgi->keywords;
$query ||= ''; #to avoid use of unitialized value errors
my(@svc_broadband,$sortby);
if ( $query eq 'svcnum' ) {
$sortby=\*svcnum_sort;
@svc_broadband=qsearch('svc_broadband',{});
} elsif ( $query eq 'blocknum' ) {
$sortby=\*blocknum_sort;
@svc_broadband=qsearch('svc_broadband',{});
} else {
$cgi->param('ip_addr') =~ /^(\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3})$/;
my($ip_addr)=$1;
@svc_broadband = qsearchs('svc_broadband',{'ip_addr'=>$ip_addr});
}
my %routerbyblock = ();
foreach my $router (qsearch('router', {})) {
foreach ($router->addr_block) {
$routerbyblock{$_->blocknum} = $router;
}
}
if ( scalar(@svc_broadband) == 1 ) {
print $cgi->redirect(popurl(2). "view/svc_broadband.cgi?". $svc_broadband[0]->svcnum);
#exit;
} elsif ( scalar(@svc_broadband) == 0 ) {
%>
<!-- mason kludge -->
<%
eidiot "No matching ip address found!\n";
} else {
%>
<!-- mason kludge -->
<%
my($total)=scalar(@svc_broadband);
print header("IP Address Search Results",''), <<END;
$total matching broadband services found
<TABLE BORDER=4 CELLSPACING=0 CELLPADDING=0>
<TR>
<TH>Service #</TH>
<TH>Router</TH>
<TH>IP Address</TH>
</TR>
END
foreach my $svc_broadband (
sort $sortby (@svc_broadband)
) {
my($svcnum,$ip_addr,$routername,$routernum)=(
$svc_broadband->svcnum,
$svc_broadband->ip_addr,
$routerbyblock{$svc_broadband->blocknum}->routername,
$routerbyblock{$svc_broadband->blocknum}->routernum,
);
my $rowspan = 1;
print <<END;
<TR>
<TD ROWSPAN=$rowspan><A HREF="${p}view/svc_broadband.cgi?$svcnum">$svcnum</A></TD>
<TD ROWSPAN=$rowspan><A HREF="${p}view/router.cgi?$routernum">$routername</A></TD>
<TD ROWSPAN=$rowspan><A HREF="${p}view/svc_broadband.cgi?$svcnum">$ip_addr</A></TD>
END
#print @rows;
print "</TR>";
}
print <<END;
</TABLE>
</BODY>
</HTML>
END
}
sub svcnum_sort {
$a->getfield('svcnum') <=> $b->getfield('svcnum');
}
sub blocknum_sort {
if ($a->getfield('blocknum') == $b->getfield('blocknum')) {
$a->getfield('ip_addr') cmp $b->getfield('ip_addr');
} else {
$a->getfield('blocknum') cmp $b->getfield('blocknum');
}
}
%>
|
