Changeset 20076 for branches/version-2_5-dev/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Best5.php
- Timestamp:
- 2011/02/03 18:40:05 (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Best5.php
r19903 r20076 81 81 } 82 82 83 //おすすめ商品検索 83 /** 84 * おすすめ商品検索. 85 * 86 * @return array $arrBestProducts 検索結果配列 87 */ 84 88 function lfGetRanking(){ 85 $objQuery = new SC_Query();89 $objQuery = SC_Query::getSingletonInstance(); 86 90 // FIXME SC_Product クラスを使用した実装 87 $col = "DISTINCT A.*, name, price02_min, price01_min, main_list_image ";88 $from = "dtb_best_products AS A INNER JOIN vw_products_allclass AS allcls using(product_id)";89 $where = "allcls.del_flg = 0 AND allcls.status = 1";91 $col = 'DISTINCT A.*, name, price02_min, price01_min, main_list_image '; 92 $from = 'dtb_best_products AS A INNER JOIN vw_products_allclass AS allcls using(product_id)'; 93 $where = 'allcls.del_flg = 0 AND allcls.status = 1'; 90 94 91 95 // 在庫無し商品の非表示 … … 94 98 } 95 99 96 $order = "rank";100 $order = 'rank'; 97 101 $objQuery->setOrder($order); 98 102 $objQuery->setLimit(RECOMMEND_NUM);
Note: See TracChangeset
for help on using the changeset viewer.