Changeset 22025

Timestamp:

2012/09/10 19:05:38 (11 years ago)

Author:

sunat134

Message:

#1935 パラメータ NOSTOCK_HIDDEN = true を設定すると、MYページお気に入り一覧でエラーになっていたのを修正

File:

• branches/version-2_12-dev/data/class/pages/mypage/LC_Page_Mypage_Favorite.php (modified) (2 diffs)

branches/version-2_12-dev/data/class/pages/mypage/LC_Page_Mypage_Favorite.php

@@ -126 +126 @@
 
         $objQuery->setOrder('create_date DESC');
-        $arrProductId  = $objQuery->getCol('product_id', 'dtb_customer_favorite_products', 'customer_id = ?', array($customer_id));
+        $where = 'customer_id = ?';
+        if (NOSTOCK_HIDDEN) {
+            $where .= ' AND EXISTS(SELECT * FROM dtb_products_class WHERE product_id = dtb_customer_favorite_products.product_id AND del_flg = 0 AND (stock >= 1 OR stock_unlimited = 1))';
+        }
+        $arrProductId  = $objQuery->getCol('product_id', 'dtb_customer_favorite_products', $where, array($customer_id));
 
         $objQuery       =& SC_Query_Ex::getSingletonInstance();
@@ -176 +180 @@
             $where = '0<>0';
         }
-        // 在庫無し商品の非表示
-        if (NOSTOCK_HIDDEN) {
-            $where .= ' AND (stock_max >= 1 OR stock_unlimited_max = 1)';
-        }
         return $where;
     }