Commit Graph

66 Commits

Author SHA1 Message Date
f7c6c506a1 Mysql conversion 2024-12-10 19:40:23 -05:00
f0977fb55d sql queries 2024-12-08 02:42:00 -05:00
e4995bbc3d First pass for PHP/MariaDB updates 2024-11-25 18:06:33 -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
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
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
8eef980ca7 Update to deal with how newer versions of PHP deal with object pointers. 2012-10-19 15:08:21 +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
d74925d2bd Updates adding the a report for printing cheques. 2012-03-13 19:54:05 +00:00
james
aedb61c286 Fix fair logo in tcpdf reports 2011-03-19 22:08:47 +00:00
james
8e6da38509 Add regfee_items columns to student reports 2011-03-18 18:35:19 +00:00
james
42f1185892 Add the barcode to the student report list 2011-03-17 22:22:44 +00:00
james
91c2666940 Fix the t-shirt size column width 2011-03-09 16:34:59 +00:00
dave
072e07a06f Add optgroup headers and shuffle some fields around for student reports 2010-04-12 00:23:21 +00:00
dave
536fec616f Add a school principal field. 2010-04-12 00:07:33 +00:00
james
015b04a81a Add two columns for the feeder fair info in the student report. 2010-04-05 19:19:53 +00:00
dave
c42748989b Add xsmall to report too 2010-03-31 04:50:55 +00:00
james
ad7051a6c9 Add Project -- Rank to student reports too, so it can be in the Special Award Nominations list given to judges. 2010-03-29 19:48:12 +00:00
jacob
6ecfb4ab42 Fix for bug #457 - Error in generating report that included the sponsor DB ID field 2010-03-26 17:41:44 +00:00
dave
355447ac76 Add highest cat pref selection (for LRSF). Pass the $field into the
report column function so the same function can be used for multiple
fields with different return values.
2010-02-02 18:19:11 +00:00
dave
bf3485c24a - Add an advanced options tab to the report generator
- Add an advanced option: Include Incompelete Registrations - Ignores the
  registrations.status and just includes everyone.  Downside: registrations
  must have a division and category selected because the mysql query matches on
  cat.year and div.year too.
2009-11-06 08:57:13 +00:00
james
f963dbf276 Merge all changes from branch r1284:1498 into trunk 2009-09-09 00:26:12 +00:00
james
4b3455f730 Increase email field size
Fall back to projectnumber sorting after projectsort (incase people manually set the project numbers in the project number field, and leave the projectsort empty
2009-03-24 15:08:51 +00:00
james
cc619e3422 Make summary scalable 2008-11-20 18:20:04 +00:00
james
651d6235a4 Add config options for Province/State and Postal Code/Zip Code 2008-07-16 17:23:53 +00:00
dave
bb4997548c - Add medic alert and food req. info
- Change the name of cshool teacher/email because these are really the values
  the student enters.
2008-03-20 02:57:18 +00:00
dave
6e8883b4a2 - Add pronunciation 2008-03-16 19:09:47 +00:00
dave
7651426f03 - Add a field for trophies
- Fix a bug with the ordering of the sql statement.  Something I noticed fixing
  this bug: Tour info and award info will generate an error if used together.
2008-03-12 01:18:29 +00:00
dave
482f2e6d3a - Sort the tour num+name column by number 2008-01-30 07:56:47 +00:00
dave
8980275627 - Add mentor info to the student report generator 2008-01-26 19:46:16 +00:00
dave
4af449a2c4 - Implemnt scalable columns in the report generator.
- New report option to fit the width of the report to the page
- Columns in each reports_*.inc.php can be specified with
	'scalable' => true
  to indicate that they may be scaled if the report is too wide for the page
- Obviously, do no scaling if the option is off (off by default)
2008-01-26 19:14:24 +00:00
dave
b14ec011d4 - use the correct limit 2008-01-23 18:42:35 +00:00
dave
3f3475d407 - fix the limit on the special awards self nomination query
- add a rollover for regfee items
2008-01-23 18:40:59 +00:00
dave
58df28ba9a - Fix drawing label boxes around text items
- 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).
2008-01-23 18:32:31 +00:00
dave
78fa4ad6ac - Add support for short project titles in addition to the regular project
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
2008-01-23 05:54:03 +00:00
dave
a364e9ea56 - Fix the Partner Name (first last) column 2007-12-30 23:02:41 +00:00
dave
f097559e9d - Fix some emergency contact headers 2007-12-30 22:32:58 +00:00
dave
e24bbb0bbc - Add a filter to the last commit, to not show the none tshirts.
- 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)
2007-12-30 22:16:34 +00:00
dave
fcd6eedc1d - Add a new data field for counting the number of tshirts of each size
- Add a system report that lists the number of tshirts of each size
2007-12-30 21:45:04 +00:00
dave
d89c756427 - Add a grade column that uses the format "Grade x", instead of just the
number.  Fix the YSF stats report to use this column and show "Grade x" in
  the titles, not just "x", which was a bit confusing.
2007-12-30 21:20:36 +00:00
dave
eaad48d6d0 - Change how the num students report column works. It was failing when awards
were added because of the row duplication.
2007-12-30 21:05:54 +00:00
dave
aa1be324ad - The project number needs a titch more space for the GVRSF. :)
- Completely remove the old gvrsf_tablenumber report column.
2007-12-29 09:04:48 +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
dave
f3f2747118 - Replace reports_acpresentation with a report from the report generator.
- Implementing a function call option to parse column data in the report
  generator as it comes out of the database.
2007-12-25 05:13:42 +00:00
dave
801e70cb0c - Fix the awards query
- Add prize amounts to the report editor
- Add a column to compute the number of students who worked on a project to the
  report editor
2007-12-22 19:12:43 +00:00
dave
71166d3e6b - Add the easyparse student names option 2007-12-20 09:51:08 +00:00
dave
6c61595cb9 - Add an option to print ALL student names for a project (will work for more
than 2 students).
2007-12-20 09:43:22 +00:00