| Line 1317... |
Line 1317... |
| 1317 |
notification.setUrl("http://app.profitmandi.com/pages/home/dashboard");
|
1317 |
notification.setUrl("http://app.profitmandi.com/pages/home/dashboard");
|
| 1318 |
notification
|
1318 |
notification
|
| 1319 |
.setSql(MessageFormat.format("SELECT distinct d1.user_id from devices d1 left join devices d2 on"
|
1319 |
.setSql(MessageFormat.format("SELECT distinct d1.user_id from devices d1 left join devices d2 on"
|
| 1320 |
+ "(d1.imeinumber = d2.imeinumber and d1.created < d2.created) "
|
1320 |
+ "(d1.imeinumber = d2.imeinumber and d1.created < d2.created) "
|
| 1321 |
+ " where d2.id is null and d1.user_id in ({0})", fofoId));
|
1321 |
+ " where d2.id is null and d1.user_id in ({0})", fofoId));
|
| 1322 |
notification.setExpiresat(LocalDateTime.now().toEpochSecond(ZoneOffset.ofHoursMinutes(5, 30)));
|
1322 |
notification.setExpiresat(LocalDateTime.now().plusDays(1).toEpochSecond(ZoneOffset.UTC) * 1000);
|
| 1323 |
notification.setStatus("active");
|
1323 |
notification.setStatus("active");
|
| 1324 |
notification.setSmsprocessed(0);
|
1324 |
notification.setSmsprocessed(0);
|
| 1325 |
notification.setNotification_processed(0);
|
1325 |
notification.setNotification_processed(0);
|
| 1326 |
notification.setNotification_type("GENERAL_NOTIFICATION");
|
1326 |
notification.setNotification_type("GENERAL_NOTIFICATION");
|
| 1327 |
mongoClient.persistNotificationCmpInfo(notification);
|
1327 |
mongoClient.persistNotificationCmpInfo(notification);
|