-- ===================================================== -- 需求一 客户档案 —— 「仅销售 / 内勤 / 财务可查看编辑」权限配置(幂等) -- 说明: -- 1) 角色与"角色-菜单"授权属于【环境数据】,换库不会自动带过去,需在目标环境执行本脚本。 -- 2) 必须把下面的角色名改成【客户环境里实际的角色名】,否则不生效(本机 .sql 里的名字只是占位)。 -- 3) 菜单用 permission/component 匹配('crm:customer:%' + 'crm/customer/index'),不写死菜单 id,跨环境更稳。 -- 4) 「仅」这三个角色:第 2 段用于从其他角色回收客户管理菜单(默认注释掉,确认后再放开)。 -- 适用库:目标租户所在库。可重复执行。 -- ===================================================== -- 0) 可选:确保三个角色存在(若客户后台已建好对应角色,可跳过本段) -- INSERT INTO system_role (name, code, sort, data_scope, status, type, remark, creator, create_time, updater, update_time, deleted, tenant_id) -- SELECT '销售', 'sale_role', 1, 1, 0, 2, '客户档案-销售', '1', NOW(), '1', NOW(), b'0', 1 -- WHERE NOT EXISTS (SELECT 1 FROM system_role WHERE name='销售' AND deleted=b'0' AND tenant_id=1); -- INSERT INTO system_role (name, code, sort, data_scope, status, type, remark, creator, create_time, updater, update_time, deleted, tenant_id) -- SELECT '内勤', 'office_role', 2, 1, 0, 2, '客户档案-内勤', '1', NOW(), '1', NOW(), b'0', 1 -- WHERE NOT EXISTS (SELECT 1 FROM system_role WHERE name='内勤' AND deleted=b'0' AND tenant_id=1); -- INSERT INTO system_role (name, code, sort, data_scope, status, type, remark, creator, create_time, updater, update_time, deleted, tenant_id) -- SELECT '财务', 'finance_role', 3, 1, 0, 2, '客户档案-财务', '1', NOW(), '1', NOW(), b'0', 1 -- WHERE NOT EXISTS (SELECT 1 FROM system_role WHERE name='财务' AND deleted=b'0' AND tenant_id=1); -- 1) 授予:把「客户管理」页面 + 「crm:customer:*」按钮 授予 销售 / 内勤 / 财务 -- ⚠️ 把 IN (...) 改成客户实际角色名 INSERT INTO `system_role_menu` (`role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) SELECT r.`id`, m.`id`, '1', NOW(), '1', NOW(), b'0', r.`tenant_id` FROM `system_role` r JOIN `system_menu` m ON (m.`permission` LIKE 'crm:customer:%' OR m.`component` = 'crm/customer/index') WHERE r.`name` IN ('销售', '内勤', '财务') AND r.`deleted` = b'0' AND m.`deleted` = b'0' AND m.`status` = 0 AND NOT EXISTS (SELECT 1 FROM `system_role_menu` rm WHERE rm.`role_id` = r.`id` AND rm.`menu_id` = m.`id` AND rm.`deleted` = b'0'); -- 2) 回收(可选,达成“仅”这三个角色):从其他角色移除客户管理菜单(超级管理员除外) -- 确认后再取消下面这段注释执行。 -- UPDATE `system_role_menu` rm -- JOIN `system_role` r ON r.`id` = rm.`role_id` -- JOIN `system_menu` m ON m.`id` = rm.`menu_id` -- SET rm.`deleted` = b'1', rm.`update_time` = NOW() -- WHERE (m.`permission` LIKE 'crm:customer:%' OR m.`component` = 'crm/customer/index') -- AND rm.`deleted` = b'0' -- AND r.`code` <> 'super_admin' -- AND r.`name` NOT IN ('销售', '内勤', '财务'); -- 3) 执行后自查:各角色拥有「客户管理」菜单数量(应只有目标角色 + 超级管理员有) -- SELECT r.id, r.name, COUNT(rm.menu_id) AS customer_menu_cnt -- FROM system_role r -- LEFT JOIN system_role_menu rm ON rm.role_id = r.id AND rm.deleted = b'0' -- AND rm.menu_id IN (SELECT id FROM system_menu WHERE permission LIKE 'crm:customer:%' OR component='crm/customer/index') -- WHERE r.deleted = b'0' -- GROUP BY r.id, r.name ORDER BY r.id;