Changeset 17509 for branches/comu-ver2/data/class/util/SC_Utils.php
- Timestamp:
- 2008/08/08 00:00:00 (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/comu-ver2/data/class/util/SC_Utils.php
r17489 r17509 919 919 // カテゴリ別おすすめ商品の取得 920 920 function sfGetBestProducts( $conn, $category_id = 0){ 921 $sql = ''; 921 922 // 既に登録されている内容を取得する 922 $sql = "SELECT name, main_image, main_list_image, price01_min, price01_max, price02_min, price02_max, point_rate,923 $sql .= "SELECT name, main_image, main_list_image, price01_min, price01_max, price02_min, price02_max, point_rate, 923 924 A.product_id, A.comment FROM dtb_best_products as A LEFT JOIN vw_products_allclass AS allcls 924 USING (product_id) WHERE A.category_id = ? AND A.del_flg = 0 AND status = 1 ORDER BY A.rank"; 925 USING (product_id) WHERE A.category_id = ? AND A.del_flg = 0 AND allcls.del_flg = 0 AND allcls.status = 1"; 926 927 // 在庫無し商品の非表示 928 if (NOSTOCK_HIDDEN === true) { 929 $sql .= ' AND (allcls.stock_max >= 1 OR allcls.stock_unlimited_max = 1)'; 930 } 931 932 $sql .= " ORDER BY A.rank"; 925 933 $arrItems = $conn->getAll($sql, array($category_id)); 926 934
Note: See TracChangeset
for help on using the changeset viewer.