diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2016-02-04 11:29:22 -0800 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2016-02-04 11:29:22 -0800 |
| commit | affba4b02a38999423f4189a40862a4c6549552a (patch) | |
| tree | ef4ae68b1c35e388fa89e8a45a3df0ffc83690d7 | |
| parent | 5b2c7dda1c5acf62de9e7472ad6ec7a25bdca04d (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 |