Ignore:
Timestamp:
2010/09/27 11:49:29 (14 years ago)
Author:
eccuore
Message:

#792(ダウンロード販売機能) vw_download_class削除、product_class_id対応(規格構成変更と並行作業中なので、作業途中の部分有)

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_5-dev/data/class/pages/mypage/LC_Page_Mypage_History.php

    r18820 r18824  
    227227        $col .= "od.classcategory_name2 AS classcategory_name2, od.price AS price, od.quantity AS quantity, od.point_rate AS point_rate"; 
    228228        $col .= ",CASE WHEN EXISTS(SELECT * FROM dtb_products WHERE product_id = od.product_id AND del_flg = 0 AND status = 1) THEN '1' ELSE '0' END AS enable"; 
    229         $col .= ",o.status AS status, pc.down AS down, o.payment_date AS payment_date, od.classcategory_id1 as classcategory_id1, od.classcategory_id2 as classcategory_id2, "; 
     229        $col .= ",o.status AS status, pc.down AS down, o.payment_date AS payment_date, od.product_class_id as product_class_id, "; 
    230230        $col .= $dbFactory->getDownloadableDaysWhereSql("o"); 
    231231        $col .= " AS effective"; 
    232232 
    233         $where = "p.product_id = od.product_id AND pc.product_id = od.product_id AND pc.classcategory_id1 = od.classcategory_id1 AND pc.classcategory_id2 = od.classcategory_id2 AND od.order_id = o.order_id AND od.order_id = ?"; 
     233        $where = "p.product_id = od.product_id AND pc.product_id = od.product_id AND pc.product_class_id = od.product_class_id AND od.order_id = o.order_id AND od.order_id = ?"; 
    234234        $arrRet = $objQuery->select($col, "dtb_products p, dtb_products_class pc, dtb_order_detail od, dtb_order o", $where); 
    235235        return $arrRet; 
Note: See TracChangeset for help on using the changeset viewer.