Proyectos de Subversion Moodle

    /**

     * Test creating participants report, with aggregated last access date (minimum and maximum)

     */

    public function test_course_last_access_aggregation(): void {

        $this->resetAfterTest();

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

        $userone = $this->getDataGenerator()->create_and_enrol($course);

        $useronelastaccess = $this->getDataGenerator()->create_user_course_lastaccess($userone, $course, 1622502000);

        $usertwo = $this->getDataGenerator()->create_and_enrol($course);

        $usertwolastaccess = $this->getDataGenerator()->create_user_course_lastaccess($usertwo, $course, 1622847600);

        /** @var core_reportbuilder_generator $generator */

        $generator = $this->getDataGenerator()->get_plugin_generator('core_reportbuilder');

        $report = $generator->create_report(['name' => 'Participants', 'source' => participants::class, 'default' => 0]);

        $generator->create_column(['reportid' => $report->get('id'), 'uniqueidentifier' => 'course:fullname']);

        $column = $generator->create_column(['reportid' => $report->get('id'), 'uniqueidentifier' => 'access:timeaccess']);

        // Course aggregated with "Minimum" last access.

        $column->set('aggregation', 'min')->update();

        $content = $this->get_custom_report_content($report->get('id'));

        $this->assertEquals([

            [$course->fullname, userdate($useronelastaccess->timeaccess)],

        ], array_map('array_values', $content));

        // Course aggregated with "Maximum" last access.

        $column->set('aggregation', 'max')->update();

        $content = $this->get_custom_report_content($report->get('id'));

        $this->assertEquals([

            [$course->fullname, userdate($usertwolastaccess->timeaccess)],

        ], array_map('array_values', $content));

    }

    /**

     * Test creating participants report, with aggregated days taking course column

     */

    public function test_completion_days_taking_course_aggregation(): void {

        $this->resetAfterTest();

        $courseone = $this->getDataGenerator()->create_course(['fullname' => 'Course 1', 'startdate' => 1622502000]);

        $coursetwo = $this->getDataGenerator()->create_course(['fullname' => 'Course 2']);

        // User one completed the course in two days.

        $userone = $this->getDataGenerator()->create_and_enrol($courseone);

        $completion = new completion_completion(['course' => $courseone->id, 'userid' => $userone->id]);

        $completion->mark_complete(1622502000 + (2 * DAYSECS));

        // User two completed the course in three days (lazy bum).

        $usertwo = $this->getDataGenerator()->create_and_enrol($courseone);

        $completion = new completion_completion(['course' => $courseone->id, 'userid' => $usertwo->id]);

        $completion->mark_complete(1622502000 + (3 * DAYSECS));

        /** @var core_reportbuilder_generator $generator */

        $generator = $this->getDataGenerator()->get_plugin_generator('core_reportbuilder');

        $report = $generator->create_report(['name' => 'Participants', 'source' => participants::class, 'default' => 0]);

        $generator->create_column(['reportid' => $report->get('id'), 'uniqueidentifier' => 'course:fullname', 'sortenabled' => 1]);

        $generator->create_column([

            'reportid' => $report->get('id'),

            'uniqueidentifier' => 'completion:dayscourse',

            'aggregation' => 'avg',

        ]);

        $content = $this->get_custom_report_content($report->get('id'));

        $this->assertEquals([

            [$courseone->fullname, '2.5'],

            [$coursetwo->fullname, ''],

        ], array_map('array_values', $content));

    }