| Line 42... |
Line 42... |
| 42 |
"o.fofoId, pr.regionId, o.id, li.serialNumber, oi.brand, oi.dp, oi.quantity, i.catalogItemId, srh.imeis) " +
|
42 |
"o.fofoId, pr.regionId, o.id, li.serialNumber, oi.brand, oi.dp, oi.quantity, i.catalogItemId, srh.imeis) " +
|
| 43 |
"from ActivatedImei ai " +
|
43 |
"from ActivatedImei ai " +
|
| 44 |
"join FofoLineItem li on li.serialNumber = ai.serialNumber " +
|
44 |
"join FofoLineItem li on li.serialNumber = ai.serialNumber " +
|
| 45 |
"join FofoOrderItem oi on oi.id = li.fofoOrderItemId " +
|
45 |
"join FofoOrderItem oi on oi.id = li.fofoOrderItemId " +
|
| 46 |
"join FofoOrder o on o.id = oi.orderId " +
|
46 |
"join FofoOrder o on o.id = oi.orderId " +
|
| 47 |
"join Item i on i.id = oi.itemId " +
|
47 |
"join Item i on i.id = oi.itemId and i.brand = :brand " +
|
| 48 |
"join PartnerRegion pr on pr.fofoId = o.fofoId " +
|
48 |
"join PartnerRegion pr on pr.fofoId = o.fofoId and pr.regionId = :regionId " +
|
| 49 |
"left join SaleRewardHistory srh on srh.imeis = ai.serialNumber " +
|
49 |
"left join SaleRewardHistory srh on srh.imeis = ai.serialNumber " +
|
| 50 |
"where pr.regionId = :regionId " +
|
- |
|
| 51 |
"and i.brand = :brand " +
|
- |
|
| 52 |
"and ai.activationTimestamp between :orderStartDate and :orderEndDate " +
|
50 |
"where ai.activationTimestamp between :orderStartDate and :orderEndDate "
|
| 53 |
"group by li.serialNumber"
|
- |
|
| 54 |
),
|
51 |
),
|
| 55 |
|
52 |
|
| 56 |
@NamedQuery(
|
53 |
@NamedQuery(
|
| 57 |
name = "LineItem.selectPartnerBrandItemMonthlySecondarySale",
|
54 |
name = "LineItem.selectPartnerBrandItemMonthlySecondarySale",
|
| 58 |
query = "select new com.spice.profitmandi.dao.model.BrandItemWisePartnerSaleModel( " +
|
55 |
query = "select new com.spice.profitmandi.dao.model.BrandItemWisePartnerSaleModel( " +
|