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

 package com.spice.profitmandi.web.controller;
-import java.io.ByteArrayInputStream;
-import java.io.ByteArrayOutputStream;
-import java.io.InputStream;
 import java.time.LocalDateTime;
 import java.util.ArrayList;
 import java.util.Arrays;
 import java.util.HashMap;
 import java.util.LinkedHashMap;
 import java.util.stream.Collectors;
 import javax.servlet.http.HttpServletRequest;
 import javax.transaction.Transactional;
+import org.apache.http.HttpResponse;
 import org.apache.logging.log4j.LogManager;
 import org.apache.logging.log4j.Logger;
 import org.json.JSONArray;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.beans.factory.annotation.Qualifier;
-import org.springframework.core.io.InputStreamResource;
-import org.springframework.http.HttpHeaders;
 import org.springframework.http.HttpStatus;
 import org.springframework.http.ResponseEntity;
 import org.springframework.stereotype.Controller;
 import org.springframework.ui.Model;
 import org.springframework.web.bind.annotation.PathVariable;
 import org.springframework.web.bind.annotation.RequestBody;
 import org.springframework.web.bind.annotation.RequestMapping;
 import org.springframework.web.bind.annotation.RequestMethod;
+import com.fasterxml.jackson.core.type.TypeReference;
+import com.fasterxml.jackson.databind.ObjectMapper;
+import com.fasterxml.jackson.databind.ObjectReader;
+import com.spice.profitmandi.common.enumuration.ReporticoProject;
 import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
+import com.spice.profitmandi.common.model.ClosingStockOnDate;
+import com.spice.profitmandi.common.model.GrnPendingDataModel;
 import com.spice.profitmandi.common.model.ItemDescriptionModel;
+import com.spice.profitmandi.common.model.PartnerImeiNotSold;
 import com.spice.profitmandi.common.model.PriceDropModel;
+import com.spice.profitmandi.common.model.ReporticoResponseModel;
+import com.spice.profitmandi.common.services.ReporticoService;
-import com.spice.profitmandi.common.util.ExcelUtils;
+import com.spice.profitmandi.common.util.FormattingUtils;
 import com.spice.profitmandi.dao.entity.catalog.Item;
 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;
 	private static final Logger LOGGER = LogManager.getLogger(PriceDropController.class);
 	@Autowired
 	private PriceDropRepository priceDropRepository;
+	private ObjectMapper objectMapper = new ObjectMapper();
 	@Autowired
 	private PriceDropIMEIRepository priceDropIMEIRepository;
 	@Autowired
 	private VendorItemPricingRepository vendorItemPricingRepository;
 	@Autowired
 	private PriceDropService priceDropService;
 	@Autowired
 	@Qualifier("fofoInventoryService")
 	private InventoryService inventoryService;
 	@Autowired
 	private MVCResponseSender mvcResponseSender;
 	@Autowired
 	private WalletService walletService;
 	@Autowired
 	private LineItemImeisRepository lineItemImeisRepository;
 	@Autowired
 	private TagListingRepository tagListingRepository;
 	@Autowired
 	private TransactionService transactionService;
 	@Autowired
 	@Qualifier("catalogItemRepository")
 	private ItemRepository itemRepository;
+	@Autowired
+	ReporticoService reporticoService;
 	@RequestMapping(value = "/getItemDescription", method = RequestMethod.GET)
