@extends('layouts.app')

@section('content')
<div class="container-fluid p-0">
    <div class="d-flex h-100">
        <!-- Sidebar -->
        @include('layouts.sidebar')

        <!-- Main Content -->
        <div class="flex-grow-1" style="margin-left: 250px; background-color: #f8f9fa; min-height: 100vh;">
            <div class="p-4">
                <!-- Header -->
                <div class="d-flex justify-content-between align-items-center mb-4 bg-white p-3 rounded shadow-sm">
                    <h4 class="mb-0">Laporan Statistik Alumni</h4>
                </div>

                <!-- Statistics Cards -->
                <div class="row g-4 mb-4">
                    <div class="col-md-4">
                        <div class="card border-0 shadow-sm bg-primary text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-start">
                                    <div>
                                        <h6 class="card-title mb-2">Total Alumni</h6>
                                        <h2 class="mb-0">{{ number_format($statistics->total_alumni) }}</h2>
                                    </div>
                                    <div class="bg-white rounded-circle p-2">
                                        <i class="bi bi-people text-primary fs-4"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="card border-0 shadow-sm bg-success text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-start">
                                    <div>
                                        <h6 class="card-title mb-2">Alumni Bekerja</h6>
                                        <h2 class="mb-0">{{ number_format($statistics->working_alumni) }}</h2>
                                    </div>
                                    <div class="bg-white rounded-circle p-2">
                                        <i class="bi bi-briefcase text-success fs-4"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="card border-0 shadow-sm bg-info text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-start">
                                    <div>
                                        <h6 class="card-title mb-2">Relevansi Pekerjaan</h6>
                                        <h2 class="mb-0">{{ number_format($statistics->relevance_percentage, 1) }}%</h2>
                                    </div>
                                    <div class="bg-white rounded-circle p-2">
                                        <i class="bi bi-graph-up text-info fs-4"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

                <!-- Yearly Statistics Table -->
                <div class="card shadow-sm border-0">
                    <div class="card-body bg-white rounded-3">
                        <h5 class="card-title mb-4">Statistik Per Tahun</h5>
                        <div class="table-responsive">
                            <table class="table table-hover">
                                <thead class="bg-light">
                                    <tr>
                                        <th>Tahun Lulus</th>
                                        <th>Total Alumni</th>
                                        <th>Bekerja</th>
                                        <th>Relevan</th>
                                        <th>% Relevansi</th>
                                        <th>Tingkat Kesesuaian (Summary)</th>
                                        <th>Avg. Perkuliahan</th>
                                        <th>Avg. Diskusi</th>
                                        <th>Avg. Praktikum</th>
                                        <th>Avg. Tugas</th>
                                        <th>Avg. Magang</th>
                                        <th>Avg. Penelitian</th>
                                        <th>Avg. Seminar</th>
                                        <th>Avg. Konsultasi</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach($yearlyData as $data)
                                    <tr>
                                        <td>{{ $data->year }}</td>
                                        <td>{{ number_format($data->total) }}</td>
                                        <td>{{ number_format($data->working) }}</td>
                                        <td>{{ number_format($data->relevant) }}</td>
                                        <td>
                                            @if($data->total > 0)
                                                {{ number_format(($data->relevant / $data->total) * 100, 1) }}%
                                            @else
                                                0%
                                            @endif
                                        </td>
                                        <td>{{ $data->summary_kesesuaian ?? '-' }}</td>
                                        <td>{{ $data->avg_perkuliahan ? number_format($data->avg_perkuliahan, 2) : '-' }}</td>
                                        <td>{{ $data->avg_diskusi ? number_format($data->avg_diskusi, 2) : '-' }}</td>
                                        <td>{{ $data->avg_praktikum ? number_format($data->avg_praktikum, 2) : '-' }}</td>
                                        <td>{{ $data->avg_tugas ? number_format($data->avg_tugas, 2) : '-' }}</td>
                                        <td>{{ $data->avg_magang ? number_format($data->avg_magang, 2) : '-' }}</td>
                                        <td>{{ $data->avg_penelitian ? number_format($data->avg_penelitian, 2) : '-' }}</td>
                                        <td>{{ $data->avg_seminar ? number_format($data->avg_seminar, 2) : '-' }}</td>
                                        <td>{{ $data->avg_konsultasi ? number_format($data->avg_konsultasi, 2) : '-' }}</td>
                                    </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection