org.compiere.model
Class MRequestType

java.lang.Object
  org.compiere.model.PO
      org.compiere.model.X_R_RequestType
          org.compiere.model.MRequestType

All Implemented Interfaces:

Serializable, Comparator, I_Persistent, I_R_RequestType, Evaluatee

public class MRequestType
extends X_R_RequestType

Request Type Model

Version:

$Id: MRequestType.java,v 1.3 2006/07/30 00:51:03 jjanke Exp $ Teo Sarca - bug fix [ 1642833 ] MRequestType minor typo bug

Author:

Jorg Janke

See Also:

Serialized Form

Field Summary

Fields inherited from class org.compiere.model.X_R_RequestType

CONFIDENTIALTYPE_AD_Reference_ID, CONFIDENTIALTYPE_Internal, CONFIDENTIALTYPE_PartnerConfidential, CONFIDENTIALTYPE_PrivateInformation, CONFIDENTIALTYPE_PublicInformation

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_R_RequestType

accessLevel, COLUMNNAME_AutoDueDateDays, COLUMNNAME_ConfidentialType, COLUMNNAME_Description, COLUMNNAME_DueDateTolerance, COLUMNNAME_IsAutoChangeRequest, COLUMNNAME_IsConfidentialInfo, COLUMNNAME_IsDefault, COLUMNNAME_IsEMailWhenDue, COLUMNNAME_IsEMailWhenOverdue, COLUMNNAME_IsIndexed, COLUMNNAME_IsInvoiced, COLUMNNAME_IsSelfService, COLUMNNAME_Name, COLUMNNAME_R_RequestType_ID, COLUMNNAME_R_StatusCategory_ID, Model, Table_ID, Table_Name

Constructor Summary

MRequestType(Properties ctx, int R_RequestType_ID, String trxName)
Standard Constructor

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

Method Summary

protected boolean	beforeSave(boolean newRecord) Before Save
static MRequestType	get(Properties ctx, int R_RequestType_ID) Get Request Type (cached)
int	getClosed30No() Get Closed in last 30 days of type
static MRequestType	getDefault(Properties ctx) Get Default Request Type
int	getDefaultR_Status_ID() Get Default R_Status_ID for Type
int	getNew30No() Get New in the last 30 days of type
int	getOpenNo() Get Open No of requests of type
MQuery	getQuery(MGoalRestriction[] restrictions, String MeasureDisplay, Timestamp date, int R_Status_ID, MRole role) Get Zoom Query
MRequest[]	getRequests() Get public Requests of Type
MRequest[]	getRequests(boolean selfService, int C_BPartner_ID) Get Requests of Type
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
int	getTotalNo() Get Total No of requests of type
String	toString() String Representation

Methods inherited from class org.compiere.model.X_R_RequestType

get_AccessLevel, getAutoDueDateDays, getConfidentialType, getDescription, getDueDateTolerance, getKeyNamePair, getName, getR_RequestType_ID, getR_StatusCategory_ID, getR_StatusCategory, initPO, isAutoChangeRequest, isConfidentialInfo, isDefault, isEMailWhenDue, isEMailWhenOverdue, isIndexed, isInvoiced, isSelfService, setAutoDueDateDays, setConfidentialType, setDescription, setDueDateTolerance, setIsAutoChangeRequest, setIsConfidentialInfo, setIsDefault, setIsEMailWhenDue, setIsEMailWhenOverdue, setIsIndexed, setIsInvoiced, setIsSelfService, setName, setR_RequestType_ID, setR_StatusCategory_ID

Methods inherited from class org.compiere.model.PO

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

MRequestType

public MRequestType(Properties ctx,
                    int R_RequestType_ID,
                    String trxName)

Standard Constructor

Parameters:

ctx - context

R_RequestType_ID - id

trxName - transaction

MRequestType

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

Load Constructor

Parameters:

ctx - context

rs - result set

trxName - transaction

Method Detail

get

public static MRequestType get(Properties ctx,
                               int R_RequestType_ID)

Get Request Type (cached)

Parameters:

ctx - context

R_RequestType_ID - id

Returns:

Request Type

getDefault

public static MRequestType getDefault(Properties ctx)

Get Default Request Type

Parameters:

ctx - context

Returns:

Request Type

getTotalNo

public int getTotalNo()

Get Total No of requests of type

Returns:

no

getOpenNo

public int getOpenNo()

Get Open No of requests of type

Returns:

no

getClosed30No

public int getClosed30No()

Get Closed in last 30 days of type

Returns:

no

getNew30No

public int getNew30No()

Get New in the last 30 days of type

Returns:

no

getRequests

public MRequest[] getRequests(boolean selfService,
                              int C_BPartner_ID)

Get Requests of Type

Parameters:

selfService - self service

C_BPartner_ID - id or 0 for public

Returns:

array of requests

getRequests

public MRequest[] getRequests()

Get public Requests of Type

Returns:

array of requests

getDefaultR_Status_ID

public int getDefaultR_Status_ID()

Get Default R_Status_ID for Type

Returns:

status or 0

beforeSave

protected boolean beforeSave(boolean newRecord)

Before Save

Overrides:

beforeSave in class PO

Parameters:

newRecord - new

Returns:

true

toString

public String toString()

String Representation

Overrides:

toString in class X_R_RequestType

Returns:

info

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 R_Status_ID,
                       MRole role)

Get Zoom Query

Parameters:

restrictions - array of restrictions

MeasureDisplay - display

date - date

R_Status_ID - status

role - role

Returns:

query