From 1eb1ae6b785210727812ed5f6ce9ccaaf09cc458 Mon Sep 17 00:00:00 2001
From: zhanghua <314079846@qq.com>
Date: 星期五, 15 十二月 2023 20:59:27 +0800
Subject: [PATCH] 案件池查询修改 定时任务加环境判断

---
 ycl-platform/src/main/java/com/ycl/mapper/caseHandler/BaseCaseMapper.java |   22 +++++++++++++++++-----
 1 files changed, 17 insertions(+), 5 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..b9faedc 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
@@ -1,6 +1,7 @@
 package com.ycl.mapper.caseHandler;
 
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.ycl.dto.caseHandler.QueryForViolationParam;
 import com.ycl.dto.cockpitManage.DelayDO;
@@ -13,6 +14,7 @@
 import com.ycl.vo.cockpit.enforcementEvents.VideoAndAreaVO;
 import org.apache.ibatis.annotations.Param;
 
+import java.time.LocalDateTime;
 import java.util.List;
 import java.util.Map;
 
@@ -25,19 +27,19 @@
  * @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, List<Integer> state, Integer type, Integer resource, String code, String categoryBig, String categorySmall, Integer street, String site, String startTime, String endTime, Integer violationsTypeId, Integer videoId);
 
-    Page<CasePoolIllegalBuildingVO> listIllegalBuildingsPage(Page page, Integer state, Integer type, Integer resource);
+    Page<CasePoolIllegalBuildingVO> listIllegalBuildingsPage(Page page, List<Integer> state, Integer type, Integer resource);
 
     BaseCase selectCondMap(Map map);
 
-    Page<BaseCase> selectBaseCasePage(Page<BaseCase> page, @Param("code") String number, @Param("streetId") Integer streetId, @Param("categories") Integer categories, @Param("startTime") String startTime, @Param("endTime") String endTime, @Param("site") String site);
+    Page<BaseCase> selectBaseCasePage(Page<BaseCase> page, @Param("code") String number, @Param("communityId") Integer communityId, @Param("categories") Integer categories, @Param("startTime") LocalDateTime startTime, @Param("endTime") LocalDateTime endTime, @Param("site") String site, @Param("state") Integer state, @Param("streetId") Integer streetId);
 
     Page<QueryForViolationVO> selectViolationPage(Page<QueryForViolationVO> setCurrent, @Param(value = "queryForViolationParam") QueryForViolationParam queryForViolationParam);
 
     List<QueryForViolationVO> selectViolationPage(@Param(value = "queryForViolationParam") QueryForViolationParam queryForViolationParam);
 
-    Page<BaseCaseVO> selectVideoInspection(Page<Object> objectPage);
+    Page<BaseCaseVO> selectVideoInspection(Page<Object> objectPage, @Param("gradeId") Long gradeId, @Param("videoId") Long videoId, @Param("beginTime") String beginTime, @Param("endTime") String endTime, @Param("type") Integer type);
 
     Integer dayCount();
 
@@ -45,7 +47,7 @@
 
     Integer dispatchCount();
 
-    List<EventVO> selectEventList(String beginTime, String endTime);
+    IPage<EventVO> selectEventList(IPage<EventVO> page, String beginTime, String endTime);
 
     Integer alCount();
 
@@ -58,4 +60,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