fix: 违规检索导出和查询车牌号

wl

2022-11-29 f6f995e5875570cafb976b2cadf90c6abdab1139

fix: 违规检索导出和查询车牌号

 ycl-platform/src/main/java/com/ycl/controller/caseHandler/BaseCaseController.java

@@ -297,7 +297,7 @@
    @ApiOperation("违规检索-导出")
    public void queryForViolationExport(HttpServletResponse response, QueryForViolationParam queryForViolationParam) {
        String sheetName = "违规数据";
        EasyExcelUtils.export(response, sheetName, QueryForViolationVO.class, baseCaseService.selectViolation(queryForViolationParam).getRecords());
        EasyExcelUtils.export(response, sheetName, QueryForViolationVO.class, baseCaseService.selectViolationList(queryForViolationParam));
    }

    @GetMapping("/video_inspection")

 ycl-platform/src/main/resources/mapper/caseHandler/BaseCaseMapper.xml

@@ -216,7 +216,7 @@
                and t1.state=#{queryForViolationParam.state}
            </if>
            <if test="queryForViolationParam.carNumber != null and  queryForViolationParam.carNumber!=''">
                and t1.car_umber like concat('%',#{queryForViolationParam.carNumber},'%')
                and t2.car_umber like concat('%',#{queryForViolationParam.carNumber},'%')
            </if>
            <if test="queryForViolationParam.videoPointId != null">
                and t1.video_point_id=#{queryForViolationParam.videoPointId}