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

 import org.apache.commons.io.FileUtils;
 import org.apache.commons.lang3.StringUtils;
 import org.apache.logging.log4j.LogManager;
 import org.apache.logging.log4j.Logger;
 import org.apache.thrift.TException;
+import org.hibernate.type.CurrencyType;
 import org.json.JSONObject;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.beans.factory.annotation.Qualifier;
 import org.springframework.beans.factory.annotation.Value;
 import org.springframework.core.io.ClassPathResource;
 import com.spice.profitmandi.common.util.ExcelUtils;
 import com.spice.profitmandi.common.util.PdfUtils;
 import com.spice.profitmandi.dao.entity.catalog.Item;
 import com.spice.profitmandi.dao.entity.catalog.TagListing;
 import com.spice.profitmandi.dao.entity.catalog.TagRanking;
+import com.spice.profitmandi.dao.entity.fofo.CurrentInventorySnapshot;
 import com.spice.profitmandi.dao.entity.fofo.FofoOrder;
 import com.spice.profitmandi.dao.entity.fofo.FofoStore;
 import com.spice.profitmandi.dao.entity.fofo.InventoryItem;
 import com.spice.profitmandi.dao.entity.fofo.LiveDemoSerialNumber;
 import com.spice.profitmandi.dao.entity.transaction.NotifyCancel;
 public class InventoryController {
 	private static final Logger LOGGER = LogManager.getLogger(InventoryController.class);
 	private static final DateTimeFormatter formatter = DateTimeFormatter.ofPattern("M/d/yyyy H:m:s");
-	private static final List<String> imeis = Arrays.asList(
+	private static final List<String> imeis = Arrays.asList("351030944216680", "351030944217183", "351030944217886",
-			"351030944216680",
-			"351030944217183",
-			"351030944217886",
-			"351030944507286",
-			"351081710231270",
-			"351081710238713",
-			"351081710238796",
-			"351081710241279",
+			"351030944507286", "351081710231270", "351081710238713", "351081710238796", "351081710241279",
-			"351081710244737",
+			"351081710244737", "355777112655976");
-			"355777112655976"
-	);
 	@Autowired
 	private CookiesProcessor cookiesProcessor;
 	@Autowired
 	@Autowired
 	private UserAccountRepository userAccountRepository;
 	@Autowired
 	private OrderService orderService;
 	@Value("${saholic.api.host}")
 	private String host;
 	@Value("${saholic.api.port}")
 	private int port;
 		return "inventory-snapshot-paginated";
+	}
 	@RequestMapping(value = "/getCatalog")
 	public String getCatalog(HttpServletRequest request, @RequestParam(name = "offset", defaultValue = "0") int offset,
-			@RequestParam(name = "limit", defaultValue = "10") int limit,
+			@RequestParam(name = "limit", defaultValue = "20") int limit,
-			@RequestParam(name = "searchTerm", required = false, defaultValue = "") String searchTerm, Model model)
+			@RequestParam(name = "searchTerm", required = false, defaultValue = "") String searchTerm,
+			@RequestParam(name = "itemId", required = false, defaultValue = "0") int itemId, Model model)
 			throws ProfitMandiBusinessException {
 		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
 		if (searchTerm == null) {
 			searchTerm = "";
+		}
-		Map<String, Object> map = inventoryService.getCatalog(loginDetails.getFofoId(), offset, limit, searchTerm);
+		Map<String, Object> map = inventoryService.getCatalog(loginDetails.getFofoId(), offset, limit, searchTerm,
+				itemId);
 		model.addAllAttributes(map);
 		model.addAttribute("hasGift", hasGift(loginDetails.getFofoId()));
 		return "catalog";
+	}
 		} catch (ProfitMandiBusinessException e) {
 			return false;
+		}
+	}
+	/*
+	 * @RequestMapping(value = "/getSimilarItem") public String
+	 * getCatalog(HttpServletRequest request, @RequestParam(name = "offset",
+	 * defaultValue = "0") int offset,
+	 *
+	 * @RequestParam(name = "limit", defaultValue = "10") int limit, @RequestParam
+	 * int catalogItemId,
+	 *
+	 * @RequestParam(name = "searchTerm", required = false, defaultValue = "")
+	 * String searchTerm, Model model) throws ProfitMandiBusinessException
+	 *
+	 * { LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
+	 *
+	 * if (catalogItemId != 0) { TagListing tagListing = null; List<Item> items =
+	 * itemRepository.selectAllByCatalogItemId(catalogItemId); Map<Integer, Float>
+	 * itemPriceing = new HashMap<>(); List<CustomCurrentInventorySnapshot>
+	 * inventoryList = new ArrayList<>();
+	 *
+	 * for (Item item : items) { tagListing =
+	 * tagListingRepository.selectByItemId(item.getId());
+	 * CustomCurrentInventorySnapshot customCurrentInventorySnapshot =
+	 * inventoryService .checkItemAvailability(item.getId(),
+	 * loginDetails.getFofoId()); inventoryList.add(customCurrentInventorySnapshot);
+	 * itemPriceing.put(item.getId(), tagListing.getMop()); } if (tagListing !=
+	 * null) {
+	 *
+	 * float tagStartPrice = tagListing.getMop() - 1000; float tagEndPrice =
+	 * tagListing.getMop() + 2000; List<TagListing> tagMoplists =
+	 * tagListingRepository.selectAllBetweenMopPrice(tagStartPrice, tagEndPrice);
+	 *
+	 * for (TagListing tagListings : tagMoplists) {
+	 *
+	 * int TagListingItemid = tagListings.getItemId();
+	 *
+	 * itemPriceing.put(TagListingItemid, tagListings.getMop());
+	 * CustomCurrentInventorySnapshot customCurrentInventorySnapshotMopPrice =
+	 * inventoryService .checkItemAvailability(TagListingItemid,
+	 * loginDetails.getFofoId());
+	 *
+	 * inventoryList.add(customCurrentInventorySnapshotMopPrice); }
+	 *
+	 * }
+	 *
+	 * else { LOGGER.info("tagBrandlist is null"); }
+	 *
+	 * model.addAttribute("inventoryLists", inventoryList);
+	 * model.addAttribute("itemPriceing", itemPriceing);
+	 *
+	 * }
+	 *
+	 * return "catalog-similar-Id"; }
+	 */
 	@RequestMapping(value = "/getPaginatedCatalog")
 	public String getCatalogPaginated(HttpServletRequest request,
 			@RequestParam(name = "offset", defaultValue = "0") int offset,
-			@RequestParam(name = "limit", defaultValue = "10") int limit,
+			@RequestParam(name = "limit", defaultValue = "20") int limit,
-			@RequestParam(name = "searchTerm", required = false, defaultValue = "") String searchTerm, Model model)
+			@RequestParam(name = "searchTerm", required = false, defaultValue = "") String searchTerm,
+			@RequestParam(name = "itemId", required = false, defaultValue = "0") int itemId, Model model)
 			throws ProfitMandiBusinessException {
 		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
 		if (searchTerm == null) {
 			searchTerm = "";
+		}
 		Map<String, Object> map = inventoryService.getPaginatedCatalog(loginDetails.getFofoId(), offset, limit,
-				searchTerm);
+				searchTerm, itemId);
 		model.addAllAttributes(map);
 		return "catalog-paginated";
