add_noshow_menu.sql 1.7 KB

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