Changeset 18402

Timestamp:

2009/12/01 12:58:00 (13 years ago)

Author:

kajiwara

Message:

#454 非公開商品を購入できる不具合を修正

Location:

branches/version-2_4/data/class

Files:

• helper/SC_Helper_DB.php (modified) (2 diffs)
• pages/shopping/LC_Page_Shopping_Confirm.php (modified) (1 diff)

branches/version-2_4/data/class/helper/SC_Helper_DB.php

@@ -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";
         $table = "vw_product_class AS prdcls";
-        $where = "product_id = ? AND classcategory_id1 = ? AND classcategory_id2 = ?";
+        $where = "product_id = ? AND classcategory_id1 = ? AND classcategory_id2 = ? AND status = 1";
         $objQuery->setorder("rank1 DESC, rank2 DESC");
         $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']);
                 $cnt++;
-            } else {
-                // DBに商品が見つからない場合はカート商品の削除
+            } else { // DBに商品が見つからない場合はカート商品の削除
+                $objPage->tpl_message .= "※申し訳ございませんが、ご購入の直前で売り切れた商品があります。該当商品をカートから削除いたしました。\n";
+                // カート商品の削除
                 $objCartSess->delProductKey('id', $arrCart[$i]['id']);
             }

branches/version-2_4/data/class/pages/shopping/LC_Page_Shopping_Confirm.php

@@ -84 +84 @@
         // カート集計処理
         $objDb->sfTotalCart($this, $objCartSess, $arrInfo);
+        if (strlen($this->tpl_message) >= 1) {
+            SC_Utils_Ex::sfDispSiteError(SOLD_OUT, '', true);
+        }
         // 一時受注テーブルの読込
         $arrData = $objDb->sfGetOrderTemp($uniqid);