diff options
Diffstat (limited to 'prediction')
| -rw-r--r-- | prediction/index.js | 47 | ||||
| -rw-r--r-- | prediction/public/index.html | 35 | ||||
| -rw-r--r-- | prediction/public/script.js | 37 | ||||
| -rw-r--r-- | prediction/public/style.css | 42 |
4 files changed, 161 insertions, 0 deletions
diff --git a/prediction/index.js b/prediction/index.js new file mode 100644 index 0000000..c5bb81e --- /dev/null +++ b/prediction/index.js @@ -0,0 +1,47 @@ +const express = require("express"); +const db = require("../db"); +const app = express.Router(); +const { checkUser } = require("../auth"); + +app.use("/", checkUser, express.static(__dirname + "/public")); + +app.get("/api/get", checkUser, async (req, res) => { + try { + const answer = (await db.query("SELECT * FROM teacher_prediction WHERE user_id = ?", [req.session.uid]))[0] || {}; + // console.log(answer); + res.json(answer); + } catch (e) { + console.error(e); + res.json({ success: false }); + } +}); + +app.post("/api/set", checkUser, async (req, res) => { + const { teacher } = req.body; + if (!teacher) return res.json({ success: false }); + try { + const isTeacher = (await db.query("SELECT id FROM users WHERE type_id = 2 AND id = ?", [teacher])).length > 0; + if (!isTeacher) return res.json({ success: false }); + await db.query("INSERT INTO teacher_prediction (user_id, teacher_id) VALUE (?,?)", [req.session.uid, teacher]); + res.json({ success: true }); + } catch (e) { + console.error(e); + res.json({ success: false }); + } +}); + +app.put("/api/set", checkUser, async (req, res) => { + const { teacher } = req.body; + if (!teacher) return res.json({ success: false }); + try { + const isTeacher = (await db.query("SELECT id FROM users WHERE type_id = 2 AND id = ?", [teacher])).length > 0; + if (!isTeacher) return res.json({ success: false }); + await db.query("UPDATE teacher_prediction SET teacher_id = ? WHERE user_id = ?", [+teacher, req.session.uid]); + res.json({ success: true }); + } catch (e) { + console.error(e); + res.json({ success: false }); + } +}); + +module.exports = app; diff --git a/prediction/public/index.html b/prediction/public/index.html new file mode 100644 index 0000000..46b920e --- /dev/null +++ b/prediction/public/index.html @@ -0,0 +1,35 @@ +<!DOCTYPE html> +<html> + <head> + <meta charset="UTF-8" /> + <meta name="viewport" content="width=device-width, initial-scale=1" /> + <link + rel="stylesheet" + href="https://unpkg.com/purecss@2.0.3/build/pure-min.css" + integrity="sha384-cg6SkqEOCV1NbJoCu11+bm0NvBRc8IYLRGXkmNrqUBfTjmMYwNKPWBTIKyw9mHNJ" + crossorigin="anonymous" + /> + <link rel="stylesheet" href="style.css" type="text/css" media="all" /> + + <title>Zitate</title> + </head> + <body> + <div class="pure-menu pure-menu-horizontal"> + <a href="/" class="pure-menu-item pure-menu-link">Home</a> + <a href="/auth/api/logout" class="pure-menu-item pure-menu-link">Logout</a> + </div> + + <main> + <div class="pure-form pure-form-stacked"> + <fieldset> + <legend>Hier sieht mich mein Lehrer in 10 Jahren:</legend> + <label for="prediction">Lehrer</label> + <select name="teacher" id="prediction"></select> + <button type="submit" class="pure-button pure-button-primary">Hinzufügen</button> + </fieldset> + </div> + </main> + + <script src="script.js" charset="utf-8"></script> + </body> +</html> diff --git a/prediction/public/script.js b/prediction/public/script.js new file mode 100644 index 0000000..a4d0527 --- /dev/null +++ b/prediction/public/script.js @@ -0,0 +1,37 @@ +const dropdown = document.getElementById("prediction"); +const submit = document.querySelector('button[type="submit"]'); +let method = "POST"; + +dropdown.insertAdjacentHTML( + "beforeend", + '<option disabled value="" selected="true" disabled>Lehrer auswählen...</option>', +); + +function appendOption(response) { + response.forEach((elem, i) => { + dropdown.insertAdjacentHTML( + "beforeend", + `<option value="${elem["id"]}">${elem["name"]} ${elem["middlename"] ? elem["middlename"] + " " : ""}${elem["surname"]}</option>`, + ); + }); +} + +function selectOption(response) { + if (Object.keys(response).length > 0) { + dropdown.value = response.teacher_id; + method = "PUT"; + } +} + +fetch("/auth/api/list?class=teacher") + .then((response) => response.json()) + .then((response) => appendOption(response)) + .then(() => fetch("api/get")) + .then((response) => response.json()) + .then(selectOption); + +submit.addEventListener("click", async (e) => { + const teacher = dropdown.value; + const body = JSON.stringify({ teacher }); + await fetch("api/set", { method, body, headers: { "Content-Type": "application/json" } }); +});
\ No newline at end of file diff --git a/prediction/public/style.css b/prediction/public/style.css new file mode 100644 index 0000000..b34819a --- /dev/null +++ b/prediction/public/style.css @@ -0,0 +1,42 @@ +html, +body { + padding: 0; + margin: 0; + height: 100%; + width: 100%; + color: #424242; + line-height: 1.6; + background-color: #eec0c6; + background-image: linear-gradient(315deg, #eec0c6 0%, #7ee8fa 74%); +} + +div { + background: white; +} + +main { + position: absolute; + max-height: calc(100% - 140px); + overflow-y: auto; + width: 50%; + left: 50%; + top: 50%; + -webkit-transform: translate(-50%, -50%); + transform: translate(-50%, -50%); + padding: 20px; + border-radius: 10px; + background: white; +} + +input, +button, +select { + width: 100%; + color: #424242; +} + +@media only screen and (max-width: 700px) { + main { + width: calc(100% - 20%); + } +} |