| Line 45... |
Line 45... |
| 45 |
+ " i.modelName,i.modelNumber,cast(pd.amount As integer ),pdi.imei ) from PriceDrop pd join PriceDropIMEI pdi on"
|
45 |
+ " i.modelName,i.modelNumber,cast(pd.amount As integer ),pdi.imei ) from PriceDrop pd join PriceDropIMEI pdi on"
|
| 46 |
+ " (pd.id = pdi.priceDropId) join InventoryItem it on (pdi.imei = it.serialNumber and pdi.partnerId=it.fofoId)"
|
46 |
+ " (pd.id = pdi.priceDropId) join InventoryItem it on (pdi.imei = it.serialNumber and pdi.partnerId=it.fofoId)"
|
| 47 |
+ " join Item i on i.id = it.itemId where pdi.status ='PENDING' and pdi.partnerId = :fofoId and "
|
47 |
+ " join Item i on i.id = it.itemId where pdi.status ='PENDING' and pdi.partnerId = :fofoId and "
|
| 48 |
+ " pd.amount > 0 and i.brand = :brand and pd.affectedOn >= :startDate and pd.affectedOn <= :endDate"),
|
48 |
+ " pd.amount > 0 and i.brand = :brand and pd.affectedOn >= :startDate and pd.affectedOn <= :endDate"),
|
| 49 |
|
49 |
|
| - |
|
50 |
@NamedQuery(name = "PriceDrop.selectPriceDropToReprocess", query = "select distinct pd.id " +
|
| - |
|
51 |
"from PriceDrop pd " +
|
| - |
|
52 |
" join PriceDropIMEI pdi on pd.id = pdi.priceDropId " +
|
| - |
|
53 |
" join ActivatedImei ai on ai.serialNumber = pdi.imei " +
|
| - |
|
54 |
"where pd.affectedOn > ai.activationTimestamp " +
|
| - |
|
55 |
" and pdi.status = 'APPROVED' " +
|
| - |
|
56 |
" and pdi.creditTimestamp >= :dateOnwards"),
|
| - |
|
57 |
|
| 50 |
|
58 |
|
| 51 |
})
|
59 |
})
|
| 52 |
public class PriceDrop implements Serializable {
|
60 |
public class PriceDrop implements Serializable {
|
| 53 |
|
61 |
|
| 54 |
private static final long serialVersionUID = 1L;
|
62 |
private static final long serialVersionUID = 1L;
|