Changeset 21320

Timestamp:

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

Author:

Seasoft

Message:

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

Location:

branches/version-2_11-dev/data/class

Files:

• SC_Product.php (modified) (1 diff)
• helper/SC_Helper_DB.php (modified) (1 diff)

branches/version-2_11-dev/data/class/SC_Product.php

@@ -664 +664 @@
      * 商品詳細の SQL を取得する.
      *
-     * @param string $where 商品詳細の WHERE 句
+     * @param string $where_products_class 商品詳細の WHERE 句
      * @return string 商品詳細の SQL
      */
-    function alldtlSQL($where = "") {
-        $where_clause = "";
-        if (!SC_Utils_Ex::isBlank($where)) {
-            $where_clause = " WHERE " . $where;
+    function alldtlSQL($where_products_class = '') {
+        $where_clause = '';
+        if (!SC_Utils_Ex::isBlank($where_products_class)) {
+            $where_clause = 'WHERE ' . $where_products_class;
         }
         /*

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';
         }