Package org.silverpeas.web.silverstatistics.control

Class SilverStatisticsPeasDAOConnexion

java.lang.Object

org.silverpeas.web.silverstatistics.control.SilverStatisticsPeasDAOConnexion

public class SilverStatisticsPeasDAOConnexion
extends Object

Class declaration Get connections data from database

Author:

Method Summary

Modifier and Type	Method	Description
static Collection[]	getStatsConnexion(String startDate, String endDate)	Returns the total number of connections per month.
static Collection<String[]>	getStatsConnexionAllAll(String startDate, String endDate)	donne les stats global pour l'enemble de tous les users cad 2 infos, la collection contient donc un seul element
static Collection<String[]>	getStatsConnexionAllGroup(String dateBegin, String dateEnd, int groupId)	Returns the group stats : Group name, number of connexions, mean connexion time and group id for all the users of a group.
static Collection<String[]>	getStatsConnexionGroupAll(String dateBegin, String dateEnd)	Returns the groups stats : group name, number of connexions, mean connexion time and group id for all the groups.
static Collection<String[]>	getStatsConnexionUser(String dateBegin, String dateEnd, int userId)	Returns the user stats : User last name, number of connexions, mean connexion time and user id.
static Collection<String[]>	getStatsConnexionUserAll(String dateBegin, String dateEnd)	Returns the user stats : User last name, number of connexions, mean connexion time and user id for all Silverpeas users.
static Collection[]	getStatsGroupConnexion(String startDate, String endDate, String groupId)	Returns the group stats : group name, number of connexions, mean connexion time and group id for all the specified group.
static Collection[]	getStatsUser(String startDate, String endDate)	Returns the number of distinct users connections per month.
static Collection[]	getStatsUserConnexion(String startDate, String endDate, String idUser)	Get user connection statistics
static Collection[]	getStatsUserFq(String startDate, String endDate, int min, int max)
static Collection<String>	getYears()

Methods inherited from class java.lang.Object

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

Method Detail

getStatsConnexionAllAll

public static Collection<String[]> getStatsConnexionAllAll(String startDate,
                                                           String endDate)
                                                    throws SQLException

donne les stats global pour l'enemble de tous les users cad 2 infos, la collection contient donc un seul element

Parameters:

startDate -

endDate -

Returns:

Throws:

SQLException

getStatsUser

public static Collection[] getStatsUser(String startDate,
                                        String endDate)
                                 throws SQLException,
                                        ParseException

Returns the number of distinct users connections per month.

Parameters:

startDate -

endDate -

Returns:

the number of distinct users connections per month.

Throws:

SQLException

ParseException

getStatsConnexion

public static Collection[] getStatsConnexion(String startDate,
                                             String endDate)
                                      throws SQLException,
                                             ParseException

Returns the total number of connections per month.

Parameters:

startDate -

endDate -

Returns:

the total number of connections per month.

Throws:

SQLException

ParseException

getStatsUserConnexion

public static Collection[] getStatsUserConnexion(String startDate,
                                                 String endDate,
                                                 String idUser)
                                          throws SQLException,
                                                 ParseException

Get user connection statistics

Parameters:

startDate - the start date

endDate - the end date

idUser - the user identifier

Returns:

an array of date and number of connections of a user between startDate and endDate

Throws:

SQLException

ParseException

getStatsGroupConnexion

public static Collection[] getStatsGroupConnexion(String startDate,
                                                  String endDate,
                                                  String groupId)
                                           throws SQLException,
                                                  ParseException

Returns the group stats : group name, number of connexions, mean connexion time and group id for all the specified group.

Parameters:

startDate - the start date

endDate - the end date

groupId - the group identifier

Returns:

the group stats : group name, number of connexions, mean connexion time and group id for all the groups.

Throws:

SQLException

ParseException

getStatsConnexionGroupAll

public static Collection<String[]> getStatsConnexionGroupAll(String dateBegin,
                                                             String dateEnd)
                                                      throws SQLException

Returns the groups stats : group name, number of connexions, mean connexion time and group id for all the groups.

Parameters:

dateBegin -

dateEnd -

Returns:

the group stats : group name, number of connexions, mean connexion time and group id for all the groups.

Throws:

SQLException

getStatsConnexionAllGroup

public static Collection<String[]> getStatsConnexionAllGroup(String dateBegin,
                                                             String dateEnd,
                                                             int groupId)
                                                      throws SQLException

Returns the group stats : Group name, number of connexions, mean connexion time and group id for all the users of a group.

Parameters:

dateBegin - .

dateEnd - .

groupId - .

Returns:

the group stats : Group last name, number of connexions, mean connexion time and group id for all the users of a group.

Throws:

SQLException

getStatsConnexionUserAll

public static Collection<String[]> getStatsConnexionUserAll(String dateBegin,
                                                            String dateEnd)
                                                     throws SQLException

Returns the user stats : User last name, number of connexions, mean connexion time and user id for all Silverpeas users.

Parameters:

dateBegin -

dateEnd -

Returns:

the user stats : User last name, number of connexions, mean connexion time and user id for all Silverpeas users.

Throws:

SQLException

getStatsConnexionUser

public static Collection<String[]> getStatsConnexionUser(String dateBegin,
                                                         String dateEnd,
                                                         int userId)
                                                  throws SQLException

Returns the user stats : User last name, number of connexions, mean connexion time and user id.

Parameters:

dateBegin -

dateEnd -

userId -

Returns:

Throws:

SQLException

getYears

public static Collection<String> getYears()
                                   throws SQLException

Returns:

if no statistic exist return current year, else return a collection of years which are loaded inside SB_Stat_ConnectionCumul table

Throws:

SQLException

getStatsUserFq

public static Collection[] getStatsUserFq(String startDate,
                                          String endDate,
                                          int min,
                                          int max)
                                   throws SQLException,
                                          ParseException

Parameters:

startDate -

endDate -

min -

max -

Returns:

Throws:

SQLException

ParseException