Guest User

Untitled

a guest
Dec 14th, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.24 KB | None | 0 0
  1. @SuppressWarnings("unchecked")
  2.     @Transactional(readOnly=true)
  3.     public List<Order> getOldOrders(Member memberResp, long end, int dateDeliveryType) {
  4.        
  5.         //dateDeliveryType
  6.         // 0 = Impostata
  7.         // 1 = Non Impostata
  8.         // 2 = Entrambe
  9.        
  10.         Timestamp endDate = new Timestamp(end);
  11.         Date now = new Date();
  12.         Timestamp nowT = new Timestamp(now.getTime());
  13.        
  14.         Query query = null;
  15.        
  16.         switch(dateDeliveryType)
  17.         {
  18.             case 0:
  19.                
  20.                 query = sessionFactory.getCurrentSession()
  21.                 .createQuery("from Order where idMember_resp = :id " +
  22.                                           "AND between :endDate and :now " +
  23.                                           "AND dateDelivery is not null");
  24.                
  25.                 break;
  26.             case 1:
  27.                
  28.                 query = sessionFactory.getCurrentSession()
  29.                 .createQuery("from Order where idMember_resp = :id " +
  30.                                           "AND between :endDate and :now " +
  31.                                           "AND dateDelivery is null");
  32.                
  33.                 break;
  34.             case 2:
  35.                
  36.                 query = sessionFactory.getCurrentSession()
  37.                 .createQuery("from Order where idMember_resp = :id " +
  38.                                           "AND between :endDate and :now ");
  39.                
  40.                 break;
  41.        
  42.         }
  43.        
  44.         query.setParameter("id", memberResp.getIdMember());
  45.         query.setTimestamp("endDate", endDate);
  46.         query.setTimestamp("now", nowT);
  47.    
  48.         return query.list();
  49.     }
Add Comment
Please, Sign In to add comment