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



    @Autowired
    RbmTargetService rbmTargetService;
 
    public void test() throws Exception {
        System.out.println("test start");
        this.generateBiReportExcel();
        System.out.println("test end");
 
    }
 
    public void generateBiReport() throws Exception {

 
    public void generateBiReportExcel() throws Exception {
 
        LocalDateTime startOfToday = LocalDate.now().atStartOfDay();
 
        /*Map<Integer, CustomRetailer> customRetailers = retailerService.getAllFofoRetailersInternalFalse();
 
        List<Integer> retailerIds = customRetailers.values().stream().map(CustomRetailer::getPartnerId).collect(Collectors.toList());*/
 
        List<Integer> retailerIds = Arrays.asList(175139401,175139400,175139381,175139667,175139662,175139661,175130896,175139323,175139452);
        Map<Integer,CustomRetailer> customRetailers = retailerService.getFofoRetailers(retailerIds);
 
        //partner daily investment
        List<Loan> defaultLoans = sdCreditService.getDefaultLoan();
        Map<Integer,List<Loan>> defaultLoanMap = defaultLoans.stream().collect(Collectors.groupingBy(Loan::getFofoId));
 

                    brandSecondaryMap.getOrDefault("Poco", 0L),
                    brandSecondaryMap.getOrDefault("Lava", 0L),
                    brandSecondaryMap.getOrDefault("Itel", 0L),
                    brandSecondaryMap.getOrDefault("Almost New", 0L)
            ));
 
 
            Map<String, Double> brandTertiaryMap = fofoBrandMtdTertiaryMap.get(fofoId);
            row.addAll(Arrays.asList(
                    fofoTotalMtdTertiaryMap.get(fofoId),
                    brandTertiaryMap.getOrDefault("Apple", 0d),

Subversion Repositories SmartDukaan

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

Rev 34648		Rev 34653
Line 147...		Line 147...
147	`@Autowired`	147	`@Autowired`
148	`RbmTargetService rbmTargetService;`	148	`RbmTargetService rbmTargetService;`
149		149
150	`public void test() throws Exception {`	150	`public void test() throws Exception {`
151	`System.out.println("test start");`	151	`System.out.println("test start");`
-		152	`this.generateBiReportExcel();`
152	`System.out.println("test end");`	153	`System.out.println("test end");`
153		154
154	`}`	155	`}`
155		156
156	`public void generateBiReport() throws Exception {`	157	`public void generateBiReport() throws Exception {`
Line 444...		Line 445...
444		445
445	`public void generateBiReportExcel() throws Exception {`	446	`public void generateBiReportExcel() throws Exception {`
446		447
447	`LocalDateTime startOfToday = LocalDate.now().atStartOfDay();`	448	`LocalDateTime startOfToday = LocalDate.now().atStartOfDay();`
448		449
449	`Map<Integer, CustomRetailer> customRetailers = retailerService.getAllFofoRetailersInternalFalse();`	450	`/*Map<Integer, CustomRetailer> customRetailers = retailerService.getAllFofoRetailersInternalFalse();`
450		451
451	`List<Integer> retailerIds = customRetailers.values().stream().map(CustomRetailer::getPartnerId).collect(Collectors.toList());`	452	`List<Integer> retailerIds = customRetailers.values().stream().map(CustomRetailer::getPartnerId).collect(Collectors.toList());*/`
452		453
453	`/* List<Integer> retailerIds = Arrays.asList(175139401,175139400,175139381,175139667,175139662,175139661,175130896,175139323,175139452);`	454	`List<Integer> retailerIds = Arrays.asList(175139401,175139400,175139381,175139667,175139662,175139661,175130896,175139323,175139452);`
454	`Map<Integer,CustomRetailer> customRetailers = retailerService.getFofoRetailers(retailerIds);*/`	455	`Map<Integer,CustomRetailer> customRetailers = retailerService.getFofoRetailers(retailerIds);`
455		456
456	`//partner daily investment`	457	`//partner daily investment`
457	`List<Loan> defaultLoans = sdCreditService.getDefaultLoan();`	458	`List<Loan> defaultLoans = sdCreditService.getDefaultLoan();`
458	`Map<Integer,List<Loan>> defaultLoanMap = defaultLoans.stream().collect(Collectors.groupingBy(Loan::getFofoId));`	459	`Map<Integer,List<Loan>> defaultLoanMap = defaultLoans.stream().collect(Collectors.groupingBy(Loan::getFofoId));`
459		460
Line 976...		Line 977...
976	`brandSecondaryMap.getOrDefault("Poco", 0L),`	977	`brandSecondaryMap.getOrDefault("Poco", 0L),`
977	`brandSecondaryMap.getOrDefault("Lava", 0L),`	978	`brandSecondaryMap.getOrDefault("Lava", 0L),`
978	`brandSecondaryMap.getOrDefault("Itel", 0L),`	979	`brandSecondaryMap.getOrDefault("Itel", 0L),`
979	`brandSecondaryMap.getOrDefault("Almost New", 0L)`	980	`brandSecondaryMap.getOrDefault("Almost New", 0L)`
980	`));`	981	`));`
981	`rows.add(row);`	-
982		982
983	`Map<String, Double> brandTertiaryMap = fofoBrandMtdTertiaryMap.get(fofoId);`	983	`Map<String, Double> brandTertiaryMap = fofoBrandMtdTertiaryMap.get(fofoId);`
984	`row.addAll(Arrays.asList(`	984	`row.addAll(Arrays.asList(`
985	`fofoTotalMtdTertiaryMap.get(fofoId),`	985	`fofoTotalMtdTertiaryMap.get(fofoId),`
986	`brandTertiaryMap.getOrDefault("Apple", 0d),`	986	`brandTertiaryMap.getOrDefault("Apple", 0d),`