showstudentdetail.js

document.addEventListener('DOMContentLoaded', () => {
    const searchForm = document.querySelector('.filter-controls form');
    const searchRegNoInput = document.getElementById('search_reg_no');
    const searchYearSelect = document.getElementById('search_year');
    const searchSemesterSelect = document.getElementById('search_semester');
    const studentTableBody = document.querySelector('#showstudent tbody');
    const clearFilterBtn = document.getElementById('ClearFilterBtn');

    // Store all initial rows
    const allTableRows = Array.from(studentTableBody.querySelectorAll('tr'));

    // Function to display "No data found" message
    const showNoDataFound = () => {
        studentTableBody.innerHTML = '<tr><td colspan="9" style="text-align: center; color: red;">No data found</td></tr>';
    };

    // Function to show all rows
    const showAllRows = () => {
        studentTableBody.innerHTML = ''; // Clear current table body
        allTableRows.forEach(row => {
            studentTableBody.appendChild(row.cloneNode(true)); // Append a clone to avoid issues with node re-insertion
        });
    };

    // Initially show all rows
    showAllRows();

    searchForm.addEventListener('submit', (event) => {
        event.preventDefault(); // Prevent default form submission

        const regNo = searchRegNoInput.value.trim().toLowerCase();
        const year = searchYearSelect.value;
        const semester = searchSemesterSelect.value;

        let foundMatch = false;
        const filteredRows = [];

        allTableRows.forEach(row => {
            const rowRegNo = row.children[4].textContent.trim().toLowerCase(); // Registration Number column
            const rowYear = row.children[5].textContent.trim().split('st').join('').split('nd').join('').split('rd').join('').toLowerCase(); // Year column (e.g., "1st" -> "1")
            const rowSemester = row.children[6].textContent.trim().split('st').join('').split('nd').join('').split('rd').join('').toLowerCase(); // Semester column (e.g., "1st" -> "1")

            const matchesRegNo = regNo === '' || rowRegNo.includes(regNo);
            const matchesYear = year === '' || rowYear === year;
            const matchesSemester = semester === '' || rowSemester === semester;

            if (matchesRegNo && matchesYear && matchesSemester) {
                filteredRows.push(row.cloneNode(true)); // Add a clone to the filtered list
                foundMatch = true;
            }
        });

        // Clear the current table body
        studentTableBody.innerHTML = '';

        if (foundMatch) {
            filteredRows.forEach(row => {
                studentTableBody.appendChild(row);
            });
        } else {
            showNoDataFound();
        }
    });

    clearFilterBtn.addEventListener('click', () => {
        searchRegNoInput.value = '';
        searchYearSelect.value = '';
        searchSemesterSelect.value = '';
        showAllRows();
    });
});