ru.bgcrm.dao.user

Class UserDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.user.UserDAO

Direct Known Subclasses:

UserPermsetDAO

public class UserDAO
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
UserDAO(java.sql.Connection con)

Method Summary

Methods

Modifier and Type	Method and Description
void	addUserGroup(int userId, UserGroup group)
void	closeUserGroupPeriod(int userId, int groupId, java.util.Date date)
void	deleteUser(int id)
java.util.Map<java.lang.Integer,java.util.Map<java.lang.String,ParameterMap>>	getAllPermissions(java.lang.String tableName, java.lang.String selectColumn)
java.util.Map<java.lang.Integer,java.util.Set<java.lang.Integer>>	getAllUserGroupIds()
java.util.Map<java.lang.Integer,java.util.List<UserGroup>>	getAllUserGroupLinks()
java.util.Map<java.lang.Integer,java.util.Map<java.lang.String,ParameterMap>>	getAllUserPerm()
java.util.Map<java.lang.Integer,java.util.List<java.lang.Integer>>	getAllUserPermsetIds()
java.util.Map<java.lang.Integer,java.util.Set<java.lang.Integer>>	getAllUserQueueIds()
protected java.lang.String	getMySQLLimit(Page page)
java.util.Map<java.lang.String,ParameterMap>	getPermissions(int userId)
User	getUser(int id)
User	getUserByLogin(java.lang.String name)
java.util.Set<java.lang.Integer>	getUserGroupIds(int userId)
java.util.List<User>	getUserList()
java.util.List<User>	getUserList(java.util.Set<java.lang.Integer> groupIds)
java.util.List<User>	getUserList(java.util.Set<java.lang.Integer> groupIds, java.lang.String userTitleMask)
java.util.List<java.lang.Integer>	getUserPermsetIds(int userId)
java.util.Set<java.lang.Integer>	getUserQueueIds(int userId)
void	removeUserGroup(int userId, int groupId)
void	searchUser(SearchResult<User> searchResult)
void	searchUser(SearchResult<User> searchResult, java.lang.String titleOrLoginFilter, java.util.Set<java.lang.Integer> groupFilter)
void	searchUser(SearchResult<User> searchResult, java.lang.String filter, java.util.Set<java.lang.Integer> groupFilter, java.util.Set<java.lang.Integer> groupSelectFilter, java.util.Date date, java.util.Set<java.lang.Integer> permsetFilter, int statusFilter)
void	updatePermissions(java.util.Set<java.lang.String> action, java.util.Set<java.lang.String> config, int userId)
void	updatePersonalization(User user)
void	updateUser(int userId, java.lang.String title, java.lang.String login, java.lang.String pswd, java.lang.String description)
void	updateUser(User user)

Methods inherited from class ru.bgcrm.dao.CommonDAO

addLikeSql, convertDateToSqlDate, convertDateToTimestamp, deleteById, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, 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

UserDAO

public UserDAO(java.sql.Connection con)

Method Detail

searchUser

public void searchUser(SearchResult<User> searchResult)
                throws BGException

Throws:

BGException

searchUser

public void searchUser(SearchResult<User> searchResult,
              java.lang.String filter,
              java.util.Set<java.lang.Integer> groupFilter,
              java.util.Set<java.lang.Integer> groupSelectFilter,
              java.util.Date date,
              java.util.Set<java.lang.Integer> permsetFilter,
              int statusFilter)
                throws BGException

Throws:

BGException

searchUser

public void searchUser(SearchResult<User> searchResult,
              java.lang.String titleOrLoginFilter,
              java.util.Set<java.lang.Integer> groupFilter)
                throws BGException

Throws:

BGException

getUserList

public java.util.List<User> getUserList()
                                 throws BGException

Throws:

BGException

getUserList

public java.util.List<User> getUserList(java.util.Set<java.lang.Integer> groupIds)
                                 throws BGException

Throws:

BGException

getUserList

public java.util.List<User> getUserList(java.util.Set<java.lang.Integer> groupIds,
                               java.lang.String userTitleMask)
                                 throws BGException

Throws:

BGException

getAllUserGroupLinks

public java.util.Map<java.lang.Integer,java.util.List<UserGroup>> getAllUserGroupLinks()
                                                                                throws BGException

Throws:

BGException

getUserGroupIds

public java.util.Set<java.lang.Integer> getUserGroupIds(int userId)
                                                 throws BGException

Throws:

BGException

getAllUserGroupIds

public java.util.Map<java.lang.Integer,java.util.Set<java.lang.Integer>> getAllUserGroupIds()
                                                                                     throws BGException

Throws:

BGException

getUserPermsetIds

public java.util.List<java.lang.Integer> getUserPermsetIds(int userId)
                                                    throws BGException

Throws:

BGException

getAllUserPermsetIds

public java.util.Map<java.lang.Integer,java.util.List<java.lang.Integer>> getAllUserPermsetIds()
                                                                                        throws BGException

Throws:

BGException

getUserQueueIds

public java.util.Set<java.lang.Integer> getUserQueueIds(int userId)
                                                 throws BGException

Throws:

BGException

getAllUserQueueIds

public java.util.Map<java.lang.Integer,java.util.Set<java.lang.Integer>> getAllUserQueueIds()
                                                                                     throws BGException

Throws:

BGException

updateUser

public void updateUser(int userId,
              java.lang.String title,
              java.lang.String login,
              java.lang.String pswd,
              java.lang.String description)
                throws BGException,
                       java.sql.SQLException

Throws:

BGException

java.sql.SQLException

updateUser

public void updateUser(User user)
                throws BGException,
                       java.sql.SQLException

Throws:

BGException

java.sql.SQLException

getUserByLogin

public User getUserByLogin(java.lang.String name)
                    throws BGException

Throws:

BGException

getUser

public User getUser(int id)
             throws BGException

Throws:

BGException

deleteUser

public void deleteUser(int id)
                throws BGException

Throws:

BGException

getMySQLLimit

protected java.lang.String getMySQLLimit(Page page)

Overrides:

getMySQLLimit in class CommonDAO

getAllPermissions

public java.util.Map<java.lang.Integer,java.util.Map<java.lang.String,ParameterMap>> getAllPermissions(java.lang.String tableName,
                                                                                              java.lang.String selectColumn)
                                                                                                throws BGException

Throws:

BGException

getAllUserPerm

public java.util.Map<java.lang.Integer,java.util.Map<java.lang.String,ParameterMap>> getAllUserPerm()
                                                                                             throws BGException

Throws:

BGException

updatePermissions

public void updatePermissions(java.util.Set<java.lang.String> action,
                     java.util.Set<java.lang.String> config,
                     int userId)
                       throws BGException

Throws:

BGException

getPermissions

public java.util.Map<java.lang.String,ParameterMap> getPermissions(int userId)
                                                            throws BGException

Throws:

BGException

updatePersonalization

public void updatePersonalization(User user)
                           throws BGException

Throws:

BGException

addUserGroup

public void addUserGroup(int userId,
                UserGroup group)
                  throws BGException

Throws:

BGException

removeUserGroup

public void removeUserGroup(int userId,
                   int groupId)
                     throws BGException

Throws:

BGException

closeUserGroupPeriod

public void closeUserGroupPeriod(int userId,
                        int groupId,
                        java.util.Date date)
                          throws BGException

Throws:

BGException