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 
}