<?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 core_enrollib_testcase extends advanced_testcase {
> 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->assertEquals($basefields, array_keys($course), '', 0, 10, true);
> $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));