Changeset 5255 for temp/trunk/html

Timestamp:

2006/09/20 14:36:48 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk/html

Files:

• frontparts/bloc/best5.php (modified) (1 diff)
• products/detail.php (modified) (2 diffs)
• products/list.php (modified) (2 diffs)

temp/trunk/html/frontparts/bloc/best5.php

@@ -26 +26 @@
     
     $col = "A.*, name, price02_min, price01_min, main_list_image ";
-    $from = "dtb_best_products AS A INNER JOIN vw_products_allclass using(product_id)";
+    $from = "dtb_best_products AS A INNER JOIN vw_products_allclass AS allcls using(product_id)";
     $where = "status = 1";
     $order = "rank";

temp/trunk/html/products/detail.php

@@ -343 +343 @@
     for($i = 0; $i < $max; $i++) {
         $where = "del_flg = 0 AND product_id = ? AND status = 1";
-        $arrProductInfo = $objQuery->select("main_list_image, price02_min, price02_max, price01_min, price01_max, name, point_rate", "vw_products_allclass", $where, array($arrRet[$i]['recommend_product_id'])); 
+        $arrProductInfo = $objQuery->select("main_list_image, price02_min, price02_max, price01_min, price01_max, name, point_rate", "vw_products_allclass  AS allcls", $where, array($arrRet[$i]['recommend_product_id'])); 
                 
         if(count($arrProductInfo) > 0) {
@@ -394 +394 @@
     //¸¡º÷¾ò·ï
     $col = "name, main_list_image, price01_min, price02_min, price01_max, price02_max, point_rate";
-    $from = "vw_products_allclass ";
+    $from = "vw_products_allclass AS allcls ";
     $where = "del_flg = 0 AND status = 1 AND (stock_max <> 0 OR stock_max IS NULL) AND product_id = ? ";
     $arrval[] = $tmp_id;

temp/trunk/html/products/list.php

@@ -198 +198 @@
             
     // ¹Ô¿ô¤Î¼èÆÀ
-    $linemax = $objQuery->count("vw_products_allclass", $where, $arrval);
+    $linemax = $objQuery->count("vw_products_allclass AS allcls", $where, $arrval);
     $objPage->tpl_linemax = $linemax;   // ²¿·ï¤¬³ºÅö¤·¤Þ¤·¤¿¡£É½¼¨ÍÑ
     
@@ -211 +211 @@
     $objQuery->setorder($order);
     // ¸¡º÷·ë²Ì¤Î¼èÆÀ
-    $objPage->arrProducts = $objQuery->select("*", "vw_products_allclass", $where, $arrval);
+    $objPage->arrProducts = $objQuery->select("*", "vw_products_allclass AS allcls", $where, $arrval);
     
     // µ¬³Ê̾°ìÍ÷