diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2016-02-04 11:29:26 -0800 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2016-02-04 11:29:26 -0800 |
| commit | 7a4a4dc69ac7f2b97e477568ebce10b861461d8c (patch) | |
| tree | c2b1a21e674fb9cf86daf19b633d5dc816f5b059 | |
| parent | 63a5cebd18a9f21c66a7ed93a8dc888c595f85a4 (diff) | |
fix customer search, RT#40212, RT#40205, fallout from RT#20173
| -rwxr-xr-x | httemplate/search/cust_main.cgi | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/httemplate/search/cust_main.cgi b/httemplate/search/cust_main.cgi index d2a797c57..9f4963d55 100755 --- a/httemplate/search/cust_main.cgi +++ b/httemplate/search/cust_main.cgi @@ -498,8 +498,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 |