2.2 KiB
https://procomponents.ant.design/components/field-set#proformmoney
node: >=18
-- 非体验课课程订单
SELECT ol.order_no,ROUND(ol.money/100,2) as money,ROUND(ol.inner_money/100,2) as inner_money,ol.pay_status,u.nick_name2,u.phone,ol.refund_mark, ol.create_time,ol.refund_time,g.title
FROM order_list ol join order_classes oc on oc.order_id = ol.id join user u on u.id = ol.user_id join ground g on g.id = oc.ground_id
WHERE ol.pay_time IS NOT NULL and ol.type = 'classes'
-- 体验课课程订单
SELECT ol.order_no,ROUND(ol.money/100,2) as money,ROUND(ol.inner_money/100,2) as inner_money,ol.pay_status,u.nick_name2,u.phone,ol.refund_mark, ol.create_time,ol.refund_time
FROM order_list ol join order_classes oc on oc.order_id = ol.id join user u on u.id = ol.user_id WHERE ol.pay_time IS NOT NULL and ol.type = 'classes'
-- 场地预定订单
SELECT ol.order_no,ROUND(ol.money/100,2) as money,ROUND(ol.inner_money/100,2) as inner_money,ol.pay_status,u.nick_name2,u.phone,ol.refund_mark,g.title, ol.create_time,ol.refund_time
FROM order_list ol join order_ground og on og.order_id = ol.id join user u on u.id = ol.user_id join ground g on g.id = og.ground_id WHERE pay_time IS NOT NULL and type = 'ground'
-- 充值卡订单
SELECT ol.order_no,ROUND(ol.money/100,2) as money,ROUND(ol.inner_money/100,2) as inner_money,ol.pay_status,u.nick_name2,u.phone,ol.refund_mark, ol.create_time,ol.refund_time
FROM order_list ol join order_vip ov on ov.order_id = ol.id join user u on u.id = ol.user_id WHERE pay_time IS NOT NULL and type = 'vip'
-- 查询已支付和已退款的畅打订单
SELECT ol.order_no,ROUND(ol.money/100,2) as money,ROUND(ol.inner_money/100,2) as inner_money,ol.pay_status,u.nick_name2,u.phone,ol.refund_mark,g.title, ol.create_time,ol.refund_time
FROM order_list ol
join order_teacher_groupact_book oo on oo.order_id = ol.id join user u on u.id = ol.user_id
join teacher_groupact_book tg on tg.id = oo.teacher_groupact_book_id join ground g on g.id = tg.ground_id WHERE ol.pay_time IS NOT NULL and ol.type = 'groupact'