const express = require('express');
const { protect } = require('../middleware/auth');
const database = require('../config/database');
const logger = require('../utils/logger');

const router = express.Router();

// Get AI suggestions
router.get('/', protect, async (req, res) => {
  try {
    const { page = 1, limit = 50, status, device_id } = req.query;
    const offset = (page - 1) * limit;
    
    let query = 'SELECT * FROM ai_suggestions WHERE 1=1';
    const params = [];
    
    if (status) {
      query += ' AND status = ?';
      params.push(status);
    }
    
    if (device_id) {
      query += ' AND device_id = ?';
      params.push(device_id);
    }
    
    query += ' ORDER BY created_at DESC LIMIT ? OFFSET ?';
    params.push(parseInt(limit), offset);
    
    const suggestions = await database.query(query, params);
    
    res.json({
      success: true,
      data: suggestions
    });
  } catch (error) {
    logger.error('Get suggestions error:', error);
    res.status(500).json({
      success: false,
      message: 'Failed to get suggestions'
    });
  }
});

module.exports = router;