69 lines
2.2 KiB
TypeScript
69 lines
2.2 KiB
TypeScript
import { NextApiRequest, NextApiResponse } from "next";
|
|
import db from "../../../../Modules/database";
|
|
import { announcements } from "#types/database";
|
|
import { authOptions } from "#/pages/api/auth/[...nextauth]";
|
|
import { getServerSession } from "next-auth";
|
|
|
|
export default async function handler(
|
|
req: NextApiRequest,
|
|
res: NextApiResponse,
|
|
) {
|
|
const session = await getServerSession(req, res, authOptions);
|
|
if (session) {
|
|
const league = parseInt(String(req.query.league));
|
|
const isAdmin =
|
|
(await db
|
|
.selectFrom("leagueUsers")
|
|
.selectAll()
|
|
.where("leagueID", "=", league)
|
|
.where("user", "=", session.user.id)
|
|
.where("admin", "=", 1)
|
|
.executeTakeFirst()) !== undefined;
|
|
switch (req.method) {
|
|
// Used to add an anouncement
|
|
case "POST":
|
|
// Checks if the user is qualified to do this
|
|
if (isAdmin) {
|
|
// Adds the announcement
|
|
const {
|
|
priority = "info",
|
|
title = "",
|
|
description = "",
|
|
}: announcements = req.body;
|
|
await db
|
|
.insertInto("announcements")
|
|
.values({
|
|
leagueID: league,
|
|
priority: priority,
|
|
title: title,
|
|
description: description,
|
|
})
|
|
.execute();
|
|
res.status(200).end("Added announcement");
|
|
} else {
|
|
res.status(401).end("You are not admin of this league");
|
|
}
|
|
break;
|
|
case "DELETE": // Used to delete an announcement
|
|
// Checks if the user is qualified to do this
|
|
if (isAdmin) {
|
|
const { title = "", description = "" }: announcements = req.body;
|
|
await db
|
|
.deleteFrom("announcements")
|
|
.where("leagueID", "=", league)
|
|
.where("title", "=", title)
|
|
.where("description", "=", description)
|
|
.execute();
|
|
res.status(200).end("Deleted announcement");
|
|
} else {
|
|
res.status(401).end("You are not admin of this league");
|
|
}
|
|
break;
|
|
default:
|
|
res.status(405).end(`Method ${req.method} Not Allowed`);
|
|
break;
|
|
}
|
|
} else {
|
|
res.status(401).end("Not logged in");
|
|
}
|
|
}
|