}
}
/**
* PREPARE DISPLAY
*
* Display contains 2 parts:
*
* 1/ Filter/search panel
* 2/ List of datas
*/
$sqlCourseList = prepare_get_filtred_course_list();
$myPager = new claro_sql_pager($sqlCourseList, $offsetC, get_conf('coursePerPage', 20));
$sortKey = isset($_GET['sort']) ? $_GET['sort'] : 'officialCode, intitule';
$sortDir = isset($_GET['dir']) ? $_GET['dir'] : SORT_ASC;
$myPager->set_sort_key($sortKey, $sortDir);
$myPager->set_pager_call_param_name('offsetC');
$courseList = $myPager->get_result_list();
if (is_array($courseList)) {
$tbl_mdb_names = claro_sql_get_main_tbl();
foreach ($courseList as $courseKey => $course) {
$sql = "SELECT\n count(IF(`isCourseManager`=0,1,null))\n AS `qty_stu`,\n #count only lines where user is not course manager\n\n count(IF(`isCourseManager`=1,1,null))\n AS `qty_cm`\n #count only lines where statut of user is 1\n FROM `" . $tbl_mdb_names['rel_course_user'] . "`\n WHERE code_cours = '" . claro_sql_escape($course['sysCode']) . "'\n GROUP BY code_cours";
$result = claro_sql_query_get_single_row($sql);
$courseList[$courseKey]['qty_stu'] = $result['qty_stu'];
$courseList[$courseKey]['qty_cm'] = $result['qty_cm'];
}
}
// Prepare display of search/Filter panel
$advanced_search_query_string = array();
$isSearched = '';
if (!empty($_REQUEST['search'])) {
$isSearched .= trim($_REQUEST['search']) . ' ';
break;
default:
}
}
}
// Build and call DB to get info about current course (for title) if needed :
$courseData = claro_get_course_data($cidToEdit);
//----------------------------------
// Build query and find info in db
//----------------------------------
$sql = "SELECT U.user_id AS user_id,\n U.nom AS name,\n U.prenom AS firstname,\n U.username AS username,\n CU.profile_id AS profileId,\n CU.isCourseManager\n FROM `" . $tbl_mdb_names['user'] . "` AS U\n , `" . $tbl_mdb_names['rel_course_user'] . "` AS CU\n WHERE CU.`user_id` = U.`user_id`\n AND CU.`code_cours` = '" . claro_sql_escape($cidToEdit) . "'";
$myPager = new claro_sql_pager($sql, $pager_offset, get_conf('userPerPage', 20));
$sortKey = isset($_GET['sort']) ? $_GET['sort'] : 'user_id';
$sortDir = isset($_GET['dir']) ? $_GET['dir'] : SORT_ASC;
$myPager->set_sort_key($sortKey, $sortDir);
$myPager->set_pager_call_param_name('pager_offset');
$userList = $myPager->get_result_list();
// Start the list of users
$userDataList = array();
foreach ($userList as $lineId => $user) {
$userDataList[$lineId]['user_id'] = $user['user_id'];
$userDataList[$lineId]['name'] = $user['name'];
$userDataList[$lineId]['firstname'] = $user['firstname'];
$userDataList[$lineId]['profileId'] = claro_get_profile_name($user['profileId']);
if ($user['isCourseManager']) {
$userDataList[$lineId]['isCourseManager'] = '<img class="qtip" src="' . get_icon_url('manager') . '" ' . 'alt="' . get_lang('Course manager') . '" ' . 'title="' . get_lang('Course manager') . '" />';
} else {
$userDataList[$lineId]['isCourseManager'] = '<img class="qtip" src="' . get_icon_url('user') . '" ' . 'alt="' . get_lang('Student') . '" ' . 'title="' . get_lang('Student') . '" />';
}
$userDataList[$lineId]['cmd_cu_edit'] = '<a href="admin_user_course_settings.php' . '?cidToEdit=' . $cidToEdit . '&uidToEdit=' . $user['user_id'] . '&ccfrom=culist">' . '<img src="' . get_icon_url('edit') . '" alt="' . get_lang('Edit') . '"/>' . '</a>';
$userDataList[$lineId]['cmd_cu_unenroll'] = '<a href="' . $_SERVER['PHP_SELF'] . '?cidToEdit=' . $cidToEdit . '&cmd=unsub&user_id=' . $user['user_id'] . '&pager_offset=' . $pager_offset . '" ' . ' onclick="return ADMIN.confirmationUnReg(\'' . clean_str_for_javascript($user['username']) . '\');">' . "\n" . '<img src="' . get_icon_url('unenroll') . '" alt="' . get_lang('Unregister user') . '" />' . "\n" . '</a>' . "\n";
