-<% include( 'elements/search.html',
- 'title' => 'Service search results',
- 'name' => 'services',
+<& elements/search.html,
+ 'title' => emt('Service search results'),
+ 'name' => emt('services'),
'query' => $sql_query,
'count_query' => $count_query,
'redirect' => $link,
- 'header' => [ '#',
- 'Service',
+ 'header' => [ emt('#'),
+ emt('Service'),
# package?
FS::UI::Web::cust_header(),
],
'',
FS::UI::Web::cust_styles(),
],
- )
-%>
+&>
<%init>
die "access denied"
$cgi->param('svcdb') =~ /^(svc_\w+)$/ or die "unknown svcdb";
push @extra_sql, "svcdb = '$1'";
+ $addl_from .= " LEFT JOIN $1 USING ( svcnum ) ";
push @extra_sql, 'pkgnum IS NULL'
if $cgi->param('magic') eq 'unlinked';
errorpage("No search term specified");
}
-if ( $cgi->param('pkgnum') =~ /^(\d+)$/ ) {
- push @extra_sql, "cust_svc.pkgnum = $1";
-}
-
#here is the agent virtualization
push @extra_sql, $FS::CurrentUser::CurrentUser->agentnums_sql(
'null_right' => 'View/link unlinked services'
'table' => 'cust_svc',
'addl_from' => $addl_from,
'hashref' => {},
- 'extra_sql' => "$extra_sql $orderby",
+ 'extra_sql' => $extra_sql,
+ 'order_by' => $orderby,
};
-warn Dumper($sql_query)."\n";
-
my $count_query = "SELECT COUNT(*) FROM cust_svc $addl_from $extra_sql";
my $link = sub {