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