manage.php

<?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/>.

/**
 * Custom SQL report categories.
 *
 * Users with the report/customsql:managequeries capability can create and edit
 * the custom categories.
 *
 * This page shows the list of categories, with edit icons, and an add new button
 * if you have the report/customsql:managequeries capability.
 *
 * @package report_customsql
 * @copyright 2013 The Open University
 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */

require_once(dirname(__FILE__) . '/../../config.php');
require_once(dirname(__FILE__) . '/locallib.php');
require_once($CFG->libdir . '/adminlib.php');

admin_externalpage_setup('report_customsql', '', null, '/report/customsql/manage.php');
$context = context_system::instance();
require_capability('report/customsql:managecategories', $context);
$PAGE->navbar->add(get_string('managecategories', 'report_customsql'), report_customsql_url('manage.php'));

echo $OUTPUT->header() . $OUTPUT->heading(get_string('managecategories', 'report_customsql'));

$categories = $DB->get_records('report_customsql_categories', null, 'name ASC');

echo html_writer::tag('p', get_string('addcategorydesc', 'report_customsql'));

if (!empty($categories)) {
    foreach ($categories as $category) {
        echo html_writer::start_tag('div');

        echo ' ' . html_writer::link(
            report_customsql_url(
                'category.php',
                ['id' => $category->id]
            ),
            format_string($category->name) . ' ',
            ['class' => 'report_customsql'],
        ) . html_writer::tag(
            'a',
            $OUTPUT->pix_icon(
                't/edit',
                get_string('edit'),
            ),
            [
                'title' => get_string(
                    'editcategoryx',
                    'report_customsql',
                    format_string($category->name)
                ),
                'href' => report_customsql_url('addcategory.php?id=' . $category->id),
            ]
        );

        if ($category->id != 1 && !$DB->record_exists('report_customsql_queries', ['categoryid' => $category->id])) {
            echo ' ' .  html_writer::tag(
                'a',
                $OUTPUT->pix_icon('t/delete', get_string('delete')),
                [
                    'title' => get_string(
                        'deletecategoryx',
                        'report_customsql',
                        format_string($category->name)
                    ),
                    'href' => report_customsql_url('categorydelete.php?id=' . $category->id),
                ]
            );
        }

        echo html_writer::end_tag('div');
    }
}

echo $OUTPUT->single_button(
    report_customsql_url('addcategory.php'),
    get_string('addcategory', 'report_customsql')
);

echo $OUTPUT->footer();