org.compiere.report
Class MReportColumn

java.lang.Object
  org.compiere.framework.PO
      org.compiere.model.X_PA_ReportColumn
          org.compiere.report.MReportColumn

All Implemented Interfaces:

Serializable, Cloneable, Comparator<PO>, Evaluatee

public class MReportColumn
extends X_PA_ReportColumn

Report Column Model

Version:

$Id: MReportColumn.java,v 1.3 2006/08/03 22:16:52 jjanke Exp $

Author:

Jorg Janke

See Also:

Serialized Form

Field Summary

Fields inherited from class org.compiere.model.X_PA_ReportColumn

accessLevel, AMOUNTTYPE_AD_Reference_ID, AMOUNTTYPE_PeriodBalance, AMOUNTTYPE_PeriodCreditOnly, AMOUNTTYPE_PeriodDebitOnly, AMOUNTTYPE_PeriodQuantity, AMOUNTTYPE_TotalBalance, AMOUNTTYPE_TotalCreditOnly, AMOUNTTYPE_TotalDebitOnly, AMOUNTTYPE_TotalQuantity, AMOUNTTYPE_YearBalance, AMOUNTTYPE_YearCreditOnly, AMOUNTTYPE_YearDebitOnly, AMOUNTTYPE_YearQuantity, CALCULATIONTYPE_AD_Reference_ID, CALCULATIONTYPE_AddOp1PlusOp2, CALCULATIONTYPE_AddRangeOp1ToOp2, CALCULATIONTYPE_PercentageOp1OfOp2, CALCULATIONTYPE_SubtractOp1_Op2, COLUMNTYPE_AD_Reference_ID, COLUMNTYPE_Calculation, COLUMNTYPE_RelativePeriod, COLUMNTYPE_SegmentValue, CURRENCYTYPE_AccountingCurrency, CURRENCYTYPE_AD_Reference_ID, CURRENCYTYPE_SourceCurrency, ELEMENTTYPE_Account, ELEMENTTYPE_Activity, ELEMENTTYPE_AD_Reference_ID, ELEMENTTYPE_BPartner, ELEMENTTYPE_Campaign, ELEMENTTYPE_LocationFrom, ELEMENTTYPE_LocationTo, ELEMENTTYPE_Organization, ELEMENTTYPE_OrgTrx, ELEMENTTYPE_Product, ELEMENTTYPE_Project, ELEMENTTYPE_SalesRegion, ELEMENTTYPE_SubAccount, ELEMENTTYPE_UserElement1, ELEMENTTYPE_UserElement2, ELEMENTTYPE_UserList1, ELEMENTTYPE_UserList2, Model, OPER_1_ID_AD_Reference_ID, OPER_2_ID_AD_Reference_ID, ORG_ID_AD_Reference_ID, POSTINGTYPE_Actual, POSTINGTYPE_AD_Reference_ID, POSTINGTYPE_Budget, POSTINGTYPE_Commitment, POSTINGTYPE_Reservation, POSTINGTYPE_Statistical, Table_ID, Table_Name, updatedMS

Fields inherited from class org.compiere.framework.PO

ACCESSLEVEL_ALL, ACCESSLEVEL_CLIENT, ACCESSLEVEL_CLIENTORG, ACCESSLEVEL_ORG, ACCESSLEVEL_SYSTEM, ACCESSLEVEL_SYSTEMCLIENT, ENTITYTYPE_Dictionary, ENTITYTYPE_UserMaintained, I_ZERO, log, p_changeVO, p_info, XML_ATTRIBUTE_AD_Table_ID, XML_ATTRIBUTE_Record_ID

Constructor Summary

MReportColumn(Ctx ctx, int PA_ReportColumn_ID, String trxName)
Constructor

MReportColumn(Ctx ctx, ResultSet rs, String trxName)
Constructor

Method Summary

