6088779b37Properly handle "quote" marks in the title if the page gets resaved after the initial save
james
2007-04-03 21:07:44 +00:00
f3ad2c7f26Oops need to global $config for that last patch to work
james
2007-04-03 20:17:32 +00:00
31aebc743fOnly count a huge penalty for the team if there's no chair on the team if the minimum number of judges per team is greater than 1. If the minimum is 1, then essentially the "willing chair" stuff should get ignored.
james
2007-04-03 20:16:48 +00:00
c2856ad9cbadd another parmeter to i18n() which will allow you to force the language that gets returned for that specific call to i18n. Makes it easy to do things like make bilingual data sets, eg: "Life Science / Sciences de la vie"
james
2007-04-03 20:12:43 +00:00
eff30a5adbAdd an option on the winners selection page, to show all ELIGIBLE projects for a special award, not just the nomiated ones. Helps in teh case that an award was added last minute that nominations didnt happen for, or in a caase that the judges decided to choose a winner that didnt nominate to begin with.
james
2007-04-03 20:10:00 +00:00
8c044c8309- Remove unused nametag stuff. It's not referenced anywhere in the code base anymore
dave
2007-04-03 20:09:19 +00:00
e7776a6b9cCSV of award winners - we used this at ORSF to do a Mail-Merge into a MS publisher template which export to a PDF to create a presentation for the awards ceremony... Next year we should automate this to create an OpenDocument Presentation (.odp)
james
2007-04-03 20:05:39 +00:00
35ccf2a2ad- Fix an instance where we rely on register_globals to be on
dave
2007-04-03 19:53:30 +00:00
526db97052- Update the custom tour selection report to: - Only report complete students - Use tour names instead of numbers - Not use $email as a temp varaible because that actually overwrites the $_SESSION['email'], and logs us out, wtf? - Sort by first tour selection
dave
2007-04-03 18:49:29 +00:00
daa3f4bb51Rename the entry to "Website Consent"
james
2007-03-31 01:10:56 +00:00
c95df2b912Implement web consent restrictions, settable by the admin (under the admin->participant registration menu) to prevent firstname and or lastname (and or photos once they are implemented) of students, on a per studnet basis, from being displayed on the website. It currently affects the confirmed participants page, and the winners page (the only two public places where sutdent info is available thorugh the system)
james
2007-03-31 01:10:08 +00:00
97c2b65a93Require >1 judge div grouping
james
2007-03-29 20:33:45 +00:00
e2ee104434If all the schools are the same, then only show the school name once, instead of once for each student.
james
2007-03-29 19:36:04 +00:00
d209b0648fAdd new CUSTOM report: Program Awards List (used for ORSF printed program) Add award criteria to getJudgingTeams() result Modify CUSTOM report judges teams proejcts, to show each award and the criteria/eligibility for each award that the team is assigned to judge. More ease of use cleanups to awards interface Add new field award order to student report generator
james
2007-03-28 22:32:57 +00:00
6fa1a01fe6Remove much of the awkwareness of the awards management interface
james
2007-03-28 18:03:15 +00:00
1bdba54ed5- Add a special awards feature (off by default) to the judge scheduler. It: - Creates a judging team for each special award - Assigns judges to special awards based on the number of students self nominated. - Obeys the judges special award preferences (if enabled), and also judges that specify if they are a judge for a specific special award (if enabled).
dave
2007-03-28 06:16:41 +00:00
cc2e6b5bce- Add fullpage (no margin) reports for the full pages, we need them for our certificate generator
dave
2007-03-27 05:01:51 +00:00
fb1ddd4775Clarify what the 'prize' field should be used for. (eg, only if the prize is non-cash/non-scholarship)
james
2007-03-26 17:06:44 +00:00
72afcf583cGet the logo to fit on the label
james
2007-03-26 17:04:42 +00:00
d21fbee5a4- Turn off table label boxes by default
dave
2007-03-26 16:55:45 +00:00
a979f158eb- Add a 0.75" page margin to the full page labels
dave
2007-03-26 16:49:15 +00:00
99ad9ae8e3Only show the max number of students per project, no matter what the address bar passes into $_GET
james
2007-03-26 16:29:20 +00:00
ee6454868f- Sneak this in so we don't print nametags for incomplete judges.
dave
2007-03-26 06:30:15 +00:00
336ec2f75c- Don't generate PDF table reports for things that should be labels.. generate "label" reports.
dave
2007-03-26 06:20:43 +00:00
efc7ae411d- BAM! - Overhauled the report generator.. It's more versatile now - Added 'filter' option to the generator, so you can filter any column by (=, <=, >=, <, >, IS, IS NOT, LIKE, NOT LIKE). It doesn't support AND or OR combinations, but that should cover what we need for now. Example: We can filter "Award Name" LIKE "%Gold%" to generate a report of just the Gold medal projects. - Wipe out the report database, and create it again from scratch. update.48.sql contains an example of how to add additional reports to the system without knowing the report_ids, because after regions start adding their own reports, we won't be able to just wipe out the whole report system to add one. - We handle more reports now, specifically nametags and table labels, so remove those files, and update the reports.php file to link the old links to the new report generator (so people don't get too confused in this transition). - Beginnings of moving the report generator to proper LEFT JOIN style constructs instead of just one big massive EQUALS JOIN.
dave
2007-03-26 06:15:41 +00:00
80ca088be2- This will break things, but I need to get these home so I can work on 'em. WIth luck, I'll have a new report generator commiteed witha proper DB update tonight.
dave
2007-03-26 01:54:18 +00:00
c22b3fa86bAdd some extra fields to the awards report
james
2007-03-22 14:55:24 +00:00
c64d7445e9Update the selector so it works
dave
2007-03-20 20:50:14 +00:00
23934f080a- Fix the report selector for browers that can't seem to do javascript
dave
2007-03-20 18:49:44 +00:00
a67e8b8fb5- Fix the position of the image on the label - Change the fair title font to 13pt (from 14pt), it was spilling over onto the second line for many fairs (Waterloo-Wellington, Greater Vancouver, Quinte, Fraser Valley) Actually, the size of that should probably be proportinal to the size of the label.. that'll come later...
dave
2007-03-20 06:27:04 +00:00
77eee9dcdd- Add options for nametags to be generated - Add committee member generator - It is now possible to generate ALL nametags the old system could generate (needs a DB update before that happens... actually, the report generator isn't as stable as I hoped.. I'll probably just nuke the report tables the next upgrade and recreate them all.. I'm probably the only one who has tried generating a custom report. :)
dave
2007-03-20 06:24:18 +00:00
18d2bfa0d3- The generator needs these to be arrays
dave
2007-03-19 16:47:01 +00:00
cf8f539c48- Missed a year check
dave
2007-03-19 07:49:21 +00:00
4e2d7d77aa- Fix up the pdf generation of our nametags - This also changes the newlabel function, so just thinking about it, I think there's a 0.15 missing in the alignment that was moved inside a conditional for labels... All labels will be replaced soon anyway. :p
dave
2007-03-19 06:56:38 +00:00
2f23e31a40- Update the generator, it can do labels and nametags now, almost ready to deprecate all the mailing list/nametag/table label/etc. files.
dave
2007-03-19 06:51:44 +00:00
3f737b3270- Replace two judging reports.. The second isn't quite a perfect match, but it's close enough.. Currently we can't produce both a list of judges and a list of awards for each team with the generator (how the heck would we express that with an SQL statement)
dave
2007-03-19 00:13:12 +00:00
2b4c5f12e3- How did that ';' get in there ?
dave
2007-03-18 23:54:35 +00:00
7487828552- 4 new reports
dave
2007-03-18 23:18:07 +00:00
d659999339- Update the judge and award report generators
dave
2007-03-18 21:48:36 +00:00
7b04204ede- Add judge and award type report generators (not nearly complete) - Migrate generic code into reports.inc.php
dave
2007-03-18 19:59:02 +00:00
f3129e7a39- Add date of birth to the student report field list so we can close a bug on bugtracker.
dave
2007-03-18 07:24:52 +00:00
857cb6aa7b- Fix the CSV generator
dave
2007-03-18 07:19:00 +00:00
331bedc7e7- Delete reports that the new report generator now duplicates
dave
2007-03-18 07:12:49 +00:00
b3978c7dae- Add a new student report generator - Add an editor for that generator.. it's not flawless, but it's not hard to use either. - Add 19 default reports - Replace several reports on the report page with the new generator versions (they pretty much look the same, same info, same sort order, same pagination) - Add a pulldown menu to the report pages so any report can be generated
dave
2007-03-18 07:10:54 +00:00
7c96874571- Add page numbers to lpdf generated reports - Allow the addTable array to contain an 'option' array, with one supported option 'allow_multiline' => if true, it allows cell data to spill into mutliple rows, instead of just printing ... if the text doesn't fit.
dave
2007-03-18 05:02:14 +00:00
a318e2d1faAlways for the project number position, incase the project title wraps onto two lines, this prevents the table labels from spilling over to two pages. Also fix it so it doesnt have a final blank page at the end
james
2007-03-14 01:18:18 +00:00
faceec20edIn the judges division groupings, only show the count of projects that are complete or paymentpending
james
2007-03-13 22:11:18 +00:00
174490b752Auto 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.
james
2007-03-13 21:34:24 +00:00
e2eff96db9Show the link to the Confirmed Participants page once the date > regclose. The list will be empty (but with a notice to that affect) until the date that the list is defined to be posted. This should hopefully prevent the frantic phone/emails "i sent my forms three days ago why havent you received them?!?!?!?!"
james
2007-03-13 14:34:02 +00:00
453a3666f1- Commit the report generator.. it still needs work, but it's quite usable now.
dave
2007-03-13 06:10:27 +00:00
eb0481b2a1- Add hr() and vspace() to the CSV report generator.
james
2007-03-13 05:01:37 +00:00
cb992b8819- Add the "none" tshirt option to the admin student editor
dave
2007-03-12 17:27:55 +00:00
3519bc5e0eAdd three new email recipients to the communications module:
james
2007-03-12 14:23:44 +00:00
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.
dave
2007-03-12 02:05:40 +00:00
1e2608d5b5If there's no regfee, then dont show the status column on the confirmed participants page becuase status will only ever be 'Complete'
james
2007-03-08 21:54:30 +00:00
ea55978aa9Make sure $config['dates']['postparticipants'] is valid before relying on it.
james
2007-03-08 21:35:52 +00:00
59aade5f0cAdd the confirmed participants list, and display it in the menu under the particpant registration link, if NOW() > the date it should be posted.
james
2007-03-08 21:33:22 +00:00
a426c264d4Version 2.0.12
james
2007-03-05 21:03:09 +00:00
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.
dave
2007-03-05 04:27:44 +00:00
5b84c70f69- Display a small warning that the signature page is only available after ALL registration sections are complete.
dave
2007-03-05 02:26:56 +00:00
6f4d3177bf- Indicate that T-Shirt sizes are adult size (just about every fair does this, I believe, if a fair doesn't, we should make this a configurable option.);
dave
2007-03-05 02:01:04 +00:00
d2ab242d39- Change the submit button on the judge's special awards page to say "Save special awards preferences", instead of "Save areas of Expertise"
dave
2007-03-05 01:59:49 +00:00
9e009bc5d6- Remove a debug print statement from last commit :)
james
2007-03-04 20:30:31 +00:00
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.
james
2007-03-04 20:28:51 +00:00
c7560b91d4Update wording for 'invite only' judge registration
james
2007-03-04 16:52:37 +00:00
2ff20effc2Respect page margins on the school access codes report
james
2007-03-04 16:38:45 +00:00
fe2627faecFix the wording on Jesse's table labels and nametags field section pages.
james
2007-03-04 16:36:28 +00:00
44a6431cd7Bump version for development
james
2007-03-04 16:26:46 +00:00
db600b5eb4Properly wrap signature lines when they reach a page break Fix the signature page to only display once ALL the sections are complete
james
2007-03-04 16:26:04 +00:00
659bc11066Put the email address in the registration list, so when someone calls and says "i never got my registration number!" you can easily look it up for them! Sorry this didnt get into 2.0.10, im going to update everyones version with this patch anyways
james
2007-03-02 15:02:14 +00:00
11c995f94aBump version number to 2.0.10
james
2007-03-02 14:42:03 +00:00
fea05546d1Fixed the reports_schoolprojects report to not error when there are no projects
james
2007-02-26 21:43:39 +00:00
d644f6dcd6If school access type is open or openorinvite, show a message on the school access page to tell the school that they do not need to login in order to have their students register for the fair.
james
2007-02-26 20:15:07 +00:00
4c08f9c517This now prompts for which fields to display in the name tag (pdf).
jesse
2007-02-24 20:24:22 +00:00
5edba483e3This will prompt for which fields to display on the project table label. By default all of the checkboxes are ticked.
jesse
2007-02-24 19:59:55 +00:00
25412b6054added "ORDER BY school" to the drop down. This places the schools in Alpha order for us.
jesse
2007-02-24 19:31:55 +00:00
2d6257715eFix text on one configuration variable Fix judge manager to keep the 'show_what' persistent when performing other actions on the table (editing, sorting, etc).
james
2007-02-21 20:42:48 +00:00
40e305b83aProperly handle the yes/no config variable for showing registration cost brekadown on the summary page
james
2007-02-20 18:37:38 +00:00
8830c1be99added another column "school boards". This allows us to sort our list and quickly distribute the school access codes because we do not have email addresses for all of our schools.
jesse
2007-02-18 17:38:48 +00:00
8a009b71e1Add a "Presented by: " to the awards ceremony script Closes Bug #0000113
james
2007-02-12 22:30:43 +00:00
952a4d3c29Fix a bug where if no $table is passed to addTable it will now return gracefully instead of spitting out error messages Add email field to the judge list, and the judge manager list
james
2007-02-09 14:57:07 +00:00
8db16d85f8bump version for development
james
2007-02-08 22:01:29 +00:00
e3f63b7d6dbump version 2.0.8
james
2007-02-08 21:21:51 +00:00
1d203535eeAdd 1x4" judging sheet stickers for use on the CWSF judging sheets. It contains the project number, title, and category/division.
james
2007-02-07 22:05:59 +00:00
ca040924e3i18n the committee login button
james
2007-02-06 15:57:26 +00:00
7a1bc1144f- Don't show the tour capacity to the students - Filter the tour list by grades - Warn the students that they can't select tours until they select their grade
dave
2007-02-01 22:48:16 +00:00
caeb7cbe78- Add a config option (default 'no') to ask the students for a pronunciation key for their name. The idea is that it's for those often mis-pronounced names at the award ceremony.
dave
2007-01-31 07:35:08 +00:00
b6b93e1060- If the option to print the total registration fee is on, and there are pay-for t-shirts, completely remove the tshirt line if no tshirt is selected. It should cause less confusion - If the same conditions are true and a tshirt has been selected, inform the student how they can deselect it to not incur the cost of a tshirt with registration.
dave
2007-01-31 07:30:43 +00:00
72f4d9031f- The Gender is actually optional, so it doesn't need a REQUIREDFIELD.
dave
2007-01-31 04:36:51 +00:00
42b60170a4- Add a 4th text section to the signature page (of course, it's optional, and off by default). It's a postamble.. just a space for "Additional Information" after all the signatures.
dave
2007-01-31 00:48:24 +00:00
e71d3c0bbb- Allow the tableeditor subclass to return an empty array for the WHERE clause, and handle that case.
dave
2007-01-30 20:00:17 +00:00
57dfb7df27- Fix the is_callable calls.
dave
2007-01-30 19:58:26 +00:00
5d20a0590a- Might want to check my logic on this one.. but basically, if special awards are set to "with registration", bypass all date checks. Assume that if they're in the registration, they're allowed to select awards. - If the special award nominations are on "with registration", don't print the dates between which special awards can be selected.
dave
2007-01-30 08:05:29 +00:00
4d56266fec- Mark the language as a required field for judge input. I don't like how this looks, but I wanted to stick with the convention of putting ththe REQUIREDFIELD after the input boxes. Any ideas? Can we center a single REQUIREDFIELD after all the checkboxes?
dave
2007-01-30 07:53:38 +00:00
39cd2fbd8c- Allow Judges to select "other" awards too
dave
2007-01-30 07:51:43 +00:00
f83dcfebd0- Add the award critera to the page where we input the winners, just so the person doing the data entry has the option to sanity check the results.
dave
2007-01-30 07:45:12 +00:00
91d122ab3e- Forgot a mysql_num_rows when checking for award selection completion
dave
2007-01-30 06:25:51 +00:00
77226edb5f- Missed a file in the last commit
dave
2007-01-30 06:16:23 +00:00
50b4e146bd- Move the judging age preferences to the expertise page... and rename that page to "Divisional Preferences" - Add the ability for the judges to select special awards they would like to judge - Add the ability for a judge to specify that they are a judge for a specific (one or more) award, and disable the divisional selection for them
dave
2007-01-30 06:12:11 +00:00
49c5704143- Include the table editor before the judge class, this is in prep for PHP5 when we implmeent templates.
dave
2007-01-30 01:52:55 +00:00
james