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 | 78 ++++++++++++++++++++++++++++++++++----
1 files changed, 69 insertions(+), 9 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 32860fa..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,8 +3,13 @@
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;
@@ -31,19 +36,12 @@
IPage page(IPage<YwPointVO> page, @Param("query") YwPointQuery query);
+
/**
* 棣栭〉鍒版湡棰勮
* @return 鏁版嵁
*/
List<YwPoint> home();
-
- /**
- * 閫氳繃鏍囩鏌ラ噸鐐圭偣浣嶆垨鐪佸巺鐐逛綅鎴栭噸鐐规寚鎸ュ浘鍍�
- */
- List<YwPoint> selectByTag(@Param("important")Boolean important,
- @Param("province")Boolean province,
- @Param("commandImage")Boolean commandImage,
- @Param("deptTag") Boolean deptTag);
/**
* 瀵煎嚭鏁版嵁
@@ -60,5 +58,67 @@
*
* @param pointList
*/
- int updatePoint(List<YwPoint> 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