You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
86 lines
3.3 KiB
86 lines
3.3 KiB
2 years ago
|
<?php
|
||
|
|
// This file is part of Moodle - http://moodle.org/
|
||
|
|
//
|
||
|
|
// Moodle is free software: you can redistribute it and/or modify
|
||
|
|
// it under the terms of the GNU General Public License as published by
|
||
|
|
// the Free Software Foundation, either version 3 of the License, or
|
||
|
|
// (at your option) any later version.
|
||
|
|
//
|
||
|
|
// Moodle is distributed in the hope that it will be useful,
|
||
|
|
// but WITHOUT ANY WARRANTY; without even the implied warranty of
|
||
|
|
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
||
|
|
// GNU General Public License for more details.
|
||
|
|
//
|
||
|
|
// You should have received a copy of the GNU General Public License
|
||
|
|
// along with Moodle. If not, see <http://www.gnu.org/licenses/>.
|
||
|
|
|
||
|
|
// This file keeps track of upgrades to
|
||
|
|
// the feedback module
|
||
|
|
//
|
||
|
|
// Sometimes, changes between versions involve
|
||
|
|
// alterations to database structures and other
|
||
|
|
// major things that may break installations.
|
||
|
|
//
|
||
|
|
// The upgrade function in this file will attempt
|
||
|
|
// to perform all the necessary actions to upgrade
|
||
|
|
// your older installation to the current version.
|
||
|
|
//
|
||
|
|
// If there's something it cannot do itself, it
|
||
|
|
// will tell you what you need to do.
|
||
|
|
//
|
||
|
|
// The commands in here will all be database-neutral,
|
||
|
|
// using the methods of database_manager class
|
||
|
|
//
|
||
|
|
// Please do not forget to use upgrade_set_timeout()
|
||
|
|
// before any action that may take longer time to finish.
|
||
|
|
|
||
|
|
defined('MOODLE_INTERNAL') || die();
|
||
|
|
|
||
|
|
function xmldb_feedback_upgrade($oldversion) {
|
||
|
|
global $CFG, $DB;
|
||
|
|
|
||
|
|
$dbman = $DB->get_manager(); // Loads ddl manager and xmldb classes.
|
||
|
|
|
||
|
|
if ($oldversion < 2017032800) {
|
||
|
|
|
||
|
|
// Delete duplicated records in feedback_completed. We just keep the last record of completion.
|
||
|
|
// Related values in feedback_value won't be deleted (they won't be used and can be kept there as a backup).
|
||
|
|
$sql = "SELECT MAX(id) as maxid, userid, feedback, courseid
|
||
|
|
FROM {feedback_completed}
|
||
|
|
WHERE userid <> 0 AND anonymous_response = :notanonymous
|
||
|
|
GROUP BY userid, feedback, courseid
|
||
|
|
HAVING COUNT(id) > 1";
|
||
|
|
$params = ['notanonymous' => 2]; // FEEDBACK_ANONYMOUS_NO.
|
||
|
|
|
||
|
|
$duplicatedrows = $DB->get_recordset_sql($sql, $params);
|
||
|
|
foreach ($duplicatedrows as $row) {
|
||
|
|
$DB->delete_records_select('feedback_completed', 'userid = ? AND feedback = ? AND courseid = ? AND id <> ?'.
|
||
|
|
' AND anonymous_response = ?', array(
|
||
|
|
$row->userid,
|
||
|
|
$row->feedback,
|
||
|
|
$row->courseid,
|
||
|
|
$row->maxid,
|
||
|
|
2, // FEEDBACK_ANONYMOUS_NO.
|
||
|
|
));
|
||
|
|
}
|
||
|
|
$duplicatedrows->close();
|
||
|
|
|
||
|
|
// Feedback savepoint reached.
|
||
|
|
upgrade_mod_savepoint(true, 2017032800, 'feedback');
|
||
|
|
}
|
||
|
|
|
||
|
|
// Automatically generated Moodle v3.3.0 release upgrade line.
|
||
|
|
// Put any upgrade step following this.
|
||
|
|
|
||
|
|
// Automatically generated Moodle v3.4.0 release upgrade line.
|
||
|
|
// Put any upgrade step following this.
|
||
|
|
|
||
|
|
// Automatically generated Moodle v3.5.0 release upgrade line.
|
||
|
|
// Put any upgrade step following this.
|
||
|
|
|
||
|
|
// Automatically generated Moodle v3.6.0 release upgrade line.
|
||
|
|
// Put any upgrade step following this.
|
||
|
|
|
||
|
|
return true;
|
||
|
|
}
|