| Line 78... |
Line 78... |
| 78 |
@NamedQuery(name = "FofoOrder.selectPartnerBillingSummaryReport", query = "select new com.spice.profitmandi.dao.model.PartnerBillingSummaryModel(o.id, o.createTimestamp, o.billingTimestamp," +
|
78 |
@NamedQuery(name = "FofoOrder.selectPartnerBillingSummaryReport", query = "select new com.spice.profitmandi.dao.model.PartnerBillingSummaryModel(o.id, o.createTimestamp, o.billingTimestamp," +
|
| 79 |
" o.deliveryTimestamp, o.partnerGrnTimestamp, o.transactionId, case when o.logisticsTransactionId is null then 'NA' else o.logisticsTransactionId end,o.airwayBillNumber, " +
|
79 |
" o.deliveryTimestamp, o.partnerGrnTimestamp, o.transactionId, case when o.logisticsTransactionId is null then 'NA' else o.logisticsTransactionId end,o.airwayBillNumber, " +
|
| 80 |
" os.statusSubGroup, os.statusName, o.retailerId, o.retailerName, i.id, i.brand, i.modelName, i.modelNumber, i.color, l.unitPrice, l.quantity, l.totalPrice, o.invoiceNumber," +
|
80 |
" os.statusSubGroup, os.statusName, o.retailerId, o.retailerName, i.id, i.brand, i.modelName, i.modelNumber, i.color, l.unitPrice, l.quantity, l.totalPrice, o.invoiceNumber," +
|
| 81 |
" l.igstRate, l.cgstRate, l.sgstRate, org.name, l.hsnCode, s.gstin, state.name )" +
|
81 |
" l.igstRate, l.cgstRate, l.sgstRate, org.name, l.hsnCode, s.gstin, state.name )" +
|
| 82 |
" 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" +
|
82 |
" 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" +
|
| 83 |
" join FofoStore fs on fs.id=o.retailerId join Seller s on s.id=o.sellerId join State state on s.stateId join Organisation org on org.id=s.organisationId" +
|
83 |
" 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" +
|
| 84 |
" where 1=1 and o.billingTimestamp between :startDate and :endDate and o.retailerId = :fofoId "),
|
84 |
" where 1=1 and o.billingTimestamp between :startDate and :endDate and o.retailerId = :fofoId "),
|
| 85 |
|
85 |
|
| 86 |
|
86 |
|
| 87 |
})
|
87 |
})
|
| 88 |
|
88 |
|