From 668fc62ed7fa383b3b9fb35acb3baba89ff5c770 Mon Sep 17 00:00:00 2001 From: dongyukun <1208714201@qq.com> Date: 星期三, 11 六月 2025 14:28:46 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/api/McsApiImpl.java | 710 ++++++++++++++++++++++++++++++++++++++++++---------------- 1 files changed, 509 insertions(+), 201 deletions(-) diff --git a/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/api/McsApiImpl.java b/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/api/McsApiImpl.java index bd7dc00..bf62f60 100644 --- a/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/api/McsApiImpl.java +++ b/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/api/McsApiImpl.java @@ -1,5 +1,6 @@ package com.iailab.module.model.api; +import com.iailab.framework.common.pojo.PageResult; import com.iailab.framework.common.util.date.DateUtils; import com.iailab.framework.common.util.object.ConvertUtils; import com.iailab.module.data.api.plan.PlanItemApi; @@ -8,25 +9,37 @@ import com.iailab.module.data.api.point.dto.ApiPointDTO; import com.iailab.module.data.api.point.dto.ApiPointValueDTO; import com.iailab.module.data.api.point.dto.ApiPointValueQueryDTO; -import com.iailab.module.data.api.point.dto.ApiPointValueWriteDTO; import com.iailab.module.data.common.ApiDataQueryDTO; import com.iailab.module.model.api.mcs.McsApi; import com.iailab.module.model.api.mcs.dto.*; -import com.iailab.module.model.common.enums.CommonConstant; +import com.iailab.module.model.api.mdk.dto.StScheduleRecordVO; +import com.iailab.module.model.common.enums.CommonDict; +import com.iailab.module.model.common.enums.DataTypeEnum; import com.iailab.module.model.common.enums.PreLineTypeEnum; +import com.iailab.module.model.enums.CommonConstant; +import com.iailab.module.model.influxdb.pojo.InfluxModelResultByOutPutIdsPOJO; +import com.iailab.module.model.influxdb.service.InfluxDBService; +import com.iailab.module.model.influxdb.vo.InfluxModelResultVO; import com.iailab.module.model.mcs.pre.entity.DmModuleEntity; import com.iailab.module.model.mcs.pre.entity.MmItemOutputEntity; import com.iailab.module.model.mcs.pre.entity.MmPredictAlarmMessageEntity; +import com.iailab.module.model.mcs.pre.entity.MmPredictModelEntity; +import com.iailab.module.model.mcs.pre.enums.PredGranularityEnum; import com.iailab.module.model.mcs.pre.service.*; +import com.iailab.module.model.mcs.pre.vo.MmItemOutputRespVO; +import com.iailab.module.model.mcs.pre.vo.MmPredictAlarmConfigSaveReqVO; import com.iailab.module.model.mcs.pre.vo.MmPredictAlarmMessageSaveReqVO; -import com.iailab.module.model.mcs.sche.entity.StScheduleModelOutEntity; +import com.iailab.module.model.mcs.pre.vo.MmPredictItemRespVO; +import com.iailab.module.model.mcs.sche.entity.StScheduleModelEntity; import com.iailab.module.model.mcs.sche.entity.StScheduleSuggestEntity; -import com.iailab.module.model.mcs.sche.service.StScheduleModelOutService; -import com.iailab.module.model.mcs.sche.service.StScheduleSchemeService; -import com.iailab.module.model.mcs.sche.service.StScheduleSuggestService; +import com.iailab.module.model.mcs.sche.service.*; +import com.iailab.module.model.mcs.sche.vo.StScheduleRecordRespVO; import com.iailab.module.model.mcs.sche.vo.StScheduleSuggestSaveReqVO; +import com.iailab.module.model.mcs.sche.vo.StSuggestOperationRecordReqVO; import com.iailab.module.model.mdk.vo.ItemVO; +import com.iailab.module.model.mpk.service.ChartParamService; import com.iailab.module.model.mpk.service.ChartService; +import com.iailab.module.model.mpk.service.ElectricityPriceSegmentedService; import lombok.extern.slf4j.Slf4j; import org.apache.commons.lang3.StringUtils; import org.springframework.beans.factory.annotation.Autowired; @@ -70,6 +83,9 @@ private MmItemResultJsonService mmItemResultJsonService; @Autowired + private StAdjustResultService stAdjustResultService; + + @Autowired private ChartService chartService; @Autowired @@ -77,6 +93,9 @@ @Autowired private StScheduleSuggestService stScheduleSuggestService; + + @Autowired + private StSuggestSnapshotRecordService stSuggestSnapshotRecordService; @Autowired private PlanItemApi planItemApi; @@ -88,9 +107,34 @@ private StScheduleSchemeService stScheduleSchemeService; @Autowired - private StScheduleModelOutService stScheduleModelOutService; + private StScheduleRecordService stScheduleRecordService; - private int HOUR_MINS = 60; + @Autowired + private ChartParamService chartParamService; + + @Autowired + private InfluxDBService influxDBService; + + @Autowired + private ElectricityPriceSegmentedService electricityPriceSegmentedService; + + @Autowired + private StScheduleModelService stScheduleModelService; + + @Autowired + private StScheduleModelSettingService stScheduleModelSettingService; + + @Autowired + private MmPredictModelService mmPredictModelService; + + @Autowired + private MmModelArithSettingsService mmModelArithSettingsService; + + @Autowired + private StSuggestOperationRecordService stSuggestOperationRecordService; + + @Autowired + private StSuggestSnapshotConfDetService stSuggestSnapshotConfDetService; @Override public List<PredictItemTreeDTO> getPredictItemTree() { @@ -104,12 +148,14 @@ PredictItemTreeDTO moduleOpt = new PredictItemTreeDTO(); moduleOpt.setId(item.getId()); moduleOpt.setLabel(item.getModulename()); + moduleOpt.setDisabled(true); List<PredictItemTreeDTO> children = new ArrayList<>(); List<ItemVO> itemList = mmPredictItemService.getByModuleId(item.getId()); itemList.forEach(item1 -> { PredictItemTreeDTO chd = new PredictItemTreeDTO(); chd.setLabel(item1.getItemName()); chd.setId(item1.getId()); + chd.setDisabled(true); List<PredictItemTreeDTO> chd1 = new ArrayList<>(); List<MmItemOutputEntity> outList = mmItemOutputService.getByItemid(item1.getId()); if (!CollectionUtils.isEmpty(outList)) { @@ -131,112 +177,7 @@ @Override public PreDataBarLineRespVO getPreDataCharts(PreDataBarLineReqVO reqVO) { - PreDataBarLineRespVO result = new PreDataBarLineRespVO(); - List<String> outIds = reqVO.getOutIds(); - List<String> legends = new ArrayList<>(); - List<PreDataViewRespDTO> dataViewList = new ArrayList<>(); - if (CollectionUtils.isEmpty(outIds)) { - return result; - } - Date predictTime = reqVO.getPredictTime(); - if (predictTime == null) { - MmItemOutputEntity output = mmItemOutputService.getOutPutById(reqVO.getOutIds().get(0)); - ItemVO predictItem = mmPredictItemService.getItemByIdFromCache(output.getItemid()); - if (predictItem.getLastTime() != null) { - predictTime = predictItem.getLastTime(); - } else { - Calendar calendar = Calendar.getInstance(); - calendar.set(Calendar.MILLISECOND, 0); - calendar.set(Calendar.SECOND, 0); - predictTime = calendar.getTime(); - } - } - Date startTime = reqVO.getStartTime(); - if (startTime == null) { - Calendar calendar = Calendar.getInstance(); - calendar.setTime(predictTime); - calendar.add(Calendar.HOUR_OF_DAY, -1); - startTime = calendar.getTime(); - } - Date endTime = reqVO.getEndTime(); - if (endTime == null) { - Calendar calendar = Calendar.getInstance(); - calendar.setTime(predictTime); - calendar.add(Calendar.HOUR_OF_DAY, 1); - endTime = calendar.getTime(); - } - - for (int i = 0; i < outIds.size(); i++) { - PreDataViewRespDTO viewDto = new PreDataViewRespDTO(); - String outId = outIds.get(i); - MmItemOutputEntity output = mmItemOutputService.getOutPutById(outId); - if (output == null) { - continue; - } - legends.add(output.getResultName()); - viewDto.setItemId(output.getItemid()); - viewDto.setOutId(outId); - viewDto.setResultstr(output.getResultstr()); - viewDto.setResultName(output.getResultName()); - viewDto.setRealData(getHisData(output.getPointid(), startTime, endTime)); - viewDto.setPreDataN(mmItemResultService.getData(output.getId(), startTime, endTime, DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND)); - viewDto.setPreDataL(mmItemResultLastPointService.getData(output.getId(), startTime, endTime, DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND)); - - List<Double> values = new ArrayList<>(); - if (!CollectionUtils.isEmpty(viewDto.getRealData())) { - List<Double> hisValues = new ArrayList<>(); - viewDto.getRealData().forEach(item -> { - values.add(Double.parseDouble(item[1].toString())); - hisValues.add(Double.parseDouble(item[1].toString())); - }); - viewDto.setHisMax(new BigDecimal(hisValues.stream().mapToDouble(Double::doubleValue).max().getAsDouble()).setScale(2, BigDecimal.ROUND_HALF_UP)); - viewDto.setHisMin(new BigDecimal(hisValues.stream().mapToDouble(Double::doubleValue).min().getAsDouble()).setScale(2, BigDecimal.ROUND_HALF_UP)); - viewDto.setHisAvg(new BigDecimal(hisValues.stream().mapToDouble(Double::doubleValue).average().getAsDouble()).setScale(2, BigDecimal.ROUND_HALF_UP)); - viewDto.setHisCumulant(new BigDecimal(hisValues.stream().mapToDouble(Double::doubleValue).sum()) - .divide(new BigDecimal(HOUR_MINS), 2, BigDecimal.ROUND_HALF_UP)); - } - if (!CollectionUtils.isEmpty(viewDto.getPreDataN())) { - viewDto.getPreDataN().forEach(item -> { - values.add(Double.parseDouble(item[1].toString())); - }); - } - if (!CollectionUtils.isEmpty(viewDto.getPreDataL())) { - List<Double> preValues = new ArrayList<>(); - viewDto.getPreDataL().forEach(item -> { - values.add(Double.parseDouble(item[1].toString())); - preValues.add(Double.parseDouble(item[1].toString())); - }); - viewDto.setPreMax(new BigDecimal(preValues.stream().mapToDouble(Double::doubleValue).max().getAsDouble()).setScale(2, BigDecimal.ROUND_HALF_UP)); - viewDto.setPreMin(new BigDecimal(preValues.stream().mapToDouble(Double::doubleValue).min().getAsDouble()).setScale(2, BigDecimal.ROUND_HALF_UP)); - viewDto.setPreAvg(new BigDecimal(preValues.stream().mapToDouble(Double::doubleValue).average().getAsDouble()).setScale(2, BigDecimal.ROUND_HALF_UP)); - } - if (!CollectionUtils.isEmpty(viewDto.getCurData())) { - List<Double> preValues = new ArrayList<>(); - viewDto.getCurData().forEach(item -> { - values.add(Double.parseDouble(item[1].toString())); - preValues.add(Double.parseDouble(item[1].toString())); - }); - viewDto.setPreCumulant(new BigDecimal(preValues.stream().mapToDouble(Double::doubleValue).sum()) - .divide(new BigDecimal(HOUR_MINS), 2, BigDecimal.ROUND_HALF_UP)); - } - if (!CollectionUtils.isEmpty(viewDto.getAdjData())) { - viewDto.getAdjData().forEach(item -> { - values.add(Double.parseDouble(item[1].toString())); - }); - } - if (!CollectionUtils.isEmpty(values)) { - viewDto.setMaxValue(new BigDecimal(values.stream().mapToDouble(Double::doubleValue).max().getAsDouble()).setScale(2, BigDecimal.ROUND_HALF_UP)); - viewDto.setMinValue(new BigDecimal(values.stream().mapToDouble(Double::doubleValue).min().getAsDouble()).setScale(2, BigDecimal.ROUND_HALF_UP)); - } - dataViewList.add(viewDto); - } - result.setStartTime(startTime); - result.setEndTime(endTime); - result.setPredictTime(predictTime); - result.setCategories(DateUtils.getTimeScale(startTime, endTime, 60)); - result.setLegend(legends); - result.setDataViewList(dataViewList); - return result; + return mmItemResultService.getPreDataCharts(reqVO); } @Override @@ -254,20 +195,20 @@ if (startTime == null) { Calendar calendar = Calendar.getInstance(); calendar.setTime(predictItem.getLastTime()); - calendar.add(Calendar.MINUTE, -1 * predictItem.getPredictLength()); + calendar.add(Calendar.SECOND, -1 * predictItem.getPredictLength() * predictItem.getGranularity()); startTime = calendar.getTime(); } Date endTime = reqVO.getEndTime(); if (endTime == null) { Calendar calendar = Calendar.getInstance(); calendar.setTime(predictItem.getLastTime()); - calendar.add(Calendar.MINUTE, predictItem.getPredictLength()); + calendar.add(Calendar.SECOND, predictItem.getPredictLength() * predictItem.getGranularity()); endTime = calendar.getTime(); } if (endTime.getTime() <= startTime.getTime()) { Calendar calendar = Calendar.getInstance(); calendar.setTime(startTime); - calendar.add(Calendar.MINUTE, predictItem.getPredictLength()); + calendar.add(Calendar.SECOND, predictItem.getPredictLength() * predictItem.getGranularity()); endTime = calendar.getTime(); } @@ -282,9 +223,20 @@ legend.add(out.getResultName()); PreDataSampleViewRespDTO viewDto = new PreDataSampleViewRespDTO(); if (StringUtils.isNotBlank(out.getPointid())) { - viewDto.setRealData(getHisData(out.getPointid(), startTime, endTime)); + viewDto.setRealData(getHisData(out.getPointid(), startTime, endTime, reqVO.getPrec())); } viewDto.setPreDataN(mmItemResultService.getData(out.getId(), startTime, endTime, DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND)); + viewDto.setPreDataL(mmItemResultLastPointService.getData(out.getId(), startTime, endTime, DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND, 3)); + //处理预测累计 + if (out.getIscumulant() == 1) { + if (StringUtils.isNotBlank(out.getCumulpoint())) { + viewDto.setCumulantRealData(getHisData(out.getCumulpoint(), startTime, endTime, reqVO.getPrec())); + } + viewDto.setCumulantPreData(mmItemResultService.getData(out.getId() + CommonDict.CUMULANT_SUFFIX, startTime, endTime, DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND)); + } + // 调整预测值 + viewDto.setAdjData(stAdjustResultService.getData(out.getId(), predictItem.getLastTime(), DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND)); + viewMap.put(out.getResultName(), viewDto); } result.setStartTime(startTime); @@ -294,6 +246,7 @@ result.setViewMap(viewMap); return result; } + @Override public PreDataSingleChartRespVO getPreDataSingleChart(PreDataSingleChartReqVO reqVO) { @@ -319,12 +272,13 @@ } String timeFormat = StringUtils.isBlank(reqVO.getTimeFormat()) ? DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND : reqVO.getTimeFormat(); PreLineTypeEnum lineType = chartParams.get(CommonConstant.LINE_TYPE) == null ? PreLineTypeEnum.TN : PreLineTypeEnum.getEumByCode(chartParams.get(CommonConstant.LINE_TYPE)); - BigDecimal rangeH = chartParams.get(CommonConstant.RANGE_H) == null ? BigDecimal.ZERO : new BigDecimal(chartParams.get(CommonConstant.RANGE_H)); - BigDecimal rangeL = chartParams.get(CommonConstant.RANGE_L) == null ? BigDecimal.ZERO : new BigDecimal(chartParams.get(CommonConstant.RANGE_L)); - BigDecimal limitH = chartParams.get(CommonConstant.LIMIT_H) == null ? BigDecimal.ZERO : new BigDecimal(chartParams.get(CommonConstant.LIMIT_H)); - BigDecimal limitL = chartParams.get(CommonConstant.LIMIT_L) == null ? BigDecimal.ZERO : new BigDecimal(chartParams.get(CommonConstant.LIMIT_L)); + BigDecimal rangeH = chartParams.get(CommonConstant.RANGE_H) == null ? null : new BigDecimal(chartParams.get(CommonConstant.RANGE_H)); + BigDecimal rangeL = chartParams.get(CommonConstant.RANGE_L) == null ? null : new BigDecimal(chartParams.get(CommonConstant.RANGE_L)); + BigDecimal limitH = chartParams.get(CommonConstant.LIMIT_H) == null ? null : new BigDecimal(chartParams.get(CommonConstant.LIMIT_H)); + BigDecimal limitL = chartParams.get(CommonConstant.LIMIT_L) == null ? null : new BigDecimal(chartParams.get(CommonConstant.LIMIT_L)); int lengthLeft = chartParams.get(CommonConstant.LENGTH_LEFT) == null ? predictItem.getPredictLength() : new BigDecimal(chartParams.get(CommonConstant.LENGTH_LEFT)).intValue(); int lengthRight = chartParams.get(CommonConstant.LENGTH_RIGHT) == null ? predictItem.getPredictLength() : new BigDecimal(chartParams.get(CommonConstant.LENGTH_RIGHT)).intValue(); + int decimalPlaces = chartParams.get(CommonConstant.DECIMAL_PLACES) == null ? 3 : new BigDecimal(chartParams.get(CommonConstant.DECIMAL_PLACES)).intValue(); Date[] timeArray = calResultTime(predictItem, reqVO.getStartTime(), reqVO.getEndTime(), lengthLeft, lengthRight); Date predictTime = timeArray[0]; @@ -342,30 +296,111 @@ dataView.setRangeL(rangeL); dataView.setLimitH(limitH); dataView.setLimitL(limitL); + + Map<String, Object> realDataMap = new HashMap<>(); if (StringUtils.isNotBlank(outPut.getPointid())) { - dataView.setRealData(getHisData(outPut.getPointid(), startTime, endTime, timeFormat)); + dataView.setRealData(getHisData(outPut.getPointid(), startTime, endTime, timeFormat, decimalPlaces)); + dataView.getRealData().forEach(item -> { + realDataMap.put(item[0].toString(), item[1]); + }); } else { dataView.setRealData(new ArrayList<>()); } - dataView.setCurData(mmItemResultJsonService.getData(outPut.getId(), predictTime, timeFormat)); + if (!CollectionUtils.isEmpty(realDataMap)) { + Object curReal = realDataMap.get(DateUtils.format(predictTime, timeFormat)) == null ? + dataView.getRealData().get(dataView.getRealData().size() - 1) : realDataMap.get(DateUtils.format(predictTime, timeFormat)); + // 当前值T0 + 当前预测值 20250409 + dataView.setCurData(mmItemResultJsonService.getData(outPut.getId(), predictTime, timeFormat, decimalPlaces, true, curReal)); + } else { + dataView.setCurData(mmItemResultJsonService.getData(outPut.getId(), predictTime, timeFormat, decimalPlaces)); + } + + // 调整预测值 + dataView.setAdjData(stAdjustResultService.getData(outPut.getId(), predictTime, timeFormat, decimalPlaces)); + dataView.setLineType(lineType.getCode()); switch (lineType) { case TN: - dataView.setPreDataN(mmItemResultService.getData(outPut.getId(), startTime, endTime, timeFormat)); + dataView.setPreDataN(mmItemResultService.getData(outPut.getId(), startTime, endTime, timeFormat, decimalPlaces)); break; case TL: - dataView.setPreDataN(mmItemResultService.getData(outPut.getId(), predictTime, endTime, timeFormat)); - dataView.setPreDataL(mmItemResultLastPointService.getData(outPut.getId(), startTime, endTime, timeFormat)); + dataView.setPreDataN(mmItemResultService.getData(outPut.getId(), startTime, endTime, timeFormat, decimalPlaces)); + dataView.setPreDataL(mmItemResultLastPointService.getData(outPut.getId(), startTime, endTime, timeFormat, decimalPlaces)); break; default: break; } + //处理预测累计 + if (outPut.getIscumulant() != null && outPut.getIscumulant() == 1) { + /*if (StringUtils.isNotBlank(outPut.getCumulpoint())) { + dataView.setCumulantRealData(getHisData(outPut.getCumulpoint(), startTime, endTime)); + }*/ + List<Object[]> cumulantPreList = mmItemResultService.getData(outPut.getId() + CommonDict.CUMULANT_SUFFIX, startTime, endTime, DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND); + dataView.setCumulantPreData(cumulantPreList); + if (!CollectionUtils.isEmpty(cumulantPreList)) { + dataView.setCumulantPreLast(new BigDecimal(cumulantPreList.get(cumulantPreList.size() - 1)[1].toString()).setScale(2, BigDecimal.ROUND_HALF_UP)); + } + } + + if (!CollectionUtils.isEmpty(dataView.getRealData())) { + Object[] rdo = dataView.getRealData().get(dataView.getRealData().size() - 1); + dataView.setCurrValue(new BigDecimal(rdo[1].toString())); + } + if (!CollectionUtils.isEmpty(dataView.getCurData())) { List<Double> curList = dataView.getCurData().stream().map(t -> { - return new Double(t[1].toString()); - }).collect(Collectors.toList()); - dataView.setPreMax(new BigDecimal(curList.stream().mapToDouble(Double::doubleValue).max().getAsDouble()).setScale(2, BigDecimal.ROUND_HALF_UP)); - dataView.setPreMin(new BigDecimal(curList.stream().mapToDouble(Double::doubleValue).min().getAsDouble()).setScale(2, BigDecimal.ROUND_HALF_UP)); + try { + return new Double(t[1].toString()); + } catch (NumberFormatException e) { + return null; + } + }).filter(Objects::nonNull).collect(Collectors.toList()); + if (!curList.isEmpty()) { + dataView.setPreMax(new BigDecimal(curList.stream().mapToDouble(Double::doubleValue).max().getAsDouble()).setScale(2, BigDecimal.ROUND_HALF_UP)); + dataView.setPreMin(new BigDecimal(curList.stream().mapToDouble(Double::doubleValue).min().getAsDouble()).setScale(2, BigDecimal.ROUND_HALF_UP)); + dataView.setPreLast(new BigDecimal(curList.get(curList.size() - 1)).setScale(2, BigDecimal.ROUND_HALF_UP)); + dataView.setPreCumulant(new BigDecimal(curList.stream().mapToDouble(Double::doubleValue).sum()).setScale(2, BigDecimal.ROUND_HALF_UP)); + } else { + dataView.setPreMax(null); + dataView.setPreMin(null); + dataView.setPreLast(null); + dataView.setPreCumulant(null); + } + } + + String alarmObj = chartParams.get(CommonConstant.ALARM_OBJ); + if (StringUtils.isNotBlank(alarmObj)) { + String alarmTitle = chartParams.get(CommonConstant.ALARM_TITLE); + List<AlarmMessageRespDTO> alarmList = ConvertUtils.sourceToTarget(mmPredictAlarmMessageService.getList(alarmObj, predictTime, alarmTitle), AlarmMessageRespDTO.class); + dataView.setAlarmList(alarmList); + if (CollectionUtils.isEmpty(alarmList)) { + dataView.setAlarmMessage("暂无预警信息"); + } else { + dataView.setAlarmMessage(alarmList.get(0).getContent()); + } + } + + try { + String adjValuePoint = chartParams.get(CommonConstant.ADJ_VALUE_POINT); + if (StringUtils.isNotBlank(adjValuePoint)) { + List<String> pointNos = new ArrayList<>(); + pointNos.add(adjValuePoint); + Map<String, Object> adjValue = dataPointApi.queryPointsRealValue(pointNos); + dataView.setAdjValue(new BigDecimal(adjValue.get(adjValuePoint).toString())); + } + + String adjValueArrPoint = chartParams.get(CommonConstant.ADJ_VALUE_ARR_POINT); + if (StringUtils.isNotBlank(adjValueArrPoint)) { + String[] adjPointArr = adjValueArrPoint.split(","); + Map<String, Object> adjValue = dataPointApi.queryPointsRealValue(Arrays.asList(adjPointArr)); + BigDecimal[] adjValueArr = new BigDecimal[adjPointArr.length]; + for (int i = 0; i < adjPointArr.length; i++) { + adjValueArr[i] = new BigDecimal(adjValue.get(adjPointArr[i]).toString()); + } + dataView.setAdjValueArr(adjValueArr); + } + } catch (Exception ex) { + ex.printStackTrace(); } result.setPredictTime(predictTime); @@ -445,10 +480,14 @@ * @param pointId * @param startTime * @param endTime + * @param prec * @return */ - private List<Object[]> getHisData(String pointId, Date startTime, Date endTime) { + private List<Object[]> getHisData(String pointId, Date startTime, Date endTime, Integer prec) { List<Object[]> result = new ArrayList<>(); + if (StringUtils.isBlank(pointId)) { + return result; + } ApiPointDTO pointDTO = dataPointApi.getInfoById(pointId); ApiPointValueQueryDTO queryPointDto = new ApiPointValueQueryDTO(); queryPointDto.setPointNo(pointDTO.getPointNo()); @@ -458,10 +497,17 @@ if (CollectionUtils.isEmpty(valueDTOS)) { return result; } + int defaultPrec = 3; valueDTOS.forEach(item -> { Object[] values = new Object[2]; values[0] = DateUtils.format(item.getT(), DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND); - values[1] = new BigDecimal(item.getV()).setScale(2, BigDecimal.ROUND_HALF_UP); + if (prec != null && prec < 0) { + values[1] = item.getV(); + } else if (prec != null && prec > 0) { + values[1] = new BigDecimal(item.getV()).setScale(prec, BigDecimal.ROUND_HALF_UP); + } else { + values[1] = new BigDecimal(item.getV()).setScale(defaultPrec, BigDecimal.ROUND_HALF_UP); + } result.add(values); }); return result; @@ -490,7 +536,36 @@ valueDTOS.forEach(item -> { Object[] values = new Object[2]; values[0] = DateUtils.format(item.getT(), timeFormat); - values[1] = new BigDecimal(item.getV()).setScale(2, BigDecimal.ROUND_HALF_UP); + values[1] = new BigDecimal(item.getV()).setScale(3, BigDecimal.ROUND_HALF_UP); + result.add(values); + }); + return result; + } + + /** + * 获取真实值 + * + * @param pointId + * @param startTime + * @param endTime + * @param timeFormat + * @return + */ + private List<Object[]> getHisData(String pointId, Date startTime, Date endTime, String timeFormat, int decimalPlaces) { + List<Object[]> result = new ArrayList<>(); + ApiPointDTO pointDTO = dataPointApi.getInfoById(pointId); + ApiPointValueQueryDTO queryPointDto = new ApiPointValueQueryDTO(); + queryPointDto.setPointNo(pointDTO.getPointNo()); + queryPointDto.setStart(startTime); + queryPointDto.setEnd(endTime); + List<ApiPointValueDTO> valueDTOS = dataPointApi.queryPointHistoryValue(queryPointDto); + if (CollectionUtils.isEmpty(valueDTOS)) { + return result; + } + valueDTOS.forEach(item -> { + Object[] values = new Object[2]; + values[0] = DateUtils.format(item.getT(), timeFormat); + values[1] = new BigDecimal(item.getV()).setScale(decimalPlaces, BigDecimal.ROUND_HALF_UP); result.add(values); }); return result; @@ -530,13 +605,17 @@ @Override public Boolean createScheduleSuggest(ScheduleSuggestRespDTO dto) { + String suggestId = UUID.randomUUID().toString(); + dto.setId(suggestId); stScheduleSuggestService.create(ConvertUtils.sourceToTarget(dto, StScheduleSuggestSaveReqVO.class)); + // 根据建议产生快照 + stSuggestSnapshotRecordService.createSnapshotRecord(dto.getModelId(),dto.getScheduleObj(),dto.getScheduleTime(),suggestId); return true; } @Override - public List<ScheduleSuggestRespDTO> listScheduleSuggest(Map<String, Object> params) { - return Collections.emptyList(); + public List<ScheduleSuggestRespDTO> listScheduleSuggest(ScheduleSuggestReqDTO vo) { + return stScheduleSuggestService.list(vo); } @Override @@ -556,101 +635,330 @@ } @Override - public List<StScheduleSchemeDTO> listScheduleScheme(Map<String, Object> params) { + public List<StScheduleSchemeDTO> listScheduleScheme(String triggerMethod, String triggerCondition) { + Map<String, Object> params = new HashMap<>(); + params.put("triggerMethod", triggerMethod); + params.put("triggerCondition", triggerCondition); return stScheduleSchemeService.list(params); } @Override - public Boolean scheduleModelOut(MdkScheduleRespDTO dto) { - String modelId = stScheduleSchemeService.getByCode(dto.getScheduleCode()).getModelId(); - Map<String,Object> result = dto.getResult(); - List<StScheduleModelOutDTO> list = stScheduleModelOutService.list(modelId); - try{ - list.forEach( - item -> { - double value = 0; - //判断点位是否下发以及返回结果是否存在 - if(item.getIsWrite()==1){ - if(result.get(item.getResultKey())==null){ - log.error(result.get(item.getResultKey()) + "resultKey匹配失败"); - } - Object resultValue = result.get(item.getResultKey()); - //判断解析方式 - if(item.getResultType().equals("double")){ - if(resultValue instanceof Double) { - value = (Double) resultValue; - } - }else if(item.getResultType().equals("double[]")){ - ArrayList<Double> doubleList = (ArrayList<Double>) resultValue; - double[] array = new double[doubleList.size()]; - for (int i = 0; i < doubleList.size(); i++) { - array[i] = doubleList.get(i); - } - if(array!= null && item.getResultPort() < array.length){ - value = array[item.getResultPort()]; - }else{ - log.error(result.get(item.getResultKey()) + "下角标超限"); - } + public List<ChartParamDTO> getChartParamList(String chartCode) { + if (StringUtils.isBlank(chartCode)) { + return null; + } + return chartParamService.list(chartCode); + } - }else if(item.getResultType().equals("double[][]")){ - if (item.getResultType().equals("double[][]")) { - if (resultValue instanceof ArrayList) { - ArrayList<ArrayList<Double>> doubleListList = (ArrayList<ArrayList<Double>>) resultValue; - double[][] array = new double[doubleListList.size()][]; - for (int i = 0; i < doubleListList.size(); i++) { - ArrayList<Double> doubleList = doubleListList.get(i); - array[i] = new double[doubleList.size()]; - for (int j = 0; j < doubleList.size(); j++) { - array[i][j] = doubleList.get(j); - } - } - if (array != null && item.getResultPort() < array.length && item.getResultIndex() < array[item.getResultPort()].length) { - value = array[item.getResultPort()][item.getResultIndex()]; - } else { - log.error(result.get(item.getResultKey()) + "下标超限"); - } - } - } - } - //下发到point点位 - ApiPointValueWriteDTO ApiPointValueWriteDTO = new ApiPointValueWriteDTO(); - ApiPointValueWriteDTO.setPointNo(item.getPointNo()); - ApiPointValueWriteDTO.setValue(value); - if (!dataPointApi.writePointRealValue(ApiPointValueWriteDTO)) { - log.error(result.get(item.getResultKey()) + "下发数据异常"); - } + @Override + public PageResult<StAlarmAndSuggestRespVO> getAlarmAndSuggestPage(StAlarmAndSuggestPageReqVO reqVO) { + return stScheduleSchemeService.getAlarmAndSuggestPage(reqVO); + } + @Override + public Map<String, Map<String, Double>> getPreDoubleData(PreDoubleDataReqVO reqVO) { + List<MmPredictItemRespVO> doubleItemOutPuts = mmPredictItemService.getDoubleOutPutsByItemNos(reqVO.getItemNos()); + + //<itemNo,<resultStr,double>> + Map<String, Map<String, Double>> result = new HashMap<>(reqVO.getItemNos().size()); + + for (MmPredictItemRespVO mmPredictItemRespVO : doubleItemOutPuts) { + List<String> outPutIds = mmPredictItemRespVO.getOutPuts().stream().map(MmItemOutputRespVO::getId).collect(Collectors.toList()); + InfluxModelResultByOutPutIdsPOJO pojo = new InfluxModelResultByOutPutIdsPOJO(); + pojo.setOutPutIds(outPutIds); + pojo.setType(DataTypeEnum.FLOAT.getCode()); + + // 查询时间加1粒度 + Calendar lastTime = Calendar.getInstance(); + lastTime.setTime(mmPredictItemRespVO.getLastTime()); + if (mmPredictItemRespVO.getGranularity() < PredGranularityEnum.D1.getCode()) { + // 如果小于天粒度,则从下个时间粒度开始 + lastTime.add(Calendar.SECOND, mmPredictItemRespVO.getGranularity()); + } + + Map<String, List<InfluxModelResultVO>> outPutIdDoubles = influxDBService.queryModelResultsByOutPutIds(pojo, lastTime.getTime(), lastTime.getTime()); + Map<String, Double> outPutIdDouble = new HashMap<>(outPutIds.size()); + for (MmItemOutputRespVO outPut : mmPredictItemRespVO.getOutPuts()) { + String outPutId = outPut.getId(); + if (outPutIdDoubles.containsKey(outPutId)) { + List<InfluxModelResultVO> influxModelResultVOS = outPutIdDoubles.get(outPutId); + if (!CollectionUtils.isEmpty(influxModelResultVOS)) { + outPutIdDouble.put(outPut.getResultstr(), Double.valueOf(influxModelResultVOS.get(0).getValue().toString())); } } - ); - }catch (Exception ex){ - log.error("下发数据异常"); - ex.printStackTrace(); + } + result.put(mmPredictItemRespVO.getItemno(), outPutIdDouble); } + return result; + } + + @Override + public Map<String, BigDecimal> getPredictLastValue(PredictLastValueReqVO reqVO) { + Map<String, BigDecimal> result = new HashMap<>(reqVO.getItemNos().size()); + if (CollectionUtils.isEmpty(reqVO.getItemNos())) { + return result; + } + List<String[]> itemNos = reqVO.getItemNos(); + for (String[] itemNo : itemNos) { + String key = itemNo[0] + "_" + itemNo[1] + "_" + itemNo[2]; + ItemVO predictItem = mmPredictItemService.getItemByItemNo(itemNo[0]); + if (predictItem == null || predictItem.getLastTime() == null) { + result.put(key, BigDecimal.ZERO); + } + MmItemOutputEntity outPut = mmItemOutputService.getByItemid(predictItem.getId(), itemNo[1], itemNo[2]); + String outputId = outPut.getId(); + // 判断是否有第五个参数,如果有第5个参数为1,则取累计值 + if (itemNo.length >= 5) { + if (StringUtils.isNotBlank(itemNo[4]) && "1".equals(itemNo[4])) { + outputId = outPut.getId() + CommonDict.CUMULANT_SUFFIX; + } + } + Date predictTime = predictItem.getLastTime(); + List<Object[]> curData = mmItemResultJsonService.getData(outputId, predictTime, DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND); + if (CollectionUtils.isEmpty(curData)) { + result.put(key, BigDecimal.ZERO); + } else { + result.put(key, new BigDecimal(curData.get(curData.size() - 1)[1].toString())); + } + } + return result; + } + + @Override + public Map<String, BigDecimal> getPredictValueByTime(PredictLastValueReqVO reqVO) { + Map<String, BigDecimal> result = new HashMap<>(reqVO.getItemNos().size()); + if (CollectionUtils.isEmpty(reqVO.getItemNos())) { + return result; + } + List<String[]> itemNos = reqVO.getItemNos(); + for (String[] itemNo : itemNos) { + String key = itemNo[0] + "," + itemNo[1] + "," + itemNo[2]; + ItemVO predictItem = mmPredictItemService.getItemByItemNo(itemNo[0]); + if (predictItem == null || predictItem.getLastTime() == null) { + result.put(key, BigDecimal.ZERO); + } + MmItemOutputEntity outPut = mmItemOutputService.getByItemid(predictItem.getId(), itemNo[1], itemNo[2]); + List<Object[]> curData = mmItemResultJsonService.getData(outPut.getId(), reqVO.getPredictTime(), DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND); + if (CollectionUtils.isEmpty(curData)) { + result.put(key, BigDecimal.ZERO); + } else { + result.put(key, new BigDecimal(curData.get(curData.size() - 1)[1].toString())); + } + } + return result; + } + + @Override + public List<StScheduleRecordVO> getLastScheduleData(String scheduleCode, Integer limit) { + if (StringUtils.isBlank(scheduleCode)) { + return null; + } + return stScheduleRecordService.getLastScheduleResult(scheduleCode, limit); + } + + @Override + public Map<String, List<Object[]>> getPredictDataItemNo(PreDataItemNoReqVO reqVO) { + if (StringUtils.isBlank(reqVO.getItemNo())) { + return new HashMap<>(); + } + ItemVO predictItem = mmPredictItemService.getItemByItemNo(reqVO.getItemNo()); + if (null == predictItem) { + return new HashMap<>(); + } + + // 默认开始时间:运行时间 + if (null == reqVO.getStartTime()) { + reqVO.setStartTime(predictItem.getLastTime()); + } + // 默认结束时间:运行时间+预测长度*粒度 + if (null == reqVO.getEndTime()) { + Calendar calendar = Calendar.getInstance(); + calendar.setTime(predictItem.getLastTime()); + calendar.add(Calendar.SECOND, predictItem.getPredictLength() * predictItem.getGranularity()); + reqVO.setEndTime(calendar.getTime()); + } + + List<String> itemNos = new ArrayList<String>() {{ + add(reqVO.getItemNo()); + }}; + List<MmPredictItemRespVO> ItemRespVOs = mmPredictItemService.getArrayOutPutsByItemNos(itemNos); + if (CollectionUtils.isEmpty(ItemRespVOs)) { + return new HashMap<>(); + } + List<MmItemOutputRespVO> outPuts = ItemRespVOs.get(0).getOutPuts(); + if (CollectionUtils.isEmpty(outPuts)) { + return new HashMap<>(); + } + + InfluxModelResultByOutPutIdsPOJO pojo = new InfluxModelResultByOutPutIdsPOJO(); + pojo.setOutPutIds(outPuts.stream().map(MmItemOutputRespVO::getId).collect(Collectors.toList())); + pojo.setType(DataTypeEnum.FLOAT.getCode()); + Map<String, List<InfluxModelResultVO>> outPutDatas = influxDBService.queryModelResultsByOutPutIds(pojo, reqVO.getStartTime(), reqVO.getEndTime()); + Map<String, List<Object[]>> result = new HashMap<>(outPuts.size()); + for (MmItemOutputRespVO outPut : outPuts) { + String outPutId = outPut.getId(); + if (outPutDatas.containsKey(outPutId)) { + List<InfluxModelResultVO> influxModelResultVOS = outPutDatas.get(outPutId); + result.put(null == outPut.getResultIndex() ? outPut.getResultstr() : outPut.getResultstr() + "_" + outPut.getResultIndex(), influxModelResultVOS.stream().map(e -> { + Object[] values = new Object[2]; + values[0] = DateUtils.format(Date.from(e.getTimestamp()), DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND); + values[1] = Double.valueOf(e.getValue().toString()); + return values; + }).collect(Collectors.toList())); + } + } + return result; + } + + @Override + public List<ElectricityPriceSegmentedDTO> getElectricityPriceList(String year, String time) { + return electricityPriceSegmentedService.getElectricityPriceList(year, time); + } + + @Override + public Boolean createElectricityPrice(List<ElectricityPriceSegmentedDTO> list) { + electricityPriceSegmentedService.deleteByITimeId(list.get(0).getITimeId()); + list.forEach(dto -> electricityPriceSegmentedService.create(dto)); return true; + } + + @Override + public Boolean updateScheduleModelSetting(String modelCode, String key, String value) { + StScheduleModelEntity model = stScheduleModelService.getByModelCode(modelCode); + stScheduleModelSettingService.updateByModelIdAndKey(model.getId(), key, value); + return true; + } + + @Override + public Boolean updateAlarmConfig(String alarmObj, String upperLimit, String lowerLimit) { + MmPredictAlarmConfigSaveReqVO reqVO = new MmPredictAlarmConfigSaveReqVO(); + reqVO.setAlarmObj(alarmObj); + reqVO.setUpperLimit(BigDecimal.valueOf(Double.parseDouble(upperLimit))); + reqVO.setLowerLimit(BigDecimal.valueOf(Double.parseDouble(lowerLimit))); + mmPredictAlarmConfigService.updateByAlarmObj(reqVO); + return true; + } + + @Override + public Boolean updateChartParam(ChartDTO chartDTO) { + ChartDTO oldChartDTO = chartService.getChartByChartCode(chartDTO.getChartCode()); + List<ChartParamDTO> chartParams = chartDTO.getChartParams(); + chartParams.forEach(item -> { + item.setChartId(oldChartDTO.getId()); + }); + chartParamService.updateByChartIdAndParamCode(chartParams); + return true; + } + + @Override + public MmItemOutputDTO getItemOutputByItemid(String itemid, String resultstr, String resultIndex) { + return ConvertUtils.sourceToTarget(mmItemOutputService.getByItemid(itemid, resultstr, resultIndex), MmItemOutputDTO.class); + } + + @Override + public List<Object[]> getItemResult(PreItemResultReqVO reqVO) { + + return mmItemResultService.getData(reqVO.getOutputid(), reqVO.getStartTime(), reqVO.getEndTime(), reqVO.getTimeFormat()); + } + + @Override + public PredictItemVO getPredictItemByItemNo(String itemNo) { + return ConvertUtils.sourceToTarget(mmPredictItemService.getItemByItemNo(itemNo), PredictItemVO.class); + } + + @Override + public List<Object[]> getItemResultLastPoint(PreItemResultReqVO reqVO) { + return mmItemResultLastPointService.getData(reqVO.getOutputid(), reqVO.getStartTime(), reqVO.getEndTime(), reqVO.getTimeFormat()); + } + + @Override + public Boolean useSuggest(StAlarmAndSuggestReqVO reqVO) { + return stScheduleSuggestService.useSuggest(reqVO); + } + + @Override + public Boolean cancelUseSuggest(StAlarmAndSuggestReqVO reqVO) { + return stScheduleSuggestService.cancelUseSuggest(reqVO); + } + + @Override + public Boolean ignoreSuggest(StAlarmAndSuggestReqVO reqVO) { + return stScheduleSuggestService.ignoreSuggest(reqVO); + } + + @Override + public List<ScheduleSuggestRespDTO> getLastSuggest(Map<String, Object> params) { + return stScheduleSuggestService.getLastSuggest(params); + } + + @Override + public Boolean updatePredictModelSetting(String modelCode, String key, String value) { + MmPredictModelEntity model = mmPredictModelService.getByModelCode(modelCode); + mmModelArithSettingsService.updateByModelIdAndKey(model.getId(), key, value); + return true; + } + + @Override + public Boolean saveSuggestOperationRecord(SuggestOperationRecordReqVO reqVO) { + StSuggestOperationRecordReqVO operationRecordVo = new StSuggestOperationRecordReqVO(); + operationRecordVo.setSuggestId(reqVO.getId()); + operationRecordVo.setOperate(reqVO.getOperate()); + operationRecordVo.setReason(reqVO.getReason()); + operationRecordVo.setHandler(reqVO.getHandler()); + operationRecordVo.setHandlerId(reqVO.getHandlerId()); + //获取建议信息 + StScheduleSuggestEntity entity = stScheduleSuggestService.getInfo(reqVO.getId()); + if (entity != null){ + operationRecordVo.setTitle(entity.getTitle()); + operationRecordVo.setContent(entity.getContent()); + operationRecordVo.setScheduleObj(entity.getScheduleObj()); + if (StringUtils.isNotBlank(entity.getModelId())){ + //获取模型记录信息 + StScheduleRecordRespVO scheduleRecordVO = stScheduleRecordService.getInfoByModelIdAndScheduleTime(entity.getModelId(), entity.getScheduleTime()); + operationRecordVo.setSchemeId(scheduleRecordVO.getSchemeId()); + operationRecordVo.setModelId(entity.getModelId()); + operationRecordVo.setModelName(scheduleRecordVO.getModelName()); + operationRecordVo.setScheduleTime(entity.getScheduleTime()); + operationRecordVo.setResultCode(scheduleRecordVO.getResultCode()); + operationRecordVo.setResultData(scheduleRecordVO.getResultData()); + } + } + stSuggestOperationRecordService.create(operationRecordVo); + return true; + } + + @Override + public List<StSuggestSnapshotRecordRespVO> getSuggestSnapshotAllChartData(String suggestId) { + return stSuggestSnapshotRecordService.getAllChartData(suggestId); + } + + @Override + public Boolean updateSuggestSnapshotConfDetByExt1(StSuggestSnapshotConfDetSaveReqVO updateReqVO) { + return stSuggestSnapshotConfDetService.updateByExt1(updateReqVO); } private Date[] calResultTime(ItemVO predictItem, Date startTimeReq, Date endTimeReq, int lengthLeft, int lengthRight) { Date[] result = new Date[3]; Date predictTime = predictItem.getLastTime(); + Integer granularity = predictItem.getGranularity(); Date startTime = startTimeReq; if (startTime == null) { Calendar calendar = Calendar.getInstance(); calendar.setTime(predictItem.getLastTime()); - calendar.add(Calendar.MINUTE, -1 * lengthLeft); + calendar.add(Calendar.SECOND, -1 * lengthLeft * granularity); startTime = calendar.getTime(); } Date endTime = endTimeReq; if (endTime == null) { Calendar calendar = Calendar.getInstance(); calendar.setTime(predictItem.getLastTime()); - calendar.add(Calendar.MINUTE, lengthRight); + calendar.add(Calendar.SECOND, lengthRight * granularity); endTime = calendar.getTime(); } if (endTime.getTime() <= startTime.getTime()) { Calendar calendar = Calendar.getInstance(); calendar.setTime(startTime); - calendar.add(Calendar.MINUTE, lengthRight); + calendar.add(Calendar.SECOND, lengthRight * granularity); endTime = calendar.getTime(); } result[0] = predictTime; -- Gitblit v1.9.3