Subversion Repositories SmartDukaan

Rev

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

Rev 29707 Rev 29845
Line 5... Line 5...
5 
import javax.persistence.Column;
 5 
import javax.persistence.Column;
6 
import javax.persistence.Entity;
 6 
import javax.persistence.Entity;
7 
import javax.persistence.GeneratedValue;
 7 
import javax.persistence.GeneratedValue;
8 
import javax.persistence.GenerationType;
 8 
import javax.persistence.GenerationType;
9 
import javax.persistence.Id;
 9 
import javax.persistence.Id;
- 
 
 10 
import javax.persistence.NamedQueries;
- 
 
 11 
import javax.persistence.NamedQuery;
10 
import javax.persistence.Table;
 12 
import javax.persistence.Table;
11 
 
 13 
 
12 
@Entity
 14 
@Entity
13 
@Table(name = "catalog.customer_offers", schema = "catalog")
 15 
@Table(name = "catalog.customer_offers", schema = "catalog")
- 
 
 16 
 
- 
 
 17 
@NamedQueries({
- 
 
 18 
		@NamedQuery(name = "CustomerOffer.getOfferItemsByBrand", query = "select new com.spice.profitmandi.service.pricecircular.PriceCircularItemModel("
- 
 
 19 
				+ " i.id, cast(sum(coi.schemePayout - coi.dealerPayout) as long))"
- 
 
 20 
				+ " from CustomerOfferItem coi join Item i on coi.catalogId = i.catalogItemId"
- 
 
 21 
				+ " join CustomerOffer co on co.id=coi.customerOfferId where "
- 
 
 22 
				+ " :date between co.startDate and co.endDate"
- 
 
 23 
				+ " and i.brand in :brands  group by i.id"), })
14 
public class CustomerOffer {
 24 
public class CustomerOffer {
15 
 
 25 
 
16 
	@Id
 26 
	@Id
17 
	@GeneratedValue(strategy = GenerationType.IDENTITY)
 27 
	@GeneratedValue(strategy = GenerationType.IDENTITY)
18 
	private int id;
 28 
	private int id;