/**
* Create Confirmation or return existing one
* @param ship shipment
* @param confirmType confirmation type
* @param checkExisting if false, new confirmation is created
* @return Confirmation
*/
public static MInOutConfirm Create(MInOut ship, String confirmType, Boolean checkExisting)
{
if (checkExisting)
{
MInOutConfirm[] confirmations = ship.GetConfirmations(false);
for (int i = 0; i < confirmations.Length; i++)
{
MInOutConfirm confirm = confirmations[i];
if (confirm.GetConfirmType().Equals(confirmType))
{
_log.Info("create - existing: " + confirm);
return(confirm);
}
}
}
MInOutConfirm confirm1 = new MInOutConfirm(ship, confirmType);
confirm1.Save(ship.Get_TrxName());
MInOutLine[] shipLines = ship.GetLines(false);
for (int i = 0; i < shipLines.Length; i++)
{
MInOutLine sLine = shipLines[i];
MInOutLineConfirm cLine = new MInOutLineConfirm(confirm1);
cLine.SetInOutLine(sLine);
cLine.Save(ship.Get_TrxName());
}
_log.Info("New: " + confirm1);
return(confirm1);
}
/**
* Create Difference Document
* @param inout shipment/receipt
* @param confirm confirm line
* @return true if created
*/
private bool CreateDifferenceDoc(MInOut inout, MInOutLineConfirm confirm)
{
if (_processMsg == null)
{
_processMsg = "";
}
else if (_processMsg.Length > 0)
{
_processMsg += "; ";
}
// Credit Memo if linked Document
if (Env.Signum(confirm.GetDifferenceQty()) != 0 &&
!inout.IsSOTrx() && !inout.IsReturnTrx() && inout.GetRef_InOut_ID() != 0)
{
log.Info("Difference=" + confirm.GetDifferenceQty());
if (_creditMemo == null)
{
_creditMemo = new MInvoice(inout, null);
_creditMemo.SetDescription(Msg.Translate(GetCtx(),
"M_InOutConfirm_ID") + " " + GetDocumentNo());
_creditMemo.SetC_DocTypeTarget_ID(MDocBaseType.DOCBASETYPE_APCREDITMEMO);
if (!_creditMemo.Save(Get_TrxName()))
{
_processMsg += "Credit Memo not created";
return(false);
}
SetC_Invoice_ID(_creditMemo.GetC_Invoice_ID());
}
MInvoiceLine line = new MInvoiceLine(_creditMemo);
line.SetShipLine(confirm.GetLine());
line.SetQty(confirm.GetDifferenceQty()); // Entered/Invoiced
if (!line.Save(Get_TrxName()))
{
_processMsg += "Credit Memo Line not created";
return(false);
}
confirm.SetC_InvoiceLine_ID(line.GetC_InvoiceLine_ID());
}
// Create Inventory Difference
if (Env.Signum(confirm.GetScrappedQty()) != 0)
{
log.Info("Scrapped=" + confirm.GetScrappedQty());
if (_inventory == null)
{
MWarehouse wh = MWarehouse.Get(GetCtx(), inout.GetM_Warehouse_ID());
_inventory = new MInventory(wh);
_inventory.SetDescription(Msg.Translate(GetCtx(),
"M_InOutConfirm_ID") + " " + GetDocumentNo());
//vikas new 13 jan 2016 1
_inventory.SetIsInternalUse(true);
if (_inventory.GetC_DocType_ID() == 0)
{
MDocType[] types = MDocType.GetOfDocBaseType(GetCtx(), MDocBaseType.DOCBASETYPE_MATERIALPHYSICALINVENTORY);
if (types.Length > 0)
{
// Get Internal Use Inv Doc Type
for (int i = 0; i < types.Length; i++)
{
int _count = Util.GetValueOfInt(DB.ExecuteScalar("SELECT Count(*) FROM C_DocType WHERE IsActive='Y' AND IsInternalUse='Y' AND C_DocType_ID=" + types[i].GetC_DocType_ID()));
if (_count > 0)
{
_inventory.SetC_DocType_ID(types[i].GetC_DocType_ID());
break;
}
}
}
else
{
log.SaveError("Error", Msg.ParseTranslation(GetCtx(), "@NotFound@ @C_DocType_ID@"));
return(false);
}
}
// 13 jan End
if (!_inventory.Save(Get_TrxName()))
{
_processMsg += "Inventory not created";
return(false);
}
SetM_Inventory_ID(_inventory.GetM_Inventory_ID());
}
MInOutLine ioLine = confirm.GetLine();
MInventoryLine line = new MInventoryLine(_inventory,
ioLine.GetM_Locator_ID(), ioLine.GetM_Product_ID(),
ioLine.GetM_AttributeSetInstance_ID(),
confirm.GetScrappedQty(), Env.ZERO);
//new 15 jan
line.SetQtyInternalUse(line.GetQtyBook());
line.SetQtyBook(0);
line.SetIsInternalUse(true);
Tuple <String, String, String> mInfo = null;
if (Env.HasModulePrefix("DTD001_", out mInfo))
{
int _charge = Util.GetValueOfInt(DB.ExecuteScalar("SELECT C_Charge_ID FROM C_Charge WHERE isactive='Y' AND DTD001_ChargeType='INV'"));
line.SetC_Charge_ID(_charge);
}
// End
if (!line.Save(Get_TrxName()))
{
_processMsg += "Inventory Line not created";
return(false);
}
confirm.SetM_InventoryLine_ID(line.GetM_InventoryLine_ID());
}
//
if (!confirm.Save(Get_TrxName()))
{
_processMsg += "Confirmation Line not saved";
return(false);
}
return(true);
}
/**
* Split Shipment into confirmed and dispute
* @param original original shipment
* @param C_DocType_ID target DocType
* @param confirmLines confirm lines
*/
private void SplitInOut(MInOut original, int C_DocType_ID, MInOutLineConfirm[] confirmLines)
{
MInOut split = new MInOut(original, C_DocType_ID, original.GetMovementDate());
split.AddDescription("Splitted from " + original.GetDocumentNo());
split.SetIsInDispute(true);
// new 13 jan
int _count = Util.GetValueOfInt(DB.ExecuteScalar("SELECT count(*) FROM AD_Column clm INNER JOIN ad_table tbl on (tbl.ad_table_id=clm.ad_table_id) where tbl.tablename='M_InOutLineConfirm' and clm.columnname = 'M_Locator_ID' "));
//nnayak : Change for bug 1431337
split.SetRef_InOut_ID(original.Get_ID());
if (!split.Save(Get_TrxName()))
{
throw new Exception("Cannot save Split");
}
original.AddDescription("Split: " + split.GetDocumentNo());
if (!original.Save(Get_TrxName()))
{
throw new Exception("Cannot update original Shipment");
}
// Go through confirmations
for (int i = 0; i < confirmLines.Length; i++)
{
MInOutLineConfirm confirmLine = confirmLines[i];
Decimal differenceQty = confirmLine.GetDifferenceQty();
if (differenceQty.CompareTo(Env.ZERO) == 0)
{
continue;
}
//
MInOutLine oldLine = confirmLine.GetLine();
log.Fine("Qty=" + differenceQty + ", Old=" + oldLine);
//
MInOutLine splitLine = new MInOutLine(split);
splitLine.SetC_OrderLine_ID(oldLine.GetC_OrderLine_ID());
splitLine.SetC_UOM_ID(oldLine.GetC_UOM_ID());
splitLine.SetDescription(oldLine.GetDescription());
splitLine.SetIsDescription(oldLine.IsDescription());
splitLine.SetLine(oldLine.GetLine());
splitLine.SetM_AttributeSetInstance_ID(oldLine.GetM_AttributeSetInstance_ID());
//new 13 jan vikas ,assigne by surya sir
if (_count > 0)
{
if (confirmLine.GetM_Locator_ID() > 0)
{
splitLine.SetM_Locator_ID(confirmLine.GetM_Locator_ID());
}
else
{
splitLine.SetM_Locator_ID(oldLine.GetM_Locator_ID());
}
}
else
{
splitLine.SetM_Locator_ID(oldLine.GetM_Locator_ID());
}
//End
// splitLine.SetM_Locator_ID(oldLine.GetM_Locator_ID());
splitLine.SetM_Product_ID(oldLine.GetM_Product_ID());
splitLine.SetM_Warehouse_ID(oldLine.GetM_Warehouse_ID());
splitLine.SetRef_InOutLine_ID(oldLine.GetRef_InOutLine_ID());
splitLine.AddDescription("Split: from " + oldLine.GetMovementQty());
// Qtys
splitLine.SetQty(differenceQty); // Entered/Movement
if (!splitLine.Save(Get_TrxName()))
{
throw new Exception("Cannot save Split Line");
}
// Old
oldLine.AddDescription("Splitted: from " + oldLine.GetMovementQty());
oldLine.SetQty(Decimal.Subtract(oldLine.GetMovementQty(), differenceQty));
if (!oldLine.Save(Get_TrxName()))
{
throw new Exception("Cannot save Splited Line");
}
// Update Confirmation Line
confirmLine.SetTargetQty(Decimal.Subtract(confirmLine.GetTargetQty(), differenceQty));
confirmLine.SetDifferenceQty(Env.ZERO);
if (!confirmLine.Save(Get_TrxName()))
{
throw new Exception("Cannot save Split Confirmation");
}
} // for all confirmations
_processMsg = "Split @M_InOut_ID@=" + split.GetDocumentNo()
+ " - @M_InOutConfirm_ID@=";
// Create Dispute Confirmation
split.ProcessIt(DocActionVariables.ACTION_PREPARE);
// split.createConfirmation();
split.Save(Get_TrxName());
MInOutConfirm[] splitConfirms = split.GetConfirmations(true);
if (splitConfirms.Length > 0)
{
int index = 0;
if (splitConfirms[index].IsProcessed())
{
if (splitConfirms.Length > 1)
{
index++; // try just next
}
if (splitConfirms[index].IsProcessed())
{
_processMsg += splitConfirms[index].GetDocumentNo() + " processed??";
return;
}
}
splitConfirms[index].SetIsInDispute(true);
splitConfirms[index].Save(Get_TrxName());
_processMsg += splitConfirms[index].GetDocumentNo();
// Set Lines to unconfirmed
MInOutLineConfirm[] splitConfirmLines = splitConfirms[index].GetLines(false);
for (int i = 0; i < splitConfirmLines.Length; i++)
{
MInOutLineConfirm splitConfirmLine = splitConfirmLines[i];
splitConfirmLine.SetScrappedQty(Env.ZERO);
splitConfirmLine.SetConfirmedQty(Env.ZERO);
splitConfirmLine.Save(Get_TrxName());
}
}
else
{
_processMsg += "??";
}
}
/**
* Complete Document
* @return new status (Complete, In Progress, Invalid, Waiting ..)
*/
public String CompleteIt()
{
// Re-Check
if (!_justPrepared)
{
String status = PrepareIt();
if (!DocActionVariables.STATUS_INPROGRESS.Equals(status))
{
return(status);
}
}
// Implicit Approval
if (!IsApproved())
{
ApproveIt();
}
log.Info(ToString());
//
MInOut inout = new MInOut(GetCtx(), GetM_InOut_ID(), Get_TrxName());
MInOutLineConfirm[] lines = GetLines(false);
/* created by sunil 19/9/2016*/
if (Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(*) FROM AD_ModuleInfo WHERE Prefix = 'DTD001_'")) > 0)
{
MPackage package = new MPackage(GetCtx(), inout.GetM_Package_ID(), Get_Trx());
if (inout.GetM_Package_ID() > 0 && !package.IsDTD001_IsPackgConfirm())
{
_processMsg = Msg.GetMsg(GetCtx(), "PleaseConfirmPackage");
return(DocActionVariables.STATUS_INVALID);
}
}
//End
// Check if we need to split Shipment
if (IsInDispute())
{
MDocType dt = MDocType.Get(GetCtx(), inout.GetC_DocType_ID());
if (dt.IsSplitWhenDifference())
{
if (dt.GetC_DocTypeDifference_ID() == 0)
{
_processMsg = "No Split Document Type defined for: " + dt.GetName();
return(DocActionVariables.STATUS_INVALID);
}
SplitInOut(inout, dt.GetC_DocTypeDifference_ID(), lines);
_lines = null;
}
}
// All lines
for (int i = 0; i < lines.Length; i++)
{
MInOutLineConfirm confirmLine = lines[i];
confirmLine.Set_TrxName(Get_TrxName());
if (!confirmLine.ProcessLine(inout.IsSOTrx(), GetConfirmType()))
{
_processMsg = "ShipLine not saved - " + confirmLine;
return(DocActionVariables.STATUS_INVALID);
}
if (confirmLine.IsFullyConfirmed())
{
confirmLine.SetProcessed(true);
confirmLine.Save(Get_TrxName());
}
else
{
if (CreateDifferenceDoc(inout, confirmLine))
{
confirmLine.SetProcessed(true);
confirmLine.Save(Get_TrxName());
}
else
{
log.Log(Level.SEVERE, "Scrapped=" + confirmLine.GetScrappedQty()
+ " - Difference=" + confirmLine.GetDifferenceQty());
return(DocActionVariables.STATUS_INVALID);
}
}
} // for all lines
if (_creditMemo != null)
{
_processMsg += " @C_Invoice_ID@=" + _creditMemo.GetDocumentNo();
}
if (_inventory != null)
{
// _processMsg += " @M_Inventory_ID@=" + _inventory.GetDocumentNo();
//new 13 jan
_processMsg += " Internal.Inventory= " + _inventory.GetDocumentNo();
}
// User Validation
String valid = ModelValidationEngine.Get().FireDocValidate(this,
ModalValidatorVariables.DOCTIMING_AFTER_COMPLETE);
if (valid != null)
{
_processMsg = valid;
return(DocActionVariables.STATUS_INVALID);
}
SetProcessed(true);
if (!Save(Get_Trx()))
{
Get_Trx().Rollback();
_processMsg = "Ship/Receipt Confirmation Not saved";
return(DocActionVariables.STATUS_INVALID);
}
// Created By Sunil 17/9/2016
// Complete Shipment
MInOut io = new MInOut(GetCtx(), GetM_InOut_ID(), Get_TrxName());
var Status = io.CompleteIt();
if (Status == "CO")
{
io.SetProcessed(true);
io.SetDocStatus(DocActionVariables.STATUS_COMPLETED);
io.SetDocAction(DocActionVariables.ACTION_CLOSE);
io.Save();
}
else if (Status == "IN")
{
Get_Trx().Rollback();
_processMsg = "Shipment Not Completed";
return(DocActionVariables.STATUS_INVALID);
}
//end
//SetProcessed(true);
SetDocAction(DOCACTION_Close);
return(DocActionVariables.STATUS_COMPLETED);
}