Subversion Repositories SmartDukaan

Rev

Rev 28272 | Rev 28430 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
21615 kshitij.so 1 
package com.spice.profitmandi.web.controller;
2 
 
25651 tejbeer 3 
import java.io.File;
4 
import java.io.FileInputStream;
5 
import java.io.FileNotFoundException;
27628 tejbeer 6 
import java.io.FileOutputStream;
7 
import java.io.ObjectInputStream;
8 
import java.io.ObjectOutputStream;
24288 amit.gupta 9 
import java.time.LocalDate;
24276 amit.gupta 10 
import java.time.LocalDateTime;
24880 govind 11 
import java.time.LocalTime;
28272 tejbeer 12 
import java.time.Month;
27555 tejbeer 13 
import java.time.YearMonth;
25649 tejbeer 14 
import java.time.ZoneOffset;
27474 tejbeer 15 
import java.time.format.DateTimeFormatter;
24339 amit.gupta 16 
import java.util.ArrayList;
26027 amit.gupta 17 
import java.util.Arrays;
27701 tejbeer 18 
import java.util.Comparator;
26011 amit.gupta 19 
import java.util.HashMap;
26090 amit.gupta 20 
import java.util.HashSet;
25136 amit.gupta 21 
import java.util.LinkedHashMap;
23884 amit.gupta 22 
import java.util.List;
24880 govind 23 
import java.util.Map;
26055 tejbeer 24 
import java.util.Map.Entry;
26071 tejbeer 25 
import java.util.Optional;
26090 amit.gupta 26 
import java.util.Set;
24880 govind 27 
import java.util.stream.Collectors;
23568 govind 28 
 
22086 amit.gupta 29 
import javax.servlet.http.HttpServletRequest;
25221 amit.gupta 30 
import javax.transaction.Transactional;
22086 amit.gupta 31 
 
23786 amit.gupta 32 
import org.apache.logging.log4j.LogManager;
23568 govind 33 
import org.apache.logging.log4j.Logger;
26158 amit.gupta 34 
import org.json.JSONObject;
22481 ashik.ali 35 
import org.springframework.beans.factory.annotation.Autowired;
23379 ashik.ali 36 
import org.springframework.beans.factory.annotation.Value;
25651 tejbeer 37 
import org.springframework.core.io.InputStreamResource;
38 
import org.springframework.http.HttpHeaders;
39 
import org.springframework.http.HttpStatus;
25649 tejbeer 40 
import org.springframework.http.ResponseEntity;
21615 kshitij.so 41 
import org.springframework.stereotype.Controller;
22073 ashik.ali 42 
import org.springframework.ui.Model;
21615 kshitij.so 43 
import org.springframework.web.bind.annotation.RequestMapping;
44 
import org.springframework.web.bind.annotation.RequestMethod;
25649 tejbeer 45 
import org.springframework.web.bind.annotation.RequestParam;
21615 kshitij.so 46 
 
25649 tejbeer 47 
import com.google.gson.Gson;
25677 amit.gupta 48 
import com.mongodb.DBObject;
25651 tejbeer 49 
import com.spice.profitmandi.common.enumuration.ContentType;
25683 tejbeer 50 
import com.spice.profitmandi.common.enumuration.MessageType;
26065 amit.gupta 51 
import com.spice.profitmandi.common.enumuration.ReporticoProject;
22481 ashik.ali 52 
import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
27636 tejbeer 53 
import com.spice.profitmandi.common.model.ActivateItemModel;
27884 tejbeer 54 
import com.spice.profitmandi.common.model.Axis;
25677 amit.gupta 55 
import com.spice.profitmandi.common.model.BrandStockPrice;
27884 tejbeer 56 
import com.spice.profitmandi.common.model.ChartInvestmentModel;
26055 tejbeer 57 
import com.spice.profitmandi.common.model.ChartModel;
26005 amit.gupta 58 
import com.spice.profitmandi.common.model.CustomRetailer;
27884 tejbeer 59 
import com.spice.profitmandi.common.model.Data;
60 
import com.spice.profitmandi.common.model.DataInvestmentModel;
26055 tejbeer 61 
import com.spice.profitmandi.common.model.DataModel;
62 
import com.spice.profitmandi.common.model.DatasetModel;
27884 tejbeer 63 
import com.spice.profitmandi.common.model.Legend;
26055 tejbeer 64 
import com.spice.profitmandi.common.model.LegendModel;
25649 tejbeer 65 
import com.spice.profitmandi.common.model.Notification;
28409 tejbeer 66 
import com.spice.profitmandi.common.model.OnlineDeliveredOrderSum;
27884 tejbeer 67 
import com.spice.profitmandi.common.model.OptionModel;
26055 tejbeer 68 
import com.spice.profitmandi.common.model.OptionsModel;
27884 tejbeer 69 
import com.spice.profitmandi.common.model.PieLables;
24203 amit.gupta 70 
import com.spice.profitmandi.common.model.ProfitMandiConstants;
27884 tejbeer 71 
import com.spice.profitmandi.common.model.ScalesModel;
26055 tejbeer 72 
import com.spice.profitmandi.common.model.TitleModel;
25651 tejbeer 73 
import com.spice.profitmandi.common.web.util.ResponseSender;
25649 tejbeer 74 
import com.spice.profitmandi.dao.Interface.Campaign;
26011 amit.gupta 75 
import com.spice.profitmandi.dao.entity.auth.AuthUser;
76 
import com.spice.profitmandi.dao.entity.auth.Menu;
27355 tejbeer 77 
import com.spice.profitmandi.dao.entity.catalog.Item;
27636 tejbeer 78 
import com.spice.profitmandi.dao.entity.catalog.TagListing;
26011 amit.gupta 79 
import com.spice.profitmandi.dao.entity.cs.Position;
27660 tejbeer 80 
import com.spice.profitmandi.dao.entity.cs.TicketAssigned;
25651 tejbeer 81 
import com.spice.profitmandi.dao.entity.dtr.Document;
25649 tejbeer 82 
import com.spice.profitmandi.dao.entity.dtr.NotificationCampaign;
22654 ashik.ali 83 
import com.spice.profitmandi.dao.entity.fofo.FofoStore;
27636 tejbeer 84 
import com.spice.profitmandi.dao.entity.fofo.InventoryItem;
24288 amit.gupta 85 
import com.spice.profitmandi.dao.entity.fofo.PartnerDailyInvestment;
25214 amit.gupta 86 
import com.spice.profitmandi.dao.entity.fofo.PartnerTargetDetails;
25566 tejbeer 87 
import com.spice.profitmandi.dao.entity.fofo.PartnerType;
28409 tejbeer 88 
import com.spice.profitmandi.dao.entity.fofo.PendingOrder;
89 
import com.spice.profitmandi.dao.entity.fofo.PendingOrderItem;
27529 tejbeer 90 
import com.spice.profitmandi.dao.entity.inventory.ReporticoCacheTable;
27586 tejbeer 91 
import com.spice.profitmandi.dao.entity.transaction.Order;
26418 tejbeer 92 
import com.spice.profitmandi.dao.entity.user.Lead;
26024 amit.gupta 93 
import com.spice.profitmandi.dao.enumuration.cs.EscalationType;
26418 tejbeer 94 
import com.spice.profitmandi.dao.enumuration.dtr.LeadStatus;
28409 tejbeer 95 
import com.spice.profitmandi.dao.enumuration.transaction.OrderStatus;
27628 tejbeer 96 
import com.spice.profitmandi.dao.model.BrandWisePartnerSaleModel;
27670 tejbeer 97 
import com.spice.profitmandi.dao.model.BrandWiseUnbilledActivateStockModel;
26674 tejbeer 98 
import com.spice.profitmandi.dao.model.CreateOfferRequest;
27660 tejbeer 99 
import com.spice.profitmandi.dao.model.InStockBrandItemModel;
27640 tejbeer 100 
import com.spice.profitmandi.dao.model.InStockBrandModel;
27579 tejbeer 101 
import com.spice.profitmandi.dao.model.ItemWiseTertiaryModel;
27474 tejbeer 102 
import com.spice.profitmandi.dao.model.MonthSaleModel;
26418 tejbeer 103 
import com.spice.profitmandi.dao.model.PartnerDetailModel;
27599 tejbeer 104 
import com.spice.profitmandi.dao.model.PartnerPendingIndentItemModel;
25649 tejbeer 105 
import com.spice.profitmandi.dao.model.SimpleCampaign;
106 
import com.spice.profitmandi.dao.model.SimpleCampaignParams;
27670 tejbeer 107 
import com.spice.profitmandi.dao.model.WarehouseBrandItemUnbilledActivatedModel;
27556 tejbeer 108 
import com.spice.profitmandi.dao.model.WarehouseBrandWiseItemSaleModel;
27628 tejbeer 109 
import com.spice.profitmandi.dao.model.WarehouseWiseBrandSaleModel;
27591 tejbeer 110 
import com.spice.profitmandi.dao.model.WarehouseWiseBrandStockModel;
27670 tejbeer 111 
import com.spice.profitmandi.dao.model.WarehouseWiseBrandUnbilledActivatedModel;
27509 tejbeer 112 
import com.spice.profitmandi.dao.model.WarehouseWiseStockModel;
113 
import com.spice.profitmandi.dao.model.WarehouseWiseitemStockModel;
25976 amit.gupta 114 
import com.spice.profitmandi.dao.repository.auth.AuthRepository;
26011 amit.gupta 115 
import com.spice.profitmandi.dao.repository.auth.MenuCategoryRepository;
116 
import com.spice.profitmandi.dao.repository.auth.MenuRepository;
27355 tejbeer 117 
import com.spice.profitmandi.dao.repository.catalog.ItemRepository;
26588 tejbeer 118 
import com.spice.profitmandi.dao.repository.catalog.OfferMarginRepository;
119 
import com.spice.profitmandi.dao.repository.catalog.OfferPartnerRepository;
120 
import com.spice.profitmandi.dao.repository.catalog.OfferRepository;
27632 tejbeer 121 
import com.spice.profitmandi.dao.repository.catalog.TagListingRepository;
26090 amit.gupta 122 
import com.spice.profitmandi.dao.repository.cs.CsService;
26418 tejbeer 123 
import com.spice.profitmandi.dao.repository.cs.PartnersPositionRepository;
26011 amit.gupta 124 
import com.spice.profitmandi.dao.repository.cs.PositionRepository;
27660 tejbeer 125 
import com.spice.profitmandi.dao.repository.cs.TicketAssignedRepository;
26011 amit.gupta 126 
import com.spice.profitmandi.dao.repository.cs.TicketCategoryRepository;
26418 tejbeer 127 
import com.spice.profitmandi.dao.repository.cs.TicketRepository;
25651 tejbeer 128 
import com.spice.profitmandi.dao.repository.dtr.DocumentRepository;
22481 ashik.ali 129 
import com.spice.profitmandi.dao.repository.dtr.FofoStoreRepository;
26418 tejbeer 130 
import com.spice.profitmandi.dao.repository.dtr.LeadRepository;
24996 amit.gupta 131 
import com.spice.profitmandi.dao.repository.dtr.Mongo;
25649 tejbeer 132 
import com.spice.profitmandi.dao.repository.dtr.NotificationCampaignRepository;
133 
import com.spice.profitmandi.dao.repository.dtr.UserAccountRepository;
134 
import com.spice.profitmandi.dao.repository.dtr.UserCampaignRepository;
24203 amit.gupta 135 
import com.spice.profitmandi.dao.repository.fofo.CurrentInventorySnapshotRepository;
24880 govind 136 
import com.spice.profitmandi.dao.repository.fofo.FofoOrderItemRepository;
26071 tejbeer 137 
import com.spice.profitmandi.dao.repository.fofo.FofoOrderRepository;
25649 tejbeer 138 
import com.spice.profitmandi.dao.repository.fofo.HygieneDataRepository;
26234 amit.gupta 139 
import com.spice.profitmandi.dao.repository.fofo.InventoryItemRepository;
24288 amit.gupta 140 
import com.spice.profitmandi.dao.repository.fofo.PartnerDailyInvestmentRepository;
25214 amit.gupta 141 
import com.spice.profitmandi.dao.repository.fofo.PartnerTargetRepository;
27474 tejbeer 142 
import com.spice.profitmandi.dao.repository.fofo.PartnerTypeChangeRepository;
25566 tejbeer 143 
import com.spice.profitmandi.dao.repository.fofo.PartnerTypeChangeService;
28409 tejbeer 144 
import com.spice.profitmandi.dao.repository.fofo.PendingOrderItemRepository;
145 
import com.spice.profitmandi.dao.repository.fofo.PendingOrderRepository;
27529 tejbeer 146 
import com.spice.profitmandi.dao.repository.inventory.ReporticoCacheTableRepository;
147 
import com.spice.profitmandi.dao.repository.inventory.SaholicInventoryCISRepository;
27509 tejbeer 148 
import com.spice.profitmandi.dao.repository.inventory.SaholicInventorySnapshotRepository;
27893 tejbeer 149 
import com.spice.profitmandi.dao.repository.transaction.OrderRepository;
24336 amit.gupta 150 
import com.spice.profitmandi.service.PartnerInvestmentService;
26460 amit.gupta 151 
import com.spice.profitmandi.service.PartnerStatsService;
23844 amit.gupta 152 
import com.spice.profitmandi.service.authentication.RoleManager;
25677 amit.gupta 153 
import com.spice.profitmandi.service.inventory.InventoryService;
27876 amit.gupta 154 
import com.spice.profitmandi.service.offers.OfferService;
27586 tejbeer 155 
import com.spice.profitmandi.service.transaction.TransactionService;
26005 amit.gupta 156 
import com.spice.profitmandi.service.user.RetailerService;
22481 ashik.ali 157 
import com.spice.profitmandi.web.model.LoginDetails;
158 
import com.spice.profitmandi.web.util.CookiesProcessor;
27529 tejbeer 159 
import com.spice.profitmandi.web.util.MVCResponseSender;
22481 ashik.ali 160 
 
