<?php

session_start();
require_once "admin.php";
require_once "../config/database.php";

$usuarios = $pdo->query("
SELECT
id,
nome,
usuario,
perfil,
status,
ultimo_acesso
<th>Ações</th>
FROM usuarios
ORDER BY nome
")->fetchAll(PDO::FETCH_ASSOC);

?>

<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Usuários</title>

<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet">

</head>
<body>

<div class="container mt-4">

<h2>Usuários do Sistema</h2>

<a href="novo_usuario.php" class="btn btn-success mb-3">
Novo Usuário
</a>

<table class="table table-bordered">

<tr>
<th>ID</th>
<th>Nome</th>
<th>Usuário</th>
<th>Perfil</th>
<th>Status</th>
<th>Último Acesso</th>
</tr>

<?php foreach($usuarios as $u): ?>

<tr>
<td><?= $u['id'] ?></td>
<td><?= $u['nome'] ?></td>
<td><?= $u['usuario'] ?></td>
<td><?= $u['perfil'] ?></td>
<td><?= $u['status'] ?></td>
<td><?= $u['ultimo_acesso'] ?></td>
</tr>

<?php endforeach; ?>

</table>

<a href="dashboard.php" class="btn btn-secondary">
Voltar
</a>

</div>

</body>
</html>
