Class ProcessParamSearchDAO

java.lang.Object
ru.bgcrm.dao.CommonDAO
org.bgerp.dao.process.ProcessParamSearchDAO
public class ProcessParamSearchDAO extends CommonDAO
Fluent DAO for selection processes by parameter values.

  • Field Details

    • form

      protected final DynActionForm form
      User request context for isolations

    • executorIds

      protected Set<Integer> executorIds

    • excludeIds

      protected Set<Integer> excludeIds

    • idOrDescriptionLike

      protected String idOrDescriptionLike

  • Constructor Details

  • Method Details

    • withOpen

      public ProcessParamSearchDAO withOpen(Boolean value)
      Filter by process closing date
      Parameters:
      value - null - no filter, or process closing date is not null
      Returns:

    • withParamTextIds

      public ProcessParamSearchDAO withParamTextIds(Set<Integer> values)

    • withParamTextValue

      public ProcessParamSearchDAO withParamTextValue(String value)

    • search

      public void search(Pageable<ParameterSearchedObject<Process>> result) throws SQLException
      Queries processes with param values.
      Parameters:
      result - pageable result.
      Throws:
      SQLException

    • withType

      protected org.bgerp.dao.process.SearchDAO withType(Set<Integer> values)
      Filter by process type ID
      Parameters:
      values - null or empty - no filter, or set with type IDs
      Returns:

    • withStatus

      protected org.bgerp.dao.process.SearchDAO withStatus(Set<Integer> values)
      Filter by process status ID
      Parameters:
      values - null or empty - no filter, or set with status IDs
      Returns:

    • withExecutor

      protected org.bgerp.dao.process.SearchDAO withExecutor(Set<Integer> values)
      Filter by process executors
      Parameters:
      values - null or empty - no filter, or set with executor user IDs
      Returns:

    • withoutId

      protected org.bgerp.dao.process.SearchDAO withoutId(Set<Integer> values)
      Excluded process IDs
      Parameters:
      values - the process IDs
      Returns:

    • withIdOrDescriptionLike

      protected org.bgerp.dao.process.SearchDAO withIdOrDescriptionLike(String value)
      SQL LIKE expression for id or description.
      Parameters:
      value - the LIKE expression.
      Returns:

    • order

      protected org.bgerp.dao.process.SearchDAO order(Order value)
      Selection order.
      Parameters:
      value - enum value.
      Returns:

    • filterOpen

      protected void filterOpen(PreparedQuery pq)

    • filterType

      protected void filterType(PreparedQuery pq)

    • filterStatus

      protected void filterStatus(PreparedQuery pq)

    • filterExecutor

      protected void filterExecutor(PreparedQuery pq)

    • filterId

      protected void filterId(PreparedQuery pq)

    • filterIdOrDescriptionLike

      protected void filterIdOrDescriptionLike(PreparedQuery pq)

    • order

      protected void order(PreparedQuery pq)