commands/moderation/NotesCommand.ts

import { BanOptions, CommandInteraction, GuildMember, Interaction, Message, User } from 'discord.js';
import BaseCommand from '../../utils/structures/BaseCommand';
import DiscordClient from '../../client/Client';
import CommandOptions from '../../types/CommandOptions';
import InteractionOptions from '../../types/InteractionOptions';
import MessageEmbed from '../../client/MessageEmbed';
import getUser from '../../utils/getUser';
import getMember from '../../utils/getMember';
import History from '../../automod/History';

export default class NotesCommand extends BaseCommand {
    supportsInteractions: boolean = true;

    constructor() {
        super('notes', 'moderation', []);
    }

    async run(client: DiscordClient, msg: Message | CommandInteraction, options: CommandOptions | InteractionOptions) {
        if (!options.isInteraction && typeof options.args[0] === 'undefined') {
            await msg.reply({
                embeds: [
                    new MessageEmbed()
                    .setColor('#f14a60')
                    .setDescription(`This command requires at least one argument.`)
                ]
            });

            return;
        }

        let user: GuildMember;

        if (options.isInteraction) {
            user = await <GuildMember> options.options.getMember('member');

            if (!user) {
                await msg.reply({
                    embeds: [
                        new MessageEmbed()
                        .setColor('#f14a60')
                        .setDescription("Invalid user given.")
                    ]
                });
    
                return;
            }
        }
        else {
            try {
                const user2 = await getMember((msg as Message), options);

                if (!user2) {
                    throw new Error('Invalid user');
                }

                user = user2;
            }
            catch (e) {
                await msg.reply({
                    embeds: [
                        new MessageEmbed()
                        .setColor('#f14a60')
                        .setDescription(`Invalid user given.`)
                    ]
                });
    
                return;
            }

            console.log(user);
        }

        await client.db.all("SELECT * FROM notes WHERE user_id = ? AND guild_id = ?", [user.id, msg.guild!.id], async (err: any, data: any) => {
            if (err) {
                console.log(err);
            }

            if (data === undefined || data.length < 1) {
                await msg.reply({
                    embeds: [
                        new MessageEmbed()
                        .setColor('#f14a60')
                        .setDescription('No notes found for user ' + user.user.tag)
                    ]
                });

                return;
            }

            let desc = '';

            for (let row of data) {
                desc += `\n\n**Note #${row.id}**\n${row.content}\nDate: ${new Date(row.date).toUTCString()}`;
            }

            desc = desc.substring(1);

            await msg.reply({
                embeds: [
                    new MessageEmbed()
                    .setAuthor({
                        iconURL: user.displayAvatarURL(),
                        name: user.user.tag
                    })
                    .setDescription(desc)
                ]
            });
        });
    }
}
1	rakin	51	import { BanOptions, CommandInteraction, GuildMember, Interaction, Message, User } from 'discord.js';
2			import BaseCommand from '../../utils/structures/BaseCommand';
3			import DiscordClient from '../../client/Client';
4			import CommandOptions from '../../types/CommandOptions';
5			import InteractionOptions from '../../types/InteractionOptions';
6			import MessageEmbed from '../../client/MessageEmbed';
7			import getUser from '../../utils/getUser';
8			import getMember from '../../utils/getMember';
9			import History from '../../automod/History';
10
11			export default class NotesCommand extends BaseCommand {
12			supportsInteractions: boolean = true;
13
14			constructor() {
15			super('notes', 'moderation', []);
16			}
17
18			async run(client: DiscordClient, msg: Message \| CommandInteraction, options: CommandOptions \| InteractionOptions) {
19			if (!options.isInteraction && typeof options.args[0] === 'undefined') {
20			await msg.reply({
21			embeds: [
22			new MessageEmbed()
23			.setColor('#f14a60')
24			.setDescription(`This command requires at least one argument.`)
25			]
26			});
27
28			return;
29			}
30
31			let user: GuildMember;
32
33			if (options.isInteraction) {
34			user = await <GuildMember> options.options.getMember('member');
35
36			if (!user) {
37			await msg.reply({
38			embeds: [
39			new MessageEmbed()
40			.setColor('#f14a60')
41			.setDescription("Invalid user given.")
42			]
43			});
44
45			return;
46			}
47			}
48			else {
49			try {
50			const user2 = await getMember((msg as Message), options);
51
52			if (!user2) {
53			throw new Error('Invalid user');
54			}
55
56			user = user2;
57			}
58			catch (e) {
59			await msg.reply({
60			embeds: [
61			new MessageEmbed()
62			.setColor('#f14a60')
63			.setDescription(`Invalid user given.`)
64			]
65			});
66
67			return;
68			}
69
70			console.log(user);
71			}
72
73			await client.db.all("SELECT * FROM notes WHERE user_id = ? AND guild_id = ?", [user.id, msg.guild!.id], async (err: any, data: any) => {
74			if (err) {
75			console.log(err);
76			}
77
78			if (data === undefined \|\| data.length < 1) {
79			await msg.reply({
80			embeds: [
81			new MessageEmbed()
82			.setColor('#f14a60')
83			.setDescription('No notes found for user ' + user.user.tag)
84			]
85			});
86
87			return;
88			}
89
90			let desc = '';
91
92			for (let row of data) {
93			desc += `\n\nNote #${row.id}\n${row.content}\nDate: ${new Date(row.date).toUTCString()}`;
94			}
95
96			desc = desc.substring(1);
97
98			await msg.reply({
99			embeds: [
100			new MessageEmbed()
101			.setAuthor({
102			iconURL: user.displayAvatarURL(),
103			name: user.user.tag
104			})
105			.setDescription(desc)
106			]
107			});
108			});
109			}
110			}