X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Fsvc_broadband.cgi;h=56711615c923f07ca598111dfca265cd94e0d1a9;hb=e68a2c760a79d6085f12be9add138067c9935074;hp=1bbdbfcdb621184dc1ba5675d5cfd5a5fb5211d9;hpb=590603ecaea3184f64530755a76626be8205da49;p=freeside.git

diff --git a/httemplate/search/svc_broadband.cgi b/httemplate/search/svc_broadband.cgi
index 1bbdbfcdb..56711615c 100755
--- a/httemplate/search/svc_broadband.cgi
+++ b/httemplate/search/svc_broadband.cgi
@@ -5,9 +5,18 @@
 %
 %my @svc_broadband = ();
 %my $sortby=\*svcnum_sort;
+%#XXX agent-virtualization needs to be finished :/
+%my $agentnums_sql = $FS::CurrentUser::CurrentUser->agentnums_sql( 
+%                      'null_right' => 'View/link unlinked services'
+%                    );
+%
 %if ( $cgi->param('magic') =~ /^(all|unlinked)$/ ) {
 %
-%  @svc_broadband=qsearch('svc_broadband',{});
+%  @svc_broadband = qsearch(
+%    'table'     => 'svc_broadband',
+%    'hashref'   => {},
+%    #needs the join first 'extra_sql' => "WHERE $agentnums_sql",
+%  );
 %
 %  if ( $cgi->param('magic') eq 'unlinked' ) {
 %    @svc_broadband = grep { qsearchs('cust_svc', {
@@ -17,7 +26,7 @@
 %                                    )
 %                          }
 %		      @svc_broadband;
-%  }
+%  } else {
 %
 %  if ( $cgi->param('sortby') =~ /^(\w+)$/ ) {
 %    my $sortby = $1;
@@ -29,10 +38,12 @@
 %} elsif ( $cgi->param('svcpart') =~ /^(\d+)$/ ) {
 %
 %  @svc_broadband =
-%    qsearch( 'svc_broadband', {}, '',
-%               " WHERE $1 = ( SELECT svcpart FROM cust_svc ".
-%               "              WHERE cust_svc.svcnum = svc_external.svcnum ) "
-%    );
+%    qsearch( {
+%               'table'     => 'svc_broadband',
+%               'addl_from' => 'LEFT JOIN cust_svc USING ( svcnum )',
+%               'extra_sql' => "WHERE svcpart = $1",
+%             }
+%           );
 %
 %} elsif ( $cgi->param('ip_addr') =~ /^(\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3})$/ ) {
 %  my $ip_addr = $1;
@@ -54,14 +65,14 @@
 
 <!-- mason kludge -->
 %
-%  eidiot "No matching ip address found!\n";
+% errorpage("No matching broadband services found!");
 %} else {
 %
 
 <!-- mason kludge -->
 %
 %  my($total)=scalar(@svc_broadband);
-%  print header("IP Address Search Results",''), <<END;
+%  print header("Broadband Search Results",''), <<END;
 %
 %    $total matching broadband services found
 %    <TABLE BORDER=4 CELLSPACING=0 CELLPADDING=0>