function getLearnPathDetailByClass($path_id, $courseUserList) { $classList = get_class_list_of_course(claro_get_current_course_id()); foreach ($courseUserList as $user) { $userList[$user['user_id']] = $user; } //prepare userlist per class while keeping track of classless users $classlessUserList = $userList; foreach ($classList as $classKey => $class) { $classList[$classKey]['userList'] = array_intersect_key($userList, array_flip(get_class_list_user_id_list(array($class['id'])))); $classList[$classKey]['name'] = ucfirst(get_lang('class')) . ' ' . $classList[$classKey]['name']; $classlessUserList = array_diff_key($classlessUserList, $classList[$classKey]['userList']); } //add remaining users to a "classless" class array_unshift($classList, array('name' => '', 'userList' => $classlessUserList)); $out = ''; foreach ($classList as $class) { if (empty($class['userList'])) { continue; } if (!empty($class['name'])) { $out .= '<span style="font-weight: bold;">' . $class['name'] . '</span><br />'; } $out .= getLearnPathDetailTable($path_id, $class['userList']); } return $out; }
*/ $courseTableName = get_module_course_tbl(array('group_team', 'group_rel_team_user')); $courseTableName = get_module_course_tbl(array('group_team', 'group_rel_team_user')); $mainTableName = claro_sql_get_main_tbl(); $sql = "SELECT \n `g`.`id`,\n `g`.`name`,\n COUNT(`cu`.`user_id`) AS `userNb`\n FROM \n `" . $courseTableName['group_team'] . "` AS `g` \n LEFT JOIN \n `" . $courseTableName['group_rel_team_user'] . "` AS `gu`\n ON \n `g`.`id` = `gu`.`team`\n LEFT JOIN \n `" . $mainTableName['rel_course_user'] . "` AS cu\n ON \n `gu`.`user` = cu.user_id\n AND \n cu.code_cours = '" . claro_sql_escape(claro_get_current_course_id()) . "'\n GROUP BY `g`.`id`"; $groupSelect = claro_sql_query_fetch_all($sql); $groupList = array(); if (is_array($groupSelect) && !empty($groupSelect)) { foreach ($groupSelect as $groupData) { $groupList[$groupData['id']] = $groupData; } } /* * Get class user list of this course */ $classList = get_class_list_of_course(claro_get_current_course_id()); $displayForm = TRUE; } // ------------ Prepare display -------------------- if ($displayForm) { $claroline->display->header->addHtmlHeader('<script type="text/javascript" language="JavaScript"> <!-- Begin javascript menu swapper function move(fbox, tbox) { var arrFbox = new Array(); var arrTbox = new Array(); var arrLookup = new Array(); var i;