-- 最近一周营收统计 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);