Subversion Repositories SmartDukaan

Rev

Rev 33010 | Rev 33038 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

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

            293