@extends('layouts.app', ['class' => 'g-sidenav-show bg-gray-100'])
@section('content')
    @include('layouts.navbars.auth.topnav', ['title' => ''])

    {{-- Header Card with Back Button --}}
    <div class="card shadow-lg mx-4">
        <div class="card-body p-3">
            <div class="row gx-4">
                <div class="col-lg">
                    <div class="nav-wrapper">
                        <button class="btn btn-secondary mb-0" onclick="window.location='{{ url($url_menu) }}'">
                            <i class="fas fa-circle-left me-1"></i> Kembali
                        </button>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="container-fluid py-4">
        {{-- Summary Cards --}}
        @php
            $totalSelisih = 0;
            $totalKeuntungan = 0;
            $totalKerugian = 0;
            $rowData = [];
            $symbols = ['USD' => '$', 'JPY' => '¥', 'EUR' => '€', 'GBP' => '£', 'SGD' => 'S$', 'AUD' => 'A$'];
            $id_perusahaan = session('id_perusahaan') ?? 1;
        @endphp
        @foreach ($banks as $bank)
            @php
                $kurs = $kurs_data->get($bank->mata_uang);
                $kursSekarang = $kurs ? $kurs->nilai : 0;

                // Cari kurs sebelumnya
                $prev = null;
                if ($kurs) {
                    $prev = \DB::table('mst_kurs')
                        ->where('kode', $bank->mata_uang)
                        ->where('kode_lawan', 'IDR')
                        ->where('id_kurs', '<', $kurs->id_kurs)
                        ->orderBy('id_kurs', 'desc')
                        ->first();
                }
                $kursBulanLalu = $prev ? $prev->nilai : $kursSekarang;

                // Hitung saldo aktual: Saldo Awal + Mutasi
                $tutupBuku = \DB::table('trs_tutup_buku')
                    ->where('id_perusahaan', $id_perusahaan)
                    ->where('id_bank', $bank->id_bank)
                    ->where('isactive', '0')
                    ->orderBy('periode', 'desc')
                    ->first();

                if (!$tutupBuku) {
                    $tutupBuku = \DB::table('trs_tutup_buku')
                        ->where('id_perusahaan', $id_perusahaan)
                        ->where('id_bank', $bank->id_bank)
                        ->orderBy('periode', 'asc')
                        ->first();
                }

                $saldo_awal = $tutupBuku ? $tutupBuku->saldo : 0;
                $baselinePeriode = $tutupBuku ? $tutupBuku->periode : null;

                $mutasiQuery = \DB::table('trs_detail_transaksi as d')
                    ->join('trs_header_transaksi as h', 'd.id_header', '=', 'h.id_header')
                    ->where('d.id_coa', $bank->id_coa);

                if ($baselinePeriode) {
                    $mutasiQuery->where('h.periode', '>', $baselinePeriode);
                }

                $mutasi_idr = $mutasiQuery->sum('d.jumlah');

                $mutasi_valas = ($bank->mata_uang !== 'IDR' && $kursSekarang > 0) ? ($mutasi_idr / $kursSekarang) : $mutasi_idr;
                $saldo = $saldo_awal + $mutasi_valas;

                $nilaiBuku = $saldo * $kursBulanLalu;
                $nilaiRevaluasi = $saldo * $kursSekarang;
                $selisih = $nilaiRevaluasi - $nilaiBuku;
                $pctPerubahan = $nilaiBuku > 0 ? (($nilaiRevaluasi - $nilaiBuku) / $nilaiBuku) * 100 : 0;
                $totalSelisih += $selisih;
                if ($selisih > 0) $totalKeuntungan += $selisih;
                if ($selisih < 0) $totalKerugian += abs($selisih);

                $rowData[] = (object)[
                    'id_coa' => $bank->id_coa,
                    'nama' => $bank->coa_nama ?? $bank->nama,
                    'mata_uang' => $bank->mata_uang,
                    'sym' => $symbols[$bank->mata_uang] ?? $bank->mata_uang . ' ',
                    'saldo' => $saldo,
                    'kursBulanLalu' => $kursBulanLalu,
                    'kursSekarang' => $kursSekarang,
                    'nilaiBuku' => $nilaiBuku,
                    'nilaiRevaluasi' => $nilaiRevaluasi,
                    'selisih' => $selisih,
                    'pctPerubahan' => $pctPerubahan,
                ];
            @endphp
        @endforeach

        <div class="row mb-4">
            <div class="col-xl-4 col-sm-6 mb-xl-0 mb-3">
                <div class="card bg-gradient-success shadow-lg" style="border-radius:12px;">
                    <div class="card-body p-3">
                        <div class="d-flex justify-content-between align-items-start">
                            <div class="bg-white rounded-circle d-flex align-items-center justify-content-center" style="width:40px;height:40px;flex-shrink:0;">
                                <i class="fas fa-file-invoice-dollar text-success"></i>
                            </div>
                            <div class="text-end ms-3">
                                <p class="text-sm mb-0 text-white opacity-8">Total Selisih Kurs</p>
                                <h4 class="text-white font-weight-bolder mb-1">Rp {{ number_format(abs($totalSelisih), 0, ',', '.') }}</h4>
                                <p class="text-white text-xs mb-0 opacity-7">
                                    {{ $totalSelisih >= 0 ? 'Netto penguatan nilai tukar (keuntungan > kerugian)' : 'Netto pelemahan nilai tukar (kerugian > keuntungan)' }}
                                </p>
                            </div>

                        </div>
                    </div>
                </div>
            </div>
            <div class="col-xl-4 col-sm-6 mb-xl-0 mb-3">
                <div class="card bg-white shadow-lg border-end border-success border-3" style="border-radius:12px;">
                    <div class="card-body p-3">
                        <div class="d-flex justify-content-between align-items-start">
                            <div class="bg-success bg-gradient rounded-circle d-flex align-items-center justify-content-center" style="width:40px;height:40px;flex-shrink:0;">
                                <i class="fas fa-chart-line text-white"></i>
                            </div>
                            <div class="text-end ms-3">
                                <p class="text-sm mb-0 text-success">Total Keuntungan</p>
                                <h4 class="text-success font-weight-bolder mb-1">Rp {{ number_format($totalKeuntungan, 0, ',', '.') }}</h4>
                                <p class="text-secondary text-xs mb-0">Penguatan nilai tukar (kurs naik)</p>
                            </div>

                        </div>
                    </div>
                </div>
            </div>
            <div class="col-xl-4 col-sm-6 mb-xl-0 mb-3">
                <div class="card bg-white shadow-lg border-end border-danger border-3" style="border-radius:12px;">
                    <div class="card-body p-3">
                        <div class="d-flex justify-content-between align-items-start">
                            <div class="bg-danger bg-gradient rounded-circle d-flex align-items-center justify-content-center" style="width:40px;height:40px;flex-shrink:0;">
                                <i class="fas fa-chart-line text-white" style="transform: scaleY(-1);"></i>
                            </div>
                            <div class="text-end ms-3">
                                <p class="text-sm mb-0 text-danger">Total Kerugian</p>
                                <h4 class="text-danger font-weight-bolder mb-1">Rp {{ number_format($totalKerugian, 0, ',', '.') }}</h4>
                                <p class="text-secondary text-xs mb-0">Pelemahan nilai tukar (kurs turun)</p>
                            </div>

                        </div>
                    </div>
                </div>
            </div>
        </div>

        {{-- Detail Table --}}
        <div class="card">
            <div class="card-header pb-0">
                <h5 class="mb-0">Selisih Kurs</h5>
                <p class="text-sm text-secondary mb-0">Perhitungan selisih kurs untuk akun Bank/Kas dalam mata uang asing</p>
            </div>
            <hr class="horizontal dark mt-2">
            <div class="row px-4 py-2">
                <div class="table-responsive">
                    <table class="table display" id="selisih_table">
                        <thead class="thead-light" style="background-color: #00b7bd4f;">
                            <tr>
                                <th>No COA</th>
                                <th>Kas/Bank</th>
                                <th class="text-end">Saldo</th>
                                <th class="text-end">Kurs Bulan Lalu</th>
                                <th class="text-end">Kurs Sekarang</th>
                                <th class="text-end">Nilai Buku (IDR)</th>
                                <th class="text-end">Nilai Revaluasi (IDR)</th>
                                <th class="text-end">Selisih Kurs</th>
                                <th class="text-end">% Perubahan</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($rowData as $row)
                                <tr>
                                    <td class="text-sm font-weight-normal">{{ $row->id_coa }}</td>
                                    <td class="text-sm font-weight-normal">{{ $row->nama }}</td>
                                    <td class="text-sm font-weight-normal text-end">{{ $row->sym }}{{ number_format($row->saldo, 0, ',', '.') }}</td>
                                    <td class="text-sm font-weight-normal text-end">{{ number_format($row->kursBulanLalu, 2, ',', '.') }}</td>
                                    <td class="text-sm font-weight-normal text-end">{{ number_format($row->kursSekarang, 2, ',', '.') }}</td>
                                    <td class="text-sm font-weight-normal text-end">Rp {{ number_format($row->nilaiBuku, 0, ',', '.') }}</td>
                                    <td class="text-sm font-weight-normal text-end">Rp {{ number_format($row->nilaiRevaluasi, 0, ',', '.') }}</td>
                                    <td class="text-sm font-weight-bold text-end {{ $row->selisih >= 0 ? 'text-success' : 'text-danger' }}">
                                        {{ $row->selisih >= 0 ? '+' : '-' }}Rp {{ number_format(abs($row->selisih), 0, ',', '.') }}
                                    </td>
                                    <td class="text-sm font-weight-bold text-end {{ $row->pctPerubahan >= 0 ? 'text-success' : 'text-danger' }}">
                                        {{ $row->pctPerubahan >= 0 ? '+' : '' }}{{ number_format($row->pctPerubahan, 2, ',', '.') }}%
                                    </td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
            <div class="row px-4 py-2">
                <div class="col-lg">
                    <div class="nav-wrapper" id="noted"><code>Note : <i aria-hidden="true" style="color: #ffc2cd;" class="fas fa-circle"></i> Data not active</code></div>
                </div>
            </div>
        </div>
    </div>
