import { db, ticketMessages, tickets } from "@/database";
import { loggers } from "@/utils/logging";
import { type Client, Events, type Message } from "discord.js";
import { and, eq } from "drizzle-orm";

const logger = loggers.events.child({ name: "messageDelete" });

export default {
	event: Events.MessageDelete,
	async execute(client: Client, message: Message) {
		if (!client.user || message.author?.bot) return;

		const ticket = db
			.select()
			.from(tickets)
			.where(
				and(
					eq(tickets.channelId, message.channelId),
					eq(tickets.guildId, message.guildId ?? ""),
				),
			)
			.get();

		if (!ticket) return;

		try {
			await db
				.update(ticketMessages)
				.set({ content: "(message deleted)" })
				.where(eq(ticketMessages.messageId, message.id));
		} catch (error) {
			logger.error(error, "Failed to handle ticket message deletion");
		}
	},
};