SET NAMES utf8mb4; -- ---------------------------- -- 初始化-部门表数据 -- ---------------------------- insert into sys_dept values(101, 100, '0,100', '常泰服务区管理办', 2, '常泰管理办', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null); -- ---------------------------- -- 初始化-岗位信息表数据 -- ---------------------------- insert into sys_post values(2, 'se', '运营经理', 2, '0', 'admin', sysdate(), '', null, ''); insert into sys_post values(3, 'worker', '机修岗', 3, '0', 'admin', sysdate(), '', null, ''); insert into sys_post values(4, 'user', '普通员工', 4, '0', 'admin', sysdate(), '', null, ''); -- ---------------------------- -- 初始化-菜单信息表数据 -- ---------------------------- -- 一级菜单 insert into sys_menu values ('1', '监控', '0', '1', 'view', null, '', 1, 0, 'M', '0', '0', '', 'eye-open', 'admin', sysdate(), '', null, '监控大屏'); insert into sys_menu values ('2', '能管', '0', '2', 'power-mgr', null, '', 1, 0, 'M', '0', '0', '', 'energy', 'admin', sysdate(), '', null, '能流态势'); insert into sys_menu values ('3', '数据', '0', '3', 'analysis', null, '', 1, 0, 'M', '0', '0', '', 'analysis', 'admin', sysdate(), '', null, '数据分析'); insert into sys_menu values ('4', '设备', '0', '4', 'device-mgr', null, '', 1, 0, 'M', '0', '0', '', 'devicemgr', 'admin', sysdate(), '', null, '设备管理'); insert into sys_menu values ('5', '运维', '0', '5', 'oper-mgr', null, '', 1, 0, 'M', '0', '0', '', 'opermgr', 'admin', sysdate(), '', null, '运维保障'); insert into sys_menu values ('6', '设置', '0', '6', 'param-cfg', null, '', 1, 0, 'M', '0', '0', '', 'paramcfg', 'admin', sysdate(), '', null, '业务配置'); insert into sys_menu values ('7', '系统', '0', '7', 'system', null, '', 1, 0, 'M', '0', '0', '', 'system', 'admin', sysdate(), '', null, '系统管理'); insert into sys_menu values ('99', '开发工具', '0', '99', 'tool', null, '', 1, 0, 'M', '0', '0', '', 'tool', 'admin', sysdate(), '', null, '开发工具'); -- 二级菜单 insert into sys_menu values ('100', '服务区', '1', '1', '/largeScreen', 'view/servicearea', '', 1, 0, 'C', '0', '0', 'view:service-area', 'servicearea', 'admin', sysdate(), '', null, '园区能源概览'); insert into sys_menu values ('101', '主路光伏', '1', '2', '/PvRoad', 'view/road/photovoltaic', '', 1, 0, 'C', '0', '0', 'view:road-pv', 'photovoltaic', 'admin', sysdate(), '', null, '主路光伏概览'); insert into sys_menu values ('111', '源网', '2', '1', 'strategy-pg', 'mgr/powergrid', '', 1, 0, 'C', '0', '0', 'power-mgr:pg', 'powergrid', 'admin', sysdate(), '', null, '源网协调'); insert into sys_menu values ('112', '储能', '2', '2', 'strategy-gs', 'mgr/powerstore', '', 1, 0, 'C', '0', '0', 'power-mgr:gs', 'powerstore', 'admin', sysdate(), '', null, '网储互动'); insert into sys_menu values ('113', '负荷', '2', '3', 'strategy-use', 'mgr/poweruse', '', 1, 0, 'C', '0', '0', 'power-mgr:use', 'powerload', 'admin', sysdate(), '', null, '源荷互动'); insert into sys_menu values ('115', '充电桩', '2', '4', 'charging-pile', 'mgr/chargingpile', '', 1, 0, 'C', '0', '0', 'power-mgr:chargingpile', 'chargingpile', 'admin', sysdate(), '', null, '充电桩'); insert into sys_menu values ('116', '计费', '2', '5', 'charging', 'mgr/charging', '', 1, 0, 'C', '0', '0', 'power-mgr:charging', 'charging', 'admin', sysdate(), '', null, '计费'); insert into sys_menu values ('117', '策略', '2', '6', 'strategy-mgr', null, '', 1, 0, 'M', '0', '0', 'power-mgr:strategy', 'strategy', 'admin', sysdate(), '', null, '策略'); insert into sys_menu values ('126', '产能分析', '3', '1', 'power-prod', 'analysis/power/prod', '', 1, 0, 'C', '0', '0', 'analysis:power:prod', 'energyprod', 'admin', sysdate(), '', null, '产能分析'); insert into sys_menu values ('127', '储能分析', '3', '2', 'power-store', 'analysis/power/store', '', 1, 0, 'C', '0', '0', 'analysis:power:store', 'energystore', 'admin', sysdate(), '', null, '储能分析'); insert into sys_menu values ('128', '用能分析', '3', '3', 'power-consume', 'analysis/power/consume', '', 1, 0, 'C', '0', '0', 'ems:consumption:list', 'energyconsume', 'admin', sysdate(), '', null, '用能分析'); insert into sys_menu values ('129', '节能分析', '3', '4', 'power-save', 'analysis/power/save', '', 1, 0, 'C', '0', '0', 'ems:EmsEcoD:list', 'energysave', 'admin', sysdate(), '', null, '节能分析'); insert into sys_menu values ('123', '碳排分析', '3', '5', 'ca-analysis', null, '', 1, 0, 'M', '0', '0', '', 'ca', 'admin', sysdate(), '', null, '碳排监测'); insert into sys_menu values ('120', '趋势预测', '3', '6', 'prediction', '', '', 1, 0, 'M', '0', '0', '', 'prediction', 'admin', sysdate(), '', null, '趋势预测'); insert into sys_menu values ('121', '数据报表', '3', '7', 'analysis-statement', '', '', 1, 0, 'M', '0', '0', 'analysis:statement', 'statement', 'admin', sysdate(), '', null, '数据报表'); insert into sys_menu values ('141', '设备列表', '4', '1', 'device-list', 'devmgr/device', '', 1, 0, 'C', '0', '0', 'ems:device:list', 'deviceattr', 'admin', sysdate(), '', null, '设备属性'); insert into sys_menu values ('142', '设备台账', '4', '2', 'device-ledger', 'devmgr/ledger', '', 1, 0, 'C', '0', '0', 'ems:ledger:list', 'excel', 'admin', sysdate(), '', null, '设备台账'); insert into sys_menu values ('143', '设备告警', '4', '3', 'device-warn', 'devmgr/warn', '', 1, 0, 'C', '0', '0', 'analysis:device', 'deviceanalyze', 'admin', sysdate(), '', null, '设备分析'); insert into sys_menu values ('144', '抄表管理', '4', '4', 'deviceMeter', '', '', 1, 0, 'M', '0', '0', 'device:meter', 'meterReading', 'admin', sysdate(), '', null, '抄表管理'); INSERT INTO sys_menu VALUES ('151', '告警策略', '5', '1', 'warn-rule', 'alarm/rule/index', '', 1, 0, 'C', '0', '0', 'ems:alarm-rule:list', 'warnstrategy', 'admin', '2024-08-29 15:40:27', 'admin', '2024-08-29 16:01:10', '告警策略'); INSERT INTO sys_menu VALUES ('152', '告警列表', '5', '2', 'warn-list', 'alarm/list/index', '', 1, 0, 'C', '0', '0', 'ems:alarm:list', 'warnmsg', 'admin', '2024-08-29 15:40:27', 'admin', '2024-08-29 16:01:36', '告警列表'); INSERT INTO sys_menu VALUES ('153', '巡检计划', '5', '3', 'oper-plan', 'inspection/plan/index', '', 1, 0, 'C', '0', '0', 'ems:inspection:plan:list', 'task', 'admin', '2024-08-29 15:40:27', 'admin', '2024-08-29 16:02:38', '巡检计划'); INSERT INTO sys_menu VALUES ('154', '巡检报告', '5', '4', 'oper-report', 'inspection/report/index', '', 1, 0, 'C', '0', '0', 'ems:inspection:report:list', 'note', 'admin', sysdate(), '', null, '巡检报告'); insert into sys_menu values ('155', '系统对接', '5', '5', 'adapter', null, '', 1, 0, 'M', '0', '0', '', 'client', 'admin', sysdate(), '', null, '系统对接'); insert into sys_menu values ('161', '区域配置', '6', '1', 'areacfg', 'basecfg/area/index', '', 1, 0, 'C', '0', '0', 'ems:area:list', 'cfgwrite', 'admin', sysdate(), '', null, '区域配置'); insert into sys_menu values ('162', '设备设施', '6', '2', 'devicecfg', '', '', 1, 0, 'M', '0', '0', 'basecfg:device', 'devicemgr', 'admin', sysdate(), '', null, '设备设施'); insert into sys_menu values ('163', '能源计量', '6', '3', 'energycfg', '', '', 1, 0, 'M', '0', '0', 'basecfg:energy', 'energy', 'admin', sysdate(), '', null, '能源计量'); insert into sys_menu values ('170', '用户管理', '7', '1', 'user', 'system/user/index', '', 1, 0, 'C', '0', '0', 'system:user:list', 'user', 'admin', sysdate(), '', null, '用户管理菜单'); insert into sys_menu values ('171', '角色管理', '7', '2', 'role', 'system/role/index', '', 1, 0, 'C', '0', '0', 'system:role:list', 'peoples', 'admin', sysdate(), '', null, '角色管理菜单'); insert into sys_menu values ('172', '菜单管理', '7', '3', 'menu', 'system/menu/index', '', 1, 0, 'C', '0', '0', 'system:menu:list', 'tree-table', 'admin', sysdate(), '', null, '菜单管理菜单'); insert into sys_menu values ('173', '部门管理', '7', '4', 'dept', 'system/dept/index', '', 1, 0, 'C', '0', '0', 'system:dept:list', 'tree', 'admin', sysdate(), '', null, '部门管理菜单'); insert into sys_menu values ('174', '岗位管理', '7', '5', 'post', 'system/post/index', '', 1, 0, 'C', '0', '0', 'system:post:list', 'post', 'admin', sysdate(), '', null, '岗位管理菜单'); insert into sys_menu values ('175', '字典管理', '7', '6', 'dict', 'system/dict/index', '', 1, 0, 'C', '0', '0', 'system:dict:list', 'dict', 'admin', sysdate(), '', null, '字典管理菜单'); insert into sys_menu values ('176', '参数设置', '7', '7', 'config', 'system/config/index', '', 1, 0, 'C', '0', '0', 'system:config:list', 'edit', 'admin', sysdate(), '', null, '参数设置菜单'); insert into sys_menu values ('177', '通知公告', '7', '8', 'notice', 'system/notice/index', '', 1, 0, 'C', '0', '0', 'system:notice:list', 'message', 'admin', sysdate(), '', null, '通知公告菜单'); insert into sys_menu values ('178', '日志管理', '7', '9', 'log', '', '', 1, 0, 'M', '0', '0', '', 'log', 'admin', sysdate(), '', null, '日志管理菜单'); insert into sys_menu values ('179', '在线用户', '7', '10', 'online', 'monitor/online/index', '', 1, 0, 'C', '0', '0', 'monitor:online:list', 'online', 'admin', sysdate(), '', null, '在线用户菜单'); INSERT INTO sys_menu VALUES ('180', '任务调度', '7', '10', 'task/job', 'monitor/job/index', '', 1, 0, 'C', '0', '0', 'monitor:job', 'date-range', 'admin', sysdate(), '', NULL, '任务调度'); insert into sys_menu values ('1170', '策略中心', '117', '1', 'strategy-index', 'mgr/strategy/index', '', 1, 0, 'C', '0', '0', 'power-mgr:strategy:list', 'system', 'admin', sysdate(), '', null, '策略中心'); insert into sys_menu values ('1171', '策略模板', '117', '2', 'strategy-template', 'mgr/strategy/template', '', 1, 0, 'C', '0', '0', 'power-mgr:strategy:list', 'system', 'admin', sysdate(), '', null, '策略模板'); insert into sys_menu values ('1172', '策略日志', '117', '3', 'strategy-log', 'mgr/strategy/log', '', 1, 0, 'C', '0', '0', 'power-mgr:strategy:list', 'system', 'admin', sysdate(), '', null, '策略日志'); insert into sys_menu values ('1550', '设备管理', '155', '1', 'adapter-devc', 'adapter/devc/index', '', 1, 0, 'C', '0', '0', 'adapter:devc:list', 'system', 'admin', sysdate(), '', null, '设备管理'); insert into sys_menu values ('1551', '能耗监测', '155', '2', 'adapter-nhjc', 'adapter/nhjc/index', '', 1, 0, 'C', '0', '0', 'adapter:devc:list', 'system', 'admin', sysdate(), '', null, '能耗监测'); insert into sys_menu values ('1552', '智慧照明', '155', '3', 'adapter-zm', 'adapter/zm/index', '', 1, 0, 'C', '0', '0', 'adapter:devc:list', 'system', 'admin', sysdate(), '', null, '智慧照明'); insert into sys_menu values ('1553', '充电桩', '155', '4', 'adapter-cdz', 'adapter/cdz/index', '', 1, 0, 'C', '0', '0', 'adapter:devc:list', 'powerstore', 'admin', sysdate(), '', null, '充电桩'); insert into sys_menu values ('1554', '光伏监测', '155', '5', 'adapter-pv', 'adapter/pv/index', '', 1, 0, 'C', '0', '0', 'adapter:devc:list', 'photovoltaic', 'admin', sysdate(), '', null, '光伏'); insert into sys_menu values ('1555', '光储直柔', '155', '6', 'adapter-gczr', 'adapter/gczr/index', '', 1, 0, 'C', '0', '0', 'adapter:devc:list', 'deviceaccess', 'admin', sysdate(), '', null, '光储直柔'); insert into sys_menu values ('1556', '光储充', '155', '7', 'adapter-gcc', 'adapter/gcc/index', '', 1, 0, 'C', '0', '0', 'adapter:devc:list', 'energyconsume', 'admin', sysdate(), '', null, '光储充'); insert into sys_menu values ('1557', '智慧海绵', '155', '8', 'adapter-hm', 'adapter/hm/index', '', 1, 0, 'C', '0', '0', 'adapter:devc:list', 'system', 'admin', sysdate(), '', null, '智慧海绵'); insert into sys_menu values ('1558', '垃圾厨余', '155', '9', 'adapter-ljcy', 'adapter/ljcy/index', '', 1, 0, 'C', '0', '0', 'adapter:devc:list', 'system', 'admin', sysdate(), '', null, '垃圾厨余'); insert into sys_menu values ('1559', '电力监控', '155', '10', 'adapter-dljk', 'adapter/dljk/index', '', 1, 0, 'C', '0', '0', 'adapter:devc:list', 'system', 'admin', sysdate(), '', null, '电力监控'); insert into sys_menu values ('997', '表单构建', '99', '1', 'build', 'tool/build/index', '', 1, 0, 'C', '0', '0', 'tool:build:list', 'build', 'admin', sysdate(), '', null, '表单构建菜单'); insert into sys_menu values ('998', '代码生成', '99', '2', 'gen', 'tool/gen/index', '', 1, 0, 'C', '0', '0', 'tool:gen:list', 'code', 'admin', sysdate(), '', null, '代码生成菜单'); insert into sys_menu values ('999', '系统接口', '99', '3', 'http://localhost:9100/swagger-ui/index.html', '', '', 0, 0, 'C', '0', '0', 'tool:swagger:list', 'swagger', 'admin', sysdate(), '', null, '系统接口菜单'); -- 三级菜单 -- 预测菜单 insert into sys_menu values ('1200', '产能预测', '120', '1', 'prediction-prod', 'prediction/prod', '', 1, 0, 'C', '0', '0', 'prediction:prod', 'energyprod', 'admin', sysdate(), '', null, '产能预测'); insert into sys_menu values ('1201', '用能预测', '120', '2', 'prediction-consume', 'prediction/consume', '', 1, 0, 'C', '0', '0', 'prediction:consume', 'energyconsume', 'admin', sysdate(), '', null, '用能预测'); insert into sys_menu values ('1202', '碳排预测', '120', '3', 'prediction-ca', 'prediction/ca', '', 1, 0, 'C', '0', '0', 'prediction:ca', 'caemission', 'admin', sysdate(), '', null, '碳排预测'); -- 报表菜单 insert into sys_menu values ('1210', '产能报表', '121', '1', 'statement-prod', 'analysis/report/statement-prod', '', 1, 0, 'C', '0', '0', 'analysis:statement:prod', 'energyprod', 'admin', sysdate(), '', null, '产能报表'); insert into sys_menu values ('1211', '用能报表', '121', '2', 'statement-consume', 'analysis/report/statement-consume', '', 1, 0, 'C', '0', '0', 'analysis:statement:consume', 'energyconsume', 'admin', sysdate(), '', null, '用能报表'); insert into sys_menu values ('1212', '告警报表', '121', '3', 'statement-warn', 'analysis/report/statement-warn', '', 1, 0, 'C', '0', '0', 'analysis:statement:warn', 'warn', 'admin', sysdate(), '', null, '告警报表'); insert into sys_menu values ('1213', '自定义', '121', '4', 'statement-self', 'analysis/report/statement-self', '', 1, 0, 'C', '0', '0', 'report:custom:list', 'statement-zdy', 'admin', sysdate(), '', null, '自定义报表'); -- 碳分析菜单 insert into sys_menu values ('1231', '碳排计量', '123', '1', 'ca-emission', 'ca/emission', '', 1, 0, 'C', '0', '0', 'ca-analysis:emission', 'caemission', 'admin', sysdate(), '', null, '碳排分析'); insert into sys_menu values ('1232', '碳汇测算', '123', '2', 'ca-sink', 'ca/emissionCalc', '', 1, 0, 'C', '0', '0', 'ca-analysis:sink', 'casink', 'admin', sysdate(), '', null, '碳汇分析'); -- 抄表管理菜单 insert into sys_menu values ('1440', '手动抄表', '144', '1', 'meterRead-manual', 'devmgr/meterRead', '', 1, 0, 'C', '0', '0', 'ems:meterReading:list', 'meterReadManual', 'admin', sysdate(), '', null, '手动抄表'); insert into sys_menu values ('1441', '自动抄表', '144', '2', 'meterRead-auto', 'devmgr/meterData', '', 1, 0, 'C', '0', '0', 'ems:meterData:list', 'meterReadAuto', 'admin', sysdate(), '', null, '抄表数据'); -- 业务配置菜单 insert into sys_menu values ('1620', '设备模型', '162', '1', 'basecfg-devmode', 'basecfg/device/model', '', 1, 0, 'C', '0', '0', 'ems:devmode:list', 'cfgwrite', 'admin', sysdate(), '', null, '设备模型'); insert into sys_menu values ('1621', '设施分类', '162', '2', 'basecfg-facscategory', 'basecfg/facscategory/index', '', 1, 0, 'C', '0', '0', 'basecfg:facscategory:list', 'cfgwrite', 'admin', sysdate(), '', null, '设施配置'); insert into sys_menu values ('1622', '能流关系', '162', '3', 'basecfg-flowrel', 'basecfg/flowrel/index', '', 1, 0, 'C', '0', '0', 'basecfg:flowrel:list', 'cfgwrite', 'admin', sysdate(), '', null, '设备配置'); insert into sys_menu values ('1623', '设施管理', '162', '4', 'basecfg-facscfg', 'basecfg/emsfacs/index', '', 1, 0, 'C', '0', '0', 'basecfg:emsfacs:list', 'cfgwrite', 'admin', sysdate(), '', null, '设施配置'); insert into sys_menu values ('1624', '设备管理', '162', '5', 'basecfg-devccfg', 'basecfg/device/index', '', 1, 0, 'C', '0', '0', 'basecfg:device:list', 'cfgwrite', 'admin', sysdate(), '', null, '设备配置'); insert into sys_menu values ('1630', '计量设备', '163', '1', 'basecfg-meterdevc', 'basecfg/meterdevc/index', '', 1, 0, 'C', '0', '0', 'ems:meterdevc:list', 'cfgwrite', 'admin', sysdate(), '', null, '计量设备'); insert into sys_menu values ('1631', '计量绑定', '163', '2', 'basecfg-boundaryRel', 'basecfg/boundaryRel/index', '', 1, 0, 'C', '0', '0', 'ems:meterBoundary:list', 'cfgwrite', 'admin', sysdate(), '', null, '边界划分'); insert into sys_menu values ('1632', '价格策略', '163', '3', 'basecfg-electricity', 'basecfg/price/index', '', 1, 0, 'C', '0', '0', 'basecfg:price:list', 'cfgwrite', 'admin', sysdate(), '', null, '价格策略'); insert into sys_menu values ('1633', '碳排因子', '163', '4', 'basecfg-cacfg', 'basecfg/cacfg/index', '', 1, 0, 'C', '0', '0', 'basecfg:cacfg:list', 'cfgwrite', 'admin', sysdate(), '', null, '碳排因子'); insert into sys_menu values ('1634', '碳汇系数', '163', '5', 'basecfg-casinkcfg', 'basecfg/casinkcfg/index', '', 1, 0, 'C', '0', '0', 'basecfg:casink:list', 'cfgwrite', 'admin', sysdate(), '', null, '碳汇系数'); insert into sys_menu values ('1635', '折煤系数', '163', '6', 'basecfg-dsccfg', 'basecfg/dsccfg/index', '', 1, 0, 'C', '0', '0', 'basecfg:dsccfg:list', 'cfgwrite', 'admin', sysdate(), '', null, '折煤系数'); -- 用户管理按钮 insert into sys_menu values ('1700', '用户查询', '170', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:user:query', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1701', '用户新增', '170', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:user:add', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1702', '用户修改', '170', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:user:edit', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1703', '用户删除', '170', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:user:remove', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1704', '用户导出', '170', '5', '', '', '', 1, 0, 'F', '0', '0', 'system:user:export', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1705', '用户导入', '170', '6', '', '', '', 1, 0, 'F', '0', '0', 'system:user:import', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1706', '重置密码', '170', '7', '', '', '', 1, 0, 'F', '0', '0', 'system:user:resetPwd', '#', 'admin', sysdate(), '', null, ''); -- 角色管理按钮 insert into sys_menu values ('1710', '角色查询', '171', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:role:query', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1711', '角色新增', '171', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:role:add', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1712', '角色修改', '171', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:role:edit', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1713', '角色删除', '171', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:role:remove', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1714', '角色导出', '171', '5', '', '', '', 1, 0, 'F', '0', '0', 'system:role:export', '#', 'admin', sysdate(), '', null, ''); -- 菜单管理按钮 insert into sys_menu values ('1720', '菜单查询', '172', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:query', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1721', '菜单新增', '172', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:add', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1722', '菜单修改', '172', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:edit', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1723', '菜单删除', '172', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:remove', '#', 'admin', sysdate(), '', null, ''); -- 部门管理按钮 insert into sys_menu values ('1730', '部门查询', '173', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:query', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1731', '部门新增', '173', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:add', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1732', '部门修改', '173', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:edit', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1733', '部门删除', '173', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:remove', '#', 'admin', sysdate(), '', null, ''); -- 岗位管理按钮 insert into sys_menu values ('1740', '岗位查询', '174', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:post:query', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1741', '岗位新增', '174', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:post:add', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1742', '岗位修改', '174', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:post:edit', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1743', '岗位删除', '174', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:post:remove', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1744', '岗位导出', '174', '5', '', '', '', 1, 0, 'F', '0', '0', 'system:post:export', '#', 'admin', sysdate(), '', null, ''); -- 字典管理按钮 insert into sys_menu values ('1750', '字典查询', '175', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:query', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1751', '字典新增', '175', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:add', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1752', '字典修改', '175', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:edit', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1753', '字典删除', '175', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:remove', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1754', '字典导出', '175', '5', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:export', '#', 'admin', sysdate(), '', null, ''); -- 参数设置按钮 insert into sys_menu values ('1760', '参数查询', '176', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:query', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1761', '参数新增', '176', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:add', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1762', '参数修改', '176', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:edit', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1763', '参数删除', '176', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:remove', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1764', '参数导出', '176', '5', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:export', '#', 'admin', sysdate(), '', null, ''); -- 通知公告按钮 insert into sys_menu values ('1770', '公告查询', '177', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:query', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1771', '公告新增', '177', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:add', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1772', '公告修改', '177', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:edit', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1773', '公告删除', '177', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:remove', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1780', '操作日志', '178', '1', 'operlog', 'system/operlog/index', '', 1, 0, 'C', '0', '0', 'system:operlog:list', 'form', 'admin', sysdate(), '', null, '操作日志菜单'); insert into sys_menu values ('1781', '登录日志', '178', '2', 'logininfor', 'system/logininfor/index', '', 1, 0, 'C', '0', '0', 'system:logininfor:list', 'logininfor', 'admin', sysdate(), '', null, '登录日志菜单'); -- 操作日志按钮 insert into sys_menu values ('17800', '操作查询', '1780', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:operlog:query', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('17801', '操作删除', '1780', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:operlog:remove', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('17802', '日志导出', '1780', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:operlog:export', '#', 'admin', sysdate(), '', null, ''); -- 登录日志按钮 insert into sys_menu values ('17810', '登录查询', '1781', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:logininfor:query', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('17811', '登录删除', '1781', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:logininfor:remove', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('17812', '日志导出', '1781', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:logininfor:export', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('17813', '账户解锁', '1781', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:logininfor:unlock', '#', 'admin', sysdate(), '', null, ''); -- 在线用户按钮 insert into sys_menu values ('1790', '在线查询', '179', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:query', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1791', '批量强退', '179', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:batchLogout', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('1792', '单条强退', '179', '3', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:forceLogout', '#', 'admin', sysdate(), '', null, ''); -- 能源设施分类配置按钮 insert into sys_menu values ('16200', '分类新增', '1620', '1', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:facscategory:add', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('16201', '分类修改', '1620', '2', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:facscategory:edit', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('16202', '分类删除', '1620', '3', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:facscategory:remove','#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('16203', '分类查询', '1620', '4', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:facscategory:query','#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('16204', '分类导出', '1620', '5', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:facscategory:export','#', 'admin', sysdate(), '', null, ''); -- 服务区能源设施配置按钮 insert into sys_menu values ('16210', '设施新增', '1621', '1', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:emsfacs:add', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('16211', '设施修改', '1621', '2', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:emsfacs:edit', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('16212', '设施删除', '1621', '3', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:emsfacs:remove','#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('16213', '设施导出', '1621', '4', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:emsfacs:export','#', 'admin', sysdate(), '', null, ''); -- 服务区能流关系配置按钮 insert into sys_menu values ('16220', '关系新增', '1622', '1', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:flowrel:add', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('16221', '关系修改', '1622', '2', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:flowrel:edit', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('16222', '关系删除', '1622', '3', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:flowrel:remove','#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('16223', '关系查询', '1622', '4', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:flowrel:query','#', 'admin', sysdate(), '', null, ''); -- 服务区设备配置按钮 insert into sys_menu values ('16230', '设备新增', '1623', '1', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:emsfacs:add', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('16231', '设备修改', '1623', '2', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:emsfacs:edit', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('16232', '设备删除', '1623', '3', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:emsfacs:remove','#', 'admin', sysdate(), '', null, ''); insert into sys_menu values ('16233', '设备导出', '1623', '4', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:emsfacs:export','#', 'admin', sysdate(), '', null, ''); -- 价格策略按钮 INSERT INTO sys_menu VALUES (16320, '列表查询', 1632, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:price:list', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16321, '导出', 1632, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:price:export', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16322, '查询', 1632, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:price:query', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16323, '新增', 1632, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:price:add', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16324, '修改', 1632, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:price:edit', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16325, '删除', 1632, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:price:remove', '#', 'admin', sysdate(), '', NULL, ''); -- 能源策略按钮 INSERT INTO sys_menu VALUES (1150, '列表查询', 115, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:strategy:list', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (1151, '导出', 115, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:strategy:export', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (1152, '查询', 115, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:strategy:query', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (1153, '新增', 115, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:strategy:add', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (1154, '修改', 115, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:strategy:edit', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (1155, '删除', 115, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:strategy:remove', '#', 'admin', sysdate(), '', NULL, ''); -- 源网协调按钮 INSERT INTO `sys_menu` VALUES (1120, '列表查询',112, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:pg:list', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (1121, '导出',112, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:pg:export', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (1122, '查询',112, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:pg:query', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (1123, '新增',112, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:pg:add', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (1124, '修改',112, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:pg:edit', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (1125, '删除',112, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:pg:remove', '#', 'admin', sysdate(), '', NULL, ''); -- 网储互动 INSERT INTO `sys_menu` VALUES (1130,'列表查询',113, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:gs:list', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (1131,'导出',113, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:gs:export', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (1132,'查询',113, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:gs:query', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (1133,'新增',113, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:gs:add', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (1134,'修改',113, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:gs:edit', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (1135,'删除',113, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:gs:remove', '#', 'admin', sysdate(), '', NULL, ''); -- 告警策略 INSERT INTO sys_menu VALUES (1510, '列表查询', 151, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:alarm-rule:list', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1511, '导出', 151, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:alarm-rule:export', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1512, '查询', 151, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:alarm-rule:query', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1513, '新增', 151, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:alarm-rule:add', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1514, '修改', 151, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:alarm-rule:edit', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1515, '删除', 151, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:alarm-rule:remove', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); -- 告警列表 INSERT INTO sys_menu VALUES (1520, '列表查询', 152, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:alarm:list', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1521, '导出', 152, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:alarm:export', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1522, '查询', 152, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:alarm:query', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1523, '新增', 152, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:alarm:add', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1524, '处理', 152, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:alarm:handle', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1525, '删除', 152, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:alarm:remove', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); -- 产能分析 INSERT INTO sys_menu VALUES (12601,'列表查询',126, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:prod:list', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (12602,'导出',126, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:prod:export', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (12603,'查询',126, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:prod:query', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (12604,'新增',126, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:prod:add', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (12605,'修改',126, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:prod:edit', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (126016,'删除',126, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:prod:remove', '#', 'admin', sysdate(), '', NULL, ''); -- 产能预测按钮 INSERT INTO sys_menu VALUES (12006, '列表查询', 1200, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:prod:list', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (12007, '导出', 1200, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:prod:export', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (12008, '查询', 1200, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:prod:query', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (12009, '新增', 1200, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:prod:add', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (120010, '修改', 1200, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:prod:edit', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (120011, '删除', 1200, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:prod:remove', '#', 'admin', sysdate(), '', NULL, ''); -- 自定义报表配置按钮 INSERT INTO sys_menu VALUES (12130, '列表查询', 1213, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'report:config:list', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (12131, '导出', 1213, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'report:config:export', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (12132, '查询', 1213, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'report:config:query', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (12133, '新增', 1213, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'report:config:add', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (12134, '修改', 1213, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'report:config:edit', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (12135, '删除', 1213, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'report:config:remove', '#', 'admin', sysdate(), '', NULL, ''); -- 用能预测 INSERT INTO `sys_menu` VALUES (12010,'列表查询',1201, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:consume:list', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (12011,'导出',1201, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:consume:export', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (12012,'查询',1201, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:consume:query', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (12013,'新增',1201, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:consume:add', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (12014,'修改',1201, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:consume:edit', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (12015,'删除',1201, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:consume:remove', '#', 'admin', sysdate(), '', NULL, ''); -- 碳排预测 INSERT INTO `sys_menu` VALUES (12020,'列表查询',1202, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:ca:list', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (12021,'导出',1202, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:ca:export', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (12022,'查询',1202, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:ca:query', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (12023,'新增',1202, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:ca:add', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (12024,'修改',1202, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:ca:edit', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (12025,'删除',1202, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:ca:remove', '#', 'admin', sysdate(), '', NULL, ''); -- 节能分析 insert into sys_menu (menu_id,menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark) values(12901,'节能计量日查询', 129, '1', '#', '', 1, 0, 'F', '0', '0', 'ems:EmsEcoD:query', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu (menu_id,menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark) values(12902,'节能计量日新增', 129, '2', '#', '', 1, 0, 'F', '0', '0', 'ems:EmsEcoD:add', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu (menu_id,menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark) values(12903,'节能计量日修改', 129, '3', '#', '', 1, 0, 'F', '0', '0', 'ems:EmsEcoD:edit', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu (menu_id,menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark) values(12904,'节能计量日删除', 129, '4', '#', '', 1, 0, 'F', '0', '0', 'ems:EmsEcoD:remove', '#', 'admin', sysdate(), '', null, ''); insert into sys_menu (menu_id,menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark) values(12905,'节能计量日导出', 129, '5', '#', '', 1, 0, 'F', '0', '0', 'ems:EmsEcoD:export', '#', 'admin', sysdate(), '', null, ''); -- 计量设备按钮 INSERT INTO sys_menu VALUES (16300, '列表查询', 1630, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterdevc:list', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16301, '导出', 1630, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterdevc:export', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16302, '查询', 1630, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterdevc:query', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16303, '新增', 1630, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterdevc:add', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16304, '修改', 1630, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterdevc:edit', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16305, '删除', 1630, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterdevc:remove', '#', 'admin', sysdate(), '', NULL, ''); -- 基础配置计量设备按钮 INSERT INTO sys_menu VALUES (162401, '列表查询', 1624, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:meterdevc:list', '#', 'admin', sysdate(), '', NULL, ''); -- 计量绑定按钮 INSERT INTO sys_menu VALUES (16310, '列表查询', 1631, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterBoundary:list', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16311, '新增', 1631, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterBoundary:add', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16312, '删除', 1631, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterBoundary:remove', '#', 'admin', sysdate(), '', NULL, ''); -- 储能设施指标按钮 INSERT INTO sys_menu VALUES (12701, '列表查询', 127, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:ElecStoreIndex:list', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (12702, '新增', 127, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:ElecStoreIndex:add', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (12703, '修改', 127, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:ElecStoreIndex:edit', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (12704, '删除', 127, 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:ElecStoreIndex:remove', '#', 'admin', sysdate(), '', NULL, ''); -- 碳排计量 INSERT INTO `sys_menu` VALUES (12311,'列表查询',1231, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:emission:list', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (12312,'导出',1231, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:emission:export', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (12313,'查询',1231, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:emission:query', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (12314,'新增',1231, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:emission:add', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (12315,'修改',1231, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:emission:edit', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (12316,'删除',1231, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:emission:remove', '#', 'admin', sysdate(), '', NULL, ''); -- 碳汇计量 INSERT INTO `sys_menu` VALUES (12321,'列表查询',1232, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:sink:list', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (12322,'导出',1232, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:sink:export', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (12323,'查询',1232, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:sink:query', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (12324,'新增',1232, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:sink:add', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (12325,'修改',1232, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:sink:edit', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO `sys_menu` VALUES (12326,'删除',1232, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:sink:remove', '#', 'admin', sysdate(), '', NULL, ''); -- 巡检计划 INSERT INTO sys_menu VALUES (1531, '列表查询', 153, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:inspection:plan:list', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1532, '导出', 153, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:inspection:plan:export', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1534, '查询', 153, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:inspection:plan:query', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1535, '新增', 153, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:inspection:plan:add', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1536, '修改', 153, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:inspection:plan:edit', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1537, '删除', 153, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:inspection:plan:remove', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1538, '巡检执行', 153, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:inspection:plan:execute', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); -- 巡检报告 INSERT INTO sys_menu VALUES (1541, '列表查询', 154, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:inspection:report:list', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1542, '导出', 154, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:inspection:report:export', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1543, '查询', 154, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:inspection:report:query', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1544, '修改', 154, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:inspection:report:edit', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1545, '删除', 154, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:inspection:report:remove', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); -- 能源子系统按钮 INSERT INTO sys_menu VALUES (15530, '查询', 1553, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'adapter:subsystem:query', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (15531, '新增', 1553, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'adapter:subsystem:add', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (15532, '修改', 1553, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'adapter:subsystem:edit', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (15533, '删除', 1553, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'adapter:subsystem:remove', '#', 'admin', sysdate(), '', NULL, ''); -- 计费账单按钮 INSERT INTO sys_menu VALUES (15540, '列表查询', 1554, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:charging:list', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (15541, '导出', 1554, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:charging:export', '#', 'admin', sysdate(), '', NULL, ''); -- 协同充电配置按钮 INSERT INTO sys_menu VALUES (15550, '列表查询', 1555, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:config:list', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (15551, '查询', 1555, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:config:query', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (15552, '新增', 1555, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:config:add', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (15553, '修改', 1555, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:config:edit', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (15554, '删除', 1555, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:config:remove', '#', 'admin', sysdate(), '', NULL, ''); -- 手动抄表按钮 INSERT INTO sys_menu VALUES (14400, '列表查询', 1440, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterReading:list', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (14401, '导出', 1440, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterReading:export', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (14402, '查询', 1440, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterReading:query', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (14403, '新增', 1440, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterReading:add', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (14404, '修改', 1440, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterReading:edit', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (14405, '删除', 1440, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterReading:remove', '#', 'admin', sysdate(), '', NULL, ''); -- 用电计量小时按钮 INSERT INTO sys_menu VALUES (14410, '用电列表查询', 1441, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:elecMeterH:list', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (14411, '用电导出', 1441, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:elecMeterH:export', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (14412, '用电查询', 1441, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:elecMeterH:query', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (14413, '用电新增', 1441, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:elecMeterH:add', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (14414, '用电修改', 1441, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:elecMeterH:edit', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (14415, '用电删除', 1441, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:elecMeterH:remove', '#', 'admin', sysdate(), '', NULL, ''); -- 用水计量小时按钮 INSERT INTO sys_menu VALUES (14420, '用水列表查询', 1441, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:waterMeterH:list', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (14421, '用水导出', 1441, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:waterMeterH:export', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (14422, '用水查询', 1441, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:waterMeterH:query', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (14423, '用水新增', 1441, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:waterMeterH:add', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (14424, '用水修改', 1441, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:waterMeterH:edit', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (14425, '用水删除', 1441, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:waterMeterH:remove', '#', 'admin', sysdate(), '', NULL, ''); -- 折煤系数按钮 INSERT INTO sys_menu VALUES (16350, '列表查询', 1635, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:disStaCoal:list', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16351, '导出', 1635, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:disStaCoal:export', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16352, '查询', 1635, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:disStaCoal:query', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16353, '新增', 1635, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:disStaCoal:add', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16354, '修改', 1635, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:disStaCoal:edit', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16355, '删除', 1635, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:disStaCoal:remove', '#', 'admin', sysdate(), '', NULL, ''); -- 非电能源价格配置按钮 INSERT INTO sys_menu VALUES (16360, '列表查询', 1632, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:FdEnergyPriceConfig:list', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16361, '导出', 1632, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:FdEnergyPriceConfig:export', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16362, '查询', 1632, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:FdEnergyPriceConfig:query', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16363, '新增', 1632, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:FdEnergyPriceConfig:add', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16364, '修改', 1632, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:FdEnergyPriceConfig:edit', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16365, '删除', 1632, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:FdEnergyPriceConfig:remove', '#', 'admin', sysdate(), '', NULL, ''); -- 碳排因子按钮 INSERT INTO sys_menu VALUES (16330, '列表查询', 1633, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:cacfg:list', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16331, '导出', 1633, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:cacfg:export', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16332, '查询', 1633, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:cacfg:query', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16333, '新增', 1633, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:cacfg:add', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16334, '修改', 1633, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:cacfg:edit', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16335, '删除', 1633, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:cacfg:remove', '#', 'admin', sysdate(), '', NULL, ''); -- 碳汇系数按钮 INSERT INTO sys_menu VALUES (16340, '列表查询', 1634, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:casink:list', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16341, '导出', 1634, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:casink:export', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16342, '查询', 1634, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:casink:query', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16343, '新增', 1634, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:casink:add', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16344, '修改', 1634, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:casink:edit', '#', 'admin', sysdate(), '', NULL, ''); INSERT INTO sys_menu VALUES (16345, '删除', 1634, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:casink:remove', '#', 'admin', sysdate(), '', NULL, ''); -- 任务调度 INSERT INTO sys_menu VALUES (1800, '任务列表', 180, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'monitor:job:list', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1801, '任务到出', 180, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'monitor:job:export', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1802, '任务查询', 180, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'monitor:job:query', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1803, '新增任务', 180, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'monitor:job:add', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1804, '编辑任务', 180, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'monitor:job:edit', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1805, '移除任务', 180, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'monitor:job:remove', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1806, '修改任务状态', 180, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'monitor:job:changeStatus', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); INSERT INTO sys_menu VALUES (1807, '执行任务', 180, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'monitor:job:run', '#', 'admin', '2024-08-26 11:08:42', '', NULL, ''); -- ---------------------------- -- 初始化-角色和菜单关联表数据 -- ---------------------------- INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 2); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 3); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 4); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 5); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 6); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 7); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 99); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 100); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 101); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 111); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 112); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 113); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 115); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 116); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 117); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 120); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 121); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 123); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 126); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 127); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 128); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 129); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 141); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 142); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 143); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 144); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 151); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 152); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 153); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 154); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 155); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 161); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 162); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 163); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 170); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 171); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 172); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 173); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 174); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 175); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 176); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 177); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 178); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 179); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 180); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 997); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 998); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 999); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1120); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1121); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1122); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1123); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1124); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1125); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1130); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1131); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1132); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1133); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1134); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1135); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1150); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1151); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1152); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1153); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1154); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1155); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1170); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1171); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1172); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1200); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1201); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1202); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1210); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1211); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1212); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1213); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1231); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1232); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1440); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1441); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1510); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1511); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1512); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1513); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1514); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1515); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1520); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1521); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1522); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1523); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1524); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1525); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1531); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1532); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1534); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1535); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1536); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1537); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1538); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1541); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1542); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1543); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1544); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1545); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1550); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1551); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1552); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1553); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1554); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1555); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1556); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1557); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1558); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1559); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1620); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1621); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1622); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1623); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1624); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1630); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1631); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1632); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1633); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1634); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1635); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1700); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1701); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1702); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1703); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1704); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1705); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1706); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1710); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1711); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1712); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1713); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1714); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1720); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1721); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1722); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1723); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1730); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1731); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1732); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1733); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1740); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1741); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1742); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1743); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1744); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1750); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1751); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1752); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1753); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1754); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1760); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1761); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1762); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1763); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1764); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1770); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1771); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1772); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1773); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1780); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1781); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1790); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1791); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1792); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1800); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1801); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1802); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1803); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1804); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1805); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1806); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1807); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12006); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12007); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12008); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12009); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12010); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12011); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12012); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12013); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12014); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12015); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12020); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12021); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12022); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12023); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12024); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12025); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12130); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12131); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12132); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12133); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12134); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12135); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12311); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12312); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12313); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12314); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12315); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12316); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12321); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12322); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12323); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12324); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12325); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12326); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12601); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12602); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12603); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12604); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12605); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12701); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12702); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12703); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12704); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12901); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12902); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12903); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12904); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12905); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14400); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14401); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14402); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14403); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14404); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14405); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14410); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14411); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14412); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14413); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14414); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14415); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14420); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14421); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14422); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14423); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14424); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14425); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 15530); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 15531); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 15532); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 15533); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 15540); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 15541); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 15550); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 15551); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 15552); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 15553); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 15554); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16200); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16201); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16202); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16203); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16204); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16210); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16211); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16212); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16213); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16220); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16221); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16222); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16223); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16230); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16231); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16232); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16233); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16300); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16301); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16302); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16303); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16304); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16305); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16310); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16311); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16312); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16320); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16321); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16322); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16323); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16324); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16325); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16330); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16331); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16332); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16333); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16334); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16335); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16340); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16341); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16342); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16343); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16344); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16345); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16350); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16351); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16352); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16353); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16354); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16355); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16360); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16361); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16362); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16363); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16364); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16365); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 17800); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 17801); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 17802); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 17810); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 17811); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 17812); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 17813); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 120010); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 120011); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 126016); INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 162401); -- ---------------------------- -- 初始化-角色和部门关联表数据 -- ---------------------------- insert into sys_role_dept values ('2', '101'); -- ---------------------------- -- 初始化-字典类型表数据 -- ---------------------------- INSERT INTO `sys_dict_type` VALUES (100, '设备状态', 'sys_device_stat', '0', 'admin', '2024-08-07 10:21:42', '', NULL, NULL); INSERT INTO `sys_dict_type` VALUES (101, '策略类型', 'strategy_type', '0', 'admin', '2024-08-08 14:45:51', 'admin', '2024-08-08 14:46:11', '1:源网协调，2：源荷互动'); INSERT INTO `sys_dict_type` VALUES (102, '执行模式', 'exec_mode', '0', 'admin', '2024-08-08 14:48:15', '', NULL, '0：固定策略 1：规则引擎 2：定时执行（cron）99：手动执行'); INSERT INTO `sys_dict_type` VALUES (104, '计量类型', 'meter_type', '0', 'admin', '2024-08-09 10:23:03', 'admin', '2024-08-09 10:23:30', '计量类型 0：不区分 1：峰电计量 2：谷电计量'); INSERT INTO `sys_dict_type` VALUES (105, '设施对象类型', 'obj_type', '0', 'admin', '2024-08-12 14:22:40', 'admin', '2024-08-28 15:33:20', '对象类型 0：园区，1：区块，2：设施，3：设备'); INSERT INTO `sys_dict_type` VALUES (106, '标签', 'basecfg_lable', '0', 'admin', '2024-08-19 10:44:49', '', NULL, NULL); INSERT INTO `sys_dict_type` VALUES (107, '告警规则', 'alarm_thre_type', '0', 'admin', '2024-08-26 10:26:49', '', NULL, '1大于；2小于'); INSERT INTO `sys_dict_type` VALUES (108, '告警类型', 'alarm_type', '0', 'admin', '2024-08-26 10:28:04', '', NULL, '1：一般 2：重要 3：紧急 4：恢复 5：诊断 6：其他'); INSERT INTO `sys_dict_type` VALUES (109, '告警状态', 'alarm_state', '0', 'admin', '2024-08-26 11:39:44', 'admin', '2024-08-26 11:40:27', '0-新增，1-处置中，2-已处置，3-消散'); INSERT INTO `sys_dict_type` VALUES (110, '设备台账对象类型', 'device_type', '0', 'admin', '2024-08-27 15:00:16', '', NULL, '设备台账对象类型'); INSERT INTO `sys_dict_type` VALUES (111, '巡检类型', 'task_type', '0', 'admin', '2024-08-29 14:28:37', '', NULL, '1自动；2手动'); INSERT INTO `sys_dict_type` VALUES (112, '巡检状态', 'task_status', '0', 'admin', '2024-08-29 14:30:35', 'admin', '2024-08-29 16:18:01', '0未完成，1进行中，2已完成，3已超期'); INSERT INTO `sys_dict_type` VALUES (113, '巡检结果', 'inspection_result', '0', 'admin', '2024-08-29 16:49:17', '', NULL, '结果状态 0：正常 1：异常'); -- ---------------------------- -- 初始化-字典数据 -- ---------------------------- INSERT INTO `sys_dict_data` VALUES (100, 0, '运行', '0', 'sys_device_stat', NULL, 'default', 'N', '0', 'admin', '2024-08-07 10:22:55', 'admin', '2024-08-07 11:12:50', NULL); INSERT INTO `sys_dict_data` VALUES (101, 0, '故障', '1', 'sys_device_stat', NULL, 'default', 'N', '0', 'admin', '2024-08-07 10:23:36', 'admin', '2024-08-07 11:12:56', NULL); INSERT INTO `sys_dict_data` VALUES (102, 0, '未运行', '2', 'sys_device_stat', NULL, 'default', 'N', '0', 'admin', '2024-08-07 10:23:48', 'admin', '2024-08-07 11:13:00', NULL); INSERT INTO `sys_dict_data` VALUES (103, 0, '源网策略', '1', 'strategy_type', NULL, 'default', 'N', '0', 'admin', '2024-08-08 14:46:37', '', NULL, NULL); INSERT INTO `sys_dict_data` VALUES (104, 0, '源荷策略', '2', 'strategy_type', NULL, 'default', 'N', '0', 'admin', '2024-08-08 14:46:55', '', NULL, NULL); INSERT INTO `sys_dict_data` VALUES (105, 0, '网储策略', '3', 'strategy_type', NULL, 'default', 'N', '0', 'admin', '2024-08-08 14:46:55', '', NULL, NULL); INSERT INTO `sys_dict_data` VALUES (106, 0, '其他', '4', 'strategy_type', NULL, 'default', 'N', '0', 'admin', '2024-08-08 14:46:55', '', NULL, NULL); INSERT INTO `sys_dict_data` VALUES (107, 0, '自动执行', '1', 'exec_mode', NULL, 'default', 'N', '0', 'admin', '2024-08-08 14:49:06', '', NULL, NULL); INSERT INTO `sys_dict_data` VALUES (108, 0, '定时执行（cron）', '2', 'exec_mode', NULL, 'default', 'N', '0', 'admin', '2024-08-08 14:49:06', '', NULL, NULL); INSERT INTO `sys_dict_data` VALUES (109, 0, '手动执行', '99', 'exec_mode', NULL, 'default', 'N', '0', 'admin', '2024-08-08 14:49:34', '', NULL, '手动执行'); INSERT INTO `sys_dict_data` VALUES (111, 0, '不区分', '0', 'meter_type', NULL, 'default', 'N', '0', 'admin', '2024-08-09 10:23:59', '', NULL, '0：不区分 '); INSERT INTO `sys_dict_data` VALUES (112, 0, '峰电计量', '1', 'meter_type', NULL, 'default', 'N', '0', 'admin', '2024-08-09 10:24:14', '', NULL, '1：峰电计量 '); INSERT INTO `sys_dict_data` VALUES (113, 0, '谷电计量', '2', 'meter_type', NULL, 'default', 'N', '0', 'admin', '2024-08-09 10:24:24', '', NULL, '2：谷电计量'); INSERT INTO `sys_dict_data` VALUES (114, 0, '区域', '1', 'obj_type', NULL, 'default', 'N', '0', 'admin', '2024-08-12 14:23:19', 'admin', '2024-08-28 15:33:44', ''); INSERT INTO `sys_dict_data` VALUES (115, 0, '设施', '2', 'obj_type', NULL, 'default', 'N', '0', 'admin', '2024-08-12 14:23:30', '', NULL, ' 2-设施 '); INSERT INTO `sys_dict_data` VALUES (116, 0, '设备', '3', 'obj_type', NULL, 'default', 'N', '0', 'admin', '2024-08-12 14:23:40', 'admin', '2024-08-12 14:23:47', '3-设备'); INSERT INTO `sys_dict_data` VALUES (117, 1, 'photovoltaic', '100', 'basecfg_lable', NULL, 'default', 'N', '0', 'admin', '2024-08-19 10:50:16', 'admin', '2024-08-19 14:33:00', '光伏'); INSERT INTO `sys_dict_data` VALUES (118, 2, 'energy', '200', 'basecfg_lable', NULL, 'default', 'N', '0', 'admin', '2024-08-19 10:50:59', '', NULL, '能源'); INSERT INTO `sys_dict_data` VALUES (119, 3, 'Energy storage', '300', 'basecfg_lable', NULL, 'default', 'N', '0', 'admin', '2024-08-19 10:51:30', '', NULL, '储能'); INSERT INTO `sys_dict_data` VALUES (120, 0, '大于', '1', 'alarm_thre_type', NULL, 'default', 'N', '0', 'admin', '2024-08-26 10:27:12', '', NULL, NULL); INSERT INTO `sys_dict_data` VALUES (121, 0, '小于', '2', 'alarm_thre_type', NULL, 'default', 'N', '0', 'admin', '2024-08-26 10:27:26', '', NULL, NULL); INSERT INTO `sys_dict_data` VALUES (122, 0, '一般', '1', 'alarm_type', NULL, 'default', 'N', '0', 'admin', '2024-08-26 10:28:19', 'admin', '2024-08-27 14:41:59', '1：一般告警'); INSERT INTO `sys_dict_data` VALUES (123, 0, '重要', '2', 'alarm_type', NULL, 'default', 'N', '0', 'admin', '2024-08-26 10:28:27', 'admin', '2024-08-26 10:28:40', '2：重要告警'); INSERT INTO `sys_dict_data` VALUES (124, 0, '紧急', '3', 'alarm_type', NULL, 'default', 'N', '0', 'admin', '2024-08-26 10:28:53', '', NULL, '3：紧急告警'); INSERT INTO `sys_dict_data` VALUES (125, 0, '恢复', '4', 'alarm_type', NULL, 'default', 'N', '0', 'admin', '2024-08-26 10:29:17', '', NULL, '4：恢复告警 '); INSERT INTO `sys_dict_data` VALUES (126, 0, '诊断', '5', 'alarm_type', NULL, 'default', 'N', '0', 'admin', '2024-08-26 10:29:30', '', NULL, '5：诊断告警 '); INSERT INTO `sys_dict_data` VALUES (127, 0, '其他', '6', 'alarm_type', NULL, 'default', 'N', '0', 'admin', '2024-08-26 10:29:38', '', NULL, '6：其他告警'); INSERT INTO `sys_dict_data` VALUES (128, 0, '新增', '0', 'alarm_state', NULL, 'default', 'N', '0', 'admin', '2024-08-26 11:40:51', '', NULL, '0-新增，'); INSERT INTO `sys_dict_data` VALUES (129, 0, '处置中', '1', 'alarm_state', NULL, 'default', 'N', '0', 'admin', '2024-08-26 11:41:06', '', NULL, '1-处置中，'); INSERT INTO `sys_dict_data` VALUES (130, 0, '已处置', '2', 'alarm_state', NULL, 'default', 'N', '0', 'admin', '2024-08-26 11:41:19', '', NULL, '2-已处置，'); INSERT INTO `sys_dict_data` VALUES (131, 0, '消散', '3', 'alarm_state', NULL, 'default', 'N', '0', 'admin', '2024-08-26 11:41:30', '', NULL, '3-消散'); INSERT INTO `sys_dict_data` VALUES (133, 1, '设施', '1', 'device_type', NULL, 'default', 'N', '0', 'admin', '2024-08-27 15:02:15', '', NULL, NULL); INSERT INTO `sys_dict_data` VALUES (132, 2, '设备', '0', 'device_type', NULL, 'default', 'N', '0', 'admin', '2024-08-27 15:02:01', '', NULL, NULL); INSERT INTO `sys_dict_data` VALUES (134, 0, '园区', '0', 'obj_type', NULL, 'default', 'N', '0', 'admin', '2024-08-28 15:34:10', '', NULL, '对象类型 0：园区，1：区块，2：设施，3：设备'); INSERT INTO `sys_dict_data` VALUES (135, 0, '自动', '1', 'task_type', NULL, 'default', 'N', '0', 'admin', '2024-08-29 14:28:57', '', NULL, '1自动；2手动'); INSERT INTO `sys_dict_data` VALUES (136, 0, '手动', '2', 'task_type', NULL, 'default', 'N', '0', 'admin', '2024-08-29 14:29:12', '', NULL, '手动'); INSERT INTO `sys_dict_data` VALUES (137, 0, '自动巡检', 'EMS_AUTO_TASK', 'sys_job_group', NULL, 'default', 'N', '0', 'admin', '2024-08-29 16:11:54', 'admin', '2024-08-29 16:12:21', NULL); INSERT INTO `sys_dict_data` VALUES (138, 0, '未完成', '0', 'task_status', NULL, 'default', 'N', '0', 'admin', '2024-08-29 16:18:23', '', NULL, '0未完成，'); INSERT INTO `sys_dict_data` VALUES (139, 0, '进行中', '1', 'task_status', NULL, 'default', 'N', '0', 'admin', '2024-08-29 16:18:39', '', NULL, '1进行中，'); INSERT INTO `sys_dict_data` VALUES (140, 0, '已完成', '2', 'task_status', NULL, 'default', 'N', '0', 'admin', '2024-08-29 16:18:55', '', NULL, '2已完成，'); INSERT INTO `sys_dict_data` VALUES (141, 0, '已超期', '3', 'task_status', NULL, 'default', 'N', '0', 'admin', '2024-08-29 16:19:05', '', NULL, '3已超期'); INSERT INTO `sys_dict_data` VALUES (142, 0, '正常', '0', 'inspection_result', NULL, 'default', 'N', '0', 'admin', '2024-08-29 16:49:39', '', NULL, '结果状态 0：正常 1：异常'); INSERT INTO `sys_dict_data` VALUES (143, 0, '异常', '1', 'inspection_result', NULL, 'default', 'N', '0', 'admin', '2024-08-29 16:49:55', '', NULL, NULL); -- ---------------------------- -- 初始化-系统配置数据 -- ---------------------------- insert into sys_config values(6, '系统信息-平台标题', 'sys.info.title', '常泰大桥服务区能源管理', 'Y', 'admin', sysdate(), '', null, null); insert into sys_config values(7, '主路光伏大屏标题', 'sys.info.pv-road-title', '常泰大桥服务区主路光伏', 'Y', 'admin', sysdate(), '', null, null); INSERT INTO sys_config VALUES (8,'储能设备桩机容量','storage-equipped-capacity','storage-equipped-capacity','Y','admin','2025-06-23 14:43:29','admin','2025-07-01 16:20:10','{ "321283124S3001": { "name": "南区", "pv":660.8, "store":200 }, "321283124S3002": {"name": "北区", "pv":605.05, "store":200 }}');