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

-- 人事管理模块菜单

-- 人事管理顶级菜单
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '人事管理', 0, 50, 'rs', null, '', 1, 0, 'M', '0', '0', '', 'peoples', 1, sysdate(), null, null, '人事管理目录');

-- 获取人事管理顶级菜单ID
declare @parentId int = (SELECT menu_id FROM sys_menu WHERE menu_name = '人事管理' AND parent_id = 0);

-- 职位管理菜单
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '职位管理', @parentId, 1, 'job', 'rs/job/index', '', 1, 0, 'C', '0', '0', 'rs:job:list', 'job', 1, sysdate(), null, null, '职位管理菜单');

-- 获取职位管理菜单ID
declare @jobMenuId int = (SELECT menu_id FROM sys_menu WHERE menu_name = '职位管理' AND parent_id = @parentId);

-- 职位管理按钮权限
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '职位管理查询', @jobMenuId, 1, '', '', '', 1, 0, 'F', '0', '0', 'rs:job:query', '#', 1, sysdate(), null, null, '');
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '职位管理新增', @jobMenuId, 2, '', '', '', 1, 0, 'F', '0', '0', 'rs:job:add', '#', 1, sysdate(), null, null, '');
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '职位管理修改', @jobMenuId, 3, '', '', '', 1, 0, 'F', '0', '0', 'rs:job:edit', '#', 1, sysdate(), null, null, '');
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '职位管理删除', @jobMenuId, 4, '', '', '', 1, 0, 'F', '0', '0', 'rs:job:remove', '#', 1, sysdate(), null, null, '');
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '职位管理导出', @jobMenuId, 5, '', '', '', 1, 0, 'F', '0', '0', 'rs:job:export', '#', 1, sysdate(), null, null, '');

-- 招聘中心菜单
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '招聘中心', @parentId, 2, 'job/public', 'rs/job/public', '', 1, 0, 'C', '0', '0', '', 'list', 1, sysdate(), null, null, '招聘中心菜单');

-- 申请管理菜单
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '申请管理', @parentId, 3, 'application', 'rs/application/index', '', 1, 0, 'C', '0', '0', 'rs:application:list', 'form', 1, sysdate(), null, null, '申请管理菜单');

-- 获取申请管理菜单ID
declare @appMenuId int = (SELECT menu_id FROM sys_menu WHERE menu_name = '申请管理' AND parent_id = @parentId);

-- 申请管理按钮权限
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '申请管理查询', @appMenuId, 1, '', '', '', 1, 0, 'F', '0', '0', 'rs:application:query', '#', 1, sysdate(), null, null, '');
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '申请管理新增', @appMenuId, 2, '', '', '', 1, 0, 'F', '0', '0', 'rs:application:add', '#', 1, sysdate(), null, null, '');
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '申请管理修改', @appMenuId, 3, '', '', '', 1, 0, 'F', '0', '0', 'rs:application:edit', '#', 1, sysdate(), null, null, '');
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '申请管理删除', @appMenuId, 4, '', '', '', 1, 0, 'F', '0', '0', 'rs:application:remove', '#', 1, sysdate(), null, null, '');
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '申请管理导出', @appMenuId, 5, '', '', '', 1, 0, 'F', '0', '0', 'rs:application:export', '#', 1, sysdate(), null, null, '');

-- 应聘者管理菜单
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '应聘者管理', @parentId, 4, 'applicant', 'rs/applicant/index', '', 1, 0, 'C', '0', '0', 'rs:applicant:list', 'user', 1, sysdate(), null, null, '应聘者管理菜单');

-- 获取应聘者管理菜单ID
declare @applicantMenuId int = (SELECT menu_id FROM sys_menu WHERE menu_name = '应聘者管理' AND parent_id = @parentId);

-- 应聘者管理按钮权限
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '应聘者管理查询', @applicantMenuId, 1, '', '', '', 1, 0, 'F', '0', '0', 'rs:applicant:query', '#', 1, sysdate(), null, null, '');
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '应聘者管理新增', @applicantMenuId, 2, '', '', '', 1, 0, 'F', '0', '0', 'rs:applicant:add', '#', 1, sysdate(), null, null, '');
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '应聘者管理修改', @applicantMenuId, 3, '', '', '', 1, 0, 'F', '0', '0', 'rs:applicant:edit', '#', 1, sysdate(), null, null, '');
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '应聘者管理删除', @applicantMenuId, 4, '', '', '', 1, 0, 'F', '0', '0', 'rs:applicant:remove', '#', 1, sysdate(), null, null, '');

-- 教育经历管理菜单
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '教育经历管理', @parentId, 5, 'education', 'rs/education/index', '', 1, 0, 'C', '0', '0', 'rs:education:list', 'education', 1, sysdate(), null, null, '教育经历管理菜单');

-- 获取教育经历管理菜单ID
declare @eduMenuId int = (SELECT menu_id FROM sys_menu WHERE menu_name = '教育经历管理' AND parent_id = @parentId);

-- 教育经历管理按钮权限
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '教育经历管理查询', @eduMenuId, 1, '', '', '', 1, 0, 'F', '0', '0', 'rs:education:query', '#', 1, sysdate(), null, null, '');
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '教育经历管理新增', @eduMenuId, 2, '', '', '', 1, 0, 'F', '0', '0', 'rs:education:add', '#', 1, sysdate(), null, null, '');
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '教育经历管理修改', @eduMenuId, 3, '', '', '', 1, 0, 'F', '0', '0', 'rs:education:edit', '#', 1, sysdate(), null, null, '');
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '教育经历管理删除', @eduMenuId, 4, '', '', '', 1, 0, 'F', '0', '0', 'rs:education:remove', '#', 1, sysdate(), null, null, '');

-- 工作经历管理菜单
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '工作经历管理', @parentId, 6, 'experience', 'rs/experience/index', '', 1, 0, 'C', '0', '0', 'rs:experience:list', 'experience', 1, sysdate(), null, null, '工作经历管理菜单');

-- 获取工作经历管理菜单ID
declare @expMenuId int = (SELECT menu_id FROM sys_menu WHERE menu_name = '工作经历管理' AND parent_id = @parentId);

-- 工作经历管理按钮权限
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '工作经历管理查询', @expMenuId, 1, '', '', '', 1, 0, 'F', '0', '0', 'rs:experience:query', '#', 1, sysdate(), null, null, '');
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '工作经历管理新增', @expMenuId, 2, '', '', '', 1, 0, 'F', '0', '0', 'rs:experience:add', '#', 1, sysdate(), null, null, '');
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '工作经历管理修改', @expMenuId, 3, '', '', '', 1, 0, 'F', '0', '0', 'rs:experience:edit', '#', 1, sysdate(), null, null, '');
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 (next value for SYSTEM_SEQUENCE_D481026F_F2E2_4DE9_897F_53C66256C4F5, '工作经历管理删除', @expMenuId, 4, '', '', '', 1, 0, 'F', '0', '0', 'rs:experience:remove', '#', 1, sysdate(), null, null, '');