One Hat Cyber Team

Your IP : 216.73.216.36
Server IP : 162.240.179.46
Server : Linux vps-14493116.nutrivittasaude.com.br 5.14.0-611.49.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Apr 21 16:39:08 EDT 2026 x86_64
Server Software : Apache
PHP Version : 8.2.31
Buat File | Buat Folder
Dir : ~/home/lifeprimeti/meta.lifeprimeti.com.br/admin/
View File Name : usuarios.php

<?php
require_once __DIR__ . '/../config/database.php';
requireSuperAdmin();

$titulo = 'Usuarios do Sistema';
require_once __DIR__ . '/../includes/header.php';

if (isset($_GET['resetar_senha'])) {
    $id = (int)$_GET['resetar_senha'];
    $hash = password_hash('admin123', PASSWORD_DEFAULT);
    $pdo->prepare("UPDATE usuarios SET senha = ? WHERE id = ?")->execute([$hash, $id]);
    $_SESSION['success_msg'] = 'Senha redefinida para admin123.';
    redirect('usuarios.php');
}

$search = trim($_GET['search'] ?? '');
$tipoFiltro = $_GET['tipo'] ?? '';

$where = '';
$params = [];
if ($search) {
    $where .= " AND (u.nome LIKE ? OR u.email LIKE ?)";
    $params[] = "%$search%";
    $params[] = "%$search%";
}
if ($tipoFiltro) {
    $where .= " AND u.tipo = ?";
    $params[] = $tipoFiltro;
}

$sql = "SELECT u.*, e.nome as empresa_nome, g.nome as grupo_nome FROM usuarios u JOIN empresas e ON u.empresa_id = e.id LEFT JOIN grupos g ON u.grupo_id = g.id WHERE 1=1 $where ORDER BY u.created_at DESC";
$usuarios = $pdo->prepare($sql);
$usuarios->execute($params);
$usuariosLista = $usuarios->fetchAll();
?>

<div class="card">
    <div class="card-header">
        <form method="GET" class="row g-2 align-items-end">
            <div class="col-md-5"><input type="text" name="search" class="form-control" placeholder="Buscar por nome ou email..." value="<?= sanitize($search) ?>"></div>
            <div class="col-md-3">
                <select name="tipo" class="form-select">
                    <option value="">Todos os tipos</option>
                    <option value="super_admin" <?= $tipoFiltro === 'super_admin' ? 'selected' : '' ?>>Super Admin</option>
                    <option value="admin" <?= $tipoFiltro === 'admin' ? 'selected' : '' ?>>Admin</option>
                    <option value="profissional" <?= $tipoFiltro === 'profissional' ? 'selected' : '' ?>>Profissional</option>
                    <option value="cliente" <?= $tipoFiltro === 'cliente' ? 'selected' : '' ?>>Cliente</option>
                </select>
            </div>
            <div class="col-md-2"><button type="submit" class="btn btn-primary w-100"><i class="bi bi-search"></i></button></div>
        </form>
    </div>
    <div class="card-body p-0">
        <table class="table table-striped mb-0">
            <thead><tr><th>ID</th><th>Nome</th><th>Email</th><th>Tipo</th><th>Empresa</th><th>Grupo</th><th>Ativo</th><th>Acoes</th><th>Cadastro</th></tr></thead>
            <tbody>
                <?php foreach ($usuariosLista as $u): ?>
                <tr>
                    <td><?= $u['id'] ?></td>
                    <td><?= sanitize($u['nome']) ?></td>
                    <td><?= sanitize($u['email']) ?></td>
                    <td><?= getUserTypeLabel($u['tipo']) ?></td>
                    <td><?= sanitize($u['empresa_nome']) ?></td>
                    <td><?= sanitize($u['grupo_nome'] ?? '-') ?></td>
                    <td><?= $u['ativo'] ? '<span class="badge bg-success">Sim</span>' : '<span class="badge bg-danger">Nao</span>' ?></td>
                    <td><a href="?resetar_senha=<?= $u['id'] ?>" class="btn btn-sm btn-warning" onclick="return confirm('Redefinir senha de <?= sanitize($u['nome']) ?> para admin123?')"><i class="bi bi-arrow-clockwise me-1"></i>Resetar Senha</a></td>
                    <td><?= formatarDataHora($u['created_at']) ?></td>
                </tr>
                <?php endforeach; ?>
            </tbody>
        </table>
    </div>
</div>

<?php require_once __DIR__ . '/../includes/footer.php'; ?>