You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
117 lines
4.9 KiB
117 lines
4.9 KiB
<?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/>.
|
|
|
|
/**
|
|
* Report of unsupported role assignments,
|
|
* unsupported role assignments can be dropped from here.
|
|
*
|
|
* @package tool
|
|
* @subpackage unsuproles
|
|
* @copyright 2010 Petr Skoda {@link http://skodak.org}
|
|
* @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
|
|
*/
|
|
|
|
require_once(__DIR__ . '/../../../config.php');
|
|
require_once($CFG->libdir.'/adminlib.php');
|
|
|
|
$action = optional_param('action', '', PARAM_ALPHANUMEXT);
|
|
|
|
|
|
admin_externalpage_setup('toolunsuproles'); // checks permissions specified in settings.php
|
|
|
|
if ($action === 'delete') {
|
|
$contextlevel = required_param('contextlevel', PARAM_INT);
|
|
$roleid = required_param('roleid', PARAM_INT);
|
|
$confirm = optional_param('confirm', 0, PARAM_BOOL);
|
|
|
|
$role = $DB->get_record('role', array('id'=>$roleid), '*', MUST_EXIST);
|
|
|
|
if ($confirm and confirm_sesskey()) {
|
|
$sql = "SELECT ra.*
|
|
FROM {role_assignments} ra
|
|
JOIN {context} c ON c.id = ra.contextid
|
|
LEFT JOIN {role_context_levels} rcl ON (rcl.roleid = ra.roleid AND rcl.contextlevel = c.contextlevel)
|
|
WHERE rcl.id IS NULL AND ra.roleid = :roleid AND c.contextlevel = :contextlevel";
|
|
$ras = $DB->get_records_sql($sql, array('roleid'=>$roleid, 'contextlevel'=>$contextlevel));
|
|
foreach ($ras as $ra) {
|
|
if (!empty($ra->component)) {
|
|
//bad luck, we can not mess with plugin ras!
|
|
//TODO: explain why not possible to remove ras
|
|
continue;
|
|
}
|
|
role_unassign($ra->roleid, $ra->userid, $ra->contextid);
|
|
}
|
|
redirect($PAGE->url);
|
|
}
|
|
//show confirmation
|
|
echo $OUTPUT->header();
|
|
$yesurl = new moodle_url($PAGE->url, array('roleid'=>$roleid, 'contextlevel'=>$contextlevel, 'action'=>'delete', 'confirm'=>1, 'sesskey'=>sesskey()));
|
|
$levelname = context_helper::get_level_name($contextlevel);
|
|
$rolename = format_string($role->name);
|
|
$message = get_string('confirmdelete', 'tool_unsuproles', array('level'=>$levelname, 'role'=>$rolename));
|
|
echo $OUTPUT->confirm($message, $yesurl, $PAGE->url);
|
|
echo $OUTPUT->footer();
|
|
die();
|
|
}
|
|
|
|
|
|
echo $OUTPUT->header();
|
|
echo $OUTPUT->heading(get_string('pluginname', 'tool_unsuproles'));
|
|
|
|
$sql = "SELECT r.id AS roleid, c.contextlevel, r.sortorder, COUNT(ra.id) AS racount
|
|
FROM {role} r
|
|
JOIN {role_assignments} ra ON ra.roleid = r.id
|
|
JOIN {context} c ON c.id = ra.contextid
|
|
LEFT JOIN {role_context_levels} rcl ON (rcl.roleid = r.id AND rcl.contextlevel = c.contextlevel)
|
|
WHERE rcl.id IS NULL
|
|
GROUP BY r.id, c.contextlevel, r.sortorder
|
|
ORDER BY c.contextlevel ASC, r.sortorder ASC";
|
|
//print the overview table
|
|
|
|
$problems = array();
|
|
$rs = $DB->get_recordset_sql($sql);
|
|
foreach ($rs as $problem) {
|
|
$problems[] = $problem;
|
|
}
|
|
$rs->close();
|
|
|
|
if (!$problems) {
|
|
echo $OUTPUT->notification(get_string('noprolbems', 'tool_unsuproles'), 'notifysuccess');
|
|
} else {
|
|
$roles = get_all_roles();
|
|
$data = array();
|
|
foreach ($problems as $problem) {
|
|
$levelname = context_helper::get_level_name($problem->contextlevel);
|
|
$rolename = role_get_name($roles[$problem->roleid]);
|
|
//TODO: show list of users if count low
|
|
$count = $problem->racount;
|
|
$edit = array();
|
|
$aurl = new moodle_url('/admin/roles/define.php', array('roleid'=>$problem->roleid, 'action'=>'edit'));
|
|
$edit[] = html_writer::link($aurl, $OUTPUT->pix_icon('t/edit', 'core', get_string('edit')));
|
|
$aurl = new moodle_url($PAGE->url, array('roleid'=>$problem->roleid, 'contextlevel'=>$problem->contextlevel, 'action'=>'delete'));
|
|
$edit[] = html_writer::link($aurl, $OUTPUT->pix_icon('t/delete', 'core', get_string('delete')));
|
|
$data[] = array($levelname, $rolename, $count, implode(' ', $edit));
|
|
}
|
|
$table = new html_table();
|
|
$table->head = array(get_string('contextlevel', 'tool_unsuproles'), get_string('role'), get_string('count', 'tool_unsuproles'), get_string('edit'));
|
|
$table->size = array('40%', '40%', '10%', '10%');
|
|
$table->align = array('left', 'left', 'center', 'center');
|
|
$table->width = '90%';
|
|
$table->data = $data;
|
|
echo html_writer::table($table);
|
|
}
|
|
|
|
echo $OUTPUT->footer();
|
|
|