diff options
-rw-r--r-- | httemplate/view/svc_phone.cgi | 67 |
1 files changed, 4 insertions, 63 deletions
diff --git a/httemplate/view/svc_phone.cgi b/httemplate/view/svc_phone.cgi index ffb6fcc..0369d5c 100644 --- a/httemplate/view/svc_phone.cgi +++ b/httemplate/view/svc_phone.cgi @@ -56,69 +56,10 @@ my $html_foot = sub { ### # Devices ### - - my $devices = ''; - - my $sth = dbh->prepare("SELECT COUNT(*) FROM part_device") #WHERE disabled = '' OR disabled IS NULL;"); - or die dbh->errstr; - $sth->execute or die $sth->errstr; - my $num_part_device = $sth->fetchrow_arrayref->[0]; - - my @phone_device = $svc_phone->phone_device; - if ( @phone_device || $num_part_device ) { - my $svcnum = $svc_phone->svcnum; - $devices .= - qq[Devices (<A HREF="${p}edit/phone_device.html?svcnum=$svcnum">Add device</A>)<BR>]; - if ( @phone_device ) { - - $devices .= qq! - <SCRIPT> - function areyousure(href) { - if (confirm("Are you sure you want to delete this device?") == true) - window.location.href = href; - } - </SCRIPT> - !; - - - $devices .= - include('/elements/table-grid.html'). - '<TR>'. - '<TH CLASS="grid" BGCOLOR="#cccccc">Type</TH>'. - '<TH CLASS="grid" BGCOLOR="#cccccc">MAC Addr</TH>'. - '<TH CLASS="grid" BGCOLOR="#cccccc"></TH>'. - '<TH CLASS="grid" BGCOLOR="#cccccc"></TH>'. - '</TR>'; - my $bgcolor1 = '#eeeeee'; - my $bgcolor2 = '#ffffff'; - my $bgcolor = ''; - - foreach my $phone_device ( @phone_device ) { - - if ( $bgcolor eq $bgcolor1 ) { - $bgcolor = $bgcolor2; - } else { - $bgcolor = $bgcolor1; - } - my $td = qq(<TD CLASS="grid" BGCOLOR="$bgcolor">); - - my $devicenum = $phone_device->devicenum; - my $export_links = join( '<BR>', @{ $phone_device->export_links } ); - - $devices .= '<TR>'. - $td. $phone_device->part_device->devicename. '</TD>'. - $td. $phone_device->mac_addr. '</TD>'. - $td. $export_links. '</TD>'. - "$td( ". - qq(<A HREF="${p}edit/phone_device.html?$devicenum">edit</A> | ). - qq(<A HREF="javascript:areyousure('${p}misc/delete-phone_device.html?$devicenum')">delete</A>). - ' )</TD>'. - '</TR>'; - } - $devices .= '</TABLE><BR>'; - } - $devices .= '<BR>'; - } + my $devices = include('elements/svc_devices.html', + 'svc_x' => $svc_phone, + 'table' => 'phone_device', + ); ## # CDR links |