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 |   86 +++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 86 insertions(+), 0 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 aada066..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
@@ -3,9 +3,15 @@
 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.excel.PointExport;
 import org.apache.ibatis.annotations.Mapper;
 import org.apache.ibatis.annotations.Param;
 
@@ -30,9 +36,89 @@
 
     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