$sql = "SELECT `course`.`registration`\n FROM `" . $tbl_courses . "` AS course\n WHERE `course`.`code`='" . claro_sql_escape(claro_get_current_course_id()) . "'";
$course = claro_sql_query_get_single_row($sql);
/*----------------------------------------------------------------------
Get User List
----------------------------------------------------------------------*/
$sqlGetUsers = "\n SELECT \n `user`.`user_id` AS `user_id`,\n `user`.`nom` AS `nom`,\n `user`.`prenom` AS `prenom`,\n `user`.`email` AS `email`,\n `course_user`.`profile_id`,\n `course_user`.`isCourseManager`,\n `course_user`.`isPending`,\n `course_user`.`tutor` AS `tutor`,\n `course_user`.`role` AS `role`,\n `course_user`.`enrollment_date`,\n `course_user`.`count_class_enrol`,\n `course_user`.`count_user_enrol`,\n\n\tGROUP_CONCAT(`grp`.name ORDER BY `grp`.name SEPARATOR ',' ) AS `groups`\n\n FROM \n \n `{$tbl_users}` AS user,\n `{$tbl_rel_course_user}` AS course_user\n\n LEFT JOIN `{$tbl_rel_users_groups}` AS user_group\n ON user_group.user = `course_user`.`user_id`\n\n LEFT JOIN `{$tbl_groups}` AS `grp`\n ON `grp`.id = user_group.team\n\n WHERE ( `user`.`user_id`=`course_user`.`user_id`\n AND `course_user`.`code_cours`='" . claro_sql_escape(claro_get_current_course_id()) . "' )\n\n GROUP BY user.user_id";
$myPager = new claro_sql_pager($sqlGetUsers, $offset, $userPerPage);
if (isset($_GET['sort'])) {
$myPager->add_sort_key($_GET['sort'], isset($_GET['dir']) ? $_GET['dir'] : SORT_ASC);
}
$defaultSortKeyList = array('course_user.isCourseManager' => SORT_DESC, 'course_user.tutor' => SORT_DESC, 'user.nom' => SORT_ASC, 'user.prenom' => SORT_ASC, 'groups' => SORT_ASC, 'enrollment_date' => SORT_ASC);
foreach ($defaultSortKeyList as $thisSortKey => $thisSortDir) {
$myPager->add_sort_key($thisSortKey, $thisSortDir);
}
$userList = $myPager->get_result_list();
$userTotalNb = $myPager->get_total_item_count();
/*----------------------------------------------------------------------
Prepare display
----------------------------------------------------------------------*/
$nameTools = get_lang('Users');
// Command list
$cmdList = array();
$advancedCmdList = array();
if ($is_allowedToEdit) {
if ($can_add_single_user) {
// Add a user link
$cmdList[] = array('img' => 'user', 'name' => get_lang('Add a user'), 'url' => claro_htmlspecialchars(Url::Contextualize(get_module_url('CLUSR') . '/user_add.php')));
}
if ($can_import_user_list) {
// Add CSV file of user link
$advancedCmdList[] = array('img' => 'import_list', 'name' => get_lang('Add a user list'), 'url' => claro_htmlspecialchars(Url::Contextualize(get_module_url('CLUSR') . '/addcsvusers.php?addType=userTool')));
