Commit Graph

  • 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
  • 972f05b58e - Remove PHP5-isms dave 2007-01-28 07:56:52 +00:00
  • 3da0ba87e2 - Update the table editor, instead of doing all that funky stuff for listing the table, we call a method in the table helper class. That method returns 3 things.. an array of SELECT columns, an array of FROM tables, and an array of WHERE clauses. The table editor takes these, adds ORDER, LIMIT, etc, and runs the sql. - Update the table editor to allow variables to be set. THe helper class reads these variables to do pretty much anything it wants.. In this commit, it reads the judges_show_what variable, to determine how to format the SQL for selecting the table of judges (so the calling php can now know NOTHIGN about the database, it just sets a variable and expects the data to be formatted correctly. - Update the judge manager, show all judges should now SHOW ALL JUDGES. dave 2007-01-28 07:53:14 +00:00
  • 418dc75cef - Comment the comment dave 2007-01-24 04:10:35 +00:00
  • 668565919f - Make the age pulldown selection based on ages, not grades dave 2007-01-24 03:56:46 +00:00
  • ff76c06e17 - Fix a bug that prevented the tour selections from showing up in IE. dave 2007-01-23 20:42:17 +00:00
  • 5d36be70e2 - Dynamically build the list of grades for tours based on the configured fair grades. dave 2007-01-21 18:46:12 +00:00
  • ca24d7afc3 - Use unlink on each logo file, instead of system and rm -rf with pattern matching. dave 2007-01-21 18:41:47 +00:00
  • 0ba89a18a7 - Add a new config variable 'specialawardnomination_aftersignatures'. Default='yes', meaning the behaviour is the same as the default. 'no' means that students can self-nominate for awards before the committee receives their signature form. dave 2007-01-21 05:45:36 +00:00
  • 94639c1278 - Allow a committee member to edit the password in their own profile (if they have admin access to access the committee editor) - Put a "My Profile" link on the main nav bar once a committee member logs in, so they don't have to find themselves thorugh the committee editor. It takes them right to editing their own profile. dave 2007-01-21 05:43:29 +00:00
  • 039a3aa1d5 - Alternate colours on each line in the config editor. Makes it easier to see which config lines go with which options. dave 2007-01-21 03:55:38 +00:00
  • 5ca11ae362 - Properly copy the config type in the config editor when copying -1 config values into the current year - Add 2 new config options. - 'participant_student_tshirt_cost' allows the cost of each fair tshirt to be set (vancouver charges $10 for tshirts, because not all students want them), this also adds a 'none' option to the tshirt selection box, and a note indicating the tshirt cost if the costs is nonzero. - 'regfee_show_info' adds a "Registration Fee Information" to the main student registration page, showing a breakdown of the registration fee computation (including tshirts, per_student and per_project registration, and indicates the total. - Convert the tshirt field to VARCHAR(32) instead of enum so the "none" option described above works, also, some fairs may want to add more optoins, like female/male sizes.. so turn this into a text field for those fairs. The next step would be to make a config option for the tshirt options. :) dave 2007-01-21 01:40:46 +00:00
  • 018725aebf - Add a type field to each config variable. The type field is used to tell the editor what type of variable to expect. It can be yesno, enum, text (default), number (unimplemented), or blank (default behaviour of the current system). In response, the editor will use pull down lists instead of text boxes for things like "Yes", and "No", or enumerated fields. - Update the descriptions and type of existing variables. dave 2007-01-20 22:23:44 +00:00
  • 82b8b75b25 - Add location and contact info for each tour. Dump this in the CSV dump of the tours, but don't show it to the students at all. dave 2007-01-20 08:10:26 +00:00
  • eff2190ac1 Added grade 4,5,6 to tour selection dave 2007-01-18 09:39:21 +00:00
  • f7c430d712 - Allow a committee privateemail to be written as '' (nothing) without throwing the "email address already exists" error. dave 2007-01-18 04:16:43 +00:00
  • dd247fa002 - Added a "Delete Logo" button if a logo exists. It just wipes out the .png and .gif logo files. dave 2007-01-16 19:45:12 +00:00
  • 14e8ee5ec9 - Fix an issue with the default import of judging questions dave 2007-01-16 19:32:40 +00:00
  • 6495dabf79 bump version to 2.0.7 for development james 2007-01-12 22:13:12 +00:00
  • 128a9c1651 Bump version number james 2007-01-12 20:49:59 +00:00
  • 932ce3731c remove some extra code from the tours manager add a link to return to admin for translations james 2007-01-12 20:45:52 +00:00
  • 8ed5dd3dfc Try this version.. Removed the quotes from sortField, added them to the table headers when the table is printed. james 2007-01-10 17:19:15 +00:00
  • e43bcb1a7d - Quote the field in the ORDER part of the sql, in case it happens to be an sql keyword. dave 2007-01-10 07:28:12 +00:00
  • b022cb5978 Fix complete/incomplete detection for tour choices - Incomplete if any student in the project hasn't selected the min number of tours. dave 2007-01-10 05:16:58 +00:00
  • a386788300 update add 2 missing columns to config. dave 2007-01-10 05:12:36 +00:00
  • 900dab702d Add Tour selection. - Admin can use the tour manager to add tours - Admin can use the config variables to enable tours, and select the min/max number of tour choices. - Students will see a "Tour Selection" section of registration, which is incomplete until the student has selected at least a minimum number of tours.... actually, this may be broken.. Need to look at it further.. dave 2007-01-09 19:05:23 +00:00
  • 2d17c8c21a Add new participnt registration type: openorinvite - allows you to use the system as if it was OPEN or INVITE however limits cannot be imposed in the inviter since when its reached in the inviter it could easily be bypassed by registering through the 'open' way. james 2007-01-02 23:38:53 +00:00
  • 0dd2da7145 Add configuration options to choose whether to ask the students if they require: - table - electricity james 2007-01-02 20:33:16 +00:00
  • 9fc98fc288 Add a TCPDF version of the signature page, TCPDF does not require any extra PDF libraries (eg pdflib) to be installed Create PNG versions of the uploaded logo image file Detect which version of the signature page to use Bump version to development series 2.0.5 james 2006-12-18 20:55:30 +00:00
  • 0bd7ab8a93 Add an option to forcibly reset the judge scheduelr incase it gets stuck in an inconsistent state Bump version number Correct wording on judges expertise page james 2006-12-15 21:18:27 +00:00
  • b38dfe33cc Update copyright headers to 2006 james 2006-12-15 19:51:32 +00:00
  • f36212f868 Add a project editor and a student editor, accessible by clicking on the project or student links from the "Registration List and Statistics" page james 2006-12-15 18:45:06 +00:00
  • 1e7d9fcad9 Show access code in schools list Add ability to create access codes for all schools and to remove access codes from all schools Update generatePassword to accept a password length as a parameter, defaults to 8 james 2006-12-06 19:24:09 +00:00
  • 8fd2a44050 Add a configurable character limit on project title length, default is 100 characters james 2006-12-06 18:22:31 +00:00
  • 319c5d6720 Add option to turn off the Mentor section for participant registration Add two new projectnumber options: c=category shortform, d=division shortform, eg (JLS01 = Junior, Life Science, Project #01) Add shortform field for age category Fix bug in config editor where it was updating values for ALL years, instead of just the current year! Bump version number to development version james 2006-12-06 17:58:40 +00:00
  • c951c58984 Only allow the Password: field in the committee manager to be shown/displayed/edited by someone with superuser access level (i thought thats how it always was!, thats how it was meant to be at least!) james 2006-11-21 20:20:25 +00:00
  • eb9cf34645 Add db update 31 to fix any fairs that have rolled over their config variables using 2.0.0.. it is essentially the same db updates as db.21 that re-categorizes the variables. james 2006-10-30 20:11:27 +00:00
  • 19c5c43b87 Fix a bug that prevented judging questions from being added Fixed a bug when rolling over fair years with configuration variables not coming over properly james 2006-10-30 20:03:38 +00:00
  • 4727c65cca Bump version number for development james 2006-10-26 14:20:38 +00:00
  • ba0714fba3 If the installation can only find an older version of the "full" installer, then automatically run the update script to get up to the newest version james 2006-10-26 02:31:50 +00:00
  • 9082d905b3 Bump version number to 2.0.0 james 2006-10-26 02:23:22 +00:00
  • c4527e1f34 Fix missing i18n's, fixes BUG #0000079 james 2006-10-25 19:18:33 +00:00
  • 669ef1349c Add an ETA calculation to the status james 2006-10-25 19:10:27 +00:00
  • 35e4e3cf22 Remove a wackload of debugging stuff from the judge class and remove a few fields that should not be editable james 2006-10-25 18:49:06 +00:00
  • b2c2fdb38b Add an option to DELETE a registration, removes everything to do with it from the database james 2006-10-25 17:35:51 +00:00
  • c72193e671 Update database for the language pack installer system to work properly james 2006-10-25 16:35:16 +00:00
  • 95dc9eea5b Launch the scheduler with a lower priority (10) instead of hte default (0) james 2006-10-25 03:25:31 +00:00
  • b65316c32e Changes to judging scheduler so the process runs smoothly Dont let it start running if its already going Properly handle the text when its done running james 2006-10-25 03:19:54 +00:00
  • 2bb5c2e2a4 Oops add the launcher james 2006-10-25 02:41:56 +00:00
  • a871759129 Add the judges scheduler status page, updated automagically using AJAX Redirect the scheduler link to a launcher link that lauches the scheduler then goes to the status page james 2006-10-25 02:41:41 +00:00
  • 5cf008adf6 s/precent/percent james 2006-10-25 02:26:49 +00:00
  • b883d2f389 - Fix the percent update in the judge scheduler dave 2006-10-25 02:23:53 +00:00
  • 677132f307 Ooops, close php properly on the communication.inc.php file (sloccount told me so!) james 2006-10-25 01:50:59 +00:00
  • cf1bf2cf9d change set_progress to set_percent james 2006-10-25 01:48:32 +00:00
  • f687e4d889 Put the judge scheduler status in the "Judge Scheduler" category, instead of a new category (having it in a new category makes that new category show up on the configuration variables page, and since they are year=0 the page would be empty anyways. james 2006-10-25 01:34:11 +00:00
  • 2339154da6 Add a live version checker that checks if your version of SFIAB is up-to-date Add a live language pack installer that installs language packs off the SFIAB server james 2006-10-25 01:17:41 +00:00
  • 31fc7a0866 Update the rollover script to rollover the new fields that were added recently james 2006-10-25 01:16:48 +00:00
  • ea418624ba - Add status output to the judge scheduler in the form of 2 variables. Completely untested because I don't have judge data here. Will test when I get home and debug. dave 2006-10-25 00:53:02 +00:00
  • 65e408ce2a Add a check about rolling over the fair year, which will begin to show a warning 4 months after the fair date until the year is rolled over properly james 2006-10-23 18:38:05 +00:00
  • f6272d7bd6 Remove the border on the help icon james 2006-10-23 14:57:29 +00:00
  • 2e36dbe28b Commit the db.29 update james 2006-10-20 05:06:06 +00:00
  • f3e8762f2e Only check if the cwsf division id is set once per project, not for each student james 2006-10-19 23:31:28 +00:00
  • 2c6568ca22 Add a script to empty out the registrations, students and projects Update populate_fake script to be more realistic and to add email addresses james 2006-10-19 23:30:13 +00:00
  • 06cb40304b Add the link to the One-click CWSF registration Also split the student display onto multiple lines james 2006-10-19 23:12:11 +00:00
  • aa93c170db Actually send the data to the YSF server! james 2006-10-19 22:54:26 +00:00
  • 2019e24b89 Add the 'one click' CWSF registration code! It current generates the XML but does not implement the sending to YSF (thats still to come!) james 2006-10-19 21:39:30 +00:00
  • 9fbb3feb3b - A few simple fixes to make it work in default mode dave 2006-10-19 17:17:43 +00:00
  • a9ca1718d1 - A new judge report generator.. it's completely broken and not done, but I wanted to get it into the repository so maybe I can work on it elsewhere later today. dave 2006-10-19 17:16:31 +00:00
  • 1d068915be - A text writer similar to the CSV and PDF writer... will allow for much faster debugging, and means we can look at data in the browser without downloading the CSV. dave 2006-10-19 07:32:02 +00:00
  • bb18130716 Set a record type for judges james 2006-10-18 19:37:31 +00:00
  • ff9c78d5a2 Make tableeditor PHP4 compatiable james 2006-10-18 19:33:04 +00:00
  • 5e77a78642 Oops i forgot to commit the help icon changes... here they are james 2006-10-18 17:32:14 +00:00
  • d1db2cceda Fix daves typo's :) james 2006-10-18 17:25:41 +00:00
  • 9f9b612e5d - Added an option for the tableeditor to construct a LEFT JOIN when listing a table - Add complete and year options to the judge manager, filter by ALL, active and inactive for the current year, or active only. - Add the "complete" status the the judge info page (the judge info popup page needs to be integrated with the new judge manager, somehow.. so we can remove the judges_judges list page). dave 2006-10-18 17:05:18 +00:00
  • 29a772ae5e - Add the judge manager to the judges admin page - Put a total at the top of the judge manager list - Add to the table editor: - Change the filter to accept a single argument, so we're not restricted to the $k='$v' syntax, we want to be able to filter on a table JOIN. - Add a additionalListTable variable, and additionalListTable() function, to specify additional tables that should be part of the table select statement. I guess ideally the class would implmenent their own if alternative behaviour was desired. But this way is pretty generic. The table editor can now, for example, select judges by year. dave 2006-10-18 07:50:23 +00:00
  • e3035cb13f - Add a password warning to the judge password page, indicating that the server may not be secure, so don't use an important password. dave 2006-10-18 06:47:41 +00:00
  • 3a4d919691 - Implement judge insert and delete. Still needs work, the "delete" should only remove the judge from the current year. The editor needs a field to say if the judge is registered for the current year or not. - Delete also needs to somehow express that the judge will be deleted for the current year only. Which means we should probably implement a Purge, to completely wipe a judge out of the system. dave 2006-10-18 05:57:20 +00:00
  • e2e1f3433c - Add the judges expertise. This should be all the cross referencing required for judge specific stuff. Haven't tested/debugged adding and deleting. But editing works. dave 2006-10-17 07:34:18 +00:00
  • 5e26bd1395 - Missed an i18n(); dave 2006-10-17 07:04:11 +00:00
  • e3abff348b - The table editor detects a pipe character in the field name now, and if it exsits, it separates the field at that point, and prints the text after the pipe in the data area, not the header area of the edit table. dave 2006-10-17 07:01:55 +00:00
  • 29e14c2514 - Fix the tableeditor to do a string compare for determining if something should be SELECTED in the select type. If the keys are 0, and there is no data, PHP does a numeric compare and matches them, when they shouldn't actually be matched. - Add Load/Save for the judge category preferences - Enable saving to mysql. It works. - Update the tableeditor css to use the same colours as sfiab dave 2006-10-17 06:44:27 +00:00
  • b8f2e52401 Show inactive judges list - this will probably be replaced soon with the new editor interface. Fixes Bug #0000064 james 2006-10-16 17:50:28 +00:00
  • f395e7480b Add a link to return to the main schoolaccess page once a school has logged in. Fixes Bug #0000100 james 2006-10-16 17:31:55 +00:00
  • 5c19a3d0f0 - Added all the fields in the judges table to the judges class, all that's left now is doing all the cross referencing. dave 2006-10-16 16:54:29 +00:00
  • 7143e9e01a Delete old school mailing labels and replace with a mailing label generator that allows you to customize the size of the labels to suit _ANY_ label stock paper. james 2006-10-16 15:42:29 +00:00
  • 1a2b3d7faf - Implemented save functionality in the judge class - Moved the tableeditor class to accept a generic class, no longer a person class - Restored the original functionality where everything is specified in the constructor, but added a 'class' which can be a dummy class to return to the original tableeditor functionality. The tableeditor checks for class->tableEditorLoad() now, and if that exists it calls it. If it doesn't then it calls a default Load() routine which contains the original code from the tableeditor. Same with save. dave 2006-10-16 06:21:20 +00:00
  • 4a5bc27532 Add salutation field to award contacts james 2006-10-16 03:36:39 +00:00
  • 671778d5ff Use the registration number in the sub-heading of the signature page so the filename's are always unique. james 2006-10-16 03:35:59 +00:00
  • 5c9920cfab update scripts for 2007, also append the language to the end of the project title, so its easier to tell if a language is english of french james 2006-10-16 03:34:57 +00:00
  • 83691b07b8 Add a header for "public email / private email" to the top of the committee list administration page. Fixes Bug #0000041 james 2006-10-16 02:36:20 +00:00
  • 7e0720dffe Fix a typo james 2006-10-15 21:52:58 +00:00
  • cbc01c020f Fix the filename of the awards ceremony CSV script - Fixes Bug #0000063 james 2006-10-15 21:33:32 +00:00
  • cb6f4a3dbb update database length of email field from 32 to 128 update maxlength attribute of phone/fax fields to 32 (from 16) to line up with the db fields james 2006-10-15 20:42:02 +00:00
  • 2dbc8fc067 change scripts for fairyear 2007 select a random school from a list of all available schools assuming that only 1 in every 4 schools actually participate james 2006-10-15 20:14:54 +00:00
  • 130f0f5786 Implement Bug #0000029 - Report to view school access codes and registration passwords james 2006-10-15 20:07:18 +00:00
  • ac3e1d6b1d Implement Bug #0000011 - Show safety question order and warnings when non-numeric values entered james 2006-10-15 19:50:09 +00:00
  • 9eef488a5d Implement Bug #0000004 - Do not allow multiple committee members with the same email address james 2006-10-15 19:36:33 +00:00
  • 335330dd35 Minor update to the person class dave 2006-10-15 18:43:46 +00:00
  • f03dcb782b bump db version for new schools data james 2006-10-15 17:12:58 +00:00
  • 4ee617eb52 Add more school information to the schools database (school lanaguage, school level, principal and school email addresS) james 2006-10-15 17:11:56 +00:00