<?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/>. /** * Test non-plugin enrollib parts. * * @package core_enrol * @category phpunit * @copyright 2012 Petr Skoda {@link http://skodak.org} * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ defined('MOODLE_INTERNAL') || die(); /** * Test non-plugin enrollib parts. * * @package core * @category phpunit * @copyright 2012 Petr Skoda {@link http://skodak.org} * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ class enrollib_test extends advanced_testcase { public function test_enrol_get_all_users_courses() { global $DB, $CFG; $this->resetAfterTest(); $studentrole = $DB->get_record('role', array('shortname'=>'student')); $this->assertNotEmpty($studentrole); $teacherrole = $DB->get_record('role', array('shortname'=>'teacher')); $this->assertNotEmpty($teacherrole); $admin = get_admin(); $user1 = $this->getDataGenerator()->create_user(); $user2 = $this->getDataGenerator()->create_user(); $user3 = $this->getDataGenerator()->create_user(); $user4 = $this->getDataGenerator()->create_user(); $user5 = $this->getDataGenerator()->create_user(); $category1 = $this->getDataGenerator()->create_category(array('visible'=>0)); $category2 = $this->getDataGenerator()->create_category(); $course1 = $this->getDataGenerator()->create_course(array( 'shortname' => 'Z', 'idnumber' => '123', 'category' => $category1->id, )); $course2 = $this->getDataGenerator()->create_course(array( 'shortname' => 'X', 'idnumber' => '789', 'category' => $category2->id, )); $course3 = $this->getDataGenerator()->create_course(array( 'shortname' => 'Y', 'idnumber' => '456', 'category' => $category2->id, 'visible' => 0, )); $course4 = $this->getDataGenerator()->create_course(array( 'shortname' => 'W', 'category' => $category2->id, )); $maninstance1 = $DB->get_record('enrol', array('courseid'=>$course1->id, 'enrol'=>'manual'), '*', MUST_EXIST); $DB->set_field('enrol', 'status', ENROL_INSTANCE_DISABLED, array('id'=>$maninstance1->id)); $maninstance1 = $DB->get_record('enrol', array('courseid'=>$course1->id, 'enrol'=>'manual'), '*', MUST_EXIST); $maninstance2 = $DB->get_record('enrol', array('courseid'=>$course2->id, 'enrol'=>'manual'), '*', MUST_EXIST); $maninstance3 = $DB->get_record('enrol', array('courseid'=>$course3->id, 'enrol'=>'manual'), '*', MUST_EXIST); $maninstance4 = $DB->get_record('enrol', array('courseid'=>$course4->id, 'enrol'=>'manual'), '*', MUST_EXIST); $manual = enrol_get_plugin('manual'); $this->assertNotEmpty($manual); $manual->enrol_user($maninstance1, $user1->id, $teacherrole->id); $manual->enrol_user($maninstance1, $user2->id, $studentrole->id); $manual->enrol_user($maninstance1, $user4->id, $teacherrole->id, 0, 0, ENROL_USER_SUSPENDED); $manual->enrol_user($maninstance1, $admin->id, $studentrole->id); $manual->enrol_user($maninstance2, $user1->id); $manual->enrol_user($maninstance2, $user2->id); $manual->enrol_user($maninstance2, $user3->id, 0, 1, time()+(60*60)); $manual->enrol_user($maninstance3, $user1->id); $manual->enrol_user($maninstance3, $user2->id); $manual->enrol_user($maninstance3, $user3->id, 0, 1, time()-(60*60)); $manual->enrol_user($maninstance3, $user4->id, 0, 0, 0, ENROL_USER_SUSPENDED); $courses = enrol_get_all_users_courses($CFG->siteguest); $this->assertSame(array(), $courses); $courses = enrol_get_all_users_courses(0); $this->assertSame(array(), $courses); // Results are sorted by visibility, sortorder by default (in our case order of creation) $courses = enrol_get_all_users_courses($admin->id); $this->assertCount(1, $courses); $this->assertEquals(array($course1->id), array_keys($courses)); $courses = enrol_get_all_users_courses($admin->id, true); $this->assertCount(0, $courses); $this->assertEquals(array(), array_keys($courses)); $courses = enrol_get_all_users_courses($user1->id); $this->assertCount(3, $courses); $this->assertEquals(array($course2->id, $course1->id, $course3->id), array_keys($courses)); $courses = enrol_get_all_users_courses($user1->id, true); $this->assertCount(2, $courses); $this->assertEquals(array($course2->id, $course3->id), array_keys($courses)); $courses = enrol_get_all_users_courses($user2->id); $this->assertCount(3, $courses); $this->assertEquals(array($course2->id, $course1->id, $course3->id), array_keys($courses)); $courses = enrol_get_all_users_courses($user2->id, true); $this->assertCount(2, $courses); $this->assertEquals(array($course2->id, $course3->id), array_keys($courses)); $courses = enrol_get_all_users_courses($user3->id); $this->assertCount(2, $courses); $this->assertEquals(array($course2->id, $course3->id), array_keys($courses)); $courses = enrol_get_all_users_courses($user3->id, true); $this->assertCount(1, $courses); $this->assertEquals(array($course2->id), array_keys($courses)); $courses = enrol_get_all_users_courses($user4->id); $this->assertCount(2, $courses); $this->assertEquals(array($course1->id, $course3->id), array_keys($courses)); $courses = enrol_get_all_users_courses($user4->id, true); $this->assertCount(0, $courses); $this->assertEquals(array(), array_keys($courses)); // Make sure sorting and columns work. $basefields = array('id', 'category', 'sortorder', 'shortname', 'fullname', 'idnumber', 'startdate', 'visible', 'groupmode', 'groupmodeforce', 'defaultgroupingid'); $courses = enrol_get_all_users_courses($user2->id, true); $course = reset($courses); context_helper::preload_from_record($course); $course = (array)$course; $this->assertEqualsCanonicalizing($basefields, array_keys($course)); $courses = enrol_get_all_users_courses($user2->id, false, 'timecreated'); $course = reset($courses); $this->assertTrue(property_exists($course, 'timecreated')); $courses = enrol_get_all_users_courses($user2->id, false, null, 'id DESC'); $this->assertEquals(array($course2->id, $course3->id, $course1->id), array_keys($courses)); // Make sure that implicit sorting defined in navsortmycoursessort is respected. $CFG->navsortmycoursessort = 'shortname'; $courses = enrol_get_all_users_courses($user1->id); $this->assertEquals(array($course2->id, $course3->id, $course1->id), array_keys($courses)); // But still the explicit sorting takes precedence over the implicit one. $courses = enrol_get_all_users_courses($user1->id, false, null, 'shortname DESC'); $this->assertEquals(array($course2->id, $course1->id, $course3->id), array_keys($courses)); // Make sure that implicit visibility sorting defined in navsortmycourseshiddenlast is respected for all course sortings. $CFG->navsortmycoursessort = 'sortorder'; $CFG->navsortmycourseshiddenlast = true; $courses = enrol_get_all_users_courses($user1->id); $this->assertEquals(array($course2->id, $course1->id, $course3->id), array_keys($courses)); $CFG->navsortmycoursessort = 'sortorder'; $CFG->navsortmycourseshiddenlast = false; $courses = enrol_get_all_users_courses($user1->id); $this->assertEquals(array($course1->id, $course3->id, $course2->id), array_keys($courses)); $CFG->navsortmycoursessort = 'fullname'; $CFG->navsortmycourseshiddenlast = true; $courses = enrol_get_all_users_courses($user1->id); $this->assertEquals(array($course2->id, $course1->id, $course3->id), array_keys($courses)); $CFG->navsortmycoursessort = 'fullname'; $CFG->navsortmycourseshiddenlast = false; $courses = enrol_get_all_users_courses($user1->id); $this->assertEquals(array($course1->id, $course2->id, $course3->id), array_keys($courses)); $CFG->navsortmycoursessort = 'shortname'; $CFG->navsortmycourseshiddenlast = true; $courses = enrol_get_all_users_courses($user1->id); $this->assertEquals(array($course2->id, $course3->id, $course1->id), array_keys($courses)); $CFG->navsortmycoursessort = 'shortname'; $CFG->navsortmycourseshiddenlast = false; $courses = enrol_get_all_users_courses($user1->id); $this->assertEquals(array($course2->id, $course3->id, $course1->id), array_keys($courses)); $CFG->navsortmycoursessort = 'idnumber'; $CFG->navsortmycourseshiddenlast = true; $courses = enrol_get_all_users_courses($user1->id); $this->assertEquals(array($course2->id, $course1->id, $course3->id), array_keys($courses)); $CFG->navsortmycoursessort = 'idnumber'; $CFG->navsortmycourseshiddenlast = false; $courses = enrol_get_all_users_courses($user1->id); $this->assertEquals(array($course1->id, $course3->id, $course2->id), array_keys($courses)); // But still the explicit visibility sorting takes precedence over the implicit one. $courses = enrol_get_all_users_courses($user1->id, false, null, 'visible DESC, shortname DESC'); $this->assertEquals(array($course2->id, $course1->id, $course3->id), array_keys($courses)); } /** * Test enrol_course_delete() without passing a user id. When a value for user id is not present, the method * should delete all enrolment related data in the course. */ public function test_enrol_course_delete_without_userid() { global $DB; $this->resetAfterTest(); // Create users. $user1 = $this->getDataGenerator()->create_user(); $user2 = $this->getDataGenerator()->create_user(); // Create a course. $course = $this->getDataGenerator()->create_course(); $coursecontext = context_course::instance($course->id); $studentrole = $DB->get_record('role', ['shortname' => 'student']); $manual = enrol_get_plugin('manual'); $manualinstance = $DB->get_record('enrol', ['courseid' => $course->id, 'enrol' => 'manual'], '*', MUST_EXIST); // Enrol user1 as a student in the course using manual enrolment. $manual->enrol_user($manualinstance, $user1->id, $studentrole->id); $self = enrol_get_plugin('self'); $selfinstance = $DB->get_record('enrol', ['courseid' => $course->id, 'enrol' => 'self'], '*', MUST_EXIST); $self->update_status($selfinstance, ENROL_INSTANCE_ENABLED); // Enrol user2 as a student in the course using self enrolment. $self->enrol_user($selfinstance, $user2->id, $studentrole->id); // Delete all enrolment related records in the course. enrol_course_delete($course); // The course enrolment of user1 should not exists. $user1enrolment = $DB->get_record('user_enrolments', ['enrolid' => $manualinstance->id, 'userid' => $user1->id]); $this->assertFalse($user1enrolment); // The role assignment of user1 should not exists. $user1roleassignment = $DB->get_record('role_assignments', ['roleid' => $studentrole->id, 'userid'=> $user1->id, 'contextid' => $coursecontext->id] ); $this->assertFalse($user1roleassignment); // The course enrolment of user2 should not exists. $user2enrolment = $DB->get_record('user_enrolments', ['enrolid' => $selfinstance->id, 'userid' => $user2->id]); $this->assertFalse($user2enrolment); // The role assignment of user2 should not exists. $user2roleassignment = $DB->get_record('role_assignments', ['roleid' => $studentrole->id, 'userid'=> $user2->id, 'contextid' => $coursecontext->id]); $this->assertFalse($user2roleassignment); // All existing course enrolment instances should not exists. $enrolmentinstances = enrol_get_instances($course->id, false); $this->assertCount(0, $enrolmentinstances); } /** * Test enrol_course_delete() when user id is present. * When a value for user id is present, the method should make sure the user has the proper capability to * un-enrol users before removing the enrolment data. If the capabilities are missing the data should not be removed. * * @dataProvider enrol_course_delete_with_userid_provider * @param array $excludedcapabilities The capabilities that should be excluded from the user's role * @param bool $expected The expected results */ public function test_enrol_course_delete_with_userid($excludedcapabilities, $expected) { global $DB; $this->resetAfterTest(); // Create users. $user1 = $this->getDataGenerator()->create_user(); $user2 = $this->getDataGenerator()->create_user(); $user3 = $this->getDataGenerator()->create_user(); // Create a course. $course = $this->getDataGenerator()->create_course(); $coursecontext = context_course::instance($course->id); $studentrole = $DB->get_record('role', ['shortname' => 'student']); $editingteacherrole = $DB->get_record('role', ['shortname' => 'editingteacher']); $manual = enrol_get_plugin('manual'); $manualinstance = $DB->get_record('enrol', ['courseid' => $course->id, 'enrol' => 'manual'], '*', MUST_EXIST); // Enrol user1 as a student in the course using manual enrolment. $manual->enrol_user($manualinstance, $user1->id, $studentrole->id); // Enrol user3 as an editing teacher in the course using manual enrolment. // By default, the editing teacher role has the capability to un-enroll users which have been enrolled using // the existing enrolment methods. $manual->enrol_user($manualinstance, $user3->id, $editingteacherrole->id); $self = enrol_get_plugin('self'); $selfinstance = $DB->get_record('enrol', ['courseid' => $course->id, 'enrol' => 'self'], '*', MUST_EXIST); $self->update_status($selfinstance, ENROL_INSTANCE_ENABLED); // Enrol user2 as a student in the course using self enrolment. $self->enrol_user($selfinstance, $user2->id, $studentrole->id); foreach($excludedcapabilities as $capability) { // Un-assign the given capability from the editing teacher role. unassign_capability($capability, $editingteacherrole->id); } // Delete only enrolment related records in the course where user3 has the required capability. enrol_course_delete($course, $user3->id); // Check the existence of the course enrolment of user1. $user1enrolmentexists = (bool) $DB->count_records('user_enrolments', ['enrolid' => $manualinstance->id, 'userid' => $user1->id]); $this->assertEquals($expected['User 1 course enrolment exists'], $user1enrolmentexists); // Check the existence of the role assignment of user1 in the course. $user1roleassignmentexists = (bool) $DB->count_records('role_assignments', ['roleid' => $studentrole->id, 'userid' => $user1->id, 'contextid' => $coursecontext->id]); $this->assertEquals($expected['User 1 role assignment exists'], $user1roleassignmentexists); // Check the existence of the course enrolment of user2. $user2enrolmentexists = (bool) $DB->count_records('user_enrolments', ['enrolid' => $selfinstance->id, 'userid' => $user2->id]); $this->assertEquals($expected['User 2 course enrolment exists'], $user2enrolmentexists); // Check the existence of the role assignment of user2 in the course. $user2roleassignmentexists = (bool) $DB->count_records('role_assignments', ['roleid' => $studentrole->id, 'userid' => $user2->id, 'contextid' => $coursecontext->id]); $this->assertEquals($expected['User 2 role assignment exists'], $user2roleassignmentexists); // Check the existence of the course enrolment of user3. $user3enrolmentexists = (bool) $DB->count_records('user_enrolments', ['enrolid' => $manualinstance->id, 'userid' => $user3->id]); $this->assertEquals($expected['User 3 course enrolment exists'], $user3enrolmentexists); // Check the existence of the role assignment of user3 in the course. $user3roleassignmentexists = (bool) $DB->count_records('role_assignments', ['roleid' => $editingteacherrole->id, 'userid' => $user3->id, 'contextid' => $coursecontext->id]); $this->assertEquals($expected['User 3 role assignment exists'], $user3roleassignmentexists); // Check the existence of the manual enrolment instance in the course. $manualinstance = (bool) $DB->count_records('enrol', ['enrol' => 'manual', 'courseid' => $course->id]); $this->assertEquals($expected['Manual course enrolment instance exists'], $manualinstance); // Check existence of the self enrolment instance in the course. $selfinstance = (bool) $DB->count_records('enrol', ['enrol' => 'self', 'courseid' => $course->id]); $this->assertEquals($expected['Self course enrolment instance exists'], $selfinstance); } /** * Data provider for test_enrol_course_delete_with_userid(). * * @return array */ public function enrol_course_delete_with_userid_provider() { return [ 'The teacher can un-enrol users in a course' => [ 'excludedcapabilities' => [], 'results' => [ // Whether certain enrolment related data still exists in the course after the deletion. // When the user has the capabilities to un-enrol users and the enrolment plugins allow manual // unenerolment than all course enrolment data should be removed. 'Manual course enrolment instance exists' => false, 'Self course enrolment instance exists' => false, 'User 1 course enrolment exists' => false, 'User 1 role assignment exists' => false, 'User 2 course enrolment exists' => false, 'User 2 role assignment exists' => false, 'User 3 course enrolment exists' => false, 'User 3 role assignment exists' => false ], ], 'The teacher cannot un-enrol self enrolled users' => [ 'excludedcapabilities' => [ // Exclude the following capabilities for the editing teacher. 'enrol/self:unenrol' ], 'results' => [ // When the user does not have the capabilities to un-enrol self enrolled users, the data // related to this enrolment method should not be removed. Everything else should be removed. 'Manual course enrolment instance exists' => false, 'Self course enrolment instance exists' => true, 'User 1 course enrolment exists' => false, 'User 1 role assignment exists' => false, 'User 2 course enrolment exists' => true, 'User 2 role assignment exists' => true, 'User 3 course enrolment exists' => false, 'User 3 role assignment exists' => false ], ], 'The teacher cannot un-enrol self and manually enrolled users' => [ 'excludedcapabilities' => [ // Exclude the following capabilities for the editing teacher. 'enrol/manual:unenrol', 'enrol/self:unenrol' ], 'results' => [ // When the user does not have the capabilities to un-enrol self and manually enrolled users, // the data related to these enrolment methods should not be removed. 'Manual course enrolment instance exists' => true, 'Self course enrolment instance exists' => true, 'User 1 course enrolment exists' => true, 'User 1 role assignment exists' => true, 'User 2 course enrolment exists' => true, 'User 2 role assignment exists' => true, 'User 3 course enrolment exists' => true, 'User 3 role assignment exists' => true ], ], ]; } public function test_enrol_user_sees_own_courses() { global $DB, $CFG; $this->resetAfterTest(); $studentrole = $DB->get_record('role', array('shortname'=>'student')); $this->assertNotEmpty($studentrole); $teacherrole = $DB->get_record('role', array('shortname'=>'teacher')); $this->assertNotEmpty($teacherrole); $admin = get_admin(); $user1 = $this->getDataGenerator()->create_user(); $user2 = $this->getDataGenerator()->create_user(); $user3 = $this->getDataGenerator()->create_user(); $user4 = $this->getDataGenerator()->create_user(); $user5 = $this->getDataGenerator()->create_user(); $user6 = $this->getDataGenerator()->create_user(); $category1 = $this->getDataGenerator()->create_category(array('visible'=>0)); $category2 = $this->getDataGenerator()->create_category(); $course1 = $this->getDataGenerator()->create_course(array('category'=>$category1->id)); $course2 = $this->getDataGenerator()->create_course(array('category'=>$category2->id)); $course3 = $this->getDataGenerator()->create_course(array('category'=>$category2->id, 'visible'=>0)); $course4 = $this->getDataGenerator()->create_course(array('category'=>$category2->id)); $maninstance1 = $DB->get_record('enrol', array('courseid'=>$course1->id, 'enrol'=>'manual'), '*', MUST_EXIST); $DB->set_field('enrol', 'status', ENROL_INSTANCE_DISABLED, array('id'=>$maninstance1->id)); $maninstance1 = $DB->get_record('enrol', array('courseid'=>$course1->id, 'enrol'=>'manual'), '*', MUST_EXIST); $maninstance2 = $DB->get_record('enrol', array('courseid'=>$course2->id, 'enrol'=>'manual'), '*', MUST_EXIST); $maninstance3 = $DB->get_record('enrol', array('courseid'=>$course3->id, 'enrol'=>'manual'), '*', MUST_EXIST); $maninstance4 = $DB->get_record('enrol', array('courseid'=>$course4->id, 'enrol'=>'manual'), '*', MUST_EXIST); $manual = enrol_get_plugin('manual'); $this->assertNotEmpty($manual); $manual->enrol_user($maninstance1, $admin->id, $studentrole->id); $manual->enrol_user($maninstance3, $user1->id, $teacherrole->id); $manual->enrol_user($maninstance2, $user2->id, $studentrole->id); $manual->enrol_user($maninstance1, $user3->id, $studentrole->id, 1, time()+(60*60)); $manual->enrol_user($maninstance2, $user3->id, 0, 1, time()-(60*60)); $manual->enrol_user($maninstance3, $user2->id, $studentrole->id); $manual->enrol_user($maninstance4, $user2->id, 0, 0, 0, ENROL_USER_SUSPENDED); $manual->enrol_user($maninstance1, $user4->id, $teacherrole->id, 0, 0, ENROL_USER_SUSPENDED); $manual->enrol_user($maninstance3, $user4->id, 0, 0, 0, ENROL_USER_SUSPENDED); $this->assertFalse(enrol_user_sees_own_courses($CFG->siteguest)); $this->assertFalse(enrol_user_sees_own_courses(0)); $this->assertFalse(enrol_user_sees_own_courses($admin)); $this->assertFalse(enrol_user_sees_own_courses(-222)); // Nonexistent user. $this->assertTrue(enrol_user_sees_own_courses($user1)); $this->assertTrue(enrol_user_sees_own_courses($user2->id)); $this->assertFalse(enrol_user_sees_own_courses($user3->id)); $this->assertFalse(enrol_user_sees_own_courses($user4)); $this->assertFalse(enrol_user_sees_own_courses($user5)); $this->setAdminUser(); $this->assertFalse(enrol_user_sees_own_courses()); $this->setGuestUser(); $this->assertFalse(enrol_user_sees_own_courses()); $this->setUser(0); $this->assertFalse(enrol_user_sees_own_courses()); $this->setUser($user1); $this->assertTrue(enrol_user_sees_own_courses()); $this->setUser($user2); $this->assertTrue(enrol_user_sees_own_courses()); $this->setUser($user3); $this->assertFalse(enrol_user_sees_own_courses()); $this->setUser($user4); $this->assertFalse(enrol_user_sees_own_courses()); $this->setUser($user5); $this->assertFalse(enrol_user_sees_own_courses()); $user1 = $DB->get_record('user', array('id'=>$user1->id)); $this->setUser($user1); $reads = $DB->perf_get_reads(); $this->assertTrue(enrol_user_sees_own_courses()); $this->assertGreaterThan($reads, $DB->perf_get_reads()); $user1 = $DB->get_record('user', array('id'=>$user1->id)); $this->setUser($user1); require_login($course3); $reads = $DB->perf_get_reads(); $this->assertTrue(enrol_user_sees_own_courses()); $this->assertEquals($reads, $DB->perf_get_reads()); } public function test_enrol_get_shared_courses() { $this->resetAfterTest(); $user1 = $this->getDataGenerator()->create_user(); $user2 = $this->getDataGenerator()->create_user(); $user3 = $this->getDataGenerator()->create_user(); $course1 = $this->getDataGenerator()->create_course(); $this->getDataGenerator()->enrol_user($user1->id, $course1->id); $this->getDataGenerator()->enrol_user($user2->id, $course1->id); $course2 = $this->getDataGenerator()->create_course(); $this->getDataGenerator()->enrol_user($user1->id, $course2->id); // Test that user1 and user2 have courses in common. $this->assertTrue(enrol_get_shared_courses($user1, $user2, false, true)); // Test that user1 and user3 have no courses in common. $this->assertFalse(enrol_get_shared_courses($user1, $user3, false, true)); // Test retrieving the courses in common. $sharedcourses = enrol_get_shared_courses($user1, $user2, true); // Only should be one shared course. $this->assertCount(1, $sharedcourses); $sharedcourse = array_shift($sharedcourses); // It should be course 1. $this->assertEquals($sharedcourse->id, $course1->id); } public function test_enrol_get_shared_courses_different_methods() { global $DB, $CFG; require_once($CFG->dirroot . '/enrol/self/externallib.php'); $this->resetAfterTest(); $user1 = $this->getDataGenerator()->create_user(); $user2 = $this->getDataGenerator()->create_user(); $user3 = $this->getDataGenerator()->create_user(); $course1 = $this->getDataGenerator()->create_course(); // Enrol user1 and user2 in course1 with a different enrolment methode. // Add self enrolment method for course1. $selfplugin = enrol_get_plugin('self'); $this->assertNotEmpty($selfplugin); $studentrole = $DB->get_record('role', array('shortname' => 'student')); $this->assertNotEmpty($studentrole); $instance1id = $selfplugin->add_instance($course1, array('status' => ENROL_INSTANCE_ENABLED, 'name' => 'Test instance 1', 'customint6' => 1, 'roleid' => $studentrole->id)); $instance1 = $DB->get_record('enrol', array('id' => $instance1id), '*', MUST_EXIST); self::setUser($user2); // Self enrol me (user2). $result = enrol_self_external::enrol_user($course1->id); // Enrol user1 manually. $this->getDataGenerator()->enrol_user($user1->id, $course1->id, null, 'manual'); $course2 = $this->getDataGenerator()->create_course(); $this->getDataGenerator()->enrol_user($user1->id, $course2->id); $course3 = $this->getDataGenerator()->create_course(); $this->getDataGenerator()->enrol_user($user2->id, $course3->id); // Test that user1 and user2 have courses in common. $this->assertTrue(enrol_get_shared_courses($user1, $user2, false, true)); // Test that user1 and user3 have no courses in common. $this->assertFalse(enrol_get_shared_courses($user1, $user3, false, true)); // Test retrieving the courses in common. $sharedcourses = enrol_get_shared_courses($user1, $user2, true); // Only should be one shared course. $this->assertCount(1, $sharedcourses); $sharedcourse = array_shift($sharedcourses); // It should be course 1. $this->assertEquals($sharedcourse->id, $course1->id); } /** * Test user enrolment created event. */ public function test_user_enrolment_created_event() { global $DB; $this->resetAfterTest(); $studentrole = $DB->get_record('role', array('shortname'=>'student')); $this->assertNotEmpty($studentrole); $admin = get_admin(); $course1 = $this->getDataGenerator()->create_course(); $maninstance1 = $DB->get_record('enrol', array('courseid'=>$course1->id, 'enrol'=>'manual'), '*', MUST_EXIST); $manual = enrol_get_plugin('manual'); $this->assertNotEmpty($manual); // Enrol user and capture event. $sink = $this->redirectEvents(); $manual->enrol_user($maninstance1, $admin->id, $studentrole->id); $events = $sink->get_events(); $sink->close(); $event = array_shift($events); $dbuserenrolled = $DB->get_record('user_enrolments', array('userid' => $admin->id)); $this->assertInstanceOf('\core\event\user_enrolment_created', $event); $this->assertEquals($dbuserenrolled->id, $event->objectid); $this->assertEquals(context_course::instance($course1->id), $event->get_context()); $this->assertEquals('user_enrolled', $event->get_legacy_eventname()); $expectedlegacyeventdata = $dbuserenrolled; $expectedlegacyeventdata->enrol = $manual->get_name(); $expectedlegacyeventdata->courseid = $course1->id; $this->assertEventLegacyData($expectedlegacyeventdata, $event); $expected = array($course1->id, 'course', 'enrol', '../enrol/users.php?id=' . $course1->id, $course1->id); $this->assertEventLegacyLogData($expected, $event); $this->assertEventContextNotUsed($event); } /** * Test user_enrolment_deleted event. */ public function test_user_enrolment_deleted_event() { global $DB; $this->resetAfterTest(true); $manualplugin = enrol_get_plugin('manual'); $user = $this->getDataGenerator()->create_user(); $course = $this->getDataGenerator()->create_course(); $student = $DB->get_record('role', array('shortname' => 'student')); $enrol = $DB->get_record('enrol', array('courseid' => $course->id, 'enrol' => 'manual'), '*', MUST_EXIST); // Enrol user. $manualplugin->enrol_user($enrol, $user->id, $student->id); // Get the user enrolment information, used to validate legacy event data. $dbuserenrolled = $DB->get_record('user_enrolments', array('userid' => $user->id)); // Unenrol user and capture event. $sink = $this->redirectEvents(); $manualplugin->unenrol_user($enrol, $user->id); $events = $sink->get_events(); $sink->close(); $event = array_pop($events); // Validate the event. $this->assertInstanceOf('\core\event\user_enrolment_deleted', $event); $this->assertEquals(context_course::instance($course->id), $event->get_context()); $this->assertEquals('user_unenrolled', $event->get_legacy_eventname()); $expectedlegacyeventdata = $dbuserenrolled; $expectedlegacyeventdata->enrol = $manualplugin->get_name(); $expectedlegacyeventdata->courseid = $course->id; $expectedlegacyeventdata->lastenrol = true; $this->assertEventLegacyData($expectedlegacyeventdata, $event); $expected = array($course->id, 'course', 'unenrol', '../enrol/users.php?id=' . $course->id, $course->id); $this->assertEventLegacyLogData($expected, $event); $this->assertEventContextNotUsed($event); } /** * Test enrol_instance_created, enrol_instance_updated and enrol_instance_deleted events. */ public function test_instance_events() { global $DB; $this->resetAfterTest(true); $selfplugin = enrol_get_plugin('self'); $studentrole = $DB->get_record('role', array('shortname' => 'student')); $course = $this->getDataGenerator()->create_course(); // Creating enrol instance. $sink = $this->redirectEvents(); $instanceid = $selfplugin->add_instance($course, array('status' => ENROL_INSTANCE_ENABLED, 'name' => 'Test instance 1', 'customint6' => 1, 'roleid' => $studentrole->id)); $events = $sink->get_events(); $sink->close(); $this->assertCount(1, $events); $event = array_pop($events); $this->assertInstanceOf('\core\event\enrol_instance_created', $event); $this->assertEquals(context_course::instance($course->id), $event->get_context()); $this->assertEquals('self', $event->other['enrol']); $this->assertEventContextNotUsed($event); // Updating enrol instance. $instance = $DB->get_record('enrol', array('id' => $instanceid)); $sink = $this->redirectEvents(); $selfplugin->update_status($instance, ENROL_INSTANCE_DISABLED); $events = $sink->get_events(); $sink->close(); $this->assertCount(1, $events); $event = array_pop($events); $this->assertInstanceOf('\core\event\enrol_instance_updated', $event); $this->assertEquals(context_course::instance($course->id), $event->get_context()); $this->assertEquals('self', $event->other['enrol']); $this->assertEventContextNotUsed($event); // Deleting enrol instance. $instance = $DB->get_record('enrol', array('id' => $instanceid)); $sink = $this->redirectEvents(); $selfplugin->delete_instance($instance); $events = $sink->get_events(); $sink->close(); $this->assertCount(1, $events); $event = array_pop($events); $this->assertInstanceOf('\core\event\enrol_instance_deleted', $event); $this->assertEquals(context_course::instance($course->id), $event->get_context()); $this->assertEquals('self', $event->other['enrol']); $this->assertEventContextNotUsed($event); } /** * Confirms that timemodified field was updated after modification of user enrollment */ public function test_enrollment_update_timemodified() { global $DB; $this->resetAfterTest(true); $datagen = $this->getDataGenerator(); /** @var enrol_manual_plugin $manualplugin */ $manualplugin = enrol_get_plugin('manual'); $this->assertNotNull($manualplugin); $studentroleid = $DB->get_field('role', 'id', ['shortname' => 'student'], MUST_EXIST); $course = $datagen->create_course(); $user = $datagen->create_user(); $instanceid = null; $instances = enrol_get_instances($course->id, true); foreach ($instances as $inst) { if ($inst->enrol == 'manual') { $instanceid = (int)$inst->id; break; } } if (empty($instanceid)) { $instanceid = $manualplugin->add_default_instance($course); if (empty($instanceid)) { $instanceid = $manualplugin->add_instance($course); } } $this->assertNotNull($instanceid); $instance = $DB->get_record('enrol', ['id' => $instanceid], '*', MUST_EXIST); $manualplugin->enrol_user($instance, $user->id, $studentroleid, 0, 0, ENROL_USER_ACTIVE); $userenrolorig = (int)$DB->get_field( 'user_enrolments', 'timemodified', ['enrolid' => $instance->id, 'userid' => $user->id], MUST_EXIST ); $this->waitForSecond(); $this->waitForSecond(); $manualplugin->update_user_enrol($instance, $user->id, ENROL_USER_SUSPENDED); $userenrolpost = (int)$DB->get_field( 'user_enrolments', 'timemodified', ['enrolid' => $instance->id, 'userid' => $user->id], MUST_EXIST ); $this->assertGreaterThan($userenrolorig, $userenrolpost); } /** * Test to confirm that enrol_get_my_courses only return the courses that * the logged in user is enrolled in. */ public function test_enrol_get_my_courses_only_enrolled_courses() { $user = $this->getDataGenerator()->create_user(); $course1 = $this->getDataGenerator()->create_course(); $course2 = $this->getDataGenerator()->create_course(); $course3 = $this->getDataGenerator()->create_course(); $course4 = $this->getDataGenerator()->create_course(); $this->getDataGenerator()->enrol_user($user->id, $course1->id); $this->getDataGenerator()->enrol_user($user->id, $course2->id); $this->getDataGenerator()->enrol_user($user->id, $course3->id); $this->resetAfterTest(true); $this->setUser($user); // By default this function should return all of the courses the user // is enrolled in. $courses = enrol_get_my_courses(); $this->assertCount(3, $courses); $this->assertEquals($course1->id, $courses[$course1->id]->id); $this->assertEquals($course2->id, $courses[$course2->id]->id); $this->assertEquals($course3->id, $courses[$course3->id]->id); // If a set of course ids are provided then the result set will only contain // these courses. $courseids = [$course1->id, $course2->id]; $courses = enrol_get_my_courses(['id'], 'visible DESC,sortorder ASC', 0, $courseids); $this->assertCount(2, $courses); $this->assertEquals($course1->id, $courses[$course1->id]->id); $this->assertEquals($course2->id, $courses[$course2->id]->id); // If the course ids list contains any ids for courses the user isn't enrolled in // then they will be ignored (in this case $course4). $courseids = [$course1->id, $course2->id, $course4->id]; $courses = enrol_get_my_courses(['id'], 'visible DESC,sortorder ASC', 0, $courseids); $this->assertCount(2, $courses); $this->assertEquals($course1->id, $courses[$course1->id]->id); $this->assertEquals($course2->id, $courses[$course2->id]->id); } /** * Tests the enrol_get_my_courses function when using the $includehidden parameter, which * should remove any courses hidden from the user's timeline * * @throws coding_exception * @throws dml_exception */ public function test_enrol_get_my_courses_include_hidden() { global $DB, $CFG; $this->resetAfterTest(true); // Create test user and 4 courses, two of which have guest access enabled. $user = $this->getDataGenerator()->create_user(); $course1 = $this->getDataGenerator()->create_course( (object)array('shortname' => 'X', 'enrol_guest_status_0' => ENROL_INSTANCE_DISABLED, 'enrol_guest_password_0' => '')); $course2 = $this->getDataGenerator()->create_course( (object)array('shortname' => 'Z', 'enrol_guest_status_0' => ENROL_INSTANCE_ENABLED, 'enrol_guest_password_0' => '')); $course3 = $this->getDataGenerator()->create_course( (object)array('shortname' => 'Y', 'enrol_guest_status_0' => ENROL_INSTANCE_ENABLED, 'enrol_guest_password_0' => 'frog')); $course4 = $this->getDataGenerator()->create_course( (object)array('shortname' => 'W', 'enrol_guest_status_0' => ENROL_INSTANCE_DISABLED, 'enrol_guest_password_0' => '')); // User is enrolled in first course. $this->getDataGenerator()->enrol_user($user->id, $course1->id); $this->getDataGenerator()->enrol_user($user->id, $course2->id); $this->getDataGenerator()->enrol_user($user->id, $course3->id); $this->getDataGenerator()->enrol_user($user->id, $course4->id); // Check enrol_get_my_courses basic use (without include hidden provided). $this->setUser($user); $courses = enrol_get_my_courses(); $this->assertEquals([$course4->id, $course3->id, $course2->id, $course1->id], array_keys($courses)); // Hide a course. set_user_preference('block_myoverview_hidden_course_' . $course3->id, true); // Hidden course shouldn't be returned. $courses = enrol_get_my_courses(null, null, 0, [], false, 0, [$course3->id]); $this->assertEquals([$course4->id, $course2->id, $course1->id], array_keys($courses)); // Offset should take into account hidden course. $courses = enrol_get_my_courses(null, null, 0, [], false, 2, [$course3->id]); $this->assertEquals([$course1->id], array_keys($courses)); } /** * Tests the enrol_get_my_courses function when using the $allaccessible parameter, which * includes a wider range of courses (enrolled courses + other accessible ones). */ public function test_enrol_get_my_courses_all_accessible() { global $DB, $CFG; $this->resetAfterTest(true); // Create test user and 4 courses, two of which have guest access enabled. $user = $this->getDataGenerator()->create_user(); $course1 = $this->getDataGenerator()->create_course( (object)array('shortname' => 'X', 'enrol_guest_status_0' => ENROL_INSTANCE_DISABLED, 'enrol_guest_password_0' => '')); $course2 = $this->getDataGenerator()->create_course( (object)array('shortname' => 'Z', 'enrol_guest_status_0' => ENROL_INSTANCE_ENABLED, 'enrol_guest_password_0' => '')); $course3 = $this->getDataGenerator()->create_course( (object)array('shortname' => 'Y', 'enrol_guest_status_0' => ENROL_INSTANCE_ENABLED, 'enrol_guest_password_0' => 'frog')); $course4 = $this->getDataGenerator()->create_course( (object)array('shortname' => 'W', 'enrol_guest_status_0' => ENROL_INSTANCE_DISABLED, 'enrol_guest_password_0' => '')); // User is enrolled in first course. $this->getDataGenerator()->enrol_user($user->id, $course1->id); // Check enrol_get_my_courses basic use (without all accessible). $this->setUser($user); $courses = enrol_get_my_courses(); $this->assertEquals([$course1->id], array_keys($courses)); // Turn on all accessible, now they can access the second course too. $courses = enrol_get_my_courses(null, 'id', 0, [], true); $this->assertEquals([$course1->id, $course2->id], array_keys($courses)); // Log in as guest to third course. load_temp_course_role(context_course::instance($course3->id), $CFG->guestroleid); $courses = enrol_get_my_courses(null, 'id', 0, [], true); $this->assertEquals([$course1->id, $course2->id, $course3->id], array_keys($courses)); // Check fields parameter still works. Fields default (certain base fields). $this->assertObjectHasAttribute('id', $courses[$course3->id]); $this->assertObjectHasAttribute('shortname', $courses[$course3->id]); $this->assertObjectNotHasAttribute('summary', $courses[$course3->id]); // Specified fields (one, string). $courses = enrol_get_my_courses('summary', 'id', 0, [], true); $this->assertObjectHasAttribute('id', $courses[$course3->id]); $this->assertObjectHasAttribute('shortname', $courses[$course3->id]); $this->assertObjectHasAttribute('summary', $courses[$course3->id]); $this->assertObjectNotHasAttribute('summaryformat', $courses[$course3->id]); // Specified fields (two, string). $courses = enrol_get_my_courses('summary, summaryformat', 'id', 0, [], true); $this->assertObjectHasAttribute('summary', $courses[$course3->id]); $this->assertObjectHasAttribute('summaryformat', $courses[$course3->id]); // Specified fields (two, array). $courses = enrol_get_my_courses(['summary', 'summaryformat'], 'id', 0, [], true); $this->assertObjectHasAttribute('summary', $courses[$course3->id]); $this->assertObjectHasAttribute('summaryformat', $courses[$course3->id]); // By default, courses are ordered by sortorder - which by default is most recent first. $courses = enrol_get_my_courses(null, null, 0, [], true); $this->assertEquals([$course3->id, $course2->id, $course1->id], array_keys($courses)); // Make sure that implicit sorting defined in navsortmycoursessort is respected. $CFG->navsortmycoursessort = 'shortname'; $courses = enrol_get_my_courses(null, null, 0, [], true); $this->assertEquals([$course1->id, $course3->id, $course2->id], array_keys($courses)); // But still the explicit sorting takes precedence over the implicit one. $courses = enrol_get_my_courses(null, 'shortname DESC', 0, [], true); $this->assertEquals([$course2->id, $course3->id, $course1->id], array_keys($courses)); // Check filter parameter still works. $courses = enrol_get_my_courses(null, 'id', 0, [$course2->id, $course3->id, $course4->id], true); $this->assertEquals([$course2->id, $course3->id], array_keys($courses)); // Check limit parameter. $courses = enrol_get_my_courses(null, 'id', 2, [], true); $this->assertEquals([$course1->id, $course2->id], array_keys($courses)); // Now try access for a different user who has manager role at system level. $manager = $this->getDataGenerator()->create_user(); $managerroleid = $DB->get_field('role', 'id', ['shortname' => 'manager']); role_assign($managerroleid, $manager->id, \context_system::instance()->id); $this->setUser($manager); // With default get enrolled, they don't have any courses. $courses = enrol_get_my_courses(); $this->assertCount(0, $courses); // But with all accessible, they have 4 because they have moodle/course:view everywhere. $courses = enrol_get_my_courses(null, 'id', 0, [], true); $this->assertEquals([$course1->id, $course2->id, $course3->id, $course4->id], array_keys($courses)); // If we prohibit manager from course:view on course 1 though... assign_capability('moodle/course:view', CAP_PROHIBIT, $managerroleid, \context_course::instance($course1->id)); $courses = enrol_get_my_courses(null, 'id', 0, [], true); $this->assertEquals([$course2->id, $course3->id, $course4->id], array_keys($courses)); // Check for admin user, which has a slightly different query. $this->setAdminUser(); $courses = enrol_get_my_courses(null, 'id', 0, [], true); $this->assertEquals([$course1->id, $course2->id, $course3->id, $course4->id], array_keys($courses)); } /** * Data provider for {@see test_enrol_get_my_courses_by_time} * * @return array */ public function enrol_get_my_courses_by_time_provider(): array { return [ 'No start or end time' => [null, null, true], 'Start time now, no end time' => [0, null, true], 'Start time now, end time in the future' => [0, MINSECS, true], 'Start time in the past, no end time' => [-MINSECS, null, true], 'Start time in the past, end time in the future' => [-MINSECS, MINSECS, true], 'Start time in the past, end time in the past' => [-DAYSECS, -HOURSECS, false], 'Start time in the future' => [MINSECS, null, false], ]; } /** * Test that expected course enrolments are returned when they have timestart / timeend specified * * @param int|null $timestartoffset Null for 0, otherwise offset from current time * @param int|null $timeendoffset Null for 0, otherwise offset from current time * @param bool $expectreturn * * @dataProvider enrol_get_my_courses_by_time_provider */ public function test_enrol_get_my_courses_by_time(?int $timestartoffset, ?int $timeendoffset, bool $expectreturn): void { $this->resetAfterTest(); $time = time(); $timestart = $timestartoffset === null ? 0 : $time + $timestartoffset; $timeend = $timeendoffset === null ? 0 : $time + $timeendoffset; $course = $this->getDataGenerator()->create_course(); $user = $this->getDataGenerator()->create_and_enrol($course, 'student', null, 'manual', $timestart, $timeend); $this->setUser($user); $courses = enrol_get_my_courses(); if ($expectreturn) { $this->assertCount(1, $courses); $this->assertEquals($course->id, reset($courses)->id); } else { $this->assertEmpty($courses); } } /** * test_course_users * * @return void */ public function test_course_users() { $this->resetAfterTest(); $user1 = $this->getDataGenerator()->create_user(); $user2 = $this->getDataGenerator()->create_user(); $course1 = $this->getDataGenerator()->create_course(); $course2 = $this->getDataGenerator()->create_course(); $this->getDataGenerator()->enrol_user($user1->id, $course1->id); $this->getDataGenerator()->enrol_user($user2->id, $course1->id); $this->getDataGenerator()->enrol_user($user1->id, $course2->id); $this->assertCount(2, enrol_get_course_users($course1->id)); $this->assertCount(2, enrol_get_course_users($course1->id, true)); $this->assertCount(1, enrol_get_course_users($course1->id, true, array($user1->id))); $this->assertCount(2, enrol_get_course_users(false, false, array($user1->id))); $instances = enrol_get_instances($course1->id, true); $manualinstance = reset($instances); $manualplugin = enrol_get_plugin('manual'); $manualplugin->update_user_enrol($manualinstance, $user1->id, ENROL_USER_SUSPENDED); $this->assertCount(2, enrol_get_course_users($course1->id, false)); $this->assertCount(1, enrol_get_course_users($course1->id, true)); } /** * test_course_users in groups * * @covers \enrol_get_course_users() * @return void */ public function test_course_users_in_groups() { $this->resetAfterTest(); $user1 = $this->getDataGenerator()->create_user(); $user2 = $this->getDataGenerator()->create_user(); $user3 = $this->getDataGenerator()->create_user(); $course = $this->getDataGenerator()->create_course(); $group1 = $this->getDataGenerator()->create_group(['courseid' => $course->id]); $group2 = $this->getDataGenerator()->create_group(['courseid' => $course->id]); $this->getDataGenerator()->enrol_user($user1->id, $course->id); $this->getDataGenerator()->enrol_user($user2->id, $course->id); $this->getDataGenerator()->enrol_user($user3->id, $course->id); $this->getDataGenerator()->create_group_member(['groupid' => $group1->id, 'userid' => $user1->id]); $this->getDataGenerator()->create_group_member(['groupid' => $group2->id, 'userid' => $user1->id]); $this->getDataGenerator()->create_group_member(['groupid' => $group2->id, 'userid' => $user2->id]); $this->assertCount(3, enrol_get_course_users($course->id)); $this->assertCount(1, enrol_get_course_users($course->id, false, [], [], [$group1->id])); $this->assertCount(2, enrol_get_course_users($course->id, false, [], [], [$group2->id])); $instances = enrol_get_instances($course->id, true); $manualinstance = reset($instances); $manualplugin = enrol_get_plugin('manual'); $manualplugin->update_user_enrol($manualinstance, $user1->id, ENROL_USER_SUSPENDED); $this->assertCount(2, enrol_get_course_users($course->id, false, [], [], [$group2->id])); $this->assertCount(1, enrol_get_course_users($course->id, true, [], [], [$group2->id])); } /** * Test count of enrolled users * * @return void */ public function test_count_enrolled_users() { global $DB; $this->resetAfterTest(true); $course = $this->getDataGenerator()->create_course(); $context = \context_course::instance($course->id); $user1 = $this->getDataGenerator()->create_user(); $user2 = $this->getDataGenerator()->create_user(); $studentrole = $DB->get_record('role', ['shortname' => 'student']); // Add each user to the manual enrolment instance. $manual = enrol_get_plugin('manual'); $manualinstance = $DB->get_record('enrol', ['courseid' => $course->id, 'enrol' => 'manual'], '*', MUST_EXIST); $manual->enrol_user($manualinstance, $user1->id, $studentrole->id); $manual->enrol_user($manualinstance, $user2->id, $studentrole->id); $this->assertEquals(2, count_enrolled_users($context)); // Create a self enrolment instance, enrol first user only. $self = enrol_get_plugin('self'); $selfid = $self->add_instance($course, ['status' => ENROL_INSTANCE_ENABLED, 'name' => 'Self', 'customint6' => 1, 'roleid' => $studentrole->id]); $selfinstance = $DB->get_record('enrol', ['id' => $selfid], '*', MUST_EXIST); $self->enrol_user($selfinstance, $user1->id, $studentrole->id); // There are still only two distinct users. $this->assertEquals(2, count_enrolled_users($context)); } /** * Test cases for the test_enrol_get_my_courses_sort_by_last_access test. */ public function get_enrol_get_my_courses_sort_by_last_access_test_cases() { $now = time(); $enrolledcoursesdata = [ ['shortname' => 'a', 'lastaccess' => $now - 2], ['shortname' => 'b', 'lastaccess' => $now - 1], ['shortname' => 'c', 'lastaccess' => $now], ['shortname' => 'd', 'lastaccess' => $now - 1], ['shortname' => 'e'] ]; $unenrolledcoursesdata = [ ['shortname' => 'x', 'lastaccess' => $now - 2], ['shortname' => 'y', 'lastaccess' => $now - 1], ['shortname' => 'z', 'lastaccess' => $now] ]; return [ 'empty set' => [ 'enrolledcoursesdata' => [], 'unenrolledcoursesdata' => $unenrolledcoursesdata, 'sort' => 'ul.timeaccess asc', 'limit' => 0, 'offset' => 0, 'expectedcourses' => [] ], 'ul.timeaccess asc, shortname asc no limit or offset' => [ 'enrolledcoursesdata' => $enrolledcoursesdata, 'unenrolledcoursesdata' => $unenrolledcoursesdata, 'sort' => 'ul.timeaccess asc, shortname asc', 'limit' => 0, 'offset' => 0, 'expectedcourses' => ['e', 'a', 'b', 'd', 'c'] ], 'ul.timeaccess asc, shortname asc with limit no offset' => [ 'enrolledcoursesdata' => $enrolledcoursesdata, 'unenrolledcoursesdata' => $unenrolledcoursesdata, 'sort' => 'ul.timeaccess asc, shortname asc', 'limit' => 2, 'offset' => 0, 'expectedcourses' => ['e', 'a'] ], 'ul.timeaccess asc, shortname asc with limit and offset' => [ 'enrolledcoursesdata' => $enrolledcoursesdata, 'unenrolledcoursesdata' => $unenrolledcoursesdata, 'sort' => 'ul.timeaccess asc, shortname asc', 'limit' => 2, 'offset' => 2, 'expectedcourses' => ['b', 'd'] ], 'ul.timeaccess asc, shortname asc with limit and offset beyond end of data set' => [ 'enrolledcoursesdata' => $enrolledcoursesdata, 'unenrolledcoursesdata' => $unenrolledcoursesdata, 'sort' => 'ul.timeaccess asc, shortname asc', 'limit' => 2, 'offset' => 4, 'expectedcourses' => ['c'] ], 'ul.timeaccess desc, shortname asc no limit or offset' => [ 'enrolledcoursesdata' => $enrolledcoursesdata, 'unenrolledcoursesdata' => $unenrolledcoursesdata, 'sort' => 'ul.timeaccess desc, shortname asc', 'limit' => 0, 'offset' => 0, 'expectedcourses' => ['c', 'b', 'd', 'a', 'e'] ], 'ul.timeaccess desc, shortname desc, no limit or offset' => [ 'enrolledcoursesdata' => $enrolledcoursesdata, 'unenrolledcoursesdata' => $unenrolledcoursesdata, 'sort' => 'ul.timeaccess desc, shortname desc', 'limit' => 0, 'offset' => 0, 'expectedcourses' => ['c', 'd', 'b', 'a', 'e'] ], 'ul.timeaccess asc, shortname desc, no limit or offset' => [ 'enrolledcoursesdata' => $enrolledcoursesdata, 'unenrolledcoursesdata' => $unenrolledcoursesdata, 'sort' => 'ul.timeaccess asc, shortname desc', 'limit' => 0, 'offset' => 0, 'expectedcourses' => ['e', 'a', 'd', 'b', 'c'] ], 'shortname asc, no limit or offset' => [ 'enrolledcoursesdata' => $enrolledcoursesdata, 'unenrolledcoursesdata' => $unenrolledcoursesdata, 'sort' => 'shortname asc', 'limit' => 0, 'offset' => 0, 'expectedcourses' => ['a', 'b', 'c', 'd', 'e'] ], 'shortname desc, no limit or offset' => [ 'enrolledcoursesdata' => $enrolledcoursesdata, 'unenrolledcoursesdata' => $unenrolledcoursesdata, 'sort' => 'shortname desc', 'limit' => 0, 'offset' => 0, 'expectedcourses' => ['e', 'd', 'c', 'b', 'a'] ], ]; } /** * Test the get_enrolled_courses_by_timeline_classification function. * * @dataProvider get_enrol_get_my_courses_sort_by_last_access_test_cases() * @param array $enrolledcoursesdata Courses to create and enrol the user in * @param array $unenrolledcoursesdata Courses to create nut not enrol the user in * @param string $sort Sort string for the enrol function * @param int $limit Maximum number of results * @param int $offset Offset the courses result set by this amount * @param array $expectedcourses Expected courses in result */ public function test_enrol_get_my_courses_sort_by_last_access( $enrolledcoursesdata, $unenrolledcoursesdata, $sort, $limit, $offset, $expectedcourses ) { global $DB, $CFG; $this->resetAfterTest(); $generator = $this->getDataGenerator(); $student = $generator->create_user(); $lastaccessrecords = []; foreach ($enrolledcoursesdata as $coursedata) { $lastaccess = null; if (isset($coursedata['lastaccess'])) { $lastaccess = $coursedata['lastaccess']; unset($coursedata['lastaccess']); } $course = $generator->create_course($coursedata); $generator->enrol_user($student->id, $course->id, 'student'); if (!is_null($lastaccess)) { $lastaccessrecords[] = [ 'userid' => $student->id, 'courseid' => $course->id, 'timeaccess' => $lastaccess ]; } } foreach ($unenrolledcoursesdata as $coursedata) { $lastaccess = null; if (isset($coursedata['lastaccess'])) { $lastaccess = $coursedata['lastaccess']; unset($coursedata['lastaccess']); } $course = $generator->create_course($coursedata); if (!is_null($lastaccess)) { $lastaccessrecords[] = [ 'userid' => $student->id, 'courseid' => $course->id, 'timeaccess' => $lastaccess ]; } } if (!empty($lastaccessrecords)) { $DB->insert_records('user_lastaccess', $lastaccessrecords); } $this->setUser($student); $result = enrol_get_my_courses('shortname', $sort, $limit, [], false, $offset); $actual = array_map(function($course) { return $course->shortname; }, array_values($result)); $this->assertEquals($expectedcourses, $actual); } /** * Test enrol_get_course_users_roles function. * * @return void */ public function test_enrol_get_course_users_roles() { global $DB; $this->resetAfterTest(); $user1 = $this->getDataGenerator()->create_user(); $user2 = $this->getDataGenerator()->create_user(); $course = $this->getDataGenerator()->create_course(); $context = context_course::instance($course->id); $roles = array(); $roles['student'] = $DB->get_field('role', 'id', array('shortname' => 'student'), MUST_EXIST); $roles['teacher'] = $DB->get_field('role', 'id', array('shortname' => 'teacher'), MUST_EXIST); $manual = enrol_get_plugin('manual'); $this->assertNotEmpty($manual); $enrol = $DB->get_record('enrol', array('courseid' => $course->id, 'enrol' => 'manual'), '*', MUST_EXIST); // Test without enrolments. $this->assertEmpty(enrol_get_course_users_roles($course->id)); // Test with 1 user, 1 role. $manual->enrol_user($enrol, $user1->id, $roles['student']); $return = enrol_get_course_users_roles($course->id); $this->assertArrayHasKey($user1->id, $return); $this->assertArrayHasKey($roles['student'], $return[$user1->id]); $this->assertArrayNotHasKey($roles['teacher'], $return[$user1->id]); // Test with 1 user, 2 role. $manual->enrol_user($enrol, $user1->id, $roles['teacher']); $return = enrol_get_course_users_roles($course->id); $this->assertArrayHasKey($user1->id, $return); $this->assertArrayHasKey($roles['student'], $return[$user1->id]); $this->assertArrayHasKey($roles['teacher'], $return[$user1->id]); // Test with another user, 1 role. $manual->enrol_user($enrol, $user2->id, $roles['student']); $return = enrol_get_course_users_roles($course->id); $this->assertArrayHasKey($user1->id, $return); $this->assertArrayHasKey($roles['student'], $return[$user1->id]); $this->assertArrayHasKey($roles['teacher'], $return[$user1->id]); $this->assertArrayHasKey($user2->id, $return); $this->assertArrayHasKey($roles['student'], $return[$user2->id]); $this->assertArrayNotHasKey($roles['teacher'], $return[$user2->id]); } /** * Test enrol_calculate_duration function */ public function test_enrol_calculate_duration() { // Start time 07/01/2019 @ 12:00am (UTC). $timestart = 1561939200; // End time 07/05/2019 @ 12:00am (UTC). $timeend = 1562284800; $duration = enrol_calculate_duration($timestart, $timeend); $durationinday = $duration / DAYSECS; $this->assertEquals(4, $durationinday); // End time 07/10/2019 @ 12:00am (UTC). $timeend = 1562716800; $duration = enrol_calculate_duration($timestart, $timeend); $durationinday = $duration / DAYSECS; $this->assertEquals(9, $durationinday); } /** * Test get_enrolled_with_capabilities_join cannotmatchanyrows attribute. * * @dataProvider get_enrolled_with_capabilities_join_cannotmatchanyrows_data() * @param string $capability the tested capability * @param bool $useprohibit if the capability must be assigned to prohibit * @param int $expectedmatch expected cannotmatchanyrows value * @param int $expectedcount expceted count value */ public function test_get_enrolled_with_capabilities_join_cannotmatchanyrows( string $capability, bool $useprohibit, int $expectedmatch, int $expectedcount ) { global $DB, $CFG; $this->resetAfterTest(); $course = $this->getDataGenerator()->create_course(); $context = context_course::instance($course->id); $roleid = $CFG->defaultuserroleid; // Override capability if necessary. if ($useprohibit && $capability) { assign_capability($capability, CAP_PROHIBIT, $roleid, $context); } // Check if we must enrol or not. $this->getDataGenerator()->create_and_enrol($course, 'editingteacher'); $join = get_enrolled_with_capabilities_join($context, '', $capability); // Execute query. $sql = "SELECT COUNT(DISTINCT u.id) FROM {user} u {$join->joins} WHERE {$join->wheres}"; $countrecords = $DB->count_records_sql($sql, $join->params); // Validate cannotmatchanyrows. $this->assertEquals($expectedmatch, $join->cannotmatchanyrows); $this->assertEquals($expectedcount, $countrecords); } /** * Data provider for test_get_enrolled_with_capabilities_join_cannotmatchanyrows * * @return @array of testing scenarios */ public function get_enrolled_with_capabilities_join_cannotmatchanyrows_data() { return [ 'no prohibits, no capability' => [ 'capability' => '', 'useprohibit' => false, 'expectedmatch' => 0, 'expectedcount' => 1, ], 'no prohibits with capability' => [ 'capability' => 'moodle/course:manageactivities', 'useprohibit' => false, 'expectedmatch' => 0, 'expectedcount' => 1, ], 'prohibits with capability' => [ 'capability' => 'moodle/course:manageactivities', 'useprohibit' => true, 'expectedmatch' => 1, 'expectedcount' => 0, ], ]; }> } > /** > * Test enrol_selfenrol_available function behavior. > * > * @covers ::enrol_selfenrol_available > */ > public function test_enrol_selfenrol_available() { > global $DB, $CFG; > > $this->resetAfterTest(); > $this->preventResetByRollback(); // Messaging does not like transactions... > > $selfplugin = enrol_get_plugin('self'); > > $user1 = $this->getDataGenerator()->create_user(); > $user2 = $this->getDataGenerator()->create_user(); > > $studentrole = $DB->get_record('role', ['shortname' => 'student'], '*', MUST_EXIST); > $course = $this->getDataGenerator()->create_course(); > $cohort1 = $this->getDataGenerator()->create_cohort(); > $cohort2 = $this->getDataGenerator()->create_cohort(); > > // New enrolments are allowed and enrolment instance is enabled. > $instance = $DB->get_record('enrol', ['courseid' => $course->id, 'enrol' => 'self'], '*', MUST_EXIST); > $instance->customint6 = 1; > $DB->update_record('enrol', $instance); > $selfplugin->update_status($instance, ENROL_INSTANCE_ENABLED); > $this->setUser($user1); > $this->assertTrue(enrol_selfenrol_available($course->id)); > $this->setGuestUser(); > $this->assertTrue(enrol_selfenrol_available($course->id)); > > $canntenrolerror = get_string('canntenrol', 'enrol_self'); > > // New enrolments are not allowed, but enrolment instance is enabled. > $instance->customint6 = 0; > $DB->update_record('enrol', $instance); > $this->setUser($user1); > $this->assertFalse(enrol_selfenrol_available($course->id)); > $this->setGuestUser(); > $this->assertFalse(enrol_selfenrol_available($course->id)); > > // New enrolments are allowed, but enrolment instance is disabled. > $instance->customint6 = 1; > $DB->update_record('enrol', $instance); > $selfplugin->update_status($instance, ENROL_INSTANCE_DISABLED); > $this->setUser($user1); > $this->assertFalse(enrol_selfenrol_available($course->id)); > $this->setGuestUser(); > $this->assertFalse(enrol_selfenrol_available($course->id)); > > // New enrolments are not allowed and enrolment instance is disabled. > $instance->customint6 = 0; > $DB->update_record('enrol', $instance); > $this->setUser($user1); > $this->assertFalse(enrol_selfenrol_available($course->id)); > $this->setGuestUser(); > $this->assertFalse(enrol_selfenrol_available($course->id)); > > // Enable enrolment instance for the rest of the tests. > $selfplugin->update_status($instance, ENROL_INSTANCE_ENABLED); > > // Enrol start date is in future. > $instance->customint6 = 1; > $instance->enrolstartdate = time() + 60; > $DB->update_record('enrol', $instance); > $error = get_string('canntenrolearly', 'enrol_self', userdate($instance->enrolstartdate)); > $this->setUser($user1); > $this->assertFalse(enrol_selfenrol_available($course->id)); > $this->setGuestUser(); > $this->assertFalse(enrol_selfenrol_available($course->id)); > > // Enrol start date is in past. > $instance->enrolstartdate = time() - 60; > $DB->update_record('enrol', $instance); > $this->setUser($user1); > $this->assertTrue(enrol_selfenrol_available($course->id)); > $this->setGuestUser(); > $this->assertTrue(enrol_selfenrol_available($course->id)); > > // Enrol end date is in future. > $instance->enrolstartdate = 0; > $instance->enrolenddate = time() + 60; > $DB->update_record('enrol', $instance); > $this->setUser($user1); > $this->assertTrue(enrol_selfenrol_available($course->id)); > $this->setGuestUser(); > $this->assertTrue(enrol_selfenrol_available($course->id)); > > // Enrol end date is in past. > $instance->enrolenddate = time() - 60; > $DB->update_record('enrol', $instance); > $error = get_string('canntenrollate', 'enrol_self', userdate($instance->enrolenddate)); > $this->setUser($user1); > $this->assertFalse(enrol_selfenrol_available($course->id)); > $this->setGuestUser(); > $this->assertFalse(enrol_selfenrol_available($course->id)); > > // Maximum enrolments reached. > $instance->customint3 = 1; > $instance->enrolenddate = 0; > $DB->update_record('enrol', $instance); > $selfplugin->enrol_user($instance, $user2->id, $studentrole->id); > $error = get_string('maxenrolledreached', 'enrol_self'); > $this->setUser($user1); > $this->assertFalse(enrol_selfenrol_available($course->id)); > $this->setGuestUser(); > $this->assertFalse(enrol_selfenrol_available($course->id)); > > // Maximum enrolments not reached. > $instance->customint3 = 3; > $DB->update_record('enrol', $instance); > $this->setUser($user1); > $this->assertTrue(enrol_selfenrol_available($course->id)); > $this->setGuestUser(); > $this->assertTrue(enrol_selfenrol_available($course->id)); > > require_once("$CFG->dirroot/cohort/lib.php"); > cohort_add_member($cohort1->id, $user2->id); > > // Cohort test. > $instance->customint5 = $cohort1->id; > $DB->update_record('enrol', $instance); > $error = get_string('cohortnonmemberinfo', 'enrol_self', $cohort1->name); > $this->setUser($user1); > $this->assertFalse(enrol_selfenrol_available($course->id)); > $this->setGuestUser(); > $this->assertFalse(enrol_selfenrol_available($course->id)); > $this->setUser($user2); > $this->assertFalse(enrol_selfenrol_available($course->id)); > }