com.wm.app.tn.db
Class InviteQuery

java.lang.Object
  com.wm.app.tn.db.Query
      com.wm.app.tn.db.InviteQuery

All Implemented Interfaces:

com.wm.data.IData

public class InviteQuery
extends Query
implements com.wm.data.IData

Field Summary

static java.lang.String	ALERTDATE
static java.lang.String	CREATEDUSER
static java.lang.String	DESCRIPTION
static java.lang.String	EXPIRYDATE
static java.lang.String	INV_TBL
static java.lang.String	INVITEID
static java.lang.String	INVITENAME
static java.lang.String	INVPRTN_TBL
static java.lang.String	INVTEMP_TBL
static java.lang.String	LASTMODIFIED
static java.lang.String	LASTSENT
static java.lang.String	ONB_INVITE_TBL
static java.lang.String	ONB_INVPARTNER_TBL
static java.lang.String	ONB_INVTEMPLATE_TBL
static java.lang.String	PARTNER_TBL
static java.lang.String	PARTNERID
static java.lang.String	PRTN_TBL
static java.lang.String	STATUS
static java.lang.String	TEMPLATEID
static java.lang.String	TIME_SINCE
static java.lang.String	TIME_TYPE
static java.lang.String	TIME_UNTIL

Fields inherited from class com.wm.app.tn.db.Query

ACTLOG_EVENT_TIMESTAMP, BDTYPE_LASTMODIFIED, DJOB_TIME_CREATED, DJOB_TIME_UPDATED, DOC_TIMESTAMP, FN_AVG, FN_MAX, FN_MIN, FN_SUM, INVITE_ALERTDATE, INVITE_EXPIRYDATE, INVITE_LASTSENT, OP_COMP_AFTER, OP_COMP_BEFORE, OP_COMP_CONTAINS, OP_COMP_EQ, OP_COMP_GEQ, OP_COMP_GT, OP_COMP_INCLUDES, OP_COMP_LEQ, OP_COMP_LT, OP_COMP_NEQ, OP_MATCHES, OP_TEST_NOT_NULL, OP_TEST_NULL, TIME_ANYTIME, TIME_CUSTOM, TIME_LAST_7_DAYS, TIME_LAST_MONTH, TIME_LAST_WEEK, TIME_NEXT_10_MIN, TIME_NEXT_12_HOURS, TIME_NEXT_24_HOURS, TIME_NEXT_3_HOURS, TIME_NEXT_30_MIN, TIME_NEXT_6_HOURS, TIME_NEXT_HOUR, TIME_THIS_MONTH, TIME_THIS_WEEK, TIME_TODAY, TIME_TOMORROW, TIME_YESTERDAY, TIME_YTD, TPA_CREATED, TPA_LASTMODIFIED, TYPE_DATE, TYPE_NUMBER, TYPE_STRING

Constructor Summary

InviteQuery()
Default query is "select * from OnboardingInvite".

Method Summary

