Advertisement
Guest User

Untitled

a guest
Nov 19th, 2017
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. public int countCarRentalsBetweenDate(Date dateFrom, Date dateTo){
  2. TypedQuery<CarEntity> query = entityManager.createQuery("SELECT r.car FROM RentDetailsEntity r WHERE "
  3. + "(r.datePickup BETWEEN :dateFrom AND :dateTo) OR "
  4. + "(r.dateReturn BETWEEN :dateFrom AND :dateTo) OR "
  5. + "(r.datePickup<:dateFrom AND r.dateReturn>:dateTo GROUP BY r.car", CarEntity.class);
  6. query.setParameter("dateFrom", dateFrom);
  7. query.setParameter("dateTo", dateTo);
  8. List<CarEntity> carList = query.getResultList();
  9. return carList.size();
  10. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement