diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2016-02-04 11:29:27 -0800 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2016-02-04 11:29:27 -0800 |
| commit | ef0ddff4fa7109a4c279995d920220f3cc83c976 (patch) | |
| tree | be5cc776cfd4439a178eb2905e8d2060c4548605 | |
| parent | 989523fb2a31eeb5ee19ed2ef24117da3d2683e5 (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 ba80f02..7bcd5bf 100755 --- a/httemplate/search/cust_main.cgi +++ b/httemplate/search/cust_main.cgi @@ -501,8 +501,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 |