| Line 56... |
Line 56... |
| 56 |
+ " from FofoStore fs join FofoOrder fo on fs.id = fo.fofoId join FofoOrderItem foi on foi.orderId = fo.id join "
|
56 |
+ " from FofoStore fs join FofoOrder fo on fs.id = fo.fofoId join FofoOrderItem foi on foi.orderId = fo.id join "
|
| 57 |
+ " Item i on i.id = foi.itemId where fo.cancelledTimestamp is null and fs.active = true "
|
57 |
+ " Item i on i.id = foi.itemId where fo.cancelledTimestamp is null and fs.active = true "
|
| 58 |
+ " and foi.createTimestamp >= :startDate and fs.warehouseId in :warehouseId and foi.brand in :brand order by foi.itemId desc"),
|
58 |
+ " and foi.createTimestamp >= :startDate and fs.warehouseId in :warehouseId and foi.brand in :brand order by foi.itemId desc"),
|
| 59 |
|
59 |
|
| 60 |
@NamedQuery(name = "FofoOrder.selectValueOfActivatedImeis", query = "select new com.spice.profitmandi.common.model.ActivatedImeisWithSellingPrice("
|
60 |
@NamedQuery(name = "FofoOrder.selectValueOfActivatedImeis", query = "select new com.spice.profitmandi.common.model.ActivatedImeisWithSellingPrice("
|
| 61 |
+ " fo.fofoId, foi.brand, sum(CAST(foi.sellingPrice AS int) * foi.quantity)) "
|
61 |
+ " fo.fofoId, foi.brand, sum(CAST(foi.mop AS int) * foi.quantity)) "
|
| 62 |
+ " from FofoOrder fo join FofoOrderItem foi on fo.id = foi.orderId join FofoLineItem fli on foi.id = fli.fofoOrderItemId join ActivatedImei ai on "
|
62 |
+ " from FofoOrder fo join FofoOrderItem foi on fo.id = foi.orderId join FofoLineItem fli on foi.id = fli.fofoOrderItemId join ActivatedImei ai on "
|
| 63 |
+ " fli.serialNumber = ai.serialNumber where fo.createTimestamp between :startDate and :endDate and fo.fofoId = :fofoId and fo.cancelledTimestamp is null group by foi.brand")
|
63 |
+ " fli.serialNumber = ai.serialNumber where fo.createTimestamp between :startDate and :endDate and fo.fofoId = :fofoId and fo.cancelledTimestamp is null group by foi.brand")
|
| 64 |
|
64 |
|
| 65 |
})
|
65 |
})
|
| 66 |
public class FofoOrder implements Serializable {
|
66 |
public class FofoOrder implements Serializable {
|