Changeset 17509 for branches/comu-ver2/data/class/helper/SC_Helper_DB.php

Timestamp:

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

Author:

Seasoft

Message:

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

File:

• branches/comu-ver2/data/class/helper/SC_Helper_DB.php (modified) (1 diff)

branches/comu-ver2/data/class/helper/SC_Helper_DB.php

@@ -928 +928 @@
         $sql .= " FROM dtb_category AS T1 LEFT JOIN dtb_product_categories AS T2";
         $sql .= " ON T1.category_id = T2.category_id ";
-        $sql .= " LEFT JOIN dtb_products AS T3";
-        $sql .= " ON T2.product_id = T3.product_id";
-        $sql .= " WHERE T3.del_flg = 0 AND T3.status = 1 ";
+        $sql .= " LEFT JOIN vw_products_allclass AS allcls";
+        $sql .= " ON T2.product_id = allcls.product_id";
+        $sql .= " WHERE allcls.del_flg = 0 AND allcls.status = 1 ";
+        
+        // 在庫無し商品の非表示
+        if (NOSTOCK_HIDDEN === true) {
+            $sql .= ' AND (allcls.stock_max >= 1 OR allcls.stock_unlimited_max = 1)';
+        }
+        
         $sql .= " GROUP BY T1.category_id, T2.category_id ";
         $objQuery->query($sql);