DevelopmentNotes

Provide More detailed development notes

2013-07-27

Scheduling

• DB updates:
  • split ev table data into ev and lc
    • location data no longer in ev directly, need to do a left join on ev.ev_lcid = lc.lcid
  • still loading previous ev data into evo table (will remove support once things better established)
  • Programmatically creating a sort order table now
    • Generate all possible division ranges for 6-17 with an ordering value - overkill, but should handle things well
  • Add distance matrix table
    • Not currently populated, but will eventually be populated with distances between sites obtained via Google Distance API
• Add support for git tags with version numbers in them!
• Add code to load scheduling location data into new lc table
• New FTP sync script to upload the mobile DB to mobile live site
• Pushed out updates to primary sched server (d7k)

Mobile

• Code updates to support db schema update.
• Add version info in credits section
• Add support for git tags with version numbers in them!
• Pushed new version up to http://m.usyvl.org

USYVL Notes from 2013-10-14

Mobile

USYVL staff found some issues with the current mobile deployment.

• auto mode has issues with locations shown
  • This was a code issue with a wrong variable
• The list of matches for a single team has intersite game days all listed as Home Games
  • This is due to the data organization and there is not really a way around it with the current structure.
    • When event list is parsed, an event id is assigned to each incoming entry that goes into the db.
    • Tournaments end up creating multiple event ids as there is an event entry for each program attending
    • All match info is attached to the Home Game event id.
    • We need each of the labels, (as shown by the errors discovered)
    • But we also need a way to associate the correct event id label to the tournament data
• A number of labels need updating

Additional Development

• scorekeeper - modified to allow changing of colors and initialization at the correct color
• added a javascript clock to many of the mobile pages so time can be seen in-site
• link tournament entries and team matches entries to scorekeeper, passing in colors and team names
• improved navigation between pools of a given intersite game day

Still ToDo from this go round

• restructure navigation to program level
• possibly combine Tournament Summary and Tournament Pool displays
• help for scorekeeper
• settings - cookies?
• possibly add match times to scorekeeper???
• db restructuring - add a tnid of some type to link together the various evids for tournaments

2013-10-24

Dealt with a number of major tasks on Mobile site:

• cleanup of social media links
• merging of code to use one template file, abandoning the other
• improved styling of social network links (issues with facebook follow)
• added a dev menu at very bottom to contain links to bleeding edge stuff
• moved a couple more devish items into the menu above
• added game summaries support
• added links to game summaries from instructional summaries
• added scorekeeping links to games summaries
• major cleanup of digital clock code
  • reduce risk of namespace collisions by changing names
  • fix several issues with original version - was very inefficient
• added an about menu item - with mission and benefits
• expanded author information a bit in credits
• reorganize some of the core functions - to improve locality of menu and actual methods
• add program name to a couple locations on the program info pages

Made another pass as stuff later in that day

A few more enhancements and fixed a few things broken with last update:

• Added some debugging output for locator - issue was missing db records
• Fixed styling of teamMatches
• Added links to tournament and game info pages from teamMatches
• Programmtically added the digitalClock to many of the summaries that could use it
• Potentially fixed the issue with scoreKeeper not updating the scorePad colors correctly
  • Pretty sure fixed the jump back to top part anyway, possibly related.
• Added the testing/testLocator script to the indev page
• Fixed broken paths in testing/testLocator (because it is at a different level in heirarchy now)

Still to do from this round of dev

• Clean up site info page
  • improve page appearance.
  • With the addition of links for both tournaments and games not from the instructional summaries, we can downplay the game and tournament summaries lists
• address renaming issues from USYVL notes above
• mid-term solution of making tournament summaries/pool more agnostic (no Away or Home once they get that far)....
• locator
  • clean up locator debug code
  • add in links to particular entries