Package com.ubs.backend.classes.database.dao.statistik

Class UnansweredQuestionStatistikDAO

java.lang.Object

com.ubs.backend.classes.database.dao.DAO<UnansweredQuestionStatistik>

com.ubs.backend.classes.database.dao.statistik.UnansweredQuestionStatistikDAO

public class UnansweredQuestionStatistikDAO
extends DAO<UnansweredQuestionStatistik>

Since:

17.07.2021

Author:

Tim Irmler

Constructor Summary

Constructors

Constructor	Description
UnansweredQuestionStatistikDAO()

Method Summary

Modifier and Type	Method	Description
List<TempAmountWithDate>	countAskedAmountByTime(long userID, TimeSearchType time, StatistikTimes statistikTimes)
List<TempAmountWithDate>	countAskedAmountByTime(TimeSearchType time, StatistikTimes statistikTimes)
List<TempAmountWithDate>	countAskedAmountByTime(Long userID, TimeSearchType time, StatistikTimes statistikTimes, javax.persistence.EntityManager em)
List<TempAmountWithDate>	countAskedAmountDay(StatistikTimes times, javax.persistence.EntityManager em)
List<TempAmountWithDate>	countAskedAmountGroupedByDay(javax.persistence.EntityManager em)
List<TempAmountWithDate>	countAskedAmountGroupedByYear(javax.persistence.EntityManager em)
List<TempAmountWithDate>	countAskedAmountMonth(StatistikTimes times, javax.persistence.EntityManager em)
List<TempAmountWithDate>	countAskedAmountSinceLastLogin(long userID, javax.persistence.EntityManager em)
Long	countAskedAmountSingleHour(StatistikTimes times, javax.persistence.EntityManager em)
List<TempAmountWithDate>	countAskedAmountWeek(StatistikTimes times, javax.persistence.EntityManager em)
List<TempAmountWithDate>	countAskedAmountYear(StatistikTimes times, javax.persistence.EntityManager em)
boolean	removeByQuestion(long id, javax.persistence.EntityManager em)
List<TempUnansweredQuestion>	selectByDayGroupedByQuestion(StatistikTimes times, javax.persistence.EntityManager em)
List<TempUnansweredQuestion>	selectByHourGroupedByQuestion(StatistikTimes times, javax.persistence.EntityManager em)
List<TempUnansweredQuestion>	selectByMonthGroupedByQuestion(StatistikTimes times, javax.persistence.EntityManager em)
UnansweredQuestionStatistik	selectByQuestion(String question)
UnansweredQuestionStatistik	selectByQuestion(String question, javax.persistence.EntityManager em)
List<TempUnansweredQuestion>	selectByTimeGroupedByQuestion(long userID, TimeSearchType time, StatistikTimes statistikTimes)
List<TempUnansweredQuestion>	selectByTimeGroupedByQuestion(TimeSearchType time, StatistikTimes statistikTimes)
List<TempUnansweredQuestion>	selectByTimeGroupedByQuestion(Long userID, TimeSearchType time, StatistikTimes statistikTimes, javax.persistence.EntityManager em)
List<TempUnansweredQuestion>	selectByWeekGroupedByQuestion(StatistikTimes times, javax.persistence.EntityManager em)
List<TempUnansweredQuestion>	selectByYearGroupedByQuestion(StatistikTimes times, javax.persistence.EntityManager em)
List<TempUnansweredQuestion>	selectGroupedByQuestion(javax.persistence.EntityManager em)
List<UnansweredQuestionStatistik>	selectOrderedByAskedAmount(int max)
List<UnansweredQuestionStatistik>	selectOrderedByAskedAmount(int max, javax.persistence.EntityManager em)
List<TempUnansweredQuestion>	selectSinceLastLoginGroupedByQuestion(long userID, javax.persistence.EntityManager em)

Methods inherited from class com.ubs.backend.classes.database.dao.DAO

insert, insert, merge, remove, remove, remove, select, select, select, select

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

UnansweredQuestionStatistikDAO

public UnansweredQuestionStatistikDAO()

Method Details

selectOrderedByAskedAmount

public List<UnansweredQuestionStatistik> selectOrderedByAskedAmount(int max)

selectOrderedByAskedAmount

public List<UnansweredQuestionStatistik> selectOrderedByAskedAmount(int max,
 javax.persistence.EntityManager em)

selectByQuestion

public UnansweredQuestionStatistik selectByQuestion(String question,
 javax.persistence.EntityManager em)

selectByQuestion

public UnansweredQuestionStatistik selectByQuestion(String question)

selectByTimeGroupedByQuestion

