all-project/script/zsjy-job-position-menu.sql

-- ==================================================
-- 招生就业模块 - 招聘信息管理菜单配置
-- 创建日期: 2025-01-26
-- 说明: 参考企业信息管理菜单配置
-- ==================================================

-- 1. 招聘信息管理父菜单（招聘管理）
INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark)
VALUES (8710, '招聘管理', 8000, 6, 'recruitment', null, null, 1, 0, 'M', '0', '0', '', 'post', 103, 1, NOW(), null, null, '招聘管理菜单');

-- 2. 招聘信息子菜单（招聘岗位）
INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark)
VALUES (8711, '招聘岗位', 8710, 1, 'position', 'zsjy/jobPosition/index', null, 1, 0, 'C', '0', '0', 'zsjy:position:list', 'job', 103, 1, NOW(), null, null, '招聘岗位菜单');

-- 3. 招聘岗位按钮权限
-- 3.1 查询权限
INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark)
VALUES (8712, '招聘岗位查询', 8711, 1, '', '', null, 1, 0, 'F', '0', '0', 'zsjy:position:query', '#', 103, 1, NOW(), null, null, '');

-- 3.2 新增权限
INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark)
VALUES (8713, '招聘岗位新增', 8711, 2, '', '', null, 1, 0, 'F', '0', '0', 'zsjy:position:add', '#', 103, 1, NOW(), null, null, '');

-- 3.3 修改权限
INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark)
VALUES (8714, '招聘岗位修改', 8711, 3, '', '', null, 1, 0, 'F', '0', '0', 'zsjy:position:edit', '#', 103, 1, NOW(), null, null, '');

-- 3.4 删除权限
INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark)
VALUES (8715, '招聘岗位删除', 8711, 4, '', '', null, 1, 0, 'F', '0', '0', 'zsjy:position:remove', '#', 103, 1, NOW(), null, null, '');

-- 3.5 导出权限
INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark)
VALUES (8716, '招聘岗位导出', 8711, 5, '', '', null, 1, 0, 'F', '0', '0', 'zsjy:position:export', '#', 103, 1, NOW(), null, null, '');

-- 4. 招聘海报子菜单
INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark)
VALUES (8720, '招聘海报', 8710, 2, 'poster', 'zsjy/recruitmentPoster/index', null, 1, 0, 'C', '0', '0', 'zsjy:poster:list', 'picture', 103, 1, NOW(), null, null, '招聘海报菜单');

-- 5. 招聘海报按钮权限
-- 5.1 查询权限
INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark)
VALUES (8721, '招聘海报查询', 8720, 1, '', '', null, 1, 0, 'F', '0', '0', 'zsjy:poster:query', '#', 103, 1, NOW(), null, null, '');

-- 5.2 新增权限
INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark)
VALUES (8722, '招聘海报新增', 8720, 2, '', '', null, 1, 0, 'F', '0', '0', 'zsjy:poster:add', '#', 103, 1, NOW(), null, null, '');

-- 5.3 修改权限
INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark)
VALUES (8723, '招聘海报修改', 8720, 3, '', '', null, 1, 0, 'F', '0', '0', 'zsjy:poster:edit', '#', 103, 1, NOW(), null, null, '');

-- 5.4 删除权限
INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark)
VALUES (8724, '招聘海报删除', 8720, 4, '', '', null, 1, 0, 'F', '0', '0', 'zsjy:poster:remove', '#', 103, 1, NOW(), null, null, '');

-- 5.5 导出权限
INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark)
VALUES (8725, '招聘海报导出', 8720, 5, '', '', null, 1, 0, 'F', '0', '0', 'zsjy:poster:export', '#', 103, 1, NOW(), null, null, '');

-- ==================================================
-- 为管理员角色分配招聘管理相关权限
-- ==================================================

-- 为管理员角色（role_id=1）分配招聘管理菜单权限
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 8710);  -- 招聘管理
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 8711);  -- 招聘岗位
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 8712);  -- 招聘岗位查询
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 8713);  -- 招聘岗位新增
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 8714);  -- 招聘岗位修改
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 8715);  -- 招聘岗位删除
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 8716);  -- 招聘岗位导出
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 8720);  -- 招聘海报
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 8721);  -- 招聘海报查询
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 8722);  -- 招聘海报新增
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 8723);  -- 招聘海报修改
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 8724);  -- 招聘海报删除
INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 8725);  -- 招聘海报导出

-- ==================================================
-- 执行前检查
-- ==================================================
-- SELECT * FROM sys_menu WHERE menu_id BETWEEN 8710 AND 8725;
-- SELECT * FROM sys_role_menu WHERE role_id = 1 AND menu_id BETWEEN 8710 AND 8725;

-- ==================================================
-- 回滚语句
-- ==================================================
-- DELETE FROM sys_role_menu WHERE role_id = 1 AND menu_id BETWEEN 8710 AND 8725;
-- DELETE FROM sys_menu WHERE menu_id BETWEEN 8710 AND 8725;