@extends('layouts.app')

@section('content')
<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">Audit Konsistensi Data</h3>
            <p class="text-soft">Cek aliran uang yang tercatat: realisasi &rarr; jurnal_entry &rarr; saldo akun.</p>
        </div>
    </div>
</div>

{{-- Filter --}}
<div class="card mb-4">
    <div class="card-body">
        <form method="GET" class="row g-2 align-items-end">
            <div class="col-md-3">
                <label class="form-label">Scope Audit Saldo</label>
                <select name="saldo_scope" class="form-select">
                    <option value="kas" {{ $saldoScope === 'kas' ? 'selected' : '' }}>Akun Kas Saja</option>
                    <option value="all" {{ $saldoScope === 'all' ? 'selected' : '' }}>Semua Akun</option>
                </select>
            </div>
            <div class="col-md-7">
                <label class="form-label">Trace Akun Kas</label>
                <select name="akun_id" class="form-select">
                    @foreach($kasAccounts as $account)
                    <option value="{{ $account->kode_akun }}" {{ (string) $selectedAkunId === (string) $account->kode_akun ? 'selected' : '' }}>
                        {{ $account->kode_akun }} - {{ $account->nama_akun }}{{ $account->nama_unit ? ' | ' . $account->nama_unit : '' }}
                    </option>
                    @endforeach
                </select>
            </div>
            <div class="col-md-2 d-grid">
                <button class="btn btn-primary"><em class="icon ni ni-filter"></em> Terapkan</button>
            </div>
        </form>
    </div>
</div>

{{-- Ringkasan Status --}}
<div class="row g-gs mb-4">
    <div class="col-6 col-md-2">
        <div class="card card-bordered h-100 text-center">
            <div class="card-inner">
                <div class="fs-6 text-soft">Transaksi Bermasalah</div>
                <div class="fs-2 fw-bold {{ $summary->mismatch_transaksi > 0 ? 'text-danger' : 'text-success' }}">{{ number_format($summary->mismatch_transaksi) }}</div>
            </div>
        </div>
    </div>
    <div class="col-6 col-md-2">
        <div class="card card-bordered h-100 text-center">
            <div class="card-inner">
                <div class="fs-6 text-soft">Saldo Tidak Cocok</div>
                <div class="fs-2 fw-bold {{ $summary->mismatch_saldo > 0 ? 'text-danger' : 'text-success' }}">{{ number_format($summary->mismatch_saldo) }}</div>
            </div>
        </div>
    </div>
    <div class="col-6 col-md-2">
        <div class="card card-bordered h-100 text-center">
            <div class="card-inner">
                <div class="fs-6 text-soft">Orphan Detail</div>
                <div class="fs-2 fw-bold {{ $summary->orphan_detail > 0 ? 'text-danger' : 'text-success' }}">{{ number_format($summary->orphan_detail) }}</div>
            </div>
        </div>
    </div>
    <div class="col-6 col-md-2">
        <div class="card card-bordered h-100 text-center">
            <div class="card-inner">
                <div class="fs-6 text-soft">Orphan Jurnal</div>
                <div class="fs-2 fw-bold {{ $summary->orphan_jurnal > 0 ? 'text-danger' : 'text-success' }}">{{ number_format($summary->orphan_jurnal) }}</div>
            </div>
        </div>
    </div>
    <div class="col-md-4">
        <div class="card card-bordered h-100">
            <div class="card-inner">
                <div class="row text-center g-2">
                    <div class="col-6">
                        <div class="fs-6 text-soft">Total Realisasi</div>
                        <div class="fs-5 fw-bold">{{ number_format($summary->total_nominal_detail, 0, ',', '.') }}</div>
                    </div>
                    <div class="col-6">
                        <div class="fs-6 text-soft">Total Debit Jurnal</div>
                        <div class="fs-5 fw-bold {{ abs($summary->total_nominal_detail - $summary->total_debit) < 0.01 ? 'text-success' : 'text-danger' }}">{{ number_format($summary->total_debit, 0, ',', '.') }}</div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

