| Line 79... |
Line 79... |
| 79 |
" join Item i on i.id=ii.itemId" +
|
79 |
" join Item i on i.id=ii.itemId" +
|
| 80 |
" join TagListing tl on tl.itemId=i.id" +
|
80 |
" join TagListing tl on tl.itemId=i.id" +
|
| 81 |
" join ActivatedImei ai on ai.serialNumber=ii.serialNumber" +
|
81 |
" join ActivatedImei ai on ai.serialNumber=ii.serialNumber" +
|
| 82 |
" WHERE ii.goodQuantity=1 and ai.activationTimestamp is not null and ai.activationTimestamp >= :startDate " +
|
82 |
" WHERE ii.goodQuantity=1 and ai.activationTimestamp is not null and ai.activationTimestamp >= :startDate " +
|
| 83 |
" and ii.fofoId= :fofoId group by DATE_FORMAT(ai.activationTimestamp, '%Y-%m')"),
|
83 |
" and ii.fofoId= :fofoId group by DATE_FORMAT(ai.activationTimestamp, '%Y-%m')"),
|
| - |
|
84 |
|
| - |
|
85 |
@NamedQuery(name = "ActivatedImei.getMonthlyUnbilledTertiaryPriceForFofoIds", query = "select new com.spice.profitmandi.dao.model.PartnerWiseActivatedNotBilledTotal(ii.fofoId, sum((tl.mop)), DATE_FORMAT(ai.activationTimestamp, '%Y-%m')) "
|
| - |
|
86 |
+" from InventoryItem ii" +
|
| - |
|
87 |
" join Item i on i.id=ii.itemId" +
|
| - |
|
88 |
" join TagListing tl on tl.itemId=i.id" +
|
| - |
|
89 |
" join ActivatedImei ai on ai.serialNumber=ii.serialNumber" +
|
| - |
|
90 |
" WHERE ii.goodQuantity=1 and ai.activationTimestamp is not null and ai.activationTimestamp >= :startDate " +
|
| - |
|
91 |
" and ii.fofoId in :fofoIds group by ii.fofoId, DATE_FORMAT(ai.activationTimestamp, '%Y-%m')"),
|
| 84 |
})
|
92 |
})
|
| 85 |
public class ActivatedImei {
|
93 |
public class ActivatedImei {
|
| 86 |
@Id
|
94 |
@Id
|
| 87 |
@Column(name = "serial_number", unique = true)
|
95 |
@Column(name = "serial_number", unique = true)
|
| 88 |
private String serialNumber;
|
96 |
private String serialNumber;
|