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

-- =============================================
-- 招生迎新系统菜单权限配置脚本
-- 创建时间: 2025-01-20
-- 说明: 配置招生迎新系统的完整菜单结构和功能权限
-- =============================================

-- 删除现有的招生迎新菜单数据（如果存在）
DELETE FROM sys_menu WHERE menu_name LIKE '%招生迎新%' OR menu_name LIKE '%报名信息%' OR menu_name LIKE '%专业信息%' OR menu_name LIKE '%录取流程%' OR menu_name LIKE '%审核记录%' OR menu_name LIKE '%招生统计%';

-- =============================================
-- 一级菜单：招生迎新管理
-- =============================================
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 (2100, '招生迎新管理', 0, 8, 'zsjy', NULL, '', 1, 0, 'M', '0', '0', '', 'education', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2101, '报名信息管理', 2100, 1, 'enrollment', 'zsjy/enrollment/index', '', 1, 0, 'C', '0', '0', 'zsjy:enrollment:list', 'peoples', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2102, '报名信息查询', 2101, 1, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:enrollment:query', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2103, '报名信息新增', 2101, 2, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:enrollment:add', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2104, '报名信息修改', 2101, 3, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:enrollment:edit', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2105, '报名信息删除', 2101, 4, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:enrollment:remove', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2106, '报名信息导出', 2101, 5, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:enrollment:export', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2107, '报名信息导入', 2101, 6, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:enrollment:import', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2108, '报名信息审核', 2101, 7, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:enrollment:approve', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2109, '报名信息统计', 2101, 8, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:enrollment:statistics', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2110, '专业信息管理', 2100, 2, 'major', 'zsjy/major/index', '', 1, 0, 'C', '0', '0', 'zsjy:major:list', 'skill', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2111, '专业信息查询', 2110, 1, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:major:query', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2112, '专业信息新增', 2110, 2, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:major:add', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2113, '专业信息修改', 2110, 3, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:major:edit', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2114, '专业信息删除', 2110, 4, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:major:remove', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2115, '专业信息导出', 2110, 5, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:major:export', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2116, '专业启用禁用', 2110, 6, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:major:changeStatus', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2120, '录取流程管理', 2100, 3, 'process', 'zsjy/process/index', '', 1, 0, 'C', '0', '0', 'zsjy:process:list', 'cascader', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2121, '录取流程查询', 2120, 1, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:process:query', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2122, '录取流程新增', 2120, 2, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:process:add', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2123, '录取流程修改', 2120, 3, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:process:edit', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2124, '录取流程删除', 2120, 4, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:process:remove', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2125, '录取流程导出', 2120, 5, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:process:export', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2126, '流程状态更新', 2120, 6, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:process:updateStatus', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2127, '录取审批', 2120, 7, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:process:approve', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2130, '审核记录管理', 2100, 4, 'audit', 'zsjy/audit/index', '', 1, 0, 'C', '0', '0', 'zsjy:audit:list', 'documentation', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2131, '审核记录查询', 2130, 1, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:audit:query', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2132, '审核记录新增', 2130, 2, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:audit:add', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2133, '审核记录修改', 2130, 3, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:audit:edit', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2134, '审核记录删除', 2130, 4, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:audit:remove', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2135, '审核记录导出', 2130, 5, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:audit:export', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2136, '审核统计', 2130, 6, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:audit:statistics', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2140, '招生统计分析', 2100, 5, 'statistics', 'zsjy/statistics/index', '', 1, 0, 'C', '0', '0', 'zsjy:statistics:list', 'chart', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2141, '统计数据查询', 2140, 1, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:statistics:query', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2142, '统计数据新增', 2140, 2, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:statistics:add', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2143, '统计数据修改', 2140, 3, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:statistics:edit', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2144, '统计数据删除', 2140, 4, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:statistics:remove', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2145, '统计数据导出', 2140, 5, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:statistics:export', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2146, '报名统计概览', 2140, 6, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:statistics:overview', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2147, '专业统计', 2140, 7, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:statistics:major', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2148, '录取进度统计', 2140, 8, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:statistics:progress', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2149, '地区分布统计', 2140, 9, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:statistics:region', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2150, '性别分布统计', 2140, 10, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:statistics:gender', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2151, '年龄分布统计', 2140, 11, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:statistics:age', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2152, '时间趋势统计', 2140, 12, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:statistics:trend', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2153, '刷新统计数据', 2140, 13, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:statistics:refresh', '#', 'admin', NOW(), 'admin', 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_by, create_time, update_by, update_time, remark) 
VALUES (2154, '生成统计报表', 2140, 14, '', '', '', 1, 0, 'F', '0', '0', 'zsjy:statistics:report', '#', 'admin', NOW(), 'admin', NOW(), '');

-- =============================================
-- 角色权限配置：为超级管理员分配权限
-- =============================================
-- 获取超级管理员角色ID（通常为1）
INSERT INTO sys_role_menu (role_id, menu_id) 
SELECT 1, menu_id FROM sys_menu WHERE menu_id BETWEEN 2100 AND 2154;

COMMIT;

-- =============================================
-- 菜单权限配置完成说明
-- =============================================
-- 1. 已创建招生迎新管理一级菜单
-- 2. 已创建5个二级功能菜单：
--    - 报名信息管理（9个功能权限）
--    - 专业信息管理（6个功能权限）
--    - 录取流程管理（7个功能权限）
--    - 审核记录管理（6个功能权限）
--    - 招生统计分析（14个功能权限）
-- 3. 已为超级管理员角色分配所有权限
-- 4. 菜单ID范围：2100-2154（共55个菜单项）
-- 
-- 使用说明：
-- 1. 执行此SQL脚本完成菜单权限配置
-- 2. 重新登录系统即可看到招生迎新管理菜单
-- 3. 可根据需要为其他角色分配相应权限
-- =============================================