{{-- Rekonsiliasi Total --}}
<div class="card card-preview mb-4">
    <div class="card-inner border-bottom"><h5 class="title mb-0">Rekonsiliasi Total</h5></div>
    <div class="table-responsive">
        <table class="table table-bordered mb-0">
            <thead>
                <tr>
                    <th>Pemeriksaan</th>
                    <th class="text-end">Nilai A</th>
                    <th class="text-end">Nilai B</th>
                    <th class="text-end">Selisih</th>
                    <th>Status</th>
                </tr>
            </thead>
            <tbody>
                <tr>
                    <td><strong>Debit vs Kredit Jurnal</strong><br><small class="text-muted">Jurnal harus balance</small></td>
                    <td class="text-end">{{ number_format($summary->total_debit, 0, ',', '.') }}</td>
                    <td class="text-end">{{ number_format($summary->total_kredit, 0, ',', '.') }}</td>
                    <td class="text-end">{{ number_format($summary->total_debit - $summary->total_kredit, 0, ',', '.') }}</td>
                    <td><span class="badge {{ abs($summary->total_debit - $summary->total_kredit) < 0.01 ? 'bg-success' : 'bg-danger' }}">{{ abs($summary->total_debit - $summary->total_kredit) < 0.01 ? 'BALANCE' : 'TIDAK BALANCE' }}</span></td>
                </tr>
                <tr>
                    <td><strong>Realisasi Detail vs Debit Jurnal</strong><br><small class="text-muted">Semua realisasi sudah dijurnalkan?</small></td>
                    <td class="text-end">{{ number_format($summary->total_nominal_detail, 0, ',', '.') }}</td>
                    <td class="text-end">{{ number_format($summary->total_debit, 0, ',', '.') }}</td>
                    <td class="text-end">{{ number_format($summary->total_nominal_detail - $summary->total_debit, 0, ',', '.') }}</td>
                    <td><span class="badge {{ abs($summary->total_nominal_detail - $summary->total_debit) < 0.01 ? 'bg-success' : 'bg-danger' }}">{{ abs($summary->total_nominal_detail - $summary->total_debit) < 0.01 ? 'COCOK' : 'TIDAK COCOK' }}</span></td>
                </tr>
                <tr>
                    <td><strong>Trace Akun Kas Terpilih vs Saldo</strong><br><small class="text-muted">{{ $selectedAccount ? $selectedAccount->kode_akun . ' - ' . $selectedAccount->nama_akun : '-' }}</small></td>
                    <td class="text-end">{{ number_format($summary->selected_account_expected, 0, ',', '.') }}</td>
                    <td class="text-end">{{ number_format($summary->selected_account_actual, 0, ',', '.') }}</td>
                    <td class="text-end">{{ number_format($summary->selected_account_delta, 0, ',', '.') }}</td>
                    <td><span class="badge {{ abs($summary->selected_account_delta) < 0.01 ? 'bg-success' : 'bg-danger' }}">{{ abs($summary->selected_account_delta) < 0.01 ? 'COCOK' : 'TIDAK COCOK' }}</span></td>
                </tr>
            </tbody>
        </table>
    </div>
</div>

