com.wm.app.tn.db
Class DeliveryJobQuery

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

All Implemented Interfaces:

com.wm.data.IData

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

Field Summary

static java.lang.String	DELIVERY_JOBTYPE
static java.lang.String	DOC_ID
static int	DOC_ID_IDX
static java.lang.String[]	FIELDS
static java.lang.String	JOB_ID
static int	JOB_ID_IDX
static java.lang.String	JOB_STAT
static int	JOB_STAT_IDX
static java.lang.String	JOB_TYPE
static int	JOB_TYPE_IDX
static java.lang.String	PART_CORP
static java.lang.String	PART_ID
static int	PART_ID_IDX
static java.lang.String	PART_UNIT
static java.lang.String	PROCESSINGRULE_JOBTYPE
static java.lang.String	QUEUE_NAME
static int	QUEUE_NAME_IDX
static java.lang.String	RETRIES
static int	RETRIES_IDX
static java.lang.String	RETRY_FACTOR
static int	RETRY_FACTOR_IDX
static java.lang.String	RETRY_LIMIT
static int	RETRY_LIMIT_IDX
static java.lang.String	SENDER_CORP
static java.lang.String	SENDER_ID
static int	SENDER_ID_IDX
static java.lang.String	SENDER_UNIT
static java.lang.String	SRV_ID
static int	SRV_IDX
static java.lang.String	SVC_NAME
static int	SVC_NAME_IDX
static java.lang.String	T_STAT
static int	T_STAT_IDX
static java.lang.String	T_STAT_MSG
static int	T_STAT_MSG_IDX
static java.lang.String	T_TIME
static int	T_TIME_IDX
static java.lang.String[][]	TABLES_RIGHT
static java.lang.String	TIME_CREATED
static int	TIME_CREATED_IDX
static java.lang.String	TIME_SINCE
static java.lang.String	TIME_TYPE
static java.lang.String	TIME_UNTIL
static java.lang.String	TIME_UPDATED
static int	TIME_UPDATED_IDX
static java.lang.String	TTW
static int	TTW_IDX
static java.lang.String[]	VISIBLE_COLS

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

DeliveryJobQuery()

Method Summary

void	clearSortColumns() Clear sort order
static com.wm.data.IData	create()
com.wm.data.IDataCursor	getCursor()
com.wm.data.IDataHashCursor	getHashCursor()
com.wm.data.IDataIndexCursor	getIndexCursor()
java.lang.String	getInternalDocId()
java.lang.String	getJobId()
java.lang.Object	getJobStatus()
java.lang.Object	getJobType()
java.lang.Object	getPartnerId()
java.lang.Object	getQueueName()
java.lang.String	getSenderId()
java.lang.String	getServerId()
java.lang.Object	getServiceName()
com.wm.data.IDataSharedCursor	getSharedCursor()
java.lang.String[][]	getSortColumns() returns sort columns (may be null)
java.sql.Timestamp[]	getTimeInterval()
int	getTimeIntervalType()
com.wm.data.IDataTreeCursor	getTreeCursor()
java.lang.String[]	getVisibleColumns()
boolean	isInternalDocIdVisible()
boolean	isJobIdVisible()
boolean	isJobStatusVisible()
boolean	isJobTypeVisible()
boolean	isPartnerIdVisible()
boolean	isQueueNameVisible()
boolean	isRetriesVisible()
boolean	isRetryFactorVisible()
boolean	isRetryLimitVisible()
boolean	isSenderIdVisible()
boolean	isServerIdVisible()
boolean	isServiceNameVisible()
boolean	isStatusMessageVisible()
boolean	isTimeCreatedVisible()
boolean	isTimeToWaitVisible()
boolean	isTimeUpdatedVisible()
boolean	isTransportationStatusVisible()
boolean	isTransportationTimeVisible()
static void	main(java.lang.String[] args)
void	preSql() For internal use only
void	setInternalDocId(java.lang.String id)
void	setInternalDocIdVisible(boolean b)
void	setJobId(java.lang.String id)
void	setJobStatus(java.lang.String status)
void	setJobStatus(java.lang.String[][] opValue, boolean isORquery)
void	setJobStatusVisible(boolean b)
void	setJobType(java.lang.String type)
void	setJobType(java.lang.String[][] opValue, boolean isORquery)
void	setJobTypeVisible(boolean b)
void	setPartnerId(java.lang.String id)
void	setPartnerId(java.lang.String[][] opValue, boolean isORquery)
void	setPartnerIdVisible(boolean b)
void	setQueueName(java.lang.String qName)
void	setQueueName(java.lang.String[][] opValue, boolean isORquery)
void	setQueueNameVisible(boolean b)
void	setRetriesVisible(boolean b)
void	setRetryFactorVisible(boolean b)
void	setRetryLimitVisible(boolean b)
void	setSenderId(java.lang.String id)
void	setSenderIdVisible(boolean b)
void	setServerId(java.lang.String id)
void	setServerIdVisible(boolean b)
void	setServiceName(java.lang.String name)
void	setServiceName(java.lang.String[][] opValue, boolean isORquery)
void	setServiceNameVisible(boolean b)
void	setSortColumns(java.lang.String[][] columnOrder) Set the sort columns and order for this query.
void	setStatusMessageVisible(boolean b)
void	setTimeCreatedVisible(boolean b)
void	setTimeInterval(int which)
void	setTimeInterval(java.sql.Timestamp since, java.sql.Timestamp until)
void	setTimeToWaitVisible(boolean b)
void	setTimeUpdatedVisible(boolean b)
void	setTransportationStatusVisible(boolean b)
void	setTransportationTimeVisible(boolean b)
java.lang.String	toDeletingSql()
java.lang.String	toPreDeleteSql()

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, toSql

