<?php
include("connection.php");
include("header.php");

ini_set('display_errors', 1);
error_reporting(E_ALL);

function generateSlug($string) {
    return trim(preg_replace('/[^A-Za-z0-9-]+/', '-', strtolower($string)), '-');
}

$error = '';

if (isset($_POST['submit'])) {

    $name  = trim($_POST['name']);
    $slug  = trim($_POST['slug']);
    $short = $_POST['short_description'] ?? '';
    $desc  = $_POST['description'] ?? '';

    if ($name == '') {
        $error = "Service name is required";
    } else {

        $slug = generateSlug($slug ?: $name);

        // unique slug
        $chk = mysqli_query($con, "SELECT id FROM services WHERE slug='$slug'");
        if (mysqli_num_rows($chk) > 0) {
            $slug .= '-' . time();
        }

        $name  = mysqli_real_escape_string($con, $name);
        $slug  = mysqli_real_escape_string($con, $slug);
        $short = mysqli_real_escape_string($con, $short);
        $desc  = mysqli_real_escape_string($con, $desc);

        // image upload
        $uploadDir = "./assets/images/services/";
        if (!is_dir($uploadDir)) mkdir($uploadDir, 0777, true);

        $image = NULL;
        if (!empty($_FILES['image']['name'])) {
            $ext = pathinfo($_FILES['image']['name'], PATHINFO_EXTENSION);
            $image = time().'_'.uniqid('srv_').'.'.$ext;
            move_uploaded_file($_FILES['image']['tmp_name'], $uploadDir.$image);
        }

        $imageSql = $image ? "'$image'" : "NULL";

        $sql = "INSERT INTO services 
                (name, slug, image, short_description, description)
                VALUES ('$name','$slug',$imageSql,'$short','$desc')";

        if (mysqli_query($con, $sql)) {
            header("Location: view_services.php");
            exit;
        } else {
            $error = mysqli_error($con);
        }
    }
}
?>

<div class="main-content">
<div class="page-content">
<div class="container-fluid">

<h4>Add Service</h4>

<?php if ($error): ?>
<div class="alert alert-danger"><?php echo $error; ?></div>
<?php endif; ?>

<form method="POST" enctype="multipart/form-data">

<div class="row mb-3">
    <div class="col-md-4">
        <label>Service Name</label>
        <input type="text" name="name" id="name" 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>Service 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_description" id="short_desc" class="form-control" rows="3"></textarea>
</div>

<div class="mb-3">
    <label>Description</label>
    <textarea name="description" id="description" class="form-control" rows="6"></textarea>
</div>

<button name="submit" class="btn btn-primary">Save Service</button>
<a href="view_services.php" class="btn btn-danger">Back</a>

</form>

</div>
</div>
</div>

<?php include("footer.php"); ?>

<script src="./ck editor/ckeditor.js"></script>
<script>
CKEDITOR.replace('description');
CKEDITOR.replace('short_desc');


function generateSlug() {
    let text = document.getElementById("name").value.toLowerCase()
        .replace(/[^a-z0-9\s-]/g,'')
        .replace(/\s+/g,'-')
        .replace(/-+/g,'-')
        .replace(/^-+|-+$/g,'');
    document.getElementById("slug").value = text;
}
</script>
