MDL-36914: Re-associate all grade_item records when upgrading assignments to prevent...
[moodle.git] / mod / assign / upgradelib.php
CommitLineData
bbd0e548
DW
1<?php
2// This file is part of Moodle - http://moodle.org/
3//
4// Moodle is free software: you can redistribute it and/or modify
5// it under the terms of the GNU General Public License as published by
6// the Free Software Foundation, either version 3 of the License, or
7// (at your option) any later version.
8//
9// Moodle is distributed in the hope that it will be useful,
10// but WITHOUT ANY WARRANTY; without even the implied warranty of
11// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12// GNU General Public License for more details.
13//
14// You should have received a copy of the GNU General Public License
15// along with Moodle. If not, see <http://www.gnu.org/licenses/>.
16
17/**
18 * This file contains the upgrade code to upgrade from mod_assignment to mod_assign
19 *
20 * @package mod_assign
21 * @copyright 2012 NetSpot {@link http://www.netspot.com.au}
22 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
23 */
24
25defined('MOODLE_INTERNAL') || die();
26
27/** Include locallib.php */
28require_once($CFG->dirroot.'/mod/assign/locallib.php');
29/** Include accesslib.php */
30require_once($CFG->libdir.'/accesslib.php');
31
5b121144
DW
32/**
33 * The maximum amount of time to spend upgrading a single assignment.
34 * This is intentionally generous (5 mins) as the effect of a timeout
35 * for a legitimate upgrade would be quite harsh (roll back code will not run)
36 */
37define('ASSIGN_MAX_UPGRADE_TIME_SECS', 300);
bbd0e548
DW
38
39/**
40 * Class to manage upgrades from mod_assignment to mod_assign
41 *
42 * @package mod_assign
43 * @copyright 2012 NetSpot {@link http://www.netspot.com.au}
44 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
45 */
46class assign_upgrade_manager {
47
48 /**
49 * This function converts all of the base settings for an instance of
50 * the old assignment to the new format. Then it calls each of the plugins
51 * to see if they can help upgrade this assignment.
52 * @param int $oldassignmentid (don't rely on the old assignment type even being installed)
53 * @param string $log This string gets appended to during the conversion process
54 * @return bool true or false
55 */
56 public function upgrade_assignment($oldassignmentid, & $log) {
bbd0e548 57 // steps to upgrade an assignment
bbd0e548
DW
58 global $DB, $CFG, $USER;
59 // steps to upgrade an assignment
60
61 // is the user the admin? admin check goes here
62 if (!is_siteadmin($USER->id)) {
63 return false;
64 }
65
5b121144
DW
66 // should we use a shutdown handler to rollback on timeout?
67 @set_time_limit(ASSIGN_MAX_UPGRADE_TIME_SECS);
68
bbd0e548
DW
69
70 // get the module details
71 $oldmodule = $DB->get_record('modules', array('name'=>'assignment'), '*', MUST_EXIST);
72 $oldcoursemodule = $DB->get_record('course_modules', array('module'=>$oldmodule->id, 'instance'=>$oldassignmentid), '*', MUST_EXIST);
73 $oldcontext = context_module::instance($oldcoursemodule->id);
74
75 // first insert an assign instance to get the id
76 $oldassignment = $DB->get_record('assignment', array('id'=>$oldassignmentid), '*', MUST_EXIST);
77
78 $oldversion = get_config('assignment_' . $oldassignment->assignmenttype, 'version');
79
80 $data = new stdClass();
81 $data->course = $oldassignment->course;
82 $data->name = $oldassignment->name;
83 $data->intro = $oldassignment->intro;
84 $data->introformat = $oldassignment->introformat;
85 $data->alwaysshowdescription = 1;
86 $data->sendnotifications = $oldassignment->emailteachers;
56ff1300 87 $data->sendlatenotifications = $oldassignment->emailteachers;
bbd0e548
DW
88 $data->duedate = $oldassignment->timedue;
89 $data->allowsubmissionsfromdate = $oldassignment->timeavailable;
90 $data->grade = $oldassignment->grade;
91 $data->submissiondrafts = $oldassignment->resubmit;
94f26900 92 $data->requiresubmissionstatement = 0;
9e795179
DW
93 $data->cutoffdate = 0;
94 // New way to specify no late submissions.
95 if ($oldassignment->preventlate) {
96 $data->cutoffdate = $data->duedate;
97 }
7c7bc2ee
DW
98 $data->teamsubmission = 0;
99 $data->requireallteammemberssubmit = 0;
100 $data->teamsubmissiongroupingid = 0;
101 $data->blindmarking = 0;
bbd0e548
DW
102
103 $newassignment = new assign(null, null, null);
104
105 if (!$newassignment->add_instance($data, false)) {
106 $log = get_string('couldnotcreatenewassignmentinstance', 'mod_assign');
107 return false;
108 }
109
110 // now create a new coursemodule from the old one
111 $newmodule = $DB->get_record('modules', array('name'=>'assign'), '*', MUST_EXIST);
112 $newcoursemodule = $this->duplicate_course_module($oldcoursemodule, $newmodule->id, $newassignment->get_instance()->id);
113 if (!$newcoursemodule) {
114 $log = get_string('couldnotcreatenewcoursemodule', 'mod_assign');
115 return false;
116 }
117
118 // convert the base database tables (assignment, submission, grade)
119
120 // these are used to store information in case a rollback is required
121 $gradingarea = null;
122 $gradingdefinitions = null;
123 $gradeidmap = array();
124 $completiondone = false;
c45261df 125 $gradesdone = false;
bbd0e548
DW
126
127 // from this point we want to rollback on failure
128 $rollback = false;
129 try {
130 $newassignment->set_context(context_module::instance($newcoursemodule->id));
131
132 // the course module has now been created - time to update the core tables
133
134 // copy intro files
135 $newassignment->copy_area_files_for_upgrade($oldcontext->id, 'mod_assignment', 'intro', 0,
136 $newassignment->get_context()->id, 'mod_assign', 'intro', 0);
137
138
139 // get the plugins to do their bit
140 foreach ($newassignment->get_submission_plugins() as $plugin) {
141 if ($plugin->can_upgrade($oldassignment->assignmenttype, $oldversion)) {
142 $plugin->enable();
143 if (!$plugin->upgrade_settings($oldcontext, $oldassignment, $log)) {
144 $rollback = true;
145 }
146 }
147 }
148 foreach ($newassignment->get_feedback_plugins() as $plugin) {
149 if ($plugin->can_upgrade($oldassignment->assignmenttype, $oldversion)) {
150 $plugin->enable();
151 if (!$plugin->upgrade_settings($oldcontext, $oldassignment, $log)) {
152 $rollback = true;
153 }
154 }
155 }
156
157 // see if there is advanced grading upgrades required
158 $gradingarea = $DB->get_record('grading_areas', array('contextid'=>$oldcontext->id, 'areaname'=>'submission'), '*', IGNORE_MISSING);
159 if ($gradingarea) {
160 $DB->update_record('grading_areas', array('id'=>$gradingarea->id, 'contextid'=>$newassignment->get_context()->id, 'component'=>'mod_assign', 'areaname'=>'submissions'));
161 $gradingdefinitions = $DB->get_records('grading_definitions', array('areaid'=>$gradingarea->id));
162 }
163
164 // upgrade completion data
165 $DB->set_field('course_modules_completion', 'coursemoduleid', $newcoursemodule->id, array('coursemoduleid'=>$oldcoursemodule->id));
1f417de8
DW
166 $allcriteria = $DB->get_records('course_completion_criteria', array('moduleinstance'=>$oldcoursemodule->id));
167 foreach ($allcriteria as $criteria) {
168 $criteria->module = 'assign';
169 $criteria->moduleinstance = $newcoursemodule->id;
170 $DB->update_record('course_completion_criteria', $criteria);
171 }
bbd0e548
DW
172 $completiondone = true;
173
ac9ac1fe
AO
174 // Migrate log entries so we don't lose them.
175 $logparams = array('cmid' => $oldcoursemodule->id, 'course' => $oldcoursemodule->course);
176 $DB->set_field('log', 'module', 'assign', $logparams);
177 $DB->set_field('log', 'cmid', $newcoursemodule->id, $logparams);
178
bbd0e548
DW
179
180 // copy all the submission data (and get plugins to do their bit)
181 $oldsubmissions = $DB->get_records('assignment_submissions', array('assignment'=>$oldassignmentid));
182
183 foreach ($oldsubmissions as $oldsubmission) {
184 $submission = new stdClass();
185 $submission->assignment = $newassignment->get_instance()->id;
186 $submission->userid = $oldsubmission->userid;
187 $submission->timecreated = $oldsubmission->timecreated;
188 $submission->timemodified = $oldsubmission->timemodified;
189 $submission->status = ASSIGN_SUBMISSION_STATUS_SUBMITTED;
190 $submission->id = $DB->insert_record('assign_submission', $submission);
191 if (!$submission->id) {
192 $log .= get_string('couldnotinsertsubmission', 'mod_assign', $submission->userid);
193 $rollback = true;
194 }
195 foreach ($newassignment->get_submission_plugins() as $plugin) {
196 if ($plugin->can_upgrade($oldassignment->assignmenttype, $oldversion)) {
197 if (!$plugin->upgrade($oldcontext, $oldassignment, $oldsubmission, $submission, $log)) {
198 $rollback = true;
199 }
200 }
201 }
202 if ($oldsubmission->timemarked) {
203 // submission has been graded - create a grade record
204 $grade = new stdClass();
205 $grade->assignment = $newassignment->get_instance()->id;
206 $grade->userid = $oldsubmission->userid;
207 $grade->grader = $oldsubmission->teacher;
208 $grade->timemodified = $oldsubmission->timemarked;
209 $grade->timecreated = $oldsubmission->timecreated;
210 // $grade->locked = $oldsubmission->locked;
211 $grade->grade = $oldsubmission->grade;
212 $grade->mailed = $oldsubmission->mailed;
213 $grade->id = $DB->insert_record('assign_grades', $grade);
214 if (!$grade->id) {
215 $log .= get_string('couldnotinsertgrade', 'mod_assign', $grade->userid);
216 $rollback = true;
217 }
218
219 // copy any grading instances
220 if ($gradingarea) {
221
222 $gradeidmap[$grade->id] = $oldsubmission->id;
223
224 foreach ($gradingdefinitions as $definition) {
225 $DB->set_field('grading_instances', 'itemid', $grade->id, array('definitionid'=>$definition->id, 'itemid'=>$oldsubmission->id));
226 }
227
228 }
229 foreach ($newassignment->get_feedback_plugins() as $plugin) {
230 if ($plugin->can_upgrade($oldassignment->assignmenttype, $oldversion)) {
231 if (!$plugin->upgrade($oldcontext, $oldassignment, $oldsubmission, $grade, $log)) {
232 $rollback = true;
233 }
234 }
235 }
236 }
237 }
238
239 $newassignment->update_calendar($newcoursemodule->id);
bbd0e548 240
8131a848
NM
241 // reassociate grade_items from the old assignment instance to the new assign instance. This includes outcome linked grade_items
242 $sql = "UPDATE {grade_items} SET itemmodule = 'assign', iteminstance = ? WHERE itemmodule = 'assignment' AND iteminstance = ?";
243 $DB->execute($sql, array($newassignment->get_instance()->id, $oldassignment->id));
1f417de8 244
c45261df 245 $gradesdone = true;
bbd0e548
DW
246
247 } catch (Exception $exception) {
248 $rollback = true;
5b121144 249 $log .= get_string('conversionexception', 'mod_assign', $exception->error);
bbd0e548
DW
250 }
251
252 if ($rollback) {
c45261df
DW
253 // roll back the grades changes
254 if ($gradesdone) {
8131a848
NM
255 // reassociate grade_items from the new assign instance to the old assignment instance
256 $sql = "UPDATE {grade_items} SET itemmodule = 'assign', iteminstance = ? WHERE itemmodule = 'assignment' AND iteminstance = ?";
257 $DB->execute($sql, array($oldassignment->id, $newassignment->get_instance()->id));
c45261df 258 }
bbd0e548
DW
259 // roll back the completion changes
260 if ($completiondone) {
261 $DB->set_field('course_modules_completion', 'coursemoduleid', $oldcoursemodule->id, array('coursemoduleid'=>$newcoursemodule->id));
1f417de8
DW
262 $allcriteria = $DB->get_records('course_completion_criteria', array('moduleinstance'=>$newcoursemodule->id));
263 foreach ($allcriteria as $criteria) {
264 $criteria->module = 'assignment';
265 $criteria->moduleinstance = $oldcoursemodule->id;
266 $DB->update_record('course_completion_criteria', $criteria);
267 }
bbd0e548 268 }
ac9ac1fe
AO
269 // Roll back the log changes
270 $logparams = array('cmid' => $newcoursemodule->id, 'course' => $newcoursemodule->course);
271 $DB->set_field('log', 'module', 'assignment', $logparams);
272 $DB->set_field('log', 'cmid', $oldcoursemodule->id, $logparams);
bbd0e548
DW
273 // roll back the advanced grading update
274 if ($gradingarea) {
275 foreach ($gradeidmap as $newgradeid => $oldsubmissionid) {
276 foreach ($gradingdefinitions as $definition) {
277 $DB->set_field('grading_instances', 'itemid', $oldsubmissionid, array('definitionid'=>$definition->id, 'itemid'=>$newgradeid));
278 }
279 }
280 $DB->update_record('grading_areas', array('id'=>$gradingarea->id, 'contextid'=>$oldcontext->id, 'component'=>'mod_assignment', 'areaname'=>'submission'));
281 }
282 $newassignment->delete_instance();
283
284 return false;
285 }
286 // all is well,
287 // delete the old assignment (use object delete)
288 $cm = get_coursemodule_from_id('', $oldcoursemodule->id, $oldcoursemodule->course);
289 if ($cm) {
290 $this->delete_course_module($cm);
291 }
292 rebuild_course_cache($oldcoursemodule->course);
293 return true;
294 }
295
296
297 /**
298 * Create a duplicate course module record so we can create the upgraded
299 * assign module alongside the old assignment module.
300 *
301 * @param stdClass $cm The old course module record
302 * @param int $moduleid The id of the new assign module
303 * @param int $newinstanceid The id of the new instance of the assign module
304 * @return mixed stdClass|bool The new course module record or FALSE
305 */
306 private function duplicate_course_module(stdClass $cm, $moduleid, $newinstanceid) {
307 global $DB, $CFG;
308
309 $newcm = new stdClass();
310 $newcm->course = $cm->course;
311 $newcm->module = $moduleid;
312 $newcm->instance = $newinstanceid;
313 $newcm->visible = $cm->visible;
314 $newcm->section = $cm->section;
315 $newcm->score = $cm->score;
316 $newcm->indent = $cm->indent;
317 $newcm->groupmode = $cm->groupmode;
318 $newcm->groupingid = $cm->groupingid;
319 $newcm->groupmembersonly = $cm->groupmembersonly;
320 $newcm->completion = $cm->completion;
321 $newcm->completiongradeitemnumber = $cm->completiongradeitemnumber;
322 $newcm->completionview = $cm->completionview;
323 $newcm->completionexpected = $cm->completionexpected;
324 if(!empty($CFG->enableavailability)) {
325 $newcm->availablefrom = $cm->availablefrom;
326 $newcm->availableuntil = $cm->availableuntil;
327 $newcm->showavailability = $cm->showavailability;
328 }
329 $newcm->showdescription = $cm->showdescription;
330
331 $newcmid = add_course_module($newcm);
332 $newcm = get_coursemodule_from_id('', $newcmid, $cm->course);
333 if (!$newcm) {
334 return false;
335 }
336 $section = $DB->get_record("course_sections", array("id"=>$newcm->section));
337 if (!$section) {
338 return false;
339 }
340
722e6ba9 341 $newcm->section = course_add_cm_to_section($newcm->course, $newcm->id, $section->section);
bbd0e548
DW
342
343 // make sure visibility is set correctly (in particular in calendar)
344 // note: allow them to set it even without moodle/course:activityvisibility
345 set_coursemodule_visible($newcm->id, $newcm->visible);
346
347 return $newcm;
348 }
349
350 /**
351 * This function deletes the old assignment course module after
352 * it has been upgraded. This code is adapted from "course/mod.php".
353 *
354 * @param stdClass $cm The course module to delete.
355 * @return bool
356 */
357 private function delete_course_module($cm) {
358 global $CFG, $USER, $DB, $OUTPUT;
359 $course = $DB->get_record('course', array('id' => $cm->course), '*', MUST_EXIST);
360
361 $coursecontext = context_course::instance($course->id);
362 $modcontext = context_module::instance($cm->id);
363
364 $modlib = "$CFG->dirroot/mod/$cm->modname/lib.php";
365
366 if (file_exists($modlib)) {
367 require_once($modlib);
368 } else {
369 print_error('modulemissingcode', '', '', $modlib);
370 }
371
372 $deleteinstancefunction = $cm->modname."_delete_instance";
373
374 if (!$deleteinstancefunction($cm->instance)) {
375 echo $OUTPUT->notification("Could not delete the $cm->modname (instance)");
376 }
377
378 // remove all module files in case modules forget to do that
379 $fs = get_file_storage();
380 $fs->delete_area_files($modcontext->id);
381
382 if (!delete_course_module($cm->id)) {
383 echo $OUTPUT->notification("Could not delete the $cm->modname (coursemodule)");
384 }
385 if (!delete_mod_from_section($cm->id, $cm->section)) {
386 echo $OUTPUT->notification("Could not delete the $cm->modname from that section");
387 }
388
389 // Trigger a mod_deleted event with information about this module.
390 $eventdata = new stdClass();
391 $eventdata->modulename = $cm->modname;
392 $eventdata->cmid = $cm->id;
393 $eventdata->courseid = $course->id;
394 $eventdata->userid = $USER->id;
395 events_trigger('mod_deleted', $eventdata);
396
397 add_to_log($course->id, 'course', "delete mod",
398 "view.php?id=$cm->course",
399 "$cm->modname $cm->instance", $cm->id);
400
401 return true;
402 }
403
bbd0e548 404}