org.compiere.model
Class MMeasureCalc

java.lang.Object
  org.compiere.framework.PO
      org.compiere.model.X_PA_MeasureCalc
          org.compiere.model.MMeasureCalc

All Implemented Interfaces:

Serializable, Cloneable, Comparator<PO>, 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

accessLevel, ENTITYTYPE_AD_Reference_ID, Model, 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

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

MMeasureCalc(Ctx 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(Ctx ctx, int PA_MeasureCalc_ID) Get MMeasureCalc from Cache
Query	getQuery(MGoalRestriction[] restrictions, String MeasureDisplay, Timestamp date, MRole role) Get Zoom Query
String	getSqlBarChart(MGoalRestriction[] restrictions, String MeasureDisplay, Timestamp startDate, Timestamp endDate, 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, 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.framework.PO

addAttachment, addAttachment, addError, afterDelete, afterSave, beforeDelete, beforeSave, 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

MMeasureCalc

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

Standard Constructor

Parameters:

ctx - context

PA_MeasureCalc_ID - id

trxName - trx

MMeasureCalc

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

Load Constructor

Parameters:

ctx - context

rs - result set

trxName - trx

Method Detail

get

public static MMeasureCalc get(Ctx 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,
                             Timestamp endDate,
                             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 Query 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