Changeset 20076 for branches/version-2_5-dev/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_News.php

Timestamp:

2011/02/03 18:40:05 (13 years ago)

Author:

yomoro

Message:

#986 リファクタリング

File:

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

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

@@ -75 +75 @@
     }
 
+    /**
+     * 新着情報を取得する.
+     *
+     * @return array $arrNewsList 新着情報の配列を返す
+     */
     function lfGetNews(){
         $objQuery = new SC_Query();
-        $sql = "SELECT *, cast(news_date as date) as news_date_disp FROM dtb_news WHERE del_flg = '0' ORDER BY rank DESC";
-        $list_data = $objQuery->getAll($sql);
-        return $list_data;
+        $sql = '';
+        $sql .= " SELECT ";
+        $sql .= "   *, ";
+        $sql .= "   cast(news_date as date) as news_date_disp ";
+        $sql .= " FROM ";
+        $sql .= "   dtb_news ";
+        $sql .= " WHERE ";
+        $sql .= "   del_flg = '0' ";
+        $sql .= " ORDER BY ";
+        $sql .= "   rank DESC ";
+        
+        $arrNewsList = $objQuery->getAll($sql);
+        return $arrNewsList;
     }
 }