| Line 65... |
Line 65... |
| 65 |
" l.igstRate, l.cgstRate, l.sgstRate, org.name, l.hsnCode, s.gstin, state.name )" +
|
65 |
" l.igstRate, l.cgstRate, l.sgstRate, org.name, l.hsnCode, s.gstin, state.name )" +
|
| 66 |
" From Order o join LineItem l on l.orderId = o.id join Item i on l.itemId = i.id join Category c on i.categoryId = c.id join OrderStatus os on os.status=o.status" +
|
66 |
" From Order o join LineItem l on l.orderId = o.id join Item i on l.itemId = i.id join Category c on i.categoryId = c.id join OrderStatus os on os.status=o.status" +
|
| 67 |
" join FofoStore fs on fs.id=o.retailerId join Seller s on s.id=o.sellerId join State state on s.stateId=state.id join Organisation org on org.id=s.organisationId" +
|
67 |
" join FofoStore fs on fs.id=o.retailerId join Seller s on s.id=o.sellerId join State state on s.stateId=state.id join Organisation org on org.id=s.organisationId" +
|
| 68 |
" where 1=1 and o.billingTimestamp between :startDate and :endDate and o.retailerId = :fofoId "),
|
68 |
" where 1=1 and o.billingTimestamp between :startDate and :endDate and o.retailerId = :fofoId "),
|
| 69 |
|
69 |
|
| - |
|
70 |
@NamedQuery(name = "FofoOrder.soldAllItemByToday",
|
| - |
|
71 |
query = "select new com.spice.profitmandi.dao.model.SoldAllCatalogitemQtyByPartnerModel" +
|
| - |
|
72 |
"(i.catalogItemId, foi.modelNumber, SUM(foi.quantity)) " +
|
| - |
|
73 |
"FROM FofoOrder fo " +
|
| - |
|
74 |
"JOIN FofoOrderItem foi ON fo.id = foi.orderId " +
|
| - |
|
75 |
"JOIN Item i ON foi.itemId = i.id " +
|
| - |
|
76 |
"JOIN Catalog c ON i.catalogItemId = c.id " +
|
| - |
|
77 |
"WHERE fo.createTimestamp BETWEEN :startOfDay AND :endOfDay and fo.fofoId = :fofoId " +
|
| - |
|
78 |
"GROUP BY i.catalogItemId")
|
| - |
|
79 |
|
| 70 |
|
80 |
|
| 71 |
})
|
81 |
})
|
| 72 |
|
82 |
|
| 73 |
|
83 |
|
| 74 |
@NamedNativeQueries({
|
84 |
@NamedNativeQueries({
|