Package overit.geocallapp.wfm.core.bl.datacollection.sheet.data

Class DAODataCollectionSheetExtendedSearch

java.lang.Object

overit.geocall.da.DAO

overit.geocallapp.wfm.mobileforms.bl.sheet.data.DAODataCollectionSheet

overit.geocallapp.wfm.core.bl.datacollection.sheet.data.DAODataCollectionSheetExtendedSearch

All Implemented Interfaces:

Serializable, DataAttributesHolder, EDMConfigurableBean, overit.geocall.marks.FieldExposer, overit.geocall.marks.NameExposer, DBFieldMapper, DBObjectMapper, Tool

@Order("ADSHCREATIONDATE DESC")
public class DAODataCollectionSheetExtendedSearch
extends DAODataCollectionSheet

DAO for the data collection sheet search.

Since:

12.0

See Also:

• Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from class overit.geocallapp.wfm.mobileforms.bl.sheet.data.DAODataCollectionSheet

DAODataCollectionSheet.Fields

Nested classes/interfaces inherited from class overit.geocall.da.DAO

DAO.Branch, DAO.Code, DAO.Distinct, DAO.Encrypt, DAO.Factory, DAO.Group, DAO.Level, DAO.Order, DAO.Pk, DAO.Pool, DAO.Sequence, DAO.Service, DAO.Star, DAO.Table, DAO.Transaction

Field Summary

Fields

Modifier and Type	Field	Description
static final String	ADSHCREATIONDATE_FROM
static final String	ADSHCREATIONDATE_TO
static final String	ADSHLASTMODIFIEDDATE_FROM
static final String	ADSHLASTMODIFIEDDATE_TO
static final String	ASSOCIATED_SCHEDULING_USER
static final String	ASSOCIATED_WO_OPERATION
static final String	AWORENDDATE_FROM
static final String	AWORENDDATE_TO
static final String	AWORSTARTDATE_FROM
static final String	AWORSTARTDATE_TO
protected static final Long	FILLED_IN
protected static final Long	NEVER_FILLED_IN
protected static final Long	PARTIALLY_FILLED_IN
protected static final Set<String>	TECHNICALOBJECT_FILTER_FIELDS
protected static final Set<String>	TEMPLATE_FILTER_FIELDS
static final Set<String>	WO_WOOPERATION_FILTER_FIELDS

Fields inherited from class overit.geocallapp.wfm.mobileforms.bl.sheet.data.DAODataCollectionSheet

TABLE

Fields inherited from class overit.geocall.da.DAO

_dbfm, _dbom, DELETE_FILTER, DELETE_PK, INSATE, INSERT, INSERT_ATTEMPT, SELECT_FILTER, SELECT_NONE, SELECT_PK, UPDATE_FILTER, UPDATE_PK, UPSERT, V_LEVEL_ENABLED

Constructor Summary

Constructors

Constructor	Description
DAODataCollectionSheetExtendedSearch()

Method Summary

Modifier and Type	Method	Description
protected boolean	areThereFiltersOnSet(CommandContext cc, Set<String> filtersFields)
protected void	defineSql(CommandContext cc, PoolKit pk)	The method creates the SQL command using the language of the criteria, and in particular based on the method DAO.getFilterCriterion(overit.geocall.da.CommandContext)
protected Clause	getAddressClause(String field)
protected String	getAssociatedSchedulingUserClause(CommandContext cc)
protected String	getAssociatedWOOperationClause(CommandContext cc)
protected String	getFilledInClause(CommandContext cc)
Criterion	getFilterCriterion(CommandContext cc)	Method to extend to go to introduce the inferential rules with which to deduce the SQL automatically based on the context passed as a parameter.
protected String	getNeverFilledInClause(CommandContext cc)
protected String	getPartiallyFilledInClause(CommandContext cc)
protected Clause	getTechnicalObjectClause(String field, String operator)
protected void	technicalObjectWOFilter(CommandContext cc, Select select)
protected void	templateFilter(CommandContext cc, Select select)
protected void	validate(CommandContext cc, PoolKit pk)	Method to extend if you want to implement some logic of data validation; it can raise a DAException, or better, a DAValidateException.

Methods inherited from class overit.geocall.da.DAO

command, command, commandForName, defineParams, defineStatement, defineValues, execute, execute, execute, execute, feedback, getBranch, getCode, getDataAttributes, getDBFieldMap, getDBObjectMap, getEncrypt, getFactory, getGroup, getLevel, getOrder, getPk, getPool, getSequence, getStar, getTable, getTeacher, getTransaction, getValuesCriterion, hasNotBeenDecorated, haveDBFieldMap, haveDBObjectMap, isDistinct, isEncrypted, isService, markAsDecorated, query, query, scan, setDataAttributes, setDBFieldMap, setDBObjectMap

Methods inherited from class java.lang.Object

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

Methods inherited from interface overit.geocall.edm.model.DataAttributesHolder

