PMNC Admin ChangeLog
Version 1.1.0 (Official Release)
11-Apr-2008- Added login redirect for coaches and atheletic directors
- Added win percentage for league record on the team stat page
- Added team-type filtering for team drop down list on the event page
- Increased with width of the columns on the team stat page for totals
- Added a drop down filter for team season on the team page
- Added a default script to set the season to the current season on the team page
- Added five additional seasons to the season drop down list
- Added a checkbox on the team edit page that allows the user to create a new season for a given team
- Added a game summary for each team on their player statistics page
- Addee a season summary for each team on their team statistics page
- Added scrimmage option as a game type on the event page
- Added yac (yards after contact) for rushing on the football statistics
- Added an icon link to each player in the admin console to link to the putmencoach site
- Installed ImageMagick on the production server
Version 1.0.29
20-Feb-2008- Added relay stats to swimming meet.
- Updated swimming stat times to record hundreths of a second
Version 1.0.28
19-Feb-2008- Changed default date for new athleete to 01 Jan 1990.
- Changed max value for score to 999.
- Updated service.php to store swimming stats by meet.
- Set up service.php to run every 60 minutes on the production server.
- Added validation to be sure that team gender and sport are the same on schedule edit page
Version 1.0.27
15-Feb-2008- Added points display at the meet level.
- Added simple interface for meets that have only two teams.
- Added popup score edit for meets.
- Added single interface for meet edit.
Version 1.0.26
08-Feb-2008- Added golf stats.
- Added Tournament Teams
- Added Tournament Games
- Added Tournament Entry Fields to Game Edit Page
Version 1.0.25
07-Feb-2008- Added support for multiple team ids for coaches and statisticians.
- Added settings menu for non-admin users so they can change their password or profile information.
- Added tournaments.
Version 1.0.24
04-Feb-2008- Added GAL to soccer stats
- Added Gymnastics
- Added Cheerleaders
- Added school field and filter to security
- Added category view for football stats
Version 1.0.23
30-Jan-2008- Added vollyball stats.
Version 1.0.22
24-Jan-2008- Added functionality to filter wrestling stats by weight class. You can pass in a variable (wcd) to override the default. See documentation for details.
- Added functionality to filter team types and leagues in the team edit page.
- Updated wrestling stat summary generator to use record wins and losses in member table instead of calculating them from the stats. This will be temporary until stats are entered.
- Added filter for stat summaries to only include those that have played at least n number of games. You can pass in a variable to (gpm) to override the default. See documentation for details.
- Added League President, Website, Particpants, Address/City/Zip and Sponsors to Youth League edit page
Version 1.0.21
17-Jan-2008- Added role-based authentication based on permission sets that are processed and persisted to MySQL.
Version 1.0.20
13-Jan-2008- Added Youth Leagues, Teams, Sports and Stats.
- Updated Team page to include one field for coach name instead of two.
- Restructured Game/Meet objects to use inheritence.
Version 1.0.19
11-Jan-2008- Added Tennis stats
- Added TeamType (Varsity, Junior Varsity, etc) to Team edit page.
- Added SchoolType Filter to School page.
- Added Score Edit feature to the Event (Game) page.
Version 1.0.18
07-Jan-2008- Added Soccer stats
Version 1.0.17
04-Jan-2008- Added Track Relay stats
Version 1.0.16
02-Jan-2008- Added state and league filters on bsktatsum, wrestatsum and swmstatsum via web service. Here is the documentation for the web service.
- Added Track stats
Version 1.0.16
23-Dec-2007- Added Softball stats.
Version 1.0.15
19-Dec-2007- Added Baseball stats.
Version 1.0.14
18-Dec-2007- Resolved issue with default value for record wins and losses on member edit page
- Resolved issue with football stat stored procedure
- Added method get_member_by_athlete to return all member objects for a given athlete
Version 1.0.13
17-Dec-2007- Resolved issue with session cookies.
- Added record win and loss fields to the wrestling member page.
- Removed jersey number from the wrestling member view and edit page.
- Added method get_member_by_athlete to return all member objects for a given athlete
Version 1.0.12
16-Dec-2007- Added three new methods for retrieving member statistics: get_bskstat_by_member, get_swmstat_by_member and get_swmstat_by_member. Each accept the memberid as the input parameter.
- Added gender filter to the member edit page. For example, this will prevent users from adding girls to the boys basketball team.
- Added add/update/delete functionality for Football stats. Previously this was just QB stats. Now it includes all positions.
- Added Superintendent to School edit form
- Resolved issue with sliding session
Version 1.0.11
10-Dec-2007- Added Win checkbox for wrestling stat.
- Added class WreStatSum. Created stored procedure to populate it. Added get_WreStatsum_by_member method call to retrieve WreStatSum class object.
- Created table pmnc_wrestatsuum for archiving WreStatSum object properties by member.
- Modified service script to update the pmnc_wrestatsum table at specified interval.
- Created get_top_wrestatsum method to retrieve n number of stats.
- Added class SwmStatSum. Created stored procedure to populate it. Added get_swmstatsum_by_member method call to retrieve SwmStatSum class object.
- Created table pmnc_swmstatsuum for archiving SwmStatSum object properties by member.
- Modified service script to update the pmnc_swmstatsum table at specified interval.
- Created get_top_swmstatsum method to retrieve n number of stats.
- Added method to existing web service to expose the data. This can be consumed by an AJAX enabled user interface. Here is the documentation for the web service.
- Resolved issue with single quote in Athlete name during upsert of all statsums
Hotfix 2
05-Dec-2007- Resolved issue with retrieving Football, Swimming and Wrestling scores.
Version 1.0.10
04-Dec-2007- Removed JerseyNo field from Wrestling member edit page.
- Added property to Athlete class called heightftin that displays the height in feet and inches.
- Added state champ flag to Team edit page
- Added school type select to the school edit page
- Added league select to school edit page
- Redesigned the database schemaa and classes to accomodate a league being assigned to both school and team.
Version 1.0.9
30-Nov-2007- Added number formatting for team stat win percentage.
- Restored two missing stored procedures to the database.
- Added class BskStatSum. Created stored procedure to populate it. Added get_bskstatsum_by_member method call to retrieve BskStatSum class object.
- Created table pmnc_BskStatSum for archiving BskStatSum object properties by member.
- Created service script to update the pmnc_BskStatSum table at specified interval.
- Created get_top_bskstatsum method to retrieve n number of stats.
- Created web service that exposes the data. This can be consumed by an AJAX enabled user interface. Here is the documentation for the web service.
Version 1.0.8
29-Nov-2007- Cleaned database and matched MaxPreps school names with IHSAA school names. 52 schools still do not match up because the IHSAA list does not include homeschools and christian schools.
- Added Coache FirstName and Coach Last Name to the team edit page.
- Added Fax, Colors, Website, Enrollment, Principal and Athletic Director to the school edit page. The league (conference) must be assigned to the team because some schools have teams that belong to different leagues. Here is an example.
- Backed up the current database, modified all the tables and stored procedures to reflect the latest release. The database update was made to pmnc (original). The previous database still exists at pmnc_v2.
- We will need a data check on all database tables this week.
- Added dynamic school name filter to the school page. Key in the name of the school and the table results will be filtered.
Version 1.0.7
19-Nov-2007- Added data from ihsaa website. 336 of 470 schools matched by name. The remaining will require manual updates will be required. The edit mode will be exposed once all schools are matched.
- Need to define the criteria for complete school
Version 1.0.6
15-Nov-2007- Changed the webservice.php page to use SimpleXML module instead of Dom module.
- Added borders to tables and used fixed layout for all tables in the site.
Version 1.0.5
09-Nov-2007- Added schoolid to Athlete table. Athletes are now associated with schools. This means an Athlete is uniquely identified by first name, last name, dob and school.
- Created State page for quick access to the School page. The School menu item has been replaced by the State menu item in the top menu.
- Added Athletes link to each school listed in the School page. The takes you to the Athlete page where all Athletes are shown for that school. When Athletes are added, the schoolid is retained.
- Added logical delete flag to Athlete database table. This is required to maintain historical data even if the student is deleted from within the PMNC Admin.
- Added form validation for Team, Member and Event input pages. Default values for dates are included. There is also validation to prevent users from entering birth dates that are in the future.
Hotfix 1
07-Nov-2007- Asked Matt to run SQL script to set Athlete DOB to Jan 1, 1970. This will be the default date for all new athletes. Form validation in the next release will
prevent users from entering a birthdate that is in the future.
update pmnc_athlete set dob = '1970-01-01';
Version 1.0.4
07-Nov-2007- Added height and weight to Athlete edit screen and database.
- Set default Athlete DOB to 01-Jan-1970.
- Added processing to business layer to handle single quotes in Athlete first and last name.
- Added processing to business layer to handle single quotes in League names.
- Added location to the Event (Game/Match/Meet) screen. The event can now be held at an alternate location that is stored to the database.
- Added Start Time to the Event edit screen.
- Changed Event list to read AwayTeam vs. HomeTeam. Previously it was HomeTeam vs. AwayTeam.
- Added client side form validation and formatting for the Athlete edit screen.
- Added client side table sorting to team, schedule, members and athlete display tables.
- Created update scripts for MySQL database that will upgrade the existing database without dropping any data.