Subversion Repositories SmartDukaan

Rev

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

Rev 25344 Rev 25345
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
				}