{{-- resources/views/yayasan/transaksi/approval/index.blade.php --}}

@extends('layouts.app')

@section('title', 'Daftar Realisasi Anggaran')

@section('content')
<div class="nk-content nk-content-fluid">
    <div class="container-xl wide-xl">
        <div class="nk-content-inner">
            <div class="nk-content-body">
                <div class="nk-block-head nk-block-head-sm">
                    <div class="nk-block-between">
                        <div class="nk-block-head-content">
                            <h3 class="nk-block-title page-title">Daftar Realisasi Anggaran</h3>
                            <div class="nk-block-des text-soft">
                                <p>Manajemen data realisasi anggaran transaksi.</p>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="mb-4">
                    <div class="row align-items-center justify-content-between">
                         <div class="col-md-6 mb-3 mb-md-0">
                           @if(Auth::check() && (Auth::user()->role_id === 2  || Auth::user()->role_id === 1))
                            <button type="button" class="btn btn-info" id="syncBtn" onclick="handleSync()">
                                <em class="icon ni ni-reload me-1"></em>
                                <span>Sinkronisasi Data</span>
                            </button>
                            @endif
                        </div>
                    </div>
                </div>

                {{-- Filter Section --}}
                <div class="card card-bordered mb-4">
                    <div class="card-inner">
                        <form method="GET" class="row g-3">
                            <div class="col-md-2">
                                <label class="form-label">Tahun</label>
                                <div class="form-control-wrap">
                                    <select name="tahun" class="form-select js-select2">
                                        @foreach($tahunList as $th)
                                        <option value="{{ $th }}" {{ $selectedTahun == $th ? 'selected' : '' }}>
                                            {{ $th }}
                                        </option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-4">
                                 <label class="form-label">Unit</label>
                                <div class="form-control-wrap">
                                    <select name="unit" class="form-select js-select2">
                                        <option value="">-- Semua Unit --</option>
                                        @foreach($units as $unit)
                                        <option value="{{ $unit->kode_unit }}" {{ $selectedUnit == $unit->kode_unit ? 'selected' : '' }}>
                                            {{ $unit->nama_unit }}
                                        </option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-4">
                                 <label class="form-label">Bulan</label>
                                 <div class="form-control-wrap">
                                    <select name="bulan" class="form-select js-select2">
                                        <option value="">-- Semua Bulan --</option>
                                        @for ($i = 1; $i <= 12; $i++)
                                        <option value="{{ $i }}" {{ $selectedBulan == $i ? 'selected' : '' }}>
                                            {{ \Carbon\Carbon::create()->month($i)->translatedFormat('F') }}
                                        </option>
                                        @endfor
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-2 d-flex align-items-end">
                                <button class="btn btn-primary w-100" type="submit">
                                    <em class="icon ni ni-filter me-1"></em> Filter
                                </button>
                            </div>
                        </form>
                    </div>
                </div>

                <div class="nk-block">
                    <div class="card card-preview">
                        <div class="card-inner border-bottom">
                            <div class="card-title-group">
                                <div class="card-title">
                                    <h5 class="title">Daftar Realisasi Anggaran</h5>
                                </div>
                            </div>
                        </div>
                        <div class="table-responsive">
                            <table class="table table-custom">
                                <thead>
                                    <tr>
                                        <th width="5%" class="text-center">No</th>
                                        <th>Bulan</th>
                                        <th>Nomor Referensi</th>
                                        <th>Unit</th>
                                        <th class="text-end">Total Ajuan</th>
                                        <th class="text-end">Total Realisasi</th>
                                        <th class="text-end">Sisa</th>
                                        <th class="text-center" width="15%">Status Realisasi</th>
                                        <th class="text-center" width="10%">Aksi</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                    $no = ($realisasiAnggarans->currentPage() - 1) * $realisasiAnggarans->perPage() + 1;
                                    @endphp
                                    @forelse ($realisasiAnggarans as $realisasiAnggaran)
                                    <tr>
                                        <td class="text-center">{{ $no++ }}</td>
                                        <td>
                                            @php
                                            $bulan = $realisasiAnggaran->bulan_transaksi;
                                            $namaBulan = $bulan ? \Carbon\Carbon::create()->month((int)$bulan)->translatedFormat('F') : '-';
                                            @endphp
                                            {{ $namaBulan }}
                                        </td>
                                        <td>
                                            <span class="badge badge-dim bg-outline-primary">{{ $realisasiAnggaran->no_referensi }}</span>
                                        </td>
                                        <td>
                                            {{ $realisasiAnggaran->unit->nama_unit ?? 'Tidak Diketahui' }}
                                        </td>
                                        <td class="text-end fw-bold">
                                            @if ($realisasiAnggaran->no_pagu_data)
                                                <span class="text-muted">-</span>
                                                <span class="badge badge-dim bg-outline-warning ms-1" title="Tidak ada data anggaran bulanan di RKAS">Tidak ada pagu</span>
                                            @else
                                                {{ number_format($realisasiAnggaran->sum_nominal_ajuan, 0, ',', '.') }}
                                            @endif
                                        </td>
                                        <td class="text-end fw-bold text-success">
                                            {{ number_format($realisasiAnggaran->sum_nominal_realisasi, 0, ',', '.') }}
                                        </td>
                                        <td class="text-end">
                                            @if ($realisasiAnggaran->no_pagu_data)
                                                <span class="badge bg-warning text-dark">Melebihi Ajuan</span>
                                            @else
                                                <span class="fw-bold {{ $realisasiAnggaran->sisa > 0 ? 'text-danger' : 'text-success' }}">
                                                    {{ number_format($realisasiAnggaran->sisa, 0, ',', '.') }}
                                                </span>
                                            @endif
                                        </td>

                                        <td class="text-center">
                                         @if($realisasiAnggaran->sum_nominal_ajuan > 0 || $realisasiAnggaran->sum_nominal_realisasi > 0)
                                             @if (!$realisasiAnggaran->is_finish_fill_realisasi)
                                             <span class="text-muted">-</span>
                                             @else
                                             <span class="badge bg-success">Realisasi Lengkap</span>
                                             @endif
                                             
                                             @if($realisasiAnggaran->tipe_transaksi == 'kas_bon_pengeluaran_kas')
                                                 @if (!$realisasiAnggaran->is_finish_fill_pengembalian)
                                                 <div class="mt-1"><span class="badge bg-warning text-dark">Belum Kembali</span></div>
                                                 @else
                                                  <div class="mt-1"><span class="badge bg-success">Sudah Kembali</span></div>
                                                 @endif
                                             @endif
                                         @else
                                             <span class="text-muted">-</span>
                                         @endif
                                     </td>
                                    <td class="text-center">
                                        <div class="d-flex justify-content-center">
                                            @if($realisasiAnggaran->sum_nominal_ajuan > 0 || $realisasiAnggaran->sum_nominal_realisasi > 0)
                                            <a href="{{ route('yayasan.transaksi.realisasi-anggaran.show', $realisasiAnggaran->id) }}" class="btn-action btn-action-view" title="Lihat Detail">
                                                <em class="icon ni ni-eye"></em>
                                            </a>
                                            @else
                                            <span class="text-muted">-</span>
                                            @endif
                                        </div>
                                    </td>
                                </tr>
                                @empty
                                <tr>
                                    <td colspan="9" class="text-center p-4 text-muted">
                                        Tidak ada data realisasi anggaran transaksi.
                                    </td>
                                </tr>
                                @endforelse
                                </tbody>
                            </table>
                        </div>
                
                        <div class="d-flex justify-content-end p-3 border-top">
                            {{ $realisasiAnggarans->appends(request()->query())->links('pagination::bootstrap-4') }}
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@push('scripts')
<script>
    document.addEventListener('DOMContentLoaded', function() {
        const successAlert = document.getElementById('success-alert');
        const errorAlert = document.getElementById('error-alert');

        if (successAlert) {
            setTimeout(function() {
                successAlert.style.display = 'none';
            }, 5000);
        }

        if (errorAlert) {
            setTimeout(function() {
                errorAlert.style.display = 'none';
            }, 5000);
        }
    });

    function handleSync() {
        Swal.fire({
            title: 'Konfirmasi Sinkronisasi',
            text: 'Apakah Anda yakin ingin melakukan sinkronisasi data? Proses ini mungkin memakan waktu beberapa menit.',
            icon: 'question',
            showCancelButton: true,
            confirmButtonColor: '#3085d6',
            cancelButtonColor: '#d33',
            confirmButtonText: 'Ya, Sinkronisasi!',
            cancelButtonText: 'Batal'
        }).then((result) => {
            if (result.isConfirmed) {
                performSync();
            }
        });
    }

    function performSync() {
        const syncBtn = document.getElementById('syncBtn');
        const originalText = syncBtn.innerHTML;
        const limit = 80;
        const resumeKey = 'realisasi_sync_offset';
        const savedOffset = parseInt(localStorage.getItem(resumeKey), 10);
        let offset = Number.isFinite(savedOffset) && savedOffset >= 0 ? savedOffset : 0;
        let completedChunks = 0;
        const maxRetry = 3;

        const wait = (ms) => new Promise(resolve => setTimeout(resolve, ms));
        const isRetryableStatus = (status) => [429, 502, 503, 504].includes(status);

            // Show loading state
            syncBtn.innerHTML = '<em class="icon ni ni-reload"></em><span>Memproses...</span>';
            syncBtn.disabled = true;
            syncBtn.classList.add('disabled');

            // Show SweetAlert loading
            Swal.fire({
                title: 'Memproses Sinkronisasi...',
                html: `Menghubungkan ke server Sub-Keu...<br><small>Mulai dari offset: <b>${offset}</b></small>`,
                icon: 'info',
                allowOutsideClick: false,
                allowEscapeKey: false,
                showConfirmButton: false,
                didOpen: () => {
                    Swal.showLoading();
                }
            });

            const runSyncChunk = async () => {
                while (true) {
                    const warmupParam = (offset === 0) ? '&warmup=1' : '';
                    const url = `/web-clean-and-resync?action=sync_realisasi&limit=${limit}&offset=${offset}${warmupParam}&t=${Date.now()}`;
                    let response = null;
                    let retryCount = 0;

                    while (retryCount <= maxRetry) {
                        response = await fetch(url, {
                            method: 'GET',
                            headers: {
                                'X-Requested-With': 'XMLHttpRequest',
                                'Accept': 'application/json'
                            }
                        });

                        if (response.ok) {
                            break;
                        }

                        if (!isRetryableStatus(response.status) || retryCount === maxRetry) {
                            throw new Error(`HTTP error! status: ${response.status} pada offset ${offset}`);
                        }

                        retryCount++;
                        Swal.update({
                            title: 'Memproses Sinkronisasi...',
                            html: `Offset: <b>${offset}</b><br>Server Sub-Keu merespon lambat (${response.status}), mencoba ulang ${retryCount}/${maxRetry}...`,
                            icon: 'warning'
                        });
                        await wait(1500 * retryCount);
                    }

                    const data = await response.json();
                    if (data.status !== 'success') {
                        throw new Error((data.message || 'Sinkronisasi gagal pada chunk.') + ` (offset ${offset})`);
                    }

                    const total = data.total ?? 0;
                    const processed = data.processed ?? 0;
                    const nextOffset = data.next_offset;
                    completedChunks++;
                    if (nextOffset !== null) {
                        localStorage.setItem(resumeKey, String(nextOffset));
                    } else {
                        localStorage.removeItem(resumeKey);
                    }

                    const currentProcessed = Math.min(total, offset + processed);
                    const percent = total > 0 ? Math.min(100, Math.round((currentProcessed / total) * 100)) : 0;
                    window.lastTotalProcessed = total;

                    Swal.update({
                        title: 'Memproses Sinkronisasi...',
                        html: `
                            <div class="progress mb-2" style="height: 14px; border-radius: 6px;">
                                <div class="progress-bar progress-bar-striped progress-bar-animated bg-primary" role="progressbar" style="width: ${percent}%; font-size: 10px; font-weight: bold; line-height: 14px;">${percent}%</div>
                            </div>
                            <small class="text-muted">Memproses <b>${currentProcessed.toLocaleString('id-ID')}</b> dari <b>${total.toLocaleString('id-ID')}</b> data realisasi (Chunk #${completedChunks})</small>
                        `,
                        icon: 'info'
                    });

                    if (nextOffset === null) {
                        await wait(500);
                        break;
                    }

                    offset = nextOffset;
                }
            };

            runSyncChunk()
                .then(() => {
                    syncBtn.innerHTML = originalText;
                    syncBtn.disabled = false;
                    syncBtn.classList.remove('disabled');

                    Swal.fire({
                        title: 'Berhasil!',
                        text: `Sinkronisasi selesai diproses bertahap. Total data realisasi yang diperbarui: ${window.lastTotalProcessed || 0} baris.`,
                        icon: 'success',
                        confirmButtonText: 'OK'
                    }).then(() => {
                        window.location.reload();
                    });
                })
                .catch(error => {
                    syncBtn.innerHTML = originalText;
                    syncBtn.disabled = false;
                    syncBtn.classList.remove('disabled');

                    console.error('Error:', error);
                    Swal.fire({
                        title: 'Error!',
                        text: (error.message || 'Terjadi kesalahan saat sinkronisasi. Silakan coba lagi.') + `. Anda bisa klik sinkronisasi lagi untuk lanjut dari offset terakhir (${offset}).`,
                        icon: 'error',
                        confirmButtonText: 'OK'
                    });
                });
        }

    </script>
    @endpush