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



import com.spice.profitmandi.dao.repository.auth.AuthRepository;
import com.spice.profitmandi.dao.repository.catalog.ItemRepository;
import com.spice.profitmandi.dao.repository.catalog.OfferRepository;
import com.spice.profitmandi.dao.repository.catalog.SamsungUpgradeOfferRepository;
import com.spice.profitmandi.dao.repository.catalog.TagListingRepository;
import com.spice.profitmandi.dao.repository.cs.*;
 
 
 
import com.spice.profitmandi.dao.repository.dtr.*;
import com.spice.profitmandi.dao.repository.fofo.*;
import com.spice.profitmandi.dao.repository.inventory.ReporticoCacheTableRepository;
import com.spice.profitmandi.dao.repository.inventory.SaholicInventoryCISRepository;
import com.spice.profitmandi.dao.repository.transaction.LineItemRepository;

	private String webApiHost;
 
	@Value("${web.api.scheme}")
	private String webApiScheme;
 
	@Autowired
	private CsService1 csService1;
 
	@Value("${web.api.root}")
	private String webApiRoot;
 
	@Value("${web.api.port}")
	private int webApiPort;

			throws Exception {
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
		String email = loginDetails.getEmailId();
 
		Set<Integer> authfofoIds = new HashSet<>();
		authfofoIds = csService1.getAuthFofoIds(email, true);
		Map<Integer, List<Integer>> warehouseIdFofoIdMap = fofoStoreRepository
				.selectActivePartnersByRetailerIds(new ArrayList<>(authfofoIds)).stream().collect(Collectors.groupingBy(
						FofoStore::getWarehouseId, Collectors.mapping(FofoStore::getId, Collectors.toList())));
 
		Map<Integer, CustomRetailer> fofoIdAndPartnerMap = retailerService.getFofoRetailers(false);

		model.addAttribute("partnerTypes", partnerTypes);
 
		return "auth_user_partner_detail";
	}
 
 
	@RequestMapping(value = "/getWarehouseWiseBrandStock", method = RequestMethod.GET)
	public String getWarehouseWiseBrandStock(HttpServletRequest request, Model model,
			@RequestParam List<Integer> warehouseId) throws Exception {
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
		String email = loginDetails.getEmailId();
		Set<Integer> authfofoIds = csService1.getAuthFofoIds(email, true);
		Map<Integer, List<Integer>> warehouseIdFofoIdMap = fofoStoreRepository
				.selectActivePartnersByRetailerIds(new ArrayList<>(authfofoIds)).stream().collect(Collectors.groupingBy(
						FofoStore::getWarehouseId, Collectors.mapping(FofoStore::getId, Collectors.toList())));
		List<WarehouseWiseBrandStockModel> warehouseWiseBrandStock = new ArrayList<>();
		if (!warehouseId.contains(0)) {

			throws Exception {
 
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
		String email = loginDetails.getEmailId();
 
		Set<Integer> authfofoIds = csService1.getAuthFofoIds(email, true);
 
		Map<Integer, WarehouseWiseBrandSaleModel> warehouseWiseBrandPartnerSales = fofoStoreRepository
				.selectGroupByWarehouseBrandWisePartnerSale(brand, new ArrayList<>(authfofoIds)).stream()
				.collect(Collectors.toMap(x -> x.getWarehouseId(), x -> x));
 

	public String getWarehouseBrandWiseItemSale(HttpServletRequest request, Model model,
			@RequestParam List<Integer> warehouseId, @RequestParam String brand) throws Exception {
		Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
		String email = loginDetails.getEmailId();
		Set<Integer> authfofoIds = csService1.getAuthFofoIds(email, true);
		Map<Integer, WarehouseBrandWiseItemSaleModel> branditemSalesMap = fofoStoreRepository
				.selectWarehouseBrandItemSale(warehouseId, brand, new ArrayList<>(authfofoIds)).stream()
				.collect(Collectors.toMap(x -> x.getItemId(), x -> x));
 
		List<WarehouseBrandItemUnbilledActivatedModel> unbilledItems = fofoStoreRepository

	public String getMobileBrandWise(HttpServletRequest request, Model model) throws Exception {
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
		String email = loginDetails.getEmailId();
 
		AuthUser authUser = authRepository.selectByEmailOrMobile(email);
		Set<Integer> fofoIds = csService1.getAuthFofoIds(email, true);
 
		Map<String, BrandWisePartnerSaleModel> partnersBrandSaleMap = null;
		partnersBrandSaleMap = fofoStoreRepository.selectGroupByBrandWarehousePartnerSale(new ArrayList<>(fofoIds))
				.stream().collect(Collectors.toMap(x -> x.getBrand(), x -> x));
 

	@RequestMapping(value = "/getAccessoriesBrandWise", method = RequestMethod.GET)
	public String getAccessoriesBrandWise(HttpServletRequest request, Model model) throws Exception {
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
		String email = loginDetails.getEmailId();
 
		Set<Integer> fofoIds = csService1.getAuthFofoIds(email, true);
 
		List<BrandWisePartnerSaleModel> accessoriesBrandSales = null;
 
		accessoriesBrandSales = fofoStoreRepository
				.selectGroupByBrandAccesoriesWarehousePartnerSale(new ArrayList<>(fofoIds));

	public String getSaleCountByMilestone(HttpServletRequest request,
			@RequestParam(required = false, defaultValue = "0") int warehouseId, Model model) throws Exception {
 
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
		String email = loginDetails.getEmailId();
		Set<Integer> fofoIds = csService1.getAuthFofoIds(email, true);
		Map<Integer, Double> last3MonthSale = fofoOrderItemRepository.selectSumMopGroupByRetailer(
				LocalDateTime.now().withDayOfMonth(1).minusMonths(2), LocalDateTime.now(), 0, false);
 
		if (fofoIds != null && fofoIds.size() > 0) {
			if (warehouseId != 0) {

	public String getPurchaseCountByMileStone(HttpServletRequest request,
			@RequestParam(required = false, defaultValue = "0") int warehouseId, Model model) throws Exception {
 
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
		String email = loginDetails.getEmailId();
		Set<Integer> fofoIds = csService1.getAuthFofoIds(email, true);
		Map<Integer, Double> last3MonthS = orderRepository.selectBillingDatesBetweenSumGroupByRetailerId(
				LocalDateTime.now().withDayOfMonth(1).minusMonths(2), LocalDateTime.now());
 
		if (fofoIds != null && fofoIds.size() > 0) {
			if (warehouseId != 0) {

	}
 
	@RequestMapping(value = "/getActivatedModelByBrand", method = RequestMethod.GET)
	public String getActivatedModelByBrand(HttpServletRequest request, Model model) throws Exception {
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
		Set<Integer> fofoIds = csService1.getAuthFofoIds(loginDetails.getEmailId(), true);
 
		List<BrandWiseActivatedModel> activatedModels = activatedImeiRepository
				.selectActivatedModelGroupByBrand(new ArrayList<>(fofoIds));
		model.addAttribute("activatedModels", activatedModels);
		return "activation-brandwise-report";

Subversion Repositories SmartDukaan

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

Rev 31521		Rev 31662
Line 25...		Line 25...
25	`import com.spice.profitmandi.dao.repository.auth.AuthRepository;`	25	`import com.spice.profitmandi.dao.repository.auth.AuthRepository;`
26	`import com.spice.profitmandi.dao.repository.catalog.ItemRepository;`	26	`import com.spice.profitmandi.dao.repository.catalog.ItemRepository;`
27	`import com.spice.profitmandi.dao.repository.catalog.OfferRepository;`	27	`import com.spice.profitmandi.dao.repository.catalog.OfferRepository;`
28	`import com.spice.profitmandi.dao.repository.catalog.SamsungUpgradeOfferRepository;`	28	`import com.spice.profitmandi.dao.repository.catalog.SamsungUpgradeOfferRepository;`
29	`import com.spice.profitmandi.dao.repository.catalog.TagListingRepository;`	29	`import com.spice.profitmandi.dao.repository.catalog.TagListingRepository;`
30	`import com.spice.profitmandi.dao.repository.cs.CsService;`	30	`import com.spice.profitmandi.dao.repository.cs.*;`
31	`import com.spice.profitmandi.dao.repository.cs.PositionRepository;`	-
32	`import com.spice.profitmandi.dao.repository.cs.TicketAssignedRepository;`	-
33	`import com.spice.profitmandi.dao.repository.cs.TicketRepository;`	-
34	`import com.spice.profitmandi.dao.repository.dtr.*;`	31	`import com.spice.profitmandi.dao.repository.dtr.*;`
35	`import com.spice.profitmandi.dao.repository.fofo.*;`	32	`import com.spice.profitmandi.dao.repository.fofo.*;`
36	`import com.spice.profitmandi.dao.repository.inventory.ReporticoCacheTableRepository;`	33	`import com.spice.profitmandi.dao.repository.inventory.ReporticoCacheTableRepository;`
37	`import com.spice.profitmandi.dao.repository.inventory.SaholicInventoryCISRepository;`	34	`import com.spice.profitmandi.dao.repository.inventory.SaholicInventoryCISRepository;`
38	`import com.spice.profitmandi.dao.repository.transaction.LineItemRepository;`	35	`import com.spice.profitmandi.dao.repository.transaction.LineItemRepository;`
Line 93...		Line 90...
93	`private String webApiHost;`	90	`private String webApiHost;`
94		91
95	`@Value("${web.api.scheme}")`	92	`@Value("${web.api.scheme}")`
96	`private String webApiScheme;`	93	`private String webApiScheme;`
97		94
-		95	`@Autowired`
-		96	`private CsService1 csService1;`
-		97
98	`@Value("${web.api.root}")`	98	`@Value("${web.api.root}")`
99	`private String webApiRoot;`	99	`private String webApiRoot;`
100		100
101	`@Value("${web.api.port}")`	101	`@Value("${web.api.port}")`
102	`private int webApiPort;`	102	`private int webApiPort;`
Line 1217...		Line 1217...
1217	`throws Exception {`	1217	`throws Exception {`
1218	`LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);`	1218	`LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);`
1219	`String email = loginDetails.getEmailId();`	1219	`String email = loginDetails.getEmailId();`
1220		1220
1221	`Set<Integer> authfofoIds = new HashSet<>();`	1221	`Set<Integer> authfofoIds = new HashSet<>();`
1222	`authfofoIds = csService.getAuthFofoIds(email, true);`	1222	`authfofoIds = csService1.getAuthFofoIds(email, true);`
1223	`Map<Integer, List<Integer>> warehouseIdFofoIdMap = fofoStoreRepository`	1223	`Map<Integer, List<Integer>> warehouseIdFofoIdMap = fofoStoreRepository`
1224	`.selectActivePartnersByRetailerIds(new ArrayList<>(authfofoIds)).stream().collect(Collectors.groupingBy(`	1224	`.selectActivePartnersByRetailerIds(new ArrayList<>(authfofoIds)).stream().collect(Collectors.groupingBy(`
1225	`FofoStore::getWarehouseId, Collectors.mapping(FofoStore::getId, Collectors.toList())));`	1225	`FofoStore::getWarehouseId, Collectors.mapping(FofoStore::getId, Collectors.toList())));`
1226		1226
1227	`Map<Integer, CustomRetailer> fofoIdAndPartnerMap = retailerService.getFofoRetailers(false);`	1227	`Map<Integer, CustomRetailer> fofoIdAndPartnerMap = retailerService.getFofoRetailers(false);`
Line 1259...		Line 1259...
1259	`model.addAttribute("partnerTypes", partnerTypes);`	1259	`model.addAttribute("partnerTypes", partnerTypes);`
1260		1260
1261	`return "auth_user_partner_detail";`	1261	`return "auth_user_partner_detail";`
1262	`}`	1262	`}`
1263		1263
-		1264
1264	`@RequestMapping(value = "/getWarehouseWiseBrandStock", method = RequestMethod.GET)`	1265	`@RequestMapping(value = "/getWarehouseWiseBrandStock", method = RequestMethod.GET)`
1265	`public String getWarehouseWiseBrandStock(HttpServletRequest request, Model model,`	1266	`public String getWarehouseWiseBrandStock(HttpServletRequest request, Model model,`
1266	`@RequestParam List<Integer> warehouseId) throws Exception {`	1267	`@RequestParam List<Integer> warehouseId) throws Exception {`
1267	`LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);`	1268	`LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);`
1268	`String email = loginDetails.getEmailId();`	1269	`String email = loginDetails.getEmailId();`
1269	`Set<Integer> authfofoIds = csService.getAuthFofoIds(email, true);`	1270	`Set<Integer> authfofoIds = csService1.getAuthFofoIds(email, true);`
1270	`Map<Integer, List<Integer>> warehouseIdFofoIdMap = fofoStoreRepository`	1271	`Map<Integer, List<Integer>> warehouseIdFofoIdMap = fofoStoreRepository`
1271	`.selectActivePartnersByRetailerIds(new ArrayList<>(authfofoIds)).stream().collect(Collectors.groupingBy(`	1272	`.selectActivePartnersByRetailerIds(new ArrayList<>(authfofoIds)).stream().collect(Collectors.groupingBy(`
1272	`FofoStore::getWarehouseId, Collectors.mapping(FofoStore::getId, Collectors.toList())));`	1273	`FofoStore::getWarehouseId, Collectors.mapping(FofoStore::getId, Collectors.toList())));`
1273	`List<WarehouseWiseBrandStockModel> warehouseWiseBrandStock = new ArrayList<>();`	1274	`List<WarehouseWiseBrandStockModel> warehouseWiseBrandStock = new ArrayList<>();`
1274	`if (!warehouseId.contains(0)) {`	1275	`if (!warehouseId.contains(0)) {`
Line 1335...		Line 1336...
1335	`throws Exception {`	1336	`throws Exception {`
1336		1337
1337	`LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);`	1338	`LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);`
1338	`String email = loginDetails.getEmailId();`	1339	`String email = loginDetails.getEmailId();`
1339		1340
1340	`Set<Integer> authfofoIds = csService.getAuthFofoIds(email, true);`	1341	`Set<Integer> authfofoIds = csService1.getAuthFofoIds(email, true);`
1341		1342
1342	`Map<Integer, WarehouseWiseBrandSaleModel> warehouseWiseBrandPartnerSales = fofoStoreRepository`	1343	`Map<Integer, WarehouseWiseBrandSaleModel> warehouseWiseBrandPartnerSales = fofoStoreRepository`
1343	`.selectGroupByWarehouseBrandWisePartnerSale(brand, new ArrayList<>(authfofoIds)).stream()`	1344	`.selectGroupByWarehouseBrandWisePartnerSale(brand, new ArrayList<>(authfofoIds)).stream()`
1344	`.collect(Collectors.toMap(x -> x.getWarehouseId(), x -> x));`	1345	`.collect(Collectors.toMap(x -> x.getWarehouseId(), x -> x));`
1345		1346
Line 1408...		Line 1409...
1408	`public String getWarehouseBrandWiseItemSale(HttpServletRequest request, Model model,`	1409	`public String getWarehouseBrandWiseItemSale(HttpServletRequest request, Model model,`
1409	`@RequestParam List<Integer> warehouseId, @RequestParam String brand) throws Exception {`	1410	`@RequestParam List<Integer> warehouseId, @RequestParam String brand) throws Exception {`
1410	`Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;`	1411	`Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;`
1411	`LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);`	1412	`LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);`
1412	`String email = loginDetails.getEmailId();`	1413	`String email = loginDetails.getEmailId();`
1413	`Set<Integer> authfofoIds = csService.getAuthFofoIds(email, true);`	1414	`Set<Integer> authfofoIds = csService1.getAuthFofoIds(email, true);`
1414	`Map<Integer, WarehouseBrandWiseItemSaleModel> branditemSalesMap = fofoStoreRepository`	1415	`Map<Integer, WarehouseBrandWiseItemSaleModel> branditemSalesMap = fofoStoreRepository`
1415	`.selectWarehouseBrandItemSale(warehouseId, brand, new ArrayList<>(authfofoIds)).stream()`	1416	`.selectWarehouseBrandItemSale(warehouseId, brand, new ArrayList<>(authfofoIds)).stream()`
1416	`.collect(Collectors.toMap(x -> x.getItemId(), x -> x));`	1417	`.collect(Collectors.toMap(x -> x.getItemId(), x -> x));`
1417		1418
1418	`List<WarehouseBrandItemUnbilledActivatedModel> unbilledItems = fofoStoreRepository`	1419	`List<WarehouseBrandItemUnbilledActivatedModel> unbilledItems = fofoStoreRepository`
Line 1788...		Line 1789...
1788	`public String getMobileBrandWise(HttpServletRequest request, Model model) throws Exception {`	1789	`public String getMobileBrandWise(HttpServletRequest request, Model model) throws Exception {`
1789	`LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);`	1790	`LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);`
1790	`String email = loginDetails.getEmailId();`	1791	`String email = loginDetails.getEmailId();`
1791		1792
1792	`AuthUser authUser = authRepository.selectByEmailOrMobile(email);`	1793	`AuthUser authUser = authRepository.selectByEmailOrMobile(email);`
1793	`Set<Integer> fofoIds = csService.getAuthFofoIds(email, true);`	1794	`Set<Integer> fofoIds = csService1.getAuthFofoIds(email, true);`
1794		1795
1795	`Map<String, BrandWisePartnerSaleModel> partnersBrandSaleMap = null;`	1796	`Map<String, BrandWisePartnerSaleModel> partnersBrandSaleMap = null;`
1796	`partnersBrandSaleMap = fofoStoreRepository.selectGroupByBrandWarehousePartnerSale(new ArrayList<>(fofoIds))`	1797	`partnersBrandSaleMap = fofoStoreRepository.selectGroupByBrandWarehousePartnerSale(new ArrayList<>(fofoIds))`
1797	`.stream().collect(Collectors.toMap(x -> x.getBrand(), x -> x));`	1798	`.stream().collect(Collectors.toMap(x -> x.getBrand(), x -> x));`
1798		1799
Line 1826...		Line 1827...
1826	`@RequestMapping(value = "/getAccessoriesBrandWise", method = RequestMethod.GET)`	1827	`@RequestMapping(value = "/getAccessoriesBrandWise", method = RequestMethod.GET)`
1827	`public String getAccessoriesBrandWise(HttpServletRequest request, Model model) throws Exception {`	1828	`public String getAccessoriesBrandWise(HttpServletRequest request, Model model) throws Exception {`
1828	`LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);`	1829	`LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);`
1829	`String email = loginDetails.getEmailId();`	1830	`String email = loginDetails.getEmailId();`
1830		1831
1831	`Set<Integer> fofoIds = csService.getAuthFofoIds(email, true);`	1832	`Set<Integer> fofoIds = csService1.getAuthFofoIds(email, true);`
1832		1833
1833	`List<BrandWisePartnerSaleModel> accessoriesBrandSales = null;`	1834	`List<BrandWisePartnerSaleModel> accessoriesBrandSales = null;`
1834		1835
1835	`accessoriesBrandSales = fofoStoreRepository`	1836	`accessoriesBrandSales = fofoStoreRepository`
1836	`.selectGroupByBrandAccesoriesWarehousePartnerSale(new ArrayList<>(fofoIds));`	1837	`.selectGroupByBrandAccesoriesWarehousePartnerSale(new ArrayList<>(fofoIds));`
Line 1923...		Line 1924...
1923	`public String getSaleCountByMilestone(HttpServletRequest request,`	1924	`public String getSaleCountByMilestone(HttpServletRequest request,`
1924	`@RequestParam(required = false, defaultValue = "0") int warehouseId, Model model) throws Exception {`	1925	`@RequestParam(required = false, defaultValue = "0") int warehouseId, Model model) throws Exception {`
1925		1926
1926	`LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);`	1927	`LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);`
1927	`String email = loginDetails.getEmailId();`	1928	`String email = loginDetails.getEmailId();`
1928	`Set<Integer> fofoIds = csService.getAuthFofoIds(email, true);`	1929	`Set<Integer> fofoIds = csService1.getAuthFofoIds(email, true);`
1929	`Map<Integer, Double> last3MonthSale = fofoOrderItemRepository.selectSumMopGroupByRetailer(`	1930	`Map<Integer, Double> last3MonthSale = fofoOrderItemRepository.selectSumMopGroupByRetailer(`
1930	`LocalDateTime.now().withDayOfMonth(1).minusMonths(2), LocalDateTime.now(), 0, false);`	1931	`LocalDateTime.now().withDayOfMonth(1).minusMonths(2), LocalDateTime.now(), 0, false);`
1931		1932
1932	`if (fofoIds != null && fofoIds.size() > 0) {`	1933	`if (fofoIds != null && fofoIds.size() > 0) {`
1933	`if (warehouseId != 0) {`	1934	`if (warehouseId != 0) {`
Line 2006...		Line 2007...
2006	`public String getPurchaseCountByMileStone(HttpServletRequest request,`	2007	`public String getPurchaseCountByMileStone(HttpServletRequest request,`
2007	`@RequestParam(required = false, defaultValue = "0") int warehouseId, Model model) throws Exception {`	2008	`@RequestParam(required = false, defaultValue = "0") int warehouseId, Model model) throws Exception {`
2008		2009
2009	`LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);`	2010	`LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);`
2010	`String email = loginDetails.getEmailId();`	2011	`String email = loginDetails.getEmailId();`
2011	`Set<Integer> fofoIds = csService.getAuthFofoIds(email, true);`	2012	`Set<Integer> fofoIds = csService1.getAuthFofoIds(email, true);`
2012	`Map<Integer, Double> last3MonthS = orderRepository.selectBillingDatesBetweenSumGroupByRetailerId(`	2013	`Map<Integer, Double> last3MonthS = orderRepository.selectBillingDatesBetweenSumGroupByRetailerId(`
2013	`LocalDateTime.now().withDayOfMonth(1).minusMonths(2), LocalDateTime.now());`	2014	`LocalDateTime.now().withDayOfMonth(1).minusMonths(2), LocalDateTime.now());`
2014		2015
2015	`if (fofoIds != null && fofoIds.size() > 0) {`	2016	`if (fofoIds != null && fofoIds.size() > 0) {`
2016	`if (warehouseId != 0) {`	2017	`if (warehouseId != 0) {`
Line 2106...		Line 2107...
2106	`}`	2107	`}`
2107		2108
2108	`@RequestMapping(value = "/getActivatedModelByBrand", method = RequestMethod.GET)`	2109	`@RequestMapping(value = "/getActivatedModelByBrand", method = RequestMethod.GET)`
2109	`public String getActivatedModelByBrand(HttpServletRequest request, Model model) throws Exception {`	2110	`public String getActivatedModelByBrand(HttpServletRequest request, Model model) throws Exception {`
2110	`LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);`	2111	`LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);`
2111	`Set<Integer> fofoIds = csService.getAuthFofoIds(loginDetails.getEmailId(), true);`	2112	`Set<Integer> fofoIds = csService1.getAuthFofoIds(loginDetails.getEmailId(), true);`
2112		2113
2113	`List<BrandWiseActivatedModel> activatedModels = activatedImeiRepository`	2114	`List<BrandWiseActivatedModel> activatedModels = activatedImeiRepository`
2114	`.selectActivatedModelGroupByBrand(new ArrayList<>(fofoIds));`	2115	`.selectActivatedModelGroupByBrand(new ArrayList<>(fofoIds));`
2115	`model.addAttribute("activatedModels", activatedModels);`	2116	`model.addAttribute("activatedModels", activatedModels);`
2116	`return "activation-brandwise-report";`	2117	`return "activation-brandwise-report";`