WebSVN – SmartDukaan – Diff – /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/DashboardController.java

 import java.io.File;
 import java.io.FileInputStream;
 import java.io.FileNotFoundException;
 import java.io.FileOutputStream;
-import java.io.ObjectInputStream;
 import java.io.ObjectOutputStream;
-import java.text.DateFormat;
-import java.text.SimpleDateFormat;
 import java.time.LocalDate;
 import java.time.LocalDateTime;
 import java.time.LocalTime;
-import java.time.Month;
-import java.time.Period;
 import java.time.YearMonth;
-import java.time.ZoneOffset;
 import java.time.format.DateTimeFormatter;
 import java.util.ArrayList;
 import java.util.Arrays;
-import java.util.Collection;
 import java.util.Collections;
-import java.util.Comparator;
-import java.util.Date;
 import java.util.HashMap;
-import java.util.HashSet;
 import java.util.LinkedHashMap;
-import java.util.LinkedHashSet;
 import java.util.List;
-import java.util.Locale;
 import java.util.Map;
 import java.util.Map.Entry;
 import java.util.Optional;
 import java.util.Set;
 import java.util.TreeMap;
-import java.util.stream.Collector;
 import java.util.stream.Collectors;
 import javax.servlet.http.HttpServletRequest;
 import javax.transaction.Transactional;
-import org.apache.commons.collections4.OrderedMap;
 import org.apache.logging.log4j.LogManager;
 import org.apache.logging.log4j.Logger;
 import org.json.JSONObject;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.beans.factory.annotation.Value;
 import org.springframework.core.io.InputStreamResource;
 import org.springframework.http.HttpHeaders;
 import org.springframework.ui.Model;
 import org.springframework.web.bind.annotation.RequestMapping;
 import org.springframework.web.bind.annotation.RequestMethod;
 import org.springframework.web.bind.annotation.RequestParam;
-import com.google.common.collect.ArrayListMultimap;
-import com.google.common.collect.Multimap;
 import com.google.gson.Gson;
-import com.mongodb.DBObject;
 import com.spice.profitmandi.common.enumuration.ContentType;
 import com.spice.profitmandi.common.enumuration.MessageType;
-import com.spice.profitmandi.common.enumuration.ReporticoProject;
 import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
 import com.spice.profitmandi.common.model.ActivateItemModel;
-import com.spice.profitmandi.common.model.Axis;
-import com.spice.profitmandi.common.model.BrandStockPrice;
 import com.spice.profitmandi.common.model.ChartInvestmentModel;
 import com.spice.profitmandi.common.model.ChartModel;
 import com.spice.profitmandi.common.model.CustomRetailer;
-import com.spice.profitmandi.common.model.Data;
-import com.spice.profitmandi.common.model.DataInvestmentModel;
-import com.spice.profitmandi.common.model.DataModel;
-import com.spice.profitmandi.common.model.DatasetModel;
-import com.spice.profitmandi.common.model.HoverModel;
-import com.spice.profitmandi.common.model.Legend;
-import com.spice.profitmandi.common.model.LegendModel;
 import com.spice.profitmandi.common.model.Notification;
 import com.spice.profitmandi.common.model.OnlineDeliveredOrderSum;
-import com.spice.profitmandi.common.model.OptionModel;
-import com.spice.profitmandi.common.model.OptionsModel;
-import com.spice.profitmandi.common.model.PieLables;
-import com.spice.profitmandi.common.model.PluginsModel;
 import com.spice.profitmandi.common.model.ProfitMandiConstants;
-import com.spice.profitmandi.common.model.ScalesModel;
-import com.spice.profitmandi.common.model.TitleModel;
-import com.spice.profitmandi.common.model.Tooltips;
 import com.spice.profitmandi.common.web.util.ResponseSender;
-import com.spice.profitmandi.dao.Interface.Campaign;
 import com.spice.profitmandi.dao.entity.auth.AuthUser;
-import com.spice.profitmandi.dao.entity.auth.Menu;
 import com.spice.profitmandi.dao.entity.catalog.Item;
 import com.spice.profitmandi.dao.entity.catalog.TagListing;
-import com.spice.profitmandi.dao.entity.cs.Position;
 import com.spice.profitmandi.dao.entity.cs.TicketAssigned;
 import com.spice.profitmandi.dao.entity.dtr.Document;
 import com.spice.profitmandi.dao.entity.dtr.NotificationCampaign;
 import com.spice.profitmandi.dao.entity.fofo.FofoStore;
 import com.spice.profitmandi.dao.entity.fofo.InventoryItem;
-import com.spice.profitmandi.dao.entity.fofo.PartnerDailyInvestment;
-import com.spice.profitmandi.dao.entity.fofo.PartnerTargetDetails;
 import com.spice.profitmandi.dao.entity.fofo.PartnerType;
-import com.spice.profitmandi.dao.entity.fofo.PendingOrder;
-import com.spice.profitmandi.dao.entity.fofo.PendingOrderItem;
 import com.spice.profitmandi.dao.entity.inventory.ReporticoCacheTable;
 import com.spice.profitmandi.dao.entity.transaction.Order;
-import com.spice.profitmandi.dao.entity.user.Lead;
-import com.spice.profitmandi.dao.enumuration.cs.EscalationType;
-import com.spice.profitmandi.dao.enumuration.dtr.LeadStatus;
 import com.spice.profitmandi.dao.enumuration.transaction.OrderStatus;
-import com.spice.profitmandi.dao.model.BrandWiseModel;
 import com.spice.profitmandi.dao.model.BrandWisePartnerSaleModel;
 import com.spice.profitmandi.dao.model.BrandWiseUnbilledActivateStockModel;
 import com.spice.profitmandi.dao.model.CreateOfferRequest;
 import com.spice.profitmandi.dao.model.InStockBrandItemModel;
 import com.spice.profitmandi.dao.model.InStockBrandModel;
 import com.spice.profitmandi.dao.model.MonthSaleModel;
 import com.spice.profitmandi.dao.model.PartnerDetailModel;
 import com.spice.profitmandi.dao.model.PartnerPendingIndentItemModel;
 import com.spice.profitmandi.dao.model.PriceDropWithDetailsByYearMonthModel;
 import com.spice.profitmandi.dao.model.PriceDropYearMonthModel;
-import com.spice.profitmandi.dao.model.SecondaryOrderBilledLmsModel;
-import com.spice.profitmandi.dao.model.SimpleCampaign;
-import com.spice.profitmandi.dao.model.SimpleCampaignParams;
 import com.spice.profitmandi.dao.model.WarehouseBrandItemUnbilledActivatedModel;
 import com.spice.profitmandi.dao.model.WarehouseBrandWiseItemSaleModel;
 import com.spice.profitmandi.dao.model.WarehouseWiseBrandSaleModel;
 import com.spice.profitmandi.dao.model.WarehouseWiseBrandStockModel;
 import com.spice.profitmandi.dao.model.WarehouseWiseBrandUnbilledActivatedModel;
-import com.spice.profitmandi.dao.model.WarehouseWiseStockModel;
 import com.spice.profitmandi.dao.model.WarehouseWiseitemStockModel;
 import com.spice.profitmandi.dao.repository.auth.AuthRepository;
-import com.spice.profitmandi.dao.repository.auth.MenuCategoryRepository;
-import com.spice.profitmandi.dao.repository.auth.MenuRepository;
 import com.spice.profitmandi.dao.repository.catalog.ItemRepository;
-import com.spice.profitmandi.dao.repository.catalog.OfferMarginRepository;
-import com.spice.profitmandi.dao.repository.catalog.OfferPartnerRepository;
-import com.spice.profitmandi.dao.repository.catalog.OfferRepository;
 import com.spice.profitmandi.dao.repository.catalog.TagListingRepository;
 import com.spice.profitmandi.dao.repository.cs.CsService;
-import com.spice.profitmandi.dao.repository.cs.PartnersPositionRepository;
-import com.spice.profitmandi.dao.repository.cs.PositionRepository;
 import com.spice.profitmandi.dao.repository.cs.TicketAssignedRepository;
-import com.spice.profitmandi.dao.repository.cs.TicketCategoryRepository;
 import com.spice.profitmandi.dao.repository.cs.TicketRepository;
 import com.spice.profitmandi.dao.repository.dtr.DocumentRepository;
 import com.spice.profitmandi.dao.repository.dtr.FofoStoreRepository;
-import com.spice.profitmandi.dao.repository.dtr.LeadRepository;
-import com.spice.profitmandi.dao.repository.dtr.Mongo;
 import com.spice.profitmandi.dao.repository.dtr.NotificationCampaignRepository;
 import com.spice.profitmandi.dao.repository.dtr.UserAccountRepository;
-import com.spice.profitmandi.dao.repository.dtr.UserCampaignRepository;
 import com.spice.profitmandi.dao.repository.fofo.CurrentInventorySnapshotRepository;
 import com.spice.profitmandi.dao.repository.fofo.FofoOrderItemRepository;
 import com.spice.profitmandi.dao.repository.fofo.FofoOrderRepository;
 import com.spice.profitmandi.dao.repository.fofo.HygieneDataRepository;
 import com.spice.profitmandi.dao.repository.fofo.InventoryItemRepository;
-import com.spice.profitmandi.dao.repository.fofo.PartnerDailyInvestmentRepository;
-import com.spice.profitmandi.dao.repository.fofo.PartnerTargetRepository;
-import com.spice.profitmandi.dao.repository.fofo.PartnerTypeChangeRepository;
 import com.spice.profitmandi.dao.repository.fofo.PartnerTypeChangeService;
 import com.spice.profitmandi.dao.repository.fofo.PendingOrderItemRepository;
 import com.spice.profitmandi.dao.repository.fofo.PendingOrderRepository;
 import com.spice.profitmandi.dao.repository.inventory.ReporticoCacheTableRepository;
 import com.spice.profitmandi.dao.repository.inventory.SaholicInventoryCISRepository;
-import com.spice.profitmandi.dao.repository.inventory.SaholicInventorySnapshotRepository;
 import com.spice.profitmandi.dao.repository.transaction.OrderRepository;
 import com.spice.profitmandi.dao.repository.transaction.PriceDropRepository;
