Changeset 18401

Timestamp:

2009/11/29 13:46:46 (13 years ago)

Author:

Seasoft

Message:

非公開の商品はリンクを外す

File:

• branches/comu-ver2/data/class/pages/mypage/LC_Page_Mypage_History.php (modified) (1 diff)

branches/comu-ver2/data/class/pages/mypage/LC_Page_Mypage_History.php

@@ -223 +223 @@
         $objQuery = new SC_Query();
         $col = "product_id, product_code, product_name, classcategory_name1, classcategory_name2, price, quantity, point_rate";
-        $col .= ",CASE WHEN EXISTS(SELECT * FROM dtb_products WHERE product_id = dtb_order_detail.product_id AND del_flg = 0) THEN '1' ELSE '0' END AS enable";
+        $col .= ",CASE WHEN EXISTS(SELECT * FROM dtb_products WHERE product_id = dtb_order_detail.product_id AND del_flg = 0 AND status = 1) THEN '1' ELSE '0' END AS enable";
         $where = "order_id = ?";
         $objQuery->setorder("classcategory_id1, classcategory_id2");