21615 kshitij.so 161 
@Controller
25222 amit.gupta 162 
@Transactional(rollbackOn = Throwable.class)
21615 kshitij.so 163 
public class DashboardController {
23923 amit.gupta 164 
 
26460 amit.gupta 165 
	private static final double ONE_LAC = 1 * 1000 * 100;
166 
	private static final double TWO_LAC = 2 * 1000 * 100;
167 
	private static final double FOUR_LAC = 4 * 1000 * 100;
168 
 
27727 tejbeer 169 
	List<String> emails = Arrays.asList("kamini.sharma@smartdukaan.com", "neeraj.gupta@smartdukaan.com",
27778 tejbeer 170 
			"niranjan.kala@smartdukaan.com", "hemant.kaura@smartdukaan.com", "amit.gupta@shop2020.in",
171 
			"tejbeer.kaur@shop2020.in");
27727 tejbeer 172 
 
23379 ashik.ali 173 
	@Value("${web.api.host}")
174 
	private String webApiHost;
23923 amit.gupta 175 
 
24072 amit.gupta 176 
	@Value("${web.api.scheme}")
177 
	private String webApiScheme;
24288 amit.gupta 178 
 
24078 amit.gupta 179 
	@Value("${web.api.root}")
180 
	private String webApiRoot;
181 
 
23379 ashik.ali 182 
	@Value("${web.api.port}")
183 
	private int webApiPort;
28409 tejbeer 184 
 
22481 ashik.ali 185 
	@Autowired
22927 ashik.ali 186 
	private CookiesProcessor cookiesProcessor;
26468 amit.gupta 187 
 
26460 amit.gupta 188 
	@Autowired
28409 tejbeer 189 
	private PendingOrderRepository pendingOrderRepository;
190 
 
191 
	@Autowired
26460 amit.gupta 192 
	private PartnerStatsService partnerStatsService;
23923 amit.gupta 193 
 
23568 govind 194 
	@Autowired
26011 amit.gupta 195 
	private MenuRepository menuRepository;
26012 amit.gupta 196 
 
26011 amit.gupta 197 
	@Autowired
198 
	private MenuCategoryRepository menuCategoryRepository;
199 
 
200 
	@Autowired
26090 amit.gupta 201 
	private CsService csService;
202 
 
203 
	@Autowired
25214 amit.gupta 204 
	private PartnerTargetRepository partnerTargetRepository;
205 
 
206 
	@Autowired
25653 amit.gupta 207 
	private ResponseSender<?> responseSender;
26012 amit.gupta 208 
 
26005 amit.gupta 209 
	@Autowired
210 
	RetailerService retailerService;
25214 amit.gupta 211 
 
212 
	@Autowired
23786 amit.gupta 213 
	private RoleManager roleManager;
23923 amit.gupta 214 
 
23838 ashik.ali 215 
	@Autowired
216 
	private FofoStoreRepository fofoStoreRepository;
23884 amit.gupta 217 
 
218 
	@Autowired
24880 govind 219 
	private PartnerDailyInvestmentRepository partnerDailyInvestmentRepository;
23923 amit.gupta 220 
 
23884 amit.gupta 221 
	@Autowired
24880 govind 222 
	private PartnerInvestmentService partnerInvestmentService;
24288 amit.gupta 223 
 
23884 amit.gupta 224 
	@Autowired
25653 amit.gupta 225 
	DocumentRepository documentRepository;
26236 amit.gupta 226 
 
26234 amit.gupta 227 
	@Autowired
228 
	InventoryItemRepository inventoryItemRepository;
25683 tejbeer 229 
 
25677 amit.gupta 230 
	@Autowired
231 
	InventoryService inventoryService;
23923 amit.gupta 232 
 
23884 amit.gupta 233 
	@Autowired
28409 tejbeer 234 
	private PendingOrderItemRepository pendingOrderItemRepository;
235 
 
236 
 
237 
	@Autowired
24203 amit.gupta 238 
	private CurrentInventorySnapshotRepository currentInventorySnapshotRepository;
239 
 
24880 govind 240 
	@Autowired
241 
	private FofoOrderItemRepository fofoOrderItemRepository;
26012 amit.gupta 242 
 
26011 amit.gupta 243 
	@Autowired
244 
	private TicketCategoryRepository ticketCategoryRepository;
24880 govind 245 
 
246 
	@Autowired
25566 tejbeer 247 
	private PartnerTypeChangeService partnerTypeChangeService;
25136 amit.gupta 248 
 
24996 amit.gupta 249 
	@Autowired
25649 tejbeer 250 
	private HygieneDataRepository hygieneDataRepository;
251 
 
252 
	@Autowired
253 
	private UserCampaignRepository userCampaignRepository;
26012 amit.gupta 254 
 
26011 amit.gupta 255 
	@Autowired
256 
	private PositionRepository positionRepository;
27474 tejbeer 257 
	@Autowired
258 
	private PartnerTypeChangeRepository partnerTypeChangeRepository;
25649 tejbeer 259 
 
260 
	@Autowired
26418 tejbeer 261 
	private PartnersPositionRepository partnerPositionRepository;
262 
 
263 
	@Autowired
25649 tejbeer 264 
	private UserAccountRepository userAccountRepository;
265 
 
266 
	@Autowired
267 
	private NotificationCampaignRepository notificationCampaignRepository;
268 
 
269 
	@Autowired
24996 amit.gupta 270 
	private Mongo mongoClient;
26012 amit.gupta 271 
 
25976 amit.gupta 272 
	@Autowired
273 
	private AuthRepository authRepository;
24880 govind 274 
 
25649 tejbeer 275 
	@Autowired
26071 tejbeer 276 
	private FofoOrderRepository fofoOrderRepository;
277 
 
278 
	@Autowired
25649 tejbeer 279 
	private Gson gson;
280 
 
26418 tejbeer 281 
	@Autowired
282 
	TicketRepository ticketRepository;
283 
 
284 
	@Autowired
285 
	private LeadRepository leadRepository;
286 
 
26588 tejbeer 287 
	@Autowired
288 
	private OfferRepository offerRepository;
289 
 
290 
	@Autowired
291 
	private OfferPartnerRepository offerPartnerRepository;
292 
 
293 
	@Autowired
27876 amit.gupta 294 
	private OfferService offerService;
295 
 
296 
	@Autowired
26588 tejbeer 297 
	private OfferMarginRepository offerMarginRepository;
27529 tejbeer 298 
 
27355 tejbeer 299 
	@Autowired
300 
	private ItemRepository itemRepository;
26588 tejbeer 301 
 
27509 tejbeer 302 
	@Autowired
303 
	private SaholicInventorySnapshotRepository saholicInventorySnapshotRepository;
27529 tejbeer 304 
 
305 
	@Autowired
306 
	private SaholicInventoryCISRepository saholicInventoryCISRepository;
307 
 
308 
	@Autowired
309 
	private MVCResponseSender mvcResponseSender;
310 
 
311 
	@Autowired
312 
	private ReporticoCacheTableRepository reporticoCacheTableRepository;
313 
 
27586 tejbeer 314 
	@Autowired
315 
	private TransactionService transactionService;
316 
 
27632 tejbeer 317 
	@Autowired
318 
	private TagListingRepository tagListingRepository;
319 
 
27660 tejbeer 320 
	@Autowired
321 
	private TicketAssignedRepository ticketAssignedRepository;
322 
 
27893 tejbeer 323 
	@Autowired
324 
	private OrderRepository orderRepository;
23568 govind 325 
	private static final Logger LOGGER = LogManager.getLogger(DashboardController.class);
23923 amit.gupta 326 
 
25136 amit.gupta 327 
	@RequestMapping(value = "/12dashboard34", method = RequestMethod.GET)
25726 amit.gupta 328 
	public String dashboard1(HttpServletRequest request, Model model, @RequestParam int fofoId) throws Exception {
25740 amit.gupta 329 
		boolean isAdmin = false;
330 
		model.addAttribute("isAdmin", isAdmin);
331 
 
332 
		model.addAttribute("webApiHost", webApiHost);
333 
		model.addAttribute("webApiPort", webApiPort);
334 
		model.addAttribute("webApiScheme", webApiScheme);
335 
		model.addAttribute("webApiRoot", webApiRoot);
336 
		if (isAdmin) {
337 
			return "dashboard1";
26236 amit.gupta 338 
		}
339 
 
340 
		FofoStore fofoStore = null;
26234 amit.gupta 341 
		try {
342 
			CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
343 
			fofoStore = fofoStoreRepository.selectByRetailerId(fofoId);
344 
			if (!fofoStore.isActive()) {
345 
				return "redirect:/login";
346 
			}
25740 amit.gupta 347 
 
26234 amit.gupta 348 
			PartnerType partnerType = partnerTypeChangeService.getTypeOnDate(fofoStore.getId(), LocalDate.now());
349 
			model.addAttribute("partnerType", partnerType);
350 
			model.addAttribute("partnerTypeImage", PartnerType.imageMap.get(partnerType));
351 
			model.addAttribute("fofoStore", customRetailer);
352 
			model.addAttribute("partnerType", partnerType);
353 
			model.addAttribute("hasGift", hasGift(fofoId));
354 
			model.addAttribute("giftItemId", ProfitMandiConstants.GIFT_ID);
25740 amit.gupta 355 
 
27884 tejbeer 356 
			model.addAttribute("brandStockPrices", this.getBrandStockPrices(fofoId));
26234 amit.gupta 357 
			model.addAttribute("salesMap", this.getSales(fofoId));
358 
			model.addAttribute("activatedImeis", inventoryItemRepository.selectCountByActivatedNotSold(fofoId));
359 
			// this.setInvestments
360 
			//
28272 tejbeer 361 
			Map<Integer, String> monthValueMap = new HashMap<>();
362 
			for (int i = 0; i <= 5; i++) {
363 
				LocalDateTime startOfMonth = LocalDateTime.now().withDayOfMonth(1).minusMonths(i);
364 
				monthValueMap.put(i, startOfMonth.format(DateTimeFormatter.ofPattern("MMM''uu")));
365 
			}
366 
			LOGGER.info("monthValueMap" + monthValueMap);
367 
			model.addAttribute("monthValueMap", monthValueMap);
26234 amit.gupta 368 
			model.addAttribute("investments", this.getInvestments(fofoId));
369 
			model.addAttribute("isInvestmentOk",
370 
					partnerInvestmentService.isInvestmentOk(fofoId, 10, ProfitMandiConstants.CUTOFF_INVESTMENT));
371 
		} catch (ProfitMandiBusinessException e) {
372 
			LOGGER.error("FofoStore Code not found of fofoId {}", fofoId);
25740 amit.gupta 373 
 
374 
		}
375 
 
28272 tejbeer 376 
			return "12dashboard34";
377 
	}
25740 amit.gupta 378 
 
28272 tejbeer 379 
	private Map<String, Object> getInvestments(int fofoId) throws Exception {
380 
		Map<String, Object> investments = new LinkedHashMap<>();
381 
		PartnerDailyInvestment investment = partnerInvestmentService.getInvestment(fofoId, 0);
382 
		LocalDate currentMonthStart = LocalDate.now().withDayOfMonth(1);
383 
		LocalDate yesterDate = LocalDate.now().minusDays(1);
384 
		PartnerDailyInvestment yesterdayInvestment = partnerDailyInvestmentRepository.select(fofoId, yesterDate);
385 
		if (yesterdayInvestment == null) {
386 
			yesterdayInvestment = new PartnerDailyInvestment();
25740 amit.gupta 387 
		}
26460 amit.gupta 388 
 
28272 tejbeer 389 
		List<PartnerDailyInvestment> currentMonthInvestments = partnerDailyInvestmentRepository.selectAll(fofoId,
390 
				currentMonthStart, currentMonthStart.withDayOfMonth(currentMonthStart.lengthOfMonth()));
391 
 
392 
		long okInvestmentDays = currentMonthInvestments.stream().filter(x -> x.getShortPercentage() <= 10)
393 
				.collect(Collectors.counting());
394 
		investments.put("today", investment.getTotalInvestment());
395 
		investments.put("investment", investment);
396 
		investments.put("inStock", investment.getInStockAmount());
397 
		investments.put("minimum", investment.getMinInvestmentString());
398 
		investments.put("short", investment.getShortPercentage());
399 
		investments.put("activated_stock", investment.getActivatedStockAmount());
400 
		investments.put("okDays", okInvestmentDays);
401 
		return investments;
25136 amit.gupta 402 
	}
403 
 
28272 tejbeer 404 
	private Map<String, Object> getInvestmentsMonths(int fofoId, int month) throws Exception {
25136 amit.gupta 405 
		Map<String, Object> investments = new LinkedHashMap<>();
26233 amit.gupta 406 
		PartnerDailyInvestment investment = partnerInvestmentService.getInvestment(fofoId, 0);
28272 tejbeer 407 
		LocalDate currentMonthStart = LocalDate.now().withDayOfMonth(1).minusMonths(month);
408 
 
25136 amit.gupta 409 
		LocalDate yesterDate = LocalDate.now().minusDays(1);
410 
		PartnerDailyInvestment yesterdayInvestment = partnerDailyInvestmentRepository.select(fofoId, yesterDate);
411 
		if (yesterdayInvestment == null) {
412 
			yesterdayInvestment = new PartnerDailyInvestment();
413 
		}
414 
 
415 
		List<PartnerDailyInvestment> currentMonthInvestments = partnerDailyInvestmentRepository.selectAll(fofoId,
416 
				currentMonthStart, currentMonthStart.withDayOfMonth(currentMonthStart.lengthOfMonth()));
417 
 
25140 amit.gupta 418 
		long okInvestmentDays = currentMonthInvestments.stream().filter(x -> x.getShortPercentage() <= 10)
25136 amit.gupta 419 
				.collect(Collectors.counting());
25140 amit.gupta 420 
		investments.put("today", investment.getTotalInvestment());
421 
		investments.put("investment", investment);
422 
		investments.put("inStock", investment.getInStockAmount());
25182 amit.gupta 423 
		investments.put("minimum", investment.getMinInvestmentString());
25140 amit.gupta 424 
		investments.put("short", investment.getShortPercentage());
26267 amit.gupta 425 
		investments.put("activated_stock", investment.getActivatedStockAmount());
25649 tejbeer 426 
		investments.put("okDays", okInvestmentDays);
25136 amit.gupta 427 
		return investments;
428 
	}
429 
 
25221 amit.gupta 430 
	private Map<String, Object> getSales(int fofoId) {
25653 amit.gupta 431 
 
25221 amit.gupta 432 
		Map<String, Object> salesMap = new LinkedHashMap<>();
25140 amit.gupta 433 
		LocalDateTime curDate = LocalDate.now().atStartOfDay();
25214 amit.gupta 434 
		int monthLength = LocalDate.now().lengthOfMonth();
26012 amit.gupta 435 
		Double todaySale = fofoOrderItemRepository
27084 amit.gupta 436 
				.selectSumMopGroupByRetailer(curDate, curDate.with(LocalTime.MAX), fofoId, false).get(fofoId);
26012 amit.gupta 437 
		Double mtdSale = fofoOrderItemRepository
27084 amit.gupta 438 
				.selectSumMopGroupByRetailer(curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), fofoId, false)
26012 amit.gupta 439 
				.get(fofoId);
27352 tejbeer 440 
		Double lmtdSale = fofoOrderItemRepository.selectSumMopGroupByRetailer(curDate.withDayOfMonth(1).minusMonths(1),
441 
				curDate.with(LocalTime.MAX).minusMonths(1), fofoId, false).get(fofoId);
25214 amit.gupta 442 
 
443 
		List<PartnerTargetDetails> partnerTargetDetails = partnerTargetRepository
444 
				.selectAllGeEqAndLeEqStartDateAndEndDate(LocalDateTime.now());
25544 amit.gupta 445 
		if (partnerTargetDetails.isEmpty()) {
25372 tejbeer 446 
			partnerTargetDetails = partnerTargetRepository
25653 amit.gupta 447 
					.selectAllGeEqAndLeEqStartDateAndEndDate(LocalDateTime.now().minusMonths(3));
25372 tejbeer 448 
		}
25214 amit.gupta 449 
 
25653 amit.gupta 450 
		PartnerType partnerType = partnerTypeChangeService.getTypeOnDate(fofoId, LocalDate.now());
25214 amit.gupta 451 
 
25664 amit.gupta 452 
		int currentRate = (int) (mtdSale / curDate.getDayOfMonth());
25653 amit.gupta 453 
 
454 
		salesMap.put("requiredType", partnerType.next());
455 
		float reqdAmount = partnerTypeChangeService.getMinimumAmount(partnerType.next());
456 
		int requiredRate = (int) ((reqdAmount - mtdSale) / (monthLength - curDate.getDayOfMonth()));
27859 tejbeer 457 
		if (partnerType.equals(PartnerType.PLATINUM) && requiredRate < currentRate) {
458 
			requiredRate = currentRate;
459 
		}
25653 amit.gupta 460 
		salesMap.put("requiredRate", requiredRate);
461 
		salesMap.put("requiredTypeImage", PartnerType.imageMap.get(partnerType.next()));
462 
 
25858 amit.gupta 463 
		salesMap.put("todaySale", todaySale == null ? 0 : todaySale);
464 
		salesMap.put("mtdSale", mtdSale == null ? 0 : mtdSale);
26012 amit.gupta 465 
		salesMap.put("lmtdSale", lmtdSale == null ? 0 : lmtdSale);
26065 amit.gupta 466 
 
27352 tejbeer 467 
		PartnerType currentType = partnerTypeChangeService.getPartnerTypeByAmount(currentRate * monthLength);
25653 amit.gupta 468 
		salesMap.put("currentRate", currentRate);
469 
		salesMap.put("currentType", currentType);
470 
		salesMap.put("currentTypeImage", PartnerType.imageMap.get(currentType));
25136 amit.gupta 471 
		return salesMap;
472 
	}
473 
 
27474 tejbeer 474 
	@RequestMapping(value = "/getMonthSale", method = RequestMethod.GET)
