One Hat Cyber Team

View File Name : index.php

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

$titulo = 'Painel Super Admin';
require_once __DIR__ . '/../includes/header.php';

if (isset($_GET['acessar_empresa'])) {
    $_SESSION['admin_empresa_id'] = (int)$_GET['acessar_empresa'];
    redirect(URL_BASE . 'public/dashboard.php');
}

$totalEmpresas = $pdo->query("SELECT COUNT(*) FROM empresas")->fetchColumn();

$despesasVencidas = $pdo->query("SELECT COALESCE(SUM(valor),0) FROM contas_pagar WHERE data_vencimento < CURDATE() AND status = 'pendente'")->fetchColumn();

$receberVencidos = $pdo->query("SELECT COALESCE(SUM(valor_total),0) FROM contas_receber WHERE data_vencimento < CURDATE() AND status = 'pendente'")->fetchColumn();

$recebidoMes = $pdo->query("SELECT COALESCE(SUM(valor_total),0) FROM contas_receber WHERE status = 'pago' AND MONTH(data_pagamento) = MONTH(CURDATE()) AND YEAR(data_pagamento) = YEAR(CURDATE())")->fetchColumn();

$pagoMes = $pdo->query("SELECT COALESCE(SUM(valor),0) FROM contas_pagar WHERE status = 'pago' AND MONTH(data_pagamento) = MONTH(CURDATE()) AND YEAR(data_pagamento) = YEAR(CURDATE())")->fetchColumn();

$saldoMes = $recebidoMes - $pagoMes;

$empresas = $pdo->query("
    SELECT e.id, e.nome, e.logo,
        (SELECT COUNT(*) FROM contas_pagar cp WHERE cp.empresa_id = e.id AND cp.data_vencimento < CURDATE() AND cp.status = 'pendente') as contas_vencidas
    FROM empresas e ORDER BY e.nome
")->fetchAll();
?>

<div class="row g-4 mb-4">
    <div class="col-lg-3 col-6">
        <div class="small-box bg-gradient-primary" style="background:linear-gradient(135deg,#667eea,#764ba2)!important">
            <div class="inner"><h3><?= $totalEmpresas ?></h3><p>Total de Empresas</p></div>
            <div class="icon"><i class="bi bi-building"></i></div>
            <a href="empresas.php" class="small-box-footer">Gerenciar <i class="bi bi-arrow-right ms-1"></i></a>
        </div>
    </div>
    <div class="col-lg-3 col-6">
        <div class="small-box bg-danger">
            <div class="inner"><h3><?= formatarMoeda($despesasVencidas) ?></h3><p>Despesas Vencidas</p></div>
            <div class="icon"><i class="bi bi-arrow-up-circle"></i></div>
            <a href="javascript:void(0)" class="small-box-footer">Total pendente</a>
        </div>
    </div>
    <div class="col-lg-3 col-6">
        <div class="small-box bg-warning">
            <div class="inner"><h3><?= formatarMoeda($receberVencidos) ?></h3><p>Receber Vencidos</p></div>
            <div class="icon"><i class="bi bi-arrow-down-circle"></i></div>
            <a href="javascript:void(0)" class="small-box-footer">Total a receber</a>
        </div>
    </div>
    <div class="col-lg-3 col-6">
        <div class="small-box bg-<?= $saldoMes >= 0 ? 'success' : 'danger' ?>">
            <div class="inner"><h3><?= formatarMoeda($saldoMes) ?></h3><p>Saldo do Mês</p></div>
            <div class="icon"><i class="bi bi-cash-stack"></i></div>
            <a href="javascript:void(0)" class="small-box-footer">Recebido - Pago</a>
        </div>
    </div>
</div>

<div class="card">
    <div class="card-header">
        <h3 class="card-title"><i class="bi bi-building me-2 text-info"></i>Empresas Cadastradas</h3>
        <div class="card-tools">
            <div class="input-group" style="width:300px">
                <input type="text" id="filtroEmpresas" class="form-control" placeholder="Buscar empresa..." onkeyup="filtrarEmpresas()">
                <span class="input-group-text"><i class="bi bi-search"></i></span>
            </div>
        </div>
    </div>
    <div class="card-body">
        <div class="row g-4" id="cardsEmpresas">
            <?php foreach ($empresas as $e): ?>
            <div class="col-lg-3 col-md-4 col-sm-6 item-empresa">
                <div class="card h-100 text-center shadow-sm">
                    <div class="card-body d-flex flex-column align-items-center justify-content-center py-4">
                        <?php if ($e['logo'] && file_exists(__DIR__ . '/../' . $e['logo'])): ?>
                        <img src="<?= URL_BASE . $e['logo'] ?>" alt="<?= sanitize($e['nome']) ?>" class="rounded-circle mb-3" style="width:80px;height:80px;object-fit:cover">
                        <?php else: ?>
                        <div class="rounded-circle bg-gradient d-flex align-items-center justify-content-center mb-3" style="width:80px;height:80px;background:linear-gradient(135deg,#667eea,#764ba2)">
                            <i class="bi bi-building text-white" style="font-size:2rem"></i>
                        </div>
                        <?php endif; ?>
                        <h5 class="card-title fw-bold"><?= sanitize($e['nome']) ?></h5>
                        <?php if ($e['contas_vencidas'] > 0): ?>
                        <span class="badge bg-danger mt-2"><?= $e['contas_vencidas'] ?> conta(s) vencida(s)</span>
                        <?php else: ?>
                        <span class="badge bg-success mt-2">Em dia</span>
                        <?php endif; ?>
                        <a href="?acessar_empresa=<?= $e['id'] ?>" class="btn btn-primary mt-3 w-100">
                            <i class="bi bi-box-arrow-in-right me-1"></i>Acessar Empresa
                        </a>
                    </div>
                </div>
            </div>
            <?php endforeach; ?>
        </div>
    </div>
</div>

<script>
function filtrarEmpresas() {
    var termo = document.getElementById('filtroEmpresas').value.toLowerCase();
    document.querySelectorAll('.item-empresa').forEach(function(el) {
        var nome = el.querySelector('.card-title').textContent.toLowerCase();
        el.style.display = nome.includes(termo) ? '' : 'none';
    });
}
</script>

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