water/server/plugin/saiadmin/db/20260904_seed_deposit_refund_test_data.sql

-- 本地退押管理测试数据。仅关联既有 TEST-ORDER-20260901-* 测试订单，可重复执行。

DELETE FROM `sa_deposit_refund_record`
WHERE `order_sn` LIKE 'TEST-ORDER-20260901-%';

INSERT INTO `sa_deposit_refund_record` (
    `order_id`, `order_sn`, `user_id`, `manage_agent_id`, `source`, `device_type`,
    `deposit_amount`, `consumption_amount`, `refund_amount`, `apply_time`,
    `scheduled_refund_time`, `refund_time`, `refund_type`, `status`, `remark`,
    `created_by`, `updated_by`, `create_time`, `update_time`
)
SELECT `id`, `order_sn`, `user_id`, `manage_agent_id`, `source`, `device_type`,
       29.90, 10.00, 19.90, DATE_SUB(NOW(), INTERVAL 2 HOUR),
       DATE_ADD(NOW(), INTERVAL 22 HOUR), NULL, 0, 0, '退押导出测试数据',
       1, 1, NOW(), NOW()
FROM `sa_rental_order`
WHERE `order_sn` = 'TEST-ORDER-20260901-K02'
  AND `delete_time` IS NULL;

INSERT INTO `sa_deposit_refund_record` (
    `order_id`, `order_sn`, `user_id`, `manage_agent_id`, `source`, `device_type`,
    `deposit_amount`, `consumption_amount`, `refund_amount`, `apply_time`,
    `scheduled_refund_time`, `refund_time`, `refund_type`, `status`, `remark`,
    `created_by`, `updated_by`, `create_time`, `update_time`
)
SELECT `id`, `order_sn`, `user_id`, `manage_agent_id`, `source`, `device_type`,
       20.00, 8.00, 12.00, DATE_SUB(NOW(), INTERVAL 1 DAY),
       DATE_SUB(NOW(), INTERVAL 22 HOUR), DATE_SUB(NOW(), INTERVAL 23 HOUR),
       0, 1, '退押导出测试数据', 1, 1, NOW(), NOW()
FROM `sa_rental_order`
WHERE `order_sn` = 'TEST-ORDER-20260901-PW01'
  AND `delete_time` IS NULL;

INSERT INTO `sa_deposit_refund_record` (
    `order_id`, `order_sn`, `user_id`, `manage_agent_id`, `source`, `device_type`,
    `deposit_amount`, `consumption_amount`, `refund_amount`, `apply_time`,
    `scheduled_refund_time`, `refund_time`, `refund_type`, `status`, `remark`,
    `created_by`, `updated_by`, `create_time`, `update_time`
)
SELECT `id`, `order_sn`, `user_id`, `manage_agent_id`, `source`, `device_type`,
       18.00, 6.00, 12.00, DATE_SUB(NOW(), INTERVAL 2 DAY),
       DATE_SUB(NOW(), INTERVAL 1 DAY), NULL, 1, 2, '退押导出测试数据',
       1, 1, NOW(), NOW()
FROM `sa_rental_order`
WHERE `order_sn` = 'TEST-ORDER-20260901-PW03'
  AND `delete_time` IS NULL;