Merge pull request #3 from marvinborner/motto

Motto

1 files changed, 43 insertions, 0 deletions

diff --git a/mottovote/index.js b/mottovote/index.js
new file mode 100644
index 0000000..df1f6a4
--- /dev/null
+++ b/mottovote/index.js
@@ -0,0 +1,43 @@
+const express = require("express");
+const db = require("../db");
+const { checkUser } = require("../auth");
+const app = express.Router();
+
+
+app.use("/", checkUser, express.static(__dirname + "/public/"));
+
+app.get("/api/list", checkUser, async (req, res) => {
+    const mottos = await db.query("SELECT id, name, description FROM mottos");
+    const votes = await db.query("SELECT motto_id, votes FROM motto_votes WHERE user_id = ?", [req.session.uid]);
+
+    for (const vote of votes) {
+        const mid = mottos.findIndex((motto) => motto.id === vote.motto_id);
+        if (mid) mottos[mid].votes = vote.votes;
+    }
+    res.json(mottos);
+});
+
+app.put("/api/vote", checkUser, async (req, res) => {
+    await db.query("DELETE FROM motto_votes WHERE user_id = ?", [req.session.uid]);
+    try {
+        if (Object.keys(req.body).length > 3) return res.send("error");
+        for (const mid in req.body) {
+            await db.query(
+                "INSERT INTO motto_votes (user_id, motto_id, votes) VALUES (?, ?, ?)",
+                [req.session.uid, mid, req.body[mid]]
+            );
+        }
+        res.send("ok");
+    } catch (e) {
+        console.error(e);
+        res.send("error");
+    }
+});
+
+// Vote result - admin
+app.get("/api/get", checkUser, async (req, res) => {
+    const votes = await db.query("SELECT m.id, m.name, m.description, SUM(votes) votes FROM motto_votes mv RIGHT JOIN mottos m on mv.motto_id = m.id GROUP BY m.id, m.name, m.description ORDER BY SUM(votes) DESC");
+    res.json(votes);
+});
+
+module.exports = app;
\ No newline at end of file