<?php
include("connection.php");
include("header.php");

ini_set('display_errors', 1);
error_reporting(E_ALL);

// Slug generator
function generateSlug($string)
{
    return trim(preg_replace('/[^A-Za-z0-9-]+/', '-', strtolower($string)), '-');
}

$error_message = '';
$valid = 1;

if (isset($_POST['submit'])) {

    $title = trim($_POST['title']);
    $slug_input = trim($_POST['slug']);

    if ($title == '') {
        $valid = 0;
        $error_message .= "Location title is required.<br>";
    }

    if ($valid == 1) {

        // Slug
        $slugBase = $slug_input != '' ? $slug_input : $title;
        $slug = mysqli_real_escape_string($con, generateSlug($slugBase));

        // Unique slug check
        $check = mysqli_query($con, "SELECT id FROM locations WHERE slug='$slug'");
        if (mysqli_num_rows($check) > 0) {
            $slug .= '-' . time();
        }

        // Image upload
        $imageName = NULL;
        if (!empty($_FILES['image']['name'])) {
            $uploadDir = "./assets/images/locations/";
            if (!is_dir($uploadDir)) mkdir($uploadDir, 0777, true);

            $ext = pathinfo($_FILES['image']['name'], PATHINFO_EXTENSION);
            $imageName = time() . '_' . uniqid() . '.' . $ext;
            move_uploaded_file($_FILES['image']['tmp_name'], $uploadDir . $imageName);
        }

        $short_desc = mysqli_real_escape_string($con, $_POST['short_desc']);
        $description = mysqli_real_escape_string($con, $_POST['description']);

        $sql = "INSERT INTO locations 
                (title, slug, image, short_desc, description)
                VALUES 
                ('$title', '$slug', '$imageName', '$short_desc', '$description')";

        if (mysqli_query($con, $sql)) {
            header("Location: view_locations.php");
            exit;
        } else {
            $error_message = mysqli_error($con);
        }
    }
}
?>
<div class="main-content mb-5">
    <div class="page-content">
        <div class="container-fluid">

            <h4 class="mb-4">Add Location</h4>

            <?php if($error_message): ?>
            <div class="alert alert-danger"><?= $error_message ?></div>
            <?php endif; ?>

            <form method="POST" enctype="multipart/form-data">

                <div class="row mb-3">
                    <div class="col-md-4">
                        <label>Location Title</label>
                        <input type="text" name="title" id="title" class="form-control" onkeyup="generateSlug()"
                            required>
                    </div>

                    <div class="col-md-4">
                        <label>Slug</label>
                        <input type="text" name="slug" id="slug" class="form-control">
                    </div>

                    <!-- <div class="col-md-4">
                        <label>Location Image</label>
                        <input type="file" name="image" class="form-control" accept="image/*">
                    </div> -->
                </div>

                <div class="mb-3">
                    <label>Short Description</label>
                    <textarea name="short_desc" id="short_desc" class="form-control"></textarea>
                </div>

                <div class="mb-3">
                    <label>Description</label>
                    <textarea name="description" id="description" class="form-control"></textarea>
                </div>

                <button type="submit" name="submit" class="btn btn-primary">Submit</button>
                <a href="view_locations.php" class="btn btn-danger">Back</a>

            </form>
        </div>
    </div>
</div>
<script src="./ck editor/ckeditor.js"></script>
<script>
CKEDITOR.replace('short_desc');
CKEDITOR.replace('description');

function generateSlug() {
    let title = document.getElementById("title").value;
    document.getElementById("slug").value = title.toLowerCase()
        .replace(/[^a-z0-9\s-]/g, '')
        .replace(/\s+/g, '-')
        .replace(/-+/g, '-')
        .replace(/^-+|-+$/g, '');
}
</script>

<?php include("footer.php"); ?>