Package sk.iway.iwcm.system.datatable

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
    SpecSearch()
     

  • Method Summary

    Modifier and Type
    Method
    Description
    void
    addSpecSearchByUserEditable(UserDetails user, String jpaProperty, List<jakarta.persistence.criteria.Predicate> predicates, jakarta.persistence.criteria.Root<T> root, jakarta.persistence.criteria.CriteriaBuilder builder)
    Search by allowed user editable pages/groups
    void
    addSpecSearchDocFullPath(String paramValue, String jpaProperty, List<jakarta.persistence.criteria.Predicate> predicates, jakarta.persistence.criteria.Root<T> root, jakarta.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<jakarta.persistence.criteria.Predicate> predicates, jakarta.persistence.criteria.Root<T> root, jakarta.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<jakarta.persistence.criteria.Predicate> predicates, jakarta.persistence.criteria.Root<T> root, jakarta.persistence.criteria.CriteriaBuilder builder)
     
    void
    addSpecSearchPasswordProtected(Integer userGroupId, String jpaProperty, List<jakarta.persistence.criteria.Predicate> predicates, jakarta.persistence.criteria.Root<T> root, jakarta.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<jakarta.persistence.criteria.Predicate> predicates, jakarta.persistence.criteria.Root<T> root, jakarta.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<jakarta.persistence.criteria.Predicate> predicates, jakarta.persistence.criteria.Root<T> root, jakarta.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<jakarta.persistence.criteria.Predicate> predicates, jakarta.persistence.criteria.Root<T> root, jakarta.persistence.criteria.CriteriaBuilder builder)
    Specialne vyhladavanie podla stavovej ikony
    void
    addSpecSearchUserFullName(String paramValue, String jpaProperty, List<jakarta.persistence.criteria.Predicate> predicates, jakarta.persistence.criteria.Root<T> root, jakarta.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).
    static List<Integer>
    getUserIdsFromFullName(String paramValue, boolean searchInEmail)
     

    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<jakarta.persistence.criteria.Predicate> predicates, jakarta.persistence.criteria.Root<T> root, jakarta.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<jakarta.persistence.criteria.Predicate> predicates, jakarta.persistence.criteria.Root<T> root, jakarta.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<jakarta.persistence.criteria.Predicate> predicates, jakarta.persistence.criteria.Root<T> root, jakarta.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<jakarta.persistence.criteria.Predicate> predicates, jakarta.persistence.criteria.Root<T> root, jakarta.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 -

    • getUserIdsFromFullName

      public static List<Integer> getUserIdsFromFullName(String paramValue, boolean searchInEmail)

    • addSpecSearchStatusIcons

      public void addSpecSearchStatusIcons(String statusSearch, List<jakarta.persistence.criteria.Predicate> predicates, jakarta.persistence.criteria.Root<T> root, jakarta.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<jakarta.persistence.criteria.Predicate> predicates, jakarta.persistence.criteria.Root<T> root, jakarta.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<jakarta.persistence.criteria.Predicate> predicates, jakarta.persistence.criteria.Root<T> root, jakarta.persistence.criteria.CriteriaBuilder builder)

    • addSpecSearchDocFullPath

      public void addSpecSearchDocFullPath(String paramValue, String jpaProperty, List<jakarta.persistence.criteria.Predicate> predicates, jakarta.persistence.criteria.Root<T> root, jakarta.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<jakarta.persistence.criteria.Predicate> predicates, jakarta.persistence.criteria.Root<T> root, jakarta.persistence.criteria.CriteriaBuilder builder)
      Search by allowed user editable pages/groups
      Parameters:
      user -
      jpaProperty -
      predicates -
      root -
      builder -