Package overit.geocallapp.wfm.workorders.bl.workload.data

Class DAOWorkLoad

java.lang.Object
overit.geocall.da.DAO
overit.geocallapp.wfm.workorders.bl.header.data.DAOWorkOrderHeader
overit.geocallapp.wfm.workorders.bl.workload.data.DAOWorkLoad
All Implemented Interfaces:
Serializable, DataAttributesHolder, EDMConfigurableBean, overit.geocall.marks.FieldExposer, overit.geocall.marks.NameExposer, DBFieldMapper, DBObjectMapper, Tool
Direct Known Subclasses:
DAOWorkLoadDetail
public class DAOWorkLoad extends DAOWorkOrderHeader
DAO for work load.
Since:
19.0
See Also:

  • Field Details

    • WORKLOADDISTRIBUTIONTYPE

      public static final String WORKLOADDISTRIBUTIONTYPE
      See Also:

    • WORK_LOAD_DISTRIBUTION_TYPE_SCHEDULED

      public static final String WORK_LOAD_DISTRIBUTION_TYPE_SCHEDULED
      See Also:

    • WORK_LOAD_OPERATION_TYPE_URGENCY_GROUPING

      public static final String WORK_LOAD_OPERATION_TYPE_URGENCY_GROUPING
      See Also:

    • WORK_LOAD_ADDITIONAL_SCHEDULED_FILTERS_REQUESTED

      public static final String WORK_LOAD_ADDITIONAL_SCHEDULED_FILTERS_REQUESTED
      See Also:

  • Constructor Details

    • DAOWorkLoad

      public DAOWorkLoad()

  • Method Details

    • defineParams

      protected void defineParams(CommandContext cc, PoolKit poolKit) 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
      poolKit - 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

    • 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

    • 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 *

    • addSelectFields

      protected void addSelectFields(ArrayList<String> fields, CommandContext cc)

    • 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 DAOWorkOrderHeader
      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.

    • getWorkLoadDistributionClause

      protected String getWorkLoadDistributionClause()

    • getGroup

      public String[] getGroup(CommandContext cc)
      Description copied from class: DAO
      Returns the array that contains the names of the columns on which we want to group the reults of the queries.
      Overrides:
      getGroup in class DAO
      Parameters:
      cc - The CommandContext associated to the DAO
      Returns:
      The array of strings that represents the name of the columns used for the grouping of the results of the queries

    • isWorkLoadOperationTypeUrgencyGrouping

      protected boolean isWorkLoadOperationTypeUrgencyGrouping(CommandContext cc)

    • areAdditionalScheduledFiltersRequested

      protected boolean areAdditionalScheduledFiltersRequested(CommandContext cc)

    • getOrder

      public String[] getOrder(CommandContext cc)
      Description copied from class: DAO
      Returns the array that contains the names of the columns on which we want to make the sorting of the results of the queries.
      The method checks for the presence of a sort string in the CommandContext, the one returned by the CommandContext.getOrder() method; the default implementation interprets the string as a comma-separated list of field names on which you want to sort query results. The presence of the exclamation point in front of a field name defines the will to order in a descending direction with respect to that field.
      The extensions of this method can define their own grammar for the received string.
      If there is no sort string in the CommandContext, the fields are searched using the annotation Group
      Overrides:
      getOrder in class DAO
      Parameters:
      cc - The {CommandContext} associated to the DAO
      Returns:
      The array of strings that represents the name of the columns, and the corresponding sorting verse, used for the sorting of the results of the queries;

    • 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

    • getWorkloadOperationTypeUrgencyTables

      protected String getWorkloadOperationTypeUrgencyTables()