Data Peminjam

Tambah Data Peminjam

<?php include __DIR__. './../../includes/config.php'; ?>
<?php include __DIR__. './../../includes/header.php'; ?>

    <?php
        $query = "SELECT * FROM buku";
        $stmt = $pdo->query($query);
        $buku = $stmt->fetchAll(PDO::FETCH_ASSOC);
    ?>

    <div class="card border-radius p-4">
        <!-- baris judul dan kembali -->
        <div class="row align-item-center">
            <div class="col">
                <h2>Tambah Data Peminjam</h2>
            </div>
            <div class="col text-end">
                <a href="/views/data-kategori-buku" class="btn btn-outline-secondary"><i class="fa-solid fa-arrow-right-to-bracket"></i></a>
            </div> 
        </div>

        <!-- form -->
         <div class="row mt-4">
            <div class="col">
                <form action="" method="post">
                    <div class="mb-3">
                        <label for="inputNamaBuku" class="form-label">Buku</label>
                        <select name="bukuID" id="" class="form-control">
                            <option disabled selected>-- Pilih Data Buku --</option>
                            <?php foreach ($buku as $bk) : ?>
                                <option value="<?= $bk['buku_id'] ?>"><?= $bk['name'] ?></option>
                            <? endforeach; ?>
                        </select>
                    </div>
                    <div class="row mb-3">
                        <div class="col-md-6">
                            <label for="inputTglPeminjaman" class="form-label">Tgl Peminjaman</label>
                            <input type="date" name="tglPeminjaman" class="form-control" id="inputTglPeminjaman">
                        </div>
                        <div class="col-md-6">
                            <label for="inputTglPengembalian" class="form-label">Tgl Pengembalian</label>
                            <input type="date" name="tglPengembalian" class="form-control" id="inputTglPengembalian">
                        </div>
                    </div>
                    <div>
                        <button type="submit" class="btn btn-primary btn-sm"><i class="fa-solid fa-floppy-disk"></i></button>
                        <button type="reset" class="btn btn-secondary btn-sm"><i class="fa-solid fa-eraser"></i></button>
                    </div>
                </form>
            </div>
         </div>
    </div>

    <?php

        if ($_SERVER["REQUEST_METHOD"] == "POST") {

            $pdo->beginTransaction();

            date_default_timezone_set('Asia/Jakarta');

            $bukuID = $_POST['bukuID'];
            $tglPeminjaman = $_POST['tglPeminjaman'];
            $tglPengembalian = $_POST['tglPengembalian'];
            $status = 'dipinjam';

            $sql = "
                INSERT INTO peminjam 
                (UserID, BukuID, TanggalPeminjaman, TanggalPengembalian, StatusPeminjaman) 
                VALUES (:userID,  :bukuID, :tanggalPeminjaman, :tanggalPengembalian, :statusPeminjaman)
            ";
            $stmt = $pdo->prepare($sql);
            
            $stmt->bindParam(':userID', $_SESSION['UserID']);
            $stmt->bindParam(':bukuID', $bukuID);
            $stmt->bindParam(':tanggalPeminjaman', $tglPeminjaman);
            $stmt->bindParam(':tanggalPengembalian', $tglPengembalian);
            $stmt->bindParam(':statusPeminjaman', $status);
            $stmt->execute();
            
            if ($pdo->commit()) {
                echo "<script>alert('Data berhasil ditambah!'); window.location.replace('/views/data-peminjam/index.php');</script>";
            } else {
                echo "Failed to create user.";
            }
        }
    ?>

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

List Data Peminjam

<?php include __DIR__. './../../includes/config.php'; ?>
<?php include __DIR__. './../../includes/header.php'; ?>


    <?php
        $query = "
            SELECT user.NamaLengkap as NamaLengkap, buku.name as NamaBuku, peminjam.* FROM peminjam
            Join user on user.UserID = peminjam.UserID
            Join buku on buku.buku_id = peminjam.BukuID
            where peminjam.UserID =
        ".$_SESSION['UserID'];
        $stmt = $pdo->query($query);
        $datas = $stmt->fetchAll(PDO::FETCH_ASSOC);
    ?>

    <div class="card border-radius p-4">
        <!-- baris judul dan tambah data pengguna -->
        <div class="row align-item-center">
            <div class="col">
                <h2>List Data Peminjam</h2>
            </div>
            <div class="col text-end">
                <a href="/views/data-peminjam/create.php" class="btn btn-outline-primary" > <i class="fa-solid fa-user-plus"></i> Tambah Data Peminjam</a>
            </div> 
        </div>

        <!-- table -->
         <div class="row mt-4">
            <div class="col">
                <table class="table table-border table-striped">
                    <thead>
                        <tr>
                            <th>No</th>
                            <th>Nama</th>
                            <th>Buku</th>
                            <th>Tgl Peminjaman</th>
                            <th>Tgl Pengembalian</th>
                            <th>Status</th>
                            <th class="text-center">Aksi</th>
                        </tr>
                    </thead>
                    <tbody>
                        <!-- start looping foreach -->
                        <?php foreach ($datas as $key => $data) : ?>
                        <tr>
                            <td>
                                <?= $key + 1 ?>
                            </td>
                            <td>
                                <?= $data['NamaLengkap'] ?>
                            </td>
                            <td>
                                <?= $data['NamaBuku'] ?>
                            </td>
                            <td>
                                <?= $data['TanggalPeminjaman'] ?>
                            </td>
                            <td>
                                <?= $data['TanggalPengembalian'] ?>
                            </td>
                            <td>
                                <span 
                                    class="
                                        text-capitalize 
                                        badge 
                                        <?= $data['StatusPeminjaman'] === 'dipinjam' ? 'text-bg-warning' : 'text-bg-success' ?>
                                    ">
                                        <?= $data['StatusPeminjaman'] ?>
                                    </span>
                            </td>
                            <td class="text-center">
                                <a href="/views/data-peminjam/detail.php?peminjam_id=<?= $data['PeminjamID'] ?>" class="btn btn-sm btn-info"><i class="fa-solid fa-eye"></i></a>
                                <a href="/views/data-peminjam/edit.php?peminjam_id=<?= $data['PeminjamID'] ?>" class="btn btn-sm btn-warning"><i class="fa-solid fa-pen-to-square"></i></a>
                                <a href="/views/data-peminjam/delete.php?peminjam_id=<?= $data['PeminjamID'] ?>" class="btn btn-sm btn-danger"><i class="fa-solid fa-trash-can"></i></a>
                            </td>
                        </tr>
                        <?php endforeach; ?>
                        <!-- end looping foreach -->
                    </tbody>
                </table>
            </div>
         </div>
    </div>

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