Changeset 15078 for branches/feature-module-update/html/rss/index.php

Timestamp:

2007/07/20 15:58:59 (17 years ago)

Author:

nanasess

Message:

r15064 から svn cp
とりあえず暫定コミット.

• UTF-8 に変更
• slib.php, glib.php のクラス化
• LC_Page の抽象化（一部）

Location:

branches/feature-module-update

Files:

• . (copied) (copied from branches/rel) (1 prop)
• html (copied) (copied from branches/rel/html)
• html/rss/index.php (modified) (3 diffs)

branches/feature-module-update/html/rss/index.php

@@ -6 +6 @@
  */
 
-//¶¦ÄÌÉôÉʤÎÆɤ߹þ¤ß
+//共通部品の読み込み
 require_once("../require.php");
 
@@ -13 +13 @@
         $this->tpl_mainpage = "rss/index.tpl";
         $this->encode = "UTF-8";
-        $this->description = "¿·Ãå¾ðÊó";
+        $this->description = "新着情報";
     }
 }
@@ -21 +21 @@
 $objView = new SC_SiteView(false);
 
-//¿·Ãå¾ðÊó¤ò¼èÆÀ
+//新着情報を取得
 $arrNews = lfGetNews($objQuery);
 
-//¥­¥ã¥Ã¥·¥å¤·¤Ê¤¤(Ç°¤Î¤¿¤á)
+//キャッシュしない(念のため)
 header("pragma: no-cache");
 
-//XML¥Æ¥­¥¹¥È(¤³¤ì¤¬¤Ê¤¤¤ÈÀµ¾ï¤ËRSS¤È¤·¤Æǧ¼±¤·¤Æ¤¯¤ì¤Ê¤¤¥Ä¡¼¥ë¤¬¤¢¤ë¤¿¤á)
+//XMLテキスト(これがないと正常にRSSとして認識してくれないツールがあるため)
 header("Content-type: application/xml");
 
-//¿·Ãå¾ðÊó¤ò¥»¥Ã¥È
+//新着情報をセット
 $objPage->arrNews = $arrNews;
 $objPage->timestamp = sf_mktime("r", $arrNews[0]['HOUR'], $arrNews[0]['MINUTE'], $arrNews[0]['SECOND'], $arrNews[0]['MONTH'], $arrNews[0]['DAY'], $arrNews[0]['YEAR']);
 
-//Ź̾¤ò¥»¥Ã¥È
+//店名をセット
 $objPage->site_title = $arrNews[0]['shop_name'];
 
-//ÂåɽEmail¥¢¥É¥ì¥¹¤ò¥»¥Ã¥È
+//代表Emailアドレスをセット
 $objPage->email = $arrNews[0]['email'];
 
-//¥»¥Ã¥È¤·¤¿¥Ç¡¼¥¿¤ò¥Æ¥ó¥×¥ì¡¼¥È¥Õ¥¡¥¤¥ë¤Ë½ÐÎÏ
+//セットしたデータをテンプレートファイルに出力
 $objView->assignobj($objPage);
 
-//²èÌÌɽ¼¨
+//画面表示
 $objView->display($objPage->tpl_mainpage, true);
 
 //---------------------------------------------------------------------------------------------------------------------
 /***************************************************************************************************************
- * ´Ø¿ô̾:lfGetNews
- * ÀâÌÀ¡¡:¿·Ãå¾ðÊó¤ò¼èÆÀ¤¹¤ë
- * °ú¿ô£±:$objQuery     DBÁàºî¥¯¥é¥¹
- * Ìá¤êÃÍ:$arrNews      ¼èÆÀ·ë²Ì¤òÇÛÎó¤ÇÊÖ¤¹
+ * 関数名:lfGetNews
+ * 説明　:新着情報を取得する
+ * 引数１:$objQuery        DB操作クラス
+ * 戻り値:$arrNews     取得結果を配列で返す
  ***************************************************************************************************************/
 function lfGetNews($objQuery){
     $col = "";
-    $col .= "     news_id ";                                //¿·Ãå¾ðÊóID
-    $col .= "     ,news_title ";                            //¿·Ãå¾ðÊ󥿥¤¥È¥ë
-    $col .= "     ,news_comment ";                          //¿·Ãå¾ðÊóËÜʸ
+    $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 ";    //ÆüÉÕ(ÉÃ)
+        $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 .= "     ,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_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'";