| Line 1176... |
Line 1176... |
| 1176 |
} else {
|
1176 |
} else {
|
| 1177 |
notification.setMessage(String.format("Rs.%.0f till %s", sale,
|
1177 |
notification.setMessage(String.format("Rs.%.0f till %s", sale,
|
| 1178 |
now.format(timeFormatter)));
|
1178 |
now.format(timeFormatter)));
|
| 1179 |
}
|
1179 |
}
|
| 1180 |
// notification.setMessage("Your sale is "+salesbyfofoId.get(fofoId));
|
1180 |
// notification.setMessage("Your sale is "+salesbyfofoId.get(fofoId));
|
| 1181 |
notification.setType("Url");
|
1181 |
notification.setType("url");
|
| 1182 |
notification.setUrl("http://app.profitmandi.com/pages/home/notifications");
|
1182 |
notification.setUrl("http://app.profitmandi.com/pages/home/notifications");
|
| 1183 |
LOGGER.info("UserID" + userAccountRepository.selectUserIdByRetailerId(fofoId));
|
1183 |
LOGGER.info("UserID" + userAccountRepository.selectUserIdByRetailerId(fofoId));
|
| 1184 |
notification.setSql("SELECT distinct d1.user_id from devices d1 left join devices d2 on"
|
1184 |
notification.setSql("SELECT distinct d1.user_id from devices d1 left join devices d2 on"
|
| 1185 |
+ "(d1.imeinumber = d2.imeinumber and d1.created < d2.created) "
|
1185 |
+ "(d1.imeinumber = d2.imeinumber and d1.created < d2.created) "
|
| 1186 |
+ " where d2.id is null and d1.user_id = "
|
1186 |
+ " where d2.id is null and d1.user_id = "
|