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



					Double minFBAPrice= null;
					Double minMFNPrice= null;
					Double salePrice= null; 
					if(nextLine[30].length() >0){
						ourPrice = Double.parseDouble(nextLine[30]);
						if(itemIdOurPriceMap.containsKey(item_id) && itemIdOurPriceMap.get(item_id).getDate().after(date)){
							PriceAtDate priceAtDate= new PriceAtDate();
							priceAtDate.setDate(date);
							priceAtDate.setPrice(ourPrice);
							itemIdOurPriceMap.put(item_id,priceAtDate);
						}

							itemIdOurPriceMap.put(item_id,priceAtDate);
						}
					}
					if(nextLine[31].length() >0){
						salePrice = Double.parseDouble(nextLine[31]);
						if(itemIdSalePriceMap.containsKey(item_id) && itemIdSalePriceMap.get(item_id).getDate().after(date)){
							PriceAtDate priceAtDate= new PriceAtDate();
							priceAtDate.setDate(date);
							priceAtDate.setPrice(salePrice);
							itemIdOurPriceMap.put(item_id,priceAtDate);
						}

							itemIdSalePriceMap.put(item_id,priceAtDate);
						}
					}
					if(nextLine[32].length() >0){
						minFBAPrice = Double.parseDouble(nextLine[32]);
						if(itemIdminFBAPriceMap.containsKey(item_id) && itemIdminFBAPriceMap.get(item_id).getDate().after(date)){
							PriceAtDate priceAtDate= new PriceAtDate();
							priceAtDate.setDate(date);
							priceAtDate.setPrice(minFBAPrice);
							itemIdOurPriceMap.put(item_id,priceAtDate);
						}

							itemIdminFBAPriceMap.put(item_id,priceAtDate);
						}
					}
					if(nextLine[34].length() >0){
						minMFNPrice = Double.parseDouble(nextLine[34]);
						if(itemIdminMFNPriceMap.containsKey(item_id) && itemIdminMFNPriceMap.get(item_id).getDate().after(date)){
							PriceAtDate priceAtDate= new PriceAtDate();
							priceAtDate.setDate(date);
							priceAtDate.setPrice(minMFNPrice);
							itemIdOurPriceMap.put(item_id,priceAtDate);
						}

		}
 
	}
 
 
 
	public static Double getPercentageDifferenceFromMinimumPrice(AmazonFbaSalesSnapshot snapshot){
		Double minPrice = getMinimumSalePriceOnAmazonFBA(snapshot);
		return (snapshot.getSalePrice() - minPrice)/snapshot.getSalePrice();
 
	}

Subversion Repositories SmartDukaan

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

