Package ru.bgcrm.dao.process

Class ProcessDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.process.ProcessDAO

Direct Known Subclasses:

BoardDAO, GroupLoadDAO

public class ProcessDAO
extends CommonDAO

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
static java.lang.String	LINKED_PROCESS
static int	MODE_USER_CLOSED
static int	MODE_USER_CREATED
static int	MODE_USER_STATUS_CHANGED

Fields inherited from class ru.bgcrm.dao.CommonDAO

con, log, SQL_AND, SQL_DELETE, SQL_DESC, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT, SQL_INSERT_IGNORE, 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_UPDATE, SQL_WHERE

Constructor Summary

Constructors

Constructor	Description
ProcessDAO(java.sql.Connection con)	Конструктор с полным доступом, без поддержки изоляций.
ProcessDAO(java.sql.Connection con, boolean history)
ProcessDAO(java.sql.Connection con, boolean history, int userId)	Deprecated.
ProcessDAO(java.sql.Connection con, User user)	Конструктор с поддержкой изоляции процессов.
ProcessDAO(java.sql.Connection con, User user, boolean history)

Method Summary

Modifier and Type	Method	Description
void	addDateFilter(DynActionForm form, java.lang.StringBuilder wherePart, java.lang.String paramPrefix, java.lang.String column)
void	addDateTimeFilter(DynActionForm form, java.lang.StringBuilder wherePart, java.lang.String paramPrefix, java.lang.String paramId, FilterParam filter)
protected void	addFilters(Queue queue, DynActionForm form, QueueSelectParams params)
void	deleteProcess(int processId)
java.lang.String	getCountQuery(Queue queue, DynActionForm form)
static java.lang.String	getIsolationJoin(User user)
EntityLogItem	getLastProcessChangeLog(Process process)	Возвращает последнюю запись лога изменения процесса.
Process	getProcess(int id)
static Process	getProcessFromRs(java.sql.ResultSet rs)
static Process	getProcessFromRs(java.sql.ResultSet rs, java.lang.String prefix)
java.util.List<Process>	getProcessList(java.util.Collection<java.lang.Integer> processIds)
protected QueueSelectParams	prepareQueueSelect(Queue queue)
void	processIdInvert(Process process)
void	searchProcess(SearchResult<java.lang.Object[]> searchResult, java.util.List<java.lang.String> aggregatedValues, Queue queue, DynActionForm form)	Selects processes for a queue's.
void	searchProcessListByAddress(SearchResult<ParameterSearchedObject<Process>> searchResult, java.util.Set<java.lang.Integer> typeIds, java.util.Set<java.lang.Integer> addressParamIdList, int houseId, java.lang.String houseFlat, java.lang.String houseRoom)	Выбирает процессы по адресному параметру.
void	searchProcessListForMessage(SearchResult<Process> searchResult, java.lang.String from, java.util.List<CommonObjectLink> links, java.lang.Boolean open)	Выбирает процессы возможно привязанные к сообщению.
void	searchProcessListForUser(SearchResult<Process> searchResult, int userId, int mode)	Выбирает связанные с процессом процессы.
void	searchProcessListForUser(SearchResult<Process> searchResult, int userId, java.lang.Boolean open)	Выбирает процессы, с пользователем в исполнителях.
void	searchProcessLog(ProcessType processType, int processId, SearchResult<EntityLogItem> result)	Выборка логов изменения процесса.
void	updateProcess(Process process)
void	updateProcessExecutors(int processId, java.util.Set<java.lang.Integer> executorIds)	Deprecated.
void	updateProcessExecutors(java.util.Set<ProcessExecutor> processExecutors, int processId)
void	updateProcessGroups(java.util.Set<ProcessGroup> processGroups, int processId)

Methods inherited from class ru.bgcrm.dao.CommonDAO

deleteById, getById, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getLikePatternEnd, getLikePatternStart, getLikePatternSub, getMySQLLimit, getPageLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, update, updateColumn, updateIds, updateIds, updateOrInsert

Methods inherited from class java.lang.Object

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

Field Detail

LINKED_PROCESS

public static final java.lang.String LINKED_PROCESS

See Also:

Constant Field Values

MODE_USER_CREATED

public static final int MODE_USER_CREATED

See Also:

Constant Field Values

MODE_USER_CLOSED

public static final int MODE_USER_CLOSED

See Also:

Constant Field Values

MODE_USER_STATUS_CHANGED

public static final int MODE_USER_STATUS_CHANGED

See Also:

Constant Field Values

Constructor Detail

ProcessDAO

public ProcessDAO(java.sql.Connection con)

Конструктор с полным доступом, без поддержки изоляций.

Parameters:

con -

ProcessDAO

public ProcessDAO(java.sql.Connection con,
                  User user)

Конструктор с поддержкой изоляции процессов.

Parameters:

con -

user -

ProcessDAO

public ProcessDAO(java.sql.Connection con,
                  boolean history)

ProcessDAO

@Deprecated
public ProcessDAO(java.sql.Connection con,
                  boolean history,
                  int userId)

Deprecated.

ProcessDAO

