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

Class DAOSearchMicroclusterForComposition

java.lang.Object
overit.geocall.da.DAO
overit.geocallapp.wfm.core.bl.location.microcluster.data.DAOMicrocluster
overit.geocallapp.wfm.core.bl.location.microcluster.data.DAOSearchMicroclusterForComposition
All Implemented Interfaces:
Serializable, DataAttributesHolder, EDMConfigurableBean, overit.geocall.marks.FieldExposer, overit.geocall.marks.NameExposer, DBFieldMapper, DBObjectMapper, Tool
public class DAOSearchMicroclusterForComposition extends DAOMicrocluster
This is a specific DAO for extract available e/o occupied areas of a zone. Used in the Operation center composition mask
See Also:

  • 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 opeation center

    • SELECT_OCCUPIED_DETAILS

      public static final Command SELECT_OCCUPIED_DETAILS

    • SELECT_ALL

      public static final Command SELECT_ALL

    • PERIOD

      public static final String PERIOD
      See Also:

    • EQUAL_ZONE

      public static final String EQUAL_ZONE
      See Also:

    • DIFFERENT_ZONE

      public static final String DIFFERENT_ZONE
      See Also:

    • descriptionField

      protected String descriptionField

  • Constructor Details

    • DAOSearchMicroclusterForComposition

      public DAOSearchMicroclusterForComposition()

  • 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

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

    • 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

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

    • 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 Select getInnerQuery(CommandContext cc)

    • getAvailableInnerQuery

      protected Select getAvailableInnerQuery(CommandContext cc)

    • getOccupiedInnerQuery

      protected Select getOccupiedInnerQuery(CommandContext cc)

    • getCompleteInnerQuery

      protected Select getCompleteInnerQuery(CommandContext cc)

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