Subversion Repositories SmartDukaan

Rev

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

Rev 31198 Rev 31199
Line 9... Line 9...
9 
@NamedQueries({
 9 
@NamedQueries({
10 
		@NamedQuery(name = "CustomerOffer.getOfferItemsByBrand", query = "select new com.spice.profitmandi.service.pricecircular.PriceCircularItemModel("
 10 
		@NamedQuery(name = "CustomerOffer.getOfferItemsByBrand", query = "select new com.spice.profitmandi.service.pricecircular.PriceCircularItemModel("
11 
				+ " i.id, i.catalogItemId, cast(sum(coi.schemePayout - coi.dealerPayout) as long))"
 11 
				+ " i.id, i.catalogItemId, cast(sum(coi.schemePayout - coi.dealerPayout) as long))"
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 
				+ " :dateTime between coi.startDate and coi.endDate and "
 14 
				+ " :date between coi.startDate and coi.endDate and "
15 
				+ " :date 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 
public class CustomerOffer {
 16 
public class CustomerOffer {
17 
 
 17 
 
18 
	@Id
 18 
	@Id
19 
	@GeneratedValue(strategy = GenerationType.IDENTITY)
 19 
	@GeneratedValue(strategy = GenerationType.IDENTITY)
20 
	private int id;
 20 
	private int id;