all-project/docs/设计文档/database/menu_fix_script.sql

-- 删除后勤管理菜单及其子菜单
DELETE FROM sys_menu WHERE menu_id = 1937078443615322113 OR parent_id = 1937078443615322113;

-- 添加人事管理菜单
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query_param, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark) 
VALUES (1939078443615322114, '人事管理', 0, 1, 'rs', NULL, NULL, 1, 0, 'M', '0', '0', NULL, 'peoples', 103, 1, NOW(), 1, NOW(), '人事管理');

-- 添加招聘公告菜单
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query_param, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark) 
VALUES (1939078443615322115, '招聘公告', 1939078443615322114, 1, 'job', 'rs/job/index', NULL, 1, 0, 'C', '0', '0', 'rs:job:list', 'job', 103, 1, NOW(), 1, NOW(), '招聘公告管理');

-- 添加招聘公告按钮权限
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query_param, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark) 
VALUES 
(1939078443615322116, '招聘公告查询', 1939078443615322115, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'rs:job:query', '#', 103, 1, NOW(), 1, NOW(), ''),
(1939078443615322117, '招聘公告新增', 1939078443615322115, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'rs:job:add', '#', 103, 1, NOW(), 1, NOW(), ''),
(1939078443615322118, '招聘公告修改', 1939078443615322115, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'rs:job:edit', '#', 103, 1, NOW(), 1, NOW(), ''),
(1939078443615322119, '招聘公告删除', 1939078443615322115, 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'rs:job:remove', '#', 103, 1, NOW(), 1, NOW(), '');

-- 应聘管理菜单
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query_param, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark) 
VALUES (1939078443615322120, '应聘管理', 1939078443615322114, 2, 'application', 'rs/application/index', NULL, 1, 0, 'C', '0', '0', 'rs:application:list', 'form', 103, 1, NOW(), 1, NOW(), '应聘申请管理');

-- 添加应聘管理按钮权限
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query_param, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark) 
VALUES 
(1939078443615322121, '应聘查询', 1939078443615322120, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'rs:application:query', '#', 103, 1, NOW(), 1, NOW(), ''),
(1939078443615322122, '应聘修改', 1939078443615322120, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'rs:application:edit', '#', 103, 1, NOW(), 1, NOW(), ''),
(1939078443615322123, '应聘删除', 1939078443615322120, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'rs:application:remove', '#', 103, 1, NOW(), 1, NOW(), ''),
(1939078443615322124, '应聘导出', 1939078443615322120, 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'rs:application:export', '#', 103, 1, NOW(), 1, NOW(), '');