void	clearSortColumns() Clear sort order
static com.wm.data.IData	create() For internal use only
java.lang.Object	getCreatedUser()
com.wm.data.IDataCursor	getCursor()
java.lang.Object	getDescription()
com.wm.data.IDataHashCursor	getHashCursor() For internal use only
com.wm.data.IDataIndexCursor	getIndexCursor() For internal use only
java.lang.Object	getInviteID()
java.lang.Object	getInviteName()
int	getLastReminderTimeIntervalType()
java.lang.Object	getPartnerID()
com.wm.data.IDataSharedCursor	getSharedCursor()
java.lang.String[][]	getSortColumns() returns sort columns (may be null)
java.lang.Object	getStatus()
java.lang.Object	getTemplateID()
java.sql.Timestamp[]	getTimeInterval()
int	getTimeIntervalType()
com.wm.data.IDataTreeCursor	getTreeCursor() For internal use only
java.lang.String[]	getVisibleColumns() For internal use only
boolean	isAlertTimeVisible()
boolean	isCreatedUserVisible()
boolean	isDescriptionVisible()
boolean	isExpiryTimeVisible()
boolean	isInviteIDVisible()
boolean	isInviteNameVisible()
boolean	isLastReminderTimeVisible()
boolean	isPartnerIDVisible()
boolean	isStatusVisible()
boolean	isTemplateIDVisible()
static void	main(java.lang.String[] args)
void	preSql() For internal use only
void	setAlertTimeVisible(boolean b)
void	setCreatedUser(java.lang.String user) Search for invitations using created user.
void	setCreatedUser(java.lang.String[][] opValue, boolean isORquery) Search for invitation names using multiple created users.
void	setCreatedUserVisible(boolean b)
void	setDescription(boolean b)
void	setDescription(java.lang.String desc) Search for invitations using invite name.
void	setDescription(java.lang.String[][] opValue, boolean isORquery) Search for invitation names using multiple criterias on description.
void	setExpiryTimeVisible(boolean b)
void	setInviteId(java.lang.String id) Search for invitations using internal id.
void	setInviteId(java.lang.String[][] opValue, boolean isORquery) Search for invitations using multiple criterias on internal id.
void	setInviteIDVisible(boolean b)
void	setInviteName(java.lang.String name) Search for invitations using invite name.
void	setInviteName(java.lang.String[][] opValue, boolean isORquery) Search for invitation names using multiple criterias on names.
void	setInviteNameVisible(boolean b)
void	setLastReminderTimeVisible(boolean b)
void	setPartnerID(java.lang.String partnerID) Search for invitations using template name.
void	setPartnerID(java.lang.String[][] opValue, boolean isORquery) Search for invitation names using multiple template names.
void	setPartnerIDVisible(boolean b)
void	setSortColumns(java.lang.String[][] columnOrder) Set the sort columns and order for this query.
void	setStatus(java.lang.String name) Search for invitations using status.
void	setStatus(java.lang.String[][] opValue, boolean isORquery) Search for invitation names using multiple statuses.
void	setStatusVisible(boolean b)
void	setTemplateID(java.lang.String templateID) Search for invitations using template name.
void	setTemplateID(java.lang.String[][] opValue, boolean isORquery) Search for invitation names using multiple template names.
void	setTemplateIDVisible(boolean b)
void	setTimeInterval(int which) Set time interval for this query (see TIME_ constants in Query)
void	setTimeInterval(java.sql.Timestamp since, java.sql.Timestamp until) Set custom time interval for this query
java.lang.String	toSql()
java.lang.String	toSql(boolean agg) For internal use only

Methods inherited from class com.wm.app.tn.db.Query

beginningOfDay, escapeString, evaluate, evaluateListConditions, generateClause, generateClause, generateColumnList, generateComp, generateComp, generateComp, generateListComp, generateNumericClause, generateStringLit, generateStringLit, generateTimeInterval, generateTimestampLiteral, getIntervalType, getUnique, isDateTime, isDistinct, isIndentSql, isOR, searchMWS, setAlertTimeInterval, setDistinct, setExpiryTimeInterval, setIndentSql, setLastReminderInterval, setOR, setViewPermission

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

INVITEID

public static final java.lang.String INVITEID

See Also:

Constant Field Values

INVITENAME

public static final java.lang.String INVITENAME

See Also:

Constant Field Values

STATUS

public static final java.lang.String STATUS

See Also:

Constant Field Values

EXPIRYDATE

public static final java.lang.String EXPIRYDATE

See Also:

Constant Field Values

ALERTDATE

public static final java.lang.String ALERTDATE

See Also:

Constant Field Values

LASTSENT

public static final java.lang.String LASTSENT

See Also:

Constant Field Values

LASTMODIFIED

public static final java.lang.String LASTMODIFIED

See Also:

Constant Field Values

CREATEDUSER

public static final java.lang.String CREATEDUSER

See Also:

Constant Field Values

DESCRIPTION

public static final java.lang.String DESCRIPTION

See Also:

Constant Field Values

ONB_INVITE_TBL

public static final java.lang.String ONB_INVITE_TBL

See Also:

Constant Field Values

INV_TBL

public static final java.lang.String INV_TBL

See Also:

Constant Field Values

ONB_INVTEMPLATE_TBL

public static final java.lang.String ONB_INVTEMPLATE_TBL

See Also:

Constant Field Values

INVTEMP_TBL

public static final java.lang.String INVTEMP_TBL

See Also:

Constant Field Values

TEMPLATEID

public static final java.lang.String TEMPLATEID

See Also:

Constant Field Values

ONB_INVPARTNER_TBL

