123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421 |
- <?php
- /* For licensing terms, see /license.txt */
- /**
- * This script shows the group space for one specific group, possibly displaying
- * a list of users in the group, subscribe or unsubscribe option, tutors...
- *
- * @package chamilo.group
- * @todo Display error message if no group ID specified
- */
- /* INIT SECTION */
- // Name of the language file that needs to be included
- $language_file = 'group';
- require_once '../inc/global.inc.php';
- /* Libraries & config files */
- require_once api_get_path(LIBRARY_PATH).'course.lib.php';
- require_once api_get_path(LIBRARY_PATH).'groupmanager.lib.php';
- require_once api_get_path(LIBRARY_PATH).'sortabletable.class.php';
- require_once api_get_path(SYS_CODE_PATH).'forum/forumfunction.inc.php';
- require_once api_get_path(SYS_CODE_PATH).'forum/forumconfig.inc.php';
- /* MAIN CODE */
- $current_group = GroupManager :: get_group_properties($_SESSION['_gid']);
- if (!is_array($current_group) ) {
- //display some error message
- }
- $this_section = SECTION_COURSES;
- $nameTools = get_lang('GroupSpace');
- $interbreadcrumb[] = array ('url' => 'group.php', 'name' => get_lang('Groups'));
- /* Ensure all private groups // Juan Carlos Raña Trabado */
- $forums_of_groups = get_forums_of_group($current_group['id']);
- $forum_state_public = 0;
- if (is_array($forums_of_groups)) {
- foreach ($forums_of_groups as $key => $value) {
- if($value['forum_group_public_private'] == 'public') {
- $forum_state_public = 1;
- }
- }
- }
- if ($current_group['doc_state'] != 1 && $current_group['calendar_state'] != 1 && $current_group['work_state'] != 1 && $current_group['announcements_state'] != 1 && $current_group['wiki_state'] != 1 && $current_group['chat_state'] != 1 && $forum_state_public != 1) {
- if (!api_is_allowed_to_edit(null,true) && !GroupManager :: is_user_in_group($_user['user_id'], $current_group['id'])) {
- echo api_not_allowed($print_headers);
- }
- }
- /* Header */
- Display::display_header($nameTools.' '.stripslashes($current_group['name']), 'Group');
- /* Introduction section (editable by course admin) */
- Display::display_introduction_section(group_space_.$_SESSION['_gid']);
- /* Actions and Action links */
- /*
- * User wants to register in this group
- */
- if (!empty($_GET['selfReg']) && GroupManager :: is_self_registration_allowed($_SESSION['_user']['user_id'], $current_group['id'])) {
- GroupManager :: subscribe_users($_SESSION['_user']['user_id'], $current_group['id']);
- Display :: display_normal_message(get_lang('GroupNowMember'));
- }
- /*
- * User wants to unregister from this group
- */
- if (!empty($_GET['selfUnReg']) && GroupManager :: is_self_unregistration_allowed($_SESSION['_user']['user_id'], $current_group['id'])) {
- GroupManager :: unsubscribe_users($_SESSION['_user']['user_id'], $current_group['id']);
- Display::display_normal_message(get_lang('StudentDeletesHimself'));
- }
- echo '<div class="actions">';
- echo '<a href="group.php">'.Display::return_icon('back.png',get_lang('BackToGroupList')).get_lang('BackToGroupList').'</a>';
- /*
- * Edit the group
- */
- if (api_is_allowed_to_edit(false, true) or GroupManager :: is_tutor($_user['user_id'])) {
- $my_origin = isset($origin) ? $origin : '';
- echo Display::return_icon('edit.gif', get_lang('EditGroup')).'<a href="group_edit.php?origin=$my_origin">'.get_lang('EditGroup').'</a>';
- }
- /*
- * Register to group
- */
- if (GroupManager :: is_self_registration_allowed($_SESSION['_user']['user_id'], $current_group['id'])) {
- echo '<a href="'.api_get_self().'?selfReg=1&group_id='.$current_group['id'].'" onclick="javascript: if(!confirm('."'".addslashes(api_htmlentities(get_lang("ConfirmYourChoice"), ENT_QUOTES))."'".')) return false;">'.Display::return_icon('groupadd.gif').get_lang("RegIntoGroup").'</a>';
- }
- /*
- * Unregister from group
- */
- if (GroupManager :: is_self_unregistration_allowed($_SESSION['_user']['user_id'], $current_group['id'])) {
- echo '<a href="'.api_get_self().'?selfUnReg=1" onclick="javascript: if(!confirm('."'".addslashes(api_htmlentities(get_lang("ConfirmYourChoice"),ENT_QUOTES))."'".')) return false;">'.Display::return_icon('group_delete.gif').get_lang("StudentUnsubscribe").'</a>';
- }
- echo ' </div>';
- if (isset($_GET['action'])) {
- switch ($_GET['action']) {
- case 'show_msg':
- Display::display_normal_message(Security::remove_XSS($_GET['msg']));
- break;
- }
- }
- /* Main Display Area */
- $course_code = $_course['sysCode'];
- $is_course_member = CourseManager :: is_user_subscribed_in_real_or_linked_course($_SESSION['_user']['user_id'], $course_code);
- /*
- * Group title and comment
- */
- //api_display_tool_title($nameTools.' '.stripslashes($current_group['name']));
- if (!empty($current_group['description'])) {
- echo '<blockquote>'.stripslashes($current_group['description']).'</blockquote>';
- }
- /*
- * Group Tools
- */
- // If the user is subscribed to the group or the user is a tutor of the group then
- if (api_is_allowed_to_edit(false, true) OR GroupManager :: is_user_in_group($_SESSION['_user']['user_id'], $current_group['id'])) {
- $tools = '';
- // Link to the forum of this group
- $forums_of_groups = get_forums_of_group($current_group['id']);
- if (is_array($forums_of_groups)) {
- if ($current_group['forum_state'] != TOOL_NOT_AVAILABLE ) {
- foreach ($forums_of_groups as $key => $value) {
- if ($value['forum_group_public_private'] == 'public' || (/*!empty($user_subscribe_to_current_group) && */ $value['forum_group_public_private'] == 'private') || !empty($user_is_tutor) || api_is_allowed_to_edit(false, true)) {
- $tools .= Display::return_icon('forum.gif', get_lang('GroupForum')) . ' <a href="../forum/viewforum.php?forum='.$value['forum_id'].'&gidReq='.Security::remove_XSS($current_group['id']).'">'.get_lang('Forum').': '.$value['forum_title'].'</a><br />';
- //$tools .= Display::return_icon('forum.gif', get_lang('Forum')) . ' <a href="../forum/viewforum.php?forum='.$value['forum_id'].'">'.get_lang('Forum').': '.$value['forum_title'].'</a><br />';
- }
- }
- }
- }
- if ($current_group['doc_state'] != TOOL_NOT_AVAILABLE ) {
- // Link to the documents area of this group
- $tools .= '<div style="margin-bottom: 5px;"><a href="../document/document.php?'.api_get_cidreq().'&gidReq='.$current_group['id'].'">'.Display::return_icon('folder_document.gif', get_lang('GroupDocument')).' '.get_lang('GroupDocument').'</a></div>';
- }
- if ($current_group['calendar_state'] != TOOL_NOT_AVAILABLE) {
- // Link to a group-specific part of agenda
- $tools .= '<div style="margin-bottom: 5px;"><a href="../calendar/agenda.php?'.api_get_cidreq().'&toolgroup='.$current_group['id'].'&group='.$current_group['id'].'&acces=0">'.Display::return_icon('agenda.gif', get_lang('GroupCalendar')).' '.get_lang('GroupCalendar').'</a></div>';
- }
- if ($current_group['work_state'] != TOOL_NOT_AVAILABLE) {
- // Link to the works area of this group
- $tools .= '<div style="margin-bottom: 5px;"><a href="../work/work.php?'.api_get_cidreq().'&toolgroup='.$current_group['id'].'">'.Display::return_icon('works.gif', get_lang('GroupWork')).' '.get_lang('GroupWork').'</a></div>';
- }
- if ($current_group['announcements_state'] != TOOL_NOT_AVAILABLE) {
- // Link to a group-specific part of announcements
- $tools .= '<div style="margin-bottom: 5px;"><a href="../announcements/announcements.php?'.api_get_cidreq().'&toolgroup='.$current_group['id'].'">'.Display::return_icon('valves.gif', get_lang('GroupAnnouncements')).' '.get_lang('GroupAnnouncements').'</a></div>';
- }
- if ($current_group['wiki_state'] != TOOL_NOT_AVAILABLE) {
- // Link to the wiki area of this group
- $tools .= '<div style="margin-bottom: 5px;"><a href="../wiki/index.php?'.api_get_cidreq().'&toolgroup='.$current_group['id'].'">'.Display::return_icon('wiki.gif', get_lang('GroupWiki')).' '.get_lang('GroupWiki').'</a></div>';
- }
- if ($current_group['chat_state'] != TOOL_NOT_AVAILABLE) {
- // Link to the chat area of this group
- if (api_get_course_setting('allow_open_chat_window')) {
- $tools .= "<div style='margin-bottom: 5px;'><a href=\"javascript: void(0);\" onclick=\"window.open('../chat/chat.php?".api_get_cidreq()."&toolgroup=".$current_group['id']."','window_chat_group_".$_SESSION['_cid']."_".$_SESSION['_gid']."','height=380, width=625, left=2, top=2, toolbar=no, menubar=no, scrollbars=yes, resizable=yes, location=no, directories=no, status=no') \" >".Display::return_icon('chat.gif', get_lang('Chat'))." ".get_lang('Chat')."</a></div>";
- } else {
- $tools .= "<div style='margin-bottom: 5px;'><a href=\"../chat/chat.php?".api_get_cidreq()."&toolgroup=".$current_group['id']."\">".Display::return_icon('chat.gif', get_lang('Chat'))." ".get_lang('Chat')."</a></div>";
- }
- }
- echo '<div class="actions-message" style="margin-bottom:4px;"><b>'.get_lang('Tools').':</b></div>';
- if (!empty($tools)) {
- echo '<div style="margin-left:5px;">'.$tools.'</div>';
- }
- } else {
- $tools = '';
- // Link to the forum of this group
- $forums_of_groups = get_forums_of_group($current_group['id']);
- if (is_array($forums_of_groups)) {
- if ( $current_group['forum_state'] == TOOL_PUBLIC ) {
- foreach ($forums_of_groups as $key => $value) {
- if ($value['forum_group_public_private'] == 'public' ) {
- $tools.= Display::return_icon('forum.gif', get_lang('GroupForum')) . ' <a href="../forum/viewforum.php?forum='.$value['forum_id'].'&gidReq='.Security::remove_XSS($current_group['id']).'">'.$value['forum_title'].'</a><br />';
- //$tools.= Display::return_icon('forum.gif', get_lang('Forum')) . ' <a href="../forum/viewforum.php?forum='.$value['forum_id'].'">'.get_lang("Forum").': '.$value['forum_title'].'</a><br />';
- }
- }
- }
- }
- if ($current_group['doc_state'] == TOOL_PUBLIC) {
- // Link to the documents area of this group
- $tools .= '<a href="../document/document.php?'.api_get_cidreq().'&gidReq='.$current_group['id'].'&origin='.$origin.'">'.Display::return_icon('folder_document.gif', get_lang('GroupDocument')).' '.get_lang('GroupDocument').'</a><br />';
- }
- if ($current_group['calendar_state'] == TOOL_PUBLIC) {
- // Link to a group-specific part of agenda
- $tools .= '<a href="../calendar/agenda.php?'.api_get_cidreq().'&toolgroup='.$current_group['id'].'&group='.$current_group['id'].'">'.Display::return_icon('agenda.gif', get_lang('GroupCalendar')).' '.get_lang('GroupCalendar').'</a><br />';
- }
- if ($current_group['work_state'] == TOOL_PUBLIC) {
- // Link to the works area of this group
- $tools .= '<a href="../work/work.php?'.api_get_cidreq().'&toolgroup='.$current_group['id'].'">'.Display::return_icon('works.gif', get_lang('GroupWork')).' '.get_lang('GroupWork').'</a><br />';
- }
- if ($current_group['announcements_state'] == TOOL_PUBLIC) {
- // Link to a group-specific part of announcements
- $tools .= '<a href="../announcements/announcements.php?'.api_get_cidreq().'&toolgroup='.$current_group['id'].'&group='.$current_group['id'].'">'.Display::return_icon('valves.gif', get_lang('GroupAnnouncements')).' '.get_lang('GroupAnnouncements').'</a><br />';
- }
- if ($current_group['wiki_state'] == TOOL_PUBLIC) {
- // Link to the wiki area of this group
- $tools .= '<a href="../wiki/index.php?'.api_get_cidreq().'&toolgroup='.$current_group['id'].'">'.Display::return_icon('wiki.gif', get_lang('GroupWiki')).' '.get_lang('GroupWiki').'</a><br />';
- }
- if ($current_group['chat_state'] == TOOL_PUBLIC ) {
- // Link to the chat area of this group
- if (api_get_course_setting('allow_open_chat_window')) {
- $tools .= "<div style='margin-bottom: 5px;'><a href=\"javascript: void(0);\" onclick=\"window.open('../chat/chat.php?".api_get_cidreq()."&toolgroup=".$current_group['id']."','window_chat_group_".$_SESSION['_cid']."_".$_SESSION['_gid']."','height=380, width=625, left=2, top=2, toolbar=no, menubar=no, scrollbars=yes, resizable=yes, location=no, directories=no, status=no') \" >".Display::return_icon('chat.gif', get_lang("Chat"))." ".get_lang("Chat")."</a></div>";
- } else {
- $tools .= "<div style='margin-bottom: 5px;'><a href=\"../chat/chat.php?".api_get_cidreq()."&toolgroup=".$current_group['id']."\">".Display::return_icon('chat.gif', get_lang("Chat"))." ".get_lang("Chat")."</a></div>";
- }
- }
- echo '<br />';
- echo '<div class="actions-message" style="margin-bottom:4px;"><b>'.get_lang('Tools').':</b></div>';
- if (!empty($tools)) {
- echo '<div style="margin-left:5px;">'.$tools.'</div>';
- }
- }
- /*
- * List all the tutors of the current group
- */
- $tutors = GroupManager::get_subscribed_tutors($current_group['id']);
- $tutor_info = '';
- if (count($tutors) == 0) {
- $tutor_info = get_lang('GroupNoneMasc');
- } else {
- isset($origin)?$my_origin = $origin:$my_origin='';
- foreach($tutors as $index => $tutor) {
- $image_path = UserManager::get_user_picture_path_by_id($tutor['user_id'], 'web', false, true);
- $image_repository = $image_path['dir'];
- $existing_image = $image_path['file'];
- $photo= '<img src="'.$image_repository.$existing_image.'" align="absbottom" alt="'.api_get_person_name($tutor['firstname'], $tutor['lastname']).'" width="32" height="32" title="'.api_get_person_name($tutor['firstname'], $tutor['lastname']).'" />';
- $tutor_info .= '<div style="margin-bottom: 5px;"><a href="../user/userInfo.php?origin='.$my_origin.'&uInfo='.$tutor['user_id'].'">'.$photo.' '.api_get_person_name($tutor['firstname'], $tutor['lastname']).'</a></div>';
- }
- }
- echo '<div class="actions-message" style="margin-bottom:4px;"><b>'.get_lang('GroupTutors').':</b></div>';
- if (!empty($tutor_info)) {
- echo '<div style="margin-left:5px;">'.$tutor_info.'</div>';
- }
- echo '<br />';
- /*
- * List all the members of the current group
- */
- echo '<b>'.get_lang("GroupMembers").':</b>';
- $table = new SortableTable('group_users', 'get_number_of_group_users', 'get_group_user_data', (api_is_western_name_order() xor api_sort_by_first_name()) ? 2 : 1);
- $my_cidreq = isset($_GET['cidReq']) ? Security::remove_XSS($_GET['cidReq']) : '';
- $my_origin = isset($_GET['origin']) ? Security::remove_XSS($_GET['origin']) : '';
- $my_gidreq = isset($_GET['gidReq']) ? Security::remove_XSS($_GET['gidReq']) : '';
- $parameters = array('cidReq' => $my_cidreq, 'origin'=> $my_origin, 'gidReq' => $my_gidreq);
- $table->set_additional_parameters($parameters);
- $table->set_header(0, '');
- if (api_is_western_name_order()) {
- $table->set_header(1, get_lang('FirstName'));
- $table->set_header(2, get_lang('LastName'));
- } else {
- $table->set_header(1, get_lang('LastName'));
- $table->set_header(2, get_lang('FirstName'));
- }
- if (api_get_setting('show_email_addresses') == 'true') {
- $table->set_header(3, get_lang('Email'));
- $table->set_column_filter(3, 'email_filter');
- } else {
- if (api_is_allowed_to_edit() == 'true') {
- $table->set_header(3, get_lang('Email'));
- $table->set_column_filter(3, 'email_filter');
- }
- }
- $table->set_column_filter(0, 'user_icon_filter');
- $table->display();
- /**
- * Get the number of subscribed users to the group
- *
- * @return integer
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University, Belgium
- * @version April 2008
- */
- function get_number_of_group_users() {
- global $current_group;
- // Database table definition
- $table_group_user = Database :: get_course_table(TABLE_GROUP_USER);
- // Query
- $sql = "SELECT count(id) AS number_of_users
- FROM ".$table_group_user."
- WHERE group_id='".Database::escape_string($current_group['id'])."'";
- $result = Database::query($sql);
- $return = Database::fetch_array($result,'ASSOC');
- return $return['number_of_users'];
- }
- /**
- * Get the details of the users in a group
- *
- * @param integer $from starting row
- * @param integer $number_of_items number of items to be displayed
- * @param integer $column sorting colum
- * @param integer $direction sorting direction
- * @return array
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University, Belgium
- * @version April 2008
- */
- function get_group_user_data($from, $number_of_items, $column, $direction) {
- global $current_group;
- // Database table definition
- $table_group_user = Database :: get_course_table(TABLE_GROUP_USER);
- $table_user = Database :: get_main_table(TABLE_MAIN_USER);
- // Query
- if (api_get_setting('show_email_addresses') == 'true') {
- $sql = "SELECT
- user.user_id AS col0,
- ".(api_is_western_name_order() ?
- "user.firstname AS col1,
- user.lastname AS col2,"
- :
- "user.lastname AS col1,
- user.firstname AS col2,"
- )."
- user.email AS col3
- FROM ".$table_user." user, ".$table_group_user." group_rel_user
- WHERE group_rel_user.user_id = user.user_id
- AND group_rel_user.group_id = '".Database::escape_string($current_group['id'])."'";
- $sql .= " ORDER BY col$column $direction ";
- $sql .= " LIMIT $from,$number_of_items";
- } else {
- if (api_is_allowed_to_edit()) {
- $sql = "SELECT
- user.user_id AS col0,
- ".(api_is_western_name_order() ?
- "user.firstname AS col1,
- user.lastname AS col2,"
- :
- "user.lastname AS col1,
- user.firstname AS col2,"
- )."
- user.email AS col3
- FROM ".$table_user." user, ".$table_group_user." group_rel_user
- WHERE group_rel_user.user_id = user.user_id
- AND group_rel_user.group_id = '".Database::escape_string($current_group['id'])."'";
- $sql .= " ORDER BY col$column $direction ";
- $sql .= " LIMIT $from,$number_of_items";
- } else {
- $sql = "SELECT
- user.user_id AS col0,
- ". (api_is_western_name_order() ?
- "user.firstname AS col1,
- user.lastname AS col2 "
- :
- "user.lastname AS col1,
- user.firstname AS col2 "
- )."
- FROM ".$table_user." user, ".$table_group_user." group_rel_user
- WHERE group_rel_user.user_id = user.user_id
- AND group_rel_user.group_id = '".Database::escape_string($current_group['id'])."'";
- $sql .= " ORDER BY col$column $direction ";
- $sql .= " LIMIT $from,$number_of_items";
- }
- }
- $return = array();
- $result = Database::query($sql);
- while ($row = Database::fetch_row($result)) {
- $return[] = $row;
- }
- return $return;
- }
- /**
- * Returns a mailto-link
- * @param string $email An email-address
- * @return string HTML-code with a mailto-link
- */
- function email_filter($email) {
- return Display :: encrypted_mailto_link($email, $email);
- }
- /**
- * Display a user icon that links to the user page
- *
- * @param integer $user_id the id of the user
- * @return html code
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University, Belgium
- * @version April 2008
- */
- function user_icon_filter($user_id) {
- global $origin;
- $userinfo = Database::get_user_info_from_id($user_id);
- $image_path = UserManager::get_user_picture_path_by_id($user_id, 'web', false, true);
- $image_repository = $image_path['dir'];
- $existing_image = $image_path['file'];
- $photo = '<center><img src="'.$image_repository.$existing_image.'" alt="'.api_get_person_name($userinfo['firstname'], $userinfo['lastname']).'" width="22" height="22" title="'.api_get_person_name($userinfo['firstname'], $userinfo['lastname']).'" /></center>';
- return '<a href="../user/userInfo.php?origin='.$origin.'&uInfo='.$user_id.'">'.$photo;
- }
- // Footer
- $orig = isset($origin) ? $origin : '';
- if ($orig != 'learnpath') {
- Display::display_footer();
- }
|