| Line 1383... |
Line 1383... |
| 1383 |
|
1383 |
|
| 1384 |
}
|
1384 |
}
|
| 1385 |
}
|
1385 |
}
|
| 1386 |
|
1386 |
|
| 1387 |
public void fixOrders() throws Exception {
|
1387 |
public void fixOrders() throws Exception {
|
| 1388 |
List<Order> orders = orderRepository.selectAllOrderDatesBetweenByStatus(LocalDate.now().atStartOfDay(),
|
1388 |
List<Order> orders = orderRepository.selectAllOrderDatesBetweenByStatus(LocalDate.now().minusDays(10).atStartOfDay(),
|
| 1389 |
LocalDateTime.now(), OrderStatus.SUBMITTED_FOR_PROCESSING);
|
1389 |
LocalDateTime.now(), OrderStatus.SUBMITTED_FOR_PROCESSING);
|
| 1390 |
orders = orders.stream().filter(x -> x.getCreateTimestamp().isAfter(LocalDateTime.of(2021, 7, 21, 0, 0, 0)))
|
1390 |
orders = orders.stream().filter(x -> x.getCreateTimestamp().isAfter(LocalDateTime.of(2021, 7, 21, 0, 0, 0)))
|
| 1391 |
.collect(Collectors.toList());
|
1391 |
.collect(Collectors.toList());
|
| 1392 |
for (Order order : orders) {
|
1392 |
for (Order order : orders) {
|
| 1393 |
/*
|
1393 |
|
| 1394 |
* LineItem lineItem =
|
1394 |
LineItem lineItem =
|
| 1395 |
* lineItemRepository.selectById(order.getLineItem().getId()); if
|
1395 |
lineItemRepository.selectById(order.getLineItem().getId()); if
|
| 1396 |
* (order.getOrderType() == null) { order.setProductCondition(0);
|
1396 |
(order.getOrderType() == null) { order.setProductCondition(0);
|
| 1397 |
* order.setOrderType(0); int itemId = order.getLineItem().getItemId(); int
|
1397 |
order.setOrderType(0); int itemId = order.getLineItem().getItemId(); int
|
| 1398 |
* fulfillmentWarehouseId = order.getFulfilmentWarehouseId();
|
1398 |
fulfillmentWarehouseId = order.getFulfilmentWarehouseId();
|
| 1399 |
* System.out.println("Item id " + itemId); Item item =
|
1399 |
System.out.println("Item id " + itemId); Item item =
|
| 1400 |
* itemRepository.selectById(itemId);
|
1400 |
itemRepository.selectById(itemId);
|
| 1401 |
*
|
1401 |
|
| 1402 |
* VendorItemPricing vendorItemPricing =
|
1402 |
VendorItemPricing vendorItemPricing =
|
| 1403 |
* vendorItemPricingRepository.selectByItemIdAndVendorId(itemId,
|
1403 |
vendorItemPricingRepository.selectByItemIdAndVendorId(itemId,
|
| 1404 |
* fulfillmentWarehouseId); if (vendorItemPricing == null) { vendorItemPricing =
|
1404 |
fulfillmentWarehouseId); if (vendorItemPricing == null) { vendorItemPricing =
|
| 1405 |
* vendorItemPricingRepository.selectAll(itemId).get(0); }
|
1405 |
vendorItemPricingRepository.selectAll(itemId).get(0); }
|
| 1406 |
* System.out.println("vendorItemPricing " + vendorItemPricing);
|
1406 |
System.out.println("vendorItemPricing " + vendorItemPricing);
|
| 1407 |
* lineItem.setProductGoup(item.getProductGroup());
|
1407 |
lineItem.setProductGoup(item.getProductGroup());
|
| 1408 |
* lineItem.setColor(item.getColor());
|
1408 |
lineItem.setColor(item.getColor());
|
| 1409 |
* lineItem.setNlc(vendorItemPricing.getNlc());
|
1409 |
lineItem.setNlc(vendorItemPricing.getNlc());
|
| 1410 |
* lineItem.setTransferPrice(vendorItemPricing.getTp());
|
1410 |
lineItem.setTransferPrice(vendorItemPricing.getTp());
|
| 1411 |
* lineItem.setLogisticsCost(0f); lineItem.setCodCollectionCharges(0f);
|
1411 |
lineItem.setLogisticsCost(0f); lineItem.setCodCollectionCharges(0f);
|
| 1412 |
*
|
1412 |
|
| 1413 |
* }
|
1413 |
}
|
| 1414 |
*/
|
1414 |
|
| 1415 |
|
1415 |
|
| 1416 |
int warehouseTo = fofoStoreRepository.selectByRetailerId(order.getRetailerId()).getWarehouseId();
|
1416 |
int warehouseTo = fofoStoreRepository.selectByRetailerId(order.getRetailerId()).getWarehouseId();
|
| 1417 |
int itemId = order.getLineItem().getItemId();
|
1417 |
int itemId = order.getLineItem().getItemId();
|
| 1418 |
Warehouse warehouse = transactionService.getFulfilmentWarehouseMap(Arrays.asList(itemId), warehouseTo).get(itemId);
|
1418 |
Warehouse warehouse = transactionService.getFulfilmentWarehouseMap(Arrays.asList(itemId), warehouseTo).get(itemId);
|
| 1419 |
LOGGER.info("Order Id - {}, WarehouseTo - {}, Item Id - {}, Warehouse From - {}, Fulfilment Warehouse Id - {}",
|
1419 |
LOGGER.info("Order Id - {}, WarehouseTo - {}, Item Id - {}, Warehouse From - {}, Fulfilment Warehouse Id - {}",
|