{{-- Transaksi Bermasalah --}}
<div class="card card-preview mb-4">
    <div class="card-inner border-bottom d-flex justify-content-between align-items-start flex-wrap gap-2">
        <div>
            <h5 class="title mb-0">Transaksi Bermasalah
                <span class="badge bg-danger ms-2">{{ $transaksiMismatches->count() }}</span>
            </h5>
            <small class="text-muted">Hanya transaksi yang sudah ada realisasinya namun jumlah tidak cocok dengan jurnal.</small>
        </div>
        @if($transaksiMismatches->count() > 0)
        <div>
            <button type="button" class="btn btn-warning btn-sm" id="btnFixPreview">
                <em class="icon ni ni-tool"></em> Fix Otomatis
            </button>
        </div>
        @endif
    </div>
    <div class="table-responsive">
        <table class="table table-bordered table-sm align-middle mb-0">
            <thead class="table-light">
                <tr>
                    <th>Tanggal</th>
                    <th>No Referensi</th>
                    <th>Tipe</th>
                    <th>Unit</th>
                    <th class="text-end">Realisasi</th>
                    <th class="text-end">Debit Jurnal</th>
                    <th class="text-end">Kredit Jurnal</th>
                    <th>Status</th>
                </tr>
            </thead>
            <tbody>
                @forelse($transaksiMismatches as $row)
                <tr>
                    <td class="text-nowrap">{{ \Carbon\Carbon::parse($row->tanggal)->format('d/m/Y') }}</td>
                    <td><div class="fw-bold">{{ $row->no_referensi }}</div><small class="text-muted">ID #{{ $row->transaksi_id }}</small></td>
                    <td><span class="badge bg-outline-secondary">{{ $row->tipe_transaksi }}</span></td>
                    <td>{{ $row->nama_unit ?: $row->unit_id }}</td>
                    <td class="text-end">{{ number_format($row->total_nominal_detail, 0, ',', '.') }}</td>
                    <td class="text-end {{ abs($row->delta_detail_debit ?? 0) >= 0.01 ? 'text-danger fw-bold' : '' }}">{{ number_format($row->total_debit, 0, ',', '.') }}</td>
                    <td class="text-end {{ abs($row->delta_detail_kredit ?? 0) >= 0.01 ? 'text-danger fw-bold' : '' }}">{{ number_format($row->total_kredit, 0, ',', '.') }}</td>
                    <td><span class="badge bg-danger">{{ $row->status_audit }}</span></td>
                </tr>
                @empty
                <tr><td colspan="8" class="text-center text-muted py-4"><em class="icon ni ni-check-circle text-success"></em> Semua transaksi yang terealisasi sudah terjurnal dengan benar.</td></tr>
                @endforelse
            </tbody>
        </table>
    </div>
</div>

{{-- Saldo Akun Tidak Cocok --}}
<div class="card card-preview mb-4">
    <div class="card-inner border-bottom">
        <h5 class="title mb-0">Saldo Akun Tidak Cocok
            <span class="badge bg-danger ms-2">{{ $saldoMismatches->count() }}</span>
        </h5>
        <small class="text-muted">Saldo di tabel akun vs total mutasi (debit - kredit) dari jurnal_entry.</small>
    </div>
    <div class="table-responsive">
        <table class="table table-bordered table-sm align-middle mb-0">
            <thead class="table-light">
                <tr>
                    <th>Kode Akun</th>
                    <th>Nama Akun</th>
                    <th>Unit</th>
                    <th class="text-end">Saldo Tersimpan</th>
                    <th class="text-end">Expected (Jurnal)</th>
                    <th class="text-end">Selisih</th>
                </tr>
            </thead>
            <tbody>
                @forelse($saldoMismatches as $row)
                <tr>
                    <td><code>{{ $row->kode_akun }}</code></td>
                    <td>{{ $row->nama_akun }}</td>
                    <td>{{ $row->nama_unit ?: $row->unit_id ?: '-' }}</td>
                    <td class="text-end">{{ number_format($row->saldo_akun, 0, ',', '.') }}</td>
                    <td class="text-end">{{ number_format($row->expected_saldo, 0, ',', '.') }}</td>
                    <td class="text-end text-danger fw-bold">{{ number_format($row->delta_saldo, 0, ',', '.') }}</td>
                </tr>
                @empty
                <tr><td colspan="6" class="text-center text-muted py-4"><em class="icon ni ni-check-circle text-success"></em> Semua saldo akun sesuai dengan jurnal.</td></tr>
                @endforelse
            </tbody>
        </table>
    </div>
</div>

{{-- Fix Form & Success Alert --}}
@if(session('fix_success'))
<div class="alert alert-success alert-dismissible fade show mb-4">
    <em class="icon ni ni-check-circle"></em> {{ session('fix_success') }}
    <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
</div>
@endif

<form id="formFix" method="POST" action="{{ route('yayasan.transaksi.audit-konsistensi.fix') }}" class="d-none">
    @csrf
    <input type="hidden" name="confirm" value="1">
</form>

