Class DAOForecastActivityGanttSearch
java.lang.Object
overit.geocall.da.DAO
overit.geocallapp.wfm.forecastcapacity.bl.forecast.activity.forecastactivity.data.DAOForecastActivity
overit.geocallapp.wfm.forecastcapacity.bl.forecast.activity.forecastactivity.data.DAOForecastActivitySearch
overit.geocallapp.wfm.forecastcapacity.bl.forecast.activity.forecastactivity.data.DAOForecastActivityGanttSearch
- All Implemented Interfaces:
Serializable,DataAttributesHolder,EDMConfigurableBean,overit.geocall.marks.FieldExposer,overit.geocall.marks.NameExposer,DBFieldMapper,DBObjectMapper,Tool
DAO for search forecast activity for the gantt view.
- Since:
- 19.0
- See Also:
-
Nested Class Summary
Nested classes/interfaces inherited from class overit.geocallapp.wfm.forecastcapacity.bl.forecast.activity.forecastactivity.data.DAOForecastActivity
DAOForecastActivity.FieldsNested 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
FieldsFields inherited from class overit.geocallapp.wfm.forecastcapacity.bl.forecast.activity.forecastactivity.data.DAOForecastActivity
TABLEFields 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 -
Method Summary
Modifier and TypeMethodDescriptionprotected voiddefineParams(CommandContext cc, PoolKit poolKit) 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 theDAO.UPDATE_FILTERcommandsprotected StringgetDateFromClause(CommandContext cc, String field) Builds the SQL clause for filtering by a "from date" condition on a given fieldprotected StringgetDateToClause(CommandContext cc, String field) Builds the SQL clause for filtering by a "to date" condition on a given fieldprotected StringMethod 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 StringgetGroupingConstraintDetailClause(Collection<Long> groupingConstraint) Builds the SQL clause for filtering by grouping constraint idsprotected StringgetPriorityDetailClause(Collection<Long> priorities) Builds the SQL clause for filtering by priority idsString[]Returns the array that contains the field list for all the select queries.Returns the name of the table on which the specific DAO actsMethods inherited from class overit.geocallapp.wfm.forecastcapacity.bl.forecast.activity.forecastactivity.data.DAOForecastActivitySearch
validateMethods inherited from class overit.geocall.da.DAO
command, command, commandForName, defineSql, defineStatement, defineValues, execute, execute, execute, execute, feedback, getBranch, getCode, getDataAttributes, getDBFieldMap, getDBObjectMap, getEncrypt, getFactory, getGroup, getLevel, getOrder, getPk, getPool, getSequence, getTeacher, getTransaction, getValuesCriterion, hasNotBeenDecorated, haveDBFieldMap, haveDBObjectMap, isDistinct, isEncrypted, isService, markAsDecorated, query, query, scan, setDataAttributes, setDBFieldMap, setDBObjectMapMethods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitMethods inherited from interface overit.geocall.edm.model.DataAttributesHolder
getEntitiesMethods inherited from interface overit.geocall.edm.model.EDMConfigurableBean
getEntity, hasEntity
-
Field Details
-
DETAIL_CLAUSE
- See Also:
-
-
Constructor Details
-
DAOForecastActivityGanttSearch
public DAOForecastActivityGanttSearch()
-
-
Method Details
-
defineParams
protected void defineParams(CommandContext cc, PoolKit poolKit) throws DAException, DAValidateException Description copied from class:DAOThe 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 theDAO.UPDATE_FILTERcommands- Overrides:
defineParamsin classDAO- Parameters:
cc- TheCommandContextassociated to the DAOpoolKit- ThePoolKitfrom which extract the connections- Throws:
DAException- If there is a (blocking) data-access error, a DAException must be thrownDAValidateException- If there are error in the validation phase, a DAValidateException must be thrown
-
getStar
Description copied from class:DAOReturns the array that contains the field list for all the select queries.- Overrides:
getStarin classDAO- Parameters:
cc- TheCommandContextassociated to the DAO- Returns:
- The array of strings that represents the names of the columns to be extracted;
the default value is the array consisting of a single element, the character
*
-
getTable
Description copied from class:DAOReturns the name of the table on which the specific DAO acts- Overrides:
getTablein classDAO- Parameters:
cc- TheCommandContextassociated to the DAO- Returns:
- The string that represents the name of the table on which the DAO want to access and operate
-
getFilterCriterion
Description copied from class:DAOMethod 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:
getFilterCriterionin classDAOForecastActivitySearch- Parameters:
cc- TheCommandContextassociated to the DAO- Returns:
- The
Criterionused to create the SQL By default the method returns theCriteria.SEARCH_STRONGfor the commands that refers to key fields and theCriteria.SEARCHfor all the other commands.
-
getDetailDecision
-
getPriorityDetailClause
Builds the SQL clause for filtering by priority ids- Parameters:
priorities- Collection of priority ids to filter by- Returns:
- SQL clause string for priority filtering
-
getGroupingConstraintDetailClause
Builds the SQL clause for filtering by grouping constraint ids- Parameters:
groupingConstraint- Collection of grouping constraint ids to filter by- Returns:
- SQL clause string for grouping constraint filtering
-
getDateFromClause
Builds the SQL clause for filtering by a "from date" condition on a given field- Parameters:
cc- Command context containing the parametersfield- Name of the date field to filter on- Returns:
- SQL clause string for "from date" filtering
-
getDateToClause
Builds the SQL clause for filtering by a "to date" condition on a given field- Parameters:
cc- Command context containing the parametersfield- Name of the date field to filter on- Returns:
- SQL clause string for "to date" filtering
-