Class GetPilotRecognition

java.lang.Object

org.deltava.dao.DAO

org.deltava.dao.PilotReadDAO

org.deltava.dao.GetPilot

org.deltava.dao.GetPilotRecognition

public class GetPilotRecognition
extends GetPilot

A Data Acccess Object to read Pilots that have achieved certain accomplishments.

Since:

1.0

Version:

9.1

Author:

Luke

Field Summary

Fields inherited from class org.deltava.dao.PilotReadDAO

_cache

Fields inherited from class org.deltava.dao.DAO

_queryMax, _queryStart, _queryTimeout, WGS84_SRID

Constructor Summary

Constructors

Constructor	Description
GetPilotRecognition(Connection c)	Initialize the Data Access Object.

Method Summary

Modifier and Type	Method	Description
Collection<Pilot>	getByAccomplishment(int id)	Loads all pilots having achieved a particular Accomplishment.
Collection<Integer>	getNominationEligible()	Returns Pilots eligible for promotion to Senior Captain.
Collection<Integer>	getPromotionQueue(String eqType)	Returns Pilots eligible for promotion to Captain.
int	hasPromotionQueue(String eqType)	Returns whether there are Pilots eligible for promotion to Captain in a particular Equipment program.
static void	invalidate(String eqType)	Invalidates the Promotion Queue caches.

Methods inherited from class org.deltava.dao.GetPilot

getActivePilots, getByEMail, getCurrencyPilots, getNewestPilots, getPilotByCode, getPilots, getPilotsByEQ, getPilotsByLetter, getPilotsByRank, getPilotsByStatus, search, search

Methods inherited from class org.deltava.dao.PilotReadDAO

execute, get, get, get, getByID, getByName, loadAccomplishments, loadChildRows, loadIMAddrs, loadPushEndpoints, loadRatings, loadRoles, updatePilotCodes

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

GetPilotRecognition

public GetPilotRecognition(Connection c)

Initialize the Data Access Object.

Parameters:

c - the JDBC connection to use

Method Details

invalidate

public static void invalidate(String eqType)

Invalidates the Promotion Queue caches.

Parameters:

eqType - the equipment type, or null to invalidate all

getByAccomplishment

public Collection<Pilot> getByAccomplishment(int id)
                                      throws DAOException

Loads all pilots having achieved a particular Accomplishment.

Parameters:

id - the Accomplishment database ID

Returns:

a Collection of Pilots

Throws:

DAOException - if a JDBC error occurs

hasPromotionQueue

public int hasPromotionQueue(String eqType)
                      throws DAOException

Returns whether there are Pilots eligible for promotion to Captain in a particular Equipment program.

Parameters:

eqType - the equipment program, or null for all

Returns:

the number of pilots

Throws:

DAOException - if a JDBC error occurs

getPromotionQueue

public Collection<Integer> getPromotionQueue(String eqType)
                                      throws DAOException

Returns Pilots eligible for promotion to Captain.

Parameters:

eqType - the Equipment program, or null for all programs

Returns:

a List of Pilot IDs

Throws:

DAOException - if a JDBC error occurs

getNominationEligible

public Collection<Integer> getNominationEligible()
                                          throws DAOException

Returns Pilots eligible for promotion to Senior Captain.

Returns:

a Collection of database IDs

Throws:

DAOException - if a JDBC error occurs