Changeset 23334

Timestamp:

2014/02/05 17:45:30 (9 years ago)

Author:

kimoto

Message:

#2504 SQLの条件が間違っているので修正

File:

• branches/version-2_13-dev/data/class/helper/SC_Helper_TaxRule.php (modified) (1 diff)

branches/version-2_13-dev/data/class/helper/SC_Helper_TaxRule.php

@@ -168 +168 @@
             $table = 'dtb_tax_rule';
             $cols = '*';
-            
+
             // 商品税率有無設定により分岐
             if(OPTION_PRODUCT_TAX_RULE == 1) {
-                $where = '((product_id = 0 OR product_id = ?)'
-                            . ' OR (product_class_id = 0 OR product_class_id = ?))'
-                            . ' AND (pref_id = 0 OR pref_id = ?)'
-                            . ' AND (country_id = 0 OR country_id = ?)'
-                            . ' AND apply_date < CURRENT_TIMESTAMP'
-                            . ' AND del_flg = 0';
+                $where = '
+                        (
+                            (product_id = 0 OR product_id = ?)
+                            AND (product_class_id = 0 OR product_class_id = ?)
+                        )
+                    AND (pref_id = 0 OR pref_id = ?)
+                    AND (country_id = 0 OR country_id = ?)
+                    AND apply_date < CURRENT_TIMESTAMP
+                    AND del_flg = 0';
                 $arrVal = array($product_id, $product_class_id, $pref_id, $country_id);
             } else {