475 
	public String getMonthsale(HttpServletRequest request, Model model) throws Exception {
476 
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
477 
		int fofoId = loginDetails.getFofoId();
478 
		Map<Integer, MonthSaleModel> monthSaleMap = new HashMap<>();
479 
		LocalDateTime curDate = LocalDate.now().atStartOfDay();
480 
		int dayOfMonth = curDate.getDayOfMonth();
481 
		for (int i = 1; i <= 6; i++) {
482 
			LocalDateTime startOfMonth = curDate.withDayOfMonth(1).minusMonths(i);
27555 tejbeer 483 
			int lengthOfMonth = YearMonth.from(startOfMonth).lengthOfMonth();
27474 tejbeer 484 
			double monthSales = fofoOrderItemRepository.selectSumMopGroupByRetailer(startOfMonth,
485 
					startOfMonth.plusMonths(1), loginDetails.getFofoId(), false).get(fofoId);
486 
 
27574 tejbeer 487 
			double mtdSales = fofoOrderItemRepository
488 
					.selectSumMopGroupByRetailer(startOfMonth,
489 
							startOfMonth.plusDays(Math.min(dayOfMonth, lengthOfMonth)), loginDetails.getFofoId(), false)
490 
					.get(fofoId);
27474 tejbeer 491 
 
492 
			PartnerType partnerType = partnerTypeChangeService.getTypeOnDate(fofoId, startOfMonth.toLocalDate());
493 
 
494 
			MonthSaleModel ms = new MonthSaleModel();
495 
			ms.setMtdSales(this.format((long) mtdSales));
496 
			ms.setMonthlySales(this.format(((long) monthSales)));
497 
			ms.setPartnerType(partnerType);
27476 tejbeer 498 
			ms.setMonth(startOfMonth.format(DateTimeFormatter.ofPattern("MMM''uu")));
27474 tejbeer 499 
			monthSaleMap.put(i, ms);
500 
 
501 
		}
502 
		model.addAttribute("monthSales", monthSaleMap);
503 
		return "monthSales";
504 
	}
505 
 
506 
	private String format(long value) {
507 
		String finalval = null;
508 
 
509 
		if (value >= 100000 && value < 10000000) {
510 
			long reminder = value / 100000;
511 
			long quitonent = value % 100000;
512 
			finalval = reminder + "." + quitonent;
513 
			String secondval = String.valueOf(quitonent);
514 
			if (secondval.length() >= 2) {
515 
				secondval = secondval.substring(0, 2);
516 
				finalval = reminder + "." + secondval;
517 
			}
518 
			return String.valueOf(finalval) + " Lacs";
519 
		} else if (value >= 1000 && value < 100000) {
520 
			long reminder = value / 1000;
521 
			long quitonent = value % 1000;
522 
			finalval = reminder + "." + quitonent;
523 
			String secondval = String.valueOf(quitonent);
524 
			if (secondval.length() >= 2) {
525 
				secondval = secondval.substring(0, 2);
526 
				finalval = reminder + "." + secondval;
527 
			}
528 
			return String.valueOf(finalval) + " K";
529 
		} else if (value >= 10000000 && value < 1000000000) {
530 
			long reminder = value / 10000000;
531 
			long quitonent = value % 10000000;
532 
			finalval = reminder + "." + quitonent;
533 
			String secondval = String.valueOf(quitonent);
534 
			if (secondval.length() >= 2) {
535 
				secondval = secondval.substring(0, 2);
536 
				finalval = reminder + "." + secondval;
537 
			}
538 
			return String.valueOf(finalval) + " Cr";
539 
		}
540 
		return String.valueOf(finalval);
541 
 
542 
	}
543 
 
27702 tejbeer 544 
	private List<BrandStockPrice> getBrandStockPrices(int fofoId) throws Exception {
545 
		Map<String, BrandStockPrice> brandStockPricesMap = inventoryService.getBrandWiseStockValue(fofoId);
25175 amit.gupta 546 
 
27702 tejbeer 547 
		List<DBObject> mobileBrands = mongoClient.getAllBrandsToDisplay(3);
548 
		List<BrandStockPrice> brandStockPrices = new ArrayList<>();
549 
 
550 
		mobileBrands.stream().forEach(x -> {
551 
			String brand = (String) x.get("name");
552 
			if (brandStockPricesMap.containsKey(brand)) {
553 
				BrandStockPrice brandStockPrice = brandStockPricesMap.get(brand);
554 
				brandStockPrice.setBrandUrl((String) x.get("url"));
555 
				brandStockPrice.setRank(((Double) x.get("rank")).intValue());
556 
				brandStockPrices.add(brandStockPrice);
557 
			}
558 
		});
559 
 
560 
		return brandStockPrices.stream().filter(x -> x.getTotalQty() > 0).sorted((x, y) -> x.getRank() - y.getRank())
561 
				.collect(Collectors.toList());
562 
	}
563 
 
21615 kshitij.so 564 
	@RequestMapping(value = "/dashboard", method = RequestMethod.GET)
25653 amit.gupta 565 
	public String dashboard(HttpServletRequest request, Model model) throws Exception {
22927 ashik.ali 566 
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
26011 amit.gupta 567 
		String email = loginDetails.getEmailId();
28409 tejbeer 568 
		int fofoId =  loginDetails.getFofoId();
569 
 
570 
	LocalDateTime startDate =	LocalDate.now().withDayOfYear(1).atStartOfDay();
571 
	LocalDateTime endtDate  =   LocalDateTime.now();
572 
	LOGGER.info("startDate"+startDate);
573 
	LOGGER.info("endtDate"+endtDate);
574 
 
575 
 
576 
	OnlineDeliveredOrderSum onlineDeliveredOrderSum= 	pendingOrderItemRepository.selectSumSellingPriceOnlineOrder(fofoId, startDate, endtDate);
577 
 
578 
	LOGGER.info("onlineDeliveredOrderSum"+onlineDeliveredOrderSum.getSellingPrice());
579 
 
580 
 
581 
	long countOrder =	pendingOrderRepository.pendingOrderCount(fofoId, OrderStatus.PROCESSING);
582 
		LOGGER.info("countOrder"+countOrder);
583 
 
584 
		model.addAttribute("countOrder", countOrder);
585 
		model.addAttribute("onlineDeliveredOrderSum", onlineDeliveredOrderSum.getSellingPrice());
25180 amit.gupta 586 
		boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
587 
		model.addAttribute("isAdmin", isAdmin);
23923 amit.gupta 588 
 
25274 amit.gupta 589 
		model.addAttribute("webApiHost", webApiHost);
590 
		model.addAttribute("webApiPort", webApiPort);
591 
		model.addAttribute("webApiScheme", webApiScheme);
25544 amit.gupta 592 
		model.addAttribute("webApiRoot", webApiRoot);
25183 amit.gupta 593 
		if (isAdmin) {
26011 amit.gupta 594 
			return adminPanel(loginDetails.getFofoId(), email, model);
25180 amit.gupta 595 
		} else {
25740 amit.gupta 596 
			FofoStore fofoStore = null;
25180 amit.gupta 597 
			try {
598 
				fofoStore = fofoStoreRepository.selectByRetailerId(loginDetails.getFofoId());
25544 amit.gupta 599 
				if (!fofoStore.isActive()) {
600 
					return "redirect:/login";
601 
				}
25649 tejbeer 602 
 
25740 amit.gupta 603 
				PartnerType partnerType = partnerTypeChangeService.getTypeOnDate(fofoStore.getId(), LocalDate.now());
25566 tejbeer 604 
				model.addAttribute("partnerType", partnerType);
25653 amit.gupta 605 
				model.addAttribute("partnerTypeImage", PartnerType.imageMap.get(partnerType));
25180 amit.gupta 606 
				model.addAttribute("fofoStore", fofoStore);
25566 tejbeer 607 
				model.addAttribute("partnerType", partnerType);
25180 amit.gupta 608 
				model.addAttribute("hasGift", hasGift(loginDetails.getFofoId()));
609 
				model.addAttribute("giftItemId", ProfitMandiConstants.GIFT_ID);
26222 tejbeer 610 
				model.addAttribute("retailers", new JSONObject().append("code", fofoStore.getCode())
26162 amit.gupta 611 
						.append("partnerId", fofoStore.getId()).toString());
26460 amit.gupta 612 
				model.addAttribute("activatedImeis",
613 
						inventoryItemRepository.selectCountByActivatedNotSold(loginDetails.getFofoId()));
26071 tejbeer 614 
				LocalDateTime curDate = LocalDate.now().atStartOfDay();
615 
				Map<Integer, Double> accesoriesmtdsale = fofoOrderRepository
616 
						.selectSumSaleGroupByFofoIdsForMobileOrAccessories(loginDetails.getFofoId(),
617 
								curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), Optional.of(false));
27701 tejbeer 618 
 
26071 tejbeer 619 
				Double accesoriesStock = currentInventorySnapshotRepository
620 
						.selectSumStockGroupByFofoIdsForMobileOrAccessories(loginDetails.getFofoId(),
621 
								Optional.of(false))
622 
						.get(loginDetails.getFofoId());
25180 amit.gupta 623 
 
26071 tejbeer 624 
				model.addAttribute("accesoriesStock", String.format("%.0f", accesoriesStock));
27702 tejbeer 625 
				model.addAttribute("brandStockPrices", this.getBrandStockPrices(loginDetails.getFofoId()));
25180 amit.gupta 626 
				model.addAttribute("salesMap", this.getSales(loginDetails.getFofoId()));
26055 tejbeer 627 
				ChartModel cm = this.getBrandChart(loginDetails.getFofoId());
628 
 
629 
				LOGGER.info("chartMap" + gson.toJson(cm));
630 
				model.addAttribute("chartMap", gson.toJson(cm));
27701 tejbeer 631 
 
27876 amit.gupta 632 
				List<CreateOfferRequest> publishedOffers = offerService.getPublishedOffers(loginDetails.getFofoId(),
633 
						YearMonth.from(LocalDateTime.now()));
634 
				model.addAttribute("publishedOffers", publishedOffers);
25180 amit.gupta 635 
				model.addAttribute("investments", this.getInvestments(loginDetails.getFofoId()));
25544 amit.gupta 636 
				model.addAttribute("isInvestmentOk", partnerInvestmentService.isInvestmentOk(loginDetails.getFofoId(),
637 
						10, ProfitMandiConstants.CUTOFF_INVESTMENT));
26460 amit.gupta 638 
 
25180 amit.gupta 639 
			} catch (ProfitMandiBusinessException e) {
640 
				LOGGER.error("FofoStore Code not found of fofoId {}", loginDetails.getFofoId());
641 
 
642 
			}
22481 ashik.ali 643 
		}
25649 tejbeer 644 
 
645 
		LocalDateTime currentMonthStart = LocalDateTime.now().withDayOfMonth(1);
25747 amit.gupta 646 
		LocalDateTime lastMonthStart = currentMonthStart.minusMonths(1);
25653 amit.gupta 647 
		LocalDateTime currentMonthEnd = currentMonthStart.plusMonths(1).withDayOfMonth(1);
648 
		double currentMonthRating = hygieneDataRepository.selectRatingAvg(loginDetails.getFofoId(), currentMonthStart,
25677 amit.gupta 649 
				currentMonthEnd) / 2;
25747 amit.gupta 650 
		double lastMonthRating = hygieneDataRepository.selectRatingAvg(loginDetails.getFofoId(), lastMonthStart,
651 
				currentMonthStart) / 2;
652 
		double ratingTillDate = hygieneDataRepository.selectRatingAvg(loginDetails.getFofoId(), LocalDateTime.MIN,
25677 amit.gupta 653 
				currentMonthEnd) / 2;
654 
		model.addAttribute("currentMonthRating", (float) Math.round(currentMonthRating * 10) / 10);
655 
		model.addAttribute("lastMonthRating", (float) Math.round(lastMonthRating * 10) / 10);
656 
		model.addAttribute("ratingTillDate", (float) Math.round(ratingTillDate * 10) / 10);
25649 tejbeer 657 
 
25653 amit.gupta 658 
		long hygieneCount = hygieneDataRepository.selectHygieneCount(loginDetails.getFofoId(), true, currentMonthStart,
659 
				currentMonthEnd);
25651 tejbeer 660 
 
25653 amit.gupta 661 
		long invalidHygieneCount = hygieneDataRepository.selectHygieneCount(loginDetails.getFofoId(), false,
662 
				currentMonthStart, currentMonthEnd);
663 
		if (hygieneCount == 0 && invalidHygieneCount == 0) {
664 
			invalidHygieneCount = 1;
665 
		}
28272 tejbeer 666 
		Map<Integer, String> monthValueMap = new HashMap<>();
667 
		for (int i = 0; i <= 5; i++) {
668 
			LocalDateTime startOfMonth = LocalDateTime.now().withDayOfMonth(1).minusMonths(i);
669 
			monthValueMap.put(i, startOfMonth.format(DateTimeFormatter.ofPattern("MMM''uu")));
670 
		}
28409 tejbeer 671 
 
672 
 
28272 tejbeer 673 
 
674 
		model.addAttribute("monthValueMap", monthValueMap);
675 
		model.addAttribute("month", 0);
676 
 
25653 amit.gupta 677 
		model.addAttribute("hygienePercentage", (hygieneCount * 100) / (invalidHygieneCount + hygieneCount));
25651 tejbeer 678 
 
25197 amit.gupta 679 
		model.addAttribute("monthDays", LocalDate.now().minusDays(1).lengthOfMonth());
680 
		model.addAttribute("dayOfMonth", LocalDate.now().minusDays(1).getDayOfMonth());
27884 tejbeer 681 
		/*
682 
		 * if (loginDetails.isReadOnly()) { return "dashboard-readonly"; } else { }
683 
		 */
28272 tejbeer 684 
 
685 
 
27882 amit.gupta 686 
		return "dashboard1";
28272 tejbeer 687 
 
21615 kshitij.so 688 
	}
23923 amit.gupta 689 
 
28272 tejbeer 690 
	@RequestMapping(value = "/getMonthsInvestment", method = RequestMethod.GET)
691 
	public String getMonthsInvestment(HttpServletRequest request,
692 
			@RequestParam(name = "month", required = true, defaultValue = "0") int month, Model model)
693 
			throws Exception {
694 
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
695 
		int fofoId = loginDetails.getFofoId();
696 
		Map<String, Object> investment = getInvestmentsMonths(fofoId, month);
697 
 
698 
 
699 
		LocalDateTime currentMonthStart = LocalDateTime.now().withDayOfMonth(1);
700 
		LocalDateTime lastMonthStart = currentMonthStart.minusMonths(1);
701 
		LocalDateTime currentMonthEnd = currentMonthStart.plusMonths(1).withDayOfMonth(1);
702 
		double currentMonthRating = hygieneDataRepository.selectRatingAvg(loginDetails.getFofoId(), currentMonthStart,
703 
				currentMonthEnd) / 2;
704 
		double lastMonthRating = hygieneDataRepository.selectRatingAvg(loginDetails.getFofoId(), lastMonthStart,
705 
				currentMonthStart) / 2;
706 
		double ratingTillDate = hygieneDataRepository.selectRatingAvg(loginDetails.getFofoId(), LocalDateTime.MIN,
707 
				currentMonthEnd) / 2;
708 
		model.addAttribute("currentMonthRating", (float) Math.round(currentMonthRating * 10) / 10);
709 
		model.addAttribute("lastMonthRating", (float) Math.round(lastMonthRating * 10) / 10);
710 
		model.addAttribute("ratingTillDate", (float) Math.round(ratingTillDate * 10) / 10);
711 
 
712 
		long hygieneCount = hygieneDataRepository.selectHygieneCount(loginDetails.getFofoId(), true, currentMonthStart.minusMonths(month),
713 
				currentMonthEnd.minusMonths(month));
714 
 
715 
		long invalidHygieneCount = hygieneDataRepository.selectHygieneCount(loginDetails.getFofoId(), false,
716 
				currentMonthStart.minusMonths(month),
717 
				currentMonthEnd.minusMonths(month));
718 
		if (hygieneCount == 0 && invalidHygieneCount == 0) {
719 
			invalidHygieneCount = 1;
720 
		}
721 
		Map<Integer, String> monthValueMap = new HashMap<>();
722 
		for (int i = 0; i <= 5; i++) {
723 
			LocalDateTime startOfMonth = LocalDateTime.now().withDayOfMonth(1).minusMonths(i);
724 
			monthValueMap.put(i, startOfMonth.format(DateTimeFormatter.ofPattern("MMM''uu")));
725 
		}
726 
		model.addAttribute("hygienePercentage", (hygieneCount * 100) / (invalidHygieneCount + hygieneCount));
727 
		model.addAttribute("monthValueMap" ,monthValueMap);
728 
		model.addAttribute("investments", investment);
729 
		model.addAttribute("monthDays", LocalDate.now().minusMonths(month).lengthOfMonth());
730 
		model.addAttribute("dayOfMonth", LocalDate.now().minusMonths(month).lengthOfMonth());
731 
		model.addAttribute("month",month);
732 
		return "performance";
733 
	}
734 
 
27884 tejbeer 735 
	@RequestMapping(value = "/investmentDetails", method = RequestMethod.GET)
