1 | <?php |
---|
2 | /* |
---|
3 | * Copyright(c) 2000-2007 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(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 | * °ú¿ô£±:$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 | |
---|
88 | ?> |
---|