<?php
declare(strict_types=1);

// ========================================
// 1. SESSION AND DATABASE
// ========================================

if (session_status() !== PHP_SESSION_ACTIVE) {
    session_start();
}

require_once "connection.php";

// ========================================
// 2. ADMIN AUTHENTICATION
// ========================================

if (
    !isset($_SESSION['admin_id']) ||
    !is_int($_SESSION['admin_id']) ||
    $_SESSION['admin_id'] <= 0 ||
    ($_SESSION['start'] ?? false) !== true
) {
    header("Location: login.php");
    exit;
}

// ========================================
// 3. CSRF TOKEN
// ========================================

if (empty($_SESSION['csrf_token'])) {
    $_SESSION['csrf_token'] = bin2hex(random_bytes(32));
}

// ========================================
// 4. SAFE IMAGE URL FUNCTION
// ========================================

function getSliderImageUrl(?string $filename): ?string
{
    if (
        empty($filename) ||
        basename($filename) !== $filename ||
        !preg_match(
            '/\A[a-zA-Z0-9._-]+\.(jpg|jpeg|png|webp)\z/i',
            $filename
        )
    ) {
        return null;
    }

    return "./assets/images/slider/" . rawurlencode($filename);
}

// ========================================
// 5. FETCH SLIDER RECORDS
// ========================================

$query = "SELECT id, Image, PImage FROM slider ORDER BY id DESC";

$sql = mysqli_query($con, $query);

if (!$sql) {
    error_log("Slider Fetch Error: " . mysqli_error($con));
    http_response_code(500);
    exit("Unable to load slider records.");
}

include("header.php");

?>

<!DOCTYPE html>
<html lang="en">

<head>

    <meta charset="utf-8">

    <title>View Slider</title>

    <meta name="viewport" content="width=device-width, initial-scale=1.0">

    <link rel="shortcut icon" href="../images/logo.png">

    <!-- Bootstrap CSS -->
    <link href="assets/css/bootstrap.min.css"
        id="bootstrap-style"
        rel="stylesheet">

    <!-- Icons CSS -->
    <link href="assets/css/icons.min.css"
        rel="stylesheet">

    <!-- App CSS -->
    <link href="assets/css/app.min.css"
        id="app-style"
        rel="stylesheet">

    <style>

        .slider-image {
            width: 150px;
            height: 110px;
            object-fit: contain;
            border: 1px solid #ddd;
            border-radius: 6px;
            padding: 5px;
            background: #fff;
        }

        .search-box {
            max-width: 300px;
        }

        .action-buttons {
            display: flex;
            gap: 6px;
            flex-wrap: wrap;
        }

        .table td {
            vertical-align: middle;
        }

    </style>

</head>


<body data-sidebar="dark">

