| 123456789 |
- -- 上传状态查询菜单补丁（任务 2610016, 幂等, 可重复执行）
- -- 1. 增加 上传状态查询 二级菜单（挂在 统计分析 下）
- 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)
- SELECT
- (SELECT COALESCE(MAX(menu_id), 0) + 1 FROM sys_menu),
- '上传状态查询',
- (SELECT menu_id FROM sys_menu t WHERE t.menu_name = '统计分析' AND t.parent_id = 0),
- 20, 'report-log-query', 'ufo/electricity/statanalysis/reportLogQuery', '', 'ReportLogQuery', 1, 0, 'C', '0', '0', 'fileupload:reportLog:list', 'CloudUploadOutlined', 'admin', now(), '', NULL, '上传状态查询页面'
- WHERE NOT EXISTS (SELECT 1 FROM sys_menu t WHERE t.menu_name = '上传状态查询');
|
