Changeset 22232 for branches/version-2_12-dev/data
- Timestamp:
- 2013/01/11 18:06:38 (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/pages/mypage/LC_Page_Mypage_Favorite.php
r22206 r22232 125 125 $objProduct = new SC_Product_Ex(); 126 126 127 $objQuery->setOrder(' create_date DESC');128 $where = ' customer_id = ?';127 $objQuery->setOrder('f.create_date DESC'); 128 $where = 'f.customer_id = ? and p.status = 1'; 129 129 if (NOSTOCK_HIDDEN) { 130 130 $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))'; 131 131 } 132 $arrProductId = $objQuery->getCol(' product_id', 'dtb_customer_favorite_products', $where, array($customer_id));132 $arrProductId = $objQuery->getCol('f.product_id', 'dtb_customer_favorite_products f inner join dtb_products p using (product_id)', $where, array($customer_id)); 133 133 134 134 $objQuery =& SC_Query_Ex::getSingletonInstance();
Note: See TracChangeset
for help on using the changeset viewer.