From ca9f3dd541747f4b8bb6a6c06f7635a962da0412 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Wed, 07 Apr 2021 23:47:43 +0800
Subject: [PATCH] 预警数量统计接口修改,mybatis 使用sql 变量问题解决
---
blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/healthcode/mapper/healthcodeMapper.java | 24 ++++++++++++++++++++++++
1 files changed, 24 insertions(+), 0 deletions(-)
diff --git a/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/healthcode/mapper/healthcodeMapper.java b/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/healthcode/mapper/healthcodeMapper.java
index 2194e07..97df574 100644
--- a/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/healthcode/mapper/healthcodeMapper.java
+++ b/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/healthcode/mapper/healthcodeMapper.java
@@ -16,11 +16,13 @@
*/
package org.springblade.jfpt.healthcode.mapper;
+import com.baomidou.mybatisplus.annotation.SqlParser;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
import org.springblade.jfpt.healthcode.entity.Healthcode;
import org.springblade.jfpt.healthcode.vo.HealthcodeVO;
+import org.springblade.jfpt.parcel.vo.ConditionVo;
import java.util.List;
import java.util.Map;
@@ -48,4 +50,26 @@
* @return
*/
List<Healthcode> selectHealthcodeListPage(IPage<Healthcode> page,@Param("healthcodeVO") HealthcodeVO healthcodeVO);
+
+ /**
+ * 查询当前时间段红色健康码总个数
+ * @param conditionVo
+ * @return
+ */
+ Integer selHealthcodeTimeCount(@Param("conditionVo")ConditionVo conditionVo);
+
+ /**
+ * 查询当前时间段区间时间红色健康码个数
+ * @param conditionVo
+ * @return
+ */
+ List<Healthcode> selRedCodeTimeData(@Param("conditionVo")ConditionVo conditionVo);
+
+ /**
+ * 统计时间段内红色健康码人数数量数据
+ * @param conditionVo
+ * @return
+ */
+ @SqlParser(filter = true)
+ List<Integer> selectHealthcodeTimeData(@Param("conditionVo")ConditionVo conditionVo);
}
--
Gitblit v1.9.3