<?php
include("connection.php");
include("header.php");

ini_set('display_errors', 1);
error_reporting(E_ALL);

// Get ID
$id = (int)($_GET['id'] ?? 0);
if ($id <= 0) die("Invalid Solution");

// Fetch solution
$solution = mysqli_fetch_assoc(
    mysqli_query($con, "SELECT * FROM solutions WHERE id=$id")
);
if (!$solution) die("Solution not found");

// Slug generator
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 = "Solution name is required";
    } else {

        $slug = generateSlug($slug ?: $name);

        // Ensure unique slug (ignore current ID)
        $chk = mysqli_query($con,
            "SELECT id FROM solutions WHERE slug='$slug' AND id!=$id"
        );
        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 update (optional)
        $imageSql = '';
        if (!empty($_FILES['image']['name'])) {

            $uploadDir = "./assets/images/solutions/";

            // remove old image
            if ($solution['image'] && file_exists($uploadDir.$solution['image'])) {
                unlink($uploadDir.$solution['image']);
            }

            $ext = pathinfo($_FILES['image']['name'], PATHINFO_EXTENSION);
            $img = time().'_'.uniqid('srv_').'.'.$ext;
            move_uploaded_file($_FILES['image']['tmp_name'], $uploadDir.$img);

            $imageSql = ", image='$img'";
        }

        // Update
        $sql = "UPDATE solutions SET
                name='$name',
                slug='$slug',
                short_description='$short',
                description='$desc'
                $imageSql
                WHERE id=$id";

        if (mysqli_query($con, $sql)) {
            header("Location: view_solutions.php");
            exit;
        } else {
            $error = mysqli_error($con);
        }
    }
}
?>

<div class="main-content">
<div class="page-content">
<div class="container-fluid">

<h4>Edit solution</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>Solution Name</label>
        <input type="text" name="name" id="name"
               class="form-control"
               value="<?php echo htmlspecialchars($solution['name']); ?>"
               onkeyup="generateSlug()" required>
    </div>

    <div class="col-md-4">
        <label>Slug</label>
        <input type="text" name="slug" id="slug"
               class="form-control"
               value="<?php echo htmlspecialchars($solution['slug']); ?>">
    </div>

    <div class="col-md-4">
        <label>Solutions Image</label>
        <input type="file" name="image" class="form-control" accept="image/*">

        <?php if (!empty($solution['image'])): ?>
            <img src="assets/images/solutions/<?php echo htmlspecialchars($solution['image']); ?>"
                 class="img-thumbnail mt-2"
                 style="max-height:120px;">
        <?php endif; ?>
    </div>

</div>

<div class="mb-3">
    <label>Short Description</label>
    <textarea name="short_description" id="short_desc" class="form-control" rows="3"><?php
        echo htmlspecialchars($solution['short_description']);
    ?></textarea>
</div>

<div class="mb-3">
    <label>Description</label>
    <textarea name="description" id="description" class="form-control" rows="6"><?php
        echo htmlspecialchars($solution['description']);
    ?></textarea>
</div>

<button name="submit" class="btn btn-primary">Update solution</button>
<a href="view_solutions.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>
