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



		LOGGER.info("Cashbacks for Recharge processed Successfully");
	}
 
	public void sendPartnerInvestmentDetails(List<String> sendTo) throws Exception {
		if (sendTo == null) {
			sendTo = Arrays.asList(//"tarun.verma@smartdukaan.com", "kamini.sharma@smartdukaan.com",
					"amit.gupta@shop2020.in");
		}
		LocalDate yesterDay = LocalDate.now().minusDays(1);
		List<FofoStore> fofoStores = fofoStoreRepository.selectActiveStores();
		Map<Integer, CustomRetailer> customRetailerMap = retailerService

			}
		}
		storeGuyMap.remove("");
 
		String fileName = "InvestmentSummary-" + FormattingUtils.formatDate(LocalDateTime.now()) + ".csv";
		/*for (Map.Entry<String, Set<String>> storeGuyEntry : storeGuyMap.entrySet()) {
			List<List<? extends Serializable>> filteredRows = storeGuyEntry.getValue().stream()
					.map(x -> partnerRow.get(x)).collect(Collectors.toList());
			ByteArrayOutputStream baos = FileUtil.getCSVByteStream(headers, filteredRows);
			String[] sendToArray = new String[] { nameEmail.get(storeGuyEntry.getKey()) };
			Utils.sendMailWithAttachment(googleMailSender, sendToArray, null, "Partner Investment Summary", "PFA",
					fileName, new ByteArrayResource(baos.toByteArray()));
		}*/
 
		ByteArrayOutputStream baos = FileUtil.getCSVByteStream(headers, rows);
		String[] sendToArray = sendTo.toArray(new String[sendTo.size()]);
		Utils.sendMailWithAttachment(googleMailSender, sendToArray, null, "Partner Investment Summary", "PFA", fileName,
				new ByteArrayResource(baos.toByteArray()));

	}
 
	public void sendTargetVsSalesReport(List<String> sendTo) throws Exception {
 
		if (sendTo == null) {
			sendTo = Arrays.asList(//"tarun.verma@smartdukaan.com", "kamini.sharma@smartdukaan.com",
					"amit.gupta@shop2020.in");
		}
		List<PartnerTargetDetails> partnerTargetDetails = partnerTargetRepository
				.selectAllGeEqAndLeEqStartDateAndEndDate(LocalDateTime.now());
		Map<String, List<? extends Serializable>> partnerSalesTargetRowsMap = new HashMap<>();

				Serializable territoryManager = storeManagerMap.get(retailer.getEmail()).get(1);
				Serializable teamLeader = storeManagerMap.get(retailer.getEmail()).get(0);
				List<Serializable> row = new ArrayList<>(
						Arrays.asList(code, storeName, businessName, stateManager, territoryManager, teamLeader));
				if (partnerSalesTargetRowsMap.get(retailer.getEmail()) != null) {
					row.addAll(partnerSalesTargetRowsMap.get(retailer.getEmail()));
					partnerRowMap.put(retailer.getEmail(), row);
					rows.add(row);
				}
			} catch(Exception e) {
				LOGGER.warn("Could not find partner with email - {}", retailer.getEmail());

			}
		}
		storeGuyMap.remove("");
 
		String fileName = "TargetVsSales-" + FormattingUtils.formatDate(LocalDateTime.now()) + ".csv";
		/*for (Map.Entry<String, Set<String>> storeGuyEntry : storeGuyMap.entrySet()) {
			List<List<? extends Serializable>> filteredRows = storeGuyEntry.getValue().stream()
					.map(x -> partnerRowMap.get(x)).filter(x->x!=null).collect(Collectors.toList());
			ByteArrayOutputStream baos = FileUtil.getCSVByteStream(headers, filteredRows);
			String[] sendToArray = new String[] { nameEmail.get(storeGuyEntry.getKey()) };
			Utils.sendMailWithAttachment(googleMailSender, sendToArray, null, "Target vs Sales Summary", "PFA",
					fileName, new ByteArrayResource(baos.toByteArray()));
		}*/
 
		ByteArrayOutputStream baos = FileUtil.getCSVByteStream(headers, rows);
		String[] sendToArray = sendTo.toArray(new String[sendTo.size()]);
		Utils.sendMailWithAttachment(googleMailSender, sendToArray, null, "Target vs Sales Summary", "PFA", fileName,
				new ByteArrayResource(baos.toByteArray()));

Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java – Rev 25322 → 25323

Rev 25322		Rev 25323
Line 568...		Line 568...
568	`LOGGER.info("Cashbacks for Recharge processed Successfully");`	568	`LOGGER.info("Cashbacks for Recharge processed Successfully");`
569	`}`	569	`}`
570		570
571	`public void sendPartnerInvestmentDetails(List<String> sendTo) throws Exception {`	571	`public void sendPartnerInvestmentDetails(List<String> sendTo) throws Exception {`
572	`if (sendTo == null) {`	572	`if (sendTo == null) {`
573	`sendTo = Arrays.asList("tarun.verma@smartdukaan.com", "kamini.sharma@smartdukaan.com",`	573	`sendTo = Arrays.asList(//"tarun.verma@smartdukaan.com", "kamini.sharma@smartdukaan.com",`
574	`"amit.gupta@shop2020.in");`	574	`"amit.gupta@shop2020.in");`
575	`}`	575	`}`
576	`LocalDate yesterDay = LocalDate.now().minusDays(1);`	576	`LocalDate yesterDay = LocalDate.now().minusDays(1);`
577	`List<FofoStore> fofoStores = fofoStoreRepository.selectActiveStores();`	577	`List<FofoStore> fofoStores = fofoStoreRepository.selectActiveStores();`
578	`Map<Integer, CustomRetailer> customRetailerMap = retailerService`	578	`Map<Integer, CustomRetailer> customRetailerMap = retailerService`
Line 619...		Line 619...
619	`}`	619	`}`
620	`}`	620	`}`
621	`storeGuyMap.remove("");`	621	`storeGuyMap.remove("");`
622		622
623	`String fileName = "InvestmentSummary-" + FormattingUtils.formatDate(LocalDateTime.now()) + ".csv";`	623	`String fileName = "InvestmentSummary-" + FormattingUtils.formatDate(LocalDateTime.now()) + ".csv";`
624	`for (Map.Entry<String, Set<String>> storeGuyEntry : storeGuyMap.entrySet()) {`	624	`/*for (Map.Entry<String, Set<String>> storeGuyEntry : storeGuyMap.entrySet()) {`
625	`List<List<? extends Serializable>> filteredRows = storeGuyEntry.getValue().stream()`	625	`List<List<? extends Serializable>> filteredRows = storeGuyEntry.getValue().stream()`
626	`.map(x -> partnerRow.get(x)).collect(Collectors.toList());`	626	`.map(x -> partnerRow.get(x)).collect(Collectors.toList());`
627	`ByteArrayOutputStream baos = FileUtil.getCSVByteStream(headers, filteredRows);`	627	`ByteArrayOutputStream baos = FileUtil.getCSVByteStream(headers, filteredRows);`
628	`String[] sendToArray = new String[] { nameEmail.get(storeGuyEntry.getKey()) };`	628	`String[] sendToArray = new String[] { nameEmail.get(storeGuyEntry.getKey()) };`
629	`Utils.sendMailWithAttachment(googleMailSender, sendToArray, null, "Partner Investment Summary", "PFA",`	629	`Utils.sendMailWithAttachment(googleMailSender, sendToArray, null, "Partner Investment Summary", "PFA",`
630	`fileName, new ByteArrayResource(baos.toByteArray()));`	630	`fileName, new ByteArrayResource(baos.toByteArray()));`
631	`}`	631	`}*/`
632		632
633	`ByteArrayOutputStream baos = FileUtil.getCSVByteStream(headers, rows);`	633	`ByteArrayOutputStream baos = FileUtil.getCSVByteStream(headers, rows);`
634	`String[] sendToArray = sendTo.toArray(new String[sendTo.size()]);`	634	`String[] sendToArray = sendTo.toArray(new String[sendTo.size()]);`
635	`Utils.sendMailWithAttachment(googleMailSender, sendToArray, null, "Partner Investment Summary", "PFA", fileName,`	635	`Utils.sendMailWithAttachment(googleMailSender, sendToArray, null, "Partner Investment Summary", "PFA", fileName,`
636	`new ByteArrayResource(baos.toByteArray()));`	636	`new ByteArrayResource(baos.toByteArray()));`
Line 643...		Line 643...
643	`}`	643	`}`
644		644
645	`public void sendTargetVsSalesReport(List<String> sendTo) throws Exception {`	645	`public void sendTargetVsSalesReport(List<String> sendTo) throws Exception {`
646		646
647	`if (sendTo == null) {`	647	`if (sendTo == null) {`
648	`sendTo = Arrays.asList("tarun.verma@smartdukaan.com", "kamini.sharma@smartdukaan.com",`	648	`sendTo = Arrays.asList(//"tarun.verma@smartdukaan.com", "kamini.sharma@smartdukaan.com",`
649	`"amit.gupta@shop2020.in");`	649	`"amit.gupta@shop2020.in");`
650	`}`	650	`}`
651	`List<PartnerTargetDetails> partnerTargetDetails = partnerTargetRepository`	651	`List<PartnerTargetDetails> partnerTargetDetails = partnerTargetRepository`
652	`.selectAllGeEqAndLeEqStartDateAndEndDate(LocalDateTime.now());`	652	`.selectAllGeEqAndLeEqStartDateAndEndDate(LocalDateTime.now());`
653	`Map<String, List<? extends Serializable>> partnerSalesTargetRowsMap = new HashMap<>();`	653	`Map<String, List<? extends Serializable>> partnerSalesTargetRowsMap = new HashMap<>();`
Line 681...		Line 681...
681	`Serializable territoryManager = storeManagerMap.get(retailer.getEmail()).get(1);`	681	`Serializable territoryManager = storeManagerMap.get(retailer.getEmail()).get(1);`
682	`Serializable teamLeader = storeManagerMap.get(retailer.getEmail()).get(0);`	682	`Serializable teamLeader = storeManagerMap.get(retailer.getEmail()).get(0);`
683	`List<Serializable> row = new ArrayList<>(`	683	`List<Serializable> row = new ArrayList<>(`
684	`Arrays.asList(code, storeName, businessName, stateManager, territoryManager, teamLeader));`	684	`Arrays.asList(code, storeName, businessName, stateManager, territoryManager, teamLeader));`
685	`if (partnerSalesTargetRowsMap.get(retailer.getEmail()) != null) {`	685	`if (partnerSalesTargetRowsMap.get(retailer.getEmail()) != null) {`
686	`row.addAll(0, partnerSalesTargetRowsMap.get(retailer.getEmail()));`	686	`row.addAll(partnerSalesTargetRowsMap.get(retailer.getEmail()));`
687	`partnerRowMap.put(retailer.getEmail(), row);`	687	`partnerRowMap.put(retailer.getEmail(), row);`
688	`rows.add(row);`	688	`rows.add(row);`
689	`}`	689	`}`
690	`} catch(Exception e) {`	690	`} catch(Exception e) {`
691	`LOGGER.warn("Could not find partner with email - {}", retailer.getEmail());`	691	`LOGGER.warn("Could not find partner with email - {}", retailer.getEmail());`
Line 705...		Line 705...
705	`}`	705	`}`
706	`}`	706	`}`
707	`storeGuyMap.remove("");`	707	`storeGuyMap.remove("");`
708		708
709	`String fileName = "TargetVsSales-" + FormattingUtils.formatDate(LocalDateTime.now()) + ".csv";`	709	`String fileName = "TargetVsSales-" + FormattingUtils.formatDate(LocalDateTime.now()) + ".csv";`
710	`for (Map.Entry<String, Set<String>> storeGuyEntry : storeGuyMap.entrySet()) {`	710	`/*for (Map.Entry<String, Set<String>> storeGuyEntry : storeGuyMap.entrySet()) {`
711	`List<List<? extends Serializable>> filteredRows = storeGuyEntry.getValue().stream()`	711	`List<List<? extends Serializable>> filteredRows = storeGuyEntry.getValue().stream()`
712	`.map(x -> partnerRowMap.get(x)).filter(x->x!=null).collect(Collectors.toList());`	712	`.map(x -> partnerRowMap.get(x)).filter(x->x!=null).collect(Collectors.toList());`
713	`ByteArrayOutputStream baos = FileUtil.getCSVByteStream(headers, filteredRows);`	713	`ByteArrayOutputStream baos = FileUtil.getCSVByteStream(headers, filteredRows);`
714	`String[] sendToArray = new String[] { nameEmail.get(storeGuyEntry.getKey()) };`	714	`String[] sendToArray = new String[] { nameEmail.get(storeGuyEntry.getKey()) };`
715	`Utils.sendMailWithAttachment(googleMailSender, sendToArray, null, "Target vs Sales Summary", "PFA",`	715	`Utils.sendMailWithAttachment(googleMailSender, sendToArray, null, "Target vs Sales Summary", "PFA",`
716	`fileName, new ByteArrayResource(baos.toByteArray()));`	716	`fileName, new ByteArrayResource(baos.toByteArray()));`
717	`}`	717	`}*/`
718		718
719	`ByteArrayOutputStream baos = FileUtil.getCSVByteStream(headers, rows);`	719	`ByteArrayOutputStream baos = FileUtil.getCSVByteStream(headers, rows);`
720	`String[] sendToArray = sendTo.toArray(new String[sendTo.size()]);`	720	`String[] sendToArray = sendTo.toArray(new String[sendTo.size()]);`
721	`Utils.sendMailWithAttachment(googleMailSender, sendToArray, null, "Target vs Sales Summary", "PFA", fileName,`	721	`Utils.sendMailWithAttachment(googleMailSender, sendToArray, null, "Target vs Sales Summary", "PFA", fileName,`
722	`new ByteArrayResource(baos.toByteArray()));`	722	`new ByteArrayResource(baos.toByteArray()));`