public static final java.lang.String ONB_INVPARTNER_TBL

See Also:

Constant Field Values

INVPRTN_TBL

public static final java.lang.String INVPRTN_TBL

See Also:

Constant Field Values

PARTNERID

public static final java.lang.String PARTNERID

See Also:

Constant Field Values

PARTNER_TBL

public static final java.lang.String PARTNER_TBL

See Also:

Constant Field Values

PRTN_TBL

public static final java.lang.String PRTN_TBL

See Also:

Constant Field Values

TIME_SINCE

public static final java.lang.String TIME_SINCE

See Also:

Constant Field Values

TIME_UNTIL

public static final java.lang.String TIME_UNTIL

See Also:

Constant Field Values

TIME_TYPE

public static final java.lang.String TIME_TYPE

See Also:

Constant Field Values

Constructor Detail

InviteQuery

public InviteQuery()

Default query is "select * from OnboardingInvite".

Method Detail

getCursor

public com.wm.data.IDataCursor getCursor()

Specified by:

getCursor in interface com.wm.data.IData

getSharedCursor

public com.wm.data.IDataSharedCursor getSharedCursor()

Specified by:

getSharedCursor in interface com.wm.data.IData

getIndexCursor

public com.wm.data.IDataIndexCursor getIndexCursor()

For internal use only

Specified by:

getIndexCursor in interface com.wm.data.IData

getTreeCursor

public com.wm.data.IDataTreeCursor getTreeCursor()

For internal use only

Specified by:

getTreeCursor in interface com.wm.data.IData

getHashCursor

public com.wm.data.IDataHashCursor getHashCursor()

For internal use only

Specified by:

getHashCursor in interface com.wm.data.IData

create

public static com.wm.data.IData create()

For internal use only

setInviteId

public void setInviteId(java.lang.String id)

Search for invitations using internal id.

Parameters:

id - the internal id of the invitation to look for

setInviteId

public void setInviteId(java.lang.String[][] opValue,
                        boolean isORquery)

Search for invitations using multiple criterias on internal id.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_CONTAINS, "123"}, {Query.OP_COMP_NEQ, "123456789012345678901234"}})

isORquery - should OR operator be used between these criterias?

setInviteName

public void setInviteName(java.lang.String name)

Search for invitations using invite name.

Parameters:

id - the internal id of the invitation to look for

setInviteName

public void setInviteName(java.lang.String[][] opValue,
                          boolean isORquery)

Search for invitation names using multiple criterias on names.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_CONTAINS, "123"}, {Query.OP_COMP_NEQ, "123456789012345678901234"}})

isORquery - should OR operator be used between these criterias?

setDescription

public void setDescription(java.lang.String desc)

Search for invitations using invite name.

Parameters:

id - the internal id of the invitation to look for

setDescription

public void setDescription(java.lang.String[][] opValue,
                           boolean isORquery)

Search for invitation names using multiple criterias on description.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_CONTAINS, "123"}, {Query.OP_COMP_NEQ, "123456789012345678901234"}})

isORquery - should OR operator be used between these criterias?

setStatus

public void setStatus(java.lang.String name)

Search for invitations using status.

Parameters:

id - the internal id of the invitation to look for

setStatus

public void setStatus(java.lang.String[][] opValue,
                      boolean isORquery)

Search for invitation names using multiple statuses.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_CONTAINS, "123"}, {Query.OP_COMP_NEQ, "123456789012345678901234"}})

isORquery - should OR operator be used between these criterias?

setCreatedUser

public void setCreatedUser(java.lang.String user)

Search for invitations using created user.

Parameters:

id - the internal id of the invitation to look for

setCreatedUser

public void setCreatedUser(java.lang.String[][] opValue,
                           boolean isORquery)

Search for invitation names using multiple created users.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_CONTAINS, "123"}, {Query.OP_COMP_NEQ, "123456789012345678901234"}})

isORquery - should OR operator be used between these criterias?

setTemplateID

public void setTemplateID(java.lang.String templateID)

Search for invitations using template name.

Parameters:

id - the internal id of the invitation to look for

setTemplateID

public void setTemplateID(java.lang.String[][] opValue,
                          boolean isORquery)

Search for invitation names using multiple template names.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_CONTAINS, "123"}, {Query.OP_COMP_NEQ, "123456789012345678901234"}})

