From 3b0516a2959e25576e4f3fda697a3b025d06c8c9 Mon Sep 17 00:00:00 2001 From: zxl <763096477@qq.com> Date: 星期二, 24 六月 2025 14:09:07 +0800 Subject: [PATCH] 每日录像可用指标添加日志,修改大屏为查看当前月平均 --- ycl-server/src/main/java/com/ycl/platform/mapper/CheckScoreMapper.java | 48 +++++++++++++++++++++++++++++++++++++++--------- 1 files changed, 39 insertions(+), 9 deletions(-) diff --git a/ycl-server/src/main/java/com/ycl/platform/mapper/CheckScoreMapper.java b/ycl-server/src/main/java/com/ycl/platform/mapper/CheckScoreMapper.java index 09d9ad8..8c5999e 100644 --- a/ycl-server/src/main/java/com/ycl/platform/mapper/CheckScoreMapper.java +++ b/ycl-server/src/main/java/com/ycl/platform/mapper/CheckScoreMapper.java @@ -1,24 +1,28 @@ package com.ycl.platform.mapper; import annotation.AutoFill; +import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.ycl.platform.domain.dto.CheckScoreDTO; +import com.ycl.platform.domain.dto.ScoreIndexDTO; import com.ycl.platform.domain.entity.CheckScore; +import com.ycl.platform.domain.query.DashboardQuery; import enumeration.OperationType; +import java.util.Date; import java.util.List; import java.util.Map; /** * 鑰冩牳绉垎鏄庣粏Mapper鎺ュ彛 - * + * * @author ruoyi * @date 2024-04-22 */ -public interface CheckScoreMapper +public interface CheckScoreMapper extends BaseMapper<CheckScore> { /** * 鏌ヨ鑰冩牳绉垎鏄庣粏 - * + * * @param id 鑰冩牳绉垎鏄庣粏涓婚敭 * @return 鑰冩牳绉垎鏄庣粏 */ @@ -26,7 +30,7 @@ /** * 鏌ヨ鑰冩牳绉垎鏄庣粏鍒楄〃 - * + * * @param checkScore 鑰冩牳绉垎鏄庣粏 * @return 鑰冩牳绉垎鏄庣粏闆嗗悎 */ @@ -34,7 +38,7 @@ /** * 鏂板鑰冩牳绉垎鏄庣粏 - * + * * @param checkScore 鑰冩牳绉垎鏄庣粏 * @return 缁撴灉 */ @@ -42,7 +46,7 @@ /** * 淇敼鑰冩牳绉垎鏄庣粏 - * + * * @param checkScore 鑰冩牳绉垎鏄庣粏 * @return 缁撴灉 */ @@ -50,7 +54,7 @@ /** * 鍒犻櫎鑰冩牳绉垎鏄庣粏 - * + * * @param id 鑰冩牳绉垎鏄庣粏涓婚敭 * @return 缁撴灉 */ @@ -58,7 +62,7 @@ /** * 鎵归噺鍒犻櫎鑰冩牳绉垎鏄庣粏 - * + * * @param ids 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎 * @return 缁撴灉 */ @@ -67,5 +71,31 @@ @AutoFill(OperationType.UPDATE) int publishCheckScore(CheckScoreDTO checkScoreDTO); - List<Map> selectScoreIndex(String tableName,Long deptId,String date); + List<Map> selectScoreIndex(ScoreIndexDTO scoreIndexDTO); + + void saveBatch(List<CheckScore> scoreList); + + List<CheckScore> selectCheckScoreMap(CheckScore checkScore); + + /** + * 棣栭〉鑰冩牳棰勮 + * @return 鏁版嵁 + */ + List<Map<String, Object>> home(Date startTime,Date endTime); + + /** + * 棣栭〉鏍哥畻 + * @param startDate 鏈湀绗竴澶� + * @param endDate 褰撳墠鏃堕棿 + * @param category 鍒嗙被 + * @return 鏁版嵁 + */ + List<Map<String, Object>> calculate(Date startDate, Date endDate, String category); + + CheckScore getLast(CheckScore checkScore); + + List<CheckScore> dashboard(DashboardQuery dashboardQuery); + + List<CheckScore> selectToday(String day); + } -- Gitblit v1.8.0