| Line 5... |
Line 5... |
| 5 |
import javax.persistence.*;
|
5 |
import javax.persistence.*;
|
| 6 |
import java.time.LocalDateTime;
|
6 |
import java.time.LocalDateTime;
|
| 7 |
import java.util.Objects;
|
7 |
import java.util.Objects;
|
| 8 |
|
8 |
|
| 9 |
@Entity
|
9 |
@Entity
|
| 10 |
@Table(name = "fofo.offer_payout", schema = "fofo")
|
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 between :startDate and :endDate and op.rejectTimestamp is null then op.amount " +
|
| 15 |
" when op.createTimestamp between :startDate and :endDate and op.rejectTimestamp between :startDate and :endDate then 0" +
|
15 |
" when op.createTimestamp between :startDate and :endDate and op.rejectTimestamp between :startDate and :endDate then 0" +
|