/// <summary>
/// Create new Journal Batch by copying
/// </summary>
/// <param name="ctx">context</param>
/// <param name="GL_JournalBatch_ID">journal batch</param>
/// <param name="dateDoc">date of the document date</param>
/// <param name="trxName">transaction</param>
/// <returns>Journal Batch</returns>
public static MJournalBatch CopyFrom(Ctx ctx, int GL_JournalBatch_ID,
DateTime?dateDoc, Trx trxName)
{
MJournalBatch from = new MJournalBatch(ctx, GL_JournalBatch_ID, trxName);
if (from.GetGL_JournalBatch_ID() == 0)
{
throw new ArgumentException("From Journal Batch not found GL_JournalBatch_ID=" + GL_JournalBatch_ID);
}
//
MJournalBatch to = new MJournalBatch(ctx, 0, trxName);
PO.CopyValues(from, to, from.GetAD_Client_ID(), from.GetAD_Org_ID());
to.Set_ValueNoCheck("DocumentNo", null);
to.Set_ValueNoCheck("C_Period_ID", null);
to.SetDateAcct(dateDoc);
to.SetDateDoc(dateDoc);
to.SetDocStatus(DOCSTATUS_Drafted);
to.SetDocAction(DOCACTION_Complete);
to.SetIsApproved(false);
to.SetProcessed(false);
//
if (!to.Save())
{
throw new Exception("Could not create Journal Batch");
}
if (to.CopyDetailsFrom(from) == 0)
{
throw new Exception("Could not create Journal Batch Details");
}
return(to);
} // copyFrom
} // toString
/// <summary>
/// Execute Run.
/// </summary>
/// <returns>clear text info</returns>
public String ExecuteRun()
{
DateTime?dateDoc = GetDateNextRun();
if (!CalculateRuns())
{
throw new Exception("No Runs Left");
}
// log
MRecurringRun run = new MRecurringRun(GetCtx(), this);
String msg = "@Created@ ";
// Copy
if (GetRecurringType().Equals(MRecurring.RECURRINGTYPE_Order))
{
MOrder from = new MOrder(GetCtx(), GetC_Order_ID(), Get_TrxName());
MOrder order = MOrder.CopyFrom(from, dateDoc,
from.GetC_DocType_ID(), false, false, Get_TrxName());
run.SetC_Order_ID(order.GetC_Order_ID());
msg += order.GetDocumentNo();
}
else if (GetRecurringType().Equals(MRecurring.RECURRINGTYPE_Invoice))
{
MInvoice from = new MInvoice(GetCtx(), GetC_Invoice_ID(), Get_TrxName());
MInvoice invoice = MInvoice.CopyFrom(from, dateDoc,
from.GetC_DocType_ID(), false, Get_TrxName(), false);
run.SetC_Invoice_ID(invoice.GetC_Invoice_ID());
msg += invoice.GetDocumentNo();
}
else if (GetRecurringType().Equals(MRecurring.RECURRINGTYPE_Project))
{
MProject project = MProject.CopyFrom(GetCtx(), GetC_Project_ID(), dateDoc, Get_TrxName());
run.SetC_Project_ID(project.GetC_Project_ID());
msg += project.GetValue();
}
else if (GetRecurringType().Equals(MRecurring.RECURRINGTYPE_GLJournal))
{
MJournalBatch journal = MJournalBatch.CopyFrom(GetCtx(), GetGL_JournalBatch_ID(), dateDoc, Get_TrxName());
run.SetGL_JournalBatch_ID(journal.GetGL_JournalBatch_ID());
msg += journal.GetDocumentNo();
}
else
{
return("Invalid @RecurringType@ = " + GetRecurringType());
}
run.Save(Get_TrxName());
//
SetDateLastRun(run.GetUpdated());
SetRunsRemaining(GetRunsRemaining() - 1);
SetDateNextRun();
Save(Get_TrxName());
return(msg);
} // execureRun
/// <summary>
/// Parent Constructor.
/// </summary>
/// <param name="parent">parent batch</param>
public MJournal(MJournalBatch parent)
: this(parent.GetCtx(), 0, parent.Get_TrxName())
{
//this (parent.getCtx(), 0, parent.get_TrxName());
SetClientOrg(parent);
SetGL_JournalBatch_ID(parent.GetGL_JournalBatch_ID());
SetC_DocType_ID(parent.GetC_DocType_ID());
SetPostingType(parent.GetPostingType());
//
SetDateDoc(parent.GetDateDoc());
SetC_Period_ID(parent.GetC_Period_ID());
SetDateAcct(parent.GetDateAcct());
SetC_Currency_ID(parent.GetC_Currency_ID());
} // MJournal
} // getJournals
/// <summary>
/// Copy Journal/Lines from other Journal Batch
/// </summary>
/// <param name="jb">Journal Batch</param>
/// <returns>number of journals + lines copied</returns>
public int CopyDetailsFrom(MJournalBatch jb)
{
if (IsProcessed() || jb == null)
{
return(0);
}
int count = 0;
int lineCount = 0;
MJournal[] fromJournals = jb.GetJournals(false);
for (int i = 0; i < fromJournals.Length; i++)
{
MJournal toJournal = new MJournal(GetCtx(), 0, jb.Get_TrxName());
PO.CopyValues(fromJournals[i], toJournal, GetAD_Client_ID(), GetAD_Org_ID());
toJournal.SetGL_JournalBatch_ID(GetGL_JournalBatch_ID());
toJournal.Set_ValueNoCheck("DocumentNo", null); // create new
//Manish 18/7/2016. C_Period_ID was Null.. But column is mandatory in database so value can't be null.
toJournal.Set_ValueNoCheck("C_Period_ID", fromJournals[i].GetC_Period_ID());
// end
toJournal.SetDateDoc(GetDateDoc()); // dates from this Batch
toJournal.SetDateAcct(GetDateAcct());
toJournal.SetDocStatus(MJournal.DOCSTATUS_Drafted);
toJournal.SetDocAction(MJournal.DOCACTION_Complete);
toJournal.SetTotalCr(Env.ZERO);
toJournal.SetTotalDr(Env.ZERO);
toJournal.SetIsApproved(false);
toJournal.SetIsPrinted(false);
toJournal.SetPosted(false);
toJournal.SetProcessed(false);
if (toJournal.Save())
{
count++;
lineCount += toJournal.CopyLinesFrom(fromJournals[i], GetDateAcct(), 'x');
}
}
if (fromJournals.Length != count)
{
log.Log(Level.SEVERE, "Line difference - Journals=" + fromJournals.Length + " <> Saved=" + count);
}
return(count + lineCount);
} // copyLinesFrom
} // MJournalBatch
/// <summary>
/// Copy Constructor.Dos not copy: Dates/Period
/// </summary>
/// <param name="original">original</param>
public MJournalBatch(MJournalBatch original)
: this(original.GetCtx(), 0, original.Get_TrxName())
{
//this (original.getCtx(), 0, original.Get_TrxName());
SetClientOrg(original);
SetGL_JournalBatch_ID(original.GetGL_JournalBatch_ID());
//
// setC_AcctSchema_ID(original.getC_AcctSchema_ID());
// setGL_Budget_ID(original.getGL_Budget_ID());
SetGL_Category_ID(original.GetGL_Category_ID());
SetPostingType(original.GetPostingType());
SetDescription(original.GetDescription());
SetC_DocType_ID(original.GetC_DocType_ID());
SetControlAmt(original.GetControlAmt());
//
SetC_Currency_ID(original.GetC_Currency_ID());
// setC_ConversionType_ID(original.getC_ConversionType_ID());
// setCurrencyRate(original.getCurrencyRate());
// SetDateDoc(original.getDateDoc());
// setDateAcct(original.getDateAcct());
// setC_Period_ID(original.getC_Period_ID());
} // MJournal
} // reverseCorrectionIt
/// <summary>
/// Reverse Accrual. Flip Dr/Cr - Use Today's date
/// </summary>
/// <returns>true if success </returns>
public Boolean ReverseAccrualIt()
{
log.Info("ReverseCorrectIt - " + ToString());
MJournal[] journals = GetJournals(true);
// check prerequisites
for (int i = 0; i < journals.Length; i++)
{
MJournal journal = journals[i];
if (!journal.IsActive())
{
continue;
}
// All need to be closed/Completed
if (DOCSTATUS_Completed.Equals(journal.GetDocStatus()))
{
;
}
else
{
m_processMsg = "All Journals need to be Compleded: " + journal.GetSummary();
return(false);
}
}
// Reverse it
MJournalBatch reverse = new MJournalBatch(this);
reverse.SetC_Period_ID(0);
//reverse.SetDateDoc(new Timestamp(System.currentTimeMillis()));
reverse.SetDateDoc(DateTime.Now);
reverse.SetDateAcct(reverse.GetDateDoc());
// Reverse indicator
String description = reverse.GetDescription();
if (description == null)
{
description = "** " + GetDocumentNo() + " **";
}
else
{
description += " ** " + GetDocumentNo() + " **";
}
reverse.SetDescription(description);
reverse.Save();
// Reverse Journals
for (int i = 0; i < journals.Length; i++)
{
MJournal journal = journals[i];
if (!journal.IsActive())
{
continue;
}
if (journal.ReverseCorrectIt(reverse.GetGL_JournalBatch_ID()) == null)
{
m_processMsg = "Could not reverse " + journal;
return(false);
}
journal.Save();
}
return(true);
} // ReverseCorrectIt
} // closeIt
/// <summary>
/// Reverse Correction.As if nothing happened - same date
/// </summary>
/// <returns>true if success </returns>
public Boolean ReverseCorrectIt()
{
log.Info("reverseCorrectIt - " + ToString());
MJournal[] journals = GetJournals(true);
// check prerequisites
for (int i = 0; i < journals.Length; i++)
{
MJournal journal = journals[i];
if (!journal.IsActive())
{
continue;
}
// All need to be closed/Completed
if (DOCSTATUS_Completed.Equals(journal.GetDocStatus()))
{
;
}
else
{
m_processMsg = "All Journals need to be Compleded: " + journal.GetSummary();
return(false);
}
}
// Reverse it
MJournalBatch reverse = new MJournalBatch(this);
reverse.SetDateDoc(GetDateDoc());
reverse.SetC_Period_ID(GetC_Period_ID());
reverse.SetDateAcct(GetDateAcct());
reverse.SetC_Year_ID(GetC_Year_ID());
// Reverse indicator
if (reverse.Get_ColumnIndex("ReversalDoc_ID") > 0 && reverse.Get_ColumnIndex("IsReversal") > 0)
{
// set Reversal property for identifying, record is reversal or not during saving or for other actions
reverse.SetIsReversal(true);
// Set Orignal Document Reference
reverse.SetReversalDoc_ID(GetGL_JournalBatch_ID());
}
// for reversal document set Temp Document No to empty
if (reverse.Get_ColumnIndex("TempDocumentNo") > 0)
{
reverse.SetTempDocumentNo("");
}
String description = reverse.GetDescription();
if (description == null)
{
description = "** " + GetDocumentNo() + " **";
}
else
{
description += " ** " + GetDocumentNo() + " **";
reverse.SetDescription(description);
}
if (!reverse.Save())
{
ValueNamePair pp = VLogger.RetrieveError();
if (pp != null && !String.IsNullOrEmpty(pp.GetName()))
{
m_processMsg = pp.GetName() + " - " + "Could not reverse " + this;
}
else
{
m_processMsg = "Could not reverse " + this;
}
return(false);
}
//
// Reverse Journals
for (int i = 0; i < journals.Length; i++)
{
MJournal journal = journals[i];
if (!journal.IsActive())
{
continue;
}
if (journal.ReverseCorrectIt(reverse.GetGL_JournalBatch_ID()) == null)
{
m_processMsg = "Could not reverse " + journal;
return(false);
}
journal.Save();
}
return(true);
} // reverseCorrectionIt
} // toString
/// <summary>
/// Execute Run.
/// </summary>
/// <returns>clear text info</returns>
public String ExecuteRun()
{
DateTime?dateDoc = GetDateNextRun();
if (!CalculateRuns())
{
throw new Exception("No Runs Left");
}
// log
MRecurringRun run = new MRecurringRun(GetCtx(), this);
String msg = "@Created@ ";
//Checked if the Next Date Run is less then the date pressent Arpit on 15th Dec,2016
if (GetDateNextRun() == DateTime.Now.Date || GetDateNextRun() == null)
{
// Copy
if (GetRecurringType().Equals(MRecurring.RECURRINGTYPE_Order))
{
MOrder from = new MOrder(GetCtx(), GetC_Order_ID(), Get_TrxName());
MOrder order = MOrder.CopyFrom(from, dateDoc,
from.GetC_DocType_ID(), false, false, Get_TrxName());
run.SetC_Order_ID(order.GetC_Order_ID());
msg += order.GetDocumentNo();
}
else if (GetRecurringType().Equals(MRecurring.RECURRINGTYPE_Invoice))
{
MInvoice from = new MInvoice(GetCtx(), GetC_Invoice_ID(), Get_TrxName());
MInvoice invoice = MInvoice.CopyFrom(from, dateDoc,
from.GetC_DocType_ID(), false, Get_TrxName(), false);
run.SetC_Invoice_ID(invoice.GetC_Invoice_ID());
//Set Invoice Refrence and Description from Orignal to Recurring
invoice.Set_Value("InvoiceReference", from.GetDocumentNo() + "_" + (GetRunsMax() - GetRunsRemaining() + 1));
invoice.AddDescription(Msg.GetMsg(from.GetCtx(), "RecurringDocument") + from.GetDocumentNo());
if (!invoice.Save(Get_TrxName()))
{
ValueNamePair pp = VLogger.RetrieveError();
if (pp != null)
{
from.SetProcessMsg(Msg.GetMsg(from.GetCtx(), "CouldNotCreateInvoice") + pp.GetName());
}
else
{
from.SetProcessMsg(Msg.GetMsg(from.GetCtx(), "CouldNotCreateInvoice"));
}
throw new Exception(Msg.GetMsg(from.GetCtx(), "CouldNotCreateInvoice") + (pp != null ? pp.GetName() : ""));
}
msg += invoice.GetDocumentNo();
}
else if (GetRecurringType().Equals(MRecurring.RECURRINGTYPE_Project))
{
MProject project = MProject.CopyFrom(GetCtx(), GetC_Project_ID(), dateDoc, Get_TrxName());
run.SetC_Project_ID(project.GetC_Project_ID());
msg += project.GetValue();
}
else if (GetRecurringType().Equals(MRecurring.RECURRINGTYPE_GLJournalBatch)) //Changes to GL Journal Batch by Arpit
{
MJournalBatch journal = MJournalBatch.CopyFrom(GetCtx(), GetGL_JournalBatch_ID(), dateDoc, Get_TrxName());
run.SetGL_JournalBatch_ID(journal.GetGL_JournalBatch_ID());
msg += journal.GetDocumentNo();
}
//Added by Arpit on 14th, Dec,2016
else if (GetRecurringType().Equals(MRecurring.RECURRINGTYPE_GLJournal))
{
MJournal Journal = MJournal.CopyFrom(GetCtx(), GetGL_Journal_ID(), dateDoc, Get_TrxName());
run.SetGL_Journal_ID(Journal.GetGL_Journal_ID());
msg += Journal.GetDocumentNo();
}
//End here
else if (GetRecurringType().Equals(MRecurring.RECURRINGTYPE_Payment))
{
MPayment from = new MPayment(GetCtx(), GetC_Payment_ID(), Get_TrxName());
MPayment payment = MPayment.CopyFrom(from, dateDoc,
from.GetC_DocType_ID(), Get_TrxName());
run.SetC_Payment_ID(payment.GetC_Payment_ID());
msg += payment.GetDocumentNo();
}
else
{
return("Invalid @RecurringType@ = " + GetRecurringType());
}
run.Save(Get_TrxName());
//
SetDateLastRun(run.GetUpdated());
SetRunsRemaining(GetRunsRemaining() - 1);
SetDateNextRun();
Save(Get_TrxName());
return(msg);
}
else
{
return(Msg.GetMsg(GetCtx(), "RecurringNotCompleted") + String.Format("{0:dd/M/yyyy}", Convert.ToDateTime(GetDateNextRun())));
}
} // execureRun
