WebSVN – Moodle – Diff – /reportbuilder/tests/local/helpers/report_test.php

 declare(strict_types=1);
 namespace core_reportbuilder\local\helpers;
 use advanced_testcase;
-use advanced_testcase;
-use core_reportbuilder_generator;
+use core\context\system;
-use invalid_parameter_exception;
+use core_reportbuilder_generator;
-use core_reportbuilder\datasource;
+use core_reportbuilder\{datasource, system_report_factory};
-use core_reportbuilder\local\models\column;
+use core_reportbuilder\local\models\{audience, column, filter, schedule};
-use core_reportbuilder\local\models\filter;
+use core_reportbuilder\local\systemreports\report_access_list;
+use core_tag_tag;
-use core_tag_tag;
+use core_user\reportbuilder\datasource\users;
-use core_user\reportbuilder\datasource\users;
+use invalid_parameter_exception;
 /**
  * Unit tests for the report helper class
+ *
  * @package     core_reportbuilder
  * @covers      \core_reportbuilder\local\helpers\report
  * @copyright   2021 Paul Holden <paulh@moodle.com>
  * @license     http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  */
-class report_test extends advanced_testcase {
+final class report_test extends advanced_testcase {
             'tags' => ['cat', 'dog'],
         ]);
         $this->assertEquals('My report with tags', $report->get('name'));
         $this->assertEquals(datasource::TYPE_CUSTOM_REPORT, $report->get('type'));
+        $this->assertEqualsCanonicalizing(
-        $this->assertEqualsCanonicalizing(['cat', 'dog'],
+            ['cat', 'dog'],
+            array_values(core_tag_tag::get_item_tags_array('core_reportbuilder', 'reportbuilder_report', $report->get('id'))),
-            core_tag_tag::get_item_tags_array('core_reportbuilder', 'reportbuilder_report', $report->get('id')));
+        );
         $report = report::create_report((object) [
             'name' => 'My report without tags',
             'tags' => ['cat', 'dog'],
         ]);
         $this->assertEquals('My renamed report adding tags', $reportupdated->get('name'));
         $this->assertTrue($reportupdated->get('uniquerows'));
