fix: 案卷查询参数

wl

2022-12-08 05af069d9d1eb900a3e9202a5e03d4b8b79e1640

fix: 案卷查询参数

 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")

 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},'%')