Esempio n. 1
0
echo '<div class="report_section">
        ' . Display::page_subheader2(Display::return_icon('chat.gif', get_lang('Chat')) . get_lang('Chat')) . '
        <table class="data_table">';
$chat_connections_during_last_x_days_by_course = Tracking::chat_connections_during_last_x_days_by_course($courseId, 7, $session_id, $filter_by_users);
if ($export_csv) {
    $csv_content[] = array(get_lang('Chat', ''), '');
    $csv_content[] = array(sprintf(get_lang('ChatConnectionsDuringLastXDays', ''), '7'), $chat_connections_during_last_x_days_by_course);
}
echo '<tr><td>' . sprintf(get_lang('ChatConnectionsDuringLastXDays'), '7') . '</td><td align="right">' . $chat_connections_during_last_x_days_by_course . '</td></tr>';
echo '</table></div>';
echo '<div class="clear"></div>';
// Tools tracking.
echo '<div class="report_section">
            ' . Display::page_subheader2(Display::return_icon('acces_tool.gif', get_lang('ToolsMostUsed')) . get_lang('ToolsMostUsed')) . '
        <table class="data_table">';
$tools_most_used = Tracking::get_tools_most_used_by_course($courseId, $session_id, $filter_by_users);
if ($export_csv) {
    $temp = array(get_lang('ToolsMostUsed'), '');
    $csv_content[] = $temp;
}
if (!empty($tools_most_used)) {
    foreach ($tools_most_used as $row) {
        echo '	<tr>
                    <td>' . get_lang(ucfirst($row['access_tool'])) . '</td>
                    <td align="right">' . $row['count_access_tool'] . ' ' . get_lang('Clicks') . '</td>
                </tr>';
        if ($export_csv) {
            $temp = array(get_lang(ucfirst($row['access_tool']), ''), $row['count_access_tool'] . ' ' . get_lang('Clicks', ''));
            $csv_content[] = $temp;
        }
    }
 $tmp_students = CourseManager::get_student_list_from_course_code($course_code, false);
 //Cleaning students only REAL students
 $students = array();
 foreach ($tmp_students as $student) {
     $user_info = api_get_user_info($student['user_id']);
     if ($user_info['status'] != STUDENT) {
         continue;
     }
     $students[] = $student['user_id'];
 }
 $t_lp = Database::get_course_table(TABLE_LP_MAIN);
 $sql_lp = "SELECT lp.name, lp.id FROM {$t_lp} lp WHERE c_id = {$course_id} AND lp.session_id = 0";
 $rs_lp = Database::query($sql_lp);
 $t_lpi = Database::get_course_table(TABLE_LP_ITEM);
 $t_news = Database::get_course_table(TABLE_ANNOUNCEMENT);
 $total_tools_list = Tracking::get_tools_most_used_by_course($course_id, $session_id);
 $total_tools = 0;
 foreach ($total_tools_list as $tool) {
     $total_tools += $tool['count_access_tool'];
 }
 if (Database::num_rows($rs_lp) > 0) {
     while ($learnpath = Database::fetch_array($rs_lp)) {
         $lp_id = $learnpath['id'];
         $lp_items = $array[$i]['lp'] = '<a href="' . api_get_path(WEB_CODE_PATH) . 'newscorm/lp_controller.php?cidReq=' . $course_code . '&amp;action=view&amp;lp_id=' . $lp_id . '" target="_blank">' . $learnpath['name'] . '</a>';
         $array[$i]['teachers'] = '';
         if (!empty($teacher_list)) {
             $array[$i]['teachers'] = implode(', ', $teacher_list);
         }
         $array[$i]['course_name'] = $course['title'];
         $count_students_accessing = 0;
         $count_students_complete_all_activities = 0;
$chat_connections_during_last_x_days_by_course = Tracking::chat_connections_during_last_x_days_by_course($course_code, 7, $session_id);
if ($export_csv) {
    $csv_content[] = array(get_lang('Chat', ''), '');
    $csv_content[] = array(sprintf(get_lang('ChatConnectionsDuringLastXDays', ''), '7'), $chat_connections_during_last_x_days_by_course);
}
echo '<tr><td>'.sprintf(get_lang('ChatConnectionsDuringLastXDays'), '7').'</td><td align="right">'.$chat_connections_during_last_x_days_by_course.'</td></tr>';

echo '</table></div>';
echo '<div class="clear"></div>';

// Tools tracking.
echo '<div class="report_section">
            '.Display::page_subheader(Display::return_icon('acces_tool.gif', get_lang('ToolsMostUsed')).get_lang('ToolsMostUsed')).'
        <table class="data_table">';

$tools_most_used = Tracking::get_tools_most_used_by_course($course_code, $session_id);    

if ($export_csv) {
    $temp = array(get_lang('ToolsMostUsed'), '');
    $csv_content[] = $temp;
}

if (!empty($tools_most_used)) {
    foreach ($tools_most_used as $row) {
        echo '	<tr>
                    <td>'.get_lang(ucfirst($row['access_tool'])).'</td>
                    <td align="right">'.$row['count_access_tool'].' '.get_lang('Clicks').'</td>
                </tr>';
        if ($export_csv) {
            $temp = array(get_lang(ucfirst($row['access_tool']), ''), $row['count_access_tool'].' '.get_lang('Clicks', ''));
            $csv_content[] = $temp;