| Line 13... |
Line 13... |
| 13 |
+ " join CustomerOffer co on co.id=coi.customerOfferId where "
|
13 |
+ " join CustomerOffer co on co.id=coi.customerOfferId where "
|
| 14 |
+ " :date between coi.startDate and coi.endDate and "
|
14 |
+ " :date between coi.startDate and coi.endDate and "
|
| 15 |
+ " :dateTime between co.startDate and co.endDate" + " and i.brand in :brands group by i.id"),
|
15 |
+ " :dateTime between co.startDate and co.endDate" + " and i.brand in :brands group by i.id"),
|
| 16 |
|
16 |
|
| 17 |
@NamedQuery(name = "CustomerOffer.getUpgradeOfferItemsByBrand", query = "select new com.spice.profitmandi.service.pricecircular.PriceCircularItemModel("
|
17 |
@NamedQuery(name = "CustomerOffer.getUpgradeOfferItemsByBrand", query = "select new com.spice.profitmandi.service.pricecircular.PriceCircularItemModel("
|
| 18 |
+ " i.id, i.catalogItemId, cast(max(coi.schemePayout) as long),coi.offerType,coi.additionalInfo)"
|
18 |
+ " i.id, i.catalogItemId, cast((coi.schemePayout) as long),coi.offerType,coi.additionalInfo)"
|
| 19 |
+ " from CustomerOfferItem coi join Item i on coi.catalogId = i.catalogItemId"
|
19 |
+ " from CustomerOfferItem coi join Item i on coi.catalogId = i.catalogItemId"
|
| 20 |
+ " join CustomerOffer co on co.id=coi.customerOfferId where "
|
20 |
+ " join CustomerOffer co on co.id=coi.customerOfferId where "
|
| 21 |
+ " :date between coi.startDate and coi.endDate and "
|
21 |
+ " :date between coi.startDate and coi.endDate and "
|
| 22 |
+ " :dateTime between co.startDate and co.endDate" + " and i.brand in :brands group by i.catalogItemId,coi.offerType"),
|
22 |
+ " :dateTime between co.startDate and co.endDate" + " and i.brand in :brands group by i.catalogItemId,coi.offerType,coi.schemePayout"),
|
| 23 |
|
23 |
|
| 24 |
@NamedQuery(name = "CustomerOffer.getMaxOfferItemsByBrand", query = "select new com.spice.profitmandi.service.pricecircular.PriceCircularItemModel("
|
24 |
@NamedQuery(name = "CustomerOffer.getMaxOfferItemsByBrand", query = "select new com.spice.profitmandi.service.pricecircular.PriceCircularItemModel("
|
| 25 |
+ " i.id, i.catalogItemId, cast(max(coi.schemePayout) as long),coi.offerType,coi.additionalInfo)"
|
25 |
+ " i.id, i.catalogItemId, cast(max(coi.schemePayout) as long),coi.offerType,coi.additionalInfo)"
|
| 26 |
+ " from CustomerOfferItem coi join Item i on coi.catalogId = i.catalogItemId"
|
26 |
+ " from CustomerOfferItem coi join Item i on coi.catalogId = i.catalogItemId"
|
| 27 |
+ " join CustomerOffer co on co.id=coi.customerOfferId where "
|
27 |
+ " join CustomerOffer co on co.id=coi.customerOfferId where "
|