| Line 1453... |
Line 1453... |
| 1453 |
public void grouping() throws Exception {
|
1453 |
public void grouping() throws Exception {
|
| 1454 |
DateTimeFormatter dtf = DateTimeFormatter.ofPattern("MM-dd-yyyy hh:mm");
|
1454 |
DateTimeFormatter dtf = DateTimeFormatter.ofPattern("MM-dd-yyyy hh:mm");
|
| 1455 |
List<PriceDropIMEI> priceDropImeis = priceDropIMEIRepository.selectByStatus(PriceDropImeiStatus.APPROVED);
|
1455 |
List<PriceDropIMEI> priceDropImeis = priceDropIMEIRepository.selectByStatus(PriceDropImeiStatus.APPROVED);
|
| 1456 |
System.out.println(String.join("\t",
|
1456 |
System.out.println(String.join("\t",
|
| 1457 |
Arrays.asList("IMEI", "ItemId", "Brand", "Model Name", "Model Number", "Franchise Id", "Franchise Name",
|
1457 |
Arrays.asList("IMEI", "ItemId", "Brand", "Model Name", "Model Number", "Franchise Id", "Franchise Name",
|
| 1458 |
"Grn On", "Price Dropped On", "Approved On", "Dropped Value", "Returned On", "Is Doa")));
|
1458 |
"Grn On", "Price Dropped On", "Approved On", "Returned On","Price Drop Paid", "Is Doa")));
|
| 1459 |
Map<Integer, CustomRetailer> retailersMap = retailerService.getFofoRetailers();
|
1459 |
Map<Integer, CustomRetailer> retailersMap = retailerService.getFofoRetailers();
|
| 1460 |
for (PriceDropIMEI priceDropIMEI : priceDropImeis) {
|
1460 |
for (PriceDropIMEI priceDropIMEI : priceDropImeis) {
|
| 1461 |
if(priceDropIMEI.getPartnerId()==0) continue;
|
1461 |
if(priceDropIMEI.getPartnerId()==0) continue;
|
| 1462 |
HashSet<String> imeis = new HashSet<>();
|
1462 |
HashSet<String> imeis = new HashSet<>();
|
| 1463 |
PriceDrop priceDrop = priceDropRepository.selectById(priceDropIMEI.getPriceDropId());
|
1463 |
PriceDrop priceDrop = priceDropRepository.selectById(priceDropIMEI.getPriceDropId());
|
| Line 1482... |
Line 1482... |
| 1482 |
item.getModelName(), item.getModelNumber(), inventoryItem.getFofoId() + "",
|
1482 |
item.getModelName(), item.getModelNumber(), inventoryItem.getFofoId() + "",
|
| 1483 |
customRetailer.getBusinessName(), inventoryItem.getCreateTimestamp().format(dtf),
|
1483 |
customRetailer.getBusinessName(), inventoryItem.getCreateTimestamp().format(dtf),
|
| 1484 |
priceDrop.getAffectedOn().format(dtf),
|
1484 |
priceDrop.getAffectedOn().format(dtf),
|
| 1485 |
priceDropIMEI.getUpdateTimestamp().format(dtf),
|
1485 |
priceDropIMEI.getUpdateTimestamp().format(dtf),
|
| 1486 |
inventoryItem.getUpdateTimestamp().format(dtf),
|
1486 |
inventoryItem.getUpdateTimestamp().format(dtf),
|
| - |
|
1487 |
priceDrop.getPartnerPayout() + "",
|
| 1487 |
inventoryItem.getLastScanType().equals(ScanType.DOA_OUT) + "")));
|
1488 |
inventoryItem.getLastScanType().equals(ScanType.DOA_OUT) + "")));
|
| 1488 |
}
|
1489 |
}
|
| 1489 |
}
|
1490 |
}
|
| 1490 |
}
|
1491 |
}
|
| 1491 |
/*
|
1492 |
/*
|