Commit Graph

1000 Commits

Author SHA1 Message Date
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
9892d738d4 Complete initial pass of sql conversion 2024-12-12 16:24:45 -05:00
f7c6c506a1 Mysql conversion 2024-12-10 19:40:23 -05:00
bab11c9228 sql queries 2024-12-08 02:49:02 -05:00
f0977fb55d sql queries 2024-12-08 02:42:00 -05:00
cb7481c01e sqlerrors 2024-12-06 20:54:02 -05:00
d6df555fc4 Converted sql to pdo 2024-11-27 10:47:41 -05:00
6af995ce3c Removed Chat 2024-11-25 19:24:39 -05:00
e4995bbc3d First pass for PHP/MariaDB updates 2024-11-25 18:06:33 -05:00
james
01ea27a39f add encoding to htmlspecialchars 2019-03-07 21:33:42 +00: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
idziak
9ec497df9f These changes were done by Richard Sin
Increase the number of sorting and grouping fiels in the Reports Editor
Fix display list when emailing schools
Add "Judge -- Other Expertise" to Reports Editor
Add "Award -- Script Order" to allow student reports to be sorted the same way they appear on the "Award Ceremony Script"
2015-03-20 19:24:37 +00:00
james
2b8416ed8e Added an optionally included county field to the student data. 2015-01-14 18:06:07 +00:00
james
c4c985ce3f remove brackets from project number in list so it can be typed in 2014-04-05 14:02:46 +00:00
idziak
f1cd9bcb5b Select Project Type field added to the project editor.
A flag in the configuration variables under Particpant Registration
must be set to enable this.
Project types are Experiment, Innovation, and Study

Comment text box has been added to the project editor.  This is only seen by 
fair administrators and not by the student.  Information related to project
safety can be flagged here.  If text is present in this box, a flag appears
in the Registration Management list.

Project summaries longer than one page now print out properly.  Blank pages 
are still sometimes printed after long sumaries.

Choose Email Recipients query has been modified so that the most recent
email address for judges is now used.

Reports Editor has been changed so that cheques can be written for
individual students as well as one cheque per project.  New report
data (split) has been added to make this work.
2014-02-27 21:38:16 +00:00
james
224520e33a Add safetyquestion answers to student report fields 2013-03-26 18:12:41 +00:00
james
1c33c03d81 Add a field to show the specific special award that a special award judge has signed up for. 2013-03-13 19:45:23 +00:00
james
7d77c47614 Test again 2013-02-20 21:21:23 +00:00
james
85571aefa2 remove a blank line.. yea. really im just re-testing commit scripts because the mailer failed. 2013-02-20 21:20:26 +00:00
james
b957eb58ad Add time available to judge list custom report 2013-02-20 21:18:52 +00:00
james
88f1cc7614 A few more missed escapes 2012-10-22 18:40:16 +00:00
james
1c10dda679 escape the insert on the report options 2012-10-22 18:39:42 +00:00
james
0497a21b40 Add judge(all) active from last year to communication list 2012-10-22 18:35:17 +00:00
james
8eef980ca7 Update to deal with how newer versions of PHP deal with object pointers. 2012-10-19 15:08:21 +00:00
james
e2a8e7a9fd Update copyright in GPL header 2012-06-15 13:50:24 +00:00
james
4d67f395f3 revert 2052. It was causing the AC script to show all award that the selected categories were ELIGIBLE for, rather than all awards won by a selected category. This causes an award available to a junior and senior to appear in both scripts regardless of who won it, rather than only in the script of the project category that won the award. 2012-04-17 03:14:35 +00:00
james
bb1823b2db Properly pull the committee members based on their highest year linking since all memebrs dont have a users record for the current year. also add new fields to show the committee name, and a combo field for committee nadm and title 2012-04-11 17:41:39 +00:00
james
d10385a80f Add a project title and summary in the same column for student reports. Needed for the gvrsf, just want to avoid getting out of sync with trunk. 2012-04-07 21:40:53 +00:00
jacob
02dd19a477 Added emergency contact e-mail as a usable report field. 2012-04-05 15:42:30 +00:00
james
1dfdcc543b Also allow school editting for "open or invite" registration. 2012-03-28 00:10:54 +00:00
james
3e0b4227bc If the registration has no project record, and they go into it in the project editor, add a project record, instead of displaying "Invalid Project to Edit"! 2012-03-22 14:56:50 +00:00
jacob
d1e12fd3c8 2012-03-21 21:02:30 +00:00
jacob
41f83b6fc0 Added a cross-client chat system to be used on the administrator dashboard 2012-03-21 20:46:03 +00:00
james
d8f4228a59 Wow committee reports were pretty broken.. fixed them, and added a field for the users title on the committee 2012-03-16 17:32:28 +00:00
james
d74925d2bd Updates adding the a report for printing cheques. 2012-03-13 19:54:05 +00:00
jacob
5c5c3e55ec Replacements of calls to deprecated function "explode", "ereg", and "ereg_replace" with their recommended equivalents. 2012-02-09 17:52:17 +00:00
jacob
1b426bcf69 Updated admin/schoolsimport.php to properly handle v2.3 shool imports.
Replace some deprecated PHP functions with their appropriate equivalents
2011-12-08 22:41:49 +00:00
james
02b06de804 Fix a bug displaying the total number of projects in the judges scheduler config 2011-11-28 18:52:32 +00:00
james
0a41f3471d Put the quote in the right spot. 2011-08-03 23:52:15 +00:00
dennis
caeb9246ff Minor changes in preparation for Evaluations Plug-in (in development) 2011-04-13 15:35:35 +00:00
james
a6741d58ac Add CWSF Winners from Last Year and CWSF Winners from ALL Years to communication module 2011-04-01 14:29:33 +00:00
james
5322837060 Fix wording for patrick 2011-04-01 13:32:48 +00:00
james
5d4d74fd0c Fix auto-create teams for special awards when divisional awards teams already exist (they shouldnt matter)
Create auto-assign special awards judges to special awards teams
2011-03-31 20:28:28 +00:00
james
529aa8ca38 Identify special awards only judges and increase the size of the judge info popup 2011-03-31 19:38:57 +00:00
james
ada73125cf Increase the size slightly if we have a date, and use format_date for localization 2011-03-31 19:19:27 +00:00
james
3eb15bd24b Give us another "out" of the annealer if we're not making any progress 2011-03-31 13:58:03 +00:00
james
106ac578f1 Oops, check the right fields for active/complete 2011-03-31 13:46:40 +00:00