Proyectos de Subversion Moodle

<?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/>.

namespace core;

defined('MOODLE_INTERNAL') || die();

require_once(__DIR__.'/fixtures/lib.php');

/**

 * Test grade grades

 *

 * @package    core

 * @category   test

 * @copyright  nicolas@moodle.com

 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later

 */

class grade_grade_test extends \grade_base_testcase {

    public function test_grade_grade(): void {

        $this->sub_test_grade_grade_construct();

        $this->sub_test_grade_grade_insert();

        $this->sub_test_grade_grade_update();

        $this->sub_test_grade_grade_fetch();

        $this->sub_test_grade_grade_fetch_all();

        $this->sub_test_grade_grade_load_grade_item();

        $this->sub_test_grade_grade_standardise_score();

        $this->sub_test_grade_grade_is_locked();

        $this->sub_test_grade_grade_set_hidden();

        $this->sub_test_grade_grade_is_hidden();

        $this->sub_test_grade_grade_deleted();

        $this->sub_test_grade_grade_deleted_event();

    }

    protected function sub_test_grade_grade_construct() {

        $params = new \stdClass();

        $params->itemid = $this->grade_items[0]->id;

        $params->userid = 1;

        $params->rawgrade = 88;

        $params->rawgrademax = 110;

        $params->rawgrademin = 18;

        $grade_grade = new \grade_grade($params, false);

        $this->assertEquals($params->itemid, $grade_grade->itemid);

        $this->assertEquals($params->rawgrade, $grade_grade->rawgrade);

    }

    protected function sub_test_grade_grade_insert() {

        $grade_grade = new \grade_grade();

        $this->assertTrue(method_exists($grade_grade, 'insert'));

        $grade_grade->itemid = $this->grade_items[0]->id;

        $grade_grade->userid = 10;

        $grade_grade->rawgrade = 88;

        $grade_grade->rawgrademax = 110;

        $grade_grade->rawgrademin = 18;

        // Check the grade_item's needsupdate variable first.

        $grade_grade->load_grade_item();

        $this->assertEmpty($grade_grade->grade_item->needsupdate);

        $grade_grade->insert();

        $last_grade_grade = end($this->grade_grades);

        $this->assertEquals($grade_grade->id, $last_grade_grade->id + 1);

        // Timecreated will only be set if the grade was submitted by an activity module.

        $this->assertTrue(empty($grade_grade->timecreated));

        // Timemodified will only be set if the grade was submitted by an activity module.

        $this->assertTrue(empty($grade_grade->timemodified));

        // Keep our collection the same as is in the database.

        $this->grade_grades[] = $grade_grade;

    }

    protected function sub_test_grade_grade_update() {

        $grade_grade = new \grade_grade($this->grade_grades[0], false);

        $this->assertTrue(method_exists($grade_grade, 'update'));

    }

    protected function sub_test_grade_grade_fetch() {

        $grade_grade = new \grade_grade();

        $this->assertTrue(method_exists($grade_grade, 'fetch'));

        $grades = \grade_grade::fetch(array('id'=>$this->grade_grades[0]->id));

        $this->assertEquals($this->grade_grades[0]->id, $grades->id);

        $this->assertEquals($this->grade_grades[0]->rawgrade, $grades->rawgrade);

    }

    protected function sub_test_grade_grade_fetch_all() {

        $grade_grade = new \grade_grade();

        $this->assertTrue(method_exists($grade_grade, 'fetch_all'));

        $grades = \grade_grade::fetch_all(array());

        $this->assertEquals(count($this->grade_grades), count($grades));

    }

    protected function sub_test_grade_grade_load_grade_item() {

        $grade_grade = new \grade_grade($this->grade_grades[0], false);

        $this->assertTrue(method_exists($grade_grade, 'load_grade_item'));

        $this->assertNull($grade_grade->grade_item);

        $this->assertNotEmpty($grade_grade->itemid);

        $this->assertNotNull($grade_grade->load_grade_item());

        $this->assertNotNull($grade_grade->grade_item);

        $this->assertEquals($this->grade_items[0]->id, $grade_grade->grade_item->id);

    }

