api/controllers/HistoryController.ts

/**
* This file is part of SudoBot.
* 
* Copyright (C) 2021-2022 OSN Inc.
*
* SudoBot is free software; you can redistribute it and/or modify it
* under the terms of the GNU Affero General Public License as published by 
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
* 
* SudoBot is distributed in the hope that it will be useful, but
* WITHOUT ANY WARRANTY; without even the implied warranty of 
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License 
* along with SudoBot. If not, see <https://www.gnu.org/licenses/>.
*/

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	rakinar2	577	/**
2			* This file is part of SudoBot.
3			*
4			* Copyright (C) 2021-2022 OSN Inc.
5			*
6			* SudoBot is free software; you can redistribute it and/or modify it
7			* under the terms of the GNU Affero General Public License as published by
8			* the Free Software Foundation, either version 3 of the License, or
9			* (at your option) any later version.
10			*
11			* SudoBot is distributed in the hope that it will be useful, but
12			* WITHOUT ANY WARRANTY; without even the implied warranty of
13			* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14			* GNU Affero General Public License for more details.
15			*
16			* You should have received a copy of the GNU Affero General Public License
17			* along with SudoBot. If not, see <https://www.gnu.org/licenses/>.
18			*/
19
20			import Punishment from "../../models/Punishment";
21			import Controller from "../Controller";
22			import RequireAuth from "../middleware/RequireAuth";
23			import ValidatorError from "../middleware/ValidatorError";
24			import Request from "../Request";
25
26			export default class HistoryController extends Controller {
27			globalMiddleware(): Function[] {
28			return [RequireAuth, ValidatorError];
29			}
30
31			async index(request: Request) {
32			if (!request.user?.guilds.includes(request.params.id)) {
33			return this.response({ error: "You don't have permission to access history of this guild." }, 403);
34			}
35
36			const queryLimit = parseInt((request.query.limit as string) ?? '0');
37			const limit = request.query.limit ? (queryLimit < 1 \|\| queryLimit > 20 ? 20 : queryLimit) : 20;
38			const maxPages = Math.ceil((await Punishment.count({ guild_id: request.params.id })) / limit);
39			const page = request.query.page ? parseInt(request.query.page as string) : 1;
40
41			if (maxPages < page) {
42			return this.response({ error: "That page does not exist" }, 404);
43			}
44
45			const offset = (page - 1) * limit;
46
47			const data = (await Punishment.find({ guild_id: request.params.id }).skip(offset).limit(limit));
48			const newData = [];
49
50			for await (const row of data) {
51			let user = { id: row.user_id };
52
53			try {
54			user = this.client.users.cache.get(row.user_id) \|\| await this.client.users.fetch(row.user_id);
55			}
56			catch (e) {
57			console.log(e);
58			}
59
60			const newRow = {
61			...(row.toJSON()),
62			user
63			};
64
65			newData.push(newRow);
66			}
67
68			return newData;
69			}
70			}