StatsDataClass

[mark1million]

Build new queries to display for pilots active, inactive and annual leave / holiday.

[nabeelio]

You can do:

$pilots_list = PilotData::findPilots(array('p.retired' => VALUE OF STATUS));

All of those functions call back to the function above

[nabeelio]

There's also a new query function which a lot of the StatsData has been converted to use:

$pilot_count = StatsData::getTotalForCol(array(
        'table' => 'pilots',
        'column' => '*',
        'where' => array('retired' => RETIRED STATUS),
        )
    );