Subversion Repositories SmartDukaan

Rev

Rev 27729 | Rev 27749 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 27729 Rev 27738
Line 51... Line 51...
51 
				+ "	sum(case when o.billingTimestamp >= :today then li.quantity else 0 end),"
 51 
				+ "	sum(case when o.billingTimestamp >= :today then li.quantity else 0 end),"
52 
				+ "	sum(case when o.billingTimestamp >= :threedays and o.billingTimestamp < :endDate then li.quantity else 0 end),"
 52 
				+ "	sum(case when o.billingTimestamp >= :threedays and o.billingTimestamp < :endDate then li.quantity else 0 end),"
53 
				+ " sum(case when concat(year(o.billingTimestamp), month(o.billingTimestamp))= :mtd  then li.quantity else 0 end),"
 53 
				+ " sum(case when concat(year(o.billingTimestamp), month(o.billingTimestamp))= :mtd  then li.quantity else 0 end),"
54 
				+ "	sum(case when o.billingTimestamp between  :lmtdStartDate and :lmtdEndDate then li.quantity else 0 end))"
 54 
				+ "	sum(case when o.billingTimestamp between  :lmtdStartDate and :lmtdEndDate then li.quantity else 0 end))"
55 
				+ "	 from Order o join LineItem li on o.id = li.orderId where o.billingTimestamp is not null and o.refundTimestamp is null"
 55 
				+ "	 from Order o join LineItem li on o.id = li.orderId where o.billingTimestamp is not null and o.refundTimestamp is null"
56 
				+ "	and o.billingTimestamp >= :lmtdStartDate and o.warehouseId in :warehouseId group by li.brand")
 56 
				+ "	and o.billingTimestamp >= :lmtdStartDate and o.warehouseId in :warehouseId group by li.brand"),
- 
 
 57 
 
- 
 
 58 
		@NamedQuery(name = "Order.selectAllBilledOrderItemByBrand", query = "select new com.spice.profitmandi.dao.model.SecondaryOrderItemBillingModel(li.brand,i.modelName, "
- 
 
 59 
				+ " i.modelNumber, i.color," + "o.totalAmount," + "	 li.quantity)"
- 
 
 60 
				+ "	 from Order o join LineItem li on o.id = li.orderId join Item i on i.id = li.itemId where o.billingTimestamp is not null and o.refundTimestamp is null"
- 
 
 61 
				+ "	and o.billingTimestamp >= :startDate and o.billingTimestamp < :endDate and o.warehouseId in :warehouseId and li.brand = :brand"),
- 
 
 62 
 
- 
 
 63 
		@NamedQuery(name = "Order.selectTodayBilledOrderItemByBrand", query = "select new com.spice.profitmandi.dao.model.SecondaryOrderItemBillingModel(li.brand,i.modelName, "
- 
 
 64 
				+ " i.modelNumber, i.color," + "o.totalAmount," + "	 li.quantity)"
- 
 
 65 
				+ "	 from Order o join LineItem li on o.id = li.orderId join Item i on i.id = li.itemId where o.billingTimestamp is not null and o.refundTimestamp is null"
- 
 
 66 
				+ "	and o.billingTimestamp >= :startDate and o.warehouseId in :warehouseId and li.brand = :brand")
57 
 
 67 
 
58 
})
 68 
})
59 
public class Order implements Serializable {
 69 
public class Order implements Serializable {
60 
 
 70 
 
61 
	private static final long serialVersionUID = 1L;
 71 
	private static final long serialVersionUID = 1L;