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