Search moodle.org's
Developer Documentation

See Release Notes
Long Term Support Release

  • Bug fixes for general core bugs in 4.1.x will end 13 November 2023 (12 months).
  • Bug fixes for security issues in 4.1.x will end 10 November 2025 (36 months).
  • PHP version: minimum PHP 7.4.0 Note: minimum PHP version has increased since Moodle 4.0. PHP 8.0.x is supported too.
<?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/>.

/**
 * This page handles listing of assign overrides
 *
 * @package    mod_assign
 * @copyright  2016 Ilya Tregubov
 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */


require_once(dirname(__FILE__) . '/../../config.php');
require_once($CFG->dirroot.'/mod/assign/lib.php');
require_once($CFG->dirroot.'/mod/assign/locallib.php');
require_once($CFG->dirroot.'/mod/assign/override_form.php');


$cmid = required_param('cmid', PARAM_INT);
$mode = optional_param('mode', '', PARAM_ALPHA); // One of 'user' or 'group', default is 'group'.

$action   = optional_param('action', '', PARAM_ALPHA);
$redirect = $CFG->wwwroot.'/mod/assign/overrides.php?cmid=' . $cmid . '&amp;mode=group';

list($course, $cm) = get_course_and_cm_from_cmid($cmid, 'assign');
$assign = $DB->get_record('assign', array('id' => $cm->instance), '*', MUST_EXIST);

require_login($course, false, $cm);

$context = context_module::instance($cm->id);

// Check the user has the required capabilities to list overrides.
require_capability('mod/assign:manageoverrides', $context);

$assigngroupmode = groups_get_activity_groupmode($cm);
$accessallgroups = ($assigngroupmode == NOGROUPS) || has_capability('moodle/site:accessallgroups', $context);

$overridecountgroup = $DB->count_records('assign_overrides', array('userid' => null, 'assignid' => $assign->id));

// Get the course groups that the current user can access.
$groups = $accessallgroups ? groups_get_all_groups($cm->course) : groups_get_activity_allowed_groups($cm);

// Default mode is "group", unless there are no groups.
if ($mode != "user" and $mode != "group") {
    if (!empty($groups)) {
        $mode = "group";
    } else {
        $mode = "user";
    }
}
$groupmode = ($mode == "group");

$url = new moodle_url('/mod/assign/overrides.php', array('cmid' => $cm->id, 'mode' => $mode));

