| Line 9... |
Line 9... |
| 9 |
@Entity
|
9 |
@Entity
|
| 10 |
@Table(name = "fofo.offer_payout")
|
10 |
@Table(name = "fofo.offer_payout")
|
| 11 |
@NamedQueries({
|
11 |
@NamedQueries({
|
| 12 |
@NamedQuery(name = "OfferPayout.selectPaidOffers", query = "select new com.spice.profitmandi.service.transaction.InventoryMarginModel("
|
12 |
@NamedQuery(name = "OfferPayout.selectPaidOffers", query = "select new com.spice.profitmandi.service.transaction.InventoryMarginModel("
|
| 13 |
+ " o.retailerId, li.sgstRate, li.cgstRate, li.igstRate," +
|
13 |
+ " o.retailerId, li.sgstRate, li.cgstRate, li.igstRate," +
|
| 14 |
" cast(case when op.createTimestamp between :startDate and :endDate and op.rejectTimestamp is null then op.amount " +
|
14 |
" cast(case when op.createTimestamp >= :startDate and op.createTimestamp <= :endDate then op.amount " +
|
| 15 |
" when op.createTimestamp between :startDate and :endDate and op.rejectTimestamp between :startDate and :endDate then 0" +
|
- |
|
| 16 |
" when op.rejectTimestamp between :startDate and :endDate then -op.amount" +
|
15 |
" when op.rejectTimestamp >= :startDate and op.rejectTimestamp <= :endDate then -op.amount" +
|
| 17 |
" else 0 end as float), op.inventoryItemId, lii.serialNumber, op.description, o.invoiceNumber, " +
|
16 |
" else 0 end as float), op.inventoryItemId, lii.serialNumber, op.description, o.invoiceNumber, " +
|
| 18 |
" case when op.rejectTimestamp between :startDate and :endDate then op.rejectTimestamp else op.createTimestamp end, ii.hsnCode) from "
|
17 |
" case when op.rejectTimestamp >= :startDate and op.rejectTimestamp <= :endDate then op.rejectTimestamp else op.createTimestamp end, ii.hsnCode) from "
|
| 19 |
+ " OfferPayout op join InventoryItem ii on ii.id=op.inventoryItemId join LineItemImei lii on (op.serialNumber=lii.serialNumber) join LineItem li on li.id=lii.lineItemId "
|
18 |
+ " OfferPayout op join InventoryItem ii on ii.id=op.inventoryItemId join LineItemImei lii on (op.serialNumber=lii.serialNumber) join LineItem li on li.id=lii.lineItemId "
|
| 20 |
+ " join Order o on (o.retailerId=op.fofoId and o.billingTimestamp is not null and o.id=li.orderId) "
|
19 |
+ " join Order o on (o.retailerId=op.fofoId and o.billingTimestamp is not null and o.id=li.orderId) "
|
| 21 |
+ " where op.createTimestamp >= :cnDate and ((op.createTimestamp between :startDate and :endDate) or (op.rejectTimestamp between :startDate and :endDate))"
|
20 |
+ " where op.createTimestamp >= :cnDate and ((op.createTimestamp >= :startDate and op.createTimestamp <= :endDate) or (op.rejectTimestamp >= :startDate and op.rejectTimestamp <= :endDate))"
|
| - |
|
21 |
+ " and not (op.createTimestamp >= :startDate and op.createTimestamp <= :endDate and op.rejectTimestamp >= :startDate and op.rejectTimestamp <= :endDate)"
|
| 22 |
+ " and lii.id=(select max(lii2.id) from LineItemImei lii2 join LineItem li2 on li2.id=lii2.lineItemId join Order o2 on o2.id=li2.orderId where lii2.serialNumber=lii.serialNumber and o2.retailerId=op.fofoId) "
|
22 |
+ " and lii.id=(select max(lii2.id) from LineItemImei lii2 join LineItem li2 on li2.id=lii2.lineItemId join Order o2 on o2.id=li2.orderId where lii2.serialNumber=lii.serialNumber and o2.retailerId=op.fofoId) "
|
| 23 |
+ " AND (:fofoId IS NULL OR o.retailerId = :fofoId)"),
|
23 |
+ " AND (:fofoId IS NULL OR o.retailerId = :fofoId)"),
|
| 24 |
|
24 |
|
| 25 |
|
25 |
|
| 26 |
|
26 |
|