Package overit.geocallapp.wfm.ai.ux.predictivepartsmanagement.data

Class DAOPPMSearchMaterials

java.lang.Object

overit.geocall.da.DAO

overit.geocallapp.wfm.ai.ux.predictivepartsmanagement.data.DAOPPMSearchMaterials

All Implemented Interfaces:

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

@Pool("Pool")
@Factory("AWORID_ACOM")
public class DAOPPMSearchMaterials
extends DAO

DAO for search informations needed for PPartsManagementMonitor and for PPartsManagementDashboard

Since:

11.0

See Also:

• Serialized Form

Nested Class Summary

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 Command	SELECT_FOR_DASHBOARD

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

Method Summary

Modifier and Type	Method	Description
protected 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 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	getOutcomeDateClause(boolean isStartDate)
protected String	getSchedulingDateClause(boolean isStartDate)
String[]	getStar(CommandContext cc)	Returns the array that contains the field list for all the select queries.
String	getTable(CommandContext cc)	Returns the name of the table on which the specific DAO acts
boolean	isDistinct(CommandContext cc)	Returns the boolean value that determines whether the queries use the DISTINCT clause or not

Methods 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, isEncrypted, isService, markAsDecorated, query, query, scan, setDataAttributes, setDBFieldMap, setDBObjectMap, validate

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_FOR_DASHBOARD

public static final Command SELECT_FOR_DASHBOARD

Constructor Details

DAOPPMSearchMaterials

public DAOPPMSearchMaterials()

Method Details

getTable

public String getTable(CommandContext cc)

Description copied from class: DAO

Returns the name of the table on which the specific DAO acts

Overrides:

getTable in class DAO

Parameters:

cc - The CommandContext associated to the DAO

Returns:

The string that represents the name of the table on which the DAO want to access and operate

isDistinct

public boolean isDistinct(CommandContext cc)

Description copied from class: DAO

Returns the boolean value that determines whether the queries use the DISTINCT clause or not

Overrides:

isDistinct in class DAO

Parameters:

cc - The CommandContext associated to the DAO

Returns:

true if the queries use the DISTINCT, false otherwise

getStar

public String[] getStar(CommandContext cc)

Description copied from class: DAO

Returns the array that contains the field list for all the select queries.

Overrides:

getStar in class DAO

Parameters:

cc - The CommandContext associated 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 *

defineParams

protected 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

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.

getSchedulingDateClause

protected String getSchedulingDateClause(boolean isStartDate)

getOutcomeDateClause

protected String getOutcomeDateClause(boolean isStartDate)