From 7ab1fcfdd4facfdafac50dc06804408e4559dba7 Mon Sep 17 00:00:00 2001
From: kongdeqiang <123456>
Date: 星期一, 24 二月 2025 08:20:49 +0800
Subject: [PATCH] fix : 查询出场接口修改
---
src/main/resources/mapper/OutParkMapper.xml | 6 ++++++
src/main/java/com/boying/service/OutParkService.java | 2 +-
src/main/java/com/boying/service/impl/OutParkServiceImpl.java | 4 ++--
src/main/java/com/boying/controller/OutParkController.java | 2 +-
src/main/java/com/boying/mapper/OutParkMapper.java | 2 +-
5 files changed, 11 insertions(+), 5 deletions(-)
diff --git a/src/main/java/com/boying/controller/OutParkController.java b/src/main/java/com/boying/controller/OutParkController.java
index a8f91a6..77c5df6 100644
--- a/src/main/java/com/boying/controller/OutParkController.java
+++ b/src/main/java/com/boying/controller/OutParkController.java
@@ -59,7 +59,7 @@
public Object findPage(Page page, String carNo,Long parkId,String payCode,Integer status,String date) throws ParseException {
List<OutPark> list = outParkService.getList(page.getCurrent(), page.getSize(), carNo,parkId,payCode,status, date);
System.out.println(list);
- long count = outParkService.getCount(carNo,parkId,payCode, date);
+ long count = outParkService.getCount(carNo,parkId,payCode,status, date);
for (OutPark record : list) {
record.setParkName(parkService.getById(record.getParkId()).getName());
if(record.getEnterTime() != null){
diff --git a/src/main/java/com/boying/mapper/OutParkMapper.java b/src/main/java/com/boying/mapper/OutParkMapper.java
index 204a1b4..23e314d 100644
--- a/src/main/java/com/boying/mapper/OutParkMapper.java
+++ b/src/main/java/com/boying/mapper/OutParkMapper.java
@@ -20,7 +20,7 @@
List<OutPark> getList(@Param("current")long current, @Param("size")long size, @Param("carNo")String carNo, @Param("parkId")Long parkId, @Param("payCode")String payCode,@Param("status")Integer status, @Param("date")String date);
- long getCount(@Param("carNo")String carNo, @Param("parkId")Long parkId, @Param("payCode")String payCode, @Param("date")String date);
+ long getCount(@Param("carNo")String carNo, @Param("parkId")Long parkId, @Param("payCode")String payCode,@Param("status")Integer status, @Param("date")String date);
List<OutParkVo> getVoList(@Param("parkId")Integer parkId,@Param("startDate")String startDate,@Param("endDate")String endDate);
diff --git a/src/main/java/com/boying/service/OutParkService.java b/src/main/java/com/boying/service/OutParkService.java
index 80ecd43..c9c0559 100644
--- a/src/main/java/com/boying/service/OutParkService.java
+++ b/src/main/java/com/boying/service/OutParkService.java
@@ -20,7 +20,7 @@
public interface OutParkService extends IService<OutPark> {
List<OutPark> getList(long current, long size, String carNo, Long parkId, String payCode,Integer status, String date);
- long getCount(String carNo, Long parkId, String payCode, String date);
+ long getCount(String carNo, Long parkId, String payCode,Integer status, String date);
int count1();
diff --git a/src/main/java/com/boying/service/impl/OutParkServiceImpl.java b/src/main/java/com/boying/service/impl/OutParkServiceImpl.java
index 8fda42e..58f67ff 100644
--- a/src/main/java/com/boying/service/impl/OutParkServiceImpl.java
+++ b/src/main/java/com/boying/service/impl/OutParkServiceImpl.java
@@ -278,7 +278,7 @@
}
@Override
- public long getCount(String carNo, Long parkId, String payCode, String date) {
- return outParkMapper.getCount(carNo,parkId,payCode,date);
+ public long getCount(String carNo, Long parkId, String payCode,Integer status, String date) {
+ return outParkMapper.getCount(carNo,parkId,payCode,status,date);
}
}
diff --git a/src/main/resources/mapper/OutParkMapper.xml b/src/main/resources/mapper/OutParkMapper.xml
index 11e82cd..f4292b9 100644
--- a/src/main/resources/mapper/OutParkMapper.xml
+++ b/src/main/resources/mapper/OutParkMapper.xml
@@ -39,6 +39,9 @@
<if test="parkId != null and parkId != ''">
and park_id = #{parkId}
</if>
+ <if test="status != null and status != ''">
+ and status = #{status}
+ </if>
<if test="date != null and date != ''">
and DATE_FORMAT(create_time,'%Y-%m-%d') >= DATE_FORMAT(#{date},'%Y-%m-%d')
and DATE_FORMAT(create_time,'%Y-%m-%d') <= DATE_FORMAT(#{date},'%Y-%m-%d')
@@ -60,6 +63,9 @@
<if test="parkId != null and parkId != ''">
and park_id = #{parkId}
</if>
+ <if test="status != null and status != ''">
+ and status = #{status}
+ </if>
<if test="date != null and date != ''">
and DATE_FORMAT(create_time,'%Y-%m-%d') >= DATE_FORMAT(#{date},'%Y-%m-%d')
and DATE_FORMAT(create_time,'%Y-%m-%d') <= DATE_FORMAT(#{date},'%Y-%m-%d')
--
Gitblit v1.9.1