Changeset 18758 for trunk/data/class/pages/rss/LC_Page_Rss.php
- Timestamp:
- 2010/07/20 13:25:33 (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/data/class/pages/rss/LC_Page_Rss.php
r17650 r18758 3 3 * This file is part of EC-CUBE 4 4 * 5 * Copyright(c) 2000-20 07LOCKON CO.,LTD. All Rights Reserved.5 * Copyright(c) 2000-2010 LOCKON CO.,LTD. All Rights Reserved. 6 6 * 7 7 * http://www.lockon.co.jp/ … … 69 69 //新着情報をセット 70 70 $this->arrNews = $arrNews; 71 $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']); 71 // XXX 2.4.3 以下の互換性確保 72 $this->timestamp = $arrNews[0]['news_date']; 72 73 73 74 //店名をセット … … 104 105 $col .= " ,news_title "; //新着情報タイトル 105 106 $col .= " ,news_comment "; //新着情報本文 106 107 if (DB_TYPE == "pgsql") { 108 $col .= " ,to_char(news_date, 'YYYY') AS YEAR "; //日付(年) 109 $col .= " ,to_char(news_date, 'MM') AS MONTH "; //日付(月) 110 $col .= " ,to_char(news_date, 'DD') AS DAY "; //日付(日) 111 $col .= " ,to_char(news_date, 'HH24') AS HOUR "; //日付(時間) 112 $col .= " ,to_char(news_date, 'MI') AS MINUTE "; //日付(分) 113 $col .= " ,to_char(news_date, 'SS') AS SECOND "; //日付(秒) 114 }else if (DB_TYPE == "mysql") { 115 $col .= " ,DATE_FORMAT(news_date, '%Y') AS YEAR "; //日付(年) 116 $col .= " ,DATE_FORMAT(news_date, '%m') AS MONTH "; //日付(月) 117 $col .= " ,DATE_FORMAT(news_date, '%d') AS DAY "; //日付(日) 118 $col .= " ,DATE_FORMAT(news_date, '%H') AS HOUR "; //日付(時間) 119 $col .= " ,DATE_FORMAT(news_date, '%i') AS MINUTE "; //日付(分) 120 $col .= " ,DATE_FORMAT(news_date, '%s') AS SECOND "; //日付(秒) 121 } 107 $col .= " ,news_date "; //新着情報日時 122 108 $col .= " ,news_url "; //新着情報URL 123 109 $col .= " ,news_select "; //新着情報の区分(1:URL、2:本文) … … 127 113 $where = "del_flg = '0'"; 128 114 $order = "rank DESC"; 129 $objQuery->set order($order);115 $objQuery->setOrder($order); 130 116 $arrNews = $objQuery->select($col,$from,$where); 117 118 // RSS用に変換 119 foreach (array_keys($arrNews) as $key) { 120 $row =& $arrNews[$key]; 121 // 日付 122 $row['news_date'] = date("r", strtotime($row['news_date'])); 123 } 124 131 125 return $arrNews; 132 126 }
Note: See TracChangeset
for help on using the changeset viewer.