diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2013-03-13 13:34:00 -0700 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2013-03-13 13:34:00 -0700 |
| commit | bcdeefe43f138092344200535100f5c035566efc (patch) | |
| tree | 1a32bc4dd5cc49b59b7ca36cf71ba85678b8f1f9 | |
| parent | 97f03b3b092ed922462308fa68dabfe92c7f7905 (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 4308e247e..c81331345 100644 --- a/httemplate/search/cust_bill_pkg.cgi +++ b/httemplate/search/cust_bill_pkg.cgi @@ -624,11 +624,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'; } |