httemplate/search/svc_domain.cgi

   1 <% include( 'elements/search.html',
   2                  'title'             => "Domain Search Results",
   3                  'name'              => 'domains',
   4                  'query'             => $sql_query,
   5                  'count_query'       => $count_query,
   6                  'redirect'          => $link,
   7                  'header'            => [ '#',
   8                                           'Service',
   9                                           'Domain',
  10                                           FS::UI::Web::cust_header(),
  11                                         ],
  12                  'fields'            => [ 'svcnum',
  13                                           'svc',
  14                                           'domain',
  15                                           \&FS::UI::Web::cust_fields,
  16                                         ],
  17                  'links'             => [ $link,
  18                                           $link,
  19                                           $link,
  20                                           ( map { $_ ne 'Cust. Status' ? $link_cust : '' }
  21                                                 FS::UI::Web::cust_header()
  22                                           ),
  23                                         ],
  24                  'align' => 'rll'. FS::UI::Web::cust_aligns(),
  25                  'color' => [
  26                               '',
  27                               '',
  28                               '',
  29                               FS::UI::Web::cust_colors(),
  30                             ],
  31                  'style' => [
  32                               '',
  33                               '',
  34                               '',
  35                               FS::UI::Web::cust_styles(),
  36                             ],
  37               )
  38 %>
  39 <%init>
  40
  41 die "access denied"
  42   unless $FS::CurrentUser::CurrentUser->access_right('List services');
  43
  44 my $conf = new FS::Conf;
  45
  46 my $orderby = 'ORDER BY svcnum';
  47 my %svc_domain = ();
  48 my @extra_sql = ();
  49 if ( $cgi->param('magic') =~ /^(all|unlinked)$/ ) {
  50
  51   push @extra_sql, 'pkgnum IS NULL'
  52     if $cgi->param('magic') eq 'unlinked';
  53
  54   if ( $cgi->param('sortby') =~ /^(\w+)$/ ) {
  55     my $sortby = $1;
  56     $orderby = "ORDER BY $sortby";
  57   }
  58
  59 } elsif ( $cgi->param('svcpart') =~ /^(\d+)$/ ) {
  60   push @extra_sql, "svcpart = $1";
  61 } else {
  62   $cgi->param('domain') =~ /^([\w\-\.]+)$/;
  63   $svc_domain{'domain'} = $1;
  64 }
  65
  66 my $addl_from = ' LEFT JOIN cust_svc  USING ( svcnum  ) '.
  67                 ' LEFT JOIN part_svc  USING ( svcpart ) '.
  68                 ' LEFT JOIN cust_pkg  USING ( pkgnum  ) '.
  69                 ' LEFT JOIN cust_main USING ( custnum ) ';
  70
  71 #here is the agent virtualization
  72 push @extra_sql, $FS::CurrentUser::CurrentUser->agentnums_sql;
  73
  74 my $extra_sql = '';
  75 if ( @extra_sql ) {
  76   $extra_sql = ( keys(%svc_domain) ? ' AND ' : ' WHERE ' ).
  77                join(' AND ', @extra_sql );
  78 }
  79
  80 my $count_query = "SELECT COUNT(*) FROM svc_domain $addl_from ";
  81 if ( keys %svc_domain ) {
  82   $count_query .= ' WHERE '.
  83                     join(' AND ', map "$_ = ". dbh->quote($svc_domain{$_}),
  84                                       keys %svc_domain
  85                         );
  86 }
  87 $count_query .= $extra_sql;
  88
  89 my $sql_query = {
  90   'table'     => 'svc_domain',
  91   'hashref'   => \%svc_domain,
  92   'select'    => join(', ',
  93                    'svc_domain.*',
  94                    'part_svc.svc',
  95                    'cust_main.custnum',
  96                    FS::UI::Web::cust_sql_fields(),
  97                  ),
  98   'extra_sql' => "$extra_sql $orderby",
  99   'addl_from' => $addl_from,
 100 };
 101
 102 my $link = [ "${p}view/svc_domain.cgi?", 'svcnum' ];
 103
 104 #smaller false laziness w/svc_*.cgi here
 105 my $link_cust = sub {
 106   my $svc_x = shift;
 107   $svc_x->custnum ? [ "${p}view/cust_main.cgi?", 'custnum' ] : '';
 108 };
 109
 110 </%init>