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, Comparator, I_PA_MeasureCalc, I_Persistent, Evaluatee

public class MMeasureCalc
extends X_PA_MeasureCalc

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, 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_Table_ID, COLUMNNAME_BPartnerColumn, COLUMNNAME_DateColumn, COLUMNNAME_Description, COLUMNNAME_EntityType, COLUMNNAME_KeyColumn, COLUMNNAME_Name, COLUMNNAME_OrgColumn, COLUMNNAME_PA_MeasureCalc_ID, COLUMNNAME_ProductColumn, COLUMNNAME_SelectClause, COLUMNNAME_WhereClause, Model, Table_ID, Table_Name

Constructor Summary

MMeasureCalc(Properties ctx, int PA_MeasureCalc_ID, String trxName)
Standard Constructor

MMeasureCalc(Properties ctx, ResultSet rs, String trxName)
Load Constructor

Method Summary

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(Properties ctx, int PA_MeasureCalc_ID) Get MMeasureCalc from Cache
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
String	toString() String Representation

Methods inherited from class org.compiere.model.X_PA_MeasureCalc

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

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

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

Method Detail

get

public static MMeasureCalc get(Properties ctx,
                               int PA_MeasureCalc_ID)

Get MMeasureCalc from Cache

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