diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index 1910af6..616405e 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,7 +7,13 @@
+
+
+
+
+
+
@@ -24,7 +30,7 @@
-
+
@@ -32,37 +38,37 @@
-
+
-
+
-
+
-
-
+
+
-
+
-
+
-
+
@@ -75,18 +81,21 @@
-
+
-
+
-
-
+
+
+
+
+
@@ -94,17 +103,71 @@
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -168,8 +231,6 @@
-
-
@@ -181,8 +242,14 @@
-
+
+
+
+
+
+
+
@@ -218,18 +285,16 @@
-
-
-
-
+
+
+
+
-
-
@@ -270,12 +335,53 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -415,7 +521,9 @@
-
+
+
+
1564361618083
@@ -473,11 +581,18 @@
1566963831930
-
+
+ 1566972146710
+
+
+
+ 1566972146710
+
+
-
+
@@ -490,9 +605,8 @@
-
-
+
@@ -578,7 +692,8 @@
-
+
+
@@ -593,48 +708,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -670,13 +743,6 @@
-
-
-
-
-
-
-
@@ -712,13 +778,6 @@
-
-
-
-
-
-
-
@@ -919,17 +978,6 @@
-
-
-
-
-
-
-
-
-
-
-
@@ -940,24 +988,92 @@
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index 1910af6..616405e 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,7 +7,13 @@
+
+
+
+
+
+
@@ -24,7 +30,7 @@
-
+
@@ -32,37 +38,37 @@
-
+
-
+
-
+
-
-
+
+
-
+
-
+
-
+
@@ -75,18 +81,21 @@
-
+
-
+
-
-
+
+
+
+
+
@@ -94,17 +103,71 @@
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -168,8 +231,6 @@
-
-
@@ -181,8 +242,14 @@
-
+
+
+
+
+
+
+
@@ -218,18 +285,16 @@
-
-
-
-
+
+
+
+
-
-
@@ -270,12 +335,53 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -415,7 +521,9 @@
-
+
+
+
1564361618083
@@ -473,11 +581,18 @@
1566963831930
-
+
+ 1566972146710
+
+
+
+ 1566972146710
+
+
-
+
@@ -490,9 +605,8 @@
-
-
+
@@ -578,7 +692,8 @@
-
+
+
@@ -593,48 +708,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -670,13 +743,6 @@
-
-
-
-
-
-
-
@@ -712,13 +778,6 @@
-
-
-
-
-
-
-
@@ -919,17 +978,6 @@
-
-
-
-
-
-
-
-
-
-
-
@@ -940,24 +988,92 @@
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java b/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java
index 854f1f1..0db633a 100644
--- a/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java
+++ b/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java
@@ -165,12 +165,16 @@
}
//获取历史报警消息列表
- public List getAllAlarm(String startDay,String endDay) {
+ public List getAllAlarm(String alarmType,String startDay,String endDay,String isNew) {
try {
Criteria criteria = createCriteria(PgAlarm.class);
criteria.addOrder(Order.desc("id"));
+ if (StringUtils.isNotBlank(alarmType)&&!alarmType.contains("全部")) {
+ criteria.add(Restrictions.eq("alarmTypeId", pgAlarmTypeManager.getAlarmTypeByAlarmType(alarmType)));
+ }
+
if(StringUtils.isNotBlank(startDay)&&StringUtils.isNotBlank(endDay))
{
criteria.add(Restrictions.ge("alarmDate", DateUtils.sdf_day.parse(startDay)));
@@ -193,9 +197,11 @@
criteria.add(Restrictions.le("alarmDate",date));
}
+ if(StringUtils.isNotBlank(isNew)&&isNew.equals("true"))
+ criteria.add(Restrictions.eq("active", 1));
List pgAlarmList = criteria.list();
- List pgAlarmDtoList = new ArrayList();
+ List pgAlarmDtoList = new ArrayList<>();
for (PgAlarm pgAlarm : pgAlarmList) {
pgAlarmDtoList.add(new PgAlarmDto(pgAlarm));
}
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index 1910af6..616405e 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,7 +7,13 @@
+
+
+
+
+
+
@@ -24,7 +30,7 @@
-
+
@@ -32,37 +38,37 @@
-
+
-
+
-
+
-
-
+
+
-
+
-
+
-
+
@@ -75,18 +81,21 @@
-
+
-
+
-
-
+
+
+
+
+
@@ -94,17 +103,71 @@
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -168,8 +231,6 @@
-
-
@@ -181,8 +242,14 @@
-
+
+
+
+
+
+
+
@@ -218,18 +285,16 @@
-
-
-
-
+
+
+
+
-
-
@@ -270,12 +335,53 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -415,7 +521,9 @@
-
+
+
+
1564361618083
@@ -473,11 +581,18 @@
1566963831930
-
+
+ 1566972146710
+
+
+
+ 1566972146710
+
+
-
+
@@ -490,9 +605,8 @@
-
-
+
@@ -578,7 +692,8 @@
-
+
+
@@ -593,48 +708,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -670,13 +743,6 @@
-
-
-
-
-
-
-
@@ -712,13 +778,6 @@
-
-
-
-
-
-
-
@@ -919,17 +978,6 @@
-
-
-
-
-
-
-
-
-
-
-
@@ -940,24 +988,92 @@
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java b/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java
index 854f1f1..0db633a 100644
--- a/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java
+++ b/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java
@@ -165,12 +165,16 @@
}
//获取历史报警消息列表
- public List getAllAlarm(String startDay,String endDay) {
+ public List getAllAlarm(String alarmType,String startDay,String endDay,String isNew) {
try {
Criteria criteria = createCriteria(PgAlarm.class);
criteria.addOrder(Order.desc("id"));
+ if (StringUtils.isNotBlank(alarmType)&&!alarmType.contains("全部")) {
+ criteria.add(Restrictions.eq("alarmTypeId", pgAlarmTypeManager.getAlarmTypeByAlarmType(alarmType)));
+ }
+
if(StringUtils.isNotBlank(startDay)&&StringUtils.isNotBlank(endDay))
{
criteria.add(Restrictions.ge("alarmDate", DateUtils.sdf_day.parse(startDay)));
@@ -193,9 +197,11 @@
criteria.add(Restrictions.le("alarmDate",date));
}
+ if(StringUtils.isNotBlank(isNew)&&isNew.equals("true"))
+ criteria.add(Restrictions.eq("active", 1));
List pgAlarmList = criteria.list();
- List pgAlarmDtoList = new ArrayList();
+ List pgAlarmDtoList = new ArrayList<>();
for (PgAlarm pgAlarm : pgAlarmList) {
pgAlarmDtoList.add(new PgAlarmDto(pgAlarm));
}
diff --git a/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java b/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java
index 5346b57..2f8d359 100644
--- a/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java
+++ b/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java
@@ -66,7 +66,7 @@
this.recordNo = recordNo;
}
- @Column(name="REPAIRMAN")
+ @Column(name="REOAIRMAN")
public String getRepairMan() {
return repairMan;
}
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index 1910af6..616405e 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,7 +7,13 @@
+
+
+
+
+
+
@@ -24,7 +30,7 @@
-
+
@@ -32,37 +38,37 @@
-
+
-
+
-
+
-
-
+
+
-
+
-
+
-
+
@@ -75,18 +81,21 @@
-
+
-
+
-
-
+
+
+
+
+
@@ -94,17 +103,71 @@
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -168,8 +231,6 @@
-
-
@@ -181,8 +242,14 @@
-
+
+
+
+
+
+
+
@@ -218,18 +285,16 @@
-
-
-
-
+
+
+
+
-
-
@@ -270,12 +335,53 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -415,7 +521,9 @@
-
+
+
+
1564361618083
@@ -473,11 +581,18 @@
1566963831930
-
+
+ 1566972146710
+
+
+
+ 1566972146710
+
+
-
+
@@ -490,9 +605,8 @@
-
-
+
@@ -578,7 +692,8 @@
-
+
+
@@ -593,48 +708,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -670,13 +743,6 @@
-
-
-
-
-
-
-
@@ -712,13 +778,6 @@
-
-
-
-
-
-
-
@@ -919,17 +978,6 @@
-
-
-
-
-
-
-
-
-
-
-
@@ -940,24 +988,92 @@
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java b/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java
index 854f1f1..0db633a 100644
--- a/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java
+++ b/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java
@@ -165,12 +165,16 @@
}
//获取历史报警消息列表
- public List getAllAlarm(String startDay,String endDay) {
+ public List getAllAlarm(String alarmType,String startDay,String endDay,String isNew) {
try {
Criteria criteria = createCriteria(PgAlarm.class);
criteria.addOrder(Order.desc("id"));
+ if (StringUtils.isNotBlank(alarmType)&&!alarmType.contains("全部")) {
+ criteria.add(Restrictions.eq("alarmTypeId", pgAlarmTypeManager.getAlarmTypeByAlarmType(alarmType)));
+ }
+
if(StringUtils.isNotBlank(startDay)&&StringUtils.isNotBlank(endDay))
{
criteria.add(Restrictions.ge("alarmDate", DateUtils.sdf_day.parse(startDay)));
@@ -193,9 +197,11 @@
criteria.add(Restrictions.le("alarmDate",date));
}
+ if(StringUtils.isNotBlank(isNew)&&isNew.equals("true"))
+ criteria.add(Restrictions.eq("active", 1));
List pgAlarmList = criteria.list();
- List pgAlarmDtoList = new ArrayList();
+ List pgAlarmDtoList = new ArrayList<>();
for (PgAlarm pgAlarm : pgAlarmList) {
pgAlarmDtoList.add(new PgAlarmDto(pgAlarm));
}
diff --git a/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java b/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java
index 5346b57..2f8d359 100644
--- a/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java
+++ b/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java
@@ -66,7 +66,7 @@
this.recordNo = recordNo;
}
- @Column(name="REPAIRMAN")
+ @Column(name="REOAIRMAN")
public String getRepairMan() {
return repairMan;
}
diff --git a/src/main/java/com/casic/PgInterface/maintenance/manager/PgMaintanceRecordHeadManager.java b/src/main/java/com/casic/PgInterface/maintenance/manager/PgMaintanceRecordHeadManager.java
index 0903f22..3484739 100644
--- a/src/main/java/com/casic/PgInterface/maintenance/manager/PgMaintanceRecordHeadManager.java
+++ b/src/main/java/com/casic/PgInterface/maintenance/manager/PgMaintanceRecordHeadManager.java
@@ -15,7 +15,7 @@
public List getPgMaintanceRecordHeadLsit(String repairMan,String startTime,String endTime){
try {
- String sql="select ID,KEY_ID,PLAN_KEY_ID,PLAN_NAME,RECORD_NO,REPAIRMAN,MAINTENANCE_DATE," +
+ String sql="select ID,KEY_ID,PLAN_KEY_ID,PLAN_NAME,RECORD_NO,REOAIRMAN,MAINTENANCE_DATE," +
"BUILD_CABIN,PROJECT,CREATEDATE,CREATOR from PG_MAINTANCERECORD_HEAD where 1=1";
if(repairMan!=null)
sql+=" and REPAIRMAN like '%"+repairMan+"%'";
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index 1910af6..616405e 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,7 +7,13 @@
+
+
+
+
+
+
@@ -24,7 +30,7 @@
-
+
@@ -32,37 +38,37 @@
-
+
-
+
-
+
-
-
+
+
-
+
-
+
-
+
@@ -75,18 +81,21 @@
-
+
-
+
-
-
+
+
+
+
+
@@ -94,17 +103,71 @@
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -168,8 +231,6 @@
-
-
@@ -181,8 +242,14 @@
-
+
+
+
+
+
+
+
@@ -218,18 +285,16 @@
-
-
-
-
+
+
+
+
-
-
@@ -270,12 +335,53 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -415,7 +521,9 @@
-
+
+
+
1564361618083
@@ -473,11 +581,18 @@
1566963831930
-
+
+ 1566972146710
+
+
+
+ 1566972146710
+
+
-
+
@@ -490,9 +605,8 @@
-
-
+
@@ -578,7 +692,8 @@
-
+
+
@@ -593,48 +708,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -670,13 +743,6 @@
-
-
-
-
-
-
-
@@ -712,13 +778,6 @@
-
-
-
-
-
-
-
@@ -919,17 +978,6 @@
-
-
-
-
-
-
-
-
-
-
-
@@ -940,24 +988,92 @@
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java b/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java
index 854f1f1..0db633a 100644
--- a/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java
+++ b/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java
@@ -165,12 +165,16 @@
}
//获取历史报警消息列表
- public List getAllAlarm(String startDay,String endDay) {
+ public List getAllAlarm(String alarmType,String startDay,String endDay,String isNew) {
try {
Criteria criteria = createCriteria(PgAlarm.class);
criteria.addOrder(Order.desc("id"));
+ if (StringUtils.isNotBlank(alarmType)&&!alarmType.contains("全部")) {
+ criteria.add(Restrictions.eq("alarmTypeId", pgAlarmTypeManager.getAlarmTypeByAlarmType(alarmType)));
+ }
+
if(StringUtils.isNotBlank(startDay)&&StringUtils.isNotBlank(endDay))
{
criteria.add(Restrictions.ge("alarmDate", DateUtils.sdf_day.parse(startDay)));
@@ -193,9 +197,11 @@
criteria.add(Restrictions.le("alarmDate",date));
}
+ if(StringUtils.isNotBlank(isNew)&&isNew.equals("true"))
+ criteria.add(Restrictions.eq("active", 1));
List pgAlarmList = criteria.list();
- List pgAlarmDtoList = new ArrayList();
+ List pgAlarmDtoList = new ArrayList<>();
for (PgAlarm pgAlarm : pgAlarmList) {
pgAlarmDtoList.add(new PgAlarmDto(pgAlarm));
}
diff --git a/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java b/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java
index 5346b57..2f8d359 100644
--- a/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java
+++ b/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java
@@ -66,7 +66,7 @@
this.recordNo = recordNo;
}
- @Column(name="REPAIRMAN")
+ @Column(name="REOAIRMAN")
public String getRepairMan() {
return repairMan;
}
diff --git a/src/main/java/com/casic/PgInterface/maintenance/manager/PgMaintanceRecordHeadManager.java b/src/main/java/com/casic/PgInterface/maintenance/manager/PgMaintanceRecordHeadManager.java
index 0903f22..3484739 100644
--- a/src/main/java/com/casic/PgInterface/maintenance/manager/PgMaintanceRecordHeadManager.java
+++ b/src/main/java/com/casic/PgInterface/maintenance/manager/PgMaintanceRecordHeadManager.java
@@ -15,7 +15,7 @@
public List getPgMaintanceRecordHeadLsit(String repairMan,String startTime,String endTime){
try {
- String sql="select ID,KEY_ID,PLAN_KEY_ID,PLAN_NAME,RECORD_NO,REPAIRMAN,MAINTENANCE_DATE," +
+ String sql="select ID,KEY_ID,PLAN_KEY_ID,PLAN_NAME,RECORD_NO,REOAIRMAN,MAINTENANCE_DATE," +
"BUILD_CABIN,PROJECT,CREATEDATE,CREATOR from PG_MAINTANCERECORD_HEAD where 1=1";
if(repairMan!=null)
sql+=" and REPAIRMAN like '%"+repairMan+"%'";
diff --git a/src/main/java/com/casic/PgInterface/patroler/dto/PgAlarmRuleDto.java b/src/main/java/com/casic/PgInterface/patroler/dto/PgAlarmRuleDto.java
index 9cc2881..6d90d7b 100644
--- a/src/main/java/com/casic/PgInterface/patroler/dto/PgAlarmRuleDto.java
+++ b/src/main/java/com/casic/PgInterface/patroler/dto/PgAlarmRuleDto.java
@@ -1,5 +1,7 @@
package com.casic.PgInterface.patroler.dto;
+import com.casic.PgInterface.devTable.domain.PgDevice;
+import com.casic.PgInterface.devTable.manager.PgDeviceManager;
import com.casic.PgInterface.patroler.domain.PgAlarmRule;
/**
@@ -14,6 +16,7 @@
private String unit;//单位
private String alarmType;//报警类型
private Long pgDeviceId;//设备编号
+ private String assetCode;//资产编号
public Long getId() {
return id;
@@ -71,7 +74,15 @@
this.pgDeviceId = pgDeviceId;
}
- public PgAlarmRuleDto(PgAlarmRule pgAlarmRule) {
+ public String getAssetCode() {
+ return assetCode;
+ }
+
+ public void setAssetCode(String assetCode) {
+ this.assetCode = assetCode;
+ }
+
+ public PgAlarmRuleDto(PgAlarmRule pgAlarmRule, PgDeviceManager pgDeviceManager) {
this.setId(pgAlarmRule.getId());
this.setHighValue(pgAlarmRule.getHighValue());
this.setLowValue(pgAlarmRule.getLowValue());
@@ -82,6 +93,10 @@
else
this.setAlarmType(pgAlarmRule.getAlarmTypeId().getAlarmType());
this.setPgDeviceId(pgAlarmRule.getPgDeviceId());
+ if(pgAlarmRule.getAlarmTypeId()!=null&&pgDeviceManager.get(pgAlarmRule.getPgDeviceId())!=null)
+ this.setAssetCode(pgDeviceManager.get(pgAlarmRule.getPgDeviceId()).getAssetCode());
+ else
+ this.setAssetCode("");
}
}
\ No newline at end of file
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index 1910af6..616405e 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,7 +7,13 @@
+
+
+
+
+
+
@@ -24,7 +30,7 @@
-
+
@@ -32,37 +38,37 @@
-
+
-
+
-
+
-
-
+
+
-
+
-
+
-
+
@@ -75,18 +81,21 @@
-
+
-
+
-
-
+
+
+
+
+
@@ -94,17 +103,71 @@
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -168,8 +231,6 @@
-
-
@@ -181,8 +242,14 @@
-
+
+
+
+
+
+
+
@@ -218,18 +285,16 @@
-
-
-
-
+
+
+
+
-
-
@@ -270,12 +335,53 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -415,7 +521,9 @@
-
+
+
+
1564361618083
@@ -473,11 +581,18 @@
1566963831930
-
+
+ 1566972146710
+
+
+
+ 1566972146710
+
+
-
+
@@ -490,9 +605,8 @@
-
-
+
@@ -578,7 +692,8 @@
-
+
+
@@ -593,48 +708,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -670,13 +743,6 @@
-
-
-
-
-
-
-
@@ -712,13 +778,6 @@
-
-
-
-
-
-
-
@@ -919,17 +978,6 @@
-
-
-
-
-
-
-
-
-
-
-
@@ -940,24 +988,92 @@
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java b/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java
index 854f1f1..0db633a 100644
--- a/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java
+++ b/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java
@@ -165,12 +165,16 @@
}
//获取历史报警消息列表
- public List getAllAlarm(String startDay,String endDay) {
+ public List getAllAlarm(String alarmType,String startDay,String endDay,String isNew) {
try {
Criteria criteria = createCriteria(PgAlarm.class);
criteria.addOrder(Order.desc("id"));
+ if (StringUtils.isNotBlank(alarmType)&&!alarmType.contains("全部")) {
+ criteria.add(Restrictions.eq("alarmTypeId", pgAlarmTypeManager.getAlarmTypeByAlarmType(alarmType)));
+ }
+
if(StringUtils.isNotBlank(startDay)&&StringUtils.isNotBlank(endDay))
{
criteria.add(Restrictions.ge("alarmDate", DateUtils.sdf_day.parse(startDay)));
@@ -193,9 +197,11 @@
criteria.add(Restrictions.le("alarmDate",date));
}
+ if(StringUtils.isNotBlank(isNew)&&isNew.equals("true"))
+ criteria.add(Restrictions.eq("active", 1));
List pgAlarmList = criteria.list();
- List pgAlarmDtoList = new ArrayList();
+ List pgAlarmDtoList = new ArrayList<>();
for (PgAlarm pgAlarm : pgAlarmList) {
pgAlarmDtoList.add(new PgAlarmDto(pgAlarm));
}
diff --git a/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java b/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java
index 5346b57..2f8d359 100644
--- a/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java
+++ b/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java
@@ -66,7 +66,7 @@
this.recordNo = recordNo;
}
- @Column(name="REPAIRMAN")
+ @Column(name="REOAIRMAN")
public String getRepairMan() {
return repairMan;
}
diff --git a/src/main/java/com/casic/PgInterface/maintenance/manager/PgMaintanceRecordHeadManager.java b/src/main/java/com/casic/PgInterface/maintenance/manager/PgMaintanceRecordHeadManager.java
index 0903f22..3484739 100644
--- a/src/main/java/com/casic/PgInterface/maintenance/manager/PgMaintanceRecordHeadManager.java
+++ b/src/main/java/com/casic/PgInterface/maintenance/manager/PgMaintanceRecordHeadManager.java
@@ -15,7 +15,7 @@
public List getPgMaintanceRecordHeadLsit(String repairMan,String startTime,String endTime){
try {
- String sql="select ID,KEY_ID,PLAN_KEY_ID,PLAN_NAME,RECORD_NO,REPAIRMAN,MAINTENANCE_DATE," +
+ String sql="select ID,KEY_ID,PLAN_KEY_ID,PLAN_NAME,RECORD_NO,REOAIRMAN,MAINTENANCE_DATE," +
"BUILD_CABIN,PROJECT,CREATEDATE,CREATOR from PG_MAINTANCERECORD_HEAD where 1=1";
if(repairMan!=null)
sql+=" and REPAIRMAN like '%"+repairMan+"%'";
diff --git a/src/main/java/com/casic/PgInterface/patroler/dto/PgAlarmRuleDto.java b/src/main/java/com/casic/PgInterface/patroler/dto/PgAlarmRuleDto.java
index 9cc2881..6d90d7b 100644
--- a/src/main/java/com/casic/PgInterface/patroler/dto/PgAlarmRuleDto.java
+++ b/src/main/java/com/casic/PgInterface/patroler/dto/PgAlarmRuleDto.java
@@ -1,5 +1,7 @@
package com.casic.PgInterface.patroler.dto;
+import com.casic.PgInterface.devTable.domain.PgDevice;
+import com.casic.PgInterface.devTable.manager.PgDeviceManager;
import com.casic.PgInterface.patroler.domain.PgAlarmRule;
/**
@@ -14,6 +16,7 @@
private String unit;//单位
private String alarmType;//报警类型
private Long pgDeviceId;//设备编号
+ private String assetCode;//资产编号
public Long getId() {
return id;
@@ -71,7 +74,15 @@
this.pgDeviceId = pgDeviceId;
}
- public PgAlarmRuleDto(PgAlarmRule pgAlarmRule) {
+ public String getAssetCode() {
+ return assetCode;
+ }
+
+ public void setAssetCode(String assetCode) {
+ this.assetCode = assetCode;
+ }
+
+ public PgAlarmRuleDto(PgAlarmRule pgAlarmRule, PgDeviceManager pgDeviceManager) {
this.setId(pgAlarmRule.getId());
this.setHighValue(pgAlarmRule.getHighValue());
this.setLowValue(pgAlarmRule.getLowValue());
@@ -82,6 +93,10 @@
else
this.setAlarmType(pgAlarmRule.getAlarmTypeId().getAlarmType());
this.setPgDeviceId(pgAlarmRule.getPgDeviceId());
+ if(pgAlarmRule.getAlarmTypeId()!=null&&pgDeviceManager.get(pgAlarmRule.getPgDeviceId())!=null)
+ this.setAssetCode(pgDeviceManager.get(pgAlarmRule.getPgDeviceId()).getAssetCode());
+ else
+ this.setAssetCode("");
}
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgAlarmRuleManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgAlarmRuleManager.java
index 1506dd4..a7cef5b 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgAlarmRuleManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgAlarmRuleManager.java
@@ -2,13 +2,16 @@
import com.casic.PgInterface.core.hibernate.HibernateEntityDao;
import com.casic.PgInterface.core.util.StringUtils;
+import com.casic.PgInterface.devTable.manager.PgDeviceManager;
import com.casic.PgInterface.patroler.domain.PgAlarmRule;
import com.casic.PgInterface.patroler.dto.PgAlarmRuleDto;
import org.hibernate.Criteria;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;
import org.springframework.stereotype.Service;
+import org.springframework.web.bind.annotation.ResponseStatus;
+import javax.annotation.Resource;
import java.util.ArrayList;
import java.util.List;
@@ -18,6 +21,9 @@
@Service
public class PgAlarmRuleManager extends HibernateEntityDao {
+ @Resource
+ private PgDeviceManager pgDeviceManager;
+
//根据设备获取设备报警阈值
public List getAlarmRuleDto(String devType) {
Criteria criteria=createCriteria(PgAlarmRule.class);
@@ -29,7 +35,7 @@
List pgAlarmRuleList=criteria.list();
List pgAlarmRuleDtoList = new ArrayList<>();
for (PgAlarmRule pgAlarmRule : pgAlarmRuleList) {
- pgAlarmRuleDtoList.add(new PgAlarmRuleDto(pgAlarmRule));
+ pgAlarmRuleDtoList.add(new PgAlarmRuleDto(pgAlarmRule,pgDeviceManager));
}
return pgAlarmRuleDtoList;
}
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index 1910af6..616405e 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,7 +7,13 @@
+
+
+
+
+
+
@@ -24,7 +30,7 @@
-
+
@@ -32,37 +38,37 @@
-
+
-
+
-
+
-
-
+
+
-
+
-
+
-
+
@@ -75,18 +81,21 @@
-
+
-
+
-
-
+
+
+
+
+
@@ -94,17 +103,71 @@
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -168,8 +231,6 @@
-
-
@@ -181,8 +242,14 @@
-
+
+
+
+
+
+
+
@@ -218,18 +285,16 @@
-
-
-
-
+
+
+
+
-
-
@@ -270,12 +335,53 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -415,7 +521,9 @@
-
+
+
+
1564361618083
@@ -473,11 +581,18 @@
1566963831930
-
+
+ 1566972146710
+
+
+
+ 1566972146710
+
+
-
+
@@ -490,9 +605,8 @@
-
-
+
@@ -578,7 +692,8 @@
-
+
+
@@ -593,48 +708,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -670,13 +743,6 @@
-
-
-
-
-
-
-
@@ -712,13 +778,6 @@
-
-
-
-
-
-
-
@@ -919,17 +978,6 @@
-
-
-
-
-
-
-
-
-
-
-
@@ -940,24 +988,92 @@
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java b/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java
index 854f1f1..0db633a 100644
--- a/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java
+++ b/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java
@@ -165,12 +165,16 @@
}
//获取历史报警消息列表
- public List getAllAlarm(String startDay,String endDay) {
+ public List getAllAlarm(String alarmType,String startDay,String endDay,String isNew) {
try {
Criteria criteria = createCriteria(PgAlarm.class);
criteria.addOrder(Order.desc("id"));
+ if (StringUtils.isNotBlank(alarmType)&&!alarmType.contains("全部")) {
+ criteria.add(Restrictions.eq("alarmTypeId", pgAlarmTypeManager.getAlarmTypeByAlarmType(alarmType)));
+ }
+
if(StringUtils.isNotBlank(startDay)&&StringUtils.isNotBlank(endDay))
{
criteria.add(Restrictions.ge("alarmDate", DateUtils.sdf_day.parse(startDay)));
@@ -193,9 +197,11 @@
criteria.add(Restrictions.le("alarmDate",date));
}
+ if(StringUtils.isNotBlank(isNew)&&isNew.equals("true"))
+ criteria.add(Restrictions.eq("active", 1));
List pgAlarmList = criteria.list();
- List pgAlarmDtoList = new ArrayList();
+ List pgAlarmDtoList = new ArrayList<>();
for (PgAlarm pgAlarm : pgAlarmList) {
pgAlarmDtoList.add(new PgAlarmDto(pgAlarm));
}
diff --git a/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java b/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java
index 5346b57..2f8d359 100644
--- a/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java
+++ b/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java
@@ -66,7 +66,7 @@
this.recordNo = recordNo;
}
- @Column(name="REPAIRMAN")
+ @Column(name="REOAIRMAN")
public String getRepairMan() {
return repairMan;
}
diff --git a/src/main/java/com/casic/PgInterface/maintenance/manager/PgMaintanceRecordHeadManager.java b/src/main/java/com/casic/PgInterface/maintenance/manager/PgMaintanceRecordHeadManager.java
index 0903f22..3484739 100644
--- a/src/main/java/com/casic/PgInterface/maintenance/manager/PgMaintanceRecordHeadManager.java
+++ b/src/main/java/com/casic/PgInterface/maintenance/manager/PgMaintanceRecordHeadManager.java
@@ -15,7 +15,7 @@
public List getPgMaintanceRecordHeadLsit(String repairMan,String startTime,String endTime){
try {
- String sql="select ID,KEY_ID,PLAN_KEY_ID,PLAN_NAME,RECORD_NO,REPAIRMAN,MAINTENANCE_DATE," +
+ String sql="select ID,KEY_ID,PLAN_KEY_ID,PLAN_NAME,RECORD_NO,REOAIRMAN,MAINTENANCE_DATE," +
"BUILD_CABIN,PROJECT,CREATEDATE,CREATOR from PG_MAINTANCERECORD_HEAD where 1=1";
if(repairMan!=null)
sql+=" and REPAIRMAN like '%"+repairMan+"%'";
diff --git a/src/main/java/com/casic/PgInterface/patroler/dto/PgAlarmRuleDto.java b/src/main/java/com/casic/PgInterface/patroler/dto/PgAlarmRuleDto.java
index 9cc2881..6d90d7b 100644
--- a/src/main/java/com/casic/PgInterface/patroler/dto/PgAlarmRuleDto.java
+++ b/src/main/java/com/casic/PgInterface/patroler/dto/PgAlarmRuleDto.java
@@ -1,5 +1,7 @@
package com.casic.PgInterface.patroler.dto;
+import com.casic.PgInterface.devTable.domain.PgDevice;
+import com.casic.PgInterface.devTable.manager.PgDeviceManager;
import com.casic.PgInterface.patroler.domain.PgAlarmRule;
/**
@@ -14,6 +16,7 @@
private String unit;//单位
private String alarmType;//报警类型
private Long pgDeviceId;//设备编号
+ private String assetCode;//资产编号
public Long getId() {
return id;
@@ -71,7 +74,15 @@
this.pgDeviceId = pgDeviceId;
}
- public PgAlarmRuleDto(PgAlarmRule pgAlarmRule) {
+ public String getAssetCode() {
+ return assetCode;
+ }
+
+ public void setAssetCode(String assetCode) {
+ this.assetCode = assetCode;
+ }
+
+ public PgAlarmRuleDto(PgAlarmRule pgAlarmRule, PgDeviceManager pgDeviceManager) {
this.setId(pgAlarmRule.getId());
this.setHighValue(pgAlarmRule.getHighValue());
this.setLowValue(pgAlarmRule.getLowValue());
@@ -82,6 +93,10 @@
else
this.setAlarmType(pgAlarmRule.getAlarmTypeId().getAlarmType());
this.setPgDeviceId(pgAlarmRule.getPgDeviceId());
+ if(pgAlarmRule.getAlarmTypeId()!=null&&pgDeviceManager.get(pgAlarmRule.getPgDeviceId())!=null)
+ this.setAssetCode(pgDeviceManager.get(pgAlarmRule.getPgDeviceId()).getAssetCode());
+ else
+ this.setAssetCode("");
}
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgAlarmRuleManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgAlarmRuleManager.java
index 1506dd4..a7cef5b 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgAlarmRuleManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgAlarmRuleManager.java
@@ -2,13 +2,16 @@
import com.casic.PgInterface.core.hibernate.HibernateEntityDao;
import com.casic.PgInterface.core.util.StringUtils;
+import com.casic.PgInterface.devTable.manager.PgDeviceManager;
import com.casic.PgInterface.patroler.domain.PgAlarmRule;
import com.casic.PgInterface.patroler.dto.PgAlarmRuleDto;
import org.hibernate.Criteria;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;
import org.springframework.stereotype.Service;
+import org.springframework.web.bind.annotation.ResponseStatus;
+import javax.annotation.Resource;
import java.util.ArrayList;
import java.util.List;
@@ -18,6 +21,9 @@
@Service
public class PgAlarmRuleManager extends HibernateEntityDao {
+ @Resource
+ private PgDeviceManager pgDeviceManager;
+
//根据设备获取设备报警阈值
public List getAlarmRuleDto(String devType) {
Criteria criteria=createCriteria(PgAlarmRule.class);
@@ -29,7 +35,7 @@
List pgAlarmRuleList=criteria.list();
List pgAlarmRuleDtoList = new ArrayList<>();
for (PgAlarmRule pgAlarmRule : pgAlarmRuleList) {
- pgAlarmRuleDtoList.add(new PgAlarmRuleDto(pgAlarmRule));
+ pgAlarmRuleDtoList.add(new PgAlarmRuleDto(pgAlarmRule,pgDeviceManager));
}
return pgAlarmRuleDtoList;
}
diff --git a/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java b/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java
index d18ebb8..baacd93 100644
--- a/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java
+++ b/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java
@@ -48,14 +48,16 @@
@POST
@Path("getAlarmInfo")
@Produces(MediaType.APPLICATION_JSON)
- public Map getAlarmList(@FormParam("startDay") String startDay,
- @FormParam("endDay") String endDay) throws Exception {
+ public Map getAlarmList(@FormParam("alarmType") String alarmType,
+ @FormParam("startDay") String startDay,
+ @FormParam("endDay") String endDay,
+ @FormParam("isNew") String isNew) throws Exception {
Map resultMap = new HashMap<>();
String msg = "";
List pgAlarmDtoList = new ArrayList<>();
try {
- pgAlarmDtoList = pgAlarmManager.getAllAlarm(startDay,endDay);
- if (pgAlarmDtoList.size() == 0)
+ pgAlarmDtoList = pgAlarmManager.getAllAlarm(alarmType,startDay,endDay,isNew);
+ if (pgAlarmDtoList==null||pgAlarmDtoList.size() == 0)
msg = "没有报警信息";
else
msg = "报警信息获取成功";
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index 1910af6..616405e 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,7 +7,13 @@
+
+
+
+
+
+
@@ -24,7 +30,7 @@
-
+
@@ -32,37 +38,37 @@
-
+
-
+
-
+
-
-
+
+
-
+
-
+
-
+
@@ -75,18 +81,21 @@
-
+
-
+
-
-
+
+
+
+
+
@@ -94,17 +103,71 @@
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -168,8 +231,6 @@
-
-
@@ -181,8 +242,14 @@
-
+
+
+
+
+
+
+
@@ -218,18 +285,16 @@
-
-
-
-
+
+
+
+
-
-
@@ -270,12 +335,53 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -415,7 +521,9 @@
-
+
+
+
1564361618083
@@ -473,11 +581,18 @@
1566963831930
-
+
+ 1566972146710
+
+
+
+ 1566972146710
+
+
-
+
@@ -490,9 +605,8 @@
-
-
+
@@ -578,7 +692,8 @@
-
+
+
@@ -593,48 +708,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -670,13 +743,6 @@
-
-
-
-
-
-
-
@@ -712,13 +778,6 @@
-
-
-
-
-
-
-
@@ -919,17 +978,6 @@
-
-
-
-
-
-
-
-
-
-
-
@@ -940,24 +988,92 @@
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java b/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java
index 854f1f1..0db633a 100644
--- a/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java
+++ b/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java
@@ -165,12 +165,16 @@
}
//获取历史报警消息列表
- public List getAllAlarm(String startDay,String endDay) {
+ public List getAllAlarm(String alarmType,String startDay,String endDay,String isNew) {
try {
Criteria criteria = createCriteria(PgAlarm.class);
criteria.addOrder(Order.desc("id"));
+ if (StringUtils.isNotBlank(alarmType)&&!alarmType.contains("全部")) {
+ criteria.add(Restrictions.eq("alarmTypeId", pgAlarmTypeManager.getAlarmTypeByAlarmType(alarmType)));
+ }
+
if(StringUtils.isNotBlank(startDay)&&StringUtils.isNotBlank(endDay))
{
criteria.add(Restrictions.ge("alarmDate", DateUtils.sdf_day.parse(startDay)));
@@ -193,9 +197,11 @@
criteria.add(Restrictions.le("alarmDate",date));
}
+ if(StringUtils.isNotBlank(isNew)&&isNew.equals("true"))
+ criteria.add(Restrictions.eq("active", 1));
List pgAlarmList = criteria.list();
- List pgAlarmDtoList = new ArrayList();
+ List pgAlarmDtoList = new ArrayList<>();
for (PgAlarm pgAlarm : pgAlarmList) {
pgAlarmDtoList.add(new PgAlarmDto(pgAlarm));
}
diff --git a/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java b/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java
index 5346b57..2f8d359 100644
--- a/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java
+++ b/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java
@@ -66,7 +66,7 @@
this.recordNo = recordNo;
}
- @Column(name="REPAIRMAN")
+ @Column(name="REOAIRMAN")
public String getRepairMan() {
return repairMan;
}
diff --git a/src/main/java/com/casic/PgInterface/maintenance/manager/PgMaintanceRecordHeadManager.java b/src/main/java/com/casic/PgInterface/maintenance/manager/PgMaintanceRecordHeadManager.java
index 0903f22..3484739 100644
--- a/src/main/java/com/casic/PgInterface/maintenance/manager/PgMaintanceRecordHeadManager.java
+++ b/src/main/java/com/casic/PgInterface/maintenance/manager/PgMaintanceRecordHeadManager.java
@@ -15,7 +15,7 @@
public List getPgMaintanceRecordHeadLsit(String repairMan,String startTime,String endTime){
try {
- String sql="select ID,KEY_ID,PLAN_KEY_ID,PLAN_NAME,RECORD_NO,REPAIRMAN,MAINTENANCE_DATE," +
+ String sql="select ID,KEY_ID,PLAN_KEY_ID,PLAN_NAME,RECORD_NO,REOAIRMAN,MAINTENANCE_DATE," +
"BUILD_CABIN,PROJECT,CREATEDATE,CREATOR from PG_MAINTANCERECORD_HEAD where 1=1";
if(repairMan!=null)
sql+=" and REPAIRMAN like '%"+repairMan+"%'";
diff --git a/src/main/java/com/casic/PgInterface/patroler/dto/PgAlarmRuleDto.java b/src/main/java/com/casic/PgInterface/patroler/dto/PgAlarmRuleDto.java
index 9cc2881..6d90d7b 100644
--- a/src/main/java/com/casic/PgInterface/patroler/dto/PgAlarmRuleDto.java
+++ b/src/main/java/com/casic/PgInterface/patroler/dto/PgAlarmRuleDto.java
@@ -1,5 +1,7 @@
package com.casic.PgInterface.patroler.dto;
+import com.casic.PgInterface.devTable.domain.PgDevice;
+import com.casic.PgInterface.devTable.manager.PgDeviceManager;
import com.casic.PgInterface.patroler.domain.PgAlarmRule;
/**
@@ -14,6 +16,7 @@
private String unit;//单位
private String alarmType;//报警类型
private Long pgDeviceId;//设备编号
+ private String assetCode;//资产编号
public Long getId() {
return id;
@@ -71,7 +74,15 @@
this.pgDeviceId = pgDeviceId;
}
- public PgAlarmRuleDto(PgAlarmRule pgAlarmRule) {
+ public String getAssetCode() {
+ return assetCode;
+ }
+
+ public void setAssetCode(String assetCode) {
+ this.assetCode = assetCode;
+ }
+
+ public PgAlarmRuleDto(PgAlarmRule pgAlarmRule, PgDeviceManager pgDeviceManager) {
this.setId(pgAlarmRule.getId());
this.setHighValue(pgAlarmRule.getHighValue());
this.setLowValue(pgAlarmRule.getLowValue());
@@ -82,6 +93,10 @@
else
this.setAlarmType(pgAlarmRule.getAlarmTypeId().getAlarmType());
this.setPgDeviceId(pgAlarmRule.getPgDeviceId());
+ if(pgAlarmRule.getAlarmTypeId()!=null&&pgDeviceManager.get(pgAlarmRule.getPgDeviceId())!=null)
+ this.setAssetCode(pgDeviceManager.get(pgAlarmRule.getPgDeviceId()).getAssetCode());
+ else
+ this.setAssetCode("");
}
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgAlarmRuleManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgAlarmRuleManager.java
index 1506dd4..a7cef5b 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgAlarmRuleManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgAlarmRuleManager.java
@@ -2,13 +2,16 @@
import com.casic.PgInterface.core.hibernate.HibernateEntityDao;
import com.casic.PgInterface.core.util.StringUtils;
+import com.casic.PgInterface.devTable.manager.PgDeviceManager;
import com.casic.PgInterface.patroler.domain.PgAlarmRule;
import com.casic.PgInterface.patroler.dto.PgAlarmRuleDto;
import org.hibernate.Criteria;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;
import org.springframework.stereotype.Service;
+import org.springframework.web.bind.annotation.ResponseStatus;
+import javax.annotation.Resource;
import java.util.ArrayList;
import java.util.List;
@@ -18,6 +21,9 @@
@Service
public class PgAlarmRuleManager extends HibernateEntityDao {
+ @Resource
+ private PgDeviceManager pgDeviceManager;
+
//根据设备获取设备报警阈值
public List getAlarmRuleDto(String devType) {
Criteria criteria=createCriteria(PgAlarmRule.class);
@@ -29,7 +35,7 @@
List pgAlarmRuleList=criteria.list();
List pgAlarmRuleDtoList = new ArrayList<>();
for (PgAlarmRule pgAlarmRule : pgAlarmRuleList) {
- pgAlarmRuleDtoList.add(new PgAlarmRuleDto(pgAlarmRule));
+ pgAlarmRuleDtoList.add(new PgAlarmRuleDto(pgAlarmRule,pgDeviceManager));
}
return pgAlarmRuleDtoList;
}
diff --git a/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java b/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java
index d18ebb8..baacd93 100644
--- a/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java
+++ b/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java
@@ -48,14 +48,16 @@
@POST
@Path("getAlarmInfo")
@Produces(MediaType.APPLICATION_JSON)
- public Map getAlarmList(@FormParam("startDay") String startDay,
- @FormParam("endDay") String endDay) throws Exception {
+ public Map getAlarmList(@FormParam("alarmType") String alarmType,
+ @FormParam("startDay") String startDay,
+ @FormParam("endDay") String endDay,
+ @FormParam("isNew") String isNew) throws Exception {
Map resultMap = new HashMap<>();
String msg = "";
List pgAlarmDtoList = new ArrayList<>();
try {
- pgAlarmDtoList = pgAlarmManager.getAllAlarm(startDay,endDay);
- if (pgAlarmDtoList.size() == 0)
+ pgAlarmDtoList = pgAlarmManager.getAllAlarm(alarmType,startDay,endDay,isNew);
+ if (pgAlarmDtoList==null||pgAlarmDtoList.size() == 0)
msg = "没有报警信息";
else
msg = "报警信息获取成功";
diff --git a/src/main/java/com/casic/PgInterface/rs/PgAlarmRuleRs.java b/src/main/java/com/casic/PgInterface/rs/PgAlarmRuleRs.java
index 5561e0f..73adc78 100644
--- a/src/main/java/com/casic/PgInterface/rs/PgAlarmRuleRs.java
+++ b/src/main/java/com/casic/PgInterface/rs/PgAlarmRuleRs.java
@@ -1,7 +1,5 @@
package com.casic.PgInterface.rs;
-import com.casic.PgInterface.devTable.manager.PgAlarmTypeManager;
-import com.casic.PgInterface.devTable.manager.PgDeviceManager;
import com.casic.PgInterface.patroler.domain.PgAlarmRule;
import com.casic.PgInterface.patroler.dto.PgAlarmRuleDto;
import com.casic.PgInterface.patroler.manager.PgAlarmRuleManager;
@@ -45,7 +43,7 @@
List pgAlarmRuleDtoList = new ArrayList<>();
try {
pgAlarmRuleDtoList = pgAlarmRuleManager.getAlarmRuleDto(devType);
- if (pgAlarmRuleDtoList == null)
+ if (pgAlarmRuleDtoList == null||pgAlarmRuleDtoList.size()==0)
msg = "不存在报警阈值信息";
else
msg = "报警阈值获取成功";
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index 1910af6..616405e 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,7 +7,13 @@
+
+
+
+
+
+
@@ -24,7 +30,7 @@
-
+
@@ -32,37 +38,37 @@
-
+
-
+
-
+
-
-
+
+
-
+
-
+
-
+
@@ -75,18 +81,21 @@
-
+
-
+
-
-
+
+
+
+
+
@@ -94,17 +103,71 @@
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -168,8 +231,6 @@
-
-
@@ -181,8 +242,14 @@
-
+
+
+
+
+
+
+
@@ -218,18 +285,16 @@
-
-
-
-
+
+
+
+
-
-
@@ -270,12 +335,53 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -415,7 +521,9 @@
-
+
+
+
1564361618083
@@ -473,11 +581,18 @@
1566963831930
-
+
+ 1566972146710
+
+
+
+ 1566972146710
+
+
-
+
@@ -490,9 +605,8 @@
-
-
+
@@ -578,7 +692,8 @@
-
+
+
@@ -593,48 +708,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -670,13 +743,6 @@
-
-
-
-
-
-
-
@@ -712,13 +778,6 @@
-
-
-
-
-
-
-
@@ -919,17 +978,6 @@
-
-
-
-
-
-
-
-
-
-
-
@@ -940,24 +988,92 @@
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java b/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java
index 854f1f1..0db633a 100644
--- a/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java
+++ b/src/main/java/com/casic/PgInterface/devTable/manager/PgAlarmManager.java
@@ -165,12 +165,16 @@
}
//获取历史报警消息列表
- public List getAllAlarm(String startDay,String endDay) {
+ public List getAllAlarm(String alarmType,String startDay,String endDay,String isNew) {
try {
Criteria criteria = createCriteria(PgAlarm.class);
criteria.addOrder(Order.desc("id"));
+ if (StringUtils.isNotBlank(alarmType)&&!alarmType.contains("全部")) {
+ criteria.add(Restrictions.eq("alarmTypeId", pgAlarmTypeManager.getAlarmTypeByAlarmType(alarmType)));
+ }
+
if(StringUtils.isNotBlank(startDay)&&StringUtils.isNotBlank(endDay))
{
criteria.add(Restrictions.ge("alarmDate", DateUtils.sdf_day.parse(startDay)));
@@ -193,9 +197,11 @@
criteria.add(Restrictions.le("alarmDate",date));
}
+ if(StringUtils.isNotBlank(isNew)&&isNew.equals("true"))
+ criteria.add(Restrictions.eq("active", 1));
List pgAlarmList = criteria.list();
- List pgAlarmDtoList = new ArrayList();
+ List pgAlarmDtoList = new ArrayList<>();
for (PgAlarm pgAlarm : pgAlarmList) {
pgAlarmDtoList.add(new PgAlarmDto(pgAlarm));
}
diff --git a/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java b/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java
index 5346b57..2f8d359 100644
--- a/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java
+++ b/src/main/java/com/casic/PgInterface/maintenance/domain/PgMaintanceRecordHead.java
@@ -66,7 +66,7 @@
this.recordNo = recordNo;
}
- @Column(name="REPAIRMAN")
+ @Column(name="REOAIRMAN")
public String getRepairMan() {
return repairMan;
}
diff --git a/src/main/java/com/casic/PgInterface/maintenance/manager/PgMaintanceRecordHeadManager.java b/src/main/java/com/casic/PgInterface/maintenance/manager/PgMaintanceRecordHeadManager.java
index 0903f22..3484739 100644
--- a/src/main/java/com/casic/PgInterface/maintenance/manager/PgMaintanceRecordHeadManager.java
+++ b/src/main/java/com/casic/PgInterface/maintenance/manager/PgMaintanceRecordHeadManager.java
@@ -15,7 +15,7 @@
public List getPgMaintanceRecordHeadLsit(String repairMan,String startTime,String endTime){
try {
- String sql="select ID,KEY_ID,PLAN_KEY_ID,PLAN_NAME,RECORD_NO,REPAIRMAN,MAINTENANCE_DATE," +
+ String sql="select ID,KEY_ID,PLAN_KEY_ID,PLAN_NAME,RECORD_NO,REOAIRMAN,MAINTENANCE_DATE," +
"BUILD_CABIN,PROJECT,CREATEDATE,CREATOR from PG_MAINTANCERECORD_HEAD where 1=1";
if(repairMan!=null)
sql+=" and REPAIRMAN like '%"+repairMan+"%'";
diff --git a/src/main/java/com/casic/PgInterface/patroler/dto/PgAlarmRuleDto.java b/src/main/java/com/casic/PgInterface/patroler/dto/PgAlarmRuleDto.java
index 9cc2881..6d90d7b 100644
--- a/src/main/java/com/casic/PgInterface/patroler/dto/PgAlarmRuleDto.java
+++ b/src/main/java/com/casic/PgInterface/patroler/dto/PgAlarmRuleDto.java
@@ -1,5 +1,7 @@
package com.casic.PgInterface.patroler.dto;
+import com.casic.PgInterface.devTable.domain.PgDevice;
+import com.casic.PgInterface.devTable.manager.PgDeviceManager;
import com.casic.PgInterface.patroler.domain.PgAlarmRule;
/**
@@ -14,6 +16,7 @@
private String unit;//单位
private String alarmType;//报警类型
private Long pgDeviceId;//设备编号
+ private String assetCode;//资产编号
public Long getId() {
return id;
@@ -71,7 +74,15 @@
this.pgDeviceId = pgDeviceId;
}
- public PgAlarmRuleDto(PgAlarmRule pgAlarmRule) {
+ public String getAssetCode() {
+ return assetCode;
+ }
+
+ public void setAssetCode(String assetCode) {
+ this.assetCode = assetCode;
+ }
+
+ public PgAlarmRuleDto(PgAlarmRule pgAlarmRule, PgDeviceManager pgDeviceManager) {
this.setId(pgAlarmRule.getId());
this.setHighValue(pgAlarmRule.getHighValue());
this.setLowValue(pgAlarmRule.getLowValue());
@@ -82,6 +93,10 @@
else
this.setAlarmType(pgAlarmRule.getAlarmTypeId().getAlarmType());
this.setPgDeviceId(pgAlarmRule.getPgDeviceId());
+ if(pgAlarmRule.getAlarmTypeId()!=null&&pgDeviceManager.get(pgAlarmRule.getPgDeviceId())!=null)
+ this.setAssetCode(pgDeviceManager.get(pgAlarmRule.getPgDeviceId()).getAssetCode());
+ else
+ this.setAssetCode("");
}
}
\ No newline at end of file
diff --git a/src/main/java/com/casic/PgInterface/patroler/manager/PgAlarmRuleManager.java b/src/main/java/com/casic/PgInterface/patroler/manager/PgAlarmRuleManager.java
index 1506dd4..a7cef5b 100644
--- a/src/main/java/com/casic/PgInterface/patroler/manager/PgAlarmRuleManager.java
+++ b/src/main/java/com/casic/PgInterface/patroler/manager/PgAlarmRuleManager.java
@@ -2,13 +2,16 @@
import com.casic.PgInterface.core.hibernate.HibernateEntityDao;
import com.casic.PgInterface.core.util.StringUtils;
+import com.casic.PgInterface.devTable.manager.PgDeviceManager;
import com.casic.PgInterface.patroler.domain.PgAlarmRule;
import com.casic.PgInterface.patroler.dto.PgAlarmRuleDto;
import org.hibernate.Criteria;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;
import org.springframework.stereotype.Service;
+import org.springframework.web.bind.annotation.ResponseStatus;
+import javax.annotation.Resource;
import java.util.ArrayList;
import java.util.List;
@@ -18,6 +21,9 @@
@Service
public class PgAlarmRuleManager extends HibernateEntityDao {
+ @Resource
+ private PgDeviceManager pgDeviceManager;
+
//根据设备获取设备报警阈值
public List getAlarmRuleDto(String devType) {
Criteria criteria=createCriteria(PgAlarmRule.class);
@@ -29,7 +35,7 @@
List pgAlarmRuleList=criteria.list();
List pgAlarmRuleDtoList = new ArrayList<>();
for (PgAlarmRule pgAlarmRule : pgAlarmRuleList) {
- pgAlarmRuleDtoList.add(new PgAlarmRuleDto(pgAlarmRule));
+ pgAlarmRuleDtoList.add(new PgAlarmRuleDto(pgAlarmRule,pgDeviceManager));
}
return pgAlarmRuleDtoList;
}
diff --git a/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java b/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java
index d18ebb8..baacd93 100644
--- a/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java
+++ b/src/main/java/com/casic/PgInterface/rs/PgAlarmRs.java
@@ -48,14 +48,16 @@
@POST
@Path("getAlarmInfo")
@Produces(MediaType.APPLICATION_JSON)
- public Map getAlarmList(@FormParam("startDay") String startDay,
- @FormParam("endDay") String endDay) throws Exception {
+ public Map getAlarmList(@FormParam("alarmType") String alarmType,
+ @FormParam("startDay") String startDay,
+ @FormParam("endDay") String endDay,
+ @FormParam("isNew") String isNew) throws Exception {
Map resultMap = new HashMap<>();
String msg = "";
List pgAlarmDtoList = new ArrayList<>();
try {
- pgAlarmDtoList = pgAlarmManager.getAllAlarm(startDay,endDay);
- if (pgAlarmDtoList.size() == 0)
+ pgAlarmDtoList = pgAlarmManager.getAllAlarm(alarmType,startDay,endDay,isNew);
+ if (pgAlarmDtoList==null||pgAlarmDtoList.size() == 0)
msg = "没有报警信息";
else
msg = "报警信息获取成功";
diff --git a/src/main/java/com/casic/PgInterface/rs/PgAlarmRuleRs.java b/src/main/java/com/casic/PgInterface/rs/PgAlarmRuleRs.java
index 5561e0f..73adc78 100644
--- a/src/main/java/com/casic/PgInterface/rs/PgAlarmRuleRs.java
+++ b/src/main/java/com/casic/PgInterface/rs/PgAlarmRuleRs.java
@@ -1,7 +1,5 @@
package com.casic.PgInterface.rs;
-import com.casic.PgInterface.devTable.manager.PgAlarmTypeManager;
-import com.casic.PgInterface.devTable.manager.PgDeviceManager;
import com.casic.PgInterface.patroler.domain.PgAlarmRule;
import com.casic.PgInterface.patroler.dto.PgAlarmRuleDto;
import com.casic.PgInterface.patroler.manager.PgAlarmRuleManager;
@@ -45,7 +43,7 @@
List pgAlarmRuleDtoList = new ArrayList<>();
try {
pgAlarmRuleDtoList = pgAlarmRuleManager.getAlarmRuleDto(devType);
- if (pgAlarmRuleDtoList == null)
+ if (pgAlarmRuleDtoList == null||pgAlarmRuleDtoList.size()==0)
msg = "不存在报警阈值信息";
else
msg = "报警阈值获取成功";
diff --git "a/\346\216\245\345\217\243\350\257\264\346\230\21620190828.docx" "b/\346\216\245\345\217\243\350\257\264\346\230\21620190828.docx"
index 0682d99..264ce46 100644
--- "a/\346\216\245\345\217\243\350\257\264\346\230\21620190828.docx"
+++ "b/\346\216\245\345\217\243\350\257\264\346\230\21620190828.docx"
Binary files differ