Changeset 5259 for temp/trunk/html

Timestamp:

2006/09/20 14:45:58 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk/html

Files:

• admin/products/index_csv.php (modified) (1 diff)
• frontparts/bloc/best5.php (modified) (1 diff)
• products/detail.php (modified) (1 diff)
• products/list.php (modified) (1 diff)

temp/trunk/html/admin/products/index_csv.php

@@ -27 +27 @@
     global $arrPRODUCTS_CVSCOL;
 
-    $from = "vw_product_class";
+    $from = "vw_product_class AS prdcls";
     $cols = sfGetCommaList($arrOutputCols);
     

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

@@ -31 +31 @@
     
     $arrBestProducts = $objQuery->select($col, $from, $where);
-    $objQuery->getlastquery();
     return $arrBestProducts;
 }

temp/trunk/html/products/detail.php

@@ -140 +140 @@
 $objQuery = new SC_Query();
 // DB¤«¤é¾¦ÉʾðÊó¤ò¼èÆÀ¤¹¤ë¡£
-$arrRet = $objQuery->select("*", "vw_products_allclass_detail", "product_id = ?", array($tmp_id));
+$arrRet = $objQuery->select("*", "vw_products_allclass_detail AS alldtl", "product_id = ?", array($tmp_id));
 $objPage->arrProduct = $arrRet[0];
 

temp/trunk/html/products/list.php

@@ -352 +352 @@
         $objQuery = new SC_Query();
         $col = "product_class_id, classcategory_id1, classcategory_id2, class_id1, class_id2, stock, stock_unlimited";
-        $table = "vw_product_class";
+        $table = "vw_product_class AS prdcls";
         $where = "product_id = ?";
         $objQuery->setorder("rank1 DESC, rank2 DESC");