Class GetFlightReportACARS

java.lang.Object

org.deltava.dao.DAO

org.deltava.dao.GetFlightReports

org.deltava.dao.GetFlightReportACARS

public class GetFlightReportACARS
extends GetFlightReports

A Data Access Object to retrieve ACARS Flight Reports from the database.

Since:

1.0

Version:

11.5

Author:

Luke

Field Summary

Fields inherited from class org.deltava.dao.DAO

_queryMax, _queryStart, _queryTimeout, WGS84_SRID

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method	Description
List<FlightReport>	checkDupes(String dbName, int acarsID)	Checks for duplicate ACARS flight submisions.
List<FlightReport>	checkDupes(String dbName, Flight f, int pilotID)	Checks for duplicate ACARS flight submissions.
List<Airframe>	getAirframes(String eqType, Airline a, int pilotID)	Returns all airframes used for flights in a given Equipment Type and Airline.
List<FlightReport>	getByDate(Instant dt)	Returns all Flight Reports flown on a certain date.
List<FlightReport>	getByPilot(int id, String orderBy)	Returns all Flight Reports for a particular Pilot, using a sort column.
List<FlightReport>	getBySDK(String sdkName)	Returns alll Flight Reports logged using a specific aircraft SDK.

Methods inherited from class org.deltava.dao.GetFlightReports

execute, get, getACARS, getByAssignment, getByEvent, getByNetwork, getByPilot, getByStatus, getByTour, getCaptEQType, getCheckRideQueueSize, getDiversion, getDraft, getDraftReports, getElite, getEliteFlights, getHeld, getLogbookCalendar, getOnlineTotals, getOnlineTotals, getRoutePairs, loadCaptEQTypes

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

GetFlightReportACARS

public GetFlightReportACARS(Connection c)

Initializes the Data Access Object.

Parameters:

c - the JDBC connection to use

Method Details

getAirframes

public List<Airframe> getAirframes(String eqType,
 Airline a,
 int pilotID)
                            throws DAOException

Returns all airframes used for flights in a given Equipment Type and Airline. This will not have populated SimBrief custom airframe IDs.

Parameters:

eqType - the Equipment Type

a - the Airline

pilotID - the Pilot database ID, or zero for all Pilots

Returns:

a List of tail codes, order by descending popularity

Throws:

DAOException - if a JDBC error occurs

getByDate

public List<FlightReport> getByDate(Instant dt)
                             throws DAOException

Returns all Flight Reports flown on a certain date.

Parameters:

dt - the date

Returns:

a List of FlightReports

Throws:

DAOException - if a JDBC error occurs

getBySDK

public List<FlightReport> getBySDK(String sdkName)
                            throws DAOException

Returns alll Flight Reports logged using a specific aircraft SDK.

Parameters:

sdkName - the SDK name

Returns:

a List of FlightReports

Throws:

DAOException - if a JDBC error occurs

getByPilot

public List<FlightReport> getByPilot(int id,
 String orderBy)
                              throws DAOException

Returns all Flight Reports for a particular Pilot, using a sort column.

Parameters:

id - the Pilot database ID

orderBy - the sort column (or null)

Returns:

a List of FlightReports

Throws:

DAOException - if a JDBC error occurs

checkDupes

public List<FlightReport> checkDupes(String dbName,
 Flight f,
 int pilotID)
                              throws DAOException

Checks for duplicate ACARS flight submissions.

Parameters:

dbName - the database name

f - the Flight information

pilotID - the Pilot's database ID

Returns:

a List of FlightReport beans

Throws:

DAOException - if a JDBC error occurs

checkDupes

public List<FlightReport> checkDupes(String dbName,
 int acarsID)
                              throws DAOException

Checks for duplicate ACARS flight submisions.

Parameters:

dbName - the database name

acarsID - the ACARS flight ID

Returns:

a List of FlightReport beans

Throws:

DAOException - if a JDBC error occurs