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
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
| -- 刷卡充电订单与 VIN 码充电订单模拟数据
| -- 仅用于测试环境。订单号前缀：刷卡 SD_，VIN VD_。
| -- 脚本可重复执行：先按固定测试 ID 清理，再重新插入。
|
| USE charging_pile_order;
|
| -- 清理旧测试数据（先子表后主表）
| DELETE FROM t_card_charging_order_share_record WHERE charging_order_code IN ('SD_20260901_001','SD_20260901_002','SD_20260901_003','SD_20260901_004','SD_20260901_005');
| DELETE FROM t_card_charging_order_refund WHERE charging_order_id IN (2095000000000010001,2095000000000010002,2095000000000010003,2095000000000010004,2095000000000010005);
| DELETE FROM t_card_charging_order_accounting_strategy WHERE charging_order_id IN (2095000000000010001,2095000000000010002,2095000000000010003,2095000000000010004,2095000000000010005);
| DELETE FROM t_card_accounting_strategy_detail_order WHERE charging_order_id IN (2095000000000010001,2095000000000010002,2095000000000010003,2095000000000010004,2095000000000010005);
| DELETE FROM t_card_accounting_strategy_order WHERE charging_order_id IN (2095000000000010001,2095000000000010002,2095000000000010003,2095000000000010004,2095000000000010005);
| DELETE FROM t_card_charging_order WHERE card_id = 1 AND id IN (2095000000000010001,2095000000000010002,2095000000000010003,2095000000000010004,2095000000000010005);
|
| DELETE FROM t_vin_charging_order_share_record WHERE charging_order_code IN ('VD_20260901_001','VD_20260901_002','VD_20260901_003','VD_20260901_004','VD_20260901_005');
| DELETE FROM t_vin_charging_order_refund WHERE charging_order_id IN (2095000000000020001,2095000000000020002,2095000000000020003,2095000000000020004,2095000000000020005);
| DELETE FROM t_vin_charging_order_accounting_strategy WHERE charging_order_id IN (2095000000000020001,2095000000000020002,2095000000000020003,2095000000000020004,2095000000000020005);
| DELETE FROM t_vin_accounting_strategy_detail_order WHERE charging_order_id IN (2095000000000020001,2095000000000020002,2095000000000020003,2095000000000020004,2095000000000020005);
| DELETE FROM t_vin_accounting_strategy_order WHERE charging_order_id IN (2095000000000020001,2095000000000020002,2095000000000020003,2095000000000020004,2095000000000020005);
| DELETE FROM t_vin_charging_order WHERE vin_id = 1 AND id IN (2095000000000020001,2095000000000020002,2095000000000020003,2095000000000020004,2095000000000020005);
|
| -- 刷卡订单主表：使用测试充电卡 card_id=1/card_no=1234695。
| INSERT INTO t_card_charging_order
| (id,code,card_id,card_no,order_type,order_classification,plate_num,site_id,charging_pile_id,charging_gun_id,charging_capacity,start_time,end_time,status,end_mode,recharge_amount,recharge_payment_status,pay_method,balance_pay_amount,third_pay_amount,balance_refund_amount,third_refund_amount,charge_amount,residual_amount,order_amount,payment_amount,refund_amount,is_whitelist,whitelist_discount_amount,whitelist_electric_refund_amount,whitelist_service_refund_amount,refund_code,refund_status,refund_time,create_time,del_flag,order_source,source_name,commission_amount,sharing_amount,service_charge,electrovalence,pay_time,phone,title,start_soc,end_soc)
| VALUES
| (2095000000000010001,'SD_20260901_001',1,'1234695',2,2,'川A123456',26,46,295,10.00000,'2026-09-01 08:00:00','2026-09-01 09:00:00',5,1,25.0000,2,1,25.00,0.00,0.00,0.00,25.00,0.00,25.0000,25.0000,0.0000,0,0.00,0.00,0.00,NULL,NULL,NULL,'2026-09-01 07:58:00',0,1,'TEST_CARD',0.0000,0.0000,10.0000,15.0000,'2026-09-01 09:01:00','15800000001','刷卡模拟订单-尖峰',20.00,80.00),
| (2095000000000010002,'SD_20260901_002',1,'1234695',2,2,'川A123456',26,46,295,12.00000,'2026-09-01 10:00:00','2026-09-01 11:20:00',5,2,24.0000,2,1,24.00,0.00,4.00,0.00,24.00,0.00,24.0000,24.0000,4.0000,0,0.00,0.00,0.00,'SD_REFUND_002',2,'2026-09-01 11:30:00','2026-09-01 09:58:00',0,1,'TEST_CARD',0.0000,0.0000,9.6000,14.4000,'2026-09-01 11:21:00','15800000002','刷卡模拟订单-部分退款',25.00,75.00),
| (2095000000000010003,'SD_20260901_003',1,'1234695',2,2,'川A123456',19,24,59,8.00000,'2026-09-01 12:00:00','2026-09-01 12:45:00',5,1,12.0000,2,1,12.00,0.00,0.00,0.00,12.00,0.00,12.0000,12.0000,0.0000,0,0.00,0.00,0.00,NULL,NULL,NULL,'2026-09-01 11:58:00',0,1,'TEST_CARD',0.0000,0.0000,4.0000,8.0000,'2026-09-01 12:46:00','15800000003','刷卡模拟订单-平段',30.00,70.00),
| (2095000000000010004,'SD_20260901_004',1,'1234695',2,2,'川A123456',75,881,1375,15.00000,'2026-09-01 14:00:00','2026-09-01 15:30:00',5,2,30.0000,2,1,30.00,0.00,0.00,0.00,30.00,0.00,30.0000,30.0000,0.0000,0,0.00,0.00,0.00,NULL,NULL,NULL,'2026-09-01 13:58:00',0,1,'TEST_CARD',0.0000,0.0000,12.0000,18.0000,'2026-09-01 15:31:00','15800000004','刷卡模拟订单-峰平',15.00,90.00),
| (2095000000000010005,'SD_20260901_005',1,'1234695',2,2,'川A123456',77,889,1391,6.00000,'2026-09-01 16:00:00','2026-09-01 16:40:00',5,1,9.0000,2,1,9.00,0.00,2.00,0.00,9.00,0.00,9.0000,9.0000,2.0000,0,0.00,0.00,0.00,'SD_REFUND_005',2,'2026-09-01 16:50:00','2026-09-01 15:58:00',0,1,'TEST_CARD',0.0000,0.0000,3.0000,6.0000,'2026-09-01 16:41:00','15800000005','刷卡模拟订单-退款',35.00,65.00);
|
| INSERT INTO t_card_accounting_strategy_order
| (id,site_id,name,description,discount,create_time,del_flag,audit_status,charging_order_id)
| VALUES
| (1910001,26,'刷卡模拟策略001','SD_测试策略',1.00,'2026-09-01 07:58:00',0,3,2095000000000010001),
| (1910002,26,'刷卡模拟策略002','SD_测试策略',1.00,'2026-09-01 09:58:00',0,3,2095000000000010002),
| (1910003,19,'刷卡模拟策略003','SD_测试策略',1.00,'2026-09-01 11:58:00',0,3,2095000000000010003),
| (1910004,75,'刷卡模拟策略004','SD_测试策略',1.00,'2026-09-01 13:58:00',0,3,2095000000000010004),
| (1910005,77,'刷卡模拟策略005','SD_测试策略',1.00,'2026-09-01 15:58:00',0,3,2095000000000010005);
|
| INSERT INTO t_card_accounting_strategy_detail_order
| (id,accounting_strategy_id,type,start_time,end_time,electrovalence,service_charge,cost_service_charge,charging_order_id,create_time,del_flag)
| VALUES
| (1910101,1910001,1,'00:00','06:00',1.0000,0.5000,0.5000,2095000000000010001,'2026-09-01 07:58:00',0),(1910102,1910001,2,'06:00','12:00',2.0000,1.0000,1.0000,2095000000000010001,'2026-09-01 07:58:00',0),
| (1910201,1910002,2,'06:00','12:00',1.2000,0.8000,0.8000,2095000000000010002,'2026-09-01 09:58:00',0),(1910202,1910002,3,'12:00','18:00',1.2000,0.8000,0.8000,2095000000000010002,'2026-09-01 09:58:00',0),
| (1910301,1910003,3,'12:00','18:00',1.0000,0.5000,0.5000,2095000000000010003,'2026-09-01 11:58:00',0),(1910302,1910003,4,'18:00','24:00',1.0000,0.5000,0.5000,2095000000000010003,'2026-09-01 11:58:00',0),
| (1910401,1910004,2,'06:00','12:00',1.2000,0.8000,0.8000,2095000000000010004,'2026-09-01 13:58:00',0),(1910402,1910004,3,'12:00','18:00',1.2000,0.8000,0.8000,2095000000000010004,'2026-09-01 13:58:00',0),
| (1910501,1910005,1,'00:00','06:00',1.0000,0.5000,0.5000,2095000000000010005,'2026-09-01 15:58:00',0),(1910502,1910005,4,'18:00','24:00',1.0000,0.5000,0.5000,2095000000000010005,'2026-09-01 15:58:00',0);
|
| INSERT INTO t_card_charging_order_accounting_strategy
| (id,charging_order_id,accounting_strategy_detail_id,type,start_time,end_time,electrovalence,service_charge,cost_service_charge,charging_capacity,create_time,period_electric_price,period_service_price,period_original_service_price,vip_discount_amount,coupon_discount_amount)
| VALUES
| (2095000000000110001,2095000000000010001,1910101,1,'08:00','08:30',1.0000,0.5000,0.5000,4.0000,'2026-09-01 09:00:00',4.0000,2.0000,2.0000,0,0),(2095000000000110002,2095000000000010001,1910102,2,'08:30','09:00',1.8333,1.3333,1.3333,6.0000,'2026-09-01 09:00:00',11.0000,8.0000,8.0000,0,0),
| (2095000000000110003,2095000000000010002,1910201,2,'10:00','10:40',1.2000,0.8000,0.8000,6.0000,'2026-09-01 11:20:00',7.2000,4.8000,4.8000,0,0),(2095000000000110004,2095000000000010002,1910202,3,'10:40','11:20',1.2000,0.8000,0.8000,6.0000,'2026-09-01 11:20:00',7.2000,4.8000,4.8000,0,0),
| (2095000000000110005,2095000000000010003,1910301,3,'12:00','12:25',1.0000,0.5000,0.5000,4.0000,'2026-09-01 12:45:00',4.0000,2.0000,2.0000,0,0),(2095000000000110006,2095000000000010003,1910302,4,'12:25','12:45',1.0000,0.5000,0.5000,4.0000,'2026-09-01 12:45:00',4.0000,2.0000,2.0000,0,0),
| (2095000000000110007,2095000000000010004,1910401,2,'14:00','14:45',1.2000,0.8000,0.8000,7.5000,'2026-09-01 15:30:00',9.0000,6.0000,6.0000,0,0),(2095000000000110008,2095000000000010004,1910402,3,'14:45','15:30',1.2000,0.8000,0.8000,7.5000,'2026-09-01 15:30:00',9.0000,6.0000,6.0000,0,0),
| (2095000000000110009,2095000000000010005,1910501,1,'16:00','16:20',1.0000,0.5000,0.5000,3.0000,'2026-09-01 16:40:00',3.0000,1.5000,1.5000,0,0),(2095000000000110010,2095000000000010005,1910502,4,'16:20','16:40',1.0000,0.5000,0.5000,3.0000,'2026-09-01 16:40:00',3.0000,1.5000,1.5000,0,0);
|
| INSERT INTO t_card_charging_order_refund
| (id,charging_order_id,refund_code,refund_amount,balance_refund_amount,third_refund_amount,refund_status,refund_serial_number,refund_time,code,refund_title,refund_content,refund_reason,refund_remark,refund_total_amount,refund_fee,pay_amount,pay_type,create_time,del_flag)
| VALUES
| (2095000000000120002,2095000000000010002,'SD_REFUND_002',4.00,4.00,0.00,2,'SD_REFUND_SERIAL_002','2026-09-01 11:30:00','SD_20260901_002','刷卡模拟退款','部分退款','测试数据','SD_TEST',4.00,0.00,24.00,1,'2026-09-01 11:30:00',0),
| (2095000000000120005,2095000000000010005,'SD_REFUND_005',2.00,2.00,0.00,2,'SD_REFUND_SERIAL_005','2026-09-01 16:50:00','SD_20260901_005','刷卡模拟退款','部分退款','测试数据','SD_TEST',2.00,0.00,9.00,1,'2026-09-01 16:50:00',0);
|
| INSERT INTO t_card_charging_order_share_record
| (charging_order_id,charging_order_code,site_id,partner_id,pay_channel,channel_pay_amount,channel_gift_amount,channel_pay_ratio,channel_electricity_amount,channel_service_amount,electricity_share_ratio,service_share_ratio,electricity_share_amount,service_share_amount,share_amount,need_online_share,online_share_status,request_json,response_json,retry_count,create_time,del_flag)
| VALUES
| (2095000000000010001,'SD_20260901_001',26,9001,'BALANCE',25.00,0,1.000000,15.00,10.00,50.00,50.00,7.50,5.00,12.50,0,'RECORDED','{"test":true}','{"test":true}',0,'2026-09-01 07:58:00',0),
| (2095000000000010002,'SD_20260901_002',26,9001,'BALANCE',24.00,0,1.000000,14.40,9.60,50.00,50.00,7.20,4.80,12.00,0,'RECORDED','{"test":true}','{"test":true}',0,'2026-09-01 09:58:00',0),
| (2095000000000010003,'SD_20260901_003',19,9001,'BALANCE',12.00,0,1.000000,8.00,4.00,50.00,50.00,4.00,2.00,6.00,0,'RECORDED','{"test":true}','{"test":true}',0,'2026-09-01 11:58:00',0),
| (2095000000000010004,'SD_20260901_004',75,9001,'BALANCE',30.00,0,1.000000,18.00,12.00,50.00,50.00,9.00,6.00,15.00,0,'RECORDED','{"test":true}','{"test":true}',0,'2026-09-01 13:58:00',0),
| (2095000000000010005,'SD_20260901_005',77,9001,'BALANCE',9.00,0,1.000000,6.00,3.00,50.00,50.00,3.00,1.50,4.50,0,'RECORDED','{"test":true}','{"test":true}',0,'2026-09-01 15:58:00',0);
|
| -- VIN 订单主表：使用测试 VIN 管理记录 vin_id=1/vin=12356789。
| INSERT INTO t_vin_charging_order
| (id,code,vin_id,order_type,order_classification,plate_num,expected_vin,actual_vin,site_id,charging_pile_id,charging_gun_id,charging_capacity,start_time,end_time,status,end_mode,recharge_amount,recharge_payment_status,pay_method,balance_pay_amount,third_pay_amount,balance_refund_amount,third_refund_amount,charge_amount,residual_amount,order_amount,payment_amount,refund_amount,is_whitelist,whitelist_discount_amount,whitelist_electric_refund_amount,whitelist_service_refund_amount,refund_code,refund_status,refund_time,create_time,del_flag,order_source,source_name,commission_amount,sharing_amount,service_charge,electrovalence,pay_time,phone,title,start_soc,end_soc)
| VALUES
| (2095000000000020001,'VD_20260901_001',1,2,2,'川A123456','12356789','12356789',26,46,295,9.00000,'2026-09-01 08:10:00','2026-09-01 09:05:00',5,1,18.0000,2,1,18.00,0.00,0.00,0.00,18.00,0.00,18.0000,18.0000,0.0000,0,0.00,0.00,0.00,NULL,NULL,NULL,'2026-09-01 08:08:00',0,1,'TEST_VIN',0.0000,0.0000,7.2000,10.8000,'2026-09-01 09:06:00','15828353127','VIN模拟订单-尖峰',20.00,78.00),
| (2095000000000020002,'VD_20260901_002',1,2,2,'川A123456','12356789','12356789',26,46,295,11.00000,'2026-09-01 10:10:00','2026-09-01 11:20:00',5,2,22.0000,2,1,22.00,0.00,3.00,0.00,22.00,0.00,22.0000,22.0000,3.0000,0,0.00,0.00,0.00,'VD_REFUND_002',2,'2026-09-01 11:30:00','2026-09-01 10:08:00',0,1,'TEST_VIN',0.0000,0.0000,8.8000,13.2000,'2026-09-01 11:21:00','15828353127','VIN模拟订单-部分退款',25.00,72.00),
| (2095000000000020003,'VD_20260901_003',1,2,2,'川A123456','12356789','12356789',19,24,59,7.00000,'2026-09-01 12:10:00','2026-09-01 12:50:00',5,1,10.5000,2,1,10.50,0.00,0.00,0.00,10.50,0.00,10.5000,10.5000,0.0000,0,0.00,0.00,0.00,NULL,NULL,NULL,'2026-09-01 12:08:00',0,1,'TEST_VIN',0.0000,0.0000,3.5000,7.0000,'2026-09-01 12:51:00','15828353127','VIN模拟订单-平段',30.00,68.00),
| (2095000000000020004,'VD_20260901_004',1,2,2,'川A123456','12356789','12356789',75,881,1375,14.00000,'2026-09-01 14:10:00','2026-09-01 15:30:00',5,2,28.0000,2,1,28.00,0.00,0.00,0.00,28.00,0.00,28.0000,28.0000,0.0000,0,0.00,0.00,0.00,NULL,NULL,NULL,'2026-09-01 14:08:00',0,1,'TEST_VIN',0.0000,0.0000,11.2000,16.8000,'2026-09-01 15:31:00','15828353127','VIN模拟订单-峰平',15.00,88.00),
| (2095000000000020005,'VD_20260901_005',1,2,2,'川A123456','12356789','12356789',77,889,1391,5.00000,'2026-09-01 16:10:00','2026-09-01 16:45:00',5,1,7.5000,2,1,7.50,0.00,1.50,0.00,7.50,0.00,7.5000,7.5000,1.5000,0,0.00,0.00,0.00,'VD_REFUND_005',2,'2026-09-01 16:55:00','2026-09-01 16:08:00',0,1,'TEST_VIN',0.0000,0.0000,2.5000,5.0000,'2026-09-01 16:46:00','15828353127','VIN模拟订单-退款',35.00,62.00);
|
| INSERT INTO t_vin_accounting_strategy_order
| (id,site_id,name,description,discount,create_time,del_flag,audit_status,charging_order_id)
| VALUES
| (1920001,26,'VIN模拟策略001','VD_测试策略',1.00,'2026-09-01 08:08:00',0,3,2095000000000020001),(1920002,26,'VIN模拟策略002','VD_测试策略',1.00,'2026-09-01 10:08:00',0,3,2095000000000020002),(1920003,19,'VIN模拟策略003','VD_测试策略',1.00,'2026-09-01 12:08:00',0,3,2095000000000020003),(1920004,75,'VIN模拟策略004','VD_测试策略',1.00,'2026-09-01 14:08:00',0,3,2095000000000020004),(1920005,77,'VIN模拟策略005','VD_测试策略',1.00,'2026-09-01 16:08:00',0,3,2095000000000020005);
|
| INSERT INTO t_vin_accounting_strategy_detail_order
| (id,accounting_strategy_id,type,start_time,end_time,electrovalence,service_charge,cost_service_charge,charging_order_id,create_time,del_flag)
| VALUES
| (1920101,1920001,1,'00:00','06:00',1.0000,0.5000,0.5000,2095000000000020001,'2026-09-01 08:08:00',0),(1920102,1920001,2,'06:00','12:00',1.2000,0.8000,0.8000,2095000000000020001,'2026-09-01 08:08:00',0),
| (1920201,1920002,2,'06:00','12:00',1.2000,0.8000,0.8000,2095000000000020002,'2026-09-01 10:08:00',0),(1920202,1920002,3,'12:00','18:00',1.2000,0.8000,0.8000,2095000000000020002,'2026-09-01 10:08:00',0),
| (1920301,1920003,3,'12:00','18:00',1.0000,0.5000,0.5000,2095000000000020003,'2026-09-01 12:08:00',0),(1920302,1920003,4,'18:00','24:00',1.0000,0.5000,0.5000,2095000000000020003,'2026-09-01 12:08:00',0),
| (1920401,1920004,2,'06:00','12:00',1.2000,0.8000,0.8000,2095000000000020004,'2026-09-01 14:08:00',0),(1920402,1920004,3,'12:00','18:00',1.2000,0.8000,0.8000,2095000000000020004,'2026-09-01 14:08:00',0),
| (1920501,1920005,1,'00:00','06:00',1.0000,0.5000,0.5000,2095000000000020005,'2026-09-01 16:08:00',0),(1920502,1920005,4,'18:00','24:00',1.0000,0.5000,0.5000,2095000000000020005,'2026-09-01 16:08:00',0);
|
| INSERT INTO t_vin_charging_order_accounting_strategy
| (id,charging_order_id,accounting_strategy_detail_id,type,start_time,end_time,electrovalence,service_charge,cost_service_charge,charging_capacity,create_time,period_electric_price,period_service_price,period_original_service_price,vip_discount_amount,coupon_discount_amount)
| VALUES
| (2095000000000210001,2095000000000020001,1920101,1,'08:10','08:35',1.0000,0.5000,0.5000,4.0000,'2026-09-01 09:05:00',4.0000,2.0000,2.0000,0,0),(2095000000000210002,2095000000000020001,1920102,2,'08:35','09:05',1.3600,1.0400,1.0400,5.0000,'2026-09-01 09:05:00',6.8000,5.2000,5.2000,0,0),
| (2095000000000210003,2095000000000020002,1920201,2,'10:10','10:45',1.2000,0.8000,0.8000,5.5000,'2026-09-01 11:20:00',6.6000,4.4000,4.4000,0,0),(2095000000000210004,2095000000000020002,1920202,3,'10:45','11:20',1.2000,0.8000,0.8000,5.5000,'2026-09-01 11:20:00',6.6000,4.4000,4.4000,0,0),
| (2095000000000210005,2095000000000020003,1920301,3,'12:10','12:30',1.0000,0.5000,0.5000,3.5000,'2026-09-01 12:50:00',3.5000,1.7500,1.7500,0,0),(2095000000000210006,2095000000000020003,1920302,4,'12:30','12:50',1.0000,0.5000,0.5000,3.5000,'2026-09-01 12:50:00',3.5000,1.7500,1.7500,0,0),
| (2095000000000210007,2095000000000020004,1920401,2,'14:10','14:50',1.2000,0.8000,0.8000,7.0000,'2026-09-01 15:30:00',8.4000,5.6000,5.6000,0,0),(2095000000000210008,2095000000000020004,1920402,3,'14:50','15:30',1.2000,0.8000,0.8000,7.0000,'2026-09-01 15:30:00',8.4000,5.6000,5.6000,0,0),
| (2095000000000210009,2095000000000020005,1920501,1,'16:10','16:27',1.0000,0.5000,0.5000,2.5000,'2026-09-01 16:45:00',2.5000,1.2500,1.2500,0,0),(2095000000000210010,2095000000000020005,1920502,4,'16:27','16:45',1.0000,0.5000,0.5000,2.5000,'2026-09-01 16:45:00',2.5000,1.2500,1.2500,0,0);
|
| INSERT INTO t_vin_charging_order_refund
| (id,charging_order_id,refund_code,refund_amount,balance_refund_amount,third_refund_amount,refund_status,refund_serial_number,refund_time,code,refund_title,refund_content,refund_reason,refund_remark,refund_total_amount,refund_fee,pay_amount,pay_type,create_time,del_flag)
| VALUES
| (2095000000000220002,2095000000000020002,'VD_REFUND_002',3.00,3.00,0.00,2,'VD_REFUND_SERIAL_002','2026-09-01 11:30:00','VD_20260901_002','VIN模拟退款','部分退款','测试数据','VD_TEST',3.00,0.00,22.00,1,'2026-09-01 11:30:00',0),
| (2095000000000220005,2095000000000020005,'VD_REFUND_005',1.50,1.50,0.00,2,'VD_REFUND_SERIAL_005','2026-09-01 16:55:00','VD_20260901_005','VIN模拟退款','部分退款','测试数据','VD_TEST',1.50,0.00,7.50,1,'2026-09-01 16:55:00',0);
|
| INSERT INTO t_vin_charging_order_share_record
| (charging_order_id,charging_order_code,site_id,partner_id,pay_channel,channel_pay_amount,channel_gift_amount,channel_pay_ratio,channel_electricity_amount,channel_service_amount,electricity_share_ratio,service_share_ratio,electricity_share_amount,service_share_amount,share_amount,need_online_share,online_share_status,request_json,response_json,retry_count,create_time,del_flag)
| VALUES
| (2095000000000020001,'VD_20260901_001',26,9001,'BALANCE',18.00,0,1.000000,10.80,7.20,50.00,50.00,5.40,3.60,9.00,0,'RECORDED','{"test":true}','{"test":true}',0,'2026-09-01 08:08:00',0),
| (2095000000000020002,'VD_20260901_002',26,9001,'BALANCE',22.00,0,1.000000,13.20,8.80,50.00,50.00,6.60,4.40,11.00,0,'RECORDED','{"test":true}','{"test":true}',0,'2026-09-01 10:08:00',0),
| (2095000000000020003,'VD_20260901_003',19,9001,'BALANCE',10.50,0,1.000000,7.00,3.50,50.00,50.00,3.50,1.75,5.25,0,'RECORDED','{"test":true}','{"test":true}',0,'2026-09-01 12:08:00',0),
| (2095000000000020004,'VD_20260901_004',75,9001,'BALANCE',28.00,0,1.000000,16.80,11.20,50.00,50.00,8.40,5.60,14.00,0,'RECORDED','{"test":true}','{"test":true}',0,'2026-09-01 14:08:00',0),
| (2095000000000020005,'VD_20260901_005',77,9001,'BALANCE',7.50,0,1.000000,5.00,2.50,50.00,50.00,2.50,1.25,3.75,0,'RECORDED','{"test":true}','{"test":true}',0,'2026-09-01 16:08:00',0);
|
| -- 验证结果
| SELECT 'card_order' AS item,COUNT(*) AS count FROM t_card_charging_order WHERE card_id=1 AND code LIKE 'SD\_%'
| UNION ALL SELECT 'card_strategy',COUNT(*) FROM t_card_accounting_strategy_order WHERE charging_order_id IN (2095000000000010001,2095000000000010002,2095000000000010003,2095000000000010004,2095000000000010005)
| UNION ALL SELECT 'card_strategy_detail',COUNT(*) FROM t_card_accounting_strategy_detail_order WHERE charging_order_id IN (2095000000000010001,2095000000000010002,2095000000000010003,2095000000000010004,2095000000000010005)
| UNION ALL SELECT 'card_period',COUNT(*) FROM t_card_charging_order_accounting_strategy WHERE charging_order_id IN (2095000000000010001,2095000000000010002,2095000000000010003,2095000000000010004,2095000000000010005)
| UNION ALL SELECT 'card_refund',COUNT(*) FROM t_card_charging_order_refund WHERE charging_order_id IN (2095000000000010001,2095000000000010002,2095000000000010003,2095000000000010004,2095000000000010005)
| UNION ALL SELECT 'card_share',COUNT(*) FROM t_card_charging_order_share_record WHERE charging_order_code LIKE 'SD\_%'
| UNION ALL SELECT 'vin_order',COUNT(*) FROM t_vin_charging_order WHERE vin_id=1 AND code LIKE 'VD\_%'
| UNION ALL SELECT 'vin_strategy',COUNT(*) FROM t_vin_accounting_strategy_order WHERE charging_order_id IN (2095000000000020001,2095000000000020002,2095000000000020003,2095000000000020004,2095000000000020005)
| UNION ALL SELECT 'vin_strategy_detail',COUNT(*) FROM t_vin_accounting_strategy_detail_order WHERE charging_order_id IN (2095000000000020001,2095000000000020002,2095000000000020003,2095000000000020004,2095000000000020005)
| UNION ALL SELECT 'vin_period',COUNT(*) FROM t_vin_charging_order_accounting_strategy WHERE charging_order_id IN (2095000000000020001,2095000000000020002,2095000000000020003,2095000000000020004,2095000000000020005)
| UNION ALL SELECT 'vin_refund',COUNT(*) FROM t_vin_charging_order_refund WHERE charging_order_id IN (2095000000000020001,2095000000000020002,2095000000000020003,2095000000000020004,2095000000000020005)
| UNION ALL SELECT 'vin_share',COUNT(*) FROM t_vin_charging_order_share_record WHERE charging_order_code LIKE 'VD\_%';
|
|
