From 6ea8bed0c8cb5d786a48bdbe4edfdb7cc13555e3 Mon Sep 17 00:00:00 2001
From: Jay <csj123456>
Date: 星期一, 21 四月 2025 19:23:19 +0800
Subject: [PATCH] 查询指标历史值分页

---
 iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/impl/MmItemResultJsonServiceImpl.java |   83 +++++++++++++++++++++++++++++++++++++++++
 1 files changed, 82 insertions(+), 1 deletions(-)

diff --git a/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/impl/MmItemResultJsonServiceImpl.java b/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/impl/MmItemResultJsonServiceImpl.java
index d2d988f..4e44b5f 100644
--- a/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/impl/MmItemResultJsonServiceImpl.java
+++ b/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/impl/MmItemResultJsonServiceImpl.java
@@ -11,6 +11,7 @@
 import org.springframework.stereotype.Service;
 import org.springframework.util.CollectionUtils;
 
+import java.math.BigDecimal;
 import java.util.*;
 
 /**
@@ -28,6 +29,34 @@
         QueryWrapper<MmItemResultJsonEntity> wrapper = new QueryWrapper<>();
         wrapper.eq("outputid", outputId)
                 .eq("predicttime", DateUtils.format(predictTime,timeFormat));
+        MmItemResultJsonEntity data = null;
+        List<MmItemResultJsonEntity> dataList = baseDao.selectList(wrapper);
+        if (!CollectionUtils.isEmpty(dataList)) {
+            data = dataList.get(0);
+        }
+        if (data == null || StringUtils.isBlank(data.getJsonvalue())) {
+            return result;
+        }
+        List<Double> valueList = JSONArray.parseArray(data.getJsonvalue(), Double.class);
+        if (CollectionUtils.isEmpty(valueList)) {
+            return result;
+        }
+        Calendar calendar = Calendar.getInstance();
+        calendar.setTime(predictTime);
+        valueList.forEach(value -> {
+            calendar.add(Calendar.MINUTE, 1);
+            Object[] dv = {DateUtils.format(calendar.getTime(), timeFormat), value};
+            result.add(dv);
+        });
+        return result;
+    }
+
+    @Override
+    public List<Object[]> getData(String outputId, Date predictTime, String timeFormat, int scale) {
+        List<Object[]> result = new ArrayList<>();
+        QueryWrapper<MmItemResultJsonEntity> wrapper = new QueryWrapper<>();
+        wrapper.eq("outputid", outputId)
+                .eq("predicttime", DateUtils.format(predictTime,timeFormat));
         MmItemResultJsonEntity data = baseDao.selectOne(wrapper);
         if (data == null || StringUtils.isBlank(data.getJsonvalue())) {
             return result;
@@ -39,7 +68,39 @@
         Calendar calendar = Calendar.getInstance();
         calendar.setTime(predictTime);
         valueList.forEach(value -> {
-            Object[] dv = {DateUtils.format(calendar.getTime(), timeFormat), value};
+            calendar.add(Calendar.MINUTE, 1);
+            Object[] dv = {DateUtils.format(calendar.getTime(), timeFormat), new BigDecimal(value).setScale(scale, BigDecimal.ROUND_HALF_UP)};
+            result.add(dv);
+        });
+        return result;
+    }
+
+    @Override
+    public List<Object[]> getData(String outputId, Date predictTime, String timeFormat, int scale, Boolean isT1, Object curReal) {
+        List<Object[]> result = new ArrayList<>();
+        QueryWrapper<MmItemResultJsonEntity> wrapper = new QueryWrapper<>();
+        wrapper.eq("outputid", outputId)
+                .eq("predicttime", DateUtils.format(predictTime,timeFormat));
+        MmItemResultJsonEntity data = baseDao.selectOne(wrapper);
+        if (data == null || StringUtils.isBlank(data.getJsonvalue())) {
+            return result;
+        }
+        List<Double> valueList = JSONArray.parseArray(data.getJsonvalue(), Double.class);
+        if (CollectionUtils.isEmpty(valueList)) {
+            return result;
+        }
+        Calendar calendar = Calendar.getInstance();
+        calendar.setTime(predictTime);
+        if (isT1) {
+            Object[] v0 = new Object[2];
+            v0[0] = DateUtils.format(calendar.getTime(), timeFormat);
+            v0[1] = curReal;
+            result.add(v0);
+            calendar.add(Calendar.MINUTE, 1);
+        }
+
+        valueList.forEach(value -> {
+            Object[] dv = {DateUtils.format(calendar.getTime(), timeFormat), new BigDecimal(value).setScale(scale, BigDecimal.ROUND_HALF_UP)};
             calendar.add(Calendar.MINUTE, 1);
             result.add(dv);
         });
@@ -47,6 +108,26 @@
     }
 
     @Override
+    public double[] getSimpleData(String outputId, Date predictTime, int predictLength) {
+        double[] result = new double[predictLength];
+        QueryWrapper<MmItemResultJsonEntity> wrapper = new QueryWrapper<>();
+        wrapper.eq("outputid", outputId)
+                .eq("predicttime", DateUtils.format(predictTime, DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND));
+        MmItemResultJsonEntity data = baseDao.selectOne(wrapper);
+        if (data == null || StringUtils.isBlank(data.getJsonvalue())) {
+            return null;
+        }
+        List<Double> valueList = JSONArray.parseArray(data.getJsonvalue(), Double.class);
+        if (CollectionUtils.isEmpty(valueList)) {
+            return result;
+        }
+        for (int i = 0; i < predictLength; i++) {
+            result[i] = valueList.get(i);
+        }
+        return result;
+    }
+
+    @Override
     public void insert(List<MmItemResultJsonEntity> resultJsonList) {
         baseDao.insertBatch(resultJsonList);
     }

--
Gitblit v1.9.3