diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/controller/AlarmRecordsController.java b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/controller/AlarmRecordsController.java index 55d6989..7d0ad2e 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/controller/AlarmRecordsController.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/controller/AlarmRecordsController.java @@ -128,7 +128,6 @@ public Object cancelAlarm(@RequestParam(value = "id", required = true) long id, //jobId @RequestParam(value = "jobStatus", required = true) String jobStatus, @RequestParam(value = "handleMessage", required = true) String handleMessage) { - Map retMap = new HashMap<>(); ShiroUser currentUser = iCommonPermissionService.getCurrLoginUser(); boolean isCancel = alarmRecordsService.cancelAlarm(id, jobStatus, handleMessage, currentUser.getId()); if (isCancel) { @@ -153,7 +152,7 @@ @RequestParam(value = "wellName", required = false) String wellName, @RequestParam(value = "jobStatus", required = true) String jobStatus, @RequestParam(value = "handleMessage", required = true) String handleMessage) { - Map retMap = new HashMap<>(); + //根据查询条件查询alarm_record记录 DataScope dataScope = iCommonPermissionService.getCurrUserDataScope(); @@ -164,8 +163,6 @@ for (AlarmRecords alarmRecord : alarmRecords) { alarmRecordsService.cancelAlarm(alarmRecord.getId(), jobStatus, handleMessage, currentUser.getId()); } - - return ResponseData.success(); } diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/controller/AlarmRecordsController.java b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/controller/AlarmRecordsController.java index 55d6989..7d0ad2e 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/controller/AlarmRecordsController.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/controller/AlarmRecordsController.java @@ -128,7 +128,6 @@ public Object cancelAlarm(@RequestParam(value = "id", required = true) long id, //jobId @RequestParam(value = "jobStatus", required = true) String jobStatus, @RequestParam(value = "handleMessage", required = true) String handleMessage) { - Map retMap = new HashMap<>(); ShiroUser currentUser = iCommonPermissionService.getCurrLoginUser(); boolean isCancel = alarmRecordsService.cancelAlarm(id, jobStatus, handleMessage, currentUser.getId()); if (isCancel) { @@ -153,7 +152,7 @@ @RequestParam(value = "wellName", required = false) String wellName, @RequestParam(value = "jobStatus", required = true) String jobStatus, @RequestParam(value = "handleMessage", required = true) String handleMessage) { - Map retMap = new HashMap<>(); + //根据查询条件查询alarm_record记录 DataScope dataScope = iCommonPermissionService.getCurrUserDataScope(); @@ -164,8 +163,6 @@ for (AlarmRecords alarmRecord : alarmRecords) { alarmRecordsService.cancelAlarm(alarmRecord.getId(), jobStatus, handleMessage, currentUser.getId()); } - - return ResponseData.success(); } 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 4a95d42..06fe095 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 @@ -206,7 +206,7 @@ SELECT COUNT(*) AS alarmTimes, - COUNT(DISTINCT a.WELL_CODE) AS alarmWells + COUNT(DISTINCT w.ID) AS alarmWells FROM alarm_records a left join bus_well_info w on a.WELL_CODE = w.WELL_CODE diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRuleMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRuleMapper.xml index e3fba0c..5bf0cd5 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRuleMapper.xml +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRuleMapper.xml @@ -19,21 +19,7 @@ ID AS id, DEVCODE AS devcode, HIGHVALUE AS highvalue, LOWVALUE AS lowvalue, OVERTIME AS overtime, SALTATION AS saltation, SENSORCODE AS sensorcode, GRADE AS grade, TS AS ts - - - - - - - - - - - - - - - + SELECT COUNT(*) AS alarmTimes, - COUNT(DISTINCT a.WELL_CODE) AS alarmWells + COUNT(DISTINCT w.ID) AS alarmWells FROM alarm_records a left join bus_well_info w on a.WELL_CODE = w.WELL_CODE diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRuleMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRuleMapper.xml index e3fba0c..5bf0cd5 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRuleMapper.xml +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRuleMapper.xml @@ -19,21 +19,7 @@ ID AS id, DEVCODE AS devcode, HIGHVALUE AS highvalue, LOWVALUE AS lowvalue, OVERTIME AS overtime, SALTATION AS saltation, SENSORCODE AS sensorcode, GRADE AS grade, TS AS ts - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - + SELECT COUNT(*) AS alarmTimes, - COUNT(DISTINCT a.WELL_CODE) AS alarmWells + COUNT(DISTINCT w.ID) AS alarmWells FROM alarm_records a left join bus_well_info w on a.WELL_CODE = w.WELL_CODE diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRuleMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRuleMapper.xml index e3fba0c..5bf0cd5 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRuleMapper.xml +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRuleMapper.xml @@ -19,21 +19,7 @@ ID AS id, DEVCODE AS devcode, HIGHVALUE AS highvalue, LOWVALUE AS lowvalue, OVERTIME AS overtime, SALTATION AS saltation, SENSORCODE AS sensorcode, GRADE AS grade, TS AS ts - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - +