Package sk.iway.iwcm.inquiry

Class InquiryDB

java.lang.Object
sk.iway.iwcm.inquiry.InquiryDB
public class InquiryDB extends Object
InquiryDB.java - praca s anketami

  • Field Details

  • Constructor Details

    • InquiryDB

      protected InquiryDB()

  • Method Details

    • getLastInquiry

      public static InquiryBean getLastInquiry(int imagesLength, String percentageFormat, javax.servlet.http.HttpServletRequest request)

    • getLastInquiry

      public static InquiryBean getLastInquiry(javax.servlet.http.HttpServletRequest request)

    • getInquiryIds

      public static List<Integer> getInquiryIds(String groupNames, javax.servlet.http.HttpServletRequest request, boolean all)
      Vrati zoznam ID ankiet zodpovedajucich danym skupinam.
      Parameters:
      groupNames -
      request -
      all - true = vsetky ankety, false = iba najnovsia
      Returns:

    • getInquiry

      public static InquiryBean getInquiry(String groupNames, int imagesLength, String percentageFormat, String orderBy, boolean ascending, javax.servlet.http.HttpServletRequest request, boolean random)
      vrati poslednu anketu zo zadanej skupiny
      Parameters:
      groupNames - - nazov skupiny ankiet
      imagesLength - - pocet generovanych obrazkov v stlpiku
      percentageFormat - - format vypisu percent
      orderBy - - SQL sposob usporiadania odpovedi
      ascending - - true ak je vzostupne usporiadanie
      request -
      random - - boolean hodnota, ci sa ma vybrat nahodna anketa alebo najnovsia
      Returns:

    • getInquiry

      public static InquiryBean getInquiry(int questionId, int imagesLength, String percentageFormat, String orderBy, boolean ascending, javax.servlet.http.HttpServletRequest request)
      Vrati anketu so zadanym id, urcene do JSP stranok s designom
      Parameters:
      questionId - - id anketu
      imagesLength - - pocet generovanych obrazkov v stlpiku
      percentageFormat - - format vypisu percent
      orderBy - - SQL sposob usporiadania odpovedi
      ascending - - true ak je vzostupne usporiadanie
      request -
      Returns:

    • getAnswers

      public static List<AnswerForm> getAnswers(int questionID, javax.servlet.http.HttpServletRequest request)

    • getAnswer

      public static AnswerForm getAnswer(int answerID, javax.servlet.http.HttpServletRequest request)
      nacita otazky a odpovede do List-u
      Parameters:
      answerID -
      request -
      Returns:

    • getQuestionGroups

      public static List<LabelValueDetails> getQuestionGroups(javax.servlet.http.HttpServletRequest request)
      nacita skupiny ankiet do listu
      Returns:

    • getQuestionGroupsByUser

      public static List<LabelValueDetails> getQuestionGroupsByUser(javax.servlet.http.HttpServletRequest request)
      nacita skupiny ankiet do listu a vyfiltruje podla povolenych kategorii pre usera
      Returns:

    • updateAnswer

      public static void updateAnswer(int qID, int aID, javax.servlet.http.HttpServletRequest request)
      incrementuje hodnotu(t.j. result) v odpovedi urcenej pomocou qID (ktora otazka) a aID(ktora odpoved)
      Parameters:
      qID -
      aID -
      request -

    • updateTotalClicks

      public static void updateTotalClicks(int qID, javax.servlet.http.HttpServletRequest request)
      inkrementuje premennu totalClicks na zaklade qID, co definuje anketu
      Parameters:
      qID - - identifikator ankety
      request -

    • getAllInquiry

      public static List<AnswerForm> getAllInquiry(javax.servlet.http.HttpServletRequest request)

    • getInquiries

      public static List<AnswerForm> getInquiries(List<String> groups, String questionText)
      Funkcia vrati zoznam objektov AnswerForm, ktore zodpovedaju vstupnym parametrom - otazka obsahuje text alebo/a patri do skupiny
      Parameters:
      groups - nazvy skupin, do ktorych musi patrit anketa
      questionText - text, ktory sa vyhladava v otazke
      Returns:
      Vrat zoznam objektov AnswerForm, ak ziadna z ankiet nevyhovuje podmienke, vrati prazdny zoznam (nie NULL)

    • getNewQuestionID

      public static int getNewQuestionID(javax.servlet.http.HttpServletRequest request)

    • addNewAnswer

      public static void addNewAnswer(int qID, AnswerForm answer, javax.servlet.http.HttpServletRequest request)

    • createNewQuestion

      public static void createNewQuestion(AnswerForm form, javax.servlet.http.HttpServletRequest request)

    • alterQuestion

      public static void alterQuestion(AnswerForm form, javax.servlet.http.HttpServletRequest request)

    • alterAnswerString

      public static void alterAnswerString(AnswerForm answer, javax.servlet.http.HttpServletRequest request)

    • deleteAnswer

      public static void deleteAnswer(int aID, javax.servlet.http.HttpServletRequest request)

    • deleteInquiry

      public static String deleteInquiry(int questionId, javax.servlet.http.HttpServletRequest request)

    • getQuestion

      public static AnswerForm getQuestion(int qID, javax.servlet.http.HttpServletRequest request)

    • getHoursCount

      public static int getHoursCount(int qID, javax.servlet.http.HttpServletRequest request)

    • getOldInquiry

      public static List<AnswerForm> getOldInquiry(String groupNames, boolean orderAscending)
      Vrati zoznam starych ankiet usporiadanych podla datumu platnosti
      Parameters:
      groupNames - - nazvy skupin oddelene ciarkou
      orderAscending - - ak je true je usporiadanie od najstarsich po najnovsie
      Returns:

    • getLastVoteDate

      public static Date getLastVoteDate(int userId, int questionId)
      Vrati najnovsi datum zahlasovania daneho pouzivatela pre danu anketu
      Parameters:
      userId - ID pouzivatela
      questionId - ID ankety
      Returns:
      najnovsi datum zahlasovania pre daneho pouzivatela

    • getAllInquiryByUser

      public static Object getAllInquiryByUser(javax.servlet.http.HttpServletRequest request)
      Vrati zoznam ankiet ako List AnswerForm vyfiltrovanych podla povolenych kategorii pre usera
      Parameters:
      request -
      Returns:

    • saveAnswer

      public static String saveAnswer(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response)
      Save answer in selected inquiry. Hadle logic and return path to some jsp taht represent "fail" or "ok" (may contain params).
      Parameters:
      request -
      response -
      Returns:
      Throws:
      IOException
      javax.servlet.ServletException