    protected function sub_test_grade_grade_standardise_score() {

        $this->assertEquals(4, round(\grade_grade::standardise_score(6, 0, 7, 0, 5)));

        $this->assertEquals(40, \grade_grade::standardise_score(50, 30, 80, 0, 100));

    }

    /**

     * Tests grade_grade::set_locked()

     *

     * @covers \grade_grade::set_locked

     */

    public function test_grade_grade_set_locked(): void {

        // Skip this test because set_locked() arguments have been modified, rendering these tests

        // useless until they are re-written. Note this comes from MDL-32323 (2012!).

        $this->markTestSkipped('Useless set_locked() tests until they are re-written');

        $grade_item = new \grade_item($this->grade_items[0]);

        $grade = new \grade_grade($grade_item->get_final(1));

        $this->assertTrue(method_exists($grade, 'set_locked'));

        $this->assertTrue(empty($grade_item->locked));

        $this->assertTrue(empty($grade->locked));

        $this->assertTrue($grade->set_locked(true));

        $this->assertFalse(empty($grade->locked));

        $this->assertTrue($grade->set_locked(false));

        $this->assertTrue(empty($grade->locked));

        $this->assertTrue($grade_item->set_locked(true, true));

        $grade = new \grade_grade($grade_item->get_final(1));

        $this->assertFalse(empty($grade->locked));

        $this->assertFalse($grade->set_locked(true, false));

        $this->assertTrue($grade_item->set_locked(true, false));

        $grade = new \grade_grade($grade_item->get_final(1));

        $this->assertTrue($grade->set_locked(true, false));

    }

    protected function sub_test_grade_grade_is_locked() {

        $grade = new \grade_grade($this->grade_grades[0], false);

        $this->assertTrue(method_exists($grade, 'is_locked'));

        $this->assertFalse($grade->is_locked());

        $grade->locked = time();

        $this->assertTrue($grade->is_locked());

    }

    protected function sub_test_grade_grade_set_hidden() {

        $grade = new \grade_grade($this->grade_grades[0], false);

        $grade_item = new \grade_item($this->grade_items[0], false);

        $this->assertTrue(method_exists($grade, 'set_hidden'));

        $this->assertEquals(0, $grade_item->hidden);

        $this->assertEquals(0, $grade->hidden);

        $grade->set_hidden(0);

        $this->assertEquals(0, $grade->hidden);

        $grade->set_hidden(1);

        $this->assertEquals(1, $grade->hidden);

        $grade->set_hidden(0);

        $this->assertEquals(0, $grade->hidden);

    }

    protected function sub_test_grade_grade_is_hidden() {

        $grade = new \grade_grade($this->grade_grades[0], false);

        $this->assertTrue(method_exists($grade, 'is_hidden'));

        $this->assertFalse($grade->is_hidden());

        $grade->hidden = 1;

        $this->assertTrue($grade->is_hidden());

        $grade->hidden = time()-666;

        $this->assertFalse($grade->is_hidden());

        $grade->hidden = time()+666;

        $this->assertTrue($grade->is_hidden());

    }

    /**

     * Test \grade_grade::flatten_dependencies_array()

     *

     * @covers \grade_grade::flatten_dependencies_array()

     */

