echo $output->render($eventSelect);
// Show user list if the user has permission to see other people's messages
if ($canAdminUsers) {
$optionSet = array(0 => get_string('optionallusers', 'block_moodletxt'));
$userList = $userDAO->getAllUsers();
foreach ($userList as $userObj) {
$optionSet[$userObj->getId()] = $userObj->getFullNameForDisplay();
}
$userSelect = new single_select(new moodle_url('sent.php', array('course' => $courseId, 'instance' => $instanceId, 'events' => $includeEvents)), 'user', $optionSet, $userToView, false);
$userSelect->set_label(get_string('labelshowmessagesforuser', 'block_moodletxt'));
echo $output->render($userSelect);
}
}
// Figure out which table item the user wants to sort by
$orderBy = '';
foreach ($table->get_sort_columns() as $field => $direction) {
switch ($field) {
case 'user':
$databaseOrder = 'u.lastname %DIR%, u.firstname %DIR%';
break;
case 'account':
$databaseOrder = 'acc.username %DIR%';
break;
case 'time':
$databaseOrder = 'o.timesent %DIR%';
break;
}
if ($direction == SORT_ASC) {
$databaseOrder = str_replace('%DIR%', 'ASC', $databaseOrder);
} else {
$databaseOrder = str_replace('%DIR%', 'DESC', $databaseOrder);
$count = $DB->count_records_sql($sqlcount);
if (!$showall && !$table->is_downloading()) {
$table->pagesize($limit, $count);
}
$table->define_columns(array('id', 'name', 'module', 'identifier', 'status', 'attempts', 'action'));
$table->define_headers(array(get_string('id', 'plagiarism_urkund'), get_string('user'), get_string('module', 'plagiarism_urkund'), get_string('identifier', 'plagiarism_urkund'), get_string('status', 'plagiarism_urkund'), get_string('attempts', 'plagiarism_urkund'), ''));
$table->define_baseurl('urkund_debug.php');
$table->sortable(true);
$table->no_sorting('file', 'action');
$table->collapsible(true);
$table->set_attribute('cellspacing', '0');
$table->set_attribute('class', 'generaltable generalbox');
$table->show_download_buttons_at(array(TABLE_P_BOTTOM));
$table->setup();
// Work out direction of sort required.
$sortcolumns = $table->get_sort_columns();
// Now do sorting if specified.
$orderby = '';
if (!empty($sort)) {
$direction = ' DESC';
if (!empty($sortcolumns[$sort]) && $sortcolumns[$sort] == SORT_ASC) {
$direction = ' ASC';
}
if ($sort == "name") {
$orderby = " ORDER BY u.firstname {$direction}, u.lastname {$direction}";
} else {
if ($sort == "module") {
$orderby = " ORDER BY cm.id {$direction}";
} else {
if ($sort == "status") {
$orderby = " ORDER BY t.statuscode {$direction}";
