Changeset 20548


Ignore:
Timestamp:
2011/03/07 22:37:26 (11 years ago)
Author:
kotani
Message:

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

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_5-dev/data/class/pages/admin/products/LC_Page_Admin_Products_ProductRank.php

    r20541 r20548  
    120120        $objQuery =& SC_Query_Ex::getSingletonInstance(); 
    121121        $col = "product_id, name, main_list_image, product_code_min, product_code_max, status"; 
    122         $table = "vw_products_allclass AS allcls"; 
     122        $objProduct = new SC_Product(); 
     123        $table = $objProduct->alldtlSQL(); 
     124        $table.= " LEFT JOIN dtb_product_categories AS T5 USING(product_id)"; 
    123125        $where = "del_flg = 0 AND category_id = ?"; 
    124126 
     
    138140        $objQuery->setLimitOffset(SEARCH_PMAX, $startno); 
    139141 
    140         $objQuery->setOrder("product_rank DESC, product_id DESC"); 
     142        $objQuery->setOrder("rank DESC, product_id DESC"); 
    141143 
    142144        $arrRet = $objQuery->select($col, $table, $where, array($category_id)); 
Note: See TracChangeset for help on using the changeset viewer.