Ejemplo n.º 1
0
}
if ($is_editor) {
    if (isset($_GET['enc']) and $_GET['enc'] == '1253') {
        $charset = 'Windows-1253';
    } else {
        $charset = 'UTF-8';
    }
    $crlf = "\r\n";
    header("Content-Type: text/csv; charset={$charset}");
    header("Content-Disposition: attachment; filename=groupuserduration.csv");
    if (isset($_REQUEST['u_date_start']) and isset($_REQUEST['u_date_end'])) {
        $u_date_start = $_REQUEST['u_date_start'];
        $u_date_end = $_REQUEST['u_date_end'];
    } else {
        $min_date = Database::get()->querySingle("SELECT MIN(day) AS minday FROM actions_daily WHERE course_id = ?d", $course_id)->minday;
        $u_date_start = strftime('%Y-%m-%d', strtotime($min_date));
        $u_date_end = strftime('%Y-%m-%d', strtotime('now'));
    }
    if (isset($u_date_start) and isset($u_date_end)) {
        $first_line = "{$langFrom} {$u_date_start} {$langAs} {$u_date_end}";
    } else {
        $date_spec = '';
    }
    echo csv_escape($first_line), $crlf, $crlf, join(';', array_map("csv_escape", array($langSurname, $langName, $langAm, $langGroup, $langDuration))), $crlf;
    $totalDuration = 0;
    $result = user_duration_query($course_id, $u_date_start, $u_date_end, $group_id);
    foreach ($result as $row) {
        echo csv_escape($row->surname) . ";" . csv_escape($row->givenname) . ";" . csv_escape($row->am) . ";" . csv_escape($group_name) . ";" . csv_escape(format_time_duration(0 + $row->duration)) . ";" . csv_escape(round($row->duration / 3600));
        echo $crlf;
    }
}
Ejemplo n.º 2
0
    }
    $crlf = "\r\n";
    header("Content-Type: text/csv; charset={$charset}");
    header("Content-Disposition: attachment; filename=usersduration.csv");
    echo join(';', array_map("csv_escape", array($langSurnameName, $langAm, $langGroup, $langDuration))), $crlf, $crlf;
} else {
    $format = 'html';
    $toolName = $langUsage;
    $pageName = $langUserDuration;
    $navigation[] = array('url' => 'index.php?course=' . $course_code, 'name' => $langUsage);
    statistics_tools($course_code, "userduration");
    // display number of users
    $tool_content .= "\n        <div class='alert alert-info'>\n           <b>{$langDumpUserDurationToFile}: </b>1. <a href='userduration.php?course={$course_code}&amp;format=csv'>{$langcsvenc2}</a>\n                2. <a href='userduration.php?course={$course_code}&amp;format=csv&amp;enc=1253'>{$langcsvenc1}</a>\n          </div>";
    $tool_content .= "\n        <table class='tbl_alt' width='99%'>\n        <tr>\n          <th class='left'>&nbsp;&nbsp;&nbsp;{$langSurname} {$langName}</th>\n          <th>{$langAm}</th>\n          <th>{$langGroup}</th>\n          <th>{$langDuration}</th>\n        </tr>";
}
$result = user_duration_query($course_id);
if (count($result) > 0) {
    $i = 0;
    foreach ($result as $row) {
        $i++;
        $grp_name = user_groups($course_id, $row->id, $format);
        if ($format == 'html') {
            if ($i % 2 == 0) {
                $tool_content .= "<tr class='even'>";
            } else {
                $tool_content .= "<tr class='odd'>";
            }
            $tool_content .= "<td class='bullet'>" . display_user($row->id) . "</td>\n                                <td class='center'>{$row->am}</td>\n                                <td class='center'>{$grp_name}</td>\n                                <td class='center'>" . format_time_duration(0 + $row->duration) . "</td>\n                                </tr>";
        } else {
            echo csv_escape($row->surname . ' ' . $row->givenname), ';', csv_escape($row->am), ';', csv_escape($grp_name), ';', csv_escape(format_time_duration(0 + $row->duration)), $crlf;
        }