/**
* Get Cash Journal for currency, org and date
* @param ctx context
* @param C_Currency_ID currency
* @param AD_Org_ID org
* @param dateAcct date
* @param trxName transaction
* @return cash
*/
public static MCash Get(Ctx ctx, int AD_Org_ID, DateTime?dateAcct, int C_Currency_ID, Trx trxName)
{
MCash retValue = null;
// Existing Journal
String sql = "SELECT * FROM C_Cash c "
+ "WHERE c.AD_Org_ID=" + AD_Org_ID // #1
+ " AND TRUNC(c.StatementDate, 'DD')=@sdate" // #2
+ " AND c.Processed='N'"
+ " AND EXISTS (SELECT * FROM C_CashBook cb "
+ "WHERE c.C_CashBook_ID=cb.C_CashBook_ID AND cb.AD_Org_ID=c.AD_Org_ID"
+ " AND cb.C_Currency_ID=" + C_Currency_ID + ")"; // #3
DataTable dt = null;
SqlParameter[] param = null;
IDataReader idr = null;
try
{
param = new SqlParameter[1];
param[0] = new SqlParameter("@sdate", TimeUtil.GetDay(dateAcct));
idr = DB.ExecuteReader(sql, param, trxName);
dt = new DataTable();
dt.Load(idr);
idr.Close();
foreach (DataRow dr in dt.Rows)
{
retValue = new MCash(ctx, dr, trxName);
}
}
catch (Exception e)
{
if (idr != null)
{
idr.Close();
}
_log.Log(Level.SEVERE, sql, e);
}
finally { dt = null; }
if (retValue != null)
{
return(retValue);
}
// Get CashBook
MCashBook cb = MCashBook.Get(ctx, AD_Org_ID, C_Currency_ID);
if (cb == null)
{
_log.Warning("No CashBook for AD_Org_ID=" + AD_Org_ID + ", C_Currency_ID=" + C_Currency_ID);
return(null);
}
// Create New Journal
retValue = new MCash(cb, dateAcct);
retValue.Save(trxName);
return(retValue);
}
/**
* Get Cash Book
* @return cash book
*/
public MCashBook GetCashBook()
{
if (_book == null)
{
_book = MCashBook.Get(GetCtx(), GetC_CashBook_ID());
}
return(_book);
}
/**
* Get CashBook
* @return cash book
*/
public MCashBook GetCashBook()
{
if (_cashBook == null)
{
_cashBook = MCashBook.Get(GetCtx(), GetParent().GetC_CashBook_ID());
}
return(_cashBook);
}