public ProcessDAO(java.sql.Connection con,
                  User user,
                  boolean history)

Method Detail

getProcessFromRs

public static Process getProcessFromRs(java.sql.ResultSet rs,
                                       java.lang.String prefix)
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

getProcessFromRs

public static Process getProcessFromRs(java.sql.ResultSet rs)
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

prepareQueueSelect

protected QueueSelectParams prepareQueueSelect(Queue queue)
                                        throws java.lang.Exception

Throws:

java.lang.Exception

getIsolationJoin

public static java.lang.String getIsolationJoin(User user)

searchProcess

public void searchProcess(SearchResult<java.lang.Object[]> searchResult,
                          java.util.List<java.lang.String> aggregatedValues,
                          Queue queue,
                          DynActionForm form)
                   throws java.lang.Exception

Selects processes for a queue's.

Parameters:

searchResult -

aggregatedValues - if not null - aggregated values are stored there.

queue -

form -

Throws:

java.lang.Exception

getCountQuery

public java.lang.String getCountQuery(Queue queue,
                                      DynActionForm form)
                               throws BGException

Throws:

BGException

addFilters

protected void addFilters(Queue queue,
                          DynActionForm form,
                          QueueSelectParams params)

addDateTimeFilter

public void addDateTimeFilter(DynActionForm form,
                              java.lang.StringBuilder wherePart,
                              java.lang.String paramPrefix,
                              java.lang.String paramId,
                              FilterParam filter)

addDateFilter

public void addDateFilter(DynActionForm form,
                          java.lang.StringBuilder wherePart,
                          java.lang.String paramPrefix,
                          java.lang.String column)

getProcess

public Process getProcess(int id)
                   throws BGException

Throws:

BGException

getProcessList

public java.util.List<Process> getProcessList(java.util.Collection<java.lang.Integer> processIds)
                                       throws BGException

Throws:

BGException

updateProcessGroups

public void updateProcessGroups(java.util.Set<ProcessGroup> processGroups,
                                int processId)
                         throws java.lang.Exception

Throws:

java.lang.Exception

updateProcessExecutors

@Deprecated
public void updateProcessExecutors(int processId,
                                   java.util.Set<java.lang.Integer> executorIds)
                            throws BGException

Deprecated.

Устаревшая функция - исполнители устанавливаются без привязки к группам, привязка восстанавливается затем по членству пользователей в группах. Использовать updateProcessExecutors(Set, int).

Throws:

BGException

updateProcessExecutors

public void updateProcessExecutors(java.util.Set<ProcessExecutor> processExecutors,
                                   int processId)
                            throws BGException

Throws:

BGException

updateProcess

public void updateProcess(Process process)
                   throws BGException

Throws:

BGException

deleteProcess

public void deleteProcess(int processId)
                   throws BGException

Throws:

BGException

processIdInvert

public void processIdInvert(Process process)
                     throws BGException

Throws:

BGException

searchProcessListByAddress

public void searchProcessListByAddress(SearchResult<ParameterSearchedObject<Process>> searchResult,
                                       java.util.Set<java.lang.Integer> typeIds,
                                       java.util.Set<java.lang.Integer> addressParamIdList,
                                       int houseId,
                                       java.lang.String houseFlat,
                                       java.lang.String houseRoom)
                                throws BGException

Выбирает процессы по адресному параметру.

Parameters:

searchResult -

addressParamIdList -

houseId - код дома

houseFlat - квартира

houseRoom - комната

Throws:

java.sql.SQLException

BGException

searchProcessListForMessage

public void searchProcessListForMessage(SearchResult<Process> searchResult,
                                        java.lang.String from,
                                        java.util.List<CommonObjectLink> links,
                                        java.lang.Boolean open)
                                 throws java.sql.SQLException

Выбирает процессы возможно привязанные к сообщению.

Parameters:

searchResult -

from -

Throws:

java.sql.SQLException

searchProcessListForUser

public void searchProcessListForUser(SearchResult<Process> searchResult,
                                     int userId,
                                     java.lang.Boolean open)
                              throws BGException

Выбирает процессы, с пользователем в исполнителях.

Parameters:

searchResult -

Throws:

BGException

searchProcessListForUser

public void searchProcessListForUser(SearchResult<Process> searchResult,
                                     int userId,
                                     int mode)
                              throws java.sql.SQLException

Выбирает связанные с процессом процессы.

Parameters:

searchResult -

userId - код пользователя.

mode - принимает значения MODE_USER_CREATED, MODE_USER_CLOSED, MODE_USER_STATUS_CHANGED.

Throws:

java.sql.SQLException

getLastProcessChangeLog

public EntityLogItem getLastProcessChangeLog(Process process)
                                      throws BGException

Возвращает последнюю запись лога изменения процесса.

Parameters:

process -

Returns:

Throws:

BGException

searchProcessLog

public void searchProcessLog(ProcessType processType,
                             int processId,
                             SearchResult<EntityLogItem> result)
                      throws BGException

Выборка логов изменения процесса.

Parameters:

processType -

processId -

result -

Throws:

java.lang.Exception

BGException