Methods inherited from class java.lang.Object

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

Field Detail

DELIVERY_JOBTYPE

public static java.lang.String DELIVERY_JOBTYPE

PROCESSINGRULE_JOBTYPE

public static java.lang.String PROCESSINGRULE_JOBTYPE

JOB_ID

public static final java.lang.String JOB_ID

See Also:

Constant Field Values

SRV_ID

public static final java.lang.String SRV_ID

See Also:

Constant Field Values

TIME_CREATED

public static final java.lang.String TIME_CREATED

See Also:

Constant Field Values

TIME_UPDATED

public static final java.lang.String TIME_UPDATED

See Also:

Constant Field Values

JOB_STAT

public static final java.lang.String JOB_STAT

See Also:

Constant Field Values

TTW

public static final java.lang.String TTW

See Also:

Constant Field Values

RETRIES

public static final java.lang.String RETRIES

See Also:

Constant Field Values

RETRY_LIMIT

public static final java.lang.String RETRY_LIMIT

See Also:

Constant Field Values

RETRY_FACTOR

public static final java.lang.String RETRY_FACTOR

See Also:

Constant Field Values

T_STAT

public static final java.lang.String T_STAT

See Also:

Constant Field Values

T_STAT_MSG

public static final java.lang.String T_STAT_MSG

See Also:

Constant Field Values

T_TIME

public static final java.lang.String T_TIME

See Also:

Constant Field Values

DOC_ID

public static final java.lang.String DOC_ID

See Also:

Constant Field Values

SVC_NAME

public static final java.lang.String SVC_NAME

See Also:

Constant Field Values

PART_ID

public static final java.lang.String PART_ID

See Also:

Constant Field Values

JOB_TYPE

public static final java.lang.String JOB_TYPE

See Also:

Constant Field Values

SENDER_ID

public static final java.lang.String SENDER_ID

See Also:

Constant Field Values

QUEUE_NAME

public static final java.lang.String QUEUE_NAME

See Also:

Constant Field Values

PART_CORP

public static final java.lang.String PART_CORP

See Also:

Constant Field Values

PART_UNIT

public static final java.lang.String PART_UNIT

See Also:

Constant Field Values

SENDER_CORP

public static final java.lang.String SENDER_CORP

See Also:

Constant Field Values

SENDER_UNIT

public static final java.lang.String SENDER_UNIT

See Also:

Constant Field Values

FIELDS

public static final java.lang.String[] FIELDS

JOB_ID_IDX

public static final int JOB_ID_IDX

See Also:

Constant Field Values

SRV_IDX

public static final int SRV_IDX

See Also:

Constant Field Values

TIME_CREATED_IDX

public static final int TIME_CREATED_IDX

See Also:

Constant Field Values

TIME_UPDATED_IDX

public static final int TIME_UPDATED_IDX

See Also:

Constant Field Values

JOB_STAT_IDX

public static final int JOB_STAT_IDX

See Also:

Constant Field Values

TTW_IDX

public static final int TTW_IDX

See Also:

Constant Field Values

RETRIES_IDX

public static final int RETRIES_IDX

See Also:

Constant Field Values

RETRY_LIMIT_IDX

public static final int RETRY_LIMIT_IDX

See Also:

Constant Field Values

RETRY_FACTOR_IDX

public static final int RETRY_FACTOR_IDX

See Also:

Constant Field Values

T_STAT_IDX

public static final int T_STAT_IDX

See Also:

Constant Field Values

T_STAT_MSG_IDX

public static final int T_STAT_MSG_IDX

See Also:

Constant Field Values

T_TIME_IDX

public static final int T_TIME_IDX

See Also:

Constant Field Values

SVC_NAME_IDX

public static final int SVC_NAME_IDX

See Also:

Constant Field Values

DOC_ID_IDX

public static final int DOC_ID_IDX

See Also:

Constant Field Values

PART_ID_IDX

public static final int PART_ID_IDX

See Also:

Constant Field Values

JOB_TYPE_IDX

public static final int JOB_TYPE_IDX

See Also:

Constant Field Values

SENDER_ID_IDX

public static final int SENDER_ID_IDX

See Also:

Constant Field Values

QUEUE_NAME_IDX

public static final int QUEUE_NAME_IDX

See Also:

Constant Field Values

VISIBLE_COLS

