Package overit.geocallapp.wfm.inventory.bl.warehouse.materialstock.data

Class DAOWarehouseMaterialStockSearch

java.lang.Object
overit.geocall.da.DAO
overit.geocallapp.wfm.inventory.bl.warehouse.materialstock.data.DAOWarehouseMaterialStockSearch
All Implemented Interfaces:
Serializable, DataAttributesHolder, EDMConfigurableBean, overit.geocall.marks.FieldExposer, overit.geocall.marks.NameExposer, DBFieldMapper, DBObjectMapper, Tool
@Pool("Pool") @Factory("AMATID_ACOM") public class DAOWarehouseMaterialStockSearch extends DAO
DAO for warehouse material stock search.
Since:
13.0
See Also:

  • Field Details

  • Constructor Details

    • DAOWarehouseMaterialStockSearch

      public DAOWarehouseMaterialStockSearch()

  • 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

    • 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

    • 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

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

    • defineStatement

      protected void defineStatement(CommandContext cc, PoolKit pk, DBStatement dbs) throws DAException, DAValidateException
      Description copied from class: DAO
      The method defines the DBStatement, sets the SQL and the parameters for the execution of the commands
      Overrides:
      defineStatement in class DAO
      Parameters:
      cc - The CommandContext associated to the DAO
      pk - The PoolKit from which extract the connections
      dbs - The DBStatement that is used to access the database
      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

      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

    • getGroupByFields

      protected List<String> getGroupByFields(CommandContext cc)

    • getHaving

      protected String getHaving(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;

    • getOrderByFields

      protected List<String> getOrderByFields(CommandContext cc)