Zitate

From ce6a00fa25bd12774fa86ee384e840565ecf965b Mon Sep 17 00:00:00 2001 From: Marvin Borner Date: Thu, 1 Oct 2020 16:45:33 +0200 Subject: Added quotes frontend --- app.js | 2 ++ auth/public/index.html | 2 +- auth/public/style.css | 3 ++- quotes/public/index.html | 30 ++++++++++++++++++++++++++++++ quotes/public/script.js | 28 ++++++++++++++++++++++++++++ quotes/public/style.css | 33 +++++++++++++++++++++++++++++++++ tables.sql | 12 ++++++++++++ 7 files changed, 108 insertions(+), 2 deletions(-) create mode 100644 quotes/public/index.html create mode 100644 quotes/public/script.js create mode 100644 quotes/public/style.css diff --git a/app.js b/app.js index a527074..b4f4282 100644 --- a/app.js +++ b/app.js @@ -3,6 +3,7 @@ const express = require("express"); const motto = require("./motto"); const auth = require("./auth"); +const quotes = require("./quotes"); const app = express(); @@ -12,5 +13,6 @@ app.use(express.json()); app.get("/", (req, res) => res.redirect("/motto")); app.use("/motto", motto); app.use("/auth", auth); +app.use("/quotes", quotes); app.listen(5005, () => console.log("Server started on http://localhost:5005")); diff --git a/auth/public/index.html b/auth/public/index.html index b016ac6..8bf9ecd 100644 --- a/auth/public/index.html +++ b/auth/public/index.html @@ -18,7 +18,7 @@

Login Username - + Passwort diff --git a/auth/public/style.css b/auth/public/style.css index f7e5f23..7cb346f 100644 --- a/auth/public/style.css +++ b/auth/public/style.css @@ -20,7 +20,8 @@ form { background: white; } -input:not([type="checkbox"]) { +input:not([type="checkbox"]), +button { width: 100%; } diff --git a/quotes/public/index.html b/quotes/public/index.html new file mode 100644 index 0000000..abe85cc --- /dev/null +++ b/quotes/public/index.html @@ -0,0 +1,30 @@ + + + + + + + + + Zitate + + + + + + + diff --git a/quotes/public/script.js b/quotes/public/script.js new file mode 100644 index 0000000..3fbc676 --- /dev/null +++ b/quotes/public/script.js @@ -0,0 +1,28 @@ +const dropdown = document.getElementById("author"); + +dropdown.insertAdjacentHTML("beforeend", ''); + +function append(response) { + response.forEach((elem) => { + dropdown.insertAdjacentHTML( + "beforeend", + `` + ); + }); +} + +// TODO: Add api list endpoint +// fetch("/auth/api/list") +// .then((response) => response.json()) +// .then((response) => append(response)); + +const exampleJson = [ + { id: 1, name: "Lars", middlename: null, surname: "Baum" }, + { id: 2, name: "Marvin", middlename: null, surname: "Giraffe" }, + { id: 3, name: "Dominik", middlename: null, surname: "Apfel" }, + { id: 4, name: "Daniel", middlename: null, surname: "Torte" }, +]; + +append(exampleJson); diff --git a/quotes/public/style.css b/quotes/public/style.css new file mode 100644 index 0000000..6ab5ef0 --- /dev/null +++ b/quotes/public/style.css @@ -0,0 +1,33 @@ +html, +body { + padding: 0; + margin: 0; + height: 100%; + width: 100%; + background: url(https://images.unsplash.com/photo-1544829728-e5cb9eedc20e?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=1500&q=80); + background-size: cover; +} + +form { + position: absolute; + width: 30%; + 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%; +} + +@media only screen and (max-width: 600px) { + form { + width: calc(100% - 50px); + } +} diff --git a/tables.sql b/tables.sql index a8201ab..e629f7a 100644 --- a/tables.sql +++ b/tables.sql @@ -9,6 +9,7 @@ CREATE TABLE IF NOT EXISTS theme( ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- TODO: Remove dropping +DROP TABLE IF EXISTS quotes; DROP TABLE IF EXISTS users; DROP TABLE IF EXISTS types; DROP TABLE IF EXISTS class; @@ -38,6 +39,17 @@ CREATE TABLE IF NOT EXISTS users( CONSTRAINT `fk_type_user` FOREIGN KEY (type_id) REFERENCES types (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +CREATE TABLE IF NOT EXISTS quotes( + id INTEGER PRIMARY KEY AUTO_INCREMENT, + user_id INTEGER NOT NULL, -- Person who heard it + author_id INTEGER NOT NULL, -- Person who said it + quote VARCHAR(255) NOT NULL, + + UNIQUE KEY uk_quote (author_id, quote), + CONSTRAINT `fk_user_quote1` FOREIGN KEY (user_id) REFERENCES users (id), + CONSTRAINT `fk_user_quote2` FOREIGN KEY (author_id) REFERENCES users (id) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + INSERT INTO types VALUES (1, "teacher"), (2, "pupil"); INSERT INTO class VALUES (1, "TGM13.1"), -- cgit v1.2.3