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";
?>

<div class="container-fluid">

  <!-- ENCABEZADO -->
  <div class="d-flex justify-content-between align-items-center mb-4">
    <h4>Dashboard</h4>
    <span class="badge bg-secondary text-uppercase">
      <br />
<b>Warning</b>:  Undefined variable $rol in <b>/home/u780398591/domains/tecnologiaasualcance.com/public_html/demo-ferreteria/ferreteria_ventas/public/dashboard.php</b> on line <b>38</b><br />
<br />
<b>Deprecated</b>:  htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in <b>/home/u780398591/domains/tecnologiaasualcance.com/public_html/demo-ferreteria/ferreteria_ventas/public/dashboard.php</b> on line <b>38</b><br />
    </span>
  </div>

  <!-- ALERTAS -->
  <br />
<b>Warning</b>:  Undefined variable $alertas in <b>/home/u780398591/domains/tecnologiaasualcance.com/public_html/demo-ferreteria/ferreteria_ventas/public/dashboard.php</b> on line <b>43</b><br />

  <!-- RESUMEN -->
  <div class="row g-3 mb-4">

    <div class="col-md-4">
      <div class="card shadow-sm text-center">
        <div class="card-body">
          <h6 class="text-muted">Productos</h6>
          <h3><br />
<b>Warning</b>:  Undefined variable $totalProductos in <b>/home/u780398591/domains/tecnologiaasualcance.com/public_html/demo-ferreteria/ferreteria_ventas/public/dashboard.php</b> on line <b>65</b><br />
</h3>
        </div>
      </div>
    </div>

    <div class="col-md-4">
      <div class="card shadow-sm text-center">
        <div class="card-body">
          <h6 class="text-muted">Clientes</h6>
          <h3><br />
<b>Warning</b>:  Undefined variable $totalClientes in <b>/home/u780398591/domains/tecnologiaasualcance.com/public_html/demo-ferreteria/ferreteria_ventas/public/dashboard.php</b> on line <b>74</b><br />
</h3>
        </div>
      </div>
    </div>

    <div class="col-md-4">
      <div class="card shadow-sm text-center">
        <div class="card-body">
          <h6 class="text-muted">Ventas</h6>
          <h3><br />
<b>Warning</b>:  Undefined variable $totalVentas in <b>/home/u780398591/domains/tecnologiaasualcance.com/public_html/demo-ferreteria/ferreteria_ventas/public/dashboard.php</b> on line <b>83</b><br />
</h3>
        </div>
      </div>
    </div>

  </div>

  <!-- ACCESOS -->
  <div class="row g-3">

    <div class="col-md-3">
      <a href="ventas.php" class="card shadow-sm text-decoration-none text-dark">
        <div class="card-body text-center">
          <h6>🛒 Nueva Venta</h6>
        </div>
      </a>
    </div>

    <div class="col-md-3">
      <a href="productos.php" class="card shadow-sm text-decoration-none text-dark">
        <div class="card-body text-center">
          <h6>📦 Productos</h6>
        </div>
      </a>
    </div>

    <div class="col-md-3">
      <a href="clientes.php" class="card shadow-sm text-decoration-none text-dark">
        <div class="card-body text-center">
          <h6>👥 Clientes</h6>
        </div>
      </a>
    </div>

    <br />
<b>Warning</b>:  Undefined variable $rol in <b>/home/u780398591/domains/tecnologiaasualcance.com/public_html/demo-ferreteria/ferreteria_ventas/public/dashboard.php</b> on line <b>117</b><br />

  </div>

</div>

</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>