WebSVN – SmartDukaan – Diff – /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/migrations/RunOnceTasks.java

 import com.spice.profitmandi.dao.entity.fofo.PurchaseReturnItem;
 import com.spice.profitmandi.dao.entity.fofo.ScanRecord;
 import com.spice.profitmandi.dao.entity.fofo.SchemeInOut;
 import com.spice.profitmandi.dao.entity.fofo.SchemeItem;
 import com.spice.profitmandi.dao.entity.inventory.SaholicInventorySnapshot;
-import com.spice.profitmandi.dao.entity.inventory.VendorItemPricing;
+import com.spice.profitmandi.dao.entity.inventory.Warehouse;
 import com.spice.profitmandi.dao.entity.transaction.HdfcPayment;
 import com.spice.profitmandi.dao.entity.transaction.LineItem;
 import com.spice.profitmandi.dao.entity.transaction.LineItemImei;
 import com.spice.profitmandi.dao.entity.transaction.ManualPaymentType;
 import com.spice.profitmandi.dao.entity.transaction.Order;
 	@Autowired
 	private LineItemRepository lineItemRepository;
 	@Autowired
 	private LeadRepository leadRepository;
 	@Autowired
 	private VendorItemPricingRepository vendorItemPricingRepository;
 	@Autowired
 	private WarehouseRepository warehouseRepository;
 	@Autowired
 	private PurchaseReturnItemRepository purchaseReturnItemRepository;
 	@Autowired
 	private CurrentInventorySnapshotRepository currentInventorySnapshotRepository;
 	@Autowired
 	private OrderRepository orderRepository;
 	@Autowired
 	private ScanRecordRepository scanRecordRepository;
 	@Autowired
 	private JavaMailSender mailSender;
+		}
+	}
 	public void fixOrders() throws Exception {
-		List<Order> orders = orderRepository.selectAllOrderDatesBetweenByStatus(LocalDate.now().atStartOfDay(), LocalDateTime.now(), OrderStatus.SUBMITTED_FOR_PROCESSING);
+		List<Order> orders = orderRepository.selectAllOrderDatesBetweenByStatus(LocalDate.now().atStartOfDay(),
-		orders = orders.stream().filter(x->x.getCreateTimestamp().isAfter(LocalDateTime.of(2021, 7, 21, 0, 0, 0))).collect(Collectors.toList());
-		for(Order order : orders) {
-			  LineItem lineItem =
-			  lineItemRepository.selectById(order.getLineItem().getId());
+				LocalDateTime.now(), OrderStatus.SUBMITTED_FOR_PROCESSING);
-			  if(order.getOrderType()==null) { order.setProductCondition(0);
-			  order.setOrderType(0); int itemId = order.getLineItem().getItemId(); int
+		orders = orders.stream().filter(x -> x.getCreateTimestamp().isAfter(LocalDateTime.of(2021, 7, 21, 0, 0, 0)))
-			  fulfillmentWarehouseId = order.getFulfilmentWarehouseId();
-			  System.out.println("Item id " + itemId); Item item =
-			  itemRepository.selectById(itemId);
+				.collect(Collectors.toList());
-			  VendorItemPricing vendorItemPricing =
+		for (Order order : orders) {
-			  vendorItemPricingRepository.selectByItemIdAndVendorId(itemId,
-			  fulfillmentWarehouseId); if(vendorItemPricing==null) { vendorItemPricing =
-			  vendorItemPricingRepository.selectAll(itemId).get(0); }
-			  System.out.println("vendorItemPricing " + vendorItemPricing);
-			  lineItem.setProductGoup(item.getProductGroup());
-			  lineItem.setColor(item.getColor());
-			  lineItem.setNlc(vendorItemPricing.getNlc());
-			  lineItem.setTransferPrice(vendorItemPricing.getTp());
-			  lineItem.setLogisticsCost(0f); lineItem.setCodCollectionCharges(0f);
-			  }
 			/*
-			 * int warehouseTo =
+			 * LineItem lineItem =
-			 * fofoStoreRepository.selectByRetailerId(order.getRetailerId()).getWarehouseId(
+			 * lineItemRepository.selectById(order.getLineItem().getId()); if
+			 * (order.getOrderType() == null) { order.setProductCondition(0);
-			 * ); int itemId = order.getLineItem().getItemId(); Warehouse warehouse =
+			 * order.setOrderType(0); int itemId = order.getLineItem().getItemId(); int
-			 * transactionService.getFulfilmentWarehouseMap(Arrays.asList(itemId),
+			 * fulfillmentWarehouseId = order.getFulfilmentWarehouseId();
+			 * System.out.println("Item id " + itemId); Item item =
-			 * warehouseTo).get(itemId);
+			 * itemRepository.selectById(itemId);
+			 *
+			 * VendorItemPricing vendorItemPricing =
+			 * vendorItemPricingRepository.selectByItemIdAndVendorId(itemId,
+			 * fulfillmentWarehouseId); if (vendorItemPricing == null) { vendorItemPricing =
+			 * vendorItemPricingRepository.selectAll(itemId).get(0); }
+			 * System.out.println("vendorItemPricing " + vendorItemPricing);
-			 * order.setWarehouseId(warehouse.getBillingWarehouseId());
+			 * lineItem.setProductGoup(item.getProductGroup());
+			 * lineItem.setColor(item.getColor());
-			 * order.setFulfilmentWarehouseId(warehouse.getId());
+			 * lineItem.setNlc(vendorItemPricing.getNlc());
+			 * lineItem.setTransferPrice(vendorItemPricing.getTp());
+			 * lineItem.setLogisticsCost(0f); lineItem.setCodCollectionCharges(0f);
+			 *
+			 * }
 			 */
+			int warehouseTo = fofoStoreRepository.selectByRetailerId(order.getRetailerId()).getWarehouseId();
+			int itemId = order.getLineItem().getItemId();
+			Warehouse warehouse = transactionService.getFulfilmentWarehouseMap(Arrays.asList(itemId), warehouseTo).get(itemId);
+			LOGGER.info("Order Id - {}, WarehouseTo - {}, Item Id - {}, Warehouse From - {}, Fulfilment Warehouse Id - {}",
+					order.getId(), warehouseTo, itemId, warehouse.getId(), warehouse.getBillingWarehouseId());
+			//order.setWarehouseId(warehouse.getBillingWarehouseId());
+			//order.setFulfilmentWarehouseId(warehouse.getId());
+		}
+	}
+}
 //7015845171

Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/migrations/RunOnceTasks.java – Rev 28730 → 28731