-
Notifications
You must be signed in to change notification settings - Fork 0
/
export.php
66 lines (56 loc) · 2.19 KB
/
export.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
<?php
// This file is part of Moodle - http://moodle.org/
//
// Moodle is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// Moodle is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Moodle. If not, see <http://www.gnu.org/licenses/>.
/**
* External tool module external API
*
* @package local_lionai_reports
* @category external
* @copyright 2023 Devlion <[email protected]>
* @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
* @since Moodle 4.1
*/
require_once(__DIR__ . '/../../config.php');
require_once(__DIR__ . '/locallib.php');
require_once("$CFG->libdir/csvlib.class.php");
global $PAGE, $CFG, $DB, $OUTPUT, $USER;
$reportid = required_param('id', PARAM_INT);
require_login();
if (!is_siteadmin()) {
throw new \moodle_exception(get_string('permission_require', 'local_lionai_reports'));
return;
}
// Prepare the data.
$report = local_lionai_reports_getreport($reportid);
$report->lastassistantcontent = json_decode($report->options, true) ? local_lionai_reports_getlast_messages(
json_decode($report->options, true)['history']
)['lastassistantcontent'] : '';
$sql = $report->lastassistantcontent;
$data = $DB->get_records_sql($sql);
list($status, $message, $data) = local_lionai_reports_getresult($sql, true);
$keys = array_keys((array)$data[array_key_first($data)]);
$context = context_system::instance();
$PAGE->set_context($context);
// Prepare workbook.
$filename = clean_filename(format_string($report->name)) . '.csv';
$downloadfilename = clean_filename($filename);
// Creating a workbook.
$csvexport = new csv_export_writer('comma');
$csvexport->set_filename($downloadfilename);
$csvexport->add_data($keys);
foreach ($data as $record) {
$csvexport->add_data((array)$record);
}
$csvexport->download_file();