Changeset 23120


Ignore:
Timestamp:
2013/08/23 19:48:57 (7 years ago)
Author:
undertree
Message:

#2017 定数NOSTOCK_HIDDENがtrue時の不具合修正

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_13-dev/data/class/pages/mypage/LC_Page_Mypage_Favorite.php

    r23066 r23120  
    117117        $where = 'f.customer_id = ? and p.status = 1'; 
    118118        if (NOSTOCK_HIDDEN) { 
    119             $where .= ' AND EXISTS(SELECT * FROM dtb_products_class WHERE product_id = dtb_customer_favorite_products.product_id AND del_flg = 0 AND (stock >= 1 OR stock_unlimited = 1))'; 
     119            $where .= ' AND EXISTS(SELECT * FROM dtb_products_class WHERE product_id = f.product_id AND del_flg = 0 AND (stock >= 1 OR stock_unlimited = 1))'; 
    120120        } 
    121121        $arrProductId  = $objQuery->getCol('f.product_id', 'dtb_customer_favorite_products f inner join dtb_products p using (product_id)', $where, array($customer_id)); 
Note: See TracChangeset for help on using the changeset viewer.