Changeset 17921 for branches/comu-ver2/data/class/pages/rss/LC_Page_Rss.php

Timestamp:

2009/03/20 16:01:20 (15 years ago)

Author:

Seasoft

Message:

新着情報に関する改修
・初期登録データの日付を時刻切捨て(管理機能の仕様に合わせた)
・RSS 出力に関わる不具合修正

 http://xoops.ec-cube.net/modules/newbb/viewtopic.php?topic_id=3172&forum=8

※ DBバージョン依存に不安あり。

File:

• branches/comu-ver2/data/class/pages/rss/LC_Page_Rss.php (modified) (4 diffs)

branches/comu-ver2/data/class/pages/rss/LC_Page_Rss.php

@@ -60 +60 @@
         //新着情報を取得
         $arrNews = $this->lfGetNews($objQuery);
-
+        
         //キャッシュしない(念のため)
         header("pragma: no-cache");
@@ -69 +69 @@
         //新着情報をセット
         $this->arrNews = $arrNews;
-        $this->timestamp = SC_Utils_Ex::sf_mktime("r", $arrNews[0]['hour'], $arrNews[0]['minute'], $arrNews[0]['second'], $arrNews[0]['month'], $arrNews[0]['day'], $arrNews[0]['year']);
 
         //店名をセット
@@ -101 +100 @@
     function lfGetNews(&$objQuery){
         $col = "";
-        $col .= "     news_id ";                                //新着情報ID
-        $col .= "     ,news_title ";                            //新着情報タイトル
-        $col .= "     ,news_comment ";                          //新着情報本文
-
-        if (DB_TYPE == "pgsql") {
-            $col .= "     ,to_char(news_date, 'YYYY') AS YEAR ";    //日付(年)
-            $col .= "     ,to_char(news_date, 'MM') AS MONTH ";     //日付(月)
-            $col .= "     ,to_char(news_date, 'DD') AS DAY ";       //日付(日)
-            $col .= "     ,to_char(news_date, 'HH24') AS HOUR ";    //日付(時間)
-            $col .= "     ,to_char(news_date, 'MI') AS MINUTE ";    //日付(分)
-            $col .= "     ,to_char(news_date, 'SS') AS SECOND ";    //日付(秒)
-        }else if (DB_TYPE == "mysql") {
-            $col .= "     ,DATE_FORMAT(news_date, '%Y') AS YEAR ";      //日付(年)
-            $col .= "     ,DATE_FORMAT(news_date, '%m') AS MONTH ";     //日付(月)
-            $col .= "     ,DATE_FORMAT(news_date, '%d') AS DAY ";       //日付(日)
-            $col .= "     ,DATE_FORMAT(news_date, '%H') AS HOUR ";      //日付(時間)
-            $col .= "     ,DATE_FORMAT(news_date, '%i') AS MINUTE ";    //日付(分)
-            $col .= "     ,DATE_FORMAT(news_date, '%s') AS SECOND ";    //日付(秒)
-        }
-        $col .= "     ,news_url ";                              //新着情報URL
-        $col .= "     ,news_select ";                           //新着情報の区分(1:URL、2:本文)
-        $col .= "     ,(SELECT shop_name FROM dtb_baseinfo limit 1) AS shop_name  ";    //店名
-        $col .= "     ,(SELECT email04 FROM dtb_baseinfo limit 1) AS email ";           //代表Emailアドレス
+        $col .= "news_id ";        // 新着情報ID
+        $col .= ",news_title ";    // 新着情報タイトル
+        $col .= ",news_comment ";  // 新着情報本文
+        $col .= ",news_date ";     // 日付
+        $col .= ",news_url ";      // 新着情報URL
+        $col .= ",news_select ";   // 新着情報の区分(1:URL、2:本文)
+        $col .= ",(SELECT shop_name FROM dtb_baseinfo limit 1) AS shop_name  ";    // 店名
+        $col .= ",(SELECT email04 FROM dtb_baseinfo limit 1) AS email ";           // 代表Emailアドレス
         $from = "dtb_news";
         $where = "del_flg = '0'";
@@ -129 +113 @@
         $objQuery->setorder($order);
         $arrNews = $objQuery->select($col,$from,$where);
+        
+        // RSS用に変換
+        foreach (array_keys($arrNews) as $key) {
+            $row =& $arrNews[$key];
+            // 日付
+            $row['news_date'] = date('r', strtotime($row['news_date']));
+        }
+        
         return $arrNews;
     }