$(function() { $( "#keyword_start_date_start" ).datepicker({ dateFormat: '."'yy-mm-dd'".' }); $( "#keyword_start_date_end" ).datepicker({ dateFormat: '."'yy-mm-dd'".' }); }); function validate() { if( $("#keyword_start_date_start").val() != "" && $("#keyword_start_date_end").val() != ""){ datestart = $("#keyword_start_date_start").val(); dateend = $("#keyword_start_date_end").val(); dif = $.datepicker.parseDate("dd/mm/yy", datestart) - $.datepicker.parseDate("dd/mm/yy", dateend); if(dif > 0){ alert("La fecha final no puede ser mayor a la fecha inicial"); return false; } } } function load_course_list (div_course,my_user_id) { $.ajax({ contentType: "application/x-www-form-urlencoded", type: "GET", url: "course_user_list.php", data: "user_id="+my_user_id, success: function(datos) { $("div#user_request").html(datos); $("#btnsubmit").attr("disabled", false); } }); } '; $types = TicketManager::get_all_tickets_categories(); $tools = []; $tools['todas'] = ['id' => '', 'name' => get_lang('All')]; $tools['announcement'] = ['id' => 'announcement', 'name' => get_lang('Announcement')]; // $tools[]= array('id'=>'assignment','name'=>get_lang('Assignment')); $tools['calendar_event'] = ['id' => 'calendar_event', 'name' => get_lang('ToolCalendarEvent')]; $tools['chat'] = ['id' => 'chat', 'name' => get_lang('Chat')]; $tools['course_description'] = ['id' => 'course_description', 'name' => get_lang('CourseDescription')]; $tools['document'] = ['id' => 'document', 'name' => get_lang('Document')]; $tools['dropbox'] = ['id' => 'dropbox', 'name' => get_lang('Dropbox')]; $tools['group'] = ['id' => 'group', 'name' => get_lang('Group')]; $tools['learnpath'] = ['id' => 'learnpath', 'name' => get_lang('Learnpath')]; $tools['link'] = ['id' => 'link', 'name' => get_lang('Link')]; $tools['quiz'] = ['id' => 'quiz', 'name' => get_lang('Quiz')]; $tools['student_publication'] = ['id' => 'student_publication', 'name' => get_lang('ToolStudentPublication')]; $tools['user'] = ['id' => 'user', 'name' => get_lang('User')]; $tools['forum'] = ['id' => 'forum', 'name' => get_lang('Forum')]; /** * This function is to show the ticket form. * * @global array $tools */ function show_form() { global $tools; echo '
'; echo '
'; $select_course = '
'; echo $select_course; //select status $select_tool = '
'.get_lang('Tool').':
'; $select_tool .= '"; $select_tool .= '
'; echo $select_tool; echo '
'.get_lang('From').':
'.get_lang('To').'
'; echo '
'; echo '
'; } /** * Get the total number of users on the platform. * * @see SortableTable#get_total_number_of_items() */ function get_number_of_users() { $user_table = Database::get_main_table(TABLE_MAIN_USER); $sql = "SELECT COUNT(u.user_id) AS total_number_of_items FROM $user_table u"; if ((api_is_platform_admin() || api_is_session_admin()) && api_get_multiple_access_url()) { $access_url_rel_user_table = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER); $sql .= " INNER JOIN $access_url_rel_user_table url_rel_user ON (u.user_id=url_rel_user.user_id)"; } if (isset($_GET['keyword'])) { $keyword = Database::escape_string(trim($_GET['keyword'])); $sql .= " WHERE (u.firstname LIKE '%$keyword%' OR u.lastname LIKE '%$keyword%' OR concat(u.firstname,' ',u.lastname) LIKE '%$keyword%' OR concat(u.lastname,' ',u.firstname) LIKE '%$keyword%' OR u.username LIKE '%$keyword%' OR u.email LIKE '%$keyword %' OR u.official_code LIKE '%$keyword%') "; } $res = Database::query($sql); $obj = Database::fetch_object($res); return $obj->total_number_of_items; } /** * Get the users to display on the current page (fill the sortable-table). * * @param int offset of first user to recover * @param int Number of users to get * @param int Column to sort on * @param string Order (ASC,DESC) * * @return array * * @see SortableTable#get_table_data($from) */ function get_user_data($from, $number_of_items, $column, $direction) { $user_table = Database::get_main_table(TABLE_MAIN_USER); if (api_is_western_name_order()) { $col34 = "u.firstname AS col3, u.lastname AS col4,"; } else { $col34 = "u.lastname AS col3, u.firstname AS col4,"; } $sql = "SELECT u.user_id AS col0, u.official_code AS col2, $col34 u.username AS col5, u.email AS col6, u.status AS col7, u.active AS col8, u.user_id AS col9, u.expiration_date AS exp FROM $user_table u "; if (isset($_GET['keyword'])) { $keyword = Database::escape_string(trim($_GET['keyword'])); $sql .= " WHERE (u.firstname LIKE '%$keyword%' OR u.lastname LIKE '%$keyword%' OR concat(u.firstname,' ',u.lastname) LIKE '%$keyword%' OR concat(u.lastname,' ',u.firstname) LIKE '%$keyword%' OR u.username LIKE '%$keyword%' OR u.official_code LIKE '%$keyword%' OR u.email LIKE '%$keyword%' )"; } if (!in_array($direction, ['ASC', 'DESC'])) { $direction = 'ASC'; } $column = intval($column); $from = intval($from); $number_of_items = intval($number_of_items); $sql .= " ORDER BY col$column $direction "; $sql .= " LIMIT $from, $number_of_items"; $res = Database::query($sql); $users = []; $webPath = api_get_path(WEB_PATH); while ($user = Database::fetch_row($res)) { $userPicture = UserManager::getUserPicture($user[0]); $photo = ''.api_get_person_name($user[2], $user[3]).''; $user_id = $user[0]; $button = ' '.get_lang('Courses').'   '; $users[] = [ $photo, $user[1], $user[2], $user[3], $user[4], $user[5], $button, ]; } return $users; } Display::display_header('Reports'); echo '
 
