Subversion Repositories SmartDukaan

package com.spice.profitmandi.web.controller;

package com.spice.profitmandi.web.controller;

import com.google.gson.Gson;

import com.google.gson.Gson;

import com.mongodb.DBObject;

import com.mongodb.DBObject;

import com.spice.profitmandi.common.enumuration.ContentType;

import com.spice.profitmandi.common.enumuration.ContentType;

import com.spice.profitmandi.common.enumuration.MessageType;

import com.spice.profitmandi.common.enumuration.MessageType;

import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;

import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;

@Controller

@Controller

@Transactional(rollbackFor = Throwable.class)

@Transactional(rollbackFor = Throwable.class)

public class DashboardController {

public class DashboardController {

    List<String> emails = Arrays.asList("kamini.sharma@smartdukaan.com", "neeraj.gupta@smartdukaan.com", "amit.gupta@smartdukaan.com", "ranu.rajput@smartdukaan.com", "vikas.jangra@smartdukaan.com", "tanay.gupta@smartdukaan.com", "rudy.kanwar@smartdukaan.com");

    List<String> emails = Arrays.asList("kamini.sharma@smartdukaan.com", "neeraj.gupta@smartdukaan.com", "amit.gupta@smartdukaan.com", "ranu.rajput@smartdukaan.com", "vikas.jangra@smartdukaan.com", "tanay.gupta@smartdukaan.com", "rudy.kanwar@smartdukaan.com");

    @Value("${web.api.host}")

    @Value("${web.api.host}")

    private String webApiHost;

    private String webApiHost;

        Map<Integer, List<Integer>> warehouseIdFofoIdMap = fofoStoreRepository

        Map<Integer, List<Integer>> warehouseIdFofoIdMap = fofoStoreRepository

                .selectActivePartnersByRetailerIds(new ArrayList<>(fofoIds)).stream()

                .selectActivePartnersByRetailerIds(new ArrayList<>(fofoIds)).stream()

