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
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
| -- 积分兑换模块 Mock 数据
| -- 用途：仅用于本地/测试环境查看“积分兑换”页面效果
| -- 前置条件：已执行 backend/sql/update_points_exchange_schema.sql
|
| SET NAMES utf8mb4;
|
| -- 先清理本脚本生成的明细和汇总数据，保证可重复执行
| DELETE FROM `tcm_points_exchange_order_item`
| WHERE `id` IN (9401, 9402, 9403, 9404, 9405, 9406, 9407);
|
| DELETE FROM `tcm_points_exchange_order`
| WHERE `id` IN (9301, 9302, 9303, 9304);
|
| DELETE FROM `tcm_points_ledger`
| WHERE `id` IN (9501, 9502, 9503, 9504, 9505, 9506, 9507);
|
| DELETE FROM `tcm_user_points_account`
| WHERE `id` IN (9201, 9202, 9203, 9204, 9205, 9206, 9207);
|
| DELETE FROM `tcm_points_config`
| WHERE `id` IN (9101, 9102);
|
| DELETE FROM `tcm_app_user`
| WHERE `id` IN (9001, 9002, 9003, 9004, 9005, 9006, 9007);
|
| DELETE FROM `tcm_clinic`
| WHERE `id` IN (8001, 8002, 8003);
|
| -- 诊所
| INSERT INTO `tcm_clinic`
| (`id`, `name`, `contact_name`, `contact_phone`, `province_code`, `province_name`, `city_code`, `city_name`, `district_code`, `district_name`, `address`, `status`, `deleted`, `created_by`, `updated_by`)
| VALUES
| (8001, '成都青羊本草堂', '陈院长', '13811110001', '510000', '四川省', '510100', '成都市', '510105', '青羊区', '四川省成都市青羊区西御街88号', 1, 0, 'mock', 'mock'),
| (8002, '成都高新仁和馆', '李主任', '13811110002', '510000', '四川省', '510100', '成都市', '510109', '高新区', '四川省成都市高新区天府大道199号', 1, 0, 'mock', 'mock'),
| (8003, '重庆渝中岐黄馆', '王馆长', '13811110003', '500000', '重庆市', '500100', '重庆市', '500103', '渝中区', '重庆市渝中区解放碑步行街66号', 1, 0, 'mock', 'mock');
|
| -- 用户
| INSERT INTO `tcm_app_user`
| (`id`, `nickname`, `phone`, `avatar`, `wechat_openid`, `wechat_nickname`, `wechat_avatar`, `wechat_bound_at`, `apple_user_identifier`, `apple_identity_subject`, `apple_bound_at`, `type`, `gender`, `age`, `intro`, `status`, `clinic_id`, `member_expire_at`, `deleted`, `created_by`, `updated_by`)
| VALUES
| (9001, '岐黄学员A', '13900000001', 'https://example.com/mock/avatar-9001.png', 'mock_openid_9001', '岐黄学员A', 'https://example.com/mock/wx-9001.png', '2026-03-01 09:00:00', NULL, NULL, NULL, 1, 1, 32, '积分兑换 mock 用户 A', 1, 8001, '2027-03-01 00:00:00', 0, 'mock', 'mock'),
| (9002, '岐黄学员B', '13900000002', 'https://example.com/mock/avatar-9002.png', 'mock_openid_9002', '岐黄学员B', 'https://example.com/mock/wx-9002.png', '2026-03-02 09:00:00', NULL, NULL, NULL, 0, 0, 29, '积分兑换 mock 用户 B', 1, 8001, '2027-03-01 00:00:00', 0, 'mock', 'mock'),
| (9003, '岐黄学员C', '13900000003', 'https://example.com/mock/avatar-9003.png', 'mock_openid_9003', '岐黄学员C', 'https://example.com/mock/wx-9003.png', '2026-03-03 09:00:00', NULL, NULL, NULL, 1, 1, 35, '积分兑换 mock 用户 C', 1, 8002, '2027-03-01 00:00:00', 0, 'mock', 'mock'),
| (9004, '岐黄学员D', '13900000004', 'https://example.com/mock/avatar-9004.png', 'mock_openid_9004', '岐黄学员D', 'https://example.com/mock/wx-9004.png', '2026-03-04 09:00:00', NULL, NULL, NULL, 0, 0, 27, '积分兑换 mock 用户 D', 1, 8002, '2027-03-01 00:00:00', 0, 'mock', 'mock'),
| (9005, '岐黄学员E', '13900000005', 'https://example.com/mock/avatar-9005.png', 'mock_openid_9005', '岐黄学员E', 'https://example.com/mock/wx-9005.png', '2026-03-05 09:00:00', NULL, NULL, NULL, 1, 1, 41, '积分兑换 mock 用户 E', 1, 8003, '2027-03-01 00:00:00', 0, 'mock', 'mock'),
| (9006, '岐黄学员F', '13900000006', 'https://example.com/mock/avatar-9006.png', 'mock_openid_9006', '岐黄学员F', 'https://example.com/mock/wx-9006.png', '2026-03-06 09:00:00', NULL, NULL, NULL, 0, 0, 38, '积分兑换 mock 用户 F', 1, 8003, '2027-03-01 00:00:00', 0, 'mock', 'mock'),
| (9007, '岐黄学员G', '13900000007', 'https://example.com/mock/avatar-9007.png', 'mock_openid_9007', '岐黄学员G', 'https://example.com/mock/wx-9007.png', '2026-03-07 09:00:00', NULL, NULL, NULL, 0, 1, 30, '积分兑换 mock 用户 G', 1, 8003, '2027-03-01 00:00:00', 0, 'mock', 'mock');
|
| -- 积分设置
| INSERT INTO `tcm_points_config`
| (`id`, `activity_start_at`, `activity_end_at`, `gift_cover`, `gift_name`, `required_points`, `settlement_status`, `settled_at`, `deleted`, `created_by`, `updated_by`, `created_at`, `updated_at`)
| VALUES
| (9101, '2026-03-01 00:00:00', '2026-03-31 23:59:59', 'https://example.com/mock/points-gift-box.png', '艾灸养生礼盒', 100, 1, '2026-04-01 10:00:00', 0, 'mock', 'mock', '2026-03-01 08:00:00', '2026-04-01 10:00:00'),
| (9102, '2026-04-01 00:00:00', '2026-04-30 23:59:59', 'https://example.com/mock/points-gift-pot.png', '草本泡脚包', 80, 0, NULL, 0, 'mock', 'mock', '2026-04-01 08:00:00', '2026-04-01 08:00:00');
|
| -- 用户积分账户
| INSERT INTO `tcm_user_points_account`
| (`id`, `app_user_id`, `points_balance`, `last_settled_config_id`, `last_cleared_at`, `deleted`, `created_by`, `updated_by`, `created_at`, `updated_at`)
| VALUES
| (9201, 9001, 0, 9101, '2026-04-01 10:00:00', 0, 'mock', 'mock', '2026-03-01 08:00:00', '2026-04-01 10:00:00'),
| (9202, 9002, 0, 9101, '2026-04-01 10:00:00', 0, 'mock', 'mock', '2026-03-01 08:00:00', '2026-04-01 10:00:00'),
| (9203, 9003, 0, 9101, '2026-04-01 10:00:00', 0, 'mock', 'mock', '2026-03-01 08:00:00', '2026-04-01 10:00:00'),
| (9204, 9004, 0, 9101, '2026-04-01 10:00:00', 0, 'mock', 'mock', '2026-03-01 08:00:00', '2026-04-01 10:00:00'),
| (9205, 9005, 20, NULL, NULL, 0, 'mock', 'mock', '2026-04-01 08:00:00', '2026-04-01 08:00:00'),
| (9206, 9006, 150, NULL, NULL, 0, 'mock', 'mock', '2026-04-01 08:00:00', '2026-04-01 08:00:00'),
| (9207, 9007, 75, NULL, NULL, 0, 'mock', 'mock', '2026-04-01 08:00:00', '2026-04-01 08:00:00');
|
| -- 汇总订单
| INSERT INTO `tcm_points_exchange_order`
| (`id`, `order_no`, `config_id`, `gift_cover`, `gift_name`, `required_points`, `activity_start_at`, `activity_end_at`, `clinic_id`, `clinic_app_user_id`, `clinic_name`, `receiver_name`, `receiver_phone`, `receiver_address`, `item_count`, `total_points`, `status`, `tracking_no`, `shipped_at`, `completed_at`, `cancelled_at`, `deleted`, `created_by`, `updated_by`, `created_at`, `updated_at`)
| VALUES
| (9301, 'PEO202604010001', 9101, 'https://example.com/mock/points-gift-box.png', '艾灸养生礼盒', 100, '2026-03-01 00:00:00', '2026-03-31 23:59:59', 8001, 9001, '成都青羊本草堂', '陈院长', '13811110001', '四川省成都市青羊区西御街88号', 2, 230, 0, NULL, NULL, NULL, NULL, 0, 'mock', 'mock', '2026-04-01 10:00:00', '2026-04-01 10:00:00'),
| (9302, 'PEO202604010002', 9101, 'https://example.com/mock/points-gift-box.png', '艾灸养生礼盒', 100, '2026-03-01 00:00:00', '2026-03-31 23:59:59', 8002, 9003, '成都高新仁和馆', '李主任', '13811110002', '四川省成都市高新区天府大道199号', 2, 230, 1, 'SF88A', '2026-04-02 14:30:00', NULL, NULL, 0, 'mock', 'mock', '2026-04-01 10:20:00', '2026-04-02 14:30:00'),
| (9303, 'PEO202604010003', 9101, 'https://example.com/mock/points-gift-box.png', '艾灸养生礼盒', 100, '2026-03-01 00:00:00', '2026-03-31 23:59:59', 8003, 9005, '重庆渝中岐黄馆', '王馆长', '13811110003', '重庆市渝中区解放碑步行街66号', 2, 210, 2, 'YT52C', '2026-04-03 11:20:00', NULL, NULL, 0, 'mock', 'mock', '2026-04-01 10:40:00', '2026-04-03 11:20:00'),
| (9304, 'PEO202604010004', 9101, 'https://example.com/mock/points-gift-box.png', '艾灸养生礼盒', 100, '2026-03-01 00:00:00', '2026-03-31 23:59:59', 8003, 9005, '重庆渝中岐黄馆', '王馆长', '13811110003', '重庆市渝中区解放碑步行街66号', 1, 110, 2, 'ZT99D', '2026-04-04 09:00:00', '2026-04-06 16:00:00', NULL, 0, 'mock', 'mock', '2026-04-01 11:00:00', '2026-04-06 16:00:00');
|
| -- 明细订单
| INSERT INTO `tcm_points_exchange_order_item`
| (`id`, `order_id`, `order_no`, `app_user_id`, `user_nickname`, `user_phone`, `clinic_id`, `clinic_name`, `province_code`, `province_name`, `city_code`, `city_name`, `district_code`, `district_name`, `settled_points`, `status`, `tracking_no`, `shipped_at`, `completed_at`, `cancelled_at`, `deleted`, `created_by`, `updated_by`, `created_at`, `updated_at`)
| VALUES
| (9401, 9301, 'PEI202604010001', 9001, '岐黄学员A', '13900000001', 8001, '成都青羊本草堂', '510000', '四川省', '510100', '成都市', '510105', '青羊区', 120, 0, NULL, NULL, NULL, NULL, 0, 'mock', 'mock', '2026-04-01 10:00:00', '2026-04-01 10:00:00'),
| (9402, 9301, 'PEI202604010002', 9002, '岐黄学员B', '13900000002', 8001, '成都青羊本草堂', '510000', '四川省', '510100', '成都市', '510105', '青羊区', 110, 0, NULL, NULL, NULL, NULL, 0, 'mock', 'mock', '2026-04-01 10:03:00', '2026-04-01 10:03:00'),
| (9403, 9302, 'PEI202604010003', 9003, '岐黄学员C', '13900000003', 8002, '成都高新仁和馆', '510000', '四川省', '510100', '成都市', '510109', '高新区', 105, 1, 'SF88A', '2026-04-02 14:30:00', NULL, NULL, 0, 'mock', 'mock', '2026-04-01 10:20:00', '2026-04-02 14:30:00'),
| (9404, 9302, 'PEI202604010004', 9004, '岐黄学员D', '13900000004', 8002, '成都高新仁和馆', '510000', '四川省', '510100', '成都市', '510109', '高新区', 125, 1, 'SF88A', '2026-04-02 14:30:00', NULL, NULL, 0, 'mock', 'mock', '2026-04-01 10:25:00', '2026-04-02 14:30:00'),
| (9405, 9303, 'PEI202604010005', 9005, '岐黄学员E', '13900000005', 8003, '重庆渝中岐黄馆', '500000', '重庆市', '500100', '重庆市', '500103', '渝中区', 100, 2, 'YT52C', '2026-04-03 11:20:00', NULL, NULL, 0, 'mock', 'mock', '2026-04-01 10:40:00', '2026-04-03 11:20:00'),
| (9406, 9303, 'PEI202604010006', 9006, '岐黄学员F', '13900000006', 8003, '重庆渝中岐黄馆', '500000', '重庆市', '500100', '重庆市', '500103', '渝中区', 110, 2, 'YT52C', '2026-04-03 11:20:00', NULL, NULL, 0, 'mock', 'mock', '2026-04-01 10:45:00', '2026-04-03 11:20:00'),
| (9407, 9304, 'PEI202604010007', 9007, '岐黄学员G', '13900000007', 8003, '重庆渝中岐黄馆', '500000', '重庆市', '500100', '重庆市', '500103', '渝中区', 110, 2, 'ZT99D', '2026-04-04 09:00:00', '2026-04-06 16:00:00', NULL, 0, 'mock', 'mock', '2026-04-01 11:00:00', '2026-04-06 16:00:00');
|
| -- 积分流水，便于联动查看“积分收支明细”时也有数据
| INSERT INTO `tcm_points_ledger`
| (`id`, `app_user_id`, `user_nickname`, `user_phone`, `clinic_id`, `clinic_name`, `province_code`, `province_name`, `city_code`, `city_name`, `district_code`, `district_name`, `income_expense_type`, `business_type`, `content_name`, `reference_type`, `reference_id`, `reference_no`, `points_delta`, `operated_at`, `source_type`, `source_id`, `deleted`, `created_by`, `updated_by`, `created_at`, `updated_at`)
| VALUES
| (9501, 9001, '岐黄学员A', '13900000001', 8001, '成都青羊本草堂', '510000', '四川省', '510100', '成都市', '510105', '青羊区', 'EXPENSE', 'POINTS_EXCHANGE', '艾灸养生礼盒', 'EXCHANGE_ITEM', 9401, 'PEI202604010001', -120, '2026-04-01 10:00:00', 'EXCHANGE_ITEM', 9401, 0, 'mock', 'mock', '2026-04-01 10:00:00', '2026-04-01 10:00:00'),
| (9502, 9002, '岐黄学员B', '13900000002', 8001, '成都青羊本草堂', '510000', '四川省', '510100', '成都市', '510105', '青羊区', 'EXPENSE', 'POINTS_EXCHANGE', '艾灸养生礼盒', 'EXCHANGE_ITEM', 9402, 'PEI202604010002', -110, '2026-04-01 10:03:00', 'EXCHANGE_ITEM', 9402, 0, 'mock', 'mock', '2026-04-01 10:03:00', '2026-04-01 10:03:00'),
| (9503, 9003, '岐黄学员C', '13900000003', 8002, '成都高新仁和馆', '510000', '四川省', '510100', '成都市', '510109', '高新区', 'EXPENSE', 'POINTS_EXCHANGE', '艾灸养生礼盒', 'EXCHANGE_ITEM', 9403, 'PEI202604010003', -105, '2026-04-01 10:20:00', 'EXCHANGE_ITEM', 9403, 0, 'mock', 'mock', '2026-04-01 10:20:00', '2026-04-01 10:20:00'),
| (9504, 9004, '岐黄学员D', '13900000004', 8002, '成都高新仁和馆', '510000', '四川省', '510100', '成都市', '510109', '高新区', 'EXPENSE', 'POINTS_EXCHANGE', '艾灸养生礼盒', 'EXCHANGE_ITEM', 9404, 'PEI202604010004', -125, '2026-04-01 10:25:00', 'EXCHANGE_ITEM', 9404, 0, 'mock', 'mock', '2026-04-01 10:25:00', '2026-04-01 10:25:00'),
| (9505, 9005, '岐黄学员E', '13900000005', 8003, '重庆渝中岐黄馆', '500000', '重庆市', '500100', '重庆市', '500103', '渝中区', 'EXPENSE', 'POINTS_EXCHANGE', '艾灸养生礼盒', 'EXCHANGE_ITEM', 9405, 'PEI202604010005', -100, '2026-04-01 10:40:00', 'EXCHANGE_ITEM', 9405, 0, 'mock', 'mock', '2026-04-01 10:40:00', '2026-04-01 10:40:00'),
| (9506, 9006, '岐黄学员F', '13900000006', 8003, '重庆渝中岐黄馆', '500000', '重庆市', '500100', '重庆市', '500103', '渝中区', 'EXPENSE', 'POINTS_EXCHANGE', '艾灸养生礼盒', 'EXCHANGE_ITEM', 9406, 'PEI202604010006', -110, '2026-04-01 10:45:00', 'EXCHANGE_ITEM', 9406, 0, 'mock', 'mock', '2026-04-01 10:45:00', '2026-04-01 10:45:00'),
| (9507, 9007, '岐黄学员G', '13900000007', 8003, '重庆渝中岐黄馆', '500000', '重庆市', '500100', '重庆市', '500103', '渝中区', 'EXPENSE', 'POINTS_EXCHANGE', '艾灸养生礼盒', 'EXCHANGE_ITEM', 9407, 'PEI202604010007', -110, '2026-04-01 11:00:00', 'EXCHANGE_ITEM', 9407, 0, 'mock', 'mock', '2026-04-01 11:00:00', '2026-04-01 11:00:00');
|
|
