- Timestamp:
- 2010/09/27 11:49:29 (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/data/class/pages/mypage/LC_Page_Mypage_History.php
r18820 r18824 227 227 $col .= "od.classcategory_name2 AS classcategory_name2, od.price AS price, od.quantity AS quantity, od.point_rate AS point_rate"; 228 228 $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, "; 230 230 $col .= $dbFactory->getDownloadableDaysWhereSql("o"); 231 231 $col .= " AS effective"; 232 232 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_id2AND 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 = ?"; 234 234 $arrRet = $objQuery->select($col, "dtb_products p, dtb_products_class pc, dtb_order_detail od, dtb_order o", $where); 235 235 return $arrRet;
Note: See TracChangeset
for help on using the changeset viewer.