From 065f243d6446ca64c64c222c757e0fa9ff36b9be Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期三, 26 四月 2023 09:46:47 +0800
Subject: [PATCH] V1.70 edit at date 2023-04-18 1.表'db_ram_db.tb_thread_util'表新增数据，用于控制负载电流更新线程手动更新 sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.ThreadUtil_Table + " VALUES ('4', '2019004', '负载电流更新线程', '2019-01-08 10:44:28', '0', '')"); //添加更新负载电流更新线程
---
BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java | 152 ++++++++++++++++++++++++++++++++++++++------------
1 files changed, 116 insertions(+), 36 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java b/BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java
index 9f172c1..341aeed 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java
@@ -4,6 +4,8 @@
import java.util.Arrays;
import java.util.List;
+import com.sql.Sql_Mysql;
+
public class SqlsUtils {
/**
@@ -16,6 +18,11 @@
*/
static List<Integer> idsDefault2;
+ /**
+ * db_app_sys.tb_menu的默认参数中的id
+ */
+ static List<Integer> idsDefault_tb_menu;
+
/**
* db_app_sys.tb_page_param的默认insert语句
@@ -26,6 +33,11 @@
*/
static ArrayList<String> sqlstb_page_param2;
+
+ /**
+ * db_app_sys.tb_menu的默认insert语句
+ */
+ static ArrayList<String> sqlstb_tb_menu;
static {
@@ -47,48 +59,116 @@
}
sqlstb_page_param = new ArrayList<>();
- String tb_page_param = "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('1', '设备工作状态', '1', '1');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('2', '设备通讯', '1', '1');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('3', '设备温度', '1', '1');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('4', '干接点', '1', '1');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('5', '核容终止原因', '1', '1');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('6', '操作失败原因', '1', '1');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('7', '剩余天数', '1', '1');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('8', '工作模式', '1', '1');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('9', '组端电压', '1', '1');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('10', '峰值电压', '1', '1');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('11', '启动核容测试', '1', '2');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('12', '停止测试', '1', '2');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('13', '系统参数设置', '1', '2');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('14', '清除告警', '1', '2');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('15', '启动养护/除硫', '1', '2');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('16', '停止养护/除硫', '1', '2');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('17', '启动离线养护', '1', '2');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('18', '停止离线养护', '1', '2');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('19', '定期启动设备', '1', '2');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('20', '重启设备', '1', '2');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('21', '均衡控制参数设置 ', '1', '2');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('31', '蓄电池后台监控管理平台', '1', '5');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('32', 'V1.0.5', '1', '6');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('33', '平台logo', '1', '7');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('34', 'uKey', '1', '7');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('35', '人脸识别', '1', '7');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('36', '签名', '1', '7');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('37', '远程修改ip', '1', '7');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('38', '启动放电添加人脸识别', '1', '7');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('39', '账号扫描策略', '1', '8');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('40', '账号登录失败限制次数', '10', '9');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('41', '账号登录失败锁定解锁策略', '2', '9');" +
+ String tb_page_param = "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('1', '设备工作状态', '1', '1','Device Status');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('2', '设备通讯', '1', '1','Device Communication');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('3', '设备温度', '1', '1','Temperature(°C)');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('4', '干接点', '1', '1','Dry Contact');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('5', '核容终止原因', '1', '1','Reason for capacity check termination');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('6', '操作失败原因', '1', '1','Operate Failure Reason');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('7', '剩余天数', '1', '1','Remaining Day(s)');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('8', '工作模式', '1', '1','Working Mode');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('9', '组端电压', '1', '1','String Voltage');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('10', '峰值电压', '1', '1','Peak Voltage');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('11', '启动核容测试', '1', '2','Initiate capacity check testing');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('12', '停止测试', '1', '2','Stop testing');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('13', '系统参数设置', '1', '2','System Parms Setting');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('14', '清除告警', '1', '2','Clear Alarm');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('15', '启动养护/除硫', '1', '2','Start Maintenance/Desulfation');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('16', '停止养护/除硫', '1', '2','Stop Maintenance/Desulfation');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('17', '启动离线养护', '1', '2','Start Offline Maintenance');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('18', '停止离线养护', '1', '2','Stop Offline Maintenance');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('19', '定期启动设备', '1', '2','Periodically Ratart');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('20', '重启设备', '1', '2','Restart');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('21', '均衡控制参数设置 ', '1', '2','Balance Control Parms Setting');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('31', '蓄电池后台监控管理平台', '1', '5','Intelligent System for Battery Uninterruptible Power Supply');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('32', 'V1.0.5', '1', '6','V1.0.5');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('33', '平台logo', '1', '7','Platform logo');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('34', 'uKey', '1', '7','uKey');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('35', '人脸识别', '1', '7','Face recognition');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('36', '签名', '1', '7','signature');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('37', '远程修改ip', '1', '7','Remote modification of IP');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('38', '启动放电添加人脸识别', '1', '7','Start discharging and add facial recognition');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('39', '账号扫描策略', '1', '8','Account scanning strategy');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('40', '账号登录失败限制次数', '10', '9','Account login failure limit number of times');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('41', '账号登录失败锁定解锁策略', '2', '9','Account login failure lock unlock strategy');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('42', '密码设置规则-位数', '8', '10');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('43', '密码设置规则-符号类型', '4', '10');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('44', '历史数据的驼峰锅底功能开启', '1', '11');" +
- "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`) VALUES ('45', '历史数据的数据显示粒度', '5', '11');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('42', '密码设置规则-位数', '8', '10','Password setting rules - number of digits');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('43', '密码设置规则-符号类型', '4', '10','Password Setting Rules - Symbol Types');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('44', '历史数据的驼峰锅底功能开启', '1', '11','Enabling the Hump Pot Bottom Function of Historical Data');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('45', '历史数据的数据显示粒度', '5', '11','Data display granularity of historical data');" +
"";
String[] strs = tb_page_param.split(";");
for (int i = 0; i < strs.length; i++) {
sqlstb_page_param.add(strs[i]);
}
+
+ Integer[] temp3= {1,2,3,4,5,6,7,8,2001,2002,2003,2004,2005,2006,2007,2008,2009,3001,3002,3003,3004,3005,3006,3007,3008,3009,3010,3011,3012,3013,4001,4002,4003,4004,4005,4006,4007,4008,4009,4010,4011,4012,4013,5001,5002,5003,5004,5005,5006,5007,5008,6001,6002,6003,6004,7001,7002,7003,7004,7005,8001,8002,8003};
+ idsDefault_tb_menu = Arrays.asList(temp3);
+ sqlstb_tb_menu = new ArrayList<>();
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('1', 'Home', '首页', 'home', '/home', 'el-icon-s-home', '0', '1', null, '1', '1', '0');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('2', 'Online Monitoring', '在线监测', 'testData', '', 'el-icon-s-data', '0', '1', null, '1', '2', '2');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3', 'Data Management', '数据管理', 'dataMager', '', 'el-icon-s-help', '0', '1', null, '1', '3', '3');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4', 'Alarm Management', '告警管理', 'alarmMager', '', 'el-icon-message-solid', '0', '1', null, '1', '4', '4');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('5', 'Report Statistics', '报表统计', 'reportStatistics', '', 'el-icon-tickets', '0', '1', null, '1', '5', '5');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('6', 'Device Management', '作业管理', 'jobManage', '', 'el-icon-s-cooperation', '0', '1', null, '1', '6', '6');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('7', 'User Management', '用户管理', 'userMager', '', 'el-icon-user-solid', '0', '1', null, '1', '7', '7');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('8', 'System Setting', '系统设置', 'systemPageSetting', '', 'el-icon-s-management', '0', '1', null, '1', '8', '8');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('2001', 'Real-time Monitoring', '实时监控', 'movingRingSystem', '/dataTest/movingRingSystem', null, '1', '1', null, '2', '1', '2');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('2002', 'Data Viewing', '历史数据', 'history', '/dataTest/history', null, '1', '1', null, '2', '2', '2');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('2003', 'Data Management', '历史数据管理', 'historyInfoMager', '/dataTest/historyInfoMager', null, '1', '1', null, '2', '3', '2');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('2004', 'Standard Curve', '标准曲线', 'standardLine', '/dataTest/standardLine', null, '1', '1', null, '2', '4', '2');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('2005', 'Device Status Search', '设备状态查询', 'btsStatus', '/dataTest/btsStatus', null, '1', '1', null, '2', '5', '2');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('2006', 'FGCD Tester Import Record', '一体机导入记录', 'historyAio', '/dataTest/historyAio', null, '1', '1', null, '2', '6', '2');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('2007', 'Comm Alarm Parameter Rule', '通信电源告警规则', 'hfSwitch', '/dataTest/hfSwitch', null, '1', '1', null, '2', '7', '2');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('2008', 'Telemetering of AC Distribution Cabinet', '交流配电柜遥测量', 'GGDmeasure', '/dataTest/GGDmeasure', null, '1', '1', null, '2', '8', '2');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('2009', 'Discharger Data Analysis', '放电仪放电数据分析', 'dischargeMeterData', '/dataTest/dischargeMeterData', null, '1', '1', null, '2', '9', '2');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3001', 'Power Supply Setting', '电源信息配置', 'powerMager', '/dataMager/powerMager', null, '1', '1', null, '2', '1', '3');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3002', 'Battery Info Management', '电池信息管理', 'battGroupMager', '/dataMager/battGroupMager', null, '1', '1', 'batttest_data_query_permit', '2', '2', '3');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3003', 'Equipment Room Info Manaement', '机房信息管理', 'totalStation', '/dataMager/totalStation', null, '1', '1', 'batttest_data_query_permit', '2', '3', '3');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3004', 'Battery Info Statistics Analysis', '电池信息统计分析', 'produceTotal', '/dataMager/produceTotal', null, '1', '1', null, '2', '4', '3');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3005', 'Background Thread Management', '后台线程管理', 'threadMager', '/dataMager/threadMager', null, '1', '1', 'batttest_data_query_permit', '2', '5', '3');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3006', 'Equipment Room Status Search', '机房状态查询', 'powercut', '/dataMager/powercut', null, '1', '1', 'batttest_data_query_permit', '2', '6', '3');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3007', 'Battery Management', '电池关注管理', 'batteryMager', '/dataMager/batteryMager', null, '1', '1', 'batttest_data_query_permit', '2', '7', '3');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3008', 'Device Working Status', '设备工作状态', 'deviceWorkState', '/dataMager/deviceWorkState', null, '1', '1', null, '2', '8', '3');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3009', 'Dead Battery Management', '报废电池信息管理', 'scrapBattery', '/dataMager/scrapBattery', null, '1', '1', null, '2', '9', '3');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3010', 'Spare Battery Management', '备件电池信息管理', 'repairBattery', '/dataMager/repairBattery', null, '1', '1', null, '2', '10', '3');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3011', 'Electricity Rate Distribution Template', '电价分布模板管理', 'elePriceDistributionTpl', '/dataMager/elePriceDistributionTpl', null, '1', '1', null, '2', '11', '3');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3012', 'FGCD Equipment Room Import', '一体机机房导入', 'aioStationImport', '/dataMager/aioStationImport', null, '1', '1', null, '2', '12', '3');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3013', 'Carbon Neutral', '碳中和', 'carbonInfo', '/dataMager/carbonInfo', null, '1', '1', null, '2', '13', '3');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4001', 'Power Supply Real-time Alarm', '电源实时告警', 'powerRealtimeInfo', '/alarmMager/powerRealtimeInfo', null, '1', '1', null, '2', '1', '4');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4002', 'Power Supply History Alarm', '电源历史告警', 'powerHistoryInfo', '/alarmMager/powerHistoryInfo', null, '1', '1', null, '2', '2', '4');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4003', 'Battery Alarm Real-time Search', '电池告警实时查询', 'batteryrTimequery', '/alarmMager/batteryrTimequery', null, '1', '1', 'batt_alm_query_permit', '2', '3', '4');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4004', 'Battery Alarm History Search', '电池告警历史查询', 'batteryrHistoryquery', '/alarmMager/batteryrHistoryquery', null, '1', '1', 'batt_alm_query_permit', '2', '4', '4');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4005', 'Device Alarm Real-time Search', '设备告警实时查询', 'deviceTimequery', '/alarmMager/deviceTimequery', null, '1', '1', 'dev_alm_query_permit', '2', '5', '4');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4006', 'Device Alarm History Search', '设备告警历史查询', 'deviceHistoryquery', '/alarmMager/deviceHistoryquery', null, '1', '1', 'dev_alm_query_permit', '2', '6', '4');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4007', 'Comm Power Real-time Alarm', '通信电源实时告警', 'powerBoxAlarm', '/alarmMager/powerBoxAlarm', null, '1', '1', null, '2', '7', '4');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4008', 'Comm Power History Alarm', '通信电源历史告警', 'powerBoxHistoryAlarm', '/alarmMager/powerBoxHistoryAlarm', null, '1', '1', null, '2', '8', '4');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4009', 'Comm Power Timeout Alarm', '通信电源超时告警', 'powerAlarmTimeout', '/alarmMager/powerAlarmTimeout', null, '1', '1', null, '2', '9', '4');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4010', 'Comm Alarm Parameter Rule', '通信电源告警规则', 'powerCabinetSetting', '/alarmMager/powerCabinetSetting', null, '1', '1', null, '2', '10', '4');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4011', 'Battery Alarm Parameter Setting', '电池告警参数设置', 'devicepaSetting', '/alarmMager/devicepaSetting', null, '1', '1', 'batt_alm_param_query_permit', '2', '11', '4');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4012', 'Alarm Assign Management', '告警派单管理', 'alarmDispatch', '/alarmMager/alarmDispatch', null, '1', '1', null, '2', '12', '4');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4013', 'Alarm Preprocess Management', '告警预处理管理', 'alarmHandle', '/alarmMager/alarmHandle', null, '1', '1', 'batt_alm_param_query_permit', '2', '13', '4');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('5001', 'Battery Group Statistics Search', '电池组统计分析查询', 'eleAnalyse', '/reportStatistics/eleAnalyse', null, '1', '1', null, '2', '1', '5');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('5002', 'Cell Statistics Search', '电池单体统计分析查询', 'eleMonomer', '/reportStatistics/eleMonomer', null, '1', '1', null, '2', '2', '5');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('5003', 'Battery Group Post-Evaluation', '蓄电池组后评估', 'eleAssess', '/reportStatistics/eleAssess', null, '1', '1', null, '2', '3', '5');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('5004', 'Lagging Cell Search', '落后单体查询', 'taskplan', '/reportStatistics/taskplan', null, '1', '1', null, '2', '4', '5');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('5005', 'Battery Real-time Status Search', '电池实时状态查询', 'elestatus', '/reportStatistics/elestatus', null, '1', '1', null, '2', '5', '5');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('5006', 'Battery Life History Search', '电池续航能力历史查询', 'endure', '/reportStatistics/endure', null, '1', '1', null, '2', '6', '5');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('5007', 'Comm Power Report', '通信电源报表', 'powerReport', '/reportStatistics/powerReport', null, '1', '1', null, '2', '7', '5');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('5008', 'Event Summary Table', '事件总表', 'eventTotalPage', '/reportStatistics/eventTotalPage', null, '1', '1', null, '2', '8', '5');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('6001', 'BTS Equipment Upgrade', 'BTS设备升级', 'btsUpgrade', '/jobManage/btsUpgrade', null, '1', '1', null, '2', '1', '6');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('6002', 'Discharge Plan Management', '放电计划管理', 'planManage', '/jobManage/planManage', null, '1', '1', null, '2', '2', '6');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('6003', 'LD-9 Device Upgrade', '9度设备升级', 'nineDevUpdate', '/jobManage/nineDevUpdate', null, '1', '1', null, '2', '3', '6');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('6004', 'FGCD Tester Upgrade', '一体机设备升级', 'aioUpdate', '/jobManage/aioUpdate', null, '1', '1', null, '2', '4', '6');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('7001', 'User Info Management', '用户信息管理', 'userInfoMager', '/userMager/userInfo', null, '1', '1', 'usr_query_permit', '2', '1', '7');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('7002', 'User Facial Recognition', '用户人脸管理', 'userFaceManager', '/userMager/userFaceManager', null, '1', '1', null, '2', '2', '7');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('7003', 'Authority Management', '权限管理', 'powerMager', '/userMager/powerMager', null, '1', '1', 'permit_query_permit', '2', '3', '7');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('7004', 'Work Team Management', '包机组管理', 'baojiMager', '/userMager/baojiMager', null, '1', '1', 'usr_query_permit', '2', '4', '7');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('7005', 'Operation Event Management', '操作事件管理', 'operationRecordMager', '/userMager/operationRecord', null, '1', '1', null, '2', '5', '7');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('8001', 'System Configuration', '系统配置', 'realTimeSetting', '/pageSetting/realTime', null, '1', '1', 'batt_test_op_permit', '2', '1', '8');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('8002', '3D Equipement Room Config.', '3D机房配置', 'threeHomeSetting', '/pageSetting/threeHomeSetting', null, '1', '1', null, '2', '2', '8');");
+ sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('8003', 'Map Configuration', '地图配置', 'chartMapSetting', '/pageSetting/chartMapSetting', null, '1', '1', null, '2', '3', '8');");
+
}
--
Gitblit v1.9.1