join(' AND ', map "$_ = ". dbh->quote($svc_domain{$_}),
keys %svc_domain
);
-
}
my $sql_query = {
'hashref' => \%svc_domain,
'select' => join(', ',
'svc_domain.*',
- map "cust_main.$_", qw(custnum last first company)
+ 'cust_main.custnum',
+ FS::UI::Web::cust_sql_fields(),
),
'extra_sql' => "$extra_sql $orderby",
- 'addl_from' => 'LEFT JOIN cust_svc USING ( svcnum )'.
- 'LEFT JOIN cust_pkg USING ( pkgnum )'.
- 'LEFT JOIN cust_main USING ( custnum )',
+ 'addl_from' => 'LEFT JOIN cust_svc USING ( svcnum ) '.
+ 'LEFT JOIN cust_pkg USING ( pkgnum ) '.
+ 'LEFT JOIN cust_main USING ( custnum ) ',
};
my $link = [ "${p}view/svc_domain.cgi?", 'svcnum' ];
$svc_x->custnum ? [ "${p}view/cust_main.cgi?", 'custnum' ] : '';
};
-%><%= include ('elements/search.html',
+%><%= include( 'elements/search.html',
'title' => "Domain Search Results",
'name' => 'domains',
'query' => $sql_query,
'redirect' => $link,
'header' => [ '#',
'Domain',
- 'Customer',
+ FS::UI::Web::cust_header(),
],
'fields' => [ 'svcnum',
'domain',
- \&FS::svc_Common::cust_name,
+ \&FS::UI::Web::cust_fields,
],
'links' => [ $link,
$link,
- $link_cust,
+ ( map { $link_cust }
+ FS::UI::Web::cust_header()
+ ),
],
)
%>