Changeset 16192
- Timestamp:
- 2007/10/01 02:21:17 (16 years ago)
- Location:
- branches/feature-module-update
- Files:
-
- 4 added
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/feature-module-update/html/rss/index.php
r15532 r16192 6 6 */ 7 7 8 // 共通部品の読み込み8 // {{{ requires 9 9 require_once("../require.php"); 10 require_once(CLASS_PATH . "page_extends/rss/LC_Page_Rss_Ex.php"); 10 11 11 class LC_Page{ 12 function LC_Page(){ 13 $this->tpl_mainpage = "rss/index.tpl"; 14 $this->encode = "UTF-8"; 15 $this->description = "新着情報"; 16 } 17 } 12 // }}} 13 // {{{ generate page 18 14 19 $objQuery = new SC_Query(); 20 $objPage = new LC_Page(); 21 $objView = new SC_SiteView(false); 22 23 //新着情報を取得 24 $arrNews = lfGetNews($objQuery); 25 26 //キャッシュしない(念のため) 27 header("pragma: no-cache"); 28 29 //XMLテキスト(これがないと正常にRSSとして認識してくれないツールがあるため) 30 header("Content-type: application/xml"); 31 32 //新着情報をセット 33 $objPage->arrNews = $arrNews; 34 $objPage->timestamp = sf_mktime("r", $arrNews[0]['HOUR'], $arrNews[0]['MINUTE'], $arrNews[0]['SECOND'], $arrNews[0]['MONTH'], $arrNews[0]['DAY'], $arrNews[0]['YEAR']); 35 36 //店名をセット 37 $objPage->site_title = $arrNews[0]['shop_name']; 38 39 //代表Emailアドレスをセット 40 $objPage->email = $arrNews[0]['email']; 41 42 //セットしたデータをテンプレートファイルに出力 43 $objView->assignobj($objPage); 44 45 //画面表示 46 $objView->display($objPage->tpl_mainpage, true); 47 48 //--------------------------------------------------------------------------------------------------------------------- 49 /*************************************************************************************************************** 50 * 関数名:lfGetNews 51 * 説明 :新着情報を取得する 52 * 引数1:$objQuery DB操作クラス 53 * 戻り値:$arrNews 取得結果を配列で返す 54 ***************************************************************************************************************/ 55 function lfGetNews($objQuery){ 56 $col = ""; 57 $col .= " news_id "; //新着情報ID 58 $col .= " ,news_title "; //新着情報タイトル 59 $col .= " ,news_comment "; //新着情報本文 60 61 if (DB_TYPE == "pgsql") { 62 $col .= " ,to_char(news_date, 'YYYY') AS YEAR "; //日付(年) 63 $col .= " ,to_char(news_date, 'MM') AS MONTH "; //日付(月) 64 $col .= " ,to_char(news_date, 'DD') AS DAY "; //日付(日) 65 $col .= " ,to_char(news_date, 'HH24') AS HOUR "; //日付(時間) 66 $col .= " ,to_char(news_date, 'MI') AS MINUTE "; //日付(分) 67 $col .= " ,to_char(news_date, 'SS') AS SECOND "; //日付(秒) 68 }else if (DB_TYPE == "mysql") { 69 $col .= " ,DATE_FORMAT(news_date, '%Y') AS YEAR "; //日付(年) 70 $col .= " ,DATE_FORMAT(news_date, '%m') AS MONTH "; //日付(月) 71 $col .= " ,DATE_FORMAT(news_date, '%d') AS DAY "; //日付(日) 72 $col .= " ,DATE_FORMAT(news_date, '%H') AS HOUR "; //日付(時間) 73 $col .= " ,DATE_FORMAT(news_date, '%i') AS MINUTE "; //日付(分) 74 $col .= " ,DATE_FORMAT(news_date, '%s') AS SECOND "; //日付(秒) 75 } 76 $col .= " ,news_url "; //新着情報URL 77 $col .= " ,news_select "; //新着情報の区分(1:URL、2:本文) 78 $col .= " ,(SELECT shop_name FROM dtb_baseinfo limit 1) AS shop_name "; //店名 79 $col .= " ,(SELECT email04 FROM dtb_baseinfo limit 1) AS email "; //代表Emailアドレス 80 $from = "dtb_news"; 81 $where = "del_flg = '0'"; 82 $order = "rank DESC"; 83 $objQuery->setorder($order); 84 $arrNews = $objQuery->select($col,$from,$where); 85 return $arrNews; 86 } 87 15 $objPage = new LC_Page_Rss_Ex(); 16 $objPage->init(); 17 $objPage->process(); 18 register_shutdown_function(array($objPage, "destroy")); 88 19 ?>
Note: See TracChangeset
for help on using the changeset viewer.