@extends('layouts.app')

@section('content')
    <div class="page-header">
        <div class="row">
            <div class="col">
                <h3 class="page-title">Laporan Belum Bayar</h3>
                <ul class="breadcrumb">
                    <li class="breadcrumb-item"><a href="{{ route('home') }}">Dashboard</a></li>
                    <li class="breadcrumb-item active">Laporan Belum Bayar</li>
                </ul>
            </div>
        </div>
    </div>

    {{-- FILTER PROYEK & TAHUN --}}

    <div class="row">
        <div class="col-sm-12">
            <div class="card">
                <div class="card-header bg-dark">
                    <h4 class="card-title">Data Belum Bayar</h4>
                    <p class="card-text">
                        Tabel ini berisi data cicilan atau transaksi yang belum dibayar.
                    </p>
                </div>
                <div class="card-body">
                    <div class="row mb-3">
                        {{-- Filter Proyek --}}
                        <div class="col-md-3">
                            <label for="filter_proyek" class="form-label mb-1">Proyek</label>
                            <select id="filter_proyek" class="select2">
                                <option value="">Semua Proyek</option>
                                @foreach ($Proyek as $proyek)
                                    <option value="{{ $proyek->id }}">{{ $proyek->NamaProyek ?? ($proyek->nama ?? '-') }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        {{-- Filter Tahun --}}
                        <div class="col-md-2">
                            <label for="filter_tahun" class="form-label mb-1">Tahun</label>
                            <select id="filter_tahun" class="select2">
                                <option value="">Semua Tahun</option>
                                @php
                                    $tahun_sekarang = date('Y');
                                    $tahun_awal = $tahun_sekarang - 5;
                                @endphp
                                @for ($tahun = $tahun_sekarang; $tahun >= $tahun_awal; $tahun--)
                                    <option value="{{ $tahun }}">{{ $tahun }}</option>
                                @endfor
                            </select>
                        </div>
                        <div class="col-md-2">
                            <label for="filter_bulan" class="form-label mb-1">Bulan</label>
                            <select id="filter_bulan" class="select2">
                                <option value="">Semua Bulan</option>
                                @php
                                    $daftar_bulan = [
                                        1 => 'Januari',
                                        2 => 'Februari',
                                        3 => 'Maret',
                                        4 => 'April',
                                        5 => 'Mei',
                                        6 => 'Juni',
                                        7 => 'Juli',
                                        8 => 'Agustus',
                                        9 => 'September',
                                        10 => 'Oktober',
                                        11 => 'November',
                                        12 => 'Desember',
                                    ];
                                @endphp
                                @foreach ($daftar_bulan as $num => $nama)
                                    <option value="{{ $num }}">{{ $nama }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-2 align-self-end d-flex gap-2">
                            <button type="button" class="btn btn-primary" id="btn-tampilkan-filter">
                                <i class="fas fa-filter me-1"></i> Tampilkan
                            </button>
                            <button type="button" class="btn btn-secondary" id="btn-reset-filter">
                                <i class="fas fa-redo me-1"></i> Reset
                            </button>
                        </div>
                        <div class="col text-end align-self-end">
                            <button class="btn btn-success" id="btnShowExportModal"
                                onclick="$('#modalExportOmset').modal('show')">
                                <i class="fa fa-file-excel"></i> Cetak Laporan
                            </button>
                        </div>
                    </div>
                    <div class="table-responsive">
                        <table class="table datanew cell-border compact stripe" id="belumBayarTable" width="100%">
                            <thead>
                                <tr>
                                    <th width="5%">No</th>
                                    <th>Nama Pelanggan</th>
                                    <th>HP</th>
                                    <th>Produk</th>
                                    <th>Jatuh Tempo</th>
                                    <th>Besar Cicilan</th>
                                    <th>Status</th>
                                </tr>
                            </thead>
                            <tbody></tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
    @include('laporan.belum-bayar.modal-cetak')
@endsection

@push('js')
    @if (Session::get('success'))
        <script>
            Swal.fire({
                icon: 'success',
                title: 'Berhasil!',
                text: '{{ Session::get('success') }}',
                iconColor: '#4BCC1F',
                confirmButtonText: 'Oke',
                confirmButtonColor: '#4BCC1F',
            });
        </script>
    @endif
    <script>
        $(document).ready(function() {

            function loadBelumBayarTable() {
                $('#belumBayarTable').DataTable({
                    responsive: true,
                    serverSide: true,
                    processing: true,
                    bDestroy: true,
                    ajax: {
                        url: "{{ route('laporan-belum-bayar.index') }}",
                        data: function(d) {
                            d.proyek = $('#filter_proyek').val();
                            d.tahun = $('#filter_tahun').val();
                            d.filter_bulan = $('#filter_bulan').val();
                        }
                    },
                    language: {
                        processing: '<i class="fa fa-spinner fa-spin fa-3x fa-fw"></i><span class="sr-only">Memuat...</span>',
                        paginate: {
                            next: '<i class="fa fa-angle-double-right" aria-hidden="true"></i>',
                            previous: '<i class="fa fa-angle-double-left" aria-hidden="true"></i>'
                        }
                    },
                    columns: [{
                            data: 'DT_RowIndex',
                            name: 'DT_RowIndex',
                            orderable: false,
                            searchable: false
                        },
                        {
                            data: 'NamaPelanggan',
                            name: 'NamaPelanggan',
                            defaultContent: '-'
                        },
                        {
                            data: 'NoHp',
                            name: 'NoHp',
                            defaultContent: '-'
                        },
                        {
                            data: 'NamaProduk',
                            name: 'NamaProduk',
                            defaultContent: '-'
                        },
                        {
                            data: 'TanggalJatuhTempo',
                            name: 'TanggalJatuhTempo',
                            defaultContent: '-'
                        },
                        {
                            data: 'BesarCicilan',
                            name: 'BesarCicilan',
                            defaultContent: '-'
                        },
                        {
                            data: 'Status',
                            name: 'Status',
                            defaultContent: '-'
                        }
                    ]
                });
            }

            // Initial load
            loadBelumBayarTable();

            // Terapkan filter saat tombol tampilkan ditekan
            $('#btn-tampilkan-filter').on('click', function() {
                $('#belumBayarTable').DataTable().ajax.reload();
            });

            // Reset filter
            $('#btn-reset-filter').on('click', function() {
                $('#filter_proyek').val('').trigger('change');
                $('#filter_tahun').val('').trigger('change');
                $('#filter_bulan').val('').trigger('change');
                $('#belumBayarTable').DataTable().ajax.reload();
            });

            // Untuk reload otomatis saat ganti filter, bisa uncomment baris berikut:
            // $('#filter_proyek, #filter_tahun').on('change', function() { $('#belumBayarTable').DataTable().ajax.reload(); });

        });
    </script>
@endpush