Changeset 17955

Timestamp:

2009/04/08 21:49:36 (15 years ago)

Author:

Seasoft

Message:

「お気に入り登録機能」の重複表示の修正。
・Linux-user 様の報告。  http://xoops.ec-cube.net/modules/newbb/viewtopic.php?topic_id=3739&forum=1
・使用するビューが誤っていた。

File:

• branches/comu-ver2/data/class/pages/mypage/LC_Page_Mypage_Favorite.php (modified) (1 diff)

branches/comu-ver2/data/class/pages/mypage/LC_Page_Mypage_Favorite.php

@@ -95 +95 @@
         }
 
-        $col = "allcls.*";
-        $from = "dtb_customer_favorite_products AS dcfp LEFT JOIN vw_products_allclass AS allcls USING(product_id)";
+        $col = "alldtl.*";
+        $from = "dtb_customer_favorite_products AS dcfp LEFT JOIN vw_products_allclass_detail AS alldtl USING(product_id)";
         
-        $where = "allcls.del_flg = 0 AND allcls.status = 1 AND dcfp.customer_id = ?";
+        $where = "alldtl.del_flg = 0 AND alldtl.status = 1 AND dcfp.customer_id = ?";
         // 在庫無し商品の非表示
         if (NOSTOCK_HIDDEN === true) {
-            $where .= ' AND (allcls.stock_max >= 1 OR allcls.stock_unlimited_max = 1)';
+            $where .= ' AND (alldtl.stock_max >= 1 OR alldtl.stock_unlimited_max = 1)';
         }