fitme3070.pt/views/admin/rgpd/index.php

<?php
require __DIR__ . '/../../../config/db.php';
require __DIR__ . '/../../../config/functions.php';
$user = require_admin();

// Apagar dados (POST + CSRF) — anonimiza e marca o pedido como concluído.
if (($_SERVER['REQUEST_METHOD'] ?? 'GET') === 'POST') {
    csrf_check();
    $id = (int) ($_POST['id'] ?? 0);
    if (isset($_POST['erase']) && $id) {
        $req = db_rgpd_request_get($pdo, $id);
        if ($req) {
            $n = rgpd_erase($pdo, $req['email']);
            db_rgpd_request_mark($pdo, $id, 'concluido', (int) $user['id']);
            audit('rgpd.erase', [
                'target_type' => 'rgpd_request', 'target_id' => $id,
                'summary' => 'Apagamento RGPD de ' . audit_mask_email($req['email']) . ' — ' . $n . ' registos anonimizados',
            ]);
            session()->setFlashdata('success', 'Dados de ' . htmlspecialchars($req['email']) . ' anonimizados (' . $n . ' registos).');
        }
    }
    header('Location: ' . base_url('views/admin/rgpd/index.php'));
    exit;
}

// Exportar dados (acesso, art.º 15.º) — CSV com tudo o que existe para o email.
if (isset($_GET['csv']) && is_numeric($_GET['csv'])) {
    $req = db_rgpd_request_get($pdo, (int) $_GET['csv']);
    if ($req) {
        audit('rgpd.export', [
            'target_type' => 'rgpd_request', 'target_id' => (int) $_GET['csv'],
            'summary' => 'Exportação RGPD (acesso) de ' . audit_mask_email($req['email']),
        ]);
        $rows = [];
        foreach (rgpd_find($pdo, $req['email']) as $table => $items) {
            foreach ($items as $it) {
                $rows[] = [rgpd_pii_tables()[$table] ?? $table, $it['name'], $it['email'], $it['phone'], $it['message'] ?? '', $it['created_at']];
            }
        }
        csv_export('rgpd', 'dados-' . substr(md5($req['email']), 0, 8), 'Exportação RGPD (acesso) de ' . audit_mask_email($req['email']), ['Fonte', 'Nome', 'E-mail', 'Telefone', 'Mensagem', 'Data'], $rows);
    }
}

$requests = db_rgpd_requests_list($pdo);
$page_title = 'Pedidos RGPD';
include __DIR__ . '/../../../includes/header.php';
?>
<?= link_tag('assets/vendor/datatables-2.3.4/dataTables.bootstrap5.min.css') ?>
<?= link_tag('assets/vendor/datatables-2.3.4/responsive.bootstrap5.min.css') ?>
<div class="container">
    <div class="d-flex justify-content-between align-items-center mb-3">
        <h1 class="h3 mb-0">Pedidos RGPD</h1>
    </div>
    <p class="text-muted small">Pedidos de acesso (exportação) e apagamento feitos na Política de Privacidade. O apagamento anonimiza o nome/e-mail/telefone nas leads — a linha fica para estatística e audit.</p>

    <div class="card shadow-sm"><div class="card-body p-0">
        <div class="table-responsive">
        <table class="table table-hover align-middle mb-0" id="rgpdTable">
            <thead class="table-light"><tr>
                <th>Data</th><th>E-mail</th><th>Pedido</th><th>Mensagem</th><th>Estado</th><th style="width:230px">Ações</th>
            </tr></thead>
            <tbody>
            <?php if (!$requests): ?>
                <tr><td colspan="6" class="text-center text-muted py-4">Sem pedidos RGPD.</td></tr>
            <?php else: foreach ($requests as $r): ?>
                <tr>
                    <td class="text-nowrap small"><?= htmlspecialchars(format_date_pt((string) $r['created_at'])) ?></td>
                    <td><?= htmlspecialchars($r['email']) ?></td>
                    <td><span class="badge <?= $r['request_type'] === 'apagamento' ? 'bg-danger' : 'bg-info text-dark' ?>"><?= $r['request_type'] === 'apagamento' ? 'Apagamento' : 'Acesso' ?></span></td>
                    <td class="small text-muted"><?= htmlspecialchars((string) $r['message']) ?></td>
                    <td><span class="badge <?= $r['status'] === 'novo' ? 'bg-warning text-dark' : 'bg-success' ?>"><?= $r['status'] === 'novo' ? 'Novo' : 'Concluído' ?></span></td>
                    <td class="text-nowrap">
                        <a class="btn btn-sm btn-outline-primary" href="?csv=<?= (int) $r['id'] ?>"><i class="bi bi-download me-1"></i>Exportar</a>
                        <?php if ($r['status'] === 'novo'): ?>
                            <form method="POST" class="d-inline" onsubmit="return confirm('Anonimizar todos os dados pessoais de <?= htmlspecialchars($r['email'], ENT_QUOTES) ?>? (irreversível)')">
                                <?= csrf_field() ?>
                                <input type="hidden" name="id" value="<?= (int) $r['id'] ?>">
                                <button class="btn btn-sm btn-outline-danger" name="erase" value="1"><i class="bi bi-eraser me-1"></i>Apagar</button>
                            </form>
                        <?php endif; ?>
                    </td>
                </tr>
            <?php endforeach; endif; ?>
            </tbody>
        </table>
        </div>
    </div></div>
</div>
<script>
window.DT_SRC = [
    <?= json_encode(_asset_versioned('assets/vendor/datatables-2.3.4/dataTables.min.js')) ?>,
    <?= json_encode(_asset_versioned('assets/vendor/datatables-2.3.4/dataTables.bootstrap5.min.js')) ?>,
    <?= json_encode(_asset_versioned('assets/vendor/datatables-2.3.4/dataTables.responsive.min.js')) ?>,
    <?= json_encode(_asset_versioned('assets/vendor/datatables-2.3.4/responsive.bootstrap5.min.js')) ?>,
    <?= json_encode(_asset_versioned('assets/js/datatables-init.js')) ?>
];
document.addEventListener('DOMContentLoaded', function () {
    (function next(i) {
        if (i >= window.DT_SRC.length) {
            return initDataTable('#rgpdTable', { columnDefs: [{ targets: 5, orderable: false, searchable: false }] });
        }
        var s = document.createElement('script');
        s.src = window.DT_SRC[i];
        s.onload = function () { next(i + 1); };
        document.body.appendChild(s);
    })(0);
});
</script>
<?php include __DIR__ . '/../../../includes/footer.php';