1 2 3 4 5 6 7 8 9 10 11 12 13 14
| Query query = em().createQuery("SELECT p.id, p.name, o.price, SUM(s.quantity), SUM(s.quantity*o.price)"+
" FROM Sale s "+
" INNER JOIN s.offer o"+
" INNER JOIN s.order ord"+
" INNER JOIN o.product p"+
" WHERE o.activityId=:act"+
" AND ord.orderDate BETWEEN :dtCreateFrom AND :dtCreateTo"+
" AND ord.orderStatus =:status" +
" GROUP BY p.id, p.name, o.price"+
" ORDER BY p.id");
query.setParameter("status", orderstatus);
query.setParameter("act", act.getId());
query.setParameter("dtCreateFrom", dtCreateFrom);
query.setParameter("dtCreateTo", dtCreateTo); |
Partager