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 | 50 +++++++++++++++++++++++++++++++++++++++++++++++--- 1 files changed, 47 insertions(+), 3 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 f490917..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 @@ -2,12 +2,18 @@ import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; -import com.ycl.bo.casePool.CasePoolIllegalBuildingDO; -import com.ycl.bo.casePool.CasePoolViolationDO; +import com.ycl.dto.caseHandler.QueryForViolationParam; +import com.ycl.dto.cockpitManage.DelayDO; import com.ycl.entity.caseHandler.BaseCase; +import com.ycl.vo.casePool.BaseCaseVO; import com.ycl.vo.casePool.CasePoolIllegalBuildingVO; import com.ycl.vo.casePool.CasePoolViolationVO; +import com.ycl.vo.casePool.QueryForViolationVO; +import com.ycl.vo.cockpit.enforcementEvents.EventVO; +import com.ycl.vo.cockpit.enforcementEvents.VideoAndAreaVO; +import org.apache.ibatis.annotations.Param; +import java.util.List; import java.util.Map; /** @@ -19,9 +25,47 @@ * @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); 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<QueryForViolationVO> selectViolationPage(Page<QueryForViolationVO> setCurrent, @Param(value = "queryForViolationParam") QueryForViolationParam queryForViolationParam); + + List<QueryForViolationVO> selectViolationPage(@Param(value = "queryForViolationParam") QueryForViolationParam queryForViolationParam); + + Page<BaseCaseVO> selectVideoInspection(Page<Object> objectPage); + + Integer dayCount(); + + Integer weekCount(); + + Integer dispatchCount(); + + List<EventVO> selectEventList(String beginTime, String endTime); + + Integer alCount(); + + Long selectRegisterCount(); + + Long selectStudyCount(); + + List<VideoAndAreaVO> areaCount(); + + 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