| Line 2478... |
Line 2478... |
| 2478 |
|
2478 |
|
| 2479 |
List<PartnerProblem> partnerProblems = partnerProblemRepository.selectAll().stream()
|
2479 |
List<PartnerProblem> partnerProblems = partnerProblemRepository.selectAll().stream()
|
| 2480 |
.filter(x -> x.getMtd() + x.getInvestment() + x.getStockInvestment() > 0).collect(Collectors.toList());
|
2480 |
.filter(x -> x.getMtd() + x.getInvestment() + x.getStockInvestment() > 0).collect(Collectors.toList());
|
| 2481 |
|
2481 |
|
| 2482 |
partnerProblems = partnerProblems.stream().sorted((x1, x2) -> {
|
2482 |
partnerProblems = partnerProblems.stream().sorted((x1, x2) -> {
|
| 2483 |
return x1.getMtd() + x1.getInvestment() + x1.getStockInvestment() > x2.getMtd() + x2.getInvestment()
|
2483 |
return x1.getMtd() + x1.getInvestment() + x1.getStockInvestment() < x2.getMtd() + x2.getInvestment()
|
| 2484 |
+ x2.getStockInvestment() ? 1 : -1;
|
2484 |
+ x2.getStockInvestment() ? 1 : -1;
|
| 2485 |
}).collect(Collectors.toList());
|
2485 |
}).collect(Collectors.toList());
|
| 2486 |
Map<Integer, PartnerProblem> partnerProblemMap = partnerProblems.stream()
|
2486 |
Map<Integer, PartnerProblem> partnerProblemMap = partnerProblems.stream()
|
| 2487 |
.collect(Collectors.toMap(x -> x.getFofoId(), x -> x));
|
2487 |
.collect(Collectors.toMap(x -> x.getFofoId(), x -> x));
|
| 2488 |
Map<Integer, CustomRetailer> customRetailers = retailerService.getAllFofoRetailers();
|
2488 |
Map<Integer, CustomRetailer> customRetailers = retailerService.getAllFofoRetailers();
|
| Line 2525... |
Line 2525... |
| 2525 |
+ assignAuthUserMap.get(assignTo.get(value)).getName() + "</td>");
|
2525 |
+ assignAuthUserMap.get(assignTo.get(value)).getName() + "</td>");
|
| 2526 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + pp.getMtd() + "</td>");
|
2526 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + pp.getMtd() + "</td>");
|
| 2527 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + pp.getInvestment() + "</td>");
|
2527 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + pp.getInvestment() + "</td>");
|
| 2528 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + pp.getStockInvestment() + "</td>");
|
2528 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + pp.getStockInvestment() + "</td>");
|
| 2529 |
sb.append("<td style='border:1px solid black;padding: 5px'>"
|
2529 |
sb.append("<td style='border:1px solid black;padding: 5px'>"
|
| 2530 |
+ (authUserMap.get(EscalationType.L1) == null ? "no available"
|
2530 |
+ (authUserMap.get(EscalationType.L1) == null ? "N/A"
|
| 2531 |
: authUserMap.get(EscalationType.L1).getFirstName())
|
2531 |
: authUserMap.get(EscalationType.L1).getFirstName())
|
| 2532 |
+ " ," + (authUserMap.get(EscalationType.L2) == null ? "no available"
|
2532 |
+ " ," + (authUserMap.get(EscalationType.L2) == null ? "N/A"
|
| 2533 |
: authUserMap.get(EscalationType.L2).getFirstName())
|
2533 |
: authUserMap.get(EscalationType.L2).getFirstName())
|
| 2534 |
+ "</td>");
|
2534 |
+ "</td>");
|
| 2535 |
|
2535 |
|
| 2536 |
sb.append("</tr>");
|
2536 |
sb.append("</tr>");
|
| 2537 |
}
|
2537 |
}
|
| Line 2543... |
Line 2543... |
| 2543 |
|
2543 |
|
| 2544 |
Map<Integer, List<Integer>> authUserPartnerMapping = csService.getAuthUserIdPartnerIdMapping();
|
2544 |
Map<Integer, List<Integer>> authUserPartnerMapping = csService.getAuthUserIdPartnerIdMapping();
|
| 2545 |
|
2545 |
|
| 2546 |
for (Entry<Integer, List<Integer>> authUserPartner : authUserPartnerMapping.entrySet()) {
|
2546 |
for (Entry<Integer, List<Integer>> authUserPartner : authUserPartnerMapping.entrySet()) {
|
| 2547 |
AuthUser authUser = authRepository.selectById(authUserPartner.getKey());
|
2547 |
AuthUser authUser = authRepository.selectById(authUserPartner.getKey());
|
| - |
|
2548 |
if (!authUserPartner.getValue().isEmpty()) {
|
| 2548 |
StringBuilder sbbuilder = new StringBuilder();
|
2549 |
StringBuilder sbbuilder = new StringBuilder();
|
| 2549 |
sbbuilder.append("<hml><body>");
|
2550 |
sbbuilder.append("<hml><body>");
|
| 2550 |
sb.append(
|
2551 |
sb.append(
|
| 2551 |
"<p>Number against MTD or Investment are the count of days the MTD is low VS LMTD OR Investment is below 75%.</p><br/><p>These partners needs immediate attention.</p><br/><table style='border:1px solid black';cellspacing=0>");
|
2552 |
"<p>Number against MTD or Investment are the count of days the MTD is low VS LMTD OR Investment is below 75%.</p><br/><p>These partners needs immediate attention.</p><br/><table style='border:1px solid black';cellspacing=0>");
|
| 2552 |
sbbuilder.append("<tbody>\n" + " <tr>"
|
2553 |
sbbuilder.append("<tbody>\n" + " <tr>"
|
| 2553 |
+ " <th style='border:1px solid black;padding: 5px'>Partner Name</th>"
|
2554 |
+ " <th style='border:1px solid black;padding: 5px'>Partner Name</th>"
|
| 2554 |
+ " <th style='border:1px solid black;padding: 5px'>Mtd</th>"
|
2555 |
+ " <th style='border:1px solid black;padding: 5px'>Mtd</th>"
|
| 2555 |
+ " <th style='border:1px solid black;padding: 5px'>Investment</th>"
|
2556 |
+ " <th style='border:1px solid black;padding: 5px'>Investment</th>"
|
| 2556 |
+ " <th style='border:1px solid black;padding: 5px'>Stock</th>"
|
2557 |
+ " <th style='border:1px solid black;padding: 5px'>Stock</th>"
|
| 2557 |
|
2558 |
|
| 2558 |
+ " </tr>");
|
2559 |
+ " </tr>");
|
| 2559 |
|
2560 |
|
| 2560 |
for (Integer partnerId : authUserPartner.getValue()) {
|
2561 |
for (Integer partnerId : authUserPartner.getValue()) {
|
| 2561 |
if (partnerProblemMap.get(partnerId) != null) {
|
2562 |
if (partnerProblemMap.get(partnerId) != null) {
|
| 2562 |
PartnerProblem pp = partnerProblemMap.get(partnerId);
|
2563 |
PartnerProblem pp = partnerProblemMap.get(partnerId);
|
| 2563 |
sbbuilder.append("<tr>");
|
2564 |
sbbuilder.append("<tr>");
|
| 2564 |
sbbuilder.append("<td style='border:1px solid black;padding: 5px'>"
|
2565 |
sbbuilder.append("<td style='border:1px solid black;padding: 5px'>"
|
| 2565 |
+ customRetailers.get(pp.getFofoId()).getBusinessName() + "</td>");
|
2566 |
+ customRetailers.get(pp.getFofoId()).getBusinessName() + "</td>");
|
| 2566 |
sbbuilder.append("<td style='border:1px solid black;padding: 5px'>" + pp.getMtd() + "</td>");
|
2567 |
sbbuilder.append("<td style='border:1px solid black;padding: 5px'>" + pp.getMtd() + "</td>");
|
| - |
|
2568 |
sbbuilder.append(
|
| 2567 |
sbbuilder.append("<td style='border:1px solid black;padding: 5px'>" + pp.getInvestment() + "</td>");
|
2569 |
"<td style='border:1px solid black;padding: 5px'>" + pp.getInvestment() + "</td>");
|
| 2568 |
sbbuilder.append(
|
2570 |
sbbuilder.append(
|
| 2569 |
"<td style='border:1px solid black;padding: 5px'>" + pp.getStockInvestment() + "</td>");
|
2571 |
"<td style='border:1px solid black;padding: 5px'>" + pp.getStockInvestment() + "</td>");
|
| 2570 |
|
2572 |
|
| 2571 |
sbbuilder.append("</tr>");
|
2573 |
sbbuilder.append("</tr>");
|
| 2572 |
}
|
2574 |
}
|
| 2573 |
|
2575 |
|
| 2574 |
}
|
2576 |
}
|
| 2575 |
sbbuilder.append("</tbody></table><br><br>");
|
2577 |
sbbuilder.append("</tbody></table><br><br>");
|
| 2576 |
|
2578 |
|
| 2577 |
this.sendMailOfHtmlFormat(authUser.getEmailId(), sbbuilder.toString(), null, subject);
|
2579 |
this.sendMailOfHtmlFormat("tejbeerkaur27@gmail.com", sbbuilder.toString(), null, subject);
|
| 2578 |
|
2580 |
|
| - |
|
2581 |
}
|
| 2579 |
}
|
2582 |
}
|
| 2580 |
|
2583 |
|
| 2581 |
}
|
2584 |
}
|
| 2582 |
|
2585 |
|
| 2583 |
private void sendMailHtmlFormat(String email[], String body, String cc[], String subject)
|
2586 |
private void sendMailHtmlFormat(String email[], String body, String cc[], String subject)
|