Changeset 20196

Timestamp:

2011/02/18 17:07:49 (12 years ago)

Author:

yomoro

Message:

#986 再リファクタリング

File:

• branches/version-2_5-dev/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Best5.php (modified) (3 diffs)

branches/version-2_5-dev/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Best5.php

@@ -65 +65 @@
 
         // 基本情報を渡す
-        $objSiteInfo = new SC_SiteInfo();
+        $objSiteInfo = SC_Helper_DB_Ex::sfGetBasisData();
         $this->arrInfo = $objSiteInfo->data;
 
@@ -87 +87 @@
      */
     function lfGetRanking(){
+        $arrProduct = array();
         // おすすめ商品取得
         $objQuery = SC_Query::getSingletonInstance();
@@ -106 +107 @@
         $objQuery->setLimit(RECOMMEND_NUM);
         $arrBestProducts = $objQuery->getAll($sql);
-        // 各商品の詳細情報を取得
-        $objQuery = SC_Query::getSingletonInstance();
-        $objProduct = new SC_Product();
-        // where条件生成&セット
-        $arrBestProductIds = array();
-        $where = 'product_id IN ( ';
-        foreach( $arrBestProducts as $key => $val ) {
-            $arrBestProductIds[] = $val['product_id'];
-        }
-        $where .= implode(', ', $arrBestProductIds);
-        $where .= ' )';
-        $objQuery->setWhere($where);
-        // 取得
-        $arrProductList = $objProduct->lists($objQuery);
-        // おすすめ商品情報とマージ
-        $arrProduct = array();
-        foreach( $arrProductList as $pdct_key => $pdct_val ) {
-            foreach( $arrBestProducts as $best_key => $best_val ) {
-                if ( $pdct_val['product_id'] == $best_val['product_id'] ) {
-                    $arrProduct[$best_key] = array_merge($best_val, $pdct_val);
-                    break;
+        if ( is_array($arrBestProducts) && count($arrBestProducts) > 0 ) {
+            // 各商品の詳細情報を取得
+            $objQuery = SC_Query::getSingletonInstance();
+            $objProduct = new SC_Product();
+            // where条件生成&セット
+            $arrBestProductIds = array();
+            $where = 'product_id IN ( ';
+            foreach( $arrBestProducts as $key => $val ) {
+                $arrBestProductIds[] = $val['product_id'];
+            }
+            $where .= implode(', ', $arrBestProductIds);
+            $where .= ' )';
+            $objQuery->setWhere($where);
+            // 取得
+            $arrProductList = $objProduct->lists($objQuery);
+            // おすすめ商品情報とマージ
+            foreach( $arrProductList as $pdct_key => $pdct_val ) {
+                foreach( $arrBestProducts as $best_key => $best_val ) {
+                    if ( $pdct_val['product_id'] == $best_val['product_id'] ) {
+                        $arrProduct[$best_key] = array_merge($best_val, $pdct_val);
+                        break;
+                    }
                 }
             }