fixed), and reset some award sources to 0 instead of NULL.
award_source_fairs_id can never be 0 anyway (unless someone edits the DB
manually), so just set them back to NULL so the existing code works.
Notify user if invalid regexp's are entered in fields (there was no feedback as to why it wasnt saving!)
Also make the space in the postalcode optional
FIXME: still need to change the "incomplete" to "complete" message once everything is saved properly, it stays as incomplete right now until they navigate away and come back.
- Detect the theme directories and use dropdown boxes to select the theme and theme_icons, so no one can type in random stuff and screw their sfiab.
- Add 2 missing icons.
- Add the ability to specify a filter when calling for a report generation
(e.g., so we can dynamically filter a report for a specific fundraising
campaign)
Database now refers to everything by donor/donation .. and apparently just as i complete this, carolyn has decided to go to both donor/sponsor instead of just donor.. ugh..
- additional_materials: if there are additional materials required if a fair assigns a winner to this award.
- register_winners: to tell the feeder fair that this award is for winners who will participate at the upstream fair
- Add the ability to select category/division mappings specific for each upstream server
- Add some auto-determining code if the cat/div mappings don't exist
a fair_id. This is ignored for regular operation, but now needed to have
multiple students from multiple feeder fairs attached to the same award. (so
we know which ones to delete when we update the winners)
- Load/Save feeder fair awards in the award editor
- Fix all the POSTs in the award editor. .load automatically does a POST if
the data is an array, so we need to call .serializeArray() when we want a
post to happen.
Add countries_code field to provinces table and fix canadian provinces
Populate US States into provinces table
Add config option to Localization tab to enter a 2 letter country code (how to lookuup from countries table?!)
Update emit_province_selector to use country config entry
Add .htaccess rules for the cms
Add cms page display code and convert index.php to pull from the cms
If no page title is passed to send_header(), output the fair name in the <title> tag
'self_nominate', and 'schedule_judges'.
- self_nominate defaults to 'yes' for all new and existing awards. If turned
off, the award will not appear in the student self-nomination pages.
- schedule_judges specifies whether an award should have judges or not, we have
some special awards that students can nominate for but do not require judges
to find the winner. Similarly we have some awards students cannot nominate
for but do require judges to determine a winner. This allows both cases to
be handled.
- Add the ability to draw a static label box (without text)
- Add "self nominated award" 1 through 5 to the student reports
- Add a new report demonstrating how to use the above (this is of the format
Sudbury sent us).
titles (defaults to off)
- Renumber the order of the config variables in Participant Registration, it's
getting a bit crowded
- Fill in some missing types for config variables
- Add a 'total' option to the report generator, to signal that this column
should be added up.
- If total is != zero, it shows the total at the bottom of each table, else, it
shows the number of rows (changed the text to Total: for a total, and Rows:
to show rows, if the total is 0)
tinytext.
- Change the icon_path to somethign SFIAB will like better in the tableeditor
(was wondering why I had no icons in the tableeditor)
- Add a crude maxlength support for text areas
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.
public winners page. (defaults to ON, which is the current behaviour)
- Fix pluralization of "Students" for one student. :)
- Change the effort option for judges and tours to a pulldown menu Low=100,
Med=1000, High=10000
{$type}_password_expiry_days. This allows the $config variable to be updated
and everyones password will expire based on the new value. To implement
this, the password expiry column in the users table has been changed to
passwordset, and a PHP script is used to convert the expiry dates to set
dates (based on the _password_expiry_days)
- Cleanup the password entry checking
- Load all config variables for the db_update.php script. Just in case an
update script wants access to $config
number, and an option to create numbers automatically
- Completely remove all references (hopefully) to the Tour ID
- Add a Tour type report
- Rework the student report query so it actually makes sense. It really should
be a whole bunch of left joins based on the students. Using comma (cross)
joins creates situations where if the right side of the join doesn't have
information, it wipes out the left side. (Happened before with emergency
contact info).
- Remove the (two) old custom tour reports
- Add 4 new tour reports to the database:
- ALL tours for the committee, tour list for students,
student emergency contact info for tour coordinators, and
a list of tour assignments for students
activity and percent.
- Add the status update and links to automatically start the "tour assigner".
(Didn't want to call it a scheduler, because someone might thing it's for
assigning tours to timeslots or something)
- Prevent the user from setting zero, or more than one, primary contact.
- Add a primary column to the contacts table, so they can see the automatic
set/unset operations on the primary contact.
Create page text entry for 'invite only' volunteer registration
Create a contact page to contact committee members, and link it into the committees page, and the bottom of the left side menu
- Add a designate field to the schools, to indicate an independent, standard,
private, etc. school. It's not editable yet, but.. eventually.
- Fix generatePassword to use proper string indexing, and remove the
possibility of indexing beyond the end of the string.
- Add "Invite" and "SinglePassword" modes for volunteer registration.
- Update the admin section, add a new volunteers page to contain links to all
volunteer options
already exist, they will be guided through the process of adding a role to
their existing account.
- Do a database update, and merge anyone who has managed to create 2 accounts
into a single account.
- Still testing this, but it seems to be working
reports.php) to existing committee members. New members will get to build
their list up from scratch, but we dont' want to confuse old members that are
use to seeing this list.
reports require admin access) can define a list of reports out of all the
reports, and tag each one with a category and comments.
- Add all except the ceremony scripts as "Custom" reports. The My Reports
system can handle links to custom reports now, but not the ceremony scripts.
They're too special. I think they should be moved out of the Reports Area.
- Clean up some report variables to avoid collisions with local names
($options, and $stock)
- Implment a new screen for report generation that lets the user set the
format, stock, and year of the report.
variable, this will allow the committee to specify exactly what they
wish to collect (and which fields are requried)
- Insert config variables for volunteers and committee
function in the config editor to one that checks where ALL variables marked
with year=-1 exist for FAIRYEAR. If it doesn't, it creates them. This
function gets called in three places:
- On installation
- On rollover
- Whenever the database is updated
We should, now, be able to just insert new variables with year=-1, and they
will be automatically updated for the current year with the default value.
(no more going into the variable editor to make sure the copy is done).
- Fix the superuser account creation in the install script
- Allow user_personal.php to handle committee members
- Add password field if the editer in user_personal has access_super
- Allow a committee member to edit anyone in user_personal.php
- Convert auth_required to user_auth_required, and check for both a user type
and an access level (if committee)
- Convert the committee to the new user system (BIG change :)
- Remove the ^M from admin/committees.php
