45 lines
1.1 KiB
JavaScript
45 lines
1.1 KiB
JavaScript
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;
|