org.compiere.model
Class MProjectType

java.lang.Object
  org.compiere.framework.PO
      org.compiere.model.X_C_ProjectType
          org.compiere.model.MProjectType

All Implemented Interfaces:

Serializable, Cloneable, Comparator<PO>, Evaluatee

public class MProjectType
extends X_C_ProjectType

Project Type Model

Version:

$Id: MProjectType.java,v 1.3 2006/07/30 00:51:03 jjanke Exp $

Author:

Jorg Janke

See Also:

Serialized Form

Field Summary

Fields inherited from class org.compiere.model.X_C_ProjectType

accessLevel, Model, PROJECTCATEGORY_AD_Reference_ID, PROJECTCATEGORY_AssetProject, PROJECTCATEGORY_General, PROJECTCATEGORY_ServiceChargeProject, PROJECTCATEGORY_WorkOrderJob, 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

MProjectType(Ctx ctx, int C_ProjectType_ID, String trxName)
Standrad Constructor

MProjectType(Ctx ctx, ResultSet rs, String trxName)
Load Constructor

Method Summary

static MProjectType	get(Ctx ctx, int C_ProjectType_ID) Get MProjectType from Cache
MProjectTypePhase[]	getPhases() Get Project Type Phases
Query	getQuery(MGoalRestriction[] restrictions, String MeasureDisplay, Timestamp date, int C_Phase_ID, MRole role) Get Zoom Query
String	getSqlBarChart(MGoalRestriction[] restrictions, String MeasureDisplay, String MeasureDataType, 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	toString() String Representation

Methods inherited from class org.compiere.model.X_C_ProjectType

get_AccessLevel, getC_ProjectType_ID, getDescription, getHelp, getKeyNamePair, getName, getProjectCategory, initPO, isProjectCategoryValid, setC_ProjectType_ID, setDescription, setHelp, setName, setProjectCategory

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

MProjectType

public MProjectType(Ctx ctx,
                    int C_ProjectType_ID,
                    String trxName)

Standrad Constructor

Parameters:

ctx - context

C_ProjectType_ID - id

trxName - trx

MProjectType

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

Load Constructor

Parameters:

ctx - context

rs - result set

trxName - trx

Method Detail

get

public static MProjectType get(Ctx ctx,
                               int C_ProjectType_ID)

Get MProjectType from Cache

Parameters:

ctx - context

C_ProjectType_ID - id

Returns:

MProjectType

toString

public String toString()

String Representation

Overrides:

toString in class X_C_ProjectType

Returns:

info

getPhases

public MProjectTypePhase[] getPhases()

Get Project Type Phases

Returns:

Array of phases

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,
                             String MeasureDataType,
                             Timestamp startDate,
                             MRole role)

Get Sql to value for the bar chart

Parameters:

restrictions - array of goal restrictions

MeasureDisplay - scope of this value

MeasureDataType - data type

startDate - optional report start date

role - role

Returns:

sql for Bar Chart

getQuery

public Query getQuery(MGoalRestriction[] restrictions,
                      String MeasureDisplay,
                      Timestamp date,
                      int C_Phase_ID,
                      MRole role)

Get Zoom Query

Parameters:

restrictions - restrictions

MeasureDisplay - display

date - date

C_Phase_ID - phase

role - role

Returns:

query