+	}
 	@RequestMapping(value = "/checkItemAvailability")
+			}
 		});
 		model.addAttribute("inventoryItems", inventoryItems);
 		return "activated-imeis";
+	}
 	@RequestMapping(value = "/view-invoices")
 	public String viewInvoices(HttpServletRequest request, Model model) throws ProfitMandiBusinessException {
 		return "view-dummy-invoices";
+	}
 	@RequestMapping(value = "/dummy-invoices")
-	public ResponseEntity<?> downloadInvoices(HttpServletRequest request, @RequestParam String serialNumber, Model model) throws ProfitMandiBusinessException {
+	public ResponseEntity<?> downloadInvoices(HttpServletRequest request, @RequestParam String serialNumber,
+			Model model) throws ProfitMandiBusinessException {
 		byte[] bytes = null;
-		if(!imeis.contains(serialNumber)) {
+		if (!imeis.contains(serialNumber)) {
 			PdfModel pdfModel = orderService.getDummyPdfModel(serialNumber);
 			ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
 			PdfUtils.generateAndWrite(Arrays.asList(pdfModel), byteArrayOutputStream);
 			bytes = byteArrayOutputStream.toByteArray();
 		} else {
 			ClassPathResource resource = new ClassPathResource("/META-INF/" + serialNumber + ".pdf");
 			try {
 				bytes = FileUtils.readFileToByteArray(resource.getFile());
-			} catch(Exception e) {
+			} catch (Exception e) {
+			}
+		}
 		final HttpHeaders headers = new HttpHeaders();
 		headers.setContentType(MediaType.APPLICATION_PDF);
 		headers.set("Content-disposition", "inline; filename=invoice-" + serialNumber + ".pdf");
 		headers.setContentLength(byteArrayOutputStream.toByteArray().length);
 		final InputStream inputStream = new ByteArrayInputStream(byteArrayOutputStream.toByteArray());
 		final InputStreamResource inputStreamResource = new InputStreamResource(inputStream);
 		return new ResponseEntity<InputStreamResource>(inputStreamResource, headers, HttpStatus.OK);
+	}
 	@RequestMapping(value = "/aging-report", method = RequestMethod.GET)
-	public ResponseEntity<?> downloadInventoryItemAgingByInterval(HttpServletRequest request) throws ProfitMandiBusinessException {
+	public ResponseEntity<?> downloadInventoryItemAgingByInterval(HttpServletRequest request)
+			throws ProfitMandiBusinessException {
-		List<Integer> intervals = Arrays.asList(5,15,30,45);
+		List<Integer> intervals = Arrays.asList(5, 15, 30, 45);
 		List<InventoryItemAgingModel> inventoryItemAgingModels = inventoryService.getItemAgingByInterval(intervals)
 				.values().stream().flatMap(Collection::stream).collect(Collectors.toList());
 		LOGGER.info("Fofo Id {}", inventoryItemAgingModels.get(0).getFofoId());
 		ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
 		ExcelUtils.writeInventoryItemAgingModels(inventoryItemAgingModels, intervals, byteArrayOutputStream);
 		final HttpHeaders headers = new HttpHeaders();
 		// private static final String CONTENT_TYPE_XLSX =
 		// "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
 		headers.set("Content-Type", "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
 		// headers.set("Content-Type", "application/vnd.ms-excel");
 	@RequestMapping(value = "/getProductCompareInfo", method = RequestMethod.GET)
 	public String getProductCompareInfo(HttpServletRequest request, @RequestParam List<Long> catalogIds, Model model)
 			throws Exception {
 		List<ContentPojo> cps = new ArrayList<>();
+		Set<Integer> cataogIds = catalogIds.stream().mapToInt(Long::intValue).boxed().collect(Collectors.toSet());
 		for (Long cId : catalogIds) {
 			ContentPojo cp = mongoClient.getEntityById(cId);
 			if (cp.getName() == null) {
 				cp.setName(itemRepository.selectAllByCatalogItemId(cId.intValue()).get(0).getItemDescriptionNoColor());
+			}
+			List<Item> items = itemRepository.selectAllByCatalogItemId(cId.intValue());
+			TagListing tagListing = tagListingRepository.selectByItemId(items.get(0).getId());
+			cp.setPrice(tagListing.getMop());
 			cps.add(cp);
+		}
 		List<Map<String, String>> entityList = new ArrayList<>();
 		for (ContentPojo cp : cps) {
 			Map<String, String> specsMap = new HashMap<>();
 					String key = title + s.getName();
 					specsMap.put(key, String.join(", ", s.getValues()));
+				}
+			}
 			entityList.add(specsMap);
+		}
 		LOGGER.info("cps" + cps);
 		model.addAttribute("cps", cps);
 		model.addAttribute("catalogIds", gson.toJson(catalogIds, List.class));

Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/InventoryController.java – Rev 27544 → 27583