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.
		
		
		
		
		
			
		
			
				
					
					
						
							406 lines
						
					
					
						
							13 KiB
						
					
					
				
			
		
		
	
	
							406 lines
						
					
					
						
							13 KiB
						
					
					
				<?php
 | 
						|
/* For licensing terms, see /license.txt */
 | 
						|
 | 
						|
/**
 | 
						|
 * Homepage for the MySpace directory.
 | 
						|
 *
 | 
						|
 * @package chamilo.reporting
 | 
						|
 */
 | 
						|
 | 
						|
// resetting the course id
 | 
						|
$cidReset = true;
 | 
						|
 | 
						|
require_once __DIR__.'/../inc/global.inc.php';
 | 
						|
 | 
						|
// Access control
 | 
						|
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('MySpace');
 | 
						|
$export_csv = isset($_GET['export']) && $_GET['export'] === 'csv' ? 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 = api_get_configuration_value('tracking_skip_generic_data');
 | 
						|
 | 
						|
$logInfo = [
 | 
						|
    'tool' => SECTION_TRACKING,
 | 
						|
    'tool_id' => 0,
 | 
						|
    'tool_id_detail' => 0,
 | 
						|
];
 | 
						|
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 = api_get_plugin_setting('learning_calendar', 'enabled') === 'true';
 | 
						|
$calendarMenuAdded = false;
 | 
						|
 | 
						|
if ($is_platform_admin) {
 | 
						|
    if ($view == 'admin') {
 | 
						|
        $menu_items[] = Display::url(
 | 
						|
            Display::return_icon('teacher.png', get_lang('TeacherInterface'), [], ICON_SIZE_MEDIUM),
 | 
						|
            api_get_self().'?view=teacher'
 | 
						|
        );
 | 
						|
        $menu_items[] = Display::url(
 | 
						|
            Display::return_icon('star_na.png', get_lang('AdminInterface'), [], ICON_SIZE_MEDIUM),
 | 
						|
            api_get_path(WEB_CODE_PATH).'mySpace/admin_view.php'
 | 
						|
        );
 | 
						|
        $menu_items[] = Display::url(
 | 
						|
            Display::return_icon('quiz.png', get_lang('ExamTracking'), [], ICON_SIZE_MEDIUM),
 | 
						|
            api_get_path(WEB_CODE_PATH).'tracking/exams.php'
 | 
						|
        );
 | 
						|
        $menu_items[] = Display::url(
 | 
						|
            Display::return_icon('statistics.png', get_lang('CurrentCoursesReport'), [], ICON_SIZE_MEDIUM),
 | 
						|
            api_get_path(WEB_CODE_PATH).'mySpace/current_courses.php'
 | 
						|
        );
 | 
						|
    } else {
 | 
						|
        $menu_items[] = Display::url(
 | 
						|
            Display::return_icon(
 | 
						|
                'teacher_na.png',
 | 
						|
                get_lang('TeacherInterface'),
 | 
						|
                [],
 | 
						|
                ICON_SIZE_MEDIUM
 | 
						|
            ),
 | 
						|
            ''
 | 
						|
        );
 | 
						|
        $menu_items[] = Display::url(
 | 
						|
            Display::return_icon('star.png', get_lang('AdminInterface'), [], ICON_SIZE_MEDIUM),
 | 
						|
            //api_get_path(WEB_CODE_PATH).'tracking/course_session_report.php?view=admin'
 | 
						|
            api_get_path(WEB_CODE_PATH).'mySpace/admin_view.php'
 | 
						|
        );
 | 
						|
        $menu_items[] = Display::url(
 | 
						|
            Display::return_icon('quiz.png', get_lang('ExamTracking'), [], ICON_SIZE_MEDIUM),
 | 
						|
            api_get_path(WEB_CODE_PATH).'tracking/exams.php'
 | 
						|
        );
 | 
						|
        $menu_items[] = Display::url(
 | 
						|
            Display::return_icon('statistics.png', get_lang('CurrentCoursesReport'), [], ICON_SIZE_MEDIUM),
 | 
						|
            api_get_path(WEB_CODE_PATH).'mySpace/current_courses.php'
 | 
						|
        );
 | 
						|
 | 
						|
        if ($pluginCalendar) {
 | 
						|
            $lpCalendar = LearningCalendarPlugin::create();
 | 
						|
            $menu_items[] = Display::url(
 | 
						|
                Display::return_icon('agenda.png', $lpCalendar->get_lang('LearningCalendar'), [], ICON_SIZE_MEDIUM),
 | 
						|
                api_get_path(WEB_PLUGIN_PATH).'learning_calendar/start.php'
 | 
						|
            );
 | 
						|
            $calendarMenuAdded = true;
 | 
						|
        }
 | 
						|
    }
 | 
						|
}
 | 
						|
 | 
						|
