const { GuildMember, Events } = require('discord.js')
const db = require('../../db')
const { welcomeEmbed } = require('../../embeds/welcomeMember')

/**
* @param {Client} client
* @param {GuildMember} member
*/

module.exports = {
    name: Events.GuildMemberAdd,
    async execute(member) {

        try {
        const embed = welcomeEmbed(member)
        const result = await db.query(`SELECT channel_id, enabled FROM auto_welcome WHERE guild_id = $1`,
        [member.guild.id])

        const welcomeData = result.rows[0]

        if (welcomeData && welcomeData.enabled) {
            const welcomeChannel = member.guild.channels.cache.get(welcomeData.channel_id)

            if (welcomeChannel) {
                welcomeChannel.send({ embeds: [embed]})
            } else {
                console.error('Invalid channel id')
            }
        }
        } catch (error) {
            console.error('There was an error in sendWelcome:', error)
        }
    }
}