@extends('layouts.master')

@section('title', 'Laporan Rekap Tagihan Tahunan')
@section('page-title', 'Laporan Rekapitulasi Tagihan per Pelanggan per Tahun')

@section('content')
    @php
        $shortK = function ($amount) {
            $n = (float) $amount;
            if ($n >= 1000) {
                $v = $n / 1000;
                $txt = number_format($v, 1, ',', '.');
                $txt = preg_replace('/,0$/', '', $txt);
                return $txt . 'k';
            }
            return number_format($n, 0, ',', '.');
        };
    @endphp
    <style>
        .card-soft {
            border-radius: 14px;
            border: 0;
            box-shadow: 0 8px 24px rgba(15, 23, 42, .06);
        }

        .text-mono {
            font-family: ui-monospace, SFMono-Regular, Menlo, Monaco, Consolas,
                "Liberation Mono", "Courier New", monospace;
        }

        .table-sticky thead th {
            position: sticky;
            top: 0;
            z-index: 5;
            background: #f9fafb;
        }

        .table-scroll-x {
            overflow-x: auto;
        }

        .paid-date-subtle {
            font-size: .7rem;
            line-height: 1.1;
            color: #9aa3af !important;
            letter-spacing: .02em;
        }

        .month-total-stack {
            line-height: 1.2;
            font-size: .72rem;
        }

        .month-total-stack .line {
            display: flex;
            justify-content: flex-end;
            gap: .25rem;
            white-space: nowrap;
        }

        @media (max-width: 767.98px) {
            .table-scroll-x {
                font-size: .8rem;
            }

            .paid-date-subtle {
                font-size: .66rem;
            }

            .month-total-stack {
                font-size: .68rem;
            }
        }
    </style>

    <div class="d-flex justify-content-between align-items-center mb-3">
        <div>
            <h4 class="mb-1">Rekap Tagihan Tahunan</h4>
            <small class="text-muted">
                Rekap tagihan per pelanggan per bulan untuk tahun {{ $tahun }}.
            </small>
        </div>
        <a href="{{ route('internet.dashboard') }}" class="btn btn-light d-none d-md-inline-flex">
            <i class="bx bx-chevron-left"></i> Kembali ke Dashboard
        </a>
    </div>

    {{-- Filter Tahun --}}
    <form method="get" class="row g-2 mb-3">
        <div class="col-md-3">
            <label class="form-label mb-0">Tahun</label>
            <select name="tahun" class="form-select">
                @foreach ($tahunOptions as $th)
                    <option value="{{ $th }}" @selected($th == $tahun)>{{ $th }}</option>
                @endforeach
            </select>
        </div>
        <div class="col-md-3 d-flex align-items-end">
            <button class="btn btn-outline-primary me-2">
                <i class="bx bx-filter-alt"></i> Tampilkan
            </button>
            <a href="{{ route('internet.laporan.rekap-tagihan-tahunan') }}" class="btn btn-outline-secondary">
                Reset
            </a>
        </div>
    </form>

    {{-- Info ringkas --}}
    <div class="row g-2 mb-3">
        <div class="col-md-4">
            <div class="card card-soft">
                <div class="card-body py-2">
                    <div class="small text-muted">Total Tagihan Tahun {{ $tahun }}</div>
                    <div class="h5 mb-0 text-mono">
                        {{ $shortK($grandTotalTagihan) }}
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card card-soft">
                <div class="card-body py-2">
                    <div class="small text-muted">Total Terbayar</div>
                    <div class="h5 mb-0 text-mono text-success">
                        {{ $shortK($grandTotalTerbayar) }}
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            @php $isPlus = $grandTotalSisa <= 0; @endphp
            <div class="card card-soft">
                <div class="card-body py-2">
                    <div class="small text-muted">Total Sisa Tagihan</div>
                    <div class="h5 mb-0 text-mono {{ $isPlus ? 'text-success' : 'text-danger' }}">
                        {{ $shortK($grandTotalSisa) }}
                    </div>
                </div>
            </div>
        </div>
    </div>

    {{-- Tabel Rekap --}}
    <div class="card card-soft">
        <div class="card-body">
            <div class="table-scroll-x">
                <table class="table table-sm align-middle mb-0 table-sticky">
                    <thead>
                        <tr>
                            <th style="min-width: 120px;">Kode</th>
                            <th style="min-width: 180px;">Pelanggan</th>
                            <th class="text-end">Jan</th>
                            <th class="text-end">Feb</th>
                            <th class="text-end">Mar</th>
                            <th class="text-end">Apr</th>
                            <th class="text-end">Mei</th>
                            <th class="text-end">Jun</th>
                            <th class="text-end">Jul</th>
                            <th class="text-end">Agu</th>
                            <th class="text-end">Sep</th>
                            <th class="text-end">Okt</th>
                            <th class="text-end">Nov</th>
                            <th class="text-end">Des</th>
                            <th class="text-end">Total Tagihan</th>
                            <th class="text-end">Total Terbayar</th>
                            <th class="text-end">Sisa / Status</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php
                            $currentKec = null;
                            $currentDesa = null;
                        @endphp

                        @forelse ($rows as $row)
                            @php
                                $p = $row['pelanggan'];
                                $perBulan = $row['per_bulan'];
                                $detailBln = $row['per_bulan_detail'] ?? [];
                                $totalSisa = $row['total_sisa'] ?? 0;
                                $rowLunas = $totalSisa <= 0;

                                $kec = $p->kecamatan ?? 'Tanpa Kecamatan';
                                $des = $p->desa ?? 'Tanpa Desa/Kelurahan';
                            @endphp

                            {{-- HEADER GRUP: tampil jika kecamatan/desa berganti --}}
                            @if ($currentKec !== $kec || $currentDesa !== $des)
                                <tr class="table-secondary">
                                    <td colspan="17">
                                        <strong>{{ $kec }}</strong>
                                        @if ($des)
                                            <span class="text-muted"> &raquo; {{ $des }}</span>
                                        @endif
                                    </td>
                                </tr>
                                @php
                                    $currentKec = $kec;
                                    $currentDesa = $des;
                                @endphp
                            @endif

                            {{-- baris data pelanggan --}}
                            <tr>
                                <td class="text-mono">
                                    {{ $p->kode_pelanggan ?? '-' }}
                                </td>
                                <td>
                                    {{ $p->nama ?? '-' }}<br>
                                    <small class="text-muted">
                                        {{ $p->paketInternet->nama ?? 'Tanpa paket' }}
                                    </small>
                                </td>

                                {{-- Kolom Jan–Des: warna + link ke detail per bulan --}}
                                @for ($m = 1; $m <= 12; $m++)
                                    @php
                                        $det = $detailBln[$m] ?? ['tagihan' => 0, 'terbayar' => 0, 'sisa' => 0, 'last_paid_at' => null];
                                        $nilai = (float) ($det['tagihan'] ?? 0);
                                        $terbayar = (float) ($det['terbayar'] ?? 0);
                                        $sisaBln = (float) ($det['sisa'] ?? max(0, $nilai - $terbayar));
                                        $lastPaidAtBln = $det['last_paid_at'] ?? null;
                                        $adaTagihan = $nilai > 0;
                                        $lunasBln = $adaTagihan && $sisaBln <= 0;

                                        $cellClass = '';
                                        $statusTitle = 'Tidak ada tagihan';

                                        if ($adaTagihan) {
                                            if ($lunasBln) {
                                                $cellClass = 'bg-success-subtle text-success';
                                                $statusTitle = 'Lunas';
                                            } else {
                                                $cellClass = 'bg-warning-subtle text-warning';
                                                $statusTitle = 'Belum lunas';
                                            }
                                        }

                                        $detailUrl = $adaTagihan
                                            ? route('internet.laporan.rekap-tagihan-tahunan.detail', [
                                                'pelanggan' => $p->id,
                                                'tahun' => $tahun,
                                                'bulan' => $m,
                                            ])
                                            : null;
                                    @endphp

                                    <td class="text-end text-mono {{ $cellClass }}"
                                        @if ($adaTagihan) title="{{ $statusTitle }}" @endif>
                                        @if ($adaTagihan && $detailUrl)
                                            <a href="{{ $detailUrl }}"
                                                class="d-block text-decoration-none {{ $lunasBln ? 'text-success' : 'text-warning' }}">
                                                {{ $shortK($nilai) }}
                                            </a>
                                            @if ($lunasBln && !empty($lastPaidAtBln))
                                                <small class="d-block fw-normal paid-date-subtle">
                                                    {{ \Carbon\Carbon::parse($lastPaidAtBln)->translatedFormat('d-M') }}
                                                </small>
                                            @endif
                                        @else
                                            -
                                        @endif
                                    </td>
                                @endfor

                                <td class="text-end text-mono">
                                    {{ $shortK($row['total_tagihan']) }}
                                </td>
                                <td class="text-end text-mono">
                                    {{ $shortK($row['total_terbayar']) }}
                                </td>
                                <td class="text-end text-mono">
                                    @php $isLunas = $totalSisa <= 0; @endphp
                                    <div class="mb-1">
                                        <span
                                            class="badge {{ $isLunas ? 'bg-success-subtle text-success' : 'bg-danger-subtle text-danger' }}">
                                            {{ $isLunas ? 'LUNAS (TAHUNAN)' : 'BELUM LUNAS (TAHUNAN)' }}
                                        </span>
                                    </div>
                                    <div class="{{ $isLunas ? 'text-success' : 'text-danger' }}">
                                        {{ $shortK($totalSisa) }}
                                    </div>
                                </td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="17" class="text-center text-muted">
                                    Belum ada data tagihan untuk tahun ini.
                                </td>
                            </tr>
                        @endforelse
                    </tbody>


                    @if ($rows->count())
                        <tfoot>
                            <tr class="fw-semibold">
                                <td colspan="2" class="text-end">TOTAL</td>
                                @for ($m = 1; $m <= 12; $m++)
                                    <td class="text-end text-mono">
                                        @php
                                            $d = $grandPerBulanDetail[$m] ?? ['tagihan' => 0, 'terbayar' => 0, 'sisa' => 0];
                                            $vTagihan = (float) ($d['tagihan'] ?? 0);
                                            $vTerbayar = (float) ($d['terbayar'] ?? 0);
                                            $vSisa = (float) ($d['sisa'] ?? 0);
                                        @endphp
                                        <div class="month-total-stack">
                                            <div class="line" title="Total">{{ $shortK($vTagihan) }}</div>
                                            <div class="line text-success" title="Lunas">{{ $shortK($vTerbayar) }}</div>
                                            <div class="line {{ $vSisa > 0 ? 'text-danger' : 'text-success' }}" title="Sisa">
                                                {{ $shortK($vSisa) }}
                                            </div>
                                        </div>
                                    </td>
                                @endfor
                                <td class="text-end text-mono">
                                    {{ $shortK($grandTotalTagihan) }}
                                </td>
                                <td class="text-end text-mono">
                                    {{ $shortK($grandTotalTerbayar) }}
                                </td>
                                <td class="text-end text-mono {{ $grandTotalSisa > 0 ? 'text-danger' : 'text-success' }}">
                                    {{ $shortK($grandTotalSisa) }}
                                </td>
                            </tr>
                        </tfoot>
                    @endif
                </table>
            </div>
        </div>
    </div>
@endsection

@section('scripts')
    {{-- <script src="{{ asset('build/js/app.js') }}"></script> --}}
@endsection