Changeset 6692 for temp

Timestamp:

2006/10/25 17:29:14 (20 years ago)

Author:

kakinaka

Message:

* empty log message *

File:

• temp/trunk/html/rss/product.php (modified) (5 diffs)

temp/trunk/html/rss/product.php

@@ -35 +35 @@
     // ÃͤΥ»¥Ã¥È¤·Ä¾¤·
     foreach($arrProduct as $key => $val){
-        
         //¾¦ÉʲÁ³Ê¤òÀǹþ¤ß¤ËÊÔ½¸
         $arrProduct[$key]["price02"] = sfPreTax($arrProduct[$key]["price02"], $arrSiteInfo["tax"], $arrSiteInfo["tax_rule"]);
@@ -50 +49 @@
         $arrProduct[$key]["point"] = sfPrePoint($arrProduct[$key]["price02"], $arrProduct[$key]["point_rate"], POINT_RULE, $arrProduct[$key]["product_id"]);
     }
-}elseif($mode == "list"){
+}
+if($mode == "list"){
     //¾¦ÉÊ°ìÍ÷¤ò¼èÆÀ
     $arrProduct = $objQuery->getall("SELECT product_id, name AS product_name FROM dtb_products");
+}else{
+    $arrProduct = lfGetProductsAllclass($objQuery);
+    
+    // ÃͤΥ»¥Ã¥È¤·Ä¾¤·
+    foreach($arrProduct as $key => $val){
+        //¾¦ÉʲÁ³Ê¤òÀǹþ¤ß¤ËÊÔ½¸
+        $arrProduct[$key]["price01_max"] = sfPreTax($arrProduct[$key]["price01_max"], $arrSiteInfo["tax"], $arrSiteInfo["tax_rule"]);
+        $arrProduct[$key]["price01_min"] = sfPreTax($arrProduct[$key]["price01_min"], $arrSiteInfo["tax"], $arrSiteInfo["tax_rule"]);
+        $arrProduct[$key]["price02_max"] = sfPreTax($arrProduct[$key]["price02_max"], $arrSiteInfo["tax"], $arrSiteInfo["tax_rule"]);
+        $arrProduct[$key]["price02_min"] = sfPreTax($arrProduct[$key]["price02_min"], $arrSiteInfo["tax"], $arrSiteInfo["tax_rule"]);
+        
+        // ²èÁü¥Õ¥¡¥¤¥ë¤ÎURL¥»¥Ã¥È
+        (file_exists(IMAGE_SAVE_DIR . $arrProduct[$key]["main_list_image"])) ? $dir = IMAGE_SAVE_URL_RSS : $dir = IMAGE_TEMP_URL_RSS;
+        $arrProduct[$key]["main_list_image"] = $dir . $arrProduct[$key]["main_list_image"];
+        (file_exists(IMAGE_SAVE_DIR . $arrProduct[$key]["main_image"])) ? $dir = IMAGE_SAVE_URL_RSS : $dir = IMAGE_TEMP_URL_RSS;
+        $arrProduct[$key]["main_image"] = $dir . $arrProduct[$key]["main_image"];
+        (file_exists(IMAGE_SAVE_DIR . $arrProduct[$key]["main_large_image"])) ? $dir = IMAGE_SAVE_URL_RSS : $dir = IMAGE_TEMP_URL_RSS;
+        $arrProduct[$key]["main_large_image"] = $dir . $arrProduct[$key]["main_large_image"];
+        
+        // ¥Ý¥¤¥ó¥È·×»»
+        $arrProduct[$key]["point_max"] = sfPrePoint($arrProduct[$key]["price02_max"], $arrProduct[$key]["point_rate"], POINT_RULE, $arrProduct[$key]["product_id"]);
+        $arrProduct[$key]["point_min"] = sfPrePoint($arrProduct[$key]["price02_min"], $arrProduct[$key]["point_rate"], POINT_RULE, $arrProduct[$key]["product_id"]);
+    }
 }
 
@@ -85 +108 @@
  * Ìá¤êÃÍ:$arrProduct   ¼èÆÀ·ë²Ì¤òÇÛÎó¤ÇÊÖ¤¹
  **************************************************************************************************************/
-function lfGetProductsDetail($objQuery, $product_id = "all"){
+function lfGetProductsDetail($objQuery, $product_id = ""){
     $sql = "";
     $sql .= "SELECT ";
@@ -109 +132 @@
     $sql .= " WHERE prod.product_id = cls.product_id AND prod.del_flg = 0 AND prod.status = 1";
     
-    if($product_id != "all"){
+    if($product_id != "all" and $product_id != ""){
         $sql .= " AND prod.product_id = ?";
         $arrval = array($product_id);
@@ -118 +141 @@
 }
 
+/**************************************************************************************************************
+ * ´Ø¿ô̾:lfGetProductsAllclass
+ * ÀâÌÀ¡¡:¾¦ÉʾðÊó¤ò¼èÆÀ¤¹¤ë(vw_products_allclass»ÈÍÑ)
+ * °ú¿ô£±:$objQuery     DBÁàºî¥¯¥é¥¹
+ * Ìá¤êÃÍ:$arrProduct   ¼èÆÀ·ë²Ì¤òÇÛÎó¤ÇÊÖ¤¹
+ **************************************************************************************************************/
+function lfGetProductsAllclass($objQuery){
+    $sql = "";
+    $sql .= "SELECT  
+                product_id
+                ,name as product_name
+                ,category_id
+                ,point_rate
+                ,comment3
+                ,main_list_comment
+                ,main_image
+                ,main_list_image
+                ,product_code_min
+                ,product_code_max
+                ,price01_min
+                ,price01_max
+                ,price02_min
+                ,price02_max
+                ,(SELECT category_name FROM dtb_category AS cat WHERE cat.category_id = allcls.category_id) AS category_name
+            FROM  vw_products_allclass as allcls
+            WHERE allcls.del_flg = 0 AND allcls.status = 1";
+    $sql .= " ORDER BY allcls.product_id";
+    $arrProduct = $objQuery->getall($sql);
+    return $arrProduct;
+}
+
+
 ?>