<?php
require_once __DIR__ . '/header.php';
?>

<section class="content-header">

    <div class="content-header-left">
        <h1>View Photos</h1>
    </div>

    <div class="content-header-right">
        <a href="photo-add.php" class="btn btn-primary btn-sm">
            Add New
        </a>
    </div>

</section>

<section class="content">

    <div class="row">

        <div class="col-md-12">

            <div class="box box-info">

                <div class="box-body table-responsive">

                    <table
                        id="example1"
                        class="table table-bordered table-striped">

                        <thead>

                            <tr>
                                <th>#</th>
                                <th>Caption</th>
                                <th>Photo</th>
                                <th>Action</th>
                            </tr>

                        </thead>

                        <tbody>

                            <?php
                            $i = 0;

                            $statement = $pdo->prepare("
                                SELECT *
                                FROM tbl_photo
                                ORDER BY id DESC
                            ");

                            $statement->execute();

                            $result = $statement->fetchAll(PDO::FETCH_ASSOC);

                            foreach ($result as $row):

                                $i++;

                                $photo_file = trim($row['photo'] ?? '');

                                $photo_path = '../assets/images/gallery/' . $photo_file;
                            ?>

                                <tr>

                                    <td>
                                        <?= $i ?>
                                    </td>

                                    <td>
                                        <?= htmlspecialchars(
                                            $row['caption'] ?? '',
                                            ENT_QUOTES,
                                            'UTF-8'
                                        ) ?>
                                    </td>

                                    <td>

                                        <?php if (!empty($photo_file)): ?>

                                            <img
                                                src="<?= htmlspecialchars(
                                                    $photo_path,
                                                    ENT_QUOTES,
                                                    'UTF-8'
                                                ) ?>"
                                                alt="<?= htmlspecialchars(
                                                    $row['caption'] ?? 'Gallery Image',
                                                    ENT_QUOTES,
                                                    'UTF-8'
                                                ) ?>"
                                                width="140"
                                                style="height:90px;object-fit:cover;border-radius:5px;">

                                        <?php else: ?>

                                            <span class="label label-default">
                                                No Image
                                            </span>

                                        <?php endif; ?>

                                    </td>

                                    <td>

                                        <a
                                            href="photo-edit.php?id=<?= (int)$row['id'] ?>"
                                            class="btn btn-primary btn-xs">
                                            Edit
                                        </a>

                                        <a
                                            href="#"
                                            class="btn btn-danger btn-xs"
                                            data-href="photo-delete.php?id=<?= (int)$row['id'] ?>"
                                            data-toggle="modal"
                                            data-target="#confirm-delete">
                                            Delete
                                        </a>

                                    </td>

                                </tr>

                            <?php endforeach; ?>

                        </tbody>

                    </table>

                </div>

            </div>

        </div>

    </div>

</section>

<div
    class="modal fade"
    id="confirm-delete"
    tabindex="-1"
    role="dialog"
    aria-labelledby="myModalLabel"
    aria-hidden="true">

    <div class="modal-dialog">

        <div class="modal-content">

            <div class="modal-header">

                <button
                    type="button"
                    class="close"
                    data-dismiss="modal"
                    aria-hidden="true">
                    &times;
                </button>

                <h4
                    class="modal-title"
                    id="myModalLabel">
                    Delete Confirmation
                </h4>

            </div>

            <div class="modal-body">
                Are you sure want to delete this item?
            </div>

            <div class="modal-footer">

                <button
                    type="button"
                    class="btn btn-default"
                    data-dismiss="modal">
                    Cancel
                </button>

                <a
                    class="btn btn-danger btn-ok">
                    Delete
                </a>

            </div>

        </div>

    </div>

</div>

<?php
require_once __DIR__ . '/footer.php';
?>