org.compiere.model
Class MProjectType

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

All Implemented Interfaces:

Serializable, Comparator, I_C_ProjectType, I_Persistent, 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

PROJECTCATEGORY_AD_Reference_ID, PROJECTCATEGORY_AssetProject, PROJECTCATEGORY_General, PROJECTCATEGORY_ServiceChargeProject, PROJECTCATEGORY_WorkOrderJob

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_C_ProjectType

accessLevel, COLUMNNAME_C_ProjectType_ID, COLUMNNAME_Description, COLUMNNAME_Help, COLUMNNAME_Name, COLUMNNAME_ProjectCategory, Model, Table_ID, Table_Name

Constructor Summary

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

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

Method Summary

static MProjectType	get(Properties ctx, int C_ProjectType_ID) Get MProjectType from Cache
MProjectTypePhase[]	getPhases() Get Project Type Phases
MQuery	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, setC_ProjectType_ID, setDescription, setHelp, setName, setProjectCategory

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

MProjectType

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

Standrad Constructor

Parameters:

ctx - context

C_ProjectType_ID - id

trxName - trx

MProjectType

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

Load Constructor

Parameters:

ctx - context

rs - result set

trxName - trx

Method Detail

get

public static MProjectType get(Properties 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 MQuery 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