all-project/docs/设计文档/database/04-venue-reservation-menu.sql

-- =============================================
-- 场地预约管理模块菜单权限配置脚本
-- 
-- 模块: 场地预约管理 (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;