[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  2013 onwards Martin Dougiamas  http://dougiamas.com
  22   * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  23   */
  24  namespace core\task;
  25  
  26  /**
  27   * Simple task to run the grade cron.
  28   */
  29  class grade_cron_task extends scheduled_task {
  30  
  31      /**
  32       * Get a descriptive name for this task (shown to admins).
  33       *
  34       * @return string
  35       */
  36      public function get_name() {
  37          return get_string('taskgradecron', 'admin');
  38      }
  39  
  40      /**
  41       * Do the job.
  42       * Throw exceptions on errors (the job will be retried).
  43       */
  44      public function execute() {
  45          global $CFG, $DB;
  46          require_once($CFG->libdir . '/gradelib.php');
  47  
  48          $now = time();
  49          $sql = "SELECT i.*
  50                    FROM {grade_items} i
  51                   WHERE i.locked = 0
  52                     AND i.locktime > 0
  53                     AND i.locktime < ?
  54                     AND EXISTS (SELECT 'x'
  55                                   FROM {grade_items} c
  56                                  WHERE c.itemtype='course'
  57                                    AND c.needsupdate=0
  58                                    AND c.courseid=i.courseid)";
  59          // Go through all courses that have proper final grades and lock them if needed.
  60          $rs = $DB->get_recordset_sql($sql, array($now));
  61          foreach ($rs as $item) {
  62              $gradeitem = new \grade_item($item, false);
  63              $gradeitem->locked = $now;
  64              $gradeitem->update('locktime');
  65          }
  66          $rs->close();
  67  
  68          $gradeinst = new \grade_grade();
  69          $fields = 'g.' . implode(',g.', $gradeinst->required_fields);
  70          $sql = "SELECT $fields
  71                    FROM {grade_grades} g, {grade_items} i
  72                   WHERE g.locked = 0
  73                     AND g.locktime > 0
  74                     AND g.locktime < ?
  75                     AND g.itemid = i.id
  76                     AND EXISTS (SELECT 'x'
  77                                   FROM {grade_items} c
  78                                  WHERE c.itemtype = 'course'
  79                                    AND c.needsupdate = 0
  80                                    AND c.courseid = i.courseid)";
  81          // Go through all courses that have proper final grades and lock them if needed.
  82          $rs = $DB->get_recordset_sql($sql, array($now));
  83          foreach ($rs as $grade) {
  84              $gradegrade = new \grade_grade($grade, false);
  85              $gradegrade->locked = $now;
  86              $gradegrade->update('locktime');
  87          }
  88          $rs->close();
  89      }
  90  
  91  }