Subversion Repositories SmartDukaan

Rev

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