Subversion Repositories SmartDukaan

Rev

Rev 36508 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 36508 Rev 36525
Line 68... Line 68...
68 
                        + " count(distinct op.serialNumber), sum(op.amount))"
 68 
                        + " count(distinct op.serialNumber), sum(op.amount))"
69 
                        + " from OfferPayout op join Offer o on o.id=op.offerId"
 69 
                        + " from OfferPayout op join Offer o on o.id=op.offerId"
70 
                        + " where op.fofoId=:fofoId"
 70 
                        + " where op.fofoId=:fofoId"
71 
                        + " and op.createTimestamp >= :startDate and op.createTimestamp <= :endDate"
 71 
                        + " and op.createTimestamp >= :startDate and op.createTimestamp <= :endDate"
72 
                        + " and op.rejectTimestamp is null"
 72 
                        + " and op.rejectTimestamp is null"
- 
 
 73 
                        + " and op.status = 'CREDITED'"
73 
                        + " group by op.offerId, o.name, o.offerNotes")
 74 
                        + " group by op.offerId, o.name, o.offerNotes")
74 
})
 75 
})
75 
public class OfferPayout {
 76 
public class OfferPayout {
76 
        @Id
 77 
        @Id
77 
        @GeneratedValue(strategy = GenerationType.IDENTITY)
 78 
        @GeneratedValue(strategy = GenerationType.IDENTITY)