water/server/plugin/saiadmin/db/20260902_fix_merchant_menu_encoding.sql

-- Repair merchant menu names that were imported through a non-UTF-8 SQL client.
-- Safe to run repeatedly.

SET NAMES utf8mb4;

UPDATE `sa_system_menu`
SET
    `name` = CASE `code`
        WHEN 'MerchantWithdrawalSettingRead' THEN '商户提现更新配置'
        WHEN 'MerchantWithdrawalSettingUpdate' THEN '保存商户提现更新配置'
        WHEN 'MerchantStatistics' THEN '数据统计'
        WHEN 'MerchantStatisticsRead' THEN '商户数据统计'
        WHEN 'MerchantStatisticsExport' THEN '导出商户数据统计'
        ELSE `name`
    END,
    `remark` = CASE `code`
        WHEN 'MerchantWithdrawalSettingRead' THEN '读取有权访问商户的提现更新设置'
        WHEN 'MerchantWithdrawalSettingUpdate' THEN '保存实时或每月定时更新方式'
        WHEN 'MerchantStatistics' THEN '商户每日交易、收益、订单、使用率及支付渠道统计'
        WHEN 'MerchantStatisticsRead' THEN '读取有权访问商户的每日统计'
        WHEN 'MerchantStatisticsExport' THEN '导出有权访问商户的每日统计'
        ELSE `remark`
    END,
    `update_time` = NOW()
WHERE `code` IN (
    'MerchantWithdrawalSettingRead',
    'MerchantWithdrawalSettingUpdate',
    'MerchantStatistics',
    'MerchantStatisticsRead',
    'MerchantStatisticsExport'
)
AND `delete_time` IS NULL;