| Line 10... |
Line 10... |
| 10 |
* This class basically contains scheme details
|
10 |
* This class basically contains scheme details
|
| 11 |
*
|
11 |
*
|
| 12 |
* @author Govind Kumar
|
12 |
* @author Govind Kumar
|
| 13 |
*/
|
13 |
*/
|
| 14 |
@Entity
|
14 |
@Entity
|
| 15 |
@Table(name = "warehouse.scanNew", schema = "warehouse")
|
15 |
@Table(name = "warehouse.scanNew")
|
| 16 |
@NamedQueries({
|
16 |
@NamedQueries({
|
| 17 |
@NamedQuery(name = "warehouse.selectOurPurchase", query = "select new com.spice.profitmandi.dao.model.OurPurchaseModel(li.brand, "
|
17 |
@NamedQuery(name = "warehouse.selectOurPurchase", query = "select new com.spice.profitmandi.dao.model.OurPurchaseModel(li.brand, "
|
| 18 |
+ " sum(case when sn.scannedAt >= :today then CAST(sn.quantity * li.unitPrice AS int) else 0 end),"
|
18 |
+ " sum(case when sn.scannedAt >= :today then CAST(sn.quantity * li.unitPrice AS int) else 0 end),"
|
| 19 |
+ " sum(case when sn.scannedAt >= :threedays and sn.scannedAt < :endDate then CAST(sn.quantity * li.unitPrice AS int) else 0 end),"
|
19 |
+ " sum(case when sn.scannedAt >= :threedays and sn.scannedAt < :endDate then CAST(sn.quantity * li.unitPrice AS int) else 0 end),"
|
| 20 |
+ " sum(case when sn.scannedAt >= :dataDate and sn.scannedAt < :lmsEndDate then CAST(sn.quantity * li.unitPrice AS int) else 0 end),"
|
20 |
+ " sum(case when sn.scannedAt >= :dataDate and sn.scannedAt < :lmsEndDate then CAST(sn.quantity * li.unitPrice AS int) else 0 end),"
|