[Summary view] [Print] [Text view]

   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  
  25  defined('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   */
  32  function 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.
  59      if ($DB->get_dbfamily() !== 'mysql') {
  60          $sql = "UPDATE {feedback_completed$suffix} "
  61              . "SET courseid = (SELECT COALESCE(MIN(v.course_id), 0) "
  62              . "FROM {feedback_value$suffix} v "
  63              . "WHERE v.completed = {feedback_completed$suffix}.id)";
  64          $DB->execute($sql);
  65      } else {
  66          $sql = "UPDATE {feedback_completed$suffix} c, {feedback_value$suffix} v "
  67              . "SET c.courseid = v.course_id "
  68              . "WHERE v.completed = c.id AND v.course_id <> 0";
  69          $DB->execute($sql);
  70      }
  71  }
  72  
  73  /**
  74   * Ensure tables feedback_value and feedback_valuetmp have unique entries for each pair (completed,item).
  75   *
  76   * @param bool $tmp use for temporary table
  77   */
  78  function mod_feedback_upgrade_delete_duplicate_values($tmp = false) {
  79      global $DB;
  80      $suffix = $tmp ? 'tmp' : '';
  81  
  82      $sql = "SELECT MIN(id) AS id, completed, item, course_id " .
  83              "FROM {feedback_value$suffix} GROUP BY completed, item, course_id HAVING count(id)>1";
  84      $records = $DB->get_records_sql($sql);
  85      foreach ($records as $record) {
  86          $DB->delete_records_select("feedback_value$suffix",
  87              "completed = :completed AND item = :item AND course_id = :course_id AND id > :id", (array)$record);
  88      }
  89  }