This repository has been archived by the owner on Jun 15, 2020. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 12
/
view.php
87 lines (68 loc) · 2.85 KB
/
view.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
<?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/>.
/**
* @package auth
* @subpackage mcae
* @copyright 2011 Andrew "Kama" ([email protected])
* @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
*/
require_once('../../config.php');
require_once($CFG->libdir . '/adminlib.php');
require_login();
admin_externalpage_setup('cohortviewmcae');
$context = context_system::instance();
require_capability('moodle/cohort:view', $context, $USER->id);
$cid = optional_param('cid', 0, PARAM_INT);
$cohorts = $DB->get_records('cohort', array('contextid' => $context->id), 'name ASC');
$selectoptions = '<option default value="0">'.get_string('auth_selectcohort', 'auth_mcae').'</option>';
foreach ($cohorts as $cohort) {
$cohortid = $cohort->id;
$cohortname = format_string($cohort->name);
$selected = ($cid == $cohortid) ? 'selected' : '';
$selectoptions .= "<option $selected value=\"$cohortid\">$cohortname</option>";
}
$fullname = $DB->sql_fullname($first = 'firstname', $last = 'lastname');
$sql = "SELECT u.id AS uid, $fullname AS usrname
FROM {cohort_members} AS cm
JOIN {user} AS u ON u.id = cm.userid
WHERE cm.cohortid = ? ORDER BY usrname";
$userlist = $DB->get_records_sql($sql, array($cid));
$total = 0;
$head = array(get_string('auth_username', 'auth_mcae'), get_string('auth_link', 'auth_mcae'));
$data = array();
if (empty($userlist)) {
$data[] = array(get_string('auth_emptycohort', 'auth_mcae'), '');
} else {
foreach ($userlist as $user) {
$link = new moodle_url('/user/profile.php', array('id' => $user->uid));
$data[] = array($user->usrname, '<a href="'.$link.'">'.get_string('auth_userprofile', 'auth_mcae').'</a>');
$total++;
};
$data[] = array(get_string('auth_total', 'auth_mcae'), $total);
};
$table = new html_table();
$table->head = $head;
$table->width = '60%';
$table->data = $data;
$return = new moodle_url('/auth/mcae/view.php');
echo $OUTPUT->header();
echo $OUTPUT->heading(get_string('auth_viewcohort', 'auth_mcae'));
echo '<form action="'.$return.'" method="POST"><select name="cid">';
echo $selectoptions;
echo '<input type="submit"></form><br />';
echo '<br>';
echo html_writer::table($table);
echo $OUTPUT->footer();