import disnake
from disnake.ext import commands
from disnake.enums import ButtonStyle
from env import *
from database import *
from adje import member_leave_dbClean
from datetime import datetime, date
from dateutil import relativedelta
import re
# @todo fix image remove logging

class log_to_server(commands.Cog):
    def __init__(self, bot: commands.Bot):
        self.bot = bot


        @commands.Cog.listener()
        async def on_audit_log_entry_create(audit_entry):
            print("Debug 1")
            if "AuditLogAction.message_delete" in str(audit_entry):
                async for entry in audit_entry.guild.audit_logs(limit=1,action=disnake.AuditLogAction.message_delete):
                    deleter = entry.user
                print(f"{deleter.name} deleted message by {audit_entry.name}")



        # triggers
        # Member guild
        @bot.event
        async def on_member_join(member):
            print("Welcome! ", member)
            await member_guild_embed(member, type="joinde de keet!")
            await welcome_msg_member(member)

        @bot.event
        async def on_member_remove(member):
            print("Aaaah! er is een member/memberina weg!")
            await member_guild_embed(member, type="verliet de keet!")

        @bot.event
        async def on_member_ban(guild, member):
            print(f"Aaaah! User: {member} is gebanned van guild: {guild}.")
            await member_guild_embed(member, type="is verbannen van deze keet!")

        @bot.event
        async def on_member_unban(guild, member):
            print(f"Aaaah! User: {member} is gebanned van guild: {guild}.")
            await member_guild_embed(member, type="is un-banned van deze keet!")

        @bot.event
        async def on_member_update(before, after):
            if before.nick != after.nick:
                    name_before = before.nick
                    name_after = after.nick
                    await user_name_change(name_before, name_after)


        # Voice
        @bot.event
        async def on_voice_state_update(member, before, after):
            # member joins voice
            if before.channel is None and after.channel is not None:
                await log_voice_state(member, vc_channel=after.channel, type="Joinde")
            # Member leaves voice
            elif after.channel is None and before.channel is not None:
                await log_voice_state(member, vc_channel=before.channel, type="Verliet")
            # Member switches voice channels
            elif before.channel != after.channel:
                await log_voice_state(member, vc_channel=after.channel, type="Veranderde")



        # Messages in guild
        @bot.event
        async def on_message_delete(payload):
            await message_deleted(payload, message=payload.content, channel=payload.channel)


        @bot.event
        async def on_raw_bulk_message_delete(messages):
            bulk_deleted_count = len(messages.message_ids)
            bulk_deleted_channel = messages.channel_id
            await message_bulk_deleted(count=bulk_deleted_count, channel=bulk_deleted_channel)


        @bot.event
        async def on_message_edit(before, after):
            channel = after.channel.mention
            author = before.author
            if before.clean_content != after.clean_content:
                before_content = before.clean_content
                after_content = after.clean_content
                await message_edited(before_content, after_content, channel, author)






        # Changes in guild
        # Roles
        @bot.event
        async def on_guild_role_create(role):
            await new_or_deleted_role(role, type="aangemaakt")

        @bot.event
        async def on_guild_role_delete(role):
            await new_or_deleted_role(role, type="verwijderd")

        @bot.event
        async def on_guild_role_update(before, after):
            if before.name != after.name:
                await edited_role(before, after)

            elif before.color != after.color:
                await color_change_role(before, after)

        # Channels
        @bot.event
        async def on_guild_channel_create(channel):
            await channel_change(channel, type="Nieuw kanaal")

        @bot.event
        async def on_guild_channel_delete(channel):
            await channel_change(channel, type="Kanaal verwijderd")

        @bot.event
        async def on_guild_channel_update(before, after):
            if before.name != after.name:
                await channel_name_change(before=before.name, after=after.name)


        # Member join welcome msg
        async def welcome_msg_member(member):
            channel = bot.get_channel(int(env_variable.WELCOME_CHANNEL))
            Database.cursor.execute("SELECT content FROM configuration_text WHERE service='welcome_text' LIMIT 1")

            res = Database.cursor.fetchone()[0]
            member_mentiont = member.mention
            await channel.send(res.format(member_mentiont))



        # LOG EMBEDS
        # Member guild embed
        async def member_guild_embed(member, type):

            date_created_at = str(member.created_at).split(" ")[0]
            x = date_created_at.split("-")


            # get two dates
            d1 = f'{x[2]}/{x[1]}/{x[0]}'
            d2 = datetime.today().strftime('%d/%m/%Y')

            start_date = datetime.strptime(d1, "%d/%m/%Y")
            end_date = datetime.strptime(d2, "%d/%m/%Y")

            # Get the relativedelta between two dates
            delta = relativedelta.relativedelta(end_date, start_date)
            if str(delta.years) == "0":
                i = f"{delta.months} maanden en {delta.days} dagen"
            else:
                i = f"{delta.years} jaar,  {delta.months} maanden en {delta.days} dagen"


            embed=disnake.Embed(title="\n", description=f"**{member.mention} {type}**", color=disnake.Color.dark_green())
            embed.set_author(name=member, icon_url=member.avatar)
            embed.add_field(name="Account leeftijd:", value=str(i), inline=False)
            channel_to_send = bot.get_channel(env_variable.ADJE_LOG_CHANNEL_ID)
            await channel_to_send.send(embed=embed)

        # Member username change
        async def user_name_change(name_before, name_after):
            embed=disnake.Embed(title=f"Server gebruikersnaam bewerkt", description=f"\n", color=disnake.Color.purple())
            embed.add_field(name="Voor het bewerken:", value=str(name_before), inline=False)
            embed.add_field(name="Account is gemaakt op:", value=str(f"{name_after.created_at}"), inline=False)

            embed.add_field(name="Na het bewerken:", value=str(name_after), inline=False)
            channel_to_send = bot.get_channel(env_variable.ADJE_LOG_CHANNEL_ID)
            await channel_to_send.send(embed=embed)




        # Voice logging
        async def log_voice_state(member, vc_channel, type):
            embed=disnake.Embed(title=f"\n", description=f"**{member.mention} {type} voice kanaal: #{vc_channel}**", color=disnake.Color.greyple())
            embed.set_author(name=member, icon_url=member.avatar)
            channel_to_send = bot.get_channel(env_variable.ADJE_LOG_CHANNEL_ID)
            await channel_to_send.send(embed=embed)




        # Message
        async def message_deleted(payload, message, channel):

            embed=disnake.Embed(title=f"\n", description=f"{payload.author.mention} verwijderde een bericht in {channel.mention}", color=disnake.Color.purple())
            embed.set_author(name=payload.author.name, icon_url=payload.author.avatar)
            channel_to_send = bot.get_channel(env_variable.ADJE_LOG_CHANNEL_ID)
            try:
                if payload.attachments[0] != None:
                        embed.set_image(url=payload.attachments[0].proxy_url)
            except Exception as error:
                pass
            embed.add_field(name="Content:", value=str(payload.clean_content), inline=False)
            await channel_to_send.send(embed=embed)

        async def message_bulk_deleted(count, channel):
            channel_name = (await bot.fetch_channel(channel)).mention
            embed=disnake.Embed(title=f"\n", description=f"**Bulk berichten verwijderd in {channel_name} - Aantal: {count}**", color=disnake.Color.purple())
            channel_to_send = bot.get_channel(env_variable.ADJE_LOG_CHANNEL_ID)
            await channel_to_send.send(embed=embed)

        async def message_edited(before_content, after_content, channel, author):
            embed=disnake.Embed(title=f"\n", description=f"**Bericht bewerkt in {channel} - Door: {author.mention}**", color=disnake.Color.purple())
            embed.set_author(name=author, icon_url=author.avatar)
            embed.add_field(name="Voor het bewerken:", value=str(before_content), inline=False)
            embed.add_field(name="Na het bewerken:", value=str(after_content), inline=False)
            channel_to_send = bot.get_channel(env_variable.ADJE_LOG_CHANNEL_ID)
            await channel_to_send.send(embed=embed)




        # Guild changes
        # Roles
        async def new_or_deleted_role(role, type):
            embed=disnake.Embed(title=f"Rol {type}: {role}", description="\n", color=disnake.Color.purple())
            channel_to_send = bot.get_channel(env_variable.ADJE_LOG_CHANNEL_ID)
            await channel_to_send.send(embed=embed)

        async def edited_role(before, after):
            if str(before) != str(after):
                embed=disnake.Embed(title=f"Rol bewerkt", description="\n", color=disnake.Color.purple())
                embed.add_field(name="Voor het bewerken:", value=str(before), inline=False)
                embed.add_field(name="Na het bewerken:", value=str(after), inline=False)
                channel_to_send = bot.get_channel(env_variable.ADJE_LOG_CHANNEL_ID)
                await channel_to_send.send(embed=embed)
            else:
                pass

        async def color_change_role(before, after):
                embed=disnake.Embed(title=f"Rol {before.name} kleur bewerkt", description="\n", color=disnake.Color.purple())
                embed.add_field(name="Voor het bewerken:", value=str(before.color), inline=False)
                embed.add_field(name="Na het bewerken:", value=str(after.color), inline=False)
                channel_to_send = bot.get_channel(env_variable.ADJE_LOG_CHANNEL_ID)
                await channel_to_send.send(embed=embed)




        # Channels
        async def channel_change(channel, type="Nieuw kanaal"):
                embed=disnake.Embed(title=f"\n", description="**{type} met de naam: #{channel}**", color=disnake.Color.purple())
                channel_to_send = bot.get_channel(env_variable.ADJE_LOG_CHANNEL_ID)
                await channel_to_send.send(embed=embed)

        async def channel_name_change(before, after):
                embed=disnake.Embed(title=f"Kanaal bewerkt", description="\n", color=disnake.Color.purple())
                embed.add_field(name="Voor het bewerken:", value=str(before), inline=False)
                embed.add_field(name="Na het bewerken:", value=str(after), inline=False)
                channel_to_send = bot.get_channel(env_variable.ADJE_LOG_CHANNEL_ID)
                await channel_to_send.send(embed=embed)



        # Logging commands to log channel
        def log_commands(inter, command, on_user):
                embed=disnake.Embed(title=f"Adje log", description="\n", color=disnake.Color.purple())
                embed.set_author(name=inter.author, icon_url=inter.author.avatar)
                embed.add_field(name="Command:", value=str(command), inline=False)
                embed.add_field(name="Op gebruiker:", value=str(on_user), inline=False)
                channel_to_send = bot.get_channel(env_variable.ADJE_LOG_CHANNEL_ID)
                bot.loop.create_task(channel_to_send.send(embed=embed))





def setup(bot: commands.Bot):
    bot.add_cog(log_to_server(bot))