<?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. ALLOW POST REQUEST ONLY
// ========================================

if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
    http_response_code(405);
    exit("Method not allowed.");
}

// ========================================
// 4. CSRF VALIDATION
// ========================================

if (
    !isset($_POST['csrf_token']) ||
    !isset($_SESSION['csrf_token']) ||
    !hash_equals($_SESSION['csrf_token'], $_POST['csrf_token'])
) {
    http_response_code(403);
    exit("Invalid request. Please refresh and try again.");
}

// ========================================
// 5. VALIDATE SLIDER ID
// ========================================

$id = filter_input(INPUT_POST, 'id', FILTER_VALIDATE_INT);

if (!$id || $id <= 0) {
    http_response_code(400);
    exit("Invalid slider ID.");
}

// ========================================
// 6. FETCH SLIDER RECORD
// ========================================

try {

    $selectSQL = "
        SELECT id, Image, PImage
        FROM slider
        WHERE id = ?
        LIMIT 1
    ";

    $stmt = mysqli_prepare($con, $selectSQL);

    mysqli_stmt_bind_param($stmt, "i", $id);

    mysqli_stmt_execute($stmt);

    $result = mysqli_stmt_get_result($stmt);

    $slider = mysqli_fetch_assoc($result);

    mysqli_stmt_close($stmt);

    if (!$slider) {
        http_response_code(404);
        exit("Slider not found.");
    }

    // ========================================
    // 7. DELETE DATABASE RECORD FIRST
    // ========================================

    $deleteSQL = "DELETE FROM slider WHERE id = ?";

    $stmt = mysqli_prepare($con, $deleteSQL);

    mysqli_stmt_bind_param($stmt, "i", $id);

    mysqli_stmt_execute($stmt);

    $deleted = mysqli_stmt_affected_rows($stmt);

    mysqli_stmt_close($stmt);

    if ($deleted !== 1) {
        throw new RuntimeException("Unable to delete slider record.");
    }

    // ========================================
    // 8. DELETE IMAGE FILES
    // ========================================

    $uploadDir = __DIR__ . "/assets/images/slider/";

    /**
     * Delete only safe image filenames.
     */
    $deleteImage = function (?string $filename) use ($uploadDir) {

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

        $filePath = $uploadDir . $filename;

        if (
            is_file($filePath) &&
            !is_link($filePath)
        ) {
            if (!unlink($filePath)) {
                error_log("Unable to delete slider image: " . $filename);
            }
        }
    };

    // Delete desktop image
    $deleteImage($slider['Image']);

    // Delete phone image
    $deleteImage($slider['PImage']);

    // ========================================
    // 9. REFRESH CSRF TOKEN
    // ========================================

    $_SESSION['csrf_token'] = bin2hex(random_bytes(32));

    // ========================================
    // 10. REDIRECT
    // ========================================

    header("Location: viewslider.php");
    exit;

} catch (Throwable $e) {

    error_log("Slider Delete Error: " . $e->getMessage());

    http_response_code(500);

    exit("Unable to delete slider. Please try again.");

}

?>
