| 123456789101112131415161718192021222324252627 |
- -- 预约限制管理菜单SQL
- -- 2025-07-30 添加预约限制管理菜单
- -- 获取心理咨询预约父菜单ID
- SET @consultation_parent_id = (SELECT menu_id FROM sys_menu WHERE menu_name = '心理咨询预约' AND parent_menu_id IS NULL LIMIT 1);
- -- 如果找不到父菜单,使用心理健康菜单作为父菜单
- IF @consultation_parent_id IS NULL THEN
- SET @consultation_parent_id = (SELECT menu_id FROM sys_menu WHERE menu_name = '心理健康管理' AND parent_menu_id IS NULL LIMIT 1);
- END IF;
- -- 插入预约限制管理菜单
- 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_by, create_time, update_by, update_time, remark)
- VALUES (8140, '预约限制管理', @consultation_parent_id, 4, 'noshow', 'xljk/consultation/noshow/index', NULL, 1, 0, 'C', '0', '0', 'xljk:consultationnoshow:list', 'message', 'admin', NOW(), '', NULL, '预约限制管理菜单');
- -- 插入按钮权限
- 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_by, create_time, update_by, update_time, remark) VALUES
- (8141, '预约限制查询', 8140, 1, '', '', NULL, 1, 0, 'F', '0', '0', 'xljk:consultationnoshow:query', '#', 'admin', NOW(), '', NULL, ''),
- (8142, '解除预约限制', 8140, 2, '', '', NULL, 1, 0, 'F', '0', '0', 'xljk:consultationnoshow:release', '#', 'admin', NOW(), '', NULL, '');
- -- 将菜单权限分配给角色
- INSERT INTO sys_role_menu (role_id, menu_id)
- SELECT role_id, 8140 FROM sys_role WHERE role_id = 1
- UNION
- SELECT role_id, 8141 FROM sys_role WHERE role_id = 1
- UNION
- SELECT role_id, 8142 FROM sys_role WHERE role_id = 1;
|