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 |  101 ++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 101 insertions(+), 0 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
new file mode 100644
index 0000000..8c5999e
--- /dev/null
+++ b/ycl-server/src/main/java/com/ycl/platform/mapper/CheckScoreMapper.java
@@ -0,0 +1,101 @@
+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 extends BaseMapper<CheckScore>
+{
+    /**
+     * 鏌ヨ鑰冩牳绉垎鏄庣粏
+     *
+     * @param id 鑰冩牳绉垎鏄庣粏涓婚敭
+     * @return 鑰冩牳绉垎鏄庣粏
+     */
+    public CheckScore selectCheckScoreById(Long id);
+
+    /**
+     * 鏌ヨ鑰冩牳绉垎鏄庣粏鍒楄〃
+     *
+     * @param checkScore 鑰冩牳绉垎鏄庣粏
+     * @return 鑰冩牳绉垎鏄庣粏闆嗗悎
+     */
+    public List<CheckScore> selectCheckScoreList(CheckScore checkScore);
+
+    /**
+     * 鏂板鑰冩牳绉垎鏄庣粏
+     *
+     * @param checkScore 鑰冩牳绉垎鏄庣粏
+     * @return 缁撴灉
+     */
+    public int insertCheckScore(CheckScore checkScore);
+
+    /**
+     * 淇敼鑰冩牳绉垎鏄庣粏
+     *
+     * @param checkScore 鑰冩牳绉垎鏄庣粏
+     * @return 缁撴灉
+     */
+    public int updateCheckScore(CheckScore checkScore);
+
+    /**
+     * 鍒犻櫎鑰冩牳绉垎鏄庣粏
+     *
+     * @param id 鑰冩牳绉垎鏄庣粏涓婚敭
+     * @return 缁撴灉
+     */
+    public int deleteCheckScoreById(Long id);
+
+    /**
+     * 鎵归噺鍒犻櫎鑰冩牳绉垎鏄庣粏
+     *
+     * @param ids 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎
+     * @return 缁撴灉
+     */
+    public int deleteCheckScoreByIds(Long[] ids);
+
+    @AutoFill(OperationType.UPDATE)
+    int publishCheckScore(CheckScoreDTO checkScoreDTO);
+
+    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