Package ru.bgcrm.dao

Class ConfigDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.ConfigDAO

public class ConfigDAO
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 String	TABLE_CONFIG
static final String	TABLE_CONFIG_GLOBAL

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
ConfigDAO(Connection con)
ConfigDAO(Connection con, String tableName)

Method Summary

Modifier and Type	Method	Description
void	deleteGlobalConfig(int id)
Config	getActiveGlobalConfig()
List<ConfigRecord>	getConfigRecordList(String tableId, int recordId)
Map<String,String>	getConfigRecordMap(String tableId, int recordId)
Config	getGlobalConfig(int id)
void	searchGlobalConfigList(SearchResult<Config> searchResult, Set<Integer> allowedConfigIds, int configId, String filterLike)
void	setActiveGlobalConfig(int id)
void	updateConfigForRecord(String tableId, int recordId, List<ConfigRecord> config)
void	updateConfigForRecord(String tableId, int recordId, Map<String,String> config)
void	updateGlobalConfig(Config config)

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

TABLE_CONFIG

public static final String TABLE_CONFIG

See Also:

• Constant Field Values

TABLE_CONFIG_GLOBAL

public static final String TABLE_CONFIG_GLOBAL

See Also:

• Constant Field Values

Constructor Details

ConfigDAO

public ConfigDAO(Connection con)

ConfigDAO

public ConfigDAO(Connection con,
 String tableName)

Method Details

searchGlobalConfigList

public void searchGlobalConfigList(SearchResult<Config> searchResult,
 Set<Integer> allowedConfigIds,
 int configId,
 String filterLike)
                            throws SQLException

Throws:

SQLException

getGlobalConfig

public Config getGlobalConfig(int id)
                       throws SQLException

Throws:

SQLException

getActiveGlobalConfig

public Config getActiveGlobalConfig()
                             throws SQLException

Throws:

SQLException

setActiveGlobalConfig

public void setActiveGlobalConfig(int id)
                           throws SQLException

Throws:

SQLException

updateGlobalConfig

public void updateGlobalConfig(Config config)
                        throws SQLException

Throws:

SQLException

deleteGlobalConfig

public void deleteGlobalConfig(int id)
                        throws SQLException

Throws:

SQLException

getConfigRecordList

public List<ConfigRecord> getConfigRecordList(String tableId,
 int recordId)
                                       throws SQLException

Throws:

SQLException

getConfigRecordMap

public Map<String,String> getConfigRecordMap(String tableId,
 int recordId)
                                      throws SQLException

Throws:

SQLException

updateConfigForRecord

public void updateConfigForRecord(String tableId,
 int recordId,
 Map<String,String> config)
                           throws SQLException

Throws:

SQLException

updateConfigForRecord

public void updateConfigForRecord(String tableId,
 int recordId,
 List<ConfigRecord> config)
                           throws SQLException

Throws:

SQLException