One Hat Cyber Team

View File Name : frequencias.php

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

$titulo = 'Frequencias';
require_once __DIR__ . '/../includes/header.php';

$empresaId = getEmpresaId();

if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['acao'])) {
    $acao = $_POST['acao'];

    if ($acao === 'cadastrar') {
        $nome = trim($_POST['nome']);
        $dias = (int)$_POST['dias'];
        try {
            $pdo->prepare("INSERT INTO frequencias (empresa_id, nome, dias) VALUES (?,?,?)")
                ->execute([$empresaId, $nome, $dias]);
            $_SESSION['success_msg'] = 'Frequencia cadastrada!';
        } catch (PDOException $e) { $_SESSION['error_msg'] = 'Erro: ' . $e->getMessage(); }
        redirect('frequencias.php');
    }

    if ($acao === 'editar') {
        $id = (int)$_POST['id'];
        $nome = trim($_POST['nome']);
        $dias = (int)$_POST['dias'];
        $ativo = isset($_POST['ativo']) ? 1 : 0;
        try {
            $pdo->prepare("UPDATE frequencias SET nome=?, dias=?, ativo=? WHERE id=? AND empresa_id=?")
                ->execute([$nome, $dias, $ativo, $id, $empresaId]);
            $_SESSION['success_msg'] = 'Frequencia atualizada!';
        } catch (PDOException $e) { $_SESSION['error_msg'] = 'Erro: ' . $e->getMessage(); }
        redirect('frequencias.php');
    }

    if ($acao === 'excluir') {
        $id = (int)$_POST['id'];
        $pdo->prepare("DELETE FROM frequencias WHERE id=? AND empresa_id=?")->execute([$id, $empresaId]);
        $_SESSION['success_msg'] = 'Frequencia excluida!';
        redirect('frequencias.php');
    }
}

$frequencias = $pdo->prepare("SELECT * FROM frequencias WHERE empresa_id = ? ORDER BY dias");
$frequencias->execute([$empresaId]);
$frequenciasLista = $frequencias->fetchAll();
?>
<div class="card animate-fadeIn">
    <div class="card-header d-flex align-items-center justify-content-between">
        <h3 class="card-title"><i class="bi bi-arrow-repeat me-2 text-info"></i>Frequencias</h3>
        <button class="btn btn-primary btn-sm" onclick="abrirModal('modalCadastrar')"><i class="bi bi-plus"></i> Nova</button>
    </div>
    <div class="card-body p-0">
        <div class="table-responsive">
            <table class="table">
                <thead><tr><th>ID</th><th>Nome</th><th>Intervalo (dias)</th><th>Status</th><th>Acoes</th></tr></thead>
                <tbody>
                    <?php foreach ($frequenciasLista as $f): ?>
                    <tr>
                        <td><?= $f['id'] ?></td>
                        <td class="fw-semibold"><?= sanitize($f['nome']) ?></td>
                        <td><span class="badge bg-primary bg-opacity-10 text-primary border border-primary border-opacity-25"><?= $f['dias'] ?> dias</span></td>
                        <td><?= $f['ativo'] ? '<span class="badge bg-success bg-opacity-10 text-success">Ativo</span>' : '<span class="badge bg-danger bg-opacity-10 text-danger">Inativo</span>' ?></td>
                        <td>
                            <button class="btn btn-warning btn-sm" onclick="abrirModal('modalEditar<?= $f['id'] ?>')"><i class="bi bi-pencil"></i></button>
                            <form method="POST" style="display:inline" onsubmit="return confirm('Excluir frequencia?')">
                                <input type="hidden" name="acao" value="excluir"><input type="hidden" name="id" value="<?= $f['id'] ?>">
                                <button class="btn btn-danger btn-sm"><i class="bi bi-trash"></i></button>
                            </form>
                        </td>
                    </tr>
                    <?php endforeach; ?>
                </tbody>
            </table>
        </div>
    </div>
</div>

<div class="modal fade" id="modalCadastrar" tabindex="-1"><div class="modal-dialog modal-dialog-centered">
    <form method="POST" class="modal-content"><div class="modal-header"><h5 class="modal-title"><i class="bi bi-plus-circle me-2 text-info"></i>Nova Frequencia</h5><button type="button" class="btn-close" data-bs-dismiss="modal"></button></div>
        <div class="modal-body">
            <input type="hidden" name="acao" value="cadastrar">
            <div class="mb-3"><label class="form-label">Nome</label><input type="text" name="nome" class="form-control" required></div>
            <div class="mb-3"><label class="form-label">Intervalo (dias)</label><input type="number" name="dias" class="form-control" min="1" required></div>
        </div>
        <div class="modal-footer"><button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancelar</button><button type="submit" class="btn btn-primary">Salvar</button></div>
    </form>
</div></div>

<?php foreach ($frequenciasLista as $f): ?>
<div class="modal fade" id="modalEditar<?= $f['id'] ?>" tabindex="-1"><div class="modal-dialog modal-dialog-centered">
    <form method="POST" class="modal-content"><div class="modal-header"><h5 class="modal-title"><i class="bi bi-pencil-square me-2 text-warning"></i>Editar <?= sanitize($f['nome']) ?></h5><button type="button" class="btn-close" data-bs-dismiss="modal"></button></div>
        <div class="modal-body">
            <input type="hidden" name="acao" value="editar"><input type="hidden" name="id" value="<?= $f['id'] ?>">
            <div class="mb-3"><label class="form-label">Nome</label><input type="text" name="nome" class="form-control" value="<?= sanitize($f['nome']) ?>" required></div>
            <div class="mb-3"><label class="form-label">Intervalo (dias)</label><input type="number" name="dias" class="form-control" min="1" value="<?= $f['dias'] ?>" required></div>
            <div class="form-check"><input type="checkbox" name="ativo" class="form-check-input" id="ativo<?= $f['id'] ?>" <?= $f['ativo'] ? 'checked' : '' ?>><label class="form-check-label" for="ativo<?= $f['id'] ?>">Ativo</label></div>
        </div>
        <div class="modal-footer"><button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancelar</button><button type="submit" class="btn btn-primary">Atualizar</button></div>
    </form>
</div></div>
<?php endforeach; ?>

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