Rev 8463		Rev 8465
Line 188...		Line 188...
188	`Double minFBAPrice= null;`	188	`Double minFBAPrice= null;`
189	`Double minMFNPrice= null;`	189	`Double minMFNPrice= null;`
190	`Double salePrice= null;`	190	`Double salePrice= null;`
191	`if(nextLine[30].length() >0){`	191	`if(nextLine[30].length() >0){`
192	`ourPrice = Double.parseDouble(nextLine[30]);`	192	`ourPrice = Double.parseDouble(nextLine[30]);`
193	`if(itemIdOurPriceMap.containsKey(item_id) && itemIdOurPriceMap.get(item_id).getDate().before(date)){`	193	`if(itemIdOurPriceMap.containsKey(item_id) && itemIdOurPriceMap.get(item_id).getDate().after(date)){`
194	`PriceAtDate priceAtDate= new PriceAtDate();`	194	`PriceAtDate priceAtDate= new PriceAtDate();`
195	`priceAtDate.setDate(date);`	195	`priceAtDate.setDate(date);`
196	`priceAtDate.setPrice(ourPrice);`	196	`priceAtDate.setPrice(ourPrice);`
197	`itemIdOurPriceMap.put(item_id,priceAtDate);`	197	`itemIdOurPriceMap.put(item_id,priceAtDate);`
198	`}`	198	`}`
Line 203...		Line 203...
203	`itemIdOurPriceMap.put(item_id,priceAtDate);`	203	`itemIdOurPriceMap.put(item_id,priceAtDate);`
204	`}`	204	`}`
205	`}`	205	`}`
206	`if(nextLine[31].length() >0){`	206	`if(nextLine[31].length() >0){`
207	`salePrice = Double.parseDouble(nextLine[31]);`	207	`salePrice = Double.parseDouble(nextLine[31]);`
208	`if(itemIdSalePriceMap.containsKey(item_id) && itemIdSalePriceMap.get(item_id).getDate().before(date)){`	208	`if(itemIdSalePriceMap.containsKey(item_id) && itemIdSalePriceMap.get(item_id).getDate().after(date)){`
209	`PriceAtDate priceAtDate= new PriceAtDate();`	209	`PriceAtDate priceAtDate= new PriceAtDate();`
210	`priceAtDate.setDate(date);`	210	`priceAtDate.setDate(date);`
211	`priceAtDate.setPrice(salePrice);`	211	`priceAtDate.setPrice(salePrice);`
212	`itemIdOurPriceMap.put(item_id,priceAtDate);`	212	`itemIdOurPriceMap.put(item_id,priceAtDate);`
213	`}`	213	`}`
Line 218...		Line 218...
218	`itemIdSalePriceMap.put(item_id,priceAtDate);`	218	`itemIdSalePriceMap.put(item_id,priceAtDate);`
219	`}`	219	`}`
220	`}`	220	`}`
221	`if(nextLine[32].length() >0){`	221	`if(nextLine[32].length() >0){`
222	`minFBAPrice = Double.parseDouble(nextLine[32]);`	222	`minFBAPrice = Double.parseDouble(nextLine[32]);`
223	`if(itemIdminFBAPriceMap.containsKey(item_id) && itemIdminFBAPriceMap.get(item_id).getDate().before(date)){`	223	`if(itemIdminFBAPriceMap.containsKey(item_id) && itemIdminFBAPriceMap.get(item_id).getDate().after(date)){`
224	`PriceAtDate priceAtDate= new PriceAtDate();`	224	`PriceAtDate priceAtDate= new PriceAtDate();`
225	`priceAtDate.setDate(date);`	225	`priceAtDate.setDate(date);`
226	`priceAtDate.setPrice(minFBAPrice);`	226	`priceAtDate.setPrice(minFBAPrice);`
227	`itemIdOurPriceMap.put(item_id,priceAtDate);`	227	`itemIdOurPriceMap.put(item_id,priceAtDate);`
228	`}`	228	`}`
Line 233...		Line 233...
233	`itemIdminFBAPriceMap.put(item_id,priceAtDate);`	233	`itemIdminFBAPriceMap.put(item_id,priceAtDate);`
234	`}`	234	`}`
235	`}`	235	`}`
236	`if(nextLine[34].length() >0){`	236	`if(nextLine[34].length() >0){`
237	`minMFNPrice = Double.parseDouble(nextLine[34]);`	237	`minMFNPrice = Double.parseDouble(nextLine[34]);`
238	`if(itemIdminMFNPriceMap.containsKey(item_id) && itemIdminMFNPriceMap.get(item_id).getDate().before(date)){`	238	`if(itemIdminMFNPriceMap.containsKey(item_id) && itemIdminMFNPriceMap.get(item_id).getDate().after(date)){`
239	`PriceAtDate priceAtDate= new PriceAtDate();`	239	`PriceAtDate priceAtDate= new PriceAtDate();`
240	`priceAtDate.setDate(date);`	240	`priceAtDate.setDate(date);`
241	`priceAtDate.setPrice(minMFNPrice);`	241	`priceAtDate.setPrice(minMFNPrice);`
242	`itemIdOurPriceMap.put(item_id,priceAtDate);`	242	`itemIdOurPriceMap.put(item_id,priceAtDate);`
243	`}`	243	`}`
Line 321...		Line 321...
321	`}`	321	`}`
322		322
323	`}`	323	`}`
324		324
325		325
-		326
326	`public static Double getPercentageDifferenceFromMinimumPrice(AmazonFbaSalesSnapshot snapshot){`	327	`public static Double getPercentageDifferenceFromMinimumPrice(AmazonFbaSalesSnapshot snapshot){`
327	`Double minPrice = getMinimumSalePriceOnAmazonFBA(snapshot);`	328	`Double minPrice = getMinimumSalePriceOnAmazonFBA(snapshot);`
328	`return (snapshot.getSalePrice() - minPrice)/snapshot.getSalePrice();`	329	`return (snapshot.getSalePrice() - minPrice)/snapshot.getSalePrice();`
329		330
330	`}`	331	`}`