Package org.compiere.model

Class MMeasureCalc

java.lang.Object

org.compiere.model.PO

org.compiere.model.X_PA_MeasureCalc

org.compiere.model.MMeasureCalc

All Implemented Interfaces:

Serializable, Cloneable, Comparator<Object>, I_PA_MeasureCalc, I_Persistent, Evaluatee, ImmutablePOSupport

public class MMeasureCalc
extends X_PA_MeasureCalc
implements ImmutablePOSupport

Performance Measure Calculation

Version:

$Id: MMeasureCalc.java,v 1.4 2006/09/25 00:59:41 jjanke Exp $

Author:

Jorg Janke

See Also:

Serialized Form

Field Summary

Fields inherited from class org.compiere.model.X_PA_MeasureCalc

ENTITYTYPE_AD_Reference_ID

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, LOCAL_TRX_PREFIX, log, p_ctx, p_info, XML_ATTRIBUTE_AD_Table_ID, XML_ATTRIBUTE_Record_ID

Fields inherited from interface org.compiere.model.I_PA_MeasureCalc

accessLevel, COLUMNNAME_AD_Client_ID, COLUMNNAME_AD_Org_ID, COLUMNNAME_AD_Table_ID, COLUMNNAME_BPartnerColumn, COLUMNNAME_Created, COLUMNNAME_CreatedBy, COLUMNNAME_DateColumn, COLUMNNAME_Description, COLUMNNAME_EntityType, COLUMNNAME_IsActive, COLUMNNAME_KeyColumn, COLUMNNAME_Name, COLUMNNAME_OrgColumn, COLUMNNAME_PA_MeasureCalc_ID, COLUMNNAME_PA_MeasureCalc_UU, COLUMNNAME_ProductColumn, COLUMNNAME_SelectClause, COLUMNNAME_Updated, COLUMNNAME_UpdatedBy, COLUMNNAME_WhereClause, Model, Table_ID, Table_Name

Constructor Summary

Constructors

Constructor	Description
MMeasureCalc(Properties ctx, int PA_MeasureCalc_ID, String trxName)	Standard Constructor
MMeasureCalc(Properties ctx, ResultSet rs, String trxName)	Load Constructor
MMeasureCalc(Properties ctx, MMeasureCalc copy)
MMeasureCalc(Properties ctx, MMeasureCalc copy, String trxName)
MMeasureCalc(MMeasureCalc copy)

Method Summary

Modifier and Type	Method	Description
static String	addRestrictions(String sql, boolean queryOnly, MGoalRestriction[] restrictions, MRole role, String tableName, String orgColumn, String bpColumn, String pColumn)	Add Restrictions to SQL
static MMeasureCalc	get(int PA_MeasureCalc_ID)	Get MMeasureCalc from Cache (immutable)
static MMeasureCalc	get(Properties ctx, int PA_MeasureCalc_ID)	Get MMeasureCalc from Cache (immutable)
MQuery	getQuery(MGoalRestriction[] restrictions, String MeasureDisplay, Timestamp date, MRole role)	Get Zoom Query
String	getSqlBarChart(MGoalRestriction[] restrictions, String MeasureDisplay, Timestamp startDate, MRole role)	Get Sql to value for the bar chart
String	getSqlPI(MGoalRestriction[] restrictions, String MeasureScope, String MeasureDataType, Timestamp reportDate, MRole role)	Get Sql to return single value for the Performance Indicator
String	getTableName()	Get Table Name
MMeasureCalc	markImmutable()	mark PO as immutable
String	toString()	String Representation

Methods inherited from class org.compiere.model.X_PA_MeasureCalc

get_AccessLevel, getAD_Table, getAD_Table_ID, getBPartnerColumn, getDateColumn, getDescription, getEntityType, getKeyColumn, getKeyNamePair, getName, getOrgColumn, getPA_MeasureCalc_ID, getPA_MeasureCalc_UU, getProductColumn, getSelectClause, getWhereClause, initPO, setAD_Table_ID, setBPartnerColumn, setDateColumn, setDescription, setEntityType, setKeyColumn, setName, setOrgColumn, setPA_MeasureCalc_ID, setPA_MeasureCalc_UU, setProductColumn, setSelectClause, setWhereClause

Methods inherited from class org.compiere.model.PO