    public function test_flatten_dependencies(): void {

        // First test a simple normal case.

        $a = array(1 => array(2, 3), 2 => array(), 3 => array(4), 4 => array());

        $b = array();

        $expecteda = array(1 => array(2, 3, 4), 2 => array(), 3 => array(4), 4 => array());

        $expectedb = array(1 => 1);

        \test_grade_grade_flatten_dependencies_array::test_flatten_dependencies_array($a, $b);

        $this->assertSame($expecteda, $a);

        $this->assertSame($expectedb, $b);

        // Edge case - empty arrays.

        $a = $b = $expecteda = $expectedb = array();

        \test_grade_grade_flatten_dependencies_array::test_flatten_dependencies_array($a, $b);

        $this->assertSame($expecteda, $a);

        $this->assertSame($expectedb, $b);

        // Circular dependency.

        $a = array(1 => array(2), 2 => array(3), 3 => array(1));

        $b = array();

        $expecteda = array(1 => array(1, 2, 3), 2 => array(1, 2, 3), 3 => array(1, 2, 3));

        \test_grade_grade_flatten_dependencies_array::test_flatten_dependencies_array($a, $b);

        $this->assertSame($expecteda, $a);

        // Note - we don't test the depth when we got circular dependencies - the main thing we wanted to test was that there was

        // no ka-boom. The result would be hard to understand and doesn't matter.

        // Circular dependency 2.

        $a = array(1 => array(2), 2 => array(3), 3 => array(4), 4 => array(2, 1));

        $b = array();

        $expecteda = array(1 => array(1, 2, 3, 4), 2 => array(1, 2, 3, 4), 3 => array(1, 2, 3, 4), 4 => array(1, 2, 3, 4));

        \test_grade_grade_flatten_dependencies_array::test_flatten_dependencies_array($a, $b);

        $this->assertSame($expecteda, $a);

        // Missing first level dependency.

        $a = array(1 => array(2, 3), 3 => array(4), 4 => array());

        $b = array();

        $expecteda = array(1 => array(2, 3, 4), 3 => array(4), 4 => array());

        $expectedb = array(1 => 1);

        \test_grade_grade_flatten_dependencies_array::test_flatten_dependencies_array($a, $b);

        $this->assertSame($expecteda, $a);

        $this->assertSame($expectedb, $b);

        // Missing 2nd level dependency.

        $a = array(1 => array(2, 3), 2 => array(), 3 => array(4));

        $b = array();

        $expecteda = array(1 => array(2, 3, 4), 2 => array(), 3 => array(4));

        $expectedb = array(1 => 1);

        \test_grade_grade_flatten_dependencies_array::test_flatten_dependencies_array($a, $b);

        $this->assertSame($expecteda, $a);

        $this->assertSame($expectedb, $b);

        // Null first level dependency.

        $a = array(1 => array(2, null), 2 => array(3), 3 => array(4), 4 => array());

        $b = array();

        $expecteda = array(1 => array(2, 3, 4), 2 => array(3, 4), 3 => array(4), 4 => array());

        $expectedb = array(1 => 2, 2 => 1);

        \test_grade_grade_flatten_dependencies_array::test_flatten_dependencies_array($a, $b);

        $this->assertSame($expecteda, $a);

        $this->assertSame($expectedb, $b);

        // Null 2nd level dependency.

        $a = array(1 => array(2, 3), 2 => array(), 3 => array(4), 4 => array(null));

        $b = array();

        $expecteda = array(1 => array(2, 3, 4), 2 => array(), 3 => array(4), 4 => array());

        $expectedb = array(1 => 1);

        \test_grade_grade_flatten_dependencies_array::test_flatten_dependencies_array($a, $b);

        $this->assertSame($expecteda, $a);

        $this->assertSame($expectedb, $b);

        // Straight null dependency.

        $a = array(1 => array(2, 3), 2 => array(), 3 => array(4), 4 => null);

        $b = array();

        $expecteda = array(1 => array(2, 3, 4), 2 => array(), 3 => array(4), 4 => array());

        $expectedb = array(1 => 1);

        \test_grade_grade_flatten_dependencies_array::test_flatten_dependencies_array($a, $b);

        $this->assertSame($expecteda, $a);

        $this->assertSame($expectedb, $b);

        // Also incorrect non-array dependency.

        $a = array(1 => array(2, 3), 2 => array(), 3 => array(4), 4 => 23);

        $b = array();

        $expecteda = array(1 => array(2, 3, 4), 2 => array(), 3 => array(4), 4 => array());

        $expectedb = array(1 => 1);

        \test_grade_grade_flatten_dependencies_array::test_flatten_dependencies_array($a, $b);

        $this->assertSame($expecteda, $a);

        $this->assertSame($expectedb, $b);

    }

