{% extends 'admin_master/base_admin_master.html' if session.get('role') == 'admin_master' else 'admin_database/base_admin_database.html' %}
{% set active_page = 'guru' %}

{% block page_title %}Preview Import Data Guru - Admin Database{% endblock %}

{% block page_header %}
<h5 class="mb-1 fw-bold" style="color: #1f2937; font-size: 1.25rem;">Preview Import Data Guru</h5>
<small class="text-muted" style="font-size: 0.85rem;">Harap periksa kembali data di bawah sebelum menyimpan ke sistem.</small>
{% endblock %}

{% block content %}
<div class="row g-4">
    <div class="col-12">
        {% if invalid_count > 0 %}
        <div class="alert alert-danger border-0 rounded-3 shadow-sm mb-4">
            <h6 class="fw-bold"><i class="fas fa-exclamation-triangle me-2"></i>Terdapat {{ invalid_count }} Baris Error pada File Anda:</h6>
            <p class="mt-2 mb-0 small"><strong>Catatan:</strong> Baris yang error <u>TIDAK</u> akan diimpor. Hanya baris yang valid di tabel bawah ini yang akan dimasukkan ke database.</p>
        </div>
        {% endif %}

        <div class="db-card rounded-2 shadow-sm border-0 overflow-hidden bg-white p-4">
            <div class="d-flex justify-content-between align-items-center mb-3">
                <h6 class="fw-semibold text-dark mb-0"><i class="fas fa-table text-primary me-2"></i>Data Valid Siap Import ({{ valid_rows|length }} Baris)</h6>
            </div>
            
            {% if valid_rows|length > 0 %}
            <div class="table-responsive border border-light-subtle rounded-3" style="max-height: 500px; overflow-y: auto;">
                <table class="table mb-0 align-middle table-hover text-start" style="font-size: 0.85rem;">
                    <thead style="position: sticky; top: 0; background-color: #f8fafc; z-index: 1;">
                        <tr class="border-bottom border-light-subtle">
                            <th class="py-3 px-3 text-center" style="width: 50px;">
                                <input class="form-check-input" type="checkbox" id="checkAll" checked>
                            </th>
                            <th class="py-3 px-3 text-uppercase fw-semibold text-muted">NO</th>
                            <th class="py-3 px-3 text-uppercase fw-semibold text-muted">NAMA LENGKAP</th>
                            <th class="py-3 px-3 text-uppercase fw-semibold text-muted">ID/NIY</th>
                            <th class="py-3 px-3 text-uppercase fw-semibold text-muted">L/P</th>
                            <th class="py-3 px-3 text-uppercase fw-semibold text-muted">JABATAN</th>
                            <th class="py-3 px-3 text-uppercase fw-semibold text-muted">STATUS</th>
                        </tr>
                    </thead>
                    <tbody class="border-top-0">
                        {% for row in valid_rows %}
                        <tr class="border-bottom border-light-subtle">
                            <td class="text-center px-3 py-2">
                                <input class="form-check-input row-checkbox" type="checkbox" value="{{ loop.index0 }}" checked>
                            </td>
                            <td class="text-muted px-3 py-2">{{ loop.index }}</td>
                            <td class="fw-medium text-dark px-3 py-2">{{ row.nama_lengkap }}</td>
                            <td class="px-3 py-2 text-muted">{{ row.id_guru }}</td>
                            <td class="px-3 py-2 text-muted">{{ row.jenis_kelamin }}</td>
                            <td class="px-3 py-2 text-muted">{{ row.jabatan }}</td>
                            <td class="px-3 py-2">
                                <span class="badge bg-success bg-opacity-10 text-success rounded-pill fw-medium">Valid</span>
                            </td>
                        </tr>
                        {% endfor %}
                    </tbody>
                </table>
            </div>
            
            <div class="mt-4 pt-3 border-top border-light-subtle d-flex justify-content-between align-items-center">
                <span class="text-muted small fw-medium" id="selectedCountMsg"><i class="fas fa-check-square text-success me-1"></i> <span id="selectedCount">{{ valid_rows|length }}</span> data terpilih</span>
                <div class="d-flex gap-2">
                    <a href="/admin_database/guru" class="btn btn-light text-secondary border-light-subtle px-4 rounded-3" style="font-weight: 500;">Batal</a>
                    <form action="/admin_database/guru/import_confirm" method="POST" id="formImport">
                        <textarea id="validRowsJson" style="display:none;">{{ valid_rows_json }}</textarea>
                        <textarea name="valid_rows_json" id="finalJsonData" style="display:none;"></textarea>
                        <input type="hidden" name="selected_indices" id="selectedIndices">
                        <button type="submit" id="btnKonfirmasi" class="btn text-white px-4 rounded-3 d-flex align-items-center gap-2" style="background-color: #00685f; font-weight: 600;">
                            <i class="fas fa-check-circle"></i> Konfirmasi & Simpan (<span id="btnCount">{{ valid_rows|length }}</span> Data)
                        </button>
                    </form>
                </div>
            </div>

            <script>
                document.addEventListener('DOMContentLoaded', function() {
                    const checkAll = document.getElementById('checkAll');
                    const rowCheckboxes = document.querySelectorAll('.row-checkbox');
                    const selectedCount = document.getElementById('selectedCount');
                    const btnCount = document.getElementById('btnCount');
                    const formImport = document.getElementById('formImport');
                    const rawJsonText = document.getElementById('validRowsJson').value;
                    const finalJsonData = document.getElementById('finalJsonData');
                    
                    function updateCount() {
                        const checked = document.querySelectorAll('.row-checkbox:checked').length;
                        selectedCount.textContent = checked;
                        btnCount.textContent = checked;
                        
                        document.getElementById('btnKonfirmasi').disabled = (checked === 0);
                        checkAll.checked = (checked === rowCheckboxes.length && rowCheckboxes.length > 0);
                    }

                    checkAll.addEventListener('change', function() {
                        rowCheckboxes.forEach(cb => cb.checked = this.checked);
                        updateCount();
                    });

                    rowCheckboxes.forEach(cb => {
                        cb.addEventListener('change', updateCount);
                    });

                    formImport.addEventListener('submit', function(e) {
                        e.preventDefault();
                        
                        const selectedIndices = Array.from(document.querySelectorAll('.row-checkbox:checked')).map(cb => parseInt(cb.value));
                        
                        finalJsonData.value = rawJsonText;
                        document.getElementById('selectedIndices').value = selectedIndices.join(',');
                        
                        this.submit();
                    });
                });
            </script>
            
            {% else %}
            <div class="text-center py-5">
                <i class="fas fa-file-excel mb-3" style="font-size: 3rem; color: #cbd5e1;"></i>
                <h5 class="text-muted">Tidak ada data valid yang bisa diimpor</h5>
                <p class="text-muted small">Semua baris dalam file Excel terdapat error atau kosong. Silakan perbaiki file Excel Anda lalu coba kembali.</p>
                <a href="/admin_database/guru" class="btn btn-primary mt-3"><i class="fas fa-arrow-left me-2"></i>Kembali ke Data Guru</a>
            </div>
            {% endif %}
        </div>
    </div>
</div>
{% endblock %}