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

-- 人事管理模块菜单 (MySQL版本 - 修复版)
-- 修改日期: 2025-07-10

-- 使用雪花算法生成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, 'job', 'rs/job/index', '', 1, 0, 'C', '0', '0', 'rs:job:list', 'job', 1, now(), null, null, '职位管理菜单');

-- 获取职位管理菜单ID
SET @jobMenuId = @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, '职位管理查询', @jobMenuId, 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, '职位管理新增', @jobMenuId, 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, '职位管理修改', @jobMenuId, 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, '职位管理删除', @jobMenuId, 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, '职位管理导出', @jobMenuId, 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, '招聘中心', @parentId, 2, 'job/public', 'rs/job/public', '', 1, 0, 'C', '0', '0', '', 'list', 1, now(), null, null, '招聘中心菜单');
SET @publicJobMenu = @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, 3, 'application', 'rs/application/index', '', 1, 0, 'C', '0', '0', 'rs:application:list', 'form', 1, now(), null, null, '申请管理菜单');

-- 获取申请管理菜单ID
SET @appMenuId = @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, '申请管理查询', @appMenuId, 1, '', '', '', 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, '申请管理新增', @appMenuId, 2, '', '', '', 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, '申请管理修改', @appMenuId, 3, '', '', '', 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, '申请管理删除', @appMenuId, 4, '', '', '', 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, '申请管理导出', @appMenuId, 5, '', '', '', 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, '应聘者管理', @parentId, 4, 'applicant', 'rs/applicant/index', '', 1, 0, 'C', '0', '0', 'rs:applicant:list', 'user', 1, now(), null, null, '应聘者管理菜单');

-- 获取应聘者管理菜单ID
SET @applicantMenuId = @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, '应聘者管理查询', @applicantMenuId, 1, '', '', '', 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, '应聘者管理新增', @applicantMenuId, 2, '', '', '', 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, '应聘者管理修改', @applicantMenuId, 3, '', '', '', 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, '应聘者管理删除', @applicantMenuId, 4, '', '', '', 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, '教育经历管理', @parentId, 5, 'education', 'rs/education/index', '', 1, 0, 'C', '0', '0', 'rs:education:list', 'education', 1, now(), null, null, '教育经历管理菜单');

-- 获取教育经历管理菜单ID
SET @eduMenuId = @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, '教育经历管理查询', @eduMenuId, 1, '', '', '', 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, '教育经历管理新增', @eduMenuId, 2, '', '', '', 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, '教育经历管理修改', @eduMenuId, 3, '', '', '', 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, '教育经历管理删除', @eduMenuId, 4, '', '', '', 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, '工作经历管理', @parentId, 6, 'experience', 'rs/experience/index', '', 1, 0, 'C', '0', '0', 'rs:experience:list', 'experience', 1, now(), null, null, '工作经历管理菜单');

-- 获取工作经历管理菜单ID
SET @expMenuId = @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, '工作经历管理查询', @expMenuId, 1, '', '', '', 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, '工作经历管理新增', @expMenuId, 2, '', '', '', 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, '工作经历管理修改', @expMenuId, 3, '', '', '', 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, '工作经历管理删除', @expMenuId, 4, '', '', '', 1, 0, 'F', '0', '0', 'rs:experience:remove', '#', 1, now(), null, null, '');
SET @expRemove = @baseMenuId;
SET @baseMenuId = @baseMenuId + 1;