-- ============================================= -- 场地预约管理模块菜单权限配置脚本 -- -- 模块: 场地预约管理 (venue-reservation) -- 创建时间: 2025-07-01 -- 描述: 菜单权限配置,使用独立的ID范围避免冲突 -- ============================================= -- 设置字符集 SET NAMES utf8mb4; -- ============================================= -- 菜单权限配置 -- ============================================= -- 后勤管理菜单(如果不存在) 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_dept, create_by, create_time, update_by, update_time, remark) VALUES (2200, '后勤管理', 0, 6, 'hq', NULL, '', 1, 0, 'M', '0', '0', '', 'logistics', 103, 1, NOW(), 1, NOW(), '后勤管理目录') ON DUPLICATE KEY UPDATE menu_name='后勤管理', order_num=6; -- 场地管理菜单 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_dept, create_by, create_time, update_by, update_time, remark) VALUES (2210, '场地管理', 2200, 1, 'venue', 'hq/venue/index', '', 1, 0, 'C', '0', '0', 'hq:venue:list', 'venue', 103, 1, NOW(), 1, NOW(), '场地管理菜单') ON DUPLICATE KEY UPDATE menu_name='场地管理'; -- 场地管理按钮权限 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_dept, create_by, create_time, update_by, update_time, remark) VALUES (2211, '场地查询', 2210, 1, '', '', '', 1, 0, 'F', '0', '0', 'hq:venue:query', '#', 103, 1, NOW(), 1, NOW(), '') ON DUPLICATE KEY UPDATE menu_name='场地查询'; 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_dept, create_by, create_time, update_by, update_time, remark) VALUES (2212, '场地新增', 2210, 2, '', '', '', 1, 0, 'F', '0', '0', 'hq:venue:add', '#', 103, 1, NOW(), 1, NOW(), '') ON DUPLICATE KEY UPDATE menu_name='场地新增'; 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_dept, create_by, create_time, update_by, update_time, remark) VALUES (2213, '场地修改', 2210, 3, '', '', '', 1, 0, 'F', '0', '0', 'hq:venue:edit', '#', 103, 1, NOW(), 1, NOW(), '') ON DUPLICATE KEY UPDATE menu_name='场地修改'; 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_dept, create_by, create_time, update_by, update_time, remark) VALUES (2214, '场地删除', 2210, 4, '', '', '', 1, 0, 'F', '0', '0', 'hq:venue:remove', '#', 103, 1, NOW(), 1, NOW(), '') ON DUPLICATE KEY UPDATE menu_name='场地删除'; -- 场地预约菜单 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_dept, create_by, create_time, update_by, update_time, remark) VALUES (2220, '场地预约', 2200, 2, 'reservation', 'hq/venue/reservation', '', 1, 0, 'C', '0', '0', 'hq:venue:reservation:list', 'calendar', 103, 1, NOW(), 1, NOW(), '场地预约菜单') ON DUPLICATE KEY UPDATE menu_name='场地预约'; -- 预约按钮权限 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_dept, create_by, create_time, update_by, update_time, remark) VALUES (2221, '预约查询', 2220, 1, '', '', '', 1, 0, 'F', '0', '0', 'hq:venue:reservation:query', '#', 103, 1, NOW(), 1, NOW(), '') ON DUPLICATE KEY UPDATE menu_name='预约查询'; 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_dept, create_by, create_time, update_by, update_time, remark) VALUES (2222, '预约新增', 2220, 2, '', '', '', 1, 0, 'F', '0', '0', 'hq:venue:reservation:add', '#', 103, 1, NOW(), 1, NOW(), '') ON DUPLICATE KEY UPDATE menu_name='预约新增'; 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_dept, create_by, create_time, update_by, update_time, remark) VALUES (2223, '预约修改', 2220, 3, '', '', '', 1, 0, 'F', '0', '0', 'hq:venue:reservation:edit', '#', 103, 1, NOW(), 1, NOW(), '') ON DUPLICATE KEY UPDATE menu_name='预约修改'; 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_dept, create_by, create_time, update_by, update_time, remark) VALUES (2224, '预约审批', 2220, 4, '', '', '', 1, 0, 'F', '0', '0', 'hq:venue:reservation:approve', '#', 103, 1, NOW(), 1, NOW(), '') ON DUPLICATE KEY UPDATE menu_name='预约审批'; -- 场地统计菜单 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_dept, create_by, create_time, update_by, update_time, remark) VALUES (2230, '使用统计', 2200, 3, 'statistics', 'hq/venue/statistics', '', 1, 0, 'C', '0', '0', 'hq:venue:statistics:view', 'chart', 103, 1, NOW(), 1, NOW(), '场地使用统计') ON DUPLICATE KEY UPDATE menu_name='使用统计'; -- ============================================= -- 验证菜单配置结果 -- ============================================= SELECT '菜单权限配置完成!' AS result; SELECT CONCAT('场地预约菜单:', COUNT(*), '个') AS menu_info FROM sys_menu WHERE menu_id BETWEEN 2200 AND 2230;