/******************************************************************************
* Product: Adempiere ERP & CRM Smart Business Solution *
* Copyright (C) 1999-2006 ComPiere, Inc. All Rights Reserved. *
* This program is free software; you can redistribute it and/or modify it *
* under the terms version 2 of the GNU General Public License as published *
* by the Free Software Foundation. This program is distributed in the hope *
* that it will be useful, but WITHOUT ANY WARRANTY; without even the implied *
* warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. *
* See the GNU General Public License for more details. *
* You should have received a copy of the GNU General Public License along *
* with this program; if not, write to the Free Software Foundation, Inc., *
* 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA. *
* For the text or an alternative of this public license, you may reach us *
* ComPiere, Inc., 2620 Augustine Dr. #245, Santa Clara, CA 95054, USA *
* or via info@compiere.org or http://www.compiere.org/license.html *
*****************************************************************************/
package org.compiere.acct;
import java.lang.reflect.*;
import java.math.*;
import java.sql.*;
import java.util.*;
import java.util.logging.*;
import org.compiere.model.*;
import org.compiere.process.*;
import org.compiere.report.*;
import org.compiere.util.*;
/**
* Posting Document Root.
*
*
* Table Base Document Types (C_DocType.DocBaseType & AD_Reference_ID=183)
* Class AD_Table_ID
* ------------------ ------------------------------
* C_Invoice: ARI, ARC, ARF, API, APC
* Doc_Invoice 318 - has C_DocType_ID
*
* C_Payment: ARP, APP
* Doc_Payment 335 - has C_DocType_ID
*
* C_Order: SOO, POO, POR (Requisition)
* Doc_Order 259 - has C_DocType_ID
*
* M_InOut: MMS, MMR
* Doc_InOut 319 - DocType derived
*
* M_Inventory: MMI
* Doc_Inventory 321 - DocType fixed
*
* M_Movement: MMM
* Doc_Movement 323 - DocType fixed
*
* M_Production: MMP
* Doc_Production 325 - DocType fixed
*
* C_BankStatement: CMB
* Doc_Bank 392 - DocType fixed
*
* C_Cash: CMC
* Doc_Cash 407 - DocType fixed
*
* C_Allocation: CMA
* Doc_Allocation 390 - DocType fixed
*
* GL_Journal: GLJ
* Doc_GLJournal 224 = has C_DocType_ID
*
* Matching Invoice MXI
* M_MatchInv 472 - DocType fixed
*
* Matching PO MXP
* M_MatchPO 473 - DocType fixed
*
* Project Issue PJI
* C_ProjectIssue 623 - DocType fixed
*
*
* @author Jorg Janke
* @version $Id: Doc.java,v 1.6 2006/07/30 00:53:33 jjanke Exp $
*/
public abstract class Doc
{
/** AD_Table_ID's of documents */
public static int[] documentsTableID = new int[] {
MInvoice.Table_ID, // C_Invoice
MAllocationHdr.Table_ID, // C_Allocation
MCash.Table_ID, // C_Cash
MBankStatement.Table_ID, // C_BankStatement
MOrder.Table_ID, // C_Order
MPayment.Table_ID, // C_Payment
MInOut.Table_ID, // M_InOut
MInventory.Table_ID, // M_Inventory
MMovement.Table_ID, // M_Movement
X_M_Production.Table_ID, // M_Production
MJournal.Table_ID, // GL_Journal
MMatchInv.Table_ID, // M_MatchInv
MMatchPO.Table_ID, // M_MatchPO
MProjectIssue.Table_ID, // C_ProjectIssue
MRequisition.Table_ID // M_Requisition
,org.eevolution.model.MHRProcess.Table_ID
};
/** Table Names of documents */
public static String[] documentsTableName = new String[] {
MInvoice.Table_Name, // C_Invoice
MAllocationHdr.Table_Name, // C_Allocation
MCash.Table_Name, // C_Cash
MBankStatement.Table_Name, // C_BankStatement
MOrder.Table_Name, // C_Order
MPayment.Table_Name, // C_Payment
MInOut.Table_Name, // M_InOut
MInventory.Table_Name, // M_Inventory
MMovement.Table_Name, // M_Movement
X_M_Production.Table_Name, // M_Production
MJournal.Table_Name, // GL_Journal
MMatchInv.Table_Name, // M_MatchInv
MMatchPO.Table_Name, // M_MatchPO
MProjectIssue.Table_Name, // C_ProjectIssue
MRequisition.Table_Name // M_Requisition
,org.eevolution.model.MHRProcess.Table_Name
};
/**************************************************************************
* Document Types
* --------------
* C_DocType.DocBaseType & AD_Reference_ID=183
* C_Invoice: ARI, ARC, ARF, API, APC
* C_Payment: ARP, APP
* C_Order: SOO, POO
* M_Transaction: MMI, MMM, MMS, MMR
* C_BankStatement: CMB
* C_Cash: CMC
* C_Allocation: CMA
* GL_Journal: GLJ
* C_ProjectIssue PJI
* M_Requisition POR
**************************************************************************/
/** AR Invoices - ARI */
public static final String DOCTYPE_ARInvoice = MDocType.DOCBASETYPE_ARInvoice;
/** AR Credit Memo */
public static final String DOCTYPE_ARCredit = "ARC";
/** AR Receipt */
public static final String DOCTYPE_ARReceipt = "ARR";
/** AR ProForma */
public static final String DOCTYPE_ARProForma = "ARF";
/** AP Invoices */
public static final String DOCTYPE_APInvoice = "API";
/** AP Credit Memo */
public static final String DOCTYPE_APCredit = "APC";
/** AP Payment */
public static final String DOCTYPE_APPayment = "APP";
/** CashManagement Bank Statement */
public static final String DOCTYPE_BankStatement = "CMB";
/** CashManagement Cash Journals */
public static final String DOCTYPE_CashJournal = "CMC";
/** CashManagement Allocations */
public static final String DOCTYPE_Allocation = "CMA";
/** Material Shipment */
public static final String DOCTYPE_MatShipment = "MMS";
/** Material Receipt */
public static final String DOCTYPE_MatReceipt = "MMR";
/** Material Inventory */
public static final String DOCTYPE_MatInventory = "MMI";
/** Material Movement */
public static final String DOCTYPE_MatMovement = "MMM";
/** Material Production */
public static final String DOCTYPE_MatProduction = "MMP";
/** Match Invoice */
public static final String DOCTYPE_MatMatchInv = "MXI";
/** Match PO */
public static final String DOCTYPE_MatMatchPO = "MXP";
/** GL Journal */
public static final String DOCTYPE_GLJournal = "GLJ";
/** Purchase Order */
public static final String DOCTYPE_POrder = "POO";
/** Sales Order */
public static final String DOCTYPE_SOrder = "SOO";
/** Project Issue */
public static final String DOCTYPE_ProjectIssue = "PJI";
/** Purchase Requisition */
public static final String DOCTYPE_PurchaseRequisition = "POR";
public static final String DOCTYPE_HRPayroll = "HRP";
// Posting Status - AD_Reference_ID=234 //
/** Document Status */
public static final String STATUS_NotPosted = "N";
/** Document Status */
public static final String STATUS_NotBalanced = "b";
/** Document Status */
public static final String STATUS_NotConvertible = "c";
/** Document Status */
public static final String STATUS_PeriodClosed = "p";
/** Document Status */
public static final String STATUS_InvalidAccount = "i";
/** Document Status */
public static final String STATUS_PostPrepared = "y";
/** Document Status */
public static final String STATUS_Posted = "Y";
/** Document Status */
public static final String STATUS_Error = "E";
/**
* Create Posting document
* @param ass accounting schema
* @param AD_Table_ID Table ID of Documents
* @param Record_ID record ID to load
* @param trxName transaction name
* @return Document or null
*/
public static Doc get (MAcctSchema[] ass, int AD_Table_ID, int Record_ID, String trxName)
{
String TableName = null;
for (int i = 0; i < documentsTableID.length; i++)
{
if (documentsTableID[i] == AD_Table_ID)
{
TableName = documentsTableName[i];
break;
}
}
if (TableName == null)
{
s_log.severe("Not found AD_Table_ID=" + AD_Table_ID);
return null;
}
//
Doc doc = null;
StringBuffer sql = new StringBuffer("SELECT * FROM ")
.append(TableName)
.append(" WHERE ").append(TableName).append("_ID=? AND Processed='Y'");
PreparedStatement pstmt = null;
try
{
pstmt = DB.prepareStatement (sql.toString(), trxName);
pstmt.setInt (1, Record_ID);
ResultSet rs = pstmt.executeQuery ();
if (rs.next ())
{
doc = get (ass, AD_Table_ID, rs, trxName);
}
else
s_log.severe("Not Found: " + TableName + "_ID=" + Record_ID);
rs.close ();
pstmt.close ();
pstmt = null;
}
catch (Exception e)
{
s_log.log (Level.SEVERE, sql.toString(), e);
}
try
{
if (pstmt != null)
pstmt.close ();
pstmt = null;
}
catch (Exception e)
{
pstmt = null;
}
return doc;
} // get
/**
* Create Posting document
* @param ass accounting schema
* @param AD_Table_ID Table ID of Documents
* @param rs ResultSet
* @param trxName transaction name
* @return Document
*/
public static Doc get (MAcctSchema[] ass, int AD_Table_ID, ResultSet rs, String trxName)
{
Doc doc = null;
if (AD_Table_ID == MInvoice.Table_ID)
doc = new Doc_Invoice (ass, rs, trxName);
else if (AD_Table_ID == MAllocationHdr.Table_ID)
doc = new Doc_Allocation (ass, rs, trxName);
else if (AD_Table_ID == MCash.Table_ID)
doc = new Doc_Cash (ass, rs, trxName);
else if (AD_Table_ID == MBankStatement.Table_ID)
doc = new Doc_Bank (ass, rs, trxName);
else if (AD_Table_ID == MOrder.Table_ID)
doc = new Doc_Order (ass, rs, trxName);
else if (AD_Table_ID == MPayment.Table_ID)
doc = new Doc_Payment (ass, rs, trxName);
else if (AD_Table_ID == MInOut.Table_ID)
doc = new Doc_InOut (ass, rs, trxName);
else if (AD_Table_ID == MInventory.Table_ID)
doc = new Doc_Inventory (ass, rs, trxName);
else if (AD_Table_ID == MMovement.Table_ID)
doc = new Doc_Movement (ass, rs, trxName);
else if (AD_Table_ID == X_M_Production.Table_ID)
doc = new Doc_Production (ass, rs, trxName);
else if (AD_Table_ID == MJournal.Table_ID)
doc = new Doc_GLJournal (ass, rs, trxName);
else if (AD_Table_ID == MMatchInv.Table_ID)
doc = new Doc_MatchInv (ass, rs, trxName);
else if (AD_Table_ID == MMatchPO.Table_ID)
doc = new Doc_MatchPO (ass, rs, trxName);
else if (AD_Table_ID == MProjectIssue.Table_ID)
doc = new Doc_ProjectIssue (ass, rs, trxName);
else if (AD_Table_ID == MRequisition.Table_ID)
doc = new Doc_Requisition (ass, rs, trxName);
if (doc == null)
s_log.log(Level.SEVERE, "Unknown AD_Table_ID=" + AD_Table_ID);
return doc;
} // get
/**
* Post Document
* @param ass accounting schemata
* @param AD_Table_ID Transaction table
* @param Record_ID Record ID of this document
* @param force force posting
* @param trxName transaction
* @return null if the document was posted or error message
*/
public static String postImmediate (MAcctSchema[] ass,
int AD_Table_ID, int Record_ID, boolean force, String trxName)
{
Doc doc = get (ass, AD_Table_ID, Record_ID, trxName);
if (doc != null)
return doc.post (force, true); // repost
return "NoDoc";
} // post
/** Static Log */
protected static CLogger s_log = CLogger.getCLogger(Doc.class);
/** Log per Document */
protected CLogger log = CLogger.getCLogger(getClass());
/**************************************************************************
* Constructor
* @param ass accounting schemata
* @param clazz Document Class
* @param rs result set
* @param defaultDocumentType default document type or null
* @param trxName trx
*/
Doc (MAcctSchema[] ass, Class clazz, ResultSet rs, String defaultDocumentType, String trxName)
{
p_Status = STATUS_Error;
m_ass = ass;
m_ctx = new Properties(m_ass[0].getCtx());
m_ctx.setProperty("#AD_Client_ID", String.valueOf(m_ass[0].getAD_Client_ID()));
String className = clazz.getName();
className = className.substring(className.lastIndexOf('.')+1);
try
{
Constructor constructor = clazz.getConstructor(new Class[]{Properties.class, ResultSet.class, String.class});
p_po = (PO)constructor.newInstance(new Object[]{m_ctx, rs, trxName});
}
catch (Exception e)
{
String msg = className + ": " + e.getLocalizedMessage();
log.severe(msg);
throw new IllegalArgumentException(msg);
}
// DocStatus
int index = p_po.get_ColumnIndex("DocStatus");
if (index != -1)
m_DocStatus = (String)p_po.get_Value(index);
// Document Type
setDocumentType (defaultDocumentType);
m_trxName = trxName;
if (m_trxName == null)
m_trxName = "Post" + m_DocumentType + p_po.get_ID();
p_po.set_TrxName(m_trxName);
// Amounts
m_Amounts[0] = Env.ZERO;
m_Amounts[1] = Env.ZERO;
m_Amounts[2] = Env.ZERO;
m_Amounts[3] = Env.ZERO;
} // Doc
/** Accounting Schema Array */
private MAcctSchema[] m_ass = null;
/** Properties */
private Properties m_ctx = null;
/** Transaction Name */
private String m_trxName = null;
/** The Document */
protected PO p_po = null;
/** Document Type */
private String m_DocumentType = null;
/** Document Status */
private String m_DocStatus = null;
/** Document No */
private String m_DocumentNo = null;
/** Description */
private String m_Description = null;
/** GL Category */
private int m_GL_Category_ID = 0;
/** GL Period */
private MPeriod m_period = null;
/** Period ID */
private int m_C_Period_ID = 0;
/** Location From */
private int m_C_LocFrom_ID = 0;
/** Location To */
private int m_C_LocTo_ID = 0;
/** Accounting Date */
private Timestamp m_DateAcct = null;
/** Document Date */
private Timestamp m_DateDoc = null;
/** Tax Included */
private boolean m_TaxIncluded = false;
/** Is (Source) Multi-Currency Document - i.e. the document has different currencies
* (if true, the document will not be source balanced) */
private boolean m_MultiCurrency = false;
/** BP Sales Region */
private int m_BP_C_SalesRegion_ID = -1;
/** B Partner */
private int m_C_BPartner_ID = -1;
/** Bank Account */
private int m_C_BankAccount_ID = -1;
/** Cach Book */
private int m_C_CashBook_ID = -1;
/** Currency */
private int m_C_Currency_ID = -1;
/** Contained Doc Lines */
protected DocLine[] p_lines;
/** Facts */
private ArrayList m_fact = null;
/** No Currency in Document Indicator (-1) */
protected static final int NO_CURRENCY = -2;
/** Actual Document Status */
protected String p_Status = null;
/** Error Message */
protected String p_Error = null;
/**
* Get Context
* @return context
*/
protected Properties getCtx()
{
return m_ctx;
} // getCtx
/**
* Get Table Name
* @return table name
*/
public String get_TableName()
{
return p_po.get_TableName();
} // get_TableName
/**
* Get Table ID
* @return table id
*/
public int get_Table_ID()
{
return p_po.get_Table_ID();
} // get_Table_ID
/**
* Get Record_ID
* @return record id
*/
public int get_ID()
{
return p_po.get_ID();
} // get_ID
/**
* Get Persistent Object
* @return po
*/
protected PO getPO()
{
return p_po;
} // getPO
/**
* Post Document.
*
* - try to lock document (Processed='Y' (AND Processing='N' AND Posted='N'))
* - if not ok - return false
* - postlogic (for all Accounting Schema)
* - create Fact lines
* - postCommit
* - commits Fact lines and Document & sets Processing = 'N'
* - if error - create Note
*
* @param force if true ignore that locked
* @param repost if true ignore that already posted
* @return null if posted error otherwise
*/
public final String post (boolean force, boolean repost)
{
if (m_DocStatus == null)
; // return "No DocStatus for DocumentNo=" + getDocumentNo();
else if (m_DocStatus.equals(DocumentEngine.STATUS_Completed)
|| m_DocStatus.equals(DocumentEngine.STATUS_Closed)
|| m_DocStatus.equals(DocumentEngine.STATUS_Voided)
|| m_DocStatus.equals(DocumentEngine.STATUS_Reversed))
;
else
return "Invalid DocStatus='" + m_DocStatus + "' for DocumentNo=" + getDocumentNo();
//
if (p_po.getAD_Client_ID() != m_ass[0].getAD_Client_ID())
{
String error = "AD_Client_ID Conflict - Document=" + p_po.getAD_Client_ID()
+ ", AcctSchema=" + m_ass[0].getAD_Client_ID();
log.severe(error);
return error;
}
// Lock Record ----
StringBuffer sql = new StringBuffer ("UPDATE ");
sql.append(get_TableName()).append( " SET Processing='Y' WHERE ")
.append(get_TableName()).append("_ID=").append(get_ID())
.append(" AND Processed='Y' AND IsActive='Y'");
if (!force)
sql.append(" AND (Processing='N' OR Processing IS NULL)");
if (!repost)
sql.append(" AND Posted='N'");
if (DB.executeUpdate(sql.toString(), null) == 1) // outside trx
log.info("Locked: " + get_TableName() + "_ID=" + get_ID());
else
{
log.log(Level.SEVERE, "Resubmit - Cannot lock " + get_TableName() + "_ID="
+ get_ID() + ", Force=" + force + ",RePost=" + repost);
if (force)
return "Cannot Lock - ReSubmit";
return "Cannot Lock - ReSubmit or RePost with Force";
}
p_Error = loadDocumentDetails();
if (p_Error != null)
return p_Error;
// Delete existing Accounting
if (repost)
{
if (isPosted() && !isPeriodOpen()) // already posted - don't delete if period closed
{
log.log(Level.SEVERE, toString() + " - Period Closed for already posed document");
unlock();
return "PeriodClosed";
}
// delete it
deleteAcct();
}
else if (isPosted())
{
log.log(Level.SEVERE, toString() + " - Document already posted");
unlock();
return "AlreadyPosted";
}
p_Status = STATUS_NotPosted;
// Create Fact per AcctSchema
m_fact = new ArrayList();
// for all Accounting Schema
boolean OK = true;
try
{
for (int i = 0; OK && i < m_ass.length; i++)
{
// if acct schema has "only" org, skip
boolean skip = false;
if (m_ass[i].getAD_OrgOnly_ID() != 0)
{
if (m_ass[i].getOnlyOrgs() == null)
m_ass[i].setOnlyOrgs(MReportTree.getChildIDs(getCtx(),
0, MAcctSchemaElement.ELEMENTTYPE_Organization,
m_ass[i].getAD_OrgOnly_ID()));
// Header Level Org
skip = m_ass[i].isSkipOrg(getAD_Org_ID());
// Line Level Org
if (p_lines != null)
{
for (int line = 0; skip && line < p_lines.length; line++)
{
skip = m_ass[i].isSkipOrg(p_lines[line].getAD_Org_ID());
if (!skip)
break;
}
}
}
if (skip)
continue;
// post
log.info("(" + i + ") " + p_po);
p_Status = postLogic (i);
if (!p_Status.equals(STATUS_Posted))
OK = false;
}
}
catch (Exception e)
{
log.log(Level.SEVERE, "", e);
p_Status = STATUS_Error;
p_Error = e.toString();
OK = false;
}
String validatorMsg = null;
// Call validator on before post
if (!p_Status.equals(STATUS_Error)) {
getPO().setDoc(this);
validatorMsg = ModelValidationEngine.get().fireDocValidate(getPO(), ModelValidator.TIMING_BEFORE_POST);
if (validatorMsg != null) {
p_Status = STATUS_Error;
p_Error = validatorMsg;
OK = false;
}
}
// commitFact
p_Status = postCommit (p_Status);
if (!p_Status.equals(STATUS_Error)) {
validatorMsg = ModelValidationEngine.get().fireDocValidate(getPO(), ModelValidator.TIMING_AFTER_POST);
if (validatorMsg != null) {
p_Status = STATUS_Error;
p_Error = validatorMsg;
OK = false;
}
}
// Create Note
if (!p_Status.equals(STATUS_Posted))
{
// Insert Note
String AD_MessageValue = "PostingError-" + p_Status;
int AD_User_ID = p_po.getUpdatedBy();
MNote note = new MNote (getCtx(), AD_MessageValue, AD_User_ID,
getAD_Client_ID(), getAD_Org_ID(), null);
note.setRecord(p_po.get_Table_ID(), p_po.get_ID());
// Reference
note.setReference(toString()); // Document
// Text
StringBuffer Text = new StringBuffer (Msg.getMsg(Env.getCtx(), AD_MessageValue));
if (p_Error != null)
Text.append(" (").append(p_Error).append(")");
String cn = getClass().getName();
Text.append(" - ").append(cn.substring(cn.lastIndexOf('.')))
.append(" (").append(getDocumentType())
.append(" - DocumentNo=").append(getDocumentNo())
.append(", DateAcct=").append(getDateAcct().toString().substring(0,10))
.append(", Amount=").append(getAmount())
.append(", Sta=").append(p_Status)
.append(" - PeriodOpen=").append(isPeriodOpen())
.append(", Balanced=").append(isBalanced());
note.setTextMsg(Text.toString());
note.save();
}
// dispose facts
for (int i = 0; i < m_fact.size(); i++)
{
Fact fact = m_fact.get(i);
if (fact != null)
fact.dispose();
}
p_lines = null;
if (p_Status.equals(STATUS_Posted))
return null;
return p_Error;
} // post
/**
* Delete Accounting
* @return number of records
*/
private int deleteAcct()
{
StringBuffer sql = new StringBuffer ("DELETE Fact_Acct WHERE AD_Table_ID=")
.append(get_Table_ID())
.append(" AND Record_ID=").append(p_po.get_ID());
int no = DB.executeUpdate(sql.toString(), getTrxName());
if (no != 0)
log.info("deleted=" + no);
return no;
} // deleteAcct
/**
* Posting logic for Accounting Schema index
* @param index Accounting Schema index
* @return posting status/error code
*/
private final String postLogic (int index)
{
log.info("(" + index + ") " + p_po);
// rejectUnbalanced
if (!m_ass[index].isSuspenseBalancing() && !isBalanced())
return STATUS_NotBalanced;
// rejectUnconvertible
if (!isConvertible(m_ass[index]))
return STATUS_NotConvertible;
// rejectPeriodClosed
if (!isPeriodOpen())
return STATUS_PeriodClosed;
// createFacts
ArrayList facts = createFacts (m_ass[index]);
if (facts == null)
return STATUS_Error;
for (int f = 0; f < facts.size(); f++)
{
Fact fact = facts.get(f);
if (fact == null)
return STATUS_Error;
m_fact.add(fact);
//
p_Status = STATUS_PostPrepared;
// check accounts
if (!fact.checkAccounts())
return STATUS_InvalidAccount;
// distribute
if (!fact.distribute())
return STATUS_Error;
// balanceSource
if (!fact.isSourceBalanced())
{
fact.balanceSource();
if (!fact.isSourceBalanced())
return STATUS_NotBalanced;
}
// balanceSegments
if (!fact.isSegmentBalanced())
{
fact.balanceSegments();
if (!fact.isSegmentBalanced())
return STATUS_NotBalanced;
}
// balanceAccounting
if (!fact.isAcctBalanced())
{
fact.balanceAccounting();
if (!fact.isAcctBalanced())
return STATUS_NotBalanced;
}
} // for all facts
return STATUS_Posted;
} // postLogic
/**
* Post Commit.
* Save Facts & Document
* @param status status
* @return Posting Status
*/
private final String postCommit (String status)
{
log.info("Sta=" + status + " DT=" + getDocumentType()
+ " ID=" + p_po.get_ID());
p_Status = status;
Trx trx = Trx.get(getTrxName(), true);
try
{
// *** Transaction Start ***
// Commit Facts
if (status.equals(STATUS_Posted))
{
for (int i = 0; i < m_fact.size(); i++)
{
Fact fact = m_fact.get(i);
if (fact == null)
;
else if (fact.save(getTrxName()))
;
else
{
log.log(Level.SEVERE, "(fact not saved) ... rolling back");
trx.rollback();
trx.close();
unlock();
return STATUS_Error;
}
}
}
// Commit Doc
if (!save(getTrxName())) // contains unlock & document status update
{
log.log(Level.SEVERE, "(doc not saved) ... rolling back");
trx.rollback();
trx.close();
unlock();
return STATUS_Error;
}
// Success
trx.commit(true);
trx.close();
trx = null;
// *** Transaction End ***
}
catch (Exception e)
{
log.log(Level.SEVERE, "... rolling back", e);
status = STATUS_Error;
try {
if (trx != null)
trx.rollback();
} catch (Exception e2) {}
try {
if (trx != null)
trx.close();
trx = null;
} catch (Exception e3) {}
unlock();
}
p_Status = status;
return status;
} // postCommit
/**
* Get Trx Name and create Transaction
* @return Trx Name
*/
protected String getTrxName()
{
return m_trxName;
} // getTrxName
/**
* Unlock Document
*/
private void unlock()
{
StringBuffer sql = new StringBuffer ("UPDATE ");
sql.append(get_TableName()).append( " SET Processing='N' WHERE ")
.append(get_TableName()).append("_ID=").append(p_po.get_ID());
DB.executeUpdate(sql.toString(), null); // outside trx
} // unlock
/**************************************************************************
* Load Document Type and GL Info.
* Set p_DocumentType and p_GL_Category_ID
* @return document type
*/
protected String getDocumentType()
{
if (m_DocumentType == null)
setDocumentType(null);
return m_DocumentType;
} // getDocumentType
/**
* Load Document Type and GL Info.
* Set p_DocumentType and p_GL_Category_ID
* @param DocumentType
*/
public void setDocumentType (String DocumentType)
{
if (DocumentType != null)
m_DocumentType = DocumentType;
// No Document Type defined
if (m_DocumentType == null && getC_DocType_ID() != 0)
{
String sql = "SELECT DocBaseType, GL_Category_ID FROM C_DocType WHERE C_DocType_ID=?";
try
{
PreparedStatement pstmt = DB.prepareStatement(sql, null);
pstmt.setInt(1, getC_DocType_ID());
ResultSet rsDT = pstmt.executeQuery();
if (rsDT.next())
{
m_DocumentType = rsDT.getString(1);
m_GL_Category_ID = rsDT.getInt(2);
}
rsDT.close();
pstmt.close();
}
catch (SQLException e)
{
log.log(Level.SEVERE, sql, e);
}
}
if (m_DocumentType == null)
{
log.log(Level.SEVERE, "No DocBaseType for C_DocType_ID="
+ getC_DocType_ID() + ", DocumentNo=" + getDocumentNo());
}
// We have a document Type, but no GL info - search for DocType
if (m_GL_Category_ID == 0)
{
String sql = "SELECT GL_Category_ID FROM C_DocType "
+ "WHERE AD_Client_ID=? AND DocBaseType=?";
try
{
PreparedStatement pstmt = DB.prepareStatement(sql, null);
pstmt.setInt(1, getAD_Client_ID());
pstmt.setString(2, m_DocumentType);
ResultSet rsDT = pstmt.executeQuery();
if (rsDT.next())
m_GL_Category_ID = rsDT.getInt(1);
rsDT.close();
pstmt.close();
}
catch (SQLException e)
{
log.log(Level.SEVERE, sql, e);
}
}
// Still no GL_Category - get Default GL Category
if (m_GL_Category_ID == 0)
{
String sql = "SELECT GL_Category_ID FROM GL_Category "
+ "WHERE AD_Client_ID=? "
+ "ORDER BY IsDefault DESC";
try
{
PreparedStatement pstmt = DB.prepareStatement(sql, null);
pstmt.setInt(1, getAD_Client_ID());
ResultSet rsDT = pstmt.executeQuery();
if (rsDT.next())
m_GL_Category_ID = rsDT.getInt(1);
rsDT.close();
pstmt.close();
}
catch (SQLException e)
{
log.log(Level.SEVERE, sql, e);
}
}
//
if (m_GL_Category_ID == 0)
log.log(Level.SEVERE, "No default GL_Category - " + toString());
if (m_DocumentType == null)
throw new IllegalStateException("Document Type not found");
} // setDocumentType
/**************************************************************************
* Is the Source Document Balanced
* @return true if (source) baanced
*/
public boolean isBalanced()
{
// Multi-Currency documents are source balanced by definition
if (isMultiCurrency())
return true;
//
boolean retValue = getBalance().signum() == 0;
if (retValue)
log.fine("Yes " + toString());
else
log.warning("NO - " + toString());
return retValue;
} // isBalanced
/**
* Is Document convertible to currency and Conversion Type
* @param acctSchema accounting schema
* @return true, if vonvertable to accounting currency
*/
public boolean isConvertible (MAcctSchema acctSchema)
{
// No Currency in document
if (getC_Currency_ID() == NO_CURRENCY)
{
log.fine("(none) - " + toString());
return true;
}
// Get All Currencies
HashSet set = new HashSet();
set.add(new Integer(getC_Currency_ID()));
for (int i = 0; p_lines != null && i < p_lines.length; i++)
{
int C_Currency_ID = p_lines[i].getC_Currency_ID();
if (C_Currency_ID != NO_CURRENCY)
set.add(new Integer(C_Currency_ID));
}
// just one and the same
if (set.size() == 1 && acctSchema.getC_Currency_ID() == getC_Currency_ID())
{
log.fine("(same) Cur=" + getC_Currency_ID() + " - " + toString());
return true;
}
boolean convertible = true;
Iterator it = set.iterator();
while (it.hasNext() && convertible)
{
int C_Currency_ID = ((Integer)it.next()).intValue();
if (C_Currency_ID != acctSchema.getC_Currency_ID())
{
BigDecimal amt = MConversionRate.getRate (C_Currency_ID, acctSchema.getC_Currency_ID(),
getDateAcct(), getC_ConversionType_ID(), getAD_Client_ID(), getAD_Org_ID());
if (amt == null)
{
convertible = false;
log.warning ("NOT from C_Currency_ID=" + C_Currency_ID
+ " to " + acctSchema.getC_Currency_ID()
+ " - " + toString());
}
else
log.fine("From C_Currency_ID=" + C_Currency_ID);
}
}
log.fine("Convertible=" + convertible + ", AcctSchema C_Currency_ID=" + acctSchema.getC_Currency_ID() + " - " + toString());
return convertible;
} // isConvertible
/**
* Calculate Period from DateAcct.
* m_C_Period_ID is set to -1 of not open to 0 if not found
*/
public void setPeriod()
{
if (m_period != null)
return;
// Period defined in GL Journal (e.g. adjustment period)
int index = p_po.get_ColumnIndex("C_Period_ID");
if (index != -1)
{
Integer ii = (Integer)p_po.get_Value(index);
if (ii != null)
m_period = MPeriod.get(getCtx(), ii.intValue());
}
if (m_period == null)
m_period = MPeriod.get(getCtx(), getDateAcct());
// Is Period Open?
if (m_period != null
&& m_period.isOpen(getDocumentType()))
m_C_Period_ID = m_period.getC_Period_ID();
else
m_C_Period_ID = -1;
//
log.fine( // + AD_Client_ID + " - "
getDateAcct() + " - " + getDocumentType() + " => " + m_C_Period_ID);
} // setC_Period_ID
/**
* Get C_Period_ID
* @return period
*/
public int getC_Period_ID()
{
if (m_period == null)
setPeriod();
return m_C_Period_ID;
} // getC_Period_ID
/**
* Is Period Open
* @return true if period is open
*/
public boolean isPeriodOpen()
{
setPeriod();
boolean open = m_C_Period_ID > 0;
if (open)
log.fine("Yes - " + toString());
else
log.warning("NO - " + toString());
return open;
} // isPeriodOpen
/*************************************************************************/
/** Amount Type - Invoice - Gross */
public static final int AMTTYPE_Gross = 0;
/** Amount Type - Invoice - Net */
public static final int AMTTYPE_Net = 1;
/** Amount Type - Invoice - Charge */
public static final int AMTTYPE_Charge = 2;
/** Source Amounts (may not all be used) */
private BigDecimal[] m_Amounts = new BigDecimal[4];
/** Quantity */
private BigDecimal m_qty = null;
/**
* Get the Amount
* (loaded in loadDocumentDetails)
*
* @param AmtType see AMTTYPE_*
* @return Amount
*/
public BigDecimal getAmount(int AmtType)
{
if (AmtType < 0 || AmtType >= m_Amounts.length)
return null;
return m_Amounts[AmtType];
} // getAmount
/**
* Set the Amount
* @param AmtType see AMTTYPE_*
* @param amt Amount
*/
public void setAmount(int AmtType, BigDecimal amt)
{
if (AmtType < 0 || AmtType >= m_Amounts.length)
return;
if (amt == null)
m_Amounts[AmtType] = Env.ZERO;
else
m_Amounts[AmtType] = amt;
} // setAmount
/**
* Get Amount with index 0
* @return Amount (primary document amount)
*/
public BigDecimal getAmount()
{
return m_Amounts[0];
} // getAmount
/**
* Set Quantity
* @param qty Quantity
*/
public void setQty (BigDecimal qty)
{
m_qty = qty;
} // setQty
/**
* Get Quantity
* @return Quantity
*/
public BigDecimal getQty()
{
if (m_qty == null)
{
int index = p_po.get_ColumnIndex("Qty");
if (index != -1)
m_qty = (BigDecimal)p_po.get_Value(index);
else
m_qty = Env.ZERO;
}
return m_qty;
} // getQty
/*************************************************************************/
/** Account Type - Invoice - Charge */
public static final int ACCTTYPE_Charge = 0;
/** Account Type - Invoice - AR */
public static final int ACCTTYPE_C_Receivable = 1;
/** Account Type - Invoice - AP */
public static final int ACCTTYPE_V_Liability = 2;
/** Account Type - Invoice - AP Service */
public static final int ACCTTYPE_V_Liability_Services = 3;
/** Account Type - Invoice - AR Service */
public static final int ACCTTYPE_C_Receivable_Services = 4;
/** Account Type - Payment - Unallocated */
public static final int ACCTTYPE_UnallocatedCash = 10;
/** Account Type - Payment - Transfer */
public static final int ACCTTYPE_BankInTransit = 11;
/** Account Type - Payment - Selection */
public static final int ACCTTYPE_PaymentSelect = 12;
/** Account Type - Payment - Prepayment */
public static final int ACCTTYPE_C_Prepayment = 13;
/** Account Type - Payment - Prepayment */
public static final int ACCTTYPE_V_Prepayment = 14;
/** Account Type - Cash - Asset */
public static final int ACCTTYPE_CashAsset = 20;
/** Account Type - Cash - Transfer */
public static final int ACCTTYPE_CashTransfer = 21;
/** Account Type - Cash - Expense */
public static final int ACCTTYPE_CashExpense = 22;
/** Account Type - Cash - Receipt */
public static final int ACCTTYPE_CashReceipt = 23;
/** Account Type - Cash - Difference */
public static final int ACCTTYPE_CashDifference = 24;
/** Account Type - Allocation - Discount Expense (AR) */
public static final int ACCTTYPE_DiscountExp = 30;
/** Account Type - Allocation - Discount Revenue (AP) */
public static final int ACCTTYPE_DiscountRev = 31;
/** Account Type - Allocation - Write Off */
public static final int ACCTTYPE_WriteOff = 32;
/** Account Type - Bank Statement - Asset */
public static final int ACCTTYPE_BankAsset = 40;
/** Account Type - Bank Statement - Interest Revenue */
public static final int ACCTTYPE_InterestRev = 41;
/** Account Type - Bank Statement - Interest Exp */
public static final int ACCTTYPE_InterestExp = 42;
/** Inventory Accounts - Differnces */
public static final int ACCTTYPE_InvDifferences = 50;
/** Inventory Accounts - NIR */
public static final int ACCTTYPE_NotInvoicedReceipts = 51;
/** Project Accounts - Assets */
public static final int ACCTTYPE_ProjectAsset = 61;
/** Project Accounts - WIP */
public static final int ACCTTYPE_ProjectWIP = 62;
/** GL Accounts - PPV Offset */
public static final int ACCTTYPE_PPVOffset = 101;
/** GL Accounts - Commitment Offset */
public static final int ACCTTYPE_CommitmentOffset = 111;
/**
* Get the Valid Combination id for Accounting Schema
* @param AcctType see ACCTTYPE_*
* @param as accounting schema
* @return C_ValidCombination_ID
*/
public int getValidCombination_ID (int AcctType, MAcctSchema as)
{
int para_1 = 0; // first parameter (second is always AcctSchema)
String sql = null;
/** Account Type - Invoice */
if (AcctType == ACCTTYPE_Charge) // see getChargeAccount in DocLine
{
int cmp = getAmount(AMTTYPE_Charge).compareTo(Env.ZERO);
if (cmp == 0)
return 0;
else if (cmp < 0)
sql = "SELECT CH_Expense_Acct FROM C_Charge_Acct WHERE C_Charge_ID=? AND C_AcctSchema_ID=?";
else
sql = "SELECT CH_Revenue_Acct FROM C_Charge_Acct WHERE C_Charge_ID=? AND C_AcctSchema_ID=?";
para_1 = getC_Charge_ID();
}
else if (AcctType == ACCTTYPE_V_Liability)
{
sql = "SELECT V_Liability_Acct FROM C_BP_Vendor_Acct WHERE C_BPartner_ID=? AND C_AcctSchema_ID=?";
para_1 = getC_BPartner_ID();
}
else if (AcctType == ACCTTYPE_V_Liability_Services)
{
sql = "SELECT V_Liability_Services_Acct FROM C_BP_Vendor_Acct WHERE C_BPartner_ID=? AND C_AcctSchema_ID=?";
para_1 = getC_BPartner_ID();
}
else if (AcctType == ACCTTYPE_C_Receivable)
{
sql = "SELECT C_Receivable_Acct FROM C_BP_Customer_Acct WHERE C_BPartner_ID=? AND C_AcctSchema_ID=?";
para_1 = getC_BPartner_ID();
}
else if (AcctType == ACCTTYPE_C_Receivable_Services)
{
sql = "SELECT C_Receivable_Services_Acct FROM C_BP_Customer_Acct WHERE C_BPartner_ID=? AND C_AcctSchema_ID=?";
para_1 = getC_BPartner_ID();
}
else if (AcctType == ACCTTYPE_V_Prepayment)
{
sql = "SELECT V_Prepayment_Acct FROM C_BP_Vendor_Acct WHERE C_BPartner_ID=? AND C_AcctSchema_ID=?";
para_1 = getC_BPartner_ID();
}
else if (AcctType == ACCTTYPE_C_Prepayment)
{
sql = "SELECT C_Prepayment_Acct FROM C_BP_Customer_Acct WHERE C_BPartner_ID=? AND C_AcctSchema_ID=?";
para_1 = getC_BPartner_ID();
}
/** Account Type - Payment */
else if (AcctType == ACCTTYPE_UnallocatedCash)
{
sql = "SELECT B_UnallocatedCash_Acct FROM C_BankAccount_Acct WHERE C_BankAccount_ID=? AND C_AcctSchema_ID=?";
para_1 = getC_BankAccount_ID();
}
else if (AcctType == ACCTTYPE_BankInTransit)
{
sql = "SELECT B_InTransit_Acct FROM C_BankAccount_Acct WHERE C_BankAccount_ID=? AND C_AcctSchema_ID=?";
para_1 = getC_BankAccount_ID();
}
else if (AcctType == ACCTTYPE_PaymentSelect)
{
sql = "SELECT B_PaymentSelect_Acct FROM C_BankAccount_Acct WHERE C_BankAccount_ID=? AND C_AcctSchema_ID=?";
para_1 = getC_BankAccount_ID();
}
/** Account Type - Allocation */
else if (AcctType == ACCTTYPE_DiscountExp)
{
sql = "SELECT a.PayDiscount_Exp_Acct FROM C_BP_Group_Acct a, C_BPartner bp "
+ "WHERE a.C_BP_Group_ID=bp.C_BP_Group_ID AND bp.C_BPartner_ID=? AND a.C_AcctSchema_ID=?";
para_1 = getC_BPartner_ID();
}
else if (AcctType == ACCTTYPE_DiscountRev)
{
sql = "SELECT PayDiscount_Rev_Acct FROM C_BP_Group_Acct a, C_BPartner bp "
+ "WHERE a.C_BP_Group_ID=bp.C_BP_Group_ID AND bp.C_BPartner_ID=? AND a.C_AcctSchema_ID=?";
para_1 = getC_BPartner_ID();
}
else if (AcctType == ACCTTYPE_WriteOff)
{
sql = "SELECT WriteOff_Acct FROM C_BP_Group_Acct a, C_BPartner bp "
+ "WHERE a.C_BP_Group_ID=bp.C_BP_Group_ID AND bp.C_BPartner_ID=? AND a.C_AcctSchema_ID=?";
para_1 = getC_BPartner_ID();
}
/** Account Type - Bank Statement */
else if (AcctType == ACCTTYPE_BankAsset)
{
sql = "SELECT B_Asset_Acct FROM C_BankAccount_Acct WHERE C_BankAccount_ID=? AND C_AcctSchema_ID=?";
para_1 = getC_BankAccount_ID();
}
else if (AcctType == ACCTTYPE_InterestRev)
{
sql = "SELECT B_InterestRev_Acct FROM C_BankAccount_Acct WHERE C_BankAccount_ID=? AND C_AcctSchema_ID=?";
para_1 = getC_BankAccount_ID();
}
else if (AcctType == ACCTTYPE_InterestExp)
{
sql = "SELECT B_InterestExp_Acct FROM C_BankAccount_Acct WHERE C_BankAccount_ID=? AND C_AcctSchema_ID=?";
para_1 = getC_BankAccount_ID();
}
/** Account Type - Cash */
else if (AcctType == ACCTTYPE_CashAsset)
{
sql = "SELECT CB_Asset_Acct FROM C_CashBook_Acct WHERE C_CashBook_ID=? AND C_AcctSchema_ID=?";
para_1 = getC_CashBook_ID();
}
else if (AcctType == ACCTTYPE_CashTransfer)
{
sql = "SELECT CB_CashTransfer_Acct FROM C_CashBook_Acct WHERE C_CashBook_ID=? AND C_AcctSchema_ID=?";
para_1 = getC_CashBook_ID();
}
else if (AcctType == ACCTTYPE_CashExpense)
{
sql = "SELECT CB_Expense_Acct FROM C_CashBook_Acct WHERE C_CashBook_ID=? AND C_AcctSchema_ID=?";
para_1 = getC_CashBook_ID();
}
else if (AcctType == ACCTTYPE_CashReceipt)
{
sql = "SELECT CB_Receipt_Acct FROM C_CashBook_Acct WHERE C_CashBook_ID=? AND C_AcctSchema_ID=?";
para_1 = getC_CashBook_ID();
}
else if (AcctType == ACCTTYPE_CashDifference)
{
sql = "SELECT CB_Differences_Acct FROM C_CashBook_Acct WHERE C_CashBook_ID=? AND C_AcctSchema_ID=?";
para_1 = getC_CashBook_ID();
}
/** Inventory Accounts */
else if (AcctType == ACCTTYPE_InvDifferences)
{
sql = "SELECT W_Differences_Acct FROM M_Warehouse_Acct WHERE M_Warehouse_ID=? AND C_AcctSchema_ID=?";
// "SELECT W_Inventory_Acct, W_Revaluation_Acct, W_InvActualAdjust_Acct FROM M_Warehouse_Acct WHERE M_Warehouse_ID=? AND C_AcctSchema_ID=?";
para_1 = getM_Warehouse_ID();
}
else if (AcctType == ACCTTYPE_NotInvoicedReceipts)
{
sql = "SELECT NotInvoicedReceipts_Acct FROM C_BP_Group_Acct a, C_BPartner bp "
+ "WHERE a.C_BP_Group_ID=bp.C_BP_Group_ID AND bp.C_BPartner_ID=? AND a.C_AcctSchema_ID=?";
para_1 = getC_BPartner_ID();
}
/** Project Accounts */
else if (AcctType == ACCTTYPE_ProjectAsset)
{
sql = "SELECT PJ_Asset_Acct FROM C_Project_Acct WHERE C_Project_ID=? AND C_AcctSchema_ID=?";
para_1 = getC_Project_ID();
}
else if (AcctType == ACCTTYPE_ProjectWIP)
{
sql = "SELECT PJ_WIP_Acct FROM C_Project_Acct WHERE C_Project_ID=? AND C_AcctSchema_ID=?";
para_1 = getC_Project_ID();
}
/** GL Accounts */
else if (AcctType == ACCTTYPE_PPVOffset)
{
sql = "SELECT PPVOffset_Acct FROM C_AcctSchema_GL WHERE C_AcctSchema_ID=?";
para_1 = -1;
}
else if (AcctType == ACCTTYPE_CommitmentOffset)
{
sql = "SELECT CommitmentOffset_Acct FROM C_AcctSchema_GL WHERE C_AcctSchema_ID=?";
para_1 = -1;
}
else
{
log.severe ("Not found AcctType=" + AcctType);
return 0;
}
// Do we have sql & Parameter
if (sql == null || para_1 == 0)
{
log.severe ("No Parameter for AcctType=" + AcctType + " - SQL=" + sql);
return 0;
}
// Get Acct
int Account_ID = 0;
try
{
PreparedStatement pstmt = DB.prepareStatement(sql, null);
if (para_1 == -1) // GL Accounts
pstmt.setInt (1, as.getC_AcctSchema_ID());
else
{
pstmt.setInt (1, para_1);
pstmt.setInt (2, as.getC_AcctSchema_ID());
}
ResultSet rs = pstmt.executeQuery();
if (rs.next())
Account_ID = rs.getInt(1);
rs.close();
pstmt.close();
}
catch (SQLException e)
{
log.log(Level.SEVERE, "AcctType=" + AcctType + " - SQL=" + sql, e);
return 0;
}
// No account
if (Account_ID == 0)
{
log.severe ("NO account Type="
+ AcctType + ", Record=" + p_po.get_ID());
return 0;
}
return Account_ID;
} // getAccount_ID
/**
* Get the account for Accounting Schema
* @param AcctType see ACCTTYPE_*
* @param as accounting schema
* @return Account
*/
public final MAccount getAccount (int AcctType, MAcctSchema as)
{
int C_ValidCombination_ID = getValidCombination_ID(AcctType, as);
if (C_ValidCombination_ID == 0)
return null;
// Return Account
MAccount acct = MAccount.get (as.getCtx(), C_ValidCombination_ID);
return acct;
} // getAccount
/**************************************************************************
* Save to Disk - set posted flag
* @param trxName transaction name
* @return true if saved
*/
private final boolean save (String trxName)
{
log.fine(toString() + "->" + p_Status);
StringBuffer sql = new StringBuffer("UPDATE ");
sql.append(get_TableName()).append(" SET Posted='").append(p_Status)
.append("',Processing='N' ")
.append("WHERE ")
.append(get_TableName()).append("_ID=").append(p_po.get_ID());
int no = DB.executeUpdate(sql.toString(), trxName);
return no == 1;
} // save
/**
* Get DocLine with ID
* @param Record_ID Record ID
* @return DocLine
*/
public DocLine getDocLine (int Record_ID)
{
if (p_lines == null || p_lines.length == 0 || Record_ID == 0)
return null;
for (int i = 0; i < p_lines.length; i++)
{
if (p_lines[i].get_ID() == Record_ID)
return p_lines[i];
}
return null;
} // getDocLine
/**
* String Representation
* @return String
*/
public String toString()
{
return p_po.toString();
} // toString
/**
* Get AD_Client_ID
* @return client
*/
public int getAD_Client_ID()
{
return p_po.getAD_Client_ID();
} // getAD_Client_ID
/**
* Get AD_Org_ID
* @return org
*/
public int getAD_Org_ID()
{
return p_po.getAD_Org_ID();
} // getAD_Org_ID
/**
* Get Document No
* @return document No
*/
public String getDocumentNo()
{
if (m_DocumentNo != null)
return m_DocumentNo;
int index = p_po.get_ColumnIndex("DocumentNo");
if (index == -1)
index = p_po.get_ColumnIndex("Name");
if (index == -1)
throw new UnsupportedOperationException("No DocumentNo");
m_DocumentNo = (String)p_po.get_Value(index);
return m_DocumentNo;
} // getDocumentNo
/**
* Get Description
* @return Description
*/
public String getDescription()
{
if (m_Description == null)
{
int index = p_po.get_ColumnIndex("Description");
if (index != -1)
m_Description = (String)p_po.get_Value(index);
else
m_Description = "";
}
return m_Description;
} // getDescription
/**
* Get C_Currency_ID
* @return currency
*/
public int getC_Currency_ID()
{
if (m_C_Currency_ID == -1)
{
int index = p_po.get_ColumnIndex("C_Currency_ID");
if (index != -1)
{
Integer ii = (Integer)p_po.get_Value(index);
if (ii != null)
m_C_Currency_ID = ii.intValue();
}
if (m_C_Currency_ID == -1)
m_C_Currency_ID = NO_CURRENCY;
}
return m_C_Currency_ID;
} // getC_Currency_ID
/**
* Set C_Currency_ID
* @param C_Currency_ID id
*/
public void setC_Currency_ID (int C_Currency_ID)
{
m_C_Currency_ID = C_Currency_ID;
} // setC_Currency_ID
/**
* Is Multi Currency
* @return mc
*/
public boolean isMultiCurrency()
{
return m_MultiCurrency;
} // isMultiCurrency
/**
* Set Multi Currency
* @param mc multi currency
*/
public void setIsMultiCurrency (boolean mc)
{
m_MultiCurrency = mc;
} // setIsMultiCurrency
/**
* Is Tax Included
* @return tax incl
*/
public boolean isTaxIncluded()
{
return m_TaxIncluded;
} // isTaxIncluded
/**
* Set Tax Includedy
* @param ti Tax Included
*/
public void setIsTaxIncluded (boolean ti)
{
m_TaxIncluded = ti;
} // setIsTaxIncluded
/**
* Get C_ConversionType_ID
* @return ConversionType
*/
public int getC_ConversionType_ID()
{
int index = p_po.get_ColumnIndex("C_ConversionType_ID");
if (index != -1)
{
Integer ii = (Integer)p_po.get_Value(index);
if (ii != null)
return ii.intValue();
}
return 0;
} // getC_ConversionType_ID
/**
* Get GL_Category_ID
* @return categoory
*/
public int getGL_Category_ID()
{
return m_GL_Category_ID;
} // getGL_Category_ID
/**
* Get GL_Category_ID
* @return categoory
*/
public int getGL_Budget_ID()
{
int index = p_po.get_ColumnIndex("GL_Budget_ID");
if (index != -1)
{
Integer ii = (Integer)p_po.get_Value(index);
if (ii != null)
return ii.intValue();
}
return 0;
} // getGL_Budget_ID
/**
* Get Accounting Date
* @return currency
*/
public Timestamp getDateAcct()
{
if (m_DateAcct != null)
return m_DateAcct;
int index = p_po.get_ColumnIndex("DateAcct");
if (index != -1)
{
m_DateAcct = (Timestamp)p_po.get_Value(index);
if (m_DateAcct != null)
return m_DateAcct;
}
throw new IllegalStateException("No DateAcct");
} // getDateAcct
/**
* Set Date Acct
* @param da accounting date
*/
public void setDateAcct (Timestamp da)
{
m_DateAcct = da;
} // setDateAcct
/**
* Get Document Date
* @return currency
*/
public Timestamp getDateDoc()
{
if (m_DateDoc != null)
return m_DateDoc;
int index = p_po.get_ColumnIndex("DateDoc");
if (index == -1)
index = p_po.get_ColumnIndex("MovementDate");
if (index != -1)
{
m_DateDoc = (Timestamp)p_po.get_Value(index);
if (m_DateDoc != null)
return m_DateDoc;
}
throw new IllegalStateException("No DateDoc");
} // getDateDoc
/**
* Set Date Doc
* @param dd document date
*/
public void setDateDoc (Timestamp dd)
{
m_DateDoc = dd;
} // setDateDoc
/**
* Is Document Posted
* @return true if posted
*/
public boolean isPosted()
{
int index = p_po.get_ColumnIndex("Posted");
if (index != -1)
{
Object posted = p_po.get_Value(index);
if (posted instanceof Boolean)
return ((Boolean)posted).booleanValue();
if (posted instanceof String)
return "Y".equals(posted);
}
throw new IllegalStateException("No Posted");
} // isPosted
/**
* Is Sales Trx
* @return true if posted
*/
public boolean isSOTrx()
{
int index = p_po.get_ColumnIndex("IsSOTrx");
if (index == -1)
index = p_po.get_ColumnIndex("IsReceipt");
if (index != -1)
{
Object posted = p_po.get_Value(index);
if (posted instanceof Boolean)
return ((Boolean)posted).booleanValue();
if (posted instanceof String)
return "Y".equals(posted);
}
return false;
} // isSOTrx
/**
* Get C_DocType_ID
* @return DocType
*/
public int getC_DocType_ID()
{
int index = p_po.get_ColumnIndex("C_DocType_ID");
if (index != -1)
{
Integer ii = (Integer)p_po.get_Value(index);
// DocType does not exist - get DocTypeTarget
if (ii != null && ii.intValue() == 0)
{
index = p_po.get_ColumnIndex("C_DocTypeTarget_ID");
if (index != -1)
ii = (Integer)p_po.get_Value(index);
}
if (ii != null)
return ii.intValue();
}
return 0;
} // getC_DocType_ID
/**
* Get header level C_Charge_ID
* @return Charge
*/
public int getC_Charge_ID()
{
int index = p_po.get_ColumnIndex("C_Charge_ID");
if (index != -1)
{
Integer ii = (Integer)p_po.get_Value(index);
if (ii != null)
return ii.intValue();
}
return 0;
} // getC_Charge_ID
/**
* Get SalesRep_ID
* @return SalesRep
*/
public int getSalesRep_ID()
{
int index = p_po.get_ColumnIndex("SalesRep_ID");
if (index != -1)
{
Integer ii = (Integer)p_po.get_Value(index);
if (ii != null)
return ii.intValue();
}
return 0;
} // getSalesRep_ID
/**
* Get C_BankAccount_ID
* @return BankAccount
*/
public int getC_BankAccount_ID()
{
if (m_C_BankAccount_ID == -1)
{
int index = p_po.get_ColumnIndex("C_BankAccount_ID");
if (index != -1)
{
Integer ii = (Integer)p_po.get_Value(index);
if (ii != null)
m_C_BankAccount_ID = ii.intValue();
}
if (m_C_BankAccount_ID == -1)
m_C_BankAccount_ID = 0;
}
return m_C_BankAccount_ID;
} // getC_BankAccount_ID
/**
* Set C_BankAccount_ID
* @param C_BankAccount_ID bank acct
*/
public void setC_BankAccount_ID (int C_BankAccount_ID)
{
m_C_BankAccount_ID = C_BankAccount_ID;
} // setC_BankAccount_ID
/**
* Get C_CashBook_ID
* @return CashBook
*/
public int getC_CashBook_ID()
{
if (m_C_CashBook_ID == -1)
{
int index = p_po.get_ColumnIndex("C_CashBook_ID");
if (index != -1)
{
Integer ii = (Integer)p_po.get_Value(index);
if (ii != null)
m_C_CashBook_ID = ii.intValue();
}
if (m_C_CashBook_ID == -1)
m_C_CashBook_ID = 0;
}
return m_C_CashBook_ID;
} // getC_CashBook_ID
/**
* Set C_CashBook_ID
* @param C_CashBook_ID cash book
*/
public void setC_CashBook_ID (int C_CashBook_ID)
{
m_C_CashBook_ID = C_CashBook_ID;
} // setC_CashBook_ID
/**
* Get M_Warehouse_ID
* @return Warehouse
*/
public int getM_Warehouse_ID()
{
int index = p_po.get_ColumnIndex("M_Warehouse_ID");
if (index != -1)
{
Integer ii = (Integer)p_po.get_Value(index);
if (ii != null)
return ii.intValue();
}
return 0;
} // getM_Warehouse_ID
/**
* Get C_BPartner_ID
* @return BPartner
*/
public int getC_BPartner_ID()
{
if (m_C_BPartner_ID == -1)
{
int index = p_po.get_ColumnIndex("C_BPartner_ID");
if (index != -1)
{
Integer ii = (Integer)p_po.get_Value(index);
if (ii != null)
m_C_BPartner_ID = ii.intValue();
}
if (m_C_BPartner_ID == -1)
m_C_BPartner_ID = 0;
}
return m_C_BPartner_ID;
} // getC_BPartner_ID
/**
* Set C_BPartner_ID
* @param C_BPartner_ID bp
*/
public void setC_BPartner_ID (int C_BPartner_ID)
{
m_C_BPartner_ID = C_BPartner_ID;
} // setC_BPartner_ID
/**
* Get C_BPartner_Location_ID
* @return BPartner Location
*/
public int getC_BPartner_Location_ID()
{
int index = p_po.get_ColumnIndex("C_BPartner_Location_ID");
if (index != -1)
{
Integer ii = (Integer)p_po.get_Value(index);
if (ii != null)
return ii.intValue();
}
return 0;
} // getC_BPartner_Location_ID
/**
* Get C_Project_ID
* @return Project
*/
public int getC_Project_ID()
{
int index = p_po.get_ColumnIndex("C_Project_ID");
if (index != -1)
{
Integer ii = (Integer)p_po.get_Value(index);
if (ii != null)
return ii.intValue();
}
return 0;
} // getC_Project_ID
/**
* Get C_SalesRegion_ID
* @return Sales Region
*/
public int getC_SalesRegion_ID()
{
int index = p_po.get_ColumnIndex("C_SalesRegion_ID");
if (index != -1)
{
Integer ii = (Integer)p_po.get_Value(index);
if (ii != null)
return ii.intValue();
}
return 0;
} // getC_SalesRegion_ID
/**
* Get C_SalesRegion_ID
* @return Sales Region
*/
public int getBP_C_SalesRegion_ID()
{
if (m_BP_C_SalesRegion_ID == -1)
{
int index = p_po.get_ColumnIndex("C_SalesRegion_ID");
if (index != -1)
{
Integer ii = (Integer)p_po.get_Value(index);
if (ii != null)
m_BP_C_SalesRegion_ID = ii.intValue();
}
if (m_BP_C_SalesRegion_ID == -1)
m_BP_C_SalesRegion_ID = 0;
}
return m_BP_C_SalesRegion_ID;
} // getBP_C_SalesRegion_ID
/**
* Set C_SalesRegion_ID
* @param C_SalesRegion_ID id
*/
public void setBP_C_SalesRegion_ID (int C_SalesRegion_ID)
{
m_BP_C_SalesRegion_ID = C_SalesRegion_ID;
} // setBP_C_SalesRegion_ID
/**
* Get C_Activity_ID
* @return Activity
*/
public int getC_Activity_ID()
{
int index = p_po.get_ColumnIndex("C_Activity_ID");
if (index != -1)
{
Integer ii = (Integer)p_po.get_Value(index);
if (ii != null)
return ii.intValue();
}
return 0;
} // getC_Activity_ID
/**
* Get C_Campaign_ID
* @return Campaign
*/
public int getC_Campaign_ID()
{
int index = p_po.get_ColumnIndex("C_Campaign_ID");
if (index != -1)
{
Integer ii = (Integer)p_po.get_Value(index);
if (ii != null)
return ii.intValue();
}
return 0;
} // getC_Campaign_ID
/**
* Get M_Product_ID
* @return Product
*/
public int getM_Product_ID()
{
int index = p_po.get_ColumnIndex("M_Product_ID");
if (index != -1)
{
Integer ii = (Integer)p_po.get_Value(index);
if (ii != null)
return ii.intValue();
}
return 0;
} // getM_Product_ID
/**
* Get AD_OrgTrx_ID
* @return Trx Org
*/
public int getAD_OrgTrx_ID()
{
int index = p_po.get_ColumnIndex("AD_OrgTrx_ID");
if (index != -1)
{
Integer ii = (Integer)p_po.get_Value(index);
if (ii != null)
return ii.intValue();
}
return 0;
} // getAD_OrgTrx_ID
/**
* Get C_LocFrom_ID
* @return loc from
*/
public int getC_LocFrom_ID()
{
return m_C_LocFrom_ID;
} // getC_LocFrom_ID
/**
* Set C_LocFrom_ID
* @param C_LocFrom_ID loc from
*/
public void setC_LocFrom_ID(int C_LocFrom_ID)
{
m_C_LocFrom_ID = C_LocFrom_ID;
} // setC_LocFrom_ID
/**
* Get C_LocTo_ID
* @return loc to
*/
public int getC_LocTo_ID()
{
return m_C_LocTo_ID;
} // getC_LocTo_ID
/**
* Set C_LocTo_ID
* @param C_LocTo_ID loc to
*/
public void setC_LocTo_ID(int C_LocTo_ID)
{
m_C_LocTo_ID = C_LocTo_ID;
} // setC_LocTo_ID
/**
* Get User1_ID
* @return Campaign
*/
public int getUser1_ID()
{
int index = p_po.get_ColumnIndex("User1_ID");
if (index != -1)
{
Integer ii = (Integer)p_po.get_Value(index);
if (ii != null)
return ii.intValue();
}
return 0;
} // getUser1_ID
/**
* Get User2_ID
* @return Campaign
*/
public int getUser2_ID()
{
int index = p_po.get_ColumnIndex("User2_ID");
if (index != -1)
{
Integer ii = (Integer)p_po.get_Value(index);
if (ii != null)
return ii.intValue();
}
return 0;
} // getUser2_ID
/**
* Get User Defined value
* @return User defined
*/
public int getValue (String ColumnName)
{
int index = p_po.get_ColumnIndex(ColumnName);
if (index != -1)
{
Integer ii = (Integer)p_po.get_Value(index);
if (ii != null)
return ii.intValue();
}
return 0;
} // getValue
/*************************************************************************/
// To be overwritten by Subclasses
/**
* Load Document Details
* @return error message or null
*/
protected abstract String loadDocumentDetails ();
/**
* Get Source Currency Balance - subtracts line (and tax) amounts from total - no rounding
* @return positive amount, if total header is bigger than lines
*/
public abstract BigDecimal getBalance();
/**
* Create Facts (the accounting logic)
* @param as accounting schema
* @return Facts
*/
public abstract ArrayList createFacts (MAcctSchema as);
/**
* Get Facts (the accounting logic)
* @return Facts
*/
public ArrayList getFacts() {
return m_fact;
}
} // Doc