From 407e8bed7378a56b2008ad539ef8bdfc6e034bd2 Mon Sep 17 00:00:00 2001
From: wl <173@qq.com>
Date: 星期二, 13 十二月 2022 18:14:57 +0800
Subject: [PATCH] fix: 预警研判今日学习

---
 ycl-platform/src/main/resources/mapper/caseHandler/BaseCaseMapper.xml                |    7 +++++++
 ycl-platform/src/main/java/com/ycl/service/caseHandler/impl/BaseCaseServiceImpl.java |    2 +-
 ycl-platform/src/main/java/com/ycl/mapper/caseHandler/BaseCaseMapper.java            |    2 ++
 3 files changed, 10 insertions(+), 1 deletions(-)

diff --git a/ycl-platform/src/main/java/com/ycl/mapper/caseHandler/BaseCaseMapper.java b/ycl-platform/src/main/java/com/ycl/mapper/caseHandler/BaseCaseMapper.java
index 237e22d..6714acb 100644
--- a/ycl-platform/src/main/java/com/ycl/mapper/caseHandler/BaseCaseMapper.java
+++ b/ycl-platform/src/main/java/com/ycl/mapper/caseHandler/BaseCaseMapper.java
@@ -55,6 +55,8 @@
 
     Long selectRegisterCount();
 
+    Long selectStudyCount();
+
     List<VideoAndAreaVO> areaCount();
 
     List<DelayDO> selectDelayVOList();
diff --git a/ycl-platform/src/main/java/com/ycl/service/caseHandler/impl/BaseCaseServiceImpl.java b/ycl-platform/src/main/java/com/ycl/service/caseHandler/impl/BaseCaseServiceImpl.java
index 9acb354..7229b90 100644
--- a/ycl-platform/src/main/java/com/ycl/service/caseHandler/impl/BaseCaseServiceImpl.java
+++ b/ycl-platform/src/main/java/com/ycl/service/caseHandler/impl/BaseCaseServiceImpl.java
@@ -422,7 +422,7 @@
         HashMap<String, Object> map = new HashMap<>();
         Long review = baseCaseMapper.selectCount(new LambdaQueryWrapper<BaseCase>().eq(BaseCase::getState, 1));
         Long register = baseCaseMapper.selectRegisterCount();
-        Long study = baseCaseMapper.selectCount(new LambdaQueryWrapper<BaseCase>().eq(BaseCase::getState, 3));
+        Long study = baseCaseMapper.selectStudyCount();
         map.put("review", review);
         map.put("register", register);
         map.put("study", study);
diff --git a/ycl-platform/src/main/resources/mapper/caseHandler/BaseCaseMapper.xml b/ycl-platform/src/main/resources/mapper/caseHandler/BaseCaseMapper.xml
index ae8aff0..e4f7649 100644
--- a/ycl-platform/src/main/resources/mapper/caseHandler/BaseCaseMapper.xml
+++ b/ycl-platform/src/main/resources/mapper/caseHandler/BaseCaseMapper.xml
@@ -259,6 +259,13 @@
           and to_days(create_time) = TO_DAYS(now());
     </select>
 
+    <select id="selectStudyCount" resultType="java.lang.Long">
+        select count(1)
+        from ums_base_case
+        where state =3
+          and to_days(create_time) = TO_DAYS(now());
+    </select>
+
     <select id="dayCount" resultType="java.lang.Integer">
         select count(1)
         from ums_base_case

--
Gitblit v1.8.0