Package ru.bgcrm.dao.message

Class MessageDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.message.MessageDAO

public class MessageDAO
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 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
MessageDAO(java.sql.Connection con)
MessageDAO(java.sql.Connection con, User user)

Method Summary

Modifier and Type	Method	Description
void	deleteMessage(int id)
void	deleteProcessMessages(int processId)
static java.lang.String	getIsolationJoin(User user)
Message	getMessageById(int id)
Message	getMessageBySystemId(int typeId, java.lang.String systemId)
static Message	getMessageFromRs(java.sql.ResultSet rs, java.lang.String prefix)
java.util.Set<java.lang.Integer>	getMessageTags(int messageId)
java.util.List<Message>	getProcessMessageList(int processId, int beforeMessageId)	Retrieves process message list, sorted by ID.
java.util.List<Message>	getProcessMessageList(java.util.Set<java.lang.Integer> processIds, java.lang.String text)	Searches messages in processes.
java.util.Map<java.lang.Integer,java.util.Set<java.lang.Integer>>	getProcessMessageTagMap(int processId)
java.util.Map<java.lang.Integer,java.util.Set<java.lang.Integer>>	getProcessMessageTagMap(java.util.Collection<java.lang.Integer> processIds)
java.util.List<Message>	getUnsendMessageList(int type, int maxCount)
void	searchMessageList(SearchResult<Message> searchResult, java.lang.Integer processId, java.lang.Integer typeId, java.lang.Integer direction, java.lang.Boolean processed, java.lang.Boolean withAttach, java.util.Date dateFrom, java.util.Date dateTo, java.lang.String from)
void	searchMessageList(SearchResult<Message> searchResult, java.lang.Integer processId, java.lang.Integer typeId, java.lang.Integer direction, java.lang.Boolean processed, java.lang.Boolean withAttach, java.util.Date dateFrom, java.util.Date dateTo, java.lang.String from, boolean reverseOrder)
void	searchMessageList(SearchResult<Message> searchResult, java.lang.Integer processId, java.lang.Integer typeId, java.lang.Integer direction, java.lang.Boolean processed, java.lang.Boolean withAttach, java.util.Date dateFrom, java.util.Date dateTo, java.lang.String from, boolean reverseOrder, java.util.Set<java.lang.Integer> tagIds)
void	searchMessageList(SearchResult<Message> searchResult, java.util.Collection<java.lang.Integer> processIds, java.lang.Integer typeId, java.lang.Integer direction, java.lang.Boolean processed, java.lang.Boolean withAttach, java.util.Date dateFrom, java.util.Date dateTo, java.lang.String from, boolean reverseOrder, java.util.Set<java.lang.Integer> tagIds)	Deprecated.
void	searchMessageList(SearchResult<Message> searchResult, java.util.Collection<java.lang.Integer> processIds, java.util.Set<java.lang.Integer> typeIds, java.lang.Integer direction, java.lang.Boolean processed, java.lang.Boolean withAttach, java.util.Date dateFrom, java.util.Date dateTo, java.lang.String from, boolean reverseOrder, java.util.Set<java.lang.Integer> tagIds)
void	updateMessage(Message message)
void	updateMessageProcess(Message message)
void	updateMessageTags(int messageId, java.util.Set<java.lang.Integer> tagIds)

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

Constructor Detail

MessageDAO

public MessageDAO(java.sql.Connection con)

MessageDAO

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

Method Detail

getMessageById

public Message getMessageById(int id)
                       throws BGException

Throws:

BGException

getMessageBySystemId

public Message getMessageBySystemId(int typeId,
                                    java.lang.String systemId)
                             throws BGException

Throws:

BGException

updateMessage

public void updateMessage(Message message)
                   throws BGException

Throws:

BGException

updateMessageProcess

public void updateMessageProcess(Message message)
                          throws BGException

Throws:

BGException

updateMessageTags

public void updateMessageTags(int messageId,
                              java.util.Set<java.lang.Integer> tagIds)
                       throws java.lang.Exception

Throws:

java.lang.Exception

getMessageTags

public java.util.Set<java.lang.Integer> getMessageTags(int messageId)
                                                throws java.lang.Exception

Throws:

java.lang.Exception

