api/controllers/HistoryController.ts

import Punishment from "../../models/Punishment";
import Controller from "../Controller";
import RequireAuth from "../middleware/RequireAuth";
import ValidatorError from "../middleware/ValidatorError";
import Request from "../Request";

export default class HistoryController extends Controller {
    globalMiddleware(): Function[] {
        return [RequireAuth, ValidatorError];
    }

    async index(request: Request) {
        if (!request.user?.guilds.includes(request.params.id)) {
            return this.response({ error: "You don't have permission to access history of this guild." }, 403);
        }

        const queryLimit = parseInt((request.query.limit as string) ?? '0');
        const limit = request.query.limit ? (queryLimit < 1 || queryLimit > 20 ? 20 : queryLimit) : 20;
        const maxPages = Math.ceil((await Punishment.count({ guild_id: request.params.id })) / limit);
        const page = request.query.page ? parseInt(request.query.page as string) : 1;

        if (maxPages < page) {
            return this.response({ error: "That page does not exist" }, 404);
        } 

        const offset = (page - 1) * limit;

        const data = (await Punishment.find({ guild_id: request.params.id }).skip(offset).limit(limit));
        const newData = [];

        for await (const row of data) {
            let user = { id: row.user_id };

            try {
                user = this.client.users.cache.get(row.user_id) || await this.client.users.fetch(row.user_id);
            }
            catch (e) {
                console.log(e);
            } 

            const newRow = {
                ...(row.toJSON()),
                user
            };

            newData.push(newRow);
        }

        return newData;
    }
}
1	import Punishment from "../../models/Punishment";
2	import Controller from "../Controller";
3	import RequireAuth from "../middleware/RequireAuth";
4	import ValidatorError from "../middleware/ValidatorError";
5	import Request from "../Request";
6
7	export default class HistoryController extends Controller {
8	globalMiddleware(): Function[] {
9	return [RequireAuth, ValidatorError];
10	}
11
12	async index(request: Request) {
13	if (!request.user?.guilds.includes(request.params.id)) {
14	return this.response({ error: "You don't have permission to access history of this guild." }, 403);
15	}
16
17	const queryLimit = parseInt((request.query.limit as string) ?? '0');
18	const limit = request.query.limit ? (queryLimit < 1 \|\| queryLimit > 20 ? 20 : queryLimit) : 20;
19	const maxPages = Math.ceil((await Punishment.count({ guild_id: request.params.id })) / limit);
20	const page = request.query.page ? parseInt(request.query.page as string) : 1;
21
22	if (maxPages < page) {
23	return this.response({ error: "That page does not exist" }, 404);
24	}
25
26	const offset = (page - 1) * limit;
27
28	const data = (await Punishment.find({ guild_id: request.params.id }).skip(offset).limit(limit));
29	const newData = [];
30
31	for await (const row of data) {
32	let user = { id: row.user_id };
33
34	try {
35	user = this.client.users.cache.get(row.user_id) \|\| await this.client.users.fetch(row.user_id);
36	}
37	catch (e) {
38	console.log(e);
39	}
40
41	const newRow = {
42	...(row.toJSON()),
43	user
44	};
45
46	newData.push(newRow);
47	}
48
49	return newData;
50	}
51	}