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 70193fa..9cc0b08 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 @@ -235,7 +235,7 @@ ShiroUser currentUser = iCommonPermissionService.getCurrLoginUser(); List alarmRecords = alarmRecordsService.alarmListNoPage(dataScope, keywords, alarmType, alarmContent, beginTime, endTime, areaId); for (AlarmRecords alarmRecord : alarmRecords) { - alarmRecordsService.cancelAlarm(alarmRecord.getJobId(),"4","手动消警",currentUser.getId()); + alarmRecordsService.cancelAlarm(alarmRecord.getId(),"4","手动消警",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 70193fa..9cc0b08 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 @@ -235,7 +235,7 @@ ShiroUser currentUser = iCommonPermissionService.getCurrLoginUser(); List alarmRecords = alarmRecordsService.alarmListNoPage(dataScope, keywords, alarmType, alarmContent, beginTime, endTime, areaId); for (AlarmRecords alarmRecord : alarmRecords) { - alarmRecordsService.cancelAlarm(alarmRecord.getJobId(),"4","手动消警",currentUser.getId()); + alarmRecordsService.cancelAlarm(alarmRecord.getId(),"4","手动消警",currentUser.getId()); } return ResponseData.success(); } diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java index 9d4e4a2..b3e6fed 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java @@ -66,7 +66,6 @@ public String isOldAlarmRecord(String devCode, String MsgContent) { return this.baseMapper.isOldAlarmRecord(devCode, MsgContent); - } public Integer updateOldAlarmRecord(String devCode, String MsgContent) { 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 70193fa..9cc0b08 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 @@ -235,7 +235,7 @@ ShiroUser currentUser = iCommonPermissionService.getCurrLoginUser(); List alarmRecords = alarmRecordsService.alarmListNoPage(dataScope, keywords, alarmType, alarmContent, beginTime, endTime, areaId); for (AlarmRecords alarmRecord : alarmRecords) { - alarmRecordsService.cancelAlarm(alarmRecord.getJobId(),"4","手动消警",currentUser.getId()); + alarmRecordsService.cancelAlarm(alarmRecord.getId(),"4","手动消警",currentUser.getId()); } return ResponseData.success(); } diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java index 9d4e4a2..b3e6fed 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java @@ -66,7 +66,6 @@ public String isOldAlarmRecord(String devCode, String MsgContent) { return this.baseMapper.isOldAlarmRecord(devCode, MsgContent); - } public Integer updateOldAlarmRecord(String devCode, String MsgContent) { diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java index 6b60c4a..5a85056 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java @@ -65,11 +65,9 @@ // 创建原始记录对象 DataGasFlow dataGasFlow = new DataGasFlow(); - // 赋值设备地址 String gasFlowAddr = gasFlowData.get("assetcode").toString(); dataGasFlow.setDevcode(gasFlowAddr); - // 赋值井编号 DeviceWellDto wellDto = deviceService.selectWellByDevcode(gasFlowAddr); if (null == wellDto) { @@ -81,13 +79,7 @@ Device device = deviceService.getDeviceByDevCode(gasFlowAddr); // 赋值水表读数 - Double gasFlowNumber = 0.0; - String numType = gasFlowData.get("ljll").getClass().getSimpleName(); - if (numType.equals("String")) { - gasFlowNumber = Double.parseDouble(gasFlowData.get("ljll").toString()); - } else if (numType.equals("BigDecimal")) { - gasFlowNumber = ((Number) gasFlowData.get("ljll")).doubleValue(); - } + Double gasFlowNumber = Double.valueOf(gasFlowData.get("ljll").toString()); dataGasFlow.setTotalFlow(String.valueOf(gasFlowNumber)); // 赋值数据采集时间 String readDate = gasFlowData.get("logat").toString(); 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 70193fa..9cc0b08 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 @@ -235,7 +235,7 @@ ShiroUser currentUser = iCommonPermissionService.getCurrLoginUser(); List alarmRecords = alarmRecordsService.alarmListNoPage(dataScope, keywords, alarmType, alarmContent, beginTime, endTime, areaId); for (AlarmRecords alarmRecord : alarmRecords) { - alarmRecordsService.cancelAlarm(alarmRecord.getJobId(),"4","手动消警",currentUser.getId()); + alarmRecordsService.cancelAlarm(alarmRecord.getId(),"4","手动消警",currentUser.getId()); } return ResponseData.success(); } diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java index 9d4e4a2..b3e6fed 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java @@ -66,7 +66,6 @@ public String isOldAlarmRecord(String devCode, String MsgContent) { return this.baseMapper.isOldAlarmRecord(devCode, MsgContent); - } public Integer updateOldAlarmRecord(String devCode, String MsgContent) { diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java index 6b60c4a..5a85056 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java @@ -65,11 +65,9 @@ // 创建原始记录对象 DataGasFlow dataGasFlow = new DataGasFlow(); - // 赋值设备地址 String gasFlowAddr = gasFlowData.get("assetcode").toString(); dataGasFlow.setDevcode(gasFlowAddr); - // 赋值井编号 DeviceWellDto wellDto = deviceService.selectWellByDevcode(gasFlowAddr); if (null == wellDto) { @@ -81,13 +79,7 @@ Device device = deviceService.getDeviceByDevCode(gasFlowAddr); // 赋值水表读数 - Double gasFlowNumber = 0.0; - String numType = gasFlowData.get("ljll").getClass().getSimpleName(); - if (numType.equals("String")) { - gasFlowNumber = Double.parseDouble(gasFlowData.get("ljll").toString()); - } else if (numType.equals("BigDecimal")) { - gasFlowNumber = ((Number) gasFlowData.get("ljll")).doubleValue(); - } + Double gasFlowNumber = Double.valueOf(gasFlowData.get("ljll").toString()); dataGasFlow.setTotalFlow(String.valueOf(gasFlowNumber)); // 赋值数据采集时间 String readDate = gasFlowData.get("logat").toString(); diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/WaterMeterDataReceiver.java b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/WaterMeterDataReceiver.java index 7677a87..63d2e9d 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/WaterMeterDataReceiver.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/WaterMeterDataReceiver.java @@ -100,8 +100,7 @@ dataWaterMeter.setLogtime(Calendar.getInstance().getTime()); // 保存到数据库 同时计算日/月用水量 -// double flowAccToday = waterMeterDataService.saveWaterMeterData(dataWaterMeter); - double flowAccToday=100; + double flowAccToday = waterMeterDataService.saveWaterMeterData(dataWaterMeter); // 判断是否报警/预警 AlarmRule alarmRule = alarmRuleService.selectAlarmRuleByDev(meterAddr, "1"); // 报警 AlarmRule alarmRuleWarn = alarmRuleService.selectAlarmRuleByDev(meterAddr, "2"); // 预警 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 70193fa..9cc0b08 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 @@ -235,7 +235,7 @@ ShiroUser currentUser = iCommonPermissionService.getCurrLoginUser(); List alarmRecords = alarmRecordsService.alarmListNoPage(dataScope, keywords, alarmType, alarmContent, beginTime, endTime, areaId); for (AlarmRecords alarmRecord : alarmRecords) { - alarmRecordsService.cancelAlarm(alarmRecord.getJobId(),"4","手动消警",currentUser.getId()); + alarmRecordsService.cancelAlarm(alarmRecord.getId(),"4","手动消警",currentUser.getId()); } return ResponseData.success(); } diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java index 9d4e4a2..b3e6fed 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java @@ -66,7 +66,6 @@ public String isOldAlarmRecord(String devCode, String MsgContent) { return this.baseMapper.isOldAlarmRecord(devCode, MsgContent); - } public Integer updateOldAlarmRecord(String devCode, String MsgContent) { diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java index 6b60c4a..5a85056 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java @@ -65,11 +65,9 @@ // 创建原始记录对象 DataGasFlow dataGasFlow = new DataGasFlow(); - // 赋值设备地址 String gasFlowAddr = gasFlowData.get("assetcode").toString(); dataGasFlow.setDevcode(gasFlowAddr); - // 赋值井编号 DeviceWellDto wellDto = deviceService.selectWellByDevcode(gasFlowAddr); if (null == wellDto) { @@ -81,13 +79,7 @@ Device device = deviceService.getDeviceByDevCode(gasFlowAddr); // 赋值水表读数 - Double gasFlowNumber = 0.0; - String numType = gasFlowData.get("ljll").getClass().getSimpleName(); - if (numType.equals("String")) { - gasFlowNumber = Double.parseDouble(gasFlowData.get("ljll").toString()); - } else if (numType.equals("BigDecimal")) { - gasFlowNumber = ((Number) gasFlowData.get("ljll")).doubleValue(); - } + Double gasFlowNumber = Double.valueOf(gasFlowData.get("ljll").toString()); dataGasFlow.setTotalFlow(String.valueOf(gasFlowNumber)); // 赋值数据采集时间 String readDate = gasFlowData.get("logat").toString(); diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/WaterMeterDataReceiver.java b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/WaterMeterDataReceiver.java index 7677a87..63d2e9d 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/WaterMeterDataReceiver.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/WaterMeterDataReceiver.java @@ -100,8 +100,7 @@ dataWaterMeter.setLogtime(Calendar.getInstance().getTime()); // 保存到数据库 同时计算日/月用水量 -// double flowAccToday = waterMeterDataService.saveWaterMeterData(dataWaterMeter); - double flowAccToday=100; + double flowAccToday = waterMeterDataService.saveWaterMeterData(dataWaterMeter); // 判断是否报警/预警 AlarmRule alarmRule = alarmRuleService.selectAlarmRuleByDev(meterAddr, "1"); // 报警 AlarmRule alarmRuleWarn = alarmRuleService.selectAlarmRuleByDev(meterAddr, "2"); // 预警 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 d275ff7..0b1650e 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 @@ -151,6 +151,7 @@ WHERE DEVCODE = #{devcode} AND ALARM_CONTENT = #{MsgContent} AND STATUS='1' + AND JOB_ID>0 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 70193fa..9cc0b08 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 @@ -235,7 +235,7 @@ ShiroUser currentUser = iCommonPermissionService.getCurrLoginUser(); List alarmRecords = alarmRecordsService.alarmListNoPage(dataScope, keywords, alarmType, alarmContent, beginTime, endTime, areaId); for (AlarmRecords alarmRecord : alarmRecords) { - alarmRecordsService.cancelAlarm(alarmRecord.getJobId(),"4","手动消警",currentUser.getId()); + alarmRecordsService.cancelAlarm(alarmRecord.getId(),"4","手动消警",currentUser.getId()); } return ResponseData.success(); } diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java index 9d4e4a2..b3e6fed 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java @@ -66,7 +66,6 @@ public String isOldAlarmRecord(String devCode, String MsgContent) { return this.baseMapper.isOldAlarmRecord(devCode, MsgContent); - } public Integer updateOldAlarmRecord(String devCode, String MsgContent) { diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java index 6b60c4a..5a85056 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java @@ -65,11 +65,9 @@ // 创建原始记录对象 DataGasFlow dataGasFlow = new DataGasFlow(); - // 赋值设备地址 String gasFlowAddr = gasFlowData.get("assetcode").toString(); dataGasFlow.setDevcode(gasFlowAddr); - // 赋值井编号 DeviceWellDto wellDto = deviceService.selectWellByDevcode(gasFlowAddr); if (null == wellDto) { @@ -81,13 +79,7 @@ Device device = deviceService.getDeviceByDevCode(gasFlowAddr); // 赋值水表读数 - Double gasFlowNumber = 0.0; - String numType = gasFlowData.get("ljll").getClass().getSimpleName(); - if (numType.equals("String")) { - gasFlowNumber = Double.parseDouble(gasFlowData.get("ljll").toString()); - } else if (numType.equals("BigDecimal")) { - gasFlowNumber = ((Number) gasFlowData.get("ljll")).doubleValue(); - } + Double gasFlowNumber = Double.valueOf(gasFlowData.get("ljll").toString()); dataGasFlow.setTotalFlow(String.valueOf(gasFlowNumber)); // 赋值数据采集时间 String readDate = gasFlowData.get("logat").toString(); diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/WaterMeterDataReceiver.java b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/WaterMeterDataReceiver.java index 7677a87..63d2e9d 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/WaterMeterDataReceiver.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/WaterMeterDataReceiver.java @@ -100,8 +100,7 @@ dataWaterMeter.setLogtime(Calendar.getInstance().getTime()); // 保存到数据库 同时计算日/月用水量 -// double flowAccToday = waterMeterDataService.saveWaterMeterData(dataWaterMeter); - double flowAccToday=100; + double flowAccToday = waterMeterDataService.saveWaterMeterData(dataWaterMeter); // 判断是否报警/预警 AlarmRule alarmRule = alarmRuleService.selectAlarmRuleByDev(meterAddr, "1"); // 报警 AlarmRule alarmRuleWarn = alarmRuleService.selectAlarmRuleByDev(meterAddr, "2"); // 预警 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 d275ff7..0b1650e 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 @@ -151,6 +151,7 @@ WHERE DEVCODE = #{devcode} AND ALARM_CONTENT = #{MsgContent} AND STATUS='1' + AND JOB_ID>0 diff --git a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataGasFlowMapper.java b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataGasFlowMapper.java index 9256c80..1283ba2 100644 --- a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataGasFlowMapper.java +++ b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataGasFlowMapper.java @@ -14,4 +14,10 @@ Map selectLatestDayAccByDevice(@Param("devcode") String devcode, @Param("date") String date); Map isExistDataGasFlowMonth(@Param("devcode") String devcode, @Param("month") String month); + + void updateDataGasFlowDay(@Param("devcode") String devcode, + @Param("wellCode") String wellCode, + @Param("date") String date, + @Param("totalFlow") String totalFlow, + @Param("totalFlowDate") String totalFlowDate); } 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 70193fa..9cc0b08 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 @@ -235,7 +235,7 @@ ShiroUser currentUser = iCommonPermissionService.getCurrLoginUser(); List alarmRecords = alarmRecordsService.alarmListNoPage(dataScope, keywords, alarmType, alarmContent, beginTime, endTime, areaId); for (AlarmRecords alarmRecord : alarmRecords) { - alarmRecordsService.cancelAlarm(alarmRecord.getJobId(),"4","手动消警",currentUser.getId()); + alarmRecordsService.cancelAlarm(alarmRecord.getId(),"4","手动消警",currentUser.getId()); } return ResponseData.success(); } diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java index 9d4e4a2..b3e6fed 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java @@ -66,7 +66,6 @@ public String isOldAlarmRecord(String devCode, String MsgContent) { return this.baseMapper.isOldAlarmRecord(devCode, MsgContent); - } public Integer updateOldAlarmRecord(String devCode, String MsgContent) { diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java index 6b60c4a..5a85056 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java @@ -65,11 +65,9 @@ // 创建原始记录对象 DataGasFlow dataGasFlow = new DataGasFlow(); - // 赋值设备地址 String gasFlowAddr = gasFlowData.get("assetcode").toString(); dataGasFlow.setDevcode(gasFlowAddr); - // 赋值井编号 DeviceWellDto wellDto = deviceService.selectWellByDevcode(gasFlowAddr); if (null == wellDto) { @@ -81,13 +79,7 @@ Device device = deviceService.getDeviceByDevCode(gasFlowAddr); // 赋值水表读数 - Double gasFlowNumber = 0.0; - String numType = gasFlowData.get("ljll").getClass().getSimpleName(); - if (numType.equals("String")) { - gasFlowNumber = Double.parseDouble(gasFlowData.get("ljll").toString()); - } else if (numType.equals("BigDecimal")) { - gasFlowNumber = ((Number) gasFlowData.get("ljll")).doubleValue(); - } + Double gasFlowNumber = Double.valueOf(gasFlowData.get("ljll").toString()); dataGasFlow.setTotalFlow(String.valueOf(gasFlowNumber)); // 赋值数据采集时间 String readDate = gasFlowData.get("logat").toString(); diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/WaterMeterDataReceiver.java b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/WaterMeterDataReceiver.java index 7677a87..63d2e9d 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/WaterMeterDataReceiver.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/WaterMeterDataReceiver.java @@ -100,8 +100,7 @@ dataWaterMeter.setLogtime(Calendar.getInstance().getTime()); // 保存到数据库 同时计算日/月用水量 -// double flowAccToday = waterMeterDataService.saveWaterMeterData(dataWaterMeter); - double flowAccToday=100; + double flowAccToday = waterMeterDataService.saveWaterMeterData(dataWaterMeter); // 判断是否报警/预警 AlarmRule alarmRule = alarmRuleService.selectAlarmRuleByDev(meterAddr, "1"); // 报警 AlarmRule alarmRuleWarn = alarmRuleService.selectAlarmRuleByDev(meterAddr, "2"); // 预警 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 d275ff7..0b1650e 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 @@ -151,6 +151,7 @@ WHERE DEVCODE = #{devcode} AND ALARM_CONTENT = #{MsgContent} AND STATUS='1' + AND JOB_ID>0 diff --git a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataGasFlowMapper.java b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataGasFlowMapper.java index 9256c80..1283ba2 100644 --- a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataGasFlowMapper.java +++ b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataGasFlowMapper.java @@ -14,4 +14,10 @@ Map selectLatestDayAccByDevice(@Param("devcode") String devcode, @Param("date") String date); Map isExistDataGasFlowMonth(@Param("devcode") String devcode, @Param("month") String month); + + void updateDataGasFlowDay(@Param("devcode") String devcode, + @Param("wellCode") String wellCode, + @Param("date") String date, + @Param("totalFlow") String totalFlow, + @Param("totalFlowDate") String totalFlowDate); } diff --git a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java index a277471..743bee9 100644 --- a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java +++ b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java @@ -25,6 +25,7 @@ Map isExistDataWatermeterMonth(@Param("devcode") String devcode, @Param("month") String month); void insertDataWatermeterDay(@Param("dataDay") Map dataDay); + void updateDataWatermeterDay(@Param("dataDay") Map dataDay); void insertDataWatermeterMonth(@Param("dataMonth") Map dataMonth); void updateDataWatermeterMonth(@Param("dataMonth") Map dataMonth, @Param("id") Long id); } 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 70193fa..9cc0b08 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 @@ -235,7 +235,7 @@ ShiroUser currentUser = iCommonPermissionService.getCurrLoginUser(); List alarmRecords = alarmRecordsService.alarmListNoPage(dataScope, keywords, alarmType, alarmContent, beginTime, endTime, areaId); for (AlarmRecords alarmRecord : alarmRecords) { - alarmRecordsService.cancelAlarm(alarmRecord.getJobId(),"4","手动消警",currentUser.getId()); + alarmRecordsService.cancelAlarm(alarmRecord.getId(),"4","手动消警",currentUser.getId()); } return ResponseData.success(); } diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java index 9d4e4a2..b3e6fed 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java @@ -66,7 +66,6 @@ public String isOldAlarmRecord(String devCode, String MsgContent) { return this.baseMapper.isOldAlarmRecord(devCode, MsgContent); - } public Integer updateOldAlarmRecord(String devCode, String MsgContent) { diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java index 6b60c4a..5a85056 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java @@ -65,11 +65,9 @@ // 创建原始记录对象 DataGasFlow dataGasFlow = new DataGasFlow(); - // 赋值设备地址 String gasFlowAddr = gasFlowData.get("assetcode").toString(); dataGasFlow.setDevcode(gasFlowAddr); - // 赋值井编号 DeviceWellDto wellDto = deviceService.selectWellByDevcode(gasFlowAddr); if (null == wellDto) { @@ -81,13 +79,7 @@ Device device = deviceService.getDeviceByDevCode(gasFlowAddr); // 赋值水表读数 - Double gasFlowNumber = 0.0; - String numType = gasFlowData.get("ljll").getClass().getSimpleName(); - if (numType.equals("String")) { - gasFlowNumber = Double.parseDouble(gasFlowData.get("ljll").toString()); - } else if (numType.equals("BigDecimal")) { - gasFlowNumber = ((Number) gasFlowData.get("ljll")).doubleValue(); - } + Double gasFlowNumber = Double.valueOf(gasFlowData.get("ljll").toString()); dataGasFlow.setTotalFlow(String.valueOf(gasFlowNumber)); // 赋值数据采集时间 String readDate = gasFlowData.get("logat").toString(); diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/WaterMeterDataReceiver.java b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/WaterMeterDataReceiver.java index 7677a87..63d2e9d 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/WaterMeterDataReceiver.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/WaterMeterDataReceiver.java @@ -100,8 +100,7 @@ dataWaterMeter.setLogtime(Calendar.getInstance().getTime()); // 保存到数据库 同时计算日/月用水量 -// double flowAccToday = waterMeterDataService.saveWaterMeterData(dataWaterMeter); - double flowAccToday=100; + double flowAccToday = waterMeterDataService.saveWaterMeterData(dataWaterMeter); // 判断是否报警/预警 AlarmRule alarmRule = alarmRuleService.selectAlarmRuleByDev(meterAddr, "1"); // 报警 AlarmRule alarmRuleWarn = alarmRuleService.selectAlarmRuleByDev(meterAddr, "2"); // 预警 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 d275ff7..0b1650e 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 @@ -151,6 +151,7 @@ WHERE DEVCODE = #{devcode} AND ALARM_CONTENT = #{MsgContent} AND STATUS='1' + AND JOB_ID>0 diff --git a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataGasFlowMapper.java b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataGasFlowMapper.java index 9256c80..1283ba2 100644 --- a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataGasFlowMapper.java +++ b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataGasFlowMapper.java @@ -14,4 +14,10 @@ Map selectLatestDayAccByDevice(@Param("devcode") String devcode, @Param("date") String date); Map isExistDataGasFlowMonth(@Param("devcode") String devcode, @Param("month") String month); + + void updateDataGasFlowDay(@Param("devcode") String devcode, + @Param("wellCode") String wellCode, + @Param("date") String date, + @Param("totalFlow") String totalFlow, + @Param("totalFlowDate") String totalFlowDate); } diff --git a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java index a277471..743bee9 100644 --- a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java +++ b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java @@ -25,6 +25,7 @@ Map isExistDataWatermeterMonth(@Param("devcode") String devcode, @Param("month") String month); void insertDataWatermeterDay(@Param("dataDay") Map dataDay); + void updateDataWatermeterDay(@Param("dataDay") Map dataDay); void insertDataWatermeterMonth(@Param("dataMonth") Map dataMonth); void updateDataWatermeterMonth(@Param("dataMonth") Map dataMonth, @Param("id") Long id); } diff --git a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataGasFlowMapper.xml b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataGasFlowMapper.xml index c4ca696..eb691c4 100644 --- a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataGasFlowMapper.xml +++ b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataGasFlowMapper.xml @@ -27,7 +27,7 @@ SELECT FROM data_gasflow - WHERE devcode = #{devcode} and unix_timestamp(uptime) < unix_timestamp(#{uptime}) + WHERE devcode = #{devcode} ORDER BY uptime DESC limit 1 @@ -39,7 +39,8 @@ WHERE DEVCODE =#{devcode} order by uptime desc limit 1 ) dg - WHERE DEVCODE = #{devcode} AND unix_timestamp(DATE) < unix_timestamp(#{date}) order by DATE desc limit 1 + WHERE DEVCODE = #{devcode} + order by DATE desc limit 1 + + UPDATE data_gasflow_day + SET TOTAL_FLOW = #{totalFlow},TOTAL_FLOW_DATE = #{totalFlowDate} + WHERE DATE = #{date} + AND WELL_CODE= #{wellCode} + AND DEVCODE=#{devcode} + + 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 70193fa..9cc0b08 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 @@ -235,7 +235,7 @@ ShiroUser currentUser = iCommonPermissionService.getCurrLoginUser(); List alarmRecords = alarmRecordsService.alarmListNoPage(dataScope, keywords, alarmType, alarmContent, beginTime, endTime, areaId); for (AlarmRecords alarmRecord : alarmRecords) { - alarmRecordsService.cancelAlarm(alarmRecord.getJobId(),"4","手动消警",currentUser.getId()); + alarmRecordsService.cancelAlarm(alarmRecord.getId(),"4","手动消警",currentUser.getId()); } return ResponseData.success(); } diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java index 9d4e4a2..b3e6fed 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/service/impl/AlarmRecordsServiceImpl.java @@ -66,7 +66,6 @@ public String isOldAlarmRecord(String devCode, String MsgContent) { return this.baseMapper.isOldAlarmRecord(devCode, MsgContent); - } public Integer updateOldAlarmRecord(String devCode, String MsgContent) { diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java index 6b60c4a..5a85056 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/GasFlowDataReceiver.java @@ -65,11 +65,9 @@ // 创建原始记录对象 DataGasFlow dataGasFlow = new DataGasFlow(); - // 赋值设备地址 String gasFlowAddr = gasFlowData.get("assetcode").toString(); dataGasFlow.setDevcode(gasFlowAddr); - // 赋值井编号 DeviceWellDto wellDto = deviceService.selectWellByDevcode(gasFlowAddr); if (null == wellDto) { @@ -81,13 +79,7 @@ Device device = deviceService.getDeviceByDevCode(gasFlowAddr); // 赋值水表读数 - Double gasFlowNumber = 0.0; - String numType = gasFlowData.get("ljll").getClass().getSimpleName(); - if (numType.equals("String")) { - gasFlowNumber = Double.parseDouble(gasFlowData.get("ljll").toString()); - } else if (numType.equals("BigDecimal")) { - gasFlowNumber = ((Number) gasFlowData.get("ljll")).doubleValue(); - } + Double gasFlowNumber = Double.valueOf(gasFlowData.get("ljll").toString()); dataGasFlow.setTotalFlow(String.valueOf(gasFlowNumber)); // 赋值数据采集时间 String readDate = gasFlowData.get("logat").toString(); diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/WaterMeterDataReceiver.java b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/WaterMeterDataReceiver.java index 7677a87..63d2e9d 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/WaterMeterDataReceiver.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/controller/WaterMeterDataReceiver.java @@ -100,8 +100,7 @@ dataWaterMeter.setLogtime(Calendar.getInstance().getTime()); // 保存到数据库 同时计算日/月用水量 -// double flowAccToday = waterMeterDataService.saveWaterMeterData(dataWaterMeter); - double flowAccToday=100; + double flowAccToday = waterMeterDataService.saveWaterMeterData(dataWaterMeter); // 判断是否报警/预警 AlarmRule alarmRule = alarmRuleService.selectAlarmRuleByDev(meterAddr, "1"); // 报警 AlarmRule alarmRuleWarn = alarmRuleService.selectAlarmRuleByDev(meterAddr, "2"); // 预警 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 d275ff7..0b1650e 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 @@ -151,6 +151,7 @@ WHERE DEVCODE = #{devcode} AND ALARM_CONTENT = #{MsgContent} AND STATUS='1' + AND JOB_ID>0 diff --git a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataGasFlowMapper.java b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataGasFlowMapper.java index 9256c80..1283ba2 100644 --- a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataGasFlowMapper.java +++ b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataGasFlowMapper.java @@ -14,4 +14,10 @@ Map selectLatestDayAccByDevice(@Param("devcode") String devcode, @Param("date") String date); Map isExistDataGasFlowMonth(@Param("devcode") String devcode, @Param("month") String month); + + void updateDataGasFlowDay(@Param("devcode") String devcode, + @Param("wellCode") String wellCode, + @Param("date") String date, + @Param("totalFlow") String totalFlow, + @Param("totalFlowDate") String totalFlowDate); } diff --git a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java index a277471..743bee9 100644 --- a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java +++ b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java @@ -25,6 +25,7 @@ Map isExistDataWatermeterMonth(@Param("devcode") String devcode, @Param("month") String month); void insertDataWatermeterDay(@Param("dataDay") Map dataDay); + void updateDataWatermeterDay(@Param("dataDay") Map dataDay); void insertDataWatermeterMonth(@Param("dataMonth") Map dataMonth); void updateDataWatermeterMonth(@Param("dataMonth") Map dataMonth, @Param("id") Long id); } diff --git a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataGasFlowMapper.xml b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataGasFlowMapper.xml index c4ca696..eb691c4 100644 --- a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataGasFlowMapper.xml +++ b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataGasFlowMapper.xml @@ -27,7 +27,7 @@ SELECT FROM data_gasflow - WHERE devcode = #{devcode} and unix_timestamp(uptime) < unix_timestamp(#{uptime}) + WHERE devcode = #{devcode} ORDER BY uptime DESC limit 1 @@ -39,7 +39,8 @@ WHERE DEVCODE =#{devcode} order by uptime desc limit 1 ) dg - WHERE DEVCODE = #{devcode} AND unix_timestamp(DATE) < unix_timestamp(#{date}) order by DATE desc limit 1 + WHERE DEVCODE = #{devcode} + order by DATE desc limit 1 + + UPDATE data_gasflow_day + SET TOTAL_FLOW = #{totalFlow},TOTAL_FLOW_DATE = #{totalFlowDate} + WHERE DATE = #{date} + AND WELL_CODE= #{wellCode} + AND DEVCODE=#{devcode} + + diff --git a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataWaterMeterMapper.xml b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataWaterMeterMapper.xml index 4015909..faf1e9e 100644 --- a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataWaterMeterMapper.xml +++ b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataWaterMeterMapper.xml @@ -24,7 +24,7 @@ @@ -43,6 +43,14 @@ VALUES (#{dataDay.wellCode}, #{dataDay.devCode}, #{dataDay.flowAccDate}, #{dataDay.flowAcc}, #{dataDay.date}) + + UPDATE data_watermeter_day + SET FLOW_ACC = #{dataDay.flowAcc}, FLOW_ACC_DATE = #{dataDay.flowAccDate} + WHERE DATE = #{dataDay.date} + AND WELL_CODE= #{dataDay.wellCode} + AND DEVCODE=#{dataDay.devCode} + + diff --git a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataGasFlowMapper.java b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataGasFlowMapper.java index 9256c80..1283ba2 100644 --- a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataGasFlowMapper.java +++ b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataGasFlowMapper.java @@ -14,4 +14,10 @@ Map selectLatestDayAccByDevice(@Param("devcode") String devcode, @Param("date") String date); Map isExistDataGasFlowMonth(@Param("devcode") String devcode, @Param("month") String month); + + void updateDataGasFlowDay(@Param("devcode") String devcode, + @Param("wellCode") String wellCode, + @Param("date") String date, + @Param("totalFlow") String totalFlow, + @Param("totalFlowDate") String totalFlowDate); } diff --git a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java index a277471..743bee9 100644 --- a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java +++ b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java @@ -25,6 +25,7 @@ Map isExistDataWatermeterMonth(@Param("devcode") String devcode, @Param("month") String month); void insertDataWatermeterDay(@Param("dataDay") Map dataDay); + void updateDataWatermeterDay(@Param("dataDay") Map dataDay); void insertDataWatermeterMonth(@Param("dataMonth") Map dataMonth); void updateDataWatermeterMonth(@Param("dataMonth") Map dataMonth, @Param("id") Long id); } diff --git a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataGasFlowMapper.xml b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataGasFlowMapper.xml index c4ca696..eb691c4 100644 --- a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataGasFlowMapper.xml +++ b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataGasFlowMapper.xml @@ -27,7 +27,7 @@ SELECT FROM data_gasflow - WHERE devcode = #{devcode} and unix_timestamp(uptime) < unix_timestamp(#{uptime}) + WHERE devcode = #{devcode} ORDER BY uptime DESC limit 1 @@ -39,7 +39,8 @@ WHERE DEVCODE =#{devcode} order by uptime desc limit 1 ) dg - WHERE DEVCODE = #{devcode} AND unix_timestamp(DATE) < unix_timestamp(#{date}) order by DATE desc limit 1 + WHERE DEVCODE = #{devcode} + order by DATE desc limit 1 + + UPDATE data_gasflow_day + SET TOTAL_FLOW = #{totalFlow},TOTAL_FLOW_DATE = #{totalFlowDate} + WHERE DATE = #{date} + AND WELL_CODE= #{wellCode} + AND DEVCODE=#{devcode} + + diff --git a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataWaterMeterMapper.xml b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataWaterMeterMapper.xml index 4015909..faf1e9e 100644 --- a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataWaterMeterMapper.xml +++ b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataWaterMeterMapper.xml @@ -24,7 +24,7 @@ @@ -43,6 +43,14 @@ VALUES (#{dataDay.wellCode}, #{dataDay.devCode}, #{dataDay.flowAccDate}, #{dataDay.flowAcc}, #{dataDay.date}) + + UPDATE data_watermeter_day + SET FLOW_ACC = #{dataDay.flowAcc}, FLOW_ACC_DATE = #{dataDay.flowAccDate} + WHERE DATE = #{dataDay.date} + AND WELL_CODE= #{dataDay.wellCode} + AND DEVCODE=#{dataDay.devCode} + + diff --git a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataGasFlowMapper.java b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataGasFlowMapper.java index 9256c80..1283ba2 100644 --- a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataGasFlowMapper.java +++ b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataGasFlowMapper.java @@ -14,4 +14,10 @@ Map selectLatestDayAccByDevice(@Param("devcode") String devcode, @Param("date") String date); Map isExistDataGasFlowMonth(@Param("devcode") String devcode, @Param("month") String month); + + void updateDataGasFlowDay(@Param("devcode") String devcode, + @Param("wellCode") String wellCode, + @Param("date") String date, + @Param("totalFlow") String totalFlow, + @Param("totalFlowDate") String totalFlowDate); } diff --git a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java index a277471..743bee9 100644 --- a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java +++ b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java @@ -25,6 +25,7 @@ Map isExistDataWatermeterMonth(@Param("devcode") String devcode, @Param("month") String month); void insertDataWatermeterDay(@Param("dataDay") Map dataDay); + void updateDataWatermeterDay(@Param("dataDay") Map dataDay); void insertDataWatermeterMonth(@Param("dataMonth") Map dataMonth); void updateDataWatermeterMonth(@Param("dataMonth") Map dataMonth, @Param("id") Long id); } diff --git a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataGasFlowMapper.xml b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataGasFlowMapper.xml index c4ca696..eb691c4 100644 --- a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataGasFlowMapper.xml +++ b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataGasFlowMapper.xml @@ -27,7 +27,7 @@ SELECT FROM data_gasflow - WHERE devcode = #{devcode} and unix_timestamp(uptime) < unix_timestamp(#{uptime}) + WHERE devcode = #{devcode} ORDER BY uptime DESC limit 1 @@ -39,7 +39,8 @@ WHERE DEVCODE =#{devcode} order by uptime desc limit 1 ) dg - WHERE DEVCODE = #{devcode} AND unix_timestamp(DATE) < unix_timestamp(#{date}) order by DATE desc limit 1 + WHERE DEVCODE = #{devcode} + order by DATE desc limit 1 + + UPDATE data_gasflow_day + SET TOTAL_FLOW = #{totalFlow},TOTAL_FLOW_DATE = #{totalFlowDate} + WHERE DATE = #{date} + AND WELL_CODE= #{wellCode} + AND DEVCODE=#{devcode} + + diff --git a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataWaterMeterMapper.xml b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataWaterMeterMapper.xml index 4015909..faf1e9e 100644 --- a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataWaterMeterMapper.xml +++ b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataWaterMeterMapper.xml @@ -24,7 +24,7 @@ @@ -43,6 +43,14 @@ VALUES (#{dataDay.wellCode}, #{dataDay.devCode}, #{dataDay.flowAccDate}, #{dataDay.flowAcc}, #{dataDay.date}) + + UPDATE data_watermeter_day + SET FLOW_ACC = #{dataDay.flowAcc}, FLOW_ACC_DATE = #{dataDay.flowAccDate} + WHERE DATE = #{dataDay.date} + AND WELL_CODE= #{dataDay.wellCode} + AND DEVCODE=#{dataDay.devCode} + +