src/commands/ticketStats.js

const { createEmbed } = require('../utils/embeds');
const { Colors } = require('../config');
const { stmts } = require('../database');

module.exports = {
    name: 'ticket stats',
    async execute(client, message) {
        const stats = await stmts.ticketStats();

        const embed = createEmbed({
            title: '🎫 Ticket Statistics',
            description: '> Overview of all support tickets',
            color: Colors.PRIMARY,
            fields: [
                { name: '📊 Total', value: `\`${stats.total || 0}\``, inline: true },
                { name: '🟢 Open', value: `\`${stats.open_count || 0}\``, inline: true },
                { name: '🔴 Closed', value: `\`${stats.closed_count || 0}\``, inline: true },
                { name: '🗑️ Deleted', value: `\`${stats.deleted_count || 0}\``, inline: true },
            ],
        });

        await message.reply({ embeds: [embed] });
    },
};