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