+import com.spice.profitmandi.service.AdminUser;
+import com.spice.profitmandi.service.FofoUser;
 import com.spice.profitmandi.service.PartnerInvestmentService;
 import com.spice.profitmandi.service.PartnerStatsService;
 import com.spice.profitmandi.service.authentication.RoleManager;
 import com.spice.profitmandi.service.inventory.InventoryService;
 import com.spice.profitmandi.service.offers.OfferService;
 @Controller
 @Transactional(rollbackOn = Throwable.class)
 public class DashboardController {
-	private static final double ONE_LAC = 1 * 1000 * 100;
-	private static final double TWO_LAC = 2 * 1000 * 100;
-	private static final double FOUR_LAC = 4 * 1000 * 100;
 	List<String> emails = Arrays.asList("kamini.sharma@smartdukaan.com", "neeraj.gupta@smartdukaan.com",
 			"niranjan.kala@smartdukaan.com", "hemant.kaura@smartdukaan.com", "amit.gupta@shop2020.in",
 			"tejbeer.kaur@shop2020.in");
 	@Value("${web.api.host}")
 	@Autowired
 	private PartnerStatsService partnerStatsService;
 	@Autowired
-	private MenuRepository menuRepository;
-	@Autowired
-	private MenuCategoryRepository menuCategoryRepository;
-	@Autowired
 	private CsService csService;
 	@Autowired
-	private PartnerTargetRepository partnerTargetRepository;
-	@Autowired
 	private ResponseSender<?> responseSender;
 	@Autowired
 	RetailerService retailerService;
 	@Autowired
-	private RoleManager roleManager;
+	private AdminUser adminUser;
 	@Autowired
-	private FofoStoreRepository fofoStoreRepository;
+	private RoleManager roleManager;
 	@Autowired
-	private PartnerDailyInvestmentRepository partnerDailyInvestmentRepository;
+	private FofoStoreRepository fofoStoreRepository;
 	@Autowired
 	private PartnerInvestmentService partnerInvestmentService;
 	@Autowired
 	@Autowired
 	private FofoOrderItemRepository fofoOrderItemRepository;
 	@Autowired
-	private TicketCategoryRepository ticketCategoryRepository;
-	@Autowired
 	private PartnerTypeChangeService partnerTypeChangeService;
 	@Autowired
 	private HygieneDataRepository hygieneDataRepository;
 	@Autowired
-	private UserCampaignRepository userCampaignRepository;
-	@Autowired
-	private PositionRepository positionRepository;
-	@Autowired
-	private PartnerTypeChangeRepository partnerTypeChangeRepository;
-	@Autowired
-	private PartnersPositionRepository partnerPositionRepository;
-	@Autowired
 	private UserAccountRepository userAccountRepository;
 	@Autowired
 	private NotificationCampaignRepository notificationCampaignRepository;
 	@Autowired
-	private Mongo mongoClient;
-	@Autowired
 	private AuthRepository authRepository;
 	@Autowired
 	private FofoOrderRepository fofoOrderRepository;
 	@Autowired
 	TicketRepository ticketRepository;
 	@Autowired
-	private LeadRepository leadRepository;
-	@Autowired
-	private OfferRepository offerRepository;
-	@Autowired
-	private OfferPartnerRepository offerPartnerRepository;
-	@Autowired
 	private OfferService offerService;
 	@Autowired
-	private OfferMarginRepository offerMarginRepository;
-	@Autowired
 	private ItemRepository itemRepository;
 	@Autowired
-	private SaholicInventorySnapshotRepository saholicInventorySnapshotRepository;
-	@Autowired
 	private SaholicInventoryCISRepository saholicInventoryCISRepository;
 	@Autowired
 	private MVCResponseSender mvcResponseSender;
 	@Autowired
 	private TicketAssignedRepository ticketAssignedRepository;
 	@Autowired
 	private OrderRepository orderRepository;
+	@Autowired
+	private FofoUser fofoUser;
 	private static final Logger LOGGER = LogManager.getLogger(DashboardController.class);
 	@RequestMapping(value = "/12dashboard34", method = RequestMethod.GET)
 	public String dashboard1(HttpServletRequest request, Model model, @RequestParam int fofoId) throws Exception {
 		boolean isAdmin = false;
 			PartnerType partnerType = partnerTypeChangeService.getTypeOnDate(fofoStore.getId(), LocalDate.now());
 			model.addAttribute("partnerType", partnerType);
 			model.addAttribute("partnerTypeImage", PartnerType.imageMap.get(partnerType));
 			model.addAttribute("fofoStore", customRetailer);
 			model.addAttribute("partnerType", partnerType);
-			model.addAttribute("hasGift", hasGift(fofoId));
+			model.addAttribute("hasGift", fofoUser.hasGift(fofoId));
 			model.addAttribute("giftItemId", ProfitMandiConstants.GIFT_ID);
-			model.addAttribute("brandStockPrices", this.getBrandStockPrices(fofoId));
+			model.addAttribute("brandStockPrices", fofoUser.getBrandStockPrices(fofoId));
-			model.addAttribute("salesMap", this.getSales(fofoId));
+			model.addAttribute("salesMap", fofoUser.getSales(fofoId));
 			model.addAttribute("activatedImeis", inventoryItemRepository.selectCountByActivatedNotSold(fofoId));
 			// this.setInvestments
 			//
 			Map<Integer, String> monthValueMap = new HashMap<>();
 			for (int i = 0; i <= 5; i++) {
 				LocalDateTime startOfMonth = LocalDateTime.now().withDayOfMonth(1).minusMonths(i);
 				monthValueMap.put(i, startOfMonth.format(DateTimeFormatter.ofPattern("MMM''uu")));
+			}
 			LOGGER.info("monthValueMap" + monthValueMap);
 			model.addAttribute("monthValueMap", monthValueMap);
-			model.addAttribute("investments", this.getInvestments(fofoId));
+			model.addAttribute("investments", fofoUser.getInvestments(fofoId));
 			model.addAttribute("isInvestmentOk",
 					partnerInvestmentService.isInvestmentOk(fofoId, 10, ProfitMandiConstants.CUTOFF_INVESTMENT));
 		} catch (ProfitMandiBusinessException e) {
 			LOGGER.error("FofoStore Code not found of fofoId {}", fofoId);
+		}
 		return "12dashboard34";
+	}
-	private Map<String, Object> getInvestments(int fofoId) throws Exception {
-		Map<String, Object> investments = new LinkedHashMap<>();
-		PartnerDailyInvestment investment = partnerInvestmentService.getInvestment(fofoId, 0);
-		LocalDate currentMonthStart = LocalDate.now().withDayOfMonth(1);
-		LocalDate yesterDate = LocalDate.now().minusDays(1);
-		PartnerDailyInvestment yesterdayInvestment = partnerDailyInvestmentRepository.select(fofoId, yesterDate);
-		if (yesterdayInvestment == null) {
-			yesterdayInvestment = new PartnerDailyInvestment();
-		}
-		List<PartnerDailyInvestment> currentMonthInvestments = partnerDailyInvestmentRepository.selectAll(fofoId,
-				currentMonthStart, currentMonthStart.withDayOfMonth(currentMonthStart.lengthOfMonth()));
-		long okInvestmentDays = currentMonthInvestments.stream().filter(x -> x.getShortPercentage() <= 10)
-				.collect(Collectors.counting());
-		investments.put("today", investment.getTotalInvestment());
-		investments.put("investment", investment);
-		investments.put("inStock", investment.getInStockAmount());
-		investments.put("minimum", investment.getMinInvestmentString());
-		investments.put("short", investment.getShortPercentage());
-		investments.put("activated_stock", investment.getActivatedStockAmount());
-		investments.put("okDays", okInvestmentDays);
-		return investments;
-	}
-	private Map<String, Object> getInvestmentsMonths(int fofoId, int month) throws Exception {
-		Map<String, Object> investments = new LinkedHashMap<>();
-		PartnerDailyInvestment investment = partnerInvestmentService.getInvestment(fofoId, 0);
-		LocalDate currentMonthStart = LocalDate.now().withDayOfMonth(1).minusMonths(month);
-		LocalDate yesterDate = LocalDate.now().minusDays(1);
-		PartnerDailyInvestment yesterdayInvestment = partnerDailyInvestmentRepository.select(fofoId, yesterDate);
-		if (yesterdayInvestment == null) {
-			yesterdayInvestment = new PartnerDailyInvestment();
-		}
-		List<PartnerDailyInvestment> currentMonthInvestments = partnerDailyInvestmentRepository.selectAll(fofoId,
-				currentMonthStart, currentMonthStart.withDayOfMonth(currentMonthStart.lengthOfMonth()));
-		long okInvestmentDays = currentMonthInvestments.stream().filter(x -> x.getShortPercentage() <= 10)
-				.collect(Collectors.counting());
-		investments.put("today", investment.getTotalInvestment());
-		investments.put("investment", investment);
-		investments.put("inStock", investment.getInStockAmount());
-		investments.put("minimum", investment.getMinInvestmentString());
-		investments.put("short", investment.getShortPercentage());
-		investments.put("activated_stock", investment.getActivatedStockAmount());
-		investments.put("okDays", okInvestmentDays);
-		return investments;
-	}
-	private Map<String, Object> getSales(int fofoId) {
-		Map<String, Object> salesMap = new LinkedHashMap<>();
-		LocalDateTime now = LocalDateTime.now();
-		LocalDateTime startOfToday = LocalDate.now().atStartOfDay();
-		int monthLength = LocalDate.now().lengthOfMonth();
-		int daysGone = now.getDayOfMonth() - 1;
-		int daysRemaining = monthLength - daysGone;
-		Double todaySale = fofoOrderItemRepository.selectSumMopGroupByRetailer(startOfToday, now, fofoId, false)
-				.get(fofoId);
-		Double mtdSaleTillYesterDay = fofoOrderItemRepository
-				.selectSumMopGroupByRetailer(startOfToday.withDayOfMonth(1), startOfToday, fofoId, false).get(fofoId);
-		Double mtdSale = mtdSaleTillYesterDay + todaySale;
-		Double lmtdSale = fofoOrderItemRepository.selectSumMopGroupByRetailer(
-				startOfToday.withDayOfMonth(1).minusMonths(1), now.minusMonths(1), fofoId, false).get(fofoId);
-		List<PartnerTargetDetails> partnerTargetDetails = partnerTargetRepository
-				.selectAllGeEqAndLeEqStartDateAndEndDate(LocalDateTime.now());
-		if (partnerTargetDetails.isEmpty()) {
-			partnerTargetDetails = partnerTargetRepository
-					.selectAllGeEqAndLeEqStartDateAndEndDate(LocalDateTime.now().minusMonths(3));
-		}
-		PartnerType partnerType = partnerTypeChangeService.getTypeOnDate(fofoId, LocalDate.now());
-		int currentRate = 0;
-		if (mtdSaleTillYesterDay > 0) {
-			currentRate = (int) (mtdSaleTillYesterDay / daysGone);
-		}
-		salesMap.put("requiredType", partnerType.next());
-		float reqdAmount = partnerTypeChangeService.getMinimumAmount(partnerType.next());
-		int requiredRate = (int) ((reqdAmount - mtdSaleTillYesterDay) / daysRemaining);
-		if (partnerType.equals(PartnerType.PLATINUM) && requiredRate < currentRate) {
-			requiredRate = currentRate;
-		}
-		salesMap.put("requiredRate", requiredRate);
-		salesMap.put("requiredTypeImage", PartnerType.imageMap.get(partnerType.next()));
-		salesMap.put("todaySale", todaySale == null ? 0 : todaySale);
-		salesMap.put("mtdSale", mtdSale == null ? 0 : mtdSale);
-		salesMap.put("lmtdSale", lmtdSale == null ? 0 : lmtdSale);
-		PartnerType currentType = partnerTypeChangeService.getPartnerTypeByAmount(currentRate * monthLength);
-		salesMap.put("currentRate", currentRate);
-		salesMap.put("currentType", currentType);
-		salesMap.put("currentTypeImage", PartnerType.imageMap.get(currentType));
-		return salesMap;
-	}
 	@RequestMapping(value = "/getMonthSale", method = RequestMethod.GET)
 	public String getMonthsale(HttpServletRequest request, Model model) throws Exception {
 		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
 		int fofoId = loginDetails.getFofoId();
 		Map<Integer, MonthSaleModel> monthSaleMap = new HashMap<>();
 					.get(fofoId);
 			PartnerType partnerType = partnerTypeChangeService.getTypeOnDate(fofoId, startOfMonth.toLocalDate());
 			MonthSaleModel ms = new MonthSaleModel();
-			ms.setMtdSales(this.format((long) mtdSales));
+			ms.setMtdSales(fofoUser.format((long) mtdSales));
-			ms.setMonthlySales(this.format(((long) monthSales)));
+			ms.setMonthlySales(fofoUser.format(((long) monthSales)));
 			ms.setPartnerType(partnerType);
 			ms.setMonth(startOfMonth.format(DateTimeFormatter.ofPattern("MMM''uu")));
 			monthSaleMap.put(i, ms);
+		}
 		model.addAttribute("monthSales", monthSaleMap);
 		return "monthSales";
