From f6f995e5875570cafb976b2cadf90c6abdab1139 Mon Sep 17 00:00:00 2001
From: wl <173@qq.com>
Date: 星期二, 29 十一月 2022 16:46:45 +0800
Subject: [PATCH] fix: 违规检索导出和查询车牌号

---
 ycl-platform/src/main/resources/mapper/caseHandler/BaseCaseMapper.xml             |    2 +-
 ycl-platform/src/main/java/com/ycl/controller/caseHandler/BaseCaseController.java |    2 +-
 2 files changed, 2 insertions(+), 2 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 471cbb8..4e9122d 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
@@ -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")
diff --git a/ycl-platform/src/main/resources/mapper/caseHandler/BaseCaseMapper.xml b/ycl-platform/src/main/resources/mapper/caseHandler/BaseCaseMapper.xml
index 740b16c..857dc90 100644
--- a/ycl-platform/src/main/resources/mapper/caseHandler/BaseCaseMapper.xml
+++ b/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}

--
Gitblit v1.8.0