public ReconciliationVoucher createReconciliationVoucher(
ReconciliationType reconciliationType, String remark) {
User loggedOnUser = userService.getLoggedInUser();
ReconciliationVoucher reconciliationVoucher = new ReconciliationVoucher();
reconciliationVoucher.setReconciliationType(reconciliationType);
reconciliationVoucher.setCreateDate(new Date());
reconciliationVoucher.setCreatedBy(loggedOnUser);
reconciliationVoucher.setWarehouse(userService.getWarehouseForLoggedInUser());
reconciliationVoucher.setRemarks(remark);
reconciliationVoucher.setReconciliationDate(new Date());
reconciliationVoucher =
(ReconciliationVoucher) reconciliationVoucherDao.save(reconciliationVoucher);
return reconciliationVoucher;
}
@Transactional
public RvLineItem reconcileInventoryForPV(
RvLineItem rvLineItem, List<SkuItem> inStockSkuItems, Sku sku) {
RvLineItem rvLineItemSaved = null;
User loggedOnUser = userService.getLoggedInUser();
int deleteQty = rvLineItem.getQty().intValue();
rvLineItem.setSku(sku);
rvLineItem.setReconciledQty(rvLineItem.getQty());
rvLineItem.setReconciliationType(
EnumReconciliationType.ProductVariantAudited.asReconciliationType());
rvLineItemSaved = (RvLineItem) reconciliationVoucherDao.save(rvLineItem);
for (int i = 0; i < deleteQty; i++) {
SkuItem skuItem = inStockSkuItems.get(i);
// Delete -1 entry in PVI
adminInventoryService.inventoryCheckinCheckout(
sku,
skuItem,
null,
null,
null,
rvLineItemSaved,
null,
inventoryService.getInventoryTxnType(EnumInvTxnType.PRODUCT_VARIANT_AUDITED),
-1L,
loggedOnUser);
// set sku item status to Product_variant_ Audited
skuItem.setSkuItemStatus(EnumSkuItemStatus.ProductVariantAudited.getSkuItemStatus());
skuItem = skuGroupService.saveSkuItem(skuItem);
}
// Check inventory health now.
inventoryService.checkInventoryHealth(sku.getProductVariant());
// save RvLine item
return rvLineItemSaved;
}
@Transactional
public void reconcileAddRV(
User loggedOnUser,
List<RvLineItem> rvLineItems,
ReconciliationVoucher reconciliationVoucher) {
if (reconciliationVoucher == null || reconciliationVoucher.getId() == null) {
// reconciliationVoucher = new ReconciliationVoucher();
reconciliationVoucher.setCreateDate(new Date());
reconciliationVoucher.setCreatedBy(loggedOnUser);
reconciliationVoucher.setReconciliationType(
EnumReconciliationType.Add.asReconciliationType());
}
reconciliationVoucher =
(ReconciliationVoucher) reconciliationVoucherDao.save(reconciliationVoucher);
logger.debug("rvLineItems@Save: " + rvLineItems.size());
for (RvLineItem rvLineItem : rvLineItems) {
Sku sku = rvLineItem.getSku();
if (sku == null) {
sku =
skuService.getSKU(rvLineItem.getProductVariant(), reconciliationVoucher.getWarehouse());
}
if (rvLineItem.getQty() != null && rvLineItem.getQty() == 0 && rvLineItem.getId() != null) {
getBaseDao().delete(rvLineItem);
} else if (rvLineItem.getId() == null) {
Long additionType = rvLineItem.getReconciliationType().getId();
EnumReconciliationType enumReconciliationType =
EnumReconciliationType.getEnumReconciliationTypeById(additionType);
InvTxnType invTxnType = null;
switch (enumReconciliationType) {
case AddDamage:
invTxnType = inventoryService.getInventoryTxnType(EnumInvTxnType.RV_ADD_DAMAGED);
break;
case AddExpired:
invTxnType = inventoryService.getInventoryTxnType(EnumInvTxnType.RV_ADD_EXPIRED);
break;
case AddBatchMismatch:
invTxnType = inventoryService.getInventoryTxnType(EnumInvTxnType.RV_ADD_BATCH_MISMATCH);
break;
case CustomerReturn:
invTxnType = inventoryService.getInventoryTxnType(EnumInvTxnType.RV_CUSTOMER_RETURN);
break;
case PharmaReturn:
invTxnType = inventoryService.getInventoryTxnType(EnumInvTxnType.RV_PHARMA_RETURN);
break;
case AddFreeVariant:
invTxnType =
inventoryService.getInventoryTxnType(EnumInvTxnType.RV_ADD_FREE_VARIANT_RECONCILE);
break;
case AddIncorrectCounting:
invTxnType =
inventoryService.getInventoryTxnType(EnumInvTxnType.RV_ADD_INCORRECT_COUNTING);
break;
}
rvLineItem.setSku(sku);
rvLineItem.setReconciliationVoucher(reconciliationVoucher);
rvLineItem = (RvLineItem) getBaseDao().save(rvLineItem);
SkuGroup skuGroup = null;
if (productVariantInventoryDao.getPVIForRV(sku, rvLineItem).isEmpty()) {
// Create batch and checkin inv
// SkuGroup skuGroup =
// adminInventoryService.createSkuGroup(rvLineItem.getBatchNumber(),
// rvLineItem.getMfgDate(), rvLineItem.getExpiryDate(), rvLineItem.getCostPrice(),
// rvLineItem.getMrp(), null, reconciliationVoucher, null, sku);
skuGroup =
adminInventoryService.createSkuGroupWithoutBarcode(
rvLineItem.getBatchNumber(),
rvLineItem.getMfgDate(),
rvLineItem.getExpiryDate(),
rvLineItem.getCostPrice(),
rvLineItem.getMrp(),
null,
reconciliationVoucher,
null,
sku);
adminInventoryService.createSkuItemsAndCheckinInventory(
skuGroup,
rvLineItem.getQty(),
null,
null,
rvLineItem,
null,
invTxnType,
loggedOnUser);
rvLineItem.setSkuGroup(skuGroup);
}
rvLineItem.setReconciledQty(rvLineItem.getQty());
rvLineItem = (RvLineItem) getBaseDao().save(rvLineItem);
// Add PVI Entry with -1 and set sku item status to expired
if ((additionType.intValue()) == (EnumReconciliationType.AddExpired.getId().intValue())) {
for (SkuItem skuItem : skuGroup.getSkuItems()) {
adminInventoryService.inventoryCheckinCheckout(
sku,
skuItem,
null,
null,
null,
rvLineItem,
null,
EnumInvTxnType.RV_ADD_EXPIRED_AUTOMATIC_DELETION.asInvTxnType(),
-1L,
userService.getLoggedInUser());
skuItem.setSkuItemStatus(EnumSkuItemStatus.Expired.getSkuItemStatus());
skuGroupService.saveSkuItem(skuItem);
}
}
// Check inventory health now.
inventoryService.checkInventoryHealth(rvLineItem.getSku().getProductVariant());
}
}
}
@Override
public DebitNote getDebitNote(ReconciliationVoucher reconciliationVoucher) {
return (DebitNote) reconciliationVoucherDao.getDebitNote(reconciliationVoucher);
}
@Transactional
public RvLineItem reconcileSKUItems(
ReconciliationVoucher reconciliationVoucher,
ReconciliationType reconciliationType,
SkuItem skuItem,
String remarks) {
SkuGroup skuGroup = skuItem.getSkuGroup();
Sku sku = skuGroup.getSku();
Long subtractionType = reconciliationType.getId();
EnumReconciliationType subtractTypeEnum =
EnumReconciliationType.getEnumReconciliationTypeById(subtractionType);
InvTxnType invTxnType = null;
SkuItemStatus skuItemStatus = null;
switch (subtractTypeEnum) {
case SubtractDamage:
invTxnType = inventoryService.getInventoryTxnType(EnumInvTxnType.RV_SUBTRACT_DAMAGED);
skuItemStatus = EnumSkuItemStatus.Damaged.getSkuItemStatus();
break;
case SubtractExpired:
invTxnType = inventoryService.getInventoryTxnType(EnumInvTxnType.RV_SUBTRACT_EXPIRED);
skuItemStatus = EnumSkuItemStatus.Expired.getSkuItemStatus();
break;
case Lost:
invTxnType = inventoryService.getInventoryTxnType(EnumInvTxnType.RV_LOST_PILFERAGE);
skuItemStatus = EnumSkuItemStatus.Lost.getSkuItemStatus();
break;
case SubtractBatchMismatch:
invTxnType =
inventoryService.getInventoryTxnType(EnumInvTxnType.RV_SUBTRACT_BATCH_MISMATCH);
skuItemStatus = EnumSkuItemStatus.BatchMismatch.getSkuItemStatus();
break;
case MrpMismatch:
invTxnType = inventoryService.getInventoryTxnType(EnumInvTxnType.RV_MRP_MISMATCH);
skuItemStatus = EnumSkuItemStatus.MrpMismatch.getSkuItemStatus();
break;
case NonMoving:
invTxnType = inventoryService.getInventoryTxnType(EnumInvTxnType.RV_NON_MOVING);
skuItemStatus = EnumSkuItemStatus.NonMoving.getSkuItemStatus();
break;
case SubtractFreeVariant:
invTxnType =
inventoryService.getInventoryTxnType(EnumInvTxnType.RV_SUBTRACT_FREE_VARIANT_RECONCILE);
skuItemStatus = EnumSkuItemStatus.FreeVariant.getSkuItemStatus();
break;
case SubtractIncorrectCounting:
invTxnType =
inventoryService.getInventoryTxnType(EnumInvTxnType.RV_SUBTRACT_INCORRECT_COUNTING);
skuItemStatus = EnumSkuItemStatus.IncorrectCounting.getSkuItemStatus();
break;
}
RvLineItem rvLineItem =
reconciliationVoucherDao.getRvLineItems(
reconciliationVoucher, sku, skuGroup, reconciliationType);
if (rvLineItem == null) {
rvLineItem = createRVLineItemWithBasicDetails(skuGroup, sku);
}
rvLineItem.setReconciliationType(reconciliationType);
rvLineItem.setReconciliationVoucher(reconciliationVoucher);
rvLineItem.setRemarks(remarks);
if (rvLineItem.getReconciledQty() != null) {
rvLineItem.setReconciledQty(rvLineItem.getReconciledQty() + 1L);
rvLineItem.setQty(rvLineItem.getQty() + 1L);
} else {
rvLineItem.setReconciledQty(1L);
rvLineItem.setQty(1L);
}
rvLineItem = (RvLineItem) getBaseDao().save(rvLineItem);
adminInventoryService.inventoryCheckinCheckout(
sku,
skuItem,
null,
null,
null,
rvLineItem,
null,
invTxnType,
-1L,
userService.getLoggedInUser());
if (skuItemStatus != null) {
skuItem.setSkuItemStatus(skuItemStatus);
}
skuItem = skuGroupService.saveSkuItem(skuItem);
if (reconciliationType.getId().equals(EnumReconciliationType.SubtractDamage.getId())) {
adminInventoryService.damageInventoryCheckin(skuItem, null);
}
// Check inventory health now.
inventoryService.checkInventoryHealth(rvLineItem.getSku().getProductVariant());
return rvLineItem;
}