zkxw/docs/sql/2026-05-25-channel-service-order-txn-void-fields.sql

-- 渠道服务订单操作流水：财务确认人、作废人、作废时间
ALTER TABLE `biz_channel_service_order_txn`
  ADD COLUMN `finance_confirm_by` varchar(64) DEFAULT NULL COMMENT '财务确认人ID' AFTER `finance_confirm_time`,
  ADD COLUMN `void_by` varchar(64) DEFAULT NULL COMMENT '作废人ID' AFTER `finance_remark`,
  ADD COLUMN `void_time` datetime DEFAULT NULL COMMENT '作废时间' AFTER `void_by`;

-- 历史已确认流水：用 update_by 回填确认人
UPDATE `biz_channel_service_order_txn`
SET `finance_confirm_by` = `update_by`
WHERE `txn_status` = 'yqr' AND `finance_confirm_time` IS NOT NULL AND `finance_confirm_by` IS NULL;

-- 历史已作废流水：用 update_by / update_time 回填（仅曾提交财务的流水视为财务作废）
UPDATE `biz_channel_service_order_txn`
SET `void_by` = `update_by`, `void_time` = `update_time`
WHERE `txn_status` = 'yzf' AND `finance_submit_time` IS NOT NULL AND `void_by` IS NULL;