all-project/docs/设计文档/database/rs-menu-merged.sql

-- 人事管理模块菜单 (合并版本)
-- 修改日期: 2025-07-15
-- 说明: 将原有的多个子菜单合并为一个统一的"招聘管理"菜单

-- 使用雪花算法生成ID (这里使用简化的固定ID，实际应用中应使用雪花算法)
SET @baseMenuId = 2050;  -- 基础ID，每个新菜单递增

-- 人事管理顶级菜单
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_by, create_time, update_by, update_time, remark)
VALUES (@baseMenuId, '人事管理', 0, 50, 'rs', null, '', 1, 0, 'M', '0', '0', '', 'peoples', 1, now(), null, null, '人事管理目录');

-- 获取人事管理顶级菜单ID
SET @parentId = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;

-- 招聘管理菜单 (合并后的单一入口)
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_by, create_time, update_by, update_time, remark)
VALUES (@baseMenuId, '招聘管理', @parentId, 1, 'index', 'rs/index', '', 1, 0, 'C', '0', '0', 'rs:recruitment:list', 'job', 1, now(), null, null, '招聘管理菜单(统一入口)');

-- 获取招聘管理菜单ID
SET @recruitmentMenuId = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;

-- 招聘管理按钮权限 (组合了原有多个子菜单的权限)

-- 职位管理相关权限
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_by, create_time, update_by, update_time, remark)
VALUES (@baseMenuId, '职位管理查询', @recruitmentMenuId, 1, '', '', '', 1, 0, 'F', '0', '0', 'rs:job:query', '#', 1, now(), null, null, '');
SET @jobQuery = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;

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_by, create_time, update_by, update_time, remark)
VALUES (@baseMenuId, '职位管理新增', @recruitmentMenuId, 2, '', '', '', 1, 0, 'F', '0', '0', 'rs:job:add', '#', 1, now(), null, null, '');
SET @jobAdd = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;

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_by, create_time, update_by, update_time, remark)
VALUES (@baseMenuId, '职位管理修改', @recruitmentMenuId, 3, '', '', '', 1, 0, 'F', '0', '0', 'rs:job:edit', '#', 1, now(), null, null, '');
SET @jobEdit = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;

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_by, create_time, update_by, update_time, remark)
VALUES (@baseMenuId, '职位管理删除', @recruitmentMenuId, 4, '', '', '', 1, 0, 'F', '0', '0', 'rs:job:remove', '#', 1, now(), null, null, '');
SET @jobRemove = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;

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_by, create_time, update_by, update_time, remark)
VALUES (@baseMenuId, '职位管理导出', @recruitmentMenuId, 5, '', '', '', 1, 0, 'F', '0', '0', 'rs:job:export', '#', 1, now(), null, null, '');
SET @jobExport = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;

-- 申请管理相关权限
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_by, create_time, update_by, update_time, remark)
VALUES (@baseMenuId, '申请管理查询', @recruitmentMenuId, 6, '', '', '', 1, 0, 'F', '0', '0', 'rs:application:query', '#', 1, now(), null, null, '');
SET @appQuery = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;

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_by, create_time, update_by, update_time, remark)
VALUES (@baseMenuId, '申请管理新增', @recruitmentMenuId, 7, '', '', '', 1, 0, 'F', '0', '0', 'rs:application:add', '#', 1, now(), null, null, '');
SET @appAdd = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;

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_by, create_time, update_by, update_time, remark)
VALUES (@baseMenuId, '申请管理修改', @recruitmentMenuId, 8, '', '', '', 1, 0, 'F', '0', '0', 'rs:application:edit', '#', 1, now(), null, null, '');
SET @appEdit = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;

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_by, create_time, update_by, update_time, remark)
VALUES (@baseMenuId, '申请管理删除', @recruitmentMenuId, 9, '', '', '', 1, 0, 'F', '0', '0', 'rs:application:remove', '#', 1, now(), null, null, '');
SET @appRemove = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;

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_by, create_time, update_by, update_time, remark)
VALUES (@baseMenuId, '申请管理导出', @recruitmentMenuId, 10, '', '', '', 1, 0, 'F', '0', '0', 'rs:application:export', '#', 1, now(), null, null, '');
SET @appExport = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;

-- 应聘者管理相关权限
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_by, create_time, update_by, update_time, remark)
VALUES (@baseMenuId, '应聘者管理查询', @recruitmentMenuId, 11, '', '', '', 1, 0, 'F', '0', '0', 'rs:applicant:query', '#', 1, now(), null, null, '');
SET @applicantQuery = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;

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_by, create_time, update_by, update_time, remark)
VALUES (@baseMenuId, '应聘者管理新增', @recruitmentMenuId, 12, '', '', '', 1, 0, 'F', '0', '0', 'rs:applicant:add', '#', 1, now(), null, null, '');
SET @applicantAdd = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;

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_by, create_time, update_by, update_time, remark)
VALUES (@baseMenuId, '应聘者管理修改', @recruitmentMenuId, 13, '', '', '', 1, 0, 'F', '0', '0', 'rs:applicant:edit', '#', 1, now(), null, null, '');
SET @applicantEdit = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;

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_by, create_time, update_by, update_time, remark)
VALUES (@baseMenuId, '应聘者管理删除', @recruitmentMenuId, 14, '', '', '', 1, 0, 'F', '0', '0', 'rs:applicant:remove', '#', 1, now(), null, null, '');
SET @applicantRemove = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;

