34 lines
2.2 KiB
Markdown
34 lines
2.2 KiB
Markdown
|
https://www.figma.com/file/ZHTlv6VKz6As6gVlG2KnmG/Merchant-Management-System?type=design&node-id=19-2&mode=design&t=cZ9I7U9SAJVxQlqk-0
|
||
|
|
|
||
|
|
|
||
|
|
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'
|