Changeset 6478 for temp

Timestamp:

2006/10/24 13:08:12 (20 years ago)

Author:

kakinaka

Message:

* empty log message *

Location:

temp/trunk

Files:

• data/Smarty/templates/rss/product.tpl (modified) (previous)
• html/rss/index.php (modified) (2 diffs)
• html/rss/product.php (modified) (5 diffs)

temp/trunk/html/rss/index.php

@@ -39 +39 @@
 $objPage->email = $arrNews[0]['email'];
 
-//DESCRIPTION¤ò¥»¥Ã¥È
-$objPage->description = $objPage->description;
-
-//XML¥Õ¥¡¥¤¥ë¤Î¥¨¥ó¥³¡¼¥É¤ò¥»¥Ã¥È
-$objPage->encode = $objPage->encode;
-
 //¥»¥Ã¥È¤·¤¿¥Ç¡¼¥¿¤ò¥Æ¥ó¥×¥ì¡¼¥È¥Õ¥¡¥¤¥ë¤Ë½ÐÎÏ
 $objView->assignobj($objPage);
@@ -51 +45 @@
 $objView->display($objPage->tpl_mainpage, true);
 
-//******************************************************************************************/
-/*
+//---------------------------------------------------------------------------------------------------------------------
+/***************************************************************************************************************
  * ´Ø¿ô̾:lfGetNews
  * ÀâÌÀ¡¡:¿·Ãå¾ðÊó¤ò¼èÆÀ¤¹¤ë
  * °ú¿ô£±:$objQuery     DBÁàºî¥¯¥é¥¹
  * Ìá¤êÃÍ:$arrNews      ¼èÆÀ·ë²Ì¤òÇÛÎó¤ÇÊÖ¤¹
- */
+ ***************************************************************************************************************/
 function lfGetNews($objQuery){
     $col = "";

temp/trunk/html/rss/product.php

@@ -11 +11 @@
 class LC_Page{
     function LC_Page(){
-        $this->tpl_mainpage = "rss/index.tpl";
+        $this->tpl_mainpage = "rss/product.tpl";
         $this->encode = "UTF-8";
         $this->description = "¿·Ãå¾ðÊó";
@@ -20 +20 @@
 $objPage = new LC_Page();
 $objView = new SC_SiteView();
+$objSiteInfo = new SC_SiteInfo();
+
+sfprintr($objSiteInfo);
+exit();
 
 //¿·Ãå¾ðÊó¤ò¼èÆÀ
-$arrNews = lfGetNews($objQuery);
+$arrProduct = lfGetProductsDetail($objQuery, 1);
 
 //¥­¥ã¥Ã¥·¥å¤·¤Ê¤¤(Ç°¤Î¤¿¤á)
@@ -30 +34 @@
 header("Content-type: application/xml");
 
-//¿·Ãå¾ðÊó¤ò¥»¥Ã¥È
-$objPage->arrNews = $arrNews;
+//¾¦ÉʾðÊó¤ò¥»¥Ã¥È
+$objPage->$arrProduct = $arrProduct;
 
 //Ź̾¤ò¥»¥Ã¥È
-$objPage->site_title = $arrNews[0]['shop_name'];
+$objPage->site_title = $arrProduct[0]['shop_name'];
 
 //ÂåɽEmail¥¢¥É¥ì¥¹¤ò¥»¥Ã¥È
-$objPage->email = $arrNews[0]['email'];
-
-//DESCRIPTION¤ò¥»¥Ã¥È
-$objPage->description = $objPage->description;
-
-//XML¥Õ¥¡¥¤¥ë¤Î¥¨¥ó¥³¡¼¥É¤ò¥»¥Ã¥È
-$objPage->encode = $objPage->encode;
+$objPage->email = $arrProduct[0]['email'];
 
 //¥»¥Ã¥È¤·¤¿¥Ç¡¼¥¿¤ò¥Æ¥ó¥×¥ì¡¼¥È¥Õ¥¡¥¤¥ë¤Ë½ÐÎÏ
@@ -51 +49 @@
 $objView->display($objPage->tpl_mainpage, true);
 
-//******************************************************************************************/
-/*
+//---------------------------------------------------------------------------------------------------------------------
+/**************************************************************************************************************
  * ´Ø¿ô̾:lfGetProducts
  * ÀâÌÀ¡¡:¾¦ÉʾðÊó¤ò¼èÆÀ¤¹¤ë
  * °ú¿ô£±:$objQuery     DBÁàºî¥¯¥é¥¹
- * Ìá¤êÃÍ:$arrProduct       ¼èÆÀ·ë²Ì¤òÇÛÎó¤ÇÊÖ¤¹
- */
-function lfGetProducts($objQuery, $product_id){
+ * °ú¿ô£²:$product_id   ¾¦ÉÊID
+ * Ìá¤êÃÍ:$arrProduct   ¼èÆÀ·ë²Ì¤òÇÛÎó¤ÇÊÖ¤¹
+ ***************************************************************************************************************/
+function lfGetProductsDetail($objQuery, $product_id){
+    $sql = "";
+    $sql .= "SELECT 
+                prod.product_id
+                ,prod.name
+                ,prod.category_id
+                ,prod.point_rate
+                ,prod.comment3
+                ,prod.main_list_comment
+                ,prod.main_list_image
+                ,prod.main_comment
+                ,prod.main_image
+                ,prod.main_large_image
+                ,cls.price01
+                ,cls.price02
+                ,(SELECT name FROM dtb_classcategory AS clscat WHERE clscat.classcategory_id = cls.classcategory_id1) AS classcategory_name1
+                ,(SELECT name FROM dtb_classcategory AS clscat WHERE clscat.classcategory_id = cls.classcategory_id2) AS classcategory_name2
+                ,(SELECT category_name FROM dtb_category AS cat WHERE cat.category_id = prod.category_id) AS category_name
+            FROM dtb_products AS prod, dtb_products_class AS cls
+            WHERE prod.product_id = cls.product_id AND prod.del_flg = 0 AND prod.status = 1 AND prod.product_id = ?
+            ORDER BY prod.product_id, cls.classcategory_id1, cls.classcategory_id2
+            ";
+    $arrProduct = $objQuery->getall($sql, array($product_id));
+    return $arrProduct;
+}
+
+/***************************************************************************************************************
+ * ´Ø¿ô̾:lfGetNews
+ * ÀâÌÀ¡¡:¿·Ãå¾ðÊó¤ò¼èÆÀ¤¹¤ë
+ * °ú¿ô£±:$objQuery     DBÁàºî¥¯¥é¥¹
+ * Ìá¤êÃÍ:$arrNews      ¼èÆÀ·ë²Ì¤òÇÛÎó¤ÇÊÖ¤¹
+ ***************************************************************************************************************/
+function lfGetShopData($objQuery){
     $col = "";
     $col .= "     news_id ";                                //¿·Ãå¾ðÊóID
@@ -73 +104 @@
     $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_produts";
+    $from = "dtb_news";
     $where = "del_flg = '0'";
     $order = "rank DESC";
     $objQuery->setorder($order);
-    $arrProduct = $objQuery->select($col,$from,$where);
-    return $arrProduct;
+    $arrNews = $objQuery->select($col,$from,$where);
+    return $arrNews;
 }
 
+
 ?>