"index.php", "name" => get_lang('MySpace')); if(isset($_GET["id_student"])){ $interbreadcrumb[] = array ("url" => "student.php", "name" => get_lang('Students')); } Display :: display_header($nameTools); api_display_tool_title($nameTools); // Database Table Definitions $tbl_course = Database :: get_main_table(TABLE_MAIN_COURSE); $tbl_course_user = Database :: get_main_table(TABLE_MAIN_COURSE_USER); $tbl_user = Database :: get_main_table(TABLE_MAIN_USER); $tbl_session = Database :: get_main_table(TABLE_MAIN_SESSION); $tbl_session_rel_course = Database :: get_main_table(TABLE_MAIN_SESSION_COURSE); $tbl_session_rel_course_rel_user = Database :: get_main_table(TABLE_MAIN_SESSION_COURSE_USER); $tbl_session_rel_user = Database :: get_main_table(TABLE_MAIN_SESSION_USER); $tbl_track_login = Database :: get_statistic_table(TABLE_STATISTIC_TRACK_E_LOGIN); /* =============================================================================== FUNCTION =============================================================================== */ function exportCsv($a_header, $a_data) { global $archiveDirName; $fileName = 'coaches.csv'; $archivePath = api_get_path(SYS_ARCHIVE_PATH); $archiveURL = api_get_path(WEB_CODE_PATH).'course_info/download.php?archive='; if (!$open = fopen($archivePath.$fileName, 'w+')) { $message = get_lang('noOpen'); } else { $info = ''; foreach ($a_header as $header) { $info .= $header.';'; } $info .= "\r\n"; foreach ($a_data as $data) { foreach ($data as $infos) { $info .= $infos.';'; } $info .= "\r\n"; } fwrite($open, $info); fclose($open); $perm = api_get_setting('permissions_for_new_files'); $perm = octdec(!empty($perm) ? $perm : '0660'); chmod($fileName, $perm); header("Location:".$archiveURL.$fileName); } return $message; } function calculHours($seconds) { //combien d'heures ? $hours = floor($seconds / 3600); //combien de minutes ? $min = floor(($seconds - ($hours * 3600)) / 60); if ($min < 10) { $min = "0".$min; } //combien de secondes $sec = $seconds - ($hours * 3600) - ($min * 60); if ($sec < 10) { $sec = "0".$sec; } //echo $hours."h".$min."m".$sec."s"; return $hours."h".$min."m".$sec."s" ; } function is_coach() { global $tbl_session_course; $sql = "SELECT course_code FROM $tbl_session_course WHERE id_coach='".$_SESSION["_uid"]."'"; $result = Database::query($sql, __FILE__, __LINE__); if (Database::num_rows($result) > 0) { return true; } else { return false; } } /** * MAIN PART */ if (isset($_POST['export'])) { $order_clause = api_is_western_name_order(PERSON_NAME_DATA_EXPORT) ? ' ORDER BY firstname, lastname' : ' ORDER BY lastname, firstname'; } else { $order_clause = api_sort_by_first_name() ? ' ORDER BY firstname, lastname' : ' ORDER BY lastname, firstname'; } if (isset($_GET["id_student"])) { $i_id_student=$_GET["id_student"]; $sqlCoachs = "SELECT DISTINCT src.id_coach " . "FROM $tbl_session_rel_course as src, $tbl_session_rel_course_rel_user as srcru " . "WHERE src.id_coach<>'0' AND src.course_code=srcru.course_code AND srcru.id_user='$i_id_student' AND srcru.id_session=src.id_session"; } else { if (api_is_platform_admin()) { $sqlCoachs = "SELECT DISTINCT id_coach, user_id, lastname, firstname FROM $tbl_user, $tbl_session_rel_course WHERE id_coach=user_id".$order_clause; } else { $sqlCoachs = "SELECT DISTINCT id_coach, $tbl_user.user_id, lastname, firstname FROM $tbl_user as user, $tbl_session_rel_course as session_rel_course, $tbl_course_user as course_rel_user WHERE course_rel_user.course_code=session_rel_course.course_code AND course_rel_user.status='1' AND course_rel_user.user_id='".$_SESSION["_uid"]."' AND session_rel_course.id_coach=user.user_id".$order_clause; } } $resultCoachs = Database::query($sqlCoachs, __FILE__, __LINE__); if (api_is_western_name_order()) { echo '