Commit Graph

  • c0026c75e5 If there are no jdiv's left, hide the multi-select box and all the "Add >>" buttons so the page looks much nicer (and better to print!) james 2008-03-20 20:59:56 +00:00
  • 560d799b4b Allow filtering the awards management interface by award sponsor status: any, confirmed only, unconfirmed only james 2008-03-20 20:37:33 +00:00
  • ec66217a2b Split label_box into two separate options: label_box and field_box. label_box draws a border around the entire label, field_box draws a boarder around each field of text on the label james 2008-03-20 20:07:13 +00:00
  • 45a1bdd1e4 Only set the school if the school is posted through, this way we dont whipe out a students school. -This line, and those below, will be ignored-- james 2008-03-20 16:28:50 +00:00
  • bb4997548c - Add medic alert and food req. info - Change the name of cshool teacher/email because these are really the values the student enters. dave 2008-03-20 02:57:18 +00:00
  • 06cb13d7e4 Oops, the _seq's cant be null, they need to be set to 0 james 2008-03-20 01:57:24 +00:00
  • 3fc27ceb04 Set everything to do with the project number, project sort, and sequence numbers to null, not just the project number, when unregistering a project. james 2008-03-20 01:52:47 +00:00
  • e320230a3e Add a way to unregister projects. Simply re-enter their registration number, and click the link. james 2008-03-20 01:19:35 +00:00
  • 431c8d9036 Properly fix the summary required field for wordmin=0 (summary simply becomes a non-required field) Fixes the problem reported by waterloo, where the preg to count words was not counting words the same as the real word counter (602 vs 598 in the one i was looking at) james 2008-03-16 19:32:30 +00:00
  • 6e8883b4a2 - Add pronunciation dave 2008-03-16 19:09:47 +00:00
  • 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. dave 2008-03-12 01:18:29 +00:00
  • 4587fd3c86 - When checking the project status, count the words and test that against the min/max number of words. (fix 335). dave 2008-03-12 00:28:44 +00:00
  • a7da608982 Switch heading() to use addText() so it implements line-wrapping for super-long headings james 2008-03-04 21:57:49 +00:00
  • a7dad33da3 Cleanify the subject, and strip slashes from the message body james 2008-03-03 20:12:59 +00:00
  • 2d052c056f - Add an option to the award ceremony script to show the pronunciation key (if the students entered it) - Add an option to the award ceremony script to filter the awards by age category (the GVRSF needs one script for juniors, and another for intermediate/senior :) dave 2008-02-29 07:10:08 +00:00
  • 3a1b4cca15 - Ignore jdiv 0 in the annealer and in the check. jdiv 0 is what all unassigned divs/cats get, and if they're unassigned we don't want to schedule them. - Fix a typo in the language selection james 2008-02-28 20:23:27 +00:00
  • 6454f86aa9 - Add judge_scheduler_activity and judge_scheduler_percent to the config, if they don't already exist. dave 2008-02-28 20:03:48 +00:00
  • a8ed1d28e9 - Remove some old "Back to" links, the navbar does it now. dave 2008-02-28 19:34:39 +00:00
  • 07a7994d81 - When resetting the status of the scheduler, it is helpful to actually reset the status of the scheduler. dave 2008-02-28 19:30:19 +00:00
  • bb3d4c0480 Need -r3 now to keep track of changes since r2 was packaged james 2008-02-27 16:03:43 +00:00
  • 17745cbb0a Always show the city in the school access login page, and sort it first by city then school name (previously it only showed the city for duplicate school names) james 2008-02-27 15:59:03 +00:00
  • f70314653b - Only lookup _GET['showstatus'] once, for a minute speed increase and easier handling. dave 2008-02-26 08:32:00 +00:00
  • b1ed8e4b4a - Optimize away some code where I was trying something different. :) dave 2008-02-26 08:28:20 +00:00
  • 10bf90f0db - Fix the total count on the cat/div summary. Several fairs have emailed me to say the count is wrong. It's not wrong, it's just not printing the number they expect. This fixes that. dave 2008-02-26 08:19:38 +00:00
  • 343d777aab - Restrict data in a committee report to actual committee members dave 2008-02-23 03:42:51 +00:00
  • 15a56ce13f - Add First Aid and CPR data collection to the user table. - Modify the config so a committee can enable it for volutneers and committee members dave 2008-02-23 03:28:43 +00:00
  • e26453f06e - Fix spelling of spelled. This is why I shouldn't be allowed to code at 3am. dave 2008-02-23 02:50:29 +00:00
  • 145a5251c3 Only foreach the special awards if there are special awards to foreach over james 2008-02-22 19:35:23 +00:00
  • 1d3ee3f83e - Judge autocomplete function, there's no menu link to it. This should work for timmins and fraser valley dave 2008-02-22 06:19:22 +00:00
  • 3b55ddd4a7 Use single quotes for consistency james 2008-02-15 23:11:16 +00:00
  • a118acc21c Add the missing 'Gender' field to the user personal profile page, as well as save it :) james 2008-02-15 23:08:33 +00:00
  • e0a0e3dbcf - Fix a typo in two places... I wonder how long these have been like this. :S dave 2008-02-15 05:27:06 +00:00
  • 52fb9faed8 special awards communications should contact this year's contacts only.wq james 2008-02-13 22:42:02 +00:00
  • 6a766ac59d - fix copy/paste error in the tour annealer dave 2008-02-12 01:11:21 +00:00
  • c639892f3b - Properly disable divisional checks for special award only judges dave 2008-02-05 01:07:37 +00:00
  • fc4de718f0 - Use a » character instead of >> for menu position. dave 2008-02-04 23:40:26 +00:00
  • 482f2e6d3a - Sort the tour num+name column by number dave 2008-01-30 07:56:47 +00:00
  • 8ffc278286 - Put the "..." in the proper cell dave 2008-01-30 07:54:13 +00:00
  • a7ca82ff23 Add a preview option to the signature page config. james 2008-01-28 23:01:41 +00:00
  • 414a85ccb2 - Add number checking (and parsing) to the config editor - Change the type of $config['regfee'] to 'number' dave 2008-01-28 21:48:44 +00:00
  • 8b38f44501 - Move the start/end table logic into functions - If a multi-line table row spills off the bottom of the page, start a new page / and then print that row. dave 2008-01-26 20:41:33 +00:00
  • 8980275627 - Add mentor info to the student report generator dave 2008-01-26 19:46:16 +00:00
  • 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) dave 2008-01-26 19:14:24 +00:00
  • fddce24de3 - Fix the paper type in system report 44 - Add 2 new paper types (Ledger 11x17 + landscape) dave 2008-01-25 05:31:27 +00:00
  • 6a2683d92d Add ability to get registration list for previous years (only via appending &year=year to the URL) there is currently no user interface to access this feature. Also add the school board in brackets after the school name james 2008-01-24 18:51:05 +00:00
  • 4b9d67fffe - Fix division saving for the case when a committee decides to drop a division and the remaning ones need renumbering. (It was not properly saving the new id) dave 2008-01-24 08:59:04 +00:00
  • 125437dd55 - More GVRSF stuff that I missed. Add two fields to the award_awards: 'self_nominate', and 'schedule_judges'. - self_nominate defaults to 'yes' for all new and existing awards. If turned off, the award will not appear in the student self-nomination pages. - schedule_judges specifies whether an award should have judges or not, we have some special awards that students can nominate for but do not require judges to find the winner. Similarly we have some awards students cannot nominate for but do require judges to determine a winner. This allows both cases to be handled. dave 2008-01-24 07:46:12 +00:00
  • 446b54f693 - Properly construct the WHERE clause in the table editor dave 2008-01-23 20:20:54 +00:00
  • df38d87b40 - Columns for school report dave 2008-01-23 19:30:05 +00:00
  • 98d6c7b493 - Report to export school CSV data in the format used by the CSV importer dave 2008-01-23 19:27:46 +00:00
  • 7370a9387c Fix rollover comment :) james 2008-01-23 19:00:26 +00:00
  • b14ec011d4 - use the correct limit dave 2008-01-23 18:42:35 +00:00
  • 3f3475d407 - fix the limit on the special awards self nomination query - add a rollover for regfee items dave 2008-01-23 18:40:59 +00:00
  • 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). dave 2008-01-23 18:32:31 +00:00
  • 735e5e0999 - Add a registration fee item editor - Allow students to choose items from the optional registration items dave 2008-01-23 07:53:10 +00:00
  • 4357280ffb - Typo in the ordering dave 2008-01-23 06:02:10 +00:00
  • 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 dave 2008-01-23 05:54:03 +00:00
  • 8411d614d5 Add the schoolaccess page to the page text editor james 2008-01-22 19:22:51 +00:00
  • 086ee99c8f Lets bump version number to -r2 for 'stable fixes & changes' james 2008-01-22 18:46:18 +00:00
  • 856c86367a Remove the fair name from the title on the index page.. it doesnt need to be there, because its right above it! james 2008-01-22 18:26:46 +00:00
  • 1464751fb7 If the registration list is sorted by project number, sneakily sort it by projectsort (then fall back to projectnumber) james 2008-01-15 18:20:56 +00:00
  • 9c2955bf94 FIX a major error with the judge class - typo in the table name james 2008-01-15 17:34:36 +00:00
  • 658929d1d7 Update CHANGES Increase version to 2.1.8 james 2008-01-11 22:08:14 +00:00
  • 7eb4ad1ecc Fix install3 after dave's commit of the tour assigner config values as default year=0 The install3 script detects an 'existing' install vs a 'fresh' install by checking for config entries with year=0... originally it expected only one DBVERSION and if any others existed then this must not be a fresh install, but now since things exist there, we need to forcefully check only the vars we're looking for. james 2008-01-11 21:36:25 +00:00
  • 1fed6629bd Use firstname for the names so they show in the "to" of the email james 2008-01-09 17:28:11 +00:00
  • e7d436e409 Add ability to communicate (send emails to) - school principals (via schools.schoolemail) - school science heads (via schools.scienceheademail) - teachers (via students.teacheremail) - this year, last year, or all years james 2008-01-09 17:25:30 +00:00
  • 9a473041c8 - Be consistent with the header text dave 2008-01-07 05:51:54 +00:00
  • 48593842c6 - fix a typo in a link dave 2008-01-07 05:40:53 +00:00
  • 8c4b77cf41 - When saving committee orders, don't iterate through the order array if a committee has no members. Doing so just generates a PHP error. dave 2008-01-07 05:38:44 +00:00
  • 3cba628b51 - Disregard the year in award sponsors and contacts dave 2008-01-07 05:29:42 +00:00
  • a364e9ea56 - Fix the Partner Name (first last) column dave 2007-12-30 23:02:41 +00:00
  • f097559e9d - Fix some emergency contact headers dave 2007-12-30 22:32:58 +00:00
  • 7c5b53c268 - Fix the judges "Complete" header. Changed to "Cmpl" so it shows in the header. dave 2007-12-30 22:30:28 +00:00
  • 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) dave 2007-12-30 22:16:34 +00:00
  • 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 dave 2007-12-30 21:45:04 +00:00
  • 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. dave 2007-12-30 21:20:36 +00:00
  • eaad48d6d0 - Change how the num students report column works. It was failing when awards were added because of the row duplication. dave 2007-12-30 21:05:54 +00:00
  • ca52174cfe - Fix the grouping logic to handle the case where the group by column is also selected as part of the display columns dave 2007-12-30 20:03:05 +00:00
  • 5bcd7cd1e1 - Obey the pagesize settings when generating actual reports, not just labels. This makes landscape reports work. This still ignores the margins (just like regular reports ignore the margins on 8.5x11 pages anyway) dave 2007-12-30 07:28:06 +00:00
  • 827887a0fd - Change the volunteer position description/meet_place colums to text from tinytext. - Change the icon_path to somethign SFIAB will like better in the tableeditor (was wondering why I had no icons in the tableeditor) - Add a crude maxlength support for text areas dave 2007-12-29 19:43:56 +00:00
  • aa1be324ad - The project number needs a titch more space for the GVRSF. :) - Completely remove the old gvrsf_tablenumber report column. dave 2007-12-29 09:04:48 +00:00
  • 5aeaa6be0a - Also add the database update :) dave 2007-12-29 08:47:53 +00:00
  • 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. dave 2007-12-29 08:46:40 +00:00
  • a5998ca3dd Text update BUG239 james 2007-12-27 00:47:23 +00:00
  • 8e91b16b63 Text update BUG238 james 2007-12-27 00:45:31 +00:00
  • 67f3c2eda3 Text update BUG265 james 2007-12-27 00:43:40 +00:00
  • a13303afe9 text update BUG266 james 2007-12-27 00:40:59 +00:00
  • 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. dave 2007-12-25 05:13:42 +00:00
  • a912b7df99 - Clean up the award query. - Fix a bug in the award query tha twas incorrectly linking judges teams with judges - Add 'Judge Name' to the query so non mysql5 users can create an award report that lists the judge names for each award. dave 2007-12-24 21:18:08 +00:00
  • 1b0835a47f - Make the default report type 'student'. And load the necessary fields for that - If the report type is changed, submit the form with a reload, to reload all the available fields. dave 2007-12-24 19:38:06 +00:00
  • 7ff0b4b104 - Add more fields to the committee report type - Sort the report by the first field if no sort field is given dave 2007-12-24 19:20:01 +00:00
  • b47ac24ed1 - Decrease the cost of students not from the same school +5 could lead to a large penalty (5*20=100) which exceeds the cost of a 1st vs. 2nd choice tour. This could cause a student to be bumped to a 2nd choice tour for no reason other than to fix the schools. The idea for duplicate schools is to only prefer to have 2 students from the same school on a tour if there's a choice that oculd go either way, this will break that tie. dave 2007-12-23 19:15:50 +00:00
  • 8972b5219f - Fix the db update dave 2007-12-23 01:52:18 +00:00
  • e74c4ce64d - Another GVRSF change. Optionally include registration fee information on the signature page. dave 2007-12-23 01:33:09 +00:00
  • ebbac49b4b - Add the database stuff for the name check.. oops. dave 2007-12-22 23:44:46 +00:00
  • 6fc2118646 - Snazz up the important dates page a bit. Also add a unix timestamp query to show how we could, eventually, use that to format the date. But for now, leave it printing the ISO date. dave 2007-12-22 23:42:25 +00:00
  • 8ef21626f2 - Add a participant name check page for students to double check their name. - Fix a bug in tour printing after tours have been assigned (it would show both students in a pair project on the same tour, always.) dave 2007-12-22 23:28:14 +00:00
  • 60df636517 - Reorder/Rename some of the judge columns for clarity - Add an option to NOT filter a judge report by year if the report already includes a year filter. This allows one to FITLER by judges.year!='0', and get every judge that has ever judged at the fair (should probably add a distinct(judges.name) or something, because a judge that has judged in two past years would appear twice in that list. dave 2007-12-22 22:16:12 +00:00
  • 0b782d467d - Unclutter the judge query - Add project info, timeslots, and students to the judge query. dave 2007-12-22 21:50:25 +00:00
  • edf26caf1e - Avoid a divde by zero in label generation - Never allow the number of lines for text data to be zero in the first place. dave 2007-12-22 20:49:33 +00:00