MDL-53638 mod_feedback: corrections during rebase:
[moodle.git] / mod / feedback / db / upgradelib.php
CommitLineData
ffee513e
MG
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 * Upgrade helper functions
19 *
20 * @package mod_feedback
21 * @copyright 2016 Marina Glancy
22 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
23 */
24
25defined('MOODLE_INTERNAL') || die();
26
27/**
28 * Fill new field courseid in tables feedback_completed or feedback_completedtmp
29 *
30 * @param bool $tmp use for temporary table
31 */
32function mod_feedback_upgrade_courseid($tmp = false) {
33 global $DB;
34 $suffix = $tmp ? 'tmp' : '';
35
36 // Part 1. Ensure that each completed record has associated values with only one courseid.
37 $sql = "SELECT c.id
38 FROM {feedback_completed$suffix} c, {feedback_value$suffix} v
39 WHERE c.id = v.completed
40 GROUP by c.id
41 having count(DISTINCT v.course_id) > 1";
42 $problems = $DB->get_fieldset_sql($sql);
43 foreach ($problems as $problem) {
44 $courses = $DB->get_fieldset_sql("SELECT DISTINCT course_id "
45 . "FROM {feedback_value$suffix} WHERE completed = ?", array($problem));
46 $firstcourse = array_shift($courses);
47 $record = $DB->get_record('feedback_completed'.$suffix, array('id' => $problem));
48 unset($record->id);
49 $DB->update_record('feedback_completed'.$suffix, ['id' => $problem, 'courseid' => $firstcourse]);
50 foreach ($courses as $courseid) {
51 $record->courseid = $courseid;
52 $completedid = $DB->insert_record('feedback_completed'.$suffix, $record);
53 $DB->execute("UPDATE {feedback_value$suffix} SET completed = ? WHERE completed = ? AND course_id = ?",
54 array($completedid, $problem, $courseid));
55 }
56 }
57
58 // Part 2. Update courseid in the completed table.
0a0632ce 59 $sql = "UPDATE {feedback_completed$suffix} "
ffee513e 60 . "SET courseid = (SELECT COALESCE(MIN(v.course_id), 0) "
0a0632ce
MG
61 . "FROM {feedback_value$suffix} v "
62 . "WHERE v.completed = {feedback_completed$suffix}.id)";
ffee513e
MG
63 $DB->execute($sql);
64}