Class GetACARSDispatchStats

java.lang.Object

org.deltava.dao.DAO

org.deltava.dao.GetACARSDispatchStats

public class GetACARSDispatchStats
extends DAO

A Data Access Object to load Dispatcher Activity statistics.

Since:

3.2

Version:

11.4

Author:

Luke

Field Summary

Fields inherited from class org.deltava.dao.DAO

_queryMax, _queryStart, _queryTimeout, WGS84_SRID

Constructor Summary

Constructors

Constructor	Description
GetACARSDispatchStats(Connection c)	Initializes the Data Access Object.

Method Summary

Modifier and Type	Method	Description
List<DateRange>	getDispatchRanges()	Returns all date ranges with dispatched flights.
void	getDispatchTotals(Pilot p)	Loads dispatcher totals for a pilot.
Collection<DispatchStatistics>	getTopDispatchers(DateRange dr)	Returns all Dispatchers who provided service between two Dates.

Methods inherited from class org.deltava.dao.DAO

commitTransaction, createTimestamp, executeIDs, executeUpdate, executeUpdate, expandDate, formatDBName, formatLocation, getNewID, getQueryCount, prepare, prepareWithoutLimits, rollbackTransaction, setQueryMax, setQueryStart, setQueryTimeout, startTransaction, toID, toID, toInstant

Methods inherited from class java.lang.Object

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

Constructor Details

GetACARSDispatchStats

public GetACARSDispatchStats(Connection c)

Initializes the Data Access Object.

Parameters:

c - the JDBC connection to use

Method Details

getDispatchTotals

public void getDispatchTotals(Pilot p)
                       throws DAOException

Loads dispatcher totals for a pilot.

Parameters:

p - the Pilot bean

Throws:

DAOException - if a JDBC error occurs

getTopDispatchers

public Collection<DispatchStatistics> getTopDispatchers(DateRange dr)
                                                 throws DAOException

Returns all Dispatchers who provided service between two Dates.

Parameters:

dr - the DateRange

Returns:

a Collection of Database IDs

Throws:

DAOException - if a JDBC error occurs

getDispatchRanges

public List<DateRange> getDispatchRanges()
                                  throws DAOException

Returns all date ranges with dispatched flights.

Returns:

a Collection of DateRange beans

Throws:

DAOException - if a JDBC error occurs