WebSVN – SmartDukaan – Diff – /trunk/InventoryManager/src/main/java/in/shop2020/inventory/controllers/InventoryAgeController.java

 	 * @param inventoryAge
 	 * @return
 	 */
 	private File createFile(List<InventoryAge> inventoryAge, List<InventoryAge> inventoryAgeAmazon) {
 		Map<Long,InventoryAge> inventoryAgeMap = new HashMap<Long,InventoryAge>();
 		for(InventoryAge invAge : inventoryAge){
 			inventoryAgeMap.put(invAge.getItemId(), invAge);
+		}
 		for(InventoryAge invAge : inventoryAgeAmazon){
 			if(inventoryAgeMap.containsKey(invAge.getItemId())){
 				InventoryAge invAgeObj = inventoryAgeMap.get(invAge.getItemId());
 				invAgeObj.setFreshCount(invAgeObj.getFreshCount()+ invAge.getFreshCount());
 				invAgeObj.setOneToTwoCount(invAgeObj.getOneToTwoCount() + invAge.getOneToTwoCount());
 				invAgeObj.setTwoToThreeCount(invAgeObj.getTwoToThreeCount() + invAge.getTwoToThreeCount());
 				invAgeObj.setThreeToFourCount(invAgeObj.getThreeToFourCount() + invAge.getThreeToFourCount());
 				invAgeObj.setFourPlusCount(invAgeObj.getFourPlusCount() + invAge.getFourPlusCount());
 				invAgeObj.setThreeMonthPlusCount(invAgeObj.getThreeMonthPlusCount() + invAge.getThreeMonthPlusCount());
 				invAgeObj.setSixMonthPlusCount(invAgeObj.getSixMonthPlusCount() + invAge.getSixMonthPlusCount());
 				invAgeObj.setZeroToThreeMonthCount(invAgeObj.getZeroToThreeMonthCount() + invAge.getZeroToThreeMonthCount());
 				invAgeObj.setTwelveMonthsPlusCount(invAgeObj.getTwelveMonthsPlusCount() + invAge.getTwelveMonthsPlusCount());
 				invAgeObj.setZeroPlusCount(invAgeObj.getZeroPlusCount() + invAge.getZeroPlusCount());
 				invAgeObj.setOnePlusCount(invAgeObj.getOnePlusCount() + invAge.getOnePlusCount());
 				invAgeObj.setZeroPlusCost(invAgeObj.getZeroPlusCost() + invAge.getZeroPlusCost());
 				invAgeObj.setOnePlusCost(invAgeObj.getOnePlusCost() + invAge.getOnePlusCost());
 				inventoryAgeMap.put(invAge.getItemId(), invAgeObj);
+			}
 			else{
 				inventoryAgeMap.put(invAge.getItemId(), invAge);
+			}
+		}
 		List<InventoryAge> amazonInventoryAge = new ArrayList<InventoryAge>();
 		try{
 			InventoryService.Client inventoryClient = new InventoryClient().getClient();
 			List<AmazonFbaInventorySnapshot> amazonFbaInventorySnapshot = inventoryClient.getAllAmazonFbaItemInventory();
 			List<Long> itemIds = new ArrayList<Long>();
-			for(AmazonFbaInventorySnapshot invSnapShot : amazonFbaInventorySnapshot)
+			for(AmazonFbaInventorySnapshot invSnapShot : amazonFbaInventorySnapshot){
+				logger.info("AmazonFbaInventorySnapshot entry " + invSnapShot.getItem_id());
+				if(!itemIds.contains(invSnapShot.getItem_id())){
-				itemIds.add(invSnapShot.getItem_id());
+					itemIds.add(invSnapShot.getItem_id());
+				}
+				else{
+					logger.info("AmazonFbaInventorySnapshot entry skipped" + invSnapShot.getItem_id());
+				}
+			}
 			Client client = new WarehouseClient().getClient();
 			List<AmazonTransferredSkuDetail> amazonTransferredSkuDetails = client.getAmazonTransferredSkuDetails(itemIds);
 			Map<Long, AmazonFbaInventorySnapshot> amazonFbaSnapshotMap = new HashMap<Long, AmazonFbaInventorySnapshot> ();
 			Map<Long, List<AmazonTransferredSkuDetail>> skuDetailsMap = new HashMap<Long, List<AmazonTransferredSkuDetail>>();
 			for(AmazonFbaInventorySnapshot invSnapShot : amazonFbaInventorySnapshot){
 				Long itemId= invSnapShot.getItem_id();
 				if(!amazonFbaSnapshotMap.containsKey(itemId)){
 					amazonFbaSnapshotMap.put(itemId, invSnapShot);
+					logger.info("Adding Availabity " + invSnapShot.getItem_id() + " Availability " +invSnapShot.getAvailability());
 				} else {
 					AmazonFbaInventorySnapshot invSS = amazonFbaSnapshotMap.get(itemId);
 					invSnapShot.setAvailability(invSnapShot.getAvailability() + invSS.getAvailability());
 					amazonFbaSnapshotMap.put(itemId, invSnapShot);
+					logger.info("Updating Availabity " + invSnapShot.getItem_id() + " Availability " +invSnapShot.getAvailability());
+				}
 				List<AmazonTransferredSkuDetail> mappedList = new ArrayList<AmazonTransferredSkuDetail>();
 				for(AmazonTransferredSkuDetail detail: amazonTransferredSkuDetails){
 					if(itemId == detail.getItemId()){
+						logger.info("Amazon Transferred Sku Details Detail found for ITEM ID  " + detail.getItemId());
 						mappedList.add(detail);
+					}
+					else{
+						logger.info("Amazon Transferred Sku Details Detail not found for ITEM ID  " + detail.getItemId());
+					}
+				}
+				if(mappedList.size()>0){
+					skuDetailsMap.put(itemId, mappedList);
+					logger.info("Amazon Sku Details transfer entries added Item ID " + itemId + " Total Entires " +mappedList.size());
+				}
+				else{
+					logger.info("Amazon Sku Details transfer entries not found added Item ID " + itemId + " Total Entires " +mappedList.size());
+				}
-				skuDetailsMap.put(itemId, mappedList);
+			}
 			//CatalogService.Client catalogClient = new CatalogClient().getClient();
 			for(AmazonFbaInventorySnapshot invSnapShot : amazonFbaSnapshotMap.values()){
 				try{
 					Long item_id = invSnapShot.getItem_id();
 					List<AmazonTransferredSkuDetail> amazonTranSkuDetails = skuDetailsMap.get(item_id);
 						brand = amazonTranSkuDetails.get(0).getBrand();
 						modelName = amazonTranSkuDetails.get(0).getModelName();
 						modelNumber = amazonTranSkuDetails.get(0).getModelNumber();
 						color = amazonTranSkuDetails.get(0).getColor();
 						category = amazonTranSkuDetails.get(0).getCategory();
 					}else{
+						logger.info("Amazon Sku Transfer details  skipped " + item_id);
 						continue;
+					}
 					double invAge = 0;
 					for(AmazonTransferredSkuDetail amazonSkuDetail : amazonTranSkuDetails){
 							threeMonthPlusCount = threeMonthPlusCount + amazonSkuInfo.getQuantity();
+						}
 						if(invAge >= 26){
 							sixMonthPlusCount = sixMonthPlusCount + amazonSkuInfo.getQuantity();
+						}
 						if(invAge >0 && invAge <=13){
 							zeroToThreeMonthCount = zeroToThreeMonthCount + amazonSkuInfo.getQuantity();
+						}
 						if(invAge >13 && invAge <=26){
 							threeToSixMonthsCount = threeToSixMonthsCount + amazonSkuInfo.getQuantity();
+						}
 						if(invAge >26 && invAge <=52){
 							sixToTwelveMonthsCount = sixToTwelveMonthsCount + amazonSkuInfo.getQuantity();
+						}
 						if(invAge > 52){
 							twelveMonthsPlusCount = twelveMonthsPlusCount + amazonSkuInfo.getQuantity();
+						}
 						zeroPlusCount = zeroPlusCount + amazonSkuInfo.getQuantity();
 						zeroPlusCost = (long)(zeroPlusCost + ( amazonSkuInfo.getQuantity() * amazonSkuInfo.getUnitPrice() ));
+					}
 					InventoryAge inventAge = new InventoryAge();
 					inventAge.setItemId(item_id);
 					inventAge.setBrand(brand);
 					inventAge.setModelName(modelName);
 					inventAge.setModelNumber(modelNumber);
 		catch(Exception e){
 			e.printStackTrace();
+		}
 		return amazonInventoryAge;
+	}
 	public File createFile(List<InventoryAge> inventoryAge, String name){
 		try {
 			File file = new File(name);
 			BufferedWriter bufferedWriter = new BufferedWriter(new FileWriter(file));
 			bufferedWriter.write(StringUtils.join(new String[] {
 			bufferedWriter.close();
 			return file;
 		} catch (Exception e) {
 			return null;
+		}
+	}
 	public void downloadAmazonInventoryAge(){
 		try {
 			List<InventoryAge> inventoryAgeAmazon = getAmazonInventoryAge();
 			byte[] buffer = null;
 			File file = createFile(inventoryAgeAmazon,"/tmp/AmazonInventoryAge.xls");
+		}
 		catch (Exception e) {
+		}
+	}
 	public void downloadSaholicInventoryAge(){
 		try {
 			Client client = new WarehouseClient().getClient();
 			List<InventoryAge> inventoryAge = client.getInventoryAge();
 			byte[] buffer = null;
+		}
+	}
 	/*public static void main(String[] args) throws Exception{
 	}*/
+}

Subversion Repositories SmartDukaan

(root)/trunk/InventoryManager/src/main/java/in/shop2020/inventory/controllers/InventoryAgeController.java – Rev 11582 → 11639