Changeset 18432 for branches/version-2/data/class/helper/SC_Helper_DB.php
- Timestamp:
- 2009/12/07 15:08:06 (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2/data/class/helper/SC_Helper_DB.php
r18177 r18432 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 } … … 1230 1231 1231 1232 // 自身のランクを取得する 1232 $rank = $objQuery->get($tableName, "rank", "$keyIdColumn = ? AND " . $where, array($keyId)); 1233 if($where != "") { 1234 $getWhere = "$keyIdColumn = ? AND " . $where; 1235 } else { 1236 $getWhere = "$keyIdColumn = ?"; 1237 } 1238 $rank = $objQuery->get($tableName, "rank", $getWhere, array($keyId)); 1233 1239 1234 1240 $max = $objQuery->max($tableName, "rank", $where);
Note: See TracChangeset
for help on using the changeset viewer.