| | |
| | | @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); |
| | | } |