if ($is_drh) {
 | 
						|
    $view = 'drh';
 | 
						|
    $menu_items[] = Display::url(
 | 
						|
        Display::return_icon('user_na.png', get_lang('Students'), [], ICON_SIZE_MEDIUM),
 | 
						|
        '#'
 | 
						|
    );
 | 
						|
    $menu_items[] = Display::url(
 | 
						|
        Display::return_icon('teacher.png', get_lang('Trainers'), [], ICON_SIZE_MEDIUM),
 | 
						|
        'teachers.php'
 | 
						|
    );
 | 
						|
    $menu_items[] = Display::url(
 | 
						|
        Display::return_icon('course.png', get_lang('Courses'), [], ICON_SIZE_MEDIUM),
 | 
						|
        'course.php'
 | 
						|
    );
 | 
						|
    $menu_items[] = Display::url(
 | 
						|
        Display::return_icon('session.png', get_lang('Sessions'), [], ICON_SIZE_MEDIUM),
 | 
						|
        'session.php'
 | 
						|
    );
 | 
						|
    $menu_items[] = Display::url(
 | 
						|
        Display::return_icon('empty_evaluation.png', get_lang('CompanyReport'), [], ICON_SIZE_MEDIUM),
 | 
						|
        'company_reports.php'
 | 
						|
    );
 | 
						|
    $menu_items[] = Display::url(
 | 
						|
        Display::return_icon('evaluation_rate.png', get_lang('CompanyReportResumed'), [], ICON_SIZE_MEDIUM),
 | 
						|
        'company_reports_resumed.php'
 | 
						|
    );
 | 
						|
}
 | 
						|
 | 
						|
$actionsRight = '';
 | 
						|
$actionsLeft = '';
 | 
						|
if ($display == 'useroverview' || $display == 'sessionoverview' || $display == 'courseoverview') {
 | 
						|
    $actionsRight .= Display::url(
 | 
						|
        Display::return_icon(
 | 
						|
            'export_csv.png',
 | 
						|
            get_lang('ExportAsCSV'),
 | 
						|
            null,
 | 
						|
            ICON_SIZE_MEDIUM
 | 
						|
        ),
 | 
						|
        api_get_self().'?display='.$display.'&export=csv&view='.$view
 | 
						|
    );
 | 
						|
}
 | 
						|
 | 
						|
$actionsRight .= Display::url(
 | 
						|
    Display::return_icon(
 | 
						|
        'printer.png',
 | 
						|
        get_lang('Print'),
 | 
						|
        null,
 | 
						|
        ICON_SIZE_MEDIUM
 | 
						|
    ),
 | 
						|
    'javascript: void(0);',
 | 
						|
    ['onclick' => 'javascript: window.print()']
 | 
						|
);
 | 
						|
 | 
						|
