ru.bgcrm.dao.process

Class ProcessDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.process.ProcessDAO

public class ProcessDAO
extends CommonDAO

Field Summary

Fields inherited from class ru.bgcrm.dao.CommonDAO

con, dateFormat_DDMMYYYY, dateFormat_DDMMYYYY_HHMM, log, SQL_AND, SQL_DELETE, SQL_DESC, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT, SQL_LEFT_JOIN, SQL_LIMIT, 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 and Description
ProcessDAO(java.sql.Connection con)
ProcessDAO(java.sql.Connection con, boolean history)
ProcessDAO(java.sql.Connection con, boolean history, int userId)

Method Summary

Methods

Modifier and Type	Method and Description
void	addDateFilter(ru.bgcrm.struts.form.DynActionForm form, java.lang.StringBuilder wherePart, java.lang.String paramPrefix, java.lang.String column)
void	addDateTimeFilter(ru.bgcrm.struts.form.DynActionForm form, java.lang.StringBuilder wherePart, java.lang.String paramPrefix, java.lang.String paramId)
java.util.List<java.lang.Integer>	getLinkedProcessTypeIdList(java.lang.String objectType, int objectId)
Process	getProcess(int id)
static Process	getProcessFromRs(java.sql.ResultSet rs)
static Process	getProcessFromRs(java.sql.ResultSet rs, boolean titleLoad) Deprecated.
static Process	getProcessFromRs(java.sql.ResultSet rs, java.lang.String prefix)
void	searchLinkedProcessList(SearchResult<Pair<java.lang.String,Process>> searchResult, java.lang.String objectType, int objectId, java.util.Set<java.lang.Integer> typeIds, java.util.Set<java.lang.Integer> statusIds, java.lang.String paramFilter) Возвращает процессы, привязанные к какой-либо сущности.
void	searchLinkProcessList(SearchResult<Pair<java.lang.String,Process>> searchResult, int processId) Возвращает процессы, привязанные к процессу.
void	searchProcess(SearchResult<java.lang.Object[]> searchResult, Queue queue, ru.bgcrm.struts.form.DynActionForm form)
void	searchProcessListByAddress(SearchResult<AddressSearchedObject<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	searchProcessListByMessageFrom(SearchResult<Process> searchResult, java.lang.String email) Выбор списка процесс.
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

addLikeSql, convertDateToSqlDate, convertDateToTimestamp, deleteById, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getMySQLLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, updateColumn, updateIds, updateIds

Methods inherited from class java.lang.Object

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

Constructor Detail

ProcessDAO

public ProcessDAO(java.sql.Connection con)

ProcessDAO

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

ProcessDAO

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

Method Detail

searchProcess

public void searchProcess(SearchResult<java.lang.Object[]> searchResult,
                 Queue queue,
                 ru.bgcrm.struts.form.DynActionForm form)
                   throws BGException

Throws:

BGException

addDateTimeFilter

public void addDateTimeFilter(ru.bgcrm.struts.form.DynActionForm form,
                     java.lang.StringBuilder wherePart,
                     java.lang.String paramPrefix,
                     java.lang.String paramId)

addDateFilter

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

getProcess

public Process getProcess(int id)
                   throws BGException

Throws:

BGException

getProcessFromRs

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

Throws:

java.sql.SQLException

getProcessFromRs

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

Throws:

java.sql.SQLException

getProcessFromRs

@Deprecated
public static Process getProcessFromRs(java.sql.ResultSet rs,
                                  boolean titleLoad)
                                throws java.sql.SQLException,
                                       BGException

Deprecated.

Использовать getProcessFromRs(ResultSet).

Throws:

java.sql.SQLException

BGException

updateProcessGroups

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

Throws:

BGException

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

searchLinkedProcessList

public void searchLinkedProcessList(SearchResult<Pair<java.lang.String,Process>> searchResult,
                           java.lang.String objectType,
                           int objectId,
                           java.util.Set<java.lang.Integer> typeIds,
                           java.util.Set<java.lang.Integer> statusIds,
                           java.lang.String paramFilter)
                             throws BGException

Возвращает процессы, привязанные к какой-либо сущности.

Parameters:

searchResult -

objectType -

objectId -

typeIds -

statusIds -

paramFilter -

Throws:

BGException

getLinkedProcessTypeIdList

public java.util.List<java.lang.Integer> getLinkedProcessTypeIdList(java.lang.String objectType,
                                                           int objectId)
                                                             throws BGException

Throws:

BGException

searchLinkProcessList

public void searchLinkProcessList(SearchResult<Pair<java.lang.String,Process>> searchResult,
                         int processId)
                           throws BGException

Возвращает процессы, привязанные к процессу.

Parameters:

searchResult -

processId -

Throws:

BGException

searchProcessListByAddress

public void searchProcessListByAddress(SearchResult<AddressSearchedObject<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 -

processIds - коды

addressParamIdList -

houseId - код дома

houseFlat - квартира

houseRoom - комната

Throws:

java.sql.SQLException

BGException

searchProcessListByMessageFrom

public void searchProcessListByMessageFrom(SearchResult<Process> searchResult,
                                  java.lang.String email)
                                    throws BGException

Выбор списка процесс.

Parameters:

searchResult -

email -

Throws:

java.sql.SQLException

BGException