Package 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	Description
static final int	CANNED_MESSAGE_GROUP_PROTECTED_ID
static final String	CANNED_MESSAGES_GROUPS_TABLE
static final 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	Description
CannedMessageDAO(Connection con)

Method Summary

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

Methods inherited from class ru.bgcrm.dao.CommonDAO

buildPlaceholders, deleteById, execute, execute, execute, executeBatch, 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 Details

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 String CANNED_MESSAGES_TABLE

See Also:

• Constant Field Values

CANNED_MESSAGES_GROUPS_TABLE

public static final String CANNED_MESSAGES_GROUPS_TABLE

See Also:

• Constant Field Values

Constructor Details

CannedMessageDAO

public CannedMessageDAO(Connection con)

Method Details

getCannedGroupsMessages

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