|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.opencms.db.generic.CmsUserQueryBuilder
org.opencms.db.jpa.CmsJpaUserQueryBuilder
public class CmsJpaUserQueryBuilder
User query builder implementation for JPA.
Constructor Summary | |
---|---|
CmsJpaUserQueryBuilder()
|
Method Summary | |
---|---|
protected void |
addSorting(CmsSelectQuery select,
CmsSelectQuery.TableAlias users,
CmsUserSearchParameters searchParams)
Adds a sort order to an SQL query. |
protected java.lang.String |
colDateCreated()
Column name accessor. |
protected java.lang.String |
colEmail()
Column name accessor. |
protected java.lang.String |
colFirstName()
Column name accessor. |
protected java.lang.String |
colFlags()
Column name accessor. |
protected java.lang.String |
colGroupUserGroupId()
Column name accessor. |
protected java.lang.String |
colGroupUserUserId()
Column name accessor. |
protected java.lang.String |
colId()
Column name accessor. |
protected java.lang.String |
colLastLogin()
Column name accessor. |
protected java.lang.String |
colLastName()
Column name accessor. |
protected java.lang.String |
colName()
Column name accessor. |
protected java.lang.String |
colOu()
Column name accessor. |
protected java.lang.String |
colPassword()
Column name accessor. |
protected I_CmsQueryFragment |
createFlagCondition(CmsSelectQuery.TableAlias users,
int flags)
Creates an SQL flag check condition. |
protected java.lang.String |
createSingleFlagCondition(java.lang.String col,
int flag)
Creates the condition for matching a single flag. |
CmsPair<java.lang.String,java.util.List<java.lang.Object>> |
createUserQuery(CmsUserSearchParameters searchParams,
boolean countOnly)
Creates a query for searching users. |
protected java.lang.String |
generateConcat(java.lang.String... expressions)
Generates an SQL expression for concatenating several other SQL expressions. |
protected java.lang.String |
getGroupUserSubqueryColumns()
Returns the columns that should be returned by user subqueries. |
protected java.lang.String |
internalCreateFlagCondition(java.lang.String col,
int flags)
Helper method for creating a flag condition. |
protected java.lang.String |
tabGroups()
Table name accessor. |
protected java.lang.String |
tabGroupUsers()
Table name accessor. |
protected java.lang.String |
tabUsers()
Table name accessor. |
protected java.util.List<java.lang.Integer> |
uncompressFlags(int flags)
Uncompresses an integer used to store flags into its component flags. |
Methods inherited from class org.opencms.db.generic.CmsUserQueryBuilder |
---|
addAllowedOuCondition, addFlagCondition, addGroupCondition, addOrgUnitCondition, addSearchFilterCondition, addWebuserCondition, createCoreCondition, generateTrim, getSortExpression, getUserActivatedExpression, getUserFlagExpression, getUserFullNameExpression, makePaged, shouldNameSubqueries, useWindowFunctionsForPaging, wrapLower |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public CmsJpaUserQueryBuilder()
Method Detail |
---|
public CmsPair<java.lang.String,java.util.List<java.lang.Object>> createUserQuery(CmsUserSearchParameters searchParams, boolean countOnly)
createUserQuery
in class CmsUserQueryBuilder
searchParams
- the user search criteriacountOnly
- if true, the query will only count the total number of results instead of returning them
protected void addSorting(CmsSelectQuery select, CmsSelectQuery.TableAlias users, CmsUserSearchParameters searchParams)
addSorting
in class CmsUserQueryBuilder
select
- the queryusers
- the user table aliassearchParams
- the user search criteriaprotected java.lang.String colDateCreated()
CmsUserQueryBuilder
colDateCreated
in class CmsUserQueryBuilder
CmsUserQueryBuilder.colDateCreated()
protected java.lang.String colEmail()
CmsUserQueryBuilder
colEmail
in class CmsUserQueryBuilder
CmsUserQueryBuilder.colEmail()
protected java.lang.String colFirstName()
CmsUserQueryBuilder
colFirstName
in class CmsUserQueryBuilder
CmsUserQueryBuilder.colFirstName()
protected java.lang.String colFlags()
CmsUserQueryBuilder
colFlags
in class CmsUserQueryBuilder
CmsUserQueryBuilder.colFlags()
protected java.lang.String colGroupUserGroupId()
CmsUserQueryBuilder
colGroupUserGroupId
in class CmsUserQueryBuilder
CmsUserQueryBuilder.colGroupUserGroupId()
protected java.lang.String colGroupUserUserId()
CmsUserQueryBuilder
colGroupUserUserId
in class CmsUserQueryBuilder
CmsUserQueryBuilder.colGroupUserUserId()
protected java.lang.String colId()
CmsUserQueryBuilder
colId
in class CmsUserQueryBuilder
CmsUserQueryBuilder.colId()
protected java.lang.String colLastLogin()
CmsUserQueryBuilder
colLastLogin
in class CmsUserQueryBuilder
CmsUserQueryBuilder.colLastLogin()
protected java.lang.String colLastName()
CmsUserQueryBuilder
colLastName
in class CmsUserQueryBuilder
CmsUserQueryBuilder.colLastName()
protected java.lang.String colName()
CmsUserQueryBuilder
colName
in class CmsUserQueryBuilder
CmsUserQueryBuilder.colName()
protected java.lang.String colOu()
CmsUserQueryBuilder
colOu
in class CmsUserQueryBuilder
CmsUserQueryBuilder.colOu()
protected java.lang.String colPassword()
CmsUserQueryBuilder
colPassword
in class CmsUserQueryBuilder
CmsUserQueryBuilder.colPassword()
protected I_CmsQueryFragment createFlagCondition(CmsSelectQuery.TableAlias users, int flags)
CmsUserQueryBuilder
createFlagCondition
in class CmsUserQueryBuilder
users
- the user table aliasflags
- the flags to check
CmsUserQueryBuilder.createFlagCondition(org.opencms.db.CmsSelectQuery.TableAlias, int)
protected java.lang.String createSingleFlagCondition(java.lang.String col, int flag)
col
- the column nameflag
- the flag
protected java.lang.String generateConcat(java.lang.String... expressions)
CmsUserQueryBuilder
generateConcat
in class CmsUserQueryBuilder
expressions
- the expressions to concatenate
CmsUserQueryBuilder.generateConcat(java.lang.String[])
protected java.lang.String getGroupUserSubqueryColumns()
CmsUserQueryBuilder
getGroupUserSubqueryColumns
in class CmsUserQueryBuilder
CmsUserQueryBuilder.getGroupUserSubqueryColumns()
protected java.lang.String internalCreateFlagCondition(java.lang.String col, int flags)
col
- the column which contains the flagsflags
- the flags to match
protected java.lang.String tabGroups()
CmsUserQueryBuilder
tabGroups
in class CmsUserQueryBuilder
CmsUserQueryBuilder.tabGroups()
protected java.lang.String tabGroupUsers()
CmsUserQueryBuilder
tabGroupUsers
in class CmsUserQueryBuilder
CmsUserQueryBuilder.tabGroupUsers()
protected java.lang.String tabUsers()
CmsUserQueryBuilder
tabUsers
in class CmsUserQueryBuilder
CmsUserQueryBuilder.tabUsers()
protected java.util.List<java.lang.Integer> uncompressFlags(int flags)
flags
- the flags as an integer
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |