Changeset 21380

Timestamp:

2011/12/31 11:27:36 (11 years ago)

Author:

fukap

Message:

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

File:

• branches/version-2_11-dev/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Recommend.php (modified) (1 diff)

branches/version-2_11-dev/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Recommend.php

@@ -90 +90 @@
 
         // おすすめ商品取得
-        $col = 'best_id, best_id, category_id, rank, product_id, title, comment, create_date, update_date';
-        $table = 'dtb_best_products';
-        $where = 'del_flg = 0';
-        $objQuery->setOrder('rank');
+        $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';
+        $table = 'dtb_best_products as T1 INNER JOIN dtb_products as T2 ON T1.product_id = T2.product_id';
+        $where = 'T1.del_flg = 0 and T2.status = 1';
+        $objQuery->setOrder('T1.rank');
         $objQuery->setLimit(RECOMMEND_NUM);
         $arrBestProducts = $objQuery->select($col, $table, $where);
 
-        $objQuery =& SC_Query_Ex::getSingletonInstance();
         if (count($arrBestProducts) > 0) {
             // 商品一覧を取得