Subversion Repositories SmartDukaan

Rev

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

Rev 30121 Rev 31147
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 
				+ " :date between co.startDate and co.endDate"
 - 
 
15 
				+ " and i.brand in :brands  group by i.id"), })
 14 
				+ " :date between co.startDate and co.endDate" + " and i.brand in :brands  group by i.id"), })
16 
public class CustomerOffer {
 15 
public class CustomerOffer {
17 
 
 16 
 
18 
	@Id
 17 
	@Id
19 
	@GeneratedValue(strategy = GenerationType.IDENTITY)
 18 
	@GeneratedValue(strategy = GenerationType.IDENTITY)
20 
	private int id;
 19 
	private int id;
Line 26... Line 25...
26 
	private LocalDateTime startDate;
 25 
	private LocalDateTime startDate;
27 
 
 26 
 
28 
	@Column(name = "end_date")
 27 
	@Column(name = "end_date")
29 
	private LocalDateTime endDate;
 28 
	private LocalDateTime endDate;
30 
 
 29 
 
- 
 
 30 
	@Column(name = "partner_criteria")
- 
 
 31 
	private String partnerCriteria;
- 
 
 32 
 
31 
	@Column(name = "created_timestamp")
 33 
	@Column(name = "created_timestamp")
32 
	private LocalDateTime createdTimestamp;
 34 
	private LocalDateTime createdTimestamp;
33 
 
 35 
 
34 
	@Column(name = "updated_timestamp")
 36 
	@Column(name = "updated_timestamp")
35 
	private LocalDateTime updatedTimestamp;
 37 
	private LocalDateTime updatedTimestamp;
36 
 
 38 
 
- 
 
 39 
	@Transient
- 
 
 40 
	private String partnerCriteriaString;
- 
 
 41 
 
37 
	public int getId() {
 42 
	public int getId() {
38 
		return id;
 43 
		return id;
39 
	}
 44 
	}
40 
 
 45 
 
41 
	public void setId(int id) {
 46 
	public void setId(int id) {
Line 48... Line 53...
48 
 
 53 
 
49 
	public void setOfferName(String offerName) {
 54 
	public void setOfferName(String offerName) {
50 
		this.offerName = offerName;
 55 
		this.offerName = offerName;
51 
	}
 56 
	}
52 
 
 57 
 
- 
 
 58 
	public String getPartnerCriteria() {
- 
 
 59 
		return partnerCriteria;
- 
 
 60 
	}
- 
 
 61 
 
- 
 
 62 
	public void setPartnerCriteria(String partnerCriteria) {
- 
 
 63 
		this.partnerCriteria = partnerCriteria;
- 
 
 64 
	}
- 
 
 65 
 
53 
	public LocalDateTime getStartDate() {
 66 
	public LocalDateTime getStartDate() {
54 
		return startDate;
 67 
		return startDate;
55 
	}
 68 
	}
56 
 
 69 
 
57 
	public void setStartDate(LocalDateTime startDate) {
 70 
	public void setStartDate(LocalDateTime startDate) {
Line 80... Line 93...
80 
 
 93 
 
81 
	public void setUpdatedTimestamp(LocalDateTime updatedTimestamp) {
 94 
	public void setUpdatedTimestamp(LocalDateTime updatedTimestamp) {
82 
		this.updatedTimestamp = updatedTimestamp;
 95 
		this.updatedTimestamp = updatedTimestamp;
83 
	}
 96 
	}
84 
 
 97 
 
- 
 
 98 
	public String getPartnerCriteriaString() {
- 
 
 99 
		return partnerCriteriaString;
- 
 
 100 
	}
- 
 
 101 
 
- 
 
 102 
	public void setPartnerCriteriaString(String partnerCriteriaString) {
- 
 
 103 
		this.partnerCriteriaString = partnerCriteriaString;
- 
 
 104 
	}
- 
 
 105 
 
85 
	@Override
 106 
	@Override
86 
	public String toString() {
 107 
	public String toString() {
87 
		return "CustomerOffer [id=" + id + ", offerName=" + offerName + ", startDate=" + startDate + ", endDate="
 108 
		return "CustomerOffer [id=" + id + ", offerName=" + offerName + ", startDate=" + startDate + ", endDate="
88 
				+ endDate + ", createdTimestamp=" + createdTimestamp + ", updatedTimestamp=" + updatedTimestamp + "]";
 109 
				+ endDate + ", partnerCriteria=" + partnerCriteria + ", createdTimestamp=" + createdTimestamp
- 
 
 110 
				+ ", updatedTimestamp=" + updatedTimestamp + ", partnerCriteriaString=" + partnerCriteriaString + "]";
89 
	}
 111 
	}
90 
 
 112 
 
91 
}
 113 
}