Changeset 17509 for branches/comu-ver2/data/class/pages/mypage

Timestamp:

2008/08/08 00:00:00 (18 years ago)

Author:

Seasoft

Message:

パラメータ設定により、在庫無し商品を一覧に非表示しないように設定可能とする。
※ カテゴリ別おすすめ商品( SC_Utils::sfGetBestProducts() )はテスト方法が分からず、未テスト。
※ dtb_maker_count の更新は未対応。

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

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