Changeset 18402 for branches/version-2_4/data/class/helper/SC_Helper_DB.php
- Timestamp:
- 2009/12/01 12:58:00 (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_4/data/class/helper/SC_Helper_DB.php
r18115 r18402 257 257 $col = "product_id, deliv_fee, name, product_code, main_list_image, main_image, price01, price02, point_rate, product_class_id, classcategory_id1, classcategory_id2, class_id1, class_id2, stock, stock_unlimited, sale_limit, sale_unlimited"; 258 258 $table = "vw_product_class AS prdcls"; 259 $where = "product_id = ? AND classcategory_id1 = ? AND classcategory_id2 = ? ";259 $where = "product_id = ? AND classcategory_id1 = ? AND classcategory_id2 = ? AND status = 1"; 260 260 $objQuery->setorder("rank1 DESC, rank2 DESC"); 261 261 $arrRet = $objQuery->select($col, $table, $where, array($product_id, $classcategory_id1, $classcategory_id2)); … … 380 380 $objPage->tpl_total_deliv_fee+= ($arrData['deliv_fee'] * $arrCart[$i]['quantity']); 381 381 $cnt++; 382 } else { 383 // DBに商品が見つからない場合はカート商品の削除 382 } else { // DBに商品が見つからない場合はカート商品の削除 383 $objPage->tpl_message .= "※申し訳ございませんが、ご購入の直前で売り切れた商品があります。該当商品をカートから削除いたしました。\n"; 384 // カート商品の削除 384 385 $objCartSess->delProductKey('id', $arrCart[$i]['id']); 385 386 }
Note: See TracChangeset
for help on using the changeset viewer.