+	}
-	private String format(long value) {
-		String finalval = null;
-		if (value >= 100000 && value < 10000000) {
-			long reminder = value / 100000;
-			long quitonent = value % 100000;
-			finalval = reminder + "." + quitonent;
-			String secondval = String.valueOf(quitonent);
-			if (secondval.length() >= 2) {
-				secondval = secondval.substring(0, 2);
-				finalval = reminder + "." + secondval;
-			}
-			return String.valueOf(finalval) + " Lacs";
-		} else if (value >= 1000 && value < 100000) {
-			long reminder = value / 1000;
-			long quitonent = value % 1000;
-			finalval = reminder + "." + quitonent;
-			String secondval = String.valueOf(quitonent);
-			if (secondval.length() >= 2) {
-				secondval = secondval.substring(0, 2);
-				finalval = reminder + "." + secondval;
-			}
-			return String.valueOf(finalval) + " K";
-		} else if (value >= 10000000 && value < 1000000000) {
-			long reminder = value / 10000000;
-			long quitonent = value % 10000000;
-			finalval = reminder + "." + quitonent;
-			String secondval = String.valueOf(quitonent);
-			if (secondval.length() >= 2) {
-				secondval = secondval.substring(0, 2);
-				finalval = reminder + "." + secondval;
-			}
-			return String.valueOf(finalval) + " Cr";
-		}
-		return String.valueOf(finalval);
-	}
-	private List<BrandStockPrice> getBrandStockPrices(int fofoId) throws Exception {
-		Map<String, BrandStockPrice> brandStockPricesMap = inventoryService.getBrandWiseStockValue(fofoId);
-		List<DBObject> mobileBrands = mongoClient.getAllBrandsToDisplay(3);
-		List<BrandStockPrice> brandStockPrices = new ArrayList<>();
-		mobileBrands.stream().forEach(x -> {
-			String brand = (String) x.get("name");
-			if (brandStockPricesMap.containsKey(brand)) {
-				BrandStockPrice brandStockPrice = brandStockPricesMap.get(brand);
-				brandStockPrice.setBrandUrl((String) x.get("url"));
-				brandStockPrice.setRank(((Double) x.get("rank")).intValue());
-				brandStockPrices.add(brandStockPrice);
-			}
-		});
-		return brandStockPrices.stream().filter(x -> x.getTotalQty() > 0).sorted((x, y) -> x.getRank() - y.getRank())
-				.collect(Collectors.toList());
-	}
 	@RequestMapping(value = "/dashboard", method = RequestMethod.GET)
 	public String dashboard(HttpServletRequest request, Model model) throws Exception {
 		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
 		String email = loginDetails.getEmailId();
 		int fofoId = loginDetails.getFofoId();
 		model.addAttribute("webApiHost", webApiHost);
 		model.addAttribute("webApiPort", webApiPort);
 		model.addAttribute("webApiScheme", webApiScheme);
 		model.addAttribute("webApiRoot", webApiRoot);
 		if (isAdmin) {
-			return adminPanel(loginDetails.getFofoId(), email, model);
+			return adminUser.adminPanel(loginDetails.getFofoId(), email, model);
 		} else {
 			FofoStore fofoStore = null;
 			try {
 				fofoStore = fofoStoreRepository.selectByRetailerId(loginDetails.getFofoId());
 				if (!fofoStore.isActive()) {
 				PartnerType partnerType = partnerTypeChangeService.getTypeOnDate(fofoStore.getId(), LocalDate.now());
 				model.addAttribute("partnerType", partnerType);
 				model.addAttribute("partnerTypeImage", PartnerType.imageMap.get(partnerType));
 				model.addAttribute("fofoStore", fofoStore);
 				model.addAttribute("partnerType", partnerType);
-				model.addAttribute("hasGift", hasGift(loginDetails.getFofoId()));
+				model.addAttribute("hasGift", fofoUser.hasGift(loginDetails.getFofoId()));
 				model.addAttribute("giftItemId", ProfitMandiConstants.GIFT_ID);
 				model.addAttribute("retailers", new JSONObject().append("code", fofoStore.getCode())
 						.append("partnerId", fofoStore.getId()).toString());
 				model.addAttribute("activatedImeis",
 						inventoryItemRepository.selectCountByActivatedNotSold(loginDetails.getFofoId()));
 						.selectSumStockGroupByFofoIdsForMobileOrAccessories(loginDetails.getFofoId(),
 								Optional.of(false))
 						.get(loginDetails.getFofoId());
 				model.addAttribute("accesoriesStock", String.format("%.0f", accesoriesStock));
-				model.addAttribute("brandStockPrices", this.getBrandStockPrices(loginDetails.getFofoId()));
+				model.addAttribute("brandStockPrices", fofoUser.getBrandStockPrices(loginDetails.getFofoId()));
-				model.addAttribute("salesMap", this.getSales(loginDetails.getFofoId()));
+				model.addAttribute("salesMap", fofoUser.getSales(loginDetails.getFofoId()));
-				ChartModel cm = this.getBrandChart(loginDetails.getFofoId());
+				ChartModel cm = fofoUser.getBrandChart(loginDetails.getFofoId());
 				LOGGER.info("chartMap" + gson.toJson(cm));
 				model.addAttribute("chartMap", gson.toJson(cm));
 				List<CreateOfferRequest> publishedOffers = offerService.getPublishedOffers(loginDetails.getFofoId(),
 						YearMonth.from(LocalDateTime.now()));
 				model.addAttribute("publishedOffers", publishedOffers);
-				model.addAttribute("investments", this.getInvestments(loginDetails.getFofoId()));
+				model.addAttribute("investments", fofoUser.getInvestments(loginDetails.getFofoId()));
 				model.addAttribute("isInvestmentOk", partnerInvestmentService.isInvestmentOk(loginDetails.getFofoId(),
 , ProfitMandiConstants.CUTOFF_INVESTMENT));
 			} catch (ProfitMandiBusinessException e) {
 				LOGGER.error("FofoStore Code not found of fofoId {}", loginDetails.getFofoId());
 	public String getMonthsInvestment(HttpServletRequest request,
 			@RequestParam(name = "month", required = true, defaultValue = "0") int month, Model model)
 			throws Exception {
 		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
 		int fofoId = loginDetails.getFofoId();
-		Map<String, Object> investment = getInvestmentsMonths(fofoId, month);
+		Map<String, Object> investment = fofoUser.getInvestmentsMonths(fofoId, month);
 		LocalDateTime currentMonthStart = LocalDateTime.now().withDayOfMonth(1);
 		LocalDateTime lastMonthStart = currentMonthStart.minusMonths(1);
 		LocalDateTime currentMonthEnd = currentMonthStart.plusMonths(1).withDayOfMonth(1);
 		double currentMonthRating = hygieneDataRepository.selectRatingAvg(loginDetails.getFofoId(), currentMonthStart,
 	@RequestMapping(value = "/investmentDetails", method = RequestMethod.GET)
 	public String getInvestmentDetails(HttpServletRequest request, Model model) throws Exception {
 		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
 		int fofoId = loginDetails.getFofoId();
-		ChartInvestmentModel cm = this.getInvestmentChart(fofoId);
+		ChartInvestmentModel cm = fofoUser.getInvestmentChart(fofoId);
 		model.addAttribute("chartPieMap", gson.toJson(cm));
 		LOGGER.info("InvestmentChart" + gson.toJson(cm));
 		LOGGER.info("InvestmentChart" + cm);
 		return "investmentdetails";
 	@RequestMapping(value = "/getlmsLineChart", method = RequestMethod.GET)
 	public String getlmsLineChart(HttpServletRequest request, Model model) throws Exception {
 		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
 		int fofoId = loginDetails.getFofoId();
-		ChartModel cm = this.getLmsLineChart(loginDetails.getFofoId());
+		ChartModel cm = fofoUser.getLmsLineChart(loginDetails.getFofoId());
 		LOGGER.info("linechartMap" + gson.toJson(cm));
 		model.addAttribute("linechartMap", gson.toJson(cm));
 		return "lmsLineChart";
+	}
 	@RequestMapping(value = "/getMonthlyPurchaseLineChart", method = RequestMethod.GET)
 	public String getMonthlyPurchaseLineChart(HttpServletRequest request, Model model) throws Exception {
 		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
 		int fofoId = loginDetails.getFofoId();
-		ChartModel cm = this.getPurchaseOrderChart(fofoId);
+		ChartModel cm = fofoUser.getPurchaseOrderChart(fofoId);
 		LOGGER.info("chartMap" + gson.toJson(cm));
 		model.addAttribute("chartMap", gson.toJson(cm));
 		return "purchase_chart";
 	@RequestMapping(value = "/getBarChart", method = RequestMethod.GET)
 	public String getBarChart(HttpServletRequest request, Model model) throws Exception {
 		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
 		int fofoId = loginDetails.getFofoId();
-		ChartModel cm = this.getBrandChart(fofoId);
+		ChartModel cm = fofoUser.getBrandChart(fofoId);
 		LOGGER.info("chartMap" + gson.toJson(cm));
 		model.addAttribute("chartMap", gson.toJson(cm));
 		return "bar_chart";
+	}
-	@RequestMapping(value = "/getMonthlyPriceDropTab", method = RequestMethod.GET)
-	public String getMonthlyPriceDrop(HttpServletRequest request, Model model) throws Exception {
-		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
-		int fofoId = loginDetails.getFofoId();
-		ChartModel cm = this.getMonthlyPriceDrop(fofoId);
-		LOGGER.info("chartMap" + gson.toJson(cm));
-		model.addAttribute("chartMap", gson.toJson(cm));
-		return "price_drop_chart";
-	}
 	@RequestMapping(value = "/getPriceDropDetails", method = RequestMethod.GET)
 	public String getPriceDropDetails(HttpServletRequest request,
 			@RequestParam(name = "fofoId", required = true, defaultValue = "0") int fofoId,
 			@RequestParam(name = "brand", required = true, defaultValue = "0") String brand,
 			@RequestParam(name = "yearMonth", required = true, defaultValue = "0") String yearMonth, Model model)
 			throws Exception {
-		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
 		LOGGER.info("params" + fofoId + brand + yearMonth);
 		List<PriceDropWithDetailsByYearMonthModel> priceDropdetailsList = priceDropRepository
 				.selectBrandPendingPriceDropWithDetailsByYearMonth(fofoId, brand, yearMonth);
 		model.addAttribute("sortedBrandValue", brandValues);
 		return "price-drop-tabular";
+	}
-	private ChartModel getMonthlyPriceDrop(int fofoId) throws ProfitMandiBusinessException {
-		LocalDateTime curDate = LocalDate.now().atStartOfDay();
-		LocalDateTime startOfMonth = curDate.withDayOfMonth(1).minusMonths(6);
-		List<PriceDropYearMonthModel> priceDropYearMonthModels = priceDropRepository
-				.selectBrandPendingPriceDropByYearMonth(fofoId, startOfMonth);
-		DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("MM-yyyy");
-		Map<YearMonth, Map<String, Double>> monthBrandValue = new HashMap<>();
-		LOGGER.info("priceDropYearMonthModels" + priceDropYearMonthModels);
-		for (PriceDropYearMonthModel priceDropYearMonthModel : priceDropYearMonthModels) {
-			Map<String, Double> brandValue = new HashMap<>();
-			brandValue.put(priceDropYearMonthModel.getBrand(), (double) priceDropYearMonthModel.getAmount());
-			monthBrandValue.put(YearMonth.parse(priceDropYearMonthModel.getYearMonth(), dateTimeFormatter), brandValue);
-		}
-		Map<YearMonth, Map<String, Double>> sortedMonthBrandValue = new TreeMap<>(monthBrandValue);
-		LOGGER.info("sortedMonthBrandValue" + sortedMonthBrandValue);
-		List<String> brands = new ArrayList<>();
-		brands.add("Accessories");
-		brands.add("Oppo");
-		brands.add("Vivo");
-		brands.add("Samsung");
-		brands.add("Realme");
-		brands.add("Xiaomi");
-		brands.add("Tecno");
-		brands.add("Itel");
-		brands.add("Nokia");
-		for (int i = 6; i >= 1; i--) {
-			LocalDateTime startMonth = curDate.withDayOfMonth(1).minusMonths(i);
-			LOGGER.info("getStartMonth" + sortedMonthBrandValue.get(YearMonth.from(startMonth)));
-			Map<String, Double> valbrand = sortedMonthBrandValue.get(YearMonth.from(startMonth));
-			for (String brand : brands) {
-				if (valbrand != null) {
-					if (!valbrand.containsKey(brand)) {
-						valbrand.put(brand, 0.0);
-					} else {
-						valbrand.put(brand, valbrand.get(brand));
-					}
-				} else {
-					valbrand = new HashMap<String, Double>();
-					valbrand.put(brand, 0.0);
-				}
-			}
-			sortedMonthBrandValue.put(YearMonth.from(curDate.withDayOfMonth(1).minusMonths(i)), valbrand);
-		}
-		Multimap<String, Map<YearMonth, Double>> brandMonthValueMap = ArrayListMultimap.create();
-		for (Entry<YearMonth, Map<String, Double>> month : sortedMonthBrandValue.entrySet()) {
-			for (Entry<String, Double> val : month.getValue().entrySet()) {
-				Map<YearMonth, Double> yearValue = new HashMap<>();
-				yearValue.put(month.getKey(), val.getValue() == null ? 0 : val.getValue());
-				brandMonthValueMap.put(val.getKey(), yearValue);
-			}
-		}
-		Map<String, List<Double>> sortedBrandValue = new LinkedHashMap<>();
-		for (String brand : brands) {
-			Collection<Map<YearMonth, Double>> coll = brandMonthValueMap.get(brand);
-			List<Double> valueList = new ArrayList<>();
-			for (Map<YearMonth, Double> col : coll) {
-				valueList.addAll(col.values());
-			}
-			sortedBrandValue.put(brand, valueList);
-		}
-		LinkedHashSet<String> labels = new LinkedHashSet<String>();
-		for (int i = 6; i >= 1; i--) {
-			LocalDateTime startMonth = curDate.withDayOfMonth(1).minusMonths(i);
-			labels.add(startMonth.format(DateTimeFormatter.ofPattern("MMM''uu")).toString());
-		}
-		List<DatasetModel> datasets = new ArrayList<>();
-		List<String> colorList = new ArrayList<>();
-		colorList.add("papayawhip");
-		colorList.add("darkgreen");
-		colorList.add("dodgerblue");
-		colorList.add("darkblue");
-		colorList.add("gold");
-		colorList.add("coral");
-		colorList.add("steelblue");
-		colorList.add("red");
-		colorList.add("midnightblue");
-		colorList.add("cornsilk");
-		List<String> borderList = new ArrayList<>();
-		borderList.add("pink");
-		borderList.add("mediumseagreen");
-		borderList.add("lightblue");
-		borderList.add("#0000cd");
-		borderList.add("#f7e98e");
-		borderList.add("#ff8c69");
-		borderList.add("#0000cd");
-		borderList.add("lightsalmon");
-		borderList.add("#0000cd");
-		borderList.add("cornsilk");
-		int i = 0;
-		for (Entry<String, List<Double>> brandValue : sortedBrandValue.entrySet()) {
-			DatasetModel purchaseModel = new DatasetModel();
-			purchaseModel.setLabel(brandValue.getKey());
-			purchaseModel.setBackgroundColor(colorList.get(i));
-			if (brandValue.getValue().isEmpty()) {
-				purchaseModel.setData(Arrays.asList(0.0, 0.0, 0.0, 0.0, 0.0, 0.0));
-			} else {
-				purchaseModel.setData(brandValue.getValue());
-			}
-			purchaseModel.setType("line");
-			purchaseModel.setOrder(1);
-			purchaseModel.setFill("false");
-			purchaseModel.setBorderColor(borderList.get(i));
-			datasets.add(purchaseModel);
-			i++;
-		}
-		DataModel dm = new DataModel();
-		dm.setDatasets(datasets);
-		dm.setLabels(labels);
-		LegendModel lm = new LegendModel();
-		lm.setPosition("top");
-		Tooltips tooltips = new Tooltips();
-		tooltips.setBodyFontSize(15);
-		tooltips.setTitleFontSize(15);
-		tooltips.setMode("index");
-		tooltips.setIntersect(false);
-		tooltips.setBackgroundColor("rgba(0, 0, 0, .5)");
-		HoverModel hover = new HoverModel();
-		hover.setIntersect(false);
-		hover.setMode("index");
-		TitleModel tm = new TitleModel();
-		tm.setText("Brand Wise Monthly Price-Drop");
-		tm.setDisplay(true);
-		tm.setFontSize(20);
-		tm.setFontColor("#111");
-		OptionsModel om = new OptionsModel();
-		om.setResponsive(true);
-		om.setLegend(lm);
-		om.setTitle(tm);
-		om.setTooltips(tooltips);
-		om.setHover(hover);
-		ChartModel cm = new ChartModel();
-		cm.setType("line");
-		cm.setData(dm);
-		cm.setOptions(om);
-		LOGGER.info("cm" + cm);
-		return cm;
-	}
-	private ChartInvestmentModel getInvestmentChart(int fofoId) throws ProfitMandiBusinessException {
-		PartnerDailyInvestment investment = partnerInvestmentService.getInvestment(fofoId, 0);
-		Map<String, Float> investmentWalletAmount = new HashMap<>();
-		investmentWalletAmount.put("Wallet", investment.getWalletAmount());
-		investmentWalletAmount.put("InStocks", investment.getInStockAmount() - investment.getActivatedStockAmount());
-		investmentWalletAmount.put("Unbilled Order", investment.getUnbilledAmount());
-		investmentWalletAmount.put("GrnPending", investment.getGrnPendingAmount());
-		investmentWalletAmount.put("ReturnInTransit", investment.getReturnInTransitAmount());
-		if (investment.getShortInvestment() > 0) {
-			investmentWalletAmount.put("Short Investment", investment.getShortInvestment());
-		}
-		ChartInvestmentModel cm = new ChartInvestmentModel();
-		HashSet<String> labels = new HashSet<String>();
-		labels.addAll(investmentWalletAmount.keySet());
-		List<String> labelList = new ArrayList<>(labels);
-		List<String> backgroundColor = new ArrayList<>();
-		List<Float> labelsValue = new ArrayList<>();
-		List<Float> values = new ArrayList<>();
-		for (String label : labelList) {
-			values.add(investmentWalletAmount.get(label));
-			if (label.equals("Wallet")) {
-				backgroundColor.add("pink");
-			}
-			if (label.equals("Short Investment")) {
-				backgroundColor.add("red");
-			}
-			if (label.equals("InStocks")) {
-				backgroundColor.add("#9ACD32");
-			}
-			if (label.equals("Unbilled Order")) {
-				backgroundColor.add("blue");
-			}
-			if (label.equals("ReturnInTransit")) {
-				backgroundColor.add("orange");
-			}
-			if (label.equals("GrnPending")) {
-				backgroundColor.add("yellow");
-			}
-		}
-		Data data = new Data();
-		data.setData(values);
-		data.setBackgroundColor(backgroundColor);
-		data.setLabel("DataSet 1");
-		PieLables label = new PieLables();
-		label.setFontColor("White");
-		label.setFontSize(15);
-		Legend legend = new Legend();
-		legend.setLabels(label);
-		legend.setPosition("left");
-		List<Data> dataList = new ArrayList<>();
-		dataList.add(data);
-		DataInvestmentModel datasets = new DataInvestmentModel();
-		datasets.setDatasets(dataList);
-		datasets.setLabels(labels);
-		OptionModel om = new OptionModel();
-		om.setLegend(legend);
-		cm.setType("pie");
-		cm.setData(datasets);
-		cm.setOptions(om);
-		return cm;
-	}
-	private ChartModel getPurchaseOrderChart(int fofoId) throws ProfitMandiBusinessException {
-		LocalDateTime curDate = LocalDate.now().atStartOfDay();
-		LocalDateTime startOfMonth = curDate.withDayOfMonth(1).minusMonths(1);
-		List<SecondaryOrderBilledLmsModel> soblms = orderRepository.selectAllBilledOrderGroupByBrandFofoId(fofoId,
-				curDate.withDayOfMonth(1).minusMonths(6));
-		LOGGER.info("soblms" + soblms);
-		Map<String, Map<YearMonth, Double>> brandMonthValueMap = new HashMap<>();
-		for (SecondaryOrderBilledLmsModel orderBilledLmsMode : soblms) {
-			Map<YearMonth, Double> yearMonthMap = new HashMap<>();
-			yearMonthMap.put(YearMonth.from(startOfMonth), (double) orderBilledLmsMode.getFirstMonthValue());
-			yearMonthMap.put(YearMonth.from(startOfMonth.minusMonths(1)),
-					(double) orderBilledLmsMode.getSecondMonthValue());
-			yearMonthMap.put(YearMonth.from(startOfMonth.minusMonths(2)),
-					(double) orderBilledLmsMode.getThirdMonthValue());
-			yearMonthMap.put(YearMonth.from(startOfMonth.minusMonths(3)),
-					(double) orderBilledLmsMode.getFourthMonthValue());
-			yearMonthMap.put(YearMonth.from(startOfMonth.minusMonths(4)),
-					(double) orderBilledLmsMode.getFifthMonthValue());
-			yearMonthMap.put(YearMonth.from(startOfMonth.minusMonths(5)),
-					(double) orderBilledLmsMode.getSixthMonthValue());
-			Map<YearMonth, Double> sortedYearMonthMap = new TreeMap<YearMonth, Double>(yearMonthMap);
-			brandMonthValueMap.put(orderBilledLmsMode.getBrand(), sortedYearMonthMap);
-		}
-		LOGGER.info("brandMonthValueMap" + brandMonthValueMap);
-		List<String> brands = new ArrayList<>();
-		brands.add("Accessories");
-		brands.add("Oppo");
-		brands.add("Vivo");
-		brands.add("Samsung");
-		brands.add("Realme");
-		brands.add("Xiaomi");
-		brands.add("Tecno");
-		brands.add("Itel");
-		brands.add("Lava");
-		brands.add("Nokia");
-		Map<String, List<Double>> sortedBrandValue = new LinkedHashMap<>();
-		for (String brand : brands) {
-			Map<YearMonth, Double> coll = brandMonthValueMap.get(brand);
-			LOGGER.info("coll" + coll);
-			List<Double> valueList = new ArrayList<>();
-			if (coll != null) {
-				valueList.addAll(coll.values());
-			}
-			sortedBrandValue.put(brand, valueList);
-		}
-		LinkedHashSet<String> labels = new LinkedHashSet<String>();
-		for (int i = 6; i >= 1; i--) {
-			LocalDateTime startMonth = curDate.withDayOfMonth(1).minusMonths(i);
-			labels.add(startMonth.format(DateTimeFormatter.ofPattern("MMM''uu")).toString());
-			LOGGER.info("labels" + labels);
-		}
-		LOGGER.info("labels" + labels);
-		LOGGER.info("sortedBrandValue" + sortedBrandValue);
-		List<DatasetModel> datasets = new ArrayList<>();
-		List<String> colorList = new ArrayList<>();
-		colorList.add("papayawhip");
-		colorList.add("darkgreen");
-		colorList.add("dodgerblue");
-		colorList.add("darkblue");
-		colorList.add("gold");
-		colorList.add("coral");
-		colorList.add("steelblue");
-		colorList.add("red");
-		colorList.add("deeppink");
-		colorList.add("midnightblue");
-		colorList.add("cornsilk");
-		List<String> borderList = new ArrayList<>();
-		borderList.add("pink");
-		borderList.add("mediumseagreen");
-		borderList.add("lightblue");
-		borderList.add("#0000cd");
-		borderList.add("#f7e98e");
-		borderList.add("#ff8c69");
-		borderList.add("#0000cd");
-		borderList.add("lightsalmon");
-		borderList.add("pink");
-		borderList.add("#0000cd");
-		borderList.add("cornsilk");
-		int i = 0;
-		for (Entry<String, List<Double>> brandValue : sortedBrandValue.entrySet()) {
-			DatasetModel purchaseModel = new DatasetModel();
-			purchaseModel.setLabel(brandValue.getKey());
-			purchaseModel.setBackgroundColor(colorList.get(i));
-			if (brandValue.getValue().isEmpty()) {
-				purchaseModel.setData(Arrays.asList(0.0, 0.0, 0.0, 0.0, 0.0, 0.0));
-			} else {
-				purchaseModel.setData(brandValue.getValue());
-			}
-			purchaseModel.setType("line");
-			purchaseModel.setOrder(1);
-			purchaseModel.setFill("false");
-			purchaseModel.setBorderColor(borderList.get(i));
-			datasets.add(purchaseModel);
-			i++;
-		}
-		DataModel dm = new DataModel();
-		dm.setDatasets(datasets);
-		dm.setLabels(labels);
-		LegendModel lm = new LegendModel();
-		lm.setPosition("top");
-		Tooltips tooltips = new Tooltips();
-		tooltips.setBodyFontSize(15);
-		tooltips.setTitleFontSize(15);
-		tooltips.setMode("index");
-		tooltips.setIntersect(false);
-		tooltips.setBackgroundColor("rgba(0, 0, 0, .5)");
-		HoverModel hover = new HoverModel();
-		hover.setIntersect(false);
-		hover.setMode("index");
-		TitleModel tm = new TitleModel();
-		tm.setText("Brand Wise Monthly Purchase");
-		tm.setDisplay(true);
-		tm.setFontSize(20);
-		tm.setFontColor("#111");
-		OptionsModel om = new OptionsModel();
-		om.setResponsive(true);
-		om.setLegend(lm);
-		om.setTitle(tm);
-		om.setTooltips(tooltips);
-		om.setHover(hover);
-		ChartModel cm = new ChartModel();
-		cm.setType("line");
-		cm.setData(dm);
-		cm.setOptions(om);
-		LOGGER.info("cm" + cm);
-		return cm;
-	}
-	private ChartModel getLmsLineChart(int fofoId) throws ProfitMandiBusinessException {
-		LocalDateTime curDate = LocalDate.now().atStartOfDay();
-		Map<YearMonth, Map<String, Double>> monthValueMap = new HashMap<>();
-		for (int i = 1; i <= 6; i++) {
-			LocalDateTime startOfMonth = curDate.withDayOfMonth(1).minusMonths(i);
-			Map<String, Double> lmsBrandWiseSale = fofoOrderItemRepository.selectSumAmountGroupByBrand(
-					curDate.withDayOfMonth(1).minusMonths(i), curDate.withDayOfMonth(1).minusMonths(i - 1), fofoId);
-			Map<Integer, Double> accesorieslmsSale = fofoOrderRepository
-					.selectSumSaleGroupByFofoIdsForMobileOrAccessories(fofoId, curDate.withDayOfMonth(1).minusMonths(i),
-							curDate.withDayOfMonth(1).minusMonths(i - 1), Optional.of(false));
-			LOGGER.info("lmsBrandWiseSale" + lmsBrandWiseSale);
-			lmsBrandWiseSale.put("Accessories", accesorieslmsSale.get(fofoId));
-			monthValueMap.put(YearMonth.from(startOfMonth), lmsBrandWiseSale);
-		}
-		LOGGER.info("monthmap" + monthValueMap);
-		Map<YearMonth, Map<String, Double>> sortedMonthValueMap = new TreeMap(monthValueMap);
-		LOGGER.info("monthmap" + sortedMonthValueMap);
-		Multimap<String, Map<YearMonth, Double>> brandMonthValueMap = ArrayListMultimap.create();
-		for (Entry<YearMonth, Map<String, Double>> month : sortedMonthValueMap.entrySet()) {
-			for (Entry<String, Double> val : month.getValue().entrySet()) {
-				Map<YearMonth, Double> yearValue = new HashMap<>();
-				yearValue.put(month.getKey(), val.getValue() == null ? 0 : val.getValue());
-				brandMonthValueMap.put(val.getKey(), yearValue);
-			}
-		}
-		LOGGER.info("map" + brandMonthValueMap);
-		List<String> brands = new ArrayList<>();
-		brands.add("Accessories");
-		brands.add("Oppo");
-		brands.add("Vivo");
-		brands.add("Samsung");
-		brands.add("Realme");
-		brands.add("Xiaomi");
-		brands.add("Tecno");
-		brands.add("Itel");
-		brands.add("Lava");
-		brands.add("Nokia");
-		Map<String, List<Double>> sortedBrandValue = new LinkedHashMap<>();
-		for (String brand : brands) {
-			Collection<Map<YearMonth, Double>> coll = brandMonthValueMap.get(brand);
-			LOGGER.info("coll" + coll);
-			List<Double> valueList = new ArrayList<>();
-			for (Map<YearMonth, Double> col : coll) {
-				valueList.addAll(col.values());
-			}
-			sortedBrandValue.put(brand, valueList);
-		}
-		LOGGER.info("sortedBrandValue" + sortedBrandValue);
-		LinkedHashSet<String> labels = new LinkedHashSet<String>();
-		for (Entry<YearMonth, Map<String, Double>> val : sortedMonthValueMap.entrySet()) {
-			labels.add(val.getKey().format(DateTimeFormatter.ofPattern("MMM''uu")).toString());
-		}
-		List<String> labelList = new ArrayList<>(labels);
-		List<Double> lmsValues = new ArrayList<>();
-		List<DatasetModel> datasets = new ArrayList<>();
-		List<String> colorList = new ArrayList<>();
-		colorList.add("papayawhip");
-		colorList.add("mediumseagreen");
-		colorList.add("dodgerblue");
-		colorList.add("darkblue");
-		colorList.add("gold");
-		colorList.add("coral");
-		colorList.add("steelblue");
-		colorList.add("red");
-		colorList.add("deeppink");
-		colorList.add("midnightblue");
-		colorList.add("cornsilk");
-		List<String> borderList = new ArrayList<>();
-		borderList.add("pink");
-		borderList.add("lawngreen");
-		borderList.add("lightblue");
-		borderList.add("#0000cd");
-		borderList.add("#f7e98e");
-		borderList.add("lightcoral");
-		borderList.add("#0000cd");
-		borderList.add("lightsalmon");
-		borderList.add("pink");
-		borderList.add("#0000cd");
-		borderList.add("cornsilk");
-		int i = 0;
-		for (Entry<String, List<Double>> brandValue : sortedBrandValue.entrySet()) {
-			DatasetModel lineLmsChart = new DatasetModel();
-			lineLmsChart.setLabel(brandValue.getKey());
-			lineLmsChart.setBackgroundColor(colorList.get(i));
-			if (brandValue.getValue().isEmpty()) {
-				lineLmsChart.setData(Arrays.asList(0.0, 0.0, 0.0, 0.0, 0.0, 0.0));
-			} else {
-				lineLmsChart.setData(brandValue.getValue());
-			}
-			lineLmsChart.setType("line");
-			lineLmsChart.setOrder(1);
-			lineLmsChart.setFill("false");
-			lineLmsChart.setBorderColor(borderList.get(i));
-			datasets.add(lineLmsChart);
-			i++;
-		}
-		DataModel dm = new DataModel();
-		dm.setDatasets(datasets);
-		dm.setLabels(labels);
-		LegendModel lm = new LegendModel();
-		lm.setPosition("top");
-		Tooltips tooltips = new Tooltips();
-		tooltips.setBodyFontSize(15);
-		tooltips.setTitleFontSize(15);
-		tooltips.setMode("index");
-		tooltips.setIntersect(false);
-		tooltips.setBackgroundColor("rgba(0, 0, 0, .5)");
-		HoverModel hover = new HoverModel();
-		hover.setIntersect(false);
-		hover.setMode("index");
-		TitleModel tm = new TitleModel();
-		tm.setText("Brand Wise LMS");
-		tm.setDisplay(true);
-		tm.setFontSize(20);
-		tm.setFontColor("#111");
-		OptionsModel om = new OptionsModel();
-		om.setResponsive(true);
-		om.setLegend(lm);
-		om.setTitle(tm);
-		om.setTooltips(tooltips);
-		om.setHover(hover);
-		ChartModel cm = new ChartModel();
-		cm.setType("line");
-		cm.setData(dm);
-		cm.setOptions(om);
-		LOGGER.info("cm" + cm);
-		return cm;
-	}
-	private ChartModel getBrandChart(int fofoId) {
-		LocalDateTime curDate = LocalDate.now().atStartOfDay();
-		LOGGER.info("cur Date" + curDate.withDayOfMonth(1));
-		LOGGER.info("curDateYear" + curDate.with(LocalTime.MAX));
-		Map<String, Double> brandwisesale = fofoOrderItemRepository
-				.selectSumAmountGroupByBrand(curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), fofoId);
-		LOGGER.info("brandwisesale" + brandwisesale);
-		Map<Integer, Double> accesoriesmtdsale = fofoOrderRepository.selectSumSaleGroupByFofoIdsForMobileOrAccessories(
-				fofoId, curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), Optional.of(false));
-		brandwisesale.put("Accessories", accesoriesmtdsale.get(fofoId));
-		Map<String, Double> activatedImeisWithSellingPriceMTD = fofoOrderRepository
-				.selectValueOfActivatedImeis(curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), fofoId).stream()
-				.collect(Collectors.toMap(x -> x.getBrand(), x -> (double) x.getSellingPrice()));
-		activatedImeisWithSellingPriceMTD.put("Lava", brandwisesale.get("Lava"));
-		Map<String, Double> activatedImeisWithSellingPriceLMTD = fofoOrderRepository
-				.selectValueOfActivatedImeis(curDate.withDayOfMonth(1).minusMonths(1),
-						curDate.with(LocalTime.MAX).minusMonths(1), fofoId)
-				.stream().collect(Collectors.toMap(x -> x.getBrand(), x -> (double) x.getSellingPrice()));
-		Map<String, Double> lmtdBrandWiseSale = fofoOrderItemRepository.selectSumAmountGroupByBrand(
-				curDate.withDayOfMonth(1).minusMonths(1), curDate.with(LocalTime.MAX).minusMonths(1), fofoId);
-		activatedImeisWithSellingPriceLMTD.put("Lava", lmtdBrandWiseSale.get("Lava"));
-		Map<Integer, Double> accesorieslmtdsale = fofoOrderRepository.selectSumSaleGroupByFofoIdsForMobileOrAccessories(
-				fofoId, curDate.withDayOfMonth(1).minusMonths(1), curDate.with(LocalTime.MAX).minusMonths(1),
-				Optional.of(false));
-		lmtdBrandWiseSale.put("Accessories", accesorieslmtdsale.get(fofoId));
-		ChartModel cm = new ChartModel();
-		HashSet<String> labels = new HashSet<String>();
-		labels.addAll(brandwisesale.keySet());
-		labels.addAll(lmtdBrandWiseSale.keySet());
-		List<String> labelList = new ArrayList<>(labels);
-		List<Double> mtdActivatedImeisValues = new ArrayList<>();
-		List<Double> mtdValues = new ArrayList<>();
-		List<Double> lmtdUnActivatedImeisValues = new ArrayList<>();
-		List<Double> lmtdActivatedImeisValues = new ArrayList<>();
-		List<Double> mtdUnActivatedImeisValues = new ArrayList<>();
-		List<Double> lmtdValues = new ArrayList<>();
-		for (String label : labelList) {
-			mtdActivatedImeisValues.add(activatedImeisWithSellingPriceMTD.get(label) == null ? 0
-					: activatedImeisWithSellingPriceMTD.get(label));
-			lmtdActivatedImeisValues.add(activatedImeisWithSellingPriceLMTD.get(label) == null ? 0
-					: activatedImeisWithSellingPriceLMTD.get(label));
-			mtdValues.add(brandwisesale.get(label) == null ? 0 : brandwisesale.get(label));
-			if (brandwisesale.get(label) != null) {
-				mtdUnActivatedImeisValues
-						.add(brandwisesale.get(label) - (activatedImeisWithSellingPriceMTD.get(label) == null ? 0
-								: activatedImeisWithSellingPriceMTD.get(label)));
-			} else {
-				mtdUnActivatedImeisValues.add(0.0);
-			}
-			if (lmtdBrandWiseSale.get(label) != null) {
-				lmtdUnActivatedImeisValues
-						.add(lmtdBrandWiseSale.get(label) - (activatedImeisWithSellingPriceLMTD.get(label) == null ? 0
-								: activatedImeisWithSellingPriceLMTD.get(label)));
-			} else {
-				lmtdUnActivatedImeisValues.add(0.0);
-			}
-			lmtdValues.add(lmtdBrandWiseSale.get(label) == null ? 0 : lmtdBrandWiseSale.get(label));
-		}
-		DatasetModel dsmtotal = new DatasetModel();
-		dsmtotal.setLabel("MTD");
-		dsmtotal.setBackgroundColor("blue");
-		dsmtotal.setBorderColor("blue");
-		dsmtotal.setData(mtdValues);
-		dsmtotal.setStack("stack0");
-		dsmtotal.setOrder(1);
-		DatasetModel dsmUnactivated = new DatasetModel();
-		dsmUnactivated.setLabel("MTD Unactivated");
-		dsmUnactivated.setBackgroundColor("red");
-		dsmUnactivated.setBorderColor("red");
-		dsmUnactivated.setData(mtdUnActivatedImeisValues);
-		dsmUnactivated.setStack("stack0");
-		dsmUnactivated.setOrder(1);
-		LOGGER.info("mtdValuesMoney" + mtdValues);
-		DatasetModel mtdActivatedImeis = new DatasetModel();
-		mtdActivatedImeis.setLabel("MTD Activation");
-		mtdActivatedImeis.setBorderColor("#00008b");
-		mtdActivatedImeis.setData(mtdActivatedImeisValues);
-		mtdActivatedImeis.setBackgroundColor("#00008b");
-		mtdActivatedImeis.setStack("stack0");
-		mtdActivatedImeis.setOrder(1);
-		DatasetModel lmtddsmtotal = new DatasetModel();
-		lmtddsmtotal.setLabel("LMTD");
-		lmtddsmtotal.setBackgroundColor("blue");
-		lmtddsmtotal.setData(lmtdValues);
-		lmtddsmtotal.setBorderColor("blue");
-		lmtddsmtotal.setStack("stack1");
-		lmtddsmtotal.setOrder(1);
-		DatasetModel lmtdUnActivated = new DatasetModel();
-		lmtdUnActivated.setLabel("LMTD Unactivation");
-		lmtdUnActivated.setBackgroundColor("red");
-		lmtdUnActivated.setBorderColor("red");
-		lmtdUnActivated.setData(lmtdUnActivatedImeisValues);
-		lmtdUnActivated.setStack("stack1");
-		lmtdUnActivated.setOrder(1);
-		DatasetModel LmtdActivatedImeis = new DatasetModel();
-		LmtdActivatedImeis.setLabel("LMTD Activation");
-		LmtdActivatedImeis.setBackgroundColor("#87ceeb");
-		LmtdActivatedImeis.setBorderColor("#87ceeb");
-		LmtdActivatedImeis.setData(lmtdActivatedImeisValues);
-		LmtdActivatedImeis.setStack("stack1");
-		LmtdActivatedImeis.setOrder(1);
-		DatasetModel linemtdChart = new DatasetModel();
-		linemtdChart.setLabel("MTD");
-		linemtdChart.setBackgroundColor("#006400");
-		linemtdChart.setBorderColor("#006400");
-		linemtdChart.setData(mtdValues);
-		linemtdChart.setType("line");
-		linemtdChart.setOrder(2);
-		linemtdChart.setFill("false");
-		DatasetModel lineLmtdChart = new DatasetModel();
-		lineLmtdChart.setLabel("LMTD");
-		lineLmtdChart.setBackgroundColor("hotpink");
-		lineLmtdChart.setBorderColor("hotpink");
-		lineLmtdChart.setData(lmtdValues);
-		lineLmtdChart.setType("line");
-		lineLmtdChart.setOrder(3);
-		lineLmtdChart.setFill("false");
-		List<DatasetModel> datasets = new ArrayList<>();
-		datasets.add(mtdActivatedImeis);
-		datasets.add(dsmUnactivated);
-		datasets.add(LmtdActivatedImeis);
-		datasets.add(lmtdUnActivated);
-		datasets.add(linemtdChart);
-		datasets.add(lineLmtdChart);
-		DataModel dm = new DataModel();
-		dm.setDatasets(datasets);
-		dm.setLabels(labels);
-		Tooltips tooltips = new Tooltips();
-		tooltips.setBodyFontSize(10);
-		tooltips.setTitleFontSize(10);
-		tooltips.setMode("index");
-		tooltips.setIntersect(false);
-		tooltips.setBackgroundColor("rgba(0, 0, 0, .5)");
-		HoverModel hover = new HoverModel();
-		hover.setIntersect(false);
-		hover.setMode("index");
-		LegendModel lm = new LegendModel();
-		lm.setPosition("top");
-		TitleModel tm = new TitleModel();
-		tm.setText("Brand Wise Sales");
-		tm.setDisplay(true);
-		tm.setFontSize(20);
-		tm.setFontColor("#111");
-		List<Axis> xAxes = new ArrayList<>();
-		Axis xAxis = new Axis();
-		xAxis.setStacked(true);
-		xAxes.add(xAxis);
-		List<Axis> yAxes = new ArrayList<>();
-		Axis yAxis = new Axis();
-		yAxis.setStacked(false);
-		yAxes.add(yAxis);
-		ScalesModel sm = new ScalesModel();
-		sm.setxAxes(xAxes);
-		OptionsModel om = new OptionsModel();
-		om.setLegend(lm);
-		om.setTitle(tm);
-		om.setScales(sm);
-		om.setHover(hover);
-		om.setTooltips(tooltips);
-		cm.setType("bar");
-		cm.setData(dm);
-		cm.setOptions(om);
-		LOGGER.info("cm" + cm);
-		return cm;
-	}
-	private String adminPanel(int fofoId, String email, Model model) throws Exception {
-		List<Menu> menus = null;
-		try {
-			AuthUser authUser = authRepository.selectByEmailOrMobile(email);
-			List<Position> positions = positionRepository.selectAll(authUser.getId());
-			Map<Integer, PartnerDetailModel> warehousePartnerDetailMap = null;
-			ReporticoCacheTable rctSaholic = null;
-			ReporticoCacheTable rctPartneStat = null;
-			Map<Integer, WarehouseWiseStockModel> warehouseStockMap = new HashMap<>();
-			LinkedHashMap<Integer, WarehouseWiseStockModel> warehouseStockSortedMap = new LinkedHashMap<>();
-			Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
-			LinkedHashMap<Integer, String> wm = new LinkedHashMap<Integer, String>();
-			Map<AuthUser, Long> authUserTicketCount = null;
-			for (Map.Entry<Integer, String> entry : warehouseMap.entrySet()) {
-				wm.put(entry.getKey(), entry.getValue());
-			}
-			wm.put(0, "Total Values");
-			long stockValue = 0;
-			long stockQty = 0;
-			long pendingIndent = 0;
-			long tertiary = 0;
-			Map<String, Set<Integer>> storeGuyMap = csService.getAuthUserPartnerIdMapping();
-			Set<Integer> fofoIds = storeGuyMap.get(authUser.getEmailId());
-			if (emails.contains(authUser.getEmailId())) {
-				fofoIds = storeGuyMap.get("tarun.verma@smartdukaan.com");
-				LOGGER.info("fofoIds" + fofoIds);
-			}
-			if (fofoIds == null) {
-				List<Position> positions1 = positionRepository.selectAll(authUser.getId());
-				if (positions1.stream().filter(x -> x.getCategoryId() == ProfitMandiConstants.TICKET_CATEGORY_MASTER)
-						.count() > 0) {
-					fofoIds = csService.getPositionCustomRetailerMap(positions1).values().stream()
-							.flatMap(x -> x.stream()).map(x -> x.getPartnerId()).collect(Collectors.toSet());
-				}
-			}
-			if (fofoIds != null && fofoIds.size() > 0) {
-				Map<Integer, List<Integer>> warehouseIdFofoIdMap = fofoStoreRepository
-						.selectActivePartnersByRetailerIds(new ArrayList<>(fofoIds)).stream()
-						.collect(Collectors.groupingBy(FofoStore::getWarehouseId,
-								Collectors.mapping(FofoStore::getId, Collectors.toList())));
-				// warehouseStock
-				List<WarehouseWiseStockModel> warehouseStocks = saholicInventoryCISRepository
-						.selectGroupByWarehouse(new ArrayList<>(warehouseIdFofoIdMap.keySet()));
-				warehouseStockMap = warehouseStocks.stream().collect(Collectors.toMap(x -> x.getWarehouseId(), x -> x));
-				if (!warehouseStockMap.isEmpty()) {
-					for (Entry<Integer, WarehouseWiseStockModel> warehouseStock : warehouseStockMap.entrySet()) {
-						stockValue += warehouseStock.getValue().getStockValue();
-						stockQty += warehouseStock.getValue().getStockQty();
-						pendingIndent += warehouseStock.getValue().getPendingIndent();
-						tertiary += warehouseStock.getValue().getTertiary();
-					}
-					WarehouseWiseStockModel ws = new WarehouseWiseStockModel();
-					ws.setStockQty(stockQty);
-					ws.setStockValue(stockValue);
-					ws.setPendingIndent(pendingIndent);
-					ws.setTertiary(tertiary);
-					ws.setWarehouseId(0);
-					warehouseStockMap.put(0, ws);
-				}
-				warehouseStockMap.entrySet().stream().sorted(Map.Entry.comparingByKey(Comparator.reverseOrder()))
-						.forEachOrdered(x -> warehouseStockSortedMap.put(x.getKey(), x.getValue()));
-				rctSaholic = reporticoCacheTableRepository.selectByTableName("SaholicInventoryCIS");
-				// warehouseStock
-				warehousePartnerDetailMap = this.getWarehousePartnerDetail(warehouseIdFofoIdMap);
-				rctPartneStat = reporticoCacheTableRepository.selectByTableName("partnerStat");
-				Set<CustomRetailer> positionRetailers = fofoIds.stream()
-						.map(x -> retailerService.getAllFofoRetailers().get(x)).filter(x -> x != null)
-						.collect(Collectors.toSet());
-				model.addAttribute("retailers", gson.toJson(positionRetailers));
-				model.addAttribute("reporticoProjectMap", ReporticoProject.salesReporticoProjectMap);
-				model.addAttribute("warehouses", getWarehouses(positionRetailers));
-			} else {
-				List<Position> warehousePositions = positions.stream()
-						.filter(x -> x.getCategoryId() == ProfitMandiConstants.TICKET_CATEGORY_WAREHOUSE)
-						.collect(Collectors.toList());
-				if (warehousePositions.size() > 0) {
-					Set<CustomRetailer> positionRetailers = new HashSet<>();
-					csService.getPositionCustomRetailerMap(warehousePositions).values().forEach(customRetailers -> {
-						positionRetailers.addAll(customRetailers);
-					});
-					model.addAttribute("reporticoProjectMap", ReporticoProject.warehouseReporticoMap);
-					model.addAttribute("retailers", gson.toJson(positionRetailers));
-					model.addAttribute("warehouses", getWarehouses(positionRetailers));
-				}
-			}
-			if (positions.size() > 0) {
-				if (positions.stream()
-						.filter(x -> x.getEscalationType().equals(EscalationType.L3)
-								|| x.getEscalationType().equals(EscalationType.L4)
-								|| x.getEscalationType().equals(EscalationType.L5))
-						.count() > 0) {
-					authUserTicketCount = ticketRepository.selectAllAuthUserTicketCount(Optional.of(false));
-				}
-			}
-			if (Arrays.asList("amit.gupta@shop2020.in", "tejbeer.kaur@shop2020.in", "manish.tiwari@smartdukaan.com")
-					.contains(email)) {
-				menus = menuRepository.selectAll();
-			} else if (positions.size() > 0) {
-				if (positions.stream().filter(x -> x.getEscalationType().equals(EscalationType.L5)).count() > 0) {
-					menus = menuRepository.selectAll();
-				} else {
-					List<Integer> menuIds = menuCategoryRepository.selectAllByPositions(positions).stream()
-							.map(x -> x.getMenuId()).collect(Collectors.toList());
-					if (menuIds.size() > 0) {
-						menus = menuRepository.selectAllByIds(menuIds);
-					}
-				}
-			}
-			model.addAttribute("authId", authUser.getId());
-			model.addAttribute("rctPartneStat", rctPartneStat);
-			model.addAttribute("reporticoDate", rctSaholic);
-			model.addAttribute("warehousePartnerDetailMap", warehousePartnerDetailMap);
-			model.addAttribute("warehouseMap", wm);
-			model.addAttribute("authUserTicketCount", authUserTicketCount);
-			model.addAttribute("warehouseStockMap", warehouseStockSortedMap);
-			LocalDateTime curDate = LocalDate.now().atStartOfDay();
-			model.addAttribute("date", curDate.withDayOfMonth(1).minusMonths(6).toLocalDate());
-		} catch (ProfitMandiBusinessException e) {
-		}
-		List<Menu> menuList = (menus != null) ? this.prepareMenu(menus) : new ArrayList<>();
-		LOGGER.info("menu" + menuList);
-		model.addAttribute("menu", menuList);
-		return "admin";
-	}
 	@RequestMapping(value = "/getAuthUserPartners", method = RequestMethod.GET)
 	public String AuthUserPartnersDetail(HttpServletRequest request, Model model, @RequestParam int authId)
 			throws Exception {
 		Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
 		Map<Integer, List<Integer>> warehouseIdFofoIdMap = fofoStoreRepository
 				.selectActivePartnersByRetailerIds(new ArrayList<>(authfofoIds)).stream().collect(Collectors.groupingBy(
 						FofoStore::getWarehouseId, Collectors.mapping(FofoStore::getId, Collectors.toList())));
 		Map<Integer, CustomRetailer> fofoIdAndPartnerMap = retailerService.getFofoRetailers(false);
-		Map<Integer, PartnerDetailModel> fofoIdAndallValues = this.getPartnersStatDataFromFile();
+		Map<Integer, PartnerDetailModel> fofoIdAndallValues = adminUser.getPartnersStatDataFromFile();
 		if (warehouseId != 0) {
 			List<Integer> fofoIds = warehouseIdFofoIdMap.get(warehouseId);
 			/*
 			 * List<Integer> fofoIds =
 			 * fofoStoreRepository.selectActivePartnerByWarehouse(warehouseId).stream()
 		inventoryService.getItemAvailabilityAndIndent();
 		model.addAttribute("response", mvcResponseSender.createResponseString(true));
 		return "response";
+	}
-	public Map<Integer, PartnerDetailModel> getWarehousePartnerDetail(Map<Integer, List<Integer>> warehousePartnerMap)
-			throws Exception {
-		Map<Integer, PartnerDetailModel> warehouseIdAndallValues = new LinkedHashMap<>();
-		// Map<Integer, List<FofoStore>> warehousePartnerMap =
-		// fofoStoreRepository.getWarehousePartnerMap();
-		Map<Integer, PartnerDetailModel> partnerStats = this.getPartnersStatDataFromFile();
-		List<Integer> allfofoIds = new ArrayList<>();
-		if (partnerStats != null) {
-			for (Entry<Integer, List<Integer>> warehouse : warehousePartnerMap.entrySet()) {
-				List<Integer> fofoIds = warehouse.getValue().stream().map(x -> x).collect(Collectors.toList());
-				allfofoIds.addAll(fofoIds);
-				List<PartnerDetailModel> partnerDetails = fofoIds.stream().map(x -> partnerStats.get(x))
-						.collect(Collectors.toList());
-				if (partnerDetails != null && !partnerDetails.isEmpty()) {
-					PartnerDetailModel partnerDetailModel = partnerStatsService.getAggregateStats(partnerDetails);
-					warehouseIdAndallValues.put(warehouse.getKey(), partnerDetailModel);
-				}
-			}
-			List<PartnerDetailModel> allPartnerDetails = allfofoIds.stream().map(x -> partnerStats.get(x))
-					.collect(Collectors.toList());
-			LOGGER.info("allPartnerDetails" + allPartnerDetails);
-			PartnerDetailModel partnerDetailModel = partnerStatsService
-					.getAggregateStats(new ArrayList<>(allPartnerDetails));
-			warehouseIdAndallValues.put(0, partnerDetailModel);
-		}
-		return warehouseIdAndallValues;
-	}
 	@RequestMapping(value = "/getPartnersStatData", method = RequestMethod.GET)
 	public String getPartnersStatData(HttpServletRequest request, Model model) throws Exception {
 		Map<Integer, PartnerDetailModel> partnerStats = partnerStatsService.getAllPartnerStats();
 		ObjectOutputStream oos = null;
 		FileOutputStream fout = null;
 		reporticoCacheTableRepository.persist(rct);
 		model.addAttribute("response", mvcResponseSender.createResponseString(true));
 		return "response";
+	}
-	public Map<Integer, PartnerDetailModel> getPartnersStatDataFromFile() throws Exception {
-		ObjectInputStream objectinputstream = null;
-		Map<Integer, PartnerDetailModel> partnerStat = null;
-		try {
-			FileInputStream streamIn = new FileInputStream("/tmp/partnerStat.tmp");
-			objectinputstream = new ObjectInputStream(streamIn);
-			partnerStat = (Map<Integer, PartnerDetailModel>) objectinputstream.readObject();
-			LOGGER.info("partnerStat" + partnerStat);
-			objectinputstream.close();
-		} catch (Exception e) {
-			LOGGER.info("exceptionddd" + e);
-			e.printStackTrace();
-		} finally {
-			if (objectinputstream != null) {
-				objectinputstream.close();
-				LOGGER.info("clofddd" + partnerStat);
-			}
-		}
-		return partnerStat;
-	}
 	@RequestMapping(value = "/getWarehouseWiseBrandAndCategory", method = RequestMethod.GET)
 	public String getWarehouseWiseBrandAndCategory(HttpServletRequest request, Model model,
 			@RequestParam List<Integer> warehouseId, @RequestParam List<String> brands, @RequestParam String category)
 			throws Exception {
 		model.addAttribute("warehouseWiseItemStock", warehouseWiseItemStock);
 		model.addAttribute("warehouseMap", warehouseMap);
 		return "warehouse_item_details";
+	}
-	private String getWarehouses(Set<CustomRetailer> positionRetailers) {
-		Map<Integer, String> warehouses = new HashMap<>();
-		positionRetailers.stream().forEach(x -> {
-			if (x.getWarehouseId() != 0) {
-				warehouses.put(x.getWarehouseId(), ProfitMandiConstants.WAREHOUSE_MAP.get(x.getWarehouseId()));
-			}
-		});
-		return gson.toJson(warehouses);
-	}
 	@RequestMapping(value = "/getWarehouseWiseBrandPartnerSale", method = RequestMethod.GET)
 	public String getWarehouseWiseBrandPartnerSale(HttpServletRequest request, Model model, @RequestParam String brand)
 			throws Exception {
 		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
 		model.addAttribute("branditemSales", branditemSales);
 		model.addAttribute("warehouseMap", warehouseMap);
 		return "warehouse_accessories_itemwsie_sale";
+	}
-	private List<Menu> prepareMenu(List<Menu> menus) {
-		List<Menu> returnMenu = new ArrayList<>();
-		Map<Menu, List<Menu>> subMenuMap = new HashMap<Menu, List<Menu>>();
-		for (Menu menu : menus) {
-			if (menu.get_parent() == null) {
-				if (!subMenuMap.containsKey(menu)) {
-					subMenuMap.put(menu, new ArrayList<>());
-				}
-			} else {
-				Menu parentMenu = menu.get_parent();
-				if (!subMenuMap.containsKey(parentMenu)) {
-					subMenuMap.put(parentMenu, new ArrayList<>());
-				}
-				subMenuMap.get(parentMenu).add(menu);
-			}
-		}
-		subMenuMap.entrySet().stream().forEach(entry -> {
-			entry.getKey().setSubMenus(entry.getValue());
-			returnMenu.add(entry.getKey());
-		});
-		return returnMenu;
-	}
-	// This method is currently hardcoded to faciliate watches sold as gift.
-	private boolean hasGift(int fofoId) {
-		try {
-			return currentInventorySnapshotRepository.selectByItemIdAndFofoId(ProfitMandiConstants.GIFT_ID, fofoId)
-					.getAvailability() > 0;
-		} catch (ProfitMandiBusinessException e) {
-			return false;
-		}
-	}
 	@RequestMapping(value = "/contactUs", method = RequestMethod.GET)
 	public String contactUs(HttpServletRequest request, Model model) throws Throwable {
 		model.addAttribute("appContextPath", request.getContextPath());
 		return "contact-us";
+	}
 		List<Notification> notifications = null;
 		List<NotificationCampaign> notificationCampaigns = notificationCampaignRepository.getNotifications(messageType,
 				userId, offset, limit);
 		LOGGER.info("messageType" + messageType);
-		notifications = getNotifications(notificationCampaigns, messageType);
+		notifications = fofoUser.getNotifications(notificationCampaigns, messageType);
 		model.addAttribute("notifications", notifications);
 		LOGGER.info("notifications" + notifications);
 		return "notification-template";
+	}
-	public List<Notification> getNotifications(List<NotificationCampaign> nc, MessageType messageType)
-			throws ProfitMandiBusinessException {
-		List<Notification> notifications = new ArrayList<>();
-		Document document = null;
-		if (messageType != null) {
-			for (NotificationCampaign notificationCampaign : nc) {
-				if (notificationCampaign.getMessageType() == messageType) {
-					Notification ns = new Notification();
-					SimpleCampaignParams scp = gson.fromJson(notificationCampaign.getImplementationParams(),
-							SimpleCampaignParams.class);
-					Campaign campaign = new SimpleCampaign(scp);
-					LocalDateTime expire = campaign.getExpireTimestamp();
-					ns.setCid(Integer.toString(notificationCampaign.getId()));
-					ns.setType(campaign.getType());
-					ns.setMessage(campaign.getMessage());
-					ns.setTitle(campaign.getTitle());
-					if (notificationCampaign.getDocumentId() != null) {
-						document = documentRepository.selectById(notificationCampaign.getDocumentId());
-						ns.setDocumentName(document.getDisplayName());
-					}
-					ns.setUrl(campaign.getUrl());
-					ns.setShowImage(campaign.getShowImage());
-					ns.setImageUrl(campaign.getImageUrl());
-					ns.setDocumentId(notificationCampaign.getDocumentId());
-					ns.setMessageType(notificationCampaign.getMessageType());
-					ns.setCreated(
-							notificationCampaign.getCreatedTimestamp().toEpochSecond(ZoneOffset.ofHoursMinutes(5, 30))
-									* 1000);
-					if (LocalDateTime.now().isAfter(expire)) {
-						ns.setExpired(true);
-					} else {
-						ns.setExpired(false);
-					}
-					notifications.add(ns);
-				}
-			}
-		} else {
-			for (NotificationCampaign notificationCampaign : nc) {
-				Notification ns = new Notification();
-				SimpleCampaignParams scp = gson.fromJson(notificationCampaign.getImplementationParams(),
-						SimpleCampaignParams.class);
-				Campaign campaign = new SimpleCampaign(scp);
-				LocalDateTime expire = campaign.getExpireTimestamp();
-				ns.setCid(Integer.toString(notificationCampaign.getId()));
-				ns.setType(campaign.getType());
-				ns.setMessage(campaign.getMessage());
-				ns.setTitle(campaign.getTitle());
-				if (notificationCampaign.getDocumentId() != null) {
-					document = documentRepository.selectById(notificationCampaign.getDocumentId());
-					ns.setDocumentName(document.getDisplayName());
-				}
-				ns.setUrl(campaign.getUrl());
-				ns.setShowImage(campaign.getShowImage());
-				ns.setImageUrl(campaign.getImageUrl());
-				ns.setDocumentId(notificationCampaign.getDocumentId());
-				ns.setMessageType(notificationCampaign.getMessageType());
-				ns.setCreated(notificationCampaign.getCreatedTimestamp().toEpochSecond(ZoneOffset.ofHoursMinutes(5, 30))
-						* 1000);
-				if (LocalDateTime.now().isAfter(expire)) {
-					ns.setExpired(true);
-				} else {
-					ns.setExpired(false);
-				}
-				notifications.add(ns);
-			}
-		}
-		return notifications;
-	}
 	@RequestMapping(value = "/notifyDocument/documentId", method = RequestMethod.GET)
 	public ResponseEntity<?> retailerDocumentById(HttpServletRequest request,
 			@RequestParam(name = ProfitMandiConstants.DOCUMENT_ID) int documentId, @RequestParam int cid)
 			throws ProfitMandiBusinessException {
 		Document document = documentRepository.selectById(documentId);
 		headers.setContentLength(document.getSize());
 		final InputStreamResource inputStreamResource = new InputStreamResource(file);
 		return new ResponseEntity<InputStreamResource>(inputStreamResource, headers, HttpStatus.OK);
+	}
-	public Map<Integer, PartnerDetailModel> getL2AuthUserPartnerDetail() throws Exception {
-		LOGGER.info("getL2AuthUserPartnerDetail Started");
-		Map<Integer, List<Integer>> L2L1Mapping = csService.getL2L1Mapping();
-		Map<Integer, Integer> authIdAndleadsCountMap = new HashMap<>();
-		for (Entry<Integer, List<Integer>> l2l1 : L2L1Mapping.entrySet()) {
-			List<Integer> authIds = l2l1.getValue();
-			authIds.add(l2l1.getKey());
-			List<Lead> leads = leadRepository.selectByAssignAuthIdsAndStatus(authIds, LeadStatus.followUp);
-			LOGGER.info("authIdAndleadsCountMap" + authIdAndleadsCountMap);
-			AuthUser auth = authRepository.selectById(l2l1.getKey());
-			if (!leads.isEmpty()) {
-				authIdAndleadsCountMap.put(auth.getId(), leads.size());
-			} else {
-				authIdAndleadsCountMap.put(auth.getId(), 0);
-			}
-		}
-		Map<Integer, PartnerDetailModel> partnerStats = partnerStatsService.getAllPartnerStats();
-		List<Integer> unmappedPartners = partnerStats.entrySet().stream().map(x -> x.getKey())
-				.collect(Collectors.toList());
-		LOGGER.info("authIdAndleadsCountMap" + authIdAndleadsCountMap);
-		Map<Integer, PartnerDetailModel> authIdAndallValues = new LinkedHashMap<>();
-		Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
-		for (int authUserId : pp.keySet()) {
-			if (L2L1Mapping.keySet().contains(authUserId)) {
-				List<Integer> fofoIds = pp.get(authUserId);
-				unmappedPartners.removeAll(fofoIds);
-				List<PartnerDetailModel> partnerDetails = fofoIds.stream().map(x -> partnerStats.get(x))
-						.collect(Collectors.toList());
-				LOGGER.info("authUserId {}, partnerDetails2 {}" + authUserId, partnerDetails);
-				PartnerDetailModel partnerDetailModel = partnerStatsService.getAggregateStats(partnerDetails);
-				authIdAndallValues.put(authUserId, partnerDetailModel);
-			}
-		}
-		List<PartnerDetailModel> unmappedPartnerDetails = unmappedPartners.stream().map(x -> partnerStats.get(x))
-				.collect(Collectors.toList());
-		PartnerDetailModel partnerDetailModel = partnerStatsService
-				.getAggregateStats(new ArrayList<>(partnerStats.values()));
-		authIdAndallValues.put(-1, partnerStatsService.getAggregateStats(unmappedPartnerDetails));
-		authIdAndallValues.put(0, partnerDetailModel);
-		return authIdAndallValues;
-	}
 	@RequestMapping(value = "/getItemWiseTertiary", method = RequestMethod.GET)
 	public String getItemWiseTertiary(HttpServletRequest request,
 			@RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model)
 			throws ProfitMandiBusinessException {
 		List<ItemWiseTertiaryModel> itemWiseTertiary = fofoOrderRepository.SelectItemWiseTertiary(fofoId);
+	}
 	@RequestMapping(value = "/getPartnerInvestment", method = RequestMethod.GET)
 	public String getPartnerInvestment(HttpServletRequest request,
 			@RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
-		Map<Integer, PartnerDetailModel> partnerStats = this.getPartnersStatDataFromFile();
+		Map<Integer, PartnerDetailModel> partnerStats = adminUser.getPartnersStatDataFromFile();
 		PartnerDetailModel partnerDetailModel = partnerStats.get(fofoId);
 		CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
 		model.addAttribute("partnerDetailModel", partnerDetailModel);
 		model.addAttribute("customRetailer", customRetailer);
 		return "partner-investment";
 				.selectActivePartnersByRetailerIds(new ArrayList<>(fofoIds)).stream().collect(Collectors.groupingBy(
 						FofoStore::getWarehouseId, Collectors.mapping(FofoStore::getId, Collectors.toList())));
 		ChartModel cm;
 		if (warehouseId != 0) {
-			cm = this.getBrandWiseLms(Arrays.asList(warehouseId),
+			cm = adminUser.getBrandWiseLms(Arrays.asList(warehouseId),
 					fofoIds.stream().map(x -> x).collect(Collectors.toList()), date);
 		} else {
-			cm = this.getBrandWiseLms(new ArrayList<>(warehouseIdFofoIdMap.keySet()),
+			cm = adminUser.getBrandWiseLms(new ArrayList<>(warehouseIdFofoIdMap.keySet()),
 					fofoIds.stream().map(x -> x).collect(Collectors.toList()), date);
+		}
 		LOGGER.info("chartMap" + gson.toJson(cm));
 			@RequestParam(required = false, defaultValue = "0") int warehouseId,
 			@RequestParam(required = false) LocalDate date, Model model) throws Exception {
 		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
 		String email = loginDetails.getEmailId();
-		Map<String, Object> map = this.getFilter(warehouseId, email, date);
+		Map<String, Object> map = adminUser.getFilter(warehouseId, email, date);
 		model.addAttribute("warehouseId", warehouseId);
 		model.addAllAttributes(map);
 		return "chart-filter-lms";
+	}
 			@RequestParam(required = false, defaultValue = "0") int warehouseId,
 			@RequestParam(required = false) LocalDate date, Model model) throws Exception {
 		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
 		String email = loginDetails.getEmailId();
-		Map<String, Object> map = this.getFilter(warehouseId, email, date);
+		Map<String, Object> map = adminUser.getFilter(warehouseId, email, date);
 		model.addAttribute("warehouseId", warehouseId);
 		model.addAllAttributes(map);
 		return "chart-filter-lmp";
+	}
 				.selectActivePartnersByRetailerIds(new ArrayList<>(fofoIds)).stream().collect(Collectors.groupingBy(
 						FofoStore::getWarehouseId, Collectors.mapping(FofoStore::getId, Collectors.toList())));
 		ChartModel cm;
 		if (warehouseId != 0) {
-			cm = this.getBrandWiseLmp(Arrays.asList(warehouseId),
+			cm = adminUser.getBrandWiseLmp(Arrays.asList(warehouseId),
 					fofoIds.stream().map(x -> x).collect(Collectors.toList()), date);
 		} else {
-			cm = this.getBrandWiseLmp(new ArrayList<>(warehouseIdFofoIdMap.keySet()),
+			cm = adminUser.getBrandWiseLmp(new ArrayList<>(warehouseIdFofoIdMap.keySet()),
 					fofoIds.stream().map(x -> x).collect(Collectors.toList()), date);
+		}
 		LOGGER.info("chartMap" + gson.toJson(cm));
 		model.addAttribute("chartMap", gson.toJson(cm));
 		return "brand-wise-mobile-lmp-chart";
+	}
-	public Map<String, Object> getFilter(int warehouseId, String email, LocalDate date)
-			throws ProfitMandiBusinessException {
-		Map<String, Object> map = new HashMap<>();
-		Map<Integer, CustomRetailer> customRetailersMap = null;
-		Map<String, Set<Integer>> storeGuyMap = csService.getAuthUserPartnerIdMapping();
-		AuthUser authUser = authRepository.selectByEmailOrMobile(email);
-		Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
-		Set<Integer> fofoIds = null;
-		fofoIds = storeGuyMap.get(authUser.getEmailId());
-		if (emails.contains(authUser.getEmailId())) {
-			fofoIds = storeGuyMap.get("tarun.verma@smartdukaan.com");
-		}
-		if (warehouseId != 0) {
-			fofoIds = fofoStoreRepository.selectPartnerByfofoIdAndWarehouse(new ArrayList<>(fofoIds), warehouseId)
-					.stream().map(x -> x).collect(Collectors.toSet());
-		}
-		if (date == null) {
-			LocalDateTime curDate = LocalDate.now().atStartOfDay();
-			LocalDateTime startOfMonth = curDate.withDayOfMonth(1).minusMonths(6);
-			date = startOfMonth.toLocalDate();
-		}
-		if (fofoIds != null) {
-			customRetailersMap = retailerService
-					.getFofoRetailers(fofoIds.stream().map(x -> x).collect(Collectors.toList()));
-		}
-		map.put("date", date);
-		map.put("customRetailersMap", customRetailersMap);
-		map.put("fofoIds", fofoIds);
-		map.put("warehouseMap", warehouseMap);
-		return map;
-	}
-	private ChartModel getBrandWiseLms(List<Integer> warehouseIds, List<Integer> fofoIds, LocalDate startDateTime) {
-		LOGGER.info("params" + warehouseIds + fofoIds + startDateTime);
-		List<BrandWiseModel> brandWiseLms = fofoStoreRepository.selectGroupByBrandLms(fofoIds, warehouseIds,
-				startDateTime);
-		LOGGER.info("brandWiseLms" + brandWiseLms);
-		DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("MM-yyyy");
-		Map<String, Map<YearMonth, Double>> brandMonthValue = new HashMap<>();
-		for (BrandWiseModel bwl : brandWiseLms) {
-			Map<YearMonth, Double> brandValue = new HashMap<>();
-			if (brandMonthValue.containsKey(bwl.getBrand())) {
-				brandValue = brandMonthValue.get(bwl.getBrand());
-				brandValue.put(YearMonth.parse(bwl.getYearMonth(), dateTimeFormatter), (double) bwl.getAmount());
-			} else {
-				brandValue.put(YearMonth.parse(bwl.getYearMonth(), dateTimeFormatter), (double) bwl.getAmount());
-			}
-			brandMonthValue.put(bwl.getBrand(), brandValue);
-		}
-		LocalDateTime curDate = LocalDate.now().atStartOfDay();
-		Period age = Period.between(startDateTime, LocalDate.now());
-		int months = age.getMonths();
-		LOGGER.info("months" + months);
-		LOGGER.info("brandWiseLms" + brandWiseLms);
-		LOGGER.info("brandMonthValue" + brandMonthValue);
-		List<String> brands = new ArrayList<>();
-		brands.add("Oppo");
-		brands.add("Vivo");
-		brands.add("Samsung");
-		brands.add("Realme");
-		brands.add("Xiaomi");
-		brands.add("Tecno");
-		brands.add("Itel");
-		brands.add("Lava");
-		brands.add("Nokia");
-		Map<String, List<Double>> sortedBrandValue = new LinkedHashMap<>();
-		for (String brand : brands) {
-			Map<YearMonth, Double> yearMonthValue = brandMonthValue.get(brand);
-			for (int i = months; i >= 0; i--) {
-				LocalDateTime startMonth = curDate.withDayOfMonth(1).minusMonths(i);
-				if (yearMonthValue != null) {
-					if (yearMonthValue.get(YearMonth.from(startMonth)) == null) {
-						yearMonthValue.put(YearMonth.from(startMonth), 0.0);
-					}
-				} else {
-					yearMonthValue = new HashMap<>();
-					yearMonthValue.put(YearMonth.from(startMonth), 0.0);
-				}
-			}
-			Map<YearMonth, Double> sortedMonthBrandValue = new TreeMap<>(yearMonthValue);
-			brandMonthValue.put(brand, sortedMonthBrandValue);
-			sortedBrandValue.put(brand, sortedMonthBrandValue.values().stream().collect(Collectors.toList()));
-		}
-		LOGGER.info("brandMonthValue" + brandMonthValue);
-		LOGGER.info("sortedBrandValue" + sortedBrandValue);
-		LinkedHashSet<String> labels = new LinkedHashSet<String>();
-		for (int i = months; i >= 0; i--) {
-			LocalDateTime startMonth = curDate.withDayOfMonth(1).minusMonths(i);
-			labels.add(startMonth.format(DateTimeFormatter.ofPattern("MMM''uu")).toString());
-		}
-		List<DatasetModel> datasets = new ArrayList<>();
-		List<String> colorList = new ArrayList<>();
-		colorList.add("darkgreen");
-		colorList.add("dodgerblue");
-		colorList.add("darkblue");
-		colorList.add("gold");
-		colorList.add("coral");
-		colorList.add("steelblue");
-		colorList.add("red");
-		colorList.add("midnightblue");
-		colorList.add("cornsilk");
-		List<String> borderList = new ArrayList<>();
-		borderList.add("mediumseagreen");
-		borderList.add("lightblue");
-		borderList.add("#0000cd");
-		borderList.add("#f7e98e");
-		borderList.add("#ff8c69");
-		borderList.add("#0000cd");
-		borderList.add("lightsalmon");
-		borderList.add("#0000cd");
-		borderList.add("cornsilk");
-		int i = 0;
-		for (Entry<String, List<Double>> brandValue : sortedBrandValue.entrySet()) {
-			DatasetModel lmsModel = new DatasetModel();
-			lmsModel.setLabel(brandValue.getKey());
-			lmsModel.setBackgroundColor(colorList.get(i));
-			lmsModel.setData(brandValue.getValue());
-			lmsModel.setType("line");
-			lmsModel.setOrder(1);
-			lmsModel.setFill("false");
-			lmsModel.setBorderColor(borderList.get(i));
-			datasets.add(lmsModel);
-			i++;
-		}
-		DataModel dm = new DataModel();
-		dm.setDatasets(datasets);
-		dm.setLabels(labels);
-		LegendModel lm = new LegendModel();
-		lm.setPosition("top");
-		Tooltips tooltips = new Tooltips();
-		tooltips.setBodyFontSize(15);
-		tooltips.setTitleFontSize(15);
-		tooltips.setMode("index");
-		tooltips.setIntersect(false);
-		tooltips.setBackgroundColor("rgba(0, 0, 0, .5)");
-		HoverModel hover = new HoverModel();
-		hover.setIntersect(false);
-		hover.setMode("index");
-		TitleModel tm = new TitleModel();
-		tm.setText("Brand Wise Monthly Sale");
-		tm.setDisplay(true);
-		tm.setFontSize(20);
-		tm.setFontColor("#111");
-		OptionsModel om = new OptionsModel();
-		om.setResponsive(true);
-		om.setLegend(lm);
-		om.setTitle(tm);
-		om.setTooltips(tooltips);
-		om.setHover(hover);
-		ChartModel cm = new ChartModel();
-		cm.setType("line");
-		cm.setData(dm);
-		cm.setOptions(om);
-		LOGGER.info("cm" + cm);
-		return cm;
-	}
-	private ChartModel getBrandWiseLmp(List<Integer> warehouseIds, List<Integer> fofoIds, LocalDate startDateTime) {
-		LOGGER.info("params" + warehouseIds + fofoIds + startDateTime);
-		List<BrandWiseModel> brandWiseLms = orderRepository.selectGroupByBrandLmp(fofoIds, warehouseIds, startDateTime);
-		LOGGER.info("brandWiseLms" + brandWiseLms);
-		DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("MM-yyyy");
-		Map<String, Map<YearMonth, Double>> brandMonthValue = new HashMap<>();
-		for (BrandWiseModel bwl : brandWiseLms) {
-			Map<YearMonth, Double> brandValue = new HashMap<>();
-			if (brandMonthValue.containsKey(bwl.getBrand())) {
-				brandValue = brandMonthValue.get(bwl.getBrand());
-				brandValue.put(YearMonth.parse(bwl.getYearMonth(), dateTimeFormatter), (double) bwl.getAmount());
-			} else {
-				brandValue.put(YearMonth.parse(bwl.getYearMonth(), dateTimeFormatter), (double) bwl.getAmount());
-			}
-			brandMonthValue.put(bwl.getBrand(), brandValue);
-		}
-		LocalDateTime curDate = LocalDate.now().atStartOfDay();
-		Period age = Period.between(startDateTime, LocalDate.now());
-		int months = age.getMonths();
-		LOGGER.info("months" + months);
-		LOGGER.info("brandWiseLms" + brandWiseLms);
-		LOGGER.info("brandMonthValue" + brandMonthValue);
-		List<String> brands = new ArrayList<>();
-		brands.add("Oppo");
-		brands.add("Vivo");
-		brands.add("Samsung");
-		brands.add("Realme");
-		brands.add("Xiaomi");
-		brands.add("Tecno");
-		brands.add("Itel");
-		brands.add("Lava");
-		brands.add("Nokia");
-		Map<String, List<Double>> sortedBrandValue = new LinkedHashMap<>();
-		for (String brand : brands) {
-			Map<YearMonth, Double> yearMonthValue = brandMonthValue.get(brand);
-			for (int i = months; i >= 0; i--) {
-				LocalDateTime startMonth = curDate.withDayOfMonth(1).minusMonths(i);
-				if (yearMonthValue != null) {
-					if (yearMonthValue.get(YearMonth.from(startMonth)) == null) {
-						yearMonthValue.put(YearMonth.from(startMonth), 0.0);
-					}
-				} else {
-					yearMonthValue = new HashMap<>();
-					yearMonthValue.put(YearMonth.from(startMonth), 0.0);
-				}
-			}
-			Map<YearMonth, Double> sortedMonthBrandValue = new TreeMap<>(yearMonthValue);
-			brandMonthValue.put(brand, sortedMonthBrandValue);
-			sortedBrandValue.put(brand, sortedMonthBrandValue.values().stream().collect(Collectors.toList()));
-		}
-		LOGGER.info("brandMonthValue" + brandMonthValue);
-		LOGGER.info("sortedBrandValue" + sortedBrandValue);
-		LinkedHashSet<String> labels = new LinkedHashSet<String>();
-		for (int i = months; i >= 0; i--) {
-			LocalDateTime startMonth = curDate.withDayOfMonth(1).minusMonths(i);
-			labels.add(startMonth.format(DateTimeFormatter.ofPattern("MMM''uu")).toString());
-		}
-		List<DatasetModel> datasets = new ArrayList<>();
-		List<String> colorList = new ArrayList<>();
-		colorList.add("darkgreen");
-		colorList.add("dodgerblue");
-		colorList.add("darkblue");
-		colorList.add("gold");
-		colorList.add("coral");
-		colorList.add("steelblue");
-		colorList.add("red");
-		colorList.add("midnightblue");
-		colorList.add("cornsilk");
-		List<String> borderList = new ArrayList<>();
-		borderList.add("mediumseagreen");
-		borderList.add("lightblue");
-		borderList.add("#0000cd");
-		borderList.add("#f7e98e");
-		borderList.add("#ff8c69");
-		borderList.add("#0000cd");
-		borderList.add("lightsalmon");
-		borderList.add("#0000cd");
-		borderList.add("cornsilk");
-		int i = 0;
-		for (Entry<String, List<Double>> brandValue : sortedBrandValue.entrySet()) {
-			DatasetModel lmsModel = new DatasetModel();
-			lmsModel.setLabel(brandValue.getKey());
-			lmsModel.setBackgroundColor(colorList.get(i));
-			lmsModel.setData(brandValue.getValue());
-			lmsModel.setType("line");
-			lmsModel.setOrder(1);
-			lmsModel.setFill("false");
-			lmsModel.setBorderColor(borderList.get(i));
-			datasets.add(lmsModel);
-			i++;
-		}
-		DataModel dm = new DataModel();
-		dm.setDatasets(datasets);
-		dm.setLabels(labels);
-		LegendModel lm = new LegendModel();
-		lm.setPosition("top");
-		Tooltips tooltips = new Tooltips();
-		tooltips.setBodyFontSize(15);
-		tooltips.setTitleFontSize(15);
-		tooltips.setMode("index");
-		tooltips.setIntersect(false);
-		tooltips.setBackgroundColor("rgba(0, 0, 0, .5)");
-		HoverModel hover = new HoverModel();
-		hover.setIntersect(false);
-		hover.setMode("index");
-		TitleModel tm = new TitleModel();
-		tm.setText("Brand Wise Monthly Purchase");
-		tm.setDisplay(true);
-		tm.setFontSize(20);
-		tm.setFontColor("#111");
-		OptionsModel om = new OptionsModel();
-		om.setResponsive(true);
-		om.setLegend(lm);
-		om.setTitle(tm);
-		om.setTooltips(tooltips);
-		om.setHover(hover);
-		ChartModel cm = new ChartModel();
-		cm.setType("line");
-		cm.setData(dm);
-		cm.setOptions(om);
-		LOGGER.info("cm" + cm);
-		return cm;
-	}
+}

Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/DashboardController.java – Rev 28463 → 28468