-- 修复区县代理「单独佣金」覆盖等级配置导致佣金偏高
-- 现象：等级配置 1%，实际按 1.5% 计算（528 × 1.5% = 7.92，应为 528 × 1% = 5.28）
-- 原因：代理记录 commission_type/commission_rate 有值时会优先于等级通用配置
-- 说明：已入账的历史订单不会自动重算，仅影响后续新订单

SET @ts = UNIX_TIMESTAMP();

-- 清除测试区县代理(910003)的单独佣金，改回跟随等级
UPDATE `fa_shopro_regional_agent`
SET `commission_type` = NULL,
    `commission_rate` = NULL,
    `commission_money` = NULL,
    `updatetime` = @ts
WHERE `user_id` = 910003
  AND `status` = 'normal';

-- 若后台「区域-区县代理」不是 910003，可按昵称/区域查找后清除：
-- UPDATE `fa_shopro_regional_agent`
-- SET `commission_type` = NULL, `commission_rate` = NULL, `commission_money` = NULL, `updatetime` = @ts
-- WHERE `area_level` = 3 AND `area_name` LIKE '%南明%' AND `commission_type` IS NOT NULL;

SELECT id, user_id, area_name, area_level, commission_type, commission_rate, commission_money
FROM `fa_shopro_regional_agent`
WHERE `status` = 'normal' AND `area_level` = 3;