From 05af069d9d1eb900a3e9202a5e03d4b8b79e1640 Mon Sep 17 00:00:00 2001 From: wl <173@qq.com> Date: 星期四, 08 十二月 2022 13:42:31 +0800 Subject: [PATCH] fix: 案卷查询参数 --- ycl-platform/src/main/resources/mapper/caseHandler/BaseCaseMapper.xml | 4 ++-- ycl-platform/src/main/java/com/ycl/controller/caseHandler/BaseCaseController.java | 4 ++-- 2 files changed, 4 insertions(+), 4 deletions(-) diff --git a/ycl-platform/src/main/java/com/ycl/controller/caseHandler/BaseCaseController.java b/ycl-platform/src/main/java/com/ycl/controller/caseHandler/BaseCaseController.java index 177aecb..27ad473 100644 --- a/ycl-platform/src/main/java/com/ycl/controller/caseHandler/BaseCaseController.java +++ b/ycl-platform/src/main/java/com/ycl/controller/caseHandler/BaseCaseController.java @@ -280,12 +280,12 @@ public CommonResult queryCase(@RequestParam Integer pageSize, @RequestParam Integer current, @RequestParam(required = false) String number, - @RequestParam(required = false) Integer streetId, + @RequestParam(required = false) Integer communityId, @RequestParam(required = false) Integer categories, @RequestParam(required = false) String startTime, @RequestParam(required = false) String endTime, @RequestParam(required = false) String site) { - return CommonResult.success(baseCaseService.selectPage(new Page<BaseCase>().setCurrent(current).setSize(pageSize), number, streetId, categories, startTime, endTime, site)); + return CommonResult.success(baseCaseService.selectPage(new Page<BaseCase>().setCurrent(current).setSize(pageSize), number, communityId, categories, startTime, endTime, site)); } @GetMapping("/query_for_violation") diff --git a/ycl-platform/src/main/resources/mapper/caseHandler/BaseCaseMapper.xml b/ycl-platform/src/main/resources/mapper/caseHandler/BaseCaseMapper.xml index 9007ee7..c0c694c 100644 --- a/ycl-platform/src/main/resources/mapper/caseHandler/BaseCaseMapper.xml +++ b/ycl-platform/src/main/resources/mapper/caseHandler/BaseCaseMapper.xml @@ -127,13 +127,13 @@ select t1.*, t3.region_name community_text from ums_base_case t1 - left join ums_sccg_region t3 on t1.street_id=t3.id + left join ums_sccg_region t3 on t1.community_id=t3.id <where> <if test="categories != null"> t1.category = #{categories} </if> <if test="streetId != null"> - and t1.street_id = #{streetId} + and t1.community_id = #{streetId} </if> <if test="code != null and code !=''"> and t1.code like concat('%',#{code},'%') -- Gitblit v1.8.0