Provide quarterly summaries

[mjennings061]

As a pilot, I want to have a quarterly summary provided by this program, so that I can save time calculating my launches for the quarter.

Required outputs:

• Launches this quarter
• SCT this quarter
• Last PLF

Possible implementation:

• Use a MongoDB filter query to provide a list of where the person is aircraft commander e.g. AircraftCommander == Name
• Use a second query to provide a list of where SCT is recorded and the second pilot/trainee is the person e.g. Duty == SCT && SecondPilot == Name
• For last PLF, get the SCT list from the point above. Sort by date and take the first element

[mjennings061]

Possible SQL solution:

1. Use a WHERE "AircraftCommander" == name
2. Use a WHERE "2ndPilot" == name AND ("Duty" == "SCT U/T" OR "Duty" == "SCT QGI")
3. Use a UNION to link the two tables

[mjennings061]

MongoDB charts does not support this level of grouping. A separate collection should be created as a summary for each pilot The processing should be done in python to do the following:

for name in AircraftCommander: 
   select where AircraftCommander == name in log_sheets as commander
   select where SecondPilot == name in log_sheets as second
   select where Duty is AGT, SCT U/T or SCT QGI in second
   union commander and second
   add to "Pilot" collection under name