Subversion Repositories SmartDukaan

	public void fixDupGrns() throws Exception {

		List<Integer> duplicatePurchaseIds = Arrays.asList(11655,13615, 13616, 13617, 13625, 13626, 8227);

		for(int duplicatePurchaseId : duplicatePurchaseIds) {

			Purchase purchase = purchaseRepository.selectById(duplicatePurchaseId);

			List<InventoryItem> inventoryItems = inventoryItemRepository.selectByPurchaseId(duplicatePurchaseId);

			schemeService.rollbackSchemes(inventoryItems.stream().map(x->x.getId()).collect(Collectors.toList()), duplicatePurchaseId, "Rolled back duplicate grn for Purchase Invoice " + purchase.getPurchaseReference());

			for(InventoryItem inventoryItem : inventoryItems) {

				inventoryItemRepository.delete(inventoryItem);

				List<ScanRecord> scanRecords = scanRecordRepository.selectByInventoryItemId(inventoryItem.getId());

				for(ScanRecord scanRecord : scanRecords) {

					scanRecordRepository.delete(scanRecord);

				}

				List<SchemeInOut> sios = schemeInOutRepository.selectByInventoryItemIds(new HashSet<>(Arrays.asList(inventoryItem.getId())));

				for(SchemeInOut sio : sios) {

					LOGGER.info("SIO - {}", sio);

					schemeInOutRepository.delete(sio);

				}

			}

		}

		throw new Exception();

	}