Package sk.iway.iwcm.forum

Class ForumDB

java.lang.Object
sk.iway.iwcm.forum.ForumDB
public class ForumDB extends Object
Diskusne forum

  • Constructor Details

    • ForumDB

      protected ForumDB()

  • Method Details

    • getForumFieldsForDoc

      public static List<DocForumEntity> getForumFieldsForDoc(javax.servlet.http.HttpServletRequest request, int doc_id)

    • getForumFieldsForDoc

      public static List<DocForumEntity> getForumFieldsForDoc(javax.servlet.http.HttpServletRequest request, int doc_id, boolean onlyConfirmed)

    • getForumFieldsForDoc

      public static List<DocForumEntity> getForumFieldsForDoc(javax.servlet.http.HttpServletRequest request, int doc_id, boolean onlyConfirmed, int parentId)
      vrati zoznam vsetkych otazok pre dane docId
      Parameters:
      request -
      doc_id -
      onlyConfirmed - - ak true, zo zoznamu vyhodi nepotvrdene
      Returns:

    • getForumFieldsForDoc

      public static List<DocForumEntity> getForumFieldsForDoc(javax.servlet.http.HttpServletRequest request, int doc_id, boolean onlyConfirmed, int parentId, boolean sortAscending)

    • getForumFieldsForDoc

      public static List<DocForumEntity> getForumFieldsForDoc(javax.servlet.http.HttpServletRequest request, int doc_id, boolean onlyConfirmed, int parentId, boolean sortAscending, boolean showDeleted)

    • getForumBean

      public static DocForumEntity getForumBean(javax.servlet.http.HttpServletRequest request, int forumId)
      vrati ForumDetails pre zadane forumId
      Parameters:
      forumId -
      Returns:

    • getForumBean

      public static DocForumEntity getForumBean(javax.servlet.http.HttpServletRequest request, int forumId, boolean sortAscending)

    • getLastMessage

      public static DocForumEntity getLastMessage(int doc_id)
      Vrati posledne zadany prispevok zadaneho fora
      Parameters:
      doc_id - - id web stranky / fora
      Returns:

    • deleteMessage

      public static boolean deleteMessage(int forumId, int docId, Identity user)
      Rekurzivna metoda. Vymaze zadany prispevok a jeho odpovede z DB.
      Parameters:
      forumId - - id prispevku
      Returns:

    • getForum

      public static ForumGroupEntity getForum(int docId)
      vrati ForumGroupBean pre zadane docId - data z tab. forum, ak neexistuje definicia, vrati defaultnu
      Parameters:
      docId - - stranka, ku ktorej je pridane forum
      Returns:

    • getForum

      public static ForumGroupEntity getForum(int docId, boolean returnNull)
      vrati ForumGroupBean pre zadane docId - data z tab. forum
      Parameters:
      docId - - id stranky
      returnNull - - ak je nastavene na false a zaznam neexistuje, vrati default zaznam
      Returns:

    • forumApprove

      public static boolean forumApprove(int forumId, int docId, Identity user)
      Potvrdi prispevok diskusie
      Parameters:
      forumId -
      Returns:

    • getForumTopics

      public static List<DocForumEntity> getForumTopics(int docId)
      Vrati zoznam schvalenych podtem pre dane forum
      Parameters:
      docId -
      Returns:

    • getForumTopics

      public static List<DocForumEntity> getForumTopics(int docId, boolean onlyConfirmed)

    • getForumTopics

      public static List<DocForumEntity> getForumTopics(int docId, boolean onlyConfirmed, boolean showDeleted)

    • getForumTopics

      public static List<DocForumEntity> getForumTopics(int docId, boolean onlyConfirmed, boolean showDeleted, String flagSearch)

    • getForumTopics

      public static List<DocForumEntity> getForumTopics(int docId, boolean onlyConfirmed, boolean showDeleted, String flagSearch, ForumSortBy sortBy)

    • getForumMessageParent

      public static int getForumMessageParent(int forumId, int docId)
      Vrati forumId podtemy, cize spravy, ktora ma parentId=-1
      Parameters:
      forumId -

    • updateForumStatViews

      public static void updateForumStatViews(int forumId)
      Zvysi statistiku videni diskusie
      Parameters:
      forumId -

    • getForumStat

      public static DocForumEntity getForumStat(int docId)
      Ziska stat. udaje o fore, do ForumBean-u sa setne iba last post a replies (celk pocet sprav)
      Parameters:
      docId -
      Returns:

    • closeForumTopic

      public static boolean closeForumTopic(int forumId, boolean close)
      Uzatvori/otvori podtemu diskusie
      Parameters:
      forumId -
      close - - ak je TRUE, diskusia sa zatvori, ak FALSE diskusia sa otvori
      Returns:

    • searchForum

      public static List<ForumSearchBean> searchForum(int docId, String searchStr, int userId)
      Vyhladavanie vo fore
      Parameters:
      docId - - id stranky s forom
      searchStr - - retazec co sa hlada
      userId - - ak je zadane hladaju sa prispevky od tohto pouzivatela (docId je vtedy ignorovane)
      Returns:

    • compareDates

      public static boolean compareDates(String lastPost, String lastLogon)
      Parameters:
      lastPost -
      lastLogon -
      Returns:

    • updateForumStatInfo

      public static void updateForumStatInfo(int docId, int forumId)

    • getParentIds

      public static String getParentIds(int topicId, int docId)

    • getUserLastLogon

      public static String getUserLastLogon(int userId)
      Vrati datum predposledneho loginu usera uvedeneho v tab. stat_userlogon
      Parameters:
      userId -
      Returns:

    • getForumTopicsCount

      public static int getForumTopicsCount(int docId)
      vrati pocet tem vo fore
      Parameters:
      docId -
      Returns:

    • getForumPostsCount

      public static int getForumPostsCount(int docId)
      vrati pocet vsetkych prispevkov vo fore
      Parameters:
      docId -
      Returns:

    • getForumLastPostDate

      public static String[] getForumLastPostDate(int docId)
      vrati datum a autora posledneho prispevku
      Parameters:
      docId -
      Returns:

    • getUploadLimits

      public static LabelValueDetails getUploadLimits(int docId, javax.servlet.http.HttpServletRequest request)
      Vrati nastavene limity pre nahratie suboru do fora so zadanym docId
      Parameters:
      docId -
      request -
      Returns:

    • getTopForums

      public static List<RatingEntity> getTopForums(int docsLength, int period, int minUsers, String groupIds, boolean includeSubGroups)
      Zobrazi zoznam clankov zoradenych podla poctu prispevkov v diskusii. Ak existuju clanky s rovnakym poctom prispevkov, zoradi ich podla poctu hlasujucich citatelov.
      Parameters:
      docsLength - - pocet zobrazenych clankov
      period - - pocet dni dozadu za ktore sa statistika berie
      minUsers - - minimalny pocet prispevkov v diskusii
      groupIds - - id adresara v ktorom sa sledovane clanky nachadzaju
      includeSubGroups - - ak je true, beru sa aj podadresare
      Returns:

    • recoverMessage

      public static boolean recoverMessage(int forumId, int docId, Identity user)
      Rekurzivna metoda. Obnovi zadany prispevok a jeho odpovede z DB.
      Parameters:
      forumId - - id prispevku
      Returns:

    • setForumCountForDocIds

      public static void setForumCountForDocIds(int doc_id, int forum_count)
      Update stlpcu forum_count, pre konkretne doc_id
      Parameters:
      doc_id -
      forum_count -

    • isActive

      public static boolean isActive(int docId)
      Test forum, if it's active, by given docId.
      Parameters:
      docId - - ID of the page where the forum is located
      Returns:
      - return true if isActive, else false

    • getForumRanks

      public static Hashtable<String,String> getForumRanks(int userGroup)
      Vrati mi hash tabulku s userID a forumRank pre userov, ktori patria do skupiny userGroup
      Parameters:
      userGroup -
      Returns: