fix a snarl in query construction
authorMark Wells <mark@freeside.biz>
Sat, 18 Jan 2014 00:39:28 +0000 (16:39 -0800)
committerMark Wells <mark@freeside.biz>
Sat, 18 Jan 2014 00:39:28 +0000 (16:39 -0800)
httemplate/search/cust_bill_pkg.cgi

index 61093d2..7476f4d 100644 (file)
@@ -436,12 +436,12 @@ if ( $cgi->param('nottax') ) {
 
     $join_pkg .= " LEFT JOIN ($exempt_sub) AS item_exempt
     USING (billpkgnum)";
-  }
  
-  # process tax restrictions
-  unshift @tax_where,
-    'cust_bill_pkg_tax_location.taxable_billpkgnum = cust_bill_pkg.billpkgnum',
-    'cust_main_county.tax > 0';
+    # process tax restrictions
+    unshift @tax_where,
+      'cust_bill_pkg_tax_location.taxable_billpkgnum = cust_bill_pkg.billpkgnum',
+      'cust_main_county.tax > 0';
+  }
 
   my $tax_sub = "SELECT 1
     FROM cust_bill_pkg_tax_location