Subversion Repositories SmartDukaan

Rev

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

Rev 24081 Rev 27723
Line 8... Line 8...
8 
import javax.persistence.EnumType;
 8 
import javax.persistence.EnumType;
9 
import javax.persistence.Enumerated;
 9 
import javax.persistence.Enumerated;
10 
import javax.persistence.GeneratedValue;
 10 
import javax.persistence.GeneratedValue;
11 
import javax.persistence.GenerationType;
 11 
import javax.persistence.GenerationType;
12 
import javax.persistence.Id;
 12 
import javax.persistence.Id;
- 
 
 13 
import javax.persistence.NamedQueries;
- 
 
 14 
import javax.persistence.NamedQuery;
13 
import javax.persistence.Table;
 15 
import javax.persistence.Table;
14 
 
 16 
 
15 
import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;
 17 
import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;
16 
 
 18 
 
17 
import in.shop2020.warehouse.ScanType;
 19 
import in.shop2020.warehouse.ScanType;
- 
 
 20 
 
18 
/**
 21 
/**
19 
 * This class basically contains scheme details
 22 
 * This class basically contains scheme details
20 
 *
23 
 *
21 
 * @author Govind Kumar
 24 
 * @author Govind Kumar
22 
 *
 25 
 *
23 
 */
 26 
 */
24 
@Entity
 27 
@Entity
25 
@Table(name = "warehouse.scanNew", schema = "warehouse")
 28 
@Table(name = "warehouse.scanNew", schema = "warehouse")
- 
 
 29 
@NamedQueries({
- 
 
 30 
		@NamedQuery(name = "warehouse.selectOurPurchase", query = "select new com.spice.profitmandi.dao.model.OurPurchaseModel(li.brand, "
- 
 
 31 
				+ " sum(case when sn.scannedAt >= :today then CAST(sn.quantity * li.unitPrice  AS int) else 0 end),"
- 
 
 32 
				+ " sum(case when sn.scannedAt >= :threedays and sn.scannedAt <= :endDate then CAST(sn.quantity * li.unitPrice  AS int) else 0 end),"
- 
 
 33 
				+ " sum(case when sn.scannedAt >= :fifteendays and sn.scannedAt <= :endDate then CAST(sn.quantity * li.unitPrice  AS int) else 0 end),"
- 
 
 34 
				+ " sum(case when sn.scannedAt >= :startDate then CAST(sn.quantity * li.unitPrice  AS int) else 0 end),"
- 
 
 35 
				+ " sum(case when sn.scannedAt >= :today then CAST(sn.quantity  AS int) else 0 end),"
- 
 
 36 
				+ " sum(case when sn.scannedAt >= :threedays and sn.scannedAt <= :endDate then CAST(sn.quantity  AS int) else 0 end),"
- 
 
 37 
				+ " sum(case when sn.scannedAt >= :fifteendays and sn.scannedAt <= :endDate then CAST(sn.quantity AS int) else 0 end),"
- 
 
 38 
				+ " sum(case when sn.scannedAt >= :startDate then CAST(sn.quantity AS int) else 0 end)" + " )"
- 
 
 39 
				+ " from WarehouseScan sn join WarehouseInventoryItem it on sn.inventoryItemId = it.id join WarehousePurchase p on it.purchaseId = p.id "
- 
 
 40 
				+ " join WarehousePurchaseOrder po on po.id = p.poId join WarehouseLineItem li on li.purchaseOrderId = po.id and po.warehouseId in :warehouseId where sn.scannedAt >= :dataDate group by li.brand"),
- 
 
 41 
 
- 
 
 42 
})
26 
public class WarehouseScan {
 43 
public class WarehouseScan {
27 
 
 44 
 
28 
	@Id
 45 
	@Id
29 
	@Column(name = "id", unique = true, updatable = false)
 46 
	@Column(name = "id", unique = true, updatable = false)
30 
	@GeneratedValue(strategy = GenerationType.IDENTITY)
 47 
	@GeneratedValue(strategy = GenerationType.IDENTITY)
Line 33... Line 50...
33 
	@Column(name = "inventoryItemId")
 50 
	@Column(name = "inventoryItemId")
34 
	private int inventoryItemId;
 51 
	private int inventoryItemId;
35 
 
 52 
 
36 
	@Column(name = "quantity")
 53 
	@Column(name = "quantity")
37 
	private Integer quantity;
 54 
	private Integer quantity;
38
55 
 
39 
	@Column(name = "orderId")
 56 
	@Column(name = "orderId")
40 
	private Integer orderId; // The order that was fulfilled with thin scan!
 57 
	private Integer orderId; // The order that was fulfilled with thin scan!
41
58 
 
42 
	@Column(name = "warehouseId")
 59 
	@Column(name = "warehouseId")
43 
	private int warehouseId;
 60 
	private int warehouseId;
44
61 
 
45 
	@Column(name = "transferLotId")
 62 
	@Column(name = "transferLotId")
46 
	private Integer transferLotId;
 63 
	private Integer transferLotId;
47
64 
 
48 
	@Column(name = "type")
 65 
	@Column(name = "type")
49 
	@Enumerated(EnumType.STRING)
 66 
	@Enumerated(EnumType.STRING)
50 
	private ScanType type;
 67 
	private ScanType type;
51
68 
 
52 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
 69 
	@Convert(converter = LocalDateTimeAttributeConverter.class)
53 
	@Column(name = "scannedAt")
 70 
	@Column(name = "scannedAt")
54 
	private LocalDateTime scannedAt;
 71 
	private LocalDateTime scannedAt;
55
72 
 
56 
	@Column(name = "remarks")
 73 
	@Column(name = "remarks")
57 
	private String remarks;
 74 
	private String remarks;
58 
 
 75 
 
59 
	public int getId() {
 76 
	public int getId() {
60 
		return id;
 77 
		return id;
Line 194... Line 211...
194 
		return "WarehouseScan [id=" + id + ", inventoryItemId=" + inventoryItemId + ", quantity=" + quantity
 211 
		return "WarehouseScan [id=" + id + ", inventoryItemId=" + inventoryItemId + ", quantity=" + quantity
195 
				+ ", orderId=" + orderId + ", warehouseId=" + warehouseId + ", transferLotId=" + transferLotId
 212 
				+ ", orderId=" + orderId + ", warehouseId=" + warehouseId + ", transferLotId=" + transferLotId
196 
				+ ", type=" + type + ", scannedAt=" + scannedAt + ", remarks=" + remarks + "]";
 213 
				+ ", type=" + type + ", scannedAt=" + scannedAt + ", remarks=" + remarks + "]";
197 
	}
 214 
	}
198 
 
 215 
 
199
- 
 
200 
 
 - 
 
201 
}
 216 
}