736 
	public String getInvestmentDetails(HttpServletRequest request, Model model) throws Exception {
737 
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
738 
		int fofoId = loginDetails.getFofoId();
739 
		ChartInvestmentModel cm = this.getInvestmentChart(fofoId);
740 
		model.addAttribute("chartPieMap", gson.toJson(cm));
741 
 
742 
		LOGGER.info("InvestmentChart" + gson.toJson(cm));
743 
		LOGGER.info("InvestmentChart" + cm);
744 
		return "investmentdetails";
745 
	}
28409 tejbeer 746 
 
27884 tejbeer 747 
 
748 
	private ChartInvestmentModel getInvestmentChart(int fofoId) throws ProfitMandiBusinessException {
749 
		PartnerDailyInvestment investment = partnerInvestmentService.getInvestment(fofoId, 0);
27900 tejbeer 750 
 
27884 tejbeer 751 
		Map<String, Float> investmentWalletAmount = new HashMap<>();
752 
		investmentWalletAmount.put("Wallet", investment.getWalletAmount());
28272 tejbeer 753 
		investmentWalletAmount.put("InStocks", investment.getInStockAmount() - investment.getActivatedStockAmount());
27900 tejbeer 754 
		investmentWalletAmount.put("Unbilled Order", investment.getUnbilledAmount());
27884 tejbeer 755 
		investmentWalletAmount.put("GrnPending", investment.getGrnPendingAmount());
756 
		investmentWalletAmount.put("ReturnInTransit", investment.getReturnInTransitAmount());
757 
 
27900 tejbeer 758 
		if (investment.getShortInvestment() > 0) {
759 
			investmentWalletAmount.put("Short Investment", investment.getShortInvestment());
760 
		}
761 
 
27884 tejbeer 762 
		ChartInvestmentModel cm = new ChartInvestmentModel();
763 
 
764 
		HashSet<String> labels = new HashSet<String>();
765 
		labels.addAll(investmentWalletAmount.keySet());
766 
 
767 
		List<String> labelList = new ArrayList<>(labels);
768 
		List<String> backgroundColor = new ArrayList<>();
27900 tejbeer 769 
		List<Float> labelsValue = new ArrayList<>();
27884 tejbeer 770 
		List<Float> values = new ArrayList<>();
771 
		for (String label : labelList) {
772 
			values.add(investmentWalletAmount.get(label));
773 
			if (label.equals("Wallet")) {
774 
				backgroundColor.add("pink");
775 
			}
27900 tejbeer 776 
			if (label.equals("Short Investment")) {
777 
				backgroundColor.add("red");
778 
			}
28015 tejbeer 779 
			if (label.equals("InStocks")) {
27900 tejbeer 780 
				backgroundColor.add("#9ACD32");
27884 tejbeer 781 
			}
27900 tejbeer 782 
			if (label.equals("Unbilled Order")) {
783 
				backgroundColor.add("blue");
27884 tejbeer 784 
			}
785 
 
786 
			if (label.equals("ReturnInTransit")) {
787 
				backgroundColor.add("orange");
788 
			}
789 
			if (label.equals("GrnPending")) {
790 
				backgroundColor.add("yellow");
791 
			}
792 
 
793 
		}
794 
 
795 
		Data data = new Data();
796 
		data.setData(values);
797 
		data.setBackgroundColor(backgroundColor);
798 
		data.setLabel("DataSet 1");
799 
 
800 
		PieLables label = new PieLables();
801 
		label.setFontColor("White");
802 
		label.setFontSize(15);
803 
 
804 
		Legend legend = new Legend();
805 
		legend.setLabels(label);
806 
		legend.setPosition("left");
807 
 
808 
		List<Data> dataList = new ArrayList<>();
809 
		dataList.add(data);
810 
 
811 
		DataInvestmentModel datasets = new DataInvestmentModel();
812 
		datasets.setDatasets(dataList);
813 
		datasets.setLabels(labels);
814 
 
815 
		OptionModel om = new OptionModel();
816 
		om.setLegend(legend);
817 
		cm.setType("pie");
818 
		cm.setData(datasets);
819 
		cm.setOptions(om);
820 
 
821 
		return cm;
822 
	}
823 
 
26055 tejbeer 824 
	private ChartModel getBrandChart(int fofoId) {
825 
 
826 
		LocalDateTime curDate = LocalDate.now().atStartOfDay();
827 
 
828 
		LOGGER.info("cur Date" + curDate.withDayOfMonth(1));
829 
 
830 
		LOGGER.info("curDateYear" + curDate.with(LocalTime.MAX));
831 
 
27900 tejbeer 832 
		Map<String, Double> brandwisesale = fofoOrderItemRepository
26055 tejbeer 833 
				.selectSumAmountGroupByBrand(curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), fofoId);
26244 tejbeer 834 
 
27900 tejbeer 835 
		LOGGER.info("brandwisesale" + brandwisesale);
27884 tejbeer 836 
 
26244 tejbeer 837 
		Map<Integer, Double> accesoriesmtdsale = fofoOrderRepository.selectSumSaleGroupByFofoIdsForMobileOrAccessories(
838 
				fofoId, curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), Optional.of(false));
27900 tejbeer 839 
		brandwisesale.put("Accessories", accesoriesmtdsale.get(fofoId));
28272 tejbeer 840 
 
27884 tejbeer 841 
		Map<String, Double> activatedImeisWithSellingPriceMTD = fofoOrderRepository
842 
				.selectValueOfActivatedImeis(curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), fofoId).stream()
843 
				.collect(Collectors.toMap(x -> x.getBrand(), x -> (double) x.getSellingPrice()));
27900 tejbeer 844 
 
27978 tejbeer 845 
		activatedImeisWithSellingPriceMTD.put("Lava", brandwisesale.get("Lava"));
846 
 
27884 tejbeer 847 
		Map<String, Double> activatedImeisWithSellingPriceLMTD = fofoOrderRepository
848 
				.selectValueOfActivatedImeis(curDate.withDayOfMonth(1).minusMonths(1),
849 
						curDate.with(LocalTime.MAX).minusMonths(1), fofoId)
850 
				.stream().collect(Collectors.toMap(x -> x.getBrand(), x -> (double) x.getSellingPrice()));
26244 tejbeer 851 
 
26055 tejbeer 852 
		Map<String, Double> lmtdBrandWiseSale = fofoOrderItemRepository.selectSumAmountGroupByBrand(
853 
				curDate.withDayOfMonth(1).minusMonths(1), curDate.with(LocalTime.MAX).minusMonths(1), fofoId);
27978 tejbeer 854 
		activatedImeisWithSellingPriceLMTD.put("Lava", lmtdBrandWiseSale.get("Lava"));
26055 tejbeer 855 
 
26244 tejbeer 856 
		Map<Integer, Double> accesorieslmtdsale = fofoOrderRepository.selectSumSaleGroupByFofoIdsForMobileOrAccessories(
857 
				fofoId, curDate.withDayOfMonth(1).minusMonths(1), curDate.with(LocalTime.MAX).minusMonths(1),
858 
				Optional.of(false));
27884 tejbeer 859 
 
860 
		lmtdBrandWiseSale.put("Accessories", accesorieslmtdsale.get(fofoId));
861 
 
26055 tejbeer 862 
		ChartModel cm = new ChartModel();
863 
 
27884 tejbeer 864 
		HashSet<String> labels = new HashSet<String>();
27900 tejbeer 865 
		labels.addAll(brandwisesale.keySet());
27876 amit.gupta 866 
		labels.addAll(lmtdBrandWiseSale.keySet());
26055 tejbeer 867 
 
27884 tejbeer 868 
		List<String> labelList = new ArrayList<>(labels);
869 
 
870 
		List<Double> mtdActivatedImeisValues = new ArrayList<>();
871 
 
872 
		List<Double> mtdValues = new ArrayList<>();
873 
		List<Double> lmtdUnActivatedImeisValues = new ArrayList<>();
874 
		List<Double> lmtdActivatedImeisValues = new ArrayList<>();
875 
		List<Double> mtdUnActivatedImeisValues = new ArrayList<>();
26055 tejbeer 876 
		List<Double> lmtdValues = new ArrayList<>();
27884 tejbeer 877 
		for (String label : labelList) {
878 
			mtdActivatedImeisValues.add(activatedImeisWithSellingPriceMTD.get(label) == null ? 0
879 
					: activatedImeisWithSellingPriceMTD.get(label));
880 
			lmtdActivatedImeisValues.add(activatedImeisWithSellingPriceLMTD.get(label) == null ? 0
881 
					: activatedImeisWithSellingPriceLMTD.get(label));
26055 tejbeer 882 
 
27900 tejbeer 883 
			mtdValues.add(brandwisesale.get(label) == null ? 0 : brandwisesale.get(label));
884 
			if (brandwisesale.get(label) != null) {
27884 tejbeer 885 
				mtdUnActivatedImeisValues
27900 tejbeer 886 
						.add(brandwisesale.get(label) - (activatedImeisWithSellingPriceMTD.get(label) == null ? 0
27884 tejbeer 887 
								: activatedImeisWithSellingPriceMTD.get(label)));
888 
			} else {
889 
				mtdUnActivatedImeisValues.add(0.0);
890 
			}
891 
			if (lmtdBrandWiseSale.get(label) != null) {
892 
				lmtdUnActivatedImeisValues
893 
						.add(lmtdBrandWiseSale.get(label) - (activatedImeisWithSellingPriceLMTD.get(label) == null ? 0
894 
								: activatedImeisWithSellingPriceLMTD.get(label)));
895 
			} else {
896 
				lmtdUnActivatedImeisValues.add(0.0);
897 
			}
26055 tejbeer 898 
 
27884 tejbeer 899 
			lmtdValues.add(lmtdBrandWiseSale.get(label) == null ? 0 : lmtdBrandWiseSale.get(label));
900 
		}
901 
		DatasetModel dsmtotal = new DatasetModel();
902 
		dsmtotal.setLabel("MTD");
903 
		dsmtotal.setBackgroundColor("blue");
904 
		dsmtotal.setData(mtdValues);
905 
		dsmtotal.setStack("stack0");
27900 tejbeer 906 
		dsmtotal.setOrder(1);
26055 tejbeer 907 
 
27884 tejbeer 908 
		DatasetModel dsmUnactivated = new DatasetModel();
909 
		dsmUnactivated.setLabel("MTD Unactivated");
910 
		dsmUnactivated.setBackgroundColor("red");
911 
		dsmUnactivated.setData(mtdUnActivatedImeisValues);
912 
		dsmUnactivated.setStack("stack0");
27900 tejbeer 913 
		dsmUnactivated.setOrder(1);
27884 tejbeer 914 
 
915 
		LOGGER.info("mtdValuesMoney" + mtdValues);
916 
 
917 
		DatasetModel mtdActivatedImeis = new DatasetModel();
918 
		mtdActivatedImeis.setLabel("MTD Activation");
919 
		mtdActivatedImeis.setData(mtdActivatedImeisValues);
27913 tejbeer 920 
		mtdActivatedImeis.setBackgroundColor("#00008b");
27884 tejbeer 921 
		mtdActivatedImeis.setStack("stack0");
27900 tejbeer 922 
		mtdActivatedImeis.setOrder(1);
27884 tejbeer 923 
 
924 
		DatasetModel lmtddsmtotal = new DatasetModel();
925 
		lmtddsmtotal.setLabel("LMTD");
926 
		lmtddsmtotal.setBackgroundColor("blue");
927 
		lmtddsmtotal.setData(lmtdValues);
928 
		lmtddsmtotal.setStack("stack1");
27900 tejbeer 929 
		lmtddsmtotal.setOrder(1);
27884 tejbeer 930 
 
931 
		DatasetModel lmtdUnActivated = new DatasetModel();
932 
		lmtdUnActivated.setLabel("LMTD Unactivation");
933 
		lmtdUnActivated.setBackgroundColor("red");
934 
		lmtdUnActivated.setData(lmtdUnActivatedImeisValues);
935 
		lmtdUnActivated.setStack("stack1");
27900 tejbeer 936 
		lmtdUnActivated.setOrder(1);
27884 tejbeer 937 
 
938 
		DatasetModel LmtdActivatedImeis = new DatasetModel();
939 
		LmtdActivatedImeis.setLabel("LMTD Activation");
27910 tejbeer 940 
		LmtdActivatedImeis.setBackgroundColor("#87ceeb");
27884 tejbeer 941 
		LmtdActivatedImeis.setData(lmtdActivatedImeisValues);
942 
		LmtdActivatedImeis.setStack("stack1");
27900 tejbeer 943 
		LmtdActivatedImeis.setOrder(1);
27930 amit.gupta 944 
 
27900 tejbeer 945 
		DatasetModel linemtdChart = new DatasetModel();
946 
		linemtdChart.setLabel("MTD");
27915 tejbeer 947 
		linemtdChart.setBackgroundColor("#006400");
27930 amit.gupta 948 
 
27900 tejbeer 949 
		linemtdChart.setData(mtdValues);
950 
		linemtdChart.setType("line");
951 
		linemtdChart.setOrder(2);
27910 tejbeer 952 
		linemtdChart.setFill("false");
27930 amit.gupta 953 
 
27900 tejbeer 954 
		DatasetModel lineLmtdChart = new DatasetModel();
955 
		lineLmtdChart.setLabel("LMTD");
27978 tejbeer 956 
		lineLmtdChart.setBackgroundColor("hotpink");
27900 tejbeer 957 
		lineLmtdChart.setData(lmtdValues);
958 
		lineLmtdChart.setType("line");
27910 tejbeer 959 
		lineLmtdChart.setOrder(3);
960 
		lineLmtdChart.setFill("false");
27884 tejbeer 961 
 
26055 tejbeer 962 
		List<DatasetModel> datasets = new ArrayList<>();
27978 tejbeer 963 
		datasets.add(mtdActivatedImeis);
964 
		datasets.add(dsmUnactivated);
965 
		datasets.add(LmtdActivatedImeis);
27910 tejbeer 966 
		datasets.add(lmtdUnActivated);
27900 tejbeer 967 
		datasets.add(linemtdChart);
968 
		datasets.add(lineLmtdChart);
27884 tejbeer 969 
 
26055 tejbeer 970 
		DataModel dm = new DataModel();
971 
		dm.setDatasets(datasets);
972 
		dm.setLabels(labels);
973 
 
974 
		LegendModel lm = new LegendModel();
27703 amit.gupta 975 
		lm.setPosition("top");
26055 tejbeer 976 
 
977 
		TitleModel tm = new TitleModel();
27703 amit.gupta 978 
		tm.setText("Brand Wise Sales");
26055 tejbeer 979 
		tm.setDisplay(true);
980 
 
27884 tejbeer 981 
		List<Axis> xAxes = new ArrayList<>();
982 
		Axis xAxis = new Axis();
983 
		xAxis.setStacked(true);
984 
		xAxes.add(xAxis);
985 
 
986 
		List<Axis> yAxes = new ArrayList<>();
987 
		Axis yAxis = new Axis();
27910 tejbeer 988 
		yAxis.setStacked(false);
27884 tejbeer 989 
		yAxes.add(yAxis);
990 
 
991 
		ScalesModel sm = new ScalesModel();
992 
		sm.setxAxes(xAxes);
993 
 
26055 tejbeer 994 
		OptionsModel om = new OptionsModel();
995 
		om.setLegend(lm);
996 
		om.setTitle(tm);
27884 tejbeer 997 
		om.setScales(sm);
26055 tejbeer 998 
 
999 
		cm.setType("bar");
1000 
		cm.setData(dm);
1001 
		cm.setOptions(om);
1002 
 
27884 tejbeer 1003 
		LOGGER.info("cm" + cm);
1004 
 
26055 tejbeer 1005 
		return cm;
1006 
 
1007 
	}
1008 
 
