Package org.bgerp.dao.process

Class ProcessSearchDAO

java.lang.Object
ru.bgcrm.dao.CommonDAO
org.bgerp.dao.process.ProcessSearchDAO
Direct Known Subclasses:
ProcessLinkProcessSearchDAO
public class ProcessSearchDAO extends CommonDAO
Fluent process search DAO.

  • 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 ProcessSearchDAO withOpen(Boolean value)
      Filter by process closing date
      Parameters:
      value - null - no filter, or process closing date is not null
      Returns:

    • withType

      public ProcessSearchDAO withType(Set<Integer> value)
      Filter by process type ID
      Parameters:
      value - null or empty - no filter, or set with type IDs
      Returns:

    • withStatus

      public ProcessSearchDAO withStatus(Set<Integer> values)
      Filter by process status ID
      Parameters:
      values - null or empty - no filter, or set with status IDs
      Returns:

    • withExecutor

      public ProcessSearchDAO withExecutor(Set<Integer> values)
      Filter by process executors
      Parameters:
      values - null or empty - no filter, or set with executor user IDs
      Returns:

    • withoutId

      public ProcessSearchDAO withoutId(Set<Integer> values)
      Excluded process IDs
      Parameters:
      values - the process IDs
      Returns:

    • withIdOrDescriptionLike

      public ProcessSearchDAO withIdOrDescriptionLike(String value)
      SQL LIKE expression for id or description.
      Parameters:
      value - the LIKE expression.
      Returns:

    • order

      public ProcessSearchDAO order(Order value)
      Selection order.
      Parameters:
      value - enum value.
      Returns:

    • search

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

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