@extends('layout')
@section('content')
    <div class="dashboard-main-body">
        <div class="d-flex flex-wrap align-items-center justify-content-between gap-3 mb-24">
            <h6 class="fw-semibold mb-0">Dashboard</h6>
            <ul class="d-flex align-items-center gap-2">
                <li class="fw-medium">
                    <a href="index.html" class="d-flex align-items-center gap-1 hover-text-primary">
                        <iconify-icon icon="solar:home-smile-angle-outline" class="icon text-lg"></iconify-icon>
                        Dashboard
                    </a>
                </li>
                <li>-</li>
                <li class="fw-medium">Dashboard</li>
            </ul>
        </div>

        <div class="row">

            <!-- Total Semua Pembayaran -->
            <div class="col-md-3">
                <div class="card shadow-sm border-0 rounded-lg text-white bg-primary mb-4">
                    <div class="card-body d-flex justify-content-between align-items-center">
                        <div>
                            <p class="mb-1 text-white">Total Pembayaran</p>
                            <p class="text-white">Rp {{ number_format($total, 0, ',', '.') }}</p>
                        </div>
                        <div>
                            <i class="fas text-white fa-wallet fa-2x"></i>
                        </div>
                    </div>
                </div>
            </div>

            <!-- Total Hari Ini -->
            <div class="col-md-3">
                <div class="card shadow-sm border-0 rounded-lg text-white bg-success mb-4">
                    <div class="card-body d-flex justify-content-between align-items-center">
                        <div>
                            <p class="mb-1 text-white">Pelayanan Masih Proses</p>
                            <p class="text-white">{{ $proses }}</p>
                        </div>
                        <div>
                            <i class="fas text-white fa-calendar-day fa-2x"></i>
                        </div>
                    </div>
                </div>
            </div>

            <!-- Total Pendaftaran -->
            <div class="col-md-3">
                <div class="card shadow-sm border-0 rounded-lg text-white bg-warning mb-4">
                    <div class="card-body d-flex justify-content-between align-items-center">
                        <div>
                            <p class="mb-1 text-white">Sisa Saldo</p>
                            <p class="text-white">Rp {{ number_format($sisa, 0, ',', '.') }}</p>
                        </div>
                        <div>
                            <i class="fas text-white fa-user-plus fa-2x"></i>
                        </div>
                    </div>
                </div>
            </div>

            <!-- Total Siswa -->
            <div class="col-md-3">
                <div class="card shadow-sm border-0 rounded-lg text-white bg-danger mb-4">
                    <div class="card-body d-flex justify-content-between align-items-center">
                        <div>
                            <p class="mb-1 text-white">Total Pelayanan</p>
                            <p class="text-white">{{ $pelayanan }}</p>
                        </div>
                        <div>
                            <i class="fas text-white fa-users fa-2x"></i>
                        </div>
                    </div>
                </div>
            </div>

        </div>

        <div class="card mt-5">
            <div class="card-header">
                <b>Report Pembayaran Iuran Periode {{ $bulanIndo . ' ' . date('Y') }}
                </b>

                @if (isset($satu) && isset($dua))
                <br>
                    <span>
                        Kecamatan {{ $satu->nama }} <br> Kelurahan {{ $dua->nama }}
                    </span>
                @endif
                <br>
                <form class="row w-75" method="GET" action="{{ url('periode') }}">
                    @csrf
                    <div class="col-md-4">
                        <div class="mb-3">
                            <label for="kecamatan" class="form-label">Kecamatan</label>
                            <select class="form-select select1" id="kecamatan" name="kecamatan" required
                                onchange="gantiKecamatan(this)">
                                <option value="" selected disabled>Pilih Kecamatan</option>
                                @foreach ($kecamatan as $one)
                                    <option value="{{ $one->id }}">{{ $one->nama }}</option>
                                @endforeach
                            </select>
                        </div>
                    </div>

                    <div class="col-md-4">
                        <div class="mb-3">
                            <label for="kelurahan" class="form-label">Kelurahan</label>
                            <select class="form-select select1" id="kelurahan" name="kelurahan" required>
                                <option value="" selected disabled>Pilih Kelurahan</option>
                            </select>
                        </div>
                    </div>

                    <div class="col-md-4">
                        <div style="margin-top: 34px;">
                            <button class="btn btn-success" type="submit">Filter</button>
                        </div>
                    </div>
                </form>
            </div>
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table bordered-table mb-0" id="dataTable" data-page-length='10'>
                        <thead>
                            <tr>
                                <th scope="col">
                                    No
                                </th>
                                <th scope="col">Nama</th>
                                <th scope="col">Kecamatan/Kelurahan</th>
                                <th scope="col">RT/RW</th>
                                <th scope="col">Tanggal Bayar</th>
                                <th scope="col">Jumlah Bayar</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php
                                $total = 0;
                            @endphp
                            @foreach ($anggota as $row)
                                <tr>
                                    <td>{{ $loop->iteration }}</td>
                                    <td>{{ $row->nama }}</td>
                                    <td>{{ $row->kecamatans?->nama  . '/' . $row->kelurahans?->nama  }}</td>
                                    <td>{{ $row->rt . '/' . $row->rw }}</td>
                                    @php
                                        $bayar = App\Models\BayarModel::where('anggota_id', $row->id)
                                            ->where('bulan', $bulanIndo)
                                            ->where('tahun', date('Y'))
                                            ->first();
                                    @endphp
                                    @if ($bayar)
                                        <td>{{ date('d F Y', strtotime($bayar->tgl)) }}</td>
                                        <td>Rp. {{ number_format($bayar->jumlah) }}</td>
                                    @else
                                        <td><span class="badge badge-pill bg-danger">Belum Bayar</span></td>
                                        <td><span class="badge badge-pill bg-danger">Belum Bayar</span></td>
                                    @endif
                                </tr>
                                @php
                                    $total += $bayar->jumlah ?? 0;
                                @endphp
                            @endforeach
                        </tbody>
                        <tfoot>
                            <tr>
                                <td colspan="5" style="text-align: right">Jumlah</td>
                                <td colspan="2">
                                    Rp. {{ number_format($total) }}
                                </td>
                            </tr>
                        </tfoot>

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

    </div>
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/choices.js/public/assets/styles/choices.min.css">

    <!-- Choices JS -->
    <script src="https://cdn.jsdelivr.net/npm/choices.js/public/assets/scripts/choices.min.js"></script>

    <script>
        let kelurahanChoices;

        document.addEventListener("DOMContentLoaded", function() {
            const selectElements = document.querySelectorAll("select.select1");

            selectElements.forEach(function(select) {
                const instance = new Choices(select, {
                    searchEnabled: true,
                    itemSelectText: '',
                    placeholder: true,
                    searchPlaceholderValue: 'Cari...'
                });

                if (select.id === "kelurahan") {
                    kelurahanChoices = instance;
                }
            });
        });

        async function gantiKecamatan(select) {
            const kecamatan_id = select.value;
            if (!kelurahanChoices) return;

            kelurahanChoices.clearChoices();
            kelurahanChoices.setChoices([{
                value: '',
                label: 'Memuat data...',
                disabled: true
            }], 'value', 'label', false);

            if (!kecamatan_id) {
                kelurahanChoices.clearChoices();
                kelurahanChoices.setChoices([{
                    value: '',
                    label: 'Pilih Kecamatan terlebih dahulu',
                    disabled: true
                }], 'value', 'label', false);
                return;
            }

            try {
                const res = await fetch(`{{ url('show_anggota') }}/${kecamatan_id}`);
                const data = await res.json();

                kelurahanChoices.clearChoices();

                if (data.length === 0) {
                    kelurahanChoices.setChoices([{
                        value: '',
                        label: 'Tidak ada kelurahan',
                        disabled: true
                    }], 'value', 'label', false);
                    return;
                }

                kelurahanChoices.setChoices(
                    data.map(item => ({
                        value: item.id,
                        label: item.nama
                    })),
                    'value',
                    'label',
                    false
                );
            } catch (error) {
                console.error(error);
                kelurahanChoices.clearChoices();
                kelurahanChoices.setChoices([{
                    value: '',
                    label: 'Gagal memuat data',
                    disabled: true
                }], 'value', 'label', false);
            }
        }
    </script>
@endsection