From d6464955dc20cb527f7be02ac8631c1effb1768a Mon Sep 17 00:00:00 2001 From: 潘志宝 <979469083@qq.com> Date: 星期一, 23 十二月 2024 16:12:11 +0800 Subject: [PATCH] 计算点查询问题修复 --- iailab-module-data/iailab-module-data-biz/src/main/resources/mapper/point/DaPointDao.xml | 12 ++++++++++++ iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/service/DaPointService.java | 2 ++ iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/service/impl/DaPointServiceImpl.java | 9 +++++++++ 3 files changed, 23 insertions(+), 0 deletions(-) diff --git a/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/service/DaPointService.java b/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/service/DaPointService.java index 5157f2a..0249769 100644 --- a/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/service/DaPointService.java +++ b/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/service/DaPointService.java @@ -46,6 +46,8 @@ List<DaPointDTO> getCumulatePoint(String freq); + List<DaPointDTO> getCumulatePoint(List<String> pointNos); + List<DaPointDTO> getCumulatePoint(DaPointPageReqVO reqVO); DaPointDTO getByNo(String pointNo); diff --git a/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/service/impl/DaPointServiceImpl.java b/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/service/impl/DaPointServiceImpl.java index b9742f0..b365cb9 100644 --- a/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/service/impl/DaPointServiceImpl.java +++ b/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/service/impl/DaPointServiceImpl.java @@ -333,6 +333,15 @@ } @Override + public List<DaPointDTO> getCumulatePoint(List<String> pointNos) { + Map<String, Object> params = new HashMap<>(3); + params.put("pointType", PointTypeEnum.CUMULATE.getCode()); + params.put("isEnable", CommonConstant.IS_ENABLE); + params.put("pointNos", pointNos); + return daPointDao.getCumulatePoint(params); + } + + @Override public List<DaPointDTO> getCumulatePoint(DaPointPageReqVO reqVO) { Map<String, Object> params = new HashMap<>(3); params.put("pointType", PointTypeEnum.CUMULATE.getCode()); diff --git a/iailab-module-data/iailab-module-data-biz/src/main/resources/mapper/point/DaPointDao.xml b/iailab-module-data/iailab-module-data-biz/src/main/resources/mapper/point/DaPointDao.xml index 8e67c76..4b08398 100644 --- a/iailab-module-data/iailab-module-data-biz/src/main/resources/mapper/point/DaPointDao.xml +++ b/iailab-module-data/iailab-module-data-biz/src/main/resources/mapper/point/DaPointDao.xml @@ -247,6 +247,12 @@ <if test="minfreqid != null and minfreqid != ''"> AND t1.minfreqid = #{minfreqid} </if> + <if test="pointNos != null"> + AND t1.point_no in + <foreach collection="pointNos" item="item" index="item" open="(" close=")" separator=","> + #{item} + </foreach> + </if> </where> </select> @@ -272,6 +278,12 @@ <if test="minfreqid != null and minfreqid != ''"> AND t1.minfreqid = #{minfreqid} </if> + <if test="pointNos != null"> + AND t1.point_no in + <foreach collection="pointNos" item="item" index="item" open="(" close=")" separator=","> + #{item} + </foreach> + </if> </where> </select> -- Gitblit v1.9.3