diff options
author | Ivan Kohler <ivan@freeside.biz> | 2014-11-20 12:02:14 -0800 |
---|---|---|
committer | Ivan Kohler <ivan@freeside.biz> | 2014-11-20 12:02:14 -0800 |
commit | 128cc33659b9811c9ed455275f76fbc7c50a47b7 (patch) | |
tree | 1cf0959ad3b04651681ce04f2b7c55ca8c837436 /FS/FS/tax_rate.pm | |
parent | 03f11df0ddb098c448c237c6640855f55abb3755 (diff) |
optimize
Diffstat (limited to 'FS/FS/tax_rate.pm')
-rw-r--r-- | FS/FS/tax_rate.pm | 13 |
1 files changed, 8 insertions, 5 deletions
diff --git a/FS/FS/tax_rate.pm b/FS/FS/tax_rate.pm index a6da3d1..ec3bb12 100644 --- a/FS/FS/tax_rate.pm +++ b/FS/FS/tax_rate.pm @@ -1366,11 +1366,14 @@ sub _remember_tax_products { my ( $imported, $last, $min_sec ) = _progressbar_foo(); - my $extra_sql = "WHERE taxproductnum IS NOT NULL OR ". - "0 < ( SELECT count(*) from part_pkg_option WHERE ". - " part_pkg_option.pkgpart = part_pkg.pkgpart AND ". - " optionname LIKE 'usage_taxproductnum_%' AND ". - " optionvalue != '' )"; + my $extra_sql = " + WHERE taxproductnum IS NOT NULL + OR EXISTS ( SELECT 1 from part_pkg_option + WHERE part_pkg_option.pkgpart = part_pkg.pkgpart + AND optionname LIKE 'usage_taxproductnum_%' + AND optionvalue != '' + ) + "; my @items = qsearch( { table => 'part_pkg', select => 'DISTINCT pkgpart,taxproductnum', hashref => {}, |