From d99c8fd5281d32b6f1ef5174e403f0b0ee9ad522 Mon Sep 17 00:00:00 2001
From: LarsVomMars
Date: Sat, 10 Oct 2020 13:17:45 +0200
Subject: It's working
Kinda
---
profile/index.js | 41 ++++++++++++++++++++++++++++++----
profile/public/index.html | 56 ++++++++++++++++++++++++-----------------------
profile/public/script.js | 43 ++++++++++++++++++++++++++++++++++--
3 files changed, 107 insertions(+), 33 deletions(-)
diff --git a/profile/index.js b/profile/index.js
index 2f1cb50..f5e8373 100644
--- a/profile/index.js
+++ b/profile/index.js
@@ -2,10 +2,15 @@ const express = require("express");
const db = require("../db");
const app = express.Router();
-app.use("/", express.static(__dirname + "/public"));
+app.use("/", express.static(__dirname + "/public/"));
+
+app.get("/user/:uid", async (req, res) => {});
// Basic API
-app.get("/api/user", async (req, res) => {});
+app.get("/api/user", async (req, res) => {
+ const user = (await db.query("SELECT name, surname FROM users WHERE id = ?", [req.session.uid]))[0];
+ res.json(user);
+});
app.get("/api/questions", async (req, res) => {
const questions = await db.query("SELECT id, question FROM profile_questions");
@@ -21,10 +26,38 @@ app.get("/api/questions", async (req, res) => {
});
app.post("/api/add", async (req, res) => {
- await db.query("INSERT INTO profile_answers (question_id, user_id, answer) VALUES (?, ?, ?)");
+ try {
+ for (let qid in req.body) {
+ if (!req.body.hasOwnProperty(qid)) continue;
+ await db.query("INSERT INTO profile_answers (question_id, user_id, answer) VALUES (?, ?, ?)", [
+ qid,
+ req.session.uid,
+ req.body[qid].replace(//g, ">"),
+ ]);
+ }
+ res.send("ok");
+ } catch (e) {
+ console.error(e);
+ res.send("error");
+ }
});
-app.put("/api/update", async (req, res) => {});
+app.put("/api/update", async (req, res) => {
+ try {
+ for (let qid in req.body) {
+ if (!req.body.hasOwnProperty(qid)) continue;
+ await db.query("UPDATE profile_answers SET answer = ? WHERE question_id = ? AND user_id = ?", [
+ req.body[qid].replace(//g, ">"),
+ qid,
+ req.session.uid,
+ ]);
+ }
+ res.send("ok");
+ } catch (e) {
+ console.error(e);
+ res.send("error");
+ }
+});
// Comments API
app.get("/api/comments/:uid", async (req, res) => {});
diff --git a/profile/public/index.html b/profile/public/index.html
index 5fcee74..fd7b507 100644
--- a/profile/public/index.html
+++ b/profile/public/index.html
@@ -1,32 +1,34 @@
+
+
+
+
+
+ Steckbrief
+
-
-
-
-
-
- Steckbrief
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
diff --git a/profile/public/script.js b/profile/public/script.js
index 7c72b69..b0434fa 100644
--- a/profile/public/script.js
+++ b/profile/public/script.js
@@ -1,13 +1,52 @@
const fs = document.querySelector("fieldset");
+const form = document.querySelector("form");
+let init = true;
+
+function updateHeading(user) {
+ document.getElementById("username").textContent = `${user.name} ${user.surname}`;
+}
function appendQuestions(question) {
+ const div = document.createElement("div");
+
+ const label = document.createElement("label");
+ label.for = "id_" + question.id;
+ label.textContent = question.question;
+
const field = document.createElement("input");
+ field.id = "id_" + question.id;
field.name = question.id;
- field.value = question.answer ?? "";
+ if (question.answer !== undefined) init = false;
+ field.value = question.answer;
field.placeholder = question.question;
- fs.insertBefore(field, fs.querySelector("button"));
+
+ div.append(label, field);
+ fs.insertBefore(div, fs.querySelector("button"));
}
+form.addEventListener("submit", async (evt) => {
+ evt.preventDefault();
+ const url = init ? "api/add" : "api/update";
+ const method = init ? "POST" : "PUT";
+
+ const inputs = form.querySelectorAll("input");
+ const body = {};
+ for (const input of inputs) body[input.name] = input.value;
+
+ const resp = await fetch(url, {
+ headers: { "Content-Type": "application/json" },
+ method,
+ body: JSON.stringify(body),
+ });
+ const res = await resp.text();
+ if (res !== "ok") alert("AHHHH");
+});
+
+fetch("api/user")
+ .then((response) => response.json())
+ .then(updateHeading)
+ .catch(console.error);
+
fetch("api/questions")
.then((response) => response.json())
.then((response) => response.forEach(appendQuestions))
--
cgit v1.2.3