| 1 | efrain | 1 | <?php
 | 
        
           |  |  | 2 | // This file is part of Moodle - http://moodle.org/
 | 
        
           |  |  | 3 | //
 | 
        
           |  |  | 4 | // Moodle is free software: you can redistribute it and/or modify
 | 
        
           |  |  | 5 | // it under the terms of the GNU General Public License as published by
 | 
        
           |  |  | 6 | // the Free Software Foundation, either version 3 of the License, or
 | 
        
           |  |  | 7 | // (at your option) any later version.
 | 
        
           |  |  | 8 | //
 | 
        
           |  |  | 9 | // Moodle is distributed in the hope that it will be useful,
 | 
        
           |  |  | 10 | // but WITHOUT ANY WARRANTY; without even the implied warranty of
 | 
        
           |  |  | 11 | // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 | 
        
           |  |  | 12 | // GNU General Public License for more details.
 | 
        
           |  |  | 13 | //
 | 
        
           |  |  | 14 | // You should have received a copy of the GNU General Public License
 | 
        
           |  |  | 15 | // along with Moodle.  If not, see <http://www.gnu.org/licenses/>.
 | 
        
           |  |  | 16 |   | 
        
           |  |  | 17 | declare(strict_types=1);
 | 
        
           |  |  | 18 |   | 
        
           |  |  | 19 | namespace core_reportbuilder\external\columns;
 | 
        
           |  |  | 20 |   | 
        
           |  |  | 21 | use core_reportbuilder_generator;
 | 
        
           |  |  | 22 | use core_external\external_api;
 | 
        
           |  |  | 23 | use externallib_advanced_testcase;
 | 
        
           |  |  | 24 | use core_reportbuilder\report_access_exception;
 | 
        
           |  |  | 25 | use core_reportbuilder\local\models\column;
 | 
        
           |  |  | 26 | use core_user\reportbuilder\datasource\users;
 | 
        
           |  |  | 27 |   | 
        
           |  |  | 28 | defined('MOODLE_INTERNAL') || die();
 | 
        
           |  |  | 29 |   | 
        
           |  |  | 30 | global $CFG;
 | 
        
           |  |  | 31 | require_once("{$CFG->dirroot}/webservice/tests/helpers.php");
 | 
        
           |  |  | 32 |   | 
        
           |  |  | 33 | /**
 | 
        
           |  |  | 34 |  * Unit tests of external class for re-ordering report columns
 | 
        
           |  |  | 35 |  *
 | 
        
           |  |  | 36 |  * @package     core_reportbuilder
 | 
        
           |  |  | 37 |  * @covers      \core_reportbuilder\external\columns\reorder
 | 
        
           |  |  | 38 |  * @copyright   2021 Paul Holden <paulh@moodle.com>
 | 
        
           |  |  | 39 |  * @license     http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 | 
        
           |  |  | 40 |  */
 | 
        
           |  |  | 41 | class reorder_test extends externallib_advanced_testcase {
 | 
        
           |  |  | 42 |   | 
        
           |  |  | 43 |     /**
 | 
        
           |  |  | 44 |      * Text execute method
 | 
        
           |  |  | 45 |      */
 | 
        
           |  |  | 46 |     public function test_execute(): void {
 | 
        
           |  |  | 47 |         $this->resetAfterTest();
 | 
        
           |  |  | 48 |         $this->setAdminUser();
 | 
        
           |  |  | 49 |   | 
        
           |  |  | 50 |         /** @var core_reportbuilder_generator $generator */
 | 
        
           |  |  | 51 |         $generator = $this->getDataGenerator()->get_plugin_generator('core_reportbuilder');
 | 
        
           |  |  | 52 |   | 
        
           |  |  | 53 |         $report = $generator->create_report([
 | 
        
           |  |  | 54 |             'name' => 'My report',
 | 
        
           |  |  | 55 |             'source' => users::class,
 | 
        
           |  |  | 56 |             'default' => false,
 | 
        
           |  |  | 57 |         ]);
 | 
        
           |  |  | 58 |   | 
        
           |  |  | 59 |         // Add four columns.
 | 
        
           |  |  | 60 |         $generator->create_column(['reportid' => $report->get('id'), 'uniqueidentifier' => 'user:fullname']);
 | 
        
           |  |  | 61 |         $generator->create_column(['reportid' => $report->get('id'), 'uniqueidentifier' => 'user:email']);
 | 
        
           |  |  | 62 |         $generator->create_column(['reportid' => $report->get('id'), 'uniqueidentifier' => 'user:country']);
 | 
        
           |  |  | 63 |         $columncity = $generator->create_column(['reportid' => $report->get('id'), 'uniqueidentifier' => 'user:city']);
 | 
        
           |  |  | 64 |   | 
        
           |  |  | 65 |         // Move the city column to second position.
 | 
        
           |  |  | 66 |         $result = reorder::execute($report->get('id'), $columncity->get('id'), 2);
 | 
        
           |  |  | 67 |         $result = external_api::clean_returnvalue(reorder::execute_returns(), $result);
 | 
        
           |  |  | 68 |         $this->assertTrue($result);
 | 
        
           |  |  | 69 |   | 
        
           |  |  | 70 |         // Assert report columns order.
 | 
        
           |  |  | 71 |         $columns = column::get_records(['reportid' => $report->get('id')], 'columnorder');
 | 
        
           |  |  | 72 |   | 
        
           |  |  | 73 |         $columnidentifiers = array_map(static function(column $column): string {
 | 
        
           |  |  | 74 |             return $column->get('uniqueidentifier');
 | 
        
           |  |  | 75 |         }, $columns);
 | 
        
           |  |  | 76 |   | 
        
           |  |  | 77 |         $this->assertEquals([
 | 
        
           |  |  | 78 |             'user:fullname',
 | 
        
           |  |  | 79 |             'user:city',
 | 
        
           |  |  | 80 |             'user:email',
 | 
        
           |  |  | 81 |             'user:country',
 | 
        
           |  |  | 82 |         ], $columnidentifiers);
 | 
        
           |  |  | 83 |     }
 | 
        
           |  |  | 84 |   | 
        
           |  |  | 85 |     /**
 | 
        
           |  |  | 86 |      * Test execute method for a user without permission to edit reports
 | 
        
           |  |  | 87 |      */
 | 
        
           |  |  | 88 |     public function test_execute_access_exception(): void {
 | 
        
           |  |  | 89 |         $this->resetAfterTest();
 | 
        
           |  |  | 90 |   | 
        
           |  |  | 91 |         /** @var core_reportbuilder_generator $generator */
 | 
        
           |  |  | 92 |         $generator = $this->getDataGenerator()->get_plugin_generator('core_reportbuilder');
 | 
        
           |  |  | 93 |   | 
        
           |  |  | 94 |         $report = $generator->create_report(['name' => 'My report', 'source' => users::class]);
 | 
        
           |  |  | 95 |         $column = $generator->create_column(['reportid' => $report->get('id'), 'uniqueidentifier' => 'user:email']);
 | 
        
           |  |  | 96 |   | 
        
           |  |  | 97 |         $user = $this->getDataGenerator()->create_user();
 | 
        
           |  |  | 98 |         $this->setUser($user);
 | 
        
           |  |  | 99 |   | 
        
           |  |  | 100 |         $this->expectException(report_access_exception::class);
 | 
        
           |  |  | 101 |         $this->expectExceptionMessage('You cannot edit this report');
 | 
        
           |  |  | 102 |         reorder::execute($report->get('id'), $column->get('id'), 1);
 | 
        
           |  |  | 103 |     }
 | 
        
           |  |  | 104 | }
 |