function editBook(bookId) {
    const modal = document.getElementById('editModal');
    const bookIdInput = document.getElementById('bookId');
    if (modal) {
        modal.style.display = 'block';
        bookIdInput.value = bookId;
    } else {
        console.error("Modal element 'editModal' not found.");
        return;
    }

    // Fetch book details and inspect the raw response
    fetch(`../Admin Actions/GetBooks.php?id=${bookId}`)
        .then(response => response.text())  // Change .json() to .text() to inspect raw response
        .then(responseText => {
            console.log("Raw response text:", responseText);  // Log raw response

            // Try to parse the JSON response
            try {
                const book = JSON.parse(responseText);  // Manually parse JSON
                console.log(book); // Log book details for debugging

                // Populate the form with book data
                const setValueIfExists = (id, value) => {
                    const element = document.getElementById(id);
                    if (element) {
                        element.value = value || '';  // Set value or empty if null/undefined
                    } else {
                        console.warn(`Element with ID '${id}' not found.`);
                    }
                };

                setValueIfExists('editTitle', book.title);
                setValueIfExists('editIsbn', book.isbn);
                setValueIfExists('editGenre', book.genre);
                setValueIfExists('editPublishedYear', book.publishedyear);
                setValueIfExists('editDescription', book.description);
                setValueIfExists('editTotalCopies', book.totalcopies);
                setValueIfExists('editFormat', book.format);
                setValueIfExists('editLanguage', book.language);
                setValueIfExists('editPublisher', book.publisher);
                setValueIfExists('editPages', book.pages);


                // Handle author selection (assuming multiple authors possible)
                const authorSelect = document.getElementById('authors');
                if (authorSelect && book.authors) {
                    book.authors.forEach(authorId => {
                        const option = authorSelect.querySelector(`option[value="${authorId}"]`);
                        if (option) option.selected = true;
                    });
                }

                // Show current cover image if exists
                const currentImageDiv = document.getElementById('currentImage');
                if (currentImageDiv) {
                    if (book.coverimage) {
                        currentImageDiv.innerHTML = `
                            <img src="./BookCovers/${book.coverimage}" alt="Current book cover" style="max-width: 100px; margin-top: 10px;">
                            <p>Current cover</p>
                        `;
                    } else {
                        currentImageDiv.innerHTML = '<p>No cover image uploaded</p>';
                    }
                }
            } catch (error) {
                console.error('Error parsing JSON:', error);
            }
        })
        .catch(error => console.error('Error fetching book details:', error));
}


function closeModal() {
    document.getElementById('editModal').style.display = 'none';
}

function searchBooks() {
    const searchInput = document.querySelector('.search-input').value.toLowerCase();
    const tableRows = document.querySelectorAll('#booksTableBody tr');
    
    tableRows.forEach(row => {
        const title = row.cells[1].textContent.toLowerCase();
        const isbn = row.cells[3].textContent.toLowerCase();
        const author = row.cells[2].textContent.toLowerCase();
        
        if (title.includes(searchInput) || 
            isbn.includes(searchInput) || 
            author.includes(searchInput)) {
            row.style.display = '';
        } else {
            row.style.display = 'none';
        }
    });
}

function updateBook(event) {
    event.preventDefault();
    const formData = new FormData(event.target);
    
    // Debug: Check what data is being sent
    for (let pair of formData.entries()) {
        console.log(pair[0] + ': ' + pair[1]);
    }

    fetch('../Admin Actions/UpdateBook.php', {
        method: 'POST',
        body: formData
    })
    .then(response => {
        console.log('Response status:', response.status);
        return response.text(); // First, get the response as text
    })
    .then(text => {
        console.log('Raw response text:', text);
        try {
            const data = JSON.parse(text); // Try to parse it as JSON
            console.log('Response data:', data);
            if(data.success) {
                closeModal();
                location.reload();
            } else {
                alert(data.message || 'Failed to update book');
            }
        } catch (error) {
            console.error('Failed to parse JSON:', error);
            console.error('Raw response text:', text);
            alert('Server returned an invalid response. Check console for details.');
        }
    })
}

function deleteBook(bookId) {
    if(confirm('Are you sure you want to delete this book?')) {
        fetch('../Admin Actions/DeleteBook.php', {
            method: 'POST',
            headers: {
                'Content-Type': 'application/x-www-form-urlencoded',
            },
            body: `bookId=${bookId}`
        })
        .then(response => response.json())
        .then(data => {
            if(data.success) {
                location.reload();
            } else {
                alert(data.message || 'Failed to delete book');
            }
        })
        .catch(error => {
            console.error('Error:', error);
            alert('An error occurred while deleting the book');
        });
    }
}

