Package sk.iway.iwcm.system.datatable
Class SpecSearch<T>
java.lang.Object
sk.iway.iwcm.system.datatable.SpecSearch<T>
Pomocne metody pre specialne/zlozite vyhladavanie v repozitaroch
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionvoid
addSpecSearchByUserEditable
(UserDetails user, String jpaProperty, List<javax.persistence.criteria.Predicate> predicates, javax.persistence.criteria.Root<T> root, javax.persistence.criteria.CriteriaBuilder builder) Search by allowed user editable pages/groupsvoid
addSpecSearchDocFullPath
(String paramValue, String jpaProperty, List<javax.persistence.criteria.Predicate> predicates, javax.persistence.criteria.Root<T> root, javax.persistence.criteria.CriteriaBuilder builder) Search by DocDetails.fullPath value, simulated by concating file_name/title in table documentsvoid
addSpecSearchIdInForeignTable
(String paramValue, String foreignTableName, String foreignTableId, String foreignColumnName, String jpaProperty, List<javax.persistence.criteria.Predicate> predicates, javax.persistence.criteria.Root<T> root, javax.persistence.criteria.CriteriaBuilder builder) Search by ID in foreign table in column with name foreignColumnName by paramValue Useful in case of media search by mediaGroupName in media_group foreign tablevoid
addSpecSearchIdInForeignTableInteger
(int paramValue, String foreignTableName, String foreignTableId, String foreignColumnName, String jpaProperty, List<javax.persistence.criteria.Predicate> predicates, javax.persistence.criteria.Root<T> root, javax.persistence.criteria.CriteriaBuilder builder) void
addSpecSearchPasswordProtected
(Integer userGroupId, String jpaProperty, List<javax.persistence.criteria.Predicate> predicates, javax.persistence.criteria.Root<T> root, javax.persistence.criteria.CriteriaBuilder builder) Specialne vyhladavanie v password_protected stlpci, kde sa hlada zadany vyraz cez LIKE vo forme ID ID,% %,ID,% %,ID cize vo vsetkych variantoch ako sa moze vyskytovat v ciarkou oddelenom zoznamevoid
addSpecSearchPasswordProtected
(String userGroupName, String jpaProperty, List<javax.persistence.criteria.Predicate> predicates, javax.persistence.criteria.Root<T> root, javax.persistence.criteria.CriteriaBuilder builder) Specialne vyhladavanie v password_protected stlpci, kde sa hlada zadany vyraz cez LIKE vo forme ID ID,% %,ID,% %,ID cize vo vsetkych variantoch ako sa moze vyskytovat v ciarkou oddelenom zoznamevoid
addSpecSearchPerexGroup
(String perexGroupName, String jpaProperty, List<javax.persistence.criteria.Predicate> predicates, javax.persistence.criteria.Root<T> root, javax.persistence.criteria.CriteriaBuilder builder) Specialne vyhladavanie v perex_group stlpci, kde sa hlada zadany vyraz cez LIKE vo forme ID ID,% %,ID,% %,ID cize vo vsetkych variantoch ako sa moze vyskytovat v ciarkou oddelenom zoznamevoid
addSpecSearchStatusIcons
(String statusSearch, List<javax.persistence.criteria.Predicate> predicates, javax.persistence.criteria.Root<T> root, javax.persistence.criteria.CriteriaBuilder builder) Specialne vyhladavanie podla stavovej ikonyvoid
addSpecSearchUserFullName
(String paramValue, String jpaProperty, List<javax.persistence.criteria.Predicate> predicates, javax.persistence.criteria.Root<T> root, javax.persistence.criteria.CriteriaBuilder builder) Specialne vyhladavanie podla zadaneho mena/priezviska s konverziou na hladanie podla ID pouzivatela (v DB tabulke je zvycajne ulozene ID pouzivatela, nie jeho cele meno).
-
Constructor Details
-
SpecSearch
public SpecSearch()
-
-
Method Details
-
addSpecSearchPasswordProtected
public void addSpecSearchPasswordProtected(String userGroupName, String jpaProperty, List<javax.persistence.criteria.Predicate> predicates, javax.persistence.criteria.Root<T> root, javax.persistence.criteria.CriteriaBuilder builder) Specialne vyhladavanie v password_protected stlpci, kde sa hlada zadany vyraz cez LIKE vo forme ID ID,% %,ID,% %,ID cize vo vsetkych variantoch ako sa moze vyskytovat v ciarkou oddelenom zozname- Parameters:
userGroupName
- - MENO skupiny pouzivatelovjpaProperty
-predicates
-root
-builder
-
-
addSpecSearchPasswordProtected
public void addSpecSearchPasswordProtected(Integer userGroupId, String jpaProperty, List<javax.persistence.criteria.Predicate> predicates, javax.persistence.criteria.Root<T> root, javax.persistence.criteria.CriteriaBuilder builder) Specialne vyhladavanie v password_protected stlpci, kde sa hlada zadany vyraz cez LIKE vo forme ID ID,% %,ID,% %,ID cize vo vsetkych variantoch ako sa moze vyskytovat v ciarkou oddelenom zozname- Parameters:
userGroupId
- - ID skupiny pouzivatelovjpaProperty
-predicates
-root
-builder
-
-
addSpecSearchPerexGroup
public void addSpecSearchPerexGroup(String perexGroupName, String jpaProperty, List<javax.persistence.criteria.Predicate> predicates, javax.persistence.criteria.Root<T> root, javax.persistence.criteria.CriteriaBuilder builder) Specialne vyhladavanie v perex_group stlpci, kde sa hlada zadany vyraz cez LIKE vo forme ID ID,% %,ID,% %,ID cize vo vsetkych variantoch ako sa moze vyskytovat v ciarkou oddelenom zozname- Parameters:
perexGroupName
- - MENO perex skupinyjpaProperty
-predicates
-root
-builder
-
-
addSpecSearchUserFullName
public void addSpecSearchUserFullName(String paramValue, String jpaProperty, List<javax.persistence.criteria.Predicate> predicates, javax.persistence.criteria.Root<T> root, javax.persistence.criteria.CriteriaBuilder builder) Specialne vyhladavanie podla zadaneho mena/priezviska s konverziou na hladanie podla ID pouzivatela (v DB tabulke je zvycajne ulozene ID pouzivatela, nie jeho cele meno). Interne funguje tak, ze v users tabulke vyhlada zadane meno, vysledok skonvertuje na pole ID pouzivatelov a to nasledne hlada v jpaProperty.in()- Parameters:
paramValue
- - hladane meno/priezviskojpaProperty
- - meno JPA property, v ktorej sa nasledne hlada ID pouzivatelapredicates
-root
-builder
-
-
addSpecSearchStatusIcons
public void addSpecSearchStatusIcons(String statusSearch, List<javax.persistence.criteria.Predicate> predicates, javax.persistence.criteria.Root<T> root, javax.persistence.criteria.CriteriaBuilder builder) Specialne vyhladavanie podla stavovej ikony- Parameters:
statusSearch
-predicates
-root
-builder
-
-
addSpecSearchIdInForeignTable
public void addSpecSearchIdInForeignTable(String paramValue, String foreignTableName, String foreignTableId, String foreignColumnName, String jpaProperty, List<javax.persistence.criteria.Predicate> predicates, javax.persistence.criteria.Root<T> root, javax.persistence.criteria.CriteriaBuilder builder) Search by ID in foreign table in column with name foreignColumnName by paramValue Useful in case of media search by mediaGroupName in media_group foreign table- Parameters:
paramValue
-foreignTableName
-foreignTableId
-foreignColumnName
-jpaProperty
-predicates
-root
-builder
-
-
addSpecSearchIdInForeignTableInteger
public void addSpecSearchIdInForeignTableInteger(int paramValue, String foreignTableName, String foreignTableId, String foreignColumnName, String jpaProperty, List<javax.persistence.criteria.Predicate> predicates, javax.persistence.criteria.Root<T> root, javax.persistence.criteria.CriteriaBuilder builder) -
addSpecSearchDocFullPath
public void addSpecSearchDocFullPath(String paramValue, String jpaProperty, List<javax.persistence.criteria.Predicate> predicates, javax.persistence.criteria.Root<T> root, javax.persistence.criteria.CriteriaBuilder builder) Search by DocDetails.fullPath value, simulated by concating file_name/title in table documents- Parameters:
paramValue
-jpaProperty
-predicates
-root
-builder
-
-
addSpecSearchByUserEditable
public void addSpecSearchByUserEditable(UserDetails user, String jpaProperty, List<javax.persistence.criteria.Predicate> predicates, javax.persistence.criteria.Root<T> root, javax.persistence.criteria.CriteriaBuilder builder) Search by allowed user editable pages/groups- Parameters:
user
-jpaProperty
-predicates
-root
-builder
-
-