org.compiere.report
Class MReportColumn

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

All Implemented Interfaces:

Serializable, Comparator, I_PA_ReportColumn, I_Persistent, 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

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_Combination, ELEMENTTYPE_LocationFrom, ELEMENTTYPE_LocationTo, ELEMENTTYPE_Organization, ELEMENTTYPE_OrgTrx, ELEMENTTYPE_Product, ELEMENTTYPE_Project, ELEMENTTYPE_SalesRegion, ELEMENTTYPE_SubAccount, ELEMENTTYPE_UserElement1, ELEMENTTYPE_UserElement2, ELEMENTTYPE_UserList1, ELEMENTTYPE_UserList2, 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

Fields inherited from class org.compiere.model.PO

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

Fields inherited from interface org.compiere.model.I_PA_ReportColumn

accessLevel, COLUMNNAME_AmountType, COLUMNNAME_C_Activity_ID, COLUMNNAME_C_BPartner_ID, COLUMNNAME_C_Campaign_ID, COLUMNNAME_C_Currency_ID, COLUMNNAME_C_ElementValue_ID, COLUMNNAME_C_Location_ID, COLUMNNAME_C_Project_ID, COLUMNNAME_C_SalesRegion_ID, COLUMNNAME_CalculationType, COLUMNNAME_ColumnType, COLUMNNAME_CurrencyType, COLUMNNAME_Description, COLUMNNAME_ElementType, COLUMNNAME_GL_Budget_ID, COLUMNNAME_IsAdhocConversion, COLUMNNAME_IsIncludeNullsActivity, COLUMNNAME_IsIncludeNullsBPartner, COLUMNNAME_IsIncludeNullsCampaign, COLUMNNAME_IsIncludeNullsElementValue, COLUMNNAME_IsIncludeNullsLocation, COLUMNNAME_IsIncludeNullsOrg, COLUMNNAME_IsIncludeNullsProduct, COLUMNNAME_IsIncludeNullsProject, COLUMNNAME_IsIncludeNullsSalesRegion, COLUMNNAME_IsIncludeNullsUserElement1, COLUMNNAME_IsIncludeNullsUserElement2, COLUMNNAME_IsPrinted, COLUMNNAME_M_Product_ID, COLUMNNAME_Name, COLUMNNAME_Oper_1_ID, COLUMNNAME_Oper_2_ID, COLUMNNAME_Org_ID, COLUMNNAME_PA_ReportColumn_ID, COLUMNNAME_PA_ReportColumnSet_ID, COLUMNNAME_PostingType, COLUMNNAME_RelativePeriod, COLUMNNAME_SeqNo, COLUMNNAME_UserElement1_ID, COLUMNNAME_UserElement2_ID, Model, Table_ID, Table_Name

Constructor Summary

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

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

Method Summary

static MReportColumn	copy(Properties ctx, int AD_Client_ID, int AD_Org_ID, int PA_ReportColumnSet_ID, MReportColumn source, String trxName) /** Copy
int	getRelativePeriodAsInt() Get Relative Period As Int
String	getSelectClause(boolean withSum) Get Column SQL Select 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_Activity, getC_BPartner_ID, getC_BPartner, getC_Campaign_ID, getC_Campaign, getC_Currency_ID, getC_Currency, getC_ElementValue_ID, getC_ElementValue, getC_Location_ID, getC_Project_ID, getC_Project, getC_SalesRegion_ID, getC_SalesRegion, getCalculationType, getColumnType, getCurrencyType, getDescription, getElementType, getGL_Budget_ID, getGL_Budget, getKeyNamePair, getM_Product_ID, getM_Product, getName, getOper_1_ID, getOper_2_ID, getOrg_ID, getPA_ReportColumn_ID, getPA_ReportColumnSet_ID, getPA_ReportColumnSet, getPostingType, getRelativePeriod, getSeqNo, getUserElement1_ID, getUserElement2_ID, initPO, isAdhocConversion, isIncludeNullsActivity, isIncludeNullsBPartner, isIncludeNullsCampaign, isIncludeNullsElementValue, isIncludeNullsLocation, isIncludeNullsOrg, isIncludeNullsProduct, isIncludeNullsProject, isIncludeNullsSalesRegion, isIncludeNullsUserElement1, isIncludeNullsUserElement2, 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, setIsIncludeNullsActivity, setIsIncludeNullsBPartner, setIsIncludeNullsCampaign, setIsIncludeNullsElementValue, setIsIncludeNullsLocation, setIsIncludeNullsOrg, setIsIncludeNullsProduct, setIsIncludeNullsProject, setIsIncludeNullsSalesRegion, setIsIncludeNullsUserElement1, setIsIncludeNullsUserElement2, setIsPrinted, setM_Product_ID, setName, setOper_1_ID, setOper_2_ID, setOrg_ID, setPA_ReportColumn_ID, setPA_ReportColumnSet_ID, setPostingType, setRelativePeriod, setSeqNo, setUserElement1_ID, setUserElement2_ID

Methods inherited from class org.compiere.model.PO

afterDelete, afterSave, beforeDelete, beforeSave, compare, copyValues, copyValues, createAttachment, delete_Accounting, delete_Tree, delete, delete, deleteEx, deleteEx, dump, dump, equals, get_ColumnCount, get_ColumnDescription, get_ColumnDisplayType, get_ColumnIndex, get_ColumnLabel, get_ColumnLookup, get_ColumnName, get_DisplayValue, get_HashMap, get_ID, get_IDOld, get_KeyColumns, get_Logger, get_Table_ID, get_TableName, get_Translation, get_TrxName, get_Value, get_Value, get_ValueAsInt, get_ValueAsString, get_ValueDifference, get_ValueDifference, get_ValueE, get_ValueOfColumn, get_ValueOld, get_ValueOld, get_ValueOldAsInt, get_WhereClause, get_xmlDocument, get_xmlString, getAD_Client_ID, getAD_Org_ID, getAllIDs, getAttachment, getAttachment, getAttachmentData, getCreated, getCreatedBy, getCtx, getDoc, getFindParameter, getPdfAttachment, getUpdated, getUpdatedBy, insert_Accounting, insert_Tree, insert_Tree, is_Changed, is_new, is_ValueChanged, is_ValueChanged, isActive, isAttachment, isColumnMandatory, isColumnUpdateable, isMandatoryOK, isPdfAttachment, isReplication, load, load, load, load, loadComplete, loadDefaults, loadSpecial, lock, save, save, saveEx, saveEx, saveNew_getID, saveNewSpecial, saveReplica, saveUpdate, set_ColumnUpdateable, set_CustomColumn, set_TrxName, set_TrxName, set_Value, set_Value, set_ValueE, set_ValueNoCheck, set_ValueNoCheckE, set_ValueOfColumn, set_ValueOfColumn, setAD_Client_ID, setAD_Org_ID, setClientOrg, setClientOrg, setDoc, setDocWorkflowMgr, setIsActive, setReplication, setStandardDefaults, setUpdateable, setUpdatedBy, unlock

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.compiere.model.I_Persistent

save

Constructor Detail

MReportColumn

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

Constructor

Parameters:

ctx - context

PA_ReportColumn_ID - id

trxName - transaction

MReportColumn

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

Constructor

Parameters:

ctx - context

rs - ResultSet to load from

trxName - transaction

Method Detail

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

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 ralative 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

copy

public static MReportColumn copy(Properties 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