@extends('layouts.app', ['class' => 'g-sidenav-show bg-gray-100'])

@section('content')
    @include('layouts.navbars.auth.topnav', ['title' => $title_menu])

    <div class="container-fluid py-4">
        <div class="row">
            <div class="col-12">
                <div class="row mx-0 mb-3">
                    <div class="col-12">
                        <div class="card border-info">
                            <div class="card-body py-2">
                                <div class="row align-items-center">
                                    <div class="col-md-8">
                                        <div class="d-flex align-items-center">
                                            <div>
                                                @if ($show_data && $current_periode)
                                                    <p class="text-sm mb-0">
                                                        <i class="fas fa-check-circle text-success me-1"></i>
                                                        Menampilkan data potongan untuk periode: <strong
                                                            class="text-primary">{{ $formatted_periode }}</strong>
                                                    </p>
                                                @elseif(!$show_data)
                                                    <p class="text-sm mb-0 text-muted">
                                                        <i class="fas fa-info-circle text-info me-1"></i>
                                                        Klik tombol <strong>"Generate Potongan"</strong> untuk membuat data
                                                        baru atau menampilkan data yang sudah ada.
                                                    </p>
                                                @else
                                                    <p class="text-sm mb-0 text-warning">
                                                        <i class="fas fa-exclamation-triangle text-warning me-1"></i>
                                                        Belum ada data potongan yang ditampilkan. Silakan generate potongan
                                                        terlebih dahulu.
                                                    </p>
                                                @endif
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-4 text-end">
                                        <button class="btn btn-primary" onclick="handleGeneratePotongan()">
                                            <i class="fas fa-plus me-1"></i>
                                            Generate Potongan
                                        </button>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>


                @if ($show_data)
                    <div class="row mx-1">
                        <div class="card">
                            <div class="row">
                                <div class="card-header col-md-auto">
                                    <h5 class="mb-0">{{ $title_menu }}</h5>
                                </div>
                                <div class="col">

                                </div>
                            </div>
                            <hr class="horizontal dark mt-0">
                            <div class="row px-4 py-2">
                                <div class="table-responsive">
                                    <table class="table display" id="list_{{ $dmenu }}">
                                        <thead class="thead-light" style="background-color: #00b7bd4f;">
                                            <tr>
                                                <th>No</th>
                                                @foreach ($table_header as $header)
                                                    <th>{{ $header->alias }}</th>
                                                @endforeach
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @foreach ($table_detail as $detail)
                                                @php
                                                    $vcount = $loop->iteration;

                                                    $compositeKey =
                                                        $detail->periode .
                                                        '|' .
                                                        $detail->nik .
                                                        '|' .
                                                        $detail->angsuran_ke;
                                                @endphp
                                                <tr
                                                    {{ $detail->isactive == '0' ? 'class=not style=background-color:#ffe9ed;' : '' }}>
                                                    <td>{{ $vcount }}</td>
                                                    @foreach ($table_header as $field)
                                                        @php
                                                            $string = $field->field;
                                                            $displayValue = $detail->$string;
                                                            
                                                            // Handle join type - execute query to get related data
                                                            if ($field->type == 'join' && $field->query != '' && $displayValue) {
                                                                try {
                                                                    $joinResult = DB::select($field->query . "'" . $displayValue . "'");
                                                                    if (!empty($joinResult)) {
                                                                        $joinArray = array_values((array) $joinResult[0]);
                                                                        $displayValue = $joinArray[0] ?? $displayValue;
                                                                    }
                                                                } catch (\Exception $e) {
                                                                    // Keep original value if query fails
                                                                }
                                                            }
                                                        @endphp
                                                        @if ($field->type == 'currency')
                                                            <td
                                                                class="text-sm font-weight-{{ $field->primary == '1' ? 'bold text-dark' : 'normal' }} text-currency text-end">
                                                                {{ $format->CurrencyFormat($detail->$string, $field->decimals ?? 0, $field->sub ?: 'Rp.') }}
                                                            </td>
                                                        @elseif ($field->type == 'date' || $field->type == 'datetime')
                                                            <td
                                                                class="text-sm font-weight-{{ $field->primary == '1' ? 'bold text-dark' : 'normal' }}">
                                                                {{ $format->DateFormat($detail->$string) }}
                                                            </td>
                                                        @elseif ($field->type == 'number')
                                                            <td
                                                                class="text-sm font-weight-{{ $field->primary == '1' ? 'bold text-dark' : 'normal' }} text-number text-end">
                                                                {{ number_format($detail->$string, $field->decimals ?? 0) }}
                                                            </td>
                                                        @elseif ($field->type == 'join')
                                                            <td
                                                                class="text-sm font-weight-{{ $field->primary == '1' ? 'bold text-dark' : 'normal' }}">
                                                                {{ $displayValue }}
                                                            </td>
                                                        @else
                                                            <td
                                                                class="text-sm font-weight-{{ $field->primary == '1' ? 'bold text-dark' : 'normal' }}">
                                                                @if ($field->field === 'isactive')
                                                                    @if ($detail->$string == '1')
                                                                        <span
                                                                            class="badge badge-sm bg-success">Active</span>
                                                                    @else
                                                                        <span
                                                                            class="badge badge-sm bg-secondary">Inactive</span>
                                                                    @endif
                                                                @else
                                                                    {{ $detail->$string }}
                                                                @endif
                                                            </td>
                                                        @endif
                                                    @endforeach
                                                </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                </div>
                                @if (method_exists($table_detail, 'links'))
                                    <div class="d-flex justify-content-between align-items-center">
                                        <div>
                                            Data {{ $table_detail->firstItem() }} - {{ $table_detail->lastItem() }}
                                            dari {{ $table_detail->total() }} data.
                                        </div>
                                        <div>
                                            {{ $table_detail->appends(request()->query())->links('pagination::bootstrap-4') }}
                                        </div>
                                    </div>
                                @endif
                            </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>
                @else
                    <div class="row mx-1">
                        <div class="card">
                            <div class="card-body text-center py-5">
                                <div class="mb-3">
                                    <i class="fas fa-table fa-3x text-muted"></i>
                                </div>
                                <h5 class="text-muted mb-2">Belum Ada Data Ditampilkan</h5>
                                <p class="text-muted mb-0">
                                    Klik tombol <strong>"Generate Potongan"</strong> untuk membuat data baru atau
                                    menampilkan data yang sudah ada.
                                </p>
                            </div>
                        </div>
                    </div>
                @endif
            </div>
        </div>
    </div>


    <div class="modal fade" id="generateModal" tabindex="-1" aria-labelledby="generateModalLabel" aria-hidden="true">
        <div class="modal-dialog">
            <div class="modal-content">
                <form method="POST" action="{{ URL::to($url_menu) }}" id="generate-form">
                    @csrf
                    <input type="hidden" name="generate_by_periode" value="1">

                    <div class="modal-header">
                        <h5 class="modal-title" id="generateModalLabel">Generate Potongan</h5>
                        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                    </div>
                    <div class="modal-body">
                        <div class="row">
                            <div class="col-md-6">
                                <div class="form-group">
                                    <label class="form-control-label">Bulan <span class="text-danger">*</span></label>
                                    <select class="form-control" name="bulan" id="bulan" required>
                                        <option value="">-- Pilih Bulan --</option>
                                        <option value="1">Januari</option>
                                        <option value="2">Februari</option>
                                        <option value="3">Maret</option>
                                        <option value="4">April</option>
                                        <option value="5">Mei</option>
                                        <option value="6">Juni</option>
                                        <option value="7">Juli</option>
                                        <option value="8">Agustus</option>
                                        <option value="9">September</option>
                                        <option value="10">Oktober</option>
                                        <option value="11">November</option>
                                        <option value="12">Desember</option>
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-6">
                                <div class="form-group">
                                    <label class="form-control-label">Tahun <span class="text-danger">*</span></label>
                                    <input type="number" class="form-control" name="tahun" id="tahun"
                                        min="2020" max="2030" value="{{ date('Y') }}" required>
                                    <small class="text-muted">Format: YYYY (contoh: 2025)</small>
                                </div>
                            </div>
                        </div>

                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Batal</button>
                        <button type="submit" class="btn btn-primary" id="generate-btn">
                            <i class="fas fa-cog me-1"></i>
                            Generate Potongan
                        </button>
                    </div>
                </form>
            </div>
        </div>
    </div>
@endsection

@if ($jsmenu == '1')
    @if (view()->exists("js.{$dmenu}"))
        @push('addjs')
            @include('js.' . $dmenu)
        @endpush
    @else
        @push('addjs')
            <script>
                Swal.fire({
                    title: 'JS Not Found!!',
                    text: 'Please Create File JS',
                    icon: 'error',
                    confirmButtonColor: '#028284'
                });
            </script>
        @endpush
    @endif
@endif