public class UserGroupDAO extends 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 and Description |
---|
UserGroupDAO(java.sql.Connection con) |
Modifier and Type | Method and Description |
---|---|
boolean |
checkGroup(int id,
int parentId,
java.lang.String title)
true если можно добавить скрипт с таким именем в данный каталог
|
void |
deleteGroup(int id) |
java.util.Map<java.lang.Integer,java.util.List<java.lang.Integer>> |
getAllGroupPermsetIds() |
java.util.Map<java.lang.Integer,java.util.Set<java.lang.Integer>> |
getAllGroupQueueIds() |
Group |
getGroupById(int id) |
java.util.List<Group> |
getGroupList() |
java.util.List<java.lang.Integer> |
getGroupPermsetIds(int groupId) |
java.util.Set<java.lang.Integer> |
getGroupQueueIds(int groupId) |
void |
searchGroup(SearchResult<Group> searchResult,
int parentId) |
void |
searchGroup(SearchResult<Group> searchResult,
int parentId,
int archive) |
void |
searchGroup(SearchResult<Group> searchResult,
int parentId,
int archive,
java.lang.String filter) |
void |
updateGroup(Group group) |
addLikeSql, convertDateToSqlDate, convertDateToTimestamp, deleteById, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getMySQLLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, updateColumn, updateIds, updateIds
public void searchGroup(SearchResult<Group> searchResult, int parentId) throws BGException
BGException
public void searchGroup(SearchResult<Group> searchResult, int parentId, int archive) throws BGException
BGException
public void searchGroup(SearchResult<Group> searchResult, int parentId, int archive, java.lang.String filter) throws BGException
BGException
public java.util.List<Group> getGroupList() throws BGException
BGException
public Group getGroupById(int id) throws BGException
BGException
public void updateGroup(Group group) throws BGException
BGException
public void deleteGroup(int id) throws BGException
BGException
public java.util.Set<java.lang.Integer> getGroupQueueIds(int groupId) throws BGException
BGException
public java.util.List<java.lang.Integer> getGroupPermsetIds(int groupId) throws BGException
BGException
public java.util.Map<java.lang.Integer,java.util.List<java.lang.Integer>> getAllGroupPermsetIds() throws BGException
BGException
public java.util.Map<java.lang.Integer,java.util.Set<java.lang.Integer>> getAllGroupQueueIds() throws BGException
BGException
public boolean checkGroup(int id, int parentId, java.lang.String title) throws java.sql.SQLException
parentId
- name
- java.sql.SQLException