protected boolean	beforeSave(boolean newRecord) Before Save
static MReportColumn	copy(Ctx ctx, int AD_Client_ID, int AD_Org_ID, int PA_ReportColumnSet_ID, MReportColumn source, String trxName) Copy
String	getCalculationType() Get Calculation Type
String	getElementType() Get Element Type
BigDecimal	getRelativePeriod() Get Relative Period
int	getRelativePeriodAsInt() Get Relative Period As Int
String	getSelectClause(boolean withSum) Get Column SQL Select Clause.
String	getWhereClause(int PA_Hierarchy_ID) Get Segment Value Where Clause
boolean	isCalculationTypeAdd() Calculation Type Add
boolean	isCalculationTypePercent() Calculation Type Percent
boolean	isCalculationTypeRange() Calculation Type Range
boolean	isCalculationTypeSubtract() Calculation Type Subtract
boolean	isColumnTypeCalculation() Column Type Calculation
boolean	isColumnTypeRelativePeriod() Column Type Relative Period
boolean	isColumnTypeSegmentValue() Column Type Segment Value
boolean	isPeriod() Is it Period Info ?
boolean	isTotal() Is it Total Info ?
boolean	isYear() Is it Year Info ?
String	toString() Get String Representation

Methods inherited from class org.compiere.model.X_PA_ReportColumn

get_AccessLevel, getAmountType, getC_Activity_ID, getC_BPartner_ID, getC_Campaign_ID, getC_Currency_ID, getC_ElementValue_ID, getC_Location_ID, getC_Project_ID, getC_SalesRegion_ID, getColumnType, getCurrencyType, getDescription, getGL_Budget_ID, getKeyNamePair, getM_Product_ID, getName, getOper_1_ID, getOper_2_ID, getOrg_ID, getPA_ReportColumn_ID, getPA_ReportColumnSet_ID, getPostingType, getSeqNo, initPO, isAdhocConversion, isAmountTypeValid, isCalculationTypeValid, isColumnTypeValid, isCurrencyTypeValid, isElementTypeValid, isPostingTypeValid, isPrinted, setAmountType, setC_Activity_ID, setC_BPartner_ID, setC_Campaign_ID, setC_Currency_ID, setC_ElementValue_ID, setC_Location_ID, setC_Project_ID, setC_SalesRegion_ID, setCalculationType, setColumnType, setCurrencyType, setDescription, setElementType, setGL_Budget_ID, setIsAdhocConversion, setIsPrinted, setM_Product_ID, setName, setOper_1_ID, setOper_2_ID, setOrg_ID, setPA_ReportColumn_ID, setPA_ReportColumnSet_ID, setPostingType, setRelativePeriod, setSeqNo

Methods inherited from class org.compiere.framework.PO

addAttachment, addAttachment, addError, afterDelete, afterSave, beforeDelete, compare, convertToBigDecimal, convertToBoolean, convertToInt, convertToTimestamp, copy, copyValues, copyValues, createAttachment, delete_Accounting, delete, delete, dump, dump, equals, get_ChangeVO, get_ColumnCount, get_ColumnDescription, get_ColumnDisplayType, get_ColumnIndex, get_ColumnLabel, get_ColumnLookup, get_ColumnName, get_DisplayValue, get_EntityType, get_HashMap, get_ID, get_IDOld, get_Info, get_KeyColumns, get_Logger, get_Table_ID, get_Table_ID, get_TableName, get_Translation, get_TrxName, get_Value, get_Value, get_ValueAsInt, get_ValueAsInt, get_ValueAsString, get_ValueDifference, get_ValueDifference, get_ValueOfColumn, get_ValueOld, get_ValueOld, get_ValueOldAsInt, get_ValuesAsString, get_WhereClause, get_xmlDocument, get_xmlString, get_xmlString, getAD_Client_ID, getAD_Org_ID, getAllIDs, getAttachment, getAttachment, getAttachmentData, getCreated, getCreatedBy, getCtx, getFindParameter, getPdfAttachment, getUpdated, getUpdatedBy, getVO, hashCode, insert_Accounting, is_Changed, is_KeyColumn, is_new, is_ValueChanged, is_ValueChanged, isActive, isAttachment, isColumnMandatory, isColumnUpdateable, isMandatoryOK, isPdfAttachment, load, load, load, load, loadComplete, loadDefaults, loadSpecial, lock, save, save, saveNew_getID, saveNewInsertSQL, saveNewSpecial, saveUpdate, set_ChangeVO, set_ColumnUpdateable, set_CustomColumn, set_TrxName, set_Value, set_Value, set_ValueE, set_ValueNoCheck, set_ValueNoCheckE, set_ValueOfColumn, set_ValueString, setAD_Client_ID, setAD_Org_ID, setClientOrg, setClientOrg, setContext, setCtx, setDocWorkflowMgr, setIsActive, setStandardDefaults, setUpdateable, setUpdatedBy, toStringX, unlock, update

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Constructor Detail

