@extends('layouts.app')

@section('title', 'Laporan Rekapan Gaji')

@section('content')
<div class="d-flex justify-content-between align-items-center mb-4">
    <div>
        <h2 class="mb-0"><i class="bi bi-file-earmark-text"></i> Laporan Rekapan Gaji</h2>
        <small class="text-muted">Rekap gaji per bulan untuk setiap pegawai</small>
    </div>
</div>

<!-- Filter Form -->
<div class="card mb-4">
    <div class="card-header">
        <h5 class="mb-0"><i class="bi bi-funnel"></i> Filter Laporan</h5>
    </div>
    <div class="card-body">
        <form method="GET" action="{{ route('laporan-gaji.index') }}" class="row g-3">
            <div class="col-md-3">
                <label class="form-label">Tahun</label>
                <select name="tahun" class="form-select">
                    @for($y = date('Y'); $y >= date('Y') - 5; $y--)
                        <option value="{{ $y }}" {{ $tahun == $y ? 'selected' : '' }}>{{ $y }}</option>
                    @endfor
                </select>
            </div>
            <div class="col-md-3">
                <label class="form-label">Bulan</label>
                <select name="bulan" class="form-select">
                    @foreach([
                        1 => 'Januari', 2 => 'Februari', 3 => 'Maret', 4 => 'April',
                        5 => 'Mei', 6 => 'Juni', 7 => 'Juli', 8 => 'Agustus',
                        9 => 'September', 10 => 'Oktober', 11 => 'November', 12 => 'Desember'
                    ] as $b => $namaBulan)
                        <option value="{{ $b }}" {{ $bulan == $b ? 'selected' : '' }}>{{ $namaBulan }}</option>
                    @endforeach
                </select>
            </div>
            @if(!auth()->user()->isPegawai())
            <div class="col-md-4">
                <label class="form-label">Pegawai</label>
                <select name="pegawai_id" class="form-select">
                    <option value="">Semua Pegawai</option>
                    @foreach($pegawaiList as $p)
                        <option value="{{ $p->id }}" {{ $pegawaiId == $p->id ? 'selected' : '' }}>
                            {{ $p->nama_lengkap }} ({{ $p->nip ?? '-' }})
                        </option>
                    @endforeach
                </select>
            </div>
            @endif
            <div class="col-md-2 d-flex align-items-end">
                <button type="submit" class="btn btn-primary w-100">
                    <i class="bi bi-search"></i> Cari
                </button>
            </div>
        </form>
    </div>
</div>

<!-- Export Buttons -->
@if(count($laporan) > 0)
<div class="mb-3 d-flex gap-2">
    <a href="{{ route('laporan-gaji.export-pdf', ['tahun' => $tahun, 'bulan' => $bulan, 'pegawai_id' => $pegawaiId]) }}" 
       class="btn btn-danger">
        <i class="bi bi-file-pdf"></i> Export PDF
    </a>
    <a href="{{ route('laporan-gaji.export-excel', ['tahun' => $tahun, 'bulan' => $bulan, 'pegawai_id' => $pegawaiId]) }}" 
       class="btn btn-success">
        <i class="bi bi-file-excel"></i> Export Excel
    </a>
</div>
@endif