                .collect(Collectors.groupingBy(FofoStore::getWarehouseId,

                .collect(Collectors.groupingBy(FofoStore::getWarehouseId,

                        Collectors.mapping(FofoStore::getId, Collectors.toList())));

                        Collectors.mapping(FofoStore::getId, Collectors.toList())));

        }

        }

        List<WarehouseWiseBrandStockModel> warehouseWiseBrandStock = new ArrayList<>();

        List<WarehouseWiseBrandStockModel> warehouseWiseBrandStock = new ArrayList<>();

        if (!warehouseId.contains(0)) {

        if (!warehouseId.contains(0)) {

            warehouseWiseBrandStock = saholicInventoryCISRepository.selectGroupByWarehouseAndBrand(warehouseId);

            warehouseWiseBrandStock = saholicInventoryCISRepository.selectGroupByWarehouseAndBrand(warehouseId);

        } else {

        } else {

            LOGGER.info("warehouseIdFofoIdMap" + warehouseIdFofoIdMap.keySet());

            LOGGER.info("warehouseIdFofoIdMap" + warehouseIdFofoIdMap.keySet());

            warehouseWiseBrandStock = saholicInventoryCISRepository.selectGroupByWarehouseAndBrand(new ArrayList<>(warehouseIdFofoIdMap.keySet()));

            warehouseWiseBrandStock = saholicInventoryCISRepository.selectGroupByWarehouseAndBrand(new ArrayList<>(warehouseIdFofoIdMap.keySet()));

        }

        }

        model.addAttribute("warehouseWiseBrandStock", warehouseWiseBrandStock);

        model.addAttribute("warehouseWiseBrandStock", warehouseWiseBrandStock);

        model.addAttribute("warehouseId", warehouseId);

        model.addAttribute("warehouseId", warehouseId);

        model.addAttribute("warehouseMap", warehouseMap);

        model.addAttribute("warehouseMap", warehouseMap);

        return "warehouse_brand_stock";

        return "warehouse_brand_stock";

                                           Model model) throws Exception {

                                           Model model) throws Exception {

        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

        LinkedHashMap<Integer, WarehouseWiseStockModel> stockMap =

        LinkedHashMap<Integer, WarehouseWiseStockModel> stockMap =

                adminUser.getWarehouseStockMap(loginDetails.getEmailId(), brands);

                adminUser.getWarehouseStockMap(loginDetails.getEmailId(), brands);

        // Same shape adminPanel uses so the Total Values row (key 0) renders its label.

        // Same shape adminPanel uses so the Total Values row (key 0) renders its label.

        warehouseMap.put(0, "Total Values");

        warehouseMap.put(0, "Total Values");

        model.addAttribute("warehouseStockMap", stockMap);

        model.addAttribute("warehouseStockMap", stockMap);

        model.addAttribute("warehouseMap", warehouseMap);

        model.addAttribute("warehouseMap", warehouseMap);

        return "warehouse_wise_stock_rows";

        return "warehouse_wise_stock_rows";

    }

    }

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

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

    public String getWarehouseWiseBrandAndCategory(HttpServletRequest request, Model

    public String getWarehouseWiseBrandAndCategory(HttpServletRequest request, Model

            model, @RequestParam List<Integer> warehouseId, @RequestParam List<String> brands, @RequestParam String

            model, @RequestParam List<Integer> warehouseId, @RequestParam List<String> brands, @RequestParam String

                                                           category) throws Exception {

                                                           category) throws Exception {

        List<String> listbrands = saholicInventoryCISRepository.selectAllBrand();

        List<String> listbrands = saholicInventoryCISRepository.selectAllBrand();

        List<String> listCategory = saholicInventoryCISRepository.selectAllSubCategory();

        List<String> listCategory = saholicInventoryCISRepository.selectAllSubCategory();

        model.addAttribute("warehouseMap", warehouseMap);

        model.addAttribute("warehouseMap", warehouseMap);

        model.addAttribute("brands", listbrands);

        model.addAttribute("brands", listbrands);

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

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

    public String getWarehouseWiseItemStock(HttpServletRequest request, Model

    public String getWarehouseWiseItemStock(HttpServletRequest request, Model

            model, @RequestParam(name = "warehouseId") List<Integer> warehouseIds, @RequestParam List<String> brands, @RequestParam String

            model, @RequestParam(name = "warehouseId") List<Integer> warehouseIds, @RequestParam List<String> brands, @RequestParam String

                                                    category) throws Exception {

                                                    category) throws Exception {

        if (warehouseIds.contains(0)) {

        if (warehouseIds.contains(0)) {

            warehouseIds.addAll(warehouseMap.keySet());

            warehouseIds.addAll(warehouseMap.keySet());

        }

        }

        // Band-aid for URL '+' decode issue on brand names (e.g. "Ai+"):

        // Band-aid for URL '+' decode issue on brand names (e.g. "Ai+"):

        // if a brand doesn't exist in catalog.brand as-is but "<brand>+" does,

        // if a brand doesn't exist in catalog.brand as-is but "<brand>+" does,

                bpt.setLmtd(0);

                bpt.setLmtd(0);

                bpt.setLmtdQty(0);

                bpt.setLmtdQty(0);

                warehouseWiseBrandPartnerSales.put(un.getWarehouseId(), bpt);

                warehouseWiseBrandPartnerSales.put(un.getWarehouseId(), bpt);

            }

            }

        }

        }

        Set<String> brands = inventoryService.getAllTagListingBrands();

        Set<String> brands = inventoryService.getAllTagListingBrands();

        model.addAttribute("warehouseWiseBrandPartnerSales", warehouseWiseBrandPartnerSales);

        model.addAttribute("warehouseWiseBrandPartnerSales", warehouseWiseBrandPartnerSales);

        model.addAttribute("warehouseMap", warehouseMap);

        model.addAttribute("warehouseMap", warehouseMap);

        model.addAttribute("brands", brands);

        model.addAttribute("brands", brands);

            if (positions1.stream().filter(x -> x.getCategoryId() == ProfitMandiConstants.TICKET_CATEGORY_MASTER).count() > 0) {

            if (positions1.stream().filter(x -> x.getCategoryId() == ProfitMandiConstants.TICKET_CATEGORY_MASTER).count() > 0) {

                authfofoIds = csService.getPositionCustomRetailerMap(positions1).values().stream().flatMap(x -> x.stream()).map(x -> x.getPartnerId()).collect(Collectors.toSet());

                authfofoIds = csService.getPositionCustomRetailerMap(positions1).values().stream().flatMap(x -> x.stream()).map(x -> x.getPartnerId()).collect(Collectors.toSet());

            }

            }

        }

        }

        List<WarehouseWiseBrandSaleModel> warehouseWiseBrandPartnerSales = fofoStoreRepository.selectGroupByWarehouseAccesoriesBrandWisePartnerSale(brand, new ArrayList<>(authfofoIds));

        List<WarehouseWiseBrandSaleModel> warehouseWiseBrandPartnerSales = fofoStoreRepository.selectGroupByWarehouseAccesoriesBrandWisePartnerSale(brand, new ArrayList<>(authfofoIds));

        Set<String> brands = inventoryService.getAllTagListingBrands();

        Set<String> brands = inventoryService.getAllTagListingBrands();

        model.addAttribute("warehouseWiseBrandPartnerSales", warehouseWiseBrandPartnerSales);

        model.addAttribute("warehouseWiseBrandPartnerSales", warehouseWiseBrandPartnerSales);

        model.addAttribute("warehouseMap", warehouseMap);

        model.addAttribute("warehouseMap", warehouseMap);

        model.addAttribute("brands", brands);

        model.addAttribute("brands", brands);

    }

    }

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

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

    public String getWarehouseBrandWiseItemSale(HttpServletRequest request, Model

    public String getWarehouseBrandWiseItemSale(HttpServletRequest request, Model

            model, @RequestParam List<Integer> warehouseId, @RequestParam String brand) throws Exception {

            model, @RequestParam List<Integer> warehouseId, @RequestParam String brand) throws Exception {

        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

        String email = loginDetails.getEmailId();

        String email = loginDetails.getEmailId();

        Set<Integer> authfofoIds = csService1.getAuthFofoIds(email, true);

        Set<Integer> authfofoIds = csService1.getAuthFofoIds(email, true);

        Map<Integer, WarehouseBrandWiseItemSaleModel> branditemSalesMap = fofoStoreRepository.selectWarehouseBrandItemSale(warehouseId, brand, new ArrayList<>(authfofoIds)).stream().collect(Collectors.toMap(x -> x.getItemId(), x -> x));

        Map<Integer, WarehouseBrandWiseItemSaleModel> branditemSalesMap = fofoStoreRepository.selectWarehouseBrandItemSale(warehouseId, brand, new ArrayList<>(authfofoIds)).stream().collect(Collectors.toMap(x -> x.getItemId(), x -> x));

    }

    }

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

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

    public String getWarehouseAccesoriesBrandWiseItemSale(HttpServletRequest request, Model

    public String getWarehouseAccesoriesBrandWiseItemSale(HttpServletRequest request, Model

            model, @RequestParam List<Integer> warehouseId, @RequestParam String brand) throws Exception {

            model, @RequestParam List<Integer> warehouseId, @RequestParam String brand) throws Exception {

        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

        String email = loginDetails.getEmailId();

        String email = loginDetails.getEmailId();

        Map<String, Set<Integer>> storeGuyMap = csService.getAuthUserPartnerIdMapping();

        Map<String, Set<Integer>> storeGuyMap = csService.getAuthUserPartnerIdMapping();

        Set<Integer> authfofoIds = storeGuyMap.get(email);

        Set<Integer> authfofoIds = storeGuyMap.get(email);

        List<WarehouseBrandWiseItemSaleModel> branditemSales = fofoStoreRepository.selectWarehouseAccesoriesBrandItemSale(warehouseId, brand, new ArrayList<>(authfofoIds));

        List<WarehouseBrandWiseItemSaleModel> branditemSales = fofoStoreRepository.selectWarehouseAccesoriesBrandItemSale(warehouseId, brand, new ArrayList<>(authfofoIds));

                }

                }

            }

            }

        }

        }

        model.addAttribute("warehouseId", warehouseId);

        model.addAttribute("warehouseId", warehouseId);

        model.addAttribute("milestones", Milestone.values());

        model.addAttribute("milestones", Milestone.values());

        return "sale-milestone";

        return "sale-milestone";

                }

                }

            }

            }

        }

        }

        model.addAttribute("warehouseId", warehouseId);

        model.addAttribute("warehouseId", warehouseId);

        model.addAttribute("milestones", Milestone.values());

        model.addAttribute("milestones", Milestone.values());

        return "purchase-milestone";

        return "purchase-milestone";

    public String getActivatedModelWarehouseWise(HttpServletRequest request, Model model, @RequestParam String

    public String getActivatedModelWarehouseWise(HttpServletRequest request, Model model, @RequestParam String

            brand) throws Exception {

            brand) throws Exception {

        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

        List<Integer> fofoIds = getFofoIds(loginDetails);

        List<Integer> fofoIds = getFofoIds(loginDetails);

        List<WarehouseWiseActivatedModel> warehouseWiseActivatedModels = activatedImeiRepository.selectActivatedModelGroupByWarehouse(brand, fofoIds);

        List<WarehouseWiseActivatedModel> warehouseWiseActivatedModels = activatedImeiRepository.selectActivatedModelGroupByWarehouse(brand, fofoIds);

        List<DBObject> mobileBrands = mongoClient.getAllBrandsToDisplay(3);

        List<DBObject> mobileBrands = mongoClient.getAllBrandsToDisplay(3);

        List<String> brands = mobileBrands.stream().map(x -> (String) x.get("name")).collect(Collectors.toList());

        List<String> brands = mobileBrands.stream().map(x -> (String) x.get("name")).collect(Collectors.toList());

        LOGGER.info("brands" + brands.add("Redmi"));

        LOGGER.info("brands" + brands.add("Redmi"));

    public String getWarehouseBrandWiseItemActivatedModel(HttpServletRequest request, Model

    public String getWarehouseBrandWiseItemActivatedModel(HttpServletRequest request, Model

            model, @RequestParam List<Integer> warehouseId, @RequestParam String brand) throws Exception {

            model, @RequestParam List<Integer> warehouseId, @RequestParam String brand) throws Exception {

        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

        List<Integer> fofoIds = getFofoIds(loginDetails);

        List<Integer> fofoIds = getFofoIds(loginDetails);

        List<WarehouseBrandWiseItemActivatedModel> activatedItems = activatedImeiRepository.selectWarehouseBrandActivatedItem(warehouseId, brand, fofoIds);

        List<WarehouseBrandWiseItemActivatedModel> activatedItems = activatedImeiRepository.selectWarehouseBrandActivatedItem(warehouseId, brand, fofoIds);

        model.addAttribute("warehouseMap", warehouseMap);

        model.addAttribute("warehouseMap", warehouseMap);

        model.addAttribute("activatedItems", activatedItems);

        model.addAttribute("activatedItems", activatedItems);

        return "warehouse-activated-itemwise-model";

        return "warehouse-activated-itemwise-model";

    }

    }

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

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

    public String getActivatedImeiUpdationDate(HttpServletRequest request, Model model) throws Exception {

    public String getActivatedImeiUpdationDate(HttpServletRequest request, Model model) throws Exception {

        List<String> brands = ProfitMandiConstants.BRANDS;

        List<String> brands = ProfitMandiConstants.BRANDS;

        List<ActivationImeiUpdationModel> activationImeiUpdations = activatedImeiRepository.selectActivatedUpdationDate();

        List<ActivationImeiUpdationModel> activationImeiUpdations = activatedImeiRepository.selectActivatedUpdationDate();

        // Create a map for quick lookup of existing results

        // Create a map for quick lookup of existing results