getEntities

Methods inherited from interface overit.geocall.edm.model.EDMConfigurableBean

getEntity, hasEntity

Field Details

ASSOCIATED_WO_OPERATION

public static final String ASSOCIATED_WO_OPERATION

See Also:

• Constant Field Values

ASSOCIATED_SCHEDULING_USER

public static final String ASSOCIATED_SCHEDULING_USER

See Also:

• Constant Field Values

AWORSTARTDATE_FROM

public static final String AWORSTARTDATE_FROM

See Also:

• Constant Field Values

AWORSTARTDATE_TO

public static final String AWORSTARTDATE_TO

See Also:

• Constant Field Values

AWORENDDATE_FROM

public static final String AWORENDDATE_FROM

See Also:

• Constant Field Values

AWORENDDATE_TO

public static final String AWORENDDATE_TO

See Also:

• Constant Field Values

ADSHCREATIONDATE_FROM

public static final String ADSHCREATIONDATE_FROM

See Also:

• Constant Field Values

ADSHCREATIONDATE_TO

public static final String ADSHCREATIONDATE_TO

See Also:

• Constant Field Values

ADSHLASTMODIFIEDDATE_FROM

public static final String ADSHLASTMODIFIEDDATE_FROM

See Also:

• Constant Field Values

ADSHLASTMODIFIEDDATE_TO

public static final String ADSHLASTMODIFIEDDATE_TO

See Also:

• Constant Field Values

NEVER_FILLED_IN

protected static final Long NEVER_FILLED_IN

PARTIALLY_FILLED_IN

protected static final Long PARTIALLY_FILLED_IN

FILLED_IN

protected static final Long FILLED_IN

TECHNICALOBJECT_FILTER_FIELDS

protected static final Set<String> TECHNICALOBJECT_FILTER_FIELDS

TEMPLATE_FILTER_FIELDS

protected static final Set<String> TEMPLATE_FILTER_FIELDS

WO_WOOPERATION_FILTER_FIELDS

public static final Set<String> WO_WOOPERATION_FILTER_FIELDS

Constructor Details

DAODataCollectionSheetExtendedSearch

public DAODataCollectionSheetExtendedSearch()

Method Details

validate

protected void validate(CommandContext cc,
 PoolKit pk)
                 throws DAException,
DAValidateException

Description copied from class: DAO

Method to extend if you want to implement some logic of data validation; it can raise a DAException, or better, a DAValidateException. By default the method verifies that, if the command requested is a command that refers to a key field, that key field has been defined for the DAO and that the key field is among those passed as filter.

Overrides:

validate in class DAO

Parameters:

cc - The CommandContext associated to the DAO

pk - The PoolKit from which extract the connections

Throws:

DAException - If there is a (blocking) data-access error, a DAException must be thrown

DAValidateException - If there are error in the validation phase, a DAValidateException must be thrown

getFilterCriterion

public Criterion getFilterCriterion(CommandContext cc)

Description copied from class: DAO

Method to extend to go to introduce the inferential rules with which to deduce the SQL automatically based on the context passed as a parameter.

Overrides:

getFilterCriterion in class DAODataCollectionSheet

Parameters:

cc - The CommandContext associated to the DAO

Returns:

The Criterion used to create the SQL By default the method returns the Criteria.SEARCH_STRONG for the commands that refers to key fields and the Criteria.SEARCH for all the other commands.

getAssociatedWOOperationClause

protected String getAssociatedWOOperationClause(CommandContext cc)

getAssociatedSchedulingUserClause

protected String getAssociatedSchedulingUserClause(CommandContext cc)

getFilledInClause

protected String getFilledInClause(CommandContext cc)

getPartiallyFilledInClause

protected String getPartiallyFilledInClause(CommandContext cc)

getNeverFilledInClause

protected String getNeverFilledInClause(CommandContext cc)

defineSql

protected void defineSql(CommandContext cc,
 PoolKit pk)
                  throws DAException,
DAValidateException

Description copied from class: DAO

The method creates the SQL command using the language of the criteria, and in particular based on the method DAO.getFilterCriterion(overit.geocall.da.CommandContext)

Overrides:

defineSql in class DAO

Parameters:

cc - The CommandContext associated to the DAO

pk - The PoolKit from which extract the connections

Throws:

DAException - If there is a (blocking) data-access error, a DAException must be thrown

DAValidateException - If there are error in the validation phase, a DAValidateException must be thrown

technicalObjectWOFilter

protected void technicalObjectWOFilter(CommandContext cc,
 Select select)

templateFilter

protected void templateFilter(CommandContext cc,
 Select select)

getTechnicalObjectClause

protected Clause getTechnicalObjectClause(String field,
 String operator)

getAddressClause

protected Clause getAddressClause(String field)

areThereFiltersOnSet

protected boolean areThereFiltersOnSet(CommandContext cc,
 Set<String> filtersFields)