ru.bgcrm.plugin.notification.dao

Class CannedMessageDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.plugin.notification.dao.CannedMessageDAO

public class CannedMessageDAO
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 and Description
static int	CANNED_MESSAGE_GROUP_PROTECTED_ID
static java.lang.String	CANNED_MESSAGES_GROUPS_TABLE
static java.lang.String	CANNED_MESSAGES_TABLE

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_INSERT_IGNORE, SQL_LEFT_JOIN, SQL_LEFT_OUTER_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_OR, 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
CannedMessageDAO(java.sql.Connection con)

Method Summary

Modifier and Type	Method and Description
void	addCannedMessage(CannedMessage cannedMessage)
void	addCannedMessageGroup(CannedMessageGroup cannedMessageGroup)
void	deleteCannedMessage(int messageId)
void	deleteCannedMessageGroup(int groupId)
java.util.Map<java.lang.Integer,CannedMessageGroup>	getCannedGroupsMessages()
void	moveCannedMessagesFromDeletedGroup(int groupId)
void	updateCannedMessage(CannedMessage cannedMessage)
void	updateCannedMessageGroup(CannedMessageGroup cannedMessageGroup)

Methods inherited from class ru.bgcrm.dao.CommonDAO

deleteById, execute, execute, execute, executeInsert, executeUpdate, getById, getFoundRows, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getLikePatternEnd, getLikePatternStart, getLikePatternSub, getMySQLLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, update, updateColumn, updateIds, updateIds

Methods inherited from class java.lang.Object

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

Field Detail

CANNED_MESSAGE_GROUP_PROTECTED_ID

public static final int CANNED_MESSAGE_GROUP_PROTECTED_ID

See Also:

Constant Field Values

CANNED_MESSAGES_TABLE

public static final java.lang.String CANNED_MESSAGES_TABLE

See Also:

Constant Field Values

CANNED_MESSAGES_GROUPS_TABLE

public static final java.lang.String CANNED_MESSAGES_GROUPS_TABLE

See Also:

Constant Field Values

Constructor Detail

CannedMessageDAO

public CannedMessageDAO(java.sql.Connection con)

Method Detail

getCannedGroupsMessages

public java.util.Map<java.lang.Integer,CannedMessageGroup> getCannedGroupsMessages()

addCannedMessage

public void addCannedMessage(CannedMessage cannedMessage)

updateCannedMessage

public void updateCannedMessage(CannedMessage cannedMessage)

deleteCannedMessage

public void deleteCannedMessage(int messageId)

addCannedMessageGroup

public void addCannedMessageGroup(CannedMessageGroup cannedMessageGroup)

updateCannedMessageGroup

public void updateCannedMessageGroup(CannedMessageGroup cannedMessageGroup)

deleteCannedMessageGroup

public void deleteCannedMessageGroup(int groupId)

moveCannedMessagesFromDeletedGroup

public void moveCannedMessagesFromDeletedGroup(int groupId)