$PAGE->set_url($url);
> navigation_node::override_active_url(new moodle_url('/mod/assign/overrides.php', ['cmid' => $cmid]));
if ($action == 'movegroupoverride') { $id = required_param('id', PARAM_INT); $dir = required_param('dir', PARAM_ALPHA); if (confirm_sesskey()) { move_group_override($id, $dir, $assign->id); } redirect($redirect); } // Display a list of overrides. $PAGE->set_pagelayout('admin');
> $PAGE->add_body_class('limitedwidth');
$PAGE->set_title(get_string('overrides', 'assign')); $PAGE->set_heading($course->fullname);
> $activityheader = $PAGE->activityheader; echo $OUTPUT->header(); > $activityheader->set_attrs([ echo $OUTPUT->heading(format_string($assign->name, true, array('context' => $context))); > 'description' => '', > 'hidecompletion' => true, // Delete orphaned group overrides. > 'title' => $activityheader->is_title_allowed() ? format_string($assign->name, true, ['context' => $context]) : "" $sql = 'SELECT o.id > ]);
< echo $OUTPUT->heading(format_string($assign->name, true, array('context' => $context)));
> echo $OUTPUT->heading(get_string('overrides', 'mod_assign'), 2); > $overridemenu = new \mod_assign\output\override_actionmenu($url, $cm); > $renderer = $PAGE->get_renderer('mod_assign'); > echo $renderer->render($overridemenu);
LEFT JOIN {groups} g ON o.groupid = g.id WHERE o.groupid IS NOT NULL AND g.id IS NULL AND o.assignid = ?'; $params = array($assign->id); $orphaned = $DB->get_records_sql($sql, $params); if (!empty($orphaned)) { $DB->delete_records_list('assign_overrides', 'id', array_keys($orphaned)); } $overrides = []; // Fetch all overrides. if ($groupmode) { $colname = get_string('group'); // To filter the result by the list of groups that the current user has access to. if ($groups) { $params = ['assignid' => $assign->id]; list($insql, $inparams) = $DB->get_in_or_equal(array_keys($groups), SQL_PARAMS_NAMED); $params += $inparams; $sql = "SELECT o.*, g.name FROM {assign_overrides} o JOIN {groups} g ON o.groupid = g.id WHERE o.assignid = :assignid AND g.id $insql ORDER BY o.sortorder"; $overrides = $DB->get_records_sql($sql, $params); } } else { $colname = get_string('user'); list($sort, $params) = users_order_by_sql('u'); $params['assignid'] = $assign->id; $userfieldsapi = \core_user\fields::for_name(); if ($accessallgroups) { $sql = 'SELECT o.*, ' . $userfieldsapi->get_sql('u', false, '', '', false)->selects . ' FROM {assign_overrides} o JOIN {user} u ON o.userid = u.id WHERE o.assignid = :assignid ORDER BY ' . $sort; $overrides = $DB->get_records_sql($sql, $params); } else if ($groups) { list($insql, $inparams) = $DB->get_in_or_equal(array_keys($groups), SQL_PARAMS_NAMED); $params += $inparams; $sql = 'SELECT o.*, ' . $userfieldsapi->get_sql('u', false, '', '', false)->selects . ' FROM {assign_overrides} o JOIN {user} u ON o.userid = u.id JOIN {groups_members} gm ON u.id = gm.userid WHERE o.assignid = :assignid AND gm.groupid ' . $insql . ' ORDER BY ' . $sort; $overrides = $DB->get_records_sql($sql, $params); } } // Initialise table. $table = new html_table(); $table->headspan = array(1, 2, 1); $table->colclasses = array('colname', 'colsetting', 'colvalue', 'colaction'); $table->head = array( $colname, get_string('overrides', 'assign'), get_string('action'), ); $userurl = new moodle_url('/user/view.php', array()); $groupurl = new moodle_url('/group/overview.php', array('id' => $cm->course)); $overridedeleteurl = new moodle_url('/mod/assign/overridedelete.php'); $overrideediturl = new moodle_url('/mod/assign/overrideedit.php'); $hasinactive = false; // Whether there are any inactive overrides. foreach ($overrides as $override) { $fields = array(); $values = array(); $active = true; // Check for inactive overrides. if (!$groupmode) { if (!is_enrolled($context, $override->userid)) { // User not enrolled. $active = false; } else if (!\core_availability\info_module::is_user_visible($cm, $override->userid)) { // User cannot access the module. $active = false; } } // Format allowsubmissionsfromdate. if (isset($override->allowsubmissionsfromdate)) { $fields[] = get_string('open', 'assign'); $values[] = $override->allowsubmissionsfromdate > 0 ? userdate($override->allowsubmissionsfromdate) : get_string('noopen', 'assign'); } // Format duedate. if (isset($override->duedate)) { $fields[] = get_string('duedate', 'assign'); $values[] = $override->duedate > 0 ? userdate($override->duedate) : get_string('noclose', 'assign'); } // Format cutoffdate. if (isset($override->cutoffdate)) { $fields[] = get_string('cutoffdate', 'assign'); $values[] = $override->cutoffdate > 0 ? userdate($override->cutoffdate) : get_string('noclose', 'assign'); }
> // Format timelimit. // Icons. > if (isset($override->timelimit)) { $iconstr = ''; > $fields[] = get_string('timelimit', 'assign'); > $values[] = $override->timelimit > 0 ? format_time($override->timelimit) : get_string('none', 'assign'); // Edit. > } $editurlstr = $overrideediturl->out(true, array('id' => $override->id)); >
$iconstr = '<a title="' . get_string('edit') . '" href="'. $editurlstr . '">' . $OUTPUT->pix_icon('t/edit', get_string('edit')) . '</a> '; // Duplicate. $copyurlstr = $overrideediturl->out(true, array('id' => $override->id, 'action' => 'duplicate')); $iconstr .= '<a title="' . get_string('copy') . '" href="' . $copyurlstr . '">' . $OUTPUT->pix_icon('t/copy', get_string('copy')) . '</a> '; // Delete. $deleteurlstr = $overridedeleteurl->out(true, array('id' => $override->id, 'sesskey' => sesskey())); $iconstr .= '<a title="' . get_string('delete') . '" href="' . $deleteurlstr . '">' . $OUTPUT->pix_icon('t/delete', get_string('delete')) . '</a> '; if ($groupmode) {
< $usergroupstr = '<a href="' . $groupurl->out(true, < array('group' => $override->groupid)) . '" >' . $override->name . '</a>';
> $usergroupstr = '<a href="' . $groupurl->out(true, ['group' => $override->groupid]) . '" >' . > format_string($override->name, true, ['context' => $context]) . '</a>';
// Move up. if ($override->sortorder > 1) { $iconstr .= '<a title="'.get_string('moveup').'" href="overrides.php?cmid=' . $cmid . '&amp;id=' . $override->id .'&amp;action=movegroupoverride&amp;dir=up&amp;sesskey='.sesskey().'">' . $OUTPUT->pix_icon('t/up', get_string('moveup')) . '</a> '; } else { $iconstr .= $OUTPUT->spacer() . ' '; } // Move down. if ($override->sortorder < $overridecountgroup) { $iconstr .= '<a title="'.get_string('movedown').'" href="overrides.php?cmid='.$cmid. '&amp;id=' . $override->id . '&amp;action=movegroupoverride&amp;dir=down&amp;sesskey='.sesskey().'">' . $OUTPUT->pix_icon('t/down', get_string('movedown')) . '</a> '; } else { $iconstr .= $OUTPUT->spacer() . ' '; } } else { $usergroupstr = html_writer::link($userurl->out(false, array('id' => $override->userid, 'course' => $course->id)), fullname($override)); } $class = ''; if (!$active) { $class = "dimmed_text"; $usergroupstr .= '*'; $hasinactive = true; } $usergroupcell = new html_table_cell(); $usergroupcell->rowspan = count($fields); $usergroupcell->text = $usergroupstr; $actioncell = new html_table_cell(); $actioncell->rowspan = count($fields); $actioncell->text = $iconstr; for ($i = 0; $i < count($fields); ++$i) { $row = new html_table_row(); $row->attributes['class'] = $class; if ($i == 0) { $row->cells[] = $usergroupcell; } $cell1 = new html_table_cell(); $cell1->text = $fields[$i]; $row->cells[] = $cell1; $cell2 = new html_table_cell(); $cell2->text = $values[$i]; $row->cells[] = $cell2; if ($i == 0) { $row->cells[] = $actioncell; } $table->data[] = $row; } } // Output the table and button. echo html_writer::start_tag('div', array('id' => 'assignoverrides')); if (count($table->data)) { echo html_writer::table($table);
> } else { } > if ($groupmode) { if ($hasinactive) { > echo $OUTPUT->notification(get_string('nogroupoverrides', 'mod_assign'), 'info'); echo $OUTPUT->notification(get_string('inactiveoverridehelp', 'assign'), 'dimmed_text'); > } else { } > echo $OUTPUT->notification(get_string('nouseroverrides', 'mod_assign'), 'info'); > }
echo html_writer::start_tag('div', array('class' => 'buttons'));
>
$options = array(); if ($groupmode) { if (empty($groups)) { // There are no groups. echo $OUTPUT->notification(get_string('groupsnone', 'assign'), 'error'); $options['disabled'] = true; }
< echo $OUTPUT->single_button($overrideediturl->out(true, < array('action' => 'addgroup', 'cmid' => $cm->id)), < get_string('addnewgroupoverride', 'assign'), 'post', $options);
} else { $users = array(); // See if there are any users in the assign. if ($accessallgroups) { $users = get_enrolled_users($context, '', 0, 'u.id'); $nousermessage = get_string('usersnone', 'assign'); } else if ($groups) { $enrolledjoin = get_enrolled_join($context, 'u.id'); list($ingroupsql, $ingroupparams) = $DB->get_in_or_equal(array_keys($groups), SQL_PARAMS_NAMED); $params = $enrolledjoin->params + $ingroupparams; $sql = "SELECT u.id FROM {user} u JOIN {groups_members} gm ON gm.userid = u.id {$enrolledjoin->joins} WHERE gm.groupid $ingroupsql AND {$enrolledjoin->wheres} ORDER BY $sort"; $users = $DB->get_records_sql($sql, $params); $nousermessage = get_string('usersnone', 'assign'); } else { $nousermessage = get_string('groupsnone', 'assign'); } $info = new \core_availability\info_module($cm); $users = $info->filter_user_list($users); if (empty($users)) { // There are no users. echo $OUTPUT->notification($nousermessage, 'error'); $options['disabled'] = true; }
< echo $OUTPUT->single_button($overrideediturl->out(true, < array('action' => 'adduser', 'cmid' => $cm->id)), < get_string('addnewuseroverride', 'assign'), 'get', $options);
} echo html_writer::end_tag('div'); echo html_writer::end_tag('div'); // Finish the page. echo $OUTPUT->footer();