123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434 |
- <?php // $Id: group.php 22201 2009-07-17 19:57:03Z cfasanando $
- /*
- ==============================================================================
- Dokeos - elearning and course management software
- Copyright (c) 2004-2008 Dokeos SPRL
- Copyright (c) 2003 Ghent University (UGent)
- Copyright (c) 2001 Universite catholique de Louvain (UCL)
- Copyright (c) various contributors
- For a full list of contributors, see "credits.txt".
- The full license can be read in "license.txt".
- This program 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 2
- of the License, or (at your option) any later version.
- See the GNU General Public License for more details.
- Contact address: Dokeos, rue du Corbeau, 108, B-1030 Brussels, Belgium
- Mail: info@dokeos.com
- ==============================================================================
- */
- /**
- ==============================================================================
- * Main page for the group module.
- * This script displays the general group settings,
- * and a list of groups with buttons to view, edit...
- *
- * @author Thomas Depraetere, Hugues Peeters, Christophe Gesche: initial versions
- * @author Bert Vanderkimpen, improved self-unsubscribe for cvs
- * @author Patrick Cool, show group comment under the group name
- * @author Roan Embrechts, initial self-unsubscribe code, code cleaning, virtual course support
- * @author Bart Mollet, code cleaning, use of Display-library, list of courseAdmin-tools, use of GroupManager
- * @author Isaac Flores, code cleaning and improvements
- * @package dokeos.group
- ==============================================================================
- */
- /*
- ==============================================================================
- INIT SECTION
- ==============================================================================
- */
- // name of the language file that needs to be included
- $language_file = 'group';
- require_once '../inc/global.inc.php';
- $this_section=SECTION_COURSES;
- // notice for unauthorized people.
- api_protect_course_script(true);
- $htmlHeadXtra[] = '<script src="'.api_get_path(WEB_LIBRARY_PATH).'javascript/jquery.js" type="text/javascript" language="javascript"></script>'; //jQuery
- $htmlHeadXtra[] = '<script type="text/javascript">
- $(document).ready( function() {
- for (i=0;i<$(".actions").length;i++) {
- if ($(".actions:eq("+i+")").html()=="<table border=\"0\"></table>" || $(".actions:eq("+i+")").html()=="" || $(".actions:eq("+i+")").html()==null) {
- $(".actions:eq("+i+")").hide();
- }
- }
- } );
- </script>';
- $nameTools = get_lang('GroupManagement');
- /*
- -----------------------------------------------------------
- Libraries
- -----------------------------------------------------------
- */
- require_once (api_get_path(LIBRARY_PATH).'course.lib.php');
- require_once (api_get_path(LIBRARY_PATH).'groupmanager.lib.php');
- //Create default category if it doesn't exist when group categories aren't allowed
- if( api_get_setting('allow_group_categories') == 'false')
- {
- $cat_table = Database::get_course_table(TABLE_GROUP_CATEGORY);
- $sql = "SELECT * FROM $cat_table WHERE id = '".DEFAULT_GROUP_CATEGORY."'";
- $res = api_sql_query($sql,__FILE__,__LINE__);
- $num = Database::num_rows($res);
- if($num == 0)
- {
- api_sql_query("INSERT INTO ".$cat_table." ( id , title , description , forum_state , wiki_state, max_student , self_reg_allowed , self_unreg_allowed , groups_per_user , display_order ) VALUES ('2', '".lang2db($DefaultGroupCategory)."', '', '1', '1', '8', '0', '0', '0', '0');");
- }
- }
- /*
- -----------------------------------------------------------
- Header
- -----------------------------------------------------------
- */
- if (!isset ($_GET['origin']) || $_GET['origin'] != 'learnpath')
- { //so we are not in learnpath tool
- event_access_tool(TOOL_GROUP);
- if (! $is_allowed_in_course) api_not_allowed(true);
- }
- Display::display_header(get_lang('Groups'));
- // Tool introduction
- Display::display_introduction_section(TOOL_GROUP);
- /*
- * Self-registration and unregistration
- */
- $my_group_id = Security::remove_XSS($_GET['group_id']);
- $my_msg = Security::remove_XSS($_GET['msg']);
- $my_group = $_POST['group'];
- $my_get_id1 = Security::remove_XSS($_GET['id1']);
- $my_get_id2 = Security::remove_XSS($_GET['id2']);
- $my_get_id = Security::remove_XSS($_GET['id']);
- if (isset ($_GET['action']))
- {
- switch ($_GET['action'])
- {
- case 'self_reg' :
- if (GroupManager :: is_self_registration_allowed($_SESSION['_user']['user_id'], $my_group_id))
- {
- GroupManager :: subscribe_users($_SESSION['_user']['user_id'],$my_group_id);
- Display :: display_confirmation_message(get_lang('GroupNowMember'));
- }
- break;
- case 'self_unreg' :
- if (GroupManager :: is_self_unregistration_allowed($_SESSION['_user']['user_id'], $my_group_id))
- {
- GroupManager :: unsubscribe_users($_SESSION['_user']['user_id'],$my_group_id);
- Display :: display_confirmation_message(get_lang('StudentDeletesHimself'));
- }
- break;
- case 'show_msg' :
- Display :: display_confirmation_message($my_msg);
- break;
- }
- }
- /*
- * Group-admin functions
- */
- if (api_is_allowed_to_edit(false,true))
- {
- // Post-actions
- if (isset ($_POST['action']))
- {
- switch ($_POST['action'])
- {
- case 'delete_selected' :
- if( is_array($_POST['group']))
- {
- GroupManager :: delete_groups($my_group);
- Display :: display_confirmation_message(get_lang('SelectedGroupsDeleted'));
- }
- break;
- case 'empty_selected' :
- if( is_array($_POST['group']))
- {
- GroupManager :: unsubscribe_all_users($my_group);
- Display :: display_confirmation_message(get_lang('SelectedGroupsEmptied'));
- }
- break;
- case 'fill_selected' :
- if( is_array($_POST['group']))
- {
- GroupManager :: fill_groups($my_group);
- Display :: display_confirmation_message(get_lang('SelectedGroupsFilled'));
- }
- break;
- }
- }
- // Get-actions
- if (isset ($_GET['action']))
- {
- switch ($_GET['action'])
- {
- case 'swap_cat_order' :
- GroupManager :: swap_category_order($my_get_id1,$my_get_id2);
- Display :: display_confirmation_message(get_lang('CategoryOrderChanged'));
- break;
- case 'delete_one' :
- GroupManager :: delete_groups($my_get_id);
- Display :: display_confirmation_message(get_lang('GroupDel'));
- break;
- case 'empty_one' :
- GroupManager :: unsubscribe_all_users($my_get_id);
- Display :: display_confirmation_message(get_lang('GroupEmptied'));
- break;
- case 'fill_one' :
- GroupManager :: fill_groups($my_get_id);
- Display :: display_confirmation_message(get_lang('GroupFilledGroups'));
- break;
- case 'delete_category' :
- GroupManager :: delete_category($my_get_id);
- Display :: display_confirmation_message(get_lang('CategoryDeleted'));
- break;
- }
- }
- }
- echo '<div class="actions">';
- if (api_is_allowed_to_edit(false,true))
- {
- echo Display::return_icon('groupadd.gif', get_lang('NewGroupCreate')) . '<a href="group_creation.php?'.api_get_cidreq().'">'.get_lang('NewGroupCreate').'</a> ';
- if( Database::count_rows(Database::get_course_table(TABLE_GROUP)) > 0) {
- //echo '<a href="group_overview.php?'.api_get_cidreq().'">'.Display::return_icon('group_view.gif').' '.get_lang('GroupOverview').'</a> ';
- echo Display::return_icon('group.gif', get_lang('GroupOverview')) .'<a href="group_overview.php?'.api_get_cidreq().'">'.get_lang('GroupOverview').'</a> ';
- }
- if (api_get_setting('allow_group_categories') == 'true') {
- echo Display::return_icon('folder_new.gif', get_lang('AddCategory')) . '<a href="group_category.php?'.api_get_cidreq().'&action=add_category">'.get_lang('AddCategory').'</a> ';
- } else {
- //echo '<a href="group_category.php?'.api_get_cidreq().'&id=2">'.Display::return_icon('edit_group.gif').' '.get_lang('PropModify').'</a> ';
- echo Display::return_icon('settings.gif', get_lang('PropModify')) . '<a href="group_category.php?'.api_get_cidreq().'&id=2">'.get_lang('PropModify').'</a> ';
- }
- //echo Display::return_icon('csv.gif', get_lang('ExportAsCSV')).'<a href="group_overview.php?'.api_get_cidreq().'&action=export&type=csv">'.get_lang('ExportAsCSV').'</a> ';
- echo Display::return_icon('excel.gif', get_lang('ExportAsXLS')).' <a href="group_overview.php?'.api_get_cidreq().'&action=export&type=xls">'.get_lang('ExportAsXLS').'</a>';
- //echo '<a href="group_creation.php?'.api_get_cidreq().'">'.Display::return_icon('group_add_big.gif').' '.get_lang('NewGroupCreate').'</a> ';
- }
- $group_cats = GroupManager :: get_categories();
- if (api_get_setting('allow_group_categories') == 'true' && count($group_cats) > 1)
- {
- //echo '<p><a href="?'.api_get_cidreq().'&show_all=1">'.get_lang('ShowAll').'</a></p>';
- echo Display::return_icon('group.gif').' <a href="?'.api_get_cidreq().'&show_all=1">'.get_lang('ShowAll').'</a>';
- }
- echo '</div>';
- /*
- * List all categories
- */
- foreach ($group_cats as $index => $category)
- {
- global $charset;
- $group_list = array ();
- $in_category = false;
- if (api_get_setting('allow_group_categories') == 'true')
- {
- if (isset ($_GET['show_all']) || (isset ($_GET['category']) && $_GET['category'] == $category['id']))
- {
- echo '<img src="../img/shared_folder.gif" alt=""/>';
- echo ' <a href="group.php?'.api_get_cidreq().'&origin='.Security::remove_XSS($_GET['origin']).'">'.$category['title'].'</a>';
- $in_category = true;
- }
- else
- {
- echo '<img src="../img/folder_document.gif" alt=""/>';
- echo ' <a href="group.php?'.api_get_cidreq().'&origin='.Security::remove_XSS($_GET['origin']).'&category='.$category['id'].'">'.$category['title'].'</a>';
- }
- $group_list = GroupManager :: get_group_list($category['id']);
- echo ' ('.count($group_list).' '.get_lang('ExistingGroups').')';
- if (api_is_allowed_to_edit(false,true))
- {
- echo '<a href="group_category.php?'.api_get_cidreq().'&id='.$category['id'].'" title="'.get_lang('Edit').'"><img src="../img/edit.gif" alt="'.get_lang('Edit').'"/></a> ';
- echo '<a href="group.php?'.api_get_cidreq().'&action=delete_category&id='.$category['id'].'" onclick="javascript:if(!confirm('."'".addslashes(api_htmlentities(get_lang('ConfirmYourChoice'), ENT_QUOTES, $charset))."'".')) return false;" title="'.get_lang('Delete').'"><img src="../img/delete.gif" alt="'.get_lang('Delete').'"/></a> ';
- if ($index != 0)
- {
- echo ' <a href="group.php?'.api_get_cidreq().'&action=swap_cat_order&id1='.$category['id'].'&id2='.$group_cats[$index -1]['id'].'"><img src="../img/up.gif" alt=""/></a>';
- }
- if ($index != count($group_cats) - 1)
- {
- echo ' <a href="group.php?'.api_get_cidreq().'&action=swap_cat_order&id1='.$category['id'].'&id2='.$group_cats[$index +1]['id'].'"><img src="../img/down.gif" alt=""/></a>';
- }
- }
- echo '<p style="margin: 0px;margin-left: 50px;">'.$category['description'].'</p><p/>';
- }
- else {
- $group_list = GroupManager :: get_group_list();
- $in_category = true;
- }
- //if (count($group_list) > 0 && $in_category)
- if ($in_category)
- {
- $totalRegistered = 0;
- // Determine wether current user is tutor for this course
- $user_is_tutor = GroupManager :: is_tutor($_user['user_id']);
- $group_data = array ();
- foreach ($group_list as $index => $this_group)
- {
- // all the tutors of this group
- $tutorsids_of_group=GroupManager::get_subscribed_tutors($this_group['id'],true);
- // create a new table-row
- $row = array ();
- // checkbox
- if (api_is_allowed_to_edit(false,true) && count($group_list) > 1)
- {
- $row[] = $this_group['id'];
- }
- // group name
- if ((api_is_allowed_to_edit(false,true) ||
- in_array($_user['user_id'],$tutorsids_of_group) ||
- $this_group['is_member'] ||
- GroupManager::user_has_access($_user['user_id'],$this_group['id'],GROUP_TOOL_FORUM) ||
- GroupManager::user_has_access($_user['user_id'],$this_group['id'],GROUP_TOOL_DOCUMENTS) ||
- GroupManager::user_has_access($_user['user_id'],$this_group['id'],GROUP_TOOL_CALENDAR) ||
- GroupManager::user_has_access($_user['user_id'],$this_group['id'],GROUP_TOOL_ANNOUNCEMENT) ||
- GroupManager::user_has_access($_user['user_id'],$this_group['id'],GROUP_TOOL_WORK) ||
- GroupManager::user_has_access($_user['user_id'],$this_group['id'],GROUP_TOOL_WIKI))
- && !(api_is_course_coach() && intval($this_group['session_id'])!=intval($_SESSION['id_session'])))
- {
- isset($origin)?$orig=$origin:$orig=null;
- $group_name = '<a href="group_space.php?'.api_get_cidreq().'&origin='.$orig.'&gidReq='.$this_group['id'].'">'.stripslashes($this_group['name']).'</a>';
- if (!empty($_SESSION['_user']['user_id']) && !empty($this_group['id_tutor']) && $_SESSION['_user']['user_id'] == $this_group['id_tutor'])
- {
- $group_name .= ' ('.get_lang('OneMyGroups').')';
- }
- elseif ($this_group['is_member'])
- {
- $group_name .= ' ('.get_lang('MyGroup').')';
- }
- if(api_is_allowed_to_edit() && !empty($this_group['session_name']))
- {
- $group_name .= ' ('.$this_group['session_name'].')';
- }
- $row[] = $group_name.'<br/>'.stripslashes(trim($this_group['description']));
- }
- else
- {
- $row[] = $this_group['name'].'<br/>'.stripslashes(trim($this_group['description']));
- }
- // self-registration / unregistration
- if (!api_is_allowed_to_edit(false,true))
- {
- if (GroupManager :: is_self_registration_allowed($_user['user_id'], $this_group['id']))
- {
- $row[] = '<a href="group.php?'.api_get_cidreq().'&category='.$category['id'].'&action=self_reg&group_id='.$this_group['id'].'" onclick="javascript:if(!confirm('."'".addslashes(api_htmlentities(get_lang('ConfirmYourChoice'), ENT_QUOTES, $charset))."'".')) return false;">'.get_lang('GroupSelfRegInf').'</a>';
- }
- elseif (GroupManager :: is_self_unregistration_allowed($_user['user_id'], $this_group['id']))
- {
- $row[] = '<a href="group.php?'.api_get_cidreq().'&category='.$category['id'].'&action=self_unreg&group_id='.$this_group['id'].'" onclick="javascript:if(!confirm('."'".addslashes(api_htmlentities(get_lang('ConfirmYourChoice'), ENT_QUOTES, $charset))."'".')) return false;">'.get_lang('GroupSelfUnRegInf').'</a>';
- }
- else
- {
- $row[] = '-';
- }
- }
- // number of members in group
- $row[] = $this_group['number_of_members'];
- // max number of members in group
- $row[] = ($this_group['maximum_number_of_members'] == MEMBER_PER_GROUP_NO_LIMIT ? '-' : $this_group['maximum_number_of_members']);
- // tutor name
- $tutor_info = '';
- if(count($tutorsids_of_group)>0)
- {
- foreach($tutorsids_of_group as $tutor_id){
- $tutor = api_get_user_info($tutor_id);
- if (api_get_setting("show_email_addresses") == "true")
- {
- $tutor_info .= Display::encrypted_mailto_link($tutor['mail'], api_get_person_name($tutor['firstName'], $tutor['lastName'])).', ';
- }
- else
- {
- if (api_is_allowed_to_edit()=='true')
- {
- $tutor_info .= Display::encrypted_mailto_link($tutor['mail'], api_get_person_name($tutor['firstName'], $tutor['lastName'])).', ';
- }
- else
- {
- $tutor_info .= api_get_person_name($tutor['firstName'], $tutor['lastName']).', ';
- }
- }
- }
- }
- $tutor_info = api_substr($tutor_info,0,api_strlen($tutor_info)-2);
- $row[] = $tutor_info;
- // edit-links
- if (api_is_allowed_to_edit(false,true) && !(api_is_course_coach() && intval($this_group['session_id'])!=intval($_SESSION['id_session'])))
- {
- $edit_actions = '<a href="group_edit.php?'.api_get_cidreq().'&gidReq='.$this_group['id'].'" title="'.get_lang('Edit').'"><img src="../img/edit.gif" alt="'.get_lang('Edit').'"/></a> ';
- $edit_actions .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&category='.$category['id'].'&action=delete_one&id='.$this_group['id'].'" onclick="javascript:if(!confirm('."'".addslashes(api_htmlentities(get_lang('ConfirmYourChoice'), ENT_QUOTES, $charset))."'".')) return false;" title="'.get_lang('Delete').'"><img src="../img/delete.gif" alt="'.get_lang('Delete').'"/></a> ';
- $edit_actions .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&category='.$category['id'].'&action=empty_one&id='.$this_group['id'].'" onclick="javascript:if(!confirm('."'".addslashes(api_htmlentities(get_lang('ConfirmYourChoice'), ENT_QUOTES, $charset))."'".')) return false;" title="'.get_lang('EmptyGroup').'"><img src="../img/clean_group.gif" alt="'.get_lang('EmptyGroup').'"/></a> ';
- $edit_actions .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&category='.$category['id'].'&action=fill_one&id='.$this_group['id'].'" onclick="javascript:if(!confirm('."'".addslashes(api_htmlentities(get_lang('ConfirmYourChoice'), ENT_QUOTES, $charset))."'".')) return false;" title="'.get_lang('FillGroup').'"><img src="../img/fill_group.gif" alt="'.get_lang('FillGroup').'"/></a>';
- $row[] = $edit_actions;
- }
- if (!empty($this_group['nbMember'])) {
- $totalRegistered = $totalRegistered + $this_group['nbMember'];
- }
- $group_data[] = $row;
- } // while loop
- if (isset ($_GET['show_all']))
- {
- $paging_options = array ('per_page' => count($group_data));
- }
- else
- {
- $paging_options = array ();
- }
- $table = new SortableTableFromArrayConfig($group_data, 1);
- isset($_GET['category'])?$my_cat = Security::remove_XSS($_GET['category']): $my_cat = null;
- $table->set_additional_parameters(array('category'=>$my_cat));
- $column = 0;
- if (api_is_allowed_to_edit(false,true) and count($group_list) > 1)
- {
- $table->set_header($column++,'', false);
- }
- $table->set_header($column++,get_lang('ExistingGroups'));
- if (!api_is_allowed_to_edit(false,true)) // If self-registration allowed
- {
- $table->set_header($column++,get_lang('GroupSelfRegistration'));
- }
- $table->set_header($column++,get_lang('Registered'));
- $table->set_header($column++,get_lang('Max'));
- $table->set_header($column++,get_lang('GroupTutor'));
- if (api_is_allowed_to_edit(false,true)) // only for course administrator
- {
- $table->set_header($column++,get_lang('Modify'), false);
- $form_actions = array();
- $form_actions['delete_selected'] = get_lang('Delete');
- $form_actions['fill_selected'] = get_lang('FillGroup');
- $form_actions['empty_selected'] = get_lang('EmptyGroup');
- if (count($group_list) > 1)
- {
- $table->set_form_actions($form_actions,'group');
- }
- }
- $table->display();
- }
- /*
- elseif ($in_category)
- {
- echo get_lang('NoGroupsAvailable');
- }
- */
- }
- /*
- ==============================================================================
- FOOTER
- ==============================================================================
- */
- if (!isset ($_GET['origin']) || $_GET['origin'] != 'learnpath')
- {
- Display::display_footer();
- }
- ?>
|