function addBook(event) {
    event.preventDefault();
    
    const authorId = document.getElementById('authorId').value;
    const authorSearch = document.getElementById('authorSearch').value;
    
    console.log('Author ID:', authorId);
    console.log('Author Search:', authorSearch);
    
    if (!authorId || authorId.trim() === '') {
        if (!authorSearch || authorSearch.trim() === '') {
            alert('Please enter an author name');
        } else {
            alert('Please select an author from the suggestions list');
        }
        return;
    }
    
    const formData = new FormData(event.target);
    
    // Debug log all form data
    for (let pair of formData.entries()) {
        console.log(pair[0] + ': ' + pair[1]);
    }

    // Continue with form submission...
    fetch('../Admin Actions/AddBook.php', {
        method: 'POST',
        body: formData
    })
    .then(response => response.text())
    .then(text => {
        console.log('Server response:', text);
        try {
            const data = JSON.parse(text);
            if (data.success) {
                alert('Book added successfully!');
                resetForm();
            } else {
                alert(data.message || 'Error adding book');
            }
        } catch (error) {
            console.error('Invalid JSON:', text);
            alert('Server returned invalid JSON. Check console for details.');
        }
    })
    .catch(error => {
        console.error('Fetch error:', error);
        alert('An error occurred while adding the book');
    });
}
/*
// Add Book functionality
function addBook(event) {
    event.preventDefault();
    
    console.debug('Form submission started.');
    
    const formData = new FormData(event.target);
    
    // Handle multiple authors for new book
    const authorSelect = document.getElementById('addAuthors');
    const selectedAuthors = Array.from(authorSelect.selectedOptions).map(option => option.value);
    formData.append('authorIds', JSON.stringify(selectedAuthors));
    
    console.debug('FormData created:', Array.from(formData.entries()));
    
    fetch('../Admin Actions/AddBook.php', {
        method: 'POST',
        body: formData
    })
    .then(response => response.text())
    .then(text => {
        console.debug('Raw server response:', text);
        
        try {
            const data = JSON.parse(text);
            if (data.success) {
                alert('Book added successfully!');
                event.target.reset();
                // Clear current image display
                document.getElementById('currentImage').innerHTML = '';
            } else {
                alert(data.message || 'Error adding book');
            }
        } catch (error) {
            console.error('Invalid JSON:', text);
            alert('Server returned invalid JSON. Check console for details.');
        }
    })
    .catch(error => {
        console.error('Fetch error:', error);
        alert('An error occurred while adding the book');
    });
}
*/
function resetBookForm() {
    document.getElementById('addBookForm').reset();
    // Clear any error messages
    document.querySelectorAll('.error-message').forEach(elem => {
        elem.style.display = 'none';
    });
    // Clear current image display
    document.getElementById('currentImage').innerHTML = '';
}

// Add these variables at the top of your Book.js file
let currentPage = 1;
let totalPages = 1;
const booksPerPage = 10;

function loadBooks(page, searchTerm = '') {
    fetch(`../Admin Actions/GetBooks.php?page=${page}&search=${encodeURIComponent(searchTerm)}`)
        .then(response => response.json())
        .then(data => {
            const tableBody = document.getElementById('booksTableBody');
            tableBody.innerHTML = '';
            console.log(data);
            
            data.books.forEach(book => {
                tableBody.innerHTML += `
                    <tr>
                        <td>${book.bookid}</td>
                        <td>${book.title}</td>
                        <td>${book.author_names}</td>
                        <td>${book.isbn}</td>
                        <td>${book.totalcopies}</td>
                        <td>
                            <button class="btn btn-edit" onclick="editBook(${book.bookid})">Edit</button>
                            <button class="btn btn-delete" onclick="deleteBook(${book.bookid})">Delete</button>
                        </td>
                    </tr>
                `;
            });
            
            totalPages = data.totalPages;
            currentPage = data.currentPage;
            updatePagination();
        })
        .catch(error => {
            console.error('Error loading books:', error);
            alert('Error loading books');
        });
}

function updatePagination() {
    const pagination = document.querySelector('.pagination');
    pagination.innerHTML = '';
    
    // Previous button
    if (currentPage > 1) {
        pagination.innerHTML += `
            <button onclick="changePage(${currentPage - 1})">Previous</button>
        `;
    }
    
    // First page
    pagination.innerHTML += `
        <button ${currentPage === 1 ? 'class="active"' : ''} onclick="changePage(1)">1</button>
    `;
    
    // Ellipsis and middle pages
    if (totalPages > 2) {
        if (currentPage > 3) {
            pagination.innerHTML += '<button>...</button>';
        }
        
        for (let i = Math.max(2, currentPage - 1); i <= Math.min(totalPages - 1, currentPage + 1); i++) {
            pagination.innerHTML += `
                <button ${currentPage === i ? 'class="active"' : ''} onclick="changePage(${i})">${i}</button>
            `;
        }
        
        if (currentPage < totalPages - 2) {
            pagination.innerHTML += '<button>...</button>';
        }
    }
    
    // Last page
    if (totalPages > 1) {
        pagination.innerHTML += `
            <button ${currentPage === totalPages ? 'class="active"' : ''} onclick="changePage(${totalPages})">${totalPages}</button>
        `;
    }
    
    // Next button
    if (currentPage < totalPages) {
        pagination.innerHTML += `
            <button onclick="changePage(${currentPage + 1})">Next</button>
        `;
    }
}

function changePage(page) {
    currentPage = page;
    const searchTerm = document.querySelector('.search-input').value;
    loadBooks(page, searchTerm);
}

// Modify the existing searchBooks function to work with pagination
function searchBooks() {
    const searchTerm = document.querySelector('.search-input').value;
    currentPage = 1; // Reset to first page on new search
    loadBooks(1, searchTerm);
}