-- 教育经历管理相关权限
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_by, create_time, update_by, update_time, remark)
VALUES (@baseMenuId, '教育经历管理查询', @recruitmentMenuId, 15, '', '', '', 1, 0, 'F', '0', '0', 'rs:education:query', '#', 1, now(), null, null, '');
SET @eduQuery = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;

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_by, create_time, update_by, update_time, remark)
VALUES (@baseMenuId, '教育经历管理新增', @recruitmentMenuId, 16, '', '', '', 1, 0, 'F', '0', '0', 'rs:education:add', '#', 1, now(), null, null, '');
SET @eduAdd = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;

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_by, create_time, update_by, update_time, remark)
VALUES (@baseMenuId, '教育经历管理修改', @recruitmentMenuId, 17, '', '', '', 1, 0, 'F', '0', '0', 'rs:education:edit', '#', 1, now(), null, null, '');
SET @eduEdit = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;

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_by, create_time, update_by, update_time, remark)
VALUES (@baseMenuId, '教育经历管理删除', @recruitmentMenuId, 18, '', '', '', 1, 0, 'F', '0', '0', 'rs:education:remove', '#', 1, now(), null, null, '');
SET @eduRemove = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;

-- 工作经历管理相关权限
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_by, create_time, update_by, update_time, remark)
VALUES (@baseMenuId, '工作经历管理查询', @recruitmentMenuId, 19, '', '', '', 1, 0, 'F', '0', '0', 'rs:experience:query', '#', 1, now(), null, null, '');
SET @expQuery = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;

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_by, create_time, update_by, update_time, remark)
VALUES (@baseMenuId, '工作经历管理新增', @recruitmentMenuId, 20, '', '', '', 1, 0, 'F', '0', '0', 'rs:experience:add', '#', 1, now(), null, null, '');
SET @expAdd = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;

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_by, create_time, update_by, update_time, remark)
VALUES (@baseMenuId, '工作经历管理修改', @recruitmentMenuId, 21, '', '', '', 1, 0, 'F', '0', '0', 'rs:experience:edit', '#', 1, now(), null, null, '');
SET @expEdit = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;

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_by, create_time, update_by, update_time, remark)
VALUES (@baseMenuId, '工作经历管理删除', @recruitmentMenuId, 22, '', '', '', 1, 0, 'F', '0', '0', 'rs:experience:remove', '#', 1, now(), null, null, '');
SET @expRemove = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;

-- 为管理员角色分配菜单权限
SET @adminRoleId = 1; -- 管理员角色ID

-- 删除现有管理员角色的人事管理菜单权限
DELETE FROM sys_role_menu WHERE role_id = @adminRoleId AND menu_id = @parentId;

-- 重新分配人事管理权限
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@adminRoleId, @parentId);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@adminRoleId, @recruitmentMenuId);

-- 为管理员角色分配全部按钮权限
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@adminRoleId, @jobQuery);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@adminRoleId, @jobAdd);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@adminRoleId, @jobEdit);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@adminRoleId, @jobRemove);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@adminRoleId, @jobExport);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@adminRoleId, @appQuery);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@adminRoleId, @appAdd);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@adminRoleId, @appEdit);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@adminRoleId, @appRemove);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@adminRoleId, @appExport);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@adminRoleId, @applicantQuery);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@adminRoleId, @applicantAdd);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@adminRoleId, @applicantEdit);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@adminRoleId, @applicantRemove);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@adminRoleId, @eduQuery);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@adminRoleId, @eduAdd);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@adminRoleId, @eduEdit);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@adminRoleId, @eduRemove);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@adminRoleId, @expQuery);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@adminRoleId, @expAdd);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@adminRoleId, @expEdit);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@adminRoleId, @expRemove);

-- 为普通用户角色分配部分菜单权限（可自定义）
SET @commonRoleId = 2; -- 普通用户角色ID

-- 删除现有普通用户角色的人事管理菜单权限
DELETE FROM sys_role_menu WHERE role_id = @commonRoleId AND menu_id = @parentId;

-- 分配基本浏览和申请权限
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@commonRoleId, @parentId);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@commonRoleId, @recruitmentMenuId);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@commonRoleId, @jobQuery);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@commonRoleId, @appAdd);
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (@commonRoleId, @appQuery);