Changeset 21975

Timestamp:

2012/07/27 13:59:36 (12 years ago)

Author:

dkazuto

Message:

#1881 商品一覧画面 パラメータ NOSTOCK_HIDDEN = true で DB エラーが発生するバグを修正

File:

• branches/version-2_12-dev/data/class/pages/products/LC_Page_Products_List.php (modified) (1 diff)

branches/version-2_12-dev/data/class/pages/products/LC_Page_Products_List.php

@@ -452 +452 @@
         // 在庫無し商品の非表示
         if (NOSTOCK_HIDDEN) {
-            $searchCondition['where'] .= ' AND (stock >= 1 OR stock_unlimited = 1)';
+            $searchCondition['where'] .= ' AND EXISTS(SELECT * FROM dtb_products_class WHERE product_id = alldtl.product_id AND del_flg = 0 AND (stock >= 1 OR stock_unlimited = 1))';
             $searchCondition['where_for_count'] .= ' AND EXISTS(SELECT * FROM dtb_products_class WHERE product_id = alldtl.product_id AND del_flg = 0 AND (stock >= 1 OR stock_unlimited = 1))';
         }