/lib/tests/tablelib_test.php
PHP | 791 lines | 520 code | 143 blank | 128 comment | 5 complexity | a7963fd34c0096b798d169359a271e42 MD5 | raw file
Possible License(s): BSD-3-Clause, MIT, GPL-3.0, Apache-2.0, LGPL-2.1
- <?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 tablelib.
- *
- * @package core
- * @category phpunit
- * @copyright 2013 Damyon Wiese <damyon@moodle.com>
- * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
- */
- defined('MOODLE_INTERNAL') || die();
- global $CFG;
- require_once($CFG->libdir . '/tablelib.php');
- require_once($CFG->libdir . '/tests/fixtures/testable_flexible_table.php');
- /**
- * Test some of tablelib.
- *
- * @package core
- * @category phpunit
- * @copyright 2013 Damyon Wiese <damyon@moodle.com>
- * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
- */
- class core_tablelib_testcase extends advanced_testcase {
- protected function generate_columns($cols) {
- $columns = array();
- foreach (range(0, $cols - 1) as $j) {
- array_push($columns, 'column' . $j);
- }
- return $columns;
- }
- protected function generate_headers($cols) {
- $columns = array();
- foreach (range(0, $cols - 1) as $j) {
- array_push($columns, 'Column ' . $j);
- }
- return $columns;
- }
- protected function generate_data($rows, $cols) {
- $data = array();
- foreach (range(0, $rows - 1) as $i) {
- $row = array();
- foreach (range(0, $cols - 1) as $j) {
- $val = 'row ' . $i . ' col ' . $j;
- $row['column' . $j] = $val;
- }
- array_push($data, $row);
- }
- return $data;
- }
- /**
- * Create a table with properties as passed in params, add data and output html.
- *
- * @param string[] $columns
- * @param string[] $headers
- * @param bool $sortable
- * @param bool $collapsible
- * @param string[] $suppress
- * @param string[] $nosorting
- * @param (array|object)[] $data
- * @param int $pagesize
- */
- protected function run_table_test($columns, $headers, $sortable, $collapsible, $suppress, $nosorting, $data, $pagesize) {
- $table = $this->create_and_setup_table($columns, $headers, $sortable, $collapsible, $suppress, $nosorting);
- $table->pagesize($pagesize, count($data));
- foreach ($data as $row) {
- $table->add_data_keyed($row);
- }
- $table->finish_output();
- }
- /**
- * Create a table with properties as passed in params.
- *
- * @param string[] $columns
- * @param string[] $headers
- * @param bool $sortable
- * @param bool $collapsible
- * @param string[] $suppress
- * @param string[] $nosorting
- * @return flexible_table
- */
- protected function create_and_setup_table($columns, $headers, $sortable, $collapsible, $suppress, $nosorting) {
- $table = new flexible_table('tablelib_test');
- $table->define_columns($columns);
- $table->define_headers($headers);
- $table->define_baseurl('/invalid.php');
- $table->sortable($sortable);
- $table->collapsible($collapsible);
- foreach ($suppress as $column) {
- $table->column_suppress($column);
- }
- foreach ($nosorting as $column) {
- $table->no_sorting($column);
- }
- $table->setup();
- return $table;
- }
- public function test_empty_table() {
- $this->expectOutputRegex('/' . get_string('nothingtodisplay') . '/');
- $this->run_table_test(
- array('column1', 'column2'), // Columns.
- array('Column 1', 'Column 2'), // Headers.
- true, // Sortable.
- false, // Collapsible.
- array(), // Suppress columns.
- array(), // No sorting.
- array(), // Data.
- 10 // Page size.
- );
- }
- public function test_has_next_pagination() {
- $data = $this->generate_data(11, 2);
- $columns = $this->generate_columns(2);
- $headers = $this->generate_headers(2);
- // Search for pagination controls containing 'page-link"\saria-label="Next"'.
- $this->expectOutputRegex('/page-link"\saria-label="Next page"/');
- $this->run_table_test(
- $columns,
- $headers,
- true,
- false,
- array(),
- array(),
- $data,
- 10
- );
- }
- public function test_has_hide() {
- $data = $this->generate_data(11, 2);
- $columns = $this->generate_columns(2);
- $headers = $this->generate_headers(2);
- // Search for 'hide' links in the column headers.
- $this->expectOutputRegex('/' . get_string('hide') . '/');
- $this->run_table_test(
- $columns,
- $headers,
- true,
- true,
- array(),
- array(),
- $data,
- 10
- );
- }
- public function test_has_not_hide() {
- $data = $this->generate_data(11, 2);
- $columns = $this->generate_columns(2);
- $headers = $this->generate_headers(2);
- // Make sure there are no 'hide' links in the headers.
- ob_start();
- $this->run_table_test(
- $columns,
- $headers,
- true,
- false,
- array(),
- array(),
- $data,
- 10
- );
- $output = ob_get_contents();
- ob_end_clean();
- $this->assertStringNotContainsString(get_string('hide'), $output);
- }
- public function test_has_sort() {
- $data = $this->generate_data(11, 2);
- $columns = $this->generate_columns(2);
- $headers = $this->generate_headers(2);
- // Search for pagination controls containing '1.*2</a>.*Next</a>'.
- $this->expectOutputRegex('/' . get_string('sortby') . '/');
- $this->run_table_test(
- $columns,
- $headers,
- true,
- false,
- array(),
- array(),
- $data,
- 10
- );
- }
- public function test_has_not_sort() {
- $data = $this->generate_data(11, 2);
- $columns = $this->generate_columns(2);
- $headers = $this->generate_headers(2);
- // Make sure there are no 'Sort by' links in the headers.
- ob_start();
- $this->run_table_test(
- $columns,
- $headers,
- false,
- false,
- array(),
- array(),
- $data,
- 10
- );
- $output = ob_get_contents();
- ob_end_clean();
- $this->assertStringNotContainsString(get_string('sortby'), $output);
- }
- public function test_has_not_next_pagination() {
- $data = $this->generate_data(10, 2);
- $columns = $this->generate_columns(2);
- $headers = $this->generate_headers(2);
- // Make sure there are no 'Next' links in the pagination.
- ob_start();
- $this->run_table_test(
- $columns,
- $headers,
- true,
- false,
- array(),
- array(),
- $data,
- 10
- );
- $output = ob_get_contents();
- ob_end_clean();
- $this->assertStringNotContainsString(get_string('next'), $output);
- }
- public function test_1_col() {
- $data = $this->generate_data(100, 1);
- $columns = $this->generate_columns(1);
- $headers = $this->generate_headers(1);
- $this->expectOutputRegex('/row 0 col 0/');
- $this->run_table_test(
- $columns,
- $headers,
- true,
- false,
- array(),
- array(),
- $data,
- 10
- );
- }
- public function test_empty_rows() {
- $data = $this->generate_data(1, 5);
- $columns = $this->generate_columns(5);
- $headers = $this->generate_headers(5);
- // Test that we have at least 5 columns generated for each empty row.
- $this->expectOutputRegex('/emptyrow.*r9_c4/');
- $this->run_table_test(
- $columns,
- $headers,
- true,
- false,
- array(),
- array(),
- $data,
- 10
- );
- }
- public function test_5_cols() {
- $data = $this->generate_data(100, 5);
- $columns = $this->generate_columns(5);
- $headers = $this->generate_headers(5);
- $this->expectOutputRegex('/row 0 col 0/');
- $this->run_table_test(
- $columns,
- $headers,
- true,
- false,
- array(),
- array(),
- $data,
- 10
- );
- }
- public function test_50_cols() {
- $data = $this->generate_data(100, 50);
- $columns = $this->generate_columns(50);
- $headers = $this->generate_headers(50);
- $this->expectOutputRegex('/row 0 col 0/');
- $this->run_table_test(
- $columns,
- $headers,
- true,
- false,
- array(),
- array(),
- $data,
- 10
- );
- }
- /**
- * Data provider for test_fullname_column
- *
- * @return array
- */
- public function fullname_column_provider() {
- return [
- ['language'],
- ['alternatename lastname'],
- ['firstname lastnamephonetic'],
- ];
- }
- /**
- * Test fullname column observes configured alternate fullname format configuration
- *
- * @param string $format
- * @return void
- *
- * @dataProvider fullname_column_provider
- */
- public function test_fullname_column(string $format) {
- $this->resetAfterTest();
- $this->setAdminUser();
- set_config('alternativefullnameformat', $format);
- $user = $this->getDataGenerator()->create_user();
- $table = $this->create_and_setup_table(['fullname'], [], true, false, [], []);
- $this->assertStringContainsString(fullname($user, true), $table->format_row($user)['fullname']);
- }
- /**
- * Test fullname column ignores fullname format configuration for a user with viewfullnames capability prohibited
- *
- * @param string $format
- * @return void
- *
- * @dataProvider fullname_column_provider
- */
- public function test_fullname_column_prohibit_viewfullnames(string $format) {
- global $DB, $CFG;
- $this->resetAfterTest();
- set_config('alternativefullnameformat', $format);
- $currentuser = $this->getDataGenerator()->create_user();
- $this->setUser($currentuser);
- // Prohibit the viewfullnames from the default user role.
- $userrole = $DB->get_record('role', ['id' => $CFG->defaultuserroleid]);
- role_change_permission($userrole->id, context_system::instance(), 'moodle/site:viewfullnames', CAP_PROHIBIT);
- $user = $this->getDataGenerator()->create_user();
- $table = $this->create_and_setup_table(['fullname'], [], true, false, [], []);
- $this->assertStringContainsString(fullname($user, false), $table->format_row($user)['fullname']);
- }
- public function test_get_row_html() {
- $data = $this->generate_data(1, 5);
- $columns = $this->generate_columns(5);
- $headers = $this->generate_headers(5);
- $data = array_keys(array_flip($data[0]));
- $table = new flexible_table('tablelib_test');
- $table->define_columns($columns);
- $table->define_headers($headers);
- $table->define_baseurl('/invalid.php');
- $row = $table->get_row_html($data);
- $this->assertMatchesRegularExpression('/row 0 col 0/', $row);
- $this->assertMatchesRegularExpression('/<tr class=""/', $row);
- $this->assertMatchesRegularExpression('/<td class="cell c0"/', $row);
- }
- public function test_persistent_table() {
- global $SESSION;
- $data = $this->generate_data(5, 5);
- $columns = $this->generate_columns(5);
- $headers = $this->generate_headers(5);
- // Testing without persistence first to verify that the results are different.
- $table1 = new flexible_table('tablelib_test');
- $table1->define_columns($columns);
- $table1->define_headers($headers);
- $table1->define_baseurl('/invalid.php');
- $table1->sortable(true);
- $table1->collapsible(true);
- $table1->is_persistent(false);
- $_GET['thide'] = 'column0';
- $_GET['tsort'] = 'column1';
- $_GET['tifirst'] = 'A';
- $_GET['tilast'] = 'Z';
- foreach ($data as $row) {
- $table1->add_data_keyed($row);
- }
- $table1->setup();
- // Clear session data between each new table.
- unset($SESSION->flextable);
- $table2 = new flexible_table('tablelib_test');
- $table2->define_columns($columns);
- $table2->define_headers($headers);
- $table2->define_baseurl('/invalid.php');
- $table2->sortable(true);
- $table2->collapsible(true);
- $table2->is_persistent(false);
- unset($_GET);
- foreach ($data as $row) {
- $table2->add_data_keyed($row);
- }
- $table2->setup();
- $this->assertNotEquals($table1, $table2);
- unset($SESSION->flextable);
- // Now testing with persistence to check that the tables are the same.
- $table3 = new flexible_table('tablelib_test');
- $table3->define_columns($columns);
- $table3->define_headers($headers);
- $table3->define_baseurl('/invalid.php');
- $table3->sortable(true);
- $table3->collapsible(true);
- $table3->is_persistent(true);
- $_GET['thide'] = 'column0';
- $_GET['tsort'] = 'column1';
- $_GET['tifirst'] = 'A';
- $_GET['tilast'] = 'Z';
- foreach ($data as $row) {
- $table3->add_data_keyed($row);
- }
- $table3->setup();
- unset($SESSION->flextable);
- $table4 = new flexible_table('tablelib_test');
- $table4->define_columns($columns);
- $table4->define_headers($headers);
- $table4->define_baseurl('/invalid.php');
- $table4->sortable(true);
- $table4->collapsible(true);
- $table4->is_persistent(true);
- unset($_GET);
- foreach ($data as $row) {
- $table4->add_data_keyed($row);
- }
- $table4->setup();
- $this->assertEquals($table3, $table4);
- unset($SESSION->flextable);
- // Finally, another test with no persistence, but without clearing the session data.
- $table5 = new flexible_table('tablelib_test');
- $table5->define_columns($columns);
- $table5->define_headers($headers);
- $table5->define_baseurl('/invalid.php');
- $table5->sortable(true);
- $table5->collapsible(true);
- $table5->is_persistent(true);
- $_GET['thide'] = 'column0';
- $_GET['tsort'] = 'column1';
- $_GET['tifirst'] = 'A';
- $_GET['tilast'] = 'Z';
- foreach ($data as $row) {
- $table5->add_data_keyed($row);
- }
- $table5->setup();
- $table6 = new flexible_table('tablelib_test');
- $table6->define_columns($columns);
- $table6->define_headers($headers);
- $table6->define_baseurl('/invalid.php');
- $table6->sortable(true);
- $table6->collapsible(true);
- $table6->is_persistent(true);
- unset($_GET);
- foreach ($data as $row) {
- $table6->add_data_keyed($row);
- }
- $table6->setup();
- $this->assertEquals($table5, $table6);
- }
- /**
- * Helper method for preparing tables instances in {@link self::test_can_be_reset()}.
- *
- * @param string $tableid
- * @return testable_flexible_table
- */
- protected function prepare_table_for_reset_test($tableid) {
- global $SESSION;
- unset($SESSION->flextable[$tableid]);
- $data = $this->generate_data(25, 3);
- $columns = array('column0', 'column1', 'column2');
- $headers = $this->generate_headers(3);
- $table = new testable_flexible_table($tableid);
- $table->define_baseurl('/invalid.php');
- $table->define_columns($columns);
- $table->define_headers($headers);
- $table->collapsible(true);
- $table->is_persistent(false);
- return $table;
- }
- public function test_can_be_reset() {
- // Table in its default state (as if seen for the first time), nothing to reset.
- $table = $this->prepare_table_for_reset_test(uniqid('tablelib_test_'));
- $table->setup();
- $this->assertFalse($table->can_be_reset());
- // Table in its default state with default sorting defined, nothing to reset.
- $table = $this->prepare_table_for_reset_test(uniqid('tablelib_test_'));
- $table->sortable(true, 'column1', SORT_DESC);
- $table->setup();
- $this->assertFalse($table->can_be_reset());
- // Table explicitly sorted by the default column & direction, nothing to reset.
- $table = $this->prepare_table_for_reset_test(uniqid('tablelib_test_'));
- $table->sortable(true, 'column1', SORT_DESC);
- $_GET['tsort'] = 'column1';
- $_GET['tdir'] = SORT_DESC;
- $table->setup();
- unset($_GET['tsort']);
- unset($_GET['tdir']);
- $this->assertFalse($table->can_be_reset());
- // Table explicitly sorted twice by the default column & direction, nothing to reset.
- $table = $this->prepare_table_for_reset_test(uniqid('tablelib_test_'));
- $table->sortable(true, 'column1', SORT_DESC);
- $_GET['tsort'] = 'column1';
- $_GET['tdir'] = SORT_DESC;
- $table->setup();
- $table->setup(); // Set up again to simulate the second page request.
- unset($_GET['tsort']);
- unset($_GET['tdir']);
- $this->assertFalse($table->can_be_reset());
- // Table sorted by other than default column, can be reset.
- $table = $this->prepare_table_for_reset_test(uniqid('tablelib_test_'));
- $table->sortable(true, 'column1', SORT_DESC);
- $_GET['tsort'] = 'column2';
- $table->setup();
- unset($_GET['tsort']);
- $this->assertTrue($table->can_be_reset());
- // Table sorted by other than default direction, can be reset.
- $table = $this->prepare_table_for_reset_test(uniqid('tablelib_test_'));
- $table->sortable(true, 'column1', SORT_DESC);
- $_GET['tsort'] = 'column1';
- $_GET['tdir'] = SORT_ASC;
- $table->setup();
- unset($_GET['tsort']);
- unset($_GET['tdir']);
- $this->assertTrue($table->can_be_reset());
- // Table sorted by the default column after another sorting previously selected.
- // This leads to different ORDER BY than just having a single sort defined, can be reset.
- $table = $this->prepare_table_for_reset_test(uniqid('tablelib_test_'));
- $table->sortable(true, 'column1', SORT_DESC);
- $_GET['tsort'] = 'column0';
- $table->setup();
- $_GET['tsort'] = 'column1';
- $table->setup();
- unset($_GET['tsort']);
- $this->assertTrue($table->can_be_reset());
- // Table having some column collapsed, can be reset.
- $table = $this->prepare_table_for_reset_test(uniqid('tablelib_test_'));
- $_GET['thide'] = 'column2';
- $table->setup();
- unset($_GET['thide']);
- $this->assertTrue($table->can_be_reset());
- // Table having some column explicitly expanded, nothing to reset.
- $table = $this->prepare_table_for_reset_test(uniqid('tablelib_test_'));
- $_GET['tshow'] = 'column2';
- $table->setup();
- unset($_GET['tshow']);
- $this->assertFalse($table->can_be_reset());
- // Table after expanding a collapsed column, nothing to reset.
- $table = $this->prepare_table_for_reset_test(uniqid('tablelib_test_'));
- $_GET['thide'] = 'column0';
- $table->setup();
- $_GET['tshow'] = 'column0';
- $table->setup();
- unset($_GET['thide']);
- unset($_GET['tshow']);
- $this->assertFalse($table->can_be_reset());
- // Table with some name filtering enabled, can be reset.
- $table = $this->prepare_table_for_reset_test(uniqid('tablelib_test_'));
- $_GET['tifirst'] = 'A';
- $table->setup();
- unset($_GET['tifirst']);
- $this->assertTrue($table->can_be_reset());
- }
- /**
- * Test export in CSV format
- */
- public function test_table_export() {
- $table = new flexible_table('tablelib_test_export');
- $table->define_baseurl('/invalid.php');
- $table->define_columns(['c1', 'c2', 'c3']);
- $table->define_headers(['Col1', 'Col2', 'Col3']);
- ob_start();
- $table->is_downloadable(true);
- $table->is_downloading('csv');
- $table->setup();
- $table->add_data(['column0' => 'a', 'column1' => 'b', 'column2' => 'c']);
- $output = ob_get_contents();
- ob_end_clean();
- $this->assertEquals("Col1,Col2,Col3\na,b,c\n", substr($output, 3));
- }
- /**
- * Test the initials functionality.
- *
- * @dataProvider initials_provider
- * @param string|null $getvalue
- * @param string|null $setvalue
- * @param string|null $finalvalue
- */
- public function test_initials_first_set(?string $getvalue, ?string $setvalue, ?string $finalvalue): void {
- global $_GET;
- $this->resetAfterTest(true);
- $table = new flexible_table('tablelib_test');
- $user = $this->getDataGenerator()->create_user();
- $table->define_columns(['fullname']);
- $table->define_headers(['Fullname']);
- $table->define_baseurl('/invalid.php');
- $table->initialbars(true);
- if ($getvalue !== null) {
- $_GET['tifirst'] = $getvalue;
- }
- if ($setvalue !== null) {
- $table->set_first_initial($setvalue);
- }
- $table->setup();
- $this->assertEquals($finalvalue, $table->get_initial_first());
- }
- /**
- * Test the initials functionality.
- *
- * @dataProvider initials_provider
- * @param string|null $getvalue
- * @param string|null $setvalue
- * @param string|null $finalvalue
- */
- public function test_initials_last_set(?string $getvalue, ?string $setvalue, ?string $finalvalue): void {
- global $_GET;
- $this->resetAfterTest(true);
- $table = new flexible_table('tablelib_test');
- $user = $this->getDataGenerator()->create_user();
- $table->define_columns(['fullname']);
- $table->define_headers(['Fullname']);
- $table->define_baseurl('/invalid.php');
- $table->initialbars(true);
- if ($getvalue !== null) {
- $_GET['tilast'] = $getvalue;
- }
- if ($setvalue !== null) {
- $table->set_last_initial($setvalue);
- }
- $table->setup();
- $this->assertEquals($finalvalue, $table->get_initial_last());
- }
- /**
- * Data for testing initials providers.
- *
- * @return array
- */
- public function initials_provider(): array {
- return [
- [null, null, null],
- ['A', null, 'A'],
- ['Z', null, 'Z'],
- [null, 'A', 'A'],
- [null, 'Z', 'Z'],
- ['A', 'Z', 'Z'],
- ['Z', 'A', 'A'],
- ];
- }
- }