/** * Converts <ELEMENT> into <workshopform_numerrors_dimension> and stores it for later writing * * @return array to be written to workshop.xml */ public function process_legacy_element($data, $raw) { $workshop = $this->parenthandler->get_current_workshop(); $mapping = array(); $mapping['id'] = $data['id']; $mapping['nonegative'] = $data['elementno']; if ($workshop['grade'] == 0 or $data['maxscore'] == 0) { $mapping['grade'] = 0; } else { $mapping['grade'] = grade_floatval($data['maxscore'] / $workshop['grade'] * 100); } $this->mappings[] = $mapping; $converted = null; if (trim($data['description']) and $data['description'] <> '@@ GRADE_MAPPING_ELEMENT @@') { // prepare a fake record and re-use the upgrade logic $fakerecord = (object)$data; $converted = (array)workshopform_numerrors_upgrade_element($fakerecord, 12345678); unset($converted['workshopid']); $converted['id'] = $data['id']; $this->dimensions[] = $converted; } return $converted; }
/** * Check if there are some legacy workshop 1.x data to be migrated and upgrade them * * This must be called after workshop core migration has finished so that * all assessments are already upgraded and tables are correctly renamed. */ function workshopform_numerrors_upgrade_legacy() { global $CFG, $DB, $OUTPUT; require_once($CFG->dirroot . '/mod/workshop/db/upgradelib.php'); if (!workshopform_numerrors_upgrade_legacy_needed()) { return; } // get the list of all legacy workshops using this grading strategy if ($legacyworkshops = $DB->get_records('workshop_old', array('gradingstrategy' => 2), 'course,id', 'id')) { echo $OUTPUT->notification('Copying assessment forms elements and grade mappings', 'notifysuccess'); $legacyworkshops = array_keys($legacyworkshops); // get some needed info about the workshops $workshopinfos = $DB->get_records_list('workshop_old', 'id', $legacyworkshops, 'id', 'id,grade'); // get the list of all form elements list($workshopids, $params) = $DB->get_in_or_equal($legacyworkshops, SQL_PARAMS_NAMED); $sql = "SELECT * FROM {workshop_elements_old} WHERE workshopid $workshopids AND newid IS NULL"; $rs = $DB->get_recordset_sql($sql, $params); foreach ($rs as $old) { // process the information about mapping $newmapping = new stdclass(); $newmapping->workshopid = $old->workshopid; $newmapping->nonegative = $old->elementno; $newmapping->grade = $old->maxscore; if ($old->maxscore > 0) { $newmapping->grade = grade_floatval($old->maxscore / $workshopinfos[$old->workshopid]->grade * 100); } else { $newmapping->grade = 0; } $DB->delete_records('workshopform_numerrors_map', array('workshopid' => $newmapping->workshopid, 'nonegative' => $newmapping->nonegative)); $DB->insert_record('workshopform_numerrors_map', $newmapping); // process the information about the element itself if (trim($old->description) and $old->description <> '@@ GRADE_MAPPING_ELEMENT @@') { $new = workshopform_numerrors_upgrade_element($old, $old->workshopid); $newid = $DB->insert_record('workshopform_numerrors', $new); } else { $newid = 0; } $DB->set_field('workshop_elements_old', 'newplugin', 'numerrors', array('id' => $old->id)); $DB->set_field('workshop_elements_old', 'newid', $newid, array('id' => $old->id)); } $rs->close(); // now we need to reload the legacy ids. Although we have them in $newelements after the first run, we must // refetch them from DB so that this function can be called during recovery $newelementids = workshop_upgrade_element_id_mappings('numerrors'); // migrate all grades for these elements (it est the values that reviewers put into forms) echo $OUTPUT->notification('Copying assessment form grades', 'notifysuccess'); $sql = "SELECT * FROM {workshop_grades_old} WHERE workshopid $workshopids AND newid IS NULL"; $rs = $DB->get_recordset_sql($sql, $params); $newassessmentids = workshop_upgrade_assessment_id_mappings(); foreach ($rs as $old) { if (!isset($newassessmentids[$old->assessmentid])) { // orphaned grade - the assessment was removed but the grade remained continue; } if (!isset($newelementids[$old->workshopid]) or !isset($newelementids[$old->workshopid][$old->elementno])) { // orphaned grade - the assessment form element has been removed after the grade was recorded continue; } $newelementinfo = $newelementids[$old->workshopid][$old->elementno]; if ($newelementinfo->newid == 0 or $old->feedback == '@@ GRADE_ADJUSTMENT @@') { // this is not a real grade - it was used just for mapping purposes $DB->set_field('workshop_grades_old', 'newplugin', 'numerrors_map', array('id' => $old->id)); $DB->set_field('workshop_grades_old', 'newid', 0, array('id' => $old->id)); continue; } $new = workshopform_numerrors_upgrade_grade($old, $newassessmentids[$old->assessmentid], $newelementids[$old->workshopid][$old->elementno]); $newid = $DB->insert_record('workshop_grades', $new); $DB->set_field('workshop_grades_old', 'newplugin', 'numerrors', array('id' => $old->id)); $DB->set_field('workshop_grades_old', 'newid', $newid, array('id' => $old->id)); } $rs->close(); } }