Subversion Repositories SmartDukaan

Rev

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

Rev 34431 Rev 34433
Line 12... Line 12...
12 
				+ " from CustomerOfferItem coi join Item i on coi.catalogId = i.catalogItemId"
 12 
				+ " from CustomerOfferItem coi join Item i on coi.catalogId = i.catalogItemId"
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.getMaxOfferItemsByBrand", 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)"
 18 
				+ " i.id, i.catalogItemId, cast(max(coi.schemePayout) as long),coi.offerType)"
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"),
- 
 
 23 
 
- 
 
 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)"
- 
 
 26 
				+ " from CustomerOfferItem coi join Item i on coi.catalogId = i.catalogItemId"
- 
 
 27 
				+ " join CustomerOffer co on co.id=coi.customerOfferId where "
- 
 
 28 
				+ " :date between coi.startDate and coi.endDate and "
- 
 
 29 
				+ " :dateTime between co.startDate and co.endDate" + " and i.brand in :brands  group by i.id"),
23 
})
 30 
})
24 
public class CustomerOffer {
 31 
public class CustomerOffer {
25 
 
 32 
 
26 
	@Id
 33 
	@Id
27 
	@GeneratedValue(strategy = GenerationType.IDENTITY)
 34 
	@GeneratedValue(strategy = GenerationType.IDENTITY)