<!-- Laporan Table -->
@if(count($laporan) > 0)
<div class="card">
    <div class="card-header">
        <h5 class="mb-0">
            <i class="bi bi-list-ul"></i> 
            Rekap Gaji Bulan {{ $laporan[0]['periode']['nama_bulan'] }} {{ $tahun }}
        </h5>
    </div>
    <div class="card-body">
        <div class="table-responsive">
            <table class="table table-hover align-middle">
                <thead>
                    <tr>
                        <th rowspan="2" class="align-middle text-center">No</th>
                        <th rowspan="2" class="align-middle">NIP</th>
                        <th rowspan="2" class="align-middle">Nama Pegawai</th>
                        <th colspan="5" class="text-center bg-light">Kehadiran</th>
                        <th rowspan="2" class="align-middle text-center">Total Hari Cuti</th>
                        <th rowspan="2" class="align-middle text-center">Denda Cuti</th>
                        <th rowspan="2" class="align-middle text-center">Potongan Absensi</th>
                        <th rowspan="2" class="align-middle text-center">Total Gaji</th>
                    </tr>
                    <tr class="bg-light">
                        <th class="text-center">Hadir</th>
                        <th class="text-center">Izin</th>
                        <th class="text-center">Sakit</th>
                        <th class="text-center">Cuti</th>
                        <th class="text-center">Alpha</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($laporan as $index => $item)
                    @php
                        $gaji = $item['gaji'];
                        $pegawai = $gaji->pegawai;
                    @endphp
                    <tr>
                        <td class="text-center">{{ $index + 1 }}</td>
                        <td>{{ $pegawai->nip ?? '-' }}</td>
                        <td>
                            <strong>{{ $pegawai->nama_lengkap }}</strong>
                            <br>
                            <small class="text-muted">{{ $pegawai->jabatan ?? '-' }}</small>
                        </td>
                        <td class="text-center">
                            <span class="badge bg-success">{{ $item['jumlah_hadir'] }}</span>
                        </td>
                        <td class="text-center">
                            <span class="badge bg-info">{{ $item['jumlah_izin'] }}</span>
                        </td>
                        <td class="text-center">
                            <span class="badge bg-warning">{{ $item['jumlah_sakit'] }}</span>
                        </td>
                        <td class="text-center">
                            <span class="badge bg-primary">{{ $item['jumlah_cuti'] }}</span>
                        </td>
                        <td class="text-center">
                            <span class="badge bg-danger">{{ $item['jumlah_alpha'] }}</span>
                        </td>
                        <td class="text-center">
                            <strong>{{ $item['total_hari_cuti'] }}</strong>
                        </td>
                        <td class="text-center">
                            @if($item['denda_cuti'] > 0)
                                <span class="badge bg-danger">Rp {{ number_format($item['denda_cuti'], 0, ',', '.') }}</span>
                            @else
                                <span class="text-muted">-</span>
                            @endif
                        </td>
                        <td class="text-center">
                            <span class="text-danger">Rp {{ number_format($gaji->potongan_absensi, 0, ',', '.') }}</span>
                        </td>
                        <td class="text-center">
                            <strong class="text-success">Rp {{ number_format($gaji->total_gaji, 0, ',', '.') }}</strong>
                        </td>
                    </tr>
                    @endforeach
                </tbody>
                <tfoot class="table-light">
                    <tr>
                        <th colspan="3" class="text-end">TOTAL:</th>
                        <th class="text-center">{{ collect($laporan)->sum('jumlah_hadir') }}</th>
                        <th class="text-center">{{ collect($laporan)->sum('jumlah_izin') }}</th>
                        <th class="text-center">{{ collect($laporan)->sum('jumlah_sakit') }}</th>
                        <th class="text-center">{{ collect($laporan)->sum('jumlah_cuti') }}</th>
                        <th class="text-center">{{ collect($laporan)->sum('jumlah_alpha') }}</th>
                        <th class="text-center">{{ collect($laporan)->sum('total_hari_cuti') }}</th>
                        <th class="text-center">Rp {{ number_format(collect($laporan)->sum('denda_cuti'), 0, ',', '.') }}</th>
                        <th class="text-center">Rp {{ number_format(collect($laporan)->sum(function($item) { return $item['gaji']->potongan_absensi; }), 0, ',', '.') }}</th>
                        <th class="text-center">Rp {{ number_format(collect($laporan)->sum(function($item) { return $item['gaji']->total_gaji; }), 0, ',', '.') }}</th>
                    </tr>
                </tfoot>
            </table>
        </div>
    </div>
</div>
@else
<div class="card">
    <div class="card-body text-center py-5">
        <i class="bi bi-inbox fs-1 text-muted d-block mb-3"></i>
        <h5 class="text-muted">Tidak ada data laporan</h5>
        <p class="text-muted">Tidak ada data gaji untuk periode yang dipilih.</p>
    </div>
</div>
@endif
@endsection