| Line 724... |
Line 724... |
| 724 |
|
724 |
|
| 725 |
notification.setTitle("Notify Partner");
|
725 |
notification.setTitle("Notify Partner");
|
| 726 |
|
726 |
|
| 727 |
notification.setMessage(item.getItemDescriptionNoColor() + "/" + item.getColor()
|
727 |
notification.setMessage(item.getItemDescriptionNoColor() + "/" + item.getColor()
|
| 728 |
+ "is currently not in stock with Brand/ND. The current availability is in" + color);
|
728 |
+ "is currently not in stock with Brand/ND. The current availability is in" + color);
|
| 729 |
notification.setType("Url");
|
729 |
notification.setType("url");
|
| 730 |
notification.setUrl("http://app.profitmandi.com/pages/home/notifyOrder");
|
730 |
notification.setUrl("http://app.profitmandi.com/pages/home/notifyOrder");
|
| 731 |
|
731 |
|
| 732 |
notification.setSql("SELECT distinct d1.user_id from devices d1 left join devices d2 on"
|
732 |
notification.setSql("SELECT distinct d1.user_id from devices d1 left join devices d2 on"
|
| 733 |
+ "(d1.imeinumber = d2.imeinumber and d1.created < d2.created) "
|
733 |
+ "(d1.imeinumber = d2.imeinumber and d1.created < d2.created) "
|
| 734 |
+ " where d2.id is null and d1.user_id = "
|
734 |
+ " where d2.id is null and d1.user_id = "
|