Project Evaluation release

NEW:

• New project evaluation features
• Added export student feedback route
• Added a notice for admins in project evaluation
• Added external markers to login as
• Added AddProjectEvaluationDifferencePercentageToModeTable migration
• Added RemoveSubmittedColumnsFromProjectEvaluations migration
• Added project evaluation date to mode table
• Added col checks
• Added email links to project evaluation page
• Added users without privileges to to log-in as page
• Added Friendly Project Year
• Added print and export to Project Evaluation student feedback
• Added print button to project evaluations
• Added min height to main content

CHANGES:

• Evaluation and feedback reports are now sorted by name
• Cleaned dashboard a little
• Updated toast wording when submitting a PE group
• Updated help pages
• Updated Project Evaluation JS for new features
• Updated supervisor help info to include PE and sections
• Updated error pages to use bootstrap
• Updated parameters fields to use bootstrap
• Updated second marker project headers to match accepted project table
• Updated supervisor arrangements input class

FIXES:

• Fixed some issues with the display of PE values
• Fixed a bug in when updating PE questions
• Fixed a reverse migration
• Fixed bug in student feedback printing
• Fixed a bug which might have reset project loads to 0
• Fixed migration scripts
• Fixed indentation in some files
• Fixed second marker export
• Fixed Student Feedback link for project admins
• Fixed an overflow error in Firefox
• Fixed a bug where an incorrect middleware was being used
• Fixed issue where you couldn't toggle columns in Firefox
• Fixed closing bracket in IE banner
• Fixed bug where second marker export was missing
• Fixed a bug in the search CSS
• And more fixes

SVG:

• Added printer SVG
• Added file export SVG
• Added bullhorn SVG
• Added SVG sizes for Firefox
• Added height to SVG helpers
• Removed SVG animation
• Fixed SVG sizing in project evaluation

OTHER:

• Removed isOnlyStaff
• Removed scaling from PE because it breaks printing
• Changed some wording in PE
• Changed catch all SQL message
• Changed staff where cause to be a like as it is no longer a unique privilege
• Separated first and last names for export
• Project admins can no longer see evaluation data
• Project evaluation export button now includes an icon
• Project evaluation now checks more PEQ Types on submission
• External marker can now see student feedback
• External markers can now select all education levels
• "Logged in as" banner is now always shown
• Fixed sorting for personal projects
• Delete project is no longer shown for accepted projects
• Headings in help view are now shown as sub tabs
• Second marker is now a responsive table
• Log in as screen now scales to more screen sizes
• Disabled PE so we can push a bug fix release

Bug fixes

• Added explanation when a project evaluations can't be finalised
• Added reject count to student proposals table
• Main.js is now called before scripts
• Fixed an exception when viewing a project evaluation for the first time
• Fixed a data access bug when importing students which caused an exception
• Fixed a bug which caused the cookie banner to not hide after pressing close
• Fixed a bug in import students which caused all modal font to be bold
• Fixed a bug which would hide the project report when either proposals or interested students was zero
• Fixed a bug where the supervisor report toggle was overlapping text
• Fixed a bug where the archived projects toggle was overlapping text
• Updated project report tables to be responsive
• Updated accepted students table to be responsive
• Updated some pages to be presented better
• Updated automatic assignment view to display information more clearly
• Removed an unneeded entry from the project model hidden array

Project Evaluation & Bootstrap

General:

• Refreshed design to show information more clearly
• Added universal search on home screen
  • This can search for project and topics
• Added column toggles to the feedback page
• Added Thresholds to parameters page
• Updated update user form to use ID instead of username
  • Previously this would cause an exception if you tried to update a user's username
• Updated the table in the "Manual Second Marker Assignment" view to be sortable
• Updated print CSS
  • Drastically improved printability of pages
• Updated user form to disable incompatible privileges checkboxes
• Updated column toggles to be remembered for the session
  • Now when a user sets which columns they want to see, it will remain after the page is refreshed
• Supervisor filter auto complete now shows/hides supervisors closed to offers depending on the supervisor report dropdown value
  • The "By Supervisor" page always hides supervisors closed to offers
• User feedback page is now paginated
• User agent string page is now paginated
• Moved Mode methods from ProjectAdminController to ModeController
• Renamed several routes (URLs) to be more readable
• Fixed a bug where some middlewares and views allowed a project admin of any level to perform actions
• Fixed a bug where a user could scroll the page when a modal was open
• Moved department/education level selector into the footer

General Boring:

• Updated ColumnToggleTable to longer need a unique ID
• Updated help pages
• Fixed several spelling mistakes
• Disabled the edit button when a topic/programme has been un-edited
• Fixed a bug where when after a topic/programme was edited, the elements original-name data is not updated
• Replaced all "Student load" text with "Project load"
• Moved JS only needed by admins from Main.js to Admin.js
• Numerous reductions in DB calls in several views
• Reduced supervisor email options cooldown for 5 seconds to 2 seconds
• Removed "Rainbow" option from System Dashboard
• Removed intro animation for home page
• Removed animation for project topics
• Removed unused SVG files
• Removed DotMenu
  • Was used for ColumnToggleTable but was a huge amount of JS and has been replaced
• Removed dynamic pagination JS

Student Import:

• Added explanations to the checkboxes in the "Import Students" view
• Added an "Are you sure?" prompt when importing students
• Fixed a bug where every student was being retrieved for the "Import Students" view
  • This view will now only show students from the current education level
• Fixed a bug where students of all educations level were being deleted on import (When "Delete Students" option was selected)

Supervisor Report:

• Changed "Closed to offer" toggle in the Supervisor Report to a dropdown so the selected option is more clear
• The "Closed to offer" is now saved as a cookie so the option remains when a user leaves the page

Navigation:

• Added department to login modal title (e.g Informatics Log-in)
• Updated mobile menu to be more useable
  • Removed the dropdowns and increased margins
• Moved "Amend Supervisor Arrangements" from Users to Settings in Admin navigation
• Fixed a bug where some elements would appear on top of the desktop navigation

Homepage:

• Added the department and education level to help distinguish between them after login
• Added second supervising projects for supervisors
• Users are now welcomed in a random language

End-Of-Year Archive:

• EOYA no longer deletes accepted student-proposed projects
• EOYA no longer deletes student id's from student-proposed projects
• EOYA no longer sets projects view count to zero
• Fixed a bug where students of all education levels were being deleted

Projects:

• Added option to copy an archived project
• Added explanations when a user can't change the status of a project
• Added a limit of 50 results to search
• Updated the string "Project Status" to "Status" on the project edit form to match the new project form
• Updated the "Archived Projects" toggle in My Projects to a dropdown so the selected option is more clear
• Updated the description preview to match the result more closely
• Updated projects table to be sortable
  • Sort preference will persist for session
• The default column sort is now view count, the least popular projects will show first
• Topic column is now hidden when on the "Projects by Topic" page
• Fixed a bug where a supervisor can change a project's status to on-offer after a student has already been accepted
• Fixed a bug where a new project could have the archived status
• Fixed a bug where "by supervisor" was showing supervisors closed to offers
• Removed the option to edit an archived edited
• Removed the option to set a project status to archived on the Edit Project page
• Removed dynamic pagination in favour of traditional pagination

Transactions:
View:

• Added topic column
• Columns are now transaction type dependant
  • e.g The topic transaction view hides the project column by default
• Reduced database calls by 3x

Backend:

• When a project is deleted the Name is stored instead of the ID
• When a topic is deleted the Name is stored instead of the ID
• Added a transaction when a topic is created in a project
  Previously only topics created in the "Topics" page were stored as a transaction
• Added the admin's name to several topic transactions
• Added a transaction when a student 'Un-selects' their selected project (yet to be accepted)
• A student being either accepted or rejected will now be stored as a Student Transaction
  Previously a Project transaction

Project Popularity:

• Removed 3 poplar projects minimum requirement
• Fixed a bug in project popularity where a title excluding any letters would crash the page

Project Evaluation:

• NOTE:
  Project evaluations are encrypted using OpenSSL and the AES-256-CBC cipher.
  Because values must be encrypted/decrypted, accessing and updating project evaluations
  may face a slight performance penalty compared to other pages, however the difference is negligible.
• Added overall project evaluation page
  • A page which shows every student, their grades and more (Available for project admins)
• Added project evaluation page
  • A page which shows a specific projects evaluation (Available for project admins & supervisors)
• Once a project evaluation is finalised, marks and comments are no longer editable
  • Only project admins can un-finalise a project evaluation

Second Marker:

• Fixed a bug in getAcceptedProjectWithoutSecondMarker where the student ID would be selecting instead of the project ID in an SQL join
• Fixed a bug where a supervisor could be assigned as the second marker
• Fixed a bug where the student count was being used instead of accepted project count
• Fixed a spelling mistake (getAccetped -> getAccepted)

DB Changes:

• Added "Project Evaluation" table to the DB
• Added "Thresholds" column to the Mode table
• Added "Copied" transaction type to the Transaction table
• Migrated Marker ID from students table to Project table