Subversion Repositories SmartDukaan

Rev

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