Changeset 20548

Timestamp:

2011/03/07 22:37:26 (13 years ago)

Author:

kotani

Message:

#1060 ([管理画面]商品管理（商品並び替え）：vw_products_allclassを使っているためDBエラー)

File:

• branches/version-2_5-dev/data/class/pages/admin/products/LC_Page_Admin_Products_ProductRank.php (modified) (2 diffs)

branches/version-2_5-dev/data/class/pages/admin/products/LC_Page_Admin_Products_ProductRank.php

@@ -120 +120 @@
         $objQuery =& SC_Query_Ex::getSingletonInstance();
         $col = "product_id, name, main_list_image, product_code_min, product_code_max, status";
-        $table = "vw_products_allclass AS allcls";
+        $objProduct = new SC_Product();
+        $table = $objProduct->alldtlSQL();
+        $table.= " LEFT JOIN dtb_product_categories AS T5 USING(product_id)";
         $where = "del_flg = 0 AND category_id = ?";
 
@@ -138 +140 @@
         $objQuery->setLimitOffset(SEARCH_PMAX, $startno);
 
-        $objQuery->setOrder("product_rank DESC, product_id DESC");
+        $objQuery->setOrder("rank DESC, product_id DESC");
 
         $arrRet = $objQuery->select($col, $table, $where, array($category_id));