| Line 53... |
Line 53... |
| 53 |
+ " sum(case when o.billingTimestamp >= :threedays and o.billingTimestamp < :endDate then li.quantity else 0 end),"
|
53 |
+ " sum(case when o.billingTimestamp >= :threedays and o.billingTimestamp < :endDate then li.quantity else 0 end),"
|
| 54 |
+ " sum(case when concat(year(o.billingTimestamp), month(o.billingTimestamp))= :mtd then li.quantity else 0 end),"
|
54 |
+ " sum(case when concat(year(o.billingTimestamp), month(o.billingTimestamp))= :mtd then li.quantity else 0 end),"
|
| 55 |
+ " sum(case when o.billingTimestamp between :lmtdStartDate and :lmtdEndDate then li.quantity else 0 end),"
|
55 |
+ " sum(case when o.billingTimestamp between :lmtdStartDate and :lmtdEndDate then li.quantity else 0 end),"
|
| 56 |
+ " sum(case when o.billingTimestamp between :lmtdStartDate and :lmsEndDate then li.quantity else 0 end)"
|
56 |
+ " sum(case when o.billingTimestamp between :lmtdStartDate and :lmsEndDate then li.quantity else 0 end)"
|
| 57 |
+ " )"
|
57 |
+ " )"
|
| 58 |
+ " from Order o join LineItem li on o.id = li.orderId where o.billingTimestamp is not null and o.refundTimestamp is null"
|
58 |
+ " from Order o join LineItem li on o.id = li.orderId join FofoStore fs on fs.id = o.retailerId where o.billingTimestamp is not null and o.refundTimestamp is null"
|
| 59 |
+ " and o.billingTimestamp >= :lmtdStartDate and o.warehouseId in :warehouseId group by li.brand"),
|
59 |
+ " and o.billingTimestamp >= :lmtdStartDate and fs.warehouseId in :warehouseId group by li.brand"),
|
| 60 |
|
60 |
|
| 61 |
@NamedQuery(name = "Order.selectAllBilledOrderItemByBrand", query = "select new com.spice.profitmandi.dao.model.SecondaryOrderItemBillingModel(o.retailerName,li.brand,i.modelName, "
|
61 |
@NamedQuery(name = "Order.selectAllBilledOrderItemByBrand", query = "select new com.spice.profitmandi.dao.model.SecondaryOrderItemBillingModel(o.retailerName,li.brand,i.modelName, "
|
| 62 |
+ " i.modelNumber, i.color," + "o.totalAmount," + " li.quantity)"
|
62 |
+ " i.modelNumber, i.color," + "o.totalAmount," + " li.quantity)"
|
| 63 |
+ " from Order o join LineItem li on o.id = li.orderId join Item i on i.id = li.itemId join FofoStore fs on fs.id = o.retailerId where o.billingTimestamp is not null and o.refundTimestamp is null"
|
63 |
+ " from Order o join LineItem li on o.id = li.orderId join Item i on i.id = li.itemId join FofoStore fs on fs.id = o.retailerId where o.billingTimestamp is not null and o.refundTimestamp is null"
|
| 64 |
+ " and o.billingTimestamp >= :startDate and o.billingTimestamp < :endDate and fs.warehouseId in :warehouseId and li.brand in :brand order by li.itemId desc"),
|
64 |
+ " and o.billingTimestamp >= :startDate and o.billingTimestamp < :endDate and fs.warehouseId in :warehouseId and li.brand in :brand order by li.itemId desc"),
|