| Line 580... |
Line 580... |
| 580 |
LocalDate yesterDay = LocalDate.now().minusDays(1);
|
580 |
LocalDate yesterDay = LocalDate.now().minusDays(1);
|
| 581 |
List<FofoStore> fofoStores = fofoStoreRepository.selectActiveStores();
|
581 |
List<FofoStore> fofoStores = fofoStoreRepository.selectActiveStores();
|
| 582 |
Map<Integer, CustomRetailer> customRetailerMap = retailerService
|
582 |
Map<Integer, CustomRetailer> customRetailerMap = retailerService
|
| 583 |
.getFofoRetailers(fofoStores.stream().map(x -> x.getId()).collect(Collectors.toList()));
|
583 |
.getFofoRetailers(fofoStores.stream().map(x -> x.getId()).collect(Collectors.toList()));
|
| 584 |
|
584 |
|
| 585 |
List<String> headers = Arrays.asList("Code", "Store Name", "Firm Name", "State Manager", "Teritory Manager",
|
585 |
List<String> headers = Arrays.asList("Code", "Firm Name", "Store Name", "State Manager", "Teritory Manager",
|
| 586 |
"Team Leader", "Wallet Amount", "In Stock Amount", "Return In Transit Stock", "Unbilled Amount",
|
586 |
"Team Leader", "Wallet Amount", "In Stock Amount", "Return In Transit Stock", "Unbilled Amount",
|
| 587 |
"Grn Pending Amount", "Min Investment", "Investment Amount", "Investment Short", "Unbilled Qty");
|
587 |
"Grn Pending Amount", "Min Investment", "Investment Amount", "Investment Short", "Unbilled Qty");
|
| 588 |
List<List<? extends Serializable>> rows = new ArrayList<>();
|
588 |
List<List<? extends Serializable>> rows = new ArrayList<>();
|
| 589 |
Map<String, List<? extends Serializable>> partnerRow = new HashMap<>();
|
589 |
Map<String, List<? extends Serializable>> partnerRow = new HashMap<>();
|
| 590 |
for (FofoStore fofoStore : fofoStores) {
|
590 |
for (FofoStore fofoStore : fofoStores) {
|
| Line 599... |
Line 599... |
| 599 |
1);
|
599 |
1);
|
| 600 |
partnerDailyInvestment.setDate(yesterDay);
|
600 |
partnerDailyInvestment.setDate(yesterDay);
|
| 601 |
partnerDailyInvestmentRepository.persist(partnerDailyInvestment);
|
601 |
partnerDailyInvestmentRepository.persist(partnerDailyInvestment);
|
| 602 |
|
602 |
|
| 603 |
List<? extends Serializable> row = Arrays.asList(fofoStore.getCode(),
|
603 |
List<? extends Serializable> row = Arrays.asList(fofoStore.getCode(),
|
| 604 |
"SmartDukaan-" + fofoStore.getCode().replace("\\[a-zA-Z]+", ""), retailer.getBusinessName(),
|
604 |
retailer.getBusinessName(), "SmartDukaan-" + fofoStore.getCode().replaceAll("[a-zA-Z]+", ""),
|
| 605 |
storeManagerMap.get(retailer.getEmail()).get(2), storeManagerMap.get(retailer.getEmail()).get(1),
|
605 |
storeManagerMap.get(retailer.getEmail()).get(2), storeManagerMap.get(retailer.getEmail()).get(1),
|
| 606 |
storeManagerMap.get(retailer.getEmail()).get(0), partnerDailyInvestment.getWalletAmount(),
|
606 |
storeManagerMap.get(retailer.getEmail()).get(0), partnerDailyInvestment.getWalletAmount(),
|
| 607 |
partnerDailyInvestment.getInStockAmount(), 0,
|
607 |
partnerDailyInvestment.getInStockAmount(), 0,
|
| 608 |
partnerDailyInvestment.getUnbilledAmount(), partnerDailyInvestment.getGrnPendingAmount(),
|
608 |
partnerDailyInvestment.getUnbilledAmount(), partnerDailyInvestment.getGrnPendingAmount(),
|
| 609 |
partnerDailyInvestment.getMinInvestment(), partnerDailyInvestment.getTotalInvestment(),
|
609 |
partnerDailyInvestment.getMinInvestment(), partnerDailyInvestment.getTotalInvestment(),
|
| Line 667... |
Line 667... |
| 667 |
.getFofoRetailers(new ArrayList<>(fofoStoresMap.keySet()));
|
667 |
.getFofoRetailers(new ArrayList<>(fofoStoresMap.keySet()));
|
| 668 |
|
668 |
|
| 669 |
Map<String, CustomRetailer> customRetailerEmailMap = customRetailerMap.values().stream()
|
669 |
Map<String, CustomRetailer> customRetailerEmailMap = customRetailerMap.values().stream()
|
| 670 |
.collect(Collectors.toMap(x -> x.getEmail(), x -> x));
|
670 |
.collect(Collectors.toMap(x -> x.getEmail(), x -> x));
|
| 671 |
|
671 |
|
| 672 |
List<String> headers = Arrays.asList("Code", "Store Name", "Firm Name", "State Manager", "Teritory Manager",
|
672 |
List<String> headers = Arrays.asList("Code", "Firm Name", "Store Name", "State Manager", "Teritory Manager",
|
| 673 |
"Team Leader", "Target Name", "Target Value", "Target Achieved", "Achived Percentage",
|
673 |
"Team Leader", "Target Name", "Target Value", "Target Achieved", "Achived Percentage",
|
| 674 |
"Remaining Target", "Today's Target", "Today's achievement");
|
674 |
"Remaining Target", "Today's Target", "Today's achievement");
|
| 675 |
|
675 |
|
| 676 |
List<List<? extends Serializable>> rows = new ArrayList<>();
|
676 |
List<List<? extends Serializable>> rows = new ArrayList<>();
|
| 677 |
Map<String, List<Serializable>> partnerRowMap = new HashMap<>();
|
677 |
Map<String, List<Serializable>> partnerRowMap = new HashMap<>();
|
| 678 |
for (Map.Entry<String, List<? extends Serializable>> partnerSalesTargetRowEntry : partnerSalesTargetRowsMap
|
678 |
for (Map.Entry<String, List<? extends Serializable>> partnerSalesTargetRowEntry : partnerSalesTargetRowsMap
|
| 679 |
.entrySet()) {
|
679 |
.entrySet()) {
|
| 680 |
CustomRetailer retailer = customRetailerEmailMap.get(partnerSalesTargetRowEntry.getKey());
|
680 |
CustomRetailer retailer = customRetailerEmailMap.get(partnerSalesTargetRowEntry.getKey());
|
| 681 |
FofoStore fofoStore = fofoStoresMap.get(retailer.getPartnerId());
|
681 |
FofoStore fofoStore = fofoStoresMap.get(retailer.getPartnerId());
|
| 682 |
Serializable code = fofoStore.getCode();
|
682 |
Serializable code = fofoStore.getCode();
|
| 683 |
Serializable storeName = "SmartDukaan-" + fofoStore.getCode().replace("\\[a-zA-Z]+", "");
|
683 |
Serializable storeName = "SmartDukaan-" + fofoStore.getCode().replaceAll("[a-zA-Z]", "");
|
| 684 |
Serializable businessName = retailer.getBusinessName();
|
684 |
Serializable businessName = retailer.getBusinessName();
|
| 685 |
try {
|
685 |
try {
|
| 686 |
Serializable stateManager = storeManagerMap.get(retailer.getEmail()).get(2);
|
686 |
Serializable stateManager = storeManagerMap.get(retailer.getEmail()).get(2);
|
| 687 |
Serializable territoryManager = storeManagerMap.get(retailer.getEmail()).get(1);
|
687 |
Serializable territoryManager = storeManagerMap.get(retailer.getEmail()).get(1);
|
| 688 |
Serializable teamLeader = storeManagerMap.get(retailer.getEmail()).get(0);
|
688 |
Serializable teamLeader = storeManagerMap.get(retailer.getEmail()).get(0);
|
| 689 |
List<Serializable> row = new ArrayList<>(
|
689 |
List<Serializable> row = new ArrayList<>(
|
| 690 |
Arrays.asList(code, storeName, businessName, stateManager, territoryManager, teamLeader));
|
690 |
Arrays.asList(code, businessName, storeName, stateManager, territoryManager, teamLeader));
|
| 691 |
if (partnerSalesTargetRowsMap.get(retailer.getEmail()) != null) {
|
691 |
if (partnerSalesTargetRowsMap.get(retailer.getEmail()) != null) {
|
| 692 |
row.addAll(partnerSalesTargetRowsMap.get(retailer.getEmail()));
|
692 |
row.addAll(partnerSalesTargetRowsMap.get(retailer.getEmail()));
|
| 693 |
partnerRowMap.put(retailer.getEmail(), row);
|
693 |
partnerRowMap.put(retailer.getEmail(), row);
|
| 694 |
rows.add(row);
|
694 |
rows.add(row);
|
| 695 |
}
|
695 |
}
|