1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
| -- 最近一周营收统计 mock 数据（2026-03-20 ~ 2026-03-26）
| -- 用途：给「统计-营收数据」页面提供最近 7 天的支付/退款波动数据
| -- 说明：只插入订单表，支付流水会在查询统计接口时由 syncFlows() 自动补齐
|
| INSERT IGNORE INTO `tcm_course_purchase_order`
| (`order_no`, `app_user_id`, `user_nickname`, `user_phone`, `course_type`, `purchase_target_type`, `course_id`,
| `course_video_id`, `product_name_snapshot`, `course_title_snapshot`, `chapter_name_snapshot`, `cover_img_snapshot`,
| `order_amount`, `payment_method`, `refund_amount`, `refund_remark`, `status`, `paid_at`, `refunded_at`, `cancelled_at`, `deleted`)
| VALUES
| ('CPO202603200001', 200, '王美丽', '14712346905', 'HEALTH_COURSE', 'COURSE', 1,
| NULL, '中医针灸资格证', '中医针灸资格证', NULL, 'https://example.com/health/course-1-cover.png',
| 299.00, 'WECHAT', NULL, NULL, 'PAID', '2026-03-20 10:15:00', NULL, NULL, 0),
| ('CPO202603210001', 200, '王美丽', '14712346905', 'HEALTH_COURSE', 'COURSE_CHAPTER', 1,
| 1, '中医针灸资格证-方剂学', '中医针灸资格证', '方剂学', 'https://example.com/health/course-1-cover.png',
| 199.00, 'ALIPAY', NULL, NULL, 'PAID', '2026-03-21 14:20:00', NULL, NULL, 0),
| ('CPO202603220001', 200, '王美丽', '14712346905', 'HEALTH_COURSE', 'COURSE', 1,
| NULL, '中医针灸资格证', '中医针灸资格证', NULL, 'https://example.com/health/course-1-cover.png',
| 399.00, 'WECHAT', NULL, NULL, 'PAID', '2026-03-22 11:08:00', NULL, NULL, 0),
| ('CPO202603230001', 200, '王美丽', '14712346905', 'HEALTH_COURSE', 'COURSE_CHAPTER', 1,
| 1, '中医针灸资格证-方剂学', '中医针灸资格证', '方剂学', 'https://example.com/health/course-1-cover.png',
| 159.00, 'WECHAT', 59.00, '用户误购申请部分退款', 'REFUNDED', '2026-03-23 09:36:00', '2026-03-23 18:10:00', NULL, 0),
| ('CPO202603250001', 200, '王美丽', '14712346905', 'HEALTH_COURSE', 'COURSE', 1,
| NULL, '中医针灸资格证', '中医针灸资格证', NULL, 'https://example.com/health/course-1-cover.png',
| 259.00, 'ALIPAY', NULL, NULL, 'PAID', '2026-03-25 16:42:00', NULL, NULL, 0),
| ('CPO202603260001', 200, '王美丽', '14712346905', 'HEALTH_COURSE', 'COURSE', 1,
| NULL, '中医针灸资格证', '中医针灸资格证', NULL, 'https://example.com/health/course-1-cover.png',
| 329.00, 'WECHAT', NULL, NULL, 'PAID', '2026-03-26 13:25:00', NULL, NULL, 0);
|
| INSERT IGNORE INTO `tcm_member_purchase_order`
| (`order_no`, `app_user_id`, `user_nickname`, `user_phone`, `member_type`, `member_days`, `order_amount`,
| `payment_method`, `refund_amount`, `refund_remark`, `status`, `paid_at`, `refunded_at`, `cancelled_at`, `deleted`)
| VALUES
| ('MPO202603200001', 200, '王美丽', '14712346905', 'MONTH_CARD', 30, 69.00,
| 'ALIPAY', NULL, NULL, 'PAID', '2026-03-20 19:30:00', NULL, NULL, 0),
| ('MPO202603210001', 200, '王美丽', '14712346905', 'QUARTER_CARD', 90, 199.00,
| 'WECHAT', NULL, NULL, 'PAID', '2026-03-21 20:10:00', NULL, NULL, 0),
| ('MPO202603220001', 200, '王美丽', '14712346905', 'MONTH_CARD', 30, 69.00,
| 'WECHAT', 69.00, '重复购买退款', 'REFUNDED', '2026-03-22 15:00:00', '2026-03-22 17:30:00', NULL, 0),
| ('MPO202603240001', 200, '王美丽', '14712346905', 'QUARTER_CARD', 90, 199.00,
| 'ALIPAY', NULL, NULL, 'PAID', '2026-03-24 12:18:00', NULL, NULL, 0),
| ('MPO202603250001', 200, '王美丽', '14712346905', 'MONTH_CARD', 30, 69.00,
| 'WECHAT', NULL, NULL, 'PAID', '2026-03-25 09:55:00', NULL, NULL, 0),
| ('MPO202603260001', 200, '王美丽', '14712346905', 'QUARTER_CARD', 90, 199.00,
| 'ALIPAY', 199.00, '用户申请退款', 'REFUNDED', '2026-03-26 08:40:00', '2026-03-26 18:20:00', NULL, 0);
|
|
