Package org.bgerp.dao.process
Class ProcessLinkSearchDAO
java.lang.Object
ru.bgcrm.dao.CommonDAO
org.bgerp.dao.process.ProcessLinkSearchDAO
Fluent DAO for selection processes by links.
-
Nested Class Summary
Nested classes/interfaces inherited from class ru.bgcrm.dao.CommonDAO
CommonDAO.ObjectExtractor<T>, CommonDAO.RecordUpdater<T extends Id>
-
Field Summary
Modifier and TypeFieldDescriptionprotected final DynActionForm
User request context for isolations.Fields inherited from class ru.bgcrm.dao.CommonDAO
con, log, SQL_AND, SQL_DELETE, SQL_DELETE_FROM, SQL_DESC, SQL_DISTINCT, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT, SQL_INSERT_IGNORE, SQL_INSERT_INTO, SQL_LEFT_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UNION_ALL, SQL_UPDATE, SQL_VALUES, SQL_WHERE
-
Constructor Summary
-
Method Summary
Modifier and TypeMethodDescriptionprotected void
protected void
protected void
Selection order.protected void
order
(PreparedQuery pq) void
Queries processes.withLinkObjectId
(int value) Filter by link object ID.withLinkObjectType
(String value) Filter by link object type.Filter by process closing date.org.bgerp.dao.process.SearchDAO
withStatus
(Collection<Integer> value) Filter by process status ID.org.bgerp.dao.process.SearchDAO
Filter by process type ID.Methods inherited from class ru.bgcrm.dao.CommonDAO
deleteById, foundRows, getById, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePatternEnd, getLikePatternStart, getLikePatternSub, getPageLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, update, updateColumn, updateIds, updateIds, updateOrInsert
-
Field Details
-
Constructor Details
-
Method Details
-
withOpen
Filter by process closing date.- Parameters:
value
-null
- no filter, or process closing date not null.- Returns:
-
order
Selection order.- Parameters:
value
- enum value.- Returns:
-
withLinkObjectType
Filter by link object type.- Parameters:
value
-- Returns:
-
withLinkObjectId
Filter by link object ID.- Parameters:
value
-- Returns:
-
search
Queries processes.- Parameters:
result
- pageable result. throws SQLException- Throws:
SQLException
-
withType
Filter by process type ID.- Parameters:
value
-null
or empty - no filter, or set with type IDs.- Returns:
-
withStatus
Filter by process status ID.- Parameters:
value
-null
or empty - no filter, or set with status IDs.- Returns:
-
filterOpen
-
filterType
-
filterStatus
-
order
-