Changeset 6529 for temp/trunk

Timestamp:

2006/10/24 16:16:01 (20 years ago)

Author:

kakinaka

Message:

* empty log message *

Location:

temp/trunk

Files:

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

temp/trunk/html/rss/product.php

@@ -27 +27 @@
 if($product_id != ""){
     //¾¦Éʾܺ٤ò¼èÆÀ
-    $arrProduct = lfGetProductsDetail($objQuery, $product_id);
+    $arrProductTmp = lfGetProductsDetail($objQuery, $product_id);
+    
+    // ÃͤΥ»¥Ã¥È¤·Ä¾¤·
+    foreach($arrProductTmp as $key => $val){
+        
+        switch ($key){
+            case "main_list_image":
+            case "main_image":
+            case "main_large_image":
+                $arrProductTmp[$key] = IMAGE_SAVE_URL . $arrProductTmp[$key];
+                break;
+        }
+    }
+    
 }else{
     //¾¦ÉÊ°ìÍ÷¤ò¼èÆÀ
@@ -48 +61 @@
 //XML¥Æ¥­¥¹¥È(¤³¤ì¤¬¤Ê¤¤¤ÈÀµ¾ï¤ËRSS¤È¤·¤Æǧ¼±¤·¤Æ¤¯¤ì¤Ê¤¤¥Ä¡¼¥ë¤¬¤¢¤ë¤¿¤á)
 header("Content-type: application/xml");
+DETAIL_P_HTML;
 
 //²èÌÌɽ¼¨
@@ -62 +76 @@
 function lfGetProductsDetail($objQuery, $product_id){
     $sql = "";
-    $sql .= "SELECT 
-                prod.product_id
-                ,prod.name AS product_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
-                ,cls.classcategory_id1
-                ,cls.classcategory_id2
-                ,(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";
+    $sql .= "SELECT ";
+    $sql .= "   prod.product_id ";
+    $sql .= "   ,prod.name AS product_name ";
+    $sql .= "   ,prod.category_id ";
+    $sql .= "   ,prod.point_rate ";
+    $sql .= "   ,prod.comment3 ";
+    $sql .= "   ,prod.main_list_comment ";
+    $sql .= "   ,prod.main_list_image ";
+    $sql .= "   ,prod.main_comment ";
+    $sql .= "   ,prod.main_image ";
+    $sql .= "   ,prod.main_large_image ";
+    $sql .= "   ,cls.price01 ";
+    $sql .= "   ,cls.price02 ";
+    $sql .= "   ,cls.classcategory_id1 ";
+    $sql .= "   ,cls.classcategory_id2 ";
+    $sql .= "   ,(SELECT name FROM dtb_classcategory AS clscat WHERE clscat.classcategory_id = cls.classcategory_id1) AS classcategory_name1 ";
+    $sql .= "   ,(SELECT name FROM dtb_classcategory AS clscat WHERE clscat.classcategory_id = cls.classcategory_id2) AS classcategory_name2 ";
+    $sql .= "   ,(SELECT category_name FROM dtb_category AS cat WHERE cat.category_id = prod.category_id) AS category_name";
     $sql .= " FROM dtb_products AS prod, dtb_products_class AS cls";
     $sql .= " WHERE prod.product_id = cls.product_id AND prod.del_flg = 0 AND prod.status = 1";