26418 tejbeer 1009 
	private String adminPanel(int fofoId, String email, Model model) throws Exception {
26022 amit.gupta 1010 
		List<Menu> menus = null;
26011 amit.gupta 1011 
		try {
1012 
			AuthUser authUser = authRepository.selectByEmailOrMobile(email);
1013 
			List<Position> positions = positionRepository.selectAll(authUser.getId());
27545 tejbeer 1014 
			Map<Integer, PartnerDetailModel> warehousePartnerDetailMap = null;
27628 tejbeer 1015 
			ReporticoCacheTable rctSaholic = null;
1016 
			ReporticoCacheTable rctPartneStat = null;
1017 
 
27509 tejbeer 1018 
			Map<Integer, WarehouseWiseStockModel> warehouseStockMap = new HashMap<>();
27701 tejbeer 1019 
			LinkedHashMap<Integer, WarehouseWiseStockModel> warehouseStockSortedMap = new LinkedHashMap<>();
1020 
 
27509 tejbeer 1021 
			Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
27539 tejbeer 1022 
			LinkedHashMap<Integer, String> wm = new LinkedHashMap<Integer, String>();
27701 tejbeer 1023 
 
27670 tejbeer 1024 
			Map<String, BrandWisePartnerSaleModel> partnersBrandSaleMap = null;
27594 tejbeer 1025 
			List<BrandWisePartnerSaleModel> accessoriesBrandSales = null;
27701 tejbeer 1026 
 
27819 tejbeer 1027 
			Map<AuthUser, Long> authUserTicketCount = null;
1028 
 
27539 tejbeer 1029 
			for (Map.Entry<Integer, String> entry : warehouseMap.entrySet()) {
1030 
				wm.put(entry.getKey(), entry.getValue());
1031 
			}
1032 
 
1033 
			wm.put(0, "Total Values");
1034 
			long stockValue = 0;
1035 
			long stockQty = 0;
1036 
			long pendingIndent = 0;
27542 tejbeer 1037 
			long tertiary = 0;
26418 tejbeer 1038 
 
27701 tejbeer 1039 
			Map<String, Set<Integer>> storeGuyMap = csService.getAuthUserPartnerIdMapping();
27727 tejbeer 1040 
 
27701 tejbeer 1041 
			Set<Integer> fofoIds = storeGuyMap.get(authUser.getEmailId());
27727 tejbeer 1042 
			if (emails.contains(authUser.getEmailId())) {
1043 
				fofoIds = storeGuyMap.get("tarun.verma@smartdukaan.com");
27930 amit.gupta 1044 
				LOGGER.info("fofoIds" + fofoIds);
27727 tejbeer 1045 
			}
27556 tejbeer 1046 
 
27701 tejbeer 1047 
			if (fofoIds != null) {
27539 tejbeer 1048 
 
27701 tejbeer 1049 
				Map<Integer, List<Integer>> warehouseIdFofoIdMap = fofoStoreRepository
1050 
						.selectActivePartnersByRetailerIds(new ArrayList<>(fofoIds)).stream()
1051 
						.collect(Collectors.groupingBy(FofoStore::getWarehouseId,
1052 
								Collectors.mapping(FofoStore::getId, Collectors.toList())));
1053 
				// warehouseStock
1054 
				List<WarehouseWiseStockModel> warehouseStocks = saholicInventoryCISRepository
1055 
						.selectGroupByWarehouse(new ArrayList<>(warehouseIdFofoIdMap.keySet()));
1056 
 
1057 
				warehouseStockMap = warehouseStocks.stream().collect(Collectors.toMap(x -> x.getWarehouseId(), x -> x));
1058 
 
1059 
				if (!warehouseStockMap.isEmpty()) {
1060 
					for (Entry<Integer, WarehouseWiseStockModel> warehouseStock : warehouseStockMap.entrySet()) {
1061 
						stockValue += warehouseStock.getValue().getStockValue();
1062 
						stockQty += warehouseStock.getValue().getStockQty();
1063 
						pendingIndent += warehouseStock.getValue().getPendingIndent();
1064 
						tertiary += warehouseStock.getValue().getTertiary();
27539 tejbeer 1065 
					}
27701 tejbeer 1066 
					WarehouseWiseStockModel ws = new WarehouseWiseStockModel();
1067 
					ws.setStockQty(stockQty);
1068 
					ws.setStockValue(stockValue);
1069 
					ws.setPendingIndent(pendingIndent);
1070 
					ws.setTertiary(tertiary);
1071 
					ws.setWarehouseId(0);
1072 
					warehouseStockMap.put(0, ws);
27591 tejbeer 1073 
 
27701 tejbeer 1074 
				}
27670 tejbeer 1075 
 
27701 tejbeer 1076 
				warehouseStockMap.entrySet().stream().sorted(Map.Entry.comparingByKey(Comparator.reverseOrder()))
1077 
						.forEachOrdered(x -> warehouseStockSortedMap.put(x.getKey(), x.getValue()));
27670 tejbeer 1078 
 
27701 tejbeer 1079 
				rctSaholic = reporticoCacheTableRepository.selectByTableName("SaholicInventoryCIS");
1080 
 
1081 
				// warehouseStock
1082 
				warehousePartnerDetailMap = this.getWarehousePartnerDetail(warehouseIdFofoIdMap);
1083 
				rctPartneStat = reporticoCacheTableRepository.selectByTableName("partnerStat");
1084 
 
1085 
				partnersBrandSaleMap = fofoStoreRepository
1086 
						.selectGroupByBrandWarehousePartnerSale(new ArrayList<>(fofoIds)).stream()
1087 
						.collect(Collectors.toMap(x -> x.getBrand(), x -> x));
1088 
 
1089 
				List<BrandWiseUnbilledActivateStockModel> unbilledActivatedStock = fofoStoreRepository
1090 
						.selectUnbilledActivateStockGroupByBrand(new ArrayList<>(fofoIds));
1091 
				for (BrandWiseUnbilledActivateStockModel un : unbilledActivatedStock) {
1092 
					BrandWisePartnerSaleModel bpt = partnersBrandSaleMap.get(un.getBrand());
1093 
					if (bpt != null) {
1094 
						bpt.setAmtd(un.getUnbilledMtd());
1095 
						bpt.setUamtdQty(un.getUnbilledMTDQty());
1096 
					} else {
1097 
						bpt = new BrandWisePartnerSaleModel();
1098 
						bpt.setBrand(un.getBrand());
1099 
						bpt.setAmtd(un.getUnbilledMtd());
1100 
						bpt.setUamtdQty(un.getUnbilledMTDQty());
1101 
						bpt.setLms(0);
1102 
						bpt.setLmtd(0);
1103 
						bpt.setMtd(0);
1104 
						bpt.setMtdQty(0);
1105 
						bpt.setLmtd(0);
1106 
						bpt.setLmtdQty(0);
1107 
						partnersBrandSaleMap.put(un.getBrand(), bpt);
27670 tejbeer 1108 
					}
26418 tejbeer 1109 
				}
27701 tejbeer 1110 
				accessoriesBrandSales = fofoStoreRepository
1111 
						.selectGroupByBrandAccesoriesWarehousePartnerSale(new ArrayList<>(fofoIds));
28272 tejbeer 1112 
				Set<CustomRetailer> positionRetailers = fofoIds.stream()
1113 
						.map(x -> retailerService.getAllFofoRetailers().get(x)).filter(x -> x != null)
1114 
						.collect(Collectors.toSet());
27931 amit.gupta 1115 
				model.addAttribute("retailers", gson.toJson(positionRetailers));
1116 
				model.addAttribute("reporticoProjectMap", ReporticoProject.salesReporticoProjectMap);
1117 
				model.addAttribute("warehouses", getWarehouses(positionRetailers));
26418 tejbeer 1118 
			}
1119 
 
27819 tejbeer 1120 
			if (positions.size() > 0) {
1121 
				if (positions.stream()
1122 
						.filter(x -> x.getEscalationType().equals(EscalationType.L3)
1123 
								|| x.getEscalationType().equals(EscalationType.L4)
1124 
								|| x.getEscalationType().equals(EscalationType.L5))
1125 
						.count() > 0) {
1126 
					authUserTicketCount = ticketRepository.selectAllAuthUserTicketCount(Optional.of(false));
1127 
				}
1128 
			}
1129 
 
27415 tejbeer 1130 
			if (Arrays.asList("amit.gupta@shop2020.in", "tejbeer.kaur@shop2020.in", "manish.tiwari@smartdukaan.com")
27701 tejbeer 1131 
					.contains(email))
1132 
 
1133 
			{
26029 amit.gupta 1134 
				menus = menuRepository.selectAll();
1135 
			} else if (positions.size() > 0) {
27108 amit.gupta 1136 
				if (positions.stream().filter(x -> x.getEscalationType().equals(EscalationType.L5)).count() > 0) {
26028 amit.gupta 1137 
					menus = menuRepository.selectAll();
27893 tejbeer 1138 
				} else {
1139 
					List<Integer> menuIds = menuCategoryRepository.selectAllByPositions(positions).stream()
1140 
							.map(x -> x.getMenuId()).collect(Collectors.toList());
1141 
					if (menuIds.size() > 0) {
1142 
						menus = menuRepository.selectAllByIds(menuIds);
26028 amit.gupta 1143 
					}
26022 amit.gupta 1144 
				}
27930 amit.gupta 1145 
			}
28272 tejbeer 1146 
			/*
1147 
			 * List<Position> salesPositions = positions.stream() .filter(x ->
1148 
			 * x.getCategoryId() == ProfitMandiConstants.TICKET_CATEGORY_SALES)
1149 
			 * .collect(Collectors.toList()); if (salesPositions.size() > 0) {
1150 
			 * Set<CustomRetailer> positionRetailers = new HashSet<>();
1151 
			 * csService.getPositionCustomRetailerMap(salesPositions).values().forEach(
1152 
			 * customRetailers -> { positionRetailers.addAll(customRetailers); }); }
1153 
			 */
1154 
			if (fofoIds == null) {
1155 
				List<Position> warehousePositions = positions.stream()
1156 
						.filter(x -> x.getCategoryId() == ProfitMandiConstants.TICKET_CATEGORY_WAREHOUSE)
26090 amit.gupta 1157 
						.collect(Collectors.toList());
28272 tejbeer 1158 
				if (warehousePositions.size() > 0) {
26090 amit.gupta 1159 
					Set<CustomRetailer> positionRetailers = new HashSet<>();
28272 tejbeer 1160 
					csService.getPositionCustomRetailerMap(warehousePositions).values().forEach(customRetailers -> {
26090 amit.gupta 1161 
						positionRetailers.addAll(customRetailers);
1162 
					});
28272 tejbeer 1163 
					model.addAttribute("reporticoProjectMap", ReporticoProject.warehouseReporticoMap);
1164 
					model.addAttribute("retailers", gson.toJson(positionRetailers));
1165 
					model.addAttribute("warehouses", getWarehouses(positionRetailers));
26090 amit.gupta 1166 
				}
28272 tejbeer 1167 
			}
1168 
			model.addAttribute("authId", authUser.getId());
26028 amit.gupta 1169 
 
27628 tejbeer 1170 
			model.addAttribute("rctPartneStat", rctPartneStat);
1171 
 
1172 
			model.addAttribute("reporticoDate", rctSaholic);
27545 tejbeer 1173 
			model.addAttribute("warehousePartnerDetailMap", warehousePartnerDetailMap);
27539 tejbeer 1174 
			model.addAttribute("warehouseMap", wm);
27819 tejbeer 1175 
 
1176 
			model.addAttribute("authUserTicketCount", authUserTicketCount);
27701 tejbeer 1177 
			model.addAttribute("warehouseStockMap", warehouseStockSortedMap);
27670 tejbeer 1178 
			model.addAttribute("brandSalesMap", partnersBrandSaleMap);
27556 tejbeer 1179 
 
27594 tejbeer 1180 
			model.addAttribute("accessoriesBrandSales", accessoriesBrandSales);
1181 
 
26012 amit.gupta 1182 
		} catch (ProfitMandiBusinessException e) {
26011 amit.gupta 1183 
		}
26028 amit.gupta 1184 
		List<Menu> menuList = (menus != null) ? this.prepareMenu(menus) : new ArrayList<>();
26422 tejbeer 1185 
		LOGGER.info("menu" + menuList);
26022 amit.gupta 1186 
		model.addAttribute("menu", menuList);
26012 amit.gupta 1187 
		return "admin";
1188 
	}
1189 
 
26468 amit.gupta 1190 
	@RequestMapping(value = "/getAuthUserPartners", method = RequestMethod.GET)
26418 tejbeer 1191 
	public String AuthUserPartnersDetail(HttpServletRequest request, Model model, @RequestParam int authId)
1192 
			throws Exception {
1193 
 
1194 
		Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
26963 amit.gupta 1195 
		Map<Integer, CustomRetailer> fofoIdAndPartnerMap = retailerService.getFofoRetailers(false);
26418 tejbeer 1196 
 
26468 amit.gupta 1197 
		Map<Integer, PartnerDetailModel> fofoIdAndallValues = partnerStatsService.getAllPartnerStats();
1198 
		if (authId != 0) {
1199 
			List<Integer> fofoIds = pp.get(authId);
1200 
			fofoIdAndallValues = fofoIdAndallValues.entrySet().stream().filter(x -> fofoIds.contains(x.getKey()))
1201 
					.collect(Collectors.toMap(x -> x.getKey(), x -> x.getValue()));
26474 amit.gupta 1202 
		} else {
26418 tejbeer 1203 
		}
1204 
 
1205 
		model.addAttribute("fofoIdAndallValues", fofoIdAndallValues);
1206 
		model.addAttribute("fofoIdAndPartnerMap", fofoIdAndPartnerMap);
1207 
 
1208 
		return "auth_user_partner_detail";
26468 amit.gupta 1209 
	}
26418 tejbeer 1210 
 
27545 tejbeer 1211 
	@RequestMapping(value = "/getWarehousePartners", method = RequestMethod.GET)
1212 
	public String warehousePartnersDetail(HttpServletRequest request, Model model, @RequestParam int warehouseId)
1213 
			throws Exception {
27701 tejbeer 1214 
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1215 
		String email = loginDetails.getEmailId();
1216 
		Map<String, Set<Integer>> storeGuyMap = csService.getAuthUserPartnerIdMapping();
1217 
		Set<Integer> authfofoIds = storeGuyMap.get(email);
27545 tejbeer 1218 
 
27701 tejbeer 1219 
		Map<Integer, List<Integer>> warehouseIdFofoIdMap = fofoStoreRepository
1220 
				.selectActivePartnersByRetailerIds(new ArrayList<>(authfofoIds)).stream().collect(Collectors.groupingBy(
1221 
						FofoStore::getWarehouseId, Collectors.mapping(FofoStore::getId, Collectors.toList())));
1222 
 
27545 tejbeer 1223 
		Map<Integer, CustomRetailer> fofoIdAndPartnerMap = retailerService.getFofoRetailers(false);
27628 tejbeer 1224 
		Map<Integer, PartnerDetailModel> fofoIdAndallValues = this.getPartnersStatDataFromFile();
27545 tejbeer 1225 
		if (warehouseId != 0) {
27701 tejbeer 1226 
			List<Integer> fofoIds = warehouseIdFofoIdMap.get(warehouseId);
1227 
			/*
1228 
			 * List<Integer> fofoIds =
1229 
			 * fofoStoreRepository.selectActivePartnerByWarehouse(warehouseId).stream()
1230 
			 * .map(x -> x.getId()).collect(Collectors.toList());
1231 
			 */
27545 tejbeer 1232 
			fofoIdAndallValues = fofoIdAndallValues.entrySet().stream().filter(x -> fofoIds.contains(x.getKey()))
1233 
					.collect(Collectors.toMap(x -> x.getKey(), x -> x.getValue()));
1234 
		} else {
27701 tejbeer 1235 
			fofoIdAndallValues = fofoIdAndallValues.entrySet().stream()
1236 
					.filter(x -> new ArrayList<>(authfofoIds).contains(x.getKey()))
1237 
					.collect(Collectors.toMap(x -> x.getKey(), x -> x.getValue()));
27545 tejbeer 1238 
		}
1239 
 
1240 
		model.addAttribute("fofoIdAndallValues", fofoIdAndallValues);
1241 
		model.addAttribute("fofoIdAndPartnerMap", fofoIdAndPartnerMap);
1242 
 
1243 
		return "auth_user_partner_detail";
1244 
	}
1245 
 
27509 tejbeer 1246 
	@RequestMapping(value = "/getWarehouseWiseBrandStock", method = RequestMethod.GET)
