| Line 127... |
Line 127... |
| 127 |
|
127 |
|
| 128 |
|
128 |
|
| 129 |
@NamedQuery(name = "Order.getLastOrderByFofoId", query = "select COALESCE(Max(o.id),0) from Order o where o.retailerId = :fofoId and o.status in (7,9,10,12)"),
|
129 |
@NamedQuery(name = "Order.getLastOrderByFofoId", query = "select COALESCE(Max(o.id),0) from Order o where o.retailerId = :fofoId and o.status in (7,9,10,12)"),
|
| 130 |
|
130 |
|
| 131 |
@NamedQuery(name = "Order.selectOrderValueByCreateDateGroupByFofoId", query = "select new com.spice.profitmandi.common.model.IdAmountModel(o.retailerId, sum(o.totalAmount)) from Order o where o.retailerId in :retailerIds and o.status in :status and o.createTimestamp between :startDate and :endDate group by o.retailerId"),
|
131 |
@NamedQuery(name = "Order.selectOrderValueByCreateDateGroupByFofoId", query = "select new com.spice.profitmandi.common.model.IdAmountModel(o.retailerId, sum(o.totalAmount)) from Order o where o.retailerId in :retailerIds and o.status in :status and o.createTimestamp between :startDate and :endDate group by o.retailerId"),
|
| - |
|
132 |
|
| - |
|
133 |
@NamedQuery(name = "Order.selectOrderValueByBillingDateGroupByFofoId", query = "select new com.spice.profitmandi.common.model.IdAmountModel(o.retailerId, sum(o.totalAmount)) from Order o where o.retailerId in :retailerIds and o.billingTimestamp between :startDate and :endDate group by o.retailerId"),
|
| - |
|
134 |
|
| 132 |
@NamedQuery(name = "Order.selectOrdersByBilledDateCatalogId",
|
135 |
@NamedQuery(name = "Order.selectOrdersByBilledDateCatalogId",
|
| 133 |
query = "select new com.spice.profitmandi.common.model.GrnPendingDataModel(" +
|
136 |
query = "select new com.spice.profitmandi.common.model.GrnPendingDataModel(" +
|
| 134 |
"o.retailerId, fs.code, o.retailerName, o.invoiceNumber, o.billingTimestamp, l.itemId, l.brand, l.modelName, l.modelNumber, l.color, " +
|
137 |
"o.retailerId, fs.code, o.retailerName, o.invoiceNumber, o.billingTimestamp, l.itemId, l.brand, l.modelName, l.modelNumber, l.color, " +
|
| 135 |
"l.unitPrice, lii.serialNumber, v.name, wi.created, ai.activationTimestamp, ai.createTimestamp)" +
|
138 |
"l.unitPrice, lii.serialNumber, v.name, wi.created, ai.activationTimestamp, ai.createTimestamp)" +
|
| 136 |
|
139 |
|