Changeset 22796 for branches/version-2_12-dev/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Recommend.php

Timestamp:

2013/05/02 18:11:36 (11 years ago)

Author:

h_yoshimoto

Message:

#2236 2.12.3リリース以降の2.12-devへのコミット差し戻し

File:

• branches/version-2_12-dev/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Recommend.php (modified) (6 diffs)

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

@@ -32 +32 @@
  * @version $Id: LC_Page_FrontParts_Bloc_Best5 - Copy.php -1   $
  */
-class LC_Page_FrontParts_Bloc_Recommend extends LC_Page_FrontParts_Bloc_Ex 
-{
+class LC_Page_FrontParts_Bloc_Recommend extends LC_Page_FrontParts_Bloc_Ex {
 
     // }}}
@@ -43 +42 @@
      * @return void
      */
-    function init()
-    {
+    function init() {
         parent::init();
     }
@@ -53 +51 @@
      * @return void
      */
-    function process()
-    {
+    function process() {
         $this->action();
         $this->sendResponse();
@@ -64 +61 @@
      * @return void
      */
-    function action()
-    {
+    function action() {
 
         // 基本情報を渡す
@@ -82 +78 @@
      * @return void
      */
-    function destroy()
-    {
+    function destroy() {
         parent::destroy();
     }
@@ -92 +87 @@
      * @return array $arrBestProducts 検索結果配列
      */
-    function lfGetRanking()
-    {
-        $objRecommend = new SC_Helper_Recommend_Ex();
+    function lfGetRanking() {
+        $objQuery =& SC_Query_Ex::getSingletonInstance();
+        $objProduct = new SC_Product_Ex();
 
         // おすすめ商品取得
-        $arrRecommends = $objRecommend->getList(RECOMMEND_NUM);
+        $col = '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);
 
-        $response = array();
-        if (count($arrRecommends) > 0) {
+        $objQuery =& SC_Query_Ex::getSingletonInstance();
+        if (count($arrBestProducts) > 0) {
             // 商品一覧を取得
-            $objQuery =& SC_Query_Ex::getSingletonInstance();
-            $objProduct = new SC_Product_Ex();
             // where条件生成&セット
             $arrProductId = array();
-            foreach ($arrRecommends as $key => $val) {
+            $where = 'product_id IN (';
+            foreach ($arrBestProducts as $key => $val) {
                 $arrProductId[] = $val['product_id'];
             }
-            $arrProducts = $objProduct->getListByProductIds($objQuery, $arrProductId);
-
-            // 税込金額を設定する
-            SC_Product_Ex::setIncTaxToProducts($arrProducts);
-
+            // 取得
+            $arrProductList = $objProduct->getListByProductIds($objQuery, $arrProductId);
             // おすすめ商品情報にマージ
-            foreach ($arrRecommends as $key => $value) {
-                if (isset($arrProducts[$value['product_id']])) {
-                    $product = $arrProducts[$value['product_id']];
-                    if (!NOSTOCK_HIDDEN || ($product['status'] == 1 && ($product['stock_max'] >= 1 || $product['stock_unlimited_max'] == 1))) {
-                        $response[] = array_merge($value, $arrProducts[$value['product_id']]);
-                    }
+            foreach ($arrBestProducts as $key => $value) {
+                $arrRow =& $arrBestProducts[$key];
+                if (isset($arrProductList[$arrRow['product_id']])) {
+                    $arrRow = array_merge($arrRow, $arrProductList[$arrRow['product_id']]);
                 } else {
                     // 削除済み商品は除外
-                    unset($arrRecommends[$key]);
+                    unset($arrBestProducts[$key]);
                 }
             }
         }
-        return $response;
+        return $arrBestProducts;
     }
 }