Subversion Repositories SmartDukaan

Rev

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

Rev Author Line No. Line
26332 amit.gupta 1
 
21714 ashik.ali 2
package com.spice.profitmandi.dao.entity.fofo;
21596 ashik.ali 3
 
4
import java.io.Serializable;
23019 ashik.ali 5
import java.time.LocalDateTime;
21687 ashik.ali 6
import java.util.Set;
21596 ashik.ali 7
 
21687 ashik.ali 8
import javax.persistence.CascadeType;
21596 ashik.ali 9
import javax.persistence.Column;
23019 ashik.ali 10
import javax.persistence.Convert;
21596 ashik.ali 11
import javax.persistence.Entity;
21687 ashik.ali 12
import javax.persistence.FetchType;
21596 ashik.ali 13
import javax.persistence.GeneratedValue;
14
import javax.persistence.GenerationType;
15
import javax.persistence.Id;
21687 ashik.ali 16
import javax.persistence.JoinColumn;
31285 tejbeer 17
import javax.persistence.NamedQueries;
18
import javax.persistence.NamedQuery;
21687 ashik.ali 19
import javax.persistence.OneToMany;
21596 ashik.ali 20
import javax.persistence.Table;
24094 amit.gupta 21
import javax.persistence.Transient;
21596 ashik.ali 22
import javax.persistence.UniqueConstraint;
23
 
23019 ashik.ali 24
import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;
25
 
21596 ashik.ali 26
@Entity
31860 tejbeer 27
@Table(name = "fofo.fofo_order_item", uniqueConstraints = {
28566 tejbeer 28
		@UniqueConstraint(name = "UK_ORDER_ID_AND_ITEM_ID", columnNames = { "order_id", "item_id" }) })
31285 tejbeer 29
 
30
@NamedQueries({
31
		@NamedQuery(name = "FofoOrderItem.selectPartnerMonthlySale", query = "select new com.spice.profitmandi.dao.model.PartnerMonthlySaleModel(fo.fofoId, "
32
				+ " DATE_FORMAT(foi.createTimestamp, '%m-%Y'),sum(CAST(foi.quantity*foi.mop  AS int))) from  FofoOrder fo join FofoOrderItem foi on "
33
				+ " fo.id = foi.orderId  where fo.fofoId in :fofoIds and fo.cancelledTimestamp is null "
34
				+ " and foi.createTimestamp >= :startDate"
35
				+ " group by fo.fofoId,DATE_FORMAT(foi.createTimestamp, '%m-%Y')"), })