    public function test_grade_grade_min_max(): void {

        global $CFG;

        $initialminmaxtouse = $CFG->grade_minmaxtouse;

        $this->setAdminUser();

        $course = $this->getDataGenerator()->create_course();

        $user = $this->getDataGenerator()->create_user();

        $assignrecord = $this->getDataGenerator()->create_module('assign', array('course' => $course, 'grade' => 100));

        $cm = get_coursemodule_from_instance('assign', $assignrecord->id);

        $assigncontext = \context_module::instance($cm->id);

        $assign = new \assign($assigncontext, $cm, $course);

        // Fetch the assignment item.

        $giparams = array('itemtype' => 'mod', 'itemmodule' => 'assign', 'iteminstance' => $assignrecord->id,

                'courseid' => $course->id, 'itemnumber' => 0);

        $gi = \grade_item::fetch($giparams);

        $this->assertEquals(0, $gi->grademin);

        $this->assertEquals(100, $gi->grademax);

        // Give a grade to the student.

        $usergrade = $assign->get_user_grade($user->id, true);

        $usergrade->grade = 10;

        $assign->update_grade($usergrade);

        // Check the grade stored in gradebook.

        $gg = \grade_grade::fetch(array('userid' => $user->id, 'itemid' => $gi->id));

        $this->assertEquals(10, $gg->rawgrade);

        $this->assertEquals(0, $gg->get_grade_min());

        $this->assertEquals(100, $gg->get_grade_max());

        // Change the min/max grade of the item.

        $gi->grademax = 50;

        $gi->grademin = 2;

        $gi->update();

        // Fetch the updated item.

        $gi = \grade_item::fetch($giparams);

        // Now check the grade grade min/max with system setting.

        $CFG->grade_minmaxtouse = GRADE_MIN_MAX_FROM_GRADE_ITEM;

        grade_set_setting($course->id, 'minmaxtouse', null); // Ensure no course setting.

        $gg = \grade_grade::fetch(array('userid' => $user->id, 'itemid' => $gi->id));

        $this->assertEquals(2, $gg->get_grade_min());

        $this->assertEquals(50, $gg->get_grade_max());

        // Now with other system setting.

        $CFG->grade_minmaxtouse = GRADE_MIN_MAX_FROM_GRADE_GRADE;

        grade_set_setting($course->id, 'minmaxtouse', null); // Ensure no course setting, and reset static cache.

        $gg = \grade_grade::fetch(array('userid' => $user->id, 'itemid' => $gi->id));

        $this->assertEquals(0, $gg->get_grade_min());

        $this->assertEquals(100, $gg->get_grade_max());

        // Now with overriden setting in course.

        $CFG->grade_minmaxtouse = GRADE_MIN_MAX_FROM_GRADE_ITEM;

        grade_set_setting($course->id, 'minmaxtouse', GRADE_MIN_MAX_FROM_GRADE_GRADE);

        $gg = \grade_grade::fetch(array('userid' => $user->id, 'itemid' => $gi->id));

        $this->assertEquals(0, $gg->get_grade_min());

        $this->assertEquals(100, $gg->get_grade_max());

        $CFG->grade_minmaxtouse = GRADE_MIN_MAX_FROM_GRADE_GRADE;

        grade_set_setting($course->id, 'minmaxtouse', GRADE_MIN_MAX_FROM_GRADE_ITEM);

        $gg = \grade_grade::fetch(array('userid' => $user->id, 'itemid' => $gi->id));

        $this->assertEquals(2, $gg->get_grade_min());

        $this->assertEquals(50, $gg->get_grade_max());

        $CFG->grade_minmaxtouse = $initialminmaxtouse;

    }

