From 18087f533cd48ddb9f972c0848ffe920ec58ee8e Mon Sep 17 00:00:00 2001 From: kongdeqiang <123456> Date: 星期一, 26 九月 2022 16:01:14 +0800 Subject: [PATCH] 修改打包和app --- src/main/java/com/boying/dao/OutParkDao.java | 8 ++++---- 1 files changed, 4 insertions(+), 4 deletions(-) diff --git a/src/main/java/com/boying/dao/OutParkDao.java b/src/main/java/com/boying/dao/OutParkDao.java index 7a7063b..1d51461 100644 --- a/src/main/java/com/boying/dao/OutParkDao.java +++ b/src/main/java/com/boying/dao/OutParkDao.java @@ -20,9 +20,9 @@ @Query(value = "select sum(price) from OutPark where createTime>:startTime and createTime<:endTime") Double sumByPrice(Date startTime, Date endTime); - @Query(value = "from OutPark where barrierId=:bId and status=1 and status2=0 and id = (select max(id) from OutPark)") - OutPark count4(Long bId); + @Query(value = "from OutPark where barrierId=:bId and status=1 and status2=0 order by createTime desc") + List<OutPark> count4(Long bId); - @Query(value = "from OutPark where barrierId=:id and carNo=:carNo and id = (select max(id) from OutPark)") - OutPark findByCarNoAndBarrierId(String carNo, Long id); + @Query(value = "from OutPark where barrierId=:id and carNo=:carNo order by createTime desc") + List<OutPark> findByCarNoAndBarrierId(String carNo, Long id); } \ No newline at end of file -- Gitblit v1.9.1