28566 tejbeer 36
public class FofoOrderItem implements Serializable {
21596 ashik.ali 37
 
38
	private static final long serialVersionUID = 1L;
39
 
40
	@Id
41
	@Column(name = "id")
42
	@GeneratedValue(strategy = GenerationType.IDENTITY)
43
	private int id;
28566 tejbeer 44
 
21596 ashik.ali 45
	@Column(name = "order_id")
46
	private int orderId;
28566 tejbeer 47
 
21596 ashik.ali 48
	@Column(name = "item_id")
49
	private int itemId;
28566 tejbeer 50
 
21596 ashik.ali 51
	@Column(name = "quantity")
52
	private int quantity;
28566 tejbeer 53
 
21596 ashik.ali 54
	@Column(name = "selling_price")
55
	private float sellingPrice;
28566 tejbeer 56
 
21710 ashik.ali 57
	@Column(name = "cost")
58
	private float cost;
28566 tejbeer 59
 
26332 amit.gupta 60
	@Column(name = "mop")
61
	private float mop;
28566 tejbeer 62
 
21895 ashik.ali 63
	@Column(name = "igst_rate")
64
	private float igstRate;
28566 tejbeer 65
 
21895 ashik.ali 66
	@Column(name = "cgst_rate")
67
	private float cgstRate;
28566 tejbeer 68
 
21895 ashik.ali 69
	@Column(name = "sgst_rate")
70
	private float sgstRate;
28566 tejbeer 71
 
21895 ashik.ali 72
	@Column(name = "hsn_code")
73
	private String hsnCode;
28566 tejbeer 74
 
21596 ashik.ali 75
	@Column(name = "dp")
76
	private float dp;
28566 tejbeer 77
 
21596 ashik.ali 78
	@Column(name = "brand")
79
	private String brand;
28566 tejbeer 80
 
21596 ashik.ali 81
	@Column(name = "model_name")
82
	private String modelName;
28566 tejbeer 83
 
21596 ashik.ali 84
	@Column(name = "model_number")
85
	private String modelNumber;
28566 tejbeer 86
 
21596 ashik.ali 87
	@Column(name = "color")
88
	private String color;
28566 tejbeer 89
 
22580 ashik.ali 90
	@Column(name = "discount")
91
	private float discount;
28566 tejbeer 92
 
24094 amit.gupta 93
	@Transient
94
	private boolean doa;
28566 tejbeer 95
 
96
	@Transient
97
	private String itemName;
98
 
24094 amit.gupta 99
	public boolean isDoa() {
100
		return doa;
101
	}
28566 tejbeer 102
 
103
	public String getItemName() {
104
		return itemName;
105
	}
106
 
107
	public void setItemName(String itemName) {
108
		this.itemName = itemName;
109
	}
110
 
24094 amit.gupta 111
	public void setDoa(boolean doa) {
112
		this.doa = doa;
113
	}
28566 tejbeer 114
 
23019 ashik.ali 115
	@Convert(converter = LocalDateTimeAttributeConverter.class)
116
	@Column(name = "create_timestamp")
117
	private LocalDateTime createTimestamp = LocalDateTime.now();
28566 tejbeer 118
 
119
	@OneToMany(cascade = CascadeType.ALL, fetch = FetchType.EAGER)
120
	@JoinColumn(name = "fofo_order_item_id", insertable = false, updatable = false, nullable = false)
22859 ashik.ali 121
	private Set<FofoLineItem> fofoLineItems;
28566 tejbeer 122
 
21596 ashik.ali 123
	public int getId() {
124
		return id;
125
	}
28566 tejbeer 126
 
21596 ashik.ali 127
	public void setId(int id) {
128
		this.id = id;
129
	}
28566 tejbeer 130
 
21596 ashik.ali 131
	public int getOrderId() {
132
		return orderId;
133
	}
28566 tejbeer 134
 
21596 ashik.ali 135
	public void setOrderId(int orderId) {
136
		this.orderId = orderId;
137
	}
28566 tejbeer 138
 
21596 ashik.ali 139
	public int getItemId() {
140
		return itemId;
141
	}
28566 tejbeer 142
 
21596 ashik.ali 143
	public void setItemId(int itemId) {
144
		this.itemId = itemId;
145
	}
28566 tejbeer 146
 
21596 ashik.ali 147
	public int getQuantity() {
148
		return quantity;
149
	}
28566 tejbeer 150
 
21596 ashik.ali 151
	public void setQuantity(int quantity) {
152
		this.quantity = quantity;
153
	}
28566 tejbeer 154
 
21596 ashik.ali 155
	public float getSellingPrice() {
156
		return sellingPrice;
157
	}
28566 tejbeer 158
 
21596 ashik.ali 159
	public void setSellingPrice(float sellingPrice) {
160
		this.sellingPrice = sellingPrice;
161
	}
28566 tejbeer 162
 
21710 ashik.ali 163
	public float getCost() {
164
		return cost;
165
	}
28566 tejbeer 166
 
21710 ashik.ali 167
	public void setCost(float cost) {
168
		this.cost = cost;
169
	}
28566 tejbeer 170
 
26332 amit.gupta 171
	public float getMop() {
172
		return mop;
173
	}
28566 tejbeer 174
 
26332 amit.gupta 175
	public void setMop(float mop) {
176
		this.mop = mop;
177
	}
28566 tejbeer 178
 
21895 ashik.ali 179
	public float getIgstRate() {
180
		return igstRate;
21596 ashik.ali 181
	}
28566 tejbeer 182
 
21895 ashik.ali 183
	public void setIgstRate(float igstRate) {
184
		this.igstRate = igstRate;
21596 ashik.ali 185
	}
28566 tejbeer 186
 
21895 ashik.ali 187
	public float getCgstRate() {
188
		return cgstRate;
21687 ashik.ali 189
	}
28566 tejbeer 190
 
21895 ashik.ali 191
	public void setCgstRate(float cgstRate) {
192
		this.cgstRate = cgstRate;
21687 ashik.ali 193
	}
28566 tejbeer 194
 
21895 ashik.ali 195
	public float getSgstRate() {
196
		return sgstRate;
197
	}
28566 tejbeer 198
 
21895 ashik.ali 199
	public void setSgstRate(float sgstRate) {
200
		this.sgstRate = sgstRate;
201
	}
28566 tejbeer 202
 
21895 ashik.ali 203
	public String getHsnCode() {
204
		return hsnCode;
205
	}
28566 tejbeer 206
 
21895 ashik.ali 207
	public void setHsnCode(String hsnCode) {
208
		this.hsnCode = hsnCode;
209
	}
28566 tejbeer 210
 
21596 ashik.ali 211
	public float getDp() {
212
		return dp;
213
	}
26332 amit.gupta 214
 
21596 ashik.ali 215
	public void setDp(float dp) {
216
		this.dp = dp;
217
	}
28566 tejbeer 218
 
21596 ashik.ali 219
	public String getBrand() {
220
		return brand;
221
	}
28566 tejbeer 222
 
21596 ashik.ali 223
	public void setBrand(String brand) {
224
		this.brand = brand;
225
	}
28566 tejbeer 226
 
21596 ashik.ali 227
	public String getModelName() {
228
		return modelName;
229
	}
28566 tejbeer 230
 
21596 ashik.ali 231
	public void setModelName(String modelName) {
232
		this.modelName = modelName;
233
	}
28566 tejbeer 234
 
21596 ashik.ali 235
	public String getModelNumber() {
236
		return modelNumber;
237
	}
28566 tejbeer 238
 
21596 ashik.ali 239
	public void setModelNumber(String modelNumber) {
240
		this.modelNumber = modelNumber;
241
	}
28566 tejbeer 242
 
21596 ashik.ali 243
	public String getColor() {
244
		return color;
245
	}
28566 tejbeer 246
 
21596 ashik.ali 247
	public void setColor(String color) {
248
		this.color = color;
249
	}
28566 tejbeer 250
 
22580 ashik.ali 251
	public float getDiscount() {
252
		return discount;
253
	}
28566 tejbeer 254
 
22580 ashik.ali 255
	public void setDiscount(float discount) {
256
		this.discount = discount;
257
	}
28566 tejbeer 258
 
23019 ashik.ali 259
	public LocalDateTime getCreateTimestamp() {
260
		return createTimestamp;
261
	}
28566 tejbeer 262
 
23019 ashik.ali 263
	public void setCreateTimestamp(LocalDateTime createTimestamp) {
264
		this.createTimestamp = createTimestamp;
265
	}
28566 tejbeer 266
 
22859 ashik.ali 267
	public Set<FofoLineItem> getFofoLineItems() {
268
		return fofoLineItems;
21687 ashik.ali 269
	}
28566 tejbeer 270
 
22859 ashik.ali 271
	public void setFofoLineItems(Set<FofoLineItem> fofoLineItems) {
272
		this.fofoLineItems = fofoLineItems;
21687 ashik.ali 273
	}
28566 tejbeer 274
 
21602 ashik.ali 275
	@Override
21924 ashik.ali 276
	public int hashCode() {
277
		final int prime = 31;
278
		int result = 1;
28566 tejbeer 279
		result = prime * result + ((brand == null) ? 0 : brand.hashCode());
280
		result = prime * result + Float.floatToIntBits(cgstRate);
281
		result = prime * result + ((color == null) ? 0 : color.hashCode());
282
		result = prime * result + Float.floatToIntBits(cost);
283
		result = prime * result + ((createTimestamp == null) ? 0 : createTimestamp.hashCode());
284
		result = prime * result + Float.floatToIntBits(discount);
285
		result = prime * result + (doa ? 1231 : 1237);
286
		result = prime * result + Float.floatToIntBits(dp);
287
		result = prime * result + ((fofoLineItems == null) ? 0 : fofoLineItems.hashCode());
288
		result = prime * result + ((hsnCode == null) ? 0 : hsnCode.hashCode());
21924 ashik.ali 289
		result = prime * result + id;
28566 tejbeer 290
		result = prime * result + Float.floatToIntBits(igstRate);
291
		result = prime * result + itemId;
292
		result = prime * result + ((itemName == null) ? 0 : itemName.hashCode());
293
		result = prime * result + ((modelName == null) ? 0 : modelName.hashCode());
294
		result = prime * result + ((modelNumber == null) ? 0 : modelNumber.hashCode());
295
		result = prime * result + Float.floatToIntBits(mop);
296
		result = prime * result + orderId;
297
		result = prime * result + quantity;
298
		result = prime * result + Float.floatToIntBits(sellingPrice);
299
		result = prime * result + Float.floatToIntBits(sgstRate);
21924 ashik.ali 300
		return result;
301
	}
28566 tejbeer 302
 
21924 ashik.ali 303
	@Override
304
	public boolean equals(Object obj) {
305
		if (this == obj)
306
			return true;
307
		if (obj == null)
308
			return false;
309
		if (getClass() != obj.getClass())
310
			return false;
22859 ashik.ali 311
		FofoOrderItem other = (FofoOrderItem) obj;
28566 tejbeer 312
		if (brand == null) {
313
			if (other.brand != null)
314
				return false;
315
		} else if (!brand.equals(other.brand))
316
			return false;
317
		if (Float.floatToIntBits(cgstRate) != Float.floatToIntBits(other.cgstRate))
318
			return false;
319
		if (color == null) {
320
			if (other.color != null)
321
				return false;
322
		} else if (!color.equals(other.color))
323
			return false;
324
		if (Float.floatToIntBits(cost) != Float.floatToIntBits(other.cost))
325
			return false;
326
		if (createTimestamp == null) {
327
			if (other.createTimestamp != null)
328
				return false;
329
		} else if (!createTimestamp.equals(other.createTimestamp))
330
			return false;
331
		if (Float.floatToIntBits(discount) != Float.floatToIntBits(other.discount))
332
			return false;
333
		if (doa != other.doa)
334
			return false;
335
		if (Float.floatToIntBits(dp) != Float.floatToIntBits(other.dp))
336
			return false;
337
		if (fofoLineItems == null) {
338
			if (other.fofoLineItems != null)
339
				return false;
340
		} else if (!fofoLineItems.equals(other.fofoLineItems))
341
			return false;
342
		if (hsnCode == null) {
343
			if (other.hsnCode != null)
344
				return false;
345
		} else if (!hsnCode.equals(other.hsnCode))
346
			return false;
21924 ashik.ali 347
		if (id != other.id)
348
			return false;
28566 tejbeer 349
		if (Float.floatToIntBits(igstRate) != Float.floatToIntBits(other.igstRate))
350
			return false;
351
		if (itemId != other.itemId)
352
			return false;
353
		if (itemName == null) {
354
			if (other.itemName != null)
355
				return false;
356
		} else if (!itemName.equals(other.itemName))
357
			return false;
358
		if (modelName == null) {
359
			if (other.modelName != null)
360
				return false;
361
		} else if (!modelName.equals(other.modelName))
362
			return false;
363
		if (modelNumber == null) {
364
			if (other.modelNumber != null)
365
				return false;
366
		} else if (!modelNumber.equals(other.modelNumber))
367
			return false;
368
		if (Float.floatToIntBits(mop) != Float.floatToIntBits(other.mop))
369
			return false;
370
		if (orderId != other.orderId)
371
			return false;
372
		if (quantity != other.quantity)
373
			return false;
374
		if (Float.floatToIntBits(sellingPrice) != Float.floatToIntBits(other.sellingPrice))
375
			return false;
376
		if (Float.floatToIntBits(sgstRate) != Float.floatToIntBits(other.sgstRate))
377
			return false;
21924 ashik.ali 378
		return true;
379
	}
28566 tejbeer 380
 
21924 ashik.ali 381
	@Override
21602 ashik.ali 382
	public String toString() {
22859 ashik.ali 383
		return "FofoOrderItem [id=" + id + ", orderId=" + orderId + ", itemId=" + itemId + ", quantity=" + quantity
26332 amit.gupta 384
				+ ", sellingPrice=" + sellingPrice + ", cost=" + cost + ", mop=" + mop + ", igstRate=" + igstRate
385
				+ ", cgstRate=" + cgstRate + ", sgstRate=" + sgstRate + ", hsnCode=" + hsnCode + ", dp=" + dp
386
				+ ", brand=" + brand + ", modelName=" + modelName + ", modelNumber=" + modelNumber + ", color=" + color
28566 tejbeer 387
				+ ", discount=" + discount + ", doa=" + doa + ", itemName=" + itemName + ", createTimestamp="
388
				+ createTimestamp + ", fofoLineItems=" + fofoLineItems + "]";
21602 ashik.ali 389
	}
28566 tejbeer 390
 
21596 ashik.ali 391
}