From 8fad9df67cc660f8e6d581b9e06f3132a187d713 Mon Sep 17 00:00:00 2001
From: dengzedong <dengzedong@email>
Date: 星期五, 18 四月 2025 18:20:18 +0800
Subject: [PATCH] 数据分析 左测下拉数据预测项不可点击 接口 获得影响因素结果列表 接口 获得影响因素结果列表 影响因素表添加组合唯一索引
---
iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/controller/admin/MmPredictInfluenceFactorController.java | 28 +++++++++
iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/vo/MmPredictInfluenceFactorResultVO.java | 14 ++++
iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/vo/MmPredictInfluenceFactorVO.java | 5 +
iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/dao/MmPredictInfluenceFactorResultDao.java | 5 +
iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/impl/MmPredictInfluenceFactorServiceImpl.java | 13 +++-
iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/api/McsApiImpl.java | 1
iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/impl/MmPredictInfluenceFactorResultServiceImpl.java | 16 +++--
iailab-module-model/iailab-module-model-biz/db/mysql.sql | 4
iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/dao/MmPredictInfluenceFactorDao.java | 4 +
iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/vo/MmPredictInfluenceFactorResultListReqVO.java | 37 ++++++++++++
iailab-module-model/iailab-module-model-biz/src/main/resources/mapper/mcs/MmPredictInfluenceFactorResultDao.xml | 26 ++++++++
iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/MmPredictInfluenceFactorService.java | 9 +-
iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/MmPredictInfluenceFactorResultService.java | 7 +-
13 files changed, 150 insertions(+), 19 deletions(-)
diff --git a/iailab-module-model/iailab-module-model-biz/db/mysql.sql b/iailab-module-model/iailab-module-model-biz/db/mysql.sql
index f1c8e4f..6c1a5c4 100644
--- a/iailab-module-model/iailab-module-model-biz/db/mysql.sql
+++ b/iailab-module-model/iailab-module-model-biz/db/mysql.sql
@@ -1039,6 +1039,7 @@
`is_enable` tinyint DEFAULT NULL COMMENT '是否启用（0禁用 1启用）',
`create_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
+ UNIQUE KEY `output_id_pattern_unique` (`output_id`,`pattern`),
KEY `output_id` (`output_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='预测项影响因素配置表';
@@ -1048,8 +1049,7 @@
`factor_output_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '因素预测项id',
`deviation_value` double DEFAULT NULL COMMENT '偏差值',
PRIMARY KEY (`id`),
- KEY `config_id` (`config_id`),
- KEY `item_id` (`factor_output_id`),
+ UNIQUE KEY `config_id_factor_output_id_unique` (`config_id`,`factor_output_id`),
CONSTRAINT `t_mm_predict_influence_factor_ibfk_1` FOREIGN KEY (`config_id`) REFERENCES `t_mm_predict_influence_factor_config` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='预测项影响因素关联表';
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 7db2a25..3506553 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
@@ -138,6 +138,7 @@
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)) {
diff --git a/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/controller/admin/MmPredictInfluenceFactorController.java b/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/controller/admin/MmPredictInfluenceFactorController.java
index 159032e..773c429 100644
--- a/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/controller/admin/MmPredictInfluenceFactorController.java
+++ b/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/controller/admin/MmPredictInfluenceFactorController.java
@@ -11,9 +11,16 @@
import com.iailab.module.model.mcs.pre.service.MmPredictInfluenceFactorService;
import com.iailab.module.model.mcs.pre.vo.*;
import io.swagger.v3.oas.annotations.Operation;
+import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.access.prepost.PreAuthorize;
+import org.springframework.util.CollectionUtils;
import org.springframework.web.bind.annotation.*;
+
+import java.util.ArrayList;
+import java.util.HashMap;
+import java.util.List;
+import java.util.Map;
import static com.iailab.framework.common.pojo.CommonResult.success;
@@ -78,4 +85,25 @@
PageResult<MmPredictInfluenceFactorResultVO> pageResult = influenceFactorResultService.page(params);
return success(pageResult);
}
+
+
+ @PostMapping("/getResultList")
+ @Operation(summary = "获得影响因素结果列表")
+ public CommonResult<Map<String,List<MmPredictInfluenceFactorResultVO>>> getResultList(@RequestBody MmPredictInfluenceFactorResultListReqVO params) {
+ if (CollectionUtils.isEmpty(params.getOutIds())) {
+ return success(new HashMap<>());
+ }
+ Map<String,List<MmPredictInfluenceFactorResultVO>> list = influenceFactorResultService.getResultList(params);
+ return success(list);
+ }
+
+ @GetMapping("/getListByOutId")
+ @Operation(summary = "通过outId获得影响因素列表")
+ public CommonResult<List<MmPredictInfluenceFactorVO>> getListByOutId(String outId) {
+ if (StringUtils.isBlank(outId)) {
+ return success(new ArrayList<>());
+ }
+ List<MmPredictInfluenceFactorVO> list = influenceFactorService.getListByOutId(outId);
+ return success(list);
+ }
}
\ No newline at end of file
diff --git a/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/dao/MmPredictInfluenceFactorDao.java b/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/dao/MmPredictInfluenceFactorDao.java
index ffe7f81..ca1128f 100644
--- a/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/dao/MmPredictInfluenceFactorDao.java
+++ b/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/dao/MmPredictInfluenceFactorDao.java
@@ -9,6 +9,7 @@
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
import java.util.List;
import java.util.Map;
@@ -36,4 +37,7 @@
void deleteInfluenceFactor(String configId);
List<MmPredictInfluenceFactorHandleVO> selectList(@Param("params") Map<String, Object> params);
+
+ @Select("SELECT t1.pattern,t2.factor_output_id,t3.result_name factor_output_name FROM t_mm_predict_influence_factor_config t1 LEFT JOIN t_mm_predict_influence_factor t2 ON t1.id = t2.config_id LEFT JOIN t_mm_item_output t3 ON t2.factor_output_id = t3.id WHERE t1.is_enable = 1 AND t1.output_id = #{outId}")
+ List<MmPredictInfluenceFactorVO> getListByOutId(String outId);
}
diff --git a/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/dao/MmPredictInfluenceFactorResultDao.java b/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/dao/MmPredictInfluenceFactorResultDao.java
index 329c606..31d6c3d 100644
--- a/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/dao/MmPredictInfluenceFactorResultDao.java
+++ b/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/dao/MmPredictInfluenceFactorResultDao.java
@@ -3,9 +3,10 @@
import com.iailab.framework.mybatis.core.mapper.BaseMapperX;
import com.iailab.framework.tenant.core.db.dynamic.TenantDS;
import com.iailab.module.model.mcs.pre.entity.MmPredictInfluenceFactorResultEntity;
+import com.iailab.module.model.mcs.pre.vo.MmPredictInfluenceFactorResultListReqVO;
+import com.iailab.module.model.mcs.pre.vo.MmPredictInfluenceFactorResultVO;
import org.apache.ibatis.annotations.Mapper;
-import java.util.Collection;
import java.util.List;
/**
@@ -17,4 +18,6 @@
@Mapper
public interface MmPredictInfluenceFactorResultDao extends BaseMapperX<MmPredictInfluenceFactorResultEntity> {
void insertOrUpdate(List<MmPredictInfluenceFactorResultEntity> list);
+
+ List<MmPredictInfluenceFactorResultVO> getResultList(MmPredictInfluenceFactorResultListReqVO params);
}
diff --git a/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/MmPredictInfluenceFactorResultService.java b/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/MmPredictInfluenceFactorResultService.java
index 9025d9e..5024ca1 100644
--- a/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/MmPredictInfluenceFactorResultService.java
+++ b/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/MmPredictInfluenceFactorResultService.java
@@ -2,14 +2,13 @@
import com.iailab.framework.common.pojo.PageResult;
import com.iailab.framework.common.service.BaseService;
-import com.iailab.module.model.mcs.pre.entity.MmPredictInfluenceFactorConfigEntity;
import com.iailab.module.model.mcs.pre.entity.MmPredictInfluenceFactorResultEntity;
-import com.iailab.module.model.mcs.pre.vo.MmPredictInfluenceFactorConfigVO;
-import com.iailab.module.model.mcs.pre.vo.MmPredictInfluenceFactorPageReqVO;
+import com.iailab.module.model.mcs.pre.vo.MmPredictInfluenceFactorResultListReqVO;
import com.iailab.module.model.mcs.pre.vo.MmPredictInfluenceFactorResultPageReqVO;
import com.iailab.module.model.mcs.pre.vo.MmPredictInfluenceFactorResultVO;
import java.util.List;
+import java.util.Map;
/**
* @description:
@@ -21,4 +20,6 @@
PageResult<MmPredictInfluenceFactorResultVO> page(MmPredictInfluenceFactorResultPageReqVO params);
void insert(List<MmPredictInfluenceFactorResultEntity> resultList);
+
+ Map<String,List<MmPredictInfluenceFactorResultVO>> getResultList(MmPredictInfluenceFactorResultListReqVO params);
}
diff --git a/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/MmPredictInfluenceFactorService.java b/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/MmPredictInfluenceFactorService.java
index c40cbfb..5b926c7 100644
--- a/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/MmPredictInfluenceFactorService.java
+++ b/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/MmPredictInfluenceFactorService.java
@@ -4,10 +4,9 @@
import com.iailab.framework.common.service.BaseService;
import com.iailab.module.model.api.mcs.dto.MmPredictInfluenceFactorHandleReqVO;
import com.iailab.module.model.mcs.pre.entity.MmPredictInfluenceFactorConfigEntity;
-import com.iailab.module.model.mcs.pre.vo.MmPredictInfluenceFactorConfigVO;
-import com.iailab.module.model.mcs.pre.vo.MmPredictInfluenceFactorPageReqVO;
-import com.iailab.module.model.mcs.pre.vo.MmPredictInfluenceFactorResultPageReqVO;
-import com.iailab.module.model.mcs.pre.vo.MmPredictInfluenceFactorResultVO;
+import com.iailab.module.model.mcs.pre.vo.*;
+
+import java.util.List;
/**
* @description:
@@ -27,4 +26,6 @@
void delete(String id);
void influenceFactorHandle(MmPredictInfluenceFactorHandleReqVO reqVO);
+
+ List<MmPredictInfluenceFactorVO> getListByOutId(String outId);
}
diff --git a/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/impl/MmPredictInfluenceFactorResultServiceImpl.java b/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/impl/MmPredictInfluenceFactorResultServiceImpl.java
index 77e49ae..7b52641 100644
--- a/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/impl/MmPredictInfluenceFactorResultServiceImpl.java
+++ b/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/impl/MmPredictInfluenceFactorResultServiceImpl.java
@@ -1,8 +1,6 @@
package com.iailab.module.model.mcs.pre.service.impl;
-import cn.hutool.core.bean.BeanUtil;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
-import com.baomidou.mybatisplus.core.metadata.IPage;
import com.iailab.framework.common.pojo.PageResult;
import com.iailab.framework.common.pojo.SortingField;
import com.iailab.framework.common.service.impl.BaseServiceImpl;
@@ -10,17 +8,16 @@
import com.iailab.module.model.mcs.pre.dao.MmPredictInfluenceFactorResultDao;
import com.iailab.module.model.mcs.pre.entity.MmPredictInfluenceFactorResultEntity;
import com.iailab.module.model.mcs.pre.service.MmPredictInfluenceFactorResultService;
-import com.iailab.module.model.mcs.pre.vo.MmPredictInfluenceFactorConfigVO;
+import com.iailab.module.model.mcs.pre.vo.MmPredictInfluenceFactorResultListReqVO;
import com.iailab.module.model.mcs.pre.vo.MmPredictInfluenceFactorResultPageReqVO;
import com.iailab.module.model.mcs.pre.vo.MmPredictInfluenceFactorResultVO;
import lombok.extern.slf4j.Slf4j;
-import org.checkerframework.checker.units.qual.C;
import org.springframework.stereotype.Service;
-import java.sql.Array;
import java.util.ArrayList;
-import java.util.Collection;
import java.util.List;
+import java.util.Map;
+import java.util.stream.Collectors;
@Slf4j
@Service
@@ -43,4 +40,11 @@
public void insert(List<MmPredictInfluenceFactorResultEntity> resultList) {
baseDao.insertOrUpdate(resultList);
}
+
+ @Override
+ public Map<String,List<MmPredictInfluenceFactorResultVO>> getResultList(MmPredictInfluenceFactorResultListReqVO params) {
+ List<MmPredictInfluenceFactorResultVO> list = baseDao.getResultList(params);
+ Map<String, List<MmPredictInfluenceFactorResultVO>> result = list.stream().collect(Collectors.groupingBy(MmPredictInfluenceFactorResultVO::getOutputId));
+ return result;
+ }
}
diff --git a/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/impl/MmPredictInfluenceFactorServiceImpl.java b/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/impl/MmPredictInfluenceFactorServiceImpl.java
index cc97a76..f297c2a 100644
--- a/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/impl/MmPredictInfluenceFactorServiceImpl.java
+++ b/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/service/impl/MmPredictInfluenceFactorServiceImpl.java
@@ -17,7 +17,10 @@
import com.iailab.module.model.mcs.pre.service.MmItemResultJsonService;
import com.iailab.module.model.mcs.pre.service.MmPredictInfluenceFactorResultService;
import com.iailab.module.model.mcs.pre.service.MmPredictInfluenceFactorService;
-import com.iailab.module.model.mcs.pre.vo.*;
+import com.iailab.module.model.mcs.pre.vo.MmPredictInfluenceFactorConfigVO;
+import com.iailab.module.model.mcs.pre.vo.MmPredictInfluenceFactorHandleVO;
+import com.iailab.module.model.mcs.pre.vo.MmPredictInfluenceFactorPageReqVO;
+import com.iailab.module.model.mcs.pre.vo.MmPredictInfluenceFactorVO;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
@@ -26,8 +29,6 @@
import java.math.BigDecimal;
import java.util.*;
-import java.util.function.BinaryOperator;
-import java.util.function.Function;
import java.util.stream.Collectors;
@Slf4j
@@ -169,6 +170,12 @@
}
+ @Override
+ public List<MmPredictInfluenceFactorVO> getListByOutId(String outId) {
+ List<MmPredictInfluenceFactorVO> list = baseDao.getListByOutId(outId);
+ return list;
+ }
+
private Double influenceFactorAccuracyCalculate(MmPredictInfluenceFactorHandleVO influenceFactor, HashMap<String, Double> values, Date influenceTime) {
if (values.containsKey(influenceFactor.getFactorOutputId())) {
return values.get(influenceFactor.getFactorOutputId());
diff --git a/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/vo/MmPredictInfluenceFactorResultListReqVO.java b/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/vo/MmPredictInfluenceFactorResultListReqVO.java
new file mode 100644
index 0000000..69de355
--- /dev/null
+++ b/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/vo/MmPredictInfluenceFactorResultListReqVO.java
@@ -0,0 +1,37 @@
+package com.iailab.module.model.mcs.pre.vo;
+
+import com.fasterxml.jackson.annotation.JsonFormat;
+import com.iailab.framework.common.pojo.PageParam;
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+import lombok.ToString;
+import org.springframework.format.annotation.DateTimeFormat;
+
+import java.util.Date;
+import java.util.List;
+
+/**
+ * @description:
+ * @author: dzd
+ * @date: 2025/4/18 10:45
+ **/
+@Schema(description = "预测影响因素结果列表 - Request VO")
+@Data
+@EqualsAndHashCode(callSuper = true)
+@ToString(callSuper = true)
+public class MmPredictInfluenceFactorResultListReqVO extends PageParam {
+
+ @Schema(description = "输出ID列表")
+ private List<String> outIds;
+
+ @Schema(description = "开始时间")
+ @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
+ private Date startTime;
+
+ @Schema(description = "结束时间")
+ @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
+ private Date endTime;
+}
\ No newline at end of file
diff --git a/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/vo/MmPredictInfluenceFactorResultVO.java b/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/vo/MmPredictInfluenceFactorResultVO.java
index 18e02a2..b841c29 100644
--- a/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/vo/MmPredictInfluenceFactorResultVO.java
+++ b/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/vo/MmPredictInfluenceFactorResultVO.java
@@ -14,6 +14,10 @@
public class MmPredictInfluenceFactorResultVO implements Serializable {
private static final long serialVersionUID = 1L;
/**
+ * 预测项id
+ */
+ private String outputId;
+ /**
* 因素id
*/
private String factorId;
@@ -27,4 +31,14 @@
* 影响值
*/
private Double value;
+
+ /**
+ * 因素预测项名称
+ */
+ private String factorOutputName;
+
+ /**
+ * 统计方式
+ */
+ private String pattern;
}
\ No newline at end of file
diff --git a/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/vo/MmPredictInfluenceFactorVO.java b/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/vo/MmPredictInfluenceFactorVO.java
index be982f4..666870a 100644
--- a/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/vo/MmPredictInfluenceFactorVO.java
+++ b/iailab-module-model/iailab-module-model-biz/src/main/java/com/iailab/module/model/mcs/pre/vo/MmPredictInfluenceFactorVO.java
@@ -40,4 +40,9 @@
* 偏差值
*/
private Double deviationValue;
+
+ /**
+ * 统计方式
+ */
+ private String pattern;
}
\ No newline at end of file
diff --git a/iailab-module-model/iailab-module-model-biz/src/main/resources/mapper/mcs/MmPredictInfluenceFactorResultDao.xml b/iailab-module-model/iailab-module-model-biz/src/main/resources/mapper/mcs/MmPredictInfluenceFactorResultDao.xml
index fa95869..ebdbb7a 100644
--- a/iailab-module-model/iailab-module-model-biz/src/main/resources/mapper/mcs/MmPredictInfluenceFactorResultDao.xml
+++ b/iailab-module-model/iailab-module-model-biz/src/main/resources/mapper/mcs/MmPredictInfluenceFactorResultDao.xml
@@ -11,4 +11,30 @@
ON DUPLICATE KEY UPDATE
value = VALUES(value);
</insert>
+ <select id="getResultList" resultType="com.iailab.module.model.mcs.pre.vo.MmPredictInfluenceFactorResultVO"
+ parameterType="com.iailab.module.model.mcs.pre.vo.MmPredictInfluenceFactorResultListReqVO">
+ SELECT
+ t1.output_id,
+ t1.pattern,
+ t3.result_name factor_output_name,
+ t4.time,
+ t4.value
+ FROM
+ t_mm_predict_influence_factor_config t1
+ LEFT JOIN t_mm_predict_influence_factor t2 ON t1.id = t2.config_id
+ LEFT JOIN t_mm_item_output t3 ON t2.factor_output_id = t3.id
+ LEFT JOIN t_mm_predict_influence_factor_result t4 ON t4.factor_id = t2.id
+ WHERE
+ t1.is_enable = 1
+ and t1.output_id IN
+ <foreach collection="outIds" item="item" open="(" close=")" separator=",">
+ #{item}
+ </foreach>
+ <if test="startTime != null">
+ AND t4.time >= #{startTime}
+ </if>
+ <if test="endTime != null">
+ AND t4.time <= #{endTime}
+ </if>
+ </select>
</mapper>
\ No newline at end of file
--
Gitblit v1.9.3