Make queries for communications easier, all you need is a users.id queried, the system will find everything else for you
Add ability to use [PASSWORD], [USERNAME], [EMAIL] (tries accounts.email first, if its not there, it uses accounts.pendingemail), in _ANY_ email. [REGNUM] also added but will obviously only work for participants
Add "all" section to the tabs list for user editor, so a user without any roles can still get the basic pages like "account", "roles", and "personal info"
Put count on participant invitations for teachers (and superusers)
Fix a bug where changing a password for a different user didnt work (it changed YOURS!)
Updated report system to read students from users table instead of students table
Fix tcpdf tables spanning multiple pages spilling into the header area
Fix calling an invalid add_table function (its addTable yo!)
award_awards
award_prizes
award_types
award_awards_projectcategories
award_awards_projectdivisions
winners
students
projects
registrations
Also modified all code that uses those tables to work with the conference id
instead of the year, with the exception of these files:
communication.inc.php
reports_students.inc.php
rerollprizes.php
remote.php
The "rerollprizes.php" probably doesn't matter, having been a one-time usage
file anyway. The others will need to be modified in the future to correctly
use the conference id instead of the year.
options. This way, the logo/fairname can be moved around and
resized. Ensure those fields exist in each report. Convert name/logo
preferences in all existing reports, and adjust the yloc/height of
existing fields to make way for the headers if they exist.
Convert ISO-8859 -> UTF-8 before printing text on the TCPDF label... happily only the GVRSF is using this right now so we don't need to update everyone.
Update lpdf's table functions to honour the default font size setting.
(this works great, except for the column widths - if you choose a font-size too big, its not oging to fit in the pre-defined column widths.)
- 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.
- 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)
- 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)
- 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).
- 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)
- The docs say pdf_place_image is deprecated (and so is
pdf_open_image_file.. apparently)
- By using pdf_fit_image we can define a box where we would like the
image to fit, then use the highest quality image (logo.gif) and tell
pdflib to scale and center the image within that box.
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