    public function test_grade_grade_min_max_with_course_item(): void {

        global $CFG, $DB;

        $initialminmaxtouse = $CFG->grade_minmaxtouse;

        $this->setAdminUser();

        $course = $this->getDataGenerator()->create_course();

        $user = $this->getDataGenerator()->create_user();

        $gi = \grade_item::fetch_course_item($course->id);

        // Fetch the category item.

        $this->assertEquals(0, $gi->grademin);

        $this->assertEquals(100, $gi->grademax);

        // Give a grade to the student.

        $gi->update_final_grade($user->id, 10);

        // Check the grade min/max stored in gradebook.

        $gg = \grade_grade::fetch(array('userid' => $user->id, 'itemid' => $gi->id));

        $this->assertEquals(0, $gg->get_grade_min());

        $this->assertEquals(100, $gg->get_grade_max());

        // Change the min/max grade of the item.

        $gi->grademin = 2;

        $gi->grademax = 50;

        $gi->update();

        // Fetch the updated item.

        $gi = \grade_item::fetch_course_item($course->id);

        // Now check the grade grade min/max with system setting.

        $CFG->grade_minmaxtouse = GRADE_MIN_MAX_FROM_GRADE_ITEM;

        grade_set_setting($course->id, 'minmaxtouse', null); // Ensure no course setting.

        $gg = \grade_grade::fetch(array('userid' => $user->id, 'itemid' => $gi->id));

        $this->assertEquals(0, $gg->get_grade_min());

        $this->assertEquals(100, $gg->get_grade_max());

        // Now with other system setting.

        $CFG->grade_minmaxtouse = GRADE_MIN_MAX_FROM_GRADE_GRADE;

        grade_set_setting($course->id, 'minmaxtouse', null); // Ensure no course setting, and reset static cache.

        $gg = \grade_grade::fetch(array('userid' => $user->id, 'itemid' => $gi->id));

        $this->assertEquals(0, $gg->get_grade_min());

        $this->assertEquals(100, $gg->get_grade_max());

        // Now with overriden setting in course.

        $CFG->grade_minmaxtouse = GRADE_MIN_MAX_FROM_GRADE_ITEM;

        grade_set_setting($course->id, 'minmaxtouse', GRADE_MIN_MAX_FROM_GRADE_GRADE);

        $gg = \grade_grade::fetch(array('userid' => $user->id, 'itemid' => $gi->id));

        $this->assertEquals(0, $gg->get_grade_min());

        $this->assertEquals(100, $gg->get_grade_max());

        $CFG->grade_minmaxtouse = GRADE_MIN_MAX_FROM_GRADE_GRADE;

        grade_set_setting($course->id, 'minmaxtouse', GRADE_MIN_MAX_FROM_GRADE_ITEM);

        $gg = \grade_grade::fetch(array('userid' => $user->id, 'itemid' => $gi->id));

        $this->assertEquals(0, $gg->get_grade_min());

        $this->assertEquals(100, $gg->get_grade_max());

        $CFG->grade_minmaxtouse = $initialminmaxtouse;

    }

    public function test_grade_grade_min_max_with_category_item(): void {

        global $CFG, $DB;

        $initialminmaxtouse = $CFG->grade_minmaxtouse;

        $this->setAdminUser();

        $course = $this->getDataGenerator()->create_course();

        $user = $this->getDataGenerator()->create_user();

        $coursegi = \grade_item::fetch_course_item($course->id);

        // Create a category item.

        $gc = new \grade_category(array('courseid' => $course->id, 'fullname' => 'test'), false);

        $gc->insert();

        $gi = $gc->get_grade_item();

        $gi->grademax = 100;

        $gi->grademin = 0;

        $gi->update();

        // Fetch the category item.

        $giparams = array('itemtype' => 'category', 'iteminstance' => $gc->id);

        $gi = \grade_item::fetch($giparams);

        $this->assertEquals(0, $gi->grademin);

        $this->assertEquals(100, $gi->grademax);

        // Give a grade to the student.

        $gi->update_final_grade($user->id, 10);

        // Check the grade min/max stored in gradebook.

        $gg = \grade_grade::fetch(array('userid' => $user->id, 'itemid' => $gi->id));

        $this->assertEquals(0, $gg->get_grade_min());

        $this->assertEquals(100, $gg->get_grade_max());

        // Change the min/max grade of the item.

        $gi->grademin = 2;

        $gi->grademax = 50;

        $gi->update();

        // Fetch the updated item.

        $gi = \grade_item::fetch($giparams);

        // Now check the grade grade min/max with system setting.

        $CFG->grade_minmaxtouse = GRADE_MIN_MAX_FROM_GRADE_ITEM;

        grade_set_setting($course->id, 'minmaxtouse', null); // Ensure no course setting.

        $gg = \grade_grade::fetch(array('userid' => $user->id, 'itemid' => $gi->id));

        $this->assertEquals(0, $gg->get_grade_min());

        $this->assertEquals(100, $gg->get_grade_max());

        // Now with other system setting.

        $CFG->grade_minmaxtouse = GRADE_MIN_MAX_FROM_GRADE_GRADE;

        grade_set_setting($course->id, 'minmaxtouse', null); // Ensure no course setting, and reset static cache.

        $gg = \grade_grade::fetch(array('userid' => $user->id, 'itemid' => $gi->id));

        $this->assertEquals(0, $gg->get_grade_min());

        $this->assertEquals(100, $gg->get_grade_max());

        // Now with overriden setting in course.

        $CFG->grade_minmaxtouse = GRADE_MIN_MAX_FROM_GRADE_ITEM;

        grade_set_setting($course->id, 'minmaxtouse', GRADE_MIN_MAX_FROM_GRADE_GRADE);

        $gg = \grade_grade::fetch(array('userid' => $user->id, 'itemid' => $gi->id));

        $this->assertEquals(0, $gg->get_grade_min());

        $this->assertEquals(100, $gg->get_grade_max());

        $CFG->grade_minmaxtouse = GRADE_MIN_MAX_FROM_GRADE_GRADE;

        grade_set_setting($course->id, 'minmaxtouse', GRADE_MIN_MAX_FROM_GRADE_ITEM);

        $gg = \grade_grade::fetch(array('userid' => $user->id, 'itemid' => $gi->id));

        $this->assertEquals(0, $gg->get_grade_min());

        $this->assertEquals(100, $gg->get_grade_max());

        $CFG->grade_minmaxtouse = $initialminmaxtouse;

    }

    /**

     * Tests when a grade_grade has been deleted.

     */

    public function sub_test_grade_grade_deleted() {

        $dg = $this->getDataGenerator();

        // Create the data we need for the tests.

        $fs = new \file_storage();

        $u1 = $dg->create_user();

        $c1 = $dg->create_course();

        $a1 = $dg->create_module('assign', ['course' => $c1->id]);

        $a1context = \context_module::instance($a1->cmid);

        $gi = new \grade_item($dg->create_grade_item(

            [

                'courseid' => $c1->id,

                'itemtype' => 'mod',

                'itemmodule' => 'assign',

                'iteminstance' => $a1->id

            ]

        ), false);

        // Add feedback files to copy as our update.

        $this->add_feedback_file_to_copy();

        $grades['feedback'] = 'Nice feedback!';

        $grades['feedbackformat'] = FORMAT_MOODLE;

        $grades['feedbackfiles'] = [

            'contextid' => 1,

            'component' => 'test',

            'filearea' => 'testarea',

            'itemid' => 1

        ];

        $grades['userid'] = $u1->id;

        grade_update('mod/assign', $gi->courseid, $gi->itemtype, $gi->itemmodule, $gi->iteminstance,

            $gi->itemnumber, $grades);

        // Feedback file area.

        $files = $fs->get_area_files($a1context->id, GRADE_FILE_COMPONENT, GRADE_FEEDBACK_FILEAREA);

        $this->assertEquals(2, count($files));

        // History file area.

        $files = $fs->get_area_files($a1context->id, GRADE_FILE_COMPONENT, GRADE_HISTORY_FEEDBACK_FILEAREA);

        $this->assertEquals(2, count($files));

        $gg = \grade_grade::fetch(array('userid' => $u1->id, 'itemid' => $gi->id));

        $gg->delete();

        // Feedback file area.

        $files = $fs->get_area_files($a1context->id, GRADE_FILE_COMPONENT, GRADE_FEEDBACK_FILEAREA);

        $this->assertEquals(0, count($files));

        // History file area.

        $files = $fs->get_area_files($a1context->id, GRADE_FILE_COMPONENT, GRADE_HISTORY_FEEDBACK_FILEAREA);

        $this->assertEquals(2, count($files));

    }