27701 tejbeer 1247 
	public String getWarehouseWiseBrandStock(HttpServletRequest request, Model model,
1248 
			@RequestParam List<Integer> warehouseId) throws Exception {
1249 
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1250 
		String email = loginDetails.getEmailId();
1251 
		Map<String, Set<Integer>> storeGuyMap = csService.getAuthUserPartnerIdMapping();
1252 
		Set<Integer> authfofoIds = storeGuyMap.get(email);
27509 tejbeer 1253 
 
27701 tejbeer 1254 
		Map<Integer, List<Integer>> warehouseIdFofoIdMap = fofoStoreRepository
1255 
				.selectActivePartnersByRetailerIds(new ArrayList<>(authfofoIds)).stream().collect(Collectors.groupingBy(
1256 
						FofoStore::getWarehouseId, Collectors.mapping(FofoStore::getId, Collectors.toList())));
1257 
		List<WarehouseWiseBrandStockModel> warehouseWiseBrandStock = new ArrayList<>();
1258 
		if (!warehouseId.contains(0)) {
1259 
			warehouseWiseBrandStock = saholicInventoryCISRepository.selectGroupByWarehouseAndBrand(warehouseId);
1260 
		} else {
1261 
			LOGGER.info("warehouseIdFofoIdMap" + warehouseIdFofoIdMap.keySet());
1262 
			warehouseWiseBrandStock = saholicInventoryCISRepository
1263 
					.selectGroupByWarehouseAndBrand(new ArrayList<>(warehouseIdFofoIdMap.keySet()));
1264 
 
1265 
		}
27542 tejbeer 1266 
		Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
27509 tejbeer 1267 
		model.addAttribute("warehouseWiseBrandStock", warehouseWiseBrandStock);
27542 tejbeer 1268 
		model.addAttribute("warehouseId", warehouseId);
27509 tejbeer 1269 
		model.addAttribute("warehouseMap", warehouseMap);
27660 tejbeer 1270 
 
27509 tejbeer 1271 
		return "warehouse_brand_stock";
1272 
	}
1273 
 
27529 tejbeer 1274 
	@RequestMapping(value = "/getWarehouseWiseData", method = RequestMethod.GET)
1275 
	public String getWarehouseWiseData(HttpServletRequest request, Model model) throws Exception {
1276 
		inventoryService.getItemAvailabilityAndIndent();
1277 
		model.addAttribute("response", mvcResponseSender.createResponseString(true));
1278 
		return "response";
1279 
	}
1280 
 
27701 tejbeer 1281 
	public Map<Integer, PartnerDetailModel> getWarehousePartnerDetail(Map<Integer, List<Integer>> warehousePartnerMap)
1282 
			throws Exception {
27628 tejbeer 1283 
 
1284 
		Map<Integer, PartnerDetailModel> warehouseIdAndallValues = new LinkedHashMap<>();
27701 tejbeer 1285 
		// Map<Integer, List<FofoStore>> warehousePartnerMap =
1286 
		// fofoStoreRepository.getWarehousePartnerMap();
27628 tejbeer 1287 
		Map<Integer, PartnerDetailModel> partnerStats = this.getPartnersStatDataFromFile();
27701 tejbeer 1288 
		List<Integer> allfofoIds = new ArrayList<>();
27628 tejbeer 1289 
		if (partnerStats != null) {
27701 tejbeer 1290 
			for (Entry<Integer, List<Integer>> warehouse : warehousePartnerMap.entrySet()) {
1291 
				List<Integer> fofoIds = warehouse.getValue().stream().map(x -> x).collect(Collectors.toList());
1292 
				allfofoIds.addAll(fofoIds);
27628 tejbeer 1293 
				List<PartnerDetailModel> partnerDetails = fofoIds.stream().map(x -> partnerStats.get(x))
1294 
						.collect(Collectors.toList());
27634 tejbeer 1295 
				if (partnerDetails != null && !partnerDetails.isEmpty()) {
1296 
					PartnerDetailModel partnerDetailModel = partnerStatsService.getAggregateStats(partnerDetails);
1297 
					warehouseIdAndallValues.put(warehouse.getKey(), partnerDetailModel);
1298 
				}
27628 tejbeer 1299 
 
1300 
			}
27701 tejbeer 1301 
			List<PartnerDetailModel> allPartnerDetails = allfofoIds.stream().map(x -> partnerStats.get(x))
1302 
					.collect(Collectors.toList());
1303 
			LOGGER.info("allPartnerDetails" + allPartnerDetails);
27628 tejbeer 1304 
			PartnerDetailModel partnerDetailModel = partnerStatsService
27701 tejbeer 1305 
					.getAggregateStats(new ArrayList<>(allPartnerDetails));
27628 tejbeer 1306 
			warehouseIdAndallValues.put(0, partnerDetailModel);
1307 
		}
1308 
		return warehouseIdAndallValues;
1309 
	}
1310 
 
1311 
	@RequestMapping(value = "/getPartnersStatData", method = RequestMethod.GET)
1312 
	public String getPartnersStatData(HttpServletRequest request, Model model) throws Exception {
1313 
		Map<Integer, PartnerDetailModel> partnerStats = partnerStatsService.getAllPartnerStats();
1314 
		ObjectOutputStream oos = null;
1315 
		FileOutputStream fout = null;
1316 
		try {
1317 
			fout = new FileOutputStream("/tmp/partnerStat.tmp", false);
1318 
			oos = new ObjectOutputStream(fout);
1319 
			oos.writeObject(partnerStats);
1320 
 
1321 
		} catch (Exception ex) {
1322 
			ex.printStackTrace();
1323 
		} finally {
1324 
			if (oos != null) {
1325 
				oos.close();
1326 
			}
1327 
		}
1328 
		ReporticoCacheTable rct = reporticoCacheTableRepository.selectByTableName("partnerStat");
1329 
		if (rct == null) {
1330 
			rct = new ReporticoCacheTable();
1331 
			rct.setTableName("partnerStat");
1332 
 
1333 
		}
1334 
		rct.setLastCreatedTimestamp(LocalDateTime.now());
1335 
		reporticoCacheTableRepository.persist(rct);
1336 
		model.addAttribute("response", mvcResponseSender.createResponseString(true));
1337 
		return "response";
1338 
	}
1339 
 
1340 
	public Map<Integer, PartnerDetailModel> getPartnersStatDataFromFile() throws Exception {
1341 
		ObjectInputStream objectinputstream = null;
1342 
		Map<Integer, PartnerDetailModel> partnerStat = null;
1343 
		try {
1344 
			FileInputStream streamIn = new FileInputStream("/tmp/partnerStat.tmp");
1345 
			objectinputstream = new ObjectInputStream(streamIn);
1346 
			partnerStat = (Map<Integer, PartnerDetailModel>) objectinputstream.readObject();
1347 
 
1348 
			LOGGER.info("partnerStat" + partnerStat);
1349 
			objectinputstream.close();
1350 
 
1351 
		} catch (Exception e) {
1352 
			LOGGER.info("exceptionddd" + e);
1353 
 
1354 
			e.printStackTrace();
1355 
 
1356 
		} finally {
1357 
			if (objectinputstream != null) {
1358 
				objectinputstream.close();
1359 
				LOGGER.info("clofddd" + partnerStat);
1360 
 
1361 
			}
1362 
		}
1363 
		return partnerStat;
1364 
 
1365 
	}
1366 
 
27539 tejbeer 1367 
	@RequestMapping(value = "/getWarehouseWiseBrandAndCategory", method = RequestMethod.GET)
1368 
	public String getWarehouseWiseBrandAndCategory(HttpServletRequest request, Model model,
27538 tejbeer 1369 
			@RequestParam List<Integer> warehouseId, @RequestParam List<String> brands, @RequestParam String category)
1370 
			throws Exception {
27509 tejbeer 1371 
 
1372 
		Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
27529 tejbeer 1373 
		List<String> listbrands = saholicInventoryCISRepository.selectAllBrand();
27538 tejbeer 1374 
		List<String> listCategory = saholicInventoryCISRepository.selectAllSubCategory();
27539 tejbeer 1375 
 
27509 tejbeer 1376 
		model.addAttribute("warehouseMap", warehouseMap);
27529 tejbeer 1377 
		model.addAttribute("brands", listbrands);
27538 tejbeer 1378 
		model.addAttribute("listCategory", listCategory);
1379 
 
27529 tejbeer 1380 
		model.addAttribute("selectedBrand", brands);
27538 tejbeer 1381 
		model.addAttribute("selectedWarehouse", warehouseId);
27539 tejbeer 1382 
		model.addAttribute("selectedCategory", category);
1383 
 
27509 tejbeer 1384 
		return "warehouse_brand_item_stock";
1385 
	}
1386 
 
27538 tejbeer 1387 
	@RequestMapping(value = "/getWarehouseWiseItemStock", method = RequestMethod.GET)
1388 
	public String getWarehouseWiseItemStock(HttpServletRequest request, Model model,
1389 
			@RequestParam List<Integer> warehouseId, @RequestParam List<String> brands, @RequestParam String category)
1390 
			throws Exception {
27539 tejbeer 1391 
		Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
1392 
		if (warehouseId.contains(0)) {
1393 
			warehouseId.addAll(warehouseMap.keySet());
1394 
		}
27538 tejbeer 1395 
		List<WarehouseWiseitemStockModel> warehouseWiseItemStock = saholicInventoryCISRepository
1396 
				.selectWarehouseItemStock(warehouseId, brands, category);
27539 tejbeer 1397 
 
27538 tejbeer 1398 
		model.addAttribute("warehouseWiseItemStock", warehouseWiseItemStock);
1399 
		model.addAttribute("warehouseMap", warehouseMap);
1400 
		return "warehouse_item_details";
1401 
	}
1402 
 
26114 amit.gupta 1403 
	private String getWarehouses(Set<CustomRetailer> positionRetailers) {
1404 
		Map<Integer, String> warehouses = new HashMap<>();
26222 tejbeer 1405 
		positionRetailers.stream().forEach(x -> {
1406 
			if (x.getWarehouseId() != 0) {
26171 amit.gupta 1407 
				warehouses.put(x.getWarehouseId(), ProfitMandiConstants.WAREHOUSE_MAP.get(x.getWarehouseId()));
1408 
			}
1409 
		});
26114 amit.gupta 1410 
		return gson.toJson(warehouses);
1411 
 
1412 
	}
1413 
 
27556 tejbeer 1414 
	@RequestMapping(value = "/getWarehouseWiseBrandPartnerSale", method = RequestMethod.GET)
27591 tejbeer 1415 
	public String getWarehouseWiseBrandPartnerSale(HttpServletRequest request, Model model, @RequestParam String brand)
1416 
			throws Exception {
27701 tejbeer 1417 
 
1418 
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1419 
		String email = loginDetails.getEmailId();
1420 
		Map<String, Set<Integer>> storeGuyMap = csService.getAuthUserPartnerIdMapping();
1421 
		Set<Integer> authfofoIds = storeGuyMap.get(email);
1422 
 
27670 tejbeer 1423 
		Map<Integer, WarehouseWiseBrandSaleModel> warehouseWiseBrandPartnerSales = fofoStoreRepository
27701 tejbeer 1424 
				.selectGroupByWarehouseBrandWisePartnerSale(brand, new ArrayList<>(authfofoIds)).stream()
27670 tejbeer 1425 
				.collect(Collectors.toMap(x -> x.getWarehouseId(), x -> x));
1426 
 
1427 
		List<WarehouseWiseBrandUnbilledActivatedModel> unbilledStock = fofoStoreRepository
27701 tejbeer 1428 
				.selectUnbilledActivateStockGroupByWarehouse(brand, new ArrayList<>(authfofoIds));
27670 tejbeer 1429 
 
1430 
		for (WarehouseWiseBrandUnbilledActivatedModel un : unbilledStock) {
1431 
			WarehouseWiseBrandSaleModel bpt = warehouseWiseBrandPartnerSales.get(un.getWarehouseId());
1432 
			if (bpt != null) {
1433 
				bpt.setAmtd(un.getUnbilledMtd());
27676 tejbeer 1434 
				bpt.setUamtdQty(un.getUnbilledQty());
27670 tejbeer 1435 
			} else {
1436 
				bpt = new WarehouseWiseBrandSaleModel();
1437 
				bpt.setWarehouseId(un.getWarehouseId());
1438 
				bpt.setAmtd(un.getUnbilledMtd());
27677 tejbeer 1439 
				bpt.setUamtdQty(un.getUnbilledQty());
27670 tejbeer 1440 
				bpt.setLms(0);
1441 
				bpt.setLmtd(0);
1442 
				bpt.setMtd(0);
1443 
				bpt.setMtdQty(0);
1444 
				bpt.setLmtd(0);
1445 
				bpt.setLmtdQty(0);
1446 
				warehouseWiseBrandPartnerSales.put(un.getWarehouseId(), bpt);
1447 
			}
1448 
		}
27556 tejbeer 1449 
		Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
27591 tejbeer 1450 
 
1451 
		Set<String> brands = inventoryService.getAllTagListingBrands();
1452 
		model.addAttribute("warehouseWiseBrandPartnerSales", warehouseWiseBrandPartnerSales);
27556 tejbeer 1453 
		model.addAttribute("warehouseMap", warehouseMap);
27591 tejbeer 1454 
		model.addAttribute("brands", brands);
1455 
		model.addAttribute("selectedbrand", brand);
1456 
		return "warehousewise_brand_partners_sale";
27556 tejbeer 1457 
	}
1458 
 
27594 tejbeer 1459 
	@RequestMapping(value = "/getWarehouseWiseAccesoriesBrandPartnerSale", method = RequestMethod.GET)
1460 
	public String getWarehouseWiseAccesoriesBrandPartnerSale(HttpServletRequest request, Model model,
1461 
			@RequestParam String brand) throws Exception {
27701 tejbeer 1462 
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1463 
		String email = loginDetails.getEmailId();
1464 
		Map<String, Set<Integer>> storeGuyMap = csService.getAuthUserPartnerIdMapping();
1465 
		Set<Integer> authfofoIds = storeGuyMap.get(email);
27594 tejbeer 1466 
		List<WarehouseWiseBrandSaleModel> warehouseWiseBrandPartnerSales = fofoStoreRepository
27701 tejbeer 1467 
				.selectGroupByWarehouseAccesoriesBrandWisePartnerSale(brand, new ArrayList<>(authfofoIds));
27594 tejbeer 1468 
		Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
1469 
 
1470 
		Set<String> brands = inventoryService.getAllTagListingBrands();
1471 
		model.addAttribute("warehouseWiseBrandPartnerSales", warehouseWiseBrandPartnerSales);
1472 
		model.addAttribute("warehouseMap", warehouseMap);
1473 
		model.addAttribute("brands", brands);
1474 
		model.addAttribute("selectedbrand", brand);
1475 
		return "warehousewise_accessoriesbrand_sale";
1476 
	}
1477 
 
27556 tejbeer 1478 
	@RequestMapping(value = "/getWarehouseBrandWiseItemSale", method = RequestMethod.GET)
1479 
	public String getWarehouseBrandWiseItemSale(HttpServletRequest request, Model model,
1480 
			@RequestParam List<Integer> warehouseId, @RequestParam String brand) throws Exception {
1481 
		Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
27701 tejbeer 1482 
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1483 
		String email = loginDetails.getEmailId();
1484 
		Map<String, Set<Integer>> storeGuyMap = csService.getAuthUserPartnerIdMapping();
1485 
		Set<Integer> authfofoIds = storeGuyMap.get(email);
27670 tejbeer 1486 
		Map<Integer, WarehouseBrandWiseItemSaleModel> branditemSalesMap = fofoStoreRepository
27701 tejbeer 1487 
				.selectWarehouseBrandItemSale(warehouseId, brand, new ArrayList<>(authfofoIds)).stream()
27670 tejbeer 1488 
				.collect(Collectors.toMap(x -> x.getItemId(), x -> x));
1489 
 
1490 
		List<WarehouseBrandItemUnbilledActivatedModel> unbilledItems = fofoStoreRepository
27701 tejbeer 1491 
				.selectWarehouseBrandItemUnbilledActivateStock(warehouseId, brand, new ArrayList<>(authfofoIds));
27670 tejbeer 1492 
 
1493 
		for (WarehouseBrandItemUnbilledActivatedModel un : unbilledItems) {
1494 
			WarehouseBrandWiseItemSaleModel bpt = branditemSalesMap.get(un.getItemId());
1495 
			if (bpt != null) {
1496 
				bpt.setAmtd(un.getAmtd());
27676 tejbeer 1497 
				bpt.setUamtdQty(un.getUnmtdQty());
27670 tejbeer 1498 
			} else {
1499 
				bpt = new WarehouseBrandWiseItemSaleModel();
1500 
				bpt.setWarehouseId(un.getWarehouseId());
1501 
				bpt.setItemId(un.getItemId());
1502 
				bpt.setAmtd(un.getAmtd());
27677 tejbeer 1503 
				bpt.setUamtdQty(un.getUnmtdQty());
27670 tejbeer 1504 
				bpt.setBrand(un.getBrand());
1505 
				bpt.setModelName(un.getModelName());
1506 
				bpt.setModelNumber(un.getModelNumber());
1507 
				bpt.setColor(un.getColor());
1508 
				bpt.setLms(0);
1509 
				bpt.setLmtd(0);
1510 
				bpt.setMtd(0);
1511 
				bpt.setMtdQty(0);
1512 
				bpt.setLmtd(0);
1513 
				bpt.setLmtdQty(0);
1514 
				branditemSalesMap.put(un.getItemId(), bpt);
1515 
			}
1516 
		}
1517 
		model.addAttribute("branditemSales", branditemSalesMap);
27556 tejbeer 1518 
		model.addAttribute("warehouseMap", warehouseMap);
1519 
		return "warehouse_partner_itemwise_sale";
1520 
	}
