Subversion Repositories SmartDukaan

Rev

Rev 34297 | Rev 34979 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 34297 Rev 34299
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());