stickyMessageRemove.ts

import { Message, PermissionsBitField, TextChannel } from 'discord.js'

import { StickyMessage } from '@prisma/client'

import { prisma } from '@/prisma'
import { Logger } from '@/types/Logger'
import { getCache, removeCache } from '@/utils/cache'
import { sendDm } from '@/utils/sendDm'

import { STICKY_CACHE_PREFIX } from './stickyMessages'

export async function stickyMessageRemove(
  message: Message,
  log: Logger = console,
) {
  if (!message.content.startsWith('?stickao-remove')) {
    return
  }

  const channel = message.channel as TextChannel

  // Check if the user has the 'MANAGE_MESSAGES' permission
  const authorPermissions = channel.permissionsFor(message.author)
  if (!authorPermissions?.has(PermissionsBitField.Flags.ManageMessages)) {
    await sendDm(message, {
      content:
        'You must have the "Manage Messages" permission to use this command.',
    })
    return
  }

  try {
    // Retrieve the sticky message with the specified order from the database
    const stickyMessageEntity = getCache(
      `${STICKY_CACHE_PREFIX}-${message.channelId}`,
    ) as StickyMessage

    // If the sticky message exists, remove it from the database
    if (stickyMessageEntity) {
      await prisma.stickyMessage.delete({
        where: {
          channelId: message.channelId,
        },
      })
      removeCache(`${STICKY_CACHE_PREFIX}-${message.channelId}`)

      const stickyMessage = await channel.messages.fetch(
        stickyMessageEntity.messageId,
      )

      await stickyMessage.delete()

      log.info(`Sticky message removed: ${stickyMessageEntity.message}`)
      await sendDm(message, {
        content: 'Successfully removed the sticky message.',
      })
    } else {
      await sendDm(message, {
        content: 'Not found message in this channel',
      })
    }
  } catch (error) {
    log.error(`Error removing sticky message:`, error)
    await sendDm(message, {
      content: 'An error occurred while removing the sticky message.',
    })
  } finally {
    await message.delete()
  }
}