Package sk.iway.iwcm.components.banner

Class BannerDB

java.lang.Object
sk.iway.iwcm.components.banner.BannerDB
public class BannerDB extends Object
BannerDB.java - zobrazovanie bannerov, praca s tabulkou banner_banners

  • Method Details

    • getAllBanners

      public static List<BannerBean> getAllBanners()
      Ziskanie zoznamu vsetky banerov (aj neaktivnych) z databazy
      Returns:

    • getBanners

      public static List<BannerBean> getBanners(String groups, String orderBy)
      Ziskanie banerov podla podmienok
      Parameters:
      groups - - zoznam skupin oddelenych ciarkou, alebo null
      orderBy - - nazov JAVA PROPERTY (nie stlpca v DB), podla ktoreho sa robi order
      Returns:

    • getBanners

      public static List<BannerBean> getBanners(String groups, String orderBy, String campaignBanner)
      vyfiltrujem vsetky bannery na zaklade campaignBanner. Ak nenajde, tak vratim vsetky
      Parameters:
      campaignBanner - - hodnota kampanoveho bannera ziskaneho z parametra

    • getBannerGroups

      public static List<BannerGroupBean> getBannerGroups()
      Ziskanie skupin bannerov
      Returns:

    • getBannerGroupsByUserAllowedCategories

      public static List<BannerGroupBean> getBannerGroupsByUserAllowedCategories(int userid)
      Ziska skupiny bannerov povolenych pre usera
      Parameters:
      userid - id usera
      Returns:

    • getBanner

      public static BannerBean getBanner(int bannerId)
      Ziskanie banera
      Parameters:
      bannerId - - id bannera
      Returns:

    • saveBanner

      public static boolean saveBanner(BannerBean banBean, int banId)
      Ulozenie banera do DB
      Parameters:
      banBean -
      banId -
      Returns:

    • deleteBanner

      public static boolean deleteBanner(int bannerId)
      Vymaze banner z DB
      Parameters:
      bannerId - - ID bannera v DB
      Returns:

    • getRandomBanner

      public static BannerBean getRandomBanner(String groups)

    • getRandomBanner

      public static BannerBean getRandomBanner(String groups, String campaignBanner)
      Vrati nahodny banner
      Parameters:
      groups - - zoznam skupin oddelenych ciarkou
      campaignBanner - - hodnota kampanoveho bannera ziskaneho z parametra
      Returns:

    • getRandomBanner

      public static BannerBean getRandomBanner(String groups, javax.servlet.http.Cookie[] cookie)
      Vrati nahodny banner - doplnene o cookie filtrovanie na zaklade cookieGroup
      Parameters:
      groups - - zoznam skupin oddelenych ciarkou
      Returns:

    • getNextBanner

      public static BannerBean getNextBanner(String groups, javax.servlet.http.HttpSession session, List<String> bannerList, String bannerIndex)
      Vrati nasledujuci banner v zozname
      Parameters:
      groups - - zoznam skupin oddelenych ciarkou
      session - - session
      bannerList - - zoznam bannerov, ktore som uz zobrazil
      bannerIndex - - index bannera v session
      Returns:

    • getNextBanner

      @Deprecated public static BannerBean getNextBanner(String groups, javax.servlet.http.HttpSession session, List<String> bannerList, int bannerIndex)
      Deprecated.
      pouzite verziu so stringom*

    • getNextBanner

      @Deprecated public static BannerBean getNextBanner(String groups, javax.servlet.http.HttpSession session, List<String> bannerList, int bannerIndex, javax.servlet.http.Cookie[] cookie)
      Deprecated.
      pozuite verziu so Stringom
      Returns:

    • getNextBanner

      public static BannerBean getNextBanner(String groups, javax.servlet.http.HttpSession session, List<String> bannerList, String bannerIndex, javax.servlet.http.Cookie[] cookie)

    • getNextBanner

      public static BannerBean getNextBanner(String groups, javax.servlet.http.HttpSession session, List<String> bannerList, String bannerIndex, javax.servlet.http.Cookie[] cookie, String campaignBanner)
      Doplnenie o fitrovanie cez cookie custom pre Ing
      Parameters:
      groups -
      session -
      bannerList -
      bannerIndex -
      campaignBanner - - hodnota kampanoveho bannera ziskaneho z parametra
      Returns:

    • getPriorityBanner

      public static BannerBean getPriorityBanner(String groups)

    • getPriorityBanner

      public static BannerBean getPriorityBanner(String groups, String campaignBanner)
      Vrati banner s najvyssou prioritou
      Parameters:
      groups - - zoznam skupin oddelenych ciarkou
      campaignBanner - - hodnota kampanoveho bannera ziskaneho z parametra
      Returns:

    • getPriorityBanner

      public static BannerBean getPriorityBanner(String groups, javax.servlet.http.Cookie[] cookie)

    • getFirstBannerForUrlByPriority

      public static BannerBean getFirstBannerForUrlByPriority(String url, String groups, String campaignBanner)
      Banner pre url - nahodny
      Parameters:
      url - - url stranky, pre ktoru chceme vratit zoznam bannerov
      groups - - nazov skup
      campaignBanner - - hodnota kampanoveho bannera ziskaneho z parametra

    • getBannerForUrlRandom

      public static BannerBean getBannerForUrlRandom(String url, String groups, String campaignBanner)
      Banner pre url - prvy podla najvyssej priority
      Parameters:
      url - - url stranky, pre ktoru chceme vratit zoznam bannerov
      groups - - nazov skup
      campaignBanner - - hodnota kampanoveho bannera ziskaneho z parametra

    • isBannerForUrl

      public static boolean isBannerForUrl(BannerBean banner, String url)
      vrati priznak, ci dany banner je pre danu url
      Parameters:
      banner -
      url -

    • statAddClick

      public static boolean statAddClick(int bannerId, javax.servlet.http.HttpServletRequest request)
      Update statistiky kliknuti na banner v DB
      Parameters:
      bannerId - - ID bannera v DB
      Returns:

    • statAddView

      public static boolean statAddView(int bannerId)
      Update statistiky videni bannera v DB
      Parameters:
      bannerId - - ID bannera v DB
      Returns:

    • getBannerStatViewsTimeData

      public static Map<String,Map<Date,Number>> getBannerStatViewsTimeData(Date from, Date to, int bannerId)
      vrati time serie VIDENI bannera pre graf
      Parameters:
      from - Description of the Parameter
      to - Description of the Parameter
      Returns:
      The topPagesTimeData value

    • getBannerStatClicksTimeData

      public static Map<String,Map<Date,Number>> getBannerStatClicksTimeData(Date from, Date to, int bannerId)
      vrati time serie KLIKNUTI bannera pre graf
      Parameters:
      from - Description of the Parameter
      to - Description of the Parameter
      bannerId - ID bannera
      Returns:
      The topPagesTimeData value

    • getTop10Banners

      public static List<Column> getTop10Banners(Date from, Date to, List<BannerGroupBean> bannerGroups)
      Parameters:
      from -
      to -
      Returns:

    • getTop10BannersViewsTimeData

      public static Map<String,Map<Date,Number>> getTop10BannersViewsTimeData(Date from, Date to, List<BannerGroupBean> bannerGroups)
      Parameters:
      from -
      to -
      bannerGroups -
      Returns:

    • getTop10BannersClicksTimeData

      public static Map<String,Map<Date,Number>> getTop10BannersClicksTimeData(Date from, Date to, List<BannerGroupBean> bannerGroups)
      Parameters:
      from -
      to -
      bannerGroups -
      Returns:

    • statAddViewExt

      public static boolean statAddViewExt(int bannerId, int inc, Date insertDate)
      Update statistiky videni bannera v DB
      Parameters:
      bannerId - - ID bannera v DB
      Returns:

    • getBannerNameFromLocation

      public static String getBannerNameFromLocation(String name, String location)

    • getBannersByUserId

      public static List<BannerBean> getBannersByUserId(String groups, String orderBy, int userId)
      Ziskanie uzivatelskych bannerov
      Parameters:
      userId -
      Returns:

    • getTop10BannersByUserId

      public static List<Column> getTop10BannersByUserId(Date from, Date to, int userId, List<BannerGroupBean> bannerGroups)
      Ziskanie uzivatelskych bannerov pre statistiku
      Parameters:
      from -
      to -
      userId -
      Returns:

    • getBannerAccess

      public static boolean getBannerAccess(int bannerId, int userId)
      Metoda vrati true ak uzivatel ma pravo vidiet banner so zadanym bannerId, v opacnom pripade vrati false
      Parameters:
      bannerId -
      userId -
      Returns:

    • isBannerActive

      public static boolean isBannerActive(BannerBean banner)
      Zistuje platnost baneru, ci je aktivny, banerovu exspiraciu, ci nieje prekoreceny pocet zobrazeni
      Parameters:
      banner -
      Returns:

    • getOnlyAvailable

      public static List<BannerBean> getOnlyAvailable(List<BannerBean> banners)

    • getOnlyAvailable

      public static List<BannerBean> getOnlyAvailable(List<BannerBean> banners, String campaignBanner)
      prefiltruje zoznam banerov a vrati dostupne banery a v pripade obsahovych len take, ktore sa nezobrazuju len pri kampani
      Parameters:
      banners -
      campaignBanner - - hodnota kampanoveho bannera ziskaneho z parametra

    • getVisitorCookieGroup

      public static List<BannerBean> getVisitorCookieGroup(List<BannerBean> banners, javax.servlet.http.Cookie[] cookie)
      Vrati iba tie banery, ktore vyhovuju skupine v cookies. Ak je cookie prazdna vrati null alebo jeden banner.
      Parameters:
      banners -
      cookie -
      Returns:

    • isBannerCampaignOnly

      public static boolean isBannerCampaignOnly(BannerBean banner)
      Metoda zisti ci je banner kampanovy, tzn. zobrazuje sa iba pri kampani
      Parameters:
      banner -
      Returns:
      true alebo false podla toho ci je banner kampanovy