Package 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

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, 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
UserDAO(Connection con)

Method Summary

Modifier and Type	Method	Description
void	addUserGroup(int userId, UserGroup group)
void	closeUserGroupPeriod(int userId, int groupId, Date date, Date dateFrom, Date dateTo)
void	deleteUser(int id)
void	editStartUserGroupPeriod(int userId, int groupId, Date date, Date dateFrom, Date dateTo)
Map<Integer,Map<String,ParameterMap>>	getAllPermissions(String tableName, String selectColumn)
Map<Integer,Set<Integer>>	getAllUserGroupIds()
Map<Integer,List<UserGroup>>	getAllUserGroups()
Map<Integer,Map<String,ParameterMap>>	getAllUserPerm()
Map<Integer,List<Integer>>	getAllUserPermsetIds()
Map<Integer,Set<Integer>>	getAllUserQueueIds()
@Nullable User	getByTextParam(int paramId, String expectedValue, Set<Integer> statuses)
protected String	getMySQLLimit(Page page)
Map<String,ParameterMap>	getPermissions(int userId)
User	getUser(int id)
int	getUserByFioAndTabelId(ru.ufanet.ldap.user.user1C.structure.elements.Fio fio, List<String> tabelIds)
User	getUserByLogin(String name)
int	getUserERPIdByLoginAD(String loginDomain)
Set<Integer>	getUserGroupIds(int userId)
List<UserGroup>	getUserGroupList(int userId, Date date)
List<User>	getUserList()
List<User>	getUserList(Set<Integer> groupIds)
List<User>	getUserList(Set<Integer> groupIds, String userTitleMask)
List<User>	getUserList(Set<Integer> groupFilter, Date dateGroupFrom, Date dateGroupTo)
List<Integer>	getUserPermsetIds(int userId)
Set<Integer>	getUserQueueIds(int userId)
void	removeUserGroup(int userId, int groupId, Date dateFrom, Date dateTo)
void	searchUser(SearchResult<User> searchResult)
void	searchUser(SearchResult<User> searchResult, int userId, String filterLike, Set<Integer> groupFilter, Set<Integer> groupSelectFilter, Date date, Set<Integer> permsetFilter, int statusFilter)
void	searchUser(SearchResult<User> searchResult, String titleOrLoginFilter, Set<Integer> groupFilter)
void	searchUser(SearchResult<User> searchResult, String filterLike, Set<Integer> groupFilter, Set<Integer> groupSelectFilter, Date date, Set<Integer> permsetFilter, int statusFilter)
void	updatePermissions(Set<String> action, Set<String> config, int userId)
void	updatePersonalization(String configBefore, User user)	Обновить персональныую конфигурацию, только если она отличается от configBefore.
void	updateUser(int userId, String title, String login, String pswd, String description)
void	updateUser(User user)

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, 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

Constructor Details

UserDAO

public UserDAO(Connection con)

Method Details

searchUser

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

Throws:

BGException

searchUser

public void searchUser(SearchResult<User> searchResult,
 int userId,
 String filterLike,
 Set<Integer> groupFilter,
 Set<Integer> groupSelectFilter,
 Date date,
 Set<Integer> permsetFilter,
 int statusFilter)
                throws BGException

Throws:

BGException

searchUser

public void searchUser(SearchResult<User> searchResult,
 String filterLike,
 Set<Integer> groupFilter,
 Set<Integer> groupSelectFilter,
 Date date,
 Set<Integer> permsetFilter,
 int statusFilter)
                throws BGException

Throws:

BGException

searchUser

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

Throws:

BGException

getUserList

public List<User> getUserList()
                       throws BGException

Throws:

BGException

getUserList

public List<User> getUserList(Set<Integer> groupIds)
                       throws BGException

Throws:

BGException

getUserList

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

Throws:

BGException

getUserList

public List<User> getUserList(Set<Integer> groupFilter,
 Date dateGroupFrom,
 Date dateGroupTo)
                       throws BGException

Throws:

BGException

getAllUserGroups

public Map<Integer,List<UserGroup>> getAllUserGroups()
                                              throws BGException

Throws:

BGException

getUserGroupIds

public Set<Integer> getUserGroupIds(int userId)
                             throws BGException

Throws:

BGException

getAllUserGroupIds

public Map<Integer,Set<Integer>> getAllUserGroupIds()
                                             throws BGException

Throws:

BGException

getUserPermsetIds

public List<Integer> getUserPermsetIds(int userId)
                                throws BGException

Throws:

BGException

getAllUserPermsetIds

public Map<Integer,List<Integer>> getAllUserPermsetIds()
                                                throws BGException

Throws:

BGException

getUserQueueIds

public Set<Integer> getUserQueueIds(int userId)
                             throws BGException

Throws:

BGException

getAllUserQueueIds

public Map<Integer,Set<Integer>> getAllUserQueueIds()
                                             throws BGException

Throws:

BGException

updateUser

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

Throws:

BGException

SQLException

updateUser

public void updateUser(User user)
                throws BGException,
SQLException

Throws:

BGException

SQLException

getUserByLogin

public User getUserByLogin(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 String getMySQLLimit(Page page)

Overrides:

getMySQLLimit in class CommonDAO

getAllPermissions

public Map<Integer,Map<String,ParameterMap>> getAllPermissions(String tableName,
 String selectColumn)
                                                        throws BGException

Throws:

BGException

getAllUserPerm

public Map<Integer,Map<String,ParameterMap>> getAllUserPerm()
                                                     throws BGException

Throws:

BGException

updatePermissions

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

Throws:

BGException

getPermissions

public Map<String,ParameterMap> getPermissions(int userId)
                                        throws BGException

Throws:

BGException

updatePersonalization

public void updatePersonalization(String configBefore,
 User user)
                           throws BGException

Обновить персональныую конфигурацию, только если она отличается от configBefore.

Parameters:

configBefore - null, если нужно безусловное сохранение.

user -

Throws:

BGException

addUserGroup

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

Throws:

BGException

removeUserGroup

public void removeUserGroup(int userId,
 int groupId,
 Date dateFrom,
 Date dateTo)
                     throws BGException

Throws:

BGException

getUserGroupList

public List<UserGroup> getUserGroupList(int userId,
 Date date)
                                 throws BGException

Throws:

BGException

getUserERPIdByLoginAD

public int getUserERPIdByLoginAD(String loginDomain)
                          throws SQLException

Throws:

SQLException

getUserByFioAndTabelId

public int getUserByFioAndTabelId(ru.ufanet.ldap.user.user1C.structure.elements.Fio fio,
 List<String> tabelIds)
                           throws Exception

Throws:

Exception

closeUserGroupPeriod

public void closeUserGroupPeriod(int userId,
 int groupId,
 Date date,
 Date dateFrom,
 Date dateTo)
                          throws BGException

Throws:

BGException

editStartUserGroupPeriod

public void editStartUserGroupPeriod(int userId,
 int groupId,
 Date date,
 Date dateFrom,
 Date dateTo)
                              throws BGException

Throws:

BGException

getByTextParam

@Nullable
public @Nullable User getByTextParam(int paramId,
 String expectedValue,
 Set<Integer> statuses)
                              throws BGException

Throws:

BGException