    /**

     * Creates a feedback file to copy to the gradebook area.

     */

    private function add_feedback_file_to_copy() {

        $dummy = array(

            'contextid' => 1,

            'component' => 'test',

            'filearea' => 'testarea',

            'itemid' => 1,

            'filepath' => '/',

            'filename' => 'feedback1.txt'

        );

        $fs = get_file_storage();

        $fs->create_file_from_string($dummy, '');

    }

    /**

     * Tests grade_deleted event.

     */

    public function sub_test_grade_grade_deleted_event() {

        global $DB;

        $dg = $this->getDataGenerator();

        // Create the data we need for the tests.

        $u1 = $dg->create_user();

        $u2 = $dg->create_user();

        $c1 = $dg->create_course();

        $a1 = $dg->create_module('assign', ['course' => $c1->id]);

        $gi = new \grade_item($dg->create_grade_item(

            [

                'courseid' => $c1->id,

                'itemtype' => 'mod',

                'itemmodule' => 'assign',

                'iteminstance' => $a1->id

            ]

        ), false);

        grade_update('mod/assign', $gi->courseid, $gi->itemtype, $gi->itemmodule, $gi->iteminstance,

            $gi->itemnumber, ['userid' => $u1->id]);

        grade_update('mod/assign', $gi->courseid, $gi->itemtype, $gi->itemmodule, $gi->iteminstance,

            $gi->itemnumber, ['userid' => $u2->id]);

        $gg = \grade_grade::fetch(array('userid' => $u1->id, 'itemid' => $gi->id));

        $this->assertEquals($u1->id, $gg->userid);

        $gg->load_grade_item();

        $this->assertEquals($gi->id, $gg->grade_item->id);

        // Delete user with valid grade item.

        $sink = $this->redirectEvents();

        grade_user_delete($u1->id);

        $events = $sink->get_events();

        $event = reset($events);

        $sink->close();

        $this->assertInstanceOf('core\event\grade_deleted', $event);

        $gg = \grade_grade::fetch(array('userid' => $u2->id, 'itemid' => $gi->id));

        $this->assertEquals($u2->id, $gg->userid);

        $gg->load_grade_item();

        $this->assertEquals($gi->id, $gg->grade_item->id);

        // Delete grade item, mock up orphaned grade_grades.

        $DB->delete_records('grade_items', ['id' => $gi->id]);

        $gg = \grade_grade::fetch(array('userid' => $u2->id, 'itemid' => $gi->id));

        $this->assertEquals($u2->id, $gg->userid);

        // No event is triggered and there is a debugging message.

        $sink = $this->redirectEvents();

        grade_user_delete($u2->id);

        $this->assertDebuggingCalled("Missing grade item id $gi->id");

        $events = $sink->get_events();

        $sink->close();

        $this->assertEmpty($events);

        // The grade should be deleted.

        $gg = \grade_grade::fetch(array('userid' => $u2->id, 'itemid' => $gi->id));

        $this->assertEmpty($gg);

    }

    /**

     * Tests get_hiding_affected by locked category and overridden grades.

     */