@endsection
@push('js')
    <script>
        $('#selisih_table').DataTable({
            "language": {
                "search": "", "searchPlaceholder": "Search...", "lengthMenu": "Tampilkan _MENU_ baris", "zeroRecords": "Tidak ada bank valas (non-IDR) yang aktif",
                "info": "Data _START_ - _END_ dari _TOTAL_", "infoEmpty": "Tidak ada data", "infoFiltered": "(pencarian dari _MAX_ data)"
            },
            responsive: true, dom: '<"row d-flex justify-content-between align-items-center"<"col-lg-12 d-flex justify-content-between align-items-center"Bf>>rtip',
            buttons: [
                { extend: 'excelHtml5', text: '<i class="fas fa-file-excel me-1 text-lg text-success"></i><span class="font-weight-bold"> Excel', exportOptions: { columns: ':visible' } },
                { extend: 'pdfHtml5', text: '<i class="fas fa-file-pdf me-1 text-lg text-danger"></i><span class="font-weight-bold"> PDF', exportOptions: { columns: ':visible' } },
                { extend: 'print', text: '<i class="fas fa-print me-1 text-lg text-info"></i><span class="font-weight-bold"> Print', exportOptions: { columns: ':visible' } },
            ],
            initComplete: function() {
                $('.dataTables_filter input').addClass('form-control');
            }
        });
        $('.dt-button').addClass('btn btn-secondary').removeClass('dt-button');
    </script>
@endpush