diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml
index 3a6d54a..df31d87 100644
--- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml
+++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml
@@ -44,6 +44,7 @@
WHERE BD.VALID = '1' AND BDW.VALID='1' AND BWI.DEPTID IN (${deptIds})
GROUP BY BD.DEVICE_TYPE
) A ON bdt.ID = A.deviceType
+ WHERE A.devicecount>0
@@ -263,12 +264,13 @@
- GROUP BY ar.WELL_CODE,bwi.WELL_NAME,bwi.deptid,POSITION,COORDINATE_X,COORDINATE_Y,LAT_BAIDU,LNG_BAIDU,LNG_GAODE,LNG_GAODE
+ GROUP BY
+ ar.WELL_CODE,bwi.WELL_NAME,bwi.deptid,POSITION,COORDINATE_X,COORDINATE_Y,LAT_BAIDU,LNG_BAIDU,LNG_GAODE,LNG_GAODE
ORDER BY "alarmCount" DESC
- SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "alarmCount",DEPTID AS deptid
+ SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "alarmCount",DEPTID AS deptid
FROM alarm_records ar
LEFT JOIN bus_well_info bwi ON bwi.WELL_CODE=ar.WELL_CODE
WHERE 1=1
@@ -292,8 +294,8 @@
- SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "totalAlarm",DEPTID AS deptid,
- SUM(CASE WHEN ar.STATUS='1' THEN 1 ELSE 0 END) AS alarmings
+ SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "totalAlarm",DEPTID AS deptid,
+ SUM(CASE WHEN ar.STATUS='1' THEN 1 ELSE 0 END) AS alarmings
FROM alarm_records ar
LEFT JOIN bus_well_info bwi ON bwi.WELL_CODE=ar.WELL_CODE
WHERE 1=1
diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml
index 3a6d54a..df31d87 100644
--- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml
+++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml
@@ -44,6 +44,7 @@
WHERE BD.VALID = '1' AND BDW.VALID='1' AND BWI.DEPTID IN (${deptIds})
GROUP BY BD.DEVICE_TYPE
) A ON bdt.ID = A.deviceType
+ WHERE A.devicecount>0
@@ -263,12 +264,13 @@
- GROUP BY ar.WELL_CODE,bwi.WELL_NAME,bwi.deptid,POSITION,COORDINATE_X,COORDINATE_Y,LAT_BAIDU,LNG_BAIDU,LNG_GAODE,LNG_GAODE
+ GROUP BY
+ ar.WELL_CODE,bwi.WELL_NAME,bwi.deptid,POSITION,COORDINATE_X,COORDINATE_Y,LAT_BAIDU,LNG_BAIDU,LNG_GAODE,LNG_GAODE
ORDER BY "alarmCount" DESC
- SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "alarmCount",DEPTID AS deptid
+ SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "alarmCount",DEPTID AS deptid
FROM alarm_records ar
LEFT JOIN bus_well_info bwi ON bwi.WELL_CODE=ar.WELL_CODE
WHERE 1=1
@@ -292,8 +294,8 @@
- SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "totalAlarm",DEPTID AS deptid,
- SUM(CASE WHEN ar.STATUS='1' THEN 1 ELSE 0 END) AS alarmings
+ SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "totalAlarm",DEPTID AS deptid,
+ SUM(CASE WHEN ar.STATUS='1' THEN 1 ELSE 0 END) AS alarmings
FROM alarm_records ar
LEFT JOIN bus_well_info bwi ON bwi.WELL_CODE=ar.WELL_CODE
WHERE 1=1
diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/service/impl/StatisticServiceImpl.java b/casic-alarm/src/main/java/com/casic/missiles/modular/system/service/impl/StatisticServiceImpl.java
index d336acb..0c7d723 100644
--- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/service/impl/StatisticServiceImpl.java
+++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/service/impl/StatisticServiceImpl.java
@@ -11,6 +11,7 @@
import com.casic.missiles.modular.system.service.IStatisticsService;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;
+import org.apache.ibatis.annotations.Param;
import org.springframework.dao.DataAccessException;
import org.springframework.stereotype.Service;
@@ -54,6 +55,7 @@
public List> deviceStaticsByType(DataScope dataScope) {
String deptIds = StringUtils.strip(dataScope.getDeptIds().toString(), "[]");
List> mapList = statisticMapper.deviceStaticsByType(deptIds);
+
// for (Map map : mapList) {
// map.replace("deviceType",sysDictMapper.getDeviceTypeNameById(map.get("deviceType").toString()));
// }
diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml
index 3a6d54a..df31d87 100644
--- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml
+++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml
@@ -44,6 +44,7 @@
WHERE BD.VALID = '1' AND BDW.VALID='1' AND BWI.DEPTID IN (${deptIds})
GROUP BY BD.DEVICE_TYPE
) A ON bdt.ID = A.deviceType
+ WHERE A.devicecount>0
@@ -263,12 +264,13 @@
- GROUP BY ar.WELL_CODE,bwi.WELL_NAME,bwi.deptid,POSITION,COORDINATE_X,COORDINATE_Y,LAT_BAIDU,LNG_BAIDU,LNG_GAODE,LNG_GAODE
+ GROUP BY
+ ar.WELL_CODE,bwi.WELL_NAME,bwi.deptid,POSITION,COORDINATE_X,COORDINATE_Y,LAT_BAIDU,LNG_BAIDU,LNG_GAODE,LNG_GAODE
ORDER BY "alarmCount" DESC
- SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "alarmCount",DEPTID AS deptid
+ SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "alarmCount",DEPTID AS deptid
FROM alarm_records ar
LEFT JOIN bus_well_info bwi ON bwi.WELL_CODE=ar.WELL_CODE
WHERE 1=1
@@ -292,8 +294,8 @@
- SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "totalAlarm",DEPTID AS deptid,
- SUM(CASE WHEN ar.STATUS='1' THEN 1 ELSE 0 END) AS alarmings
+ SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "totalAlarm",DEPTID AS deptid,
+ SUM(CASE WHEN ar.STATUS='1' THEN 1 ELSE 0 END) AS alarmings
FROM alarm_records ar
LEFT JOIN bus_well_info bwi ON bwi.WELL_CODE=ar.WELL_CODE
WHERE 1=1
diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/service/impl/StatisticServiceImpl.java b/casic-alarm/src/main/java/com/casic/missiles/modular/system/service/impl/StatisticServiceImpl.java
index d336acb..0c7d723 100644
--- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/service/impl/StatisticServiceImpl.java
+++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/service/impl/StatisticServiceImpl.java
@@ -11,6 +11,7 @@
import com.casic.missiles.modular.system.service.IStatisticsService;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;
+import org.apache.ibatis.annotations.Param;
import org.springframework.dao.DataAccessException;
import org.springframework.stereotype.Service;
@@ -54,6 +55,7 @@
public List> deviceStaticsByType(DataScope dataScope) {
String deptIds = StringUtils.strip(dataScope.getDeptIds().toString(), "[]");
List> mapList = statisticMapper.deviceStaticsByType(deptIds);
+
// for (Map map : mapList) {
// map.replace("deviceType",sysDictMapper.getDeviceTypeNameById(map.get("deviceType").toString()));
// }
diff --git a/casic-device/src/main/java/com/casic/missiles/modular/system/controller/DeviceController.java b/casic-device/src/main/java/com/casic/missiles/modular/system/controller/DeviceController.java
index 6b5a8fd..e45613c 100644
--- a/casic-device/src/main/java/com/casic/missiles/modular/system/controller/DeviceController.java
+++ b/casic-device/src/main/java/com/casic/missiles/modular/system/controller/DeviceController.java
@@ -77,6 +77,19 @@
@RequestMapping(value = "/list")
@ResponseBody
public Object list(String keywords, String deviceType, String deptid, String beginTime, String endTime, String isOnline) {
+ //查询数据权限 使用默认DEPTID 字段
+ DataScope dataScope = permissionService.getAuthService().getLoginUserDataScope();
+ List deviceList = deviceService.getDeviceList(dataScope, deviceType, deptid, beginTime, endTime, keywords, isOnline);
+ deviceList.forEach(deviceDto -> {
+ deviceDto.setBfztName(dictService.getDictNameByCode(ModularDictConst.BFZT, deviceDto.getBfzt()));
+ deviceDto.setOnlineStateName(dictService.getDictNameByCode(ModularDictConst.ONLINESTATUS, deviceDto.getOnlineState()));
+ });
+ return new SuccessResponseData(deviceList);
+ }
+
+ @RequestMapping(value = "/list-page")
+ @ResponseBody
+ public Object listPage(String keywords, String deviceType, String deptid, String beginTime, String endTime, String isOnline) {
Page page = PageFactory.defaultPage();
//查询数据权限 使用默认DEPTID 字段
DataScope dataScope = permissionService.getAuthService().getLoginUserDataScope();
diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml
index 3a6d54a..df31d87 100644
--- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml
+++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml
@@ -44,6 +44,7 @@
WHERE BD.VALID = '1' AND BDW.VALID='1' AND BWI.DEPTID IN (${deptIds})
GROUP BY BD.DEVICE_TYPE
) A ON bdt.ID = A.deviceType
+ WHERE A.devicecount>0
@@ -263,12 +264,13 @@
- GROUP BY ar.WELL_CODE,bwi.WELL_NAME,bwi.deptid,POSITION,COORDINATE_X,COORDINATE_Y,LAT_BAIDU,LNG_BAIDU,LNG_GAODE,LNG_GAODE
+ GROUP BY
+ ar.WELL_CODE,bwi.WELL_NAME,bwi.deptid,POSITION,COORDINATE_X,COORDINATE_Y,LAT_BAIDU,LNG_BAIDU,LNG_GAODE,LNG_GAODE
ORDER BY "alarmCount" DESC
- SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "alarmCount",DEPTID AS deptid
+ SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "alarmCount",DEPTID AS deptid
FROM alarm_records ar
LEFT JOIN bus_well_info bwi ON bwi.WELL_CODE=ar.WELL_CODE
WHERE 1=1
@@ -292,8 +294,8 @@
- SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "totalAlarm",DEPTID AS deptid,
- SUM(CASE WHEN ar.STATUS='1' THEN 1 ELSE 0 END) AS alarmings
+ SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "totalAlarm",DEPTID AS deptid,
+ SUM(CASE WHEN ar.STATUS='1' THEN 1 ELSE 0 END) AS alarmings
FROM alarm_records ar
LEFT JOIN bus_well_info bwi ON bwi.WELL_CODE=ar.WELL_CODE
WHERE 1=1
diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/service/impl/StatisticServiceImpl.java b/casic-alarm/src/main/java/com/casic/missiles/modular/system/service/impl/StatisticServiceImpl.java
index d336acb..0c7d723 100644
--- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/service/impl/StatisticServiceImpl.java
+++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/service/impl/StatisticServiceImpl.java
@@ -11,6 +11,7 @@
import com.casic.missiles.modular.system.service.IStatisticsService;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;
+import org.apache.ibatis.annotations.Param;
import org.springframework.dao.DataAccessException;
import org.springframework.stereotype.Service;
@@ -54,6 +55,7 @@
public List> deviceStaticsByType(DataScope dataScope) {
String deptIds = StringUtils.strip(dataScope.getDeptIds().toString(), "[]");
List> mapList = statisticMapper.deviceStaticsByType(deptIds);
+
// for (Map map : mapList) {
// map.replace("deviceType",sysDictMapper.getDeviceTypeNameById(map.get("deviceType").toString()));
// }
diff --git a/casic-device/src/main/java/com/casic/missiles/modular/system/controller/DeviceController.java b/casic-device/src/main/java/com/casic/missiles/modular/system/controller/DeviceController.java
index 6b5a8fd..e45613c 100644
--- a/casic-device/src/main/java/com/casic/missiles/modular/system/controller/DeviceController.java
+++ b/casic-device/src/main/java/com/casic/missiles/modular/system/controller/DeviceController.java
@@ -77,6 +77,19 @@
@RequestMapping(value = "/list")
@ResponseBody
public Object list(String keywords, String deviceType, String deptid, String beginTime, String endTime, String isOnline) {
+ //查询数据权限 使用默认DEPTID 字段
+ DataScope dataScope = permissionService.getAuthService().getLoginUserDataScope();
+ List deviceList = deviceService.getDeviceList(dataScope, deviceType, deptid, beginTime, endTime, keywords, isOnline);
+ deviceList.forEach(deviceDto -> {
+ deviceDto.setBfztName(dictService.getDictNameByCode(ModularDictConst.BFZT, deviceDto.getBfzt()));
+ deviceDto.setOnlineStateName(dictService.getDictNameByCode(ModularDictConst.ONLINESTATUS, deviceDto.getOnlineState()));
+ });
+ return new SuccessResponseData(deviceList);
+ }
+
+ @RequestMapping(value = "/list-page")
+ @ResponseBody
+ public Object listPage(String keywords, String deviceType, String deptid, String beginTime, String endTime, String isOnline) {
Page page = PageFactory.defaultPage();
//查询数据权限 使用默认DEPTID 字段
DataScope dataScope = permissionService.getAuthService().getLoginUserDataScope();
diff --git a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/DeviceMapper.java b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/DeviceMapper.java
index 244e9ff..e2104a4 100644
--- a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/DeviceMapper.java
+++ b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/DeviceMapper.java
@@ -20,6 +20,8 @@
*/
public interface DeviceMapper extends BaseMapper {
+ List getDeviceList(@Param("scope") DataScope dataScope,@Param("deviceType") String deviceType, @Param("deptid") String deptid, @Param("beginTime") String beginTime, @Param("endTime") String endTime, @Param("keywords") String keywords, @Param("isOnline") String isOnline);
+
List selectDataScopePage(@Param("scope") DataScope dataScope, @Param("page") Page page, @Param("deviceType") String deviceType, @Param("deptid") String deptid, @Param("beginTime") String beginTime, @Param("endTime") String endTime, @Param("keywords") String keywords, @Param("isOnline") String isOnline);
List getDeviceList(@Param("scope") DataScope dataScope);
diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml
index 3a6d54a..df31d87 100644
--- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml
+++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml
@@ -44,6 +44,7 @@
WHERE BD.VALID = '1' AND BDW.VALID='1' AND BWI.DEPTID IN (${deptIds})
GROUP BY BD.DEVICE_TYPE
) A ON bdt.ID = A.deviceType
+ WHERE A.devicecount>0
@@ -263,12 +264,13 @@
- GROUP BY ar.WELL_CODE,bwi.WELL_NAME,bwi.deptid,POSITION,COORDINATE_X,COORDINATE_Y,LAT_BAIDU,LNG_BAIDU,LNG_GAODE,LNG_GAODE
+ GROUP BY
+ ar.WELL_CODE,bwi.WELL_NAME,bwi.deptid,POSITION,COORDINATE_X,COORDINATE_Y,LAT_BAIDU,LNG_BAIDU,LNG_GAODE,LNG_GAODE
ORDER BY "alarmCount" DESC
- SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "alarmCount",DEPTID AS deptid
+ SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "alarmCount",DEPTID AS deptid
FROM alarm_records ar
LEFT JOIN bus_well_info bwi ON bwi.WELL_CODE=ar.WELL_CODE
WHERE 1=1
@@ -292,8 +294,8 @@
- SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "totalAlarm",DEPTID AS deptid,
- SUM(CASE WHEN ar.STATUS='1' THEN 1 ELSE 0 END) AS alarmings
+ SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "totalAlarm",DEPTID AS deptid,
+ SUM(CASE WHEN ar.STATUS='1' THEN 1 ELSE 0 END) AS alarmings
FROM alarm_records ar
LEFT JOIN bus_well_info bwi ON bwi.WELL_CODE=ar.WELL_CODE
WHERE 1=1
diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/service/impl/StatisticServiceImpl.java b/casic-alarm/src/main/java/com/casic/missiles/modular/system/service/impl/StatisticServiceImpl.java
index d336acb..0c7d723 100644
--- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/service/impl/StatisticServiceImpl.java
+++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/service/impl/StatisticServiceImpl.java
@@ -11,6 +11,7 @@
import com.casic.missiles.modular.system.service.IStatisticsService;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;
+import org.apache.ibatis.annotations.Param;
import org.springframework.dao.DataAccessException;
import org.springframework.stereotype.Service;
@@ -54,6 +55,7 @@
public List> deviceStaticsByType(DataScope dataScope) {
String deptIds = StringUtils.strip(dataScope.getDeptIds().toString(), "[]");
List> mapList = statisticMapper.deviceStaticsByType(deptIds);
+
// for (Map map : mapList) {
// map.replace("deviceType",sysDictMapper.getDeviceTypeNameById(map.get("deviceType").toString()));
// }
diff --git a/casic-device/src/main/java/com/casic/missiles/modular/system/controller/DeviceController.java b/casic-device/src/main/java/com/casic/missiles/modular/system/controller/DeviceController.java
index 6b5a8fd..e45613c 100644
--- a/casic-device/src/main/java/com/casic/missiles/modular/system/controller/DeviceController.java
+++ b/casic-device/src/main/java/com/casic/missiles/modular/system/controller/DeviceController.java
@@ -77,6 +77,19 @@
@RequestMapping(value = "/list")
@ResponseBody
public Object list(String keywords, String deviceType, String deptid, String beginTime, String endTime, String isOnline) {
+ //查询数据权限 使用默认DEPTID 字段
+ DataScope dataScope = permissionService.getAuthService().getLoginUserDataScope();
+ List deviceList = deviceService.getDeviceList(dataScope, deviceType, deptid, beginTime, endTime, keywords, isOnline);
+ deviceList.forEach(deviceDto -> {
+ deviceDto.setBfztName(dictService.getDictNameByCode(ModularDictConst.BFZT, deviceDto.getBfzt()));
+ deviceDto.setOnlineStateName(dictService.getDictNameByCode(ModularDictConst.ONLINESTATUS, deviceDto.getOnlineState()));
+ });
+ return new SuccessResponseData(deviceList);
+ }
+
+ @RequestMapping(value = "/list-page")
+ @ResponseBody
+ public Object listPage(String keywords, String deviceType, String deptid, String beginTime, String endTime, String isOnline) {
Page page = PageFactory.defaultPage();
//查询数据权限 使用默认DEPTID 字段
DataScope dataScope = permissionService.getAuthService().getLoginUserDataScope();
diff --git a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/DeviceMapper.java b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/DeviceMapper.java
index 244e9ff..e2104a4 100644
--- a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/DeviceMapper.java
+++ b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/DeviceMapper.java
@@ -20,6 +20,8 @@
*/
public interface DeviceMapper extends BaseMapper {
+ List getDeviceList(@Param("scope") DataScope dataScope,@Param("deviceType") String deviceType, @Param("deptid") String deptid, @Param("beginTime") String beginTime, @Param("endTime") String endTime, @Param("keywords") String keywords, @Param("isOnline") String isOnline);
+
List selectDataScopePage(@Param("scope") DataScope dataScope, @Param("page") Page page, @Param("deviceType") String deviceType, @Param("deptid") String deptid, @Param("beginTime") String beginTime, @Param("endTime") String endTime, @Param("keywords") String keywords, @Param("isOnline") String isOnline);
List getDeviceList(@Param("scope") DataScope dataScope);
diff --git a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceMapper.xml b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceMapper.xml
index 8de6875..0974260 100644
--- a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceMapper.xml
+++ b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceMapper.xml
@@ -109,6 +109,43 @@
ORDER by a.DEVCODE
+
+ SELECT
+
+ FROM device_view
+ WHERE VALID = '1'
+
+ and deviceType = #{deviceType}
+
+
+ and deptid = #{deptid}
+
+
+ and onlineState = #{isOnline}
+
+
+ and installDate >
+
+
+
+
+
+ and installDate <
+
+
+
+
+
+ and (DEVCODE like
+
+ OR wellCode LIKE
+
+ )
+
+ ORDER BY INSTALLDATE DESC
+
+
SELECT
diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml
index 3a6d54a..df31d87 100644
--- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml
+++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml
@@ -44,6 +44,7 @@
WHERE BD.VALID = '1' AND BDW.VALID='1' AND BWI.DEPTID IN (${deptIds})
GROUP BY BD.DEVICE_TYPE
) A ON bdt.ID = A.deviceType
+ WHERE A.devicecount>0
@@ -263,12 +264,13 @@
- GROUP BY ar.WELL_CODE,bwi.WELL_NAME,bwi.deptid,POSITION,COORDINATE_X,COORDINATE_Y,LAT_BAIDU,LNG_BAIDU,LNG_GAODE,LNG_GAODE
+ GROUP BY
+ ar.WELL_CODE,bwi.WELL_NAME,bwi.deptid,POSITION,COORDINATE_X,COORDINATE_Y,LAT_BAIDU,LNG_BAIDU,LNG_GAODE,LNG_GAODE
ORDER BY "alarmCount" DESC
- SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "alarmCount",DEPTID AS deptid
+ SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "alarmCount",DEPTID AS deptid
FROM alarm_records ar
LEFT JOIN bus_well_info bwi ON bwi.WELL_CODE=ar.WELL_CODE
WHERE 1=1
@@ -292,8 +294,8 @@
- SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "totalAlarm",DEPTID AS deptid,
- SUM(CASE WHEN ar.STATUS='1' THEN 1 ELSE 0 END) AS alarmings
+ SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "totalAlarm",DEPTID AS deptid,
+ SUM(CASE WHEN ar.STATUS='1' THEN 1 ELSE 0 END) AS alarmings
FROM alarm_records ar
LEFT JOIN bus_well_info bwi ON bwi.WELL_CODE=ar.WELL_CODE
WHERE 1=1
diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/service/impl/StatisticServiceImpl.java b/casic-alarm/src/main/java/com/casic/missiles/modular/system/service/impl/StatisticServiceImpl.java
index d336acb..0c7d723 100644
--- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/service/impl/StatisticServiceImpl.java
+++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/service/impl/StatisticServiceImpl.java
@@ -11,6 +11,7 @@
import com.casic.missiles.modular.system.service.IStatisticsService;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;
+import org.apache.ibatis.annotations.Param;
import org.springframework.dao.DataAccessException;
import org.springframework.stereotype.Service;
@@ -54,6 +55,7 @@
public List> deviceStaticsByType(DataScope dataScope) {
String deptIds = StringUtils.strip(dataScope.getDeptIds().toString(), "[]");
List> mapList = statisticMapper.deviceStaticsByType(deptIds);
+
// for (Map map : mapList) {
// map.replace("deviceType",sysDictMapper.getDeviceTypeNameById(map.get("deviceType").toString()));
// }
diff --git a/casic-device/src/main/java/com/casic/missiles/modular/system/controller/DeviceController.java b/casic-device/src/main/java/com/casic/missiles/modular/system/controller/DeviceController.java
index 6b5a8fd..e45613c 100644
--- a/casic-device/src/main/java/com/casic/missiles/modular/system/controller/DeviceController.java
+++ b/casic-device/src/main/java/com/casic/missiles/modular/system/controller/DeviceController.java
@@ -77,6 +77,19 @@
@RequestMapping(value = "/list")
@ResponseBody
public Object list(String keywords, String deviceType, String deptid, String beginTime, String endTime, String isOnline) {
+ //查询数据权限 使用默认DEPTID 字段
+ DataScope dataScope = permissionService.getAuthService().getLoginUserDataScope();
+ List deviceList = deviceService.getDeviceList(dataScope, deviceType, deptid, beginTime, endTime, keywords, isOnline);
+ deviceList.forEach(deviceDto -> {
+ deviceDto.setBfztName(dictService.getDictNameByCode(ModularDictConst.BFZT, deviceDto.getBfzt()));
+ deviceDto.setOnlineStateName(dictService.getDictNameByCode(ModularDictConst.ONLINESTATUS, deviceDto.getOnlineState()));
+ });
+ return new SuccessResponseData(deviceList);
+ }
+
+ @RequestMapping(value = "/list-page")
+ @ResponseBody
+ public Object listPage(String keywords, String deviceType, String deptid, String beginTime, String endTime, String isOnline) {
Page page = PageFactory.defaultPage();
//查询数据权限 使用默认DEPTID 字段
DataScope dataScope = permissionService.getAuthService().getLoginUserDataScope();
diff --git a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/DeviceMapper.java b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/DeviceMapper.java
index 244e9ff..e2104a4 100644
--- a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/DeviceMapper.java
+++ b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/DeviceMapper.java
@@ -20,6 +20,8 @@
*/
public interface DeviceMapper extends BaseMapper {
+ List getDeviceList(@Param("scope") DataScope dataScope,@Param("deviceType") String deviceType, @Param("deptid") String deptid, @Param("beginTime") String beginTime, @Param("endTime") String endTime, @Param("keywords") String keywords, @Param("isOnline") String isOnline);
+
List selectDataScopePage(@Param("scope") DataScope dataScope, @Param("page") Page page, @Param("deviceType") String deviceType, @Param("deptid") String deptid, @Param("beginTime") String beginTime, @Param("endTime") String endTime, @Param("keywords") String keywords, @Param("isOnline") String isOnline);
List getDeviceList(@Param("scope") DataScope dataScope);
diff --git a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceMapper.xml b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceMapper.xml
index 8de6875..0974260 100644
--- a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceMapper.xml
+++ b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceMapper.xml
@@ -109,6 +109,43 @@
ORDER by a.DEVCODE
+
+ SELECT
+
+ FROM device_view
+ WHERE VALID = '1'
+
+ and deviceType = #{deviceType}
+
+
+ and deptid = #{deptid}
+
+
+ and onlineState = #{isOnline}
+
+
+ and installDate >
+
+
+
+
+
+ and installDate <
+
+
+
+
+
+ and (DEVCODE like
+
+ OR wellCode LIKE
+
+ )
+
+ ORDER BY INSTALLDATE DESC
+
+
SELECT
diff --git a/casic-device/src/main/java/com/casic/missiles/modular/system/service/IDeviceService.java b/casic-device/src/main/java/com/casic/missiles/modular/system/service/IDeviceService.java
index 1bef4a7..7f6232e 100644
--- a/casic-device/src/main/java/com/casic/missiles/modular/system/service/IDeviceService.java
+++ b/casic-device/src/main/java/com/casic/missiles/modular/system/service/IDeviceService.java
@@ -21,18 +21,33 @@
*/
public interface IDeviceService extends IService {
+
+ /**
+ * 不分页
+ *
+ * @param dataScope
+ * @param deviceType
+ * @param deptid
+ * @param beginTime
+ * @param endTime
+ * @param keywords
+ * @param isOnline
+ * @return
+ */
+ List getDeviceList(DataScope dataScope, String deviceType, String deptid, String beginTime, String endTime, String keywords, String isOnline);
+
/**
* 根据条件分页查询设备列表
*
* @param dataScope 数据权限集合
- * @param page 分页参数
* @param deviceType 设备类型
* @param deptid 组织ID
* @param beginTime 设备安装开始时间
* @param endTime 设备安装结束时间
* @return 设备列表
*/
- List selectDataScopePage(DataScope dataScope, Page page, String deviceType, String deptid, String beginTime, String endTime, String keywords, String isOnline);
+ List selectDataScopePage(DataScope dataScope, Page page, String deviceType, String deptid,
+ String beginTime, String endTime, String keywords, String isOnline);
/**
* 根据闸井编号查询闸井ID
diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml
index 3a6d54a..df31d87 100644
--- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml
+++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml
@@ -44,6 +44,7 @@
WHERE BD.VALID = '1' AND BDW.VALID='1' AND BWI.DEPTID IN (${deptIds})
GROUP BY BD.DEVICE_TYPE
) A ON bdt.ID = A.deviceType
+ WHERE A.devicecount>0
@@ -263,12 +264,13 @@
- GROUP BY ar.WELL_CODE,bwi.WELL_NAME,bwi.deptid,POSITION,COORDINATE_X,COORDINATE_Y,LAT_BAIDU,LNG_BAIDU,LNG_GAODE,LNG_GAODE
+ GROUP BY
+ ar.WELL_CODE,bwi.WELL_NAME,bwi.deptid,POSITION,COORDINATE_X,COORDINATE_Y,LAT_BAIDU,LNG_BAIDU,LNG_GAODE,LNG_GAODE
ORDER BY "alarmCount" DESC
- SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "alarmCount",DEPTID AS deptid
+ SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "alarmCount",DEPTID AS deptid
FROM alarm_records ar
LEFT JOIN bus_well_info bwi ON bwi.WELL_CODE=ar.WELL_CODE
WHERE 1=1
@@ -292,8 +294,8 @@
- SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "totalAlarm",DEPTID AS deptid,
- SUM(CASE WHEN ar.STATUS='1' THEN 1 ELSE 0 END) AS alarmings
+ SELECT ALARM_CONTENT AS "alarmContent",COUNT(*) AS "totalAlarm",DEPTID AS deptid,
+ SUM(CASE WHEN ar.STATUS='1' THEN 1 ELSE 0 END) AS alarmings
FROM alarm_records ar
LEFT JOIN bus_well_info bwi ON bwi.WELL_CODE=ar.WELL_CODE
WHERE 1=1
diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/service/impl/StatisticServiceImpl.java b/casic-alarm/src/main/java/com/casic/missiles/modular/system/service/impl/StatisticServiceImpl.java
index d336acb..0c7d723 100644
--- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/service/impl/StatisticServiceImpl.java
+++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/service/impl/StatisticServiceImpl.java
@@ -11,6 +11,7 @@
import com.casic.missiles.modular.system.service.IStatisticsService;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;
+import org.apache.ibatis.annotations.Param;
import org.springframework.dao.DataAccessException;
import org.springframework.stereotype.Service;
@@ -54,6 +55,7 @@
public List> deviceStaticsByType(DataScope dataScope) {
String deptIds = StringUtils.strip(dataScope.getDeptIds().toString(), "[]");
List> mapList = statisticMapper.deviceStaticsByType(deptIds);
+
// for (Map map : mapList) {
// map.replace("deviceType",sysDictMapper.getDeviceTypeNameById(map.get("deviceType").toString()));
// }
diff --git a/casic-device/src/main/java/com/casic/missiles/modular/system/controller/DeviceController.java b/casic-device/src/main/java/com/casic/missiles/modular/system/controller/DeviceController.java
index 6b5a8fd..e45613c 100644
--- a/casic-device/src/main/java/com/casic/missiles/modular/system/controller/DeviceController.java
+++ b/casic-device/src/main/java/com/casic/missiles/modular/system/controller/DeviceController.java
@@ -77,6 +77,19 @@
@RequestMapping(value = "/list")
@ResponseBody
public Object list(String keywords, String deviceType, String deptid, String beginTime, String endTime, String isOnline) {
+ //查询数据权限 使用默认DEPTID 字段
+ DataScope dataScope = permissionService.getAuthService().getLoginUserDataScope();
+ List deviceList = deviceService.getDeviceList(dataScope, deviceType, deptid, beginTime, endTime, keywords, isOnline);
+ deviceList.forEach(deviceDto -> {
+ deviceDto.setBfztName(dictService.getDictNameByCode(ModularDictConst.BFZT, deviceDto.getBfzt()));
+ deviceDto.setOnlineStateName(dictService.getDictNameByCode(ModularDictConst.ONLINESTATUS, deviceDto.getOnlineState()));
+ });
+ return new SuccessResponseData(deviceList);
+ }
+
+ @RequestMapping(value = "/list-page")
+ @ResponseBody
+ public Object listPage(String keywords, String deviceType, String deptid, String beginTime, String endTime, String isOnline) {
Page page = PageFactory.defaultPage();
//查询数据权限 使用默认DEPTID 字段
DataScope dataScope = permissionService.getAuthService().getLoginUserDataScope();
diff --git a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/DeviceMapper.java b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/DeviceMapper.java
index 244e9ff..e2104a4 100644
--- a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/DeviceMapper.java
+++ b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/DeviceMapper.java
@@ -20,6 +20,8 @@
*/
public interface DeviceMapper extends BaseMapper {
+ List getDeviceList(@Param("scope") DataScope dataScope,@Param("deviceType") String deviceType, @Param("deptid") String deptid, @Param("beginTime") String beginTime, @Param("endTime") String endTime, @Param("keywords") String keywords, @Param("isOnline") String isOnline);
+
List selectDataScopePage(@Param("scope") DataScope dataScope, @Param("page") Page page, @Param("deviceType") String deviceType, @Param("deptid") String deptid, @Param("beginTime") String beginTime, @Param("endTime") String endTime, @Param("keywords") String keywords, @Param("isOnline") String isOnline);
List getDeviceList(@Param("scope") DataScope dataScope);
diff --git a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceMapper.xml b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceMapper.xml
index 8de6875..0974260 100644
--- a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceMapper.xml
+++ b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceMapper.xml
@@ -109,6 +109,43 @@
ORDER by a.DEVCODE
+
+ SELECT
+
+ FROM device_view
+ WHERE VALID = '1'
+
+ and deviceType = #{deviceType}
+
+
+ and deptid = #{deptid}
+
+
+ and onlineState = #{isOnline}
+
+
+ and installDate >
+
+
+
+
+
+ and installDate <
+
+
+
+
+
+ and (DEVCODE like
+
+ OR wellCode LIKE
+
+ )
+
+ ORDER BY INSTALLDATE DESC
+
+
SELECT
diff --git a/casic-device/src/main/java/com/casic/missiles/modular/system/service/IDeviceService.java b/casic-device/src/main/java/com/casic/missiles/modular/system/service/IDeviceService.java
index 1bef4a7..7f6232e 100644
--- a/casic-device/src/main/java/com/casic/missiles/modular/system/service/IDeviceService.java
+++ b/casic-device/src/main/java/com/casic/missiles/modular/system/service/IDeviceService.java
@@ -21,18 +21,33 @@
*/
public interface IDeviceService extends IService {
+
+ /**
+ * 不分页
+ *
+ * @param dataScope
+ * @param deviceType
+ * @param deptid
+ * @param beginTime
+ * @param endTime
+ * @param keywords
+ * @param isOnline
+ * @return
+ */
+ List getDeviceList(DataScope dataScope, String deviceType, String deptid, String beginTime, String endTime, String keywords, String isOnline);
+
/**
* 根据条件分页查询设备列表
*
* @param dataScope 数据权限集合
- * @param page 分页参数
* @param deviceType 设备类型
* @param deptid 组织ID
* @param beginTime 设备安装开始时间
* @param endTime 设备安装结束时间
* @return 设备列表
*/
- List selectDataScopePage(DataScope dataScope, Page page, String deviceType, String deptid, String beginTime, String endTime, String keywords, String isOnline);
+ List selectDataScopePage(DataScope dataScope, Page page, String deviceType, String deptid,
+ String beginTime, String endTime, String keywords, String isOnline);
/**
* 根据闸井编号查询闸井ID
diff --git a/casic-device/src/main/java/com/casic/missiles/modular/system/service/impl/DeviceServiceImpl.java b/casic-device/src/main/java/com/casic/missiles/modular/system/service/impl/DeviceServiceImpl.java
index 1a48093..77d3da6 100644
--- a/casic-device/src/main/java/com/casic/missiles/modular/system/service/impl/DeviceServiceImpl.java
+++ b/casic-device/src/main/java/com/casic/missiles/modular/system/service/impl/DeviceServiceImpl.java
@@ -54,6 +54,23 @@
@Autowired
private Validator validator;
+
+ /**
+ * 不分页
+ *
+ * @param dataScope
+ * @param deviceType
+ * @param deptid
+ * @param beginTime
+ * @param endTime
+ * @param keywords
+ * @param isOnline
+ * @return
+ */
+ public List getDeviceList(DataScope dataScope, String deviceType, String deptid, String beginTime, String endTime, String keywords, String isOnline){
+ return this.baseMapper.getDeviceList(dataScope, deviceType, deptid, beginTime, endTime, keywords, isOnline);
+ }
+
/**
* 判断设备是否关联集中器
*