Changeset 16599


Ignore:
Timestamp:
2007/10/29 20:41:11 (14 years ago)
Author:
nanasess
Message:

商品並べ替えのデグレ修正

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/feature-module-update/data/class/pages/admin/products/LC_Page_Admin_Products_ProductRank.php

    r16598 r16599  
    117117    function lfGetProduct($category_id) { 
    118118        $objQuery = new SC_Query(); 
    119         $col = "product_id, name, main_list_image, rank"; 
    120         $table = "vw_products_allclass AS allcls"; 
    121         $where = "del_flg = 0 AND category_id = ?"; 
     119        $col = "product_id, name, main_list_image, T2.rank, product_code"; 
     120        $table = "vw_products_nonclass AS noncls " 
     121            . " LEFT JOIN dtb_product_categories AS T2 USING (product_id)"; 
     122        $where = "del_flg = 0 AND T2.category_id = ?"; 
    122123 
    123124        // 行数の取得 
Note: See TracChangeset for help on using the changeset viewer.