OwlCyberSecurity - MANAGER
Edit File: dashboard.controller.js
// controllers/dashboard.controller.js import pool from '../db.js'; // your MySQL connection export const getDashboardData = async (req, res) => { try { const [totalAssets] = await pool.query('SELECT COUNT(*) as count FROM assets'); const [recentAssets] = await pool.query('SELECT asset_name, category, purchase_date, book_value FROM assets ORDER BY asset_id DESC LIMIT 5'); res.json({ totalAssets: totalAssets[0].count, recentAssets, }); } catch (err) { console.error(err); res.status(500).json({ message: 'Dashboard data fetch error' }); } };