MDL-65694 grade: Fix missing gradelib library
[moodle.git] / lib / classes / task / grade_cron_task.php
CommitLineData
309ae892
DW
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 */
24namespace core\task;
25
26/**
27 * Simple task to run the grade cron.
28 */
29class 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() {
be8f453b 45 global $CFG, $DB;
07839e6a 46 require_once($CFG->libdir . '/gradelib.php');
309ae892 47
be8f453b
SL
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();
309ae892
DW
89 }
90
91}