1521 
 
27594 tejbeer 1522 
	@RequestMapping(value = "/getWarehouseAccesoriesBrandWiseItemSale", method = RequestMethod.GET)
1523 
	public String getWarehouseAccesoriesBrandWiseItemSale(HttpServletRequest request, Model model,
1524 
			@RequestParam List<Integer> warehouseId, @RequestParam String brand) throws Exception {
1525 
		Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
27701 tejbeer 1526 
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1527 
		String email = loginDetails.getEmailId();
1528 
		Map<String, Set<Integer>> storeGuyMap = csService.getAuthUserPartnerIdMapping();
1529 
		Set<Integer> authfofoIds = storeGuyMap.get(email);
27594 tejbeer 1530 
		List<WarehouseBrandWiseItemSaleModel> branditemSales = fofoStoreRepository
27701 tejbeer 1531 
				.selectWarehouseAccesoriesBrandItemSale(warehouseId, brand, new ArrayList<>(authfofoIds));
27594 tejbeer 1532 
		model.addAttribute("branditemSales", branditemSales);
1533 
		model.addAttribute("warehouseMap", warehouseMap);
1534 
		return "warehouse_accessories_itemwsie_sale";
1535 
	}
1536 
 
26012 amit.gupta 1537 
	private List<Menu> prepareMenu(List<Menu> menus) {
1538 
		List<Menu> returnMenu = new ArrayList<>();
1539 
		Map<Menu, List<Menu>> subMenuMap = new HashMap<Menu, List<Menu>>();
1540 
		for (Menu menu : menus) {
1541 
			if (menu.get_parent() == null) {
26014 amit.gupta 1542 
				if (!subMenuMap.containsKey(menu)) {
26012 amit.gupta 1543 
					subMenuMap.put(menu, new ArrayList<>());
26011 amit.gupta 1544 
				}
1545 
			} else {
26012 amit.gupta 1546 
				Menu parentMenu = menu.get_parent();
1547 
				if (!subMenuMap.containsKey(parentMenu)) {
1548 
					subMenuMap.put(parentMenu, new ArrayList<>());
26011 amit.gupta 1549 
				}
26012 amit.gupta 1550 
				subMenuMap.get(parentMenu).add(menu);
26011 amit.gupta 1551 
			}
1552 
		}
26012 amit.gupta 1553 
		subMenuMap.entrySet().stream().forEach(entry -> {
1554 
			entry.getKey().setSubMenus(entry.getValue());
1555 
			returnMenu.add(entry.getKey());
1556 
		});
1557 
		return returnMenu;
26005 amit.gupta 1558 
	}
1559 
 
24288 amit.gupta 1560 
	// This method is currently hardcoded to faciliate watches sold as gift.
24203 amit.gupta 1561 
	private boolean hasGift(int fofoId) {
1562 
		try {
24288 amit.gupta 1563 
			return currentInventorySnapshotRepository.selectByItemIdAndFofoId(ProfitMandiConstants.GIFT_ID, fofoId)
1564 
					.getAvailability() > 0;
24203 amit.gupta 1565 
		} catch (ProfitMandiBusinessException e) {
1566 
			return false;
1567 
		}
1568 
	}
24288 amit.gupta 1569 
 
22354 ashik.ali 1570 
	@RequestMapping(value = "/contactUs", method = RequestMethod.GET)
23923 amit.gupta 1571 
	public String contactUs(HttpServletRequest request, Model model) throws Throwable {
22354 ashik.ali 1572 
		model.addAttribute("appContextPath", request.getContextPath());
1573 
		return "contact-us";
1574 
	}
23923 amit.gupta 1575 
 
25649 tejbeer 1576 
	@RequestMapping(value = "/notifications", method = RequestMethod.GET)
25683 tejbeer 1577 
	public String getNotificationsWithType(HttpServletRequest request,
1578 
			@RequestParam(required = false) MessageType messageType,
25649 tejbeer 1579 
			@RequestParam(name = "offset", defaultValue = "0") int offset,
1580 
			@RequestParam(name = "limit", defaultValue = "20") int limit, Model model) throws Exception {
1581 
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
26060 tejbeer 1582 
		int userId = 0;
1583 
		boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
1584 
		if (isAdmin) {
1585 
			userId = loginDetails.getFofoId();
1586 
		} else {
1587 
			userId = userAccountRepository.selectUserIdByRetailerId(loginDetails.getFofoId());
1588 
		}
25683 tejbeer 1589 
		List<Notification> notifications = null;
1590 
 
26086 tejbeer 1591 
		List<NotificationCampaign> notificationCampaigns = notificationCampaignRepository.getNotifications(messageType,
1592 
				userId, offset, limit);
1593 
		LOGGER.info("messageType" + messageType);
1594 
		notifications = getNotifications(notificationCampaigns, messageType);
1595 
 
25683 tejbeer 1596 
		model.addAttribute("notifications", notifications);
1597 
 
1598 
		LOGGER.info("notifications" + notifications);
1599 
		return "notification-template";
1600 
	}
1601 
 
1602 
	public List<Notification> getNotifications(List<NotificationCampaign> nc, MessageType messageType)
1603 
			throws ProfitMandiBusinessException {
1604 
		List<Notification> notifications = new ArrayList<>();
1605 
		Document document = null;
1606 
		if (messageType != null) {
1607 
			for (NotificationCampaign notificationCampaign : nc) {
1608 
				if (notificationCampaign.getMessageType() == messageType) {
25649 tejbeer 1609 
					Notification ns = new Notification();
1610 
					SimpleCampaignParams scp = gson.fromJson(notificationCampaign.getImplementationParams(),
1611 
							SimpleCampaignParams.class);
1612 
					Campaign campaign = new SimpleCampaign(scp);
1613 
					LocalDateTime expire = campaign.getExpireTimestamp();
1614 
					ns.setCid(Integer.toString(notificationCampaign.getId()));
1615 
					ns.setType(campaign.getType());
1616 
					ns.setMessage(campaign.getMessage());
1617 
					ns.setTitle(campaign.getTitle());
25651 tejbeer 1618 
					if (notificationCampaign.getDocumentId() != null) {
1619 
						document = documentRepository.selectById(notificationCampaign.getDocumentId());
1620 
						ns.setDocumentName(document.getDisplayName());
1621 
					}
25683 tejbeer 1622 
					ns.setUrl(campaign.getUrl());
25649 tejbeer 1623 
					ns.setShowImage(campaign.getShowImage());
1624 
					ns.setImageUrl(campaign.getImageUrl());
25683 tejbeer 1625 
					ns.setDocumentId(notificationCampaign.getDocumentId());
1626 
					ns.setMessageType(notificationCampaign.getMessageType());
25649 tejbeer 1627 
					ns.setCreated(
1628 
							notificationCampaign.getCreatedTimestamp().toEpochSecond(ZoneOffset.ofHoursMinutes(5, 30))
1629 
									* 1000);
1630 
					if (LocalDateTime.now().isAfter(expire)) {
1631 
						ns.setExpired(true);
1632 
					} else {
1633 
						ns.setExpired(false);
1634 
					}
1635 
					notifications.add(ns);
1636 
				}
1637 
			}
25683 tejbeer 1638 
		} else {
1639 
			for (NotificationCampaign notificationCampaign : nc) {
1640 
 
1641 
				Notification ns = new Notification();
1642 
				SimpleCampaignParams scp = gson.fromJson(notificationCampaign.getImplementationParams(),
1643 
						SimpleCampaignParams.class);
1644 
				Campaign campaign = new SimpleCampaign(scp);
1645 
				LocalDateTime expire = campaign.getExpireTimestamp();
1646 
				ns.setCid(Integer.toString(notificationCampaign.getId()));
1647 
				ns.setType(campaign.getType());
1648 
				ns.setMessage(campaign.getMessage());
1649 
				ns.setTitle(campaign.getTitle());
1650 
				if (notificationCampaign.getDocumentId() != null) {
1651 
					document = documentRepository.selectById(notificationCampaign.getDocumentId());
1652 
					ns.setDocumentName(document.getDisplayName());
1653 
				}
1654 
				ns.setUrl(campaign.getUrl());
1655 
				ns.setShowImage(campaign.getShowImage());
1656 
				ns.setImageUrl(campaign.getImageUrl());
1657 
				ns.setDocumentId(notificationCampaign.getDocumentId());
1658 
				ns.setMessageType(notificationCampaign.getMessageType());
1659 
				ns.setCreated(notificationCampaign.getCreatedTimestamp().toEpochSecond(ZoneOffset.ofHoursMinutes(5, 30))
1660 
						* 1000);
1661 
				if (LocalDateTime.now().isAfter(expire)) {
1662 
					ns.setExpired(true);
1663 
				} else {
1664 
					ns.setExpired(false);
1665 
				}
1666 
				notifications.add(ns);
1667 
			}
1668 
 
25649 tejbeer 1669 
		}
25683 tejbeer 1670 
		return notifications;
25651 tejbeer 1671 
 
1672 
	}
25649 tejbeer 1673 
 
25651 tejbeer 1674 
	@RequestMapping(value = "/notifyDocument/documentId", method = RequestMethod.GET)
1675 
	public ResponseEntity<?> retailerDocumentById(HttpServletRequest request,
1676 
			@RequestParam(name = ProfitMandiConstants.DOCUMENT_ID) int documentId, @RequestParam int cid)
1677 
			throws ProfitMandiBusinessException {
1678 
		Document document = documentRepository.selectById(documentId);
1679 
		NotificationCampaign nc = notificationCampaignRepository.selectById(cid);
1680 
		if (nc.getDocumentId() == null) {
1681 
			throw new ProfitMandiBusinessException("cid", nc.getId(), "not available");
1682 
		}
1683 
		if (nc.getDocumentId() != documentId) {
1684 
			throw new ProfitMandiBusinessException(ProfitMandiConstants.DOCUMENT_ID, documentId, "RTLR_1014");
1685 
		}
1686 
		return responseSender.ok(document);
25649 tejbeer 1687 
	}
1688 
 
25651 tejbeer 1689 
	@RequestMapping(value = "/notifyDocument/download", method = RequestMethod.GET)
1690 
	public ResponseEntity<?> downloadRetailerDocument(HttpServletRequest request, @RequestParam int cid, Model model)
1691 
			throws ProfitMandiBusinessException {
1692 
 
1693 
		NotificationCampaign nc = notificationCampaignRepository.selectById(cid);
1694 
 
1695 
		if (nc.getDocumentId() == null) {
1696 
			throw new ProfitMandiBusinessException("cid", nc.getId(), "not available");
1697 
		}
1698 
 
1699 
		Document document = documentRepository.selectById(nc.getDocumentId());
1700 
 
1701 
		FileInputStream file = null;
1702 
		try {
1703 
			file = new FileInputStream(document.getPath() + File.separator + document.getName());
1704 
		} catch (FileNotFoundException e) {
1705 
			LOGGER.error("Retailer Document file not found : ", e);
1706 
			throw new ProfitMandiBusinessException(ProfitMandiConstants.DOCUMENT_ID, document.getId(), "RTLR_1013");
1707 
		}
1708 
		// ByteArrayOutputStream byteArrayOutputStream = new
1709 
		// ByteArrayOutputStream();
1710 
		// ExcelUtils.writeSchemeModels(schemeModels, byteArrayOutputStream);
1711 
 
1712 
		final HttpHeaders headers = new HttpHeaders();
1713 
		String contentType = "";
1714 
		if (document.getContentType() == ContentType.JPEG) {
1715 
			contentType = "image/jpeg";
1716 
		} else if (document.getContentType() == ContentType.PNG) {
1717 
			contentType = "image/png";
1718 
		} else if (document.getContentType() == ContentType.PDF) {
1719 
			contentType = "application/pdf";
1720 
		}
1721 
		headers.set("Content-Type", contentType);
1722 
		headers.set("Content-disposition", "inline; filename=" + document.getName());
1723 
		headers.setContentLength(document.getSize());
1724 
		final InputStreamResource inputStreamResource = new InputStreamResource(file);
1725 
		return new ResponseEntity<InputStreamResource>(inputStreamResource, headers, HttpStatus.OK);
1726 
	}
26460 amit.gupta 1727 
 
1728 
	public Map<Integer, PartnerDetailModel> getL2AuthUserPartnerDetail() throws Exception {
26445 amit.gupta 1729 
		LOGGER.info("getL2AuthUserPartnerDetail Started");
26460 amit.gupta 1730 
		Map<Integer, List<Integer>> L2L1Mapping = csService.getL2L1Mapping();
26422 tejbeer 1731 
		Map<Integer, Integer> authIdAndleadsCountMap = new HashMap<>();
1732 
		for (Entry<Integer, List<Integer>> l2l1 : L2L1Mapping.entrySet()) {
1733 
			List<Integer> authIds = l2l1.getValue();
1734 
			authIds.add(l2l1.getKey());
1735 
 
1736 
			List<Lead> leads = leadRepository.selectByAssignAuthIdsAndStatus(authIds, LeadStatus.followUp);
26433 tejbeer 1737 
			LOGGER.info("authIdAndleadsCountMap" + authIdAndleadsCountMap);
26422 tejbeer 1738 
			AuthUser auth = authRepository.selectById(l2l1.getKey());
26431 tejbeer 1739 
			if (!leads.isEmpty()) {
1740 
				authIdAndleadsCountMap.put(auth.getId(), leads.size());
1741 
			} else {
1742 
				authIdAndleadsCountMap.put(auth.getId(), 0);
1743 
			}
26422 tejbeer 1744 
		}
26468 amit.gupta 1745 
 
26460 amit.gupta 1746 
		Map<Integer, PartnerDetailModel> partnerStats = partnerStatsService.getAllPartnerStats();
27352 tejbeer 1747 
		List<Integer> unmappedPartners = partnerStats.entrySet().stream().map(x -> x.getKey())
1748 
				.collect(Collectors.toList());
26433 tejbeer 1749 
		LOGGER.info("authIdAndleadsCountMap" + authIdAndleadsCountMap);
26422 tejbeer 1750 
 
26460 amit.gupta 1751 
		Map<Integer, PartnerDetailModel> authIdAndallValues = new LinkedHashMap<>();
26422 tejbeer 1752 
 
26460 amit.gupta 1753 
		Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
1754 
		for (int authUserId : pp.keySet()) {
1755 
			if (L2L1Mapping.keySet().contains(authUserId)) {
1756 
				List<Integer> fofoIds = pp.get(authUserId);
26997 amit.gupta 1757 
				unmappedPartners.removeAll(fofoIds);
26468 amit.gupta 1758 
				List<PartnerDetailModel> partnerDetails = fofoIds.stream().map(x -> partnerStats.get(x))
1759 
						.collect(Collectors.toList());
27632 tejbeer 1760 
				LOGGER.info("authUserId {}, partnerDetails2 {}" + authUserId, partnerDetails);
26460 amit.gupta 1761 
				PartnerDetailModel partnerDetailModel = partnerStatsService.getAggregateStats(partnerDetails);
1762 
				authIdAndallValues.put(authUserId, partnerDetailModel);
26422 tejbeer 1763 
			}
1764 
		}
26997 amit.gupta 1765 
		List<PartnerDetailModel> unmappedPartnerDetails = unmappedPartners.stream().map(x -> partnerStats.get(x))
1766 
				.collect(Collectors.toList());
26468 amit.gupta 1767 
		PartnerDetailModel partnerDetailModel = partnerStatsService
1768 
				.getAggregateStats(new ArrayList<>(partnerStats.values()));
27000 amit.gupta 1769 
		authIdAndallValues.put(-1, partnerStatsService.getAggregateStats(unmappedPartnerDetails));
26460 amit.gupta 1770 
		authIdAndallValues.put(0, partnerDetailModel);
26422 tejbeer 1771 
		return authIdAndallValues;
1772 
	}
