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 ConstructorMMeasureCalc(Properties ctx, ResultSet rs, String trxName)
Load ConstructorMMeasureCalc(Properties ctx, MMeasureCalc copy)
MMeasureCalc(Properties ctx, MMeasureCalc copy, String trxName)
MMeasureCalc(MMeasureCalc copy)
-
Method Summary
All Methods Static Methods Instance Methods Concrete Methods 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 SQLstatic 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 QueryString
getSqlBarChart(MGoalRestriction[] restrictions, String MeasureDisplay, Timestamp startDate, MRole role)
Get Sql to value for the bar chartString
getSqlPI(MGoalRestriction[] restrictions, String MeasureScope, String MeasureDataType, Timestamp reportDate, MRole role)
Get Sql to return single value for the Performance IndicatorString
getTableName()
Get Table NameMMeasureCalc
markImmutable()
mark PO as immutableString
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
- contextPA_MeasureCalc_ID
- idtrxName
- trx
-
MMeasureCalc
public MMeasureCalc(Properties ctx, ResultSet rs, String trxName)
Load Constructor- Parameters:
ctx
- contextrs
- result settrxName
- 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
- contextPA_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 restrictionsMeasureScope
- scope of this valueMeasureDataType
- data typereportDate
- optional report daterole
- 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 restrictionsMeasureDisplay
- scope of this valuestartDate
- optional report start daterole
- role- Returns:
- sql for Bar Chart
-
getQuery
public MQuery getQuery(MGoalRestriction[] restrictions, String MeasureDisplay, Timestamp date, MRole role)
Get Zoom Query- Parameters:
restrictions
- restrictionsMeasureDisplay
- displaydate
- daterole
- 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 sqlqueryOnly
- incomplete sql for query restrictionrestrictions
- restrictionsrole
- roletableName
- table nameorgColumn
- org columnbpColumn
- bpartner columnpColumn
- product column- Returns:
- updated sql
-
getTableName
public String getTableName()
Get Table Name- Returns:
- Table Name
-
toString
public String toString()
String Representation- Overrides:
toString
in classX_PA_MeasureCalc
- Returns:
- info
-
markImmutable
public MMeasureCalc markImmutable()
Description copied from interface:ImmutablePOSupport
mark PO as immutable- Specified by:
markImmutable
in interfaceImmutablePOSupport
- Returns:
- PO
-
-