SDSHOWTO:SDS 0 Series Changelog

SDS 0.C (0.12) release candidate (August 18, 2004)

• Fix extra slashes in paths in list_subjects (pushed)
• Fix reports_data_entry for editing previous years by subject (pushed)
• Key information layout changes
• Fix adding teacher twice in edit_course
• Richard hack to show graduated students in all_course_registrations
• Fix edit_breaks showing breaks from previous years
• Fix formatting of parents_meetings pt page
• Fix some typos and grade autodetection bugs in preregistration
• Clean up page tree and move unused scripts to attic
• Finish documentation
• Do basic code audit as part of documentation project

SDS 0.B (0.11) beta (August 3, 2004)

• deletion of teacher (by setting is_deleted='Y') now permitted
• subject_name added to edit_student_course_registration
• pdf_mark_collection now calculates average mark, increments cut scores of calculated average marks
• pdf_report substitutes subject name and cut-score incremented average marks for rotating courses
• print_marksheet correctly shows all courses for a teacher
• edit_course now saves a block_id of 0 for N/A
• menu will not show all students for writing reports if the block_id of the course = 0
• Fix CSV import
• Change edit_class date box to a date dropdown
• Add teacher course edit page
• Create student SDS
• Fix MOE captions in edit_subject
• Don't show already registered students in student list in edit_course_registrations
• Add capability to edit marks for a whole subject at once
• Fix number of registrations miscounting
• Replace list_courses with an enhanced edit_subject
• Add outstanding registrations in finished courses page
• Display passport academic score out of 100
• Add grant interface to passport summary
• Remove list_courses link from edit_course_registration
• "Set registration date" button in edit_course sets start date enrolment date for students who started after the course started
• Add awards granting, searching, and editing interfaces
• Enhance Student SDS
• Added previous class import
• Made bus request electronic
• Added edit bus request page
• Added bus request summary page
• Made key asterisks into links
• Added key information page
• Added transcripts
• Add documentation engine
• fix calendarmeister not highlighting properly
• fix copy/paste error in edit_address_types and other scripts
• Add NS4 warnings
• 2004 rollover
• Passport to Education fixed
• PT PDF script fixed
• Don't show extra students in reports entry menu
• Show alumni in show_student_info
• Removed advisor classroom field
• Fixed year switching
• Enhanced key data

SDS 0.A (0.10) alpha (June 21, 2004)

• track student post secondary correspondence
• CSV import will deal with blank mark entries
• Calendar features with photos now display properly on the brentwood website
• all_course_registrations will use school marks if final marks don't exist for grade 12 provincially examinable courses
• add passport to education collection pages for academics, fine arts and sports
• add summary page for passport to education information
• edit_student_course_registration and edit_course_registration have fewer bugs
• student_course_registration has a brief/verbose switcher
• reports_data_entry shows courses with block_id 0 now
• edit_assignment_marks and reports_data_entry check validity of marks
• add university, university_action add/edit pages
• Add dollar amount, sortkey to postsec
• sport_term_marks will show marks now, rather than act as a collection sheet
• remove delete report functionality, just clear out the box now

SDS 0.9.1 alpha (June 14, 2004)

• append random number to mark graphs so that browsers do not cache them
• do not show other courses with block_id = 0 or block_2_id = 0 in reports_data_entry
• marks graphing shows the date and time that the graph was rendered
• list_mark_sessions shows mark collections ending on July 31st
• add change password to the parents sds, ldap hooks to the main sds
• fix a bunch of bugs with the resource booking
• fix repeat bookings for resource bookings
• added a page in the main sds to allow parents into the parents sds
• edit_parents now synchronizes parent LDAP data
• students can now see their marks graph on the student SDS
• creating new students (with parents and addresses) is faster now
• improve moe_1701 autofill functionality
• which mark_caption to display on reports is now customizable
• advisors can see mark graphs were data exists
• menu will only show students currently running courses
• reports_data_entry only shows courses currently running

SDS 0.9 alpha (June 7, 2004 to beta only)

• Added email automatically generated message to missing_assignments
• PDF reports now ignore newlines at the end of a comment
• Created parent access site
• Menu supports blank spaces
• Fix printing reports for one class where that class is empty
• Make the includes all fully XHTML compliant (may look worse on NS4)
• SDS looks nice in Opera again
• Teacher dropdowns don't always default to Bruce Tate
• Date dropdown doesn't use month for minutes
• list_classes no longer shows URLs if no URL is set
• Added resource booking (computer labs, projectors)
• daily_attendance shows the correct printable view if you've changed the date
• houseparent page uses usual_first_name if it exists
• add computer/library prep signup/signin/history
• made houseparent a full menu
• houseparent weekend_leaves page shows usual_first_name
• the sds header no longer appears vertically aligned to the top of the page
• courses can now have two blocks assigned to them
• table borders are one pixel wide
• all weekend_leave pages use usual_first_name now, not just the multi-edit one
• tidied up the database for weekend_leaves, eliminated redundant information
• added parent permission field to weekend leave
• added additional destinations for weekend leaves
• added mark graphing support
• broke up palm sync page into sections for quicker loading on pdas

