| Line 1262... |
Line 1262... |
| 1262 |
"Secondary Target", "Secondary Achieved", "Returns", "Net Secondary", "Secondary %",
|
1262 |
"Secondary Target", "Secondary Achieved", "Returns", "Net Secondary", "Secondary %",
|
| 1263 |
"Tertiary Sale", "Unbilled",
|
1263 |
"Tertiary Sale", "Unbilled",
|
| 1264 |
"Counter Potential", "Short investment", "Default", "INVESTMENT LEVEL", "Loan", "PO value", "Agreed investment",
|
1264 |
"Counter Potential", "Short investment", "Default", "INVESTMENT LEVEL", "Loan", "PO value", "Agreed investment",
|
| 1265 |
"Wallet", "po+bill", "MONTH BEGINNING DRR", "REQ DRR", "Drr %", "Last billing Done", "Slab",
|
1265 |
"Wallet", "po+bill", "MONTH BEGINNING DRR", "REQ DRR", "Drr %", "Last billing Done", "Slab",
|
| 1266 |
|
1266 |
|
| 1267 |
"Total Stock", "Apple","Xiaomi", "Vivo", "Tecno", "Samsung", "Realme", "Oppo", "OnePlus", "POCO", "Lava", "Itel", "Almost New",
|
1267 |
"Total Stock", "Apple","Xiaomi", "Vivo", "Tecno","Motorola", "Samsung", "Realme", "Oppo", "OnePlus", "POCO", "Lava", "Itel", "Almost New",
|
| 1268 |
"Total Secondary", "Apple", "Xiaomi", "Vivo", "Tecno", "Samsung", "Realme", "Oppo", "OnePlus", "POCO", "Lava", "Itel", "Almost New",
|
1268 |
"Total Secondary", "Apple", "Xiaomi", "Vivo", "Tecno","Motorola", "Samsung", "Realme", "Oppo", "OnePlus", "POCO", "Lava", "Itel", "Almost New",
|
| 1269 |
"Total Tertiary", "Apple", "Xiaomi", "Vivo", "Tecno", "Samsung", "Realme", "Oppo", "OnePlus", "POCO", "Lava", "Itel", "Almost New",
|
1269 |
"Total Tertiary", "Apple", "Xiaomi", "Vivo", "Tecno","Motorola", "Samsung", "Realme", "Oppo", "OnePlus", "POCO", "Lava", "Itel", "Almost New",
|
| 1270 |
"YesterDay Seconday","Day Before Yesterday Secondary"
|
1270 |
"YesterDay Seconday","Day Before Yesterday Secondary"
|
| 1271 |
);
|
1271 |
);
|
| 1272 |
|
1272 |
|
| 1273 |
headerGroup.add(headers1);
|
1273 |
headerGroup.add(headers1);
|
| 1274 |
headerGroup.add(headers2);
|
1274 |
headerGroup.add(headers2);
|
| Line 1381... |
Line 1381... |
| 1381 |
fofoTotalStockPriceMap.getOrDefault(fofoId, 0.0),
|
1381 |
fofoTotalStockPriceMap.getOrDefault(fofoId, 0.0),
|
| 1382 |
brandStockMap.get("Apple") != null ? brandStockMap.get("Apple").getTotalValue() : 0.0,
|
1382 |
brandStockMap.get("Apple") != null ? brandStockMap.get("Apple").getTotalValue() : 0.0,
|
| 1383 |
brandStockMap.get("Xiaomi") != null ? brandStockMap.get("Xiaomi").getTotalValue() : 0.0,
|
1383 |
brandStockMap.get("Xiaomi") != null ? brandStockMap.get("Xiaomi").getTotalValue() : 0.0,
|
| 1384 |
brandStockMap.get("Vivo") != null ? brandStockMap.get("Vivo").getTotalValue() : 0.0,
|
1384 |
brandStockMap.get("Vivo") != null ? brandStockMap.get("Vivo").getTotalValue() : 0.0,
|
| 1385 |
brandStockMap.get("Tecno") != null ? brandStockMap.get("Tecno").getTotalValue() : 0.0,
|
1385 |
brandStockMap.get("Tecno") != null ? brandStockMap.get("Tecno").getTotalValue() : 0.0,
|
| - |
|
1386 |
brandStockMap.get("Motorola") != null ? brandStockMap.get("Motorola").getTotalValue() : 0.0,
|
| 1386 |
brandStockMap.get("Samsung") != null ? brandStockMap.get("Samsung").getTotalValue() : 0.0,
|
1387 |
brandStockMap.get("Samsung") != null ? brandStockMap.get("Samsung").getTotalValue() : 0.0,
|
| 1387 |
brandStockMap.get("Realme") != null ? brandStockMap.get("Realme").getTotalValue() : 0.0,
|
1388 |
brandStockMap.get("Realme") != null ? brandStockMap.get("Realme").getTotalValue() : 0.0,
|
| 1388 |
brandStockMap.get("Oppo") != null ? brandStockMap.get("Oppo").getTotalValue() : 0.0,
|
1389 |
brandStockMap.get("Oppo") != null ? brandStockMap.get("Oppo").getTotalValue() : 0.0,
|
| 1389 |
brandStockMap.get("OnePlus") != null ? brandStockMap.get("OnePlus").getTotalValue() : 0.0,
|
1390 |
brandStockMap.get("OnePlus") != null ? brandStockMap.get("OnePlus").getTotalValue() : 0.0,
|
| 1390 |
brandStockMap.get("POCO") != null ? brandStockMap.get("POCO").getTotalValue() : 0.0,
|
1391 |
brandStockMap.get("POCO") != null ? brandStockMap.get("POCO").getTotalValue() : 0.0,
|
| Line 1398... |
Line 1399... |
| 1398 |
fofoTotalMtdSecondaryMap.get(fofoId),
|
1399 |
fofoTotalMtdSecondaryMap.get(fofoId),
|
| 1399 |
brandSecondaryMap.getOrDefault("Apple", 0L),
|
1400 |
brandSecondaryMap.getOrDefault("Apple", 0L),
|
| 1400 |
brandSecondaryMap.getOrDefault("Xiaomi", 0L),
|
1401 |
brandSecondaryMap.getOrDefault("Xiaomi", 0L),
|
| 1401 |
brandSecondaryMap.getOrDefault("Vivo", 0L),
|
1402 |
brandSecondaryMap.getOrDefault("Vivo", 0L),
|
| 1402 |
brandSecondaryMap.getOrDefault("Tecno", 0L),
|
1403 |
brandSecondaryMap.getOrDefault("Tecno", 0L),
|
| - |
|
1404 |
brandSecondaryMap.getOrDefault("Motorola", 0L),
|
| 1403 |
brandSecondaryMap.getOrDefault("Samsung", 0L),
|
1405 |
brandSecondaryMap.getOrDefault("Samsung", 0L),
|
| 1404 |
brandSecondaryMap.getOrDefault("Realme", 0L),
|
1406 |
brandSecondaryMap.getOrDefault("Realme", 0L),
|
| 1405 |
brandSecondaryMap.getOrDefault("Oppo", 0L),
|
1407 |
brandSecondaryMap.getOrDefault("Oppo", 0L),
|
| 1406 |
brandSecondaryMap.getOrDefault("OnePlus", 0L),
|
1408 |
brandSecondaryMap.getOrDefault("OnePlus", 0L),
|
| 1407 |
brandSecondaryMap.getOrDefault("POCO", 0L),
|
1409 |
brandSecondaryMap.getOrDefault("POCO", 0L),
|
| Line 1415... |
Line 1417... |
| 1415 |
fofoTotalMtdTertiaryMap.get(fofoId),
|
1417 |
fofoTotalMtdTertiaryMap.get(fofoId),
|
| 1416 |
brandTertiaryMap.getOrDefault("Apple", 0d),
|
1418 |
brandTertiaryMap.getOrDefault("Apple", 0d),
|
| 1417 |
brandTertiaryMap.getOrDefault("Xiaomi", 0d),
|
1419 |
brandTertiaryMap.getOrDefault("Xiaomi", 0d),
|
| 1418 |
brandTertiaryMap.getOrDefault("Vivo", 0d),
|
1420 |
brandTertiaryMap.getOrDefault("Vivo", 0d),
|
| 1419 |
brandTertiaryMap.getOrDefault("Tecno", 0d),
|
1421 |
brandTertiaryMap.getOrDefault("Tecno", 0d),
|
| - |
|
1422 |
brandTertiaryMap.getOrDefault("Motorola", 0d),
|
| 1420 |
brandTertiaryMap.getOrDefault("Samsung", 0d),
|
1423 |
brandTertiaryMap.getOrDefault("Samsung", 0d),
|
| 1421 |
brandTertiaryMap.getOrDefault("Realme", 0d),
|
1424 |
brandTertiaryMap.getOrDefault("Realme", 0d),
|
| 1422 |
brandTertiaryMap.getOrDefault("Oppo", 0d),
|
1425 |
brandTertiaryMap.getOrDefault("Oppo", 0d),
|
| 1423 |
brandTertiaryMap.getOrDefault("OnePlus", 0d),
|
1426 |
brandTertiaryMap.getOrDefault("OnePlus", 0d),
|
| 1424 |
brandTertiaryMap.getOrDefault("POCO", 0d),
|
1427 |
brandTertiaryMap.getOrDefault("POCO", 0d),
|
| Line 1445... |
Line 1448... |
| 1445 |
.filter(row -> row.size() > 5 && fofoIds.contains((Integer) row.get(5)))
|
1448 |
.filter(row -> row.size() > 5 && fofoIds.contains((Integer) row.get(5)))
|
| 1446 |
.collect(Collectors.toList());
|
1449 |
.collect(Collectors.toList());
|
| 1447 |
this.sendMailToUser(headerGroup,filteredRows,sendToArray);
|
1450 |
this.sendMailToUser(headerGroup,filteredRows,sendToArray);
|
| 1448 |
}
|
1451 |
}
|
| 1449 |
|
1452 |
|
| - |
|
1453 |
this.sendMailToUser(
|
| - |
|
1454 |
headerGroup,
|
| - |
|
1455 |
rows,
|
| - |
|
1456 |
new String[]{
|
| 1450 |
this.sendMailToUser(headerGroup,rows,new String[]{"ranu.rajput@smartdukaan.com"});
|
1457 |
"ranu.rajput@smartdukaan.com",
|
| - |
|
1458 |
"niranjan.kala@smartdukaan.com",
|
| - |
|
1459 |
"deena.nath@smartdukaan.com",
|
| - |
|
1460 |
"santosh.giri@smartdukaan.com"
|
| - |
|
1461 |
}
|
| - |
|
1462 |
);
|
| 1451 |
|
1463 |
|
| 1452 |
|
1464 |
|
| 1453 |
}
|
1465 |
}
|
| 1454 |
|
1466 |
|
| 1455 |
private void sendMailToUser(List<List<String>> headerGroup,List<List<?>> rows, String[] sendToArray ) throws Exception {
|
1467 |
private void sendMailToUser(List<List<String>> headerGroup,List<List<?>> rows, String[] sendToArray ) throws Exception {
|
| Line 1560... |
Line 1572... |
| 1560 |
Map<String, CellStyle> brandStyles = new HashMap<>();
|
1572 |
Map<String, CellStyle> brandStyles = new HashMap<>();
|
| 1561 |
brandStyles.put("Apple", createStyle(workbook, IndexedColors.GREY_25_PERCENT));
|
1573 |
brandStyles.put("Apple", createStyle(workbook, IndexedColors.GREY_25_PERCENT));
|
| 1562 |
brandStyles.put("Xiaomi", createStyle(workbook, IndexedColors.ORANGE));
|
1574 |
brandStyles.put("Xiaomi", createStyle(workbook, IndexedColors.ORANGE));
|
| 1563 |
brandStyles.put("Vivo", createStyle(workbook, IndexedColors.SKY_BLUE));
|
1575 |
brandStyles.put("Vivo", createStyle(workbook, IndexedColors.SKY_BLUE));
|
| 1564 |
brandStyles.put("Tecno", createStyle(workbook, IndexedColors.LIGHT_BLUE));
|
1576 |
brandStyles.put("Tecno", createStyle(workbook, IndexedColors.LIGHT_BLUE));
|
| - |
|
1577 |
brandStyles.put("Motorola", createStyle(workbook, IndexedColors.LIGHT_GREEN));
|
| 1565 |
brandStyles.put("Samsung", createStyle(workbook, IndexedColors.ROYAL_BLUE));
|
1578 |
brandStyles.put("Samsung", createStyle(workbook, IndexedColors.ROYAL_BLUE));
|
| 1566 |
brandStyles.put("Realme", createStyle(workbook, IndexedColors.YELLOW));
|
1579 |
brandStyles.put("Realme", createStyle(workbook, IndexedColors.YELLOW));
|
| 1567 |
brandStyles.put("Oppo", createStyle(workbook, IndexedColors.LIGHT_GREEN));
|
1580 |
brandStyles.put("Oppo", createStyle(workbook, IndexedColors.LIGHT_GREEN));
|
| 1568 |
brandStyles.put("OnePlus", createStyle(workbook, IndexedColors.RED));
|
1581 |
brandStyles.put("OnePlus", createStyle(workbook, IndexedColors.RED));
|
| 1569 |
brandStyles.put("POCO", createStyle(workbook, IndexedColors.ORANGE));
|
1582 |
brandStyles.put("POCO", createStyle(workbook, IndexedColors.ORANGE));
|