"index.php", "name" => get_lang('MySpace')); Display :: display_header($nameTools); // Database Table Definitions $tbl_course_user = Database :: get_main_table(TABLE_MAIN_COURSE_USER); $tbl_sessions = Database :: get_main_table(TABLE_MAIN_SESSION); $tbl_session_course = Database :: get_main_table(TABLE_MAIN_SESSION_COURSE); $tbl_course = Database :: get_main_table(TABLE_MAIN_COURSE); $export_csv = false; if (isset($_GET['export']) && $_GET['export'] == 'csv') { $export_csv = true; } /* =============================================================================== FUNCTION =============================================================================== */ function count_sessions_coached() { global $nb_sessions; return $nb_sessions; } function sort_sessions($a, $b) { global $tracking_column; if ($a[$tracking_column] > $b[$tracking_column]) { return 1; } else { return -1; } } function rsort_sessions($a, $b) { global $tracking_column; if ($b[$tracking_column] > $a[$tracking_column]) { return 1; } else { return -1; } } /* =============================================================================== MAIN CODE =============================================================================== */ if (isset($_GET['id_coach']) && $_GET['id_coach'] != '') { $id_coach = intval($_GET['id_coach']); } else { $id_coach = $_user['user_id']; } $a_sessions = Tracking :: get_sessions_coached_by_user($id_coach); $nb_sessions = count($a_sessions); if ($export_csv) { $csv_content = array(); } if ($nb_sessions > 0) { echo '
'; $table = new SortableTable('tracking', 'count_sessions_coached'); $table -> set_header(0, get_lang('Title')); $table -> set_header(1, get_lang('Status')); $table -> set_header(2, get_lang('Date')); $table -> set_header(3, get_lang('Details'), false); $all_data = array(); foreach ($a_sessions as $session) { $row = array(); $row[] = $session['name']; $row[] = $session['status']; if ($session['date_start'] != '0000-00-00' && $session['date_end'] != '0000-00-00') { $row[] = get_lang('From').' '.format_locale_date(get_lang('DateFormatLongWithoutDay'), strtotime($session['date_start'])).' '.get_lang('To').' '.format_locale_date(get_lang('DateFormatLongWithoutDay'), strtotime($session['date_end'])); } else { $row[] = ' - '; } if ($export_csv) { $csv_content[] = $row; } if (isset($_GET['id_coach']) && $_GET['id_coach'] != '') { $row[] = '