| Line 246... |
Line 246... |
| 246 |
Date date = istFormatter.parse(nextLine[2]);
|
246 |
Date date = istFormatter.parse(nextLine[2]);
|
| 247 |
SimpleDateFormat dateFormat = new SimpleDateFormat("MM/dd/yyyy");
|
247 |
SimpleDateFormat dateFormat = new SimpleDateFormat("MM/dd/yyyy");
|
| 248 |
Date date_key = dateFormat.parse(dateFormat.format(date));
|
248 |
Date date_key = dateFormat.parse(dateFormat.format(date));
|
| 249 |
System.out.println(nextLine[0]+" "+date_key+" "+ nextLine[11] +" " + nextLine[13] + " " + nextLine[14]);
|
249 |
System.out.println(nextLine[0]+" "+date_key+" "+ nextLine[11] +" " + nextLine[13] + " " + nextLine[14]);
|
| 250 |
Long itemid = Long.parseLong(nextLine[11].replaceAll("FBA",""));
|
250 |
Long itemid = Long.parseLong(nextLine[11].replaceAll("FBA",""));
|
| 251 |
|
251 |
|
| 252 |
Integer qty = new Integer(nextLine[14]);
|
252 |
Integer qty = new Integer(nextLine[14]);
|
| 253 |
Float itemSale = null;
|
253 |
Float itemSale = null;
|
| 254 |
if(nextLine[16].length()!=0){
|
254 |
if(nextLine[16].length()!=0){
|
| 255 |
itemSale = new Float(nextLine[16]);
|
255 |
itemSale = new Float(nextLine[16]);
|
| 256 |
}
|
256 |
}
|
| Line 364... |
Line 364... |
| 364 |
count=1;
|
364 |
count=1;
|
| 365 |
while ((nextLine = inventoryhealthreportreader.readNext()) != null ) {
|
365 |
while ((nextLine = inventoryhealthreportreader.readNext()) != null ) {
|
| 366 |
if(count!=1){
|
366 |
if(count!=1){
|
| 367 |
//System.out.println(nextLine[1] +" "+ nextLine[31] +" " + nextLine[32] + " " + nextLine[34]);
|
367 |
//System.out.println(nextLine[1] +" "+ nextLine[31] +" " + nextLine[32] + " " + nextLine[34]);
|
| 368 |
Long item_id = Long.parseLong(nextLine[1].replaceAll("FBA",""));
|
368 |
Long item_id = Long.parseLong(nextLine[1].replaceAll("FBA",""));
|
| 369 |
Double ourPrice = Double.parseDouble(nextLine[30]);
|
369 |
Double ourPrice = null;
|
| 370 |
Double salePrice = Double.parseDouble(nextLine[31]);
|
370 |
Double minFBAPrice= null;
|
| 371 |
Double minFBAPrice = Double.parseDouble(nextLine[32]);
|
371 |
Double minMFNPrice= null;
|
| - |
|
372 |
Double salePrice= null;
|
| - |
|
373 |
|
| - |
|
374 |
if(nextLine[30].length() >0){
|
| 372 |
Double minMFNPrice = Double.parseDouble(nextLine[34]);
|
375 |
ourPrice = Double.parseDouble(nextLine[30]);
|
| 373 |
itemIdOurPriceMap.put(item_id,ourPrice);
|
376 |
itemIdOurPriceMap.put(item_id,ourPrice);
|
| - |
|
377 |
}
|
| - |
|
378 |
if(nextLine[31].length() >0){
|
| - |
|
379 |
salePrice = Double.parseDouble(nextLine[31]);
|
| 374 |
itemIdSalePriceMap.put(item_id,salePrice);
|
380 |
itemIdSalePriceMap.put(item_id,salePrice);
|
| - |
|
381 |
}
|
| - |
|
382 |
if(nextLine[32].length() >0){
|
| - |
|
383 |
minFBAPrice = Double.parseDouble(nextLine[32]);
|
| 375 |
itemIdminFBAPriceMap.put(item_id,minFBAPrice);
|
384 |
itemIdminFBAPriceMap.put(item_id,minFBAPrice);
|
| - |
|
385 |
}
|
| - |
|
386 |
if(nextLine[32].length() >0){
|
| - |
|
387 |
minMFNPrice = Double.parseDouble(nextLine[34]);
|
| 376 |
itemIdminMFNPriceMap.put(item_id,minMFNPrice);
|
388 |
itemIdminMFNPriceMap.put(item_id,minMFNPrice);
|
| - |
|
389 |
}
|
| 377 |
}
|
390 |
}
|
| 378 |
count++;
|
391 |
count++;
|
| 379 |
}
|
392 |
}
|
| 380 |
boolean oos;
|
393 |
boolean oos;
|
| 381 |
for (Entry<Date, Map<Long, FbaSalesSnapshot>> entry : orderDateItemIdFbaSaleSnapshotMap.entrySet()){
|
394 |
for (Entry<Date, Map<Long, FbaSalesSnapshot>> entry : orderDateItemIdFbaSaleSnapshotMap.entrySet()){
|