Subversion Repositories SmartDukaan

Rev

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

Rev Author Line No. Line
26588 tejbeer 1 
package com.spice.profitmandi.dao.entity.catalog;
2 
 
29950 amit.gupta 3 
import com.spice.profitmandi.dao.enumuration.catalog.AchievementType;
4 
import com.spice.profitmandi.dao.enumuration.catalog.OfferSchemeType;
5 
 
6 
import javax.persistence.*;
26588 tejbeer 7 
import java.io.Serializable;
8 
import java.time.LocalDateTime;
32949 shampa 9 
@NamedQueries({
26588 tejbeer 10 
 
32949 shampa 11 
 
32950 amit.gupta 12 
 
13 
		/*int id, String code, String name, String city, String state, String brand, String modelName,
14 
		String modelNumber, String color, String serialNumber,
15 
		int offerId, String offerName, OfferSchemeType type, LocalDateTime startDate, LocalDateTime endDate, String description, double slabAmount,
16 
		double amount, LocalDateTime createTimestamp, LocalDateTime rejectTimestamp*/
17 
		@NamedQuery(name = "Offer.selectOfferPayoutDumpReport", query = "select new com.spice.profitmandi.dao.model.OfferPayoutDumpReportModel(fs.id, fs.code, " +
32949 shampa 18 
				"ua.name, ua.city, ua.state, i.brand, i.modelName, i.modelNumber, i.color,  op.serialNumber, op.offerId, o.name, o.schemeType, o.startDate, o.endDate, op.description, " +
19 
				"op.slabAmount, op.amount, op.createTimestamp, op.rejectTimestamp) " +
20 
				"FROM FofoStore fs " +
32950 amit.gupta 21 
				"JOIN com.spice.profitmandi.dao.entity.user.User u ON u.id = fs.id " +
32949 shampa 22 
				"JOIN Address ua ON u.addressId = ua.id " +
23 
				"JOIN OfferPayout op ON op.fofoId = fs.id " +
24 
				"JOIN Offer o ON o.id = op.offerId " +
25 
				"LEFT JOIN InventoryItem ii ON ii.serialNumber = op.serialNumber " +
26 
				"LEFT JOIN Item i ON i.id = ii.itemId " +
27 
				"WHERE (op.createTimestamp BETWEEN :startDate AND :endDate) " +
28 
				"OR (op.rejectTimestamp BETWEEN :startDate AND :endDate)")
29 
 
30 
 
31 
})
26588 tejbeer 32 
@Entity
31860 tejbeer 33 
@Table(name = "catalog.offer")
26588 tejbeer 34 
public class Offer implements Serializable {
35 
 
29707 tejbeer 36 
	@Id
37 
	@Column(name = "id")
38 
	@GeneratedValue(strategy = GenerationType.IDENTITY)
39 
	private int id;
26588 tejbeer 40 
 
29707 tejbeer 41 
	@Column(name = "brand_share_percentage", nullable = false)
42 
	private double brandSharePercentage;
26588 tejbeer 43 
 
29707 tejbeer 44 
	@Column(name = "name")
45 
	private String name;
26588 tejbeer 46 
 
29707 tejbeer 47 
	@Column(name = "offer_notes")
48 
	private String offerNotes;
26588 tejbeer 49 
 
29707 tejbeer 50 
	@Column(name = "terms")
51 
	private String terms;
26588 tejbeer 52 
 
29707 tejbeer 53 
	@Column(name = "scheme_type")
54 
	@Enumerated(EnumType.STRING)
55 
	private OfferSchemeType schemeType;
26588 tejbeer 56 
 
30121 amit.gupta 57 
	@Column(name = "base_criteria", nullable = false)
29795 amit.gupta 58 
	private boolean baseCriteia;
26588 tejbeer 59 
 
29707 tejbeer 60 
	@Column(name = "sellin_percentage")
61 
	private double sellinPercentage;
28019 amit.gupta 62 
 
29707 tejbeer 63 
	@Column(name = "target_type")
64 
	@Enumerated(EnumType.STRING)
65 
	private AchievementType targetType;
26674 tejbeer 66 
 
29707 tejbeer 67 
	@Column(name = "payout_type")
68 
	@Enumerated(EnumType.STRING)
69 
	private AchievementType payoutType;
26694 tejbeer 70 
 
29707 tejbeer 71 
	@Column(name = "activation_brands")
72 
	private String activationBrands;
26674 tejbeer 73 
 
29707 tejbeer 74 
	@Column(name = "item_criteria")
75 
	private String itemCriteria;
26674 tejbeer 76 
 
29707 tejbeer 77 
	@Column(name = "partner_criteria")
78 
	private String partnerCriteria;
26674 tejbeer 79 
 
29707 tejbeer 80 
	@Column(name = "start_date")
81 
	private LocalDateTime startDate = LocalDateTime.now();
26694 tejbeer 82 
 
29707 tejbeer 83 
	@Column(name = "end_date")
84 
	private LocalDateTime endDate = LocalDateTime.now();
26694 tejbeer 85 
 
29707 tejbeer 86 
	@Column(name = "created_timestamp")
87 
	private LocalDateTime createdTimestamp = LocalDateTime.now();
26694 tejbeer 88 
 
31191 amit.gupta 89 
	@Column(name = "booster")
90 
	private boolean booster = false;
91 
 
32021 amit.gupta 92 
 
93 
	@Column(name = "discount")
94 
	private boolean discount = false;
95 
 
29707 tejbeer 96 
	@Column(name = "active", columnDefinition = "TINYINT(1)")
97 
	private boolean active;
27878 amit.gupta 98 
 
31606 amit.gupta 99 
	public LocalDateTime getProcessedTimestamp() {
100 
		return processedTimestamp;
101 
	}
102 
 
103 
	public void setProcessedTimestamp(LocalDateTime processedTimestamp) {
104 
		this.processedTimestamp = processedTimestamp;
105 
	}
106 
 
31618 amit.gupta 107 
	@Column(name = "processed_timestamp")
31605 amit.gupta 108 
	private LocalDateTime processedTimestamp;
109 
 
29950 amit.gupta 110 
 
29707 tejbeer 111 
	public AchievementType getPayoutType() {
27918 amit.gupta 112 
		return payoutType;
113 
	}
114 
 
115 
	public void setPayoutType(AchievementType payoutType) {
116 
		this.payoutType = payoutType;
117 
	}
118 
 
29795 amit.gupta 119 
	public boolean isBaseCriteia() {
120 
		return baseCriteia;
28019 amit.gupta 121 
	}
122 
 
29795 amit.gupta 123 
	public void setBaseCriteia(boolean baseCriteia) {
124 
		this.baseCriteia = baseCriteia;
28019 amit.gupta 125 
	}
126 
 
31191 amit.gupta 127 
	public boolean isBooster() {
128 
		return booster;
129 
	}
130 
 
131 
	public void setBooster(boolean booster) {
132 
		this.booster = booster;
133 
	}
134 
 
29610 amit.gupta 135 
	@Transient
27878 amit.gupta 136 
 
137 
 
32949 shampa 138 
 
139 
 
29707 tejbeer 140 
	public String getActivationBrands() {
27878 amit.gupta 141 
		return activationBrands;
26588 tejbeer 142 
	}
143 
 
27878 amit.gupta 144 
	public void setActivationBrands(String activationBrands) {
145 
		this.activationBrands = activationBrands;
26588 tejbeer 146 
	}
147 
 
148 
 
29707 tejbeer 149 
	public int getId() {
150 
		return id;
151 
	}
26588 tejbeer 152 
 
29707 tejbeer 153 
	public double getBrandSharePercentage() {
154 
		return brandSharePercentage;
155 
	}
26588 tejbeer 156 
 
29707 tejbeer 157 
	public void setBrandSharePercentage(double brandSharePercentage) {
158 
		this.brandSharePercentage = brandSharePercentage;
159 
	}
26588 tejbeer 160 
 
29707 tejbeer 161 
	public void setId(int id) {
162 
		this.id = id;
163 
	}
26588 tejbeer 164 
 
29707 tejbeer 165 
	public String getName() {
166 
		return name;
167 
	}
26588 tejbeer 168 
 
29707 tejbeer 169 
	public void setName(String name) {
170 
		this.name = name;
171 
	}
26588 tejbeer 172 
 
29707 tejbeer 173 
	public String getOfferNotes() {
174 
		return offerNotes;
175 
	}
26588 tejbeer 176 
 
29707 tejbeer 177 
	public void setOfferNotes(String offerNotes) {
178 
		this.offerNotes = offerNotes;
179 
	}
26588 tejbeer 180 
 
29707 tejbeer 181 
	public String getTerms() {
182 
		return terms;
183 
	}
26588 tejbeer 184 
 
29707 tejbeer 185 
	public void setTerms(String terms) {
186 
		this.terms = terms;
187 
	}
26588 tejbeer 188 
 
29707 tejbeer 189 
	public OfferSchemeType getSchemeType() {
190 
		return schemeType;
191 
	}
26588 tejbeer 192 
 
29707 tejbeer 193 
	public void setSchemeType(OfferSchemeType schemeType) {
194 
		this.schemeType = schemeType;
195 
	}
26588 tejbeer 196 
 
29707 tejbeer 197 
	public double getSellinPercentage() {
198 
		return sellinPercentage;
199 
	}
26588 tejbeer 200 
 
29707 tejbeer 201 
	public void setSellinPercentage(double sellinPercentage) {
202 
		this.sellinPercentage = sellinPercentage;
203 
	}
26588 tejbeer 204 
 
29707 tejbeer 205 
	public AchievementType getTargetType() {
206 
		return targetType;
207 
	}
26588 tejbeer 208 
 
29707 tejbeer 209 
	public void setTargetType(AchievementType targetType) {
210 
		this.targetType = targetType;
211 
	}
26694 tejbeer 212 
 
29707 tejbeer 213 
	public String getItemCriteria() {
214 
		return itemCriteria;
215 
	}
26694 tejbeer 216 
 
29707 tejbeer 217 
	public void setItemCriteria(String itemCriteria) {
218 
		this.itemCriteria = itemCriteria;
219 
	}
26588 tejbeer 220 
 
29707 tejbeer 221 
	public String getPartnerCriteria() {
222 
		return partnerCriteria;
223 
	}
26674 tejbeer 224 
 
29707 tejbeer 225 
	public void setPartnerCriteria(String partnerCriteria) {
226 
		this.partnerCriteria = partnerCriteria;
227 
	}
26674 tejbeer 228 
 
29707 tejbeer 229 
	public LocalDateTime getStartDate() {
230 
		return startDate;
231 
	}
26674 tejbeer 232 
 
29707 tejbeer 233 
	public void setStartDate(LocalDateTime startDate) {
234 
		this.startDate = startDate;
235 
	}
26588 tejbeer 236 
 
29707 tejbeer 237 
	public LocalDateTime getEndDate() {
238 
		return endDate;
239 
	}
26588 tejbeer 240 
 
29707 tejbeer 241 
	public void setEndDate(LocalDateTime endDate) {
242 
		this.endDate = endDate;
243 
	}
26588 tejbeer 244 
 
29707 tejbeer 245 
	public LocalDateTime getCreatedTimestamp() {
246 
		return createdTimestamp;
247 
	}
26588 tejbeer 248 
 
29707 tejbeer 249 
	public void setCreatedTimestamp(LocalDateTime createdTimestamp) {
250 
		this.createdTimestamp = createdTimestamp;
251 
	}
26588 tejbeer 252 
 
29707 tejbeer 253 
	public boolean isActive() {
254 
		return active;
255 
	}
26588 tejbeer 256 
 
29707 tejbeer 257 
	public void setActive(boolean active) {
258 
		this.active = active;
259 
	}
26588 tejbeer 260 
 
32021 amit.gupta 261 
	@Override
262 
	public String toString() {
263 
		return "Offer{" +
264 
				"id=" + id +
265 
				", brandSharePercentage=" + brandSharePercentage +
266 
				", name='" + name + '\'' +
267 
				", offerNotes='" + offerNotes + '\'' +
268 
				", terms='" + terms + '\'' +
269 
				", schemeType=" + schemeType +
270 
				", baseCriteia=" + baseCriteia +
271 
				", sellinPercentage=" + sellinPercentage +
272 
				", targetType=" + targetType +
273 
				", payoutType=" + payoutType +
274 
				", activationBrands='" + activationBrands + '\'' +
275 
				", itemCriteria='" + itemCriteria + '\'' +
276 
				", partnerCriteria='" + partnerCriteria + '\'' +
277 
				", startDate=" + startDate +
278 
				", endDate=" + endDate +
279 
				", createdTimestamp=" + createdTimestamp +
280 
				", booster=" + booster +
281 
				", discount=" + discount +
282 
				", active=" + active +
283 
				", processedTimestamp=" + processedTimestamp +
32949 shampa 284 
 
32021 amit.gupta 285 
				'}';
286 
	}
287 
 
288 
	public boolean isDiscount() {
289 
		return discount;
290 
	}
291 
 
292 
	public void setDiscount(boolean discount) {
293 
		this.discount = discount;
294 
	}
27878 amit.gupta 295 
}