book_list.php

<?php

    require_once 'include/user.php';
    require_once 'user_required.php';
    

    $query = $db->prepare( 
        'SELECT books.*, books.book_id AS bookID, books.name AS bookName, library_authors.name AS bookAuthor, 
        books.max_stock AS bookMax, books.borrowed AS bookLoaned, books.description AS bookDescr, library_genres.name AS genre  
        FROM books JOIN library_authors USING (author_id) JOIN library_genres USING (genre_id)
        ORDER BY library_authors.name ASC');

    $query->execute();

    $book_list = $query->fetchAll(PDO::FETCH_ASSOC);
    if(empty($book_list)){
        echo '<div class="alert alert-info">Nebyly nalezeny žádné knihy.</div>';
    };

    $pageTitle="Seznam knih";
    include 'include/header.php';
?>      
        <div class="row">
            <h2 class="col-4 mt-2 mx-3">Seznam knih</h2>
            <div class="input-group flex-nowrap col-3 py-2 px-2 mr-auto mt-1 text-center">
                <div class="input-group-prepend">
                    <span class="input-group-text fa fa-search"></span>
                </div>
                <input class="form-control" id="searchBar" type="text" placeholder="Vyhledat knihu, autora, žánr">
            </div>
            <form action="users.php" method="GET" class="col text-right py-2 mr-3">
            <?php
            if($role > 1){
            echo '<a href="new_book.php" class="btn btn-success px-4 mt-1">Přidat knihu</a>';
            }
            ?>
            </form>
        </div>
        
    <div class="col w-100 px-0 pb-5">
        <ul class="list-group mx-3" id="searchList">
        <?
        foreach($book_list as $book){
            $availableBooks = $book['bookMax'] - $book['bookLoaned'];
            echo '<li class="list-group-item col border border-dark my-1 py-1 w-100 bg-secondary text-white">';
            echo '  <div class="row">';
            echo '      <div class="col ml-4">';
            echo '          <div class="row">';
            echo '              <h4><a href="./book_detail.php?bookID='.$book['bookID'].'" class="badge badge-light">'.htmlspecialchars($book['bookName']).'</a></h4>';
            echo '              <h6><div class="badge badge-warning ml-3">'.htmlspecialchars($book['genre']).'</div></h6>';
            echo '          </div>';
            
            echo '          <div>'.nl2br(htmlspecialchars($book['bookAuthor'])).'</div>';
            echo '      </div>';

            echo '      <div class="col text-right">';
            echo '          <div class="small text-white mt-1">'.'Aktuálně&nbsp;dostupné:&nbsp;'.$availableBooks.'</div>';
            echo '          <div class="row text-right">';
            echo '              <div class="col text-right">';
            echo '                  <a href="./reservation.php?bookID='.$book['bookID'].'" class="btn btn-info btn-sm">Vypůjčit</a>';
            if($role > 1){
            echo '                  <a href="./books_edit.php?bookID='.$book['bookID'].'" class="btn btn-light btn-sm">Upravit</a>';
            echo '                  <a href="./book_delete.php?bookID='.$book['bookID'].'" class="btn btn-danger btn-sm">Smazat</a>';
            }
            echo '              </div>';
            echo '          </div>';
            echo '      </div>';
            
            echo '  </div>';
            echo '  </li>';
        }
        ?>
        </ul>
    </div>
        
<?php
    include 'include/footer.php';
?>