-- 刷卡充电订单与 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\_%';