SDS 0.8 alpha (May 27, 2004)

• Add houseparent collection for passport to education
• Add expand/contract all link to menu
• Intranet links now work from off campus
• Uploaded photos for students who started after photo day
• Reports no longer shows cumulative marks if there is only one mark (first term)
• Reports no longer averages in zeroes
• Reports displays two courses with the same name properly
• Reports no longer overlaps text on the first line of the second page if the comment is one line
• Printing class reports no longer aborts if a course with no students is found
• Printing class reports searches for courses with names like the start and end filters
• Add emergency contact info page for palm pilot synchronization

SDS 0.7.3 alpha (May 20, 2004)

• add_to_queue now deletes the files if you delete a print job
• print queue merges jobs if printed to the copy room printer
• list_assignments creates new assignments with the current assignment_mark_type_id
• course_comparison can sort by last name
• year status indicator now a link to reset to current year
• select_student, daily_timetable, weekly_timetable, student_absence now deal with year switching
• added a date pulldown to the student_timetable page
• missing_assignments can now email students who are missing assignments
• add_to_queue remembers what type of report you printed last
• add_to_queue has been reorganized, and has a printer pulldown now

SDS 0.7.2 alpha (May 17, 2004)

• input_absence supports default times for absences - see page for details
• puke email tells me the username who had trouble
• list_courses now shows empty courses
• fix puke in absence_list
• automatically generate cumulative may marks for rotating sets
• list_assignments can now filter by assignment_mark_type
• add student_mark_collections page for advisors - this will show all marks data for a student for a year
• change printer for mark collections
• reports now allow bold, italics, and underlines. Use text, text, and text respectively
• Intensive pages generate as much as an order of magnitude faster due to database upgrade
• The important fields on input_absence should now fit on one page

SDS 0.7.1 alpha (May 13, 2004)

• marks_data_entry doesn't lose marks every time they are submitted (uploaded to production as p1)
• student_course_registration shows dropped records
• added student count to manage_calendar_events, edit_calendar, and print_calendar_event
• reports_data_entry now supports import from and export to CSV
• input_absence orders absence reasons alphabetically
• select_student and show_student_info now show a student's picture if it exists
• edit_student has a picture upload form
• fix missing '-' separator on production site titles
• list_classes now allows sorting by both class number and date

SDS 0.7 alpha (May 11, 2004)

• reports_data_entry now shows the correct internal_comment once the teacher has saved once
• daily_attendance and other scripts now show the comment for absences (eg: health centre affliciton)
• calendar_meister now works again in IE with large forms
• call_pdf no longer outputs an SDS header and footer (sometimes interferes with PDF download)
• edit_student_course_registration now has next and previous buttons
• daily_attendance now reports the correct time for students leaving on absences
• student timetables no longer show courses that have ended
• all_course_registrations allows you to switch grades even from printable view
• reports_entry_spell can now find the student id
• Session timeout now recognized
• puke function emails me if the site is the production version

SDS 0.6.12 alpha (May 7, 2004)

• add_word_to_dictionary allows use of a custom dictionary
• reports_data_entry, pdf_mark_collection identify Key students.
• input_absence correctly allow access to day students only
• add_to_queue now uses new "copies" column in database correctly
• year_switch allows limited viewing of data from previous years
• calendar now displays proper links for next/previous month
• calendar supports repeated events
• calendar shades breaks, uses CSS properly
• daily attendance shows one amalgamated list for all classes taught at the same time
• student_info now checks to see if the student is enroled first. Use the year switcher to view info for alumni.
• edit_classes shows recent classes only by default, also indicates when save has occured
• certain pages now indicate key students with an asterisk
• edit_course_registrations allows reregistration for students who are not currently taking the course
• all_course_registrations allows you to select a mark collection period
• reports_data_entry now works with mark collections that do not have reports
• more scripts now detect auditing and independent students
• updated output_reports to use the proper advisor linking method
• updated output_reports to use only current advisors
• daily_attendance now shows partial absences (along with when students should leave or come back)
• student daily timetable now shows teacher input absence information
• student timetables now handle multiple classes at the same time (rotating sets, sports)
• student timetables no longer show courses that aren't courses (such as head report)
• edit_timetable_blocks has been unbroken

SDS 0.6.11 alpha (March 12, 2004)

• edit_calendar shows students on trip as last_name. first_name
• print_marksheet adapted to show data after course has finished....
• add_to_queue, all_department_registrations altered for course.name LIKE '%Advisor%'
• print_marksheet will print all courses taught by a teacher at a time, or just the particular course called.
• reports_entry_spell passes course_id back to itself, in case session has expired, also returns messages about the saving it has just done.
• pdf_report calculates average marks for rotation subjects (number of rotations >1)
• edit_subject allows editing of number_of_rotations
• course.course_subset field expanded to varchar(20)
• mark_collection_index links to student_subject_marks_reports
• head_of_department page now shows subject and related course links

SDS 0.6.10 alpha (March 4, 2004)

• rel_student_course='Independent' created: numerous pages edited (not tested)
• select_student lists mark_collection_period information in chronological order, also does not link New Student reports except in first year
• edit_student_mcp_data sorts subjects by course_sort_order
• improvements to print_bus_request
• pdf_report now only prints student grade (not subject grade) if the report is printed within the current school year.
• edit_course will only save courses into current_school_year()
• list_courses shows start and end dates, also some columns have sort options
• edit_mark_session now shows maximum_value for mark_caption data
• mark_caption.maximum_value created, edited in edit_mark_session.php, checked against in reports_data_entry and reports_entry_spell
• student_course_registration.php now displays subject.name data
• daily_attendance bug fixed that didn't allow sports attendance for Saturdays to show
• calendar shows breaks
• moe1701_core_french shows students not taking core French for MOE 1701
• students_in_departments.php shows students and their registrations in a particular department
• pdf_report, pdf_marksheet, pdf_midyear_marks now look at course.name for '%Advisor%'
• list_subjects shows SQL ORDER BY clause
• edit_course links back to list_subjects
• absence_list list student by last_name, first_name
• edit_calendar checks student.status before adding a class list, or a trip list
• reports_data_entry now allows multiple courses to be entered at once, for the same teacher in the same timetable block.
• reports_entry_spell - the associated menu lists all students registered with the same teacher at the same time

SDS 0.6.9 alpha (February 1, 2004)

