Sistema de Protocolos
Objetivo: Um sistema onde o visitante abre um “protocolo” (solicitação, reclamação, sugestão) e recebe um número de acompanhamento. Funciona como um mini-SAC institucional.
Estrutura
/protocolos/ ├── index.php ├── consultar.php ├── funcoes.php ├── admin.php ├── exportar.php ├── style.css └── protocolos.json (criado automaticamente)
1.1 index.php
<?php
// index.php - Portal de Abertura de Protocolos
require_once 'funcoes.php';
$mensagem = '';
$protocolo_gerado = '';
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$nome = trim($_POST['nome'] ?? '');
$email = trim($_POST['email'] ?? '');
$tipo = $_POST['tipo'] ?? '';
$assunto = trim($_POST['assunto'] ?? '');
$descricao = trim($_POST['descricao'] ?? '');
$erros = [];
if (strlen($nome) < 3) $erros[] = 'Nome deve ter ao menos 3 caracteres.';
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) $erros[] = 'E-mail inválido.';
if (!in_array($tipo, ['Reclamação', 'Sugestão', 'Elogio', 'Solicitação', 'Informação'])) {
$erros[] = 'Selecione um tipo válido.';
}
if (strlen($assunto) < 5) $erros[] = 'Assunto muito curto.';
if (strlen($descricao) < 10) $erros[] = 'Descrição muito curta.';
if (empty($erros)) {
$protocolo_gerado = gerarProtocolo($nome, $email, $tipo, $assunto, $descricao);
$mensagem = 'sucesso';
} else {
$mensagem = 'erro';
}
}
?>
<!DOCTYPE html>
<html lang="pt-BR">
<head>
<meta charset="UTF-8">
<title>Portal de Protocolos | Atendimento Institucional</title>
<link rel="stylesheet" href="style.css">
</head>
<body>
<header class="topbar">
<div class="container-topbar">
<div class="brand">
<span class="brand-icon">🏛️</span>
<div>
<div class="brand-title">Portal de Protocolos</div>
<div class="brand-sub">Atendimento Institucional</div>
</div>
</div>
<nav class="topnav">
<a href="index.php" class="active">Abrir Protocolo</a>
<a href="consultar.php">Consultar</a>
<a href="admin.php">Painel Admin</a>
</nav>
</div>
</header>
<main class="container">
<section class="page-head">
<h1>Abertura de Protocolo</h1>
<p>Preencha os dados abaixo para registrar sua solicitação. Um número de protocolo será gerado para acompanhamento.</p>
</section>
<?php if ($mensagem === 'sucesso'): ?>
<div class="alert alert-success">
<strong>Protocolo registrado com sucesso.</strong>
Guarde o número abaixo para consultas futuras.
<div class="protocolo-numero"><?php echo htmlspecialchars($protocolo_gerado); ?></div>
</div>
<?php elseif ($mensagem === 'erro'): ?>
<div class="alert alert-error">
<strong>Verifique os campos destacados:</strong>
<ul>
<?php foreach ($erros as $e): ?>
<li><?php echo htmlspecialchars($e); ?></li>
<?php endforeach; ?>
</ul>
</div>
<?php endif; ?>
<form method="POST" class="form-card">
<div class="grid-2">
<div class="form-group">
<label>Nome completo *</label>
<input type="text" name="nome" required value="<?php echo htmlspecialchars($_POST['nome'] ?? ''); ?>">
</div>
<div class="form-group">
<label>E-mail *</label>
<input type="email" name="email" required value="<?php echo htmlspecialchars($_POST['email'] ?? ''); ?>">
</div>
<div class="form-group">
<label>Tipo de manifestação *</label>
<select name="tipo" required>
<option value="">Selecione...</option>
<?php foreach (['Reclamação','Sugestão','Elogio','Solicitação','Informação'] as $t): ?>
<option value="<?php echo $t; ?>" <?php echo (($_POST['tipo'] ?? '') === $t) ? 'selected' : ''; ?>>
<?php echo $t; ?>
</option>
<?php endforeach; ?>
</select>
</div>
<div class="form-group">
<label>Assunto *</label>
<input type="text" name="assunto" required value="<?php echo htmlspecialchars($_POST['assunto'] ?? ''); ?>">
</div>
<div class="form-group full">
<label>Descrição detalhada *</label>
<textarea name="descricao" rows="5" required><?php echo htmlspecialchars($_POST['descricao'] ?? ''); ?></textarea>
</div>
</div>
<div class="form-actions">
<button type="submit" class="btn btn-primary">Registrar Protocolo</button>
</div>
</form>
<footer class="page-footer">
<p>Sistema Institucional de Atendimento © <?php echo date('Y'); ?></p>
</footer>
</main>
</body>
</html>
1.2 funcoes.php
<?php
// funcoes.php - Funções do Portal de Protocolos
define('ARQ_PROTOCOLOS', __DIR__ . '/protocolos.json');
function carregarProtocolos() {
if (!file_exists(ARQ_PROTOCOLOS)) return [];
$json = file_get_contents(ARQ_PROTOCOLOS);
return json_decode($json, true) ?? [];
}
function salvarProtocolos($lista) {
file_put_contents(ARQ_PROTOCOLOS, json_encode($lista, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE));
}
function gerarProtocolo($nome, $email, $tipo, $assunto, $descricao) {
$lista = carregarProtocolos();
$numero = 'PRT-' . date('Ymd') . '-' . str_pad(count($lista) + 1, 4, '0', STR_PAD_LEFT);
$lista[] = [
'numero' => $numero,
'nome' => $nome,
'email' => $email,
'tipo' => $tipo,
'assunto' => $assunto,
'descricao' => $descricao,
'status' => 'Aberto',
'data' => date('d/m/Y H:i')
];
salvarProtocolos($lista);
return $numero;
}
function buscarProtocolo($numero) {
foreach (carregarProtocolos() as $p) {
if (strcasecmp($p['numero'], $numero) === 0) return $p;
}
return null;
}
function atualizarStatus($numero, $novoStatus) {
$lista = carregarProtocolos();
foreach ($lista as &$p) {
if ($p['numero'] === $numero) {
$p['status'] = $novoStatus;
break;
}
}
salvarProtocolos($lista);
}
?>
1.3 consultar.php
<?php
require_once 'funcoes.php';
$protocolo = null;
$nao_encontrado = false;
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$numero = trim($_POST['numero'] ?? '');
$protocolo = buscarProtocolo($numero);
if (!$protocolo) $nao_encontrado = true;
}
?>
<!DOCTYPE html>
<html lang="pt-BR">
<head>
<meta charset="UTF-8">
<title>Consultar Protocolo</title>
<link rel="stylesheet" href="style.css">
</head>
<body>
<header class="topbar">
<div class="container-topbar">
<div class="brand">
<span class="brand-icon">🏛️</span>
<div>
<div class="brand-title">Portal de Protocolos</div>
<div class="brand-sub">Atendimento Institucional</div>
</div>
</div>
<nav class="topnav">
<a href="index.php">Abrir Protocolo</a>
<a href="consultar.php" class="active">Consultar</a>
<a href="admin.php">Painel Admin</a>
</nav>
</div>
</header>
<main class="container">
<section class="page-head">
<h1>Consultar Protocolo</h1>
<p>Informe o número do protocolo recebido no momento do registro.</p>
</section>
<form method="POST" class="form-card compact">
<div class="form-group">
<label>Número do protocolo</label>
<input type="text" name="numero" placeholder="Ex: PRT-20260101-0001" required
value="<?php echo htmlspecialchars($_POST['numero'] ?? ''); ?>">
</div>
<button type="submit" class="btn btn-primary">Consultar</button>
</form>
<?php if ($nao_encontrado): ?>
<div class="alert alert-error">Nenhum protocolo encontrado com esse número.</div>
<?php endif; ?>
<?php if ($protocolo): ?>
<section class="detail-card">
<div class="detail-head">
<h2><?php echo htmlspecialchars($protocolo['numero']); ?></h2>
<span class="badge status-<?php echo strtolower($protocolo['status']); ?>">
<?php echo $protocolo['status']; ?>
</span>
</div>
<dl class="detail-list">
<dt>Nome</dt><dd><?php echo htmlspecialchars($protocolo['nome']); ?></dd>
<dt>E-mail</dt><dd><?php echo htmlspecialchars($protocolo['email']); ?></dd>
<dt>Tipo</dt><dd><?php echo htmlspecialchars($protocolo['tipo']); ?></dd>
<dt>Assunto</dt><dd><?php echo htmlspecialchars($protocolo['assunto']); ?></dd>
<dt>Descrição</dt><dd><?php echo nl2br(htmlspecialchars($protocolo['descricao'])); ?></dd>
<dt>Data</dt><dd><?php echo htmlspecialchars($protocolo['data']); ?></dd>
</dl>
</section>
<?php endif; ?>
</main>
</body>
</html>
1.4 admin.php
<?php
require_once 'funcoes.php';
$senha_admin = 'admin123';
session_start();
$logado = $_SESSION['admin_ok'] ?? false;
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['senha'])) {
if ($_POST['senha'] === $senha_admin) {
$_SESSION['admin_ok'] = true;
$logado = true;
}
}
if (isset($_GET['sair'])) {
session_destroy();
header('Location: admin.php');
exit;
}
if (isset($_POST['status']) && isset($_POST['numero'])) {
atualizarStatus($_POST['numero'], $_POST['status']);
header('Location: admin.php');
exit;
}
$lista = carregarProtocolos();
$lista = array_reverse($lista);
?>
<!DOCTYPE html>
<html lang="pt-BR">
<head>
<meta charset="UTF-8">
<title>Painel Administrativo</title>
<link rel="stylesheet" href="style.css">
</head>
<body>
<header class="topbar">
<div class="container-topbar">
<div class="brand">
<span class="brand-icon">🏛️</span>
<div>
<div class="brand-title">Painel Administrativo</div>
<div class="brand-sub">Gestão de Protocolos</div>
</div>
</div>
<?php if ($logado): ?>
<nav class="topnav">
<a href="index.php">Portal</a>
<a href="exportar.php">Exportar CSV</a>
<a href="?sair=1" class="danger">Sair</a>
</nav>
<?php endif; ?>
</div>
</header>
<main class="container">
<?php if (!$logado): ?>
<div class="login-box">
<h1>Acesso Restrito</h1>
<p>Informe a senha administrativa para continuar.</p>
<form method="POST" class="form-card compact">
<div class="form-group">
<label>Senha</label>
<input type="password" name="senha" required>
</div>
<button type="submit" class="btn btn-primary">Entrar</button>
</form>
</div>
<?php else: ?>
<section class="page-head">
<h1>Protocolos Registrados</h1>
<p>Total: <strong><?php echo count($lista); ?></strong> protocolo(s)</p>
</section>
<?php if (empty($lista)): ?>
<div class="empty-state">
<p>Nenhum protocolo registrado até o momento.</p>
</div>
<?php else: ?>
<div class="table-wrapper">
<table class="table">
<thead>
<tr>
<th>Protocolo</th>
<th>Solicitante</th>
<th>Tipo</th>
<th>Assunto</th>
<th>Data</th>
<th>Status</th>
<th>Ações</th>
</tr>
</thead>
<tbody>
<?php foreach ($lista as $p): ?>
<tr>
<td><strong><?php echo htmlspecialchars($p['numero']); ?></strong></td>
<td><?php echo htmlspecialchars($p['nome']); ?></td>
<td><?php echo htmlspecialchars($p['tipo']); ?></td>
<td><?php echo htmlspecialchars($p['assunto']); ?></td>
<td><?php echo htmlspecialchars($p['data']); ?></td>
<td>
<span class="badge status-<?php echo strtolower($p['status']); ?>">
<?php echo $p['status']; ?>
</span>
</td>
<td>
<form method="POST" class="inline-form">
<input type="hidden" name="numero" value="<?php echo $p['numero']; ?>">
<select name="status" onchange="this.form.submit()">
<?php foreach (['Aberto','Em análise','Resolvido','Arquivado'] as $s): ?>
<option value="<?php echo $s; ?>" <?php echo $p['status'] === $s ? 'selected' : ''; ?>>
<?php echo $s; ?>
</option>
<?php endforeach; ?>
</select>
</form>
</td>
</tr>
<?php endforeach; ?>
</tbody>
</table>
</div>
<?php endif; ?>
<?php endif; ?>
</main>
</body>
</html>
1.5 exportar.php
<?php
require_once 'funcoes.php';
session_start();
if (!isset($_SESSION['admin_ok'])) {
header('Location: admin.php');
exit;
}
$lista = carregarProtocolos();
$nome = 'protocolos_' . date('Y-m-d_H-i') . '.csv';
header('Content-Type: text/csv; charset=utf-8');
header('Content-Disposition: attachment; filename="' . $nome . '"');
$saida = fopen('php://output', 'w');
fprintf($saida, chr(0xEF).chr(0xBB).chr(0xBF));
fputcsv($saida, ['Protocolo', 'Nome', 'E-mail', 'Tipo', 'Assunto', 'Descrição', 'Status', 'Data']);
foreach ($lista as $p) {
fputcsv($saida, [
$p['numero'], $p['nome'], $p['email'], $p['tipo'],
$p['assunto'], $p['descricao'], $p['status'], $p['data']
]);
}
fclose($saida);
exit;
?>
1.6 style.css
/* ============================================
Portal de Protocolos - Estilo Institucional
============================================ */
:root {
--navy: #0f2b46;
--navy-soft: #1e5b96;
--navy-dark: #0a1f34;
--gold: #c9a227;
--bg: #f4f6f9;
--white: #ffffff;
--border: #d9e0e8;
--text: #2d3748;
--text-soft: #64748b;
--success: #1f9d55;
--danger: #c53030;
--warning: #b7791f;
}
* { margin: 0; padding: 0; box-sizing: border-box; }
body {
font-family: 'Georgia', 'Segoe UI', serif;
background: var(--bg);
color: var(--text);
min-height: 100vh;
}
/* Topbar */
.topbar {
background: var(--navy);
border-bottom: 3px solid var(--gold);
color: white;
}
.container-topbar {
max-width: 1200px;
margin: 0 auto;
padding: 16px 30px;
display: flex;
justify-content: space-between;
align-items: center;
flex-wrap: wrap;
gap: 15px;
}
.brand { display: flex; align-items: center; gap: 14px; }
.brand-icon { font-size: 2rem; }
.brand-title {
font-size: 1.15rem;
font-weight: 700;
letter-spacing: 0.5px;
}
.brand-sub {
font-size: 0.75rem;
color: rgba(255,255,255,0.6);
letter-spacing: 2px;
text-transform: uppercase;
}
.topnav { display: flex; gap: 6px; flex-wrap: wrap; }
.topnav a {
color: rgba(255,255,255,0.85);
text-decoration: none;
padding: 8px 16px;
border-radius: 4px;
font-size: 0.85rem;
font-family: 'Segoe UI', sans-serif;
font-weight: 500;
transition: all 0.25s ease;
}
.topnav a:hover { background: rgba(255,255,255,0.1); color: white; }
.topnav a.active {
background: var(--gold);
color: var(--navy);
font-weight: 700;
}
.topnav a.danger { color: #ffb3b3; }
.topnav a.danger:hover { background: var(--danger); color: white; }
/* Container */
.container {
max-width: 1100px;
margin: 0 auto;
padding: 40px 30px 60px;
}
/* Cabeçalho de página */
.page-head {
margin-bottom: 30px;
padding-bottom: 20px;
border-bottom: 2px solid var(--border);
}
.page-head h1 {
font-size: 1.75rem;
color: var(--navy);
margin-bottom: 8px;
letter-spacing: -0.3px;
}
.page-head p {
color: var(--text-soft);
font-family: 'Segoe UI', sans-serif;
font-size: 0.95rem;
}
/* Alerts */
.alert {
padding: 16px 20px;
border-radius: 6px;
margin-bottom: 25px;
border-left: 5px solid;
font-family: 'Segoe UI', sans-serif;
}
.alert-success {
background: #e6f4ea;
border-color: var(--success);
color: #1e4620;
}
.alert-error {
background: #fdecea;
border-color: var(--danger);
color: #5c1a1a;
}
.alert ul { margin-top: 8px; margin-left: 20px; }
.protocolo-numero {
background: var(--navy);
color: var(--gold);
font-family: 'Courier New', monospace;
font-size: 1.4rem;
font-weight: bold;
padding: 12px 20px;
border-radius: 4px;
margin-top: 12px;
display: inline-block;
letter-spacing: 2px;
}
/* Formulário */
.form-card {
background: var(--white);
padding: 32px;
border-radius: 8px;
box-shadow: 0 1px 3px rgba(15,43,70,0.08);
border: 1px solid var(--border);
font-family: 'Segoe UI', sans-serif;
}
.form-card.compact {
max-width: 500px;
margin: 0 auto;
}
.grid-2 {
display: grid;
grid-template-columns: 1fr 1fr;
gap: 20px;
}
.form-group { display: flex; flex-direction: column; }
.form-group.full { grid-column: span 2; }
.form-group label {
font-size: 0.82rem;
font-weight: 600;
color: var(--navy);
margin-bottom: 6px;
text-transform: uppercase;
letter-spacing: 0.5px;
}
.form-group input,
.form-group select,
.form-group textarea {
padding: 11px 14px;
border: 1px solid var(--border);
border-radius: 4px;
font-size: 0.95rem;
font-family: inherit;
background: var(--white);
transition: border-color 0.2s, box-shadow 0.2s;
color: var(--text);
}
.form-group input:focus,
.form-group select:focus,
.form-group textarea:focus {
outline: none;
border-color: var(--navy-soft);
box-shadow: 0 0 0 3px rgba(30,91,150,0.12);
}
.form-group textarea { resize: vertical; min-height: 110px; }
.form-actions {
display: flex;
justify-content: flex-end;
gap: 12px;
margin-top: 25px;
padding-top: 20px;
border-top: 1px solid var(--border);
}
/* Botões */
.btn {
padding: 12px 28px;
border: none;
border-radius: 4px;
font-size: 0.85rem;
font-weight: 600;
text-transform: uppercase;
letter-spacing: 1px;
cursor: pointer;
text-decoration: none;
display: inline-flex;
align-items: center;
justify-content: center;
transition: all 0.25s ease;
font-family: 'Segoe UI', sans-serif;
}
.btn-primary {
background: var(--navy);
color: white;
}
.btn-primary:hover {
background: var(--navy-dark);
box-shadow: 0 4px 12px rgba(15,43,70,0.25);
}
/* Detalhes */
.detail-card {
background: var(--white);
padding: 30px;
border-radius: 8px;
border: 1px solid var(--border);
box-shadow: 0 1px 3px rgba(15,43,70,0.08);
font-family: 'Segoe UI', sans-serif;
}
.detail-head {
display: flex;
justify-content: space-between;
align-items: center;
padding-bottom: 16px;
border-bottom: 2px solid var(--border);
margin-bottom: 20px;
flex-wrap: wrap;
gap: 10px;
}
.detail-head h2 {
color: var(--navy);
font-family: 'Courier New', monospace;
letter-spacing: 1px;
font-size: 1.3rem;
}
.detail-list {
display: grid;
grid-template-columns: 160px 1fr;
gap: 12px 20px;
}
.detail-list dt {
font-weight: 700;
color: var(--navy);
font-size: 0.82rem;
text-transform: uppercase;
letter-spacing: 0.5px;
padding-top: 2px;
}
.detail-list dd { color: var(--text); line-height: 1.6; }
/* Badges */
.badge {
display: inline-block;
padding: 4px 12px;
border-radius: 20px;
font-size: 0.75rem;
font-weight: 700;
text-transform: uppercase;
letter-spacing: 0.5px;
font-family: 'Segoe UI', sans-serif;
}
.status-aberto { background: #e0efff; color: #1e5b96; }
.status-em-análise, .status-em_análise { background: #fff4d6; color: #8a6516; }
.status-resolvido { background: #d4edda; color: #1e4620; }
.status-arquivado { background: #e2e8f0; color: #4a5568; }
/* Tabela */
.table-wrapper {
background: var(--white);
border-radius: 8px;
border: 1px solid var(--border);
overflow-x: auto;
box-shadow: 0 1px 3px rgba(15,43,70,0.08);
}
.table {
width: 100%;
border-collapse: collapse;
font-family: 'Segoe UI', sans-serif;
font-size: 0.9rem;
}
.table thead {
background: var(--navy);
color: white;
}
.table th {
padding: 14px 16px;
text-align: left;
font-size: 0.78rem;
text-transform: uppercase;
letter-spacing: 0.5px;
font-weight: 600;
}
.table td {
padding: 14px 16px;
border-bottom: 1px solid var(--border);
color: var(--text);
}
.table tbody tr:last-child td { border-bottom: none; }
.table tbody tr:hover { background: #f9fbfd; }
.inline-form select {
padding: 6px 10px;
border: 1px solid var(--border);
border-radius: 4px;
font-size: 0.8rem;
background: white;
cursor: pointer;
}
/* Login */
.login-box {
max-width: 480px;
margin: 60px auto;
text-align: center;
}
.login-box h1 {
color: var(--navy);
margin-bottom: 8px;
font-size: 1.5rem;
}
.login-box p {
color: var(--text-soft);
margin-bottom: 25px;
font-family: 'Segoe UI', sans-serif;
}
/* Vazio */
.empty-state {
background: var(--white);
padding: 60px 30px;
text-align: center;
border-radius: 8px;
border: 1px dashed var(--border);
color: var(--text-soft);
font-family: 'Segoe UI', sans-serif;
}
/* Rodapé */
.page-footer {
margin-top: 50px;
padding-top: 20px;
border-top: 1px solid var(--border);
text-align: center;
color: var(--text-soft);
font-size: 0.8rem;
font-family: 'Segoe UI', sans-serif;
letter-spacing: 1px;
}
/* Responsivo */
@media (max-width: 700px) {
.container-topbar { flex-direction: column; align-items: flex-start; }
.topnav { width: 100%; }
.topnav a { flex: 1; text-align: center; }
.grid-2 { grid-template-columns: 1fr; }
.form-group.full { grid-column: span 1; }
.detail-list { grid-template-columns: 1fr; gap: 4px 0; }
.detail-list dd { margin-bottom: 10px; }
.page-head h1 { font-size: 1.4rem; }
.form-card { padding: 22px; }
}