isORquery - should OR operator be used between these criterias?

setPartnerID

public void setPartnerID(java.lang.String partnerID)

Search for invitations using template name.

Parameters:

id - the internal id of the invitation to look for

setPartnerID

public void setPartnerID(java.lang.String[][] opValue,
                         boolean isORquery)

Search for invitation names using multiple template names.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_CONTAINS, "123"}, {Query.OP_COMP_NEQ, "123456789012345678901234"}})

isORquery - should OR operator be used between these criterias?

setTimeInterval

public void setTimeInterval(int which)

Set time interval for this query (see TIME_ constants in Query)

setTimeInterval

public void setTimeInterval(java.sql.Timestamp since,
                            java.sql.Timestamp until)

Set custom time interval for this query

Overrides:

setTimeInterval in class Query

getInviteID

public java.lang.Object getInviteID()

Returns:

the Invite ID criterion.

getInviteName

public java.lang.Object getInviteName()

Returns:

the Invite name criterion.

getDescription

public java.lang.Object getDescription()

Returns:

the Invite description criterion.

getStatus

public java.lang.Object getStatus()

Returns:

the Invite status criterion.

getCreatedUser

public java.lang.Object getCreatedUser()

Returns:

the created user criterion.

getTemplateID

public java.lang.Object getTemplateID()

Returns:

the template id criterion.

getPartnerID

public java.lang.Object getPartnerID()

Returns:

the partner id criterion.

getTimeInterval

public java.sql.Timestamp[] getTimeInterval()

Returns:

time interval for this query ( { from, to } )

getTimeIntervalType

public int getTimeIntervalType()

Returns:

time interval type for this query

getLastReminderTimeIntervalType

public int getLastReminderTimeIntervalType()

Returns:

the code for the last reminder time interval (could be -1)

setInviteIDVisible

public void setInviteIDVisible(boolean b)

setInviteNameVisible

public void setInviteNameVisible(boolean b)

setStatusVisible

public void setStatusVisible(boolean b)

setDescription

public void setDescription(boolean b)

setCreatedUserVisible

public void setCreatedUserVisible(boolean b)

setTemplateIDVisible

public void setTemplateIDVisible(boolean b)

setPartnerIDVisible

public void setPartnerIDVisible(boolean b)

setExpiryTimeVisible

public void setExpiryTimeVisible(boolean b)

setAlertTimeVisible

public void setAlertTimeVisible(boolean b)

setLastReminderTimeVisible

public void setLastReminderTimeVisible(boolean b)

isInviteIDVisible

public boolean isInviteIDVisible()

isInviteNameVisible

public boolean isInviteNameVisible()

isStatusVisible

public boolean isStatusVisible()

isDescriptionVisible

public boolean isDescriptionVisible()

isCreatedUserVisible

public boolean isCreatedUserVisible()

isTemplateIDVisible

public boolean isTemplateIDVisible()

isPartnerIDVisible

public boolean isPartnerIDVisible()

isExpiryTimeVisible

public boolean isExpiryTimeVisible()

isAlertTimeVisible

public boolean isAlertTimeVisible()

isLastReminderTimeVisible

public boolean isLastReminderTimeVisible()

setSortColumns

public void setSortColumns(java.lang.String[][] columnOrder)

Set the sort columns and order for this query. Make sure to use one of the constants above: EXPIRYDATE, PARTNERID, etc. Trying to sort on a column that's not visible will be ignored.

Overrides:

setSortColumns in class Query

Parameters:

columnOrder - takes column names and sort orders (e.g. {{EXPIRYDATE, "ASC"}, {PARTNERID, "DESC"}} )

getSortColumns

public java.lang.String[][] getSortColumns()

returns sort columns (may be null)

clearSortColumns

public void clearSortColumns()

Clear sort order

preSql

public void preSql()

For internal use only

Overrides:

preSql in class Query

toSql

public java.lang.String toSql()

Overrides:

toSql in class Query

Returns:

the SQL statement generated by this query

toSql

public java.lang.String toSql(boolean agg)

For internal use only

getVisibleColumns

public java.lang.String[] getVisibleColumns()

For internal use only

main

public static void main(java.lang.String[] args)
                 throws java.lang.Exception

Throws:

java.lang.Exception