| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273 |
- -- config_station 增加逆变器数量(幂等)
- ALTER TABLE config_station ADD COLUMN IF NOT EXISTS inverter_quantity integer;
- COMMENT ON COLUMN config_station.inverter_quantity IS '逆变器数量(测光法理论功率用)';
- -- 增加 理论功率 一级菜单
- INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
- SELECT
- nextval(pg_get_serial_sequence('sys_menu', 'menu_id')),
- '理论功率', 0, 20, 'theoretical', '', '', '', 1, 0, 'M', '0', '0', '', 'ThunderboltOutlined', 'admin', now(), '', NULL, '理论功率一级菜单'
- WHERE NOT EXISTS (SELECT 1 FROM sys_menu t WHERE t.menu_name = '理论功率');
- -- 增加 光伏理论功率 二级菜单
- INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
- SELECT
- nextval(pg_get_serial_sequence('sys_menu', 'menu_id')),
- '光伏理论功率',
- (select menu_id from sys_menu t where t.menu_name = '理论功率' and t.parent_id = 0),
- 10, 'pv-theoretical-power', 'ufo/theoretical/PvTheoreticalPower', '', 'PvTheoreticalPower', 1, 0, 'C', '0', '0', 'theoretical:power:list', 'LineChartOutlined', 'admin', now(), '', NULL, '光伏理论功率页面'
- WHERE NOT EXISTS (SELECT 1 FROM sys_menu t WHERE t.menu_name = '光伏理论功率');
- -- 增加 光伏受阻电量 二级菜单
- INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
- SELECT
- nextval(pg_get_serial_sequence('sys_menu', 'menu_id')),
- '光伏受阻电量',
- (select menu_id from sys_menu t where t.menu_name = '理论功率' and t.parent_id = 0),
- 20, 'pv-curtailment-energy', 'ufo/theoretical/PvCurtailmentEnergy', '', 'PvCurtailmentEnergy', 1, 0, 'C', '0', '0', 'theoretical:curtailedEnergy:list', 'AreaChartOutlined', 'admin', now(), '', NULL, '光伏受阻电量页面'
- WHERE NOT EXISTS (SELECT 1 FROM sys_menu t WHERE t.menu_name = '光伏受阻电量');
- -- 增加 光伏场站逻辑校核 二级菜单
- INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
- SELECT
- nextval(pg_get_serial_sequence('sys_menu', 'menu_id')),
- '光伏场站逻辑校核',
- (select menu_id from sys_menu t where t.menu_name = '理论功率' and t.parent_id = 0),
- 30, 'pv-station-logic-check', 'ufo/theoretical/PvStationLogicCheck', '', 'PvStationLogicCheck', 1, 0, 'C', '0', '0', 'theoretical:logicCheck:list', 'AuditOutlined', 'admin', now(), '', NULL, '光伏场站逻辑校核页面'
- WHERE NOT EXISTS (SELECT 1 FROM sys_menu t WHERE t.menu_name = '光伏场站逻辑校核');
- -- 增加 光伏场外受阻电力校核 二级菜单
- INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
- SELECT
- nextval(pg_get_serial_sequence('sys_menu', 'menu_id')),
- '光伏场外受阻电力校核',
- (select menu_id from sys_menu t where t.menu_name = '理论功率' and t.parent_id = 0),
- 40, 'pv-off-site-power-check', 'ufo/theoretical/PvOffSitePowerCheck', '', 'PvOffSitePowerCheck', 1, 0, 'C', '0', '0', 'theoretical:offSiteCheck:list', 'SafetyOutlined', 'admin', now(), '', NULL, '光伏场外受阻电力校核页面'
- WHERE NOT EXISTS (SELECT 1 FROM sys_menu t WHERE t.menu_name = '光伏场外受阻电力校核');
- -- 增加 光伏场内受阻电力校核 二级菜单
- INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
- SELECT
- nextval(pg_get_serial_sequence('sys_menu', 'menu_id')),
- '光伏场内受阻电力校核',
- (select menu_id from sys_menu t where t.menu_name = '理论功率' and t.parent_id = 0),
- 50, 'pv-intra-plant-power-check', 'ufo/theoretical/PvIntraPlantPowerCheck', '', 'PvIntraPlantPowerCheck', 1, 0, 'C', '0', '0', 'theoretical:intraPlantCheck:list', 'SafetyCertificateOutlined', 'admin', now(), '', NULL, '光伏场内受阻电力校核页面'
- WHERE NOT EXISTS (SELECT 1 FROM sys_menu t WHERE t.menu_name = '光伏场内受阻电力校核');
- -- 增加 光伏受阻电量日报 二级菜单
- INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
- SELECT
- nextval(pg_get_serial_sequence('sys_menu', 'menu_id')),
- '光伏受阻电量日报',
- (select menu_id from sys_menu t where t.menu_name = '理论功率' and t.parent_id = 0),
- 60, 'pv-curtailment-energy-daily', 'ufo/theoretical/PvCurtailmentEnergyDaily', '', 'PvCurtailmentEnergyDaily', 1, 0, 'C', '0', '0', 'theoretical:dailyReport:list', 'FileTextOutlined', 'admin', now(), '', NULL, '光伏受阻电量日报页面'
- WHERE NOT EXISTS (SELECT 1 FROM sys_menu t WHERE t.menu_name = '光伏受阻电量日报');
- -- 增加 光伏受阻电量月报 二级菜单
- INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
- SELECT
- nextval(pg_get_serial_sequence('sys_menu', 'menu_id')),
- '光伏受阻电量月报',
- (select menu_id from sys_menu t where t.menu_name = '理论功率' and t.parent_id = 0),
- 70, 'pv-curtailment-energy-monthly', 'ufo/theoretical/PvCurtailmentEnergyMonthly', '', 'PvCurtailmentEnergyMonthly', 1, 0, 'C', '0', '0', 'theoretical:monthlyReport:list', 'CalendarOutlined', 'admin', now(), '', NULL, '光伏受阻电量月报页面'
- WHERE NOT EXISTS (SELECT 1 FROM sys_menu t WHERE t.menu_name = '光伏受阻电量月报');
|