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
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
|
const DB_TEMPLATE_LIST_HEADER = `
<table class="table table-striped">
<thead>
<tr>
<th>Json</th>
</tr>
</thead>
<tbody>
`;
const DB_TEMPLATE_LIST_ENTRY = `
<tr class="db-row">
<td class="db-cell" data-key="date">##timeadded##</td>
<td class="db-cell" data-key="coach">##user##</td>
<td class="db-cell" data-key="json">[[Json]]</td>
</tr>
`;
const DB_TEMPLATE_LIST_FOOTER = `
</tbody>
</table>
`;
let studentDbs = null;
async function populateStudentDbs() {
const courseUrl = `https://lernplattform.bycs.de/course/view.php?id=${getCourseId()}`;
const courseRes = await fetch(courseUrl);
const courseDoc = new DOMParser().parseFromString(await courseRes.text(), 'text/html');
studentDbs = new Map();
for (const link of courseDoc.querySelectorAll("div.activityname > a.aalink")) {
const match = link.textContent.match(/(\d+)(Shadow|Public|Submit)/);
const studentId = match[1];
const dbType = match[2];
const dbId = link.href.match(/[?&]id=(\d+)/)[1]
if (!studentDbs.has(studentId)) {
studentDbs.set(studentId, {});
}
studentDbs.get(studentId)[dbType.lower()] = new DB(dbId);
}
}
class DB {
constructor(id) {
this.id = id;
}
async fetchEntries(params) {
return loadFromDatabaseActivity(this.id, params)
}
async saveEntry(json) {
return addEntryToDatabaseActivity(this.id, json);
}
static async getStudentDbs(student) {
if (!studentDbs)
await populateStudentDbs();
return studentDbs[student.id];
}
}
async function loadFromDatabaseActivity(id, params) {
let dbUrl = `${window.location.origin}/mod/data/view.php?id=${id}&mode=list&perpage=1000`;
// TODO(muhq): Why does this not include entries?
if (params) {
dbUrl += "&filter=1&advanced=1";
for (const param in params) {
dbUrl += `&${param}=${encodeURIComponent(params[param])}`
}
}
const dbRes = await fetch(encodeURI(dbUrl));
const dbDoc = new DOMParser().parseFromString(await dbRes.text(), 'text/html');
let data = [];
dbDoc.querySelectorAll('.db-row').forEach(row => {
let entry = {};
row.querySelectorAll('.db-cell').forEach(field => {
const key = field.dataset.key;
const value = field.innerText.trim();
entry[key] = value;
});
data.push(entry);
});
return data;
}
async function loadFromStudentDatabase(student, type) {
const db = await DB.getStudentDbs(student)[type];
return await db.fetchEntries()
}
async function addEntryToDatabaseActivity(id, json) {
const url = `/mod/data/edit.php?id=${id}`;
const editRes = await fetch(url);
const editDoc = new DOMParser().parseFromString(await editRes.text(), 'text/html');
const form = editDoc.querySelector('div[role="main"] > form');
const formData = new FormData(form);
for (const key in formData.keys()) {
if (k.startsWith("field_")) {
formData.set(key, json);
// We found our json key
break;
}
}
formData.set("saveandview", "Speichern");
return await fetch("/mod/data/edit.php", {
method: "POST",
// Set the FormData instance as the request body
body: formData,
});
}
async function addEntryToStudentDatabase(student, type, json) {
const db = await DB.getStudentDbs(student)[type];
await db.saveEntry(json);
}
export {
DB,
loadFromDatabaseActivity, loadFromStudentDatabase,
addEntryToDatabaseActivity, addEntryToStudentDatabase,
};
|
