require_once __DIR__ . "/../config/db.php"; require_once __DIR__ . "/../includes/auth.php"; require_login(); $user = $_SESSION['user']; $rol = $user['rol']; // ========================= // ALERTAS DE STOCK BAJO // ========================= $alertas = $pdo->query(" SELECT nombre, stock, stock_minimo FROM productos WHERE stock <= stock_minimo ")->fetchAll(); // ========================= // RESUMEN GENERAL // ========================= $totalProductos = $pdo->query("SELECT COUNT(*) FROM productos")->fetchColumn(); $totalClientes = $pdo->query("SELECT COUNT(*) FROM clientes")->fetchColumn(); $totalVentas = $pdo->query("SELECT COUNT(*) FROM ventas")->fetchColumn(); include __DIR__ . "/../includes/header.php"; ?>