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
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
|
/*
* Staff page
*
* Copyright (C) 2024 Runxi Yu <https://runxiyu.org>
* SPDX-License-Identifier: AGPL-3.0-or-later
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* This program 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 Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <https://www.gnu.org/licenses/>.
*/
package main
import (
"encoding/csv"
"net/http"
"strconv"
)
func handleExportStudents(w http.ResponseWriter, req *http.Request) (string, int, error) {
_, _, department, err := getUserInfoFromRequest(req)
if err != nil {
return "", -1, err
}
if department != staffDepartment {
return "", -1, errStaffOnly
}
rows, err := db.Query(req.Context(), "SELECT name, email, department, confirmed FROM users")
if err != nil {
return "", -1, wrapError(errUnexpectedDBError, err)
}
output := make([][]string, 0)
for {
if !rows.Next() {
err := rows.Err()
if err != nil {
return "", -1, wrapError(errUnexpectedDBError, err)
}
break
}
var currentUserName, currentEmail, currentDepartment string
var currentConfirmed bool
err := rows.Scan(
¤tUserName,
¤tEmail,
¤tDepartment,
¤tConfirmed,
)
if err != nil {
return "", -1, wrapError(errUnexpectedDBError, err)
}
if currentDepartment == staffDepartment {
continue
}
output = append(
output,
[]string{
currentUserName,
currentEmail,
currentDepartment,
strconv.FormatBool(currentConfirmed),
},
)
}
w.Header().Set("Content-Type", "text/csv; charset=utf-8")
w.Header().Set("Content-Disposition", "attachment;filename=cca_students.csv")
csvWriter := csv.NewWriter(w)
err = csvWriter.Write([]string{
"Student Name",
"Student ID",
"Grade/Year",
"Group/Activity",
"Container",
"Section ID",
"Course ID",
})
if err != nil {
return "", -1, errHTTPWrite
}
err = csvWriter.WriteAll(output)
if err != nil {
return "", -1, errHTTPWrite
}
csvWriter.Flush()
if csvWriter.Error() != nil {
return "", -1, errHTTPWrite
}
return "", -1, nil
}
|
