Commit Graph

  • 2e1ed4a689 Fix the config variables rollover/install for the type and type_values fields james 2007-10-01 18:51:56 +0000
  • 4a3aaac8af Properly address french mailing labels to schools james 2007-09-27 15:29:48 +0000
  • 7cb46d5aee Use mb_strtoupper instead of strtoupper to properly uppercase accented french characters james 2007-09-27 14:08:46 +0000
  • 2063ada383 Insert a name 'Superuser Account' with the superuser record so it will properly show up in the committee editor list james 2007-09-26 21:30:52 +0000
  • 620353e8fa properly install config types and type values properly rollover config types and type values james 2007-09-26 20:21:13 +0000
  • 1aa5ef0332 bump version number 2.1.3 for development james 2007-09-20 17:42:55 +0000
  • c4c57fde2b Make sure the FAIRYEAR is 2008, and bump version number to 2.1.2 james 2007-09-20 17:31:43 +0000
  • 7f3a0ff528 Add a fix to re-roll award prizes that werent properly rolled over due to the rollover bug in 2.1.0 james 2007-09-20 17:26:18 +0000
  • abbfe00e82 Fix a bug that prevented the award prizes from being rolled over properly james 2007-09-20 16:53:06 +0000
  • a87647ee6c - Update database for schools report query. james 2007-09-13 19:18:18 +0000
  • 1e947cba16 - Add a school based report query, so things like mailing labels can be created for ALL schools, not just the ones attached to a student. james 2007-09-13 18:57:56 +0000
  • 6c94eeb751 Bump version number for development james 2007-09-13 16:42:32 +0000
  • d93f8e514c Version 2.1.0 james 2007-09-11 20:11:50 +0000
  • e36f452636 Wow, properly fix the broken winners.php to show multi-year data! james 2007-06-01 19:52:58 +0000
  • 0de2bfeef0 Add a few more missing "exit" calls after a header("Location"); james 2007-05-10 19:18:01 +0000
  • ec28dcfb7a if access is not allowed, make sure we exit after redirecting the script to the login page james 2007-05-10 18:59:04 +0000
  • 55fcc1cf06 Guess i never committed my multi-line table lpdf fix. here it is. james 2007-05-09 17:18:01 +0000
  • 878a29a9d1 - Another case where we depend on register_globals = 1 dave 2007-04-11 22:09:17 +0000
  • 9c1a16acc2 - Add assigned tour to the report generator - Add prize names to the report generator - Change award name to sort by name, if you want to sort by order, use the Award--Order column. (Specifying a sort by prize name, and it actually sorting by order doesn't make sense) dave 2007-04-10 15:53:48 +0000
  • 3f8d70d47d Add a bunch of fields that allow you to create all the information on a single form for Sci-Tech Ontario award winners to submit to sci-tech ontario james 2007-04-05 21:33:39 +0000
  • 6088779b37 Properly handle "quote" marks in the title if the page gets resaved after the initial save james 2007-04-03 21:07:44 +0000
  • f3ad2c7f26 Oops need to global $config for that last patch to work james 2007-04-03 20:17:32 +0000
  • 31aebc743f Only 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 +0000
  • c2856ad9cb add 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 +0000
  • eff30a5adb Add 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 +0000
  • 8c044c8309 - Remove unused nametag stuff. It's not referenced anywhere in the code base anymore dave 2007-04-03 20:09:19 +0000
  • e7776a6b9c CSV 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 +0000
  • 35ccf2a2ad - Fix an instance where we rely on register_globals to be on dave 2007-04-03 19:53:30 +0000
  • 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 +0000
  • daa3f4bb51 Rename the entry to "Website Consent" james 2007-03-31 01:10:56 +0000
  • c95df2b912 Implement 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 +0000
  • 97c2b65a93 Require >1 judge div grouping james 2007-03-29 20:33:45 +0000
  • e2ee104434 If 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 +0000
  • d209b0648f Add 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 +0000
  • 6fa1a01fe6 Remove much of the awkwareness of the awards management interface james 2007-03-28 18:03:15 +0000
  • 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 +0000
  • cc2e6b5bce - Add fullpage (no margin) reports for the full pages, we need them for our certificate generator dave 2007-03-27 05:01:51 +0000
  • fb1ddd4775 Clarify 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 +0000
  • 72afcf583c Get the logo to fit on the label james 2007-03-26 17:04:42 +0000
  • d21fbee5a4 - Turn off table label boxes by default dave 2007-03-26 16:55:45 +0000
  • a979f158eb - Add a 0.75" page margin to the full page labels dave 2007-03-26 16:49:15 +0000
  • 99ad9ae8e3 Only show the max number of students per project, no matter what the address bar passes into $_GET james 2007-03-26 16:29:20 +0000
  • ee6454868f - Sneak this in so we don't print nametags for incomplete judges. dave 2007-03-26 06:30:15 +0000
  • 336ec2f75c - Don't generate PDF table reports for things that should be labels.. generate "label" reports. dave 2007-03-26 06:20:43 +0000
  • 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 +0000
  • 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 +0000
  • c22b3fa86b Add some extra fields to the awards report james 2007-03-22 14:55:24 +0000
  • c64d7445e9 Update the selector so it works dave 2007-03-20 20:50:14 +0000
  • 23934f080a - Fix the report selector for browers that can't seem to do javascript dave 2007-03-20 18:49:44 +0000
  • 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 +0000
  • 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 +0000
  • 18d2bfa0d3 - The generator needs these to be arrays dave 2007-03-19 16:47:01 +0000
  • cf8f539c48 - Missed a year check dave 2007-03-19 07:49:21 +0000
  • 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 +0000
  • 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 +0000
  • 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 +0000
  • 2b4c5f12e3 - How did that ';' get in there ? dave 2007-03-18 23:54:35 +0000
  • 7487828552 - 4 new reports dave 2007-03-18 23:18:07 +0000
  • d659999339 - Update the judge and award report generators dave 2007-03-18 21:48:36 +0000
  • 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 +0000
  • 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 +0000
  • 857cb6aa7b - Fix the CSV generator dave 2007-03-18 07:19:00 +0000
  • 331bedc7e7 - Delete reports that the new report generator now duplicates dave 2007-03-18 07:12:49 +0000
  • 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 +0000
  • 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 +0000
  • a318e2d1fa Always 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 +0000
  • faceec20ed In the judges division groupings, only show the count of projects that are complete or paymentpending james 2007-03-13 22:11:18 +0000
  • 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. james 2007-03-13 21:34:24 +0000
  • e2eff96db9 Show 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 +0000
  • 453a3666f1 - Commit the report generator.. it still needs work, but it's quite usable now. dave 2007-03-13 06:10:27 +0000
  • eb0481b2a1 - Add hr() and vspace() to the CSV report generator. james 2007-03-13 05:01:37 +0000
  • cb992b8819 - Add the "none" tshirt option to the admin student editor dave 2007-03-12 17:27:55 +0000
  • 3519bc5e0e Add three new email recipients to the communications module: james 2007-03-12 14:23:44 +0000
  • 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 +0000
  • 1e2608d5b5 If 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 +0000
  • ea55978aa9 Make sure $config['dates']['postparticipants'] is valid before relying on it. james 2007-03-08 21:35:52 +0000
  • 59aade5f0c Add 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 +0000
  • a426c264d4 Version 2.0.12 james 2007-03-05 21:03:09 +0000
  • 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 +0000
  • 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 +0000
  • 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 +0000
  • 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 +0000
  • 9e009bc5d6 - Remove a debug print statement from last commit :) james 2007-03-04 20:30:31 +0000
  • 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 +0000
  • c7560b91d4 Update wording for 'invite only' judge registration james 2007-03-04 16:52:37 +0000
  • 2ff20effc2 Respect page margins on the school access codes report james 2007-03-04 16:38:45 +0000
  • fe2627faec Fix the wording on Jesse's table labels and nametags field section pages. james 2007-03-04 16:36:28 +0000
  • 44a6431cd7 Bump version for development james 2007-03-04 16:26:46 +0000
  • db600b5eb4 Properly 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 +0000
  • 659bc11066 Put 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 +0000
  • 11c995f94a Bump version number to 2.0.10 james 2007-03-02 14:42:03 +0000
  • fea05546d1 Fixed the reports_schoolprojects report to not error when there are no projects james 2007-02-26 21:43:39 +0000
  • d644f6dcd6 If 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 +0000
  • 4c08f9c517 This now prompts for which fields to display in the name tag (pdf). jesse 2007-02-24 20:24:22 +0000
  • 5edba483e3 This 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 +0000
  • 25412b6054 added "ORDER BY school" to the drop down. This places the schools in Alpha order for us. jesse 2007-02-24 19:31:55 +0000
  • 2d6257715e Fix 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 +0000
  • 40e305b83a Properly handle the yes/no config variable for showing registration cost brekadown on the summary page james 2007-02-20 18:37:38 +0000
  • 8830c1be99 added 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 +0000
  • 8a009b71e1 Add a "Presented by: " to the awards ceremony script Closes Bug #0000113 james 2007-02-12 22:30:43 +0000