public static final java.lang.String[] VISIBLE_COLS

TIME_TYPE

public static final java.lang.String TIME_TYPE

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

TABLES_RIGHT

public static final java.lang.String[][] TABLES_RIGHT

Constructor Detail

DeliveryJobQuery

public DeliveryJobQuery()

Method Detail

setInternalDocId

public void setInternalDocId(java.lang.String id)

setJobId

public void setJobId(java.lang.String id)

setPartnerId

public void setPartnerId(java.lang.String id)

setPartnerId

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

setSenderId

public void setSenderId(java.lang.String id)

setQueueName

public void setQueueName(java.lang.String qName)

setQueueName

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

setServerId

public void setServerId(java.lang.String id)

setJobStatus

public void setJobStatus(java.lang.String status)

setJobStatus

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

setJobType

public void setJobType(java.lang.String type)

setJobType

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

setServiceName

public void setServiceName(java.lang.String name)

setServiceName

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

setTimeInterval

public void setTimeInterval(int which)

setTimeInterval

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

Overrides:

setTimeInterval in class Query

getInternalDocId

public java.lang.String getInternalDocId()

getJobId

public java.lang.String getJobId()

getJobType

public java.lang.Object getJobType()

getPartnerId

public java.lang.Object getPartnerId()

getSenderId

public java.lang.String getSenderId()

getQueueName

public java.lang.Object getQueueName()

getServerId

public java.lang.String getServerId()

getJobStatus

public java.lang.Object getJobStatus()

getServiceName

public java.lang.Object getServiceName()

getTimeInterval

public java.sql.Timestamp[] getTimeInterval()

getTimeIntervalType

public int getTimeIntervalType()

setServerIdVisible

public void setServerIdVisible(boolean b)

setTimeCreatedVisible

public void setTimeCreatedVisible(boolean b)

setTimeUpdatedVisible

public void setTimeUpdatedVisible(boolean b)

setJobStatusVisible

public void setJobStatusVisible(boolean b)

setTimeToWaitVisible

public void setTimeToWaitVisible(boolean b)

setRetriesVisible

public void setRetriesVisible(boolean b)

setRetryLimitVisible

public void setRetryLimitVisible(boolean b)

setRetryFactorVisible

public void setRetryFactorVisible(boolean b)

setTransportationStatusVisible

public void setTransportationStatusVisible(boolean b)

setStatusMessageVisible

public void setStatusMessageVisible(boolean b)

setTransportationTimeVisible

public void setTransportationTimeVisible(boolean b)

setServiceNameVisible

public void setServiceNameVisible(boolean b)

setInternalDocIdVisible

public void setInternalDocIdVisible(boolean b)

setPartnerIdVisible

public void setPartnerIdVisible(boolean b)

setJobTypeVisible

public void setJobTypeVisible(boolean b)

setSenderIdVisible

public void setSenderIdVisible(boolean b)

setQueueNameVisible

public void setQueueNameVisible(boolean b)

isJobIdVisible

public boolean isJobIdVisible()

isServerIdVisible

public boolean isServerIdVisible()

isTimeCreatedVisible

public boolean isTimeCreatedVisible()

isTimeUpdatedVisible

public boolean isTimeUpdatedVisible()

isJobStatusVisible

public boolean isJobStatusVisible()

isTimeToWaitVisible

public boolean isTimeToWaitVisible()

isRetriesVisible

public boolean isRetriesVisible()

isRetryLimitVisible

public boolean isRetryLimitVisible()

isRetryFactorVisible

public boolean isRetryFactorVisible()

isTransportationStatusVisible

public boolean isTransportationStatusVisible()

isStatusMessageVisible

public boolean isStatusMessageVisible()

isTransportationTimeVisible

public boolean isTransportationTimeVisible()

isServiceNameVisible

public boolean isServiceNameVisible()

isInternalDocIdVisible

public boolean isInternalDocIdVisible()

isPartnerIdVisible

public boolean isPartnerIdVisible()

isJobTypeVisible

public boolean isJobTypeVisible()

isSenderIdVisible

public boolean isSenderIdVisible()

isQueueNameVisible

public boolean isQueueNameVisible()

getVisibleColumns

public java.lang.String[] getVisibleColumns()

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: JOB_ID, SRV_ID, 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. {{TIMESTAMP, "ASC"}, {SENDERID, "DESC"}} )

getSortColumns

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

returns sort columns (may be null)

clearSortColumns

public void clearSortColumns()

Clear sort order

toPreDeleteSql

public java.lang.String toPreDeleteSql()

toDeletingSql

public java.lang.String toDeletingSql()

preSql

public void preSql()

For internal use only

Overrides:

preSql in class Query

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()

Specified by:

getIndexCursor in interface com.wm.data.IData

getTreeCursor

public com.wm.data.IDataTreeCursor getTreeCursor()

Specified by:

getTreeCursor in interface com.wm.data.IData

getHashCursor

public com.wm.data.IDataHashCursor getHashCursor()

Specified by:

getHashCursor in interface com.wm.data.IData

create

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

main

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