Home Explore Help
Register Sign In
hs
/
prod_group_bg
8
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 988448f8e8
Branches Tags
prod_group_bg
/
ems
/
sql
/
ems_sys_data.sql

ems_sys_data.sql 92 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855 
  1. SET NAMES utf8mb4;
    2. 

  2. 

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

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

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

  6. insert into sys_dept values(101,  100, '0,100',      '常泰服务区管理办', 2, '常泰管理办', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
    7. 

  7. 

  8. 

  9. -- ----------------------------
    10. 

  10. -- 初始化-岗位信息表数据
    11. 

  11. -- ----------------------------
    12. 

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

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

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

  15. 

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

  17. -- 初始化-菜单信息表数据
    18. 

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

  19. -- 一级菜单
    20. 

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

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

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

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

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

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

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

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

  28. 

  29. -- 二级菜单
    30. 

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

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

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

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

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

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

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

  37. insert into sys_menu values ('117',  '策略',            '2', '6',     'strategy-mgr',        null,                       '', 1, 0, 'M', '0', '0',   'power-mgr:strategy',     'strategy',       'admin', sysdate(), '', null, '策略');
    38. 

  38. 

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

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

  41. 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, '用能分析');
    42. 

  42. 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, '节能分析');
    43. 

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

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

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

  46. 

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

  48. insert into sys_menu values ('142',  '设备台账',       '4',    '2',  'device-ledger',       'devmgr/ledger',              '', 1, 0, 'C', '0', '0',   'ems:ledger:list',              'excel',          'admin', sysdate(), '', null, '设备台账');
    49. 

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

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

  51. 

  52. 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', '告警策略');
    53. 

  53. 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', '告警列表');
    54. 

  54. 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', '巡检计划');
    55. 

  55. 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, '巡检报告');
    56. 

  56. insert into sys_menu values ('155',  '系统对接',       '5',    '5',  'adapter',          null, '', 1, 0, 'M', '0', '0', '',  'client',      'admin', sysdate(), '', null, '系统对接');
    57. 

  57. 

  58. 

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

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

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

  62. 

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

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

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

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

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

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

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

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

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

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

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

  74. 

  75. 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, '策略中心');
    76. 

  76. 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, '策略模板');
    77. 

  77. 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, '策略日志');
    78. 

  78. 

  79. 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, '设备管理');
    80. 

  80. 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, '能耗监测');
    81. 

  81. 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, '智慧照明');
    82. 

  82. 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, '充电桩');
    83. 

  83. 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, '光伏');
    84. 

  84. 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, '光储直柔');
    85. 

  85. 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, '光储充');
    86. 

  86. 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, '智慧海绵');
    87. 

  87. 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, '垃圾厨余');
    88. 

  88. 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, '电力监控');
    89. 

  89. 

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

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

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

  93. 

  94. -- 三级菜单
    95. 

  95. -- 预测菜单
    96. 

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

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

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

  99. -- 报表菜单
    100. 

  100. 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, '产能报表');
    101. 

  101. 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, '用能报表');
    102. 

  102. 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, '告警报表');
    103. 

  103. 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, '自定义报表');
    104. 

  104. 

  105. -- 碳分析菜单
    106. 

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

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

  108. 

  109. -- 抄表管理菜单
    110. 

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

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

  112. 

  113. -- 业务配置菜单
    114. 

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

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

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

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

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

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

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

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

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

  123. 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, '碳汇系数');
    124. 

  124. 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, '折煤系数');
    125. 

  125. 

  126. -- 用户管理按钮
    127. 

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

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

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

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

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

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

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

  134. -- 角色管理按钮
    135. 

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

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

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

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

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

  140. -- 菜单管理按钮
    141. 

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

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

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

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

  145. -- 部门管理按钮
    146. 

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

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

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

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

  150. -- 岗位管理按钮
    151. 

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

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

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

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

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

  156. -- 字典管理按钮
    157. 

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

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

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

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

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

  162. -- 参数设置按钮
    163. 

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

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

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

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

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

  168. -- 通知公告按钮
    169. 

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

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

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

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

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

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

  175. 

  176. -- 操作日志按钮
    177. 

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

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

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

  180. -- 登录日志按钮
    181. 

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

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

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

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

  185. -- 在线用户按钮
    186. 

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

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

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

  189. -- 能源设施分类配置按钮
    190. 

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

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

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

  193. insert into sys_menu values ('16203', '分类查询', '1620', '4', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:facscategory:query','#', 'admin', sysdate(), '', null, '');
    194. 

  194. insert into sys_menu values ('16204', '分类导出', '1620', '5', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:facscategory:export','#', 'admin', sysdate(), '', null, '');
    195. 

  195. -- 服务区能源设施配置按钮
    196. 

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

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

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

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

  200. -- 服务区能流关系配置按钮
    201. 

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

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

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

  204. insert into sys_menu values ('16223', '关系查询', '1622', '4', '#', '', '', 1, 0, 'F', '0', '0', 'basecfg:flowrel:query','#', 'admin', sysdate(), '', null, '');
    205. 

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

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

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

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

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

  210. 

  211. -- 价格策略按钮
    212. 

  212. INSERT INTO sys_menu VALUES (16320, '列表查询', 1632, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:price:list', '#', 'admin', sysdate(), '', NULL, '');
    213. 

  213. INSERT INTO sys_menu VALUES (16321, '导出', 1632, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:price:export', '#', 'admin', sysdate(), '', NULL, '');
    214. 

  214. INSERT INTO sys_menu VALUES (16322, '查询', 1632, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:price:query', '#', 'admin', sysdate(), '', NULL, '');
    215. 

  215. INSERT INTO sys_menu VALUES (16323, '新增', 1632, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:price:add', '#', 'admin', sysdate(), '', NULL, '');
    216. 

  216. INSERT INTO sys_menu VALUES (16324, '修改', 1632, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:price:edit', '#', 'admin', sysdate(), '', NULL, '');
    217. 

  217. INSERT INTO sys_menu VALUES (16325, '删除', 1632, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:price:remove', '#', 'admin', sysdate(), '', NULL, '');
    218. 

  218. 

  219. -- 能源策略按钮
    220. 

  220. INSERT INTO sys_menu VALUES (1150, '列表查询', 115, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:strategy:list', '#', 'admin', sysdate(), '', NULL, '');
    221. 

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

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

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

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

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

  226. 

  227. -- 源网协调按钮
    228. 

  228. INSERT INTO `sys_menu` VALUES (1120, '列表查询',112, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:pg:list', '#', 'admin', sysdate(), '', NULL, '');
    229. 

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

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

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

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

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

  234. -- 网储互动
    235. 

  235. INSERT INTO `sys_menu` VALUES (1130,'列表查询',113, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'power-mgr:gs:list', '#', 'admin', sysdate(), '', NULL, '');
    236. 

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

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

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

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

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

  241. 

  242. -- 告警策略
    243. 

  243. 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, '');
    244. 

  244. 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, '');
    245. 

  245. 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, '');
    246. 

  246. 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, '');
    247. 

  247. 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, '');
    248. 

  248. 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, '');
    249. 

  249. 

  250. -- 告警列表
    251. 

  251. 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, '');
    252. 

  252. 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, '');
    253. 

  253. 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, '');
    254. 

  254. 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, '');
    255. 

  255. 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, '');
    256. 

  256. 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, '');
    257. 

  257. 

  258. -- 产能分析
    259. 

  259. INSERT INTO sys_menu VALUES (12601,'列表查询',126, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:prod:list', '#', 'admin', sysdate(), '', NULL, '');
    260. 

  260. INSERT INTO sys_menu VALUES (12602,'导出',126, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:prod:export', '#', 'admin', sysdate(), '', NULL, '');
    261. 

  261. INSERT INTO sys_menu VALUES (12603,'查询',126, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:prod:query', '#', 'admin', sysdate(), '', NULL, '');
    262. 

  262. INSERT INTO sys_menu VALUES (12604,'新增',126, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:prod:add', '#', 'admin', sysdate(), '', NULL, '');
    263. 

  263. INSERT INTO sys_menu VALUES (12605,'修改',126, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:prod:edit', '#', 'admin', sysdate(), '', NULL, '');
    264. 

  264. INSERT INTO sys_menu VALUES (126016,'删除',126, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:prod:remove', '#', 'admin', sysdate(), '', NULL, '');
    265. 

  265. 

  266. -- 产能预测按钮
    267. 

  267. INSERT INTO sys_menu VALUES (12006, '列表查询', 1200, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:prod:list', '#', 'admin', sysdate(), '', NULL, '');
    268. 

  268. INSERT INTO sys_menu VALUES (12007, '导出', 1200, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:prod:export', '#', 'admin', sysdate(), '', NULL, '');
    269. 

  269. INSERT INTO sys_menu VALUES (12008, '查询', 1200, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:prod:query', '#', 'admin', sysdate(), '', NULL, '');
    270. 

  270. INSERT INTO sys_menu VALUES (12009, '新增', 1200, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:prod:add', '#', 'admin', sysdate(), '', NULL, '');
    271. 

  271. INSERT INTO sys_menu VALUES (120010, '修改', 1200, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:prod:edit', '#', 'admin', sysdate(), '', NULL, '');
    272. 

  272. INSERT INTO sys_menu VALUES (120011, '删除', 1200, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:prod:remove', '#', 'admin', sysdate(), '', NULL, '');
    273. 

  273. 

  274. -- 自定义报表配置按钮
    275. 

  275. INSERT INTO sys_menu VALUES (12130, '列表查询', 1213, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'report:config:list', '#', 'admin', sysdate(), '', NULL, '');
    276. 

  276. INSERT INTO sys_menu VALUES (12131, '导出', 1213, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'report:config:export', '#', 'admin', sysdate(), '', NULL, '');
    277. 

  277. INSERT INTO sys_menu VALUES (12132, '查询', 1213, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'report:config:query', '#', 'admin', sysdate(), '', NULL, '');
    278. 

  278. INSERT INTO sys_menu VALUES (12133, '新增', 1213, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'report:config:add', '#', 'admin', sysdate(), '', NULL, '');
    279. 

  279. INSERT INTO sys_menu VALUES (12134, '修改', 1213, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'report:config:edit', '#', 'admin', sysdate(), '', NULL, '');
    280. 

  280. INSERT INTO sys_menu VALUES (12135, '删除', 1213, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'report:config:remove', '#', 'admin', sysdate(), '', NULL, '');
    281. 

  281. 

  282. -- 用能预测
    283. 

  283. INSERT INTO `sys_menu` VALUES (12010,'列表查询',1201, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:consume:list', '#', 'admin', sysdate(), '', NULL, '');
    284. 

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

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

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

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

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

  289. 

  290. -- 碳排预测
    291. 

  291. INSERT INTO `sys_menu` VALUES (12020,'列表查询',1202, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'prediction:ca:list', '#', 'admin', sysdate(), '', NULL, '');
    292. 

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

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

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

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

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

  297. -- 节能分析
    298. 

  298. 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)
    299. 

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

  300. 

  301. 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)
    302. 

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

  303. 

  304. 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)
    305. 

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

  306. 

  307. 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)
    308. 

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

  309. 

  310. 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)
    311. 

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

  312. 

  313. -- 计量设备按钮
    314. 

  314. INSERT INTO sys_menu VALUES (16300, '列表查询', 1630, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterdevc:list', '#', 'admin', sysdate(), '', NULL, '');
    315. 

  315. INSERT INTO sys_menu VALUES (16301, '导出', 1630, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterdevc:export', '#', 'admin', sysdate(), '', NULL, '');
    316. 

  316. INSERT INTO sys_menu VALUES (16302, '查询', 1630, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterdevc:query', '#', 'admin', sysdate(), '', NULL, '');
    317. 

  317. INSERT INTO sys_menu VALUES (16303, '新增', 1630, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterdevc:add', '#', 'admin', sysdate(), '', NULL, '');
    318. 

  318. INSERT INTO sys_menu VALUES (16304, '修改', 1630, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterdevc:edit', '#', 'admin', sysdate(), '', NULL, '');
    319. 

  319. INSERT INTO sys_menu VALUES (16305, '删除', 1630, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterdevc:remove', '#', 'admin', sysdate(), '', NULL, '');
    320. 

  320. 

  321. -- 基础配置计量设备按钮
    322. 

  322. INSERT INTO sys_menu VALUES (162401, '列表查询', 1624, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:meterdevc:list', '#', 'admin', sysdate(), '', NULL, '');
    323. 

  323. 

  324. -- 计量绑定按钮
    325. 

  325. INSERT INTO sys_menu VALUES (16310, '列表查询', 1631, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterBoundary:list', '#', 'admin', sysdate(), '', NULL, '');
    326. 

  326. INSERT INTO sys_menu VALUES (16311, '新增', 1631, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterBoundary:add', '#', 'admin', sysdate(), '', NULL, '');
    327. 

  327. INSERT INTO sys_menu VALUES (16312, '删除', 1631, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterBoundary:remove', '#', 'admin', sysdate(), '', NULL, '');
    328. 

  328. 

  329. -- 储能设施指标按钮
    330. 

  330. INSERT INTO sys_menu VALUES (12701, '列表查询', 127, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:ElecStoreIndex:list', '#', 'admin', sysdate(), '', NULL, '');
    331. 

  331. INSERT INTO sys_menu VALUES (12702, '新增', 127, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:ElecStoreIndex:add', '#', 'admin', sysdate(), '', NULL, '');
    332. 

  332. INSERT INTO sys_menu VALUES (12703, '修改', 127, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:ElecStoreIndex:edit', '#', 'admin', sysdate(), '', NULL, '');
    333. 

  333. INSERT INTO sys_menu VALUES (12704, '删除', 127, 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:ElecStoreIndex:remove', '#', 'admin', sysdate(), '', NULL, '');
    334. 

  334. 

  335. -- 碳排计量
    336. 

  336. INSERT INTO `sys_menu` VALUES (12311,'列表查询',1231, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:emission:list', '#', 'admin', sysdate(), '', NULL, '');
    337. 

  337. INSERT INTO `sys_menu` VALUES (12312,'导出',1231, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:emission:export', '#', 'admin', sysdate(), '', NULL, '');
    338. 

  338. INSERT INTO `sys_menu` VALUES (12313,'查询',1231, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:emission:query', '#', 'admin', sysdate(), '', NULL, '');
    339. 

  339. INSERT INTO `sys_menu` VALUES (12314,'新增',1231, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:emission:add', '#', 'admin', sysdate(), '', NULL, '');
    340. 

  340. INSERT INTO `sys_menu` VALUES (12315,'修改',1231, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:emission:edit', '#', 'admin', sysdate(), '', NULL, '');
    341. 

  341. INSERT INTO `sys_menu` VALUES (12316,'删除',1231, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:emission:remove', '#', 'admin', sysdate(), '', NULL, '');
    342. 

  342. 

  343. -- 碳汇计量
    344. 

  344. INSERT INTO `sys_menu` VALUES (12321,'列表查询',1232, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:sink:list', '#', 'admin', sysdate(), '', NULL, '');
    345. 

  345. INSERT INTO `sys_menu` VALUES (12322,'导出',1232, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:sink:export', '#', 'admin', sysdate(), '', NULL, '');
    346. 

  346. INSERT INTO `sys_menu` VALUES (12323,'查询',1232, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:sink:query', '#', 'admin', sysdate(), '', NULL, '');
    347. 

  347. INSERT INTO `sys_menu` VALUES (12324,'新增',1232, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:sink:add', '#', 'admin', sysdate(), '', NULL, '');
    348. 

  348. INSERT INTO `sys_menu` VALUES (12325,'修改',1232, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:sink:edit', '#', 'admin', sysdate(), '', NULL, '');
    349. 

  349. INSERT INTO `sys_menu` VALUES (12326,'删除',1232, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ca-analysis:sink:remove', '#', 'admin', sysdate(), '', NULL, '');
    350. 

  350. 

  351. -- 巡检计划
    352. 

  352. 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, '');
    353. 

  353. 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, '');
    354. 

  354. 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, '');
    355. 

  355. 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, '');
    356. 

  356. 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, '');
    357. 

  357. 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, '');
    358. 

  358. 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, '');
    359. 

  359. 

  360. -- 巡检报告
    361. 

  361. 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, '');
    362. 

  362. 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, '');
    363. 

  363. 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, '');
    364. 

  364. 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, '');
    365. 

  365. 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, '');
    366. 

  366. 

  367. -- 能源子系统按钮
    368. 

  368. INSERT INTO sys_menu VALUES (15530, '查询', 1553, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'adapter:subsystem:query', '#', 'admin', sysdate(), '', NULL, '');
    369. 

  369. INSERT INTO sys_menu VALUES (15531, '新增', 1553, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'adapter:subsystem:add', '#', 'admin', sysdate(), '', NULL, '');
    370. 

  370. INSERT INTO sys_menu VALUES (15532, '修改', 1553, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'adapter:subsystem:edit', '#', 'admin', sysdate(), '', NULL, '');
    371. 

  371. INSERT INTO sys_menu VALUES (15533, '删除', 1553, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'adapter:subsystem:remove', '#', 'admin', sysdate(), '', NULL, '');
    372. 

  372. 

  373. -- 计费账单按钮
    374. 

  374. INSERT INTO sys_menu VALUES (15540, '列表查询', 1554, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:charging:list', '#', 'admin', sysdate(), '', NULL, '');
    375. 

  375. INSERT INTO sys_menu VALUES (15541, '导出', 1554, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:charging:export', '#', 'admin', sysdate(), '', NULL, '');
    376. 

  376. 

  377. -- 协同充电配置按钮
    378. 

  378. INSERT INTO sys_menu VALUES (15550, '列表查询', 1555, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:config:list', '#', 'admin', sysdate(), '', NULL, '');
    379. 

  379. INSERT INTO sys_menu VALUES (15551, '查询', 1555, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:config:query', '#', 'admin', sysdate(), '', NULL, '');
    380. 

  380. INSERT INTO sys_menu VALUES (15552, '新增', 1555, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:config:add', '#', 'admin', sysdate(), '', NULL, '');
    381. 

  381. INSERT INTO sys_menu VALUES (15553, '修改', 1555, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:config:edit', '#', 'admin', sysdate(), '', NULL, '');
    382. 

  382. INSERT INTO sys_menu VALUES (15554, '删除', 1555, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:config:remove', '#', 'admin', sysdate(), '', NULL, '');
    383. 

  383. 

  384. -- 手动抄表按钮
    385. 

  385. INSERT INTO sys_menu VALUES (14400, '列表查询', 1440, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterReading:list', '#', 'admin', sysdate(), '', NULL, '');
    386. 

  386. INSERT INTO sys_menu VALUES (14401, '导出', 1440, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterReading:export', '#', 'admin', sysdate(), '', NULL, '');
    387. 

  387. INSERT INTO sys_menu VALUES (14402, '查询', 1440, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterReading:query', '#', 'admin', sysdate(), '', NULL, '');
    388. 

  388. INSERT INTO sys_menu VALUES (14403, '新增', 1440, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterReading:add', '#', 'admin', sysdate(), '', NULL, '');
    389. 

  389. INSERT INTO sys_menu VALUES (14404, '修改', 1440, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterReading:edit', '#', 'admin', sysdate(), '', NULL, '');
    390. 

  390. INSERT INTO sys_menu VALUES (14405, '删除', 1440, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:meterReading:remove', '#', 'admin', sysdate(), '', NULL, '');
    391. 

  391. 

  392. -- 用电计量小时按钮
    393. 

  393. INSERT INTO sys_menu VALUES (14410, '用电列表查询', 1441, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:elecMeterH:list', '#', 'admin', sysdate(), '', NULL, '');
    394. 

  394. INSERT INTO sys_menu VALUES (14411, '用电导出', 1441, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:elecMeterH:export', '#', 'admin', sysdate(), '', NULL, '');
    395. 

  395. INSERT INTO sys_menu VALUES (14412, '用电查询', 1441, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:elecMeterH:query', '#', 'admin', sysdate(), '', NULL, '');
    396. 

  396. INSERT INTO sys_menu VALUES (14413, '用电新增', 1441, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:elecMeterH:add', '#', 'admin', sysdate(), '', NULL, '');
    397. 

  397. INSERT INTO sys_menu VALUES (14414, '用电修改', 1441, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:elecMeterH:edit', '#', 'admin', sysdate(), '', NULL, '');
    398. 

  398. INSERT INTO sys_menu VALUES (14415, '用电删除', 1441, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:elecMeterH:remove', '#', 'admin', sysdate(), '', NULL, '');
    399. 

  399. 

  400. -- 用水计量小时按钮
    401. 

  401. INSERT INTO sys_menu VALUES (14420, '用水列表查询', 1441, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:waterMeterH:list', '#', 'admin', sysdate(), '', NULL, '');
    402. 

  402. INSERT INTO sys_menu VALUES (14421, '用水导出', 1441, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:waterMeterH:export', '#', 'admin', sysdate(), '', NULL, '');
    403. 

  403. INSERT INTO sys_menu VALUES (14422, '用水查询', 1441, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:waterMeterH:query', '#', 'admin', sysdate(), '', NULL, '');
    404. 

  404. INSERT INTO sys_menu VALUES (14423, '用水新增', 1441, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:waterMeterH:add', '#', 'admin', sysdate(), '', NULL, '');
    405. 

  405. INSERT INTO sys_menu VALUES (14424, '用水修改', 1441, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:waterMeterH:edit', '#', 'admin', sysdate(), '', NULL, '');
    406. 

  406. INSERT INTO sys_menu VALUES (14425, '用水删除', 1441, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:waterMeterH:remove', '#', 'admin', sysdate(), '', NULL, '');
    407. 

  407. 

  408. -- 折煤系数按钮
    409. 

  409. INSERT INTO sys_menu VALUES (16350, '列表查询', 1635, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:disStaCoal:list', '#', 'admin', sysdate(), '', NULL, '');
    410. 

  410. INSERT INTO sys_menu VALUES (16351, '导出', 1635, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:disStaCoal:export', '#', 'admin', sysdate(), '', NULL, '');
    411. 

  411. INSERT INTO sys_menu VALUES (16352, '查询', 1635, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:disStaCoal:query', '#', 'admin', sysdate(), '', NULL, '');
    412. 

  412. INSERT INTO sys_menu VALUES (16353, '新增', 1635, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:disStaCoal:add', '#', 'admin', sysdate(), '', NULL, '');
    413. 

  413. INSERT INTO sys_menu VALUES (16354, '修改', 1635, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:disStaCoal:edit', '#', 'admin', sysdate(), '', NULL, '');
    414. 

  414. INSERT INTO sys_menu VALUES (16355, '删除', 1635, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:disStaCoal:remove', '#', 'admin', sysdate(), '', NULL, '');
    415. 

  415. 

  416. -- 非电能源价格配置按钮
    417. 

  417. INSERT INTO sys_menu VALUES (16360, '列表查询', 1632, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:FdEnergyPriceConfig:list', '#', 'admin', sysdate(), '', NULL, '');
    418. 

  418. INSERT INTO sys_menu VALUES (16361, '导出', 1632, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:FdEnergyPriceConfig:export', '#', 'admin', sysdate(), '', NULL, '');
    419. 

  419. INSERT INTO sys_menu VALUES (16362, '查询', 1632, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:FdEnergyPriceConfig:query', '#', 'admin', sysdate(), '', NULL, '');
    420. 

  420. INSERT INTO sys_menu VALUES (16363, '新增', 1632, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:FdEnergyPriceConfig:add', '#', 'admin', sysdate(), '', NULL, '');
    421. 

  421. INSERT INTO sys_menu VALUES (16364, '修改', 1632, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:FdEnergyPriceConfig:edit', '#', 'admin', sysdate(), '', NULL, '');
    422. 

  422. INSERT INTO sys_menu VALUES (16365, '删除', 1632, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ems:FdEnergyPriceConfig:remove', '#', 'admin', sysdate(), '', NULL, '');
    423. 

  423. 

  424. -- 碳排因子按钮
    425. 

  425. INSERT INTO sys_menu VALUES (16330, '列表查询', 1633, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:cacfg:list', '#', 'admin', sysdate(), '', NULL, '');
    426. 

  426. INSERT INTO sys_menu VALUES (16331, '导出', 1633, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:cacfg:export', '#', 'admin', sysdate(), '', NULL, '');
    427. 

  427. INSERT INTO sys_menu VALUES (16332, '查询', 1633, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:cacfg:query', '#', 'admin', sysdate(), '', NULL, '');
    428. 

  428. INSERT INTO sys_menu VALUES (16333, '新增', 1633, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:cacfg:add', '#', 'admin', sysdate(), '', NULL, '');
    429. 

  429. INSERT INTO sys_menu VALUES (16334, '修改', 1633, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:cacfg:edit', '#', 'admin', sysdate(), '', NULL, '');
    430. 

  430. INSERT INTO sys_menu VALUES (16335, '删除', 1633, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:cacfg:remove', '#', 'admin', sysdate(), '', NULL, '');
    431. 

  431. 

  432. -- 碳汇系数按钮
    433. 

  433. INSERT INTO sys_menu VALUES (16340, '列表查询', 1634, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:casink:list', '#', 'admin', sysdate(), '', NULL, '');
    434. 

  434. INSERT INTO sys_menu VALUES (16341, '导出', 1634, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:casink:export', '#', 'admin', sysdate(), '', NULL, '');
    435. 

  435. INSERT INTO sys_menu VALUES (16342, '查询', 1634, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:casink:query', '#', 'admin', sysdate(), '', NULL, '');
    436. 

  436. INSERT INTO sys_menu VALUES (16343, '新增', 1634, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:casink:add', '#', 'admin', sysdate(), '', NULL, '');
    437. 

  437. INSERT INTO sys_menu VALUES (16344, '修改', 1634, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:casink:edit', '#', 'admin', sysdate(), '', NULL, '');
    438. 

  438. INSERT INTO sys_menu VALUES (16345, '删除', 1634, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'basecfg:casink:remove', '#', 'admin', sysdate(), '', NULL, '');
    439. 

  439. 

  440. -- 任务调度
    441. 

  441. 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, '');
    442. 

  442. 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, '');
    443. 

  443. 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, '');
    444. 

  444. 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, '');
    445. 

  445. 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, '');
    446. 

  446. 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, '');
    447. 

  447. 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, '');
    448. 

  448. 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, '');
    449. 

  449. 

  450. 

  451. -- ----------------------------
    452. 

  452. -- 初始化-角色和菜单关联表数据
    453. 

  453. -- ----------------------------
    454. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  572. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1623);
    573. 

  573. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1624);
    574. 

  574. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1630);
    575. 

  575. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1631);
    576. 

  576. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1632);
    577. 

  577. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1633);
    578. 

  578. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1634);
    579. 

  579. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1635);
    580. 

  580. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1700);
    581. 

  581. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1701);
    582. 

  582. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1702);
    583. 

  583. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1703);
    584. 

  584. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1704);
    585. 

  585. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1705);
    586. 

  586. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1706);
    587. 

  587. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1710);
    588. 

  588. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1711);
    589. 

  589. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1712);
    590. 

  590. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1713);
    591. 

  591. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1714);
    592. 

  592. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1720);
    593. 

  593. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1721);
    594. 

  594. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1722);
    595. 

  595. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1723);
    596. 

  596. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1730);
    597. 

  597. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1731);
    598. 

  598. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1732);
    599. 

  599. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1733);
    600. 

  600. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1740);
    601. 

  601. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1741);
    602. 

  602. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1742);
    603. 

  603. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1743);
    604. 

  604. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1744);
    605. 

  605. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1750);
    606. 

  606. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1751);
    607. 

  607. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1752);
    608. 

  608. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1753);
    609. 

  609. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1754);
    610. 

  610. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1760);
    611. 

  611. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1761);
    612. 

  612. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1762);
    613. 

  613. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1763);
    614. 

  614. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1764);
    615. 

  615. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1770);
    616. 

  616. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1771);
    617. 

  617. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1772);
    618. 

  618. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1773);
    619. 

  619. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1780);
    620. 

  620. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1781);
    621. 

  621. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1790);
    622. 

  622. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1791);
    623. 

  623. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1792);
    624. 

  624. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1800);
    625. 

  625. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1801);
    626. 

  626. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1802);
    627. 

  627. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1803);
    628. 

  628. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1804);
    629. 

  629. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1805);
    630. 

  630. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1806);
    631. 

  631. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 1807);
    632. 

  632. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12006);
    633. 

  633. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12007);
    634. 

  634. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12008);
    635. 

  635. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12009);
    636. 

  636. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12010);
    637. 

  637. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12011);
    638. 

  638. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12012);
    639. 

  639. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12013);
    640. 

  640. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12014);
    641. 

  641. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12015);
    642. 

  642. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12020);
    643. 

  643. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12021);
    644. 

  644. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12022);
    645. 

  645. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12023);
    646. 

  646. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12024);
    647. 

  647. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12025);
    648. 

  648. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12130);
    649. 

  649. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12131);
    650. 

  650. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12132);
    651. 

  651. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12133);
    652. 

  652. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12134);
    653. 

  653. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12135);
    654. 

  654. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12311);
    655. 

  655. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12312);
    656. 

  656. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12313);
    657. 

  657. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12314);
    658. 

  658. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12315);
    659. 

  659. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12316);
    660. 

  660. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12321);
    661. 

  661. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12322);
    662. 

  662. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12323);
    663. 

  663. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12324);
    664. 

  664. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12325);
    665. 

  665. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12326);
    666. 

  666. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12601);
    667. 

  667. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12602);
    668. 

  668. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12603);
    669. 

  669. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12604);
    670. 

  670. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12605);
    671. 

  671. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12701);
    672. 

  672. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12702);
    673. 

  673. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12703);
    674. 

  674. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12704);
    675. 

  675. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12901);
    676. 

  676. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12902);
    677. 

  677. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12903);
    678. 

  678. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12904);
    679. 

  679. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 12905);
    680. 

  680. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14400);
    681. 

  681. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14401);
    682. 

  682. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14402);
    683. 

  683. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14403);
    684. 

  684. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14404);
    685. 

  685. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14405);
    686. 

  686. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14410);
    687. 

  687. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14411);
    688. 

  688. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14412);
    689. 

  689. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14413);
    690. 

  690. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14414);
    691. 

  691. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14415);
    692. 

  692. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14420);
    693. 

  693. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14421);
    694. 

  694. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14422);
    695. 

  695. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14423);
    696. 

  696. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14424);
    697. 

  697. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 14425);
    698. 

  698. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 15530);
    699. 

  699. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 15531);
    700. 

  700. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 15532);
    701. 

  701. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 15533);
    702. 

  702. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 15540);
    703. 

  703. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 15541);
    704. 

  704. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 15550);
    705. 

  705. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 15551);
    706. 

  706. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 15552);
    707. 

  707. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 15553);
    708. 

  708. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 15554);
    709. 

  709. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16200);
    710. 

  710. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16201);
    711. 

  711. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16202);
    712. 

  712. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16203);
    713. 

  713. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16204);
    714. 

  714. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16210);
    715. 

  715. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16211);
    716. 

  716. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16212);
    717. 

  717. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16213);
    718. 

  718. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16220);
    719. 

  719. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16221);
    720. 

  720. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16222);
    721. 

  721. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16223);
    722. 

  722. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16230);
    723. 

  723. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16231);
    724. 

  724. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16232);
    725. 

  725. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16233);
    726. 

  726. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16300);
    727. 

  727. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16301);
    728. 

  728. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16302);
    729. 

  729. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16303);
    730. 

  730. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16304);
    731. 

  731. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16305);
    732. 

  732. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16310);
    733. 

  733. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16311);
    734. 

  734. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16312);
    735. 

  735. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16320);
    736. 

  736. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16321);
    737. 

  737. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16322);
    738. 

  738. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16323);
    739. 

  739. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16324);
    740. 

  740. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16325);
    741. 

  741. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16330);
    742. 

  742. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16331);
    743. 

  743. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16332);
    744. 

  744. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16333);
    745. 

  745. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16334);
    746. 

  746. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16335);
    747. 

  747. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16340);
    748. 

  748. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16341);
    749. 

  749. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16342);
    750. 

  750. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16343);
    751. 

  751. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16344);
    752. 

  752. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16345);
    753. 

  753. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16350);
    754. 

  754. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16351);
    755. 

  755. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16352);
    756. 

  756. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16353);
    757. 

  757. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16354);
    758. 

  758. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16355);
    759. 

  759. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16360);
    760. 

  760. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16361);
    761. 

  761. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16362);
    762. 

  762. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16363);
    763. 

  763. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16364);
    764. 

  764. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 16365);
    765. 

  765. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 17800);
    766. 

  766. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 17801);
    767. 

  767. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 17802);
    768. 

  768. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 17810);
    769. 

  769. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 17811);
    770. 

  770. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 17812);
    771. 

  771. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 17813);
    772. 

  772. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 120010);
    773. 

  773. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 120011);
    774. 

  774. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 126016);
    775. 

  775. INSERT INTO sys_role_menu (`role_id`, `menu_id`) VALUES (2, 162401);
    776. 

  776. 

  777. -- ----------------------------
    778. 

  778. -- 初始化-角色和部门关联表数据
    779. 

  779. -- ----------------------------
    780. 

  780. insert into sys_role_dept values ('2', '101');
    781. 

  781. 

  782. 

  783. -- ----------------------------
    784. 

  784. -- 初始化-字典类型表数据
    785. 

  785. -- ----------------------------
    786. 

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

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

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

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

  790. 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：设备');
    791. 

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

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

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

  794. 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-消散');
    795. 

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

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

  797. 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已超期');
    798. 

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

  799. 

  800. 

  801. -- ----------------------------
    802. 

  802. -- 初始化-字典数据
    803. 

  803. -- ----------------------------
    804. 

  804. 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);
    805. 

  805. 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);
    806. 

  806. 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);
    807. 

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

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

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

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

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

  812. 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);
    813. 

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

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

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

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

  817. 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', '');
    818. 

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

  819. 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-设备');
    820. 

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

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

  822. 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, '储能');
    823. 

  823. 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);
    824. 

  824. 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);
    825. 

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

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

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

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

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

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

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

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

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

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

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

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

  837. 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：设备');
    838. 

  838. 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手动');
    839. 

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

  840. 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);
    841. 

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

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

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

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

  845. 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：异常');
    846. 

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

  847. 

  848. 

  849. -- ----------------------------
    850. 

  850. -- 初始化-系统配置数据
    851. 

  851. -- ----------------------------
    852. 

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

  853. insert into sys_config values(7, '主路光伏大屏标题',           'sys.info.pv-road-title',    '常泰大桥服务区主路光伏',   'Y', 'admin', sysdate(), '', null, null);
    854. 

  854. INSERT INTO sys_config VALUES
    855. 

  855.     (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 }}');
    856.