WebSVN – SmartDukaan – Diff – /trunk/AmazonReports/src/main/java/com/amazonaws/mws/samples/FileParser.java

 import java.io.FileNotFoundException;
 import java.io.FileOutputStream;
 import java.io.FileReader;
 import java.io.IOException;
+import java.io.OutputStream;
 import java.text.ParseException;
 import java.text.SimpleDateFormat;
 import java.util.ArrayList;
+import java.util.Calendar;
 import java.util.Date;
 import java.util.HashMap;
 import java.util.List;
 import java.util.Map;
 import java.util.Map.Entry;
 			TransactionClient transactionServiceClient = null;
 			CatalogClient catalogServiceClient = null;
 			try {
 				inventoryServiceClient = new InventoryClient();
 				transactionServiceClient = new TransactionClient();
-				//catalogServiceClient = new CatalogClient();
+				catalogServiceClient = new CatalogClient();
-				catalogServiceClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port");
+				//catalogServiceClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port");
 			} catch (Exception e) {
 				// TODO Auto-generated catch block
 				e.printStackTrace();
+			}
 			in.shop2020.model.v1.inventory.InventoryService.Client inventoryClient = inventoryServiceClient.getClient();
 			in.shop2020.model.v1.order.TransactionService.Client transactionClient   = transactionServiceClient.getClient();
 			in.shop2020.model.v1.catalog.CatalogService.Client catalogClient   = catalogServiceClient.getClient();
 			SimpleDateFormat dateFormat = new SimpleDateFormat("MM/dd/yyyy");
-			Date date_today = dateFormat.parse(dateFormat.format(new Date()));
+			//Date date_today = dateFormat.parse(dateFormat.format(new Date()));
+			List<Date> dates = new ArrayList<Date>();
+			Calendar cal = Calendar.getInstance();
+			cal.add(Calendar.DATE, -1);
+			Date date_end = dateFormat.parse(dateFormat.format(cal.getTime()));
+			cal.add(Calendar.DATE, -5);
+			Date date_start = dateFormat.parse(dateFormat.format(cal.getTime()));
+			System.out.println("Start Date = " + date_start);
+			System.out.println("End Date = " + date_end);
+			Date d = date_start;
+			while(!d.equals(date_end)){
+		        cal.setTime(d);
+		        cal.add(Calendar.DATE,1);
+				d = cal.getTime();
+				dates.add(d);
+			}
 			List<AmazonFbaInventorySnapshot> nonzeroFbaInventorySnapshotlist =  inventoryClient.getAllAmazonFbaItemInventory();
