echo '<center>';
print_single_button($CFG->wwwroot . '/course/report/trainingsessions/index.php', $options, get_string('generateXLS', 'report_trainingsessions'), 'get');
echo '</center>';
} else {
/// generate XLS
if ($groupid) {
$filename = 'training_group_' . $groupid . '_report_' . date('d-M-Y', time()) . '.xls';
} else {
$filename = 'training_course_' . $id . '_report_' . date('d-M-Y', time()) . '.xls';
}
$workbook = new MoodleExcelWorkbook("-");
// Sending HTTP headers
$workbook->send($filename);
$xls_formats = training_reports_xls_formats($workbook);
$startrow = 15;
foreach ($targetusers as $auser) {
$row = $startrow;
$worksheet = training_reports_init_worksheet($auser->id, $row, $xls_formats, $workbook);
$logusers = $auser->id;
$logs = use_stats_extract_logs($from, time(), $auser->id, $course->id);
$aggregate = use_stats_aggregate_logs($logs, 'module');
$overall = training_reports_print_xls($worksheet, $coursestructure, $aggregate, $done, $row, $xls_formats);
$data->items = $items;
$data->done = $done;
$data->from = $from;
$data->elapsed = $overall->elapsed;
$data->events = $overall->events;
training_reports_print_header_xls($worksheet, $auser->id, $course->id, $data, $xls_formats);
}
$workbook->close();
}
$options['userid'] = $userid;
$options['from'] = $from;
// alternate way
$options['output'] = 'xls';
// ask for XLS
$options['asxls'] = 'xls';
// force XLS for index.php
echo '<center>';
print_single_button($CFG->wwwroot . '/course/report/trainingsessions/index.php', $options, get_string('generateXLS', 'report_trainingsessions'), 'get');
echo '</center>';
} else {
$CFG->trace = 'x_temp/xlsreport.log';
debug_open_trace();
$filename = 'training_sessions_report_' . date('d-M-Y', time()) . '.xls';
$workbook = new MoodleExcelWorkbook("-");
// Sending HTTP headers
$workbook->send($filename);
// preparing some formats
$xls_formats = training_reports_xls_formats($workbook);
$startrow = 15;
$worksheet = training_reports_init_worksheet($userid, $startrow, $xls_formats, $workbook);
$overall = training_reports_print_xls($worksheet, $coursestructure, $aggregate, $done, $startrow, $xls_formats);
$data->items = $items;
$data->done = $done;
$data->from = $from;
$data->elapsed = $overall->elapsed;
$data->events = $overall->events;
training_reports_print_header_xls($worksheet, $userid, $course->id, $data, $xls_formats);
$workbook->close();
debug_close_trace();
}
