projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
5b2c7dd
)
fix customer search, RT#40212, RT#40205, fallout from RT#20173
author
Ivan Kohler
<ivan@freeside.biz>
Thu, 4 Feb 2016 19:29:22 +0000
(11:29 -0800)
committer
Ivan Kohler
<ivan@freeside.biz>
Thu, 4 Feb 2016 19:29:22 +0000
(11:29 -0800)
httemplate/search/cust_main.cgi
patch
|
blob
|
history
diff --git
a/httemplate/search/cust_main.cgi
b/httemplate/search/cust_main.cgi
index
d2a797c
..
9f4963d
100755
(executable)
--- 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