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