[Summary 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   * A scheduled task.
  19   *
  20   * @package    core
  21   * @copyright  2019 Simey Lameze <simey@moodle.com>
  22   * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  23   */
  24  namespace core\task;
  25  defined('MOODLE_INTERNAL') || die();
  26  
  27  /**
  28   * Simple task to clean grade history tables.
  29   *
  30   * @copyright  2019 Simey Lameze <simey@moodle.com>
  31   * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  32   */
  33  class grade_history_cleanup_task extends scheduled_task {
  34  
  35      /**
  36       * Get a descriptive name for this task (shown to admins).
  37       *
  38       * @return string
  39       */
  40      public function get_name() {
  41          return get_string('taskgradehistorycleanup', 'admin');
  42      }
  43  
  44      /**
  45       * Cleanup history tables.
  46       */
  47      public function execute() {
  48          global $CFG, $DB;
  49  
  50          if (!empty($CFG->gradehistorylifetime)) {
  51              $now = time();
  52              $histlifetime = $now - ($CFG->gradehistorylifetime * DAYSECS);
  53              $tables = [
  54                  'grade_outcomes_history',
  55                  'grade_categories_history',
  56                  'grade_items_history',
  57                  'grade_grades_history',
  58                  'scale_history'
  59              ];
  60              foreach ($tables as $table) {
  61                  if ($DB->delete_records_select($table, "timemodified < ?", [$histlifetime])) {
  62                      mtrace("    Deleted old grade history records from '$table'");
  63                  }
  64              }
  65          }
  66      }
  67  }