afterDelete, afterSave, beforeDelete, beforeSave, checkImmutable, clearCrossTenantSafe, clone, columnExists, columnExists, compare, copyPO, copyValues, copyValues, createAttachment, delete, delete, delete_Accounting, delete_Tree, deleteEx, deleteEx, dump, dump, equals, get_Attribute, get_Attributes, 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_OptimisticLockingColumns, get_Table_ID, get_TableName, get_Translation, get_Translation, get_Translation, get_Translation, get_Translation, get_TrxName, get_Value, get_Value, get_ValueAsBoolean, get_ValueAsInt, get_ValueAsInt, get_ValueAsString, get_ValueDifference, get_ValueDifference, get_ValueE, get_ValueOfColumn, get_ValueOld, get_ValueOld, get_ValueOldAsInt, get_WhereClause, get_WhereClause, get_xmlDocument, get_xmlString, getAD_Client_ID, getAD_Org_ID, getAllIDs, getAttachment, getAttachment, getAttachmentData, getCreated, getCreatedBy, getCtx, getDoc, getFindParameter, getPdfAttachment, getUpdated, getUpdatedBy, getUUIDColumnName, getUUIDColumnName, hashCode, insert_Accounting, insert_Tree, insert_Tree, is_Changed, is_Immutable, is_new, is_UseOptimisticLocking, is_ValueChanged, is_ValueChanged, isActive, isAttachment, isColumnMandatory, isColumnUpdateable, isMandatoryOK, isPdfAttachment, isReplication, load, load, load, load, load, loadByUU, loadComplete, loadDefaults, loadSpecial, lock, makeImmutable, postDelete, retrieveIdOfParentValue, retrieveIdOfParentValue, save, save, saveEx, saveEx, saveNew_afterSetID, saveNew_getID, saveNewSpecial, saveReplica, saveUpdate, set_Attribute, set_ColumnUpdateable, set_CustomColumn, set_CustomColumnReturningBoolean, set_OptimisticLockingColumns, set_TrxName, set_TrxName, set_UseOptimisticLocking, set_Value, set_Value, set_Value, set_Value, set_ValueE, set_ValueNoCheck, set_ValueNoCheckE, set_ValueOfColumn, set_ValueOfColumn, set_ValueOfColumnReturningBoolean, set_ValueOfColumnReturningBoolean, setAD_Client_ID, setAD_Org_ID, setClientOrg, setClientOrg, setCrossTenantSafe, setDoc, setDocWorkflowMgr, setIsActive, setProcessedOn, setReplication, setStandardDefaults, setUpdateable, setUpdatedBy, unlock, update_Tree, validForeignKeys

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.util.Comparator

reversed, thenComparing, thenComparing, thenComparing, thenComparingDouble, thenComparingInt, thenComparingLong

Methods inherited from interface org.compiere.model.I_PA_MeasureCalc

getAD_Client_ID, getAD_Org_ID, getCreated, getCreatedBy, getUpdated, getUpdatedBy, isActive, setAD_Org_ID, setIsActive

Methods inherited from interface org.compiere.model.I_Persistent

save

Constructor Detail

MMeasureCalc

public MMeasureCalc(Properties ctx,
                    int PA_MeasureCalc_ID,
                    String trxName)

Standard Constructor

Parameters:

ctx - context

PA_MeasureCalc_ID - id

trxName - trx

MMeasureCalc

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

Load Constructor

Parameters:

ctx - context

rs - result set

trxName - trx

MMeasureCalc

public MMeasureCalc(MMeasureCalc copy)

Parameters:

copy -

MMeasureCalc

public MMeasureCalc(Properties ctx,
                    MMeasureCalc copy)

Parameters:

ctx -

copy -

MMeasureCalc

public MMeasureCalc(Properties ctx,
                    MMeasureCalc copy,
                    String trxName)

Parameters:

ctx -

copy -

trxName -

Method Detail

get

public static MMeasureCalc get(int PA_MeasureCalc_ID)

Get MMeasureCalc from Cache (immutable)

Parameters:

PA_MeasureCalc_ID - id

Returns:

MMeasureCalc

get

public static MMeasureCalc get(Properties ctx,
                               int PA_MeasureCalc_ID)

Get MMeasureCalc from Cache (immutable)

Parameters:

ctx - context

PA_MeasureCalc_ID - id

Returns:

MMeasureCalc

getSqlPI

public String getSqlPI(MGoalRestriction[] restrictions,
                       String MeasureScope,
                       String MeasureDataType,
                       Timestamp reportDate,
                       MRole role)

Get Sql to return single value for the Performance Indicator

Parameters:

restrictions - array of goal restrictions

MeasureScope - scope of this value

MeasureDataType - data type

reportDate - optional report date

role - role

Returns:

sql for performance indicator

getSqlBarChart

public String getSqlBarChart(MGoalRestriction[] restrictions,
                             String MeasureDisplay,
                             Timestamp startDate,
                             MRole role)

Get Sql to value for the bar chart

Parameters:

restrictions - array of goal restrictions

MeasureDisplay - scope of this value

startDate - optional report start date

role - role

Returns:

sql for Bar Chart

getQuery

public MQuery getQuery(MGoalRestriction[] restrictions,
                       String MeasureDisplay,
                       Timestamp date,
                       MRole role)

Get Zoom Query

Parameters:

restrictions - restrictions

MeasureDisplay - display

date - date

role - role

Returns:

query

addRestrictions

public static String addRestrictions(String sql,
                                     boolean queryOnly,
                                     MGoalRestriction[] restrictions,
                                     MRole role,
                                     String tableName,
                                     String orgColumn,
                                     String bpColumn,
                                     String pColumn)

Add Restrictions to SQL

Parameters:

sql - orig sql

queryOnly - incomplete sql for query restriction

restrictions - restrictions

role - role

tableName - table name

orgColumn - org column

bpColumn - bpartner column

pColumn - product column

Returns:

updated sql

getTableName

public String getTableName()

Get Table Name

Returns:

Table Name

toString

public String toString()

String Representation

Overrides:

toString in class X_PA_MeasureCalc

Returns:

info

markImmutable

public MMeasureCalc markImmutable()

Description copied from interface: ImmutablePOSupport

mark PO as immutable

Specified by:

markImmutable in interface ImmutablePOSupport

Returns:

PO