| Line 31... |
Line 31... |
| 31 |
@NamedQuery(name = "FofoOrder.selectGroupByBrandPartnerTertiary", query = "select new com.spice.profitmandi.dao.model.BrandWiseTertiaryModel(foi.brand, "
|
31 |
@NamedQuery(name = "FofoOrder.selectGroupByBrandPartnerTertiary", query = "select new com.spice.profitmandi.dao.model.BrandWiseTertiaryModel(foi.brand, "
|
| 32 |
+ "sum(case when foi.createTimestamp >= :today then CAST(foi.quantity*foi.mop AS int) else 0 end),"
|
32 |
+ "sum(case when foi.createTimestamp >= :today then CAST(foi.quantity*foi.mop AS int) else 0 end),"
|
| 33 |
+ "sum(case when foi.createTimestamp >= :threedays and foi.createTimestamp < :endDate then CAST(foi.quantity*foi.mop AS int) else 0 end),"
|
33 |
+ "sum(case when foi.createTimestamp >= :threedays and foi.createTimestamp < :endDate then CAST(foi.quantity*foi.mop AS int) else 0 end),"
|
| 34 |
+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :mtd then CAST(foi.quantity*foi.mop AS int) else 0 end),"
|
34 |
+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :mtd then CAST(foi.quantity*foi.mop AS int) else 0 end),"
|
| 35 |
+ "sum(case when foi.createTimestamp between :lmtdStartDate and :lmtdEndDate then CAST(foi.quantity*foi.mop AS int) else 0 end),"
|
35 |
+ "sum(case when foi.createTimestamp between :lmtdStartDate and :lmtdEndDate then CAST(foi.quantity*foi.mop AS int) else 0 end),"
|
| - |
|
36 |
+ "sum(case when foi.createTimestamp between :lmtdStartDate and :lmsEndDate then CAST(foi.quantity*foi.mop AS int) else 0 end),"
|
| 36 |
+ "sum(case when foi.createTimestamp >= :today then foi.quantity else 0 end),"
|
37 |
+ "sum(case when foi.createTimestamp >= :today then foi.quantity else 0 end),"
|
| 37 |
+ "sum(case when foi.createTimestamp >= :threedays and foi.createTimestamp < :endDate then foi.quantity else 0 end),"
|
38 |
+ "sum(case when foi.createTimestamp >= :threedays and foi.createTimestamp < :endDate then foi.quantity else 0 end),"
|
| 38 |
+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :mtd then foi.quantity else 0 end), "
|
39 |
+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :mtd then foi.quantity else 0 end), "
|
| 39 |
+ "sum(case when foi.createTimestamp between :lmtdStartDate and :lmtdEndDate then foi.quantity else 0 end))"
|
40 |
+ "sum(case when foi.createTimestamp between :lmtdStartDate and :lmtdEndDate then foi.quantity else 0 end),"
|
| - |
|
41 |
+ "sum(case when foi.createTimestamp between :lmtdStartDate and :lmsEndDate then foi.quantity else 0 end)"
|
| - |
|
42 |
+ " )"
|
| 40 |
+ " from FofoStore fs join FofoOrder fo on fs.id = fo.fofoId join FofoOrderItem foi on foi.orderId = fo.id join Item i on i.id = foi.itemId where fo.cancelledTimestamp is null and fs.active = true "
|
43 |
+ " from FofoStore fs join FofoOrder fo on fs.id = fo.fofoId join FofoOrderItem foi on foi.orderId = fo.id join Item i on i.id = foi.itemId "
|
| - |
|
44 |
+ " where fo.cancelledTimestamp is null and fs.active = true "
|
| 41 |
+ " and foi.createTimestamp >= :lmtdStartDate and fs.warehouseId in :warehouseId"
|
45 |
+ " and foi.createTimestamp >= :lmtdStartDate and fs.warehouseId in :warehouseId"
|
| 42 |
+ " group by foi.brand"),
|
46 |
+ " group by foi.brand "),
|
| 43 |
|
47 |
|
| 44 |
@NamedQuery(name = "FofoOrder.selectItemPartnerTertiaryByBrand", query = "select new com.spice.profitmandi.dao.model.BrandItemWiseTertiaryModel(foi.brand, i.modelName,"
|
48 |
@NamedQuery(name = "FofoOrder.selectItemPartnerTertiaryByBrand", query = "select new com.spice.profitmandi.dao.model.BrandItemWiseTertiaryModel(foi.brand, i.modelName,"
|
| 45 |
+ " i.modelNumber, i.color, foi.quantity*foi.mop, foi.quantity)"
|
49 |
+ " i.modelNumber, i.color, foi.quantity*foi.mop, foi.quantity)"
|
| 46 |
+ " from FofoStore fs join FofoOrder fo on fs.id = fo.fofoId join FofoOrderItem foi on foi.orderId = fo.id join "
|
50 |
+ " from FofoStore fs join FofoOrder fo on fs.id = fo.fofoId join FofoOrderItem foi on foi.orderId = fo.id join "
|
| 47 |
+ " Item i on i.id = foi.itemId where fo.cancelledTimestamp is null and fs.active = true "
|
51 |
+ " Item i on i.id = foi.itemId where fo.cancelledTimestamp is null and fs.active = true "
|
| 48 |
+ " and foi.createTimestamp >= :startDate and foi.createTimestamp < :endDate and fs.warehouseId in :warehouseId and foi.brand = :brand"),
|
52 |
+ " and foi.createTimestamp >= :startDate and foi.createTimestamp < :endDate and fs.warehouseId in :warehouseId and foi.brand in :brand order by foi.itemId desc"),
|
| 49 |
|
53 |
|
| 50 |
@NamedQuery(name = "FofoOrder.selectTodayItemPartnerTertiaryByBrand", query = "select new com.spice.profitmandi.dao.model.BrandItemWiseTertiaryModel(foi.brand, i.modelName,"
|
54 |
@NamedQuery(name = "FofoOrder.selectTodayItemPartnerTertiaryByBrand", query = "select new com.spice.profitmandi.dao.model.BrandItemWiseTertiaryModel(foi.brand, i.modelName,"
|
| 51 |
+ " i.modelNumber, i.color, foi.quantity*foi.mop, foi.quantity)"
|
55 |
+ " i.modelNumber, i.color, foi.quantity*foi.mop, foi.quantity)"
|
| 52 |
+ " from FofoStore fs join FofoOrder fo on fs.id = fo.fofoId join FofoOrderItem foi on foi.orderId = fo.id join "
|
56 |
+ " from FofoStore fs join FofoOrder fo on fs.id = fo.fofoId join FofoOrderItem foi on foi.orderId = fo.id join "
|
| 53 |
+ " Item i on i.id = foi.itemId where fo.cancelledTimestamp is null and fs.active = true "
|
57 |
+ " Item i on i.id = foi.itemId where fo.cancelledTimestamp is null and fs.active = true "
|
| 54 |
+ " and foi.createTimestamp >= :startDate and fs.warehouseId in :warehouseId and foi.brand = :brand"),
|
58 |
+ " and foi.createTimestamp >= :startDate and fs.warehouseId in :warehouseId and foi.brand in :brand order by foi.itemId desc"),
|
| 55 |
|
59 |
|
| 56 |
})
|
60 |
})
|
| 57 |
public class FofoOrder implements Serializable {
|
61 |
public class FofoOrder implements Serializable {
|
| 58 |
|
62 |
|
| 59 |
private static final long serialVersionUID = 1L;
|
63 |
private static final long serialVersionUID = 1L;
|