Inicio Explorar Ayuda
Registro Iniciar sesión
hs
/
prod_group_bg
8
0
Fork 0
Archivos Incidencias 0 Pull Requests 0 Wiki
Árbol: 87413d25ec
Ramas Etiquetas
prod_group_bg
/
ems
/
sql
/
ems_sys_data.sql

ems_sys_data.sql 72 KB
Histórico Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656 
  1. SET NAMES utf8mb4;
    2. 

  2. 

  3. -- ----------------------------
    4. 

  4. -- 初始化-部门表数据
    5. 

  5. -- ----------------------------
    6. 

  6. insert into sys_dept values(101,  100, '0,100',      '常泰服务区（北）', 1, '华设集团', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
    7. 

  7. insert into sys_dept values(102,  100, '0,100',      '常泰服务区（南）', 2, '华设集团', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
    8. 

  8. insert into sys_dept values(103,  101, '0,100,101',  '北区监控组',   3, '华设集团', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
    9. 

  9. insert into sys_dept values(104,  101, '0,100,101',  '北区运维组',   4, '华设集团', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
    10. 

  10. insert into sys_dept values(105,  101, '0,100,101',  '北区机电组',   5, '华设集团', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
    11. 

  11. insert into sys_dept values(106,  102, '0,100,102',  '南区监控组',   6, '华设集团', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
    12. 

  12. insert into sys_dept values(107,  102, '0,100,102',  '南区机电组',   7, '华设集团', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
    13. 

  13. insert into sys_dept values(108,  102, '0,100,102',  '南区运维组',   8, '华设集团', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
    14. 

  14. 

  15. 

  16. -- ----------------------------
    17. 

  17. -- 初始化-岗位信息表数据
    18. 

  18. -- ----------------------------
    19. 

  19. insert into sys_post values(2, 'se',   '运营经理',  2, '0', 'admin', sysdate(), '', null, '');
    20. 

  20. insert into sys_post values(3, 'worker',  '机修岗',  3, '0', 'admin', sysdate(), '', null, '');
    21. 

  21. insert into sys_post values(4, 'user', '普通员工',  4, '0', 'admin', sysdate(), '', null, '');
    22. 

  22. 

  23. -- ----------------------------
    24. 

  24. -- 初始化-菜单信息表数据
    25. 

  25. -- ----------------------------
    26. 

  26. -- 一级菜单
    27. 

  27. insert into sys_menu values ('1',  '监控', '0', '1', 'view',             null, '', 1, 0, 'M', '0', '0', '',  'eye-open',    'admin', sysdate(), '', null, '监控大屏');
    28. 

  28. insert into sys_menu values ('2',  '能管', '0', '2', 'power-mgr',        null, '', 1, 0, 'M', '0', '0', '',  'energy',      'admin', sysdate(), '', null, '能流态势');
    29. 

  29. insert into sys_menu values ('3',  '数据', '0', '3', 'analysis',         null, '', 1, 0, 'M', '0', '0', '',  'analysis',    'admin', sysdate(), '', null, '数据分析');
    30. 

  30. insert into sys_menu values ('4',  '设备', '0', '4', 'device-mgr',       null, '', 1, 0, 'M', '0', '0', '',  'devicemgr',   'admin', sysdate(), '', null, '设备管理');
    31. 

  31. insert into sys_menu values ('5',  '运维', '0', '5', 'oper-mgr',         null, '', 1, 0, 'M', '0', '0', '',  'opermgr',     'admin', sysdate(), '', null, '运维保障');
    32. 

  32. insert into sys_menu values ('6',  '设置', '0', '6', 'param-cfg',        null, '', 1, 0, 'M', '0', '0', '',  'paramcfg',    'admin', sysdate(), '', null, '业务配置');
    33. 

  33. insert into sys_menu values ('7',  '系统', '0', '7', 'system',           null, '', 1, 0, 'M', '0', '0', '',  'system',      'admin', sysdate(), '', null, '系统管理');
    34. 

  34. insert into sys_menu values ('99', '开发工具', '0', '99', 'tool',            null, '', 1, 0, 'M', '0', '0', '',  'tool',        'admin', sysdate(), '', null, '开发工具');
    35. 

  35. 

  36. -- 二级菜单
    37. 

  37. insert into sys_menu values ('100',  '服务区',         '1',   '1',   '/largeScreen',         'view/servicearea',          '', 1, 0, 'C', '0', '0',   'view:service-area',      'servicearea',    'admin', sysdate(), '', null, '园区能源概览');
    38. 

  38. insert into sys_menu values ('101',  '主路光伏',       '1',   '2',   'hp-view-rpv',        'view/road/photovoltaic',    '', 1, 0, 'C', '0', '0',   'view:road-pv',           'photovoltaic',   'admin', sysdate(), '', null, '主路光伏概览');
    39. 

  39. 

  40. insert into sys_menu values ('111',  '源网',            '2',    '1',  'strategy-pg',        'mgr/powergrid',             '', 1, 0, 'C', '0', '0',   'power-mgr:pg',           'powergrid',      'admin', sysdate(), '', null, '源网协调');
    41. 

  41. insert into sys_menu values ('112',  '储能',            '2',    '2',  'strategy-gs',        'mgr/powerstore',            '', 1, 0, 'C', '0', '0',   'power-mgr:gs',           'powerstore',     'admin', sysdate(), '', null, '网储互动');
    42. 

  42. insert into sys_menu values ('113',  '负荷',            '2',    '3',  'strategy-use',       'mgr/poweruse',              '', 1, 0, 'C', '0', '0',   'power-mgr:use',          'powerload',      'admin', sysdate(), '', null, '源荷互动');
    43. 

  43. insert into sys_menu values ('114',  '配电',            '2',    '4',  'powerdist',          'mgr/powerdist',             '', 1, 0, 'C', '0', '1',   'power-mgr:dist',         'powerdist',      'admin', sysdate(), '', null, '配电监控');
    44. 

  44. insert into sys_menu values ('115',  '充电桩',          '2',    '5',  'charging-pile',      'mgr/chargingpile',          '', 1, 0, 'C', '0', '0',   'power-mgr:chargingpile', 'chargingpile',   'admin', sysdate(), '', null, '充电桩');
    45. 

  45. insert into sys_menu values ('116',  '计费',            '2',    '6',  'charging',           'mgr/charging',              '', 1, 0, 'C', '0', '0',   'power-mgr:charging',     'charging',       'admin', sysdate(), '', null, '计费');
    46. 

  46. insert into sys_menu values ('117',  '策略',            '2',    '7',  'strategy-mgr',       'mgr/strategy',              '', 1, 0, 'C', '0', '0',   'power-mgr:strategy',     'strategy',       'admin', sysdate(), '', null, '管能策略');
    47. 

  47. 

  48. 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, '产能分析');
    49. 

  49. 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, '储能分析');
    50. 

  50. insert into sys_menu values ('128',  '用能分析',       '3',    '3',  'power-consume',      'analysis/power/consume',    '', 1, 0, 'C', '0', '0',    'analysis:power:consume', 'energyconsume',  'admin', sysdate(), '', null, '用能分析');
    51. 

  51. insert into sys_menu values ('129',  '节能分析',       '3',    '4',  'EmsEcoD',            'ems/EmsEcoD/index',         '', 1, 0, 'C', '0', '0', 'ems:EmsEcoD:list',    'energysave',     'admin', sysdate(), '', null, '节能分析');
    52. 

  52. insert into sys_menu values ('123',  '碳排分析',       '3',    '5',  'ca-analysis',        null,                        '', 1, 0, 'M', '0', '0', '',  'ca',          'admin', sysdate(), '', null, '碳排监测');
    53. 

  53. insert into sys_menu values ('120',  '趋势预测',       '3',    '6',  'prediction',         '',                          '', 1, 0, 'M', '0', '0',    '',                       'prediction',     'admin', sysdate(), '', null, '趋势预测');
    54. 

  54. insert into sys_menu values ('121',  '数据报表',       '3',    '7',  'analysis-statement', '',                          '', 1, 0, 'M', '0', '0',    'analysis:statement',     'statement',      'admin', sysdate(), '', null, '数据报表');
    55. 

  55. 

  56. insert into sys_menu values ('141',  '设备列表',       '4',    '1',  'device-attr',         'devmgr/attr',           '', 1, 0, 'C', '0', '0',    'ems:device:list',        'deviceattr',     'admin', sysdate(), '', null, '设备属性');
    57. 

  57. insert into sys_menu values ('142',  '设备台账',       '4',    '2',  'device-el',           'devmgr/el',              '', 1, 0, 'C', '0', '0',   'device:el',              'excel',          'admin', sysdate(), '', null, '设备台账');
    58. 

  58. insert into sys_menu values ('143',  '设备告警',       '4',    '3',  'analysis-warn',       'analysis/device/warn',   '', 1, 0, 'C', '0', '0',   'analysis:device',        'deviceanalyze',  'admin', sysdate(), '', null, '设备分析');
    59. 

  59. insert into sys_menu values ('144',  '抄表管理',       '4',    '4',  'deviceMeter',         '',                       '', 1, 0, 'M', '0', '0',   'device:meter',           'meterReading',   'admin', sysdate(), '', null, '抄表管理');
    60. 

  60. 

  61. INSERT INTO sys_menu VALUES ('151',  '告警策略',       '5',    '1',  'warn-strategy',       'alarm/index',            '', 1, 0, 'C', '0', '0',    'warn:strategy', 'warnstrategy', 'admin', '2024-08-29 15:40:27', 'admin', '2024-08-29 16:01:10', '告警策略');
    62. 

  62. INSERT INTO sys_menu VALUES ('152',  '告警列表',       '5',    '2',  'warn-list',           'alarm/alarm-info/index', '', 1, 0, 'C', '0', '0',    'warn:list', 'warnmsg', 'admin', '2024-08-29 15:40:27', 'admin', '2024-08-29 16:01:36', '告警策略');
    63. 

  63. INSERT INTO sys_menu VALUES ('153',  '巡检计划',       '5',    '3',  'oper-plan',           'task/index',             '', 1, 0, 'C', '0', '0',    'oper-mgr:task', 'task', 'admin', '2024-08-29 15:40:27', 'admin', '2024-08-29 16:02:38', '巡检任务');
    64. 

  64. insert into sys_menu values ('154',  '巡检报告',       '5',    '4',  'oper-report',         'task/report/index',      '', 1, 0, 'C', '0', '0',    'oper-mgr:report',        'note',           'admin', sysdate(), '', null, '巡检报告');
    65. 

  65. 

  66. insert into sys_menu values ('161',  '区域配置',       '6',    '1',  'areacfg',            'basecfg/area/index',    '', 1, 0, 'C', '0', '0',   'basecfg:area:list',      'cfgwrite',       'admin', sysdate(), '', null, '区域配置');
    67. 

  67. insert into sys_menu values ('162',  '设备设施',       '6',    '2',  'devicecfg',          '',                       '', 1, 0, 'M', '0', '0',   'basecfg:device',         'devicemgr',      'admin', sysdate(), '', null, '设备设施');
    68. 

  68. insert into sys_menu values ('163',  '能源计量',       '6',    '3',  'energycfg',          '',                       '', 1, 0, 'M', '0', '0',   'basecfg:energy',         'energy',         'admin', sysdate(), '', null, '能源计量');
    69. 

  69. insert into sys_menu values ('164',  '标签管理',       '6',    '4',  'emstag',             'basecfg/tag',            '', 1, 0, 'C', '0', '0',   'basecfg:tag:list',       'tree',           'admin', sysdate(), '', null, '标签菜单');
    70. 

  70. insert into sys_menu values ('165',  '系统对接',       '6',    '5',  'adapter',          null, '', 1, 0, 'M', '0', '0', '',  'client',      'admin', sysdate(), '', null, '系统对接');
    71. 

  71. 

  72. insert into sys_menu values ('170',  '用户管理',       '7',   '1',  'user',               'system/user/index',      '', 1, 0, 'C', '0', '0',   'system:user:list',       'user',           'admin', sysdate(), '', null, '用户管理菜单');
    73. 

  73. insert into sys_menu values ('171',  '角色管理',       '7',   '2',  'role',               'system/role/index',      '', 1, 0, 'C', '0', '0',   'system:role:list',       'peoples',        'admin', sysdate(), '', null, '角色管理菜单');
    74. 

  74. 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, '菜单管理菜单');
    75. 

  75. insert into sys_menu values ('173',  '部门管理',       '7',   '4',  'dept',               'system/dept/index',      '', 1, 0, 'C', '0', '0',   'system:dept:list',       'tree',           'admin', sysdate(), '', null, '部门管理菜单');
    76. 

  76. insert into sys_menu values ('174',  '岗位管理',       '7',   '5',  'post',               'system/post/index',      '', 1, 0, 'C', '0', '0',   'system:post:list',       'post',           'admin', sysdate(), '', null, '岗位管理菜单');
    77. 

  77. insert into sys_menu values ('175',  '字典管理',       '7',   '6',  'dict',               'system/dict/index',      '', 1, 0, 'C', '0', '0',   'system:dict:list',       'dict',           'admin', sysdate(), '', null, '字典管理菜单');
    78. 

  78. insert into sys_menu values ('176',  '参数设置',       '7',   '7',  'config',             'system/config/index',    '', 1, 0, 'C', '0', '0',   'system:config:list',     'edit',           'admin', sysdate(), '', null, '参数设置菜单');
    79. 

  79. insert into sys_menu values ('177',  '通知公告',       '7',   '8',  'notice',             'system/notice/index',    '', 1, 0, 'C', '0', '0',   'system:notice:list',     'message',        'admin', sysdate(), '', null, '通知公告菜单');
    80. 

  80. insert into sys_menu values ('178',  '日志管理',       '7',   '9',  'log',                '',                       '', 1, 0, 'M', '0', '0',   '',                       'log',            'admin', sysdate(), '', null, '日志管理菜单');
    81. 

  81. insert into sys_menu values ('179',  '在线用户',       '7',   '10', 'online',             'monitor/online/index',   '', 1, 0, 'C', '0', '0',   'monitor:online:list',    'online',         'admin', sysdate(), '', null, '在线用户菜单');
    82. 

  82. 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, '任务调度');
    83. 

  83. 

  84. insert into sys_menu values ('1650',  '系统信息',       '165',   '1',  'adapter-subsystem',  'adapter/subsystem/index',  '', 1, 0, 'C', '0', '0',   'adapter:subsystem:list',  'note',           'admin', sysdate(), '', null, '光伏');
    85. 

  85. insert into sys_menu values ('1651',  '光伏',          '165',   '2',  'adapter-pv',         'adapter/pv/index',      '', 1, 0, 'C', '0', '0',   'adapter:user:list',       'photovoltaic',        'admin', sysdate(), '', null, '光伏');
    86. 

  86. insert into sys_menu values ('1652',  '光储直柔',       '165',   '3',  'adapter-gczr',       'adapter/gczr/index',    '', 1, 0, 'C', '0', '0',   'adapter:role:list',       'deviceaccess',      'admin', sysdate(), '', null, '光储直柔');
    87. 

  87. insert into sys_menu values ('1653',  '光储充',         '165',   '4',  'adapter-gcc',        'adapter/gcc/index',     '', 1, 0, 'C', '0', '0',   'adapter:menu:list',       'energyconsume',       'admin', sysdate(), '', null, '光储充');
    88. 

  88. insert into sys_menu values ('1654',  '充电桩',         '165',   '5',  'adapter-cdz',        'adapter/cdz/index',     '', 1, 0, 'C', '0', '0',   'adapter:dept:list',       'powerstore',       'admin', sysdate(), '', null, '充电桩');
    89. 

  89. insert into sys_menu values ('1655',  '智慧照明',       '165',   '6',  'adapter-zm',         'adapter/zm/index',      '', 1, 0, 'C', '0', '0',   'adapter:post:list',       'system',        'admin', sysdate(), '', null, '智慧照明');
    90. 

  90. insert into sys_menu values ('1656',  '智慧海绵',       '165',   '7',  'adapter-hm',         'adapter/hm/index',      '', 1, 0, 'C', '0', '0',   'adapter:dict:list',       'system',        'admin', sysdate(), '', null, '智慧海绵');
    91. 

  91. insert into sys_menu values ('1657',  '垃圾厨余',       '165',   '8',  'adapter-ljcy',       'adapter/ljcy/index',    '', 1, 0, 'C', '0', '0',   'adapter:config:list',     'system',      'admin', sysdate(), '', null, '垃圾厨余');
    92. 

  92. insert into sys_menu values ('1658',  '能耗监测',       '165',   '9',  'adapter-nhjc',       'adapter/nhjc/index',    '', 1, 0, 'C', '0', '0',   'adapter:notice:list',     'system',      'admin', sysdate(), '', null, '能耗监测');
    93. 

  93. insert into sys_menu values ('1659',  '设备管理',       '165',   '10',  'adapter-devc',       'adapter/devc/index',    '', 1, 0, 'M', '0', '0',   'adapter:devc:list',       'system',      'admin', sysdate(), '', null, '设备管理');
    94. 

  94. 

  95. insert into sys_menu values ('997',  '表单构建',       '99',   '1',  'build',              'tool/build/index',       '', 1, 0, 'C', '0', '0',   'tool:build:list',        'build',          'admin', sysdate(), '', null, '表单构建菜单');
    96. 

  96. insert into sys_menu values ('998',  '代码生成',       '99',   '2',  'gen',                'tool/gen/index',         '', 1, 0, 'C', '0', '0',   'tool:gen:list',          'code',           'admin', sysdate(), '', null, '代码生成菜单');
    97. 

  97. 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, '系统接口菜单');
    98. 

  98. 

  99. -- 三级菜单
    100. 

  100. -- 预测菜单
    101. 

  101. insert into sys_menu values ('1200',  '产能预测', '120', '1',  'prediction-prod',    'prediction/prod',        '', 1, 0, 'C', '0', '0',   'prediction:prod',        'energyprod',     'admin', sysdate(), '', null, '产能预测');
    102. 

  102. insert into sys_menu values ('1201',  '用能预测', '120', '2',  'prediction-consume', 'prediction/consume',     '', 1, 0, 'C', '0', '0',   'prediction:consume',     'energyconsume',  'admin', sysdate(), '', null, '用能预测');
    103. 

  103. insert into sys_menu values ('1202',  '碳排预测', '120', '3',  'prediction-ca',      'prediction/ca',          '', 1, 0, 'C', '0', '0',   'prediction:ca',          'caemission',     'admin', sysdate(), '', null, '碳排预测');
    104. 

  104. -- 报表菜单
    105. 

  105. insert into sys_menu values ('1210',  '产能报表',   '121', '1',  'statement-prod',    'analysis/statement/prod',     '', 1, 0, 'C', '0', '0',    'analysis:statement:prod',      'energyprod',     'admin', sysdate(), '', null, '产能报表');
    106. 

  106. insert into sys_menu values ('1211',  '用能报表',   '121', '2',  'statement-consume', 'analysis/statement/consume',  '', 1, 0, 'C', '0', '0',    'analysis:statement:consume',   'energyconsume',  'admin', sysdate(), '', null, '用能报表');
    107. 

  107. insert into sys_menu values ('1212',  '告警报表',   '121', '3',  'statement-warn',    'analysis/statement/warn',     '', 1, 0, 'C', '0', '0',    'analysis:statement:warn',      'warn',     'admin', sysdate(), '', null, '告警报表');
    108. 

  108. insert into sys_menu values ('1213',  '自定义',     '121', '4',  'statement-warn',    'analysis/statement/custom',   '', 1, 0, 'C', '0', '0',   'analysis:statement:custom',    'statement-zdy',   'admin', sysdate(), '', null, '自定义报表');
    109. 

  109. 

  110. -- 碳分析菜单
    111. 

  111. insert into sys_menu values ('1231',  '碳排计量',       '123',    '1',  'ca-emission',        'ca/emission',            '', 1, 0, 'C', '0', '0',   'ca-analysis:emission',   'caemission',     'admin', sysdate(), '', null, '碳排分析');
    112. 

  112. insert into sys_menu values ('1232',  '碳汇测算',       '123',    '2',  'ca-sink',            'ca/emissionCalc',                '', 1, 0, 'C', '0', '0',   'ca-analysis:sink',       'casink',         'admin', sysdate(), '', null, '碳汇分析');
    113. 

  113. 

  114. -- 抄表管理菜单
    115. 

  115. insert into sys_menu values ('1440',  '手动抄表',   '144', '1',  'meterRead-manual',    'devmgr/meterRead',       '', 1, 0, 'C', '0', '0',   'ems:meterReading:list',  'meterReadManual',   'admin', sysdate(), '', null, '手动抄表');
    116. 

  116. insert into sys_menu values ('1441',  '自动抄表',   '144', '2',  'meterRead-auto',      'devmgr/meterData',       '', 1, 0, 'C', '0', '0',   'ems:meterData:list',  'meterReadAuto',   'admin', sysdate(), '', null, '抄表数据');
    117. 

  117. 

  118. -- 业务配置菜单
    119. 

  119. 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, '设备模型');
    120. 

  120. 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, '设施配置');
    121. 

  121. 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, '设备配置');
    122. 

  122. 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, '设施配置');
    123. 

  123. 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, '设备配置');
    124. 

  124. 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, '计量设备');
    125. 

  125. 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, '边界划分');
    126. 

  126. 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, '价格策略');
    127. 

  127. 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, '碳排因子');
    128. 

  128. insert into sys_menu values ('1634',  '折煤系数',   '163', '5',  'basecfg-dsccfg',         'basecfg/dsccfg/index',       '', 1, 0, 'C', '0', '0',   'basecfg:dsccfg:list',           'cfgwrite',   'admin', sysdate(), '', null, '折煤系数');
    129. 

  129. 

  130. -- 用户管理按钮
    131. 

  131. insert into sys_menu values ('1700', '用户查询', '170', '1',  '', '', '', 1, 0, 'F', '0', '0', 'system:user:query',          '#', 'admin', sysdate(), '', null, '');
    132. 

  132. insert into sys_menu values ('1701', '用户新增', '170', '2',  '', '', '', 1, 0, 'F', '0', '0', 'system:user:add',            '#', 'admin', sysdate(), '', null, '');
    133. 

  133. insert into sys_menu values ('1702', '用户修改', '170', '3',  '', '', '', 1, 0, 'F', '0', '0', 'system:user:edit',           '#', 'admin', sysdate(), '', null, '');
    134. 

  134. insert into sys_menu values ('1703', '用户删除', '170', '4',  '', '', '', 1, 0, 'F', '0', '0', 'system:user:remove',         '#', 'admin', sysdate(), '', null, '');
    135. 

  135. insert into sys_menu values ('1704', '用户导出', '170', '5',  '', '', '', 1, 0, 'F', '0', '0', 'system:user:export',         '#', 'admin', sysdate(), '', null, '');
    136. 

  136. insert into sys_menu values ('1705', '用户导入', '170', '6',  '', '', '', 1, 0, 'F', '0', '0', 'system:user:import',         '#', 'admin', sysdate(), '', null, '');
    137. 

  137. insert into sys_menu values ('1706', '重置密码', '170', '7',  '', '', '', 1, 0, 'F', '0', '0', 'system:user:resetPwd',       '#', 'admin', sysdate(), '', null, '');
    138. 

  138. -- 角色管理按钮
    139. 

  139. insert into sys_menu values ('1710', '角色查询', '171', '1',  '', '', '', 1, 0, 'F', '0', '0', 'system:role:query',          '#', 'admin', sysdate(), '', null, '');
    140. 

  140. insert into sys_menu values ('1711', '角色新增', '171', '2',  '', '', '', 1, 0, 'F', '0', '0', 'system:role:add',            '#', 'admin', sysdate(), '', null, '');
    141. 

  141. insert into sys_menu values ('1712', '角色修改', '171', '3',  '', '', '', 1, 0, 'F', '0', '0', 'system:role:edit',           '#', 'admin', sysdate(), '', null, '');
    142. 

  142. insert into sys_menu values ('1713', '角色删除', '171', '4',  '', '', '', 1, 0, 'F', '0', '0', 'system:role:remove',         '#', 'admin', sysdate(), '', null, '');
    143. 

  143. insert into sys_menu values ('1714', '角色导出', '171', '5',  '', '', '', 1, 0, 'F', '0', '0', 'system:role:export',         '#', 'admin', sysdate(), '', null, '');
    144. 

  144. -- 菜单管理按钮
    145. 

  145. insert into sys_menu values ('1720', '菜单查询', '172', '1',  '', '', '', 1, 0, 'F', '0', '0', 'system:menu:query',          '#', 'admin', sysdate(), '', null, '');
    146. 

  146. insert into sys_menu values ('1721', '菜单新增', '172', '2',  '', '', '', 1, 0, 'F', '0', '0', 'system:menu:add',            '#', 'admin', sysdate(), '', null, '');
    147. 

  147. insert into sys_menu values ('1722', '菜单修改', '172', '3',  '', '', '', 1, 0, 'F', '0', '0', 'system:menu:edit',           '#', 'admin', sysdate(), '', null, '');
    148. 

  148. insert into sys_menu values ('1723', '菜单删除', '172', '4',  '', '', '', 1, 0, 'F', '0', '0', 'system:menu:remove',         '#', 'admin', sysdate(), '', null, '');
    149. 

  149. -- 部门管理按钮
    150. 

  150. insert into sys_menu values ('1730', '部门查询', '173', '1',  '', '', '', 1, 0, 'F', '0', '0', 'system:dept:query',          '#', 'admin', sysdate(), '', null, '');
    151. 

  151. insert into sys_menu values ('1731', '部门新增', '173', '2',  '', '', '', 1, 0, 'F', '0', '0', 'system:dept:add',            '#', 'admin', sysdate(), '', null, '');
    152. 

  152. insert into sys_menu values ('1732', '部门修改', '173', '3',  '', '', '', 1, 0, 'F', '0', '0', 'system:dept:edit',           '#', 'admin', sysdate(), '', null, '');
    153. 

  153. insert into sys_menu values ('1733', '部门删除', '173', '4',  '', '', '', 1, 0, 'F', '0', '0', 'system:dept:remove',         '#', 'admin', sysdate(), '', null, '');
    154. 

  154. -- 岗位管理按钮
    155. 

  155. insert into sys_menu values ('1740', '岗位查询', '174', '1',  '', '', '', 1, 0, 'F', '0', '0', 'system:post:query',          '#', 'admin', sysdate(), '', null, '');
    156. 

  156. insert into sys_menu values ('1741', '岗位新增', '174', '2',  '', '', '', 1, 0, 'F', '0', '0', 'system:post:add',            '#', 'admin', sysdate(), '', null, '');
    157. 

  157. insert into sys_menu values ('1742', '岗位修改', '174', '3',  '', '', '', 1, 0, 'F', '0', '0', 'system:post:edit',           '#', 'admin', sysdate(), '', null, '');
    158. 

  158. insert into sys_menu values ('1743', '岗位删除', '174', '4',  '', '', '', 1, 0, 'F', '0', '0', 'system:post:remove',         '#', 'admin', sysdate(), '', null, '');
    159. 

  159. insert into sys_menu values ('1744', '岗位导出', '174', '5',  '', '', '', 1, 0, 'F', '0', '0', 'system:post:export',         '#', 'admin', sysdate(), '', null, '');
    160. 

  160. -- 字典管理按钮
    161. 

  161. insert into sys_menu values ('1750', '字典查询', '175', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:query',          '#', 'admin', sysdate(), '', null, '');
    162. 

  162. insert into sys_menu values ('1751', '字典新增', '175', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:add',            '#', 'admin', sysdate(), '', null, '');
    163. 

  163. insert into sys_menu values ('1752', '字典修改', '175', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:edit',           '#', 'admin', sysdate(), '', null, '');
    164. 

  164. insert into sys_menu values ('1753', '字典删除', '175', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:remove',         '#', 'admin', sysdate(), '', null, '');
    165. 

  165. insert into sys_menu values ('1754', '字典导出', '175', '5', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:export',         '#', 'admin', sysdate(), '', null, '');
    166. 

  166. -- 参数设置按钮
    167. 

  167. insert into sys_menu values ('1760', '参数查询', '176', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:query',        '#', 'admin', sysdate(), '', null, '');
    168. 

  168. insert into sys_menu values ('1761', '参数新增', '176', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:add',          '#', 'admin', sysdate(), '', null, '');
    169. 

  169. insert into sys_menu values ('1762', '参数修改', '176', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:edit',         '#', 'admin', sysdate(), '', null, '');
    170. 

  170. insert into sys_menu values ('1763', '参数删除', '176', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:remove',       '#', 'admin', sysdate(), '', null, '');
    171. 

  171. insert into sys_menu values ('1764', '参数导出', '176', '5', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:export',       '#', 'admin', sysdate(), '', null, '');
    172. 

  172. -- 通知公告按钮
    173. 

  173. insert into sys_menu values ('1770',  '公告查询', '177', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:query',        '#', 'admin', sysdate(), '', null, '');
    174. 

  174. insert into sys_menu values ('1771',  '公告新增', '177', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:add',          '#', 'admin', sysdate(), '', null, '');
    175. 

  175. insert into sys_menu values ('1772',  '公告修改', '177', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:edit',         '#', 'admin', sysdate(), '', null, '');
    176. 

  176. insert into sys_menu values ('1773',  '公告删除', '177', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:remove',       '#', 'admin', sysdate(), '', null, '');
    177. 

  177. insert into sys_menu values ('1780',  '操作日志', '178', '1',  'operlog',           'system/operlog/index',       '', 1, 0, 'C', '0', '0',    'system:operlog:list',          'form',          'admin', sysdate(), '', null, '操作日志菜单');
    178. 

  178. insert into sys_menu values ('1781',  '登录日志', '178', '2',  'logininfor',        'system/logininfor/index',    '', 1, 0, 'C', '0', '0',    'system:logininfor:list',       'logininfor',    'admin', sysdate(), '', null, '登录日志菜单');
    179. 

  179. 

  180. -- 操作日志按钮
    181. 

  181. insert into sys_menu values ('17800', '操作查询', '1780', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:operlog:query',       '#', 'admin', sysdate(), '', null, '');
    182. 

  182. insert into sys_menu values ('17801', '操作删除', '1780', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:operlog:remove',      '#', 'admin', sysdate(), '', null, '');
    183. 

  183. insert into sys_menu values ('17802', '日志导出', '1780', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:operlog:export',      '#', 'admin', sysdate(), '', null, '');
    184. 

  184. -- 登录日志按钮
    185. 

  185. insert into sys_menu values ('17810', '登录查询', '1781', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:logininfor:query',    '#', 'admin', sysdate(), '', null, '');
    186. 

  186. insert into sys_menu values ('17811', '登录删除', '1781', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:logininfor:remove',   '#', 'admin', sysdate(), '', null, '');
    187. 

  187. insert into sys_menu values ('17812', '日志导出', '1781', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:logininfor:export',   '#', 'admin', sysdate(), '', null, '');
    188. 

  188. insert into sys_menu values ('17813', '账户解锁', '1781', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:logininfor:unlock',   '#', 'admin', sysdate(), '', null, '');
    189. 

  189. -- 在线用户按钮
    190. 

  190. insert into sys_menu values ('1790', '在线查询', '179', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:query',       '#', 'admin', sysdate(), '', null, '');
    191. 

  191. insert into sys_menu values ('1791', '批量强退', '179', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:batchLogout', '#', 'admin', sysdate(), '', null, '');
    192. 

  192. insert into sys_menu values ('1792', '单条强退', '179', '3', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:forceLogout', '#', 'admin', sysdate(), '', null, '');
    193. 

  193. -- 能源设施分类配置按钮
    194. 

  194. insert into sys_menu values ('16200', '分类新增', '1620', '1', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:facscategory:add',   '#', 'admin', sysdate(), '', null, '');
    195. 

  195. insert into sys_menu values ('16201', '分类修改', '1620', '2', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:facscategory:edit',  '#', 'admin', sysdate(), '', null, '');
    196. 

  196. insert into sys_menu values ('16202', '分类删除', '1620', '3', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:facscategory:remove','#', 'admin', sysdate(), '', null, '');
    197. 

  197. -- 服务区能源设施配置按钮
    198. 

  198. insert into sys_menu values ('16210', '设施新增', '1621', '1', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:emsfacs:add',   '#', 'admin', sysdate(), '', null, '');
    199. 

  199. insert into sys_menu values ('16211', '设施修改', '1621', '2', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:emsfacs:edit',  '#', 'admin', sysdate(), '', null, '');
    200. 

  200. insert into sys_menu values ('16212', '设施删除', '1621', '3', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:emsfacs:remove','#', 'admin', sysdate(), '', null, '');
    201. 

  201. insert into sys_menu values ('16213', '设施导出', '1621', '4', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:emsfacs:export','#', 'admin', sysdate(), '', null, '');
    202. 

  202. -- 服务区能流关系配置按钮
    203. 

  203. insert into sys_menu values ('16220', '关系新增', '1622', '1', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:flowrel:add',   '#', 'admin', sysdate(), '', null, '');
    204. 

  204. insert into sys_menu values ('16221', '关系修改', '1622', '2', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:flowrel:edit',  '#', 'admin', sysdate(), '', null, '');
    205. 

  205. insert into sys_menu values ('16222', '关系删除', '1622', '3', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:flowrel:remove','#', 'admin', sysdate(), '', null, '');
    206. 

  206. -- 服务区设备配置按钮
    207. 

  207. insert into sys_menu values ('16230', '设备新增', '1623', '1', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:flowrel:add',   '#', 'admin', sysdate(), '', null, '');
    208. 

  208. insert into sys_menu values ('16231', '设备修改', '1623', '2', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:flowrel:edit',  '#', 'admin', sysdate(), '', null, '');
    209. 

  209. insert into sys_menu values ('16232', '设备删除', '1623', '3', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:flowrel:remove','#', 'admin', sysdate(), '', null, '');
    210. 

  210. insert into sys_menu values ('16233', '设备导出', '1623', '4', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:flowrel:export','#', 'admin', sysdate(), '', null, '');
    211. 

  211. 

  212. -- 能源策略按钮
    213. 

  213. INSERT INTO sys_menu VALUES (1150, 'list', 115, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:strategy:list', '#', 'admin', sysdate(), '', NULL, '');
    214. 

  214. INSERT INTO sys_menu VALUES (1151, 'export', 115, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:strategy:export', '#', 'admin', sysdate(), '', NULL, '');
    215. 

  215. INSERT INTO sys_menu VALUES (1152, 'query', 115, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:strategy:query', '#', 'admin', sysdate(), '', NULL, '');
    216. 

  216. INSERT INTO sys_menu VALUES (1153, 'add', 115, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:strategy:add', '#', 'admin', sysdate(), '', NULL, '');
    217. 

  217. INSERT INTO sys_menu VALUES (1154, 'edit', 115, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:strategy:edit', '#', 'admin', sysdate(), '', NULL, '');
    218. 

  218. INSERT INTO sys_menu VALUES (1155, 'remove', 115, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:strategy:remove', '#', 'admin', sysdate(), '', NULL, '');
    219. 

  219. 

  220. -- 源网协调按钮
    221. 

  221. INSERT INTO `sys_menu` VALUES (1120, 'list',112, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:pg:list', '#', 'admin', sysdate(), '', NULL, '');
    222. 

  222. INSERT INTO `sys_menu` VALUES (1121, 'export',112, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:pg:export', '#', 'admin', sysdate(), '', NULL, '');
    223. 

  223. INSERT INTO `sys_menu` VALUES (1122, 'query',112, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:pg:query', '#', 'admin', sysdate(), '', NULL, '');
    224. 

  224. INSERT INTO `sys_menu` VALUES (1123, 'add',112, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:pg:add', '#', 'admin', sysdate(), '', NULL, '');
    225. 

  225. INSERT INTO `sys_menu` VALUES (1124, 'edit',112, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:pg:edit', '#', 'admin', sysdate(), '', NULL, '');
    226. 

  226. INSERT INTO `sys_menu` VALUES (1125, 'remove',112, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:pg:remove', '#', 'admin', sysdate(), '', NULL, '');
    227. 

  227. -- 网储互动
    228. 

  228. INSERT INTO `sys_menu` VALUES (1130,'list',113, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:gs:list', '#', 'admin', sysdate(), '', NULL, '');
    229. 

  229. INSERT INTO `sys_menu` VALUES (1131,'export',113, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:gs:export', '#', 'admin', sysdate(), '', NULL, '');
    230. 

  230. INSERT INTO `sys_menu` VALUES (1132,'query',113, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:gs:query', '#', 'admin', sysdate(), '', NULL, '');
    231. 

  231. INSERT INTO `sys_menu` VALUES (1133,'add',113, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:gs:add', '#', 'admin', sysdate(), '', NULL, '');
    232. 

  232. INSERT INTO `sys_menu` VALUES (1134,'edit',113, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:gs:edit', '#', 'admin', sysdate(), '', NULL, '');
    233. 

  233. INSERT INTO `sys_menu` VALUES (1135,'remove',113, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:gs:remove', '#', 'admin', sysdate(), '', NULL, '');
    234. 

  234. 

  235. -- 告警策略
    236. 

  236. INSERT INTO sys_menu VALUES (1510, 'list', 151, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:alarm-strategy:list', '#', 'admin', '2024-08-26 11:08:42', '', NULL, '');
    237. 

  237. INSERT INTO sys_menu VALUES (1511, 'export', 151, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:alarm-strategy:export', '#', 'admin', '2024-08-26 11:08:42', '', NULL, '');
    238. 

  238. INSERT INTO sys_menu VALUES (1512, 'query', 151, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:alarm-strategy:query', '#', 'admin', '2024-08-26 11:08:42', '', NULL, '');
    239. 

  239. INSERT INTO sys_menu VALUES (1513, 'add', 151, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:alarm-strategy:add', '#', 'admin', '2024-08-26 11:08:42', '', NULL, '');
    240. 

  240. INSERT INTO sys_menu VALUES (1514, 'edit', 151, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:alarm-strategy:edit', '#', 'admin', '2024-08-26 11:08:42', '', NULL, '');
    241. 

  241. INSERT INTO sys_menu VALUES (1515, 'remove', 151, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:alarm-strategy:remove', '#', 'admin', '2024-08-26 11:08:42', '', NULL, '');
    242. 

  242. 

  243. -- 告警列表
    244. 

  244. INSERT INTO sys_menu VALUES (1520, 'list', 152, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:alarm-info:list', '#', 'admin', '2024-08-26 11:08:42', '', NULL, '');
    245. 

  245. INSERT INTO sys_menu VALUES (1521, 'export', 152, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:alarm-info:export', '#', 'admin', '2024-08-26 11:08:42', '', NULL, '');
    246. 

  246. INSERT INTO sys_menu VALUES (1522, 'query', 152, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:alarm-info:query', '#', 'admin', '2024-08-26 11:08:42', '', NULL, '');
    247. 

  247. INSERT INTO sys_menu VALUES (1523, 'add', 152, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:alarm-info:add', '#', 'admin', '2024-08-26 11:08:42', '', NULL, '');
    248. 

  248. INSERT INTO sys_menu VALUES (1524, 'edit', 152, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:alarm-info:edit', '#', 'admin', '2024-08-26 11:08:42', '', NULL, '');
    249. 

  249. INSERT INTO sys_menu VALUES (1525, 'remove', 152, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:alarm-info:remove', '#', 'admin', '2024-08-26 11:08:42', '', NULL, '');
    250. 

  250. 

  251. -- 产能预测
    252. 

  252. INSERT INTO `sys_menu` VALUES (12000,'list',1200, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:prod:list', '#', 'admin', sysdate(), '', NULL, '');
    253. 

  253. INSERT INTO `sys_menu` VALUES (12001,'export',1200, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:prod:export', '#', 'admin', sysdate(), '', NULL, '');
    254. 

  254. INSERT INTO `sys_menu` VALUES (12002,'query',1200, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:prod:query', '#', 'admin', sysdate(), '', NULL, '');
    255. 

  255. INSERT INTO `sys_menu` VALUES (12003,'add',1200, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:prod:add', '#', 'admin', sysdate(), '', NULL, '');
    256. 

  256. INSERT INTO `sys_menu` VALUES (12004,'edit',1200, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:prod:edit', '#', 'admin', sysdate(), '', NULL, '');
    257. 

  257. INSERT INTO `sys_menu` VALUES (12005,'remove',1200, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:prod:remove', '#', 'admin', sysdate(), '', NULL, '');
    258. 

  258. 

  259. -- 用能预测
    260. 

  260. INSERT INTO `sys_menu` VALUES (12010,'list',1201, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:consume:list', '#', 'admin', sysdate(), '', NULL, '');
    261. 

  261. INSERT INTO `sys_menu` VALUES (12011,'export',1201, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:consume:export', '#', 'admin', sysdate(), '', NULL, '');
    262. 

  262. INSERT INTO `sys_menu` VALUES (12012,'query',1201, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:consume:query', '#', 'admin', sysdate(), '', NULL, '');
    263. 

  263. INSERT INTO `sys_menu` VALUES (12013,'add',1201, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:consume:add', '#', 'admin', sysdate(), '', NULL, '');
    264. 

  264. INSERT INTO `sys_menu` VALUES (12014,'edit',1201, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:consume:edit', '#', 'admin', sysdate(), '', NULL, '');
    265. 

  265. INSERT INTO `sys_menu` VALUES (12015,'remove',1201, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:consume:remove', '#', 'admin', sysdate(), '', NULL, '');
    266. 

  266. 

  267. -- 碳排预测
    268. 

  268. INSERT INTO `sys_menu` VALUES (12020,'list',1202, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:ca:list', '#', 'admin', sysdate(), '', NULL, '');
    269. 

  269. INSERT INTO `sys_menu` VALUES (12021,'export',1202, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:ca:export', '#', 'admin', sysdate(), '', NULL, '');
    270. 

  270. INSERT INTO `sys_menu` VALUES (12022,'query',1202, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:ca:query', '#', 'admin', sysdate(), '', NULL, '');
    271. 

  271. INSERT INTO `sys_menu` VALUES (12023,'add',1202, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:ca:add', '#', 'admin', sysdate(), '', NULL, '');
    272. 

  272. INSERT INTO `sys_menu` VALUES (12024,'edit',1202, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:ca:edit', '#', 'admin', sysdate(), '', NULL, '');
    273. 

  273. INSERT INTO `sys_menu` VALUES (12025,'remove',1202, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:ca:remove', '#', 'admin', sysdate(), '', NULL, '');
    274. 

  274. -- 节能分析
    275. 

  275. 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)
    276. 

  276. values(12901,'节能计量日查询', 129, '1',  '#', '', 1, 0, 'F', '0', '0', 'ems:EmsEcoD:query',        '#', 'admin', sysdate(), '', null, '');
    277. 

  277. 

  278. 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)
    279. 

  279. values(12902,'节能计量日新增', 129, '2',  '#', '', 1, 0, 'F', '0', '0', 'ems:EmsEcoD:add',          '#', 'admin', sysdate(), '', null, '');
    280. 

  280. 

  281. 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)
    282. 

  282. values(12903,'节能计量日修改', 129, '3',  '#', '', 1, 0, 'F', '0', '0', 'ems:EmsEcoD:edit',         '#', 'admin', sysdate(), '', null, '');
    283. 

  283. 

  284. 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)
    285. 

  285. values(12904,'节能计量日删除', 129, '4',  '#', '', 1, 0, 'F', '0', '0', 'ems:EmsEcoD:remove',       '#', 'admin', sysdate(), '', null, '');
    286. 

  286. 

  287. 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)
    288. 

  288. values(12905,'节能计量日导出', 129, '5',  '#', '', 1, 0, 'F', '0', '0', 'ems:EmsEcoD:export',       '#', 'admin', sysdate(), '', null, '');
    289. 

  289. 

  290. -- 碳排计量
    291. 

  291. INSERT INTO `sys_menu` VALUES (1310,'list',131, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:emission:list', '#', 'admin', sysdate(), '', NULL, '');
    292. 

  292. INSERT INTO `sys_menu` VALUES (1311,'export',131, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:emission:export', '#', 'admin', sysdate(), '', NULL, '');
    293. 

  293. INSERT INTO `sys_menu` VALUES (1312,'query',131, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:emission:query', '#', 'admin', sysdate(), '', NULL, '');
    294. 

  294. INSERT INTO `sys_menu` VALUES (1313,'add',131, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:emission:add', '#', 'admin', sysdate(), '', NULL, '');
    295. 

  295. INSERT INTO `sys_menu` VALUES (1314,'edit',131, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:emission:edit', '#', 'admin', sysdate(), '', NULL, '');
    296. 

  296. INSERT INTO `sys_menu` VALUES (1315,'remove',131, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:emission:remove', '#', 'admin', sysdate(), '', NULL, '');
    297. 

  297. 

  298. -- 碳汇计量
    299. 

  299. INSERT INTO `sys_menu` VALUES (1320,'list',132, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:sink:list', '#', 'admin', sysdate(), '', NULL, '');
    300. 

  300. INSERT INTO `sys_menu` VALUES (1321,'export',132, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:sink:export', '#', 'admin', sysdate(), '', NULL, '');
    301. 

  301. INSERT INTO `sys_menu` VALUES (1322,'query',132, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:sink:query', '#', 'admin', sysdate(), '', NULL, '');
    302. 

  302. INSERT INTO `sys_menu` VALUES (1323,'add',132, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:sink:add', '#', 'admin', sysdate(), '', NULL, '');
    303. 

  303. INSERT INTO `sys_menu` VALUES (1324,'edit',132, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:sink:edit', '#', 'admin', sysdate(), '', NULL, '');
    304. 

  304. INSERT INTO `sys_menu` VALUES (1325,'remove',132, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:sink:remove', '#', 'admin', sysdate(), '', NULL, '');
    305. 

  305. 

  306. -- 巡检任务
    307. 

  307. INSERT INTO sys_menu VALUES (1531, 'list', 153, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:inspection-task:list', '#', 'admin', '2024-08-26 11:08:42', '', NULL, '');
    308. 

  308. INSERT INTO sys_menu VALUES (1532, 'export', 153, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:inspection-task:export', '#', 'admin', '2024-08-26 11:08:42', '', NULL, '');
    309. 

  309. INSERT INTO sys_menu VALUES (1534, 'query', 153, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:inspection-task:query', '#', 'admin', '2024-08-26 11:08:42', '', NULL, '');
    310. 

  310. INSERT INTO sys_menu VALUES (1535, 'add', 153, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:inspection-task:add', '#', 'admin', '2024-08-26 11:08:42', '', NULL, '');
    311. 

  311. INSERT INTO sys_menu VALUES (1536, 'edit', 153, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:inspection-task:edit', '#', 'admin', '2024-08-26 11:08:42', '', NULL, '');
    312. 

  312. INSERT INTO sys_menu VALUES (1537, 'remove', 153, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:inspection-task:remove', '#', 'admin', '2024-08-26 11:08:42', '', NULL, '');
    313. 

  313. INSERT INTO sys_menu VALUES (1538, '执行一次', 153, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:auto-task:exc', '#', 'admin', '2024-08-26 11:08:42', '', NULL, '');
    314. 

  314. INSERT INTO sys_menu VALUES (1539, '任务查询权限', 153, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:auto-task:query', '#', 'admin', '2024-08-26 11:08:42', '', NULL, '');
    315. 

  315. 

  316. -- 巡检报告
    317. 

  317. 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, '');
    318. 

  318. 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, '');
    319. 

  319. 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, '');
    320. 

  320. INSERT INTO sys_menu VALUES (1544, '新增', 154, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:inspection-report:add', '#', 'admin', '2024-08-26 11:08:42', '', NULL, '');
    321. 

  321. INSERT INTO sys_menu VALUES (1545, '修改', 154, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:inspection-report:edit', '#', 'admin', '2024-08-26 11:08:42', '', NULL, '');
    322. 

  322. INSERT INTO sys_menu VALUES (1546, '删除', 154, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:inspection-report:remove', '#', 'admin', '2024-08-26 11:08:42', '', NULL, '');
    323. 

  323. 

  324. -- 任务调度
    325. 

  325. 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, '');
    326. 

  326. 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, '');
    327. 

  327. 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, '');
    328. 

  328. 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, '');
    329. 

  329. 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, '');
    330. 

  330. 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, '');
    331. 

  331. 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, '');
    332. 

  332. 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, '');
    333. 

  333. 

  334. 

  335. -- ----------------------------
    336. 

  336. -- 初始化-角色和菜单关联表数据
    337. 

  337. -- ----------------------------
    338. 

  338. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1);
    339. 

  339. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 2);
    340. 

  340. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 3);
    341. 

  341. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 4);
    342. 

  342. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 5);
    343. 

  343. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 6);
    344. 

  344. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 7);
    345. 

  345. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 99);
    346. 

  346. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 100);
    347. 

  347. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 101);
    348. 

  348. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 111);
    349. 

  349. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 112);
    350. 

  350. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 113);
    351. 

  351. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 114);
    352. 

  352. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 115);
    353. 

  353. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 116);
    354. 

  354. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 117);
    355. 

  355. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 120);
    356. 

  356. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 121);
    357. 

  357. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 123);
    358. 

  358. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 126);
    359. 

  359. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 127);
    360. 

  360. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 128);
    361. 

  361. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 129);
    362. 

  362. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 141);
    363. 

  363. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 142);
    364. 

  364. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 143);
    365. 

  365. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 144);
    366. 

  366. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 151);
    367. 

  367. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 152);
    368. 

  368. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 153);
    369. 

  369. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 154);
    370. 

  370. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 161);
    371. 

  371. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 162);
    372. 

  372. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 163);
    373. 

  373. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 164);
    374. 

  374. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 165);
    375. 

  375. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 170);
    376. 

  376. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 171);
    377. 

  377. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 172);
    378. 

  378. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 173);
    379. 

  379. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 174);
    380. 

  380. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 175);
    381. 

  381. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 176);
    382. 

  382. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 177);
    383. 

  383. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 178);
    384. 

  384. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 179);
    385. 

  385. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 180);
    386. 

  386. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 997);
    387. 

  387. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 998);
    388. 

  388. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 999);
    389. 

  389. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1120);
    390. 

  390. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1121);
    391. 

  391. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1122);
    392. 

  392. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1123);
    393. 

  393. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1124);
    394. 

  394. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1125);
    395. 

  395. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1130);
    396. 

  396. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1131);
    397. 

  397. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1132);
    398. 

  398. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1133);
    399. 

  399. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1134);
    400. 

  400. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1135);
    401. 

  401. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1150);
    402. 

  402. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1151);
    403. 

  403. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1152);
    404. 

  404. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1153);
    405. 

  405. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1154);
    406. 

  406. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1155);
    407. 

  407. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1200);
    408. 

  408. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1201);
    409. 

  409. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1202);
    410. 

  410. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1210);
    411. 

  411. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1211);
    412. 

  412. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1212);
    413. 

  413. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1213);
    414. 

  414. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1231);
    415. 

  415. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1232);
    416. 

  416. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1310);
    417. 

  417. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1311);
    418. 

  418. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1312);
    419. 

  419. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1313);
    420. 

  420. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1314);
    421. 

  421. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1315);
    422. 

  422. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1320);
    423. 

  423. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1321);
    424. 

  424. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1322);
    425. 

  425. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1323);
    426. 

  426. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1324);
    427. 

  427. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1325);
    428. 

  428. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1440);
    429. 

  429. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1441);
    430. 

  430. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1510);
    431. 

  431. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1511);
    432. 

  432. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1512);
    433. 

  433. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1513);
    434. 

  434. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1514);
    435. 

  435. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1515);
    436. 

  436. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1520);
    437. 

  437. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1521);
    438. 

  438. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1522);
    439. 

  439. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1523);
    440. 

  440. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1524);
    441. 

  441. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1525);
    442. 

  442. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1531);
    443. 

  443. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1532);
    444. 

  444. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1534);
    445. 

  445. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1535);
    446. 

  446. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1536);
    447. 

  447. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1537);
    448. 

  448. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1538);
    449. 

  449. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1539);
    450. 

  450. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1541);
    451. 

  451. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1542);
    452. 

  452. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1543);
    453. 

  453. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1544);
    454. 

  454. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1545);
    455. 

  455. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1546);
    456. 

  456. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1620);
    457. 

  457. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1621);
    458. 

  458. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1622);
    459. 

  459. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1623);
    460. 

  460. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1624);
    461. 

  461. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1630);
    462. 

  462. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1631);
    463. 

  463. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1632);
    464. 

  464. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1633);
    465. 

  465. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1634);
    466. 

  466. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1650);
    467. 

  467. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1651);
    468. 

  468. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1652);
    469. 

  469. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1653);
    470. 

  470. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1654);
    471. 

  471. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1655);
    472. 

  472. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1656);
    473. 

  473. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1657);
    474. 

  474. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1658);
    475. 

  475. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1659);
    476. 

  476. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1700);
    477. 

  477. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1701);
    478. 

  478. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1702);
    479. 

  479. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1703);
    480. 

  480. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1704);
    481. 

  481. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1705);
    482. 

  482. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1706);
    483. 

  483. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1710);
    484. 

  484. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1711);
    485. 

  485. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1712);
    486. 

  486. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1713);
    487. 

  487. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1714);
    488. 

  488. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1720);
    489. 

  489. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1721);
    490. 

  490. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1722);
    491. 

  491. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1723);
    492. 

  492. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1730);
    493. 

  493. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1731);
    494. 

  494. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1732);
    495. 

  495. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1733);
    496. 

  496. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1740);
    497. 

  497. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1741);
    498. 

  498. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1742);
    499. 

  499. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1743);
    500. 

  500. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1744);
    501. 

  501. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1750);
    502. 

  502. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1751);
    503. 

  503. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1752);
    504. 

  504. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1753);
    505. 

  505. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1754);
    506. 

  506. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1760);
    507. 

  507. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1761);
    508. 

  508. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1762);
    509. 

  509. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1763);
    510. 

  510. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1764);
    511. 

  511. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1770);
    512. 

  512. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1771);
    513. 

  513. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1772);
    514. 

  514. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1773);
    515. 

  515. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1780);
    516. 

  516. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1781);
    517. 

  517. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1790);
    518. 

  518. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1791);
    519. 

  519. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1792);
    520. 

  520. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1800);
    521. 

  521. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1801);
    522. 

  522. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1802);
    523. 

  523. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1803);
    524. 

  524. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1804);
    525. 

  525. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1805);
    526. 

  526. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1806);
    527. 

  527. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1807);
    528. 

  528. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12000);
    529. 

  529. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12001);
    530. 

  530. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12002);
    531. 

  531. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12003);
    532. 

  532. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12004);
    533. 

  533. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12005);
    534. 

  534. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12010);
    535. 

  535. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12011);
    536. 

  536. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12012);
    537. 

  537. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12013);
    538. 

  538. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12014);
    539. 

  539. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12015);
    540. 

  540. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12020);
    541. 

  541. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12021);
    542. 

  542. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12022);
    543. 

  543. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12023);
    544. 

  544. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12024);
    545. 

  545. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12025);
    546. 

  546. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12901);
    547. 

  547. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12902);
    548. 

  548. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12903);
    549. 

  549. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12904);
    550. 

  550. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12905);
    551. 

  551. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16200);
    552. 

  552. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16201);
    553. 

  553. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16202);
    554. 

  554. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16210);
    555. 

  555. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16211);
    556. 

  556. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16212);
    557. 

  557. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16213);
    558. 

  558. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16220);
    559. 

  559. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16221);
    560. 

  560. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16222);
    561. 

  561. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16230);
    562. 

  562. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16231);
    563. 

  563. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16232);
    564. 

  564. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16233);
    565. 

  565. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 17800);
    566. 

  566. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 17801);
    567. 

  567. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 17802);
    568. 

  568. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 17810);
    569. 

  569. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 17811);
    570. 

  570. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 17812);
    571. 

  571. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 17813);
    572. 

  572. 

  573. 

  574. -- ----------------------------
    575. 

  575. -- 初始化-角色和部门关联表数据
    576. 

  576. -- ----------------------------
    577. 

  577. insert into sys_role_dept values ('2', '101');
    578. 

  578. insert into sys_role_dept values ('2', '105');
    579. 

  579. 

  580. 

  581. -- ----------------------------
    582. 

  582. -- 初始化-字典类型表数据
    583. 

  583. -- ----------------------------
    584. 

  584. INSERT INTO `sys_dict_type` VALUES (100, '设备状态', 'sys_device_stat', '0', 'admin', '2024-08-07 10:21:42', '', NULL, NULL);
    585. 

  585. 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：源荷互动');
    586. 

  586. INSERT INTO `sys_dict_type` VALUES (102, '执行模式', 'exec_mode', '0', 'admin', '2024-08-08 14:48:15', '', NULL, '0：固定策略 1：规则引擎 2：定时执行（cron）99：手动执行');
    587. 

  587. 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：谷电计量');
    588. 

  588. 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：设备');
    589. 

  589. INSERT INTO `sys_dict_type` VALUES (106, '标签', 'basecfg_lable', '0', 'admin', '2024-08-19 10:44:49', '', NULL, NULL);
    590. 

  590. INSERT INTO `sys_dict_type` VALUES (107, '告警规则', 'alarm_thre_type', '0', 'admin', '2024-08-26 10:26:49', '', NULL, '1大于；2小于');
    591. 

  591. INSERT INTO `sys_dict_type` VALUES (108, '告警类型', 'alarm_type', '0', 'admin', '2024-08-26 10:28:04', '', NULL, '1：一般 2：重要 3：紧急 4：恢复 5：诊断 6：其他');
    592. 

  592. 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-消散');
    593. 

  593. INSERT INTO `sys_dict_type` VALUES (110, '设备台账对象类型', 'device_type', '0', 'admin', '2024-08-27 15:00:16', '', NULL, '设备台账对象类型');
    594. 

  594. INSERT INTO `sys_dict_type` VALUES (111, '巡检类型', 'task_type', '0', 'admin', '2024-08-29 14:28:37', '', NULL, '1自动；2手动');
    595. 

  595. 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已超期');
    596. 

  596. INSERT INTO `sys_dict_type` VALUES (113, '巡检结果', 'inspection_result', '0', 'admin', '2024-08-29 16:49:17', '', NULL, '结果状态 0：正常  1：异常');
    597. 

  597. 

  598. 

  599. -- ----------------------------
    600. 

  600. -- 初始化-字典数据
    601. 

  601. -- ----------------------------
    602. 

  602. 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);
    603. 

  603. 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);
    604. 

  604. 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);
    605. 

  605. INSERT INTO `sys_dict_data` VALUES (103, 0, '源网策略', '1', 'strategy_type', NULL, 'default', 'N', '0', 'admin', '2024-08-08 14:46:37', '', NULL, NULL);
    606. 

  606. INSERT INTO `sys_dict_data` VALUES (104, 0, '源荷策略', '2', 'strategy_type', NULL, 'default', 'N', '0', 'admin', '2024-08-08 14:46:55', '', NULL, NULL);
    607. 

  607. INSERT INTO `sys_dict_data` VALUES (105, 0, '网储策略', '3', 'strategy_type', NULL, 'default', 'N', '0', 'admin', '2024-08-08 14:46:55', '', NULL, NULL);
    608. 

  608. INSERT INTO `sys_dict_data` VALUES (106, 0, '其他',    '4', 'strategy_type', NULL, 'default', 'N', '0', 'admin', '2024-08-08 14:46:55', '', NULL, NULL);
    609. 

  609. INSERT INTO `sys_dict_data` VALUES (107, 0, '自动执行', '1', 'exec_mode', NULL, 'default', 'N', '0', 'admin', '2024-08-08 14:49:06', '', NULL, NULL);
    610. 

  610. 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);
    611. 

  611. INSERT INTO `sys_dict_data` VALUES (109, 0, '手动执行', '99', 'exec_mode', NULL, 'default', 'N', '0', 'admin', '2024-08-08 14:49:34', '', NULL, '手动执行');
    612. 

  612. INSERT INTO `sys_dict_data` VALUES (111, 0, '不区分', '0', 'meter_type', NULL, 'default', 'N', '0', 'admin', '2024-08-09 10:23:59', '', NULL, '0：不区分 ');
    613. 

  613. INSERT INTO `sys_dict_data` VALUES (112, 0, '峰电计量', '1', 'meter_type', NULL, 'default', 'N', '0', 'admin', '2024-08-09 10:24:14', '', NULL, '1：峰电计量  ');
    614. 

  614. INSERT INTO `sys_dict_data` VALUES (113, 0, '谷电计量', '2', 'meter_type', NULL, 'default', 'N', '0', 'admin', '2024-08-09 10:24:24', '', NULL, '2：谷电计量');
    615. 

  615. 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', '');
    616. 

  616. INSERT INTO `sys_dict_data` VALUES (115, 0, '设施', '2', 'obj_type', NULL, 'default', 'N', '0', 'admin', '2024-08-12 14:23:30', '', NULL, ' 2-设施 ');
    617. 

  617. 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-设备');
    618. 

  618. 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', '光伏');
    619. 

  619. INSERT INTO `sys_dict_data` VALUES (118, 2, 'energy', '200', 'basecfg_lable', NULL, 'default', 'N', '0', 'admin', '2024-08-19 10:50:59', '', NULL, '能源');
    620. 

  620. 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, '储能');
    621. 

  621. 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);
    622. 

  622. 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);
    623. 

  623. 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：一般告警');
    624. 

  624. 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：重要告警');
    625. 

  625. INSERT INTO `sys_dict_data` VALUES (124, 0, '紧急', '3', 'alarm_type', NULL, 'default', 'N', '0', 'admin', '2024-08-26 10:28:53', '', NULL, '3：紧急告警');
    626. 

  626. INSERT INTO `sys_dict_data` VALUES (125, 0, '恢复', '4', 'alarm_type', NULL, 'default', 'N', '0', 'admin', '2024-08-26 10:29:17', '', NULL, '4：恢复告警 ');
    627. 

  627. INSERT INTO `sys_dict_data` VALUES (126, 0, '诊断', '5', 'alarm_type', NULL, 'default', 'N', '0', 'admin', '2024-08-26 10:29:30', '', NULL, '5：诊断告警 ');
    628. 

  628. INSERT INTO `sys_dict_data` VALUES (127, 0, '其他', '6', 'alarm_type', NULL, 'default', 'N', '0', 'admin', '2024-08-26 10:29:38', '', NULL, '6：其他告警');
    629. 

  629. INSERT INTO `sys_dict_data` VALUES (128, 0, '新增', '0', 'alarm_state', NULL, 'default', 'N', '0', 'admin', '2024-08-26 11:40:51', '', NULL, '0-新增，');
    630. 

  630. INSERT INTO `sys_dict_data` VALUES (129, 0, '处置中', '1', 'alarm_state', NULL, 'default', 'N', '0', 'admin', '2024-08-26 11:41:06', '', NULL, '1-处置中，');
    631. 

  631. INSERT INTO `sys_dict_data` VALUES (130, 0, '已处置', '2', 'alarm_state', NULL, 'default', 'N', '0', 'admin', '2024-08-26 11:41:19', '', NULL, '2-已处置，');
    632. 

  632. INSERT INTO `sys_dict_data` VALUES (131, 0, '消散', '3', 'alarm_state', NULL, 'default', 'N', '0', 'admin', '2024-08-26 11:41:30', '', NULL, '3-消散');
    633. 

  633. INSERT INTO `sys_dict_data` VALUES (133, 1, '设施', '1', 'device_type', NULL, 'default', 'N', '0', 'admin', '2024-08-27 15:02:15', '', NULL, NULL);
    634. 

  634. INSERT INTO `sys_dict_data` VALUES (132, 2, '设备', '0', 'device_type', NULL, 'default', 'N', '0', 'admin', '2024-08-27 15:02:01', '', NULL, NULL);
    635. 

  635. 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：设备');
    636. 

  636. 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手动');
    637. 

  637. INSERT INTO `sys_dict_data` VALUES (136, 0, '手动', '2', 'task_type', NULL, 'default', 'N', '0', 'admin', '2024-08-29 14:29:12', '', NULL, '手动');
    638. 

  638. 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);
    639. 

  639. INSERT INTO `sys_dict_data` VALUES (138, 0, '未完成', '0', 'task_status', NULL, 'default', 'N', '0', 'admin', '2024-08-29 16:18:23', '', NULL, '0未完成，');
    640. 

  640. INSERT INTO `sys_dict_data` VALUES (139, 0, '进行中', '1', 'task_status', NULL, 'default', 'N', '0', 'admin', '2024-08-29 16:18:39', '', NULL, '1进行中，');
    641. 

  641. INSERT INTO `sys_dict_data` VALUES (140, 0, '已完成', '2', 'task_status', NULL, 'default', 'N', '0', 'admin', '2024-08-29 16:18:55', '', NULL, '2已完成，');
    642. 

  642. INSERT INTO `sys_dict_data` VALUES (141, 0, '已超期', '3', 'task_status', NULL, 'default', 'N', '0', 'admin', '2024-08-29 16:19:05', '', NULL, '3已超期');
    643. 

  643. 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：异常');
    644. 

  644. INSERT INTO `sys_dict_data` VALUES (143, 0, '异常', '1', 'inspection_result', NULL, 'default', 'N', '0', 'admin', '2024-08-29 16:49:55', '', NULL, NULL);
    645. 

  645. 

  646. 

  647. -- ----------------------------
    648. 

  648. -- 初始化-系统配置数据
    649. 

  649. -- ----------------------------
    650. 

  650. insert into sys_config values(6, '系统信息-平台标题',           'sys.info.title',    '常泰大桥服务区能源管理',   'Y', 'admin', sysdate(), '', null, null);
    651. 

  651. 

  652. 

  653. -- ----------------------------
    654. 

  654. -- 15、定时任务初始化数据
    655. 

  655. -- ----------------------------
    656. 

  656. INSERT INTO sys_job VALUES (100, '设施自动巡检', 'EMS_AUTO_TASK', 'facInspectionTask.execute()', '* 0/4 * * * ?', '1', '1', '1', 'admin', '2024-09-02 14:59:06', '', '2024-09-04 10:21:43', '');
    657.