diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2013-03-13 13:33:58 -0700 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2013-03-13 13:33:58 -0700 |
| commit | 7e90fee50d691a93369b1693cbb3743e627bdb03 (patch) | |
| tree | 53b53b97c2d8048038a011d0b372ed901ae32bc5 | |
| parent | 57db4484cae295551c72c88c936ef8a71d35730d (diff) | |
fix line item detail search w/"Separate sub-packages from parents", RT#21904
| -rw-r--r-- | httemplate/search/cust_bill_pkg.cgi | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/httemplate/search/cust_bill_pkg.cgi b/httemplate/search/cust_bill_pkg.cgi index 6a9f8775e..11937b3d5 100644 --- a/httemplate/search/cust_bill_pkg.cgi +++ b/httemplate/search/cust_bill_pkg.cgi @@ -278,11 +278,11 @@ my $join_pkg = LEFT JOIN part_pkg USING (pkgpart)'; my $part_pkg = 'part_pkg'; -if ( $cgi->param('use_override') ) { +if ( $cgi->param('use_override') ) { #"Separate sub-packages from parents" # still need the real part_pkg for tax applicability, # so alias this one $join_pkg .= " LEFT JOIN part_pkg AS override ON ( - COALESCE(cust_bill_pkg.pkgpart_override, cust_pkg.pkgpart, 0) = part_pkg.pkgpart + COALESCE(cust_bill_pkg.pkgpart_override, cust_pkg.pkgpart, 0) = override.pkgpart )"; $part_pkg = 'override'; } |