yhlxj/docs/sql/20261021-refund-permissions.sql

-- Explicit comparison collation avoids MySQL 1267 across database/session defaults.
-- Set the existing order-management parent menu ID before running.
SET @refund_parent = NULL;
START TRANSACTION;
INSERT INTO cms_menu (title,menu_name,perms,type,path,order_by,parent_id,created_time,update_time)
SELECT p.title,p.perms,p.perms,'button','',p.sort_num,m.id,NOW(),NOW()
FROM (SELECT '人工退款' title,'order:refund' perms,1 sort_num UNION ALL SELECT '余额转原渠道退款','order:refundTransfer',2) p
JOIN cms_menu m ON m.id=@refund_parent AND m.type<>'button'
WHERE NOT EXISTS (SELECT 1 FROM cms_menu e WHERE e.perms = CONVERT(p.perms USING utf8mb4) COLLATE utf8mb4_unicode_ci);
INSERT INTO cms_role_menu (role_id,menu_id,created_time,update_time)
SELECT r.id,m.id,NOW(),NOW() FROM cms_role r JOIN cms_menu m ON m.perms IN ('order:refund','order:refundTransfer')
WHERE r.role_name='root' AND NOT EXISTS (SELECT 1 FROM cms_role_menu e WHERE e.role_id=r.id AND e.menu_id=m.id);
COMMIT;
SELECT p.perms,m.id,IF(m.id IS NULL,'MISSING','OK') result
FROM (SELECT 'order:refund' perms UNION ALL SELECT 'order:refundTransfer') p LEFT JOIN cms_menu m ON m.perms = CONVERT(p.perms USING utf8mb4) COLLATE utf8mb4_unicode_ci;
-- Both rows must be OK. Assign other roles explicitly, refresh permissions and re-login.