Package org.bgerp.dao.process

Class ProcessLinkSearchDAO

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

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

    • withType

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

    • order

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

    • withLinkObjectType

      public ProcessLinkSearchDAO withLinkObjectType(String value)
      Filter by link object type
      Parameters:
      value - the value
      Returns:

    • withLinkObjectTypeLike

      public ProcessLinkSearchDAO withLinkObjectTypeLike(String value)
      Filter by link object type using SQL LIKE
      Parameters:
      value - the LIKE pattern
      Returns:

    • withLinkObjectId

      public ProcessLinkSearchDAO withLinkObjectId(int value)
      Filter by link object ID.
      Parameters:
      value -
      Returns:

    • search

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

    • searchWithLinkObjectTypes

      public void searchWithLinkObjectTypes(Pageable<Pair<Process,String>> result) throws SQLException
      Queries processes together with link object types
      Parameters:
      result - pageable result throws SQLException
      Throws:
      SQLException

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

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