-	public String getItemDescription(HttpServletRequest request, Model model) throws Throwable{
+	public String getItemDescription(HttpServletRequest request, Model model) throws Throwable {
 		List<TagListing> tagListings = tagListingRepository.selectAll(false);
 		Map<Integer, TagListing> tagListingMap = new HashMap<>();
 		List<ItemDescriptionModel> customItems = new ArrayList<>();
-		for(TagListing tagListing : tagListings) {
+		for (TagListing tagListing : tagListings) {
 			tagListing.setItemDescription(itemRepository.selectById(tagListing.getItemId()).getItemDescription());
 			tagListingMap.put(tagListing.getItemId(), tagListing);
 			ItemDescriptionModel itemDescriptionModel = new ItemDescriptionModel();
 			itemDescriptionModel.setItemId(tagListing.getItemId());
+			itemDescriptionModel
-			itemDescriptionModel.setItemDescription(tagListing.getItemDescription() + "(" + tagListing.getItemId()	 +")");
+					.setItemDescription(tagListing.getItemDescription() + "(" + tagListing.getItemId() + ")");
 			customItems.add(itemDescriptionModel);
+		}
 		List<PriceDrop> priceDrops = priceDropRepository.selectAll();
 		model.addAttribute("tagListingMap", tagListingMap);
 		model.addAttribute("customItems", new JSONArray(customItems).toString());
 		model.addAttribute("priceDrops", priceDrops);
 		return "price-drop";
+	}
+	/*
-	@RequestMapping(value = "/downloadPriceDropIMEI/{priceDropId}", method = RequestMethod.GET)
+	 * @RequestMapping(value = "/downloadtotalPriceDropIMEI/{priceDropId}", method =
+	 * RequestMethod.GET) public ResponseEntity<?>
-	public ResponseEntity<?> downloadPriceDropIMEI(HttpServletRequest request, @PathVariable int priceDropId,
+	 * downloadPriceDropIMEI(HttpServletRequest request, @PathVariable int
-			Model model) throws ProfitMandiBusinessException {
+	 * priceDropId, Model model) throws ProfitMandiBusinessException {
+	 *
-		PriceDrop priceDrop = priceDropRepository.selectById(priceDropId);
+	 * PriceDrop priceDrop = priceDropRepository.selectById(priceDropId);
+	 * List<PriceDropIMEI> priceDropIMEIs =
-		List<PriceDropIMEI> priceDropIMEIs = priceDropIMEIRepository.selectByPriceDropId(priceDrop.getId());
+	 * priceDropIMEIRepository.selectByPriceDropId(priceDrop.getId()); List<String>
-		List<String> imeis = priceDropIMEIs.stream().map(x -> x.getImei()).collect(Collectors.toList());
+	 * imeis = priceDropIMEIs.stream().map(x ->
+	 * x.getImei()).collect(Collectors.toList()); List<LineItemImei> lineItemImeis =
-		List<LineItemImei> lineItemImeis = lineItemImeisRepository.selectByIMEI(imeis);
+	 * lineItemImeisRepository.selectByIMEI(imeis); Map<String, String>
-		Map<String, String> priceDropIMEIfofoId = priceDropService.getIMEIandRetailerName(lineItemImeis, priceDrop);
+	 * priceDropIMEIfofoId = priceDropService.getIMEIandRetailerName(lineItemImeis,
-		if (priceDropIMEIfofoId.size() > 0) {
+	 * priceDrop); if (priceDropIMEIfofoId.size() > 0) { ByteArrayOutputStream
-			ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
+	 * byteArrayOutputStream = new ByteArrayOutputStream();
-			ExcelUtils.writePriceDrop(priceDropIMEIfofoId, priceDrop.getItemId(), byteArrayOutputStream);
+	 * ExcelUtils.writePriceDrop(priceDropIMEIfofoId, priceDrop.getItemId(),
-			final HttpHeaders headers = new HttpHeaders();
+	 * byteArrayOutputStream); final HttpHeaders headers = new HttpHeaders(); //
-			// private static final String CONTENT_TYPE_XLSX =
+	 * private static final String CONTENT_TYPE_XLSX = //
-			// "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
+	 * "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
+	 * headers.set("Content-Type",
-			headers.set("Content-Type", "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
+	 * "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); //
-			// headers.set("Content-Type", "application/vnd.ms-excel");
+	 * headers.set("Content-Type", "application/vnd.ms-excel");
-			headers.set("Content-disposition", "inline; filename=priceDrop" + priceDrop.getId() + ".xlsx");
+	 * headers.set("Content-disposition", "inline; filename=priceDrop" +
+	 * priceDrop.getId() + ".xlsx");
-			headers.setContentLength(byteArrayOutputStream.toByteArray().length);
+	 * headers.setContentLength(byteArrayOutputStream.toByteArray().length); final
+	 * InputStream inputStream = new
-			final InputStream inputStream = new ByteArrayInputStream(byteArrayOutputStream.toByteArray());
+	 * ByteArrayInputStream(byteArrayOutputStream.toByteArray()); final
-			final InputStreamResource inputStreamResource = new InputStreamResource(inputStream);
+	 * InputStreamResource inputStreamResource = new
+	 * InputStreamResource(inputStream); return new
-			return new ResponseEntity<InputStreamResource>(inputStreamResource, headers, HttpStatus.OK);
+	 * ResponseEntity<InputStreamResource>(inputStreamResource, headers,
-		} else {
+	 * HttpStatus.OK); } else { throw new
-			throw new ProfitMandiBusinessException("priceDropId", priceDropId, "No IMEI is Eligible For PriceDrop");
+	 * ProfitMandiBusinessException("priceDropId", priceDropId,
+	 * "No IMEI is Eligible For PriceDrop"); }
-		}
+	 *
+	 * }
-	}
+	 */
 	@RequestMapping(value = "/paymentAgainstPriceDrop/{priceDropId}/{processedamount}", method = RequestMethod.POST)
 	public String paymentAgainstPriceDropIMEI(HttpServletRequest request, @PathVariable int priceDropId,
 			@PathVariable int processedamount, Model model) throws Exception {
 		int noOfIMEIForPartner = 1;
 		Map<Integer, Integer> noOfPriceDropToPartners = new HashMap<>();
 		PriceDrop priceDrop = priceDropRepository.selectById(priceDropId);
 		Item item = itemRepository.selectById(priceDrop.getItemId());
 		List<PriceDropIMEI> priceDropIMEIs = priceDropIMEIRepository.selectByPriceDropId(priceDrop.getId());
 			return "false";
+		}
+	}
 	@RequestMapping(value = "/priceDrop", method = RequestMethod.POST)
-	public String addPriceDrop(HttpServletRequest request, Model model, @RequestBody PriceDropModel priceDropModel) throws Exception {
+	public String addPriceDrop(HttpServletRequest request, Model model, @RequestBody PriceDropModel priceDropModel)
+			throws Exception {
 		boolean response = false;
-		if(this.validatePriceDrop(priceDropModel)) {
+		if (this.validatePriceDrop(priceDropModel)) {
 			TagListing tagListing = tagListingRepository.selectByItemId(priceDropModel.getItemId());
 			float newDp = tagListing.getSellingPrice() - priceDropModel.getPd();
-			if(newDp > 0) {
+			if (newDp > 0) {
 				List<Item> allItems = null;
 				Item currentItem = itemRepository.selectById(priceDropModel.getItemId());
-				if(priceDropModel.isAllColors()) {
+				if (priceDropModel.isAllColors()) {
 					allItems = itemRepository.selectAllByCatalogItemId(currentItem.getCatalogItemId());
 				} else {
-					allItems=Arrays.asList(currentItem);
+					allItems = Arrays.asList(currentItem);
+				}
-				for(Item item : allItems) {
+				for (Item item : allItems) {
 					TagListing itemTagListing = tagListingRepository.selectByItemId(item.getId());
-					if(itemTagListing == null) continue;
+					if (itemTagListing == null)
+						continue;
 					itemTagListing.setSellingPrice(newDp);
 					itemTagListing.setMop(priceDropModel.getMop());
 					tagListingRepository.persist(tagListing);
 					List<VendorItemPricing> vipList = vendorItemPricingRepository.selectAll(item.getId());
-					for(VendorItemPricing vip : vipList) {
+					for (VendorItemPricing vip : vipList) {
 						vip.setDp(newDp);
 						vip.setMop(priceDropModel.getMop());
 						vip.setNlc(priceDropModel.getNlc());
 						vip.setTp(priceDropModel.getTp());
 						vendorItemPricingRepository.persist(vip);
 					priceDropRepository.persist(priceDrop);
 					transactionService.updatePriceDrop(item.getId(), newDp);
+				}
 				response = true;
 			} else {
-				throw new ProfitMandiBusinessException("Price Drop", priceDropModel.getPd(), "Price Drop Cannot be more than Current DP");
+				throw new ProfitMandiBusinessException("Price Drop", priceDropModel.getPd(),
+						"Price Drop Cannot be more than Current DP");
+			}
+		}
 		model.addAttribute("response", mvcResponseSender.createResponseString(response));
 		return "response";
+	}
 	@RequestMapping(value = "/downloadtotalPriceDropIMEI/{priceDropId}", method = RequestMethod.GET)
 	public ResponseEntity<?> downloadTotalPriceDropIMEI(HttpServletRequest request, @PathVariable int priceDropId,
-			Model model) throws ProfitMandiBusinessException {
+			Model model) throws ProfitMandiBusinessException, Exception {
 		PriceDrop priceDrop = priceDropRepository.selectById(priceDropId);
+		Map<String, String> params = new HashMap<>();
+		params.put("MANUAL_criteria1_FROMDATE", FormattingUtils.formatReporitcoDate(priceDrop.getAffectedOn()));
+		params.put("MANUAL_itemId", String.valueOf(priceDrop.getItemId()));
+		Map<String, String> params1 = new HashMap<>();
+		params1.put("MANUAL_criteriaDate_FROMDATE", FormattingUtils.formatReporitcoDate(priceDrop.getAffectedOn()));
-		Map<String, String> priceDropIMEIAndItemId = this.getpriceDropIMEIAndItemDescription(priceDrop);
+		params1.put("MANUAL_criteriaItemId", String.valueOf(priceDrop.getItemId()));
-		if (priceDropIMEIAndItemId.size() > 0) {
+		Map<String, String> params2 = new HashMap<>();
+		params2.put("MANUAL_Criteria2_FROMDATE", FormattingUtils.formatReporitcoDate(priceDrop.getAffectedOn()));
+		params2.put("MANUAL_Criteria1", String.valueOf(priceDrop.getItemId()));
+		List<GrnPendingDataModel> grnPendingList = getReports(GrnPendingDataModel.class, ReporticoProject.FOCO, "imeispendinggrn.xml", params);
+		List<PartnerImeiNotSold> partnerImeiNotSoldList = getReports(PartnerImeiNotSold.class, ReporticoProject.FOCO, "PartnerIMEINotSold.xml", params1);
+		List<ClosingStockOnDate> itemStockOnDateList = getReports(ClosingStockOnDate.class, ReporticoProject.WAREHOUSENEW, "itemstockondate.xml", params2);
+		return new ResponseEntity<Boolean>(true, null, HttpStatus.OK);
+		//List<Strng>
+		/*
-			ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
+		 * ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
-			ExcelUtils.writePriceDropForAllIMEI(priceDropIMEIAndItemId, byteArrayOutputStream);
+		 * ExcelUtils.writePriceDropForAllIMEI(priceDropIMEIAndItemId,
-			final HttpHeaders headers = new HttpHeaders();
+		 * byteArrayOutputStream); 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=totalPriceDropIMEI" + priceDrop.getItemId() + ".xlsx");
+		 * headers.set("Content-disposition", "inline; filename=totalPriceDropIMEI" +
+		 * priceDrop.getItemId() + ".xlsx");
-			headers.setContentLength(byteArrayOutputStream.toByteArray().length);
+		 * headers.setContentLength(byteArrayOutputStream.toByteArray().length); final
+		 * InputStream inputStream = new
-			final InputStream inputStream = new ByteArrayInputStream(byteArrayOutputStream.toByteArray());
+		 * ByteArrayInputStream(byteArrayOutputStream.toByteArray()); final
-			final InputStreamResource inputStreamResource = new InputStreamResource(inputStream);
+		 * InputStreamResource inputStreamResource = new
+		 * InputStreamResource(inputStream); return new
-			return new ResponseEntity<InputStreamResource>(inputStreamResource, headers, HttpStatus.OK);
+		 * ResponseEntity<InputStreamResource>(inputStreamResource, headers,
+		 * HttpStatus.OK); } else { priceDrop.setProcessTimestamp(LocalDateTime.now());
+		 * throw new ProfitMandiBusinessException("IMEI", 1,
+		 * "IMEI not Found For PriceDrop"); }
-		} else {
+		 */
+	}
+	private <T> List<T> getReports(Class<T> className, ReporticoProject project, String reportName,
-			priceDrop.setProcessTimestamp(LocalDateTime.now());
+			Map<String, String> params) throws Exception {
-			throw new ProfitMandiBusinessException("IMEI", 1, "IMEI not Found For PriceDrop");
+		HttpResponse reportResponse = reporticoService.getJsonFile(project, reportName, params);
+		TypeReference<ReporticoResponseModel<T>> typeReference = new TypeReference<ReporticoResponseModel<T>>() {
-		}
+		};
+		ObjectReader or = objectMapper.readerFor(typeReference);
+		ReporticoResponseModel<T> responseObj = or.readValue(reportResponse.getEntity().getContent());
+		return responseObj.getData();
+	}
 	private boolean validatePriceDrop(PriceDropModel priceDropModel) throws ProfitMandiBusinessException {
-		if(priceDropModel.getMop() > 0 && priceDropModel.getMop() > 0 && priceDropModel.getNlc() > 0 && priceDropModel.getTp() > 0 && priceDropModel.getNlc() > 0) {
+		if (priceDropModel.getMop() > 0 && priceDropModel.getMop() > 0 && priceDropModel.getNlc() > 0
+				&& priceDropModel.getTp() > 0 && priceDropModel.getNlc() > 0) {
 			return true;
+		}
 		return false;
+	}
 	private Map<String, String> getpriceDropIMEIAndItemDescription(PriceDrop priceDrop)
 			throws ProfitMandiBusinessException {
 		Map<String, String> priceDropIMEIAndItemId = new LinkedHashMap<>();
-		List<InventoryItem> inventoryInStock = inventoryService.getInventoryInStock(priceDrop.getItemId(), priceDrop.getAffectedOn());
+		List<InventoryItem> inventoryInStock = inventoryService.getInventoryInStock(priceDrop.getItemId(),
+				priceDrop.getAffectedOn());
 		return priceDropIMEIAndItemId;
+	}
+}

Subversion Repositories SmartDukaan

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