Package com.avoka.fc.core.dao

Class SubmissionExtractDataDao

java.lang.Object

com.avoka.core.dao.BaseDao

com.avoka.fc.core.dao.AbstractDao

com.avoka.fc.core.dao.SubmissionExtractDataDao

public class SubmissionExtractDataDao
extends AbstractDao

Provides a DAO for the SubmissionExtractData.

See Also:

• SubmissionExtractData

Field Summary

Fields

Modifier and Type	Field	Description
static final String	DELETED_FLAG	The "deleted_flag" map parameter name.
static final String	DEVICE_TYPE	The "device_type" map parameter name.
static final String	FORM_STATUS	The "form_status" map parameter name.
static final String	JSON_DATA	The "json_data" map parameter name.
static final String	RECEIPT_NUMBER	The "receipt_number" map parameter name.
static final String	SUBMISSION_OID	The "submission_oid" map parameter name.
static final String	SUBMIT_KEY	The "submit_key" map parameter name.
static final String	TIME_SUBMISSION	The "time_submission" map parameter name.
static final String	TRACKING_CODE	The "tracking_code" map parameter name.

Fields inherited from class com.avoka.core.dao.BaseDao

FETCH_LIMIT, STATEMENT_MAX_NO_PARAMETERS

Constructor Summary

Constructors

Constructor	Description
SubmissionExtractDataDao()

Method Summary

Modifier and Type	Method	Description
List<Map<String,Object>>	getSubmissionExtractData(TemplateVersion version, Date startDate, Date endDate, boolean oldestFirst)	Returns the submission extract data map based on the template version
List<Map<String,Object>>	getSubmissionExtractData(TemplateVersion version, Set<String> formStatusValues, Date startDate, Date endDate, boolean oldestFirst)	Return the submission data extract maps (one map per submission containing all data extract key-value pairs as well as some submission information) for a template version, filtered by submission form status and a time period.
List<String>	getSubmissionExtractDataNames(SchemaSeed schemaSeed)	Returns the submission extract data column names for UI table.

Methods inherited from class com.avoka.fc.core.dao.AbstractDao

andFilterClientExcludeNull, andFilterClientIncludeNull, andFilterClientOnly, isClientAccessAllowed, performQueryConfigCached

Methods inherited from class com.avoka.core.dao.BaseDao

addOrdering, addOrderingCaseInsensitive, addOrderingCaseSensitive, andQueryBetween, andQueryInExp, andQueryInExp, andQueryLikeIgnoreCaseExp, andQueryMatchDbExp, andQueryMatchExp, andQueryMatchIsNotNull, andQueryMatchIsNull, andQueryNoMatchExp, andQueryNotTrue, deleteObject, deleteObjects, findObject, getDataContext, getFetchLimit, getLogger, getObjectForPK, newObject, orQueryLikeIgnoreCaseExp, orQueryMatchExp, performNamedQuery, performNamedQuery, performNamedQuery, performNamedQuery, performNonSelectingQuery, performNonSelectingQuery, performNonSelectingQuery, performNonSelectingQuery, performQuery, performQuery, performQuery, registerNewObject, setCacheStrategy, setFetchLimit, setLocalCacheStrategy, setLocalCacheStrategy, setSharedCacheStrategy, toMap, toMap

Methods inherited from class java.lang.Object

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

Field Details

DELETED_FLAG

public static final String DELETED_FLAG

The "deleted_flag" map parameter name.

See Also:

• Constant Field Values

SUBMIT_KEY

public static final String SUBMIT_KEY

The "submit_key" map parameter name.

See Also:

• Constant Field Values

SUBMISSION_OID

public static final String SUBMISSION_OID

The "submission_oid" map parameter name.

See Also:

• Constant Field Values

TIME_SUBMISSION

public static final String TIME_SUBMISSION

The "time_submission" map parameter name.

See Also:

• Constant Field Values

TRACKING_CODE

public static final String TRACKING_CODE

The "tracking_code" map parameter name.

See Also:

• Constant Field Values

RECEIPT_NUMBER

public static final String RECEIPT_NUMBER

The "receipt_number" map parameter name.

See Also:

• Constant Field Values

FORM_STATUS

public static final String FORM_STATUS

The "form_status" map parameter name.

See Also:

• Constant Field Values

DEVICE_TYPE

public static final String DEVICE_TYPE

The "device_type" map parameter name.

See Also:

• Constant Field Values

JSON_DATA

public static final String JSON_DATA

The "json_data" map parameter name.

See Also:

• Constant Field Values

Constructor Details

SubmissionExtractDataDao

public SubmissionExtractDataDao()

Method Details

getSubmissionExtractDataNames

public List<String> getSubmissionExtractDataNames(SchemaSeed schemaSeed)

Returns the submission extract data column names for UI table.

Parameters:

schemaSeed - the schema seed

Returns:

the submission extract data names

getSubmissionExtractData

public List<Map<String,Object>> getSubmissionExtractData(TemplateVersion version,
 Date startDate,
 Date endDate,
 boolean oldestFirst)

Returns the submission extract data map based on the template version

Parameters:

version - the template version (required)

startDate - the start date

endDate - the end date

oldestFirst - whether to sort ascending or descending by age (submission OID)

Returns:

the submission extract data map

getSubmissionExtractData

public List<Map<String,Object>> getSubmissionExtractData(TemplateVersion version,
 Set<String> formStatusValues,
 Date startDate,
 Date endDate,
 boolean oldestFirst)

Return the submission data extract maps (one map per submission containing all data extract key-value pairs as well as some submission information) for a template version, filtered by submission form status and a time period. Note: this query filters extract data if their "deleted_flag" is set to 1.

Parameters:

version - the form version (required)

formStatusValues - the set of form status values to filter on (will be used only if at least one value was specified)

startDate - the start date to filter on (optional)

endDate - the end date to filter on (optional)

oldestFirst - whether to return older results (as determined by database OID) first, or last

Returns:

the list of matching extract data values maps

Since:

4.1.0