Class DAOForecastResourceDetailAvailableCapacityResourceSearch

java.lang.Object
overit.geocall.da.DAO
overit.geocallapp.wfm.forecastcapacity.bl.forecast.resource.detail.data.DAOForecastResourceDetail
overit.geocallapp.wfm.forecastcapacity.bl.forecast.resource.detail.data.DAOForecastResourceDetailAvailableCapacityResourceSearch
All Implemented Interfaces:
Serializable, DataAttributesHolder, EDMConfigurableBean, overit.geocall.marks.FieldExposer, overit.geocall.marks.NameExposer, DBFieldMapper, DBObjectMapper, Tool

public class DAOForecastResourceDetailAvailableCapacityResourceSearch extends DAOForecastResourceDetail
DAO to Search forecast resource detail available capacity.
Since:
19.0
See Also:
  • Field Details

    • SELECT_DAILY

      public static final Command SELECT_DAILY
    • SELECT_WEEKLY

      public static final Command SELECT_WEEKLY
    • SELECT_MONTHLY

      public static final Command SELECT_MONTHLY
    • SELECT_SKILL

      public static final Command SELECT_SKILL
    • SELECT_RESOURCE

      public static final Command SELECT_RESOURCE
  • Constructor Details

    • DAOForecastResourceDetailAvailableCapacityResourceSearch

      public DAOForecastResourceDetailAvailableCapacityResourceSearch()
  • 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
    • addSelectDailyFields

      protected void addSelectDailyFields(ArrayList<String> fields, CommandContext cc)
    • addSelectWeeklyFields

      protected void addSelectWeeklyFields(ArrayList<String> fields, CommandContext cc)
    • addSelectMonthlyFields

      protected void addSelectMonthlyFields(ArrayList<String> fields, CommandContext cc)
    • addSelectSkillFields

      protected void addSelectSkillFields(ArrayList<String> fields, CommandContext cc)
    • addSelectResourceFields

      protected void addSelectResourceFields(ArrayList<String> fields, CommandContext cc)
    • addSelectCommonFields

      protected void addSelectCommonFields(ArrayList<String> fields, CommandContext cc)
    • 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 *
    • 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
    • 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 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.
    • 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