- Timestamp:
- 2014/04/29 17:33:46 (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_13-dev/data/class/pages/products/LC_Page_Products_List.php
r23256 r23378 213 213 public function lfGetProductsList($searchCondition, $disp_number, $startno, &$objProduct) 214 214 { 215 $objQuery =& SC_Query_Ex::getSingletonInstance(); 216 215 217 $arrOrderVal = array(); 216 218 217 $objQuery =& SC_Query_Ex::getSingletonInstance();218 219 // 表示順序 219 220 switch ($this->orderby) { … … 235 236 $dtb_product_categories = 'dtb_product_categories'; 236 237 } 237 $order = <<< __EOS__ 238 ( 239 SELECT 240 T3.rank * 2147483648 + T2.rank 241 FROM 242 $dtb_product_categories T2 243 JOIN dtb_category T3 244 ON T2.category_id = T3.category_id 245 WHERE T2.product_id = alldtl.product_id 246 ORDER BY T3.rank DESC, T2.rank DESC 247 LIMIT 1 248 ) DESC 249 ,product_id DESC 250 __EOS__; 251 $objQuery->setOrder($order); 238 $col = 'T3.rank * 2147483648 + T2.rank'; 239 $from = "$dtb_product_categories T2 JOIN dtb_category T3 ON T2.category_id = T3.category_id"; 240 $where = 'T2.product_id = alldtl.product_id'; 241 $objQuery->setOrder('T3.rank DESC, T2.rank DESC'); 242 $objQuery->setLimit(1); 243 $sub_sql = $objQuery->getSqlWithLimitOffset($col, $from, $where); 244 245 $objQuery->setOrder("($sub_sql) DESC ,product_id DESC"); 252 246 break; 253 247 }
Note: See TracChangeset
for help on using the changeset viewer.