Changeset 18401


Ignore:
Timestamp:
2009/11/29 13:46:46 (11 years ago)
Author:
Seasoft
Message:

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

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/comu-ver2/data/class/pages/mypage/LC_Page_Mypage_History.php

    r18399 r18401  
    223223        $objQuery = new SC_Query(); 
    224224        $col = "product_id, product_code, product_name, classcategory_name1, classcategory_name2, price, quantity, point_rate"; 
    225         $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"; 
     225        $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"; 
    226226        $where = "order_id = ?"; 
    227227        $objQuery->setorder("classcategory_id1, classcategory_id2"); 
Note: See TracChangeset for help on using the changeset viewer.