From c4aa721a61edb5ff4502d621897c266b98ef3d1c Mon Sep 17 00:00:00 2001
From: baizonghao <1719256278@qq.com>
Date: 星期五, 24 二月 2023 11:18:58 +0800
Subject: [PATCH] 按报警点位统计,按区域统计

---
 ycl-platform/src/main/java/com/ycl/mapper/caseHandler/BaseCaseMapper.java |   12 +++++++++++-
 1 files changed, 11 insertions(+), 1 deletions(-)

diff --git a/ycl-platform/src/main/java/com/ycl/mapper/caseHandler/BaseCaseMapper.java b/ycl-platform/src/main/java/com/ycl/mapper/caseHandler/BaseCaseMapper.java
index 933e1ae..e309319 100644
--- a/ycl-platform/src/main/java/com/ycl/mapper/caseHandler/BaseCaseMapper.java
+++ b/ycl-platform/src/main/java/com/ycl/mapper/caseHandler/BaseCaseMapper.java
@@ -25,7 +25,7 @@
  * @since 2022-09-24
  */
 public interface BaseCaseMapper extends BaseMapper<BaseCase> {
-    Page<CasePoolViolationVO> listViolationsPage(Page page, Integer state, Integer type, Integer resource);
+    Page<CasePoolViolationVO> listViolationsPage(Page page, Integer state, Integer type, Integer resource, String code, String categoryBig, String categorySmall, Integer street, String site, String startTime, String endTime);
 
     Page<CasePoolIllegalBuildingVO> listIllegalBuildingsPage(Page page, Integer state, Integer type, Integer resource);
 
@@ -58,4 +58,14 @@
     List<DelayDO> selectDelayVOList();
 
     List<VideoAndAreaVO> selectType();
+
+    Long selectLastMonthCount(List<Integer> states);
+
+    Long selectRecentlyMonthCount(List<Integer> states);
+
+    Long selectOnTimeCaseCount();
+
+    Long selectOnTimeCaseLastMonthCount();
+
+    Long selectOnTimeCaseRecentlyMonthCount();
 }

--
Gitblit v1.8.0