Changeset 21380


Ignore:
Timestamp:
2011/12/31 11:27:36 (9 years ago)
Author:
fukap
Message:

#1586(おすすめ商品ブロックに、非公開商品が表示される)

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_11-dev/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Recommend.php

    r21325 r21380  
    9090 
    9191        // おすすめ商品取得 
    92         $col = 'best_id, best_id, category_id, rank, product_id, title, comment, create_date, update_date'; 
    93         $table = 'dtb_best_products'; 
    94         $where = 'del_flg = 0'; 
    95         $objQuery->setOrder('rank'); 
     92        $col = 'T1.best_id, T1.best_id, T1.category_id, T1.rank, T1.product_id, T1.title, T1.comment, T1.create_date, T1.update_date'; 
     93        $table = 'dtb_best_products as T1 INNER JOIN dtb_products as T2 ON T1.product_id = T2.product_id'; 
     94        $where = 'T1.del_flg = 0 and T2.status = 1'; 
     95        $objQuery->setOrder('T1.rank'); 
    9696        $objQuery->setLimit(RECOMMEND_NUM); 
    9797        $arrBestProducts = $objQuery->select($col, $table, $where); 
    9898 
    99         $objQuery =& SC_Query_Ex::getSingletonInstance(); 
    10099        if (count($arrBestProducts) > 0) { 
    101100            // 商品一覧を取得 
Note: See TracChangeset for help on using the changeset viewer.