pipe-ner-server/pipe-network-service/sql/dispatch_button_perms.sql

-- =====================================================================
-- 调度模块按钮权限初始化（sys_menu，menu_type='F'）
-- 页面菜单按 component 定位，按钮按 parent_id + perms 幂等判重，可重复执行。
-- 执行后需在「系统管理-角色管理」给相关角色勾选这些按钮权限并重新登录。
-- 事务按段独立提交，失败只影响当前段。
-- 作者/日期：2026-10-16
-- =====================================================================

-- ---------- 接报管理 ----------
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '新增接报', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/jbgl' LIMIT 1), 1, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:event:add', '#', 'admin', CURRENT_TIMESTAMP, '接报管理-新增/编辑按钮'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:event:add'
                    AND parent_id = (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/jbgl' LIMIT 1));

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '编辑接报', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/jbgl' LIMIT 1), 2, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:event:edit', '#', 'admin', CURRENT_TIMESTAMP, '接报管理-编辑按钮'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:event:edit'
                    AND parent_id = (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/jbgl' LIMIT 1));

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '删除接报', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/jbgl' LIMIT 1), 3, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:event:remove', '#', 'admin', CURRENT_TIMESTAMP, '接报管理-删除按钮'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:event:remove'
                    AND parent_id = (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/jbgl' LIMIT 1));

-- ---------- 初判核实 ----------
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '事件核实', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/cphs' LIMIT 1), 1, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:event:verify', '#', 'admin', CURRENT_TIMESTAMP, '初判核实-核实按钮'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:event:verify'
                    AND parent_id = (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/cphs' LIMIT 1));

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '删除事件', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/cphs' LIMIT 1), 2, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:event:remove', '#', 'admin', CURRENT_TIMESTAMP, '初判核实-删除按钮'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:event:remove'
                    AND parent_id = (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/cphs' LIMIT 1));

-- ---------- 转接报送 ----------
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '事件转接', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/zjbs' LIMIT 1), 1, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:event:transfer', '#', 'admin', CURRENT_TIMESTAMP, '转接报送-转接按钮'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:event:transfer'
                    AND parent_id = (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/zjbs' LIMIT 1));

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '事件报送', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/zjbs' LIMIT 1), 2, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:event:report', '#', 'admin', CURRENT_TIMESTAMP, '转接报送-报送按钮'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:event:report'
                    AND parent_id = (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/zjbs' LIMIT 1));

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '删除事件', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/zjbs' LIMIT 1), 3, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:event:remove', '#', 'admin', CURRENT_TIMESTAMP, '转接报送-删除按钮'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:event:remove'
                    AND parent_id = (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/zjbs' LIMIT 1));

-- ---------- 工作催办 ----------
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '工作催办', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/gzcb' LIMIT 1), 1, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:event:urge', '#', 'admin', CURRENT_TIMESTAMP, '工作催办-催办按钮'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:event:urge'
                    AND parent_id = (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/gzcb' LIMIT 1));

-- ---------- 跟踪解除 ----------
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '开始处置', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/gzjc' LIMIT 1), 1, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:event:dispose', '#', 'admin', CURRENT_TIMESTAMP, '跟踪解除-开始处置按钮'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:event:dispose'
                    AND parent_id = (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/gzjc' LIMIT 1));

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '处置跟踪', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/gzjc' LIMIT 1), 2, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:event:track', '#', 'admin', CURRENT_TIMESTAMP, '跟踪解除-跟踪按钮'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:event:track'
                    AND parent_id = (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/gzjc' LIMIT 1));

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '事件解除', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/gzjc' LIMIT 1), 3, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:event:release', '#', 'admin', CURRENT_TIMESTAMP, '跟踪解除-解除按钮'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:event:release'
                    AND parent_id = (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/gzjc' LIMIT 1));

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '删除事件', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/gzjc' LIMIT 1), 4, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:event:remove', '#', 'admin', CURRENT_TIMESTAMP, '跟踪解除-删除按钮'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:event:remove'
                    AND parent_id = (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/gzjc' LIMIT 1));

-- ---------- 事件分级 ----------
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '新增分级', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disPlanManage/DisEventGrade' LIMIT 1), 1, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:grade:add', '#', 'admin', CURRENT_TIMESTAMP, '事件分级-新增按钮'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:grade:add'
                    AND parent_id = (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disPlanManage/DisEventGrade' LIMIT 1));

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '编辑分级', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disPlanManage/DisEventGrade' LIMIT 1), 2, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:grade:edit', '#', 'admin', CURRENT_TIMESTAMP, '事件分级-编辑按钮'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:grade:edit'
                    AND parent_id = (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disPlanManage/DisEventGrade' LIMIT 1));

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '删除分级', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disPlanManage/DisEventGrade' LIMIT 1), 3, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:grade:remove', '#', 'admin', CURRENT_TIMESTAMP, '事件分级-删除按钮'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:grade:remove'
                    AND parent_id = (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disPlanManage/DisEventGrade' LIMIT 1));

-- ---------- 预案编辑 ----------
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '新增预案', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disPlanManage/DisPlanEditing' LIMIT 1), 1, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:plan:add', '#', 'admin', CURRENT_TIMESTAMP, '预案编辑-新增按钮'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:plan:add'
                    AND parent_id = (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disPlanManage/DisPlanEditing' LIMIT 1));

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '编辑预案', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disPlanManage/DisPlanEditing' LIMIT 1), 2, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:plan:edit', '#', 'admin', CURRENT_TIMESTAMP, '预案编辑-编辑/修订按钮'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:plan:edit'
                    AND parent_id = (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disPlanManage/DisPlanEditing' LIMIT 1));

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '删除预案', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disPlanManage/DisPlanEditing' LIMIT 1), 3, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:plan:remove', '#', 'admin', CURRENT_TIMESTAMP, '预案编辑-删除按钮'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:plan:remove'
                    AND parent_id = (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disPlanManage/DisPlanEditing' LIMIT 1));

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '提交审核', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disPlanManage/DisPlanEditing' LIMIT 1), 4, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:plan:submit', '#', 'admin', CURRENT_TIMESTAMP, '预案编辑-提交审核按钮'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:plan:submit'
                    AND parent_id = (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disPlanManage/DisPlanEditing' LIMIT 1));

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '模板库维护', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disPlanManage/DisPlanEditing' LIMIT 1), 5, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:planLibrary:add', '#', 'admin', CURRENT_TIMESTAMP, '预案编辑-模板库新增/编辑'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:planLibrary:add'
                    AND parent_id = (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disPlanManage/DisPlanEditing' LIMIT 1));

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '模板库删除', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disPlanManage/DisPlanEditing' LIMIT 1), 6, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:planLibrary:remove', '#', 'admin', CURRENT_TIMESTAMP, '预案编辑-模板库删除'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:planLibrary:remove'
                    AND parent_id = (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disPlanManage/DisPlanEditing' LIMIT 1));

-- ---------- 预案审批 ----------
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '预案审批', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disPlanManage/DisPlanApproval' LIMIT 1), 1, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:plan:approve', '#', 'admin', CURRENT_TIMESTAMP, '预案审批-通过/驳回按钮'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:plan:approve'
                    AND parent_id = (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disPlanManage/DisPlanApproval' LIMIT 1));

-- ---------- 查询权限（页面列表/详情接口） ----------
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '事件查询', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disOnDuty/jbgl' LIMIT 1), 9, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:event:list', '#', 'admin', CURRENT_TIMESTAMP, '值守管理-事件列表/详情/日志查询（各页共用）'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:event:list');

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '分级查询', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disPlanManage/DisEventGrade' LIMIT 1), 9, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:grade:list', '#', 'admin', CURRENT_TIMESTAMP, '事件分级-列表查询'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:grade:list');

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '预案查询', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disPlanManage/DisPlanEditing' LIMIT 1), 9, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:plan:list', '#', 'admin', CURRENT_TIMESTAMP, '预案编辑/审批-列表详情版本查询'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:plan:list');

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type,
                      visible, status, perms, icon, create_by, create_time, remark)
SELECT '模板库查询', (SELECT menu_id FROM sys_menu WHERE component = 'subSystem/dispatch/disPlanManage/DisPlanEditing' LIMIT 1), 10, '', NULL, 1, 0, 'F',
       '0', '0', 'dispatch:planLibrary:list', '#', 'admin', CURRENT_TIMESTAMP, '预案模板库-列表查询'
 WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'dispatch:planLibrary:list');