| Line 7... |
Line 7... |
| 7 |
import java.io.Serializable;
|
7 |
import java.io.Serializable;
|
| 8 |
import java.time.LocalDateTime;
|
8 |
import java.time.LocalDateTime;
|
| 9 |
@NamedQueries({
|
9 |
@NamedQueries({
|
| 10 |
|
10 |
|
| 11 |
|
11 |
|
| 12 |
//@NamedQuery(name = "Offer.selectOfferPayoutDumpReport", query = "select new com.spice.profitmandi.dao.model.OfferPayoutDumpModel(fs.id, fs.code, "+
|
- |
|
| 13 |
//" ua.name,ua.city, ua.state, i.brand, i.modelName, i.modelNumber i.color, op.id, op.serialNumber, op.offerId, o.name, o.schemeType, o.startDate, o.endDate, op.description," +
|
- |
|
| 14 |
//" op.slabAmount, op.amount, op.createTimestamp, op.rejectTimestamp" +
|
- |
|
| - |
|
12 |
|
| 15 |
//" FROM FofoStore fs join User u on u.id = fs.id join Address ua on u.addressId = ua.id " +
|
13 |
/*int id, String code, String name, String city, String state, String brand, String modelName,
|
| 16 |
//" join OfferPayout op on op.fofoId=fs.id + join Offer o on o.id=op.offerId +" +
|
14 |
String modelNumber, String color, String serialNumber,
|
| 17 |
//"left join InventoryItem ii on ii.serialNumber=op.serialNumber left join Item i on i.id=ii.itemId " +
|
15 |
int offerId, String offerName, OfferSchemeType type, LocalDateTime startDate, LocalDateTime endDate, String description, double slabAmount,
|
| 18 |
//"where (op.createTimestamp between :startDate and :endDate) " +
|
16 |
double amount, LocalDateTime createTimestamp, LocalDateTime rejectTimestamp*/
|
| 19 |
//"or (op.rejectTimestamp between :startDate and :endDate) " )
|
- |
|
| 20 |
//group by op.id
|
- |
|
| 21 |
//" where 1=1 and o.billingTimestamp between :startDate and :endDate and o.retailerId = :fofoId "),
|
- |
|
| 22 |
@NamedQuery(name = "Offer.selectOfferPayoutDumpReport", query = "select new com.spice.profitmandi.dao.model.OfferPayoutDumpModel(fs.id, fs.code, " +
|
17 |
@NamedQuery(name = "Offer.selectOfferPayoutDumpReport", query = "select new com.spice.profitmandi.dao.model.OfferPayoutDumpReportModel(fs.id, fs.code, " +
|
| 23 |
"ua.name, ua.city, ua.state, i.brand, i.modelName, i.modelNumber, i.color, op.serialNumber, op.offerId, o.name, o.schemeType, o.startDate, o.endDate, op.description, " +
|
18 |
"ua.name, ua.city, ua.state, i.brand, i.modelName, i.modelNumber, i.color, op.serialNumber, op.offerId, o.name, o.schemeType, o.startDate, o.endDate, op.description, " +
|
| 24 |
"op.slabAmount, op.amount, op.createTimestamp, op.rejectTimestamp) " +
|
19 |
"op.slabAmount, op.amount, op.createTimestamp, op.rejectTimestamp) " +
|
| 25 |
"FROM FofoStore fs " +
|
20 |
"FROM FofoStore fs " +
|
| 26 |
"JOIN User u ON u.id = fs.id " +
|
21 |
"JOIN com.spice.profitmandi.dao.entity.user.User u ON u.id = fs.id " +
|
| 27 |
"JOIN Address ua ON u.addressId = ua.id " +
|
22 |
"JOIN Address ua ON u.addressId = ua.id " +
|
| 28 |
"JOIN OfferPayout op ON op.fofoId = fs.id " +
|
23 |
"JOIN OfferPayout op ON op.fofoId = fs.id " +
|
| 29 |
"JOIN Offer o ON o.id = op.offerId " +
|
24 |
"JOIN Offer o ON o.id = op.offerId " +
|
| 30 |
"LEFT JOIN InventoryItem ii ON ii.serialNumber = op.serialNumber " +
|
25 |
"LEFT JOIN InventoryItem ii ON ii.serialNumber = op.serialNumber " +
|
| 31 |
"LEFT JOIN Item i ON i.id = ii.itemId " +
|
26 |
"LEFT JOIN Item i ON i.id = ii.itemId " +
|