Changeset 21975


Ignore:
Timestamp:
2012/07/27 13:59:36 (11 years ago)
Author:
dkazuto
Message:

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

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_12-dev/data/class/pages/products/LC_Page_Products_List.php

    r21957 r21975  
    452452        // 在庫無し商品の非表示 
    453453        if (NOSTOCK_HIDDEN) { 
    454             $searchCondition['where'] .= ' AND (stock >= 1 OR stock_unlimited = 1)'; 
     454            $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))'; 
    455455            $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))'; 
    456456        } 
Note: See TracChangeset for help on using the changeset viewer.