Subversion Repositories SmartDukaan

import com.spice.profitmandi.service.FofoUser;

import java.time.LocalDate;

import java.time.YearMonth;

    @Autowired

    FofoUser fofoUser;

    @RequestMapping(value = "/getMonthSale", method = RequestMethod.GET)

    public ResponseEntity<?> getMonthsale(HttpServletRequest request) throws Exception {

        UserInfo userInfo = (UserInfo) request.getAttribute("userInfo");

        int fofoId = userInfo.getRetailerId();

        logger.info("getting the user resonse {} ",userInfo);

        Map<String, MonthSaleModel> monthSaleMap = new HashMap<>();

        LocalDateTime curDate = LocalDate.now().atStartOfDay();

        int dayOfMonth = curDate.getDayOfMonth();

        YearMonth yearMonth = YearMonth.now();

        for (int i = 1; i <= 6; i++) {

            LocalDateTime startOfMonth = curDate.withDayOfMonth(1).minusMonths(i);

            int lengthOfMonth = YearMonth.from(startOfMonth).lengthOfMonth();

            logger.info("Start of previous Month {}, start of next month Month {}", startOfMonth, startOfMonth.plusMonths(1));

            double monthSales = fofoOrderItemRepository.selectSumMopGroupByRetailer(startOfMonth, startOfMonth.plusMonths(1), fofoId, false).get(fofoId);

            double mtdSales = fofoOrderItemRepository.selectSumMopGroupByRetailer(startOfMonth, startOfMonth.plusDays(Math.min(dayOfMonth, lengthOfMonth)), fofoId, false).get(fofoId);

            MonthSaleModel ms = new MonthSaleModel();

            ms.setMtdSales(fofoUser.format((long) mtdSales));

            ms.setMonthlySales(fofoUser.format(((long) monthSales)));

            ms.setMonth(startOfMonth.format(DateTimeFormatter.ofPattern("MMM''uu")));

            monthSaleMap.put(String.valueOf(i), ms);

        }

        logger.info("getting the month sale map {}",monthSaleMap);

        return responseSender.ok(monthSaleMap);

    }

    @RequestMapping(value = "/getBrandwisePartnerSale", method = RequestMethod.GET)

    @ResponseBody

    public ResponseEntity<?> getBrandwisePartnerSale(HttpServletRequest request, @RequestParam(name = "month", required = true, defaultValue = "0") int month, Model model) throws Exception {

        UserInfo userInfo = (UserInfo) request.getAttribute("userInfo");

        int fofoId = userInfo.getRetailerId();

        if (month < 1 || month > 12) {

            throw new IllegalArgumentException("Month must be between 1 and 12");

        }

        List<BrandWisePartnerSaleModel> brandWisePartnerSaleModels = fofoStoreRepository.selectBrandWiseMonthlyPartnerSale(Collections.singletonList(fofoId), month);

        List<Map<String, Object>> response = new ArrayList<>();

        for (BrandWisePartnerSaleModel m : brandWisePartnerSaleModels) {

            Map<String, Object> row = new HashMap<>();

            row.put("brand", m.getBrand());

            row.put("lms", fofoUser.format(m.getLms()));

            row.put("lmsQty", m.getLmsQty());

            row.put("mtd", fofoUser.format(m.getMtd()));

            row.put("mtdQty", m.getMtdQty());

            row.put("lmtd", fofoUser.format(m.getLmtd()));

            row.put("lmtdQty", m.getLmtdQty());

            row.put("amtd", fofoUser.format(m.getAmtd()));

            response.add(row);

        }

        logger.info("brandItemWisePartnerSaleModels {}", response);

        return responseSender.ok(response);

    }

    @RequestMapping(value = "/getBrandItemwisePartnerSale", method = RequestMethod.GET)

    @ResponseBody

    public ResponseEntity<?> getBrandItemwisePartnerSale(HttpServletRequest request, @RequestParam(name = "month", required = true, defaultValue = "0") int month, @RequestParam(name = "brand") String brand) throws Exception {

        UserInfo userInfo = (UserInfo) request.getAttribute("userInfo");

        int fofoId = userInfo.getRetailerId();

        if (month < 1 || month > 12) {

            throw new IllegalArgumentException("Month must be between 1 and 12");

        }

        List<BrandItemWisePartnerSaleModel> brandItemWisePartnerSaleModels = fofoStoreRepository.selectPartnerBrandItemMonthlySale(Collections.singletonList(fofoId), month, brand);

        logger.info("getting brandwise item sale {}",brandItemWisePartnerSaleModels);

        return responseSender.ok(brandItemWisePartnerSaleModels);

    }