2 // This file is part of Moodle - http://moodle.org/
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.
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.
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/>.
18 * This file contains the upgrade code to upgrade from mod_assignment to 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
25 defined('MOODLE_INTERNAL') || die();
27 /** Include locallib.php */
28 require_once($CFG->dirroot.'/mod/assign/locallib.php');
29 /** Include accesslib.php */
30 require_once($CFG->libdir.'/accesslib.php');
34 * Class to manage upgrades from mod_assignment to mod_assign
37 * @copyright 2012 NetSpot {@link http://www.netspot.com.au}
38 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
40 class assign_upgrade_manager {
43 * This function converts all of the base settings for an instance of
44 * the old assignment to the new format. Then it calls each of the plugins
45 * to see if they can help upgrade this assignment.
46 * @param int $oldassignmentid (don't rely on the old assignment type even being installed)
47 * @param string $log This string gets appended to during the conversion process
48 * @return bool true or false
50 public function upgrade_assignment($oldassignmentid, & $log) {
52 // steps to upgrade an assignment
54 global $DB, $CFG, $USER;
55 // steps to upgrade an assignment
57 // is the user the admin? admin check goes here
58 if (!is_siteadmin($USER->id)) {
63 // get the module details
64 $oldmodule = $DB->get_record('modules', array('name'=>'assignment'), '*', MUST_EXIST);
65 $oldcoursemodule = $DB->get_record('course_modules', array('module'=>$oldmodule->id, 'instance'=>$oldassignmentid), '*', MUST_EXIST);
66 $oldcontext = context_module::instance($oldcoursemodule->id);
68 // first insert an assign instance to get the id
69 $oldassignment = $DB->get_record('assignment', array('id'=>$oldassignmentid), '*', MUST_EXIST);
71 $oldversion = get_config('assignment_' . $oldassignment->assignmenttype, 'version');
73 $data = new stdClass();
74 $data->course = $oldassignment->course;
75 $data->name = $oldassignment->name;
76 $data->intro = $oldassignment->intro;
77 $data->introformat = $oldassignment->introformat;
78 $data->alwaysshowdescription = 1;
79 $data->sendnotifications = $oldassignment->emailteachers;
80 $data->duedate = $oldassignment->timedue;
81 $data->allowsubmissionsfromdate = $oldassignment->timeavailable;
82 $data->grade = $oldassignment->grade;
83 $data->submissiondrafts = $oldassignment->resubmit;
84 $data->preventlatesubmissions = $oldassignment->preventlate;
86 $newassignment = new assign(null, null, null);
88 if (!$newassignment->add_instance($data, false)) {
89 $log = get_string('couldnotcreatenewassignmentinstance', 'mod_assign');
93 // now create a new coursemodule from the old one
94 $newmodule = $DB->get_record('modules', array('name'=>'assign'), '*', MUST_EXIST);
95 $newcoursemodule = $this->duplicate_course_module($oldcoursemodule, $newmodule->id, $newassignment->get_instance()->id);
96 if (!$newcoursemodule) {
97 $log = get_string('couldnotcreatenewcoursemodule', 'mod_assign');
101 // convert the base database tables (assignment, submission, grade)
103 // these are used to store information in case a rollback is required
105 $gradingdefinitions = null;
106 $gradeidmap = array();
107 $completiondone = false;
109 // from this point we want to rollback on failure
112 $newassignment->set_context(context_module::instance($newcoursemodule->id));
114 // the course module has now been created - time to update the core tables
117 $newassignment->copy_area_files_for_upgrade($oldcontext->id, 'mod_assignment', 'intro', 0,
118 $newassignment->get_context()->id, 'mod_assign', 'intro', 0);
121 // get the plugins to do their bit
122 foreach ($newassignment->get_submission_plugins() as $plugin) {
123 if ($plugin->can_upgrade($oldassignment->assignmenttype, $oldversion)) {
125 if (!$plugin->upgrade_settings($oldcontext, $oldassignment, $log)) {
130 foreach ($newassignment->get_feedback_plugins() as $plugin) {
131 if ($plugin->can_upgrade($oldassignment->assignmenttype, $oldversion)) {
133 if (!$plugin->upgrade_settings($oldcontext, $oldassignment, $log)) {
139 // see if there is advanced grading upgrades required
140 $gradingarea = $DB->get_record('grading_areas', array('contextid'=>$oldcontext->id, 'areaname'=>'submission'), '*', IGNORE_MISSING);
142 $DB->update_record('grading_areas', array('id'=>$gradingarea->id, 'contextid'=>$newassignment->get_context()->id, 'component'=>'mod_assign', 'areaname'=>'submissions'));
143 $gradingdefinitions = $DB->get_records('grading_definitions', array('areaid'=>$gradingarea->id));
146 // upgrade completion data
147 $DB->set_field('course_modules_completion', 'coursemoduleid', $newcoursemodule->id, array('coursemoduleid'=>$oldcoursemodule->id));
148 $DB->set_field('course_completion_criteria', 'module', 'assign', array('moduleinstance'=>$oldcoursemodule->id));
149 $DB->set_field('course_completion_criteria', 'moduleinstance', $newcoursemodule->id, array('moduleinstance'=>$oldcoursemodule->id));
150 $completiondone = true;
153 // copy all the submission data (and get plugins to do their bit)
154 $oldsubmissions = $DB->get_records('assignment_submissions', array('assignment'=>$oldassignmentid));
156 foreach ($oldsubmissions as $oldsubmission) {
157 $submission = new stdClass();
158 $submission->assignment = $newassignment->get_instance()->id;
159 $submission->userid = $oldsubmission->userid;
160 $submission->timecreated = $oldsubmission->timecreated;
161 $submission->timemodified = $oldsubmission->timemodified;
162 $submission->status = ASSIGN_SUBMISSION_STATUS_SUBMITTED;
163 $submission->id = $DB->insert_record('assign_submission', $submission);
164 if (!$submission->id) {
165 $log .= get_string('couldnotinsertsubmission', 'mod_assign', $submission->userid);
168 foreach ($newassignment->get_submission_plugins() as $plugin) {
169 if ($plugin->can_upgrade($oldassignment->assignmenttype, $oldversion)) {
170 if (!$plugin->upgrade($oldcontext, $oldassignment, $oldsubmission, $submission, $log)) {
175 if ($oldsubmission->timemarked) {
176 // submission has been graded - create a grade record
177 $grade = new stdClass();
178 $grade->assignment = $newassignment->get_instance()->id;
179 $grade->userid = $oldsubmission->userid;
180 $grade->grader = $oldsubmission->teacher;
181 $grade->timemodified = $oldsubmission->timemarked;
182 $grade->timecreated = $oldsubmission->timecreated;
183 // $grade->locked = $oldsubmission->locked;
184 $grade->grade = $oldsubmission->grade;
185 $grade->mailed = $oldsubmission->mailed;
186 $grade->id = $DB->insert_record('assign_grades', $grade);
188 $log .= get_string('couldnotinsertgrade', 'mod_assign', $grade->userid);
192 // copy any grading instances
195 $gradeidmap[$grade->id] = $oldsubmission->id;
197 foreach ($gradingdefinitions as $definition) {
198 $DB->set_field('grading_instances', 'itemid', $grade->id, array('definitionid'=>$definition->id, 'itemid'=>$oldsubmission->id));
202 foreach ($newassignment->get_feedback_plugins() as $plugin) {
203 if ($plugin->can_upgrade($oldassignment->assignmenttype, $oldversion)) {
204 if (!$plugin->upgrade($oldcontext, $oldassignment, $oldsubmission, $grade, $log)) {
212 $newassignment->update_calendar($newcoursemodule->id);
213 $newassignment->update_gradebook(false,$newcoursemodule->id);
215 // copy the grades from the old assignment to the new one
216 $this->copy_grades_for_upgrade($oldassignment, $newassignment);
218 } catch (Exception $exception) {
220 $log .= get_string('conversionexception', 'mod_assign', $exception->getMessage());
224 // roll back the completion changes
225 if ($completiondone) {
226 $DB->set_field('course_modules_completion', 'coursemoduleid', $oldcoursemodule->id, array('coursemoduleid'=>$newcoursemodule->id));
227 $DB->set_field('course_completion_criteria', 'module', 'assignment', array('moduleinstance'=>$newcoursemodule->id));
228 $DB->set_field('course_completion_criteria', 'moduleinstance', $oldcoursemodule->id, array('moduleinstance'=>$newcoursemodule->id));
230 // roll back the advanced grading update
232 foreach ($gradeidmap as $newgradeid => $oldsubmissionid) {
233 foreach ($gradingdefinitions as $definition) {
234 $DB->set_field('grading_instances', 'itemid', $oldsubmissionid, array('definitionid'=>$definition->id, 'itemid'=>$newgradeid));
237 $DB->update_record('grading_areas', array('id'=>$gradingarea->id, 'contextid'=>$oldcontext->id, 'component'=>'mod_assignment', 'areaname'=>'submission'));
239 $newassignment->delete_instance();
244 // delete the old assignment (use object delete)
245 $cm = get_coursemodule_from_id('', $oldcoursemodule->id, $oldcoursemodule->course);
247 $this->delete_course_module($cm);
249 rebuild_course_cache($oldcoursemodule->course);
255 * Create a duplicate course module record so we can create the upgraded
256 * assign module alongside the old assignment module.
258 * @param stdClass $cm The old course module record
259 * @param int $moduleid The id of the new assign module
260 * @param int $newinstanceid The id of the new instance of the assign module
261 * @return mixed stdClass|bool The new course module record or FALSE
263 private function duplicate_course_module(stdClass $cm, $moduleid, $newinstanceid) {
266 $newcm = new stdClass();
267 $newcm->course = $cm->course;
268 $newcm->module = $moduleid;
269 $newcm->instance = $newinstanceid;
270 $newcm->visible = $cm->visible;
271 $newcm->section = $cm->section;
272 $newcm->score = $cm->score;
273 $newcm->indent = $cm->indent;
274 $newcm->groupmode = $cm->groupmode;
275 $newcm->groupingid = $cm->groupingid;
276 $newcm->groupmembersonly = $cm->groupmembersonly;
277 $newcm->completion = $cm->completion;
278 $newcm->completiongradeitemnumber = $cm->completiongradeitemnumber;
279 $newcm->completionview = $cm->completionview;
280 $newcm->completionexpected = $cm->completionexpected;
281 if(!empty($CFG->enableavailability)) {
282 $newcm->availablefrom = $cm->availablefrom;
283 $newcm->availableuntil = $cm->availableuntil;
284 $newcm->showavailability = $cm->showavailability;
286 $newcm->showdescription = $cm->showdescription;
288 $newcmid = add_course_module($newcm);
289 $newcm = get_coursemodule_from_id('', $newcmid, $cm->course);
293 $section = $DB->get_record("course_sections", array("id"=>$newcm->section));
298 $mod = new stdClass();
299 $mod->course = $newcm->course;
300 $mod->section = $section->section;
301 $mod->coursemodule = $newcm->id;
302 $mod->id = $newcm->id;
303 $newcm->section = add_mod_to_section($mod, $cm);
305 // make sure visibility is set correctly (in particular in calendar)
306 // note: allow them to set it even without moodle/course:activityvisibility
307 set_coursemodule_visible($newcm->id, $newcm->visible);
313 * This function deletes the old assignment course module after
314 * it has been upgraded. This code is adapted from "course/mod.php".
316 * @param stdClass $cm The course module to delete.
319 private function delete_course_module($cm) {
320 global $CFG, $USER, $DB, $OUTPUT;
321 $course = $DB->get_record('course', array('id' => $cm->course), '*', MUST_EXIST);
323 $coursecontext = context_course::instance($course->id);
324 $modcontext = context_module::instance($cm->id);
326 $modlib = "$CFG->dirroot/mod/$cm->modname/lib.php";
328 if (file_exists($modlib)) {
329 require_once($modlib);
331 print_error('modulemissingcode', '', '', $modlib);
334 $deleteinstancefunction = $cm->modname."_delete_instance";
336 if (!$deleteinstancefunction($cm->instance)) {
337 echo $OUTPUT->notification("Could not delete the $cm->modname (instance)");
340 // remove all module files in case modules forget to do that
341 $fs = get_file_storage();
342 $fs->delete_area_files($modcontext->id);
344 if (!delete_course_module($cm->id)) {
345 echo $OUTPUT->notification("Could not delete the $cm->modname (coursemodule)");
347 if (!delete_mod_from_section($cm->id, $cm->section)) {
348 echo $OUTPUT->notification("Could not delete the $cm->modname from that section");
351 // Trigger a mod_deleted event with information about this module.
352 $eventdata = new stdClass();
353 $eventdata->modulename = $cm->modname;
354 $eventdata->cmid = $cm->id;
355 $eventdata->courseid = $course->id;
356 $eventdata->userid = $USER->id;
357 events_trigger('mod_deleted', $eventdata);
359 add_to_log($course->id, 'course', "delete mod",
360 "view.php?id=$cm->course",
361 "$cm->modname $cm->instance", $cm->id);
367 * This function copies the grades from the old assignment module to this one.
369 * @param stdClass $oldassignment old assignment data record
370 * @param assign $newassignment the new assign class
371 * @return bool true or false
373 public function copy_grades_for_upgrade($oldassignment, $newassignment) {
376 require_once($CFG->libdir.'/gradelib.php');
378 // get the old and new grade items
379 $oldgradeitems = grade_item::fetch_all(array('itemtype'=>'mod', 'itemmodule'=>'assignment', 'iteminstance'=>$oldassignment->id));
380 if (!$oldgradeitems) {
383 $oldgradeitem = array_pop($oldgradeitems);
384 if (!$oldgradeitem) {
387 $newgradeitems = grade_item::fetch_all(array('itemtype'=>'mod', 'itemmodule'=>'assign', 'iteminstance'=>$newassignment->get_instance()->id));
388 if (!$newgradeitems) {
391 $newgradeitem = array_pop($newgradeitems);
392 if (!$newgradeitem) {
396 $gradegrades = grade_grade::fetch_all(array('itemid'=>$oldgradeitem->id));
398 foreach ($gradegrades as $gradeid=>$grade) {
399 $grade->itemid = $newgradeitem->id;
400 grade_update('mod/assign', $newassignment->get_course()->id, 'mod', 'assign', $newassignment->get_instance()->id, 0, $grade, NULL);