'; if (isset($_GET['keyword'])) { $table = new SortableTable('users', 'get_number_of_users', 'get_user_data', (api_is_western_name_order() || api_sort_by_first_name()) ? 3 : 2); $table->set_header(0, '', false, 'width="18px"'); $table->set_header(0, get_lang('Photo'), false); $table->set_header(1, get_lang('OfficialCode')); if (api_is_western_name_order()) { $table->set_header(2, get_lang('FirstName')); $table->set_header(3, get_lang('LastName')); } else { $table->set_header(2, get_lang('LastName')); $table->set_header(3, get_lang('FirstName')); } $table->set_header(4, get_lang('LoginName')); $table->set_header(5, get_lang('Email')); $table->set_header(6, get_lang('Action')); $table->display(); } if (isset($_POST['report'])) { $course_info = api_get_course_info_by_id($course_id); $course_id = Database::escape_string($_POST['course_id']); $tool = Database::escape_string($_POST['tool']); $user_id = intval($_POST['user_id_request']); $sql = "SELECT u.username , CONCAT(u.lastname, ' ', u.firstname) AS fullname, DATE_SUB(access.access_date,INTERVAL 5 HOUR) AS access_date, c.title AS course, access_tool AS tool FROM ".Database::get_main_table(TABLE_STATISTIC_TRACK_E_ACCESS)." access LEFT JOIN ".Database::get_main_table(TABLE_MAIN_USER)." u ON access.access_user_id = u.user_id LEFT JOIN ".Database::get_main_table(TABLE_MAIN_COURSE)." c ON access.c_id = c.id WHERE access.c_id = ".$course_info['real_id']." AND u.user_id = $user_id "; if ($tool != '') { $sql .= "AND access.access_tool = '$tool' "; } $start_date = Database::escape_string($_POST['keyword_start_date_start']); $end_date = Database::escape_string($_POST['keyword_start_date_end']); if ($start_date != '' || $end_date != '') { $sql .= " HAVING "; if ($start_date != '') { $sql .= " access_date >= '$start_date' "; } if ($end_date != '') { $sql = ($start_date == '') ? $sql : ($sql." AND "); $sql .= " access_date <= '$end_date' "; } } $result = Database::query($sql); $table_result = new SortableTable(); $table_result->set_header(0, get_lang('User'), false); $table_result->set_header(1, get_lang('FullUserName'), false); $table_result->set_header(2, get_lang('Date'), false); $table_result->set_header(3, get_lang('Course'), false); $table_result->set_header(4, get_lang('Tool'), false); while ($row = Database::fetch_assoc($result)) { $row = [ $row['username'], $row['fullname'], $row['access_date'], $row['course'], get_lang($tools[$row['tool']]['name']), ]; $table_result->addRow($row); } $table_result->display(); } else { show_form(); } Display::display_footer();