Changeset 6474 for temp

Timestamp:

2006/10/24 11:33:21 (20 years ago)

Author:

kakinaka

Message:

* empty log message *

Location:

temp/trunk

Files:

• data/Smarty/templates/rss/index.tpl (modified) (previous)
• html/rss/index.php (modified) (1 diff)
• html/rss/product.php (added)

temp/trunk/html/rss/index.php

@@ -80 +80 @@
     return $arrNews;
 }
-    
+
+/*
+ * ´Ø¿ô̾:lfGetProducts
+ * ÀâÌÀ¡¡:¾¦ÉʾðÊó¤ò¼èÆÀ¤¹¤ë
+ * °ú¿ô£±:$objQuery     DBÁàºî¥¯¥é¥¹
+ * Ìá¤êÃÍ:$arrNews      ¼èÆÀ·ë²Ì¤òÇÛÎó¤ÇÊÖ¤¹
+ */
+function lfGetProducts($objQuery, $product_id){
+    $col = "";
+    $col .= "     news_id ";                                //¿·Ãå¾ðÊóID
+    $col .= "     ,news_title ";                            //¿·Ãå¾ðÊ󥿥¤¥È¥ë
+    $col .= "     ,news_comment ";                          //¿·Ãå¾ðÊóËÜʸ
+    $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 .= "     ,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'";
+    $order = "rank DESC";
+    $objQuery->setorder($order);
+    $arrNews = $objQuery->select($col,$from,$where);
+    return $arrNews;
+}
+
 ?>