| Line 18... |
Line 18... |
| 18 |
" join Purchase p on p.id = ii.purchaseId join Order o on o.invoiceNumber = p.purchaseReference" +
|
18 |
" join Purchase p on p.id = ii.purchaseId join Order o on o.invoiceNumber = p.purchaseReference" +
|
| 19 |
" join LineItem li on li.orderId = o.id join LineItemImei lii on (lii.id=li.id and lii.serialNumber=ii.serialNumber)" +
|
19 |
" join LineItem li on li.orderId = o.id join LineItemImei lii on (lii.id=li.id and lii.serialNumber=ii.serialNumber)" +
|
| 20 |
"where ii.id in :inventoryItemIds"),
|
20 |
"where ii.id in :inventoryItemIds"),
|
| 21 |
|
21 |
|
| 22 |
|
22 |
|
| - |
|
23 |
@NamedQuery(name = "InventoryItem.selectActivatedStockAmount",
|
| - |
|
24 |
query = "select coalesce(sum(tl.sellingPrice), 0) from InventoryItem ii" +
|
| - |
|
25 |
" join Item i on i.id = ii.itemId" +
|
| - |
|
26 |
" join TagListing tl on tl.itemId = i.id" +
|
| - |
|
27 |
" join ActivatedImei ai on ai.serialNumber = ii.serialNumber" +
|
| - |
|
28 |
" where ii.goodQuantity = 1 and ai.activationTimestamp is not null" +
|
| - |
|
29 |
" and i.brand != 'Live Demo' and ii.fofoId = :fofoId"),
|
| - |
|
30 |
|
| 23 |
@NamedQuery(name = "InventoryItem.selectPurchaseSummary",
|
31 |
@NamedQuery(name = "InventoryItem.selectPurchaseSummary",
|
| 24 |
query = "select new com.spice.profitmandi.dao.model.ItemPurchaseSummaryModel(" +
|
32 |
query = "select new com.spice.profitmandi.dao.model.ItemPurchaseSummaryModel(" +
|
| 25 |
"ii.id, o.billingTimestamp,o.invoiceNumber, cast(li.unitPrice as float), li.item)" +
|
33 |
"ii.id, o.billingTimestamp,o.invoiceNumber, cast(li.unitPrice as float), li.item)" +
|
| 26 |
"from InventoryItem ii " +
|
34 |
"from InventoryItem ii " +
|
| 27 |
"join Purchase p on p.id = ii.purchaseId " +
|
35 |
"join Purchase p on p.id = ii.purchaseId " +
|