X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Fsvc_hardware.cgi;h=93fc2c391691d22f4c8810ea83f78794703daa6e;hb=c0c5709fb022b83a482d0b35f7094505766d5868;hp=7dd0058dc4d8389475599319851c1128b2eca612;hpb=825422583d2d510c0f552c513bef4cc1ac921950;p=freeside.git diff --git a/httemplate/search/svc_hardware.cgi b/httemplate/search/svc_hardware.cgi index 7dd0058dc..93fc2c391 100644 --- a/httemplate/search/svc_hardware.cgi +++ b/httemplate/search/svc_hardware.cgi @@ -1,4 +1,4 @@ -<% include('elements/search.html', +<& elements/svc_Common.html, 'title' => 'Hardware service search results', 'name' => 'installations', 'query' => $sql_query, @@ -19,7 +19,7 @@ 'model', 'revision', 'serial', - 'hw_addr', + 'display_hw_addr', 'ip_addr', 'smartcard', \&FS::UI::Web::cust_fields, @@ -34,8 +34,7 @@ FS::UI::Web::cust_colors() ], 'style' => [ $svc_cancel_style, ('') x 7, FS::UI::Web::cust_styles() ], - ) -%> +&> <%init> die "access denied" @@ -44,8 +43,8 @@ die "access denied" my $addl_from = ' LEFT JOIN cust_svc USING ( svcnum ) LEFT JOIN part_svc USING ( svcpart ) - LEFT JOIN cust_pkg USING ( pkgnum ) - LEFT JOIN cust_main USING ( custnum ) + LEFT JOIN cust_pkg USING ( pkgnum )'. + FS::UI::Web::join_cust_main('cust_pkg', 'cust_pkg').' LEFT JOIN hardware_type USING ( typenum )'; my @extra_sql;