if (!empty($session_id) &&
 | 
						|
    !in_array(
 | 
						|
        $display,
 | 
						|
        ['accessoverview', 'lpprogressoverview', 'progressoverview', 'exerciseprogress', 'surveyoverview']
 | 
						|
    )
 | 
						|
) {
 | 
						|
    $actionsLeft .= Display::url(
 | 
						|
        Display::return_icon(
 | 
						|
            'back.png',
 | 
						|
            get_lang('Back'),
 | 
						|
            null,
 | 
						|
            ICON_SIZE_MEDIUM
 | 
						|
        ),
 | 
						|
        'index.php'
 | 
						|
    );
 | 
						|
    if (!api_is_platform_admin()) {
 | 
						|
        if (api_get_setting('add_users_by_coach') == 'true') {
 | 
						|
            if ($is_coach) {
 | 
						|
                $actionsLeft .= Display::url(
 | 
						|
                    Display::return_icon(
 | 
						|
                        'excel.png',
 | 
						|
                        get_lang('ImportUserList'),
 | 
						|
                        null,
 | 
						|
                        ICON_SIZE_MEDIUM
 | 
						|
                    ),
 | 
						|
                    'user_import.php?id_session='.$session_id.'&action=export&type=xml'
 | 
						|
                );
 | 
						|
            }
 | 
						|
        }
 | 
						|
    } else {
 | 
						|
        Display::url(
 | 
						|
            Display::return_icon(
 | 
						|
                'excel.png',
 | 
						|
                get_lang('ImportUserList'),
 | 
						|
                null,
 | 
						|
                ICON_SIZE_MEDIUM
 | 
						|
            ),
 | 
						|
            'user_import.php?id_session='.$session_id.'&action=export&type=xml'
 | 
						|
        );
 | 
						|
    }
 | 
						|
} else {
 | 
						|
    $actionsLeft .= Display::url(
 | 
						|
        Display::return_icon(
 | 
						|
            'statistics.png',
 | 
						|
            get_lang('MyStats'),
 | 
						|
            null,
 | 
						|
            ICON_SIZE_MEDIUM
 | 
						|
        ),
 | 
						|
        api_get_path(WEB_CODE_PATH).'auth/my_progress.php'
 | 
						|
    );
 | 
						|
 | 
						|
    if ($pluginCalendar && api_is_teacher() && $calendarMenuAdded === false) {
 | 
						|
        $lpCalendar = LearningCalendarPlugin::create();
 | 
						|
        $actionsLeft .= Display::url(
 | 
						|
            Display::return_icon('agenda.png', $lpCalendar->get_lang('LearningCalendar'), [], ICON_SIZE_MEDIUM),
 | 
						|
            api_get_path(WEB_PLUGIN_PATH).'learning_calendar/start.php'
 | 
						|
        );
 | 
						|
    }
 | 
						|
 | 
						|
    if (api_is_platform_admin(true) || api_is_student_boss()) {
 | 
						|
        $actionsLeft .= Display::url(
 | 
						|
            Display::return_icon(
 | 
						|
                "certificate_list.png",
 | 
						|
                get_lang('GradebookSeeListOfStudentsCertificates'),
 | 
						|
                null,
 | 
						|
                ICON_SIZE_MEDIUM
 | 
						|
            ),
 | 
						|
            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).'mySpace/student.php'
 | 
						|
);
 | 
						|
$form = Tracking::setUserSearchForm($form);
 | 
						|
 | 
						|
$totalTimeSpent = null;
 | 
						|
$averageScore = null;
 | 
						|
$posts = null;
 | 
						|
 | 
						|
if ($skipData === false) {
 | 
						|
    if (!empty($students)) {
 | 
						|
        // Students
 | 
						|
        $studentIds = array_values($students);
 | 
						|
        $progress = Tracking::get_avg_student_progress($studentIds);
 | 
						|
        $countAssignments = Tracking::count_student_assignments($studentIds);
 | 
						|
        // 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);
 | 
						|
        $averageScore = Tracking::getAverageStudentScore($studentIds);
 | 
						|
    }
 | 
						|
 | 
						|
    if ($export_csv) {
 | 
						|
        //csv part
 | 
						|
        $csv_content[] = [get_lang('Students')];
 | 
						|
        $csv_content[] = [get_lang('InactivesStudents'), $nb_inactive_students];
 | 
						|
        $csv_content[] = [get_lang('AverageTimeSpentOnThePlatform'), $totalTimeSpent];
 | 
						|
        $csv_content[] = [get_lang('AverageCoursePerStudent'), round($avg_courses_per_student, 3)];
 | 
						|
        $csv_content[] = [
 | 
						|
            get_lang('AverageProgressInLearnpath'),
 | 
						|
            is_null($avgTotalProgress)
 | 
						|
                ? null
 | 
						|
                : round($avgTotalProgress, 2).'%',
 | 
						|
        ];
 | 
						|
        $csv_content[] = [
 | 
						|
            get_lang('AverageResultsToTheExercices'),
 | 
						|
            is_null($averageScore)
 | 
						|
                ? null
 | 
						|
                : round($averageScore, 2).'%',
 | 
						|
        ];
 | 
						|
        $csv_content[] = [get_lang('AveragePostsInForum'), $posts];
 | 
						|
        $csv_content[] = [get_lang('AverageAssignments'), $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;
 | 
						|
}
 | 
						|
 |