From 100fccb242e35b1c912ceb13fd956f48aa64acbc Mon Sep 17 00:00:00 2001 From: 龚焕茏 <2842157468@qq.com> Date: 星期二, 02 四月 2024 17:37:29 +0800 Subject: [PATCH] 设备列表展示、详情展示、显隐列、统计数 --- ycl-server/src/main/java/com/ycl/platform/service/ITMonitorService.java | 11 +++++ ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorMapper.java | 10 +++++ ycl-server/src/main/java/com/ycl/platform/controller/TMonitorController.java | 21 ++++++++++ ycl-server/src/main/resources/mapper/zgyw/TMonitorMapper.xml | 24 ++++++++++++ ycl-server/src/main/java/com/ycl/platform/service/impl/TMonitorServiceImpl.java | 11 +++++ 5 files changed, 76 insertions(+), 1 deletions(-) diff --git a/ycl-server/src/main/java/com/ycl/platform/controller/TMonitorController.java b/ycl-server/src/main/java/com/ycl/platform/controller/TMonitorController.java index 7591d6e..f70f35f 100644 --- a/ycl-server/src/main/java/com/ycl/platform/controller/TMonitorController.java +++ b/ycl-server/src/main/java/com/ycl/platform/controller/TMonitorController.java @@ -11,7 +11,6 @@ import enumeration.BusinessType; import jakarta.servlet.http.HttpServletResponse; import org.springframework.beans.factory.annotation.Autowired; -import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.web.bind.annotation.*; import java.util.List; @@ -96,4 +95,24 @@ { return toAjax(tMonitorService.deleteTMonitorByIds(ids)); } + + /** + * 鑾峰彇瑙嗛璁惧缁熻鏁� + */ + @GetMapping("/getVideoCount/{cameraFunType}") + public AjaxResult getVideoCount(@PathVariable String cameraFunType) + { + return success(tMonitorService.getVideoCount(cameraFunType)); + } + + /** + * 鑾峰彇寮傚父鎭㈠瑙嗛璁惧缁熻鏁� + */ + @GetMapping("/recoveryException") + public AjaxResult recoveryException() + { + return success(tMonitorService.recoveryException()); + } + + } diff --git a/ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorMapper.java b/ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorMapper.java index 6b1267f..deb0470 100644 --- a/ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorMapper.java +++ b/ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorMapper.java @@ -4,6 +4,7 @@ import com.ycl.platform.domain.vo.TMonitorVO; import java.util.List; +import java.util.Map; /** * 璁惧璧勪骇Mapper鎺ュ彛 @@ -60,4 +61,13 @@ * @return 缁撴灉 */ public int deleteTMonitorByIds(Long[] ids); + + /** + * 鑾峰彇瑙嗛缁熻 + * @param cameraFunType 绫诲瀷 + * @return 缁熻鏁� + */ + Map<String, String> getVideoCount(String cameraFunType); + + Map<String, String> recoveryException(); } diff --git a/ycl-server/src/main/java/com/ycl/platform/service/ITMonitorService.java b/ycl-server/src/main/java/com/ycl/platform/service/ITMonitorService.java index b0e9f5b..2c26fd4 100644 --- a/ycl-server/src/main/java/com/ycl/platform/service/ITMonitorService.java +++ b/ycl-server/src/main/java/com/ycl/platform/service/ITMonitorService.java @@ -4,6 +4,7 @@ import com.ycl.platform.domain.vo.TMonitorVO; import java.util.List; +import java.util.Map; /** * 璁惧璧勪骇Service鎺ュ彛 @@ -60,4 +61,14 @@ * @return 缁撴灉 */ public int deleteTMonitorById(Long id); + + /** + * 鑾峰彇鎸囧畾鎽勫儚澶村姛鑳界被鍨嬩笅鐨勮棰戞暟閲忋�� + * + * @param cameraFunType 鎽勫儚澶村姛鑳界被鍨嬶紝鐢ㄤ簬绛涢�夎棰戙�� + * @return 杩斿洖涓�涓寘鍚棰戞暟閲忕殑Map瀵硅薄锛屽叾涓璳ey涓虹粺璁℃寚鏍囷紝value涓哄搴斿姛鑳界被鍨嬩笅鐨勭粺璁℃暟閲忋�� + */ + Map<String, String> getVideoCount(String cameraFunType); + + Map<String, String> recoveryException(); } diff --git a/ycl-server/src/main/java/com/ycl/platform/service/impl/TMonitorServiceImpl.java b/ycl-server/src/main/java/com/ycl/platform/service/impl/TMonitorServiceImpl.java index b4af1c9..dc31c5d 100644 --- a/ycl-server/src/main/java/com/ycl/platform/service/impl/TMonitorServiceImpl.java +++ b/ycl-server/src/main/java/com/ycl/platform/service/impl/TMonitorServiceImpl.java @@ -8,6 +8,7 @@ import org.springframework.stereotype.Service; import java.util.List; +import java.util.Map; /** * 璁惧璧勪骇Service涓氬姟灞傚鐞� @@ -92,4 +93,14 @@ { return tMonitorMapper.deleteTMonitorById(id); } + + @Override + public Map<String, String> getVideoCount(String cameraFunType) { + return tMonitorMapper.getVideoCount(cameraFunType); + } + + @Override + public Map<String, String> recoveryException() { + return tMonitorMapper.recoveryException(); + } } diff --git a/ycl-server/src/main/resources/mapper/zgyw/TMonitorMapper.xml b/ycl-server/src/main/resources/mapper/zgyw/TMonitorMapper.xml index 5db47cf..e75c2f6 100644 --- a/ycl-server/src/main/resources/mapper/zgyw/TMonitorMapper.xml +++ b/ycl-server/src/main/resources/mapper/zgyw/TMonitorMapper.xml @@ -225,4 +225,28 @@ #{id} </foreach> </delete> + + <select id="getVideoCount" resultType="java.util.Map"> + SELECT count(*) AS totalPosts, + IFNULL(SUM(IF(on_state = 1, 1, 0)), 0) AS totalMembers, + IFNULL(SUM(IF(on_state = 2, 1, 0)), 0) AS postsPercentage, + IFNULL(SUM(IF(default_order = 1, 1, 0)), 0) AS totalViews, + -1 as noStore, + -1 as partStore, + IFNULL(ROUND(SUM(IF(on_state = 1, 1, 0)) / count(*) * 100, 2), 0) as viewsPercentage, + -1 as totalFace, + -1 as totalCar + FROM t_monitor + WHERE camera_fun_type like concat('%', #{cameraFunType}, '%') + </select> + + <select id="recoveryException" resultType="java.util.Map"> + SELECT count(*) AS totalPosts, + IFNULL(SUM(IF(on_state = 1, 1, 0)), 0) AS totalMembers, + IFNULL(SUM(IF(on_state = 2, 1, 0)), 0) AS postsPercentage, + IFNULL(SUM(IF(default_order = 1, 1, 0)), 0) AS totalViews, + IFNULL(ROUND(SUM(IF(on_state = 1, 1, 0)) / count(*) * 100, 2), 0) as viewsPercentage + FROM t_monitor + WHERE recovery = 1 + </select> </mapper> -- Gitblit v1.8.0