X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Fsvc_hardware.cgi;h=93fc2c391691d22f4c8810ea83f78794703daa6e;hb=a6def4c68914a9d8a282eaa34dcff5f6fd002568;hp=ec09be82bcbf39a30d76f4cd6bca22161af5039b;hpb=69bf020f03918910e0e34260d6e5a9d984f0414d;p=freeside.git diff --git a/httemplate/search/svc_hardware.cgi b/httemplate/search/svc_hardware.cgi index ec09be82b..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, @@ -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;