| Line 42... |
Line 42... |
| 42 |
|
42 |
|
| 43 |
@Override
|
43 |
@Override
|
| 44 |
public void moreThen10DaysEgedStockReport() throws MessagingException, UnsupportedEncodingException, ProfitMandiBusinessException {
|
44 |
public void moreThen10DaysEgedStockReport() throws MessagingException, UnsupportedEncodingException, ProfitMandiBusinessException {
|
| 45 |
LocalDateTime startDate = LocalDateTime.now().minusMonths(3);
|
45 |
LocalDateTime startDate = LocalDateTime.now().minusMonths(3);
|
| 46 |
LocalDateTime endDate = LocalDateTime.now();
|
46 |
LocalDateTime endDate = LocalDateTime.now();
|
| 47 |
List<CatalogAgedModel> moreThen10DaysAgedCatalogModels = getCatalogModelsOlderThan10Days(startDate,endDate);
|
47 |
List<CatalogAgedModel> moreThen10DaysAgedCatalogModels = getCatalogModelsOlderThan10Days(startDate, endDate);
|
| 48 |
StringBuilder sb = new StringBuilder();
|
48 |
StringBuilder sb = new StringBuilder();
|
| 49 |
sb.append("<html><body><b>Aging Stock List: Items that are 10 days old or older (Date Range - "+startDate.toLocalDate()+" To "+endDate.toLocalDate()+" )</b>" + "<br/><table style='border:1px solid black ;padding: 5px ;bgColor=green'>");
|
49 |
sb.append("<html><body><b>Aging Stock List: Items that are 10 days old or older (Date Range - " + startDate.toLocalDate() + " To " + endDate.toLocalDate() + " )</b>" + "<br/><table style='border:1px solid black ;padding: 5px ;bgColor=green'>");
|
| 50 |
sb.append("<tbody>" +
|
50 |
sb.append("<tbody>" +
|
| 51 |
"<tr>" +
|
51 |
"<tr>" +
|
| 52 |
"<th style='border:1px solid black;padding: 5px'>No.</th>" +
|
52 |
"<th style='border:1px solid black;padding: 5px'>No.</th>" +
|
| 53 |
"<th style='border:1px solid black;padding: 5px'>Brand</th>" +
|
53 |
"<th style='border:1px solid black;padding: 5px'>Brand</th>" +
|
| 54 |
"<th style='border:1px solid black;padding: 5px'>Vendor</th>" +
|
54 |
"<th style='border:1px solid black;padding: 5px'>Vendor</th>" +
|
| Line 60... |
Line 60... |
| 60 |
"<th style='border:1px solid black;padding: 5px'>Unsold</th>" +
|
60 |
"<th style='border:1px solid black;padding: 5px'>Unsold</th>" +
|
| 61 |
"<th style='border:1px solid black;padding: 5px'>Age</th>" +
|
61 |
"<th style='border:1px solid black;padding: 5px'>Age</th>" +
|
| 62 |
|
62 |
|
| 63 |
"</tr>");
|
63 |
"</tr>");
|
| 64 |
|
64 |
|
| - |
|
65 |
|
| - |
|
66 |
moreThen10DaysAgedCatalogModels.sort(Comparator.comparingInt(CatalogAgedModel::getAge).reversed());
|
| 65 |
int i = 1;
|
67 |
int i = 1;
|
| 66 |
for (CatalogAgedModel catalogAgedModel : moreThen10DaysAgedCatalogModels) {
|
68 |
for (CatalogAgedModel catalogAgedModel : moreThen10DaysAgedCatalogModels) {
|
| 67 |
sb.append("<tr>");
|
69 |
sb.append("<tr>");
|
| 68 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + (i++) + "</td>");
|
70 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + (i++) + "</td>");
|
| 69 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + catalogAgedModel.getBrand() + "</td>");
|
71 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + catalogAgedModel.getBrand() + "</td>");
|
| Line 93... |
Line 95... |
| 93 |
"tarun.verma@smartdukaan.com",
|
95 |
"tarun.verma@smartdukaan.com",
|
| 94 |
"chiranjib.sarkar@smartdukaan.com",
|
96 |
"chiranjib.sarkar@smartdukaan.com",
|
| 95 |
"niranjan.kala@smartdukaan.com",
|
97 |
"niranjan.kala@smartdukaan.com",
|
| 96 |
"mohit.gulati@smartdukaan.com"
|
98 |
"mohit.gulati@smartdukaan.com"
|
| 97 |
// "tejus.lohani@smartdukaan.com"
|
99 |
// "tejus.lohani@smartdukaan.com"
|
| 98 |
));
|
100 |
));
|
| 99 |
|
101 |
|
| 100 |
// niranjan kala(authId -54) Team Emails,
|
102 |
// niranjan kala(authId -54) Team Emails,
|
| 101 |
List<Integer> allReportees = authService.getAllReportees(54);
|
103 |
List<Integer> allReportees = authService.getAllReportees(54);
|
| 102 |
List<AuthUser> authUsers = authRepository.selectAllAuthUserByIds(allReportees);
|
104 |
List<AuthUser> authUsers = authRepository.selectAllAuthUserByIds(allReportees);
|
| 103 |
List<String> categotyTeamEmails = authUsers.stream().map(x -> x.getEmailId()).collect(Collectors.toList());
|
105 |
List<String> categotyTeamEmails = authUsers.stream().map(x -> x.getEmailId()).collect(Collectors.toList());
|