Subversion Repositories SmartDukaan

Rev

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

Rev 27728 Rev 27730
Line 35... Line 35...
35 
				+ " sum(case when sn.scannedAt >= :today then CAST(sn.quantity  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),"
 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),"
 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)" + " )"
 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 "
 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"),
 40 
				+ " join WarehousePurchaseOrder po on po.id = p.poId join WarehouseLineItem li on li.purchaseOrderId = po.id "
- 
 
 41 
				+ " and po.warehouseId in :warehouseId where sn.scannedAt >= :dataDate and sn.type = 'PURCHASE' group by li.brand"),
41 
 
 42 
 
42 
})
 43 
})
43 
public class WarehouseScan {
 44 
public class WarehouseScan {
44 
 
 45 
 
45 
	@Id
 46 
	@Id