MReportColumn

public MReportColumn(Ctx ctx,
                     int PA_ReportColumn_ID,
                     String trxName)

Constructor

Parameters:

ctx - context

PA_ReportColumn_ID - id

trxName - transaction

MReportColumn

public MReportColumn(Ctx ctx,
                     ResultSet rs,
                     String trxName)

Constructor

Parameters:

ctx - context

rs - ResultSet to load from

trxName - transaction

Method Detail

copy

public static MReportColumn copy(Ctx ctx,
                                 int AD_Client_ID,
                                 int AD_Org_ID,
                                 int PA_ReportColumnSet_ID,
                                 MReportColumn source,
                                 String trxName)

Copy

Parameters:

ctx - context

AD_Client_ID - parent

AD_Org_ID - parent

PA_ReportColumnSet_ID - parent

source - copy source

trxName - transaction

Returns:

Report Column

getSelectClause

public String getSelectClause(boolean withSum)

Get Column SQL Select Clause.

Parameters:

withSum - with SUM() function

Returns:

select clause - AmtAcctCR+AmtAcctDR/etc or "null" if not defined

isPeriod

public boolean isPeriod()

Is it Period Info ?

Returns:

true if Period Amount Type

isYear

public boolean isYear()

Is it Year Info ?

Returns:

true if Year Amount Type

isTotal

public boolean isTotal()

Is it Total Info ?

Returns:

true if Year Amount Type

getWhereClause

public String getWhereClause(int PA_Hierarchy_ID)

Get Segment Value Where Clause

Parameters:

PA_Hierarchy_ID - hierarchy

Returns:

where clause

toString

public String toString()

Get String Representation

Overrides:

toString in class X_PA_ReportColumn

Returns:

String Representation

isCalculationTypeRange

public boolean isCalculationTypeRange()

Calculation Type Range

Returns:

true if range

isCalculationTypeAdd

public boolean isCalculationTypeAdd()

Calculation Type Add

Returns:

true id add

isCalculationTypeSubtract

public boolean isCalculationTypeSubtract()

Calculation Type Subtract

Returns:

true if subtract

isCalculationTypePercent

public boolean isCalculationTypePercent()

Calculation Type Percent

Returns:

true if percent

isColumnTypeCalculation

public boolean isColumnTypeCalculation()

Column Type Calculation

Returns:

true if calculation

isColumnTypeRelativePeriod

public boolean isColumnTypeRelativePeriod()

Column Type Relative Period

Returns:

true if relative period

isColumnTypeSegmentValue

public boolean isColumnTypeSegmentValue()

Column Type Segment Value

Returns:

true if segment value

getRelativePeriodAsInt

public int getRelativePeriodAsInt()

Get Relative Period As Int

Returns:

relative period

getRelativePeriod

public BigDecimal getRelativePeriod()

Get Relative Period

Overrides:

getRelativePeriod in class X_PA_ReportColumn

Returns:

relative period

getElementType

public String getElementType()

Get Element Type

Overrides:

getElementType in class X_PA_ReportColumn

Returns:

Element Type (account or user defined)

getCalculationType

public String getCalculationType()

Get Calculation Type

Overrides:

getCalculationType in class X_PA_ReportColumn

Returns:

Calculation

beforeSave

protected boolean beforeSave(boolean newRecord)

Before Save

Overrides:

beforeSave in class PO

Parameters:

newRecord - new

Returns:

true