delete from t_sys_menu;
/*9000*/
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 1, '首页', '/', 'dashboard', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 1);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 2, 'FTP/SFTP工具', 'ftpSftpTools', 'ftpSftpTools', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 2);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 3, '场站信息', 'console', 'electricField', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 3);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 4, '光伏组件', 'console', 'pvModuleModel', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 4);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 5, '逆变器信息', 'console', 'inverterInfo', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 5);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 6, '假期日历', 'console', 'holidayCalendar', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 6);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 7, '气象站信息', 'console', 'weatherStationInfo', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 7);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 8, '测风塔信息', 'console', 'anemometerTowerInfo', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 8);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 9, 'AGC_AVC信息', 'console', 'agc_avcInfo', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 9);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 10, '升压站信息', 'console', 'boosterStationInfo', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 10);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 11, '风机信息', 'console', 'windTurbineidInfo', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 11);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 12, '检修计划', 'console', 'overHaulPlan', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 12);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 13, '山东发电计划', 'console', 'powerPlanSD', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 13);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 14, '系统参数', 'console', 'sysParameter', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 14);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 15, '系统告警', 'console', 'sysAlarm', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 15);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 16, '人工干预设置', 'console', 'manualInterventionData', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 16);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 17, '人工干预数据查询', 'console', 'manualInterventionQuery', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 17);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 18, '上报数据限制', 'console', 'dataLimitation', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 18);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 19, '上报数据操作记录', 'console', 'dataLimitationLog', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 19);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 20, '通信设备', 'console', 'communicationEquipment', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 20);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 21, '文件解析记录', 'console', 'fileAnalysisRecord', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 21);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 22, '二维码数据回传', 'console', 'QREnvironmentData', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 22);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 23, '设备状态属性', 'DataExchange', 'equipmentAttribute', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 23);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 24, '通道采集点表', 'DataExchange', 'gatherdatapoint', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 24);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 25, '通道转发点表', 'DataExchange', 'senderdatapoint', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 25);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 26, '模版信息', 'DataExchange', 'template', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 26);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 27, '模版点表', 'DataExchange', 'templatedatapoint', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 27);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 28, '通道信息', 'DataExchange', 'tunnelinfo', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 28);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 29, '回传日志', 'DataExchange', 'sendLog', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 29);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 30, '定时任务', 'system', 'quartz', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 30);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 31, '系统文件', 'system', 'systemfile', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 31);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 32, '用户管理', 'system', 'systemuser', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 32);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 33, '上报通道配置', 'uploadFile', 'uploadFileChannel', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 33);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 34, '文件上报查询', 'uploadFile', 'queryUploadFile', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 34);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 35, '上传上报文件', 'uploadFile', 'uploadFile', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 35);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 36, '反馈文件日志查询', 'uploadFile', 'feedbackFile', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 36);
/*9001*/
-- INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 37, '首页', null, '/', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 37);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 38, '实际功率查询', 'realTimeQuery', 'realPowerQuery', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 38);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 39, '气象站查询', 'realTimeQuery', 'weatherStationStatusData', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 39);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 40, '逆变器查询', 'realTimeQuery', 'inverterStatusData', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 40);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 41, '测风塔查询', 'realTimeQuery', 'windTowerStatusData', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 41);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 42, '风机查询', 'realTimeQuery', 'windTurbineStatusData', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 42);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 43, '实时NWP查询', 'realTimeQuery', 'nwp', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 43);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 44, '超短期16时刻查询', 'realTimeQuery', 'forecastPowerShortTerm16', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 44);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 45, '实时预测查询', 'realTimeQuery', 'contrastRealTimeQuery', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 45);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 46, '上报统计查询', 'statisticsQuery', 'reportStatistics', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 46);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 47, '准确率统计查询', 'statisticsQuery', 'accuracyPassRate', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 47);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 48, '准确率月统计查询', 'statisticsQuery', 'accuracyPassRateMonth', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 48);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 49, '预测发电量统计', 'statisticsQuery', 'comprehensiveStatistics', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 49);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 50, '环境综合统计查询', 'statisticsQuery', 'comprehensiveStatisticsQuery', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 50);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 51, '一体化统计查询', 'statisticsQuery', 'integrationStatisticsQuery', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 51);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 52, '综合统计查询', 'comprehensiveStatisticsQuery', 'comprehensiveStatisticsQuery', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 52);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 53, '上报数据查询', 'constrastQuery', 'comprehensiveQuery', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 53);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 54, '实时预测查询', 'contrastRealTimeQuery', 'contrastRealTimeQuery', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 54);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 55, '定时导出类型配置', 'exportConfigQuery', 'exportConfigQuery', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 55);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 56, '实际功率二维码', 'qrCodeQuery', 'realpowerQrCode', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 56);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 57, '环境数据二维码', 'qrCodeQuery', 'environmentQrCode', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 57);
/*9001父*/
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 58, '首页', null, '/', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 58);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 59, '控制管理', null, 'console', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 59);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 60, '数据交互中心', null, 'DataExchange', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 60);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 61, '系统管理', null, 'system', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 61);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 62, '文件上报', null, 'uploadFile', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 62);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 63, 'FTP/SFTP工具', null, 'ftpSftpTools', '9001' from dual where not exists (select C_ID from t_sys_menu where C_ID = 63);
/*9000父*/
-- INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 64, '首页', null, '/', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 64);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 65, '实时查询', null, 'realTimeQuery', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 65);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 66, '统计查询', null, 'statisticsQuery', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 66);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 67, '综合统计查询', null, 'comprehensiveStatisticsQuery', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 67);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 68, '上报数据查询', null, 'constrastQuery', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 68);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 69, '实时预测查询', null, 'contrastRealTimeQuery', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 69);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 70, '定时导出类型配置', null, 'exportConfigQuery', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 70);
INSERT INTO t_sys_menu (C_ID, C_TITLE, C_PATH, C_ITEM_PATH, C_URL) select 71, '二维码生成', null, 'qrCodeQuery', '9000' from dual where not exists (select C_ID from t_sys_menu where C_ID = 71);


