diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmNowViewMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmNowViewMapper.xml
index 174f95f..47740b5 100644
--- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmNowViewMapper.xml
+++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmNowViewMapper.xml
@@ -6,7 +6,7 @@
wellId AS wellId, deviceId AS deviceId, devcode as devcode, wellCode AS wellCode, alarmId AS alarmId, deptid AS deptid,wellType AS wellType,
alarmType AS alarmType, alarmValue AS alarmValue, alarmContent AS alarmContent, alarmTimeDate AS alarmTimeDate,
- position AS position, coordinateX AS coordinateX, coordinateY AS coordinateY,
+ position AS position, coordinateX AS coordinateX, coordinateY AS coordinateY,deviceType,
lngBaidu AS lngBaidu, latBaidu AS latBaidu, lngGaode AS lngGaode, latGaode AS latGaode
diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmNowViewMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmNowViewMapper.xml
index 174f95f..47740b5 100644
--- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmNowViewMapper.xml
+++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmNowViewMapper.xml
@@ -6,7 +6,7 @@
wellId AS wellId, deviceId AS deviceId, devcode as devcode, wellCode AS wellCode, alarmId AS alarmId, deptid AS deptid,wellType AS wellType,
alarmType AS alarmType, alarmValue AS alarmValue, alarmContent AS alarmContent, alarmTimeDate AS alarmTimeDate,
- position AS position, coordinateX AS coordinateX, coordinateY AS coordinateY,
+ position AS position, coordinateX AS coordinateX, coordinateY AS coordinateY,deviceType,
lngBaidu AS lngBaidu, latBaidu AS latBaidu, lngGaode AS lngGaode, latGaode AS latGaode
diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml
index 3d94d41..7b9b5e7 100644
--- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml
+++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml
@@ -92,7 +92,8 @@
LEFT JOIN bus_well_info bwi ON ar.WELL_CODE = bwi.WELL_CODE
WHERE STATUS = 1
- and ar.WELL_CODE like concat('%',CONCAT(#{keywords},'%'))
+ and (ar.WELL_CODE like concat('%',CONCAT(#{keywords},'%'))
+ OR ar.DEVCODE like concat('%',CONCAT(#{keywords},'%')))
AND ar.ALARM_TYPE = #{alarmType}
diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmNowViewMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmNowViewMapper.xml
index 174f95f..47740b5 100644
--- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmNowViewMapper.xml
+++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmNowViewMapper.xml
@@ -6,7 +6,7 @@
wellId AS wellId, deviceId AS deviceId, devcode as devcode, wellCode AS wellCode, alarmId AS alarmId, deptid AS deptid,wellType AS wellType,
alarmType AS alarmType, alarmValue AS alarmValue, alarmContent AS alarmContent, alarmTimeDate AS alarmTimeDate,
- position AS position, coordinateX AS coordinateX, coordinateY AS coordinateY,
+ position AS position, coordinateX AS coordinateX, coordinateY AS coordinateY,deviceType,
lngBaidu AS lngBaidu, latBaidu AS latBaidu, lngGaode AS lngGaode, latGaode AS latGaode
diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml
index 3d94d41..7b9b5e7 100644
--- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml
+++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml
@@ -92,7 +92,8 @@
LEFT JOIN bus_well_info bwi ON ar.WELL_CODE = bwi.WELL_CODE
WHERE STATUS = 1
- and ar.WELL_CODE like concat('%',CONCAT(#{keywords},'%'))
+ and (ar.WELL_CODE like concat('%',CONCAT(#{keywords},'%'))
+ OR ar.DEVCODE like concat('%',CONCAT(#{keywords},'%')))
AND ar.ALARM_TYPE = #{alarmType}
diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dto/AlarmNowView.java b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dto/AlarmNowView.java
index b49b8c0..0bd2016 100644
--- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dto/AlarmNowView.java
+++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dto/AlarmNowView.java
@@ -7,7 +7,7 @@
/**
*
- *
+ *
*
*
* @author casic123
@@ -37,6 +37,8 @@
*/
private String devcode;
+ private String deviceType;
+
/**
* 闸井编号
*/
@@ -104,6 +106,14 @@
private String wellTypeName;
+ public String getDeviceType() {
+ return deviceType;
+ }
+
+ public void setDeviceType(String deviceType) {
+ this.deviceType = deviceType;
+ }
+
public Long getAlarmId() {
return alarmId;
}
@@ -268,13 +278,13 @@
@Override
public String toString() {
return "AlarmNowView{" +
- "id=" + alarmId +
- ", deviceId=" + deviceId +
- ", wellId=" + wellId +
- ", wellCode=" + wellCode +
- ", alarmType=" + alarmType +
- ", alarmContent=" + alarmContent +
- ", alarmTime=" + getAlarmTime() +
- "}";
+ "id=" + alarmId +
+ ", deviceId=" + deviceId +
+ ", wellId=" + wellId +
+ ", wellCode=" + wellCode +
+ ", alarmType=" + alarmType +
+ ", alarmContent=" + alarmContent +
+ ", alarmTime=" + getAlarmTime() +
+ "}";
}
}
diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmNowViewMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmNowViewMapper.xml
index 174f95f..47740b5 100644
--- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmNowViewMapper.xml
+++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmNowViewMapper.xml
@@ -6,7 +6,7 @@
wellId AS wellId, deviceId AS deviceId, devcode as devcode, wellCode AS wellCode, alarmId AS alarmId, deptid AS deptid,wellType AS wellType,
alarmType AS alarmType, alarmValue AS alarmValue, alarmContent AS alarmContent, alarmTimeDate AS alarmTimeDate,
- position AS position, coordinateX AS coordinateX, coordinateY AS coordinateY,
+ position AS position, coordinateX AS coordinateX, coordinateY AS coordinateY,deviceType,
lngBaidu AS lngBaidu, latBaidu AS latBaidu, lngGaode AS lngGaode, latGaode AS latGaode
diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml
index 3d94d41..7b9b5e7 100644
--- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml
+++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml
@@ -92,7 +92,8 @@
LEFT JOIN bus_well_info bwi ON ar.WELL_CODE = bwi.WELL_CODE
WHERE STATUS = 1
- and ar.WELL_CODE like concat('%',CONCAT(#{keywords},'%'))
+ and (ar.WELL_CODE like concat('%',CONCAT(#{keywords},'%'))
+ OR ar.DEVCODE like concat('%',CONCAT(#{keywords},'%')))
AND ar.ALARM_TYPE = #{alarmType}
diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dto/AlarmNowView.java b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dto/AlarmNowView.java
index b49b8c0..0bd2016 100644
--- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dto/AlarmNowView.java
+++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dto/AlarmNowView.java
@@ -7,7 +7,7 @@
/**
*