Class SpecSearch<T>

java.lang.Object
sk.iway.iwcm.system.datatable.SpecSearch<T>

public class SpecSearch<T> extends Object
Pomocne metody pre specialne/zlozite vyhladavanie v repozitaroch
  • Constructor Summary

    Constructors
    Constructor
    Description
     
  • Method Summary

    Modifier and Type
    Method
    Description
    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
    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
    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
    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)
     
    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
    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
    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
    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
    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).

    Methods inherited from class java.lang.Object

    clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
  • 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 pouzivatelov
      jpaProperty -
      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 pouzivatelov
      jpaProperty -
      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 skupiny
      jpaProperty -
      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/priezvisko
      jpaProperty - - meno JPA property, v ktorej sa nasledne hlada ID pouzivatela
      predicates -
      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 -