+        $this->assertEqualsCanonicalizing(
-        $this->assertEqualsCanonicalizing(['cat', 'dog'],
+            ['cat', 'dog'],
+            array_values(core_tag_tag::get_item_tags_array('core_reportbuilder', 'reportbuilder_report', $reportupdated->get('id'))),
+        );
+    }
+    /**
+     * Test duplicate report
+     */
+    public function test_duplicate_report(): void {
+        $this->resetAfterTest();
+        $this->setAdminUser();
+        /** @var core_reportbuilder_generator $generator */
+        $generator = $this->getDataGenerator()->get_plugin_generator('core_reportbuilder');
+        // Create custom report containing single column, condition and filter..
+        $report = $generator->create_report(['name' => 'Report 1', 'source' => users::class, 'default' => 0]);
+        $column = $generator->create_column(['reportid' => $report->get('id'), 'uniqueidentifier' => 'user:lastname']);
+        $condition = $generator->create_condition(['reportid' => $report->get('id'), 'uniqueidentifier' => 'user:firstname']);
+        $filter = $generator->create_filter(['reportid' => $report->get('id'), 'uniqueidentifier' => 'user:email']);
+        // Add an audience and schedule.
+        $audience = $generator->create_audience(['reportid' => $report->get('id'), 'configdata' => []]);
+        $schedule = $generator->create_schedule([
+            'reportid' => $report->get('id'),
+            'name' => 'My schedule',
+            'audiences' => json_encode([
+                $audience->get_persistent()->get('id'),
+            ]),
+        ]);
+        // Duplicate report with audiences and schedules.
+        $newreport = report::duplicate_report($report, 'Report 1 copy', true, true);
+        $this->assertNotEquals($report->get('id'), $newreport->get('id'));
+        $this->assertEquals('Report 1 copy', $newreport->get('name'));
+        $this->assertEquals(users::class, $newreport->get('source'));
+        // Assert new report columns.
+        $newcolumns = column::get_records(['reportid' => $newreport->get('id')]);
+        $this->assertCount(1, $newcolumns);
+        [$newcolumn] = $newcolumns;
+        $this->assertNotEquals($column->get('id'), $newcolumn->get('id'));
+        $this->assertEquals('user:lastname', $newcolumn->get('uniqueidentifier'));
+        // Assert new report conditions.
+        $newconditions = filter::get_condition_records($newreport->get('id'));
+        $this->assertCount(1, $newconditions);
+        [$newcondition] = $newconditions;
+        $this->assertNotEquals($condition->get('id'), $newcondition->get('id'));
+        $this->assertEquals('user:firstname', $newcondition->get('uniqueidentifier'));
+        // Assert new report filters.
+        $newfilters = filter::get_filter_records($newreport->get('id'));
+        $this->assertCount(1, $newfilters);
+        [$newfilter] = $newfilters;
+        $this->assertNotEquals($filter->get('id'), $newfilter->get('id'));
+        $this->assertEquals('user:email', $newfilter->get('uniqueidentifier'));
+        // Assert new report audiences.
+        $newaudiences = audience::get_records(['reportid' => $newreport->get('id')]);
+        $this->assertCount(1, $newaudiences);
+        [$newaudience] = $newaudiences;
+        $this->assertNotEquals($audience->get_persistent()->get('id'), $newaudience->get('id'));
+         // Assert new report schedules.
+        $newschedules = schedule::get_records(['reportid' => $newreport->get('id')]);
+        $this->assertCount(1, $newschedules);
+        [$newschedule] = $newschedules;
+        $this->assertNotEquals($schedule->get('id'), $newschedule->get('id'));
+        $this->assertEquals([
+            $newaudience->get('id'),
+        ], (array) json_decode($newschedule->get('audiences')));
+        // Duplicate report without schedules.
+        $newreporttwo = report::duplicate_report($report, 'Report 1 copy #2', true, false);
+        $this->assertEquals(1, column::count_records(['reportid' => $newreporttwo->get('id')]));
+        $this->assertEquals(1, filter::count_records(['reportid' => $newreporttwo->get('id'), 'iscondition' => 1]));
+        $this->assertEquals(1, filter::count_records(['reportid' => $newreporttwo->get('id'), 'iscondition' => 0]));
+        $this->assertEquals(1, audience::count_records(['reportid' => $newreporttwo->get('id')]));
+        $this->assertEquals(0, schedule::count_records(['reportid' => $newreporttwo->get('id')]));
+        // Duplicate report without audiences or schedules.
+        $newreportthree = report::duplicate_report($report, 'Report 1 copy #3', false, false);
+        $this->assertEquals(1, column::count_records(['reportid' => $newreportthree->get('id')]));
+        $this->assertEquals(1, filter::count_records(['reportid' => $newreportthree->get('id'), 'iscondition' => 1]));
+        $this->assertEquals(1, filter::count_records(['reportid' => $newreportthree->get('id'), 'iscondition' => 0]));
+        $this->assertEquals(0, audience::count_records(['reportid' => $newreportthree->get('id')]));
-            core_tag_tag::get_item_tags_array('core_reportbuilder', 'reportbuilder_report', $reportupdated->get('id')));
+        $this->assertEquals(0, schedule::count_records(['reportid' => $newreportthree->get('id')]));
+    }
     /**
         $this->expectException(invalid_parameter_exception::class);
         $this->expectExceptionMessage('Invalid filter');
         report::reorder_report_filter($report->get('id'), 42, 1);
+    }
+    /**
+     * Test getting row count for a custom report
+     */
+    public function test_get_report_row_count_custom_report(): void {
+        $this->resetAfterTest();
+        $this->getDataGenerator()->create_user();
+        /** @var core_reportbuilder_generator $generator */
+        $generator = $this->getDataGenerator()->get_plugin_generator('core_reportbuilder');
+        $report = $generator->create_report(['name' => 'My report', 'source' => users::class]);
+        // There are two users, the admin plus the user we just created.
+        $this->assertEquals(2, report::get_report_row_count($report->get('id')));
+    }
+    /**
+     * Test getting row count for a system report
+     */
+    public function test_get_report_row_count_system_report(): void {
+        $this->resetAfterTest();
+        $this->setAdminUser();
+        $this->getDataGenerator()->create_user();
+        /** @var core_reportbuilder_generator $generator */
+        $generator = $this->getDataGenerator()->get_plugin_generator('core_reportbuilder');
+        $report = $generator->create_report(['name' => 'My report', 'source' => users::class]);
+        $generator->create_audience(['reportid' => $report->get('id'), 'configdata' => []]);
+        $reportaccesslist = system_report_factory::create(
+            report_access_list::class,
+            system::instance(),
+            parameters: ['id' => $report->get('id')],
+        )->get_report_persistent();
+        // There are two users, the admin plus the user we just created.
+        $this->assertEquals(
+,
+            report::get_report_row_count($reportaccesslist->get('id'), ['id' => $report->get('id')],
+        ));
+    }

Proyectos de Subversion Moodle

(root)/reportbuilder/tests/local/helpers/report_test.php – Rev 1 → 1441