| | |
| | | |
| | | //根据测点分组 |
| | | Map<String, List<PeakValleyFlatEntity>> groupedByPointNo = list.stream() |
| | | .collect(Collectors.groupingBy(PeakValleyFlatEntity::getPowerNo)); |
| | | .collect(Collectors.groupingBy(PeakValleyFlatEntity::getPointNo)); |
| | | |
| | | groupedByPointNo.entrySet().stream().forEach(entry -> { |
| | | |
| | | //计算昨日的累积量 |
| | | //计算昨日的峰/谷累积量 |
| | | double value = getSumValue(entry.getValue(), 1, calendar); |
| | | |
| | | //计算昨日总电耗 |
| | | Calendar cal = (Calendar) calendar.clone(); |
| | | cal.set(Calendar.MILLISECOND, 0); |
| | | cal.set(Calendar.SECOND, 0); |
| | | cal.set(Calendar.MINUTE, 0); |
| | | cal.set(Calendar.HOUR_OF_DAY, 0); |
| | | Date endTime = calendar.getTime(); |
| | | cal.add(Calendar.DAY_OF_YEAR, -1); |
| | | Date startTime = cal.getTime(); |
| | | double totalValue = getSumValueTotal(entry.getValue().get(0).getPowerNo(), startTime,endTime); |
| | | cal.add(Calendar.DAY_OF_YEAR, -29); |
| | | Date monthStartTime = cal.getTime(); |
| | | double totalValue = getSumValueTotal(entry.getValue().get(0).getPowerNo(), startTime, endTime); |
| | | |
| | | //下发昨日占比 |
| | | ApiPointValueWriteDTO dto = new ApiPointValueWriteDTO(); |
| | | dto.setPointNo(entry.getValue().get(0).getPointNo()); |
| | | double percent = totalValue==0?0:value/totalValue*100; |
| | | dto.setValue(percent); |
| | | dataPointApi.writePointRealValue(dto); |
| | | ApiPointValueWriteDTO percentDto = new ApiPointValueWriteDTO(); |
| | | percentDto.setPointNo(entry.getValue().get(0).getPointNo()); |
| | | double percent = totalValue == 0 ? 0 : value / totalValue * 100; |
| | | percentDto.setValue(percent); |
| | | dataPointApi.writePointRealValue(percentDto); |
| | | |
| | | if(entry.getValue().get(0).getPointNoMonth()!=null){ |
| | | //计算前三十日累积量 |
| | | double value30 = 0; |
| | | for (int i = 1; i < 31; i++) { |
| | | //计算前三十日累积量 |
| | | value30 = value30 + getSumValue(entry.getValue(), i, calendar); |
| | | } |
| | | //下发昨日峰/谷累积量 |
| | | ApiPointValueWriteDTO totalDto = new ApiPointValueWriteDTO(); |
| | | percentDto.setPointNo(entry.getValue().get(0).getPointNoTotal()); |
| | | percentDto.setValue(totalValue); |
| | | dataPointApi.writePointRealValue(totalDto); |
| | | |
| | | //计算前三十日总电耗 |
| | | calendar.set(Calendar.MILLISECOND, 0); |
| | | calendar.set(Calendar.MINUTE, 0); |
| | | calendar.set(Calendar.HOUR_OF_DAY, 0); |
| | | calendar.add(Calendar.DAY_OF_YEAR, -30); |
| | | Date startTimeMonth = calendar.getTime(); |
| | | double totalValueMonth = getSumValueTotal(entry.getValue().get(0).getPowerNo(), startTimeMonth,endTime); |
| | | //计算前三十日峰/谷累积量 |
| | | double valueMonth = getSumValueTotal(entry.getValue().get(0).getPointNoTotal(), monthStartTime, startTime)+totalValue; |
| | | |
| | | //下发前三十日占比 |
| | | ApiPointValueWriteDTO monthDto = new ApiPointValueWriteDTO(); |
| | | monthDto.setPointNo(entry.getValue().get(0).getPointNoMonth()); |
| | | double percentMonth = totalValueMonth==0?0:value30/totalValueMonth*100; |
| | | monthDto.setValue(percentMonth); |
| | | dataPointApi.writePointRealValue(monthDto); |
| | | } |
| | | //计算前三十日总电耗 |
| | | double totalValueMonth = getSumValueTotal(entry.getValue().get(0).getPowerNo(), monthStartTime, endTime); |
| | | |
| | | //下发前三十日占比 |
| | | ApiPointValueWriteDTO monthDto = new ApiPointValueWriteDTO(); |
| | | monthDto.setPointNo(entry.getValue().get(0).getPointNoMonth()); |
| | | double percentMonth = totalValueMonth == 0 ? 0 : valueMonth / totalValueMonth * 100; |
| | | monthDto.setValue(percentMonth); |
| | | logger.info("name:"+entry.getValue().get(0).getName()+";value:"+value+";valueMonth:"+valueMonth+";totalValueMonth:"+totalValueMonth); |
| | | dataPointApi.writePointRealValue(monthDto); |
| | | }); |
| | | } catch (Exception ex) { |
| | | logger.error("runPeakValleyFlatTask运行异常"); |
| | | ex.printStackTrace(); |
| | | logger.error("runPeakValleyFlatTask运行异常", ex); |
| | | } |
| | | } |
| | | |
| | |
| | | } |
| | | //根据配置获取startTime、endTime |
| | | cal.set(Calendar.MILLISECOND, 0); |
| | | cal.set(Calendar.SECOND, 0); |
| | | cal.set(Calendar.HOUR_OF_DAY, Integer.parseInt(timeSplit[0])); |
| | | cal.set(Calendar.MINUTE, Integer.parseInt(timeSplit[1])); |
| | | cal.add(Calendar.DAY_OF_YEAR, -ago); |
| | |
| | | dto.setPointNo(entity.getPowerNo()); |
| | | dto.setStart(startTime); |
| | | dto.setEnd(endTime); |
| | | logger.info("开始查询,测点:"+entity.getPowerNo()+"startTime:"+startTime+"endTime:"+endTime); |
| | | |
| | | logger.info("开始查询,测点:" + entity.getPowerNo() + "startTime:" + startTime + "endTime:" + endTime); |
| | | List<ApiPointValueDTO> valueList; |
| | | //查找数据 |
| | | List<ApiPointValueDTO> valueList = dataPointApi.queryPointHistoryValue(dto); |
| | | try { |
| | | valueList = dataPointApi.queryPointHistoryValue(dto); |
| | | } catch (Exception e) { |
| | | throw new RuntimeException("查询测点异常"); |
| | | } |
| | | //补全数据 |
| | | valueList = fillMissingData(valueList, startTime, endTime); |
| | | //累加 |
| | |
| | | //补全数据 |
| | | valueList = fillMissingData(valueList, startTime, endTime); |
| | | //累加 |
| | | return valueList.stream().mapToDouble(ApiPointValueDTO::getV).sum()/ 60; |
| | | return valueList.stream().mapToDouble(ApiPointValueDTO::getV).sum() / 60; |
| | | } |
| | | } |