public List<TempUnansweredQuestion> selectByTimeGroupedByQuestion(long userID,
 TimeSearchType time,
 StatistikTimes statistikTimes)

Parameters:

userID -

time -

statistikTimes -

Returns:

Since:

29.08.2021

selectByTimeGroupedByQuestion

public List<TempUnansweredQuestion> selectByTimeGroupedByQuestion(TimeSearchType time,
 StatistikTimes statistikTimes)

Parameters:

time -

statistikTimes -

Returns:

selectByTimeGroupedByQuestion

public List<TempUnansweredQuestion> selectByTimeGroupedByQuestion(Long userID,
 TimeSearchType time,
 StatistikTimes statistikTimes,
 javax.persistence.EntityManager em)

Parameters:

userID -

time -

statistikTimes -

em -

Returns:

selectByHourGroupedByQuestion

public List<TempUnansweredQuestion> selectByHourGroupedByQuestion(StatistikTimes times,
 javax.persistence.EntityManager em)

selectByDayGroupedByQuestion

public List<TempUnansweredQuestion> selectByDayGroupedByQuestion(StatistikTimes times,
 javax.persistence.EntityManager em)

selectByWeekGroupedByQuestion

public List<TempUnansweredQuestion> selectByWeekGroupedByQuestion(StatistikTimes times,
 javax.persistence.EntityManager em)

selectByMonthGroupedByQuestion

public List<TempUnansweredQuestion> selectByMonthGroupedByQuestion(StatistikTimes times,
 javax.persistence.EntityManager em)

selectByYearGroupedByQuestion

public List<TempUnansweredQuestion> selectByYearGroupedByQuestion(StatistikTimes times,
 javax.persistence.EntityManager em)

selectSinceLastLoginGroupedByQuestion

public List<TempUnansweredQuestion> selectSinceLastLoginGroupedByQuestion(long userID,
 javax.persistence.EntityManager em)

Parameters:

userID -

em -

Returns:

Since:

29.08.2021

selectGroupedByQuestion

public List<TempUnansweredQuestion> selectGroupedByQuestion(javax.persistence.EntityManager em)

countAskedAmountByTime

public List<TempAmountWithDate> countAskedAmountByTime(long userID,
 TimeSearchType time,
 StatistikTimes statistikTimes)

Parameters:

time -

statistikTimes -

Returns:

Since:

29.08.2021

countAskedAmountByTime

public List<TempAmountWithDate> countAskedAmountByTime(TimeSearchType time,
 StatistikTimes statistikTimes)

Parameters:

time -

statistikTimes -

Returns:

Since:

25.08.2021

countAskedAmountSingleHour

public Long countAskedAmountSingleHour(StatistikTimes times,
 javax.persistence.EntityManager em)

Parameters:

times -

em -

Returns:

Since:

25.08.2021

countAskedAmountByTime

public List<TempAmountWithDate> countAskedAmountByTime(Long userID,
 TimeSearchType time,
 StatistikTimes statistikTimes,
 javax.persistence.EntityManager em)

Parameters:

time -

statistikTimes -

em -

Returns:

Since:

25.08.2021

countAskedAmountDay

public List<TempAmountWithDate> countAskedAmountDay(StatistikTimes times,
 javax.persistence.EntityManager em)

Parameters:

times -

em -

Returns:

Since:

25.08.2021

countAskedAmountWeek

public List<TempAmountWithDate> countAskedAmountWeek(StatistikTimes times,
 javax.persistence.EntityManager em)

Parameters:

times -

em -

Returns:

Since:

25.08.2021

countAskedAmountMonth

public List<TempAmountWithDate> countAskedAmountMonth(StatistikTimes times,
 javax.persistence.EntityManager em)

Parameters:

times -

em -

Returns:

Since:

25.08.2021

countAskedAmountYear

public List<TempAmountWithDate> countAskedAmountYear(StatistikTimes times,
 javax.persistence.EntityManager em)

Parameters:

times -

em -

Returns:

Since:

25.08.2021

countAskedAmountSinceLastLogin

public List<TempAmountWithDate> countAskedAmountSinceLastLogin(long userID,
 javax.persistence.EntityManager em)

Parameters:

userID -

em -

Returns:

Since:

29.08.2021

countAskedAmountGroupedByDay

public List<TempAmountWithDate> countAskedAmountGroupedByDay(javax.persistence.EntityManager em)

Parameters:

em -

Returns:

Since:

29.08.2021

countAskedAmountGroupedByYear

public List<TempAmountWithDate> countAskedAmountGroupedByYear(javax.persistence.EntityManager em)

Parameters:

em -

Returns:

Since:

25.08.2021

removeByQuestion

public boolean removeByQuestion(long id,
 javax.persistence.EntityManager em)