Skip to content

Draft: Resolve "Software Evaluation Submission"

Closes #296

Changes:

  • Add Reporting Page to Edit Software for 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_evaluation table that saves software id and year (unique) and main evaluator
    • Add software_quality_evaluation_status table that saves submission and lock status with changed_by for evaluation_id
      • included a action column that describes the type of action performed: create | submit | reset submit | lock | unlock
    • Add evaluation_id property to software_quality_attribute_level_evaluation table
    • Update BEFORE INSERT trigger for software_quality_attribute_level_evaluation to deny insert if corresponding evaluation is locked
    • Add AFTER INSERT trigger for software_quality_attribute_level_evaluation to reset evaluation submission status to false if level evaluation is updated
    • Add BEFORE INSERT trigger for software_quality_evaluation_status:
      • deny insert if neither submitted nor locked is set
      • deny insert for submitted if evaluation is locked
      • copy previous value if only one value of submitted and locked is set
    • Add AFTER INSERT trigger for software_quality_evaluation to add create log to software_quality_evaluation_status
  • Add evaluation status tile to software indicator page
    • display submission and lock status
    • add button to submit evaluation
Edited by Paula Stock

Merge request reports

Loading