| Line 117... |
Line 117... |
| 117 |
+ " join fofo.scheme_region sre on sre.scheme_id = cs.id"
|
117 |
+ " join fofo.scheme_region sre on sre.scheme_id = cs.id"
|
| 118 |
+ " join cs.partner_region pr on (pr.region_id = sre.region_id and (pr.fofo_id = ii.fofo_id or pr.fofo_id = 0))"
|
118 |
+ " join cs.partner_region pr on (pr.region_id = sre.region_id and (pr.fofo_id = ii.fofo_id or pr.fofo_id = 0))"
|
| 119 |
+ " left join fofo.scheme_in_out sio on (sio.scheme_id = cs.id and sio.inventory_item_id = ii.id) "
|
119 |
+ " left join fofo.scheme_in_out sio on (sio.scheme_id = cs.id and sio.inventory_item_id = ii.id) "
|
| 120 |
+ " where cs.active_timestamp is not null " + " and cs.type ='SPECIAL_SUPPORT'"
|
120 |
+ " where cs.active_timestamp is not null " + " and cs.type ='SPECIAL_SUPPORT'"
|
| 121 |
+ " and sr.type = 'SALE'" + " and (sio.id is null or sio.status='REJECTED') "
|
121 |
+ " and sr.type = 'SALE'" + " and (sio.id is null or sio.status='REJECTED') "
|
| 122 |
, resultSetMapping = "missedActivationSaleMapping") })
|
122 |
+ " and ai.checked = false", resultSetMapping = "missedActivationSaleMapping") })
|
| 123 |
|
123 |
|
| 124 |
@SqlResultSetMappings({ @SqlResultSetMapping(name = "missedActivationSaleMapping", classes = {
|
124 |
@SqlResultSetMappings({ @SqlResultSetMapping(name = "missedActivationSaleMapping", classes = {
|
| 125 |
@ConstructorResult(targetClass = SchemesImeisModel.class, columns = {
|
125 |
@ConstructorResult(targetClass = SchemesImeisModel.class, columns = {
|
| 126 |
@ColumnResult(name = "serial_number", type = String.class),
|
126 |
@ColumnResult(name = "serial_number", type = String.class),
|
| 127 |
@ColumnResult(name = "activation_timestamp", type = LocalDateTime.class),
|
127 |
@ColumnResult(name = "activation_timestamp", type = LocalDateTime.class),
|