Package overit.geocallapp.wfm.core.bl.location.microcluster.data

Class DAOSearchMicroclusterForSchedulingAreas

java.lang.Object

overit.geocall.da.DAO

overit.geocallapp.wfm.core.bl.location.microcluster.data.DAOMicrocluster

overit.geocallapp.wfm.core.bl.location.microcluster.data.DAOSearchMicroclusterForSchedulingAreas

All Implemented Interfaces:

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

public class DAOSearchMicroclusterForSchedulingAreas
extends DAOMicrocluster

This is a specific DAO for extract available e/o occupied microclusters for a scheduling area

See Also:

• Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from class overit.geocallapp.wfm.core.bl.location.microcluster.data.DAOMicrocluster

DAOMicrocluster.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	SCHEDULING_AREA_ID
static final String	SCHEDULING_AREA_NOT_ID
static final Command	SELECT_ALL	Get all the macroclusters, assigned or not to the linked area
static final Command	SELECT_AVAILABLE	Get all the available macroclusters
static final Command	SELECT_AVAILABLE_DETAILS
static final Command	SELECT_OCCUPIED	Get the assigned macroclusters to the linked area
static final Command	SELECT_OCCUPIED_DETAILS
static final String	ZONE_LIST

Fields inherited from class overit.geocallapp.wfm.core.bl.location.microcluster.data.DAOMicrocluster

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

Method Summary

Modifier and Type	Method	Description
void	defineParams(CommandContext cc, PoolKit pk)	The method performs a cloning of the maps of the filters and of the values and makes a merge, putting before the filter field names the string F: and before the value field names the string V: to avoid possible conflicts; this is necessary because the same field can be used with different semantics, as a filter and as a value, for example for the DAO.UPDATE_FILTER commands
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 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 Fragment	getInnerQuery(CommandContext cc)
protected String	getZonesSubquery(LongSet zones)
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, 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

SELECT_AVAILABLE

public static final Command SELECT_AVAILABLE

Get all the available macroclusters

SELECT_AVAILABLE_DETAILS

public static final Command SELECT_AVAILABLE_DETAILS

SELECT_OCCUPIED

public static final Command SELECT_OCCUPIED

Get the assigned macroclusters to the linked area

SELECT_OCCUPIED_DETAILS

public static final Command SELECT_OCCUPIED_DETAILS

SELECT_ALL

public static final Command SELECT_ALL

Get all the macroclusters, assigned or not to the linked area

SCHEDULING_AREA_ID

public static final String SCHEDULING_AREA_ID

See Also:

• Constant Field Values

SCHEDULING_AREA_NOT_ID

public static final String SCHEDULING_AREA_NOT_ID

See Also:

• Constant Field Values

ZONE_LIST

public static final String ZONE_LIST

See Also:

• Constant Field Values

Constructor Details

DAOSearchMicroclusterForSchedulingAreas

public DAOSearchMicroclusterForSchedulingAreas()

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

defineParams

public void defineParams(CommandContext cc,
 PoolKit pk)
                  throws DAException,
DAValidateException

Description copied from class: DAO

The method performs a cloning of the maps of the filters and of the values and makes a merge, putting before the filter field names the string F: and before the value field names the string V: to avoid possible conflicts; this is necessary because the same field can be used with different semantics, as a filter and as a value, for example for the DAO.UPDATE_FILTER commands

Overrides:

defineParams 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

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

getInnerQuery

protected Fragment getInnerQuery(CommandContext cc)

getZonesSubquery

protected String getZonesSubquery(LongSet zones)

getFilterCriterion

protected 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 DAO

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.