Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @SuppressWarnings("unchecked")
- @Transactional(readOnly=true)
- public List<Order> getOldOrders(Member memberResp, long end, int dateDeliveryType) {
- //dateDeliveryType
- // 0 = Impostata
- // 1 = Non Impostata
- // 2 = Entrambe
- Timestamp endDate = new Timestamp(end);
- Date now = new Date();
- Timestamp nowT = new Timestamp(now.getTime());
- Query query = null;
- switch(dateDeliveryType)
- {
- case 0:
- query = sessionFactory.getCurrentSession()
- .createQuery("from Order where idMember_resp = :id " +
- "AND between :endDate and :now " +
- "AND dateDelivery is not null");
- break;
- case 1:
- query = sessionFactory.getCurrentSession()
- .createQuery("from Order where idMember_resp = :id " +
- "AND between :endDate and :now " +
- "AND dateDelivery is null");
- break;
- case 2:
- query = sessionFactory.getCurrentSession()
- .createQuery("from Order where idMember_resp = :id " +
- "AND between :endDate and :now ");
- break;
- }
- query.setParameter("id", memberResp.getIdMember());
- query.setTimestamp("endDate", endDate);
- query.setTimestamp("now", nowT);
- return query.list();
- }
Add Comment
Please, Sign In to add comment