You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
418 lines
14 KiB
418 lines
14 KiB
<?php
|
|
/* For licensing terms, see /license.txt */
|
|
|
|
/**
|
|
* Homepage for the MySpace directory.
|
|
*/
|
|
|
|
// resetting the course id
|
|
$cidReset = true;
|
|
|
|
require_once __DIR__.'/../inc/global.inc.php';
|
|
|
|
api_block_anonymous_users();
|
|
|
|
$htmlHeadXtra[] = api_get_jqgrid_js();
|
|
//$htmlHeadXtra[] = '<script type="text/javascript" src="'.api_get_path(WEB_PUBLIC_PATH).'assets/jquery.easy-pie-chart/dist/jquery.easypiechart.js"></script>';
|
|
$this_section = SECTION_TRACKING;
|
|
|
|
ob_start();
|
|
$nameTools = get_lang('Reporting');
|
|
$export_csv = isset($_GET['export']) && 'csv' === $_GET['export'] ? true : false;
|
|
$display = isset($_GET['display']) ? Security::remove_XSS($_GET['display']) : null;
|
|
$csv_content = [];
|
|
$user_id = api_get_user_id();
|
|
$session_id = isset($_GET['session_id']) ? (int) $_GET['session_id'] : 0;
|
|
$is_coach = api_is_coach($session_id);
|
|
$is_platform_admin = api_is_platform_admin();
|
|
$is_drh = api_is_drh();
|
|
$is_session_admin = api_is_session_admin();
|
|
$skipData = ('true' === api_get_setting('platform.tracking_skip_generic_data'));
|
|
|
|
$logInfo = [
|
|
'tool' => SECTION_TRACKING,
|
|
];
|
|
Event::registerLog($logInfo);
|
|
|
|
$allowToTrack = api_is_platform_admin(true, true) || api_is_teacher();
|
|
if (!$allowToTrack) {
|
|
api_not_allowed(true);
|
|
}
|
|
|
|
if ($is_session_admin) {
|
|
header('location:session.php');
|
|
exit;
|
|
}
|
|
|
|
// Get views
|
|
$views = ['admin', 'teacher', 'coach', 'drh'];
|
|
$view = 'teacher';
|
|
if (isset($_GET['view']) && in_array($_GET['view'], $views)) {
|
|
$view = $_GET['view'];
|
|
}
|
|
|
|
$menu_items = [];
|
|
$pluginCalendar = 'true' === api_get_plugin_setting('learning_calendar', 'enabled');
|
|
$calendarMenuAdded = false;
|
|
|
|
if ($is_platform_admin) {
|
|
if ('admin' === $view) {
|
|
$menu_items[] = Display::url(
|
|
Display::getMdiIcon('human-male-board', 'ch-tool-icon', null, 32, get_lang('Trainer View')),
|
|
api_get_self().'?view=teacher'
|
|
);
|
|
$menu_items[] = Display::url(
|
|
Display::getMdiIcon('star-outline', 'ch-tool-icon', null, 32, get_lang('Admin view')),
|
|
api_get_path(WEB_CODE_PATH).'my_space/admin_view.php'
|
|
);
|
|
$menu_items[] = Display::url(
|
|
Display::getMdiIcon('chart-box', 'ch-tool-icon', null, 32, get_lang('Exam tracking')),
|
|
api_get_path(WEB_CODE_PATH).'tracking/exams.php'
|
|
);
|
|
$menu_items[] = Display::url(
|
|
Display::getMdiIcon('book-open-page-variant', 'ch-tool-icon', null, 32, get_lang('Current courses report')),
|
|
api_get_path(WEB_CODE_PATH).'my_space/current_courses.php'
|
|
);
|
|
} else {
|
|
$menu_items[] = Display::url(
|
|
Display::getMdiIcon(
|
|
'human-male-board',
|
|
'ch-tool-icon-disabled',
|
|
null,
|
|
32,
|
|
get_lang('Trainer View')
|
|
),
|
|
''
|
|
);
|
|
$menu_items[] = Display::url(
|
|
Display::getMdiIcon('star-outline', 'ch-tool-icon', null, 32, get_lang('Admin view')),
|
|
//api_get_path(WEB_CODE_PATH).'tracking/course_session_report.php?view=admin'
|
|
api_get_path(WEB_CODE_PATH).'my_space/admin_view.php'
|
|
);
|
|
$menu_items[] = Display::url(
|
|
Display::getMdiIcon('order-bool-ascending-variant', 'ch-tool-icon', null, 32, get_lang('Exam tracking')),
|
|
api_get_path(WEB_CODE_PATH).'tracking/exams.php'
|
|
);
|
|
$menu_items[] = Display::url(
|
|
Display::getMdiIcon('book-open-page-variant', 'ch-tool-icon', null, 32, get_lang('Current courses report')),
|
|
api_get_path(WEB_CODE_PATH).'my_space/current_courses.php'
|
|
);
|
|
/*
|
|
$menu_items[] = Display::url(
|
|
Display::return_icon('dashboard.png', get_lang('Dashboard'), [], ICON_SIZE_MEDIUM),
|
|
api_get_path(WEB_CODE_PATH).'dashboard/index.php'
|
|
);
|
|
*/
|
|
if ($pluginCalendar) {
|
|
$lpCalendar = LearningCalendarPlugin::create();
|
|
$menu_items[] = Display::url(
|
|
Display::getMdiIcon('calendar-text', 'ch-tool-icon', null, 32, $lpCalendar->get_lang('Learning calendar')),
|
|
api_get_path(WEB_PLUGIN_PATH).'learning_calendar/start.php'
|
|
);
|
|
$calendarMenuAdded = true;
|
|
}
|
|
}
|
|
}
|
|
|
|
if ($is_drh) {
|
|
$view = 'drh';
|
|
$menu_items[] = Display::url(
|
|
Display::getMdiIcon('account', 'ch-tool-icon-disabled', null, 32, get_lang('Learners')),
|
|
'#'
|
|
);
|
|
$menu_items[] = Display::url(
|
|
Display::getMdiIcon('human-male-board', 'ch-tool-icon', null, 32, get_lang('Teachers')),
|
|
'teachers.php'
|
|
);
|
|
$menu_items[] = Display::url(
|
|
Display::getMdiIcon('book-open-page-variant', 'ch-tool-icon', null, 32, get_lang('Courses')),
|
|
'course.php'
|
|
);
|
|
$menu_items[] = Display::url(
|
|
Display::getMdiIcon('book-open-page-variant', 'ch-tool-icon', null, 32, get_lang('Course sessions')),
|
|
'session.php'
|
|
);
|
|
$menu_items[] = Display::url(
|
|
Display::getMdiIcon('chart-box', 'ch-tool-icon', null, 32, get_lang('Corporate report')),
|
|
'company_reports.php'
|
|
);
|
|
$menu_items[] = Display::url(
|
|
Display::getMdiIcon('chart-box-outline', 'ch-tool-icon', null, 32, get_lang('Corporate reportResumed')),
|
|
'company_reports_resumed.php'
|
|
);
|
|
}
|
|
|
|
$actionsRight = '';
|
|
$actionsLeft = '';
|
|
if ('useroverview' === $display || 'sessionoverview' === $display || 'courseoverview' === $display) {
|
|
$actionsRight .= Display::url(
|
|
Display::getMdiIcon(
|
|
'file-delimited-outline',
|
|
'ch-tool-icon',
|
|
null,
|
|
32,
|
|
get_lang('CSV export')
|
|
),
|
|
api_get_self().'?display='.$display.'&export=csv&view='.$view
|
|
);
|
|
}
|
|
|
|
$actionsRight .= Display::url(
|
|
Display::getMdiIcon(
|
|
'printer',
|
|
'ch-tool-icon',
|
|
null,
|
|
32,
|
|
get_lang('Print')
|
|
),
|
|
'javascript: void(0);',
|
|
['onclick' => 'javascript: window.print()']
|
|
);
|
|
|
|
if (!empty($session_id) &&
|
|
!in_array(
|
|
$display,
|
|
['accessoverview', 'lpprogressoverview', 'progressoverview', 'exerciseprogress', 'surveyoverview']
|
|
)
|
|
) {
|
|
$actionsLeft .= Display::url(
|
|
Display::getMdiIcon(
|
|
'arrow-left-bold-box',
|
|
'ch-tool-icon',
|
|
null,
|
|
32,
|
|
get_lang('Back')
|
|
),
|
|
'index.php'
|
|
);
|
|
if (!api_is_platform_admin()) {
|
|
if ('true' === api_get_setting('add_users_by_coach')) {
|
|
if ($is_coach) {
|
|
$actionsLeft .= Display::url(
|
|
Display::getMdiIcon(
|
|
'archive-arrow-up',
|
|
'ch-tool-icon',
|
|
null,
|
|
32,
|
|
get_lang('Import list of users')
|
|
),
|
|
'user_import.php?id_session='.$session_id.'&action=export&type=xml'
|
|
);
|
|
}
|
|
}
|
|
} else {
|
|
Display::url(
|
|
Display::getMdiIcon(
|
|
'archive-arrow-up',
|
|
'ch-tool-icon',
|
|
null,
|
|
32,
|
|
get_lang('Import list of users')
|
|
),
|
|
'user_import.php?id_session='.$session_id.'&action=export&type=xml'
|
|
);
|
|
}
|
|
} else {
|
|
$actionsLeft .= Display::url(
|
|
Display::getMdiIcon(
|
|
'chart-box',
|
|
'ch-tool-icon',
|
|
null,
|
|
32,
|
|
get_lang('View my progress')
|
|
),
|
|
api_get_path(WEB_CODE_PATH).'auth/my_progress.php'
|
|
);
|
|
|
|
if ($pluginCalendar && api_is_teacher() && false === $calendarMenuAdded) {
|
|
$lpCalendar = LearningCalendarPlugin::create();
|
|
$actionsLeft .= Display::url(
|
|
Display::getMdiIcon('calendar-text', 'ch-tool-icon', null, 32, $lpCalendar->get_lang('Learning calendar')),
|
|
api_get_path(WEB_PLUGIN_PATH).'learning_calendar/start.php'
|
|
);
|
|
}
|
|
|
|
if (api_is_platform_admin(true) || api_is_student_boss()) {
|
|
$actionsLeft .= Display::url(
|
|
Display::getMdiIcon(
|
|
'certificate',
|
|
'ch-tool-icon',
|
|
null,
|
|
32,
|
|
get_lang('See list of learner certificates')
|
|
),
|
|
api_get_path(WEB_CODE_PATH).'gradebook/certificate_report.php'
|
|
);
|
|
}
|
|
}
|
|
|
|
// Actions menu
|
|
$nb_menu_items = count($menu_items);
|
|
if (empty($session_id) ||
|
|
in_array(
|
|
$display,
|
|
['accessoverview', 'lpprogressoverview', 'progressoverview', 'exerciseprogress', 'surveyoverview']
|
|
)
|
|
) {
|
|
if ($nb_menu_items > 1) {
|
|
foreach ($menu_items as $key => $item) {
|
|
$actionsLeft .= $item;
|
|
}
|
|
}
|
|
}
|
|
|
|
$userId = api_get_user_id();
|
|
$stats = Tracking::getStats($userId, true);
|
|
|
|
$numberStudents = $stats['student_count'];
|
|
$students = $stats['student_list'];
|
|
$numberStudentBosses = $stats['student_bosses'];
|
|
$numberTeachers = $stats['teachers'];
|
|
$countHumanResourcesUsers = $stats['drh'];
|
|
$countAssignedCourses = $stats['assigned_courses'];
|
|
$countCourses = $stats['courses'];
|
|
$sessions = $stats['session_list'];
|
|
|
|
$sessionIdList = [];
|
|
if (!empty($sessions)) {
|
|
foreach ($sessions as $session) {
|
|
$sessionIdList[] = $session['id'];
|
|
}
|
|
}
|
|
|
|
// Sessions for the user
|
|
$countSessions = count($sessions);
|
|
$total_time_spent = 0;
|
|
$total_courses = 0;
|
|
$avgTotalProgress = 0;
|
|
$nb_inactive_students = 0;
|
|
$numberAssignments = 0;
|
|
$inactiveTime = time() - (3600 * 24 * 7);
|
|
$daysAgo = 7;
|
|
$studentIds = [];
|
|
$avg_courses_per_student = 0;
|
|
|
|
$view = new Template($nameTools);
|
|
$view->assign('students', $numberStudents);
|
|
$view->assign('studentbosses', $numberStudentBosses);
|
|
$view->assign('numberTeachers', $numberTeachers);
|
|
$view->assign('humanresources', $countHumanResourcesUsers);
|
|
$view->assign(
|
|
'total_user',
|
|
$numberStudents + $numberStudentBosses + $numberTeachers + $countHumanResourcesUsers
|
|
);
|
|
$view->assign('studentboss', STUDENT_BOSS);
|
|
$view->assign('drh', DRH);
|
|
$view->assign('stats', $stats);
|
|
|
|
$form = new FormValidator(
|
|
'search_user',
|
|
'get',
|
|
api_get_path(WEB_CODE_PATH).'my_space/student.php'
|
|
);
|
|
$form = Tracking::setUserSearchForm($form);
|
|
|
|
$totalTimeSpent = null;
|
|
$averageScore = null;
|
|
$posts = null;
|
|
|
|
if (false === $skipData) {
|
|
if (!empty($students)) {
|
|
// Students
|
|
$studentIds = array_values($students);
|
|
$progress = 0; //Tracking::get_avg_student_progress($studentIds);
|
|
// @todo fix stats
|
|
//$countAssignments = Tracking::count_student_assignments($studentIds);
|
|
$countAssignments = 0;
|
|
// average progress
|
|
$avgTotalProgress = $progress / $numberStudents;
|
|
// average assignments
|
|
$numberAssignments = $countAssignments / $numberStudents;
|
|
$avg_courses_per_student = $countCourses / $numberStudents;
|
|
$totalTimeSpent = Tracking::get_time_spent_on_the_platform($studentIds);
|
|
//$posts = Tracking::count_student_messages($studentIds);
|
|
$posts = 0;
|
|
$averageScore = Tracking::getAverageStudentScore($studentIds);
|
|
}
|
|
|
|
if ($export_csv) {
|
|
//csv part
|
|
$csv_content[] = [get_lang('Learners')];
|
|
$csv_content[] = [get_lang('InactivesLearners'), $nb_inactive_students];
|
|
$csv_content[] = [get_lang('Time spent on portal'), $totalTimeSpent];
|
|
$csv_content[] = [
|
|
get_lang('Average number of courses to which my learners are subscribed'),
|
|
round($avg_courses_per_student, 3),
|
|
];
|
|
$csv_content[] = [
|
|
get_lang('Progress in courses'),
|
|
is_null($avgTotalProgress)
|
|
? null
|
|
: round($avgTotalProgress, 2).'%',
|
|
];
|
|
$csv_content[] = [
|
|
get_lang('Tests score'),
|
|
is_null($averageScore)
|
|
? null
|
|
: round($averageScore, 2).'%',
|
|
];
|
|
$csv_content[] = [get_lang('Posts in forum'), $posts];
|
|
$csv_content[] = [get_lang('Average assignments per learner'), $numberAssignments];
|
|
$csv_content[] = [];
|
|
} else {
|
|
$lastConnectionDate = api_get_utc_datetime(strtotime('15 days ago'));
|
|
$countActiveUsers = SessionManager::getCountUserTracking(
|
|
null,
|
|
1,
|
|
null,
|
|
[],
|
|
[]
|
|
);
|
|
$countSleepingTeachers = SessionManager::getTeacherTracking(
|
|
api_get_user_id(),
|
|
1,
|
|
$lastConnectionDate,
|
|
true,
|
|
$sessionIdList
|
|
);
|
|
|
|
$countSleepingStudents = SessionManager::getCountUserTracking(
|
|
null,
|
|
1,
|
|
$lastConnectionDate,
|
|
$sessionIdList,
|
|
$studentIds
|
|
);
|
|
$report['AverageCoursePerStudent'] = is_null($avg_courses_per_student)
|
|
? ''
|
|
: round($avg_courses_per_student, 3);
|
|
$report['InactivesStudents'] = $nb_inactive_students;
|
|
$report['AverageTimeSpentOnThePlatform'] = is_null($totalTimeSpent)
|
|
? '00:00:00'
|
|
: api_time_to_hms($totalTimeSpent);
|
|
$report['AverageProgressInLearnpath'] = is_null($avgTotalProgress)
|
|
? ''
|
|
: round($avgTotalProgress, 2).'%';
|
|
$report['AvgCourseScore'] = is_null($averageScore) ? '0' : round($averageScore, 2).'%';
|
|
$report['AveragePostsInForum'] = is_null($posts) ? '0' : round($posts, 2);
|
|
$report['AverageAssignments'] = is_null($numberAssignments) ? '' : round($numberAssignments, 2);
|
|
$view->assign('report', $report);
|
|
}
|
|
}
|
|
|
|
$view->assign('header', $nameTools);
|
|
$view->assign('form', $form->returnForm());
|
|
$view->assign('actions', Display::toolbarAction('toolbar', [$actionsLeft, $actionsRight]));
|
|
$view->assign('title', get_lang('Students').' ('.$numberStudents.')');
|
|
|
|
$template = $view->get_template('my_space/index.tpl');
|
|
$content = $view->fetch($template);
|
|
$view->assign('content', $content);
|
|
$view->display_one_col_template();
|
|
|
|
// Send the csv file if asked
|
|
if ($export_csv) {
|
|
ob_end_clean();
|
|
Export:: arrayToCsv($csv_content, 'reporting_index');
|
|
exit;
|
|
}
|
|
|