arman/science-ation
1
1
Fork 0
forked from science-ation/science-ation
Code Pull Requests Activity

Commit Graph

  • 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 +0000
  • 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 +0000
  • 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 +0000
  • 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 +0000
  • 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 +0000
  • 5aeaa6be0a - Also add the database update :) dave 2007-12-29 08:47:53 +0000
  • 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 +0000
  • a5998ca3dd Text update BUG239 james 2007-12-27 00:47:23 +0000
  • 8e91b16b63 Text update BUG238 james 2007-12-27 00:45:31 +0000
  • 67f3c2eda3 Text update BUG265 james 2007-12-27 00:43:40 +0000
  • a13303afe9 text update BUG266 james 2007-12-27 00:40:59 +0000
  • 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 +0000
  • 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 +0000
  • 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 +0000
  • 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 +0000
  • 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 +0000
  • 8972b5219f - Fix the db update dave 2007-12-23 01:52:18 +0000
  • e74c4ce64d - Another GVRSF change. Optionally include registration fee information on the signature page. dave 2007-12-23 01:33:09 +0000
  • ebbac49b4b - Add the database stuff for the name check.. oops. dave 2007-12-22 23:44:46 +0000
  • 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 +0000
  • 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 +0000
  • 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 +0000
  • 0b782d467d - Unclutter the judge query - Add project info, timeslots, and students to the judge query. dave 2007-12-22 21:50:25 +0000
  • 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 +0000
  • 801e70cb0c - Fix the awards query - Add prize amounts to the report editor - Add a column to compute the number of students who worked on a project to the report editor dave 2007-12-22 19:12:43 +0000
  • 8ef6f7ea45 - Update the admin judge page to make the order of things a bit more clear. dave 2007-12-22 10:17:16 +0000
  • fd9da0845b - Add special award selection editing to the judge manager dave 2007-12-22 09:56:46 +0000
  • 1aadc76ebc - The awards store whether to schedule judges for a special award (schedule_judges). We should obey that even though it's always set to 'yes' and there's no way for a user to change it.. yet. dave 2007-12-22 09:36:23 +0000
  • 3c9253dd9d - Add a config option to disable printing the cash/scholarship amount on the public winners page. (defaults to ON, which is the current behaviour) - Fix pluralization of "Students" for one student. :) - Change the effort option for judges and tours to a pulldown menu Low=100, Med=1000, High=10000 dave 2007-12-22 05:11:42 +0000
  • e7a5ad183d - Add the grade and school of each student to the signature page. dave 2007-12-22 04:20:17 +0000
  • 0d0e6bbb0f - Clean up the participant tour selection. Don't allow participants to select tours after the assignemnts are done - Always report the Tour status as complete if tour assignments have been done (rank 0 tours exist) - Inform the participant of their tour assignment if assignments are done dave 2007-12-22 04:03:17 +0000
  • 7b7c6c0db2 - Use pdf_fit_image instead of pdf_place_image. - 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. dave 2007-12-22 03:31:02 +0000
  • 2cfbcc2b41 - Add an 'X' button to the "REmove this mentor from this project". To clean up the oldest bug in the tracker. :) dave 2007-12-21 19:24:12 +0000
  • c6e90a0ffa - Add regular expression checking for each field. And refuse to save user personal info unless the regexp matches. - Also add error reporting so the user knows which field is in error, and what the proper format is. dave 2007-12-21 09:47:18 +0000
  • 7f7c3c53e1 - Change the password expiry mechanism to always check {$type}_password_expiry_days. This allows the $config variable to be updated and everyones password will expire based on the new value. To implement this, the password expiry column in the users table has been changed to passwordset, and a PHP script is used to convert the expiry dates to set dates (based on the _password_expiry_days) - Cleanup the password entry checking - Load all config variables for the db_update.php script. Just in case an update script wants access to $config dave 2007-12-21 08:38:13 +0000
  • a420a18143 - Skip some session variables on logout, clear everything else. dave 2007-12-21 01:16:30 +0000
  • 3f2c4d95f3 - Remove an extraneous table, so that the "change password" link appears on the page, instead of below it (or not at all) dave 2007-12-21 01:03:31 +0000
  • 2f443868d0 equality, not assignment operators would help I guess justin 2007-12-21 00:35:31 +0000
  • 337d5acac2 Close php james 2007-12-20 22:47:21 +0000
  • 1ae2b2e779 Better display of development versions, and make the DEBUG session output easily switch on-off-able by passing in ?debug=true or ?debug=false to any page. james 2007-12-20 22:39:21 +0000
  • e4fb689d58 Add prize value, and the trophy stuff to the generic prize template divisional awards creator When creating divisional awards using the generic prize template, obey config option to filter divisions by category When managing jdivs, obey config option to filter divisions by category Add an option to the jdivs (at the bottom) to completely whipe out all jdivs so they can be recreated (eg if age categories / divisions are deleted or changed, or if ones were created that shouldnt have been due to the filter divisions by category not being obeyed james 2007-12-20 20:45:18 +0000
  • 0db1467da7 - Fix errors, crashes, infinite loops caused by jdivs with no projects. dave 2007-12-20 19:52:15 +0000
  • 8c42e853af - Handle type/stock for custom reports properly - Convert reports.php to use SESSION based status messages. Just to try it out. dave 2007-12-20 18:44:28 +0000
  • 348647208f put the type and stock checks back in, to make sure we get the right stuff. james 2007-12-20 18:38:17 +0000
  • 312808bc8f Dont disable the type & stock so the default values (selectedIndex=0) still gets POSTED, even though the dropdowns are not displayed. james 2007-12-20 18:35:47 +0000
  • a352886ca6 And remove my print_r debug :) james 2007-12-20 18:18:06 +0000
  • a69ad4ae71 Oops use the right fields for type and stock james 2007-12-20 18:17:40 +0000
  • 515a92dda7 Dont use JSON anymore, we really dont need the entire report object, we just need the 3 fields type, stock and desc, so return them on their own line, so we can just split on \n james 2007-12-20 18:13:06 +0000
  • f17f07ff94 - Don't open the info window until it is requested. dave 2007-12-20 18:07:39 +0000
  • 87f1452919 Fix invalid type. type="" is valid because of custom reports. Same for stock. james 2007-12-20 18:00:30 +0000
  • a660ea4e3f Add a random tour choice rankings script. Modify all scripts to 'exit' at the beginning with a message... if anyone wants to run these scripts, they should be smart enough to be able to edit the file and comment out the 'exit' call. james 2007-12-20 16:41:57 +0000
  • d9f6b8c330 Remove the warning about only being able to submit once.. it doesnt make sense for stats. james 2007-12-20 16:01:39 +0000
  • 647456ae69 judges_data.php ?? how baout judges_schedulerconfig.php :) james 2007-12-20 15:58:07 +0000
  • e0a77c6fd6 Sort the 'Projects and Judges' listing by jdiv_id james 2007-12-20 15:53:11 +0000
  • 93f610c214 Make judges_jdiv groupings obey the filterdivisionsbycategory config option and dont show div/cat's that shouldnt exist james 2007-12-20 15:47:19 +0000
  • 9a7383f552 How'd that / sign get in there, it should be a . to concatenate james 2007-12-20 14:48:02 +0000
  • 71166d3e6b - Add the easyparse student names option dave 2007-12-20 09:51:08 +0000
  • 6c61595cb9 - Add an option to print ALL student names for a project (will work for more than 2 students). dave 2007-12-20 09:43:22 +0000
  • 49a19c9d44 - Fix report stock when the report stock keys were updated - Add a missing stock number - Fix a report where distinct was missing dave 2007-12-20 09:25:43 +0000
  • 984c9776ef - Separte the action handler from the config emitter (but tie them together so that the old functionality remains) - Run the action handler separately in the tour annealer and judge annealer config so that the page can be refreshed immediately after an update, so the config variables (that may have changed) are reloaded. - Skip updating config variables that haven't changed. dave 2007-12-20 08:20:29 +0000
  • c8d01cb8fb - Handle the case where a student doesn't use all their tour rankings. dave 2007-12-20 04:29:16 +0000
  • 1dd573ab63 - Add the tour annealer config/launcher dave 2007-12-20 01:14:21 +0000
  • 7841190240 - Remove the old tour reports from the old report page dave 2007-12-20 01:13:24 +0000
  • 5a3d7de0b6 - Return emergency contact info to a component in the query. dave 2007-12-20 01:09:16 +0000
  • 998fe35d67 - Add a tour number to the database, and modify the tour editor to include the 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 dave 2007-12-20 01:05:04 +0000
  • aa2f8883e3 - Fix the overlapping text in table layout when trying to fit it in multiple lines - Fix an infinite loop if the text will never fit in the width provided. dave 2007-12-20 00:56:57 +0000
  • 5c594a9d85 - Sneak in a change to the report tables, we're going to create tour reports next dave 2007-12-19 21:16:58 +0000
  • b0338f9fdf - Add 3 config variables: An effort for the tour annealer, and the updater activity and percent. - Add the status update and links to automatically start the "tour assigner". (Didn't want to call it a scheduler, because someone might thing it's for assigning tours to timeslots or something) dave 2007-12-19 21:12:57 +0000
  • 5ad72acabf - Finish the cost function explanation dave 2007-12-19 19:58:15 +0000
  • c5887eb432 - A working tour annealer.. Now I just have to glue it all together. dave 2007-12-19 19:52:11 +0000
  • dba389618d - Move the tour manager into a tours subsection of admin - Add a tour assignment editor, basically a copy of the judge team editor dave 2007-12-19 07:49:38 +0000
  • 2af3482ecf - Also quote a field if it contains a newline. dave 2007-12-18 19:52:13 +0000
  • 1b83ff4c12 - Add a bit more error reporting, and do the error report before attempting to use the result. dave 2007-12-18 19:50:12 +0000
  • 2363a38120 Add an actual form to the ceremony script setup page. justin 2007-12-17 23:20:21 +0000
  • c514d7910a - Alternate colours on the variable editor categories dave 2007-12-17 22:25:54 +0000
  • 63c5f3b2ff Rework the variables display a bit james 2007-12-17 21:57:26 +0000
  • 1d6c0c9530 Remove committee auth check and replace with commandline only check -- This allows the judges scheduler to actually run again! james 2007-12-17 21:37:22 +0000
  • b366d7bf4e Change varaibles.php to use a vertical section menu; slightly rough initial version. justin 2007-12-17 19:31:09 +0000
  • 18aafbea9c Add support for a minimum number of words in the project description. Resolves RFE 162. justin 2007-12-17 18:19:08 +0000
  • 30072d182d Add support to omit unawarded awards and prizes from the awards ceremony script. Resolves RFE 136. -Note: currently adds two configuration variables and a new category, they didn't seem to fit elsewhere. justin 2007-12-17 17:35:19 +0000
  • 4043df2e66 set a minimum on config editor input text size, so if all fields are empty the text boxes are bigger than 1 characer long james 2007-12-14 15:46:01 +0000
  • 25c6251c65 Fix dave's typo on inputttype (inputtype) so 'date' fields will work again! james 2007-12-14 15:38:03 +0000
  • 13ef318f27 eliminate an array_keys warning if $$fieldvar isnt set james 2007-12-14 15:28:54 +0000
  • 160acc97d0 Garrrrr, fix syntax error james 2007-12-14 15:25:51 +0000
  • 1dad6505eb - Select the first contact for each sponsor as the primary - Prevent the user from setting zero, or more than one, primary contact. - Add a primary column to the contacts table, so they can see the automatic set/unset operations on the primary contact. dave 2007-12-13 21:50:31 +0000
  • dcfcd358fc - Add a primary contact field to the award contacts - Use the primary contact in award reports dave 2007-12-13 21:23:29 +0000
  • 4c9d23e513 - Add sponsor information to the report generator awards report. - Add a system report that dumps all sponsor info to a csv. dave 2007-12-13 19:56:44 +0000
  • 2da2753758 Make it say "Contact Us" instead of just "Contact" and remove the "you are here" stuff, its not needed here. james 2007-12-13 19:55:57 +0000
  • 00eed557cd Move the contact link out of the centered div, so it looks like the rest of the menu items james 2007-12-13 19:54:19 +0000
  • 6c864d1b93 Bump version for development 2.1.7 Create page text entry for 'invite only' volunteer registration Create a contact page to contact committee members, and link it into the committees page, and the bottom of the left side menu james 2007-12-13 19:52:27 +0000
  • c9fb9f1084 - Fix bug 0000128, the order of the languages in the judging team names dave 2007-12-13 19:21:41 +0000
  • 57f349b1b1 - Add a year field to the users db, we'll need it eventually - Add a designate field to the schools, to indicate an independent, standard, private, etc. school. It's not editable yet, but.. eventually. - Fix generatePassword to use proper string indexing, and remove the possibility of indexing beyond the end of the string. - Add "Invite" and "SinglePassword" modes for volunteer registration. - Update the admin section, add a new volunteers page to contain links to all volunteer options dave 2007-12-13 18:09:22 +0000
  • ab76d8b329 switch the stock entries in the database if anything's usign the old values james 2007-12-13 17:10:11 +0000
  • 89f074052c correct & combine same-size label templates james 2007-12-13 17:03:35 +0000
  • d9135ec036 - Fix label names dave 2007-12-13 16:50:53 +0000
  • 1441f24891 Make province work james 2007-12-12 23:56:33 +0000
  • 998c8b9af5 - Use a list of checkboxes instead of multisel. If the list is large, it puts in in 3 columns under the config option.. if it's small it goes beside it where the config widgets normally go. dave 2007-12-12 23:49:50 +0000
  • 7a7f87f892 Better statistics, less database queries james 2007-12-12 23:35:51 +0000
  • 89675213bf - Make address2 never required, and setup the system so we can easily add more fields that shoudl never be required. I do it this way so I don't have to duplicate the field select array in user.inc.php for the requried fields too. - Swap the City and Address2 locations so that Address1 and Address2 are on top of each other, instead of beside each other. dave 2007-12-12 22:50:54 +0000
  • 5eaf774628 Backport registration list statistics to branch 2.1.x sfiab-2.1 james 2007-12-12 21:17:44 +0000