Package org.bgerp.dao.process

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.

Nested Class Summary

Nested classes/interfaces inherited from class ru.bgcrm.dao.CommonDAO

CommonDAO.ObjectExtractor<T>, CommonDAO.RecordUpdater<T extends Id>

Field Summary

Fields

Modifier and Type	Field	Description
protected final DynActionForm	form	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_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

Constructors

Constructor	Description
ProcessParamSearchDAO(Connection con)
ProcessParamSearchDAO(Connection con, DynActionForm form)

Method Summary

Modifier and Type	Method	Description
protected void	filterOpen(PreparedQuery pq)
protected void	filterStatus(PreparedQuery pq)
protected void	filterType(PreparedQuery pq)
org.bgerp.dao.process.SearchDAO	order(Order value)	Selection order.
protected void	order(PreparedQuery pq)
void	search(Pageable<ParameterSearchedObject<Process>> result)	Queries processes with param values.
ProcessParamSearchDAO	withOpen(Boolean value)	Filter by process closing date.
ProcessParamSearchDAO	withParamTextIds(Set<Integer> values)
ProcessParamSearchDAO	withParamTextValue(String value)
org.bgerp.dao.process.SearchDAO	withStatus(Collection<Integer> value)	Filter by process status ID.
org.bgerp.dao.process.SearchDAO	withType(Set<Integer> value)	Filter by process type ID.

Methods inherited from class ru.bgcrm.dao.CommonDAO

deleteById, foundRows, getById, getGroupedIds, getGroupedIds, getIds, getIds, getPageLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, update, updateColumn, updateIds, updateIds, updateOrInsert

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

form

protected final DynActionForm form

User request context for isolations.

Constructor Details

ProcessParamSearchDAO

public ProcessParamSearchDAO(Connection con)

ProcessParamSearchDAO

public ProcessParamSearchDAO(Connection con,
 DynActionForm form)

Method Details

withOpen

public ProcessParamSearchDAO withOpen(Boolean value)

Filter by process closing date.

Parameters:

value - null - no filter, or process closing date 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

public org.bgerp.dao.process.SearchDAO withType(Set<Integer> value)

Filter by process type ID.

Parameters:

value - null or empty - no filter, or set with type IDs.

Returns:

withStatus

public org.bgerp.dao.process.SearchDAO withStatus(Collection<Integer> value)

Filter by process status ID.

Parameters:

value - null or empty - no filter, or set with status IDs.

Returns:

order

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

order

protected void order(PreparedQuery pq)