Changeset 21678


Ignore:
Timestamp:
2012/03/26 18:28:02 (9 years ago)
Author:
AMUAMU
Message:

#1721 (関連商品に非公開商品が表示される) の改修。

File:
1 edited

Legend:

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

    r21659 r21678  
    466466 
    467467        $objQuery->setOrder('rank DESC'); 
    468         $arrRecommendData = $objQuery->select('recommend_product_id, comment', 'dtb_recommend_products', 'product_id = ?', array($product_id)); 
     468        $arrRecommendData = $objQuery->select("recommend_product_id, comment", "dtb_recommend_products as t1 left join dtb_products as t2 on t1.recommend_product_id = t2.product_id", "t1.product_id = ? and t2.del_flg = 0 and t2.status = 1", array($product_id)); 
    469469 
    470470        $arrRecommendProductId = array(); 
Note: See TracChangeset for help on using the changeset viewer.