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

 import com.spice.profitmandi.common.web.util.ResponseSender;
 import com.spice.profitmandi.dao.entity.catalog.Item;
 import com.spice.profitmandi.dao.entity.catalog.Scheme;
 import com.spice.profitmandi.dao.entity.catalog.TagListing;
 import com.spice.profitmandi.dao.entity.fofo.FofoStore;
+import com.spice.profitmandi.dao.entity.fofo.InventoryItem;
 import com.spice.profitmandi.dao.entity.fofo.PartnerType;
+import com.spice.profitmandi.dao.entity.fofo.SchemeInOut;
 import com.spice.profitmandi.dao.entity.fofo.SchemeItem;
+import com.spice.profitmandi.dao.entity.transaction.PriceDrop;
+import com.spice.profitmandi.dao.entity.transaction.PriceDropIMEI;
 import com.spice.profitmandi.dao.enumuration.catalog.AmountType;
 import com.spice.profitmandi.dao.enumuration.catalog.SchemeType;
+import com.spice.profitmandi.dao.enumuration.transaction.PriceDropImeiStatus;
 import com.spice.profitmandi.dao.model.CreateOfferRequest;
 import com.spice.profitmandi.dao.model.CreateSchemeRequest;
 import com.spice.profitmandi.dao.repository.catalog.ItemRepository;
 import com.spice.profitmandi.dao.repository.catalog.SchemeRepository;
 import com.spice.profitmandi.dao.repository.catalog.StateGstRateRepository;
 import com.spice.profitmandi.dao.repository.catalog.TagListingRepository;
 import com.spice.profitmandi.dao.repository.dtr.FofoStoreRepository;
 import com.spice.profitmandi.dao.repository.dtr.Mongo;
+import com.spice.profitmandi.dao.repository.fofo.InventoryItemRepository;
 import com.spice.profitmandi.dao.repository.fofo.PartnerTypeChangeService;
+import com.spice.profitmandi.dao.repository.fofo.SchemeInOutRepository;
 import com.spice.profitmandi.dao.repository.fofo.SchemeItemRepository;
+import com.spice.profitmandi.dao.repository.transaction.PriceDropIMEIRepository;
+import com.spice.profitmandi.dao.repository.transaction.PriceDropRepository;
 import com.spice.profitmandi.service.authentication.RoleManager;
 import com.spice.profitmandi.service.inventory.InventoryService;
 import com.spice.profitmandi.service.offers.OfferService;
 import com.spice.profitmandi.service.scheme.SchemeService;
 import com.spice.profitmandi.service.user.RetailerService;
 	private Mongo mongoClient;
 	@Autowired
 	private PartnerTypeChangeService partnerTypeChangeService;
+	@Autowired
+	InventoryItemRepository inventoryItemRepository;
+	@Autowired
+	PriceDropIMEIRepository priceDropIMEIRepository;
+	@Autowired
+	PriceDropRepository priceDropRepository;
+	@Autowired
+	SchemeInOutRepository schemeInOutRepository;
 	@RequestMapping(value = "/createScheme", method = RequestMethod.GET)
 	public String createScheme(HttpServletRequest request, Model model) {
 		// Map<Integer, String> itemIdItemDescriptionMap =
 		// inventoryService.getAllItemIdItemDescriptionMap();
 		// model.addAttribute("itemIdItemDescriptionMap", itemIdItemDescriptionMap);
 			@RequestParam(required = false) LocalDate date,
 			@RequestParam(name = "limit", defaultValue = "10") int limit,
 			@RequestParam(name = "searchItem", required = false, defaultValue = "0") int searchItem,
 			@RequestParam(name = "searchTerm", required = false, defaultValue = "") String searchTerm,
 			@RequestParam(name = "partnerType", required = false, defaultValue = "") PartnerType partnerType,
+			@RequestParam(name = "searchImei", required = false, defaultValue = "") String searchImei, Model model)
-			Model model) throws ProfitMandiBusinessException {
+			throws ProfitMandiBusinessException {
 		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
 		boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
 		if (date == null) {
 			date = LocalDate.now();
+		}
 				model.addAttribute("mop", tagListing.getMop());
+			}
 			schemes = schemeService.selectSchemeByPartnerType(partnerType, date, searchItem, isAdmin, offset, limit);
 			model.addAttribute("schemes", schemes);
 			if (schemes.size() == 0) {
-				return "schemes";
-			}
-			//For 7720(HR) remove investment
-			if(item.getBrand().equals("Vivo") && fofoStoreRepository.getWarehousePartnerMap().get(7720).stream().filter(x->x.getId()==loginDetails.getFofoId()).count() > 0) {
-				schemes = schemes.stream().filter(x->!x.getType().equals(SchemeType.INVESTMENT)).collect(Collectors.toList());
-			}
-			float nlc = tagListing.getSellingPrice();
-			for (Scheme scheme : schemes) {
-				if (scheme.getAmountType().equals(AmountType.PERCENTAGE)) {
-					if (tagListing != null) {
+				if (isAdmin)
-						float taxRate = stateGstRateRepository.getIgstTaxRate(Arrays.asList(searchItem))
-								.get(searchItem);
+					return "schemes";
-						float taxableSellingPrice = tagListing.getSellingPrice() / (1 + taxRate / 100);
-						float amount = taxableSellingPrice * scheme.getAmount() / 100;
-						scheme.setAmountModel(
-								FormattingUtils.formatDecimalTwoDigits(amount) + " (" + scheme.getAmount() + "%)");
-						nlc -= amount;
-					}
+				else {
-					else {
-						scheme.setAmountModel(scheme.getAmount() + "%");
-					}
-				} else {
-					scheme.setAmountModel(scheme.getAmount() + "");
-					nlc -= scheme.getAmount();
+					return "schemes-partner";
+				}
+			}
+			// For 7720(HR) remove investment
+			int nlc = this.getNlc(item, loginDetails.getFofoId(), schemes, tagListing, searchItem);
 			size = schemeService.selectSchemeCount(partnerType, date, searchItem, isAdmin);
 			model.addAttribute("start", offset + 1);
 			model.addAttribute("size", size);
 			if (schemes.size() < limit) {
 				model.addAttribute("end", offset + schemes.size());
 			} else {
 				model.addAttribute("end", offset + limit);
+			}
 			model.addAttribute("nlc", Math.round(nlc));
+		} else if (!(searchImei.equals(""))) {
+			LOGGER.info("searchImei" + searchImei);
+			InventoryItem inventoryItem = inventoryItemRepository.selectBySerialNumberFofoId(searchImei,
+					loginDetails.getFofoId());
+			List<SchemeInOut> schemeInOut = new ArrayList<>();
+			Map<Integer, Scheme> schemeMap = new HashMap<>();
+			if (inventoryItem != null) {
+				LOGGER.info("inventoryItem" + inventoryItem);
+				schemeInOut = schemeInOutRepository
+						.selectByInventoryItemIds(new HashSet<>(Arrays.asList(inventoryItem.getId())));
+				LOGGER.info("schemeInOut" + schemeInOut);
+				if (!schemeInOut.isEmpty()) {
+					List<Integer> schemeIds = schemeInOut.stream().map(x -> x.getSchemeId())
+							.collect(Collectors.toList());
+					schemes = schemeRepository.selectBySchemeIds(schemeIds);
+					for (Scheme scheme : schemes) {
+						if (scheme.getAmountType().equals(AmountType.PERCENTAGE)) {
+							scheme.setAmountModel(scheme.getAmount() + "%");
+						} else {
+							scheme.setAmountModel(scheme.getAmount() + "");
+						}
+					}
+					schemeMap = schemes.stream().collect(Collectors.toMap(x -> x.getId(), x -> x));
+				}
+			}
+			model.addAttribute("schemeMap", schemeMap);
+			model.addAttribute("schemeInOut", schemeInOut);
+		}
 		model.addAttribute("searchItem", searchItem);
 		model.addAttribute("searchTerm", searchTerm);
 		model.addAttribute("partnerType", partnerType);
 		model.addAttribute("isAdmin", isAdmin);
 		// model.addAttribute("roleTypes", loginDetails.getRoleTypes());
 		if (isAdmin)
 			return "schemes";
 		else {
 			List<CreateOfferRequest> offers = new ArrayList<>();
+			List<PriceDropIMEI> priceDropImeis = new ArrayList<>();
 			if (searchItem > 0) {
 				offers = offerService.getPublishedOffers(date, loginDetails.getFofoId(), searchItem);
+			}
+			if (!(searchImei.equals(""))) {
+				InventoryItem inventoryItem = inventoryItemRepository.selectBySerialNumberFofoId(searchImei,
+						loginDetails.getFofoId());
+				offers = offerService.getPublishedOffers(date, loginDetails.getFofoId(), inventoryItem.getItemId());
+				priceDropImeis = priceDropIMEIRepository.selectByFofoIdImei(loginDetails.getFofoId(), searchImei);
+				for (PriceDropIMEI priceDropIMEI : priceDropImeis) {
+					int priceDropId = priceDropIMEI.getPriceDropId();
+					PriceDrop pd = priceDropRepository.selectById(priceDropId);
+					priceDropIMEI.setPriceDrop(pd);
+				}
+			}
 			FofoStore fs = fofoStoreRepository.selectByRetailerId(loginDetails.getFofoId());
 			model.addAttribute("offers", offers);
 			model.addAttribute("partnerCode", fs.getCode());
+			model.addAttribute("fofoId", fs.getId());
+			model.addAttribute("priceDropImeis", priceDropImeis);
 			return "schemes-partner";
+		}
+	}
+	private int getNlc(Item item, int fofoId, List<Scheme> schemes, TagListing tagListing, int itemId)
+			throws ProfitMandiBusinessException {
+		if (item.getBrand().equals("Vivo") && fofoStoreRepository.getWarehousePartnerMap().get(7720).stream()
+				.filter(x -> x.getId() == fofoId).count() > 0) {
+			schemes = schemes.stream().filter(x -> !x.getType().equals(SchemeType.INVESTMENT))
+					.collect(Collectors.toList());
+		}
+		float nlc = tagListing.getSellingPrice();
+		for (Scheme scheme : schemes) {
+			if (scheme.getAmountType().equals(AmountType.PERCENTAGE)) {
+				if (tagListing != null) {
+					float taxRate = stateGstRateRepository.getIgstTaxRate(Arrays.asList(itemId)).get(itemId);
+					float taxableSellingPrice = tagListing.getSellingPrice() / (1 + taxRate / 100);
+					float amount = taxableSellingPrice * scheme.getAmount() / 100;
+					scheme.setAmountModel(
+							FormattingUtils.formatDecimalTwoDigits(amount) + " (" + scheme.getAmount() + "%)");
+					nlc -= amount;
+				}
+				else {
+					scheme.setAmountModel(scheme.getAmount() + "%");
+				}
+			} else {
+				scheme.setAmountModel(scheme.getAmount() + "");
+				nlc -= scheme.getAmount();
+			}
+		}
+		return Math.round(nlc);
+	}
 	@RequestMapping(value = "/getPaginatedSchemes", method = RequestMethod.GET)
 	public String getPaginatedSchemes(HttpServletRequest request, @RequestParam(required = false) LocalDate date,
 			@RequestParam(name = "offset", defaultValue = "0") int offset,
 			@RequestParam(name = "limit", defaultValue = "10") int limit,
 			@RequestParam(name = "partnerType", required = false, defaultValue = "ALL") PartnerType partnerType,

Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/SchemeController.java – Rev 28547 → 28795