WebSVN – Moodle – Diff – /user/tests/table/participants_search_test.php



 *
 * @package   core_user
 * @category  test
 * @copyright 2020 Andrew Nicols <andrew@nicols.co.uk>
 * @license   http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 *
 * @covers \core_user\table\participants_search
 */
final class participants_search_test extends advanced_testcase {

 
    /**

        // Run the search.
        $search = new participants_search($course, $coursecontext, $filterset);
        $rs = $search->get_participants();
        $this->assertInstanceOf(moodle_recordset::class, $rs);
        $records = $this->convert_recordset_to_array($rs);
        $resetrecords = reset($records);
        $totalparticipants = $resetrecords->fullcount ?? 0;

 
        $this->assertCount($count, $records);

        $this->assertEquals($count, $totalparticipants);
 
        foreach ($expectedusers as $expecteduser) {
            $this->assertArrayHasKey($users[$expecteduser]->id, $records);

     */
    public static function role_provider(): array {
        $tests = [
            // Users who only have one role each.
            'Users in each role' => (object) [
                'usersdata' => [
                    'a' => [
                        'courseroles' => [
                            'student',
                        ],
                    ],

                    ],
                ],
                'expect' => [
                    // Tests for jointype: ANY.
                    'ANY: No role filter' => (object) [
                        'testroles' => [],
                        'jointype' => filter::JOINTYPE_ANY,
                        'count' => 8,
                        'expectedusers' => [
                            'a',
                            'b',

                            'g',
                            'h',
                        ],
                    ],
                    'ANY: Filter on student' => (object) [
                        'testroles' => ['student'],
                        'jointype' => filter::JOINTYPE_ANY,
                        'count' => 2,
                        'expectedusers' => [
                            'a',
                            'b',
                        ],
                    ],
                    'ANY: Filter on student, teacher' => (object) [
                        'testroles' => ['student', 'teacher'],
                        'jointype' => filter::JOINTYPE_ANY,
                        'count' => 4,
                        'expectedusers' => [
                            'a',
                            'b',
                            'e',
                            'f',
                        ],
                    ],
                    'ANY: Filter on student, manager (category level role)' => (object) [
                        'testroles' => ['student', 'manager'],
                        'jointype' => filter::JOINTYPE_ANY,
                        'count' => 3,
                        'expectedusers' => [
                            'a',
                            'b',
                            'h',
                        ],
                    ],
                    'ANY: Filter on student, coursecreator (not assigned)' => (object) [
                        'testroles' => ['student', 'coursecreator'],
                        'jointype' => filter::JOINTYPE_ANY,
                        'count' => 2,
                        'expectedusers' => [
                            'a',
                            'b',
                        ],
                    ],

 
                    // Tests for jointype: ALL.
                    'ALL: No role filter' => (object) [
                        'testroles' => [],
                        'jointype' => filter::JOINTYPE_ALL,
                        'count' => 8,
                        'expectedusers' => [
                            'a',

                            'g',
                            'h',
                        ],
                    ],
                    'ALL: Filter on student' => (object) [
                        'testroles' => ['student'],
                        'jointype' => filter::JOINTYPE_ALL,
                        'count' => 2,
                        'expectedusers' => [
                            'a',
                            'b',
                        ],
                    ],
                    'ALL: Filter on student, teacher' => (object) [
                        'testroles' => ['student', 'teacher'],
                        'jointype' => filter::JOINTYPE_ALL,
                        'count' => 0,
                        'expectedusers' => [],
                    ],
                    'ALL: Filter on student, manager (category level role))' => (object) [
                        'testroles' => ['student', 'manager'],
                        'jointype' => filter::JOINTYPE_ALL,
                        'count' => 0,
                        'expectedusers' => [],
                    ],
                    'ALL: Filter on student, coursecreator (not assigned))' => (object) [
                        'testroles' => ['student', 'coursecreator'],
                        'jointype' => filter::JOINTYPE_ALL,
                        'count' => 0,
                        'expectedusers' => [],
                    ],

 
                    // Tests for jointype: NONE.
                    'NONE: No role filter' => (object) [
                        'testroles' => [],
                        'jointype' => filter::JOINTYPE_NONE,
                        'count' => 8,
                        'expectedusers' => [
                            'a',

                            'g',
                            'h',
                        ],
                    ],
                    'NONE: Filter on student' => (object) [
                        'testroles' => ['student'],
                        'jointype' => filter::JOINTYPE_NONE,
                        'count' => 6,
                        'expectedusers' => [
                            'c',
                            'd',

                            'g',
                            'h',
                        ],
                    ],
                    'NONE: Filter on student, teacher' => (object) [
                        'testroles' => ['student', 'teacher'],
                        'jointype' => filter::JOINTYPE_NONE,
                        'count' => 4,
                        'expectedusers' => [
                            'c',
                            'd',
                            'g',
                            'h',
                        ],
                    ],
                    'NONE: Filter on student, manager (category level role))' => (object) [
                        'testroles' => ['student', 'manager'],
                        'jointype' => filter::JOINTYPE_NONE,
                        'count' => 5,
                        'expectedusers' => [
                            'c',
                            'd',

                            'f',
                            'g',
                        ],
                    ],
                    'NONE: Filter on student, coursecreator (not assigned))' => (object) [
                        'testroles' => ['student', 'coursecreator'],
                        'jointype' => filter::JOINTYPE_NONE,
                        'count' => 6,
                        'expectedusers' => [
                            'c',
                            'd',

                        ],
                    ],
                ],
            ],
            'Users with multiple roles' => (object) [
                'usersdata' => [
                    'a' => [
                        'courseroles' => [
                            'student',
                        ],
                    ],

                    ],
                ],
                'expect' => [
                    // Tests for jointype: ANY.
                    'ANY: No role filter' => (object) [
                        'testroles' => [],
                        'jointype' => filter::JOINTYPE_ANY,
                        'count' => 8,
                        'expectedusers' => [
                            'a',
                            'b',

                            'g',
                            'h',
                        ],
                    ],
                    'ANY: Filter on student' => (object) [
                        'testroles' => ['student'],
                        'jointype' => filter::JOINTYPE_ANY,
                        'count' => 2,
                        'expectedusers' => [
                            'a',
                            'b',
                        ],
                    ],
                    'ANY: Filter on teacher' => (object) [
                        'testroles' => ['teacher'],
                        'jointype' => filter::JOINTYPE_ANY,
                        'count' => 3,
                        'expectedusers' => [
                            'b',
                            'e',
                            'f',
                        ],
                    ],
                    'ANY: Filter on editingteacher' => (object) [
                        'testroles' => ['editingteacher'],
                        'jointype' => filter::JOINTYPE_ANY,
                        'count' => 3,
                        'expectedusers' => [
                            'c',
                            'd',
                            'e',
                        ],
                    ],
                    'ANY: Filter on student, teacher' => (object) [
                        'testroles' => ['student', 'teacher'],
                        'jointype' => filter::JOINTYPE_ANY,
                        'count' => 4,
                        'expectedusers' => [
                            'a',
                            'b',
                            'e',
                            'f',
                        ],
                    ],
                    'ANY: Filter on teacher, editingteacher' => (object) [
                        'testroles' => ['teacher', 'editingteacher'],
                        'jointype' => filter::JOINTYPE_ANY,
                        'count' => 5,
                        'expectedusers' => [
                            'b',
                            'c',

                            'e',
                            'f',
                        ],
                    ],
                    'ANY: Filter on student, manager (category level role)' => (object) [
                        'testroles' => ['student', 'manager'],
                        'jointype' => filter::JOINTYPE_ANY,
                        'count' => 3,
                        'expectedusers' => [
                            'a',
                            'b',
                            'h',
                        ],
                    ],
                    'ANY: Filter on student, coursecreator (not assigned)' => (object) [
                        'testroles' => ['student', 'coursecreator'],
                        'jointype' => filter::JOINTYPE_ANY,
                        'count' => 2,
                        'expectedusers' => [
                            'a',
                            'b',
                        ],
                    ],

 
                    // Tests for jointype: ALL.
                    'ALL: No role filter' => (object) [
                        'testroles' => [],
                        'jointype' => filter::JOINTYPE_ALL,
                        'count' => 8,
                        'expectedusers' => [
                            'a',

                            'g',
                            'h',
                        ],
                    ],
                    'ALL: Filter on student' => (object) [
                        'testroles' => ['student'],
                        'jointype' => filter::JOINTYPE_ALL,
                        'count' => 2,
                        'expectedusers' => [
                            'a',
                            'b',
                        ],
                    ],
                    'ALL: Filter on teacher' => (object) [
                        'testroles' => ['teacher'],
                        'jointype' => filter::JOINTYPE_ALL,
                        'count' => 3,
                        'expectedusers' => [
                            'b',
                            'e',
                            'f',
                        ],
                    ],
                    'ALL: Filter on editingteacher' => (object) [
                        'testroles' => ['editingteacher'],
                        'jointype' => filter::JOINTYPE_ALL,
                        'count' => 3,
                        'expectedusers' => [
                            'c',
                            'd',
                            'e',
                        ],
                    ],
                    'ALL: Filter on student, teacher' => (object) [
                        'testroles' => ['student', 'teacher'],
                        'jointype' => filter::JOINTYPE_ALL,
                        'count' => 1,
                        'expectedusers' => [
                            'b',
                        ],
                    ],
                    'ALL: Filter on teacher, editingteacher' => (object) [
                        'testroles' => ['teacher', 'editingteacher'],
                        'jointype' => filter::JOINTYPE_ALL,
                        'count' => 1,
                        'expectedusers' => [
                            'e',
                        ],
                    ],
                    'ALL: Filter on student, manager (category level role)' => (object) [
                        'testroles' => ['student', 'manager'],
                        'jointype' => filter::JOINTYPE_ALL,
                        'count' => 0,
                        'expectedusers' => [],
                    ],
                    'ALL: Filter on student, coursecreator (not assigned)' => (object) [
                        'testroles' => ['student', 'coursecreator'],
                        'jointype' => filter::JOINTYPE_ALL,
                        'count' => 0,
                        'expectedusers' => [],
                    ],

 
                    // Tests for jointype: NONE.
                    'NONE: No role filter' => (object) [
                        'testroles' => [],
                        'jointype' => filter::JOINTYPE_NONE,
                        'count' => 8,
                        'expectedusers' => [
                            'a',

                            'g',
                            'h',
                        ],
                    ],
                    'NONE: Filter on student' => (object) [
                        'testroles' => ['student'],
                        'jointype' => filter::JOINTYPE_NONE,
                        'count' => 6,
                        'expectedusers' => [
                            'c',
                            'd',

                            'g',
                            'h',
                        ],
                    ],
                    'NONE: Filter on teacher' => (object) [
                        'testroles' => ['teacher'],
                        'jointype' => filter::JOINTYPE_NONE,
                        'count' => 5,
                        'expectedusers' => [
                            'a',
                            'c',

                            'g',
                            'h',
                        ],
                    ],
                    'NONE: Filter on editingteacher' => (object) [
                        'testroles' => ['editingteacher'],
                        'jointype' => filter::JOINTYPE_NONE,
                        'count' => 5,
                        'expectedusers' => [
                            'a',
                            'b',

                            'g',
                            'h',
                        ],
                    ],
                    'NONE: Filter on student, teacher' => (object) [
                        'testroles' => ['student', 'teacher'],
                        'jointype' => filter::JOINTYPE_NONE,
                        'count' => 4,
                        'expectedusers' => [
                            'c',
                            'd',
                            'g',
                            'h',
                        ],
                    ],
                    'NONE: Filter on teacher, editingteacher' => (object) [
                        'testroles' => ['teacher', 'editingteacher'],
                        'jointype' => filter::JOINTYPE_NONE,
                        'count' => 3,
                        'expectedusers' => [
                            'a',
                            'g',
                            'h',
                        ],
                    ],
                    'NONE: Filter on student, manager (category level role)' => (object) [
                        'testroles' => ['student', 'manager'],
                        'jointype' => filter::JOINTYPE_NONE,
                        'count' => 5,
                        'expectedusers' => [
                            'c',
                            'd',

                            'f',
                            'g',
                        ],
                    ],
                    'NONE: Filter on student, coursecreator (not assigned)' => (object) [
                        'testroles' => ['student', 'coursecreator'],
                        'jointype' => filter::JOINTYPE_NONE,
                        'count' => 6,
                        'expectedusers' => [
                            'c',
                            'd',

 
        $finaltests = [];
        foreach ($tests as $testname => $testdata) {
            foreach ($testdata->expect as $expectname => $expectdata) {
                $finaltests["{$testname} => {$expectname}"] = [
                    'usersdata' => $testdata->usersdata,
                    'testroles' => $expectdata->testroles,
                    'jointype' => $expectdata->jointype,
                    'count' => $expectdata->count,
                    'expectedusers' => $expectdata->expectedusers,
                ];

        $filterset->add_filter(new integer_filter('courseid', null, [(int) $course->id]));
        $filterset->add_filter(new string_filter('country', $jointype, $countries));

 
        // Run the search, assert count matches the number of expected users.
 
 
        $search = new participants_search($course, context_course::instance($course->id), $filterset);
        $rs = $search->get_participants();
        $totalparticipants = $rs->current()->fullcount ?? 0;
        $this->assertEquals(count($expectedusers), $totalparticipants);
 

        $this->assertInstanceOf(moodle_recordset::class, $rs);
 
        // Assert that each expected user is within the participant records.

    /**
     * Data provider for {@see test_country_filter}
     *
     * @return array
     */
    public static function country_provider(): array {
        $tests = [
            'usersdata' => [
                'user1' => 'DE',
                'user2' => 'ES',
                'user3' => 'ES',
                'user4' => 'GB',
            ],

        ];

 
        $finaltests = [];
        foreach ($tests['expects'] as $testname => $test) {
            $finaltests[$testname] = [
                'usersdata' => $tests['usersdata'],
                'countries' => $test->countries,
                'jointype' => $test->jointype,
                'expectedusers' => $test->expectedusers,
            ];

        // Run the search.
        $search = new participants_search($course, $coursecontext, $filterset);
        $rs = $search->get_participants();
        $this->assertInstanceOf(moodle_recordset::class, $rs);
        $records = $this->convert_recordset_to_array($rs);
        $resetrecords = reset($records);
        $totalparticipants = $resetrecords->fullcount ?? 0;

 
        $this->assertCount($count, $records);

        $this->assertEquals($count, $totalparticipants);
 
        foreach ($expectedusers as $expecteduser) {
            $this->assertArrayHasKey($users[$expecteduser]->id, $records);

    /**
     * Data provider for keywords tests.
     *
     * @return array
     */
    public static function keywords_provider(): array {
        $tests = [
            // Users where the keyword matches basic user fields such as names and email.
            'Users with basic names' => (object) [
                'usersdata' => [
                    'adam.ant' => [
                        'firstname' => 'Adam',
                        'lastname' => 'Ant',
                    ],
                    'barbara.bennett' => [

 
        $finaltests = [];
        foreach ($tests as $testname => $testdata) {
            foreach ($testdata->expect as $expectname => $expectdata) {
                $finaltests["{$testname} => {$expectname}"] = [
                    'usersdata' => $testdata->usersdata,
                    'keywords' => $expectdata->keywords,
                    'jointype' => $expectdata->jointype,
                    'count' => $expectdata->count,
                    'expectedusers' => $expectdata->expectedusers,

        }

 
        foreach ($usersdata as $username => $userdata) {

            $user = $this->getDataGenerator()->create_user(['username' => $username]);
 
            if (array_key_exists('statuses', $userdata)) {
                foreach ($userdata['statuses'] as $enrolmethod => $status) {
                    $this->getDataGenerator()->enrol_user($user->id, $course->id, 'student', $enrolmethod, 0, 0, $status);

                }

        // Run the search.
        $search = new participants_search($course, $coursecontext, $filterset);
        $rs = $search->get_participants();
        $this->assertInstanceOf(moodle_recordset::class, $rs);
        $records = $this->convert_recordset_to_array($rs);
        $resetrecords = reset($records);
        $totalparticipants = $resetrecords->fullcount ?? 0;

 
        $this->assertCount($count, $records);

        $this->assertEquals($count, $totalparticipants);
 
        foreach ($expectedusers as $expecteduser) {
            $this->assertArrayHasKey($users[$expecteduser]->id, $records);

    /**
     * Data provider for status filter tests.
     *
     * @return array
     */
    public static function status_provider(): array {
        $tests = [
            // Users with different statuses and enrolment methods (so multiple statuses are possible for the same user).
            'Users with different enrolment statuses' => (object) [
                'usersdata' => [
                    'a' => [
                        'statuses' => [
                            'manual' => ENROL_USER_ACTIVE,
                        ]
                    ],
                    'b' => [
                        'statuses' => [
                            'self' => ENROL_USER_ACTIVE,
                        ]
                    ],
                    'c' => [
                        'statuses' => [
                            'manual' => ENROL_USER_SUSPENDED,
                        ]
                    ],
                    'd' => [
                        'statuses' => [
                            'self' => ENROL_USER_SUSPENDED,
                        ]
                    ],
                    'e' => [
                        'statuses' => [
                            'manual' => ENROL_USER_ACTIVE,
                            'self' => ENROL_USER_SUSPENDED,
                        ]
                    ],
                ],
                'expect' => [
                    // Tests for jointype: ANY.
                    'ANY: No filter' => (object) [
                        'statuses' => [],
                        'jointype' => filter::JOINTYPE_ANY,
                        'count' => 5,
                        'expectedusers' => [
                            'a',
                            'b',

                            'd',
                            'e',
                        ],
                    ],
                    'ANY: Filter on active only' => (object) [
                        'statuses' => [ENROL_USER_ACTIVE],
                        'jointype' => filter::JOINTYPE_ANY,
                        'count' => 3,
                        'expectedusers' => [
                            'a',
                            'b',
                            'e',
                        ],
                    ],
                    'ANY: Filter on suspended only' => (object) [
                        'statuses' => [ENROL_USER_SUSPENDED],
                        'jointype' => filter::JOINTYPE_ANY,
                        'count' => 3,
                        'expectedusers' => [
                            'c',
                            'd',
                            'e',
                        ],
                    ],
                    'ANY: Filter on multiple statuses' => (object) [
                        'statuses' => [ENROL_USER_ACTIVE, ENROL_USER_SUSPENDED],
                        'jointype' => filter::JOINTYPE_ANY,
                        'count' => 5,
                        'expectedusers' => [
                            'a',
                            'b',

                        ],
                    ],

 
                    // Tests for jointype: ALL.
                    'ALL: No filter' => (object) [
                       'statuses' => [],
                        'jointype' => filter::JOINTYPE_ALL,
                        'count' => 5,
                        'expectedusers' => [
                            'a',

                            'd',
                            'e',
                        ],
                    ],
                    'ALL: Filter on active only' => (object) [
                        'statuses' => [ENROL_USER_ACTIVE],
                        'jointype' => filter::JOINTYPE_ALL,
                        'count' => 3,
                        'expectedusers' => [
                            'a',
                            'b',
                            'e',
                        ],
                    ],
                    'ALL: Filter on suspended only' => (object) [
                        'statuses' => [ENROL_USER_SUSPENDED],
                        'jointype' => filter::JOINTYPE_ALL,
                        'count' => 3,
                        'expectedusers' => [
                            'c',
                            'd',
                            'e',
                        ],
                    ],
                    'ALL: Filter on multiple statuses' => (object) [
                        'statuses' => [ENROL_USER_ACTIVE, ENROL_USER_SUSPENDED],
                        'jointype' => filter::JOINTYPE_ALL,
                        'count' => 1,
                        'expectedusers' => [
                            'e',
                        ],
                    ],

 
                    // Tests for jointype: NONE.
                    'NONE: No filter' => (object) [
                       'statuses' => [],
                        'jointype' => filter::JOINTYPE_NONE,
                        'count' => 5,
                        'expectedusers' => [
                            'a',

                            'd',
                            'e',
                        ],
                    ],
                    'NONE: Filter on active only' => (object) [
                        'statuses' => [ENROL_USER_ACTIVE],
                        'jointype' => filter::JOINTYPE_NONE,
                        'count' => 3,
                        'expectedusers' => [
                            'c',
                            'd',
                            'e',
                        ],
                    ],
                    'NONE: Filter on suspended only' => (object) [
                        'statuses' => [ENROL_USER_SUSPENDED],
                        'jointype' => filter::JOINTYPE_NONE,
                        'count' => 3,
                        'expectedusers' => [
                            'a',
                            'b',
                            'e',
                        ],
                    ],
                    'NONE: Filter on multiple statuses' => (object) [
                        'statuses' => [ENROL_USER_ACTIVE, ENROL_USER_SUSPENDED],
                        'jointype' => filter::JOINTYPE_NONE,
                        'count' => 0,
                        'expectedusers' => [],
                    ],
                ],

 
        $finaltests = [];
        foreach ($tests as $testname => $testdata) {
            foreach ($testdata->expect as $expectname => $expectdata) {
                $finaltests["{$testname} => {$expectname}"] = [
                    'usersdata' => $testdata->usersdata,
                    'statuses' => $expectdata->statuses,
                    'jointype' => $expectdata->jointype,
                    'count' => $expectdata->count,
                    'expectedusers' => $expectdata->expectedusers,
                ];

        // Run the search.
        $search = new participants_search($course, $coursecontext, $filterset);
        $rs = $search->get_participants();
        $this->assertInstanceOf(moodle_recordset::class, $rs);
        $records = $this->convert_recordset_to_array($rs);
        $resetrecords = reset($records);
        $totalparticipants = $resetrecords->fullcount ?? 0;

 
        $this->assertCount($count, $records);

        $this->assertEquals($count, $totalparticipants);
 
        foreach ($expectedusers as $expecteduser) {
            $this->assertArrayHasKey($users[$expecteduser]->id, $records);

    /**
     * Data provider for enrolments filter tests.
     *
     * @return array
     */
    public static function enrolments_provider(): array {
        $tests = [
            // Users with different enrolment methods.
            'Users with different enrolment methods' => (object) [
                'usersdata' => [
                    'a' => [
                        'enrolmethods' => [
                            'manual',
                        ]
                    ],

 
        $finaltests = [];
        foreach ($tests as $testname => $testdata) {
            foreach ($testdata->expect as $expectname => $expectdata) {
                $finaltests["{$testname} => {$expectname}"] = [
                    'usersdata' => $testdata->usersdata,
                    'enrolmethods' => $expectdata->enrolmethods,
                    'jointype' => $expectdata->jointype,
                    'count' => $expectdata->count,
                    'expectedusers' => $expectdata->expectedusers,

        // Run the search.
        $search = new participants_search($course, $coursecontext, $filterset);
        $rs = $search->get_participants();
        $this->assertInstanceOf(moodle_recordset::class, $rs);
        $records = $this->convert_recordset_to_array($rs);
        $resetrecords = reset($records);
        $totalparticipants = $resetrecords->fullcount ?? 0;

 
        $this->assertCount($count, $records);

        $this->assertEquals($count, $totalparticipants);
 
        foreach ($expectedusers as $expecteduser) {
            $this->assertArrayHasKey($users[$expecteduser]->id, $records);

    /**
     * Data provider for groups filter tests.
     *
     * @return array
     */
    public static function groups_provider(): array {
        $tests = [
            'Users in different groups' => (object) [
                'groupsavailable' => [
                    'groupa',
                    'groupb',
                    'groupc',
                ],
                'usersdata' => [
                    'a' => [
                        'groups' => ['groupa'],
                    ],
                    'b' => [
                        'groups' => ['groupb'],

 
        $finaltests = [];
        foreach ($tests as $testname => $testdata) {
            foreach ($testdata->expect as $expectname => $expectdata) {
                $finaltests["{$testname} => {$expectname}"] = [
                    'usersdata' => $testdata->usersdata,
                    'groupsavailable' => $testdata->groupsavailable,
                    'filtergroups' => $expectdata->groups,
                    'jointype' => $expectdata->jointype,
                    'count' => $expectdata->count,

        } else {
            // All other cases are tested as normal.
            $rs = $search->get_participants();
            $this->assertInstanceOf(moodle_recordset::class, $rs);
            $records = $this->convert_recordset_to_array($rs);
            $resetrecords = reset($records);
            $totalparticipants = $resetrecords->fullcount ?? 0;

 
            $this->assertCount($count, $records);

            $this->assertEquals($count, $totalparticipants);
 
            foreach ($expectedusers as $expecteduser) {
                $this->assertArrayHasKey($users[$expecteduser]->id, $records);

    /**
     * Data provider for groups filter tests.
     *
     * @return array
     */
    public static function groups_separate_provider(): array {
        $tests = [
            'Users in different groups with separate groups mode enabled' => (object) [
                'groupsavailable' => [
                    'groupa',
                    'groupb',
                    'groupc',
                ],
                'usersdata' => [
                    'a' => [
                        'groups' => ['groupa'],
                    ],
                    'b' => [
                        'groups' => ['groupb'],

 
        $finaltests = [];
        foreach ($tests as $testname => $testdata) {
            foreach ($testdata->expect as $expectname => $expectdata) {
                $finaltests["{$testname} => {$expectname}"] = [
                    'usersdata' => $testdata->usersdata,
                    'groupsavailable' => $testdata->groupsavailable,
                    'filtergroups' => $expectdata->groups,
                    'jointype' => $expectdata->jointype,
                    'count' => $expectdata->count,

        // Run the search.
        $search = new participants_search($course, $coursecontext, $filterset);
        $rs = $search->get_participants();
        $this->assertInstanceOf(moodle_recordset::class, $rs);
        $records = $this->convert_recordset_to_array($rs);
        $resetrecords = reset($records);
        $totalparticipants = $resetrecords->fullcount ?? 0;

 
        $this->assertCount($count, $records);

        $this->assertEquals($count, $totalparticipants);
 
        foreach ($expectedusers as $expecteduser) {
            $this->assertArrayHasKey($users[$expecteduser]->id, $records);

    /**
     * Data provider for last access filter tests.
     *
     * @return array
     */
    public static function accesssince_provider(): array {
        $tests = [
            // Users with different last access times.
            'Users in different groups' => (object) [
                'usersdata' => [
                    'a' => [
                        'lastlogin' => '-3 days',
                    ],
                    'b' => [
                        'lastlogin' => '-2 weeks',

 
        $finaltests = [];
        foreach ($tests as $testname => $testdata) {
            foreach ($testdata->expect as $expectname => $expectdata) {
                $finaltests["{$testname} => {$expectname}"] = [
                    'usersdata' => $testdata->usersdata,
                    'accesssince' => $expectdata->accesssince,
                    'jointype' => $expectdata->jointype,
                    'count' => $expectdata->count,
                    'expectedusers' => $expectdata->expectedusers,

        // Run the search.
        $search = new participants_search($course, $coursecontext, $filterset);
        $rs = $search->get_participants();
        $this->assertInstanceOf(moodle_recordset::class, $rs);
        $records = $this->convert_recordset_to_array($rs);
        $resetrecords = reset($records);
        $totalparticipants = $resetrecords->fullcount ?? 0;

 
        $this->assertCount($count, $records);

        $this->assertEquals($count, $totalparticipants);
 
        foreach ($expectedusers as $expecteduser) {
            $this->assertArrayHasKey($users[$expecteduser]->id, $records);

    /**
     * Data provider for filterset join tests.
     *
     * @return array
     */
    public static function filterset_joins_provider(): array {
        $tests = [
            // Users with different configurations.
            'Users with different configurations' => (object) [
                'groupsavailable' => [
                    'groupa',
                    'groupb',
                    'groupc',
                ],
                'usersdata' => [
                    'adam.ant' => [
                        'firstname' => 'Adam',
                        'lastname' => 'Ant',
                        'enrolments' => [
                            [

 
        $finaltests = [];
        foreach ($tests as $testname => $testdata) {
            foreach ($testdata->expect as $expectname => $expectdata) {
                $finaltests["{$testname} => {$expectname}"] = [
                    'usersdata' => $testdata->usersdata,
                    'filterdata' => $expectdata->filterdata,
                    'groupsavailable' => $testdata->groupsavailable,
                    'jointype' => $expectdata->jointype,
                    'count' => $expectdata->count,

            }
        }

 
        return $finaltests;
    }
 
    /**
     * Tests sorting of participants in a course.
     *
     * This test runs a search for participants twice, first with an "ORDER BY" clause and second without.
     * The test asserts the correct ordering of participants based on the sorting condition.
     */
    public function test_sort_participants(): void {
        $this->resetAfterTest();
 
        $course = $this->getDataGenerator()->create_course();
        $coursecontext = context_course::instance($course->id);
 
        // Generate users with their role.
        $this->getDataGenerator()->create_and_enrol($course, 'teacher');
        $this->getDataGenerator()->create_and_enrol($course, 'student');
 
        // Create the basic filter.
        $filterset = new participants_filterset();
        $filterset->add_filter(new integer_filter('courseid', null, [(int) $course->id]));
 
        // Run the search with using ORDER BY.
        $search = new participants_search($course, $coursecontext, $filterset);
        $rs = $search->get_participants(
            sort: 'ORDER     BY id', // Adding spaces between "ORDER" and "BY" is intentional.
        );
        $records = $this->convert_recordset_to_array($rs);
        $userids = array_keys($records);
        $this->assertGreaterThan($userids[0], $userids[1]);
 
        // Run the search without using ORDER BY.
        $rs = $search->get_participants(
            sort: 'id DESC',
        );
        $records = $this->convert_recordset_to_array($rs);
        $userids = array_keys($records);
        $this->assertGreaterThan($userids[1], $userids[0]);
 
        $rs->close();
    }

Rev 11	Rev 1441
Línea 34...	Línea 34...
34	`*`	34	`*`
35	`* @package core_user`	35	`* @package core_user`
36	`* @category test`	36	`* @category test`
37	`* @copyright 2020 Andrew Nicols <andrew@nicols.co.uk>`	37	`* @copyright 2020 Andrew Nicols <andrew@nicols.co.uk>`
38	`* @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later`	38	`* @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later`
-		39	`*`
-		40	`* @covers \core_user\table\participants_search`
39	`*/`	41	`*/`
40	`final class participants_search_test extends advanced_testcase {`	42	`final class participants_search_test extends advanced_testcase {`
Línea 41...	Línea 43...
41		43
42	`/**`	44	`/**`
Línea 167...	Línea 169...
167	`// Run the search.`	169	`// Run the search.`
168	`$search = new participants_search($course, $coursecontext, $filterset);`	170	`$search = new participants_search($course, $coursecontext, $filterset);`
169	`$rs = $search->get_participants();`	171	`$rs = $search->get_participants();`
170	`$this->assertInstanceOf(moodle_recordset::class, $rs);`	172	`$this->assertInstanceOf(moodle_recordset::class, $rs);`
171	`$records = $this->convert_recordset_to_array($rs);`	173	`$records = $this->convert_recordset_to_array($rs);`
-		174	`$resetrecords = reset($records);`
-		175	`$totalparticipants = $resetrecords->fullcount ?? 0;`
Línea 172...	Línea 176...
172		176
173	`$this->assertCount($count, $records);`	177	`$this->assertCount($count, $records);`
Línea 174...	Línea 178...
174	`$this->assertEquals($count, $search->get_total_participants_count());`	178	`$this->assertEquals($count, $totalparticipants);`
175		179
176	`foreach ($expectedusers as $expecteduser) {`	180	`foreach ($expectedusers as $expecteduser) {`
177	`$this->assertArrayHasKey($users[$expecteduser]->id, $records);`	181	`$this->assertArrayHasKey($users[$expecteduser]->id, $records);`
Línea 185...	Línea 189...
185	`*/`	189	`*/`
186	`public static function role_provider(): array {`	190	`public static function role_provider(): array {`
187	`$tests = [`	191	`$tests = [`
188	`// Users who only have one role each.`	192	`// Users who only have one role each.`
189	`'Users in each role' => (object) [`	193	`'Users in each role' => (object) [`
190	`'users' => [`	194	`'usersdata' => [`
191	`'a' => [`	195	`'a' => [`
192	`'courseroles' => [`	196	`'courseroles' => [`
193	`'student',`	197	`'student',`
194	`],`	198	`],`
195	`],`	199	`],`
Línea 242...	Línea 246...
242	`],`	246	`],`
243	`],`	247	`],`
244	`'expect' => [`	248	`'expect' => [`
245	`// Tests for jointype: ANY.`	249	`// Tests for jointype: ANY.`
246	`'ANY: No role filter' => (object) [`	250	`'ANY: No role filter' => (object) [`
247	`'roles' => [],`	251	`'testroles' => [],`
248	`'jointype' => filter::JOINTYPE_ANY,`	252	`'jointype' => filter::JOINTYPE_ANY,`
249	`'count' => 8,`	253	`'count' => 8,`
250	`'expectedusers' => [`	254	`'expectedusers' => [`
251	`'a',`	255	`'a',`
252	`'b',`	256	`'b',`
Línea 257...	Línea 261...
257	`'g',`	261	`'g',`
258	`'h',`	262	`'h',`
259	`],`	263	`],`
260	`],`	264	`],`
261	`'ANY: Filter on student' => (object) [`	265	`'ANY: Filter on student' => (object) [`
262	`'roles' => ['student'],`	266	`'testroles' => ['student'],`
263	`'jointype' => filter::JOINTYPE_ANY,`	267	`'jointype' => filter::JOINTYPE_ANY,`
264	`'count' => 2,`	268	`'count' => 2,`
265	`'expectedusers' => [`	269	`'expectedusers' => [`
266	`'a',`	270	`'a',`
267	`'b',`	271	`'b',`
268	`],`	272	`],`
269	`],`	273	`],`
270	`'ANY: Filter on student, teacher' => (object) [`	274	`'ANY: Filter on student, teacher' => (object) [`
271	`'roles' => ['student', 'teacher'],`	275	`'testroles' => ['student', 'teacher'],`
272	`'jointype' => filter::JOINTYPE_ANY,`	276	`'jointype' => filter::JOINTYPE_ANY,`
273	`'count' => 4,`	277	`'count' => 4,`
274	`'expectedusers' => [`	278	`'expectedusers' => [`
275	`'a',`	279	`'a',`
276	`'b',`	280	`'b',`
277	`'e',`	281	`'e',`
278	`'f',`	282	`'f',`
279	`],`	283	`],`
280	`],`	284	`],`
281	`'ANY: Filter on student, manager (category level role)' => (object) [`	285	`'ANY: Filter on student, manager (category level role)' => (object) [`
282	`'roles' => ['student', 'manager'],`	286	`'testroles' => ['student', 'manager'],`
283	`'jointype' => filter::JOINTYPE_ANY,`	287	`'jointype' => filter::JOINTYPE_ANY,`
284	`'count' => 3,`	288	`'count' => 3,`
285	`'expectedusers' => [`	289	`'expectedusers' => [`
286	`'a',`	290	`'a',`
287	`'b',`	291	`'b',`
288	`'h',`	292	`'h',`
289	`],`	293	`],`
290	`],`	294	`],`
291	`'ANY: Filter on student, coursecreator (not assigned)' => (object) [`	295	`'ANY: Filter on student, coursecreator (not assigned)' => (object) [`
292	`'roles' => ['student', 'coursecreator'],`	296	`'testroles' => ['student', 'coursecreator'],`
293	`'jointype' => filter::JOINTYPE_ANY,`	297	`'jointype' => filter::JOINTYPE_ANY,`
294	`'count' => 2,`	298	`'count' => 2,`
295	`'expectedusers' => [`	299	`'expectedusers' => [`
296	`'a',`	300	`'a',`
297	`'b',`	301	`'b',`
298	`],`	302	`],`
299	`],`	303	`],`
Línea 300...	Línea 304...
300		304
301	`// Tests for jointype: ALL.`	305	`// Tests for jointype: ALL.`
302	`'ALL: No role filter' => (object) [`	306	`'ALL: No role filter' => (object) [`
303	`'roles' => [],`	307	`'testroles' => [],`
304	`'jointype' => filter::JOINTYPE_ALL,`	308	`'jointype' => filter::JOINTYPE_ALL,`
305	`'count' => 8,`	309	`'count' => 8,`
306	`'expectedusers' => [`	310	`'expectedusers' => [`
307	`'a',`	311	`'a',`
Línea 313...	Línea 317...
313	`'g',`	317	`'g',`
314	`'h',`	318	`'h',`
315	`],`	319	`],`
316	`],`	320	`],`
317	`'ALL: Filter on student' => (object) [`	321	`'ALL: Filter on student' => (object) [`
318	`'roles' => ['student'],`	322	`'testroles' => ['student'],`
319	`'jointype' => filter::JOINTYPE_ALL,`	323	`'jointype' => filter::JOINTYPE_ALL,`
320	`'count' => 2,`	324	`'count' => 2,`
321	`'expectedusers' => [`	325	`'expectedusers' => [`
322	`'a',`	326	`'a',`
323	`'b',`	327	`'b',`
324	`],`	328	`],`
325	`],`	329	`],`
326	`'ALL: Filter on student, teacher' => (object) [`	330	`'ALL: Filter on student, teacher' => (object) [`
327	`'roles' => ['student', 'teacher'],`	331	`'testroles' => ['student', 'teacher'],`
328	`'jointype' => filter::JOINTYPE_ALL,`	332	`'jointype' => filter::JOINTYPE_ALL,`
329	`'count' => 0,`	333	`'count' => 0,`
330	`'expectedusers' => [],`	334	`'expectedusers' => [],`
331	`],`	335	`],`
332	`'ALL: Filter on student, manager (category level role))' => (object) [`	336	`'ALL: Filter on student, manager (category level role))' => (object) [`
333	`'roles' => ['student', 'manager'],`	337	`'testroles' => ['student', 'manager'],`
334	`'jointype' => filter::JOINTYPE_ALL,`	338	`'jointype' => filter::JOINTYPE_ALL,`
335	`'count' => 0,`	339	`'count' => 0,`
336	`'expectedusers' => [],`	340	`'expectedusers' => [],`
337	`],`	341	`],`
338	`'ALL: Filter on student, coursecreator (not assigned))' => (object) [`	342	`'ALL: Filter on student, coursecreator (not assigned))' => (object) [`
339	`'roles' => ['student', 'coursecreator'],`	343	`'testroles' => ['student', 'coursecreator'],`
340	`'jointype' => filter::JOINTYPE_ALL,`	344	`'jointype' => filter::JOINTYPE_ALL,`
341	`'count' => 0,`	345	`'count' => 0,`
342	`'expectedusers' => [],`	346	`'expectedusers' => [],`
343	`],`	347	`],`
Línea 344...	Línea 348...
344		348
345	`// Tests for jointype: NONE.`	349	`// Tests for jointype: NONE.`
346	`'NONE: No role filter' => (object) [`	350	`'NONE: No role filter' => (object) [`
347	`'roles' => [],`	351	`'testroles' => [],`
348	`'jointype' => filter::JOINTYPE_NONE,`	352	`'jointype' => filter::JOINTYPE_NONE,`
349	`'count' => 8,`	353	`'count' => 8,`
350	`'expectedusers' => [`	354	`'expectedusers' => [`
351	`'a',`	355	`'a',`
Línea 357...	Línea 361...
357	`'g',`	361	`'g',`
358	`'h',`	362	`'h',`
359	`],`	363	`],`
360	`],`	364	`],`
361	`'NONE: Filter on student' => (object) [`	365	`'NONE: Filter on student' => (object) [`
362	`'roles' => ['student'],`	366	`'testroles' => ['student'],`
363	`'jointype' => filter::JOINTYPE_NONE,`	367	`'jointype' => filter::JOINTYPE_NONE,`
364	`'count' => 6,`	368	`'count' => 6,`
365	`'expectedusers' => [`	369	`'expectedusers' => [`
366	`'c',`	370	`'c',`
367	`'d',`	371	`'d',`
Línea 370...	Línea 374...
370	`'g',`	374	`'g',`
371	`'h',`	375	`'h',`
372	`],`	376	`],`
373	`],`	377	`],`
374	`'NONE: Filter on student, teacher' => (object) [`	378	`'NONE: Filter on student, teacher' => (object) [`
375	`'roles' => ['student', 'teacher'],`	379	`'testroles' => ['student', 'teacher'],`
376	`'jointype' => filter::JOINTYPE_NONE,`	380	`'jointype' => filter::JOINTYPE_NONE,`
377	`'count' => 4,`	381	`'count' => 4,`
378	`'expectedusers' => [`	382	`'expectedusers' => [`
379	`'c',`	383	`'c',`
380	`'d',`	384	`'d',`
381	`'g',`	385	`'g',`
382	`'h',`	386	`'h',`
383	`],`	387	`],`
384	`],`	388	`],`
385	`'NONE: Filter on student, manager (category level role))' => (object) [`	389	`'NONE: Filter on student, manager (category level role))' => (object) [`
386	`'roles' => ['student', 'manager'],`	390	`'testroles' => ['student', 'manager'],`
387	`'jointype' => filter::JOINTYPE_NONE,`	391	`'jointype' => filter::JOINTYPE_NONE,`
388	`'count' => 5,`	392	`'count' => 5,`
389	`'expectedusers' => [`	393	`'expectedusers' => [`
390	`'c',`	394	`'c',`
391	`'d',`	395	`'d',`
Línea 393...	Línea 397...
393	`'f',`	397	`'f',`
394	`'g',`	398	`'g',`
395	`],`	399	`],`
396	`],`	400	`],`
397	`'NONE: Filter on student, coursecreator (not assigned))' => (object) [`	401	`'NONE: Filter on student, coursecreator (not assigned))' => (object) [`
398	`'roles' => ['student', 'coursecreator'],`	402	`'testroles' => ['student', 'coursecreator'],`
399	`'jointype' => filter::JOINTYPE_NONE,`	403	`'jointype' => filter::JOINTYPE_NONE,`
400	`'count' => 6,`	404	`'count' => 6,`
401	`'expectedusers' => [`	405	`'expectedusers' => [`
402	`'c',`	406	`'c',`
403	`'d',`	407	`'d',`
Línea 408...	Línea 412...
408	`],`	412	`],`
409	`],`	413	`],`
410	`],`	414	`],`
411	`],`	415	`],`
412	`'Users with multiple roles' => (object) [`	416	`'Users with multiple roles' => (object) [`
413	`'users' => [`	417	`'usersdata' => [`
414	`'a' => [`	418	`'a' => [`
415	`'courseroles' => [`	419	`'courseroles' => [`
416	`'student',`	420	`'student',`
417	`],`	421	`],`
418	`],`	422	`],`
Línea 468...	Línea 472...
468	`],`	472	`],`
469	`],`	473	`],`
470	`'expect' => [`	474	`'expect' => [`
471	`// Tests for jointype: ANY.`	475	`// Tests for jointype: ANY.`
472	`'ANY: No role filter' => (object) [`	476	`'ANY: No role filter' => (object) [`
473	`'roles' => [],`	477	`'testroles' => [],`
474	`'jointype' => filter::JOINTYPE_ANY,`	478	`'jointype' => filter::JOINTYPE_ANY,`
475	`'count' => 8,`	479	`'count' => 8,`
476	`'expectedusers' => [`	480	`'expectedusers' => [`
477	`'a',`	481	`'a',`
478	`'b',`	482	`'b',`
Línea 483...	Línea 487...
483	`'g',`	487	`'g',`
484	`'h',`	488	`'h',`
485	`],`	489	`],`
486	`],`	490	`],`
487	`'ANY: Filter on student' => (object) [`	491	`'ANY: Filter on student' => (object) [`
488	`'roles' => ['student'],`	492	`'testroles' => ['student'],`
489	`'jointype' => filter::JOINTYPE_ANY,`	493	`'jointype' => filter::JOINTYPE_ANY,`
490	`'count' => 2,`	494	`'count' => 2,`
491	`'expectedusers' => [`	495	`'expectedusers' => [`
492	`'a',`	496	`'a',`
493	`'b',`	497	`'b',`
494	`],`	498	`],`
495	`],`	499	`],`
496	`'ANY: Filter on teacher' => (object) [`	500	`'ANY: Filter on teacher' => (object) [`
497	`'roles' => ['teacher'],`	501	`'testroles' => ['teacher'],`
498	`'jointype' => filter::JOINTYPE_ANY,`	502	`'jointype' => filter::JOINTYPE_ANY,`
499	`'count' => 3,`	503	`'count' => 3,`
500	`'expectedusers' => [`	504	`'expectedusers' => [`
501	`'b',`	505	`'b',`
502	`'e',`	506	`'e',`
503	`'f',`	507	`'f',`
504	`],`	508	`],`
505	`],`	509	`],`
506	`'ANY: Filter on editingteacher' => (object) [`	510	`'ANY: Filter on editingteacher' => (object) [`
507	`'roles' => ['editingteacher'],`	511	`'testroles' => ['editingteacher'],`
508	`'jointype' => filter::JOINTYPE_ANY,`	512	`'jointype' => filter::JOINTYPE_ANY,`
509	`'count' => 3,`	513	`'count' => 3,`
510	`'expectedusers' => [`	514	`'expectedusers' => [`
511	`'c',`	515	`'c',`
512	`'d',`	516	`'d',`
513	`'e',`	517	`'e',`
514	`],`	518	`],`
515	`],`	519	`],`
516	`'ANY: Filter on student, teacher' => (object) [`	520	`'ANY: Filter on student, teacher' => (object) [`
517	`'roles' => ['student', 'teacher'],`	521	`'testroles' => ['student', 'teacher'],`
518	`'jointype' => filter::JOINTYPE_ANY,`	522	`'jointype' => filter::JOINTYPE_ANY,`
519	`'count' => 4,`	523	`'count' => 4,`
520	`'expectedusers' => [`	524	`'expectedusers' => [`
521	`'a',`	525	`'a',`
522	`'b',`	526	`'b',`
523	`'e',`	527	`'e',`
524	`'f',`	528	`'f',`
525	`],`	529	`],`
526	`],`	530	`],`
527	`'ANY: Filter on teacher, editingteacher' => (object) [`	531	`'ANY: Filter on teacher, editingteacher' => (object) [`
528	`'roles' => ['teacher', 'editingteacher'],`	532	`'testroles' => ['teacher', 'editingteacher'],`
529	`'jointype' => filter::JOINTYPE_ANY,`	533	`'jointype' => filter::JOINTYPE_ANY,`
530	`'count' => 5,`	534	`'count' => 5,`
531	`'expectedusers' => [`	535	`'expectedusers' => [`
532	`'b',`	536	`'b',`
533	`'c',`	537	`'c',`
Línea 535...	Línea 539...
535	`'e',`	539	`'e',`
536	`'f',`	540	`'f',`
537	`],`	541	`],`
538	`],`	542	`],`
539	`'ANY: Filter on student, manager (category level role)' => (object) [`	543	`'ANY: Filter on student, manager (category level role)' => (object) [`
540	`'roles' => ['student', 'manager'],`	544	`'testroles' => ['student', 'manager'],`
541	`'jointype' => filter::JOINTYPE_ANY,`	545	`'jointype' => filter::JOINTYPE_ANY,`
542	`'count' => 3,`	546	`'count' => 3,`
543	`'expectedusers' => [`	547	`'expectedusers' => [`
544	`'a',`	548	`'a',`
545	`'b',`	549	`'b',`
546	`'h',`	550	`'h',`
547	`],`	551	`],`
548	`],`	552	`],`
549	`'ANY: Filter on student, coursecreator (not assigned)' => (object) [`	553	`'ANY: Filter on student, coursecreator (not assigned)' => (object) [`
550	`'roles' => ['student', 'coursecreator'],`	554	`'testroles' => ['student', 'coursecreator'],`
551	`'jointype' => filter::JOINTYPE_ANY,`	555	`'jointype' => filter::JOINTYPE_ANY,`
552	`'count' => 2,`	556	`'count' => 2,`
553	`'expectedusers' => [`	557	`'expectedusers' => [`
554	`'a',`	558	`'a',`
555	`'b',`	559	`'b',`
556	`],`	560	`],`
557	`],`	561	`],`
Línea 558...	Línea 562...
558		562
559	`// Tests for jointype: ALL.`	563	`// Tests for jointype: ALL.`
560	`'ALL: No role filter' => (object) [`	564	`'ALL: No role filter' => (object) [`
561	`'roles' => [],`	565	`'testroles' => [],`
562	`'jointype' => filter::JOINTYPE_ALL,`	566	`'jointype' => filter::JOINTYPE_ALL,`
563	`'count' => 8,`	567	`'count' => 8,`
564	`'expectedusers' => [`	568	`'expectedusers' => [`
565	`'a',`	569	`'a',`
Línea 571...	Línea 575...
571	`'g',`	575	`'g',`
572	`'h',`	576	`'h',`
573	`],`	577	`],`
574	`],`	578	`],`
575	`'ALL: Filter on student' => (object) [`	579	`'ALL: Filter on student' => (object) [`
576	`'roles' => ['student'],`	580	`'testroles' => ['student'],`
577	`'jointype' => filter::JOINTYPE_ALL,`	581	`'jointype' => filter::JOINTYPE_ALL,`
578	`'count' => 2,`	582	`'count' => 2,`
579	`'expectedusers' => [`	583	`'expectedusers' => [`
580	`'a',`	584	`'a',`
581	`'b',`	585	`'b',`
582	`],`	586	`],`
583	`],`	587	`],`
584	`'ALL: Filter on teacher' => (object) [`	588	`'ALL: Filter on teacher' => (object) [`
585	`'roles' => ['teacher'],`	589	`'testroles' => ['teacher'],`
586	`'jointype' => filter::JOINTYPE_ALL,`	590	`'jointype' => filter::JOINTYPE_ALL,`
587	`'count' => 3,`	591	`'count' => 3,`
588	`'expectedusers' => [`	592	`'expectedusers' => [`
589	`'b',`	593	`'b',`
590	`'e',`	594	`'e',`
591	`'f',`	595	`'f',`
592	`],`	596	`],`
593	`],`	597	`],`
594	`'ALL: Filter on editingteacher' => (object) [`	598	`'ALL: Filter on editingteacher' => (object) [`
595	`'roles' => ['editingteacher'],`	599	`'testroles' => ['editingteacher'],`
596	`'jointype' => filter::JOINTYPE_ALL,`	600	`'jointype' => filter::JOINTYPE_ALL,`
597	`'count' => 3,`	601	`'count' => 3,`
598	`'expectedusers' => [`	602	`'expectedusers' => [`
599	`'c',`	603	`'c',`
600	`'d',`	604	`'d',`
601	`'e',`	605	`'e',`
602	`],`	606	`],`
603	`],`	607	`],`
604	`'ALL: Filter on student, teacher' => (object) [`	608	`'ALL: Filter on student, teacher' => (object) [`
605	`'roles' => ['student', 'teacher'],`	609	`'testroles' => ['student', 'teacher'],`
606	`'jointype' => filter::JOINTYPE_ALL,`	610	`'jointype' => filter::JOINTYPE_ALL,`
607	`'count' => 1,`	611	`'count' => 1,`
608	`'expectedusers' => [`	612	`'expectedusers' => [`
609	`'b',`	613	`'b',`
610	`],`	614	`],`
611	`],`	615	`],`
612	`'ALL: Filter on teacher, editingteacher' => (object) [`	616	`'ALL: Filter on teacher, editingteacher' => (object) [`
613	`'roles' => ['teacher', 'editingteacher'],`	617	`'testroles' => ['teacher', 'editingteacher'],`
614	`'jointype' => filter::JOINTYPE_ALL,`	618	`'jointype' => filter::JOINTYPE_ALL,`
615	`'count' => 1,`	619	`'count' => 1,`
616	`'expectedusers' => [`	620	`'expectedusers' => [`
617	`'e',`	621	`'e',`
618	`],`	622	`],`
619	`],`	623	`],`
620	`'ALL: Filter on student, manager (category level role)' => (object) [`	624	`'ALL: Filter on student, manager (category level role)' => (object) [`
621	`'roles' => ['student', 'manager'],`	625	`'testroles' => ['student', 'manager'],`
622	`'jointype' => filter::JOINTYPE_ALL,`	626	`'jointype' => filter::JOINTYPE_ALL,`
623	`'count' => 0,`	627	`'count' => 0,`
624	`'expectedusers' => [],`	628	`'expectedusers' => [],`
625	`],`	629	`],`
626	`'ALL: Filter on student, coursecreator (not assigned)' => (object) [`	630	`'ALL: Filter on student, coursecreator (not assigned)' => (object) [`
627	`'roles' => ['student', 'coursecreator'],`	631	`'testroles' => ['student', 'coursecreator'],`
628	`'jointype' => filter::JOINTYPE_ALL,`	632	`'jointype' => filter::JOINTYPE_ALL,`
629	`'count' => 0,`	633	`'count' => 0,`
630	`'expectedusers' => [],`	634	`'expectedusers' => [],`
631	`],`	635	`],`
Línea 632...	Línea 636...
632		636
633	`// Tests for jointype: NONE.`	637	`// Tests for jointype: NONE.`
634	`'NONE: No role filter' => (object) [`	638	`'NONE: No role filter' => (object) [`
635	`'roles' => [],`	639	`'testroles' => [],`
636	`'jointype' => filter::JOINTYPE_NONE,`	640	`'jointype' => filter::JOINTYPE_NONE,`
637	`'count' => 8,`	641	`'count' => 8,`
638	`'expectedusers' => [`	642	`'expectedusers' => [`
639	`'a',`	643	`'a',`
Línea 645...	Línea 649...
645	`'g',`	649	`'g',`
646	`'h',`	650	`'h',`
647	`],`	651	`],`
648	`],`	652	`],`
649	`'NONE: Filter on student' => (object) [`	653	`'NONE: Filter on student' => (object) [`
650	`'roles' => ['student'],`	654	`'testroles' => ['student'],`
651	`'jointype' => filter::JOINTYPE_NONE,`	655	`'jointype' => filter::JOINTYPE_NONE,`
652	`'count' => 6,`	656	`'count' => 6,`
653	`'expectedusers' => [`	657	`'expectedusers' => [`
654	`'c',`	658	`'c',`
655	`'d',`	659	`'d',`
Línea 658...	Línea 662...
658	`'g',`	662	`'g',`
659	`'h',`	663	`'h',`
660	`],`	664	`],`
661	`],`	665	`],`
662	`'NONE: Filter on teacher' => (object) [`	666	`'NONE: Filter on teacher' => (object) [`
663	`'roles' => ['teacher'],`	667	`'testroles' => ['teacher'],`
664	`'jointype' => filter::JOINTYPE_NONE,`	668	`'jointype' => filter::JOINTYPE_NONE,`
665	`'count' => 5,`	669	`'count' => 5,`
666	`'expectedusers' => [`	670	`'expectedusers' => [`
667	`'a',`	671	`'a',`
668	`'c',`	672	`'c',`
Línea 670...	Línea 674...
670	`'g',`	674	`'g',`
671	`'h',`	675	`'h',`
672	`],`	676	`],`
673	`],`	677	`],`
674	`'NONE: Filter on editingteacher' => (object) [`	678	`'NONE: Filter on editingteacher' => (object) [`
675	`'roles' => ['editingteacher'],`	679	`'testroles' => ['editingteacher'],`
676	`'jointype' => filter::JOINTYPE_NONE,`	680	`'jointype' => filter::JOINTYPE_NONE,`
677	`'count' => 5,`	681	`'count' => 5,`
678	`'expectedusers' => [`	682	`'expectedusers' => [`
679	`'a',`	683	`'a',`
680	`'b',`	684	`'b',`
Línea 682...	Línea 686...
682	`'g',`	686	`'g',`
683	`'h',`	687	`'h',`
684	`],`	688	`],`
685	`],`	689	`],`
686	`'NONE: Filter on student, teacher' => (object) [`	690	`'NONE: Filter on student, teacher' => (object) [`
687	`'roles' => ['student', 'teacher'],`	691	`'testroles' => ['student', 'teacher'],`
688	`'jointype' => filter::JOINTYPE_NONE,`	692	`'jointype' => filter::JOINTYPE_NONE,`
689	`'count' => 4,`	693	`'count' => 4,`
690	`'expectedusers' => [`	694	`'expectedusers' => [`
691	`'c',`	695	`'c',`
692	`'d',`	696	`'d',`
693	`'g',`	697	`'g',`
694	`'h',`	698	`'h',`
695	`],`	699	`],`
696	`],`	700	`],`
697	`'NONE: Filter on teacher, editingteacher' => (object) [`	701	`'NONE: Filter on teacher, editingteacher' => (object) [`
698	`'roles' => ['teacher', 'editingteacher'],`	702	`'testroles' => ['teacher', 'editingteacher'],`
699	`'jointype' => filter::JOINTYPE_NONE,`	703	`'jointype' => filter::JOINTYPE_NONE,`
700	`'count' => 3,`	704	`'count' => 3,`
701	`'expectedusers' => [`	705	`'expectedusers' => [`
702	`'a',`	706	`'a',`
703	`'g',`	707	`'g',`
704	`'h',`	708	`'h',`
705	`],`	709	`],`
706	`],`	710	`],`
707	`'NONE: Filter on student, manager (category level role)' => (object) [`	711	`'NONE: Filter on student, manager (category level role)' => (object) [`
708	`'roles' => ['student', 'manager'],`	712	`'testroles' => ['student', 'manager'],`
709	`'jointype' => filter::JOINTYPE_NONE,`	713	`'jointype' => filter::JOINTYPE_NONE,`
710	`'count' => 5,`	714	`'count' => 5,`
711	`'expectedusers' => [`	715	`'expectedusers' => [`
712	`'c',`	716	`'c',`
713	`'d',`	717	`'d',`
Línea 715...	Línea 719...
715	`'f',`	719	`'f',`
716	`'g',`	720	`'g',`
717	`],`	721	`],`
718	`],`	722	`],`
719	`'NONE: Filter on student, coursecreator (not assigned)' => (object) [`	723	`'NONE: Filter on student, coursecreator (not assigned)' => (object) [`
720	`'roles' => ['student', 'coursecreator'],`	724	`'testroles' => ['student', 'coursecreator'],`
721	`'jointype' => filter::JOINTYPE_NONE,`	725	`'jointype' => filter::JOINTYPE_NONE,`
722	`'count' => 6,`	726	`'count' => 6,`
723	`'expectedusers' => [`	727	`'expectedusers' => [`
724	`'c',`	728	`'c',`
725	`'d',`	729	`'d',`
Línea 735...	Línea 739...
735		739
736	`$finaltests = [];`	740	`$finaltests = [];`
737	`foreach ($tests as $testname => $testdata) {`	741	`foreach ($tests as $testname => $testdata) {`
738	`foreach ($testdata->expect as $expectname => $expectdata) {`	742	`foreach ($testdata->expect as $expectname => $expectdata) {`
739	`$finaltests["{$testname} => {$expectname}"] = [`	743	`$finaltests["{$testname} => {$expectname}"] = [`
740	`'users' => $testdata->users,`	744	`'usersdata' => $testdata->usersdata,`
741	`'roles' => $expectdata->roles,`	745	`'testroles' => $expectdata->testroles,`
742	`'jointype' => $expectdata->jointype,`	746	`'jointype' => $expectdata->jointype,`
743	`'count' => $expectdata->count,`	747	`'count' => $expectdata->count,`
744	`'expectedusers' => $expectdata->expectedusers,`	748	`'expectedusers' => $expectdata->expectedusers,`
745	`];`	749	`];`
Línea 777...	Línea 781...
777	`$filterset->add_filter(new integer_filter('courseid', null, [(int) $course->id]));`	781	`$filterset->add_filter(new integer_filter('courseid', null, [(int) $course->id]));`
778	`$filterset->add_filter(new string_filter('country', $jointype, $countries));`	782	`$filterset->add_filter(new string_filter('country', $jointype, $countries));`
Línea 779...	Línea 783...
779		783
780	`// Run the search, assert count matches the number of expected users.`	784	`// Run the search, assert count matches the number of expected users.`
781	`$search = new participants_search($course, context_course::instance($course->id), $filterset);`	-
782	`$this->assertEquals(count($expectedusers), $search->get_total_participants_count());`	-
783		785	`$search = new participants_search($course, context_course::instance($course->id), $filterset);`
-		786	`$rs = $search->get_participants();`
-		787	`$totalparticipants = $rs->current()->fullcount ?? 0;`
-		788	`$this->assertEquals(count($expectedusers), $totalparticipants);`
784	`$rs = $search->get_participants();`	789
Línea 785...	Línea 790...
785	`$this->assertInstanceOf(moodle_recordset::class, $rs);`	790	`$this->assertInstanceOf(moodle_recordset::class, $rs);`
786		791
787	`// Assert that each expected user is within the participant records.`	792	`// Assert that each expected user is within the participant records.`
Línea 794...	Línea 799...
794	`/**`	799	`/**`
795	`* Data provider for {@see test_country_filter}`	800	`* Data provider for {@see test_country_filter}`
796	`*`	801	`*`
797	`* @return array`	802	`* @return array`
798	`*/`	803	`*/`
799	`public function country_provider(): array {`	804	`public static function country_provider(): array {`
800	`$tests = [`	805	`$tests = [`
801	`'users' => [`	806	`'usersdata' => [`
802	`'user1' => 'DE',`	807	`'user1' => 'DE',`
803	`'user2' => 'ES',`	808	`'user2' => 'ES',`
804	`'user3' => 'ES',`	809	`'user3' => 'ES',`
805	`'user4' => 'GB',`	810	`'user4' => 'GB',`
806	`],`	811	`],`
Línea 903...	Línea 908...
903	`];`	908	`];`

Proyectos de Subversion Moodle

(root)/user/tests/table/participants_search_test.php – Rev 11 → 1441