Subversion Repositories SmartDukaan

Rev

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