• add_to_queue now deals with student.number_of_report_copies for final copies of reports. Button text changed.
• various changes to pdf_report
• print_draft_report changed so that all reports can be seen.
• list_courses correctly shows courses when all students are listed as complete, also shows that a course is over
• edit_course shows warnings if the start_date or end_date do not fall within the current_school_year()
• new page edit_student_mcp_data allows admin to edit any of the mark data for a student in a year.
• student_week_timetable will show sports if the sport has its timetable block changed to "Sport"
• rel_student_course.status='Audit' created: lots of pages changed (mostly untested) - does not apply to Marks and Reports collections
• email_students aded to menu, improved
• edit_calendar adding class lists glitch fixed, also usual_first_name
• add_to_queue tries to allow printing for any mark_collection_period
• manage_calendar_events allows you to delete Accepted events (it didn't before)
• competitive house added to show_student
• email both parents from show_student
• edit_subject shows start and end dates of associated courses
• new weekend_leaves page allows editing weekend leave for whole house
• daily_attendance shows if course does not run on chosen date, also shows all courses taught by that teacher at that time, and grade of student

SDS 0.6.8 alpha (13 December, 2003)

• course_comparison now generates subset averages
• print_draft_report now limited to current_school_year()
• report_entry_spell now bolds student name, also returns rel_student_course_id to the server on POST in case the session has timed out
• usual_first_name updates for: edit_course_registration
• edit_course_registration now checks for existing registration when adding an existing course list
• pdf_report has been lowered by 12 in Y direction

SDS 0.6.7 alpha (10 December, 2003)

• reports_data_entry looks at student.status='Enrolled' and has a direct link to print_marksheet
• menu now lists course student reports directly, rather than hiding them in an expandable list
• print_marksheet now deals with variable columns correctly, and calculates averages
• new page: student_subject_marks_reports shows all mark collection data for a particular student in a subject.... linked from show student info and student_course_registrations
• edit_assignment_marks shows an average mark for the assignment
• usual_first_name updates for: advisor.php, course_comparison.php
• course_comparison checks for student.status='Enrolled' and rel_student_course='Incomplete'
• Advisor page links to both a PDF report and an HTML data version
• reports_entry_spell formats timestamp information intelligibly
• course_comparison allows subject data export to Excel (as .csv file)

SDS 0.6.6 alpha (30 November, 2003)

• names section of show_student_info fixed.
• usual_first_name updates for: input_absence
• reports_data_entry will now get information from markbook section
• markbook function assignment_marks_student_type now uses rel_student_course_id as an input variable
• list_pt_teachers.php lists all teachers for a PT session, displays their number of appointments and links to a printable list of their appointments

SDS 0.6.5 alpha (18 November, 2003)

• calendar documentation updated
• manange_calendar_events and edit-calendar now link to documentation
• edit_calendar now allows adding any class of students to a calendar item.
• calendar views have been updated to allow "All day", bold and italic to be used in day and week views
• list_classes now lists in descending numerical order
• usual_first_name changes for missing-assignments, edit_assignment_marks
• all_student_marks checks for student.status='Enrolled'

SDS 0.6.4 alpha (4 November, 2003)

• all_course_registrations calculates average marks, efforts and commendations
• print_marksheet now copes with new data structure, also usual_first_name
• usual_first_name updates: daily_attendance, student_option_list()s,
• PT functionality is updated: edit_pt_sessions updated; inserts data into pt_time as required (no deletion), list_pt_ files are updated....
• daily attendance now checks for student.status = 'Enrolled'
• head_of_department page links to mark_collection_index.
• list_parents now displays all parents, not just those which have a spouse listed

SDS 0.6.3 alpha (20 October, 2003)

• absence_list updated for usual_first_name, calendar.status. Day students mode (does not work with changing date)
• edit_course_registration links to output index in order to print a class list
• student_mark_collections page created: like show_student_info but shows mark collection information
• all_course_registrations page created: shows by department or by timetable block, can limit to advisor groups or grade, can show marks and effort values
• edit_calendar enters default dates and times for web feature status: feature_start_time is time() (now!) and feature_end_time is end_time.
• print_bus_request hopefully addresses bug #113 and works properly.
• all_student_marks has a verbose mode to allow you access to marks for students who have left the course. It is also updated for usual_first_name.

SDS 0.6.2 alpha (13 October, 2003)

• reports_administration will create report records for any marks session, then reports_data_entry will take care of the rest.
• advisor.php and select_student both link to pdf version of reports
• pdf_report updated for new student reports
• moe1701 updated for deleted courses
• reports_data_entry will now sort students alphabetically
• add_to_queue checks for to see if the session is for new students only, before adding a batch of reports for an advisor
• weekend_leave now also generates absence record, and will alter that absence record if the weekend_leave data are altered. In addition, I think that the code will generate new weekend_leave records if the previous record for a student has passed, instead of continually modifying the same record.
• edit_assignment_marks now correctly shows the details of an assignment, also warns if mark exceeds maximum mark
• list_assignments now sorts intelligently, and edit_assignments lets you know that you have saved.
• student.legal_given_names is now student.usual_first_name. Edit_student has been modified and list_students shows it in parentheses. student_name() in general_academic_fns will output usual_first_name if it exists. Pages modified: reports_data_entry, reports_entry_spell, menu (re: reports)
• assignment_marks_student_type() now shows maximum mark correctly and does not show % if maximum_mark = 0

SDS 0.6.1 alpha (9 October, 2003)

• edit_mark_session now allows adding and editing of mark_caption data (no delete yet)
• list_assignments now has all and recent ranges
• reports_data_entry will generate report records and mark records for mark collection periods

SDS 0.6 alpha (8 October, 2003)

• edit_student_course_registration will now colour code the table cells
• absent_students list is now available with a house filter if called from the houseparent page
• student marks page now links to individual student pages for their assignment marks
• daily attendance now links to student attendance page
• numerous bug fixes
• calendar improvements... edit calendar will save when add pressed, and add when save pressed
• new student reports print!

SDS 0.5.7 alpha (1 October, 2003)

• Reports will ony show new students if the report session is for new students
• various edits to report entry screen

SDS 0.5.6 alpha (29 September 2003)

• numerous improvements to calendar, including all-day option for events, and fixing multi day events on the weekly calendar
• numerous other fixes
• impovements to attendance functionality

SDS 0.5.5 alpha (19 Sept, 2003)

• Numerous small formatting changes and fixes
• Calendarmeister now links to edit_calendar page

SDS 0.5.4 alpha (9 Sept, 2003)

• SQL bug fix in trip_attendance_block()
• New timetable times
• new block for advisor meetings

SDS 0.5.3 alpha (Sept 8, 2003)

• announcement table added to database
• List and editing pages for handling announcements
• changed display_date_dropdown back to returning a single array - hopefully got all of those pages to work again!
• various bug fixes

SDS 0.52 alpha (Sept 4, 2003)

• minor improvements, bug fixes in claws_rip_hurts
• improvements to php_scripts handling
• etc

SDS 0.51 alpha (released to beta Sept 2, 2003)

• changes made to list_students, edit_student
• can now add a new student
• can create user_names and passwords for NT
• can create batch script for NT user account creation

SDS 0.5 alpha (released Aug. 27, 2003)

• More minor bug fixes
• Upload pictures for calendar items
• Calendar items integrated with front page of new web site

SDS 0.4.4 alpha (released Aug. 22, 2003)

• Various minor bug fixes
• Edit_course, list_courses shows which courses have not been touched this year
• Registration links fixed

SDS 0.4.3 alpha (released Aug. 22, 2003)

• Added a students to check (for a given subject) which students in that grade are not enrolled in it
• Minor changes to edit_course_registration (multiple deletion a little easier)

SDS 0.4.2 alpha (released Aug. 22, 2003)

• Fixed reports_comparison
• Added batch student registration from previous course lists
• Various minor bug fixes
• Updated teacher lists

SDS 0.4.1 alpha (released Aug. 21, 2003)

• Fixed timetable block issues (for the most part)
• Blocks now displayed (usually) by their common names
• Head_of_department page only shows current year's classes

SDS 0.4 alpha (released Aug. 20, 2003)

• Edit_calendar shows if a student has another trip at the same time
• Manage_calendar_events updated to display trip name and destination (oops....)
• Replaced is_enroled with a more descriptive status field
• Changed select_student to allow selection of students from different status types
• Overhauled report_entry_spell code, again....should be working well now
• Changed manage_calendar_event format
• Limited edit/list_courses to current_school_year
• Various minor bug fixes
• Added a page to allow editing of multiple assignments
• Fixed a lot of pages to only show courses for current year
• Course/assignment data carried over from last year
• Fixed some reports_pages: draft_student_report, reports_data_entry (yikes!)
• Updated calendar scripts to handle feature (i.e. front page) information
• Course registration scripts now warn if there are conflicts/students in the wrong grade

SDS 0.3.1 alpha (released Aug. 15, 2003)

• Fixed Mid-year Marks page
• Created more descripitive .htaccess
• Various minor bug fixes
• Added calendar_meister status to edit_calendar
• Fixed last names in advisor page
• Fixed reports_entry_spell.php (almost...)
• Added student_names for report editing to menu
• Added access to report_entry_spell as an advisor from advisor.php
• Added "Save and Next" and "Save and Previous" buttons to report_entry_spell.php

SDS 0.3 alpha (released Aug. 15, 2003)

• Fixed student_name formatting issue in travel_report
• Menu updated to include new scripts, and modified for better grouping of scripts
• Added edit_travel_labels.php
• Added edit_destinations.php
• Added edit_breaks.php
• Minor fixes to output_report.php
• Added automatic generation of bus requests for calendar items
• Added weekend_leave page to housemaster group
• Added weekend_leave summary page to admin for switchboard
• Added printable bus_requests to calendar events
• Added housemaster page to view student information
• Fixed calendar pages
• Fixed attendance pages
• Fixed absence pages
• Fixed class pages
• Fixed assignment, assignment_mark and assignment_mark_type pages
• Added edit_key (SLD) page
• Added moe_language_code editing page
• Added edit_timetable_blocks page
• ADDED MOE 1701 EDITING PAGE............
• Note: At this point the following pages are NOT working (probably):
  • Parent-Teacher scripts
  • Reporting scripts (excl. output_reports, which does work.)
  • Head of Department/Course Comparison
  • Students/Mid-year Marks

SDS 0.2 alpha (released Aug. 8, 2003)

• Travel_status, travel_reports and edit_travel added
• Added is_enroled option to student information
• Non-enroled students are no longer displayed in option lists, etc.
• Fixed duplicate errors for Elliot Wiechula, Rhys Wiechula, Theodore Wittman
• Set graduated students to "not enroled"

SDS 0.1 alpha (released Aug. 6, 2003)

• First new version
• New page schema and layout
• Scripts split into proper directory structure
• Database restructured for efficiency and integrity of data
• Scripts from Old SDS rewritten for new system
• Site made largely XHTML 1.0 Transitional compliant
• Many scripts had many bugs fixed
• Added PDF report cards
• Added many other PDF reports, options, etc
• New print daemon and print_queue handling scheme
• New administration pages for editing titles, parent_student_relationships, etc.
• Note: At this point the only guaranteed working pages are:
  • Admin pages (except parent-teacher pages)
  • Student, address and parent pages
  • Timetables