Subversion Repositories SmartDukaan

Rev

Rev 31860 | Rev 34334 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
29707 tejbeer 1 
package com.spice.profitmandi.dao.entity.catalog;
2 
 
30121 amit.gupta 3 
import javax.persistence.*;
29707 tejbeer 4 
import java.time.LocalDateTime;
5 
 
6 
@Entity
31860 tejbeer 7 
@Table(name = "catalog.customer_offers")
29845 amit.gupta 8 
 
9 
@NamedQueries({
10 
		@NamedQuery(name = "CustomerOffer.getOfferItemsByBrand", query = "select new com.spice.profitmandi.service.pricecircular.PriceCircularItemModel("
30121 amit.gupta 11 
				+ " i.id, i.catalogItemId, cast(sum(coi.schemePayout - coi.dealerPayout) as long))"
29845 amit.gupta 12 
				+ " from CustomerOfferItem coi join Item i on coi.catalogId = i.catalogItemId"
13 
				+ " join CustomerOffer co on co.id=coi.customerOfferId where "
31199 amit.gupta 14 
				+ " :date between coi.startDate and coi.endDate and "
33872 ranu 15 
				+ " :dateTime between co.startDate and co.endDate" + " and i.brand in :brands  group by i.id"),
16 
 
17 
		@NamedQuery(name = "CustomerOffer.getMaxOfferItemsByBrand", query = "select new com.spice.profitmandi.service.pricecircular.PriceCircularItemModel("
18 
				+ " i.id, i.catalogItemId, cast(max(coi.schemePayout) as long))"
19 
				+ " from CustomerOfferItem coi join Item i on coi.catalogId = i.catalogItemId"
20 
				+ " join CustomerOffer co on co.id=coi.customerOfferId where "
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.id"),
23 
})
29707 tejbeer 24 
public class CustomerOffer {
25 
 
26 
	@Id
27 
	@GeneratedValue(strategy = GenerationType.IDENTITY)
28 
	private int id;
29 
 
30 
	@Column(name = "offer_name")
31 
	private String offerName;
32 
 
33 
	@Column(name = "start_date")
34 
	private LocalDateTime startDate;
35 
 
36 
	@Column(name = "end_date")
37 
	private LocalDateTime endDate;
38 
 
31147 tejbeer 39 
	@Column(name = "partner_criteria")
40 
	private String partnerCriteria;
41 
 
29707 tejbeer 42 
	@Column(name = "created_timestamp")
43 
	private LocalDateTime createdTimestamp;
44 
 
45 
	@Column(name = "updated_timestamp")
46 
	private LocalDateTime updatedTimestamp;
47 
 
31147 tejbeer 48 
	@Transient
49 
	private String partnerCriteriaString;
50 
 
29707 tejbeer 51 
	public int getId() {
52 
		return id;
53 
	}
54 
 
55 
	public void setId(int id) {
56 
		this.id = id;
57 
	}
58 
 
59 
	public String getOfferName() {
60 
		return offerName;
61 
	}
62 
 
63 
	public void setOfferName(String offerName) {
64 
		this.offerName = offerName;
65 
	}
66 
 
31147 tejbeer 67 
	public String getPartnerCriteria() {
68 
		return partnerCriteria;
69 
	}
70 
 
71 
	public void setPartnerCriteria(String partnerCriteria) {
72 
		this.partnerCriteria = partnerCriteria;
73 
	}
74 
 
29707 tejbeer 75 
	public LocalDateTime getStartDate() {
76 
		return startDate;
77 
	}
78 
 
79 
	public void setStartDate(LocalDateTime startDate) {
80 
		this.startDate = startDate;
81 
	}
82 
 
83 
	public LocalDateTime getEndDate() {
84 
		return endDate;
85 
	}
86 
 
87 
	public void setEndDate(LocalDateTime endDate) {
88 
		this.endDate = endDate;
89 
	}
90 
 
91 
	public LocalDateTime getCreatedTimestamp() {
92 
		return createdTimestamp;
93 
	}
94 
 
95 
	public void setCreatedTimestamp(LocalDateTime createdTimestamp) {
96 
		this.createdTimestamp = createdTimestamp;
97 
	}
98 
 
99 
	public LocalDateTime getUpdatedTimestamp() {
100 
		return updatedTimestamp;
101 
	}
102 
 
103 
	public void setUpdatedTimestamp(LocalDateTime updatedTimestamp) {
104 
		this.updatedTimestamp = updatedTimestamp;
105 
	}
106 
 
31147 tejbeer 107 
	public String getPartnerCriteriaString() {
108 
		return partnerCriteriaString;
109 
	}
110 
 
111 
	public void setPartnerCriteriaString(String partnerCriteriaString) {
112 
		this.partnerCriteriaString = partnerCriteriaString;
113 
	}
114 
 
29707 tejbeer 115 
	@Override
116 
	public String toString() {
117 
		return "CustomerOffer [id=" + id + ", offerName=" + offerName + ", startDate=" + startDate + ", endDate="
31147 tejbeer 118 
				+ endDate + ", partnerCriteria=" + partnerCriteria + ", createdTimestamp=" + createdTimestamp
119 
				+ ", updatedTimestamp=" + updatedTimestamp + ", partnerCriteriaString=" + partnerCriteriaString + "]";
29707 tejbeer 120 
	}
121 
 
122 
}