1773 
 
27579 tejbeer 1774 
	@RequestMapping(value = "/getItemWiseTertiary", method = RequestMethod.GET)
1775 
	public String getItemWiseTertiary(HttpServletRequest request,
1776 
			@RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model)
1777 
			throws ProfitMandiBusinessException {
1778 
		List<ItemWiseTertiaryModel> itemWiseTertiary = fofoOrderRepository.SelectItemWiseTertiary(fofoId);
1779 
 
1780 
		LOGGER.info("itemWiseTertiary" + itemWiseTertiary);
27586 tejbeer 1781 
		CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
1782 
		model.addAttribute("customRetailer", customRetailer);
27579 tejbeer 1783 
		model.addAttribute("itemWiseTertiary", itemWiseTertiary);
1784 
		return "item-wise-tertiary";
1785 
	}
1786 
 
27586 tejbeer 1787 
	@RequestMapping(value = "/getItemWiseIndent", method = RequestMethod.GET)
1788 
	public String getItemWiseIndent(HttpServletRequest request,
1789 
			@RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model)
1790 
			throws ProfitMandiBusinessException {
1791 
 
1792 
		List<Order> unbilledOrders = transactionService.getInTransitOrders(fofoId);
1793 
		model.addAttribute("unbilledOrders", unbilledOrders);
1794 
 
1795 
		return "item-wise-indent";
1796 
	}
1797 
 
27636 tejbeer 1798 
	@RequestMapping(value = "/getPartnerInvestment", method = RequestMethod.GET)
1799 
	public String getPartnerInvestment(HttpServletRequest request,
1800 
			@RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
1801 
		Map<Integer, PartnerDetailModel> partnerStats = this.getPartnersStatDataFromFile();
1802 
		PartnerDetailModel partnerDetailModel = partnerStats.get(fofoId);
1803 
		CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
1804 
		model.addAttribute("partnerDetailModel", partnerDetailModel);
1805 
		model.addAttribute("customRetailer", customRetailer);
1806 
		return "partner-investment";
1807 
	}
27727 tejbeer 1808 
 
27704 amit.gupta 1809 
	@RequestMapping(value = "/getPartnerPendingIndentItem", method = RequestMethod.GET)
1810 
	public String getPartnerPendingIndentItem(HttpServletRequest request, @RequestParam int warehouseId,
1811 
			@RequestParam int itemId, Model model) throws ProfitMandiBusinessException {
1812 
		List<PartnerPendingIndentItemModel> partnerPendingIndent = fofoStoreRepository
1813 
				.selectPartnerPendingIndentItem(itemId, warehouseId);
27636 tejbeer 1814 
 
27704 amit.gupta 1815 
		model.addAttribute("partnerPendingIndent", partnerPendingIndent);
1816 
		return "partner-pending-indent-item";
1817 
	}
1818 
 
27636 tejbeer 1819 
	@RequestMapping(value = "/getPatnerActivateStock", method = RequestMethod.GET)
1820 
	public String getPartnerActivateStockItem(HttpServletRequest request,
1821 
			@RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
1822 
		List<ActivateItemModel> activateStocks = new ArrayList<>();
1823 
		List<InventoryItem> inventoryItems = inventoryItemRepository.selectByActivatedNotSold(fofoId);
1824 
		CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
1825 
 
1826 
		for (InventoryItem inventoryItem : inventoryItems) {
1827 
			TagListing tagListing = tagListingRepository.selectByItemId(inventoryItem.getItemId());
1828 
			Item item = itemRepository.selectById(inventoryItem.getItemId());
1829 
			ActivateItemModel aim = new ActivateItemModel();
1830 
			aim.setFofoId(inventoryItem.getFofoId());
1831 
			aim.setQuantity(inventoryItem.getGoodQuantity());
1832 
			aim.setAmount(tagListing.getSellingPrice());
1833 
			aim.setItemDescription(item.getItemDescription());
1834 
			aim.setItemId(inventoryItem.getItemId());
1835 
			activateStocks.add(aim);
1836 
		}
1837 
 
1838 
		model.addAttribute("activateStocks", activateStocks);
1839 
		model.addAttribute("customRetailer", customRetailer);
1840 
		return "partner-activate-stock";
1841 
	}
1842 
 
1843 
	@RequestMapping(value = "/getPatnerBrandWiseMTDSale", method = RequestMethod.GET)
1844 
	public String getPatnerBrandWiseMTDSale(HttpServletRequest request,
1845 
			@RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
1846 
		LocalDateTime curDate = LocalDate.now().atStartOfDay();
1847 
		CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
1848 
		Map<String, Double> brandMtdAmount = fofoOrderItemRepository
1849 
				.selectSumAmountGroupByBrand(curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), fofoId);
27638 tejbeer 1850 
		Map<String, Long> brandMtdQty = fofoOrderItemRepository.selectSumQuantityGroupByBrand(curDate.withDayOfMonth(1),
1851 
				curDate.with(LocalTime.MAX), fofoId);
27636 tejbeer 1852 
		Double accesoriesmtdsale = fofoOrderRepository.selectSumSaleGroupByFofoIdsForMobileOrAccessories(fofoId,
1853 
				curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), Optional.of(false)).get(fofoId);
27638 tejbeer 1854 
		Long accesoriesmtdqty = fofoOrderRepository.selectSumSaleQuantityGroupByFofoIdsForMobileOrAccessories(fofoId,
1855 
				curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), Optional.of(false)).get(fofoId);
1856 
 
27636 tejbeer 1857 
		LOGGER.info("accesoriesmtdsale" + accesoriesmtdsale);
1858 
		model.addAttribute("brandMtdAmount", brandMtdAmount);
27638 tejbeer 1859 
		model.addAttribute("brandMtdQty", brandMtdQty);
27636 tejbeer 1860 
		model.addAttribute("accesoriesmtdsale", accesoriesmtdsale);
27638 tejbeer 1861 
		model.addAttribute("accesoriesmtdqty", accesoriesmtdqty);
1862 
 
27636 tejbeer 1863 
		model.addAttribute("customRetailer", customRetailer);
1864 
		return "partner-brand-mtd-sale";
1865 
	}
1866 
 
27637 tejbeer 1867 
	@RequestMapping(value = "/getPatnerBrandWiseLMTDSale", method = RequestMethod.GET)
1868 
	public String getPatnerBrandWiseLMTDSale(HttpServletRequest request,
1869 
			@RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
1870 
		LocalDateTime curDate = LocalDate.now().atStartOfDay();
1871 
		CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
1872 
		Map<String, Double> brandLMtdAmount = fofoOrderItemRepository.selectSumAmountGroupByBrand(
1873 
				curDate.withDayOfMonth(1).minusMonths(1), curDate.with(LocalTime.MAX).minusMonths(1), fofoId);
27638 tejbeer 1874 
		Map<String, Long> brandLmtdQty = fofoOrderItemRepository.selectSumQuantityGroupByBrand(
1875 
				curDate.withDayOfMonth(1).minusMonths(1), curDate.with(LocalTime.MAX).minusMonths(1), fofoId);
27637 tejbeer 1876 
 
1877 
		Double accesorieslmtdsale = fofoOrderRepository
1878 
				.selectSumSaleGroupByFofoIdsForMobileOrAccessories(fofoId, curDate.withDayOfMonth(1).minusMonths(1),
1879 
						curDate.with(LocalTime.MAX).minusMonths(1), Optional.of(false))
1880 
				.get(fofoId);
27638 tejbeer 1881 
		Long accesorieslmtdqty = fofoOrderRepository.selectSumSaleQuantityGroupByFofoIdsForMobileOrAccessories(fofoId,
1882 
				curDate.withDayOfMonth(1).minusMonths(1), curDate.with(LocalTime.MAX).minusMonths(1),
1883 
				Optional.of(false)).get(fofoId);
1884 
 
27637 tejbeer 1885 
		model.addAttribute("brandLMtdAmount", brandLMtdAmount);
27638 tejbeer 1886 
		model.addAttribute("brandLmtdQty", brandLmtdQty);
1887 
		model.addAttribute("accesorieslmtdqty", accesorieslmtdqty);
27637 tejbeer 1888 
		model.addAttribute("accesorieslmtdsale", accesorieslmtdsale);
1889 
		model.addAttribute("customRetailer", customRetailer);
1890 
		return "partner-brand-lmtd-sale";
1891 
	}
1892 
 
27660 tejbeer 1893 
	@RequestMapping(value = "/getPatnerBrandWiseLMSSale", method = RequestMethod.GET)
1894 
	public String getPatnerBrandWiseLMSSale(HttpServletRequest request,
1895 
			@RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
1896 
		LocalDateTime curDate = LocalDate.now().atStartOfDay();
1897 
		CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
1898 
		int lengthOfMonth = YearMonth.from(curDate.minusMonths(1)).lengthOfMonth();
1899 
 
1900 
		Map<String, Double> brandLMSAmount = fofoOrderItemRepository.selectSumAmountGroupByBrand(
27893 tejbeer 1901 
				curDate.withDayOfMonth(1).minusMonths(1), curDate.withDayOfMonth(1), fofoId);
27660 tejbeer 1902 
		Map<String, Long> brandLmsQty = fofoOrderItemRepository.selectSumQuantityGroupByBrand(
27893 tejbeer 1903 
				curDate.withDayOfMonth(1).minusMonths(1), curDate.withDayOfMonth(1), fofoId);
27660 tejbeer 1904 
 
27893 tejbeer 1905 
		Double accesorieslmssale = fofoOrderRepository.selectSumSaleGroupByFofoIdsForMobileOrAccessories(fofoId,
1906 
				curDate.withDayOfMonth(1).minusMonths(1), curDate.withDayOfMonth(1), Optional.of(false)).get(fofoId);
27660 tejbeer 1907 
		Long accesorieslmsqty = fofoOrderRepository
1908 
				.selectSumSaleQuantityGroupByFofoIdsForMobileOrAccessories(fofoId,
27893 tejbeer 1909 
						curDate.withDayOfMonth(1).minusMonths(1), curDate.withDayOfMonth(1), Optional.of(false))
27660 tejbeer 1910 
				.get(fofoId);
1911 
 
1912 
		model.addAttribute("brandLMSAmount", brandLMSAmount);
1913 
		model.addAttribute("brandLmsQty", brandLmsQty);
1914 
		model.addAttribute("accesorieslmssale", accesorieslmssale);
1915 
		model.addAttribute("accesorieslmsqty", accesorieslmsqty);
1916 
		model.addAttribute("customRetailer", customRetailer);
1917 
		return "partner-brand-lms-sale";
1918 
	}
1919 
 
27640 tejbeer 1920 
	@RequestMapping(value = "/getPatnerInStock", method = RequestMethod.GET)
1921 
	public String getPatnerInStock(HttpServletRequest request,
1922 
			@RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
1923 
 
1924 
		CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
1925 
 
27660 tejbeer 1926 
		List<InStockBrandModel> mobileStocks = currentInventorySnapshotRepository
27640 tejbeer 1927 
				.selectSumInStockMobileGroupByBrand(fofoId);
27660 tejbeer 1928 
		List<InStockBrandModel> accesStock = currentInventorySnapshotRepository
27640 tejbeer 1929 
				.selectSumInStockAccessoriesGroupByBrand(fofoId);
1930 
 
27660 tejbeer 1931 
		List<InStockBrandItemModel> stockItemlist = currentInventorySnapshotRepository
1932 
				.selectInStockItemsByBrand(fofoId);
1933 
 
1934 
		Map<String, List<InStockBrandItemModel>> stockItemMap = stockItemlist.stream()
1935 
				.collect(Collectors.groupingBy(InStockBrandItemModel::getBrand));
1936 
 
1937 
		model.addAttribute("stockItemMap", stockItemMap);
1938 
		model.addAttribute("mobileStock", mobileStocks);
1939 
		model.addAttribute("accesStock", accesStock);
27640 tejbeer 1940 
		model.addAttribute("customRetailer", customRetailer);
1941 
		return "partner-instock-item";
1942 
	}
1943 
 
27660 tejbeer 1944 
	@RequestMapping(value = "/getOpenTicketByFofoId", method = RequestMethod.GET)
1945 
	public String getOpenTicketByFofoId(HttpServletRequest request,
1946 
			@RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
1947 
		Map<Integer, AuthUser> ticketIdAuthUser = new HashMap<>();
1948 
		CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
1949 
		List<Integer> ticketIds = ticketRepository.selectAllOpenTicketByRetailer(fofoId).stream().map(x -> x.getId())
1950 
				.collect(Collectors.toList());
1951 
		List<TicketAssigned> ticketAssigns = ticketAssignedRepository.selectByTicketIds(ticketIds);
1952 
 
1953 
		for (TicketAssigned ticketAssign : ticketAssigns) {
1954 
			AuthUser authUser = authRepository.selectById(ticketAssign.getAssineeId());
1955 
			ticketIdAuthUser.put(ticketAssign.getTicketId(), authUser);
1956 
		}
1957 
		model.addAttribute("ticketIdAuthUser", ticketIdAuthUser);
1958 
		model.addAttribute("ticketAssigns", ticketAssigns);
1959 
		model.addAttribute("customRetailer", customRetailer);
1960 
		return "open-ticket";
1961 
	}
1962 
 
27893 tejbeer 1963 
	@RequestMapping(value = "/getPartnerSecondarySale", method = RequestMethod.GET)
1964 
	public String getPartnerSecondarySale(HttpServletRequest request,
1965 
			@RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, @RequestParam String timeValue, Model model)
1966 
			throws Exception {
1967 
		LocalDateTime curDate = LocalDate.now().atStartOfDay();
1968 
		CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
1969 
		int lengthOfMonth = YearMonth.from(curDate.minusMonths(1)).lengthOfMonth();
1970 
		LocalDateTime startDate = null;
1971 
		LocalDateTime endDate = null;
1972 
		List<InStockBrandModel> secondarySale = null;
1973 
		Map<String, List<InStockBrandItemModel>> secondaryItemSale = null;
1974 
 
1975 
		if (timeValue.equals("mtd")) {
1976 
			startDate = curDate.withDayOfMonth(1);
1977 
			endDate = curDate.with(LocalTime.MAX);
1978 
			secondarySale = orderRepository.selectAllBilledOrderBrandByFofoId(startDate, endDate, fofoId);
1979 
			secondaryItemSale = orderRepository.selectAllBilledOrderBrandItemByFofoId(startDate, endDate, fofoId)
1980 
					.stream().collect(Collectors.groupingBy(InStockBrandItemModel::getBrand));
1981 
			LOGGER.info("secondarySalemtd" + secondarySale);
1982 
		} else if (timeValue.equals("lmtd")) {
1983 
			startDate = curDate.withDayOfMonth(1).minusMonths(1);
1984 
			endDate = curDate.with(LocalTime.MAX).minusMonths(1);
1985 
			secondaryItemSale = orderRepository.selectAllBilledOrderBrandItemByFofoId(startDate, endDate, fofoId)
1986 
					.stream().collect(Collectors.groupingBy(InStockBrandItemModel::getBrand));
1987 
 
1988 
			secondarySale = orderRepository.selectAllBilledOrderBrandByFofoId(startDate, endDate, fofoId);
1989 
			LOGGER.info("secondarySalelmtd" + secondarySale);
1990 
 
1991 
		} else {
1992 
			startDate = curDate.withDayOfMonth(1).minusMonths(1);
1993 
			endDate = curDate.withDayOfMonth(1);
1994 
			secondaryItemSale = orderRepository.selectAllBilledOrderBrandItemByFofoId(startDate, endDate, fofoId)
1995 
					.stream().collect(Collectors.groupingBy(InStockBrandItemModel::getBrand));
1996 
 
1997 
			secondarySale = orderRepository.selectAllBilledOrderBrandByFofoId(startDate, endDate, fofoId);
1998 
			LOGGER.info("secondarySalelms" + secondarySale);
1999 
 
2000 
		}
2001 
 
2002 
		LOGGER.info("secondarySale" + secondarySale);
2003 
		model.addAttribute("secondarySale", secondarySale);
2004 
		model.addAttribute("secondaryItemSale", secondaryItemSale);
2005 
		model.addAttribute("customRetailer", customRetailer);
2006 
 
2007 
		return "partner-secondary-order";
2008 
	}
2009 
 
21615 kshitij.so 2010 
}