@push('scripts')
<script>
document.getElementById('btnFixPreview')?.addEventListener('click', function () {
    const mismatchCount = {{ $transaksiMismatches->count() }};
    Swal.fire({ title: 'Memuat preview...', didOpen: () => Swal.showLoading() });
    fetch('{{ route('yayasan.transaksi.audit-konsistensi.fix') }}', {
        method: 'POST',
        headers: {
            'X-CSRF-TOKEN': '{{ csrf_token() }}',
            'Content-Type': 'application/json',
            'Accept': 'application/json'
        },
        body: JSON.stringify({ confirm: false })
    })
    .then(r => r.json())
    .then(data => {
        if (data.count === 0) {
            const msg = mismatchCount > 0
                ? 'Tidak ada baris detail yang bisa difix otomatis. Mismatch yang tampil biasanya transaksi rekap/grup (mis. GRUP-TRX) atau beda konsep realisasi vs pembayaran jurnal.'
                : 'Semua nominal_realisasi sudah sesuai jurnal.';
            Swal.fire('Tidak Ada Perubahan', msg, 'info');
            return;
        }
        let rows = data.rows.slice(0, 20).map(r =>
            `<tr><td>${r.transaksi_id}</td><td>${r.no_referensi}</td><td>${r.tipe}</td><td class="text-end text-danger">${r.lama}</td><td class="text-end text-success">${r.baru}</td></tr>`
        ).join('');
        let more = data.count > 20
            ? `<tr><td colspan="5" class="text-center text-muted">...dan ${data.count - 20} baris lainnya</td></tr>`
            : '';
        Swal.fire({
            title: `Fix ${data.count} baris?`,
            html: `<div class="table-responsive" style="max-height:300px;overflow-y:auto">
                <table class="table table-sm table-bordered">
                    <thead><tr><th>ID Trx</th><th>No Ref</th><th>Tipe</th><th>Lama</th><th>Baru</th></tr></thead>
                    <tbody>${rows}${more}</tbody>
                </table></div>`,
            icon: 'warning',
            showCancelButton: true,
            confirmButtonColor: '#e85347',
            confirmButtonText: 'Ya, Fix Sekarang',
            cancelButtonText: 'Batal',
            width: '700px'
        }).then(result => {
            if (result.isConfirmed) document.getElementById('formFix').submit();
        });
    })
    .catch(() => Swal.fire('Error', 'Gagal memuat preview. Coba lagi.', 'error'));
});
</script>
@endpush

