Commit Graph

36 Commits

Author SHA1 Message Date
bc588358ee Fix PDO and Warnings continued 2024-12-19 22:29:06 -05:00
cce7d93023 Fix usage of get_value_from_array 2024-12-18 14:27:47 -05:00
ea287cd7af WIP PDO and Warnings 2024-12-18 11:48:09 -05:00
974eb738f3 errors 2024-12-17 01:34:35 -05:00
cb7481c01e sqlerrors 2024-12-06 20:54:02 -05:00
idziak
28070d19cc These changes were done by Sebastian Ruan
Ethics questions can now be asked as a required field for each project. 
To activate this feature navigate to Configuration >> Configuration Variables >> Participant Registration 
and change  “Ask if the project requires human and/or animal participants” to “Yes”. 

All projects with human and/or animal participants can be selected using the Report Editor.

Under “Input Received Signature Forms” a button called “Receive All” was created. 
Clicking this button will cause the program to assign project numbers and mark the 
signature page as received for all students who have completed the registration process. 
Confirmation emails are sent to each student that had their signature page marked as received.

"Remove Old Judge Data" and "Remove Old Emergency Contact/Parent Data" was added to
"Database Backup/Restore".  These permanently remove all information from the database 
about these two respective groups.  This means that all historical data will be lost but  
the most recent information about judges and emergency contacts remains. Cleaning the database 
this way dramatically improves the speed of the user editor.  Make sure the database has been
backed up before trying these.

The judge's name now appears on the cancellation popup window when deleting an individual judge.
2015-05-06 16:55:46 +00:00
idziak
21636ce272 These changes were done by Sebastian Ruan
Allow the fair to choose calling the signature page either a signature page or a permission form.
Add a comment box for each judge that can only be read by a committee member.  Adding a comment will set a flag in the "manage judges" list.
Add "Update User" button to the list of judges so that a committee member can update a judge to the current year without having to log in as the judge.
2015-04-08 21:13:02 +00:00
james
4423acd4b0 Match the cat/div year with that of the project, so we don't print cats/divs
from previous years.  (Seriously, how long has this bug been here, and no one
has complained until now!)
2011-03-19 22:42:01 +00:00
james
369542ecde Make the buttons bigger and more spacing so its harder to hit the wrong thing by accident 2011-03-09 20:18:58 +00:00
dave
56cbd2dba5 Remove redundancy 2010-01-28 08:34:33 +00:00
james
63034a1d33 Check the name check status on deciding if a form is complete or not. 2008-03-27 22:12:27 +00:00
james
06cb13d7e4 Oops, the _seq's cant be null, they need to be set to 0 2008-03-20 01:57:24 +00:00
james
3fc27ceb04 Set everything to do with the project number, project sort, and sequence numbers to null, not just the project number, when
unregistering a project.
2008-03-20 01:52:47 +00:00
james
e320230a3e Add a way to unregister projects. Simply re-enter their registration number, and click the link. 2008-03-20 01:19:35 +00:00
dave
e8face39d6 - Update the project numbering system by also adding a sort field (defaults to
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.
2007-12-29 08:46:40 +00:00
james
5e4a31c50c Clarify wording "input received signature forms"
Remove redundantly redundant header heading
2007-12-11 19:44:18 +00:00
dave
0ff8489d58 - include user.inc.php before using user_auth_required() 2007-11-21 17:02:09 +00:00
dave
04e70ceb33 - Use user_auth_required() for authentication to check for committee access
(needed for multirole users)
- Add the top navbar to all pages
2007-11-18 23:50:23 +00:00
james
6d635e89f7 Only get the recipients list once
Oh, the last commit also fixed a couple multi-year registrationnumber uniquedness problems, as well as a few register_global dependencies
2007-10-30 22:37:18 +00:00
james
4378f966ce Add an email address verification function so we dont need to keep duplicating the regex everywhere
Add a function to get the email recipients for a given registration id, for now, it just gets the students, but downt eh road it should check if teachers, parents, emergency contacts, mentors, etc should receive fair updates as well.
Implement the code/replacement tags for the two new emails, one for 'forms received, with payment' and the other for 'forms received, without payment'
2007-10-30 22:35:00 +00:00
james
ab5180ef9e Add two new emails: registration complete, registration payment pending
Whipe out all 'from' of info@sfiab.ca (the old default, we dont want others using it!)
When sending emails, if 'from' is empty, use the $config['fairmanageremail']
Add a warning on the communication page if the fair manager email has not been set
Set the default 'from' for new emails to be the fair manager email

NOTE/FIXME: i added the hooks for the two new emails to be sent, but still 
need to fill in the substitution values as well as the "to" - no time now, 
will do that tomorrow
2007-10-29 20:21:40 +00:00
james
174490b752 Auto focus on the input box on the input received forms page, so you dont have to click on the box every time before you start typing in the registration number. 2007-03-13 21:34:24 +00:00
dave
57ff84c563 - Move registration fee computation into the include file
- Add the required registration fee to the received forms checkoff, so the
  amount of the cheque can ben checked too.
2007-03-12 02:05:40 +00:00
dave
f0bb80a866 - Fix the name of the generate project number function
- 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.
2007-03-05 04:27:44 +00:00
james
4789d78e2f - Move the project number generation into a header
- 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.
2007-03-04 20:28:51 +00:00
james
319c5d6720 Add option to turn off the Mentor section for participant registration
Add two new projectnumber options:  c=category shortform,  d=division shortform, eg  (JLS01 = Junior, Life Science, Project #01)
Add shortform field for age category
Fix bug in config editor where it was updating values for ALL years, instead of just the current year!
Bump version number to development version
2006-12-06 17:58:40 +00:00
justin
808290f631 projects should be assigned a project number once registration forms have been received, whether or not they still owe money. Resolves issue 101. 2006-08-20 00:02:31 +00:00
justin
0e9a889e4f Schools and students were not being properly numbered in the Registration Summary. Ref: Bug 90 2006-04-09 13:47:04 +00:00
james
229f2670f1 whoops fix big bug which prevented project numbers from being assigned properly! 2005-04-19 18:20:10 +00:00
james
3deae5e029 Implement authorizaiton for admin/config sections
Use committee members for authorization
Add auth required checks in all admin/config sections
2005-02-16 22:50:43 +00:00
james
324433ef23 Add GPL headers to ALL PHP files 2005-01-24 18:00:03 +00:00
james
0f5e201b97 assign the project number based on a config format when the form is received
fix checkin report to show the projectnumber
2005-01-21 19:27:28 +00:00
james
f7d40b115a add config options:
regfee = number
regfee_per = (student,project)

hide things to do with registration/payment if regfee == 0
2005-01-14 20:56:51 +00:00
james
ebeadd6470 Registraiton list
Fix received forms to accept paid/not paid
2005-01-07 04:45:17 +00:00
james
15cbc2597a implement actually changing the status of the registration to 'closed' 2005-01-06 04:56:33 +00:00
james
ce66249238 received forms implementation nearly complete 2005-01-05 22:57:49 +00:00