Library/reservation.php at master · matej-oliva/Library · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
<?php

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

    $bookID = $_GET['bookID'];

    $queryInfo = $db->prepare(
        'SELECT books.book_id AS bookID, books.name AS bookName, books.max_stock AS maxStock, books.borrowed AS borrowed
        FROM books
        WHERE book_id = '.$bookID.'
        ORDER BY books.name ASC');

    $queryInfo->execute();

    $book = $queryInfo->fetch();
    if(empty($book)){
        echo '<div class="alert alert-info">Nebyly nalezeny žádné knihy.</div>';
    }else{
        $bookID = $book['bookID'];
        $bookName = $book['bookName'];
        $bookStock = $book['maxStock'];
        $bookBor = $book['borrowed'];
    };
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        #region smazani knihy
        if($bookStock > $bookBor){
            $loanQuery=$db->prepare('INSERT INTO library_loaned_books (user_id, book_id, loan_start_date, loan_expire_date, extended)
            VALUES (:user_id, :bookID, Now(), DATE_ADD(Now(), INTERVAL 1 MONTH), 0);');
            $loanQuery->execute(array(
                ':user_id'=>$_SESSION['user_id'],
                ':bookID'=>$bookID
            ));

            $borQuery=$db->prepare('UPDATE books SET borrowed = borrowed + 1 WHERE book_id=?;');
            $borQuery->execute(array(
                $bookID
            ));

            header('Location: book_list.php');
            exit();
        }else{
            echo '<div class="alert alert-danger">Aktuálně není žádná kniha k vypůjčení, počkejte až knihu někdo vrátí.</div>';
        }
        #endregion pujceni knihy
    };

    $pageTitle="Výpůjčka knihy";
    include 'include/header.php';
?>

<div class="row">
    <h2 class="col">Výpůjčka knihy</h2>
</div>

        <div class="new_book-form pt-5">
            <form method="POST">
                <h2 class="text-center mb-4 pl-4">Chcete si tuto knihu vypůjčit?</h2>
                <div class="form-group">
                    <input id="delete_name" type="text" disabled class="form-control text-center font-weight-bold<?php echo(!empty($errors['delete_name']) ? ' is-invalid' : ''); ?>"
                        name="delete_name" value="<?php echo ''.htmlspecialchars($book['bookName']).'';?>"/>
                    <?php
                        echo (!empty($errors['delete_name'])?'<div class="invalid-feedback">'.$errors['delete_name'].'</div>':'');
                    ?>
                </div>
                <div class="form-group">
                    <div class="input-group">
                        <a href="book_list.php" class="col btn btn-outline-secondary mr-2">Zrušit</a>
                        <button type="submit" class="btn btn-success col form-control ml-2">ANO!</button>
                    </div>
                </div>
            </form>
        </div>


<?php
    include 'include/footer.php';
?>