{{-- Orphan Records --}}
@if($summary->orphan_detail > 0 || $summary->orphan_jurnal > 0)
<div class="row g-gs mb-4">
    @if($summary->orphan_detail > 0)
    <div class="col-md-6">
        <div class="card card-preview h-100">
            <div class="card-inner border-bottom"><h5 class="title mb-0 text-danger">Orphan Detail <small>(tanpa induk transaksi)</small></h5></div>
            <div class="table-responsive">
                <table class="table table-bordered table-sm mb-0">
                    <thead class="table-light"><tr><th>ID</th><th>Transaksi ID</th><th class="text-end">Realisasi</th></tr></thead>
                    <tbody>
                        @foreach($orphanDetails as $row)
                        <tr>
                            <td>{{ $row->id }}</td>
                            <td>{{ $row->transaksi_id }}</td>
                            <td class="text-end">{{ number_format($row->nominal, 0, ',', '.') }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    @endif
    @if($summary->orphan_jurnal > 0)
    <div class="col-md-6">
        <div class="card card-preview h-100">
            <div class="card-inner border-bottom"><h5 class="title mb-0 text-danger">Orphan Jurnal <small>(tanpa induk detail)</small></h5></div>
            <div class="table-responsive">
                <table class="table table-bordered table-sm mb-0">
                    <thead class="table-light"><tr><th>ID</th><th>Detail ID</th><th>Akun</th><th class="text-end">Mutasi</th></tr></thead>
                    <tbody>
                        @foreach($orphanJurnals as $row)
                        <tr>
                            <td>{{ $row->id }}</td>
                            <td>{{ $row->transaksi_detail_id }}</td>
                            <td><code>{{ $row->akun_id }}</code></td>
                            <td class="text-end">{{ number_format(($row->debit ?? 0) - ($row->kredit ?? 0), 0, ',', '.') }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    @endif
</div>
@endif

{{-- Trace Saldo Kas --}}
<div class="card card-preview">
    <div class="card-inner border-bottom">
        <h5 class="title mb-0">Trace Aliran Kas</h5>
        @if($selectedAccount)
        <small class="text-muted">{{ $selectedAccount->kode_akun }} &mdash; {{ $selectedAccount->nama_akun }}</small>
        @endif
    </div>
    @if($selectedAccount)
    <div class="card-inner border-bottom">
        <div class="row g-3 text-center">
            <div class="col-6 col-md-3">
                <div class="small text-soft">Saldo Awal (Input)</div>
                <div class="fw-bold fs-5">{{ number_format($traceSummary->saldo_awal_system, 0, ',', '.') }}</div>
            </div>
            <div class="col-6 col-md-3">
                <div class="small text-soft">Total Mutasi Berjalan</div>
                <div class="fw-bold fs-5">{{ number_format($traceSummary->mutasi_reguler, 0, ',', '.') }}</div>
            </div>
            <div class="col-6 col-md-3">
                <div class="small text-soft">Saldo Expected (Jurnal)</div>
                <div class="fw-bold fs-5">{{ number_format($traceSummary->saldo_expected, 0, ',', '.') }}</div>
            </div>
            <div class="col-6 col-md-3">
                <div class="small text-soft">Saldo Tersimpan</div>
                <div class="fw-bold fs-5 {{ abs($traceSummary->selisih_saldo) < 0.01 ? 'text-success' : 'text-danger' }}">
                    {{ number_format($traceSummary->saldo_actual, 0, ',', '.') }}
                    @if(abs($traceSummary->selisih_saldo) >= 0.01)
                    <span class="text-danger fs-6">(selisih {{ number_format($traceSummary->selisih_saldo, 0, ',', '.') }})</span>
                    @endif
                </div>
            </div>
        </div>
    </div>
    @endif
    <div class="table-responsive">
        <table class="table table-bordered table-sm align-middle mb-0">
            <thead class="table-light">
                <tr>
                    <th>Tanggal</th>
                    <th>No Referensi</th>
                    <th>Tipe Transaksi</th>
                    <th>Unit</th>
                    <th class="text-end">Debit Kas</th>
                    <th class="text-end">Kredit Kas</th>
                    <th class="text-end">Mutasi</th>
                    <th class="text-end">Running Saldo</th>
                </tr>
            </thead>
            <tbody>
                @forelse($traceRows as $row)
                <tr>
                    <td class="text-nowrap">{{ \Carbon\Carbon::parse($row->tanggal)->format('d/m/Y') }}</td>
                    <td><div class="fw-bold">{{ $row->no_referensi }}</div><small class="text-muted">#{{ $row->transaksi_id }}</small></td>
                    <td><span class="badge bg-outline-secondary">{{ $row->tipe_transaksi }}</span></td>
                    <td>{{ $row->nama_unit ?: $row->unit_id }}</td>
                    <td class="text-end text-success">{{ $row->debit_kas > 0 ? number_format($row->debit_kas, 0, ',', '.') : '-' }}</td>
                    <td class="text-end text-danger">{{ $row->kredit_kas > 0 ? number_format($row->kredit_kas, 0, ',', '.') : '-' }}</td>
                    <td class="text-end fw-bold {{ $row->mutasi_kas >= 0 ? 'text-success' : 'text-danger' }}">{{ number_format($row->mutasi_kas, 0, ',', '.') }}</td>
                    <td class="text-end fw-bold">{{ number_format($row->running_saldo, 0, ',', '.') }}</td>
                </tr>
                @empty
                <tr><td colspan="8" class="text-center text-muted py-4">Belum ada data untuk akun kas yang dipilih.</td></tr>
                @endforelse
            </tbody>
        </table>
    </div>
</div>
@endsection