const db = require('../config/database');

exports.getAllAnimalTypes = async (req, res) => {
  try {
    const [rows] = await db.query('SELECT * FROM animal_types');
    res.json({ success: true, data: rows });
  } catch (error) {
    res.status(500).json({ success: false, error: error.message });
  }
};

exports.getAnimalTypeById = async (req, res) => {
  try {
    const [rows] = await db.query('SELECT * FROM animal_types WHERE animal_type_id = ?', [req.params.id]);
    if (rows.length === 0) {
      return res.status(404).json({ success: false, error: 'Animal type not found' });
    }
    res.json({ success: true, data: rows[0] });
  } catch (error) {
    res.status(500).json({ success: false, error: error.message });
  }
};

exports.createAnimalType = async (req, res) => {
  try {
    const { animal_type_name } = req.body;
    
    const [result] = await db.query(
      'INSERT INTO animal_types (animal_type_name) VALUES (?)',
      [animal_type_name]
    );
    
    res.status(201).json({ 
      success: true, 
      message: 'Animal type created successfully',
      data: { animal_type_id: result.insertId }
    });
  } catch (error) {
    res.status(500).json({ success: false, error: error.message });
  }
};

exports.updateAnimalType = async (req, res) => {
  try {
    const { animal_type_name } = req.body;
    
    const [result] = await db.query(
      'UPDATE animal_types SET animal_type_name = ? WHERE animal_type_id = ?',
      [animal_type_name, req.params.id]
    );
    
    if (result.affectedRows === 0) {
      return res.status(404).json({ success: false, error: 'Animal type not found' });
    }
    
    res.json({ success: true, message: 'Animal type updated successfully' });
  } catch (error) {
    res.status(500).json({ success: false, error: error.message });
  }
};

exports.deleteAnimalType = async (req, res) => {
  try {
    const [result] = await db.query('DELETE FROM animal_types WHERE animal_type_id = ?', [req.params.id]);
    
    if (result.affectedRows === 0) {
      return res.status(404).json({ success: false, error: 'Animal type not found' });
    }
    
    res.json({ success: true, message: 'Animal type deleted successfully' });
  } catch (error) {
    res.status(500).json({ success: false, error: error.message });
  }
};