+			for(Date date:dates){
-			if(nonzeroFbaInventorySnapshotlist!=null){
+				if(nonzeroFbaInventorySnapshotlist!=null){
-				for(AmazonFbaInventorySnapshot amazonFbaInventory:nonzeroFbaInventorySnapshotlist){
+					for(AmazonFbaInventorySnapshot amazonFbaInventory:nonzeroFbaInventorySnapshotlist){
-					if(orderDateItemIdFbaSaleSnapshotMap.containsKey(date_today) ){
+						if(orderDateItemIdFbaSaleSnapshotMap.containsKey(date) ){
-						if(!orderDateItemIdFbaSaleSnapshotMap.get(date_today).containsKey(amazonFbaInventory.getItem_id())){
+							if(!orderDateItemIdFbaSaleSnapshotMap.get(date).containsKey(amazonFbaInventory.getItem_id())){
+								Map<Long,FbaSalesSnapshot> ItemIdFbaSaleSnapshotMap = new HashMap<Long,FbaSalesSnapshot>();
+								FbaSalesSnapshot fbaSalesSnapshot = new FbaSalesSnapshot();
+								fbaSalesSnapshot.setTotalOrderCount(0);
+								fbaSalesSnapshot.setPromotionOrderCount(0);
+								fbaSalesSnapshot.setTotalPromotionSale((float) 0);
+								fbaSalesSnapshot.setTotalSale((float) 0);
+								ItemIdFbaSaleSnapshotMap.put(amazonFbaInventory.getItem_id(),fbaSalesSnapshot);
+								orderDateItemIdFbaSaleSnapshotMap.get(date).put(amazonFbaInventory.getItem_id(),fbaSalesSnapshot);
+							}
+						}
+						else{
 							Map<Long,FbaSalesSnapshot> ItemIdFbaSaleSnapshotMap = new HashMap<Long,FbaSalesSnapshot>();
 							FbaSalesSnapshot fbaSalesSnapshot = new FbaSalesSnapshot();
 							fbaSalesSnapshot.setTotalOrderCount(0);
 							fbaSalesSnapshot.setPromotionOrderCount(0);
 							fbaSalesSnapshot.setTotalPromotionSale((float) 0);
 							fbaSalesSnapshot.setTotalSale((float) 0);
 							ItemIdFbaSaleSnapshotMap.put(amazonFbaInventory.getItem_id(),fbaSalesSnapshot);
-							orderDateItemIdFbaSaleSnapshotMap.get(date_today).put(amazonFbaInventory.getItem_id(),fbaSalesSnapshot);
+							orderDateItemIdFbaSaleSnapshotMap.put(date,ItemIdFbaSaleSnapshotMap);
+						}
-					}
-					else{
-						Map<Long,FbaSalesSnapshot> ItemIdFbaSaleSnapshotMap = new HashMap<Long,FbaSalesSnapshot>();
-						FbaSalesSnapshot fbaSalesSnapshot = new FbaSalesSnapshot();
-						fbaSalesSnapshot.setTotalOrderCount(0);
-						fbaSalesSnapshot.setPromotionOrderCount(0);
-						fbaSalesSnapshot.setTotalPromotionSale((float) 0);
-						fbaSalesSnapshot.setTotalSale((float) 0);
-						ItemIdFbaSaleSnapshotMap.put(amazonFbaInventory.getItem_id(),fbaSalesSnapshot);
-						orderDateItemIdFbaSaleSnapshotMap.put(date_today,ItemIdFbaSaleSnapshotMap);
+					}
+				}
-			}
-			else{
+				else{
-				System.out.println("No inventory in FBA");
+					System.out.println("No inventory in FBA");
+				}
+			}
 			Map<Long,PriceAtDate> itemIdOurPriceMap = new HashMap<Long,PriceAtDate>();
 			Map<Long,PriceAtDate> itemIdSalePriceMap = new HashMap<Long,PriceAtDate>();
 			Map<Long,PriceAtDate> itemIdminFBAPriceMap = new HashMap<Long,PriceAtDate>();
 			Map<Long,PriceAtDate> itemIdminMFNPriceMap = new HashMap<Long,PriceAtDate>();
 			count=1;
 			while ((nextLine = inventoryhealthreportreader.readNext()) != null ) {
+				try{
-				if(count!=1){
+					if(count!=1){
-					System.out.println(nextLine[0] + " " + nextLine[1]);
-					System.out.println(nextLine[30]);
-					System.out.println(nextLine[31]);
-					System.out.println(nextLine[32]);
-					System.out.println(nextLine[34]);
-					System.out.println(nextLine[1] +" "+ nextLine[31] +" " + nextLine[32] + " " + nextLine[34]);
+						//System.out.println(nextLine[1] +" "+ nextLine[31] +" " + nextLine[32] + " " + nextLine[34]);
-					SimpleDateFormat istFormatter = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss");
+						SimpleDateFormat istFormatter = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss");
-					istFormatter .setLenient(false);
+						istFormatter .setLenient(false);
-					TimeZone zone= TimeZone.getTimeZone("GMT");
+						TimeZone zone= TimeZone.getTimeZone("GMT");
-					istFormatter.setTimeZone(zone);
+						istFormatter.setTimeZone(zone);
-					Date date = istFormatter.parse(nextLine[0]);
+						Date date = istFormatter.parse(nextLine[0]);
-					Long item_id = Long.parseLong(nextLine[1].replaceAll("FBA",""));
+						Long item_id = Long.parseLong(nextLine[1].replaceAll("FBA",""));
-					Double ourPrice = null;
+						Double ourPrice = null;
-					Double minFBAPrice= null;
+						Double minFBAPrice= null;
-					Double minMFNPrice= null;
+						Double minMFNPrice= null;
-					Double salePrice= null;
+						Double salePrice= null;
-					if(nextLine[30].length() >0){
+						if(nextLine[30].length() >0){
-						ourPrice = Double.parseDouble(nextLine[30]);
+							ourPrice = Double.parseDouble(nextLine[30]);
-						if(itemIdOurPriceMap.containsKey(item_id)){
+							if(itemIdOurPriceMap.containsKey(item_id)){
-							if(itemIdOurPriceMap.get(item_id).getDate().getTime() < date.getTime()){
+								if(itemIdOurPriceMap.get(item_id).getDate().getTime() < date.getTime()){
+									PriceAtDate priceAtDate= new PriceAtDate();
+									priceAtDate.setDate(date);
+									priceAtDate.setPrice(ourPrice);
+									itemIdOurPriceMap.put(item_id,priceAtDate);
+								}
+							}
+							else{
 								PriceAtDate priceAtDate= new PriceAtDate();
 								priceAtDate.setDate(date);
 								priceAtDate.setPrice(ourPrice);
 								itemIdOurPriceMap.put(item_id,priceAtDate);
+							}
+						}
-						else{
+						if(nextLine[31].length() >0){
+							salePrice = Double.parseDouble(nextLine[31]);
+							if(itemIdSalePriceMap.containsKey(item_id) ){
+								if(itemIdSalePriceMap.get(item_id).getDate().getTime() < date.getTime()){
-							PriceAtDate priceAtDate= new PriceAtDate();
+									PriceAtDate priceAtDate= new PriceAtDate();
-							priceAtDate.setDate(date);
+									priceAtDate.setDate(date);
-							priceAtDate.setPrice(ourPrice);
+									priceAtDate.setPrice(salePrice);
-							itemIdOurPriceMap.put(item_id,priceAtDate);
+									itemIdSalePriceMap.put(item_id,priceAtDate);
-						}
+								}
-					}
+							}
-					if(nextLine[31].length() >0){
+							else{
-						salePrice = Double.parseDouble(nextLine[31]);
-						if(itemIdSalePriceMap.containsKey(item_id) ){
-							if(itemIdSalePriceMap.get(item_id).getDate().getTime() < date.getTime()){
 								PriceAtDate priceAtDate= new PriceAtDate();
 								priceAtDate.setDate(date);
 								priceAtDate.setPrice(salePrice);
 								itemIdSalePriceMap.put(item_id,priceAtDate);
+							}
+						}
-						else{
+						if(nextLine[32].length() >0){
+							minFBAPrice = Double.parseDouble(nextLine[32]);
+							if(itemIdminFBAPriceMap.containsKey(item_id)){
+								if(itemIdminFBAPriceMap.get(item_id).getDate().getTime() < date.getTime()){
-							PriceAtDate priceAtDate= new PriceAtDate();
+									PriceAtDate priceAtDate= new PriceAtDate();
-							priceAtDate.setDate(date);
+									priceAtDate.setDate(date);
-							priceAtDate.setPrice(salePrice);
+									priceAtDate.setPrice(minFBAPrice);
-							itemIdSalePriceMap.put(item_id,priceAtDate);
+									itemIdminFBAPriceMap.put(item_id,priceAtDate);
-						}
+								}
-					}
+							}
-					if(nextLine[32].length() >0){
+							else{
-						minFBAPrice = Double.parseDouble(nextLine[32]);
-						if(itemIdminFBAPriceMap.containsKey(item_id)){
-							if(itemIdminFBAPriceMap.get(item_id).getDate().getTime() < date.getTime()){
 								PriceAtDate priceAtDate= new PriceAtDate();
 								priceAtDate.setDate(date);
 								priceAtDate.setPrice(minFBAPrice);
 								itemIdminFBAPriceMap.put(item_id,priceAtDate);
+							}
+						}
-						else{
+						if(nextLine[34].length() >0){
+							minMFNPrice = Double.parseDouble(nextLine[34]);
+							if(itemIdminMFNPriceMap.containsKey(item_id)){
+								if(itemIdminMFNPriceMap.get(item_id).getDate().getTime() < date.getTime()){
-							PriceAtDate priceAtDate= new PriceAtDate();
+									PriceAtDate priceAtDate= new PriceAtDate();
-							priceAtDate.setDate(date);
+									priceAtDate.setDate(date);
-							priceAtDate.setPrice(minFBAPrice);
+									priceAtDate.setPrice(minMFNPrice);
-							itemIdminFBAPriceMap.put(item_id,priceAtDate);
+									itemIdminMFNPriceMap.put(item_id,priceAtDate);
-						}
+								}
-					}
+							}
-					if(nextLine[34].length() >0){
+							else{
-						minMFNPrice = Double.parseDouble(nextLine[34]);
-						if(itemIdminMFNPriceMap.containsKey(item_id)){
-							if(itemIdminMFNPriceMap.get(item_id).getDate().getTime() < date.getTime()){
 								PriceAtDate priceAtDate= new PriceAtDate();
 								priceAtDate.setDate(date);
 								priceAtDate.setPrice(minMFNPrice);
 								itemIdminMFNPriceMap.put(item_id,priceAtDate);
+							}
+						}
-						else{
-							PriceAtDate priceAtDate= new PriceAtDate();
-							priceAtDate.setDate(date);
-							priceAtDate.setPrice(minMFNPrice);
-							itemIdminMFNPriceMap.put(item_id,priceAtDate);
-						}
+					}
+				}
+				catch(Exception e){
+					e.printStackTrace();
+				}
 				count++;
+			}
 			boolean oos;
 			for (Entry<Date, Map<Long, FbaSalesSnapshot>> entry : orderDateItemIdFbaSaleSnapshotMap.entrySet()){
 				Date orderDate = entry.getKey();
+					}
 					amazonfbasalessnapshot.setAmazonFbaInventory(inventory);
 					transactionClient.addOrUpdateAmazonFbaSalesSnapshot(amazonfbasalessnapshot);
+				}
+			}
+		}
-		} catch (IOException e) {
+		catch (IOException e) {
 			// TODO Auto-generated catch block
 			e.printStackTrace();
 		} catch (ParseException e) {
 			// TODO Auto-generated catch block
 			e.printStackTrace();
 		} catch (TException e) {
 			// TODO Auto-generated catch block
 			e.printStackTrace();
+		}catch (Exception e) {
+			// TODO Auto-generated catch block
+			e.printStackTrace();
+		}
+	}
 	public static Double getPercentageDifferenceFromMinimumPrice(AmazonFbaSalesSnapshot snapshot){
 		Double minPrice = getMinimumSalePriceOnAmazonFBA(snapshot);
 		return (((minPrice - snapshot.getOurPrice())/snapshot.getOurPrice())*100);

Subversion Repositories SmartDukaan

(root)/trunk/AmazonReports/src/main/java/com/amazonaws/mws/samples/FileParser.java – Rev 8816 → 8825