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
|
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 !== undefined) 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;
|
