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

Class DAOPPartsManagementSearch

java.lang.Object
overit.geocall.da.DAO
overit.geocallapp.wfm.ai.bl.predictivepartsmanagement.data.DAOPPartsManagement
overit.geocallapp.wfm.ai.bl.predictivepartsmanagement.data.DAOPPartsManagementSearch
All Implemented Interfaces:
Serializable, DataAttributesHolder, EDMConfigurableBean, overit.geocall.marks.FieldExposer, overit.geocall.marks.NameExposer, DBFieldMapper, DBObjectMapper, Tool
public class DAOPPartsManagementSearch extends DAOPPartsManagement
DAO for search attributes between the tables AAIPARTSMANAGEMENT, RWOOMATERIAL, AWWOPERATION, AMATERIAL. If you select operations you will receive all the info you need to work with operations. If you select materials you will receive all the info you need to work with materials.
Since:
11.0
See Also:

  • Field Details

    • SELECT_OPERATIONS

      public static final Command SELECT_OPERATIONS

    • SELECT_OPERATIONS_MONITOR

      public static final Command SELECT_OPERATIONS_MONITOR

    • SELECT_MATERIALS

      public static final Command SELECT_MATERIALS

    • SELECT_MATERIALS_SHIFT

      public static final Command SELECT_MATERIALS_SHIFT

    • NO_ZERO_VALUES

      public static final String NO_ZERO_VALUES
      See Also:

    • workOrderOperationFields

      protected String workOrderOperationFields

  • Constructor Details

    • DAOPPartsManagementSearch

      public DAOPPartsManagementSearch()

  • 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

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

    • 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

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

    • defineValues

      protected void defineValues(CommandContext cc, PoolKit pk) throws DAException, DAValidateException
      Description copied from class: DAO
      Method to extend to go to prepare the values operating Java side, for example making calculations, avoiding to operate SQL side that is much more difficult, inconvenient, difficult to maintain and not portable. Changing the values in this method can have a return in the application mask, since the same map of values is used, and not a clone of it. By default the method sets the correct values for the sequence, the datastamp and login, where necessary.
      Overrides:
      defineValues 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

    • getOperationStatus

      protected LongSet getOperationStatus()

    • 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

    • getNoZeroPredValues

      protected String getNoZeroPredValues()

    • getFilterCriterion

      public Criteria 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 DAOPPartsManagement
      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.