. /** * This page handles listing of quiz overrides * * @package mod * @subpackage quiz * @copyright 2010 Matt Petro * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ require_once(dirname(__FILE__) . '/../../config.php'); require_once($CFG->dirroot.'/mod/quiz/lib.php'); require_once($CFG->dirroot.'/mod/quiz/locallib.php'); require_once($CFG->dirroot.'/mod/quiz/override_form.php'); $cmid = required_param('cmid', PARAM_INT); // course module ID, or $mode = optional_param('mode', '', PARAM_ALPHA); // one of 'user' or 'group', default is 'group' if (! $cm = get_coursemodule_from_id('quiz', $cmid)) { print_error('invalidcoursemodule'); } if (! $quiz = $DB->get_record('quiz', array('id' => $cm->instance))) { print_error('invalidcoursemodule'); } $course = $DB->get_record('course', array('id'=>$cm->course), '*', MUST_EXIST); // Get the course groups $groups = groups_get_all_groups($cm->course); if ($groups === false) { $groups = array(); } // 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/quiz/overrides.php', array('cmid'=>$cm->id, 'mode'=>$mode)); $PAGE->set_url($url); require_login($course, false, $cm); $context = get_context_instance(CONTEXT_MODULE, $cm->id); // Check the user has the required capabilities to list overrides require_capability('mod/quiz:manageoverrides', $context); // Display a list of overrides $PAGE->set_pagelayout('admin'); $PAGE->set_title(get_string('overrides', 'quiz')); $PAGE->set_heading($course->fullname); echo $OUTPUT->header(); // Delete orphaned group overrides $sql = 'SELECT o.id FROM {quiz_overrides} o LEFT JOIN {groups} g ON o.groupid = g.id WHERE o.groupid IS NOT NULL AND g.id IS NULL AND o.quiz = ?'; $params = array($quiz->id); $orphaned = $DB->get_records_sql($sql, $params); if (!empty($orphaned)) { $DB->delete_records_list('quiz_overrides', 'id', array_keys($orphaned)); } // Fetch all overrides if ($groupmode) { $colname = get_string('group'); $sql = 'SELECT o.*, g.name FROM {quiz_overrides} o JOIN {groups} g ON o.groupid = g.id WHERE o.quiz = ? ORDER BY g.name'; } else { $colname = get_string('user'); $sql = 'SELECT o.*, u.firstname, u.lastname FROM {quiz_overrides} o JOIN {user} u ON o.userid = u.id WHERE o.quiz = ? ORDER BY u.lastname, u.firstname'; } $params = array($quiz->id); $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', 'quiz'), 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/quiz/overridedelete.php'); $overrideediturl = new moodle_url('/mod/quiz/overrideedit.php'); $hasinactive = false; // are there any inactive overrides foreach ($overrides as $override) { $fields = array(); $values = array(); $active = true; // check for inactive overrides if (!$groupmode) { if (!has_capability('mod/quiz:attempt', $context, $override->userid)) { // user not allowed to take the quiz $active = false; } else if (!empty($CFG->enablegroupmembersonly) && $cm->groupmembersonly && !groups_has_membership($cm, $override->userid)) { // user does not belong to the current grouping $active = false; } } // Format timeopen if (isset($override->timeopen)) { $fields[] = get_string('quizopens', 'quiz'); $values[] = $override->timeopen > 0 ? userdate($override->timeopen) : get_string('noopen', 'quiz'); } // Format timeclose if (isset($override->timeclose)) { $fields[] = get_string('quizcloses', 'quiz'); $values[] = $override->timeclose > 0 ? userdate($override->timeclose) : get_string('noclose', 'quiz'); } // Format timelimit if (isset($override->timelimit)) { $fields[] = get_string('timelimit', 'quiz'); $values[] = $override->timelimit > 0 ? format_time($override->timelimit) : get_string('none', 'quiz'); } // Format number of attempts if (isset($override->attempts)) { $fields[] = get_string('attempts', 'quiz'); $values[] = $override->attempts > 0 ? $override->attempts : get_string('unlimited'); } // Format password if (isset($override->password)) { $fields[] = get_string('requirepassword', 'quiz'); $values[] = $override->password !== '' ? get_string('enabled', 'quiz') : get_string('none', 'quiz'); } // Icons: $iconstr = ''; if ($active) { // edit $editurlstr = $overrideediturl->out(true, array('id' => $override->id)); $iconstr = '' . '' .
                get_string('edit') . ' '; // duplicate $copyurlstr = $overrideediturl->out(true, array('id' => $override->id, 'action' => 'duplicate')); $iconstr .= '' . '' .
                get_string('copy') . ' '; } // delete $deleteurlstr = $overridedeleteurl->out(true, array('id' => $override->id, 'sesskey' => sesskey())); $iconstr .= '' . '' .
            get_string('delete') . ' '; if ($groupmode) { $usergroupstr = '' . $override->name . ''; } else { $usergroupstr = '' . 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' => 'quizoverrides')); if (count($table->data)) { echo html_writer::table($table); } if ($hasinactive) { echo $OUTPUT->notification(get_string('inactiveoverridehelp', 'quiz'), 'dimmed_text'); } 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', 'quiz'), 'error'); $options['disabled'] = true; } echo $OUTPUT->single_button($overrideediturl->out(true, array('action' => 'addgroup', 'cmid' => $cm->id)), get_string('addnewgroupoverride', 'quiz'), 'post', $options); } else { $users = array(); // See if there are any students in the quiz if (!empty($CFG->enablegroupmembersonly) && $cm->groupmembersonly) { // restrict to grouping $limitgroups = groups_get_all_groups($cm->course, 0, $cm->groupingid); if (!empty($limitgroups)) { $users = get_users_by_capability($context, 'mod/quiz:attempt', 'u.id', '', '', 1, array_keys($limitgroups)); // Limit to one user for speed } } else { // Limit to one user for speed. $users = get_users_by_capability($context, 'mod/quiz:attempt', 'u.id'); } if (empty($users)) { // there are no students echo $OUTPUT->notification(get_string('usersnone', 'quiz'), 'error'); $options['disabled'] = true; } echo $OUTPUT->single_button($overrideediturl->out(true, array('action' => 'adduser', 'cmid' => $cm->id)), get_string('addnewuseroverride', 'quiz'), 'post', $options); } echo html_writer::end_tag('div'); echo html_writer::end_tag('div'); // Finish the page echo $OUTPUT->footer();