20261022_irradiance_frequency_distribution_menu.sql 951 B

123456789
  1. -- 辐照度频率分布统计菜单补丁(任务 2610018, 幂等, 可重复执行)
  2. -- 1. 增加 辐照度频率分布统计 二级菜单(挂在 统计分析 下)
  3. INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
  4. SELECT
  5. (SELECT COALESCE(MAX(menu_id), 0) + 1 FROM sys_menu),
  6. '辐照度频率分布统计',
  7. (SELECT menu_id FROM sys_menu t WHERE t.menu_name = '统计分析' AND t.parent_id = 0),
  8. 22, 'irradiance-frequency-distribution', 'ufo/electricity/statanalysis/irradianceFrequencyDistribution', '', 'IrradianceFrequencyDistribution', 1, 0, 'C', '0', '0', 'data:irradianceFrequencyDistribution:list', 'SunOutlined', 'admin', now(), '', NULL, '辐照度频率分布统计页面'
  9. WHERE NOT EXISTS (SELECT 1 FROM sys_menu t WHERE t.menu_name = '辐照度频率分布统计');