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/YwPointMapper.java |  106 ++++++++++++++++++++++++++++++++++++++++++++++++++---
 1 files changed, 100 insertions(+), 6 deletions(-)

diff --git a/ycl-server/src/main/java/com/ycl/platform/mapper/YwPointMapper.java b/ycl-server/src/main/java/com/ycl/platform/mapper/YwPointMapper.java
index 16e18a6..7cb2a2d 100644
--- a/ycl-server/src/main/java/com/ycl/platform/mapper/YwPointMapper.java
+++ b/ycl-server/src/main/java/com/ycl/platform/mapper/YwPointMapper.java
@@ -1,15 +1,21 @@
 package com.ycl.platform.mapper;
 
-import com.ycl.platform.base.BaseSelect;
-import com.ycl.platform.domain.entity.YwPoint;
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.ycl.platform.base.BaseSelect;
+import com.ycl.platform.domain.entity.ReportAuditingRecord;
+import com.ycl.platform.domain.entity.YwPoint;
+import com.ycl.platform.domain.query.DataCenterQuery;
+import com.ycl.platform.domain.query.YwPointQuery;
+import com.ycl.platform.domain.vo.CheckTagVO;
+import com.ycl.platform.domain.vo.PointDetailVO;
+import com.ycl.platform.domain.vo.ReportAuditingRecordVO;
 import com.ycl.platform.domain.vo.YwPointVO;
-import com.ycl.platform.domain.form.YwPointForm;
-import java.util.List;
-
-import com.ycl.system.Result;
+import com.ycl.platform.domain.excel.PointExport;
 import org.apache.ibatis.annotations.Mapper;
 import org.apache.ibatis.annotations.Param;
+
+import java.util.List;
 
 /**
  * 杩愮淮鐐逛綅 Mapper 鎺ュ彛
@@ -27,4 +33,92 @@
      * @return
      */
     List<BaseSelect> selectData(@Param("keyword") String keyword, @Param("unitId") Integer unitId);
+
+    IPage page(IPage<YwPointVO> page, @Param("query") YwPointQuery query);
+
+
+    /**
+     * 棣栭〉鍒版湡棰勮
+     * @return 鏁版嵁
+     */
+    List<YwPoint> home();
+
+    /**
+     * 瀵煎嚭鏁版嵁
+     *
+     * @param query
+     * @return
+     */
+    List<PointExport> export(@Param("query") YwPointQuery query);
+
+    void deleteAll();
+
+    /**
+     * 鏇存柊鐐逛綅淇℃伅
+     *
+     * @param pointList
+     */
+    int updatePoint(@Param("pointList") List<YwPoint> pointList,@Param("needUpdateUnit")Boolean needUpdateUnit);
+
+    /**
+     * 缁熻鏌愮偣浣嶅搴旂殑鏈畬鎴愬伐鍗曟暟閲忥紝鐞嗚涓婃渶澶у�间负1涓伐鍗�
+     *
+     * @param pointId
+     * @return
+     */
+    YwPointVO countNotFinishedWorkOrderByPointId(@Param("pointId") Integer pointId);
+
+    /**
+     * 缁熻鏌愮偣浣嶅搴旂殑鏈畬鎴愬伐鍗曟暟閲忥紝鐞嗚涓婃渶澶у�间负1涓伐鍗�
+     *
+     * @param serialNumber
+     * @return
+     */
+    YwPointVO countNotFinishedWorkOrderByGb(@Param("serialNumber") String serialNumber);
+
+    /**
+     * 鏌ヨ鏈夐儴绾ф爣绛剧殑鐐逛綅鐨勫浗鏍囩爜
+     *
+     * @param tagType 0 閮ㄧ骇  1 閲嶇偣  2 閲嶇偣鎸囨尌鍥惧儚
+     * @return
+     */
+    List<String> getDeptPointGB(@Param("tagType") Integer tagType);
+
+    /**
+     * 鐐逛綅涓嬫媺
+     *
+     * @param keyword
+     * @param unitId
+     * @return
+     */
+    List<YwPoint> select(@Param("keyword") String keyword, @Param("unitId") Integer unitId);
+
+    /**
+     * 鑾峰彇鏈�鏂颁竴鏉℃姤澶囩粨鏋�
+     * @param serialNumber
+     * @param reportType
+     * @return
+     */
+    ReportAuditingRecordVO getReportResult(@Param("serialNumber") String serialNumber, @Param("reportType") String reportType);
+
+    /**
+     * 閫氳繃鍥芥爣鑾峰彇鏍囩淇℃伅
+     *
+     * @param gbList
+     * @return
+     */
+    List<CheckTagVO> getTagsByGB(@Param("gbList") List<String> gbList);
+
+
+    /**
+     * 璁惧鏁伴噺
+     * @param examineCategory
+     * @param examineTag
+     * @return
+     */
+    List<YwPointVO> selectToCount(Short examineCategory, Short examineTag);
+
+    void myUpdateById(YwPoint entity);
+
+    void clearMonitor();
 }

--
Gitblit v1.8.0