Changeset 18252 for branches/comu-ver2/data/class/util/SC_Utils.php
- Timestamp:
- 2009/08/04 12:47:34 (17 years ago)
- File:
-
- 1 edited
-
branches/comu-ver2/data/class/util/SC_Utils.php (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
branches/comu-ver2/data/class/util/SC_Utils.php
r18234 r18252 942 942 } 943 943 944 // カテゴリ別おすすめ商品の取得945 function sfGetBestProducts( $conn, $category_id = 0){946 $sql = '';947 // 既に登録されている内容を取得する948 $sql .= "SELECT name, main_image, main_list_image, price01_min, price01_max, price02_min, price02_max, point_rate,949 A.product_id, A.comment FROM dtb_best_products as A LEFT JOIN vw_products_allclass AS allcls950 USING (product_id) WHERE A.category_id = ? AND A.del_flg = 0 AND allcls.del_flg = 0 AND allcls.status = 1";951 952 // 在庫無し商品の非表示953 if (NOSTOCK_HIDDEN === true) {954 $sql .= ' AND (allcls.stock_max >= 1 OR allcls.stock_unlimited_max = 1)';955 }956 957 $sql .= " ORDER BY A.rank";958 $arrItems = $conn->getAll($sql, array($category_id));959 960 return $arrItems;961 }962 963 944 // 特殊制御文字の手動エスケープ 964 945 function sfManualEscape($data) {
Note: See TracChangeset
for help on using the changeset viewer.
