X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Fcust_main.cgi;h=aabc0b98b41a9d7b8a2cbb014010397e2d935ccf;hb=f7329b766b496393064a4dd4df2515cbfbb00827;hp=d2a797c57d158a4217e30beef57522b6e863d455;hpb=c4c8512adc83e2c6e6640112735e887b71222e1d;p=freeside.git diff --git a/httemplate/search/cust_main.cgi b/httemplate/search/cust_main.cgi index d2a797c57..aabc0b98b 100755 --- a/httemplate/search/cust_main.cgi +++ b/httemplate/search/cust_main.cgi @@ -119,6 +119,7 @@ % foreach my $cust_pkg ( @{$all_pkgs{$custnum}} ) { % my %cust_svc_by_svcpart; % my $rows = 0; +% local($FS::part_pkg::cache_enabled) = 1; #for $cust_pkg->part_svc % foreach my $part_svc ( % $cust_pkg->part_svc( summarize_size=>$large_pkg_size ) % ) { @@ -498,8 +499,13 @@ my $pkgs_method = $conf->exists('hidecancelledpackages') : 'all_pkgs'; #false laziness w/httemplate/view/cust_main/packages.html -my $select = '*, setup_option.optionvalue AS _opt_setup_fee, '. - 'recur_option.optionvalue AS _opt_recur_fee', +my $select = join(',', + 'cust_pkg.*', + 'part_pkg.*', + 'setup_option.optionvalue AS _opt_setup_fee', + 'recur_option.optionvalue AS _opt_recur_fee', + ); + my $addl_from = qq{ LEFT JOIN part_pkg USING ( pkgpart ) LEFT JOIN part_pkg_option AS setup_option