From 5c2fc8b317e17d0b194f27937bd9d2af8961502f Mon Sep 17 00:00:00 2001
From: dongyukun <1208714201@qq.com>
Date: 星期五, 24 一月 2025 15:06:55 +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 |  282 +++++++++++++++++++++++++++++++++++++++++---------------
 1 files changed, 205 insertions(+), 77 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 129b8da..02601f8 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,32 @@
 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.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.service.*;
+import com.iailab.module.model.mcs.pre.vo.MmItemOutputRespVO;
 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.StScheduleSuggestEntity;
-import com.iailab.module.model.mcs.sche.service.StScheduleModelOutService;
+import com.iailab.module.model.mcs.sche.service.StScheduleRecordService;
 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.vo.StScheduleSuggestSaveReqVO;
 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;
@@ -88,7 +96,16 @@
     private StScheduleSchemeService stScheduleSchemeService;
 
     @Autowired
-    private StScheduleModelOutService stScheduleModelOutService;
+    private StScheduleRecordService stScheduleRecordService;
+
+    @Autowired
+    private ChartParamService chartParamService;
+
+    @Autowired
+    private InfluxDBService influxDBService;
+
+    @Autowired
+    private ElectricityPriceSegmentedService electricityPriceSegmentedService;
 
     private int HOUR_MINS = 60;
 
@@ -140,7 +157,13 @@
         }
         Date predictTime = reqVO.getPredictTime();
         if (predictTime == null) {
-            MmItemOutputEntity output = mmItemOutputService.getOutPutById(reqVO.getOutIds().get(0));
+            MmItemOutputEntity output = null;
+            for (String outId : outIds) {
+                output = mmItemOutputService.getOutPutById(outId);
+                if (output != null) {
+                    break;
+                }
+            }
             ItemVO predictItem = mmPredictItemService.getItemByIdFromCache(output.getItemid());
             if (predictItem.getLastTime() != null) {
                 predictTime = predictItem.getLastTime();
@@ -254,20 +277,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();
         }
 
@@ -319,10 +342,10 @@
         }
         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();
 
@@ -348,6 +371,7 @@
             dataView.setRealData(new ArrayList<>());
         }
         dataView.setCurData(mmItemResultJsonService.getData(outPut.getId(), predictTime, timeFormat));
+        dataView.setLineType(lineType.getCode());
         switch (lineType) {
             case TN:
                 dataView.setPreDataN(mmItemResultService.getData(outPut.getId(), startTime, endTime, timeFormat));
@@ -359,6 +383,10 @@
             default:
                 break;
         }
+        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 -> {
@@ -366,6 +394,19 @@
             }).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));
+            dataView.setPreLast(new BigDecimal(curList.get(curList.size() - 1)));
+            dataView.setPreCumulant(new BigDecimal(curList.stream().mapToDouble(Double::doubleValue).sum()));
+        }
+
+        String alarmObj = chartParams.get(CommonConstant.ALARM_OBJ);
+        if (StringUtils.isNotBlank(alarmObj)) {
+            List<AlarmMessageRespDTO> alarmList = ConvertUtils.sourceToTarget(mmPredictAlarmMessageService.getList(alarmObj, predictTime), AlarmMessageRespDTO.class);
+            dataView.setAlarmList(alarmList);
+            if (CollectionUtils.isEmpty(alarmList)) {
+                dataView.setAlarmMessage("暂无预警信息");
+            } else {
+                dataView.setAlarmMessage(alarmList.get(0).getContent());
+            }
         }
 
         result.setPredictTime(predictTime);
@@ -564,96 +605,183 @@
     }
 
     @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());
+            Map<String, List<InfluxModelResultVO>> outPutIdDoubles = influxDBService.queryModelResultsByOutPutIds(pojo, mmPredictItemRespVO.getLastTime(), mmPredictItemRespVO.getLastTime());
+            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;
+    }
+
+    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]);
+
+            Date predictTime = predictItem.getLastTime();
+            List<Object[]> curData = mmItemResultJsonService.getData(outPut.getId(), 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 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;
+    }
+
+    /**
+     * 计算功率因数 p²/(根号:p²+Q²)
+     **/
+    public Double calculateCos(Double PValue,Double QValue) {
+        // 绝对值
+        PValue = Math.abs(PValue);
+        QValue = Math.abs(QValue);
+        //PValue [0,0.001] 直接判断为关闭返回0
+        if (PValue >= 0 && PValue <= 0.001) {
+            return 0.0;
+        }else {
+            BigDecimal result = new BigDecimal(PValue).divide(BigDecimal.valueOf(Math.sqrt(Math.pow(PValue, 2) + Math.pow(QValue, 2))), 2, BigDecimal.ROUND_HALF_UP);
+            return result.doubleValue();
+        }
     }
 
     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