The JaSPer program handles contest scoring at the contest site. When the contest is complete -- or between flights, if desired -- the scorer uploads results to a Ruby on Rails application called IACCDB that runs on the iac.org web server.
In order to present contest results with the same look and feel as other content, we've coded a JSON interface between IACCDB and the Drupal web framework that powers www.iac.org. The following Drupal pages are coded in PHP; they send an HTTP request to IACCDB, receive JSON-encoded data in return, and display the data:
- proto-contests - lists all of the contests for a given year (name will probably change to contest-results)
- proto-contest: outputs the results of a given contest; categories, competitors, and judges (name will probably change to contest-result)
TODOs:
- Implement index pages (lists of pilots, judges, assistants)
- Implement individual pages for each pilot, judge, and assistant
- Add a search-by-name capability. E.g., I should be able to type "Holland" into a search box and get a list of links to the various contests in which he participated -- as a pilot, judg, and/or assistant.
- Build a JSON display that gives, for the current the number of flights judged and/or assisted during the previous and current calendar for every judge and assistant in the database.
- Implement "Leaders" pages: Regional, Collegiate, Soucy, Judges.
- Auto-link pilot & judge results to the user's login ID (e.g., a "My Results" menu link?)
- Pare down the judging-metrics page to eliminate stats we're not going to display.
- Change proto-contest and proto-contests to more suitable permanent names.
- Change all "Sidebar 2" blocks to prevent display on the new page names (currently avoids rendering on proto-contest and proto-contests)
