source: Admin.php

main
Last change on this file was 75f74d9, checked in by Vlado 222039 <vlado.popovski@…>, 2 months ago

Initial commit: Adding Book Tracker code
  • Property mode set to 100644
File size: 47.8 KB
Line 
1<?php
2
3session_start();
4
5if (!isset($_SESSION['userid'])) {
6 header("Location: ./Sign&Log.php");
7 exit();
8}
9
10
11require "./connect.php";
12
13try {
14 $stmt = $conn->prepare("SELECT role FROM users WHERE userid = :userid");
15 $stmt->bindParam(':userid', $_SESSION['userid'], PDO::PARAM_INT);
16 $stmt->execute();
17
18 $user = $stmt->fetch(PDO::FETCH_ASSOC);
19
20 if (!$user || $user['role'] !== 'Admin') {
21 header("Location: ./Sign&Log.php");
22 exit();
23 }
24
25} catch (PDOException $e) {
26 echo "Error: " . $e->getMessage();
27 exit();
28}
29
30
31// Query the users table
32//Indexed
33$query = "
34 SELECT users.userid, users.username, users.email, member.membership_status, member.memberid
35 FROM users
36 LEFT JOIN member ON users.userid = member.userid
37";
38
39$res = $conn->query($query);
40
41$users = [];
42
43while($row = $res->fetch(PDO::FETCH_ASSOC)) {
44 $users[] = $row;
45}
46
47
48// SQL query to get loan, book, book_copies, and member information
49 $query = "
50 SELECT loan.loanid, loan.memberid, book.bookid, book_copies.copyid, loan.status
51 FROM loan
52 INNER JOIN book_copies ON loan.bookcopyid = book_copies.copyid
53 INNER JOIN book ON book_copies.bookid = book.bookid
54 INNER JOIN member ON loan.memberid = member.memberid
55 ";
56
57 $res = $conn->query($query);
58
59 $loans = [];
60 while ($row = $res->fetch(PDO::FETCH_ASSOC)) {
61 $loans[] = $row;
62 }
63
64// SQL Query to get Fine
65
66$query = " SELECT * FROM Fine";
67$res = $conn->query($query);
68
69$fines = [];
70
71while($row = $res->fetch(PDO::FETCH_ASSOC)){
72 $fines[] = $row;
73}
74
75
76// SQL Query to get Author
77$query = "SELECT * FROM Author ORDER BY authorid";
78$res = $conn->query($query);
79
80$authors = [];
81
82while($row = $res->fetch(PDO::FETCH_ASSOC)){
83 $authors[] = $row;
84}
85
86// SQL Query to get Book
87$query = "
88 SELECT b.*, a.FirstName, a.LastName
89 FROM Book b
90 JOIN Book_Author ba ON b.BookID = ba.BookID
91 JOIN Author a ON ba.AuthorID = a.AuthorID";
92$res = $conn->query($query);
93
94$books = [];
95
96while($row = $res->fetch(PDO::FETCH_ASSOC)){
97 $books[] = $row;
98}
99
100
101// SQL Query for Dashboiard
102$totalBooksQuery = "SELECT COUNT(*) AS total_books FROM Book";
103$borrowedBooksQuery = "SELECT COUNT(*) AS borrowed_books FROM Loan WHERE status != 'Returned'";
104$totalUsersQuery = "SELECT COUNT(*) AS total_users FROM Users";
105$unpaidFinesQuery = "SELECT SUM(FineAmount) AS unpaid_fines FROM Fine WHERE Status = 'Unpaid'";
106
107// Execute queries
108$totalBooksResult = $conn->query($totalBooksQuery)->fetch(PDO::FETCH_ASSOC);
109$borrowedBooksResult = $conn->query($borrowedBooksQuery)->fetch(PDO::FETCH_ASSOC);
110$totalUsersResult = $conn->query($totalUsersQuery)->fetch(PDO::FETCH_ASSOC);
111$unpaidFinesResult = $conn->query($unpaidFinesQuery)->fetch(PDO::FETCH_ASSOC);
112
113// Data for the dashboard
114$totalBooks = $totalBooksResult['total_books'];
115$borrowedBooks = $borrowedBooksResult['borrowed_books'];
116$totalUsers = $totalUsersResult['total_users'];
117$unpaidFines = $unpaidFinesResult['unpaid_fines'];
118
119
120?>
121
122<!DOCTYPE html>
123<html lang="en">
124<head>
125 <meta charset="UTF-8">
126 <meta name="viewport" content="width=device-width, initial-scale=1.0">
127 <title>Librarian Dashboard</title>
128 <link href='https://fonts.googleapis.com/css?family=EB Garamond' rel='stylesheet'>
129 <link href='https://unpkg.com/boxicons@2.1.4/css/boxicons.min.css' rel='stylesheet'>
130 <link rel="stylesheet" href="./CSS/Admin.css">
131 <link rel="stylesheet" href="DashboardMBooks.css">
132
133 <link rel="stylesheet" href="">
134
135 <style>
136 .autocomplete-wrapper {
137 position: relative;
138 }
139
140 .suggestions-list {
141 position: absolute;
142 top: 100%;
143 left: 0;
144 right: 0;
145 background: white;
146 border: 1px solid #ddd;
147 border-top: none;
148 max-height: 200px;
149 overflow-y: auto;
150 display: none;
151 z-index: 1000;
152 box-shadow: 0 2px 4px rgba(0,0,0,0.1);
153 }
154
155 .suggestion-item {
156 padding: 8px 12px;
157 cursor: pointer;
158 }
159
160 .suggestion-item:hover {
161 background-color: #f5f5f5;
162 }
163 </style>
164
165</head>
166
167<body>
168 <div class="sidebar">
169 <div class="logo-details">
170 <div class="logo_name">Book Tracker</div>
171 <i class='bx bx-menu' id="btn"></i>
172 </div>
173 <ul class="nav-list">
174 <!-- Dashboard link -->
175 <li>
176 <a href="#" onclick="showContent('dashboard')">
177 <i class='bx bx-grid-alt'></i>
178 <span class="links_name">Dashboard</span>
179 </a>
180 </li>
181
182 <!-- Books section -->
183 <li>
184 <a href="#" onclick="toggleSubmenu('books-submenu')">
185 <i class='bx bx-book'></i>
186 <span class="links_name">Books</span>
187 </a>
188 <ul class="submenu" id="books-submenu">
189 <li>
190 <a href="#" onclick="showContent('view-books')">
191 <i class='bx bx-library'></i>
192 <span class="links_name">View & Manage</span>
193 </a>
194 </li>
195 <li>
196 <a href="#" onclick="showContent('add-book')">
197 <i class='bx bx-plus'></i>
198 <span class="links_name">Add New Book</span>
199 </a>
200 </li>
201 <li>
202 <a href="#" onclick="showContent('view-authors')">
203 <i class='bx bx-group'></i>
204 <span class="links_name">View & Manage</span>
205 </a>
206 </li>
207 <li>
208 <a href="#" onclick="showContent('add-author')">
209 <i class='bx bx-user-plus'></i>
210 <span class="links_name">Add New Author</span>
211 </a>
212 </li>
213 </ul>
214 </li>
215
216 <!-- Users section -->
217 <li>
218 <a href="#" onclick="showContent('user')">
219 <i class='bx bx-user'></i>
220 <span class="links_name">Users</span>
221 </a>
222 </li>
223 <!-- Loans section -->
224 <li>
225 <a href="#" onclick="showContent('loans')">
226 <i class='bx bx-cart'></i>
227 <span class="links_name">Loan</span>
228 </a>
229 </li>
230 <!-- Fines section -->
231 <li>
232 <a href="#" onclick="toggleSubmenu('fines-submenu')">
233 <i class='bx bx-money'></i>
234 <span class="links_name">Fines</span>
235 </a>
236 <ul class="submenu" id="fines-submenu">
237 <li>
238 <a href="#" onclick="showContent('view-fines')">
239 <i class='bx bx-list-ul'></i>
240 <span class="links_name">View Fines</span>
241 </a>
242 </li>
243 <li>
244 <a href="#" onclick="showContent('issue-fine')">
245 <i class='bx bx-plus-circle'></i>
246 <span class="links_name">Issue a Fine</span>
247 </a>
248 </li>
249 </ul>
250 </li>
251
252 <!-- Logout & Toggle Mode section -->
253 <li>
254 <a href="./Logout.php" class="action-link">
255 <i class='bx bx-log-out'></i>
256 <span class="links_name">Logout</span>
257 </a>
258 </li>
259
260 <li>
261 <a href="#" onclick="toggleMode()">
262 <i class='bx bx-moon'></i>
263 <span class="links_name">Toggle Mode</span>
264 </a>
265 </li>
266
267 <li>
268 <a href="./CaseViews.php" class="action-link">
269 <i class='bx bx-low-vision'></i>
270 <span class="links_name">Case Views</span>
271 </a>
272 </li>
273 </ul>
274 </div>
275
276 <div id="content-area"></div>
277
278 <script>
279
280 function showContent(contentId) {
281 const contentArea = document.getElementById('content-area');
282
283 switch(contentId) {
284 case 'dashboard':
285 contentArea.innerHTML = `
286 <section class="home-section">
287 <div class="dashboard-container">
288 <div class="cards-container">
289 <!-- Total Books Card -->
290 <div class="card books">
291 <i class='bx bx-book card-icon'></i>
292 <h3 class="card-title">Total Books</h3>
293 <div class="card-value"><?php echo number_format($totalBooks); ?></div>
294 </div>
295
296 <!-- Books Borrowed Card -->
297 <div class="card borrowed">
298 <i class='bx bx-bookmark card-icon'></i>
299 <h3 class="card-title">Books Borrowed</h3>
300 <div class="card-value"><?php echo number_format($borrowedBooks); ?></div>
301 </div>
302
303 <!-- Total Users Card -->
304 <div class="card users">
305 <i class='bx bx-user card-icon'></i>
306 <h3 class="card-title">Total Users</h3>
307 <div class="card-value"><?php echo number_format($totalUsers); ?></div>
308 </div>
309
310 <!-- Unpaid Fines Card -->
311 <div class="card fines">
312 <i class='bx bx-money card-icon'></i>
313 <h3 class="card-title">Unpaid Fines</h3>
314 <div class="card-value">$<?php echo number_format($unpaidFines); ?></div>
315 </div>
316 </div>
317 </div>
318 </section>
319 `;
320 break;
321
322
323 case 'add-book':
324 contentArea.innerHTML = `
325 <section class="home-section" id="add-book-section">
326 <div class="add-book-container">
327 <h2 class="form-header">Add New Book</h2>
328 <form id="addBookForm" onsubmit="addBook(event)">
329 <!-- Book Table Fields -->
330 <div class="form-row">
331 <div class="form-group">
332 <label for="title">Book Title*</label>
333 <input type="text" id="title" name="title" required>
334 <div class="error-message" id="titleError">Please enter a valid title</div>
335 </div>
336 <div class="form-group">
337 <label for="isbn">ISBN*</label>
338 <input type="text" id="isbn" name="isbn" required>
339 <div class="error-message" id="isbnError">Please enter a valid ISBN</div>
340 </div>
341 </div>
342
343 <div class="form-row">
344 <div class="form-group">
345 <label for="genre">Genre*</label>
346 <input type="text" id="genre" name="genre" required>
347 </div>
348 <div class="form-group">
349 <label for="publishedYear">Published Year*</label>
350 <input type="number" id="publishedYear" name="publishedYear" required>
351 </div>
352 </div>
353
354 <div class="form-group">
355 <label for="description">Book Description</label>
356 <textarea id="description" name="description" rows="4"></textarea>
357 </div>
358
359 <div class="form-row">
360 <div class="form-group">
361 <label for="totalCopies">Total Copies*</label>
362 <input type="number" id="totalCopies" name="totalCopies" min="1" required>
363 </div>
364 <div class="form-group">
365 <label for="coverImage">Cover Image</label>
366 <div class="file-upload">
367 <label for="coverImage" class="file-upload-label">
368 <i class='bx bx-upload'></i> Choose Cover Image
369 </label>
370 <input type="file" id="coverImage" name="coverImage" accept="image/*">
371 </div>
372 </div>
373 </div>
374
375 <!-- Book_Details Table Fields -->
376 <div class="form-row">
377 <div class="form-group">
378 <label for="format">Format*</label>
379 <select id="format" name="format" required>
380 <option value="">Select Format</option>
381 <option value="Hardcover">Hardcover</option>
382 <option value="Paperback">Paperback</option>
383 </select>
384 </div>
385 <div class="form-group">
386 <label for="language">Language*</label>
387 <input type="text" id="language" name="language" required>
388 </div>
389 </div>
390
391 <div class="form-row">
392 <div class="form-group">
393 <label for="pages">Number of Pages*</label>
394 <input type="number" id="pages" name="pages" min="1" required>
395 </div>
396 <div class="form-group">
397 <label for="publisher">Publisher*</label>
398 <input type="text" id="publisher" name="publisher" required>
399 </div>
400 </div>
401
402 <div class="form-row">
403 <div class="form-group">
404 <label for="author">Author*</label>
405 <div class="autocomplete-wrapper">
406 <input type="text"
407 id="authorSearch"
408 name="authorSearch"
409 placeholder="Start typing author name..."
410 required>
411 <input type="hidden" id="authorId" name="author">
412 <div id="authorSuggestions" class="suggestions-list"></div>
413 </div>
414 </div>
415 </div>
416
417 <!-- Book_Copies Table Fields -->
418 <div id="copiesSection">
419 <h3>Book Copies</h3>
420 <div id="copiesContainer">
421 <div class="copy-entry form-row">
422 <div class="form-group">
423 <label for="condition">Condition*</label>
424 <select name="condition[]" required>
425 <option value="">Select Condition</option>
426 <option value="New">New</option>
427 <option value="Good">Good</option>
428 <option value="Damaged">Damaged</option>
429 </select>
430 </div>
431 <div class="form-group">
432 <label for="quantity">Quantity*</label>
433 <input type="number" name="quantity[]" min="1" required>
434 </div>
435 <button type="button" class="btn btn-secondary remove-copy" style="display: none;"> <i class='bx bx-x'></i> </button>
436 </div>
437 </div>
438 <button type="button" class="btn btn-secondary" onclick="addCopyEntry()">Add Another Condition</button>
439 </div>
440
441 <div class="btn-container">
442 <button type="button" class="btn btn-secondary" onclick="resetForm()">Clear Form</button>
443 <button type="submit" class="btn btn-primary">Add Book</button>
444 </div>
445 </form>
446 </div>
447 </section>
448 `;
449
450 const script = document.createElement('script');
451 script.textContent = `
452 let timeoutId;
453
454 document.getElementById('authorSearch').addEventListener('input', function(e) {
455 clearTimeout(timeoutId);
456 const searchTerm = e.target.value;
457
458 // Clear previous selection when input changes
459 document.getElementById('authorId').value = '';
460
461 if (searchTerm.length < 2) {
462 document.getElementById('authorSuggestions').style.display = 'none';
463 return;
464 }
465
466 // Add delay to prevent too many requests
467 timeoutId = setTimeout(() => {
468 fetchAuthors(searchTerm);
469 }, 300);
470 });
471
472 // Prevent manual entry without selection
473 document.getElementById('authorSearch').addEventListener('change', function(e) {
474 const authorId = document.getElementById('authorId').value;
475 if (!authorId || authorId.trim() === '') {
476 // If no author is selected from suggestions, clear the input
477 setTimeout(() => {
478 if (!document.getElementById('authorId').value) {
479 this.value = '';
480 }
481 }, 200);
482 }
483 });
484
485 function fetchAuthors(searchTerm) {
486 fetch('../Admin Actions/GetAuthor.php?search=' + encodeURIComponent(searchTerm))
487 .then(response => response.json())
488 .then(authors => {
489 console.log('Authors response:', authors); // Add this line to see the response
490 const suggestionsDiv = document.getElementById('authorSuggestions');
491 suggestionsDiv.innerHTML = '';
492
493 if (authors.length > 0) {
494 authors.forEach(author => {
495 const div = document.createElement('div');
496 div.className = 'suggestion-item';
497 div.textContent = \`\${author.firstname} \${author.lastname}\`;
498 div.addEventListener('click', () => {
499 // Update both the visible search field and hidden author ID
500 document.getElementById('authorSearch').value = \`\${author.firstname} \${author.lastname}\`;
501 document.getElementById('authorId').value = author.authorid;
502 console.log('Set author ID to:', author.authorid); // Add this line
503 suggestionsDiv.style.display = 'none';
504 });
505 suggestionsDiv.appendChild(div);
506 });
507 suggestionsDiv.style.display = 'block';
508 } else {
509 suggestionsDiv.style.display = 'none';
510 }
511 })
512 .catch(error => {
513 console.error('Error fetching authors:', error);
514 });
515 }
516
517 // Close suggestions when clicking outside
518 document.addEventListener('click', function(e) {
519 if (!e.target.closest('.autocomplete-wrapper')) {
520 document.getElementById('authorSuggestions').style.display = 'none';
521 }
522 });
523
524 function addCopyEntry() {
525 const container = document.getElementById('copiesContainer');
526 const firstEntry = container.querySelector('.copy-entry');
527 const newEntry = firstEntry.cloneNode(true); // Clone the first entry
528
529 // Reset values for the new entry
530 newEntry.querySelector('select').value = '';
531 newEntry.querySelector('input').value = '';
532
533 // Show the remove button for the new entry
534 const removeButton = newEntry.querySelector('.remove-copy');
535 removeButton.style.display = 'block';
536
537 // Add remove button functionality
538 removeButton.addEventListener('click', function() {
539 newEntry.remove(); // Remove the entry
540 updateTotalCopies(); // Update the total copies
541 });
542
543 // Append the new entry to the container
544 container.appendChild(newEntry);
545
546 // Update the total copies after adding a new entry
547 updateTotalCopies();
548 }
549
550 function updateTotalCopies() {
551 const quantityInputs = document.querySelectorAll('#copiesContainer input[name="quantity[]"]');
552 let totalCopies = 0;
553
554 // Sum up all the quantities
555 quantityInputs.forEach(input => {
556 const quantity = parseInt(input.value) || 0; // Convert to integer or default to 0
557 totalCopies += quantity;
558 });
559
560 // Update the totalCopies input field (if it exists)
561 const totalCopiesInput = document.querySelector('input[name="totalCopies"]');
562 if (totalCopiesInput) {
563 totalCopiesInput.value = totalCopies;
564 }
565 }
566
567 // Add event listener to the copies container for quantity changes
568 document.getElementById('copiesContainer').addEventListener('input', function(e) {
569 if (e.target.name === 'quantity[]') {
570 updateTotalCopies();
571 }
572 });
573
574 // Disable remove button for the first entry
575 const firstEntryRemoveButton = document.querySelector('#copiesContainer .copy-entry .remove-copy');
576 if (firstEntryRemoveButton) {
577 firstEntryRemoveButton.style.display = 'none';
578 }
579
580 function resetForm() {
581 document.getElementById('addBookForm').reset();
582 const container = document.getElementById('copiesContainer');
583 const entries = container.querySelectorAll('.copy-entry');
584 // Keep the first entry, remove the rest
585 for (let i = 1; i < entries.length; i++) {
586 entries[i].remove();
587 }
588 updateTotalCopies();
589 }`;
590 document.body.appendChild(script);
591 break;
592
593 case 'view-books':
594 contentArea.innerHTML = `
595 <section class="home-section">
596 <div class="manage-books-container">
597 <div class="controls-section">
598 <div class="search-container">
599 <input type="text" class="search-input" placeholder="Search by title, author, or ISBN...">
600 <button class="btn btn-edit" onclick="searchBooks()">Search</button>
601 </div>
602 </div>
603
604 <table class="books-table">
605 <thead>
606 <tr>
607 <th>Book ID</th>
608 <th>Title</th>
609 <th>Author</th>
610 <th>ISBN</th>
611 <th>Copies</th>
612 <th>Actions</th>
613 </tr>
614 </thead>
615 <tbody id="booksTableBody">
616 <?php foreach($books as $book): ?>
617 <tr>
618 <td><?php echo htmlspecialchars($book['bookid']); ?></td>
619 <td><?php echo htmlspecialchars($book['title']); ?></td>
620 <td><?php echo htmlspecialchars($book['firstname'] . ' ' . $book['lastname']); ?></td>
621 <td><?php echo htmlspecialchars($book['isbn']); ?></td>
622 <td><?php echo htmlspecialchars($book['totalcopies']); ?></td>
623 <td>
624 <button class="btn btn-edit" onclick="editBook(<?php echo $book['bookid']; ?>)">Edit</button>
625 <button class="btn btn-delete" onclick="deleteBook(<?php echo $book['bookid']; ?>)">Delete</button>
626 </td>
627 </tr>
628 <?php endforeach; ?>
629 </tbody>
630 </table>
631
632 <div class="pagination">
633 <button onclick="changePage(1)">1</button>
634 <button onclick="changePage(2)">2</button>
635 <button onclick="changePage(3)">3</button>
636 <button>...</button>
637 </div>
638 </div>
639 </section>
640
641 <!-- Edit Book Modal -->
642 <div id="editModal" class="modal">
643 <div class="modal-content">
644 <span class="close-modal" onclick="closeModal()">&times;</span>
645 <h2>Edit Book</h2>
646 <form id="editBookForm" onsubmit="updateBook(event)">
647 <input type="hidden" id="bookId" name="bookId">
648
649 <!-- Book Table Fields -->
650 <div class="form-row">
651 <div class="form-group">
652 <label for="editTitle">Book Title*</label>
653 <input type="text" id="editTitle" name="title" required>
654 <div class="error-message" id="editTitleError">Please enter a valid title</div>
655 </div>
656 <div class="form-group">
657 <label for="editIsbn">ISBN*</label>
658 <input type="text" id="editIsbn" name="isbn" required>
659 <div class="error-message" id="editIsbnError">Please enter a valid ISBN</div>
660 </div>
661 </div>
662
663 <div class="form-row">
664 <div class="form-group">
665 <div class="form-group">
666 <label for="editGenre">Genre*</label>
667 <input type="text" id="editGenre" name="genre" required>
668 <div class="error-message" id="editGenreError">Please enter a valid Genre</div>
669 </div>
670 </div>
671 <div class="form-group">
672 <label for="editPublishedYear">Published Year*</label>
673 <input type="number" id="editPublishedYear" name="publishedYear" required min="1800" max="2024">
674 </div>
675 </div>
676
677 <div class="form-group">
678 <label for="editDescription">Book Description</label>
679 <textarea id="editDescription" name="description" rows="4"></textarea>
680 </div>
681
682 <div class="form-row">
683 <div class="form-group">
684 <label for="editTotalCopies">Total Copies*</label>
685 <input type="number" id="editTotalCopies" name="totalCopies" min="1" required>
686 </div>
687 <div class="form-group">
688 <label for="editCoverImage">Cover Image</label>
689 <div class="file-upload">
690 <label for="editCoverImage" class="file-upload-label">
691 <i class='bx bx-upload'></i> Choose Cover Image
692 </label>
693 <input type="file" id="editCoverImage" name="coverImage" accept="image/*">
694 <div id="currentCoverImage"></div>
695 </div>
696 </div>
697 </div>
698
699 <!-- Book_Details Table Fields -->
700 <div class="form-row">
701 <div class="form-group">
702 <div class="form-group">
703 <label for="editFormat">Format*</label>
704 <input type="text" id="editFormat" name="format" required>
705 <div class="error-message" id="editFormatError">Please enter a valid Format</div>
706 </div>
707 </div>
708 <div class="form-group">
709 <label for="editLanguage">Language*</label>
710 <input type="text" id="editLanguage" name="language" required>
711 </div>
712 </div>
713
714 <div class="form-row">
715 <div class="form-group">
716 <label for="editPages">Number of Pages*</label>
717 <input type="number" id="editPages" name="pages" min="1" required>
718 </div>
719 <div class="form-group">
720 <label for="editPublisher">Publisher*</label>
721 <input type="text" id="editPublisher" name="publisher" required>
722 </div>
723 </div>
724
725 <div class="form-actions">
726 <button type="submit" class="btn btn-primary">Save Changes</button>
727 <button type="button" class="btn btn-secondary" onclick="closeModal()">Cancel</button>
728 </div>
729 </form>
730 </div>
731 </div>`;
732 break;
733
734 // ====================== ADD AUTHORS ====================== //
735 case 'add-author':
736 contentArea.innerHTML = `
737 <section class="home-section" id="add-author-section">
738 <div class="add-book-container">
739 <h2 class="form-header">Add New Author</h2>
740 <form id="addAuthorForm" onsubmit="handleAuthorSubmit(event)">
741 <div class="form-row">
742 <div class="form-group">
743 <label for="firstName">First Name*</label>
744 <input type="text" id="firstName" name="firstName" required>
745 <div class="error-message" id="firstNameError">Please enter a valid first name</div>
746 </div>
747 <div class="form-group">
748 <label for="lastName">Last Name*</label>
749 <input type="text" id="lastName" name="lastName" required>
750 <div class="error-message" id="lastNameError">Please enter a valid last name</div>
751 </div>
752 </div>
753
754 <div class="form-row">
755 <div class="form-group">
756 <label for="nationality">Nationality*</label>
757 <input type="text" id="nationality" name="nationality" required>
758 <div class="error-message" id="nationalityError">Please enter nationality</div>
759 </div>
760 <div class="form-group">
761 <label for="dateOfBirth">Date of Birth*</label>
762 <input type="date" id="dateOfBirth" name="dateOfBirth" required>
763 <div class="error-message" id="dobError">Please enter a valid date</div>
764 </div>
765 </div>
766
767 <div class="form-group">
768 <label for="authorDescription">Author Description</label>
769 <textarea id="authorDescription" name="authorDescription" rows="4" placeholder="Enter author's biography, achievements, and other relevant information..."></textarea>
770 </div>
771
772 <div class="form-group">
773 <label for="authorImage">Author Image</label>
774 <div class="file-upload">
775 <label for="authorImage" class="file-upload-label">
776 <i class='bx bx-upload'></i> Choose Author Image
777 </label>
778 <input type="file" id="authorImage" name="authorImage" accept="image/*">
779 </div>
780 </div>
781
782 <div class="btn-container">
783 <button type="button" class="btn btn-secondary" onclick="resetAuthorForm()">Clear Form</button>
784 <button type="submit" class="btn btn-primary">Add Author</button>
785 </div>
786 </form>
787 </div>
788 </section>`;
789 break;
790 // ====================== VIEW AUTHORS ====================== //
791 case 'view-authors':
792 contentArea.innerHTML = `
793 <section class="home-section">
794 <div class="manage-authors-container">
795 <div class="controls-section">
796 <div class="search-container">
797 <input type="text" class="search-input" placeholder="Search by name, nationality...">
798 <button class="btn btn-edit" onclick="searchAuthors()">Search</button>
799 </div>
800 </div>
801
802 <table class="authors-table">
803 <thead>
804 <tr>
805 <th>Author ID</th>
806 <th>First Name</th>
807 <th>Last Name</th>
808 <th>Nationality</th>
809 <th>Actions</th>
810 </tr>
811 </thead>
812 <tbody id="authorsTableBody">
813 <?php foreach($authors as $author): ?>
814 <tr>
815 <td><?php echo htmlspecialchars($author['authorid']); ?></td>
816 <td><?php echo htmlspecialchars($author['firstname']); ?></td>
817 <td><?php echo htmlspecialchars($author['lastname']); ?></td>
818 <td><?php echo htmlspecialchars($author['nationality']); ?></td>
819 <td>
820 <button class="btn btn-edit" onclick="editAuthor(<?php echo $author['authorid']; ?>)">Edit</button>
821 <button class="btn btn-delete" onclick="deleteAuthor(<?php echo $author['authorid']; ?>)">Delete</button>
822 </td>
823 </tr>
824 <?php endforeach; ?>
825 </tbody>
826 </table>
827 </div>
828 </section>
829
830 <!-- EDIT AUTHOR -->
831 <div id="editAuthorModal" class="modal">
832 <div class="modal-content">
833 <span class="close-modal" onclick="closeAuthorModal()">&times;</span>
834 <h2>Edit Author Information</h2>
835 <form id="editAuthorForm" onsubmit="updateAuthor(event)" enctype="multipart/form-data">
836 <input type="hidden" id="authorId" name="authorId">
837
838 <div class="form-row">
839 <div class="form-group">
840 <label for="firstName">First Name*</label>
841 <input type="text" id="firstName" name="firstName" required>
842 </div>
843 <div class="form-group">
844 <label for="lastName">Last Name*</label>
845 <input type="text" id="lastName" name="lastName" required>
846 </div>
847 </div>
848
849 <div class="form-row">
850 <div class="form-group">
851 <label for="nationality">Nationality*</label>
852 <input type="text" id="nationality" name="nationality" required>
853 </div>
854 <div class="form-group">
855 <label for="dateOfBirth">Date of Birth*</label>
856 <input type="date" id="dateOfBirth" name="dateOfBirth" required>
857 </div>
858 </div>
859
860 <div class="form-group">
861 <label for="authorDescription">Author Description</label>
862 <textarea id="authorDescription" name="authorDescription" rows="4" placeholder="Enter author's biography, achievements, and other relevant information..."></textarea>
863 </div>
864
865 <div class="form-group">
866 <label for="authorImage">Author Image</label>
867 <div class="file-upload">
868 <label for="authorImage" class="file-upload-label">
869 <i class='bx bx-upload'></i> Choose Author Image
870 </label>
871 <input type="file" id="authorImage" name="authorImage" accept="image/*">
872 </div>
873 <div id="currentImage"></div>
874 </div>
875
876 <div class="button-group">
877 <button type="submit" class="btn btn-primary">Update</button>
878 <button type="button" class="btn btn-secondary" onclick="closeAuthorModal()">Cancel</button>
879 </div>
880 </form>
881 </div>
882 </div>
883 `;
884 break;
885 // ====================== VIEW USERS ====================== //
886 case 'user':
887 contentArea.innerHTML = `
888 <section class="home-section">
889 <div class="manage-users-container">
890 <div class="controls-section">
891 <div class="search-container">
892 <input type="text" class="search-input" placeholder="Search by username or email...">
893 <button class="btn btn-edit" onclick="searchUsers()">Search</button>
894 </div>
895 </div>
896
897 <table class="users-table">
898 <thead>
899 <tr>
900 <th>User ID</th>
901 <th>Username</th>
902 <th>Email</th>
903 <th>Status</th>
904 <th>Actions</th>
905 </tr>
906 </thead>
907 <tbody id="usersTableBody">
908 <?php foreach($users as $user): ?>
909 <tr>
910 <td><?php echo htmlspecialchars($user['userid']); ?></td>
911 <td><?php echo htmlspecialchars($user['username']); ?></td>
912 <td><?php echo htmlspecialchars($user['email']); ?></td>
913 <td><?php echo (isset($user['membership_status'])) ? htmlspecialchars($user['membership_status']) : 'Not a Member'; ?></td>
914 <td>
915 <button class="btn btn-edit" onclick="editUser(<?php echo $user['userid']; ?>)">Edit</button>
916 </td>
917 </tr>
918 <?php endforeach; ?>
919 </tbody>
920 </table>
921 </div>
922 </section>
923
924 <!-- Edit User Modal -->
925 <div id="editModal" class="modal">
926 </div>`;
927 break;
928 // ====================== VIEW LOANS ====================== //
929 case 'loans':
930 contentArea.innerHTML = `
931 <section class="home-section">
932 <div class="manage-loans-container">
933 <div class="controls-section">
934 <div class="search-container">
935 <input type="text" class="search-input" placeholder="Search by loan, book or copy...">
936 <button class="btn btn-edit" onclick="searchLoans()">Search</button>
937 </div>
938 </div>
939 <table class="loans-table">
940 <thead>
941 <tr>
942 <th>Loan ID</th>
943 <th>Member ID</th>
944 <th>Book ID</th>
945 <th>Copy ID</th>
946 <th>Status</th>
947 </tr>
948 </thead>
949 <tbody id="loansTableBody">
950 <?php foreach($loans as $loan): ?>
951 <tr>
952 <td><?php echo htmlspecialchars($loan['loanid']); ?></td>
953 <td><?php echo htmlspecialchars($loan['memberid']); ?></td>
954 <td><?php echo htmlspecialchars($loan['bookid']); ?></td>
955 <td><?php echo htmlspecialchars($loan['copyid']); ?></td>
956 <td style="color:
957 <?php
958 if ($loan['status'] === 'Returned') {
959 echo '#1e7e34'; // Green
960 } elseif ($loan['status'] === 'Overdue') {
961 echo '#c81e1e'; // Red
962 } else {
963 echo '#000000'; // Default black
964 }
965 ?>;">
966 <?php echo htmlspecialchars($loan['status']); ?>
967 </td>
968 </tr>
969 <?php endforeach; ?>
970 </tbody>
971 </table>
972 </div>
973 </section>`;
974 break;
975 // ====================== VIEW FINES ====================== //
976 case 'view-fines':
977 contentArea.innerHTML = `
978 <section class="home-section">
979 <div class="manage-fines-container">
980 <div class="controls-section">
981 <div class="search-container">
982 <input type="text" class="search-input" placeholder="Search by loan, fine or amount...">
983 <button class="btn btn-edit" onclick="searchFines()">Search</button>
984 </div>
985 </div>
986
987 <table class="fines-table">
988 <thead>
989 <tr>
990 <th>Loan ID</th>
991 <th>Fine ID</th>
992 <th>Amount</th>
993 <th>Status</th>
994 </tr>
995 </thead>
996 <tbody id="finesTableBody">
997 <?php foreach($fines as $fine): ?>
998 <tr>
999 <td><?php echo htmlspecialchars($fine['loanid']); ?></td>
1000 <td><?php echo htmlspecialchars($fine['fineid']); ?></td>
1001 <td>$<?php echo number_format(htmlspecialchars($fine['fineamount']), 2); ?></td>
1002 <td style="color:
1003 <?php
1004 if ($fine['status'] === 'Paid') {
1005 echo '#1e7e34'; // Green
1006 } elseif ($fine['status'] === 'Unpaid') {
1007 echo '#c81e1e'; // Red
1008 } else {
1009 echo '#000000'; // Default black
1010 }
1011 ?>;">
1012 <?php echo htmlspecialchars($fine['status']); ?>
1013 </td>
1014 </tr>
1015 <?php endforeach; ?>
1016 </tbody>
1017 </table>
1018 </div>
1019 </section>`;
1020 break;
1021 // ====================== ISSUE FINE ====================== //
1022 case 'issue-fine':
1023 loadScript('/Admin Scripts/Fines.js');
1024 break;
1025
1026 case 'case-views':
1027 break;
1028
1029 default:
1030 contentArea.innerHTML = `<h2>Content Not Found</h2>`;
1031 }
1032 }
1033
1034 </script>
1035
1036 <script>
1037 function handleSubmit(event) {
1038 event.preventDefault();
1039 const formData = new FormData(event.target);
1040 console.log('Adding Book:', Object.fromEntries(formData));
1041 }
1042 </script>
1043
1044 <script src="/Admin Scripts/UpdateUserStatus.js"></script>
1045 <script src="/Admin Scripts/Loans.js"></script>
1046 <script src="/Admin Scripts/Fines.js"></script>
1047 <script src="/Admin Scripts/Author.js"></script>
1048 <script src="/Admin Scripts/Sidebar.js"></script>
1049 <script src="/Admin Scripts/Books.js"></script>
1050
1051
1052 <script>
1053 function loadScript(filename) {
1054 const script = document.createElement('script');
1055 script.src = filename;
1056 script.type = 'text/javascript';
1057 script.onload = function() {
1058 console.log(`${filename} loaded successfully`);
1059 if (filename === '/Admin Scripts/Fines.js') {
1060 showIssueFineContent(); // Call function after script loads
1061 }
1062 };
1063 script.onerror = function() {
1064 console.error(`Failed to load script: ${filename}`);
1065 };
1066 document.head.appendChild(script);
1067 }
1068 </script>
1069
1070
1071</body>
1072</html>
Note: See TracBrowser for help on using the repository browser.