38 行
1.3 KiB
SQL
38 行
1.3 KiB
SQL
-- 隐藏线下收银功能（收银机）的SQL脚本
|
||
-- 收银机菜单项ID: 660
|
||
|
||
-- 1. 备份当前权限配置
|
||
CREATE TABLE IF NOT EXISTS jurisdiction_group_backup AS
|
||
SELECT * FROM jurisdiction_group WHERE jurisdiction_id LIKE '%660%';
|
||
|
||
-- 2. 从所有权限组中移除收银机权限（ID: 660）
|
||
-- 处理以660开头的情况
|
||
UPDATE jurisdiction_group
|
||
SET jurisdiction_id = REPLACE(jurisdiction_id, '660,', '')
|
||
WHERE jurisdiction_id LIKE '660,%';
|
||
|
||
-- 处理以660结尾的情况
|
||
UPDATE jurisdiction_group
|
||
SET jurisdiction_id = REPLACE(jurisdiction_id, ',660', '')
|
||
WHERE jurisdiction_id LIKE '%,660';
|
||
|
||
-- 处理660在中间的情况（已经被上面的规则处理了，但为了确保完整性）
|
||
UPDATE jurisdiction_group
|
||
SET jurisdiction_id = REPLACE(jurisdiction_id, ',660,', ',')
|
||
WHERE jurisdiction_id LIKE '%,660,%';
|
||
|
||
-- 处理只有660一个权限的情况
|
||
UPDATE jurisdiction_group
|
||
SET jurisdiction_id = ''
|
||
WHERE jurisdiction_id = '660';
|
||
|
||
-- 3. 验证修改结果
|
||
SELECT id, role_name, jurisdiction_id
|
||
FROM jurisdiction_group
|
||
WHERE jurisdiction_id LIKE '%660%';
|
||
|
||
-- 如果上面的查询没有返回结果，说明收银机权限已经成功移除
|
||
|
||
-- 4. 可选：如果需要恢复，可以使用备份表
|
||
-- INSERT INTO jurisdiction_group SELECT * FROM jurisdiction_group_backup;
|
||
-- DROP TABLE jurisdiction_group_backup; |