deleteMessage

public void deleteMessage(int id)
                   throws BGException

Throws:

BGException

deleteProcessMessages

public void deleteProcessMessages(int processId)

getUnsendMessageList

public java.util.List<Message> getUnsendMessageList(int type,
                                                    int maxCount)
                                             throws BGException

Throws:

BGException

searchMessageList

public void searchMessageList(SearchResult<Message> searchResult,
                              java.lang.Integer processId,
                              java.lang.Integer typeId,
                              java.lang.Integer direction,
                              java.lang.Boolean processed,
                              java.lang.Boolean withAttach,
                              java.util.Date dateFrom,
                              java.util.Date dateTo,
                              java.lang.String from)
                       throws BGException

Throws:

BGException

searchMessageList

public void searchMessageList(SearchResult<Message> searchResult,
                              java.lang.Integer processId,
                              java.lang.Integer typeId,
                              java.lang.Integer direction,
                              java.lang.Boolean processed,
                              java.lang.Boolean withAttach,
                              java.util.Date dateFrom,
                              java.util.Date dateTo,
                              java.lang.String from,
                              boolean reverseOrder)
                       throws BGException

Throws:

BGException

searchMessageList

public void searchMessageList(SearchResult<Message> searchResult,
                              java.lang.Integer processId,
                              java.lang.Integer typeId,
                              java.lang.Integer direction,
                              java.lang.Boolean processed,
                              java.lang.Boolean withAttach,
                              java.util.Date dateFrom,
                              java.util.Date dateTo,
                              java.lang.String from,
                              boolean reverseOrder,
                              java.util.Set<java.lang.Integer> tagIds)
                       throws BGException

Throws:

BGException

searchMessageList

@Deprecated
public void searchMessageList(SearchResult<Message> searchResult,
                              java.util.Collection<java.lang.Integer> processIds,
                              java.lang.Integer typeId,
                              java.lang.Integer direction,
                              java.lang.Boolean processed,
                              java.lang.Boolean withAttach,
                              java.util.Date dateFrom,
                              java.util.Date dateTo,
                              java.lang.String from,
                              boolean reverseOrder,
                              java.util.Set<java.lang.Integer> tagIds)
                       throws BGException

Deprecated.

Throws:

BGException

searchMessageList

public void searchMessageList(SearchResult<Message> searchResult,
                              java.util.Collection<java.lang.Integer> processIds,
                              java.util.Set<java.lang.Integer> typeIds,
                              java.lang.Integer direction,
                              java.lang.Boolean processed,
                              java.lang.Boolean withAttach,
                              java.util.Date dateFrom,
                              java.util.Date dateTo,
                              java.lang.String from,
                              boolean reverseOrder,
                              java.util.Set<java.lang.Integer> tagIds)
                       throws BGException

Throws:

BGException

getProcessMessageList

public java.util.List<Message> getProcessMessageList(int processId,
                                                     int beforeMessageId)
                                              throws java.lang.Exception

Retrieves process message list, sorted by ID.

Parameters:

processId - process ID.

beforeMessageId - if > 0 - filter from message ID.

Returns:

Throws:

java.lang.Exception

getProcessMessageTagMap

public java.util.Map<java.lang.Integer,java.util.Set<java.lang.Integer>> getProcessMessageTagMap(int processId)
                                                                                                throws java.lang.Exception

Throws:

java.lang.Exception

getProcessMessageTagMap

public java.util.Map<java.lang.Integer,java.util.Set<java.lang.Integer>> getProcessMessageTagMap(java.util.Collection<java.lang.Integer> processIds)
                                                                                                throws java.lang.Exception

Throws:

java.lang.Exception

getProcessMessageList

public java.util.List<Message> getProcessMessageList(java.util.Set<java.lang.Integer> processIds,
                                                     java.lang.String text)
                                              throws java.lang.Exception

Searches messages in processes.

Parameters:

processIds - process IDs.

text - message substring.

Returns:

Throws:

java.lang.Exception

getIsolationJoin

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

getMessageFromRs

public static Message getMessageFromRs(java.sql.ResultSet rs,
                                       java.lang.String prefix)
                                throws java.sql.SQLException

Throws:

java.sql.SQLException