36 lines
810 B
MySQL
36 lines
810 B
MySQL
|
-- 删除工单管理下所有错误的子菜单
|
||
|
|
-- 这些子菜单导致路由跳转错误
|
||
|
|
|
||
|
|
-- 查看所有工单管理的子菜单
|
||
|
|
SELECT
|
||
|
|
menu_id,
|
||
|
|
menu_name,
|
||
|
|
parent_id,
|
||
|
|
path,
|
||
|
|
component,
|
||
|
|
query,
|
||
|
|
menu_type
|
||
|
|
FROM sys_menu
|
||
|
|
WHERE parent_id = 2098 -- 工单管理的menu_id
|
||
|
|
ORDER BY order_num;
|
||
|
|
|
||
|
|
-- 删除所有状态相关的子菜单
|
||
|
|
-- 注意：请先确认上面的查询结果，再执行删除操作
|
||
|
|
DELETE FROM sys_menu
|
||
|
|
WHERE parent_id = 2098
|
||
|
|
AND menu_name IN ('进行中', '已完成', '待领取', '一审中', '二审中', '三审中', '全部工单');
|
||
|
|
|
||
|
|
-- 验证删除结果
|
||
|
|
SELECT
|
||
|
|
menu_id,
|
||
|
|
menu_name,
|
||
|
|
parent_id,
|
||
|
|
path,
|
||
|
|
component,
|
||
|
|
menu_type
|
||
|
|
FROM sys_menu
|
||
|
|
WHERE parent_id = 2098
|
||
|
|
ORDER BY order_num;
|
||
|
|
|
||
|
|
-- 应该只剩下"测试工单"这一个子菜单
|