From b5df1cee65f3e9dcf554efcd3f1642a8c79d1e76 Mon Sep 17 00:00:00 2001 From: fuliqi <fuliqi@qq.com> Date: 星期一, 30 九月 2024 02:12:24 +0800 Subject: [PATCH] 点位监测更换对象+存入mongo+提取utils --- ycl-server/src/main/java/com/ycl/platform/mapper/YwPointMapper.java | 108 +++++++++++++++++++++++++++++++++++++++++++++++++++--- 1 files changed, 102 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..bc2ce19 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,94 @@ * @return */ List<BaseSelect> selectData(@Param("keyword") String keyword, @Param("unitId") Integer unitId); + + IPage page(IPage<YwPointVO> page, @Param("query") YwPointQuery query); + + IPage dataCenterPage(IPage<PointDetailVO> page, @Param("query") DataCenterQuery query); + + /** + * 棣栭〉鍒版湡棰勮 + * @return 鏁版嵁 + */ + List<YwPoint> home(); + + /** + * 閫氳繃鏍囩鏌ラ噸鐐圭偣浣嶆垨鐪佸巺鐐逛綅鎴栭噸鐐规寚鎸ュ浘鍍� + */ + List<YwPoint> selectByTag(@Param("important")Boolean important, + @Param("province")Boolean province, + @Param("commandImage")Boolean commandImage, + @Param("deptTag") Boolean deptTag); + + /** + * 瀵煎嚭鏁版嵁 + * + * @param query + * @return + */ + List<PointExport> export(@Param("query") YwPointQuery query); + + void deleteAll(); + + /** + * 鏇存柊鐐逛綅淇℃伅 + * + * @param pointList + */ + int updatePoint(List<YwPoint> pointList); + + /** + * 缁熻鏌愮偣浣嶅搴旂殑鏈畬鎴愬伐鍗曟暟閲忥紝鐞嗚涓婃渶澶у�间负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); + + /** + * 鏌ヨ璁惧鎬绘暟 + * @return + */ + Integer distinctCount(@Param("query") DataCenterQuery query); } -- Gitblit v1.8.0