Draft: Resolve "Software Evaluation Submission"
Closes #296
Changes:
- Add
ReportingPage toEdit Softwarefor software entries that belong to at least one Helmholtz Organisation- show existing evaluations for software in a table
- Button to start a new evaluation with current user as main evaluator
- Add data structure for software evaluations
- Add
software_quality_evaluationtable that saves software id and year (unique) and main evaluator - Add
software_quality_evaluation_statustable that saves submission and lock status with changed_by for evaluation_id- included a
actioncolumn that describes the type of action performed:create | submit | reset submit | lock | unlock
- included a
- Add evaluation_id property to
software_quality_attribute_level_evaluationtable - Update
BEFORE INSERTtrigger forsoftware_quality_attribute_level_evaluationto deny insert if corresponding evaluation is locked - Add
AFTER INSERTtrigger forsoftware_quality_attribute_level_evaluationto reset evaluation submission status tofalseif level evaluation is updated - Add
BEFORE INSERTtrigger forsoftware_quality_evaluation_status:- deny insert if neither
submittednorlockedis set - deny insert for
submittedif evaluation is locked - copy previous value if only one value of
submittedandlockedis set
- deny insert if neither
- Add
AFTER INSERTtrigger forsoftware_quality_evaluationto addcreatelog tosoftware_quality_evaluation_status
- Add
- Add evaluation status tile to software indicator page
- display submission and lock status
- add button to submit evaluation
Edited by Paula Stock