Changeset 21320 for branches/version-2_11-dev/data/class/helper/SC_Helper_DB.php

Timestamp:

2011/11/10 07:59:22 (12 years ago)

Author:

Seasoft

Message:

#1536 (商品一覧画面 パラメータ NOSTOCK_HIDDEN = true で DB エラーが発生する)

File:

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

branches/version-2_11-dev/data/class/helper/SC_Helper_DB.php

@@ -657 +657 @@
         // 在庫無し商品の非表示
         if (NOSTOCK_HIDDEN) {
-            $sql_where_dtl = 'stock_max >= 1 OR stock_unlimited_max = 1';
+            $sql_where_dtl = 'stock >= 1 OR stock_unlimited = 1';
             $from = $objProduct->alldtlSQL($sql_where_dtl);
         }else{
-            $from = " dtb_products as alldtl ";
+            $from = 'dtb_products as alldtl';
         }