| 1 | <?php |
|---|
| 2 | /* |
|---|
| 3 | * Copyright(c) 2000-2006 LOCKON CO.,LTD. All Rights Reserved. |
|---|
| 4 | * |
|---|
| 5 | * http://www.lockon.co.jp/ |
|---|
| 6 | */ |
|---|
| 7 | |
|---|
| 8 | //¶¦ÄÌÉôÉʤÎÆɤ߹þ¤ß |
|---|
| 9 | require_once("../require.php"); |
|---|
| 10 | |
|---|
| 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 | } |
|---|
| 18 | |
|---|
| 19 | $objQuery = new SC_Query(); |
|---|
| 20 | $objPage = new LC_Page(); |
|---|
| 21 | $objView = new SC_SiteView(); |
|---|
| 22 | |
|---|
| 23 | //¿·Ãå¾ðÊó¤ò¼èÆÀ |
|---|
| 24 | $arrNews = lfGetNews($objQuery); |
|---|
| 25 | |
|---|
| 26 | //¥¥ã¥Ã¥·¥å¤·¤Ê¤¤(Ç°¤Î¤¿¤á) |
|---|
| 27 | header("Paragrama: no-cache"); |
|---|
| 28 | |
|---|
| 29 | //XML¥Æ¥¥¹¥È(¤³¤ì¤¬¤Ê¤¤¤ÈÀµ¾ï¤ËRSS¤È¤·¤Æǧ¼±¤·¤Æ¤¯¤ì¤Ê¤¤¥Ä¡¼¥ë¤¬¤¢¤ë¤¿¤á) |
|---|
| 30 | header("Content-type: application/xml"); |
|---|
| 31 | |
|---|
| 32 | //¿·Ãå¾ðÊó¤ò¥»¥Ã¥È |
|---|
| 33 | $objPage->arrNews = $arrNews; |
|---|
| 34 | |
|---|
| 35 | sfprintr($arrNews); |
|---|
| 36 | |
|---|
| 37 | //Ź̾¤ò¥»¥Ã¥È |
|---|
| 38 | $objPage->site_title = $arrNews[0]['shop_name']; |
|---|
| 39 | |
|---|
| 40 | //ÂåɽEmail¥¢¥É¥ì¥¹¤ò¥»¥Ã¥È |
|---|
| 41 | $objPage->email = $arrNews[0]['email']; |
|---|
| 42 | |
|---|
| 43 | //¥»¥Ã¥È¤·¤¿¥Ç¡¼¥¿¤ò¥Æ¥ó¥×¥ì¡¼¥È¥Õ¥¡¥¤¥ë¤Ë½ÐÎÏ |
|---|
| 44 | $objView->assignobj($objPage); |
|---|
| 45 | |
|---|
| 46 | //²èÌÌɽ¼¨ |
|---|
| 47 | $objView->display($objPage->tpl_mainpage, true); |
|---|
| 48 | |
|---|
| 49 | //--------------------------------------------------------------------------------------------------------------------- |
|---|
| 50 | /*************************************************************************************************************** |
|---|
| 51 | * ´Ø¿ô̾:lfGetNews |
|---|
| 52 | * ÀâÌÀ¡¡:¿·Ãå¾ðÊó¤ò¼èÆÀ¤¹¤ë |
|---|
| 53 | * °ú¿ô£±:$objQuery DBÁàºî¥¯¥é¥¹ |
|---|
| 54 | * Ìá¤êÃÍ:$arrNews ¼èÆÀ·ë²Ì¤òÇÛÎó¤ÇÊÖ¤¹ |
|---|
| 55 | ***************************************************************************************************************/ |
|---|
| 56 | function lfGetNews($objQuery){ |
|---|
| 57 | $col = ""; |
|---|
| 58 | $col .= " news_id "; //¿·Ãå¾ðÊóID |
|---|
| 59 | $col .= " ,news_title "; //¿·Ãå¾ðÊ󥿥¤¥È¥ë |
|---|
| 60 | $col .= " ,news_comment "; //¿·Ãå¾ðÊóËÜʸ |
|---|
| 61 | |
|---|
| 62 | if (DB_TYPE == "pgsql") { |
|---|
| 63 | $col .= " ,to_char(news_date, 'YYYY') AS YEAR "; //ÆüÉÕ(ǯ) |
|---|
| 64 | $col .= " ,to_char(news_date, 'MM') AS MONTH "; //ÆüÉÕ(·î) |
|---|
| 65 | $col .= " ,to_char(news_date, 'DD') AS DAY "; //ÆüÉÕ(Æü) |
|---|
| 66 | $col .= " ,to_char(news_date, 'HH24') AS HOUR "; //ÆüÉÕ(»þ´Ö) |
|---|
| 67 | $col .= " ,to_char(news_date, 'MI') AS MINUTE "; //ÆüÉÕ(ʬ) |
|---|
| 68 | $col .= " ,to_char(news_date, 'SS') AS SECOND "; //ÆüÉÕ(ÉÃ) |
|---|
| 69 | }else if (DB_TYPE == "mysql") { |
|---|
| 70 | $col .= " ,DATE_FORMAT(news_date, '%Y') AS YEAR "; //ÆüÉÕ(ǯ) |
|---|
| 71 | $col .= " ,DATE_FORMAT(news_date, '%m') AS MONTH "; //ÆüÉÕ(·î) |
|---|
| 72 | $col .= " ,DATE_FORMAT(news_date, '%d') AS DAY "; //ÆüÉÕ(Æü) |
|---|
| 73 | $col .= " ,DATE_FORMAT(news_date, '%H') AS HOUR "; //ÆüÉÕ(»þ´Ö) |
|---|
| 74 | $col .= " ,DATE_FORMAT(news_date, '%i') AS MINUTE "; //ÆüÉÕ(ʬ) |
|---|
| 75 | $col .= " ,DATE_FORMAT(news_date, '%s') AS SECOND "; //ÆüÉÕ(ÉÃ) |
|---|
| 76 | } |
|---|
| 77 | $col .= " ,news_url "; //¿·Ãå¾ðÊóURL |
|---|
| 78 | $col .= " ,news_select "; //¿·Ãå¾ðÊó¤Î¶èʬ(1:URL¡¢2:ËÜʸ) |
|---|
| 79 | $col .= " ,(SELECT shop_name FROM dtb_baseinfo limit 1) AS shop_name "; //Ź̾ |
|---|
| 80 | $col .= " ,(SELECT email04 FROM dtb_baseinfo limit 1) AS email "; //ÂåɽEmail¥¢¥É¥ì¥¹ |
|---|
| 81 | $from = "dtb_news"; |
|---|
| 82 | $where = "del_flg = '0'"; |
|---|
| 83 | $order = "rank DESC"; |
|---|
| 84 | $objQuery->setorder($order); |
|---|
| 85 | $arrNews = $objQuery->select($col,$from,$where); |
|---|
| 86 | return $arrNews; |
|---|
| 87 | } |
|---|
| 88 | |
|---|
| 89 | ?> |
|---|