    public function test_category_get_hiding_affected(): void {

        $generator = $this->getDataGenerator();

        // Create the data we need for the tests.

        $course1 = $generator->create_course();

        $user1 = $generator->create_and_enrol($course1, 'student');

        $assignment2 = $generator->create_module('assign', ['course' => $course1->id]);

        // Create a category item.

        $gradecategory = new \grade_category(array('courseid' => $course1->id, 'fullname' => 'test'), false);

        $gradecategoryid = $gradecategory->insert();

        // Create one hidden grade item.

        $gradeitem1a = new \grade_item($generator->create_grade_item(

            [

                'courseid' => $course1->id,

                'itemtype' => 'mod',

                'itemmodule' => 'assign',

                'iteminstance' => $assignment2->id,

                'categoryid' => $gradecategoryid,

                'hidden' => 1,

            ]

        ), false);

        grade_update('mod/assign', $gradeitem1a->courseid, $gradeitem1a->itemtype, $gradeitem1a->itemmodule, $gradeitem1a->iteminstance,

        $gradeitem1a->itemnumber, ['userid' => $user1->id]);

        // Get category grade item.

        $gradeitem = $gradecategory->get_grade_item();

        // Reset needsupdate to allow set_locked.

        $gradeitem->needsupdate = 0;

        $gradeitem->update();

        // Lock category grade item.

        $gradeitem->set_locked(1);

        $hidingaffectedlocked = $this->call_get_hiding_affected($course1, $user1);

        // Since locked category now should be recalculated.

        // The number of unknown items is 2, this includes category item and course item.

        $this->assertEquals(2, count($hidingaffectedlocked['unknown']));

        // Unlock category.

        $gradeitem->set_locked(0);

        $hidingaffectedunlocked = $this->call_get_hiding_affected($course1, $user1);

        // When category unlocked, hidden item should exist in altered items.

        $this->assertTrue(in_array($gradeitem1a->id, array_keys($hidingaffectedunlocked['altered'])));

        // This creates all the grade_grades we need.

        grade_regrade_final_grades($course1->id);

        // Set grade override.

        $gradegrade = \grade_grade::fetch([

            'userid' => $user1->id,

            'itemid' => $gradeitem->id,

        ]);

        // Set override grade grade, and check that grade submission has been overridden.

        $gradegrade->set_overridden(true);

        $this->assertEquals(true, $gradegrade->is_overridden());

        $hidingaffectedoverridden = $this->call_get_hiding_affected($course1, $user1);

        // No need to recalculate overridden grades.

        $this->assertTrue(in_array($gradegrade->itemid, array_keys($hidingaffectedoverridden['alteredaggregationstatus'])));

        $this->assertEquals('used', $hidingaffectedoverridden['alteredaggregationstatus'][$gradegrade->itemid]);

    }

    /**

     * Call get_hiding_affected().

     * @param \stdClass $course The course object

     * @param \stdClass $user The student object

     * @return array

     */

    private function call_get_hiding_affected($course, $user) {

        global $DB;

        $items = \grade_item::fetch_all(array('courseid' => $course->id));

        $grades = array();

        $sql = "SELECT g.*

                  FROM {grade_grades} g

                  JOIN {grade_items} gi ON gi.id = g.itemid

                 WHERE g.userid = :userid AND gi.courseid = :courseid";

        if ($gradesrecords = $DB->get_records_sql($sql, ['userid' => $user->id, 'courseid' => $course->id])) {

            foreach ($gradesrecords as $grade) {

                $grades[$grade->itemid] = new \grade_grade($grade, false);

            }

            unset($gradesrecords);

        }

        foreach ($items as $itemid => $gradeitem) {

            if (!isset($grades[$itemid])) {

                $gradegrade = new \grade_grade();

                $gradegrade->userid = $user->id;

                $gradegrade->itemid = $gradeitem->id;

                $grades[$itemid] = $gradegrade;

            }

        }

        return \grade_grade::get_hiding_affected($grades, $items);

    }

}