WebSVN – SmartDukaan – Diff – //trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasksTest.java



            int managerL1 = salesManagerL1Map.getOrDefault(fofoId, 0);
            int managerL2 = salesManagerL2Map.getOrDefault(fofoId, 0);
            int managerL3 = salesManagerL3Map.getOrDefault(fofoId, 0);
            int managerL4 = salesManagerL4Map.getOrDefault(fofoId, 0);
            int managerL5 = salesManagerL5Map.getOrDefault(fofoId, 0);
            String salesL3Name = (managerL3 != 0 && authUserMap.get(managerL3) != null)
                    ? authUserMap.get(managerL3).getFullName() : "";
            if (managerL1 != 0 && authUserMap.get(managerL1) != null) {
                managerName = authUserMap.get(managerL1).getFullName();
            } else if (managerL2 != 0 && authUserMap.get(managerL2) != null) {
                managerName = authUserMap.get(managerL2).getFullName();
            } else if (managerL3 != 0 && authUserMap.get(managerL3) != null) {

            biRetailerModel.setCity(customRetailers.get(fofoId).getAddress().getCity());
            biRetailerModel.setStoreName(customRetailers.get(fofoId).getBusinessName());
            biRetailerModel.setStatus(retailerStatus);
            biRetailerModel.setCategory(String.valueOf(partnerTypeThisMonth));
            biRetailerModel.setSalesManager(managerName);
            biRetailerModel.setSalesL3Manager(salesL3Name);
            biRetailerModel.setRbm(rbmName);
            biRetailerModelMap.put(fofoId, biRetailerModel);
 
            Map<YearMonth, PartnerWiseActivatedNotBilledTotal> partnerWiseActivatedNotBilledTotalMap =
                    activatedNotBilledByFofo.getOrDefault(fofoId, new HashMap<>());

        //generate excel and sent to mail
        List<List<String>> headerGroup = new ArrayList<>();
 
        List<String> headers1 = Arrays.asList(
                "","","","",
                "Retailer Detail", "","","", "", "", "", "", "", "", "","","","","",
 
                twoMonthAgoStringValue, "", "", "", "", "", "",
                lastMonthStringValue, "", "", "", "", "", "",
                currentMonthStringValue, "", "", "", "", "", "",
 

 
        );
 
        List<String> headers2 = Arrays.asList(
                "Assessment","Zero billing","Billing needed","Counta",
                "BM","Sales L3 Manager","Partner Id","Link","Wallet Date","Creation Date","Code","Area",  "City", "Store Name", "Status","Category","Sales Manager", "RBM",
                "Secondary Target", "Secondary Achieved", "Returns", "Net Secondary", "Secondary %",
                "Tertiary Sale", "Unbilled",
                "Secondary Target", "Secondary Achieved", "Returns", "Net Secondary", "Secondary %",
                "Tertiary Sale", "Unbilled",
                "Secondary Target", "Secondary Achieved", "Returns", "Net Secondary", "Secondary %",

                    assessmentMap.get(fofoId),
                    zeroBillingMap.get(fofoId),
                    billingNeededMap.get(fofoId),
                    countAMap.get(fofoId),
                    retailer.getBmName(),
                    retailer.getSalesL3Manager(),
                    fofoId ,
                    "https://partners.smartdukaan.com/partnerPerformance?fofoId="+fofoId,
                    walletCreationDate != null ? walletCreationDate.format(formatter) : "-",
                    (user != null && user.getCreateTimestamp() != null) ? user.getCreateTimestamp().format(formatter) : "-",
                    retailer.getCode(),

            String storeGuyEmail = storeGuyEntry.getKey();
            Set<Integer> fofoIds = storeGuyEntry.getValue();
            String[] sendToArray = new String[]{storeGuyEmail};
 
            List<List<?>> filteredRows = rows.stream()
                    .filter(row -> row.size() > 6 && fofoIds.contains((Integer) row.get(6)))
                    .collect(Collectors.toList());
            this.sendMailToUser(headerGroup,filteredRows,sendToArray);
        }
 
        this.sendMailToUser(

        headerStyles.put("City", blueStyle);
        headerStyles.put("Area", blueStyle);
        headerStyles.put("BM", blueStyle);
        headerStyles.put("RBM", blueStyle);
        headerStyles.put("Sales Manager", blueStyle);
        headerStyles.put("Sales L3 Manager", blueStyle);
        headerStyles.put("Status", blueStyle);
        headerStyles.put("Category", blueStyle);
        headerStyles.put("Wallet Date", blueStyle);
        headerStyles.put("Creation Date", blueStyle);
        headerStyles.put("Partner Id", blueStyle);

            Row row = sheet.createRow(rowIndex++);
            for (int i = 0; i < dataRow.size(); i++) {
                Cell cell = row.createCell(i);
                Object value = dataRow.get(i);
 
                if (i == 7 && value != null) { // Assuming column 7 is "Link"
                    Hyperlink hyperlink = creationHelper.createHyperlink(HyperlinkType.URL);
                    hyperlink.setAddress(value.toString());
                    cell.setCellValue("View Link"); // Display text
                    cell.setHyperlink(hyperlink);
                    cell.setCellStyle(hyperlinkStyle);

Subversion Repositories SmartDukaan

(root)//trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasksTest.java – Rev 37233 → 37351

Rev 37233		Rev 37351
Line 962...		Line 962...
962	`int managerL1 = salesManagerL1Map.getOrDefault(fofoId, 0);`	962	`int managerL1 = salesManagerL1Map.getOrDefault(fofoId, 0);`
963	`int managerL2 = salesManagerL2Map.getOrDefault(fofoId, 0);`	963	`int managerL2 = salesManagerL2Map.getOrDefault(fofoId, 0);`
964	`int managerL3 = salesManagerL3Map.getOrDefault(fofoId, 0);`	964	`int managerL3 = salesManagerL3Map.getOrDefault(fofoId, 0);`
965	`int managerL4 = salesManagerL4Map.getOrDefault(fofoId, 0);`	965	`int managerL4 = salesManagerL4Map.getOrDefault(fofoId, 0);`
966	`int managerL5 = salesManagerL5Map.getOrDefault(fofoId, 0);`	966	`int managerL5 = salesManagerL5Map.getOrDefault(fofoId, 0);`
-		967	`String salesL3Name = (managerL3 != 0 && authUserMap.get(managerL3) != null)`
-		968	`? authUserMap.get(managerL3).getFullName() : "";`
967	`if (managerL1 != 0 && authUserMap.get(managerL1) != null) {`	969	`if (managerL1 != 0 && authUserMap.get(managerL1) != null) {`
968	`managerName = authUserMap.get(managerL1).getFullName();`	970	`managerName = authUserMap.get(managerL1).getFullName();`
969	`} else if (managerL2 != 0 && authUserMap.get(managerL2) != null) {`	971	`} else if (managerL2 != 0 && authUserMap.get(managerL2) != null) {`
970	`managerName = authUserMap.get(managerL2).getFullName();`	972	`managerName = authUserMap.get(managerL2).getFullName();`
971	`} else if (managerL3 != 0 && authUserMap.get(managerL3) != null) {`	973	`} else if (managerL3 != 0 && authUserMap.get(managerL3) != null) {`
Line 996...		Line 998...
996	`biRetailerModel.setCity(customRetailers.get(fofoId).getAddress().getCity());`	998	`biRetailerModel.setCity(customRetailers.get(fofoId).getAddress().getCity());`
997	`biRetailerModel.setStoreName(customRetailers.get(fofoId).getBusinessName());`	999	`biRetailerModel.setStoreName(customRetailers.get(fofoId).getBusinessName());`
998	`biRetailerModel.setStatus(retailerStatus);`	1000	`biRetailerModel.setStatus(retailerStatus);`
999	`biRetailerModel.setCategory(String.valueOf(partnerTypeThisMonth));`	1001	`biRetailerModel.setCategory(String.valueOf(partnerTypeThisMonth));`
1000	`biRetailerModel.setSalesManager(managerName);`	1002	`biRetailerModel.setSalesManager(managerName);`
-		1003	`biRetailerModel.setSalesL3Manager(salesL3Name);`
1001	`biRetailerModel.setRbm(rbmName);`	1004	`biRetailerModel.setRbm(rbmName);`
1002	`biRetailerModelMap.put(fofoId, biRetailerModel);`	1005	`biRetailerModelMap.put(fofoId, biRetailerModel);`
1003		1006
1004	`Map<YearMonth, PartnerWiseActivatedNotBilledTotal> partnerWiseActivatedNotBilledTotalMap =`	1007	`Map<YearMonth, PartnerWiseActivatedNotBilledTotal> partnerWiseActivatedNotBilledTotalMap =`
1005	`activatedNotBilledByFofo.getOrDefault(fofoId, new HashMap<>());`	1008	`activatedNotBilledByFofo.getOrDefault(fofoId, new HashMap<>());`
Line 1176...		Line 1179...
1176	`//generate excel and sent to mail`	1179	`//generate excel and sent to mail`
1177	`List<List<String>> headerGroup = new ArrayList<>();`	1180	`List<List<String>> headerGroup = new ArrayList<>();`
1178		1181
1179	`List<String> headers1 = Arrays.asList(`	1182	`List<String> headers1 = Arrays.asList(`
1180	`"","","","",`	1183	`"","","","",`
1181	`"Retailer Detail", "","", "", "", "", "", "", "", "","","","","",`	1184	`"Retailer Detail", "","","", "", "", "", "", "", "", "","","","","",`
1182		1185
1183	`twoMonthAgoStringValue, "", "", "", "", "", "",`	1186	`twoMonthAgoStringValue, "", "", "", "", "", "",`
1184	`lastMonthStringValue, "", "", "", "", "", "",`	1187	`lastMonthStringValue, "", "", "", "", "", "",`
1185	`currentMonthStringValue, "", "", "", "", "", "",`	1188	`currentMonthStringValue, "", "", "", "", "", "",`
1186		1189
Line 1191...		Line 1194...
1191		1194
1192	`);`	1195	`);`
1193		1196
1194	`List<String> headers2 = Arrays.asList(`	1197	`List<String> headers2 = Arrays.asList(`
1195	`"Assessment","Zero billing","Billing needed","Counta",`	1198	`"Assessment","Zero billing","Billing needed","Counta",`
1196	`"BM","Partner Id","Link","Wallet Date","Creation Date","Code","Area", "City", "Store Name", "Status","Category","Sales Manager", "RBM",`	1199	`"BM","Sales L3 Manager","Partner Id","Link","Wallet Date","Creation Date","Code","Area", "City", "Store Name", "Status","Category","Sales Manager", "RBM",`
1197	`"Secondary Target", "Secondary Achieved", "Returns", "Net Secondary", "Secondary %",`	1200	`"Secondary Target", "Secondary Achieved", "Returns", "Net Secondary", "Secondary %",`
1198	`"Tertiary Sale", "Unbilled",`	1201	`"Tertiary Sale", "Unbilled",`
1199	`"Secondary Target", "Secondary Achieved", "Returns", "Net Secondary", "Secondary %",`	1202	`"Secondary Target", "Secondary Achieved", "Returns", "Net Secondary", "Secondary %",`
1200	`"Tertiary Sale", "Unbilled",`	1203	`"Tertiary Sale", "Unbilled",`
1201	`"Secondary Target", "Secondary Achieved", "Returns", "Net Secondary", "Secondary %",`	1204	`"Secondary Target", "Secondary Achieved", "Returns", "Net Secondary", "Secondary %",`
Line 1237...		Line 1240...
1237	`assessmentMap.get(fofoId),`	1240	`assessmentMap.get(fofoId),`
1238	`zeroBillingMap.get(fofoId),`	1241	`zeroBillingMap.get(fofoId),`
1239	`billingNeededMap.get(fofoId),`	1242	`billingNeededMap.get(fofoId),`
1240	`countAMap.get(fofoId),`	1243	`countAMap.get(fofoId),`
1241	`retailer.getBmName(),`	1244	`retailer.getBmName(),`
-		1245	`retailer.getSalesL3Manager(),`
1242	`fofoId ,`	1246	`fofoId ,`
1243	`"https://partners.smartdukaan.com/partnerPerformance?fofoId="+fofoId,`	1247	`"https://partners.smartdukaan.com/partnerPerformance?fofoId="+fofoId,`
1244	`walletCreationDate != null ? walletCreationDate.format(formatter) : "-",`	1248	`walletCreationDate != null ? walletCreationDate.format(formatter) : "-",`
1245	`(user != null && user.getCreateTimestamp() != null) ? user.getCreateTimestamp().format(formatter) : "-",`	1249	`(user != null && user.getCreateTimestamp() != null) ? user.getCreateTimestamp().format(formatter) : "-",`
1246	`retailer.getCode(),`	1250	`retailer.getCode(),`
Line 1381...		Line 1385...
1381	`String storeGuyEmail = storeGuyEntry.getKey();`	1385	`String storeGuyEmail = storeGuyEntry.getKey();`
1382	`Set<Integer> fofoIds = storeGuyEntry.getValue();`	1386	`Set<Integer> fofoIds = storeGuyEntry.getValue();`
1383	`String[] sendToArray = new String[]{storeGuyEmail};`	1387	`String[] sendToArray = new String[]{storeGuyEmail};`
1384		1388
1385	`List<List<?>> filteredRows = rows.stream()`	1389	`List<List<?>> filteredRows = rows.stream()`
1386	`.filter(row -> row.size() > 5 && fofoIds.contains((Integer) row.get(5)))`	1390	`.filter(row -> row.size() > 6 && fofoIds.contains((Integer) row.get(6)))`
1387	`.collect(Collectors.toList());`	1391	`.collect(Collectors.toList());`
1388	`this.sendMailToUser(headerGroup,filteredRows,sendToArray);`	1392	`this.sendMailToUser(headerGroup,filteredRows,sendToArray);`
1389	`}`	1393	`}`
1390		1394
1391	`this.sendMailToUser(`	1395	`this.sendMailToUser(`
Line 1458...		Line 1462...
1458	`headerStyles.put("City", blueStyle);`	1462	`headerStyles.put("City", blueStyle);`
1459	`headerStyles.put("Area", blueStyle);`	1463	`headerStyles.put("Area", blueStyle);`
1460	`headerStyles.put("BM", blueStyle);`	1464	`headerStyles.put("BM", blueStyle);`
1461	`headerStyles.put("RBM", blueStyle);`	1465	`headerStyles.put("RBM", blueStyle);`
1462	`headerStyles.put("Sales Manager", blueStyle);`	1466	`headerStyles.put("Sales Manager", blueStyle);`
-		1467	`headerStyles.put("Sales L3 Manager", blueStyle);`
1463	`headerStyles.put("Status", blueStyle);`	1468	`headerStyles.put("Status", blueStyle);`
1464	`headerStyles.put("Category", blueStyle);`	1469	`headerStyles.put("Category", blueStyle);`
1465	`headerStyles.put("Wallet Date", blueStyle);`	1470	`headerStyles.put("Wallet Date", blueStyle);`
1466	`headerStyles.put("Creation Date", blueStyle);`	1471	`headerStyles.put("Creation Date", blueStyle);`
1467	`headerStyles.put("Partner Id", blueStyle);`	1472	`headerStyles.put("Partner Id", blueStyle);`
Line 1580...		Line 1585...
1580	`Row row = sheet.createRow(rowIndex++);`	1585	`Row row = sheet.createRow(rowIndex++);`
1581	`for (int i = 0; i < dataRow.size(); i++) {`	1586	`for (int i = 0; i < dataRow.size(); i++) {`
1582	`Cell cell = row.createCell(i);`	1587	`Cell cell = row.createCell(i);`
1583	`Object value = dataRow.get(i);`	1588	`Object value = dataRow.get(i);`
1584		1589
1585	`if (i == 6 && value != null) { // Assuming column 6 is "Link"`	1590	`if (i == 7 && value != null) { // Assuming column 7 is "Link"`
1586	`Hyperlink hyperlink = creationHelper.createHyperlink(HyperlinkType.URL);`	1591	`Hyperlink hyperlink = creationHelper.createHyperlink(HyperlinkType.URL);`
1587	`hyperlink.setAddress(value.toString());`	1592	`hyperlink.setAddress(value.toString());`
1588	`cell.setCellValue("View Link"); // Display text`	1593	`cell.setCellValue("View Link"); // Display text`
1589	`cell.setHyperlink(hyperlink);`	1594	`cell.setHyperlink(hyperlink);`
1590	`cell.setCellStyle(hyperlinkStyle);`	1595	`cell.setCellStyle(hyperlinkStyle);`