Package sk.iway.iwcm.calendar

Class CalendarDB

java.lang.Object
sk.iway.iwcm.calendar.CalendarDB
public class CalendarDB extends Object
CalendarDB - kalendar podujati, meniny

  • Field Details

  • Constructor Details

    • CalendarDB

      public CalendarDB()

  • Method Details

    • getEvents

      public static List<CalendarDetails> getEvents(javax.servlet.http.HttpServletRequest request)
      vrati zoznam udalosti kalendara v zavislosti na parametroch v requeste
      Parameters:
      request -
      Returns:

    • getEvent

      public static CalendarDetails getEvent(int calendarId, javax.servlet.http.HttpServletRequest request)

    • getEvent

      public static CalendarDetails getEvent(int calendarId)
      Ziska zaznam v kalendari
      Parameters:
      calendarId -
      Returns:

    • main

      public static void main(String[] args)
      Toto sa vola z crontabu kazdych 10 minut
      Parameters:
      args -

    • sendNotify

      public static void sendNotify()
      Posle notifikaciu emailom

    • getEmail

      public static String getEmail(String from)
      Vrati meno zo stringu typu Peter Weber <peter@domain.sk>
      Parameters:
      from - Description of the Parameter
      Returns:
      The email value

    • getName

      public static String getName(String from)
      Vrati email zo stringu typu Peter Weber <peter@domain.sk>
      Parameters:
      from - Description of the Parameter
      Returns:
      The name value

    • getMeniny

      public static String getMeniny(String lng, int offset)
      Vrati meniny pre dany jazyk a dnovy posun
      Parameters:
      lng - - jazyk
      offset - - pocet dni posunu
      Returns:

    • getInvitations

      public static List<CalendarInvitationDetails> getInvitations(int calendarId)
      Vrati zoznam pozvanok so stavmi pre zadany zaznam kalendara
      Parameters:
      calendarId -
      Returns:

    • getInvitation

      public static CalendarInvitationDetails getInvitation(int calendarInvitationId)
      Vrati pozvanku so zadanym ID
      Parameters:
      calendarInvitationId -
      Returns:

    • setCalendarInvitationStatus

      public static boolean setCalendarInvitationStatus(int calendarInvitationId, String status)
      Aktualizuje stav pozvanky, status je char(1) a mal by mat hodnoty: -=nenastavene A=accepted D=declined T=tentative
      Parameters:
      calendarInvitationId -
      status -

    • getInvitationByUser

      public static CalendarInvitationDetails getInvitationByUser(int calendarId, int userId)
      vrati pozvanku podla uzivatela
      Parameters:
      calendarId -
      userId -
      Returns:

    • getAllAcceptedInvitations

      public static List<CalendarInvitationDetails> getAllAcceptedInvitations(int calendarId)
      vrati vsetky akceptovane pozvanky na zaklade calendarId
      Parameters:
      calendarId -
      Returns:

    • saveCalendarInvitation

      public static boolean saveCalendarInvitation(int calendarId, int userId)
      ulozi pozvanku do DB (bez poslania mailu)
      Parameters:
      calendarId -
      userId -
      Returns:

    • getNotApprovedEvents

      public static List<CalendarDetails> getNotApprovedEvents(int userId)
      vrati vsetky neschvalene udalosti ktore ma user s userId schvalit
      Parameters:
      userId -
      Returns:

    • getEventsByUserId

      public static List<CalendarDetails> getEventsByUserId(int userId)
      vrati vsetky uzivatelove udalosti
      Parameters:
      userId -
      Returns:

    • saveEventToDB

      public static boolean saveEventToDB(EventForm event)

    • saveApproveStatus

      public static boolean saveApproveStatus(int eventId, int status, boolean sendEmail)
      nastavi status udalosti o jej schvaleni/neschvaleni
      Parameters:
      eventId -
      status -
      sendEmail - - ak je false, tak sa neposle mail o schvaleni/meschvaleni udalosti
      Returns:

    • getEventsByUserIdDateStatus

      public static List<CalendarDetails> getEventsByUserIdDateStatus(int userId, String dateFrom, String dateTo, String status)
      vrati vsetky udalosti od-do(dateFrom-dateTo) ktorych sa zucastni/nezucasti uzival userId
      Parameters:
      userId -
      dateTo -
      dateFrom -
      status - - 'A'/'D'- vrati udalosti kde uzivatel potvrdil/zamietol ucast, '-' - vrati vsetky udalosti
      Returns:

    • getEventsByRegionAndType

      public static List<CalendarDetails> getEventsByRegionAndType(javax.servlet.http.HttpServletRequest request, int[] eventTypes, String region)
      vrati akcie podla urcitych regionov a podla typu akcie
      Parameters:
      request -
      Returns:

    • getEventsByRegionAndType

      public static List<CalendarDetails> getEventsByRegionAndType(javax.servlet.http.HttpServletRequest request, int userId)
      vrati akcie podla urcitych regionov a podla typu akcie, ktore ma uzivatel nastavene
      Parameters:
      request -
      Returns:

    • getEventsByRegionAndType

      public static List<CalendarDetails> getEventsByRegionAndType(javax.servlet.http.HttpServletRequest request)
      vrati akcie podla urcitych regionov a podla typu akcie, ktore ma uzivatel nastavene
      Parameters:
      request -
      Returns:

    • setSuggestEvents

      public static boolean setSuggestEvents(int odporucitAkcia, String odporuceneId)
      nastavi odporucane udalosti podla akcie
      Parameters:
      odporucitAkcia -
      odporuceneId -
      Returns:

    • fullTextSearch

      public static List<CalendarDetails> fullTextSearch(String vyraz)
      fulltext vyhladavanie v title,description
      Parameters:
      vyraz -
      Returns:

    • getEventsForNotify

      public static List<CalendarDetails> getEventsForNotify(long calStart, long calEnd)
      vrati udalosti pre notifikacie
      Parameters:
      calStart -
      calEnd -
      Returns:

    • sendListEventsNotify

      public static void sendListEventsNotify(String serverName)
      posle mail so zoznamom udalosti podla notifikacnych nastaveni uzivatela

    • getEventsForDay

      public static List<CalendarDetails> getEventsForDay(List<CalendarDetails> events, long datum)
      vrati akcie pre zadany den z ArrayListu
      Parameters:
      events -
      datum -
      Returns:

    • getApprovedEvents

      public static List<CalendarDetails> getApprovedEvents(javax.servlet.http.HttpServletRequest request)
      vrati vsetky schvalene udalosti
      Parameters:
      request -
      Returns:

    • saveEventPublicToDB

      public static boolean saveEventPublicToDB(EventForm event, String domain, String approverMail, Prop prop)
      ulozi verejnu udalost do databazy ako neschvalenu a posle mail schvalovatelovi
      Parameters:
      event -
      domain -
      approverMail -
      Returns:

    • savePublicApproveStatus

      public static boolean savePublicApproveStatus(int eventId, int status)
      nastavi status verejnej udalosti o jej schvaleni/neschvaleni
      Parameters:
      eventId -
      status -
      Returns: