// plugins/hello/index.js
module.exports = {
    name: 'hello',
    dependencies: [],  // list plugins this depends on

    async init(bot) {
        // Phase 1: Basic setup — routes, db prep
        // Do NOT access other plugins here
        bot.app.get('/api/hello/stats', (req, res) => {
            res.json({ plugin: 'hello', commands: ['!hello'] });
        });
    },

    async lateInit(bot) {
        // Phase 2: All plugins loaded — cross-plugin calls safe here
        bot.services.hello = {
            greet: (username) => `Hello, ${username}!`
        };
    },

    commands: {
        hello: async (bot, msg, args) => {
            // Store greeting in memory
            await bot.memory.store(msg.username,
                `${msg.username} used the hello command`,
                'interactions'
            );
            await bot.say(msg.channel, `Hello ${msg.username}! Welcome to Stream CoHost!`);
        }
    }
};

class QuotesPlugin {
    constructor(bot) {
        this.bot = bot;
        this.name = 'Quotes';
        this.version = '1.0.0';
        this.description = 'Store and retrieve memorable quotes from chat';
    }

    async onLoad() {
        console.log(`${this.name} plugin loaded`);
        
        // Create quotes table
        await this.initDatabase();
        
        // Register commands
        this.bot.registerCommand('!addquote', this.addQuote.bind(this));
        this.bot.registerCommand('!quote', this.getQuote.bind(this));
        this.bot.registerCommand('!quotes', this.listQuotes.bind(this));
        
        // Set up web routes
        this.setupRoutes();
    }

    async initDatabase() {
        await this.bot.database.query(`
            CREATE TABLE IF NOT EXISTS quotes (
                id INTEGER PRIMARY KEY AUTOINCREMENT,
                content TEXT NOT NULL,
                author TEXT NOT NULL,
                added_by TEXT NOT NULL,
                created_at DATETIME DEFAULT CURRENT_TIMESTAMP
            )
        `);
    }

    async addQuote(context) {
        const { username, args } = context;
        
        if (args.length < 2) {
            return {
                success: false,
                response: 'Usage: !addquote [author] [quote text]'
            };
        }
        
        const author = args[0];
        const content = args.slice(1).join(' ');
        
        try {
            await this.bot.database.query(
                'INSERT INTO quotes (content, author, added_by) VALUES (?, ?, ?)',
                [content, author, username]
            );
            
            // Store memory of this action
            await this.bot.memory.store(username,
                `${username} added a quote by ${author}: "${content}"`,
                'contributions'
            );
            
            return {
                success: true,
                response: `Quote added! "${content}" - ${author}`
            };
        } catch (error) {
            console.error('Error adding quote:', error);
            return {
                success: false,
                response: 'Failed to add quote. Please try again.'
            };
        }
    }

    async getQuote(context) {
        const { args } = context;
        
        try {
            let quote;
            
            if (args.length > 0) {
                // Get quote by author
                const author = args.join(' ');
                const quotes = await this.bot.database.query(
                    'SELECT * FROM quotes WHERE author LIKE ? ORDER BY RANDOM() LIMIT 1',
                    [`%${author}%`]
                );
                quote = quotes[0];
            } else {
                // Get random quote
                const quotes = await this.bot.database.query(
                    'SELECT * FROM quotes ORDER BY RANDOM() LIMIT 1'
                );
                quote = quotes[0];
            }
            
            if (!quote) {
                return {
                    success: false,
                    response: args.length > 0 
                        ? `No quotes found for "${args.join(' ')}"` 
                        : 'No quotes available yet! Add one with !addquote'
                };
            }
            
            return {
                success: true,
                response: `"${quote.content}" - ${quote.author}`
            };
        } catch (error) {
            console.error('Error getting quote:', error);
            return {
                success: false,
                response: 'Failed to retrieve quote. Please try again.'
            };
        }
    }

    async listQuotes(context) {
        try {
            const count = await this.bot.database.query(
                'SELECT COUNT(*) as count FROM quotes'
            );
            
            const recentQuotes = await this.bot.database.query(
                'SELECT author FROM quotes GROUP BY author ORDER BY MAX(created_at) DESC LIMIT 5'
            );
            
            const authors = recentQuotes.map(q => q.author).join(', ');
            
            return {
                success: true,
                response: `We have ${count[0].count} quotes! Recent authors: ${authors}`
            };
        } catch (error) {
            console.error('Error listing quotes:', error);
            return {
                success: false,
                response: 'Failed to list quotes.'
            };
        }
    }

    setupRoutes() {
        // API endpoint for quotes
        this.bot.app.get('/api/quotes', async (req, res) => {
            try {
                const quotes = await this.bot.database.query(
                    'SELECT * FROM quotes ORDER BY created_at DESC LIMIT 50'
                );
                res.json({ quotes });
            } catch (error) {
                res.status(500).json({ error: 'Failed to fetch quotes' });
            }
        });
        
        // Admin interface
        this.bot.app.get('/quotes', (req, res) => {
            res.send(`
                
Quotes Plugin
                
Manage your chat quotes
                
            `);
        });
    }

    async onUnload() {
        this.bot.unregisterCommand('!addquote');
        this.bot.unregisterCommand('!quote');
        this.bot.unregisterCommand('!quotes');
        console.log(`${this.name} plugin unloaded`);
    }
}

module.exports = QuotesPlugin;