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
}