<div class="main-content">

    <div class="page-content">

        <div class="container-fluid">


            <!-- ========================================
                 PAGE TITLE
            ========================================= -->

            <div class="row">

                <div class="col-12">

                    <div class="page-title-box d-sm-flex align-items-center justify-content-between">

                        <h4 class="mb-sm-0 font-size-18">
                            View Slider
                        </h4>

                    </div>

                </div>

            </div>


            <!-- ========================================
                 SLIDER TABLE
            ========================================= -->

            <div class="row">

                <div class="col-lg-12">

                    <div class="card">

                        <div class="card-body">


                            <!-- SEARCH AND ADD BUTTON -->

                            <div class="row mb-2">

                                <div class="col-sm-6 mt-3">

                                    <div class="search-box me-2 d-inline-block">

                                        <div class="position-relative">

                                            <input
                                                type="text"
                                                class="form-control"
                                                autocomplete="off"
                                                id="searchInput"
                                                placeholder="Search..."
                                                onkeyup="searchTable()">

                                            <i class="bx bx-search-alt search-icon"></i>

                                        </div>

                                    </div>

                                </div>


                                <div class="col-sm-6 mt-3">

                                    <div class="text-sm-end">

                                        <a href="addslider.php"
                                            class="btn btn-success btn-rounded waves-effect waves-light mb-2">

                                            <i class="mdi mdi-plus me-1"></i>

                                            Add Slider

                                        </a>

                                    </div>

                                </div>

                            </div>


                            <!-- ========================================
                                 TABLE
                            ========================================= -->

                            <div class="table-responsive">

                                <table
                                    class="table align-middle table-nowrap table-hover dt-responsive nowrap w-100"
                                    id="userList-table">

                                    <thead class="table-light">

                                        <tr>

                                            <th scope="col">
                                                S.No
                                            </th>

                                            <th scope="col">
                                                Desktop Image
                                            </th>

                                            <th scope="col">
                                                Phone Image (Optional)
                                            </th>

                                            <th scope="col" style="width:200px">
                                                Action
                                            </th>

                                        </tr>

                                    </thead>


                                    <tbody id="sliderTableBody">

                                        <?php

                                        $serial = 1;

                                        if (mysqli_num_rows($sql) > 0):

                                            while ($row = mysqli_fetch_assoc($sql)):

                                                $sliderId = (int)$row['id'];

                                                $desktopImage = getSliderImageUrl(
                                                    $row['Image']
                                                );

                                                $phoneImage = getSliderImageUrl(
                                                    $row['PImage']
                                                );

                                        ?>

                                            <tr>

                                                <!-- SERIAL NUMBER -->

                                                <td>
                                                    <?php echo $serial++; ?>
                                                </td>


                                                <!-- DESKTOP IMAGE -->

                                                <td>

                                                    <?php if ($desktopImage): ?>

                                                        <img
                                                            src="<?php echo htmlspecialchars(
                                                                $desktopImage,
                                                                ENT_QUOTES,
                                                                'UTF-8'
                                                            ); ?>"
                                                            class="slider-image"
                                                            alt="Desktop slider image"
                                                            loading="lazy">

                                                    <?php else: ?>

                                                        <span class="badge bg-danger">
                                                            No valid image
                                                        </span>

                                                    <?php endif; ?>

                                                </td>


                                                <!-- PHONE IMAGE -->

                                                <td>

                                                    <?php if ($phoneImage): ?>

                                                        <img
                                                            src="<?php echo htmlspecialchars(
                                                                $phoneImage,
                                                                ENT_QUOTES,
                                                                'UTF-8'
                                                            ); ?>"
                                                            class="slider-image"
                                                            alt="Phone slider image"
                                                            loading="lazy">

                                                    <?php else: ?>

                                                        <span class="badge bg-secondary">
                                                            Not set
                                                        </span>

                                                    <?php endif; ?>

                                                </td>


                                                <!-- ACTION BUTTONS -->

                                                <td>

                                                    <div class="action-buttons">


                                                        <!-- EDIT BUTTON -->

                                                        <a
                                                            href="editslider.php?id=<?php echo $sliderId; ?>"
                                                            class="btn btn-primary btn-rounded">

                                                            <i class="far fa-edit"></i>

                                                            Edit

                                                        </a>


                                                        <!-- DELETE FORM (POST + CSRF) -->

                                                        <form
                                                            method="POST"
                                                            action="deleteslider.php"
                                                            onsubmit="return confirm('Are you sure you want to delete this slider?');">

                                                            <input
                                                                type="hidden"
                                                                name="id"
                                                                value="<?php echo $sliderId; ?>">

                                                            <input
                                                                type="hidden"
                                                                name="csrf_token"
                                                                value="<?php echo htmlspecialchars(
                                                                    $_SESSION['csrf_token'],
                                                                    ENT_QUOTES,
                                                                    'UTF-8'
                                                                ); ?>">

                                                            <button
                                                                type="submit"
                                                                name="delete"
                                                                value="1"
                                                                class="btn btn-danger btn-rounded">

                                                                <i class="fas fa-trash"></i>

                                                                Delete

                                                            </button>

                                                        </form>


                                                    </div>

                                                </td>

                                            </tr>


                                        <?php

                                            endwhile;

                                        else:

                                        ?>

                                            <tr>

                                                <td colspan="4" class="text-center">

                                                    <div class="py-4">

                                                        <i class="mdi mdi-image-off font-size-24 text-muted"></i>

                                                        <p class="text-muted mb-0">
                                                            No slider data found.
                                                        </p>

                                                    </div>

                                                </td>

                                            </tr>

                                        <?php endif; ?>

                                    </tbody>

                                </table>

                            </div>

                            <!-- END TABLE RESPONSIVE -->


                        </div>

                    </div>

                </div>

            </div>

        </div>

    </div>


    <!-- FOOTER -->

    <?php include("footer.php"); ?>


</div>


<!-- ========================================
     JAVASCRIPT
========================================= -->

<script src="assets/libs/jquery/jquery.min.js"></script>

<script src="assets/libs/bootstrap/js/bootstrap.bundle.min.js"></script>

<script src="assets/js/app.js"></script>


<script>

// ========================================
// SEARCH SLIDER TABLE
// ========================================

function searchTable() {

    let input = document.getElementById("searchInput");

    let filter = input.value.toLowerCase();

    let table = document.getElementById("userList-table");

    let rows = table.getElementsByTagName("tbody")[0]
                    .getElementsByTagName("tr");

    for (let i = 0; i < rows.length; i++) {

        let rowText = rows[i].textContent.toLowerCase();

        if (rowText.includes(filter)) {

            rows[i].style.display = "";

        } else {

            rows[i].style.display = "none";

        }

    }

}

</script>


</body>

</html>
