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
|
<!-- mason kludge -->
<%
my($query) = $cgi->keywords;
$query =~ /^(\d+)$/;
my $svcnum = $1;
my $svc_broadband = qsearchs( 'svc_broadband', { 'svcnum' => $svcnum } )
or die "svc_broadband: Unknown svcnum $svcnum";
#false laziness w/all svc_*.cgi
my $cust_svc = qsearchs( 'cust_svc', { 'svcnum' => $svcnum } );
my $pkgnum = $cust_svc->getfield('pkgnum');
my($cust_pkg, $custnum);
if ($pkgnum) {
$cust_pkg = qsearchs( 'cust_pkg', { 'pkgnum' => $pkgnum } );
$custnum = $cust_pkg->custnum;
} else {
$cust_pkg = '';
$custnum = '';
}
#eofalse
my $router = $svc_broadband->addr_block->router;
if (not $router) { die "Could not lookup router for svc_broadband (svcnum $svcnum)" };
my (
$routername,
$routernum,
$speed_down,
$speed_up,
$ip_addr
) = (
$router->getfield('routername'),
$router->getfield('routernum'),
$svc_broadband->getfield('speed_down'),
$svc_broadband->getfield('speed_up'),
$svc_broadband->getfield('ip_addr')
);
print header('Broadband Service View', menubar(
( ( $custnum )
? ( "View this package (#$pkgnum)" => "${p}view/cust_pkg.cgi?$pkgnum",
"View this customer (#$custnum)" => "${p}view/cust_main.cgi?$custnum",
)
: ( "Cancel this (unaudited) website" =>
"${p}misc/cancel-unaudited.cgi?$svcnum" )
),
"Main menu" => $p,
)).
qq!<A HREF="${p}edit/svc_broadband.cgi?$svcnum">Edit this information</A><BR>!.
ntable("#cccccc"). '<TR><TD>'. ntable("#cccccc",2).
qq!<TR><TD ALIGN="right">Service number</TD>!.
qq!<TD BGCOLOR="#ffffff">$svcnum</TD></TR>!.
qq!<TR><TD ALIGN="right">Router</TD>!.
qq!<TD BGCOLOR="#ffffff">$routernum: $routername</TD></TR>!.
qq!<TR><TD ALIGN="right">Download Speed</TD>!.
qq!<TD BGCOLOR="#ffffff">$speed_down</TD></TR>!.
qq!<TR><TD ALIGN="right">Upload Speed</TD>!.
qq!<TD BGCOLOR="#ffffff">$speed_up</TD></TR>!.
qq!<TR><TD ALIGN="right">IP Address</TD>!.
qq!<TD BGCOLOR="#ffffff">$ip_addr</TD></TR>!.
'</TD></TR><TR ROWSPAN="1"><TD></TD></TR>';
# foreach my $sb_field
# ( qsearch('sb_field', { svcnum => $svcnum }) ) {
# my $part_sb_field = qsearchs('part_sb_field',
# { sbfieldpart => $sb_field->sbfieldpart });
# print q!<TR><TD ALIGN="right">! . $part_sb_field->name .
# q!</TD><TD BGCOLOR="#ffffff">! . $sb_field->value .
# q!</TD></TR>!;
# }
# print '</TABLE>';
my $sb_field = $svc_broadband->sb_field_hashref;
foreach (sort { $a cmp $b } keys(%{$sb_field})) {
print q!<TR><TD ALIGN="right">! . $_ .
q!</TD><TD BGCOLOR="#ffffff">! . $sb_field->{$_} .
q!</TD></TR>!;
}
print '</TABLE>';
print '<BR>'. joblisting({'svcnum'=>$svcnum}, 1).
'</BODY></HTML>'
;
%>
|
