wwwroot.'/group/index.php?id='.$courseid;
$rooturl = $CFG->wwwroot.'/group/overview.php?id='.$courseid;
if (!$course = get_record('course', 'id',$courseid)) {
error('invalidcourse');
}
// Make sure that the user has permissions to manage groups.
require_login($course);
$context = get_context_instance(CONTEXT_COURSE, $courseid);
require_capability('moodle/course:managegroups', $context);
$strgroups = get_string('groups');
$strparticipants = get_string('participants');
$stroverview = get_string('overview', 'group');
$strgrouping = get_string('grouping', 'group');
$strgroup = get_string('group', 'group');
$strnotingrouping = get_string('notingrouping', 'group');
$strfiltergroups = get_string('filtergroups', 'group');
$strnogroups = get_string('nogroups', 'group');
$strdescription = get_string('description');
// Get all groupings
if (empty($CFG->enablegroupings)) {
$groupings = array();
$members = array(-1 => array()); //groups not in a grouping
$groupingid = 0;
} else {
if (!$groupings = get_records('groupings', 'courseid', $courseid, 'name')) {
$groupings = array();
}
$members = array();
foreach ($groupings as $grouping) {
$members[$grouping->id] = array();
}
$members[-1] = array(); //groups not in a grouping
}
// Get all groups
if (!$groups = get_records('groups', 'courseid', $courseid, 'name')) {
$groups = array();
}
if (empty($CFG->enablegroupings)) {
$groupwhere = $groupid ? "AND g.id = $groupid" : "";
$sql = "SELECT g.id AS groupid, NULL AS groupingid, u.id AS userid, u.firstname, u.lastname, u.idnumber, u.username
FROM {$CFG->prefix}groups g
LEFT JOIN {$CFG->prefix}groups_members gm ON g.id = gm.groupid
LEFT JOIN {$CFG->prefix}user u ON gm.userid = u.id
WHERE g.courseid = {$course->id} $groupwhere
ORDER BY g.name, u.lastname, u.firstname";
} else {
$groupingwhere = $groupingid ? "AND gg.groupingid = $groupingid" : "";
$groupwhere = $groupid ? "AND g.id = $groupid" : "";
$sql = "SELECT g.id AS groupid, gg.groupingid, u.id AS userid, u.firstname, u.lastname, u.idnumber, u.username
FROM {$CFG->prefix}groups g
LEFT JOIN {$CFG->prefix}groupings_groups gg ON g.id = gg.groupid
LEFT JOIN {$CFG->prefix}groups_members gm ON g.id = gm.groupid
LEFT JOIN {$CFG->prefix}user u ON gm.userid = u.id
WHERE g.courseid = {$course->id} $groupingwhere $groupwhere
ORDER BY g.name, u.lastname, u.firstname";
}
if ($rs = get_recordset_sql($sql)) {
while ($row = rs_fetch_next_record($rs)) {
$user = new object();
$user->id = $row->userid;
$user->firstname = $row->firstname;
$user->lastname = $row->lastname;
$user->username = $row->username;
$user->idnumber = $row->idnumber;
if (!$row->groupingid) {
$row->groupingid = -1;
}
if (!array_key_exists($row->groupid, $members[$row->groupingid])) {
$members[$row->groupingid][$row->groupid] = array();
}
if(isset($user->id)){
$members[$row->groupingid][$row->groupid][] = $user;
}
}
rs_close($rs);
}
// Print the page and form
$navlinks = array(array('name'=>$strparticipants, 'link'=>$CFG->wwwroot.'/user/index.php?id='.$courseid, 'type'=>'misc'),
array('name'=>$strgroups, 'link'=>'', 'type'=>'misc'));
$navigation = build_navigation($navlinks);
/// Print header
print_header_simple($strgroups, ': '.$strgroups, $navigation, '', '', true, '', navmenu($course));
// Add tabs
$currenttab = 'overview';
require('tabs.php');
/// Print overview
print_heading(format_string($course->shortname) .' '.$stroverview, 'center', 3);
echo $strfiltergroups;
if (!empty($CFG->enablegroupings)) {
$options = array();
$options[0] = get_string('all');
foreach ($groupings as $grouping) {
$options[$grouping->id] = strip_tags(format_string($grouping->name));
}
popup_form($rooturl.'&group='.$groupid.'&grouping=', $options, 'selectgrouping', $groupingid, '', '', '', false, 'self', $strgrouping);
}
$options = array();
$options[0] = get_string('all');
foreach ($groups as $group) {
$options[$group->id] = strip_tags(format_string($group->name));
}
popup_form($rooturl.'&grouping='.$groupingid.'&group=', $options, 'selectgroup', $groupid, '', '', '', false, 'self', $strgroup);
/// Print table
$printed = false;
foreach ($members as $gpgid=>$groupdata) {
if ($groupingid and $groupingid != $gpgid) {
continue; // do not show
}
$table = new object();
$table->head = array(get_string('groupscount', 'group', count($groupdata)), get_string('groupmembers', 'group'), get_string('usercount', 'group'));
$table->size = array('20%', '70%', '10%');
$table->align = array('left', 'left', 'center');
$table->width = '90%';
$table->data = array();
foreach ($groupdata as $gpid=>$users) {
if ($groupid and $groupid != $gpid) {
continue;
}
$line = array();
$name = format_string($groups[$gpid]->name);
$jsdescription = addslashes_js(trim(format_text($groups[$gpid]->description)));
if (empty($jsdescription)) {
$line[] = $name;
} else {
$jsstrdescription = addslashes_js($strdescription);
$overlib = "return overlib('$jsdescription', BORDER, 0, FGCLASS, 'description', "
."CAPTIONFONTCLASS, 'caption', CAPTION, '$jsstrdescription');";
$line[] = ''.$name.'';
}
$fullnames = array();
foreach ($users as $user) {
$fullnames[] = ''.fullname($user, true).'';
}
$line[] = implode(', ', $fullnames);
$line[] = count($users);
$table->data[] = $line;
}
if ($groupid and empty($table->data)) {
continue;
}
if (!empty($CFG->enablegroupings)) {
if ($gpgid < 0) {
print_heading($strnotingrouping, '', 3);
} else {
print_heading(format_string($groupings[$gpgid]->name), '', 3);
print_box(format_text($groupings[$gpgid]->description), 'generalbox boxwidthnarrow boxaligncenter');
}
}
print_table($table, false);
$printed = true;
}
print_footer($course);
?>