% 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 )
% ) {
: '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