Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public int countCarRentalsBetweenDate(Date dateFrom, Date dateTo){
- TypedQuery<CarEntity> query = entityManager.createQuery("SELECT r.car FROM RentDetailsEntity r WHERE "
- + "(r.datePickup BETWEEN :dateFrom AND :dateTo) OR "
- + "(r.dateReturn BETWEEN :dateFrom AND :dateTo) OR "
- + "(r.datePickup<:dateFrom AND r.dateReturn>:dateTo GROUP BY r.car", CarEntity.class);
- query.setParameter("dateFrom", dateFrom);
- query.setParameter("dateTo", dateTo);
- List<CarEntity> carList = query.getResultList();
- return carList.size();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement