<% 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!Edit this information
!. ntable("#cccccc"). ''. ntable("#cccccc",2). qq!Service number!. qq!$svcnum!. qq!Router!. qq!$routernum: $routername!. qq!Download Speed!. qq!$speed_down!. qq!Upload Speed!. qq!$speed_up!. qq!IP Address!. qq!$ip_addr!. ''; # foreach my $sb_field # ( qsearch('sb_field', { svcnum => $svcnum }) ) { # my $part_sb_field = qsearchs('part_sb_field', # { sbfieldpart => $sb_field->sbfieldpart }); # print q!! . $part_sb_field->name . # q!! . $sb_field->value . # q!!; # } # print ''; my $sb_field = $svc_broadband->sb_field_hashref; foreach (sort { $a cmp $b } keys(%{$sb_field})) { print q!! . $_ . q!! . $sb_field->{$_} . q!!; } print ''; print '
'. joblisting({'svcnum'=>$svcnum}, 1). '' ; %>