} 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; } }
} $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}&format=csv'>{$langcsvenc2}</a>\n 2. <a href='userduration.php?course={$course_code}&format=csv&enc=1253'>{$langcsvenc1}</a>\n </div>"; $tool_content .= "\n <table class='tbl_alt' width='99%'>\n <tr>\n <th class='left'> {$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; }