diff options
| author | ivan <ivan> | 2005-07-14 10:52:46 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2005-07-14 10:52:46 +0000 |
| commit | 08662d58e7b9a13cf841e9c89daa39b28655724e (patch) | |
| tree | bb6415dcfc8c94a30639c8a913051a38c31780ad /httemplate/search/svc_domain.cgi | |
| parent | c91e5cd4ce307d5f3573ea309cbcf03186ea3de4 (diff) | |
move account search (httemplate/search/svc_acct.cgi) to new template, cust-fields configuration value to control which customer fields are shown on reports
Diffstat (limited to 'httemplate/search/svc_domain.cgi')
| -rwxr-xr-x | httemplate/search/svc_domain.cgi | 18 |
1 files changed, 10 insertions, 8 deletions
diff --git a/httemplate/search/svc_domain.cgi b/httemplate/search/svc_domain.cgi index 06041e03b..f261ea9f3 100755 --- a/httemplate/search/svc_domain.cgi +++ b/httemplate/search/svc_domain.cgi @@ -37,7 +37,6 @@ if ( keys %svc_domain ) { join(' AND ', map "$_ = ". dbh->quote($svc_domain{$_}), keys %svc_domain ); - } my $sql_query = { @@ -45,12 +44,13 @@ 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' ]; @@ -69,15 +69,17 @@ my $link_cust = sub { '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() + ), ], ) %> |