PYBS (Personel Yönetim Bilgi Sistemi)

<?php
// panels/muhasebe-panel.php
session_start();
require_once '../config/db.php';
require_once '../config/functions.php';

if (!isset($_SESSION['rol']) || $_SESSION['rol'] !== 'insan_kaynaklari') {
    header("Location: ../index.php"); exit;
}

include '../includes/header.php';
include '../includes/menu.php';

$bu_ay_bas = date('Y-m-01');
$bu_ay_son = date('Y-m-t');

// Aylık Toplam Onaylı Mesai
$toplam_mesai = $pdo->query("SELECT SUM(toplam_saat) FROM mesai_hareketleri WHERE durum = 'onaylandi' AND tarih BETWEEN '$bu_ay_bas' AND '$bu_ay_son'")->fetchColumn() ?: 0;

// Bekleyen Mesai Onayı
$bekleyen_mesai = $pdo->query("SELECT COUNT(*) FROM mesai_hareketleri WHERE durum = 'beklemede'")->fetchColumn();
?>

<div class="container-fluid">
    <div class="d-flex justify-content-between align-items-center mb-4 mt-2">
        <h3 class="m-0 text-dark fw-bold">Muhasebe Paneli</h3>
        <span class="badge bg-secondary fs-6"><?php echo tarihTurkce(date('Y-m-d'), true); ?></span>
    </div>

    <div class="row g-3 mb-4">
        <div class="col-12 col-md-4">
            <div class="card stat-card text-white bg-primary h-100">
                <div class="card-body d-flex justify-content-between align-items-center">
                    <div>
                        <h6 class="card-title text-uppercase mb-1" style="opacity: 0.8;">Bu Ay Onaylı Mesai</h6>
                        <h2 class="mb-0 fw-bold"><?php echo $toplam_mesai; ?> <small class="fs-6">Saat</small></h2>
                    </div>
                    <i class="fas fa-calculator fa-3x" style="opacity: 0.3;"></i>
                </div>
            </div>
        </div>

        <div class="col-12 col-md-4">
            <a href="../modules/tum-mesailer.php" class="text-decoration-none">
                <div class="card stat-card text-white bg-success h-100">
                    <div class="card-body d-flex justify-content-between align-items-center">
                        <div>
                            <h6 class="card-title text-uppercase mb-1" style="opacity: 0.8;">Bekleyen Mesai</h6>
                            <h2 class="mb-0 fw-bold"><?php echo $bekleyen_mesai; ?></h2>
                        </div>
                        <i class="fas fa-check-circle fa-3x" style="opacity: 0.3;"></i>
                    </div>
                </div>
            </a>
        </div>

        <div class="col-12 col-md-4">
            <a href="../modules/raporlar.php" class="text-decoration-none">
                <div class="card stat-card text-white bg-danger h-100">
                    <div class="card-body d-flex justify-content-between align-items-center">
                        <div>
                            <h6 class="card-title text-uppercase mb-1" style="opacity: 0.8;">Finansal Raporlar</h6>
                            <h5 class="mb-0 fw-bold">Döküm Al</h5>
                        </div>
                        <i class="fas fa-file-invoice-dollar fa-3x" style="opacity: 0.3;"></i>
                    </div>
                </div>
            </a>
        </div>
    </div>
</div>
<?php include '../includes/footer.php'; ?>