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

 import com.spice.profitmandi.common.model.ClosingStockOnDate;
 import com.spice.profitmandi.common.model.GrnPendingDataModel;
 import com.spice.profitmandi.common.model.ImeiDropSummaryModel;
 import com.spice.profitmandi.common.model.ItemDescriptionModel;
 import com.spice.profitmandi.common.model.PartnerImeiNotSold;
+import com.spice.profitmandi.common.model.PriceDropImeisModel;
 import com.spice.profitmandi.common.model.PriceDropModel;
 import com.spice.profitmandi.common.model.PriceDropProcessModel;
 import com.spice.profitmandi.common.model.ReporticoResponseModel;
 import com.spice.profitmandi.common.services.ReporticoService;
 import com.spice.profitmandi.common.util.FileUtil;
 import com.spice.profitmandi.dao.entity.catalog.TagListing;
 import com.spice.profitmandi.dao.entity.fofo.InventoryItem;
 import com.spice.profitmandi.dao.entity.inventory.VendorItemPricing;
 import com.spice.profitmandi.dao.entity.transaction.LineItemImei;
 import com.spice.profitmandi.dao.entity.transaction.PriceDrop;
+import com.spice.profitmandi.dao.entity.transaction.PriceDropIMEI;
+import com.spice.profitmandi.dao.enumuration.transaction.PriceDropImeiStatus;
 import com.spice.profitmandi.dao.repository.catalog.ItemRepository;
 import com.spice.profitmandi.dao.repository.catalog.TagListingRepository;
 import com.spice.profitmandi.dao.repository.fofo.InventoryItemRepository;
 import com.spice.profitmandi.dao.repository.fofo.SchemeInOutRepository;
 import com.spice.profitmandi.dao.repository.inventory.VendorItemPricingRepository;
 import com.spice.profitmandi.dao.repository.transaction.LineItemImeisRepository;
+import com.spice.profitmandi.dao.repository.transaction.PriceDropIMEIRepository;
 import com.spice.profitmandi.dao.repository.transaction.PriceDropRepository;
 import com.spice.profitmandi.service.inventory.InventoryService;
 import com.spice.profitmandi.service.pricing.PriceDropService;
 import com.spice.profitmandi.service.scheme.SchemeService;
 import com.spice.profitmandi.service.transaction.TransactionService;
 	@Autowired
 	private MVCResponseSender mvcResponseSender;
 	@Autowired
 	private PriceDropService priceDropService;
 	@Autowired
 	private InventoryItemRepository inventoryItemRepository;
 	@Autowired
 	private WalletService walletService;
 	@Autowired
 	private TagListingRepository tagListingRepository;
 	@Autowired
 	private TransactionService transactionService;
 	@Autowired
