<?php
include("connection.php");
include("header.php");

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

// Slug generator
function generateSlug($string)
{
    $slug = preg_replace('/[^A-Za-z0-9-]+/', '-', strtolower($string));
    return trim($slug, '-');
}

// Get ID
$id = isset($_GET['id']) ? (int)$_GET['id'] : 0;
if ($id <= 0) {
    echo "<div class='alert alert-danger m-3'>Invalid category.</div>";
    include("footer.php");
    exit;
}

// Fetch category
$q = mysqli_query($con, "SELECT * FROM top_categories WHERE id=$id LIMIT 1");
$row = mysqli_fetch_assoc($q);

if (!$row) {
    echo "<div class='alert alert-danger m-3'>Category not found.</div>";
    include("footer.php");
    exit;
}

$error_message = '';
$valid = 1;

// Update logic
if (isset($_POST['submit'])) {

    $name        = trim($_POST['name'] ?? '');
    $slug_input = trim($_POST['slug'] ?? '');
    $description = $_POST['description'] ?? '';

    if ($name === '') {
        $valid = 0;
        $error_message .= "Category name is required.<br>";
    }

    if ($valid == 1) {

        // ---- Slug ----
        $slugBase = $slug_input !== '' ? $slug_input : $name;
        $slug = generateSlug($slugBase);
        $slug = mysqli_real_escape_string($con, $slug);

        // Ensure slug unique (exclude current)
        $checkSlug = mysqli_query($con,
            "SELECT COUNT(*) AS total 
             FROM top_categories 
             WHERE slug='$slug' AND id != $id"
        );
        $rowSlug = mysqli_fetch_assoc($checkSlug);
        if ($rowSlug['total'] > 0) {
            $slug .= '-' . time();
        }

        $name = mysqli_real_escape_string($con, $name);
        $description = mysqli_real_escape_string($con, $description);

        // ---- Image Upload (optional replace) ----
        $uploadDir = "./assets/images/top_categories/";
        if (!is_dir($uploadDir)) {
            mkdir($uploadDir, 0777, true);
        }

        $imageSql = "";
        if (isset($_FILES['image']) && $_FILES['image']['error'] === UPLOAD_ERR_OK) {

            // Remove old image
            if ($row['image'] && file_exists($uploadDir . $row['image'])) {
                unlink($uploadDir . $row['image']);
            }

            $ext = pathinfo($_FILES['image']['name'], PATHINFO_EXTENSION);
            $imageName = time() . '_' . uniqid('cat_') . '.' . $ext;
            move_uploaded_file($_FILES['image']['tmp_name'], $uploadDir . $imageName);

            $imageSql = ", image='" . mysqli_real_escape_string($con, $imageName) . "'";
        }

        $descSql = $description !== ''
            ? ", description='$description'"
            : ", description=NULL";

        // ---- Update ----
        $sql = "UPDATE top_categories 
                SET name='$name', slug='$slug'
                $imageSql
                $descSql
                WHERE id=$id";

        if (mysqli_query($con, $sql)) {
            header("Location: view_top_Categories.php");
            exit();
        } else {
            $error_message .= "Database Error: " . mysqli_error($con);
        }
    }
}
?>

<div class="main-content">
    <div class="page-content">
        <div class="container-fluid">

            <div class="row">
                <div class="col-12">
                    <div class="page-title-box">
                        <h4 class="mb-sm-0 font-size-18">Edit Top Category</h4>
                    </div>
                </div>
            </div>

            <?php if ($error_message != ''): ?>
                <div class="alert alert-danger"><?php echo $error_message; ?></div>
            <?php endif; ?>

            <div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="card-body">

                            <form method="POST" enctype="multipart/form-data">

                                <div class="row mb-3">
                                    <div class="col-lg-4">
                                        <label class="form-label">Category Name</label>
                                        <input type="text" name="name" id="name"
                                               class="form-control"
                                               value="<?php echo htmlspecialchars($row['name']); ?>"
                                               onkeyup="generateSlug()" required>
                                    </div>

                                    <div class="col-lg-4">
                                        <label class="form-label">Slug</label>
                                        <input type="text" name="slug" id="slug"
                                               class="form-control"
                                               value="<?php echo htmlspecialchars($row['slug']); ?>">
                                    </div>

                                    <div class="col-lg-4">
                                        <label class="form-label">Category Image</label>
                                        <input type="file" name="image" id="image"
                                               class="form-control" accept="image/*">

                                        <?php if ($row['image']): ?>
                                            <img src="./assets/images/top_categories/<?php echo htmlspecialchars($row['image']); ?>"
                                                 class="img-thumbnail mt-2"
                                                 style="max-height:120px;">
                                        <?php endif; ?>

                                        <img id="preview" class="img-thumbnail mt-2"
                                             style="max-height:120px; display:none;">
                                    </div>
                                </div>
                                
                                

                                <div class="mb-3">
                                    <label class="form-label">Description</label>
                                    <textarea name="description" id="description"
                                              class="form-control" rows="6"><?php
                                        echo htmlspecialchars($row['description'] ?? '');
                                    ?></textarea>
                                </div>

                                <div class="text-center mt-4">
                                    <button type="submit" name="submit" class="btn btn-primary">
                                        Update
                                    </button>
                                    <a href="view_top_categories.php" class="btn btn-danger">
                                        Back to List
                                    </a>
                                </div>

                            </form>

                        </div>
                    </div>
                </div>
            </div>

        </div>
    </div>

<?php include("footer.php"); ?>
</div>

<!-- CKEditor -->
<script src="./ck editor/ckeditor.js"></script>
<script>
CKEDITOR.replace('description');
// CKEDITOR.replace('short_desc');

// Auto slug
function generateSlug() {
    let text = document.getElementById("name").value.toLowerCase();
    text = text.replace(/[^a-z0-9\s-]/g, '')
               .replace(/\s+/g, '-')
               .replace(/-+/g, '-')
               .replace(/^-+|-+$/g, '');
    document.getElementById("slug").value = text;
}

// Image preview
document.getElementById("image").addEventListener("change", function(e) {
    const file = e.target.files[0];
    if (!file) return;
    const reader = new FileReader();
    reader.onload = () => {
        document.getElementById("preview").src = reader.result;
        document.getElementById("preview").style.display = "block";
    };
    reader.readAsDataURL(file);
});
</script>
