| Line 3960... |
Line 3960... |
| 3960 |
"<th style='border:1px solid black;padding: 5px'>Pending Amount</th>\n" +
|
3960 |
"<th style='border:1px solid black;padding: 5px'>Pending Amount</th>\n" +
|
| 3961 |
"<th style='border:1px solid black;padding: 5px'>RBM L2</th>\n" +
|
3961 |
"<th style='border:1px solid black;padding: 5px'>RBM L2</th>\n" +
|
| 3962 |
"<th style='border:1px solid black;padding: 5px'>RBM L1</th>\n" +
|
3962 |
"<th style='border:1px solid black;padding: 5px'>RBM L1</th>\n" +
|
| 3963 |
"<th style='border:1px solid black;padding: 5px'>Sales L1</th>\n" +
|
3963 |
"<th style='border:1px solid black;padding: 5px'>Sales L1</th>\n" +
|
| 3964 |
"<th style='border:1px solid black;padding: 5px'>Sales L2</th>\n" +
|
3964 |
"<th style='border:1px solid black;padding: 5px'>Sales L2</th>\n" +
|
| - |
|
3965 |
"<th style='border:1px solid black;padding: 5px'>Limit Assign L2</th>\n" +
|
| 3965 |
"</tr>");
|
3966 |
"</tr>");
|
| 3966 |
|
3967 |
|
| 3967 |
for (Loan entry : loans) {
|
3968 |
for (Loan entry : loans) {
|
| 3968 |
|
3969 |
|
| 3969 |
List<LoanStatement> loanStatements = loanStatementRepository.selectByLoanId(entry.getId());
|
3970 |
List<LoanStatement> loanStatements = loanStatementRepository.selectByLoanId(entry.getId());
|
| Line 3972... |
Line 3973... |
| 3972 |
|
3973 |
|
| 3973 |
long noOfdaysBetween = ChronoUnit.DAYS.between(entry.getDueDate().toLocalDate(), LocalDateTime.now());
|
3974 |
long noOfdaysBetween = ChronoUnit.DAYS.between(entry.getDueDate().toLocalDate(), LocalDateTime.now());
|
| 3974 |
|
3975 |
|
| 3975 |
CustomRetailer customRetailer = retailerService.getFofoRetailer(entry.getFofoId());
|
3976 |
CustomRetailer customRetailer = retailerService.getFofoRetailer(entry.getFofoId());
|
| 3976 |
|
3977 |
|
| - |
|
3978 |
SDCreditRequirement sdCreditRequirement = sdCreditRequirementRepository.selectByFofoId(customRetailer.getPartnerId());
|
| - |
|
3979 |
|
| 3977 |
sb.append("<tr>");
|
3980 |
sb.append("<tr>");
|
| 3978 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + customRetailer.getBusinessName() + "(" + customRetailer.getCode() + ")" + "</td>");
|
3981 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + customRetailer.getBusinessName() + "(" + customRetailer.getCode() + ")" + "</td>");
|
| 3979 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + customRetailer.getAddress().getState() + "</td>");
|
3982 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + customRetailer.getAddress().getState() + "</td>");
|
| 3980 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + astMap.get(customRetailer.getAstId()).getArea() + "</td>");
|
3983 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + astMap.get(customRetailer.getAstId()).getArea() + "</td>");
|
| 3981 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + astMap.get(customRetailer.getAstId()).getTerritory() + "</td>");
|
3984 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + astMap.get(customRetailer.getAstId()).getTerritory() + "</td>");
|
| Line 3985... |
Line 3988... |
| 3985 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + new DecimalFormat("#.##").format(Math.abs(amount)) + "</td>");
|
3988 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + new DecimalFormat("#.##").format(Math.abs(amount)) + "</td>");
|
| 3986 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + fofoRbmReportingModelMap.get(entry.getFofoId()).getL1Manager() + "</td>");
|
3989 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + fofoRbmReportingModelMap.get(entry.getFofoId()).getL1Manager() + "</td>");
|
| 3987 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + fofoRbmReportingModelMap.get(entry.getFofoId()).getL2Manager() + "</td>");
|
3990 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + fofoRbmReportingModelMap.get(entry.getFofoId()).getL2Manager() + "</td>");
|
| 3988 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + fofoReportingModelMap.get(entry.getFofoId()).getTerritoryManager() + "</td>");
|
3991 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + fofoReportingModelMap.get(entry.getFofoId()).getTerritoryManager() + "</td>");
|
| 3989 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + fofoReportingModelMap.get(entry.getFofoId()).getRegionalManager() + "</td>");
|
3992 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + fofoReportingModelMap.get(entry.getFofoId()).getRegionalManager() + "</td>");
|
| - |
|
3993 |
sb.append("<td style='border:1px solid black;padding: 5px'>" + sdCreditRequirement.getLimit() + "</td>");
|
| 3990 |
sb.append("</tr>");
|
3994 |
sb.append("</tr>");
|
| 3991 |
}
|
3995 |
}
|
| 3992 |
|
3996 |
|
| 3993 |
sb.append("</tbody></table></body></html>");
|
3997 |
sb.append("</tbody></table></body></html>");
|
| 3994 |
|
3998 |
|