claroline/claroline/group/group_edit.php File Reference

Go to the source code of this file.

Namespaces
namespace	CLGRP
Functions
	get_group_member_list ($context=array())
Variables
	$tlabelReq = 'CLGRP'
	$is_allowedToManage = claro_is_allowed_to_edit()
if(!$is_allowedToManage)	$dialogBox = new DialogBox()
	$nameTools = get_lang("Edit this group")
	$htmlHeadXtra []
	$tbl_cdb_names = claro_sql_get_course_tbl()
	$tbl_mdb_names = claro_sql_get_main_tbl()
	$tbl_rel_user_course = $tbl_mdb_names['rel_course_user' ]
	$tbl_user = $tbl_mdb_names['user' ]
	$tbl_bb_forum = $tbl_cdb_names['bb_forums']
	$tbl_group_rel_team_user = $tbl_cdb_names['group_rel_team_user']
	$tbl_group_team = $tbl_cdb_names['group_team']
	$currentCourseId = claro_get_current_course_id()
	$_groupProperties = claro_get_current_group_properties_data()
	$myStudentGroup = claro_get_current_group_data()
	$nbMaxGroupPerUser = $_groupProperties ['nbGroupPerUser']
else	$name = ''
else	$description = ''
else	$maxMember = NULL
else	$tutor = 0
else	$ingroup = array()
if(isset($_REQUEST['modify'])&&$is_allowedToManage)	$tutorList = get_course_tutor_list($currentCourseId)
	$tutor_list = array()
	$tutor_list [get_lang("(none)")] = 0
foreach($tutorList as $myTutor)	$usersInGroupList = get_group_member_list()
	$limitNumOfGroups = (is_null($nbMaxGroupPerUser) || $nbMaxGroupPerUser == 0 ? "" : " AND nbg < " . (int) $nbMaxGroupPerUser)
	$userNotInGroupList = array()
	$sql
	$result = claro_sql_query_fetch_all($sql)
foreach($result AS $myNotMember)	$thisGroupMaxMember = ( is_null($myStudentGroup['maxMember']) ? '-' : $myStudentGroup['maxMember'])
	$out = ''

---

Function Documentation

get_group_member_list

(

$

context = array()

)

return a list of user and groups of these users

Parameters:

unknown_type

$context

Returns:

unknown

Definition at line 369 of file group_edit.php.

---

Variable Documentation

$_groupProperties = claro_get_current_group_properties_data()

Definition at line 113 of file group_edit.php.

$currentCourseId = claro_get_current_course_id()

Definition at line 112 of file group_edit.php.

else $description = ''

Definition at line 121 of file group_edit.php.

if (!$is_allowedToManage) $dialogBox = new DialogBox()

Definition at line 35 of file group_edit.php.

$htmlHeadXtra[]

Definition at line 38 of file group_edit.php.

else $ingroup = array()

Definition at line 129 of file group_edit.php.

$is_allowedToManage = claro_is_allowed_to_edit()

Definition at line 28 of file group_edit.php.

$limitNumOfGroups = (is_null($nbMaxGroupPerUser) || $nbMaxGroupPerUser == 0 ? "" : " AND nbg < " . (int) $nbMaxGroupPerUser)

Definition at line 212 of file group_edit.php.

else $maxMember = NULL

Definition at line 123 of file group_edit.php.

$myStudentGroup = claro_get_current_group_data()

Definition at line 114 of file group_edit.php.

else $name = ''

Definition at line 118 of file group_edit.php.

$nameTools = get_lang("Edit this group")

Definition at line 36 of file group_edit.php.

$nbMaxGroupPerUser = $_groupProperties ['nbGroupPerUser']

Definition at line 115 of file group_edit.php.

$out = ''

Definition at line 258 of file group_edit.php.

$result = claro_sql_query_fetch_all($sql)

Definition at line 246 of file group_edit.php.

$sql

Initial value:

 "SELECT `u`.`user_id`        AS `user_id`,
               `u`.`nom`            AS `lastName`,
               `u`.`prenom`         AS `firstName`,
               `cu`.`role`          AS `role`,
               COUNT(`ug`.`id`)     AS `nbg`,
               COUNT(`ugbloc`.`id`) AS `BLOCK`

        FROM (`" . $tbl_user . "`                     AS u
           , `" . $tbl_rel_user_course . "`          AS cu )

        LEFT JOIN `" . $tbl_group_rel_team_user . "` AS ug
        ON `u`.`user_id`=`ug`.`user`

        LEFT JOIN `" . $tbl_group_rel_team_user . "` AS `ugbloc`
        ON  `u`.`user_id`=`ugbloc`.`user` AND `ugbloc`.`team` = " . (int) claro_get_current_group_id() . "

        WHERE `cu`.`code_cours` = '" . $currentCourseId . "'
        AND   `cu`.`user_id`    = `u`.`user_id`
        AND ( `cu`.`isCourseManager` = 0 )
        AND   `cu`.`tutor`      = 0
        AND ( `ug`.`team`       <> " . (int) claro_get_current_group_id() . " OR `ug`.`team` IS NULL )

        GROUP BY `u`.`user_id`
        HAVING `BLOCK` = 0
        " . $limitNumOfGroups . "
        ORDER BY
        #`nbg`, #disabled because different of  right box
        UPPER(`u`.`nom`), UPPER(`u`.`prenom`), `u`.`user_id`"

Definition at line 217 of file group_edit.php.

$tbl_bb_forum = $tbl_cdb_names['bb_forums']

Definition at line 108 of file group_edit.php.

$tbl_cdb_names = claro_sql_get_course_tbl()

Definition at line 103 of file group_edit.php.

$tbl_group_rel_team_user = $tbl_cdb_names['group_rel_team_user']

Definition at line 109 of file group_edit.php.

$tbl_group_team = $tbl_cdb_names['group_team']

Definition at line 110 of file group_edit.php.

$tbl_mdb_names = claro_sql_get_main_tbl()

Definition at line 104 of file group_edit.php.

$tbl_rel_user_course = $tbl_mdb_names['rel_course_user' ]

Definition at line 105 of file group_edit.php.

$tbl_user = $tbl_mdb_names['user' ]

Definition at line 106 of file group_edit.php.

foreach ($result AS $myNotMember) $thisGroupMaxMember = ( is_null($myStudentGroup['maxMember']) ? '-' : $myStudentGroup['maxMember'])

Definition at line 256 of file group_edit.php.

$tlabelReq = 'CLGRP'

Definition at line 21 of file group_edit.php.

else $tutor = 0

Definition at line 126 of file group_edit.php.

$tutor_list[get_lang("(none)")] = 0

Definition at line 203 of file group_edit.php.

$tutor_list = array()

Definition at line 202 of file group_edit.php.

if (isset($_REQUEST['modify'])&&$is_allowedToManage) $tutorList = get_course_tutor_list($currentCourseId)

Definition at line 198 of file group_edit.php.

$userNotInGroupList = array()

Definition at line 215 of file group_edit.php.

foreach ($tutorList as $myTutor) $usersInGroupList = get_group_member_list()

Definition at line 209 of file group_edit.php.