{% extends 'template.html' %}

{% block title %}الصفحة الرئيسية{% endblock %} {# Specific title for this page #}

{% block content %}
    <header class="text-center mb-8">
        <h1 class="text-3xl sm:text-4xl font-bold text-gray-900">نظام إدارة الطلاب</h1>
        <p class="text-gray-600 mt-2">أدخل بيانات الطلاب يدوياً أو قم باستيراد ملف CSV.</p>
    </header>

    <div id="add-student-section" class="bg-white p-8 rounded-xl shadow-lg mb-8 hidden">
        <h2 class="text-2xl font-semibold mb-6 text-gray-800 border-b pb-4">إضافة طالب جديد</h2>
        <form id="add-student-form" action="{{ url_for('add_student') }}" method="POST">
            <div class="grid grid-cols-1 md:grid-cols-2 gap-x-8 gap-y-6">
                <div>
                    <label for="student_name" class="block text-sm font-medium text-gray-700 mb-1">اسم الطالب</label>
                    <input type="text" name="student_name" id="student_name" placeholder="الاسم الكامل" required class="w-full px-4 py-2 border border-gray-300 rounded-lg shadow-sm focus:outline-none focus:ring-2 focus:ring-blue-500">
                </div>
                <div>
                    <label for="age" class="block text-sm font-medium text-gray-700 mb-1">العمر</label>
                    <input type="number" name="age" id="age" placeholder="مثال: 15" required class="w-full px-4 py-2 border border-gray-300 rounded-lg shadow-sm focus:outline-none focus:ring-2 focus:ring-blue-500">
                </div>
                <div>
                    <label for="parent_name" class="block text-sm font-medium text-gray-700 mb-1">اسم ولي الأمر</label>
                    <input type="text" name="parent_name" id="parent_name" placeholder="الاسم الكامل لولي الأمر" required class="w-full px-4 py-2 border border-gray-300 rounded-lg shadow-sm focus:outline-none focus:ring-2 focus:ring-blue-500">
                </div>
                <div>
                    <label for="parent_phone_1" class="block text-sm font-medium text-gray-700 mb-1">هاتف ولي الأمر 1 (مطلوب)</label>
                    <input type="tel" name="parent_phone_1" id="parent_phone_1" placeholder="مثال: 09xxxxxxxx" required class="w-full px-4 py-2 border border-gray-300 rounded-lg shadow-sm focus:outline-none focus:ring-2 focus:ring-blue-500">
                </div>
                <div>
                    <label for="parent_phone_2" class="block text-sm font-medium text-gray-700 mb-1">هاتف ولي الأمر 2 (اختياري)</label>
                    <input type="tel" name="parent_phone_2" id="parent_phone_2" placeholder="مثال: 09xxxxxxxx" class="w-full px-4 py-2 border border-gray-300 rounded-lg shadow-sm focus:outline-none focus:ring-2 focus:ring-blue-500">
                </div>
                <div>
                    <label for="student_phone" class="block text-sm font-medium text-gray-700 mb-1">هاتف الطالب (اختياري)</label>
                    <input type="tel" name="student_phone" id="student_phone" placeholder="مثال: 09xxxxxxxx" class="w-full px-4 py-2 border border-gray-300 rounded-lg shadow-sm focus:outline-none focus:ring-2 focus:ring-blue-500">
                </div>
                <div>
                    <label for="grade" class="block text-sm font-medium text-gray-700 mb-1">الصف</label>
                    <input type="text" name="grade" id="grade" placeholder="مثال: الصف العاشر" required class="w-full px-4 py-2 border border-gray-300 rounded-lg shadow-sm focus:outline-none focus:ring-2 focus:ring-blue-500">
                </div>
                <div>
                    <label for="school_name" class="block text-sm font-medium text-gray-700 mb-1">اسم المدرسة</label>
                    <input type="text" name="school_name" id="school_name" placeholder="مثال: مدرسة المستقبل" required class="w-full px-4 py-2 border border-gray-300 rounded-lg shadow-sm focus:outline-none focus:ring-2 focus:ring-blue-500">
                </div>
                <div class="md:col-span-2">
                    <label for="address" class="block text-sm font-medium text-gray-700 mb-1">العنوان</label>
                    <input type="text" name="address" id="address" placeholder="الشارع، المدينة" required class="w-full px-4 py-2 border border-gray-300 rounded-lg shadow-sm focus:outline-none focus:ring-2 focus:ring-blue-500">
                </div>
                <div class="md:col-span-2">
                    <label for="memorizing" class="block text-sm font-medium text-gray-700 mb-1">المحفوظات</label>
                    <input type="text" name="memorizing" id="memorizing" placeholder="مثال: القرآن، جزء عم" required class="w-full px-4 py-2 border border-gray-300 rounded-lg shadow-sm focus:outline-none focus:ring-2 focus:ring-blue-500">
                </div>
            </div>
            <div class="mt-8 text-left">
                <button type="submit" id="submit-add-button" class="px-8 py-3 bg-blue-600 text-white font-semibold rounded-lg shadow-md hover:bg-blue-700 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-blue-500 transition-all">
                    حفظ بيانات الطالب
                </button>
            </div>
        </form>
    </div>
    
    <div class="bg-white p-6 rounded-xl shadow-lg mb-8">
        <h2 class="text-2xl font-semibold mb-4 text-gray-800 border-b pb-4">استيراد من ملف CSV</h2>
        <div class="bg-yellow-50 border border-yellow-200 text-yellow-800 text-sm p-4 rounded-lg mt-4">
            <p class="font-bold">هام: تنسيق ملف CSV</p>
            <p>يجب أن يكون الملف بصيغة CSV ومرمّزاً بترميز UTF-8.</p>
            <p>يجب **ألا يحتوي** الملف على صف للعناوين، ويجب أن تكون الأعمدة بالترتيب الدقيق التالي:</p>
            <p class="mt-2" style="direction: ltr; text-align: right;">
                <code class="text-xs font-mono">اسم الطالب, العمر, اسم ولي الأمر, هاتف ولي الأمر 1, هاتف ولي الأمر 2, هاتف الطالب, الصف, اسم المدرسة, العنوان, المحفوظات</code>
            </p>
            <p>إذا كانت الحقول الاختيارية (هاتف ولي الأمر 2، هاتف الطالب) فارغة، اتركها كذلك.</p>
        </div>
        <div class="mt-6 text-left">
            <form id="import-form" action="{{ url_for('import_csv') }}" method="POST" enctype="multipart/form-data">
                <input type="file" name="file" id="csv-file-input" class="hidden" required accept=".csv">

                <button type="button" id="choose-file-button" class="px-6 py-2 bg-green-600 text-white font-semibold rounded-lg shadow-md hover:bg-green-700 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-green-500 transition-all">
                    اختر ملف
                </button>

                <span id="file-name-display" class="hidden ml-4 text-gray-700"></span>

                <button type="submit" id="submit-import-button" class="hidden px-6 py-2 bg-blue-600 text-white font-semibold rounded-lg shadow-md hover:bg-blue-700 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-blue-500 transition-all">
                    تأكيد ورفع الملف
                </button>
            </form>
        </div>
    </div>

    <div class="bg-white p-6 rounded-xl shadow-lg">
        <div class="flex justify-between items-center mb-4 pb-4 border-b">
            <h2 class="text-2xl font-semibold text-gray-800">الطلاب المسجلون</h2>
            <button id="add-manually-button" class="px-6 py-2 bg-blue-600 text-white font-semibold rounded-lg shadow-md hover:bg-blue-700 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-blue-500 transition-all">
                إضافة يدوية
            </button>
        </div>
        
        {# Search input box for fuzzy finding #}
        <div class="mb-6">
            <label for="search-input" class="sr-only">البحث عن طالب</label>
            <input type="text" id="search-input" placeholder="ابحث عن طالب بالاسم أو ولي الأمر..." class="w-full px-4 py-2 border border-gray-300 rounded-lg shadow-sm focus:outline-none focus:ring-2 focus:ring-blue-500 text-right" dir="rtl">
        </div>

        <div class="overflow-x-auto">
            <table class="min-w-full divide-y divide-gray-200 text-right">
                <thead class="bg-gray-50">
                    <tr>
                        <th class="px-6 py-3 text-xs font-medium text-gray-500 uppercase tracking-wider">#</th>
                        <th class="px-6 py-3 text-xs font-medium text-gray-500 uppercase tracking-wider">اسم الطالب</th>
                        <th class="px-6 py-3 text-xs font-medium text-gray-500 uppercase tracking-wider">العمر</th>
                        <th class="px-6 py-3 text-xs font-medium text-gray-500 uppercase tracking-wider">ولي الأمر</th>
                        <th class="px-6 py-3 text-xs font-medium text-gray-500 uppercase tracking-wider">أرقام التواصل</th>
                        <th class="px-6 py-3 text-xs font-medium text-gray-500 uppercase tracking-wider">الصف</th>
                        <th class="px-6 py-3 text-xs font-medium text-gray-500 uppercase tracking-wider">المدرسة</th>
                        <th class="px-6 py-3 text-xs font-medium text-gray-500 uppercase tracking-wider">العنوان</th>
                        <th class="px-6 py-3 text-xs font-medium text-gray-500 uppercase tracking-wider">المحفوظات</th>
                    </tr>
                </thead>
                <tbody class="bg-white divide-y divide-gray-200" id="students-table-body">
                    {% for student in students %}
                    <tr class="hover:bg-gray-50 transition-colors duration-200">
                        <td class="px-6 py-4 whitespace-nowrap text-sm font-bold text-gray-700">{{ student['id'] }}</td>
                        <td class="px-6 py-4 whitespace-nowrap text-sm font-medium text-gray-900">{{ student['student_name'] }}</td>
                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-600">{{ student['age'] }}</td>
                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-600">{{ student['parent_name'] }}</td>
                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-600">
                            <div class="flex flex-col">
                                <span>ولي الأمر 1: {{ student['parent_phone_1'] }}</span>
                                {% if student['parent_phone_2'] %}<span>ولي الأمر 2: {{ student['parent_phone_2'] }}</span>{% endif %}
                                {% if student['student_phone'] %}<span>الطالب: {{ student['student_phone'] }}</span>{% endif %}
                            </div>
                        </td>
                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-600">{{ student['grade'] }}</td>
                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-600">{{ student['school_name'] }}</td>
                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-600">{{ student['address'] }}</td>
                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-600">{{ student['memorizing'] }}</td>
                    </tr>
                    {% else %}
                    <tr id="no-students-row">
                        <td colspan="10" class="text-center py-6 text-gray-500">لم تتم إضافة أي طالب بعد.</td>
                    </tr>
                    {% endfor %}
                </tbody>
            </table>
            {# Message to display when no search results are found #}
            <div id="no-search-results" class="text-center py-6 text-gray-500 hidden">
                لا توجد نتائج بحث مطابقة.
            </div>
        </div>
    </div>

    <script>
        // Get references to all necessary elements
        const csvFileInput = document.getElementById('csv-file-input');
        const chooseFileButton = document.getElementById('choose-file-button');
        const fileNameDisplay = document.getElementById('file-name-display');
        const submitImportButton = document.getElementById('submit-import-button');
        const addManuallyButton = document.getElementById('add-manually-button');
        const addStudentSection = document.getElementById('add-student-section');
        const addStudentForm = document.getElementById('add-student-form');
        const importForm = document.getElementById('import-form');
        const submitAddButton = document.getElementById('submit-add-button');

        // New elements for search functionality
        const searchInput = document.getElementById('search-input');
        const studentsTableBody = document.getElementById('students-table-body');
        const noStudentsRow = document.getElementById('no-students-row');
        const noSearchResultsDiv = document.getElementById('no-search-results');

        // Store original student data and row elements for efficient filtering and restoration
        const allStudentData = [];
        studentsTableBody.querySelectorAll('tr').forEach(row => {
            if (row.id === 'no-students-row') {
                return; // Skip the "no students" row from data processing
            }
            allStudentData.push({
                element: row,
                student_name: row.children[1] ? row.children[1].textContent : '',
                parent_name: row.children[3] ? row.children[3].textContent : '',
                // Store original HTML of potentially highlighted cells to restore them later
                originalStudentNameHTML: row.children[1] ? row.children[1].innerHTML : '',
                originalParentNameHTML: row.children[3] ? row.children[3].innerHTML : ''
            });
        });

        // Function to perform a fuzzy match
        // Checks if all characters of the pattern exist sequentially in the text, allowing for other characters in between.
        function fuzzyMatch(pattern, text) {
            pattern = pattern.toLowerCase();
            text = text.toLowerCase();
            let patternIdx = 0;
            let textIdx = 0;

            while (patternIdx < pattern.length && textIdx < text.length) {
                if (pattern[patternIdx] === text[textIdx]) {
                    patternIdx++;
                }
                textIdx++;
            }
            return patternIdx === pattern.length;
        }

        // Function to highlight occurrences of a term within text
        function highlightText(text, term) {
            if (!term) return text;
            // Escape special characters in the term to be used in regex
            const escapedTerm = term.replace(/[.*+?^${}()|[\]\\]/g, '\\$&');
            // Use a regular expression with 'gi' for global and case-insensitive matching
            const regex = new RegExp(escapedTerm, 'gi');
            // Replace all occurrences of the term with the highlighted version
            return text.replace(regex, match => `<span class="highlight">${match}</span>`);
        }

        // Function to filter students based on search input
        function filterStudents() {
            const searchTerm = searchInput.value.trim();
            let foundResults = 0;

            // Hide the "no students" row if it exists
            if (noStudentsRow) {
                noStudentsRow.classList.add('hidden');
            }

            if (searchTerm === '') {
                // If search term is empty, show all rows and restore their original content
                allStudentData.forEach(data => {
                    data.element.classList.remove('hidden');
                    // Restore original HTML for highlighted cells
                    if (data.element.children[1]) {
                        data.element.children[1].innerHTML = data.originalStudentNameHTML;
                    }
                    if (data.element.children[3]) {
                        data.element.children[3].innerHTML = data.originalParentNameHTML;
                    }
                });
                noSearchResultsDiv.classList.add('hidden'); // Hide no results message
                // If there were no students initially (allStudentData is empty), show the "no students" row again
                if (noStudentsRow && allStudentData.length === 0) {
                    noStudentsRow.classList.remove('hidden');
                }
                return;
            }

            // Iterate through the stored student data
            allStudentData.forEach(data => {
                const studentName = data.student_name;
                const parentName = data.parent_name;

                // Perform fuzzy search ONLY on student name or parent name
                const isMatch = fuzzyMatch(searchTerm, studentName) || fuzzyMatch(searchTerm, parentName);

                if (isMatch) {
                    data.element.classList.remove('hidden'); // Show the row
                    foundResults++;

                    // Apply highlighting to the student name cell
                    if (data.element.children[1]) {
                        data.element.children[1].innerHTML = highlightText(studentName, searchTerm);
                    }
                    // Apply highlighting to the parent name cell
                    if (data.element.children[3]) {
                        data.element.children[3].innerHTML = highlightText(parentName, searchTerm);
                    }
                } else {
                    data.element.classList.add('hidden'); // Hide the row
                    // Restore original content if the row is hidden
                    if (data.element.children[1]) {
                        data.element.children[1].innerHTML = data.originalStudentNameHTML;
                    }
                    if (data.element.children[3]) {
                        data.element.children[3].innerHTML = data.originalParentNameHTML;
                    }
                }
            });

            // Show/hide the "no search results" message based on found results
            if (foundResults > 0) {
                noSearchResultsDiv.classList.add('hidden');
            } else {
                noSearchResultsDiv.classList.remove('hidden');
            }
        }

        // Event listener for the search input
        searchInput.addEventListener('input', filterStudents);

        // When the "Choose File" button is clicked, it programmatically clicks the hidden file input.
        chooseFileButton.addEventListener('click', () => {
            csvFileInput.click();
        });

        // When a file is selected using the file input...
        csvFileInput.addEventListener('change', () => {
            if (csvFileInput.files.length > 0) {
                const fileName = csvFileInput.files[0].name;
                fileNameDisplay.textContent = `الملف المختار: ${fileName}`;
                
                // Show the file name display and the submit button
                fileNameDisplay.classList.remove('hidden');
                submitImportButton.classList.remove('hidden');
                
                // Hide the original "Choose File" button to avoid confusion
                chooseFileButton.classList.add('hidden');
            } else {
                // If no file is selected (e.g., user cancels file dialog)
                fileNameDisplay.classList.add('hidden');
                submitImportButton.classList.add('hidden');
                chooseFileButton.classList.remove('hidden');
            }
        });

        // Toggle the visibility of the "Add New Student" form
        addManuallyButton.addEventListener('click', () => {
            addStudentSection.classList.toggle('hidden');
        });

        // --- Prevent Double Submissions ---

        // For the CSV Import Form
        importForm.addEventListener('submit', () => {
            submitImportButton.disabled = true;
            submitImportButton.textContent = 'جاري الرفع...'; // "Uploading..."
        });

        // For the Manual Add Student Form
        addStudentForm.addEventListener('submit', () => {
            submitAddButton.disabled = true;
            submitAddButton.textContent = 'جاري الحفظ...'; // "Saving..."
        });
    </script>
{% endblock %}