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	/**
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	}