+	private PriceDropIMEIRepository priceDropIMEIRepository;
+	@Autowired
 	@Qualifier("catalogItemRepository")
 	private ItemRepository itemRepository;
 	@Autowired
 	private SchemeService schemeService;
 	@Autowired
 	private SchemeInOutRepository schemeInOutRepository;
 	@Autowired
 	ReporticoService reporticoService;
 	@Autowired
 	LineItemImeisRepository lineItemImeisRepository;
 	@RequestMapping(value = "/getItemDescription", method = RequestMethod.GET)
 	public String getItemDescription(HttpServletRequest request, Model model) throws Throwable {
 		List<TagListing> tagListings = tagListingRepository.selectAll(false);
 		Map<Integer, TagListing> tagListingMap = new HashMap<>();
 		Set<ItemDescriptionModel> customItems = new HashSet<>();
 		List<ItemDescriptionModel> newCustomItems = new ArrayList<>();
 		List<Item> items = itemRepository.selectRecentItems(100);
-		for(Item item: items) {
+		for (Item item : items) {
 			ItemDescriptionModel itemDescriptionModel = new ItemDescriptionModel();
 			itemDescriptionModel.setItemId(item.getId());
 			itemDescriptionModel.setItemDescription(item.getItemDescription() + "(" + item.getId() + ")");
 			newCustomItems.add(itemDescriptionModel);
+		}
 		Map<Integer, String> catalogDescription = new HashMap<>();
 		for (TagListing tagListing : tagListings) {
 			Item item = itemRepository.selectById(tagListing.getItemId());
 			tagListing.setItemDescription(item.getItemDescription());
 			tagListingMap.put(tagListing.getItemId(), tagListing);
 			itemDescriptionModel
 					.setItemDescription(tagListing.getItemDescription() + "(" + tagListing.getItemId() + ")");
 			customItems.add(itemDescriptionModel);
 			catalogDescription.put(item.getCatalogItemId(), item.getItemDescriptionNoColor());
+		}
 		newCustomItems.addAll(customItems);
 		List<PriceDrop> priceDrops = priceDropRepository.selectAll();
 		model.addAttribute("tagListingMap", tagListingMap);
 		model.addAttribute("customItems", new JSONArray(customItems).toString());
 		model.addAttribute("priceDrops", priceDrops);
 		model.addAttribute("catalogDescription", catalogDescription);
 		return "price-drop";
+	}
 	@RequestMapping(value = "/item-pricing/{itemId}", method = RequestMethod.GET)
 	public String getItemPricing(HttpServletRequest request, Model model, @PathVariable int itemId) throws Throwable {
 		TagListing tagListing;
 		PriceDropModel pm = new PriceDropModel();
 		try {
 			tagListing = tagListingRepository.selectByItemId(itemId);
-			if(tagListing!=null) {
+			if (tagListing != null) {
 				pm.setMop(tagListing.getMop());
 				pm.setDp(tagListing.getSellingPrice());
 				pm.setMrp(tagListing.getMrp());
 				List<VendorItemPricing> vips = vendorItemPricingRepository.selectAll(itemId);
-				if(vips.size() > 0) {
+				if (vips.size() > 0) {
 					VendorItemPricing vip = vips.get(0);
 					pm.setNlc(vip.getNlc());
 					pm.setTp(vip.getTp());
 				} else {
 					throw new ProfitMandiBusinessException("Item Id", itemId, "Vendor item pricing does not exist");
+				}
+			}
-		} catch(Exception e) {
+		} catch (Exception e) {
 			LOGGER.info("Chose item that doesn't exist");
+		}
 		model.addAttribute("response", mvcResponseSender.createResponseString(pm));
 		return "response";
+	}
+	/*
-	/*@RequestMapping(value = "/price-drop/imes1/download")
+	 * @RequestMapping(value = "/price-drop/imes1/download") public
-	public ResponseEntity<ByteArrayResource> downloadPriceDropImeis1(HttpServletRequest request,
+	 * ResponseEntity<ByteArrayResource> downloadPriceDropImeis1(HttpServletRequest
+	 * request,
+	 *
-			@RequestParam LocalDateTime affectedDate, @RequestParam int itemId) throws Exception {
+	 * @RequestParam LocalDateTime affectedDate, @RequestParam int itemId) throws
-		Item item = itemRepository.selectById(itemId);
+	 * Exception { Item item = itemRepository.selectById(itemId);
+	 * List<ImeiDropSummaryModel> imeiDropSummaryModelList =
-		List<ImeiDropSummaryModel> imeiDropSummaryModelList = this.getAllSerialNumbersByAffectedDate(affectedDate, item.getCatalogItemId());
+	 * this.getAllSerialNumbersByAffectedDate(affectedDate,
+	 * item.getCatalogItemId()); List<String> imeis =
-		List<String> imeis = imeiDropSummaryModelList.stream().map(x->x.getSerialNumber()).collect(Collectors.toList());
+	 * imeiDropSummaryModelList.stream().map(x->x.getSerialNumber()).collect(
+	 * Collectors.toList()); Map<String, ImeiDropSummaryModel> imeisDropMap =
-		Map<String, ImeiDropSummaryModel> imeisDropMap = imeiDropSummaryModelList.stream().collect(Collectors.toMap(ImeiDropSummaryModel::getSerialNumber, x->x));
+	 * imeiDropSummaryModelList.stream().collect(Collectors.toMap(
+	 * ImeiDropSummaryModel::getSerialNumber, x->x)); List<InventoryItem>
-		List<InventoryItem> inventoryItems = inventoryItemRepository.selectBySerialNumbers(new HashSet<>(imeis));
+	 * inventoryItems = inventoryItemRepository.selectBySerialNumbers(new
+	 * HashSet<>(imeis)); List<Integer> inventoryItemIds =
-		List<Integer> inventoryItemIds = inventoryItems.stream().map(InventoryItem::getId).collect(Collectors.toList());
+	 * inventoryItems.stream().map(InventoryItem::getId).collect(Collectors.toList()
+	 * );
+	 *
+	 * List<SchemeInOut> schemeInOuts =
-		List<SchemeInOut> schemeInOuts = schemeInOutRepository.selectByInventoryItemIds(new HashSet<>(inventoryItemIds));
+	 * schemeInOutRepository.selectByInventoryItemIds(new
+	 * HashSet<>(inventoryItemIds));
+	 *
-		Set<ItemQuantity> itemSchemes = new HashSet<>();
+	 * Set<ItemQuantity> itemSchemes = new HashSet<>(); Map<ItemQuantity,
-		Map<ItemQuantity, SchemeInOut> itemSchemeInOutMap = new HashMap<>();
+	 * SchemeInOut> itemSchemeInOutMap = new HashMap<>(); for(SchemeInOut
-		for(SchemeInOut schemeInOut : schemeInOuts) {
-		}
-		List<List<Object>> rows = new ArrayList<>();
+	 * schemeInOut : schemeInOuts) { } List<List<Object>> rows = new ArrayList<>();
-		for (ImeiDropSummaryModel imeiDropSummaryModel : imeiDropSummaryModelList) {
+	 * for (ImeiDropSummaryModel imeiDropSummaryModel : imeiDropSummaryModelList) {
-			List<Object> row = this.getRow(imeiDropSummaryModel);
+	 * List<Object> row = this.getRow(imeiDropSummaryModel);
+	 *
-			rows.add(this.getRow(imeiDropSummaryModel));
+	 * rows.add(this.getRow(imeiDropSummaryModel)); }
-		}
+	 *
-		FileUtil.getCSVByteStream(Arrays.asList("IMEI Number", "Store Name", "Store Code", "Item ID", "Brand",
+	 * FileUtil.getCSVByteStream(Arrays.asList("IMEI Number", "Store Name",
-				"Model Name", "Model Number", "Color", "Last Scanned"),
+	 * "Store Code", "Item ID", "Brand", "Model Name", "Model Number", "Color",
-				rows);
-		final HttpHeaders headers = new HttpHeaders();
+	 * "Last Scanned"), rows); final HttpHeaders headers = new HttpHeaders();
+	 * headers.set("Content-Type",
-		headers.set("Content-Type", "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
+	 * "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
-		headers.set("Content-disposition", "inline; filename=imei-" + item.getItemDescriptionNoColor() + ".csv");
+	 * headers.set("Content-disposition", "inline; filename=imei-" +
+	 * item.getItemDescriptionNoColor() + ".csv"); return new
-		return new ResponseEntity<ByteArrayResource>(null, headers, HttpStatus.OK);
+	 * ResponseEntity<ByteArrayResource>(null, headers, HttpStatus.OK);
+	 *
+	 * }
-	}*/
+	 */
 	@RequestMapping(value = "/price-drop/imes/download")
 	public ResponseEntity<ByteArrayResource> downloadPriceDropImeis(HttpServletRequest request,
 			@RequestParam LocalDateTime affectedDate, @RequestParam int itemId) throws Exception {
 		Item item = itemRepository.selectById(itemId);
 		ByteArrayOutputStream baos = getByteArrayOutputStream(affectedDate, item.getCatalogItemId());
 		byte[] byteArray = baos.toByteArray();
 		headers.setContentLength(byteArray.length);
 		return new ResponseEntity<ByteArrayResource>(new ByteArrayResource(byteArray), headers, HttpStatus.OK);
+	}
+	@RequestMapping(value = "/price-drop/addPayout", method = RequestMethod.POST)
+	public String updatePriceDrop(HttpServletRequest request, @RequestBody PriceDropProcessModel priceDropProcessModel,
+			Model model) throws Exception {
+		boolean response = false;
+		PriceDrop priceDrop = priceDropRepository.selectById(priceDropProcessModel.getPriceDropId());
+		if (priceDrop.getProcessTimestamp() == null) {
+			priceDrop.setPartnerPayout(priceDropProcessModel.getPartnerPayout());
+			priceDrop.setPriceDropIn(priceDropProcessModel.getPriceDropIn());
+			// priceDrop.setProcessTimestamp(LocalDateTime.now());
+			priceDropRepository.persist(priceDrop);
+			response = true;
+		}
+		model.addAttribute("response", mvcResponseSender.createResponseString(response));
+		return "response";
+	}
+	@RequestMapping(value = "/priceDropImeis/{priceDropId}", method = RequestMethod.GET)
+	public String priceDropStatus(HttpServletRequest request, @PathVariable int priceDropId, Model model)
+			throws Exception {
+		PriceDropImeisModel priceDropImeisModel = new PriceDropImeisModel();
+		List<String> pendingImeis = new ArrayList<>();
+		List<String> approvedImeis = new ArrayList<>();
+		List<String> rejectedImeis = new ArrayList<>();
+		List<PriceDropIMEI> priceDropImeis = priceDropIMEIRepository.selectByPriceDropId(priceDropId);
+		if (priceDropImeis.size() == 0) {
+			PriceDrop priceDrop = priceDropRepository.selectById(priceDropId);
+			List<ImeiDropSummaryModel> imeis = this.getAllSerialNumbersByAffectedDate(priceDrop.getAffectedOn(),
+					priceDrop.getCatalogItemId());
+			for (ImeiDropSummaryModel imei : imeis) {
+				PriceDropIMEI priceDropIMEI = new PriceDropIMEI();
+				priceDropIMEI.setImei(imei.getSerialNumber());
+				priceDropIMEI.setPriceDropId(priceDropId);
+				priceDropIMEI.setPartnerId(imei.getRetailerId());
+				priceDropIMEIRepository.persist(priceDropIMEI);
+			}
+			priceDropImeis = priceDropIMEIRepository.selectByPriceDropId(priceDropId);
+		}
+		for (PriceDropIMEI priceDropIMEI : priceDropImeis) {
+			if (priceDropIMEI.getStatus().equals(PriceDropImeiStatus.PENDING)) {
+				pendingImeis.add(priceDropIMEI.getImei());
+			} else if (priceDropIMEI.getStatus().equals(PriceDropImeiStatus.APPROVED)) {
+				approvedImeis.add(priceDropIMEI.getImei());
+			}
+			if (priceDropIMEI.getStatus().equals(PriceDropImeiStatus.REJECTED)) {
+				rejectedImeis.add(priceDropIMEI.getImei());
+			}
+		}
+		priceDropImeisModel.setPendingImeis(pendingImeis);
+		priceDropImeisModel.setPriceDropId(priceDropId);
+		priceDropImeisModel.setApprovedImeis(approvedImeis);
+		priceDropImeisModel.setRejectedImeis(rejectedImeis);
+		model.addAttribute("response", mvcResponseSender.createResponseString(priceDropImeisModel));
+		return "response";
+	}
 	@RequestMapping(value = "/processPriceDrop", method = RequestMethod.POST)
 	public String processPriceDrop(HttpServletRequest request, @RequestBody PriceDropProcessModel priceDropProcess,
 			Model model) throws Exception {
 		PriceDrop priceDrop = priceDropRepository.selectById(priceDropProcess.getPriceDropId());
 		boolean response = false;
 		if (priceDrop.getProcessTimestamp() == null) {
-			priceDrop.setPartnerPayout(priceDropProcess.getPartnerPayout());
-			priceDrop.setPriceDropIn(priceDropProcess.getPriceDropIn());
 			priceDrop.setProcessTimestamp(LocalDateTime.now());
 			priceDropRepository.persist(priceDrop);
-			Item item = itemRepository.selectAllByCatalogItemId(priceDrop.getCatalogItemId()).get(0);
-			String description = item.getItemDescriptionNoColor();
-			List<ImeiDropSummaryModel> imeiDropSummaryModels = this.getAllSerialNumbersByAffectedDate(priceDrop.getAffectedOn(),
-					priceDrop.getCatalogItemId());
-			if (imeiDropSummaryModels.size() > 0) {
-				List<String> serialNumbers = imeiDropSummaryModels.stream().map(x->x.getSerialNumber()).collect(Collectors.toList());
-				List<LineItemImei> lineItemImeis = lineItemImeisRepository.selectByIMEI(serialNumbers);
-				Map<Integer, List<InventoryItem>> pendingPartnerInventoryMap = priceDropService.getInventoryForPriceDrop(lineItemImeis, priceDrop).
-						stream().collect(Collectors.groupingBy(InventoryItem::getFofoId));
-				for (Map.Entry<Integer, List<InventoryItem>> pendingPartnerInventory : pendingPartnerInventoryMap.entrySet()) {
-					List<InventoryItem> fofoInventoryList = pendingPartnerInventory.getValue();
-					int fofoId = pendingPartnerInventory.getKey();
-					String reversalReason = MessageFormat.format(
-							"Scheme  differential for Price Drop of Rs.{0} on {1}, on {3}. Total {2} item(s)",
-							priceDrop.getAmount(), description, fofoInventoryList.size(),
-							FormattingUtils.formatDate(priceDrop.getAffectedOn()));
-					String aReason = MessageFormat.format(
-							"Payout of Rs.{4} per unit for Price Drop of Rs.{0} on {1}, on {3}. Total {2} item(s)",
-							priceDrop.getAmount(), description, fofoInventoryList.size(),
-							FormattingUtils.formatDate(priceDrop.getAffectedOn()), priceDropProcess.getPartnerPayout());
-					inventoryService.updatePriceDrop(fofoInventoryList, priceDrop.getAmount());
-					if(item.getBrand().equals("Samsung")) {
-						schemeService.reverseSchemes(fofoInventoryList, priceDropProcess.getPriceDropId(), reversalReason);
-					}
-					walletService.addAmountToWallet(fofoId, priceDrop.getId(), WalletReferenceType.PRICE_DROP, aReason,
-							priceDrop.getPartnerPayout() * fofoInventoryList.size());
-				}
-			}
 			response = true;
+		}
 		model.addAttribute("response", mvcResponseSender.createResponseString(response));
 		return "response";
+	}
 	@RequestMapping(value = "/updateMop", method = RequestMethod.POST)
-	public String addMop(HttpServletRequest request, Model model, @RequestBody PriceDropModel priceDropModel) throws Exception {
+	public String addMop(HttpServletRequest request, Model model, @RequestBody PriceDropModel priceDropModel)
+			throws Exception {
 		boolean response = false;
 		priceDropModel.setAllColors(true);
 		TagListing tagListing = tagListingRepository.selectByItemId(priceDropModel.getItemId());
 		float newDp = tagListing.getSellingPrice() - priceDropModel.getPd();
 		List<Item> allItems = null;
 				vendorItemPricingRepository.persist(vip);
+			}
 			transactionService.updatePriceDrop(item.getId(), newDp);
+		}
 		PriceDrop priceDrop = new PriceDrop();
-		priceDrop.setAffectedOn(LocalDateTime.of(LocalDate.now(),LocalTime.MIDNIGHT));
+		priceDrop.setAffectedOn(LocalDateTime.of(LocalDate.now(), LocalTime.MIDNIGHT));
 		priceDrop.setOldDp(tagListing.getSellingPrice());
 		priceDrop.setAmount(priceDropModel.getPd());
 		priceDrop.setNewDp(tagListing.getSellingPrice());
 		priceDrop.setNlc(priceDropModel.getNlc());
 		priceDrop.setTp(priceDropModel.getTp());
 		headers.setContentLength(byteArray.length);
 		return new ResponseEntity<ByteArrayResource>(new ByteArrayResource(byteArray), headers, HttpStatus.OK);
+	}
+	@RequestMapping(value = "/updatePriceDropImeis", method = RequestMethod.POST)
+	public String downloadTotalPriceDropIMEI(HttpServletRequest request,
+			@RequestBody PriceDropImeisModel priceDropImeisModel, Model model)
+			throws ProfitMandiBusinessException, Exception {
+		PriceDropImeiStatus status=PriceDropImeiStatus.PENDING;;
+		switch (priceDropImeisModel.getUpdatedStatus()) {
+		case "pending": {
+			status = PriceDropImeiStatus.PENDING;
+			break;
+		}
+		case "approved": {
+			status = PriceDropImeiStatus.APPROVED;
+			break;
+		}
+		case "rejected": {
+			status = PriceDropImeiStatus.REJECTED;
+			break;
+		}
+		}
+		List<PriceDropIMEI> priceDropIMEIs = priceDropIMEIRepository
+				.selectByPriceDropId(priceDropImeisModel.getPriceDropId());
+		List<PriceDropIMEI> priceDropIMEIsToProcess = new ArrayList<>();
+		for (PriceDropIMEI priceDropIMEI : priceDropIMEIs) {
+			if (!priceDropImeisModel.getUpdatedImeis().contains(priceDropIMEI.getImei())
+					|| priceDropIMEI.getStatus().equals(PriceDropImeiStatus.APPROVED)
+					|| priceDropIMEI.getStatus().equals(status)) {
+				continue;
+			} else {
+				if(status.equals(PriceDropImeiStatus.APPROVED)) {
+					priceDropIMEIsToProcess.add(priceDropIMEI);
+				}
+				priceDropIMEI.setStatus(status);
+				priceDropIMEI.setUpdateTimestamp(LocalDateTime.now());
+				priceDropIMEIRepository.persist(priceDropIMEI);
+			}
+		}
+		PriceDrop priceDrop = priceDropRepository.selectById(priceDropImeisModel.getPriceDropId());
+		Item item = itemRepository.selectAllByCatalogItemId(priceDrop.getCatalogItemId()).get(0);
+		String description = item.getItemDescriptionNoColor();
+		if (priceDropIMEIsToProcess.size() > 0) {
+			List<String> serialNumbers = priceDropIMEIsToProcess.stream().map(x -> x.getImei())
+					.collect(Collectors.toList());
+			List<LineItemImei> lineItemImeis = lineItemImeisRepository.selectByIMEI(serialNumbers);
+			Map<Integer, List<InventoryItem>> pendingPartnerInventoryMap = priceDropService
+					.getInventoryForPriceDrop(lineItemImeis, priceDrop).stream()
+					.collect(Collectors.groupingBy(InventoryItem::getFofoId));
+			for (Map.Entry<Integer, List<InventoryItem>> pendingPartnerInventory : pendingPartnerInventoryMap
+					.entrySet()) {
+				List<InventoryItem> fofoInventoryList = pendingPartnerInventory.getValue();
+				int fofoId = pendingPartnerInventory.getKey();
+				String reversalReason = MessageFormat.format(
+						"Scheme  differential for Price Drop of Rs.{0} on {1}, on {3}. Total {2} item(s)",
+						priceDrop.getAmount(), description, fofoInventoryList.size(),
+						FormattingUtils.formatDate(priceDrop.getAffectedOn()));
+				String aReason = MessageFormat.format(
+						"Payout of Rs.{4} per unit for Price Drop of Rs.{0} on {1}, on {3}. Total {2} item(s)",
+						priceDrop.getAmount(), description, fofoInventoryList.size(),
+						FormattingUtils.formatDate(priceDrop.getAffectedOn()), priceDrop.getPartnerPayout());
+				inventoryService.updatePriceDrop(fofoInventoryList, priceDrop.getAmount());
+				if (item.getBrand().equals("Samsung")) {
+					schemeService.reverseSchemes(fofoInventoryList, priceDrop.getId(),
+							reversalReason);
+				}
+				walletService.addAmountToWallet(fofoId, priceDrop.getId(), WalletReferenceType.PRICE_DROP, aReason,
+						priceDrop.getPartnerPayout() * fofoInventoryList.size());
+			}
+		}
+		model.addAttribute("response", mvcResponseSender.createResponseString(true));
+		return "response";
+	}
 	private List<ImeiDropSummaryModel> getAllSerialNumbersByAffectedDate(LocalDateTime affectedOn,
 			Integer catalogItemId) throws Exception {
 		List<Item> items = itemRepository.selectAllByCatalogItemId(catalogItemId);
 		List<String> itemIds = items.stream().map(x -> String.valueOf(x.getId())).collect(Collectors.toList());
 		return mergedImeis;
+	}
 	private ByteArrayOutputStream getByteArrayOutputStream(LocalDateTime affectedOn, Integer catalogItemId)
 			throws Exception {
-		List<ImeiDropSummaryModel> imeiDropSummaryModelList = this.getAllSerialNumbersByAffectedDate(affectedOn, catalogItemId);
+		List<ImeiDropSummaryModel> imeiDropSummaryModelList = this.getAllSerialNumbersByAffectedDate(affectedOn,
+				catalogItemId);
 		List<List<Object>> rows = new ArrayList<>();
 		for (ImeiDropSummaryModel imeiDropSummaryModel : imeiDropSummaryModelList) {
 			rows.add(this.getRow(imeiDropSummaryModel));
+		}
 		return FileUtil.getCSVByteStream(Arrays.asList("IMEI Number", "Store Name", "Store Code", "Item ID", "Brand",
 				"Model Name", "Model Number", "Color", "Last Scanned"), rows);
+	}
 	private List<Object> getRow(ImeiDropSummaryModel imeiDropSummaryModel) {
 		List<Object> row = new ArrayList<>();
 		row.add(imeiDropSummaryModel.getSerialNumber());
 		row.add(imeiDropSummaryModel.getStoreName());
 		row.add(imeiDropSummaryModel.getPartnerCode());

Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/PriceDropController.java – Rev 24063 → 24083