the project number field if blank).
- Add a new number option 'X', which counts among ALL projects, not just the
ones in the same division/cat.
- Add a padding argument to N or X (N0...N9) defaults to 2 for N, and 3 for X.
- Adds 3 columns to the project table:
- projectsort: for storing the expanded text
- projectnumber_seq: for storing the N or X number for projects
- projectsort_seq: for storing the N or X number for the sort order
- Add a new config option for sorting, and expand the text for the
projectnumber.
- Change the default sorting for reports and project lists to use the
projectsort category.
- Remove the gvrsf_tn option from the database, it's not needed now.
- Hardcode add a special award to the top of the list "I do not wish to
nominate for any special awards". Allow the
project_specialawards_link.award_awards_id field to become NULL, and set it
to NULL if the student selects this award.
- Fix the display of the award status based on whether the student has or has
not specified that they do not wish to nominate for special awards.
- Add an option to the project editor to regenerate the project number
- Fix a bug in the project number generation. Include YEAR in the project
number check (and in the number generation) so we don't find a project from
last year (that already has a number), and decide not to generate one for a
project from this year. The $checkNumQuery was returning 2 rows.. one from
2006, one from 2007. Two projects from different years had the same
registrations.num (665983) in my test.. about 10% of the projects at the VDSF
collided with numbers from previous years.
