
<?php

session_start();
require_once __DIR__ . '/includes/db.php';

if (!isset($pdo) || !($pdo instanceof PDO)) {
    exit('Database connection $pdo not found. Check includes/db.php');
}

$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

/* =====================================================
   PURE CHEMICAL - ADD CATEGORY
   Modern Admin UI + Unique Slug + Image/Banner Upload
===================================================== */

function e($value): string
{
    return htmlspecialchars((string)($value ?? ''), ENT_QUOTES, 'UTF-8');
}

function getColumns(PDO $pdo, string $table): array
{
    $stmt = $pdo->query("SHOW COLUMNS FROM `$table`");
    $columns = [];

    foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
        $columns[$row['Field']] = $row;
    }

    return $columns;
}

function findColumn(array $columns, array $candidates): ?string
{
    foreach ($candidates as $candidate) {
        if (isset($columns[$candidate])) {
            return $candidate;
        }
    }

    return null;
}

function makeSlug(string $value): string
{
    $value = trim(mb_strtolower($value, 'UTF-8'));

    if (function_exists('iconv')) {
        $converted = @iconv('UTF-8', 'ASCII//TRANSLIT//IGNORE', $value);
        if ($converted !== false) {
            $value = $converted;
        }
    }

    $value = preg_replace('/[^a-z0-9]+/', '-', $value) ?? '';
    $value = trim($value, '-');

    return $value !== '' ? $value : 'category';
}

function getUniqueSlug(PDO $pdo, string $slug): string
{
    $base = makeSlug($slug);
    $candidate = $base;
    $number = 2;

    $stmt = $pdo->prepare(
        'SELECT id FROM categories WHERE slug = :slug LIMIT 1'
    );

    while (true) {
        $stmt->execute([':slug' => $candidate]);

        if ($stmt->fetchColumn() === false) {
            return $candidate;
        }

        $candidate = $base . '-' . $number;
        $number++;
    }
}

/* =====================================================
   MEDIA UPLOAD
===================================================== */

function uploadCategoryMedia(
    PDO $pdo,
    array $file,
    string $altText,
    array $mediaColumns
): ?int {
    if (!isset($file['error']) ||
        $file['error'] === UPLOAD_ERR_NO_FILE) {
        return null;
    }

    if ($file['error'] !== UPLOAD_ERR_OK) {
        throw new RuntimeException('Image upload failed.');
    }

    if ((int)$file['size'] > 5 * 1024 * 1024) {
        throw new RuntimeException('Image size cannot exceed 5 MB.');
    }

    $tmp = $file['tmp_name'] ?? '';

    if (!is_uploaded_file($tmp)) {
        throw new RuntimeException('Invalid uploaded file.');
    }

    $finfo = new finfo(FILEINFO_MIME_TYPE);
    $mime = $finfo->file($tmp);

    $allowed = [
        'image/jpeg' => 'jpg',
        'image/png'  => 'png',
        'image/webp' => 'webp',
        'image/gif'  => 'gif',
    ];

    if (!isset($allowed[$mime])) {
        throw new RuntimeException(
            'Only JPG, PNG, WEBP and GIF images are allowed.'
        );
    }

    $directory = dirname(__DIR__) . '/uploads/categories/';

    if (!is_dir($directory) &&
        !mkdir($directory, 0755, true) &&
        !is_dir($directory)) {
        throw new RuntimeException('Could not create upload directory.');
    }

    $storedName = bin2hex(random_bytes(16)) . '.' . $allowed[$mime];
    $destination = $directory . $storedName;

    if (!move_uploaded_file($tmp, $destination)) {
        throw new RuntimeException('Could not save image.');
    }

    $relativePath = 'uploads/categories/' . $storedName;
    $originalName = basename((string)($file['name'] ?? $storedName));
    $fileSize = (int)$file['size'];

    /*
     * IMPORTANT:
     * Candidate columns are stored as VALUES in a normal array.
     * This avoids the PHP "Illegal offset type" error.
     */
    $fieldGroups = [
        [['file_name', 'filename', 'original_name', 'original_filename'], $originalName],
        [['file_path', 'path', 'url', 'file_url', 'media_path'], $relativePath],
        [['stored_name', 'stored_filename', 'saved_name'], $storedName],
        [['mime_type', 'mime', 'content_type'], $mime],
        [['file_type', 'media_type', 'type'], 'image'],
        [['file_size', 'size', 'filesize'], $fileSize],
        [['alt_text', 'alt'], $altText],
        [['created_at', 'uploaded_at'], date('Y-m-d H:i:s')],
    ];

    $values = [];

    foreach ($fieldGroups as $group) {
        $candidates = $group[0];
        $value = $group[1];
        $column = findColumn($mediaColumns, $candidates);

        if ($column !== null && !array_key_exists($column, $values)) {
            $values[$column] = $value;
        }
    }

    if (!$values) {
        @unlink($destination);
        throw new RuntimeException(
            'No compatible columns found in the media table.'
        );
    }

    try {
        $names = array_keys($values);
        $quotedNames = array_map(
            static fn($name) => '`' . str_replace('`', '', $name) . '`',
            $names
        );

        $placeholders = [];
        $params = [];

        foreach (array_values($values) as $i => $value) {
            $placeholder = ':media_' . $i;
            $placeholders[] = $placeholder;
            $params[$placeholder] = $value;
        }

        $sql = 'INSERT INTO media (' .
            implode(', ', $quotedNames) .
            ') VALUES (' .
            implode(', ', $placeholders) .
            ')';

        $stmt = $pdo->prepare($sql);
        $stmt->execute($params);

        return (int)$pdo->lastInsertId();
    } catch (Throwable $exception) {
        @unlink($destination);
        throw $exception;
    }
}

/* =====================================================
   CSRF TOKEN
===================================================== */

if (empty($_SESSION['csrf_token'])) {
    $_SESSION['csrf_token'] = bin2hex(random_bytes(32));
}

$csrfToken = $_SESSION['csrf_token'];

/* =====================================================
   INITIAL DATA
===================================================== */

$error = '';
$success = '';
$categoriesColumns = [];
$mediaColumns = [];
$categoryTypes = [];
$parentCategories = [];

$form = [
    'name' => '',
    'slug' => '',
    'category_type' => '',
    'parent_id' => '',
    'description' => '',
    'status' => 'active',
];

try {
    $categoriesColumns = getColumns($pdo, 'categories');
    $mediaColumns = getColumns($pdo, 'media');

    if (isset($categoriesColumns['category_type'])) {
        $definition = $categoriesColumns['category_type']['Type'] ?? '';

        if (preg_match('/^enum\((.*)\)$/i', $definition, $matches)) {
            preg_match_all(
                "/'((?:[^'\\\\\\\\]|\\\\\\\\.)*)'/",
                $matches[1],
                $found
            );

            foreach ($found[1] ?? [] as $type) {
                $categoryTypes[] = stripcslashes($type);
            }
        }
    }

    if (!$categoryTypes) {
        $categoryTypes = ['product', 'general'];
    }

    $parentColumn = findColumn(
        $categoriesColumns,
        ['parent_id', 'parent_category_id']
    );

    if ($parentColumn !== null) {
        $stmt = $pdo->query(
            'SELECT id, name FROM categories ORDER BY name ASC'
        );
        $parentCategories = $stmt->fetchAll(PDO::FETCH_ASSOC);
    }
} catch (Throwable $exception) {
    $error = 'Database setup error: ' . $exception->getMessage();
}

/* =====================================================
   FORM SUBMISSION
===================================================== */

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    try {
        $submittedToken = (string)($_POST['csrf_token'] ?? '');

        if (!hash_equals($csrfToken, $submittedToken)) {
            throw new RuntimeException(
                'Session expired. Refresh the page and try again.'
            );
        }

        $name = trim((string)($_POST['name'] ?? ''));
        $requestedSlug = trim((string)($_POST['slug'] ?? ''));
        $categoryType = trim((string)($_POST['category_type'] ?? ''));
        $description = trim((string)($_POST['description'] ?? ''));
        $status = trim((string)($_POST['status'] ?? 'active'));
        $parentId = (int)($_POST['parent_id'] ?? 0);

        $form = [
            'name' => $name,
            'slug' => $requestedSlug,
            'category_type' => $categoryType,
            'parent_id' => $parentId > 0 ? (string)$parentId : '',
            'description' => $description,
            'status' => $status,
        ];

        if ($name === '') {
            throw new RuntimeException('Category name is required.');
        }

        if (mb_strlen($name) > 190) {
            throw new RuntimeException('Category name is too long.');
        }

        if (!isset($categoriesColumns['name']) ||
            !isset($categoriesColumns['slug'])) {
            throw new RuntimeException(
                'The categories table must contain name and slug columns.'
            );
        }

        if (isset($categoriesColumns['category_type']) &&
            !in_array($categoryType, $categoryTypes, true)) {
            throw new RuntimeException('Select a valid category type.');
        }

        if (!in_array($status, ['active', 'inactive'], true)) {
            throw new RuntimeException('Select a valid status.');
        }

        $parentColumn = findColumn(
            $categoriesColumns,
            ['parent_id', 'parent_category_id']
        );

        if ($parentId > 0) {
            if ($parentColumn === null) {
                throw new RuntimeException(
                    'Parent categories are not supported by this database.'
                );
            }

            $checkParent = $pdo->prepare(
                'SELECT id FROM categories WHERE id = :id LIMIT 1'
            );
            $checkParent->execute([':id' => $parentId]);

            if ($checkParent->fetchColumn() === false) {
                throw new RuntimeException('Selected parent category does not exist.');
            }
        }

        $baseSlug = makeSlug($requestedSlug !== '' ? $requestedSlug : $name);

        // A duplicate slug receives -2, -3, -4, etc.
        $slug = getUniqueSlug($pdo, $baseSlug);

        $pdo->beginTransaction();

        $imageId = null;
        $bannerId = null;

        if (!empty($_FILES['category_image']['name'])) {
            $imageId = uploadCategoryMedia(
                $pdo,
                $_FILES['category_image'],
                $name,
                $mediaColumns
            );
        }

        if (!empty($_FILES['category_banner']['name'])) {
            $bannerId = uploadCategoryMedia(
                $pdo,
                $_FILES['category_banner'],
                $name . ' banner',
                $mediaColumns
            );
        }

        $insert = [];

        $addField = static function (
            array &$target,
            array $columns,
            array $candidates,
            $value
        ): void {
            $column = findColumn($columns, $candidates);

            if ($column !== null) {
                $target[$column] = $value;
            }
        };

        $addField($insert, $categoriesColumns, ['name'], $name);
        $addField($insert, $categoriesColumns, ['slug'], $slug);
        $addField(
            $insert,
            $categoriesColumns,
            ['description', 'short_description'],
            $description !== '' ? $description : null
        );
        $addField(
            $insert,
            $categoriesColumns,
            ['category_type'],
            $categoryType
        );
        $addField(
            $insert,
            $categoriesColumns,
            ['status'],
            $status
        );
        $addField(
            $insert,
            $categoriesColumns,
            ['is_active'],
            $status === 'active' ? 1 : 0
        );
        $addField(
            $insert,
            $categoriesColumns,
            ['parent_id', 'parent_category_id'],
            $parentId > 0 ? $parentId : null
        );
        $addField($insert, $categoriesColumns, ['image_id'], $imageId);
        $addField(
            $insert,
            $categoriesColumns,
            ['banner_image_id', 'banner_id'],
            $bannerId
        );

        if (isset($categoriesColumns['created_at'])) {
            $insert['created_at'] = date('Y-m-d H:i:s');
        }

        if (isset($categoriesColumns['updated_at'])) {
            $insert['updated_at'] = date('Y-m-d H:i:s');
        }

        $columnNames = array_keys($insert);
        $quotedNames = array_map(
            static fn($column) => '`' . str_replace('`', '', $column) . '`',
            $columnNames
        );

        $placeholders = [];
        $params = [];

        foreach (array_values($insert) as $i => $value) {
            $placeholder = ':category_' . $i;
            $placeholders[] = $placeholder;
            $params[$placeholder] = $value;
        }

        $sql = 'INSERT INTO categories (' .
            implode(', ', $quotedNames) .
            ') VALUES (' .
            implode(', ', $placeholders) .
            ')';

        $stmt = $pdo->prepare($sql);
        $stmt->execute($params);

        $pdo->commit();

        $_SESSION['csrf_token'] = bin2hex(random_bytes(32));
        $csrfToken = $_SESSION['csrf_token'];

        $success = 'Category created successfully! Slug: ' . $slug;

        $form = [
            'name' => '',
            'slug' => '',
            'category_type' => '',
            'parent_id' => '',
            'description' => '',
            'status' => 'active',
        ];
    } catch (Throwable $exception) {
        if ($pdo->inTransaction()) {
            $pdo->rollBack();
        }

        $error = $exception instanceof PDOException
            ? 'Database error: ' . $exception->getMessage()
            : $exception->getMessage();
    }
}

$sidebarFile = __DIR__ . '/sidebar.php';
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Add Category | Pure Chemical</title>

<link rel="preconnect" href="https://fonts.googleapis.com">
<link href="https://fonts.googleapis.com/css2?family=Inter:wght@400;500;600;700;800&display=swap" rel="stylesheet">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.2/css/all.min.css">

<style>
:root {
    --primary:#4f46e5;
    --primary-dark:#3730a3;
    --primary-soft:#eef2ff;
    --text:#172033;
    --muted:#758096;
    --border:#e5e9f2;
    --page:#f5f7fb;
    --white:#fff;
    --success:#087f5b;
    --danger:#c62828;
    --radius:17px;
    --shadow:0 8px 30px rgba(22,34,65,.055);
}
* { box-sizing:border-box; }
body {
    margin:0;
    background:var(--page);
    color:var(--text);
    font-family:Inter,Arial,sans-serif;
    font-size:14px;
}
input,select,textarea,button { font:inherit; }
.main-content,.admin-main,.content-wrapper {
    margin-left:260px;
    width:calc(100% - 260px);
    min-height:100vh;
    padding:26px 30px 40px;
}
.page-wrap { max-width:1450px; margin:auto; }
.topbar {
    display:flex;
    justify-content:space-between;
    align-items:center;
    gap:18px;
    margin-bottom:25px;
}
.breadcrumbs {
    display:flex;
    flex-wrap:wrap;
    gap:9px;
    color:var(--muted);
    font-size:12px;
    margin-bottom:9px;
}
.page-title {
    font-size:clamp(24px,2.5vw,31px);
    font-weight:800;
    letter-spacing:-.8px;
    margin:0;
}
.page-subtitle { color:var(--muted); line-height:1.7; margin:8px 0 0; }
.workspace-tag {
    display:flex;
    align-items:center;
    gap:10px;
    padding:11px 15px;
    background:white;
    border:1px solid var(--border);
    border-radius:12px;
    font-size:12px;
    font-weight:700;
    white-space:nowrap;
}
.dot { width:8px;height:8px;border-radius:50%;background:#10b981; }
.alert {
    padding:15px 17px;
    border-radius:12px;
    margin-bottom:20px;
    line-height:1.7;
    overflow-wrap:anywhere;
}
.alert-success { background:#e9fbf3;color:var(--success);border:1px solid #b9f1d8; }
.alert-danger { background:#fff0f0;color:var(--danger);border:1px solid #ffd5d5; }
.layout-grid {
    display:grid;
    grid-template-columns:minmax(0,1fr) 300px;
    gap:22px;
    align-items:start;
}
.form-card,.side-card {
    background:white;
    border:1px solid var(--border);
    border-radius:var(--radius);
    box-shadow:var(--shadow);
    overflow:hidden;
}
.card-heading {
    display:flex;
    align-items:center;
    gap:13px;
    padding:21px 24px;
    border-bottom:1px solid var(--border);
}
.heading-icon {
    display:grid;
    place-items:center;
    width:43px;height:43px;
    background:var(--primary-soft);
    color:var(--primary);
    border-radius:13px;
    font-size:17px;
}
.card-heading h2 { font-size:15px;margin:0;font-weight:800; }
.card-heading p { color:var(--muted);font-size:12px;line-height:1.6;margin:5px 0 0; }
.card-body { padding:24px; }
.form-grid {
    display:grid;
    grid-template-columns:repeat(2,minmax(0,1fr));
    gap:21px 18px;
}
.field { min-width:0; }
.field.full { grid-column:1/-1; }
.field label.field-label {
    display:block;
    font-size:12px;
    font-weight:700;
    color:#303b52;
    margin-bottom:9px;
}
.required { color:#e5484d; }
.control {
    width:100%;
    min-height:45px;
    padding:11px 13px;
    border:1px solid #dfe4ee;
    border-radius:10px;
    outline:none;
    background:white;
    color:var(--text);
}
.control:focus {
    border-color:#818cf8;
    box-shadow:0 0 0 4px rgba(99,102,241,.1);
}
textarea.control { min-height:115px;resize:vertical;line-height:1.7; }
.hint { color:var(--muted);font-size:11px;line-height:1.7;margin-top:8px; }
.upload-box {
    display:block;
    padding:18px;
    text-align:center;
    background:#fafbff;
    border:1.5px dashed #cbd3e3;
    border-radius:13px;
    cursor:pointer;
}
.upload-box:hover { border-color:var(--primary);background:#f5f6ff; }
.upload-icon {
    width:42px;height:42px;
    display:grid;place-items:center;
    margin:0 auto 10px;
    border-radius:12px;
    background:var(--primary-soft);
    color:var(--primary);
    font-size:17px;
}
.upload-title { font-size:12px;font-weight:800; }
.upload-hint { color:var(--muted);font-size:11px;margin-top:6px; }
.file-name { font-size:11px;color:var(--primary);margin-top:10px;overflow-wrap:anywhere; }
.file-input { display:block;width:100%;margin-top:9px;font-size:11px; }
.form-footer {
    display:flex;
    align-items:center;
    justify-content:space-between;
    flex-wrap:wrap;
    gap:13px;
    padding:19px 24px;
    border-top:1px solid var(--border);
    background:#fcfcfe;
}
.footer-note { color:var(--muted);font-size:11px;line-height:1.7; }
.button-row { display:flex;gap:10px; }
.btn {
    display:inline-flex;
    align-items:center;
    justify-content:center;
    gap:9px;
    min-height:43px;
    padding:0 17px;
    border-radius:10px;
    border:1px solid transparent;
    font-size:12px;
    font-weight:700;
    text-decoration:none;
    cursor:pointer;
}
.btn-primary { background:var(--primary);color:white; }
.btn-primary:hover { background:var(--primary-dark); }
.btn-light { background:white;color:#47516a;border-color:var(--border); }
.side-stack { display:grid;gap:18px; }
.side-card { padding:21px; }
.side-title { display:flex;align-items:center;gap:10px;font-size:13px;font-weight:800;margin:0 0 17px; }
.side-title i { color:var(--primary); }
.preview-box { padding:16px;border:1px solid var(--border);border-radius:13px;background:#fcfcff; }
.preview-label { font-size:10px;color:var(--muted);text-transform:uppercase;letter-spacing:.8px;font-weight:800;margin-bottom:8px; }
.preview-name { font-size:15px;font-weight:800;overflow-wrap:anywhere; }
.preview-slug { font-size:11px;color:#5965c9;overflow-wrap:anywhere;line-height:1.7; }
.tips-list { display:grid;gap:15px; }
.tip { display:flex;align-items:flex-start;gap:11px;color:#606b80;font-size:11px;line-height:1.7; }
.tip i { color:#10a779;margin-top:3px; }
.tip strong { color:#27334a; }
.note { background:#f0f5ff;color:#42558a;padding:14px;border-radius:12px;font-size:11px;line-height:1.8; }
@media(max-width:1200px) {
    .main-content,.admin-main,.content-wrapper { margin-left:240px;width:calc(100% - 240px);padding:22px 18px; }
    .layout-grid { grid-template-columns:minmax(0,1fr) 260px;gap:16px; }
}
@media(max-width:950px) {
    .layout-grid { grid-template-columns:1fr; }
    .side-stack { grid-template-columns:repeat(2,minmax(0,1fr)); }
}
@media(max-width:650px) {
    .sidebar,.admin-sidebar,.sidebar-wrapper,#sidebar,#adminSidebar { display:none!important; }
    .main-content,.admin-main,.content-wrapper { margin-left:0!important;width:100%!important;padding:18px 12px 28px; }
    .workspace-tag { display:none; }
    .form-grid { grid-template-columns:1fr; }
    .field.full { grid-column:auto; }
    .card-body,.card-heading,.form-footer { padding:17px; }
    .side-stack { grid-template-columns:1fr; }
    .button-row { width:100%; }
    .button-row .btn { flex:1; }
}
</style>
</head>

<body>

<?php
if (is_file($sidebarFile)) {
    require $sidebarFile;
}
?>

<main class="main-content admin-main content-wrapper">
<div class="page-wrap">

    <header class="topbar">
        <div>
            <div class="breadcrumbs">
                <span>Dashboard</span>
                <i class="fa-solid fa-chevron-right"></i>
                <span>Categories</span>
                <i class="fa-solid fa-chevron-right"></i>
                <strong>Add Category</strong>
            </div>
            <h1 class="page-title">Add New Category</h1>
            <p class="page-subtitle">Create and manage product categories for Pure Chemical.</p>
        </div>
        <div class="workspace-tag"><span class="dot"></span> Admin Workspace</div>
    </header>

    <?php if ($success !== ''): ?>
        <div class="alert alert-success">
            <i class="fa-solid fa-circle-check"></i>
            <?= e($success) ?>
        </div>
    <?php endif; ?>

    <?php if ($error !== ''): ?>
        <div class="alert alert-danger">
            <i class="fa-solid fa-circle-exclamation"></i>
            <?= e($error) ?>
        </div>
    <?php endif; ?>

    <form method="POST" enctype="multipart/form-data">
        <input type="hidden" name="csrf_token" value="<?= e($csrfToken) ?>">

        <div class="layout-grid">
            <section class="form-card">
                <div class="card-heading">
                    <div class="heading-icon"><i class="fa-solid fa-layer-group"></i></div>
                    <div>
                        <h2>Category Information</h2>
                        <p>Enter the basic details of your category.</p>
                    </div>
                </div>

                <div class="card-body">
                    <div class="form-grid">

                        <div class="field">
                            <label class="field-label" for="name">
                                Category Name <span class="required">*</span>
                            </label>
                            <input class="control" id="name" name="name"
                                maxlength="190" required
                                placeholder="e.g. Industrial Chemicals"
                                value="<?= e($form['name']) ?>">
                            <div class="hint">Use a clear, customer-friendly name.</div>
                        </div>

                        <div class="field">
                            <label class="field-label" for="slug">URL Slug</label>
                            <input class="control" id="slug" name="slug"
                                placeholder="industrial-chemicals"
                                value="<?= e($form['slug']) ?>">
                            <div class="hint">Leave blank to use the category name. Duplicates automatically receive a number.</div>
                        </div>

                        <?php if (isset($categoriesColumns['category_type'])): ?>
                        <div class="field">
                            <label class="field-label" for="category_type">
                                Category Type <span class="required">*</span>
                            </label>
                            <select class="control" id="category_type" name="category_type" required>
                                <option value="">Select category type</option>
                                <?php foreach ($categoryTypes as $type): ?>
                                <option value="<?= e($type) ?>"
                                    <?= $form['category_type'] === $type ? 'selected' : '' ?>>
                                    <?= e(ucwords(str_replace(['_', '-'], ' ', $type))) ?>
                                </option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <?php endif; ?>

                        <?php if (findColumn($categoriesColumns, ['parent_id', 'parent_category_id'])): ?>
                        <div class="field">
                            <label class="field-label" for="parent_id">Parent Category</label>
                            <select class="control" id="parent_id" name="parent_id">
                                <option value="">No Parent (Main Category)</option>
                                <?php foreach ($parentCategories as $parent): ?>
                                <option value="<?= (int)$parent['id'] ?>"
                                    <?= (string)$form['parent_id'] === (string)$parent['id'] ? 'selected' : '' ?>>
                                    <?= e($parent['name']) ?>
                                </option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <?php endif; ?>

                        <?php if (isset($categoriesColumns['status']) || isset($categoriesColumns['is_active'])): ?>
                        <div class="field">
                            <label class="field-label" for="status">Status</label>
                            <select class="control" id="status" name="status">
                                <option value="active" <?= $form['status'] === 'active' ? 'selected' : '' ?>>Active</option>
                                <option value="inactive" <?= $form['status'] === 'inactive' ? 'selected' : '' ?>>Inactive</option>
                            </select>
                        </div>
                        <?php endif; ?>

                        <?php if (findColumn($categoriesColumns, ['description', 'short_description'])): ?>
                        <div class="field full">
                            <label class="field-label" for="description">Description</label>
                            <textarea class="control" id="description" name="description"
                                placeholder="Write a short category description..."><?= e($form['description']) ?></textarea>
                        </div>
                        <?php endif; ?>

                        <?php if (isset($categoriesColumns['image_id'])): ?>
                        <div class="field">
                            <label class="field-label" for="category_image">Category Image</label>
                            <label class="upload-box" for="category_image">
                                <span class="upload-icon"><i class="fa-regular fa-image"></i></span>
                                <div class="upload-title">Choose category image</div>
                                <div class="upload-hint">JPG, PNG, WEBP or GIF · Max 5 MB</div>
                                <div class="file-name" id="image-name">No file selected</div>
                            </label>
                            <input class="file-input" type="file" id="category_image"
                                name="category_image"
                                accept=".jpg,.jpeg,.png,.webp,.gif,image/jpeg,image/png,image/webp,image/gif">
                        </div>
                        <?php endif; ?>

                        <?php if (findColumn($categoriesColumns, ['banner_image_id', 'banner_id'])): ?>
                        <div class="field">
                            <label class="field-label" for="category_banner">Category Banner</label>
                            <label class="upload-box" for="category_banner">
                                <span class="upload-icon"><i class="fa-regular fa-images"></i></span>
                                <div class="upload-title">Choose category banner</div>
                                <div class="upload-hint">JPG, PNG, WEBP or GIF · Max 5 MB</div>
                                <div class="file-name" id="banner-name">No file selected</div>
                            </label>
                            <input class="file-input" type="file" id="category_banner"
                                name="category_banner"
                                accept=".jpg,.jpeg,.png,.webp,.gif,image/jpeg,image/png,image/webp,image/gif">
                        </div>
                        <?php endif; ?>

                    </div>
                </div>

                <div class="form-footer">
                    <div class="footer-note">
                        <i class="fa-solid fa-shield-halved"></i>
                        Fields marked * are required.
                    </div>
                    <div class="button-row">
                        <button type="reset" class="btn btn-light" id="reset-button">
                            <i class="fa-solid fa-rotate-left"></i> Reset
                        </button>
                        <button type="submit" class="btn btn-primary">
                            <i class="fa-solid fa-plus"></i> Create Category
                        </button>
                    </div>
                </div>
            </section>

            <aside class="side-stack">
                <section class="side-card">
                    <h3 class="side-title"><i class="fa-regular fa-eye"></i> Live Preview</h3>
                    <div class="preview-box">
                        <div class="preview-label">Category Name</div>
                        <div class="preview-name" id="preview-name">
                            <?= e($form['name'] ?: 'Your category name') ?>
                        </div>
                        <div class="preview-label" style="margin-top:18px">URL Slug</div>
                        <div class="preview-slug" id="preview-slug">
                            <?= e($form['slug'] ?: 'your-category-name') ?>
                        </div>
                    </div>
                </section>

                <section class="side-card">
                    <h3 class="side-title"><i class="fa-regular fa-lightbulb"></i> Helpful Tips</h3>
                    <div class="tips-list">
                        <div class="tip">
                            <i class="fa-solid fa-circle-check"></i>
                            <div><strong>Unique URL</strong><br>Existing slugs automatically receive a suffix such as -2 or -3.</div>
                        </div>
                        <div class="tip">
                            <i class="fa-solid fa-circle-check"></i>
                            <div><strong>Clear names</strong><br>Use names that customers can easily understand.</div>
                        </div>
                        <div class="tip">
                            <i class="fa-solid fa-circle-check"></i>
                            <div><strong>Quality images</strong><br>Choose relevant, clear category images.</div>
                        </div>
                    </div>
                </section>

                <section class="side-card">
                    <h3 class="side-title"><i class="fa-solid fa-lock"></i> Upload Guidelines</h3>
                    <div class="note">
                        Supported formats: JPG, PNG, WEBP and GIF. Maximum file size: 5 MB per image.
                        Files are stored in <strong>uploads/categories/</strong>.
                    </div>
                </section>
            </aside>
        </div>
    </form>
</div>
</main>

<script>
(function () {
    const nameInput = document.getElementById('name');
    const slugInput = document.getElementById('slug');
    const previewName = document.getElementById('preview-name');
    const previewSlug = document.getElementById('preview-slug');

    function slugify(value) {
        return value.toLowerCase()
            .normalize('NFD')
            .replace(/[\u0300-\u036f]/g, '')
            .replace(/[^a-z0-9]+/g, '-')
            .replace(/^-+|-+$/g, '');
    }

    function updatePreview() {
        const name = nameInput ? nameInput.value.trim() : '';
        const slug = slugInput ? slugInput.value.trim() : '';

        if (previewName) {
            previewName.textContent = name || 'Your category name';
        }

        if (previewSlug) {
            previewSlug.textContent =
                slugify(slug || name) || 'your-category-name';
        }
    }

    if (nameInput) nameInput.addEventListener('input', updatePreview);
    if (slugInput) slugInput.addEventListener('input', updatePreview);

    function showFileName(inputId, outputId) {
        const input = document.getElementById(inputId);
        const output = document.getElementById(outputId);

        if (!input || !output) return;

        input.addEventListener('change', function () {
            output.textContent = this.files && this.files.length
                ? this.files[0].name
                : 'No file selected';
        });
    }

    showFileName('category_image', 'image-name');
    showFileName('category_banner', 'banner-name');

    const resetButton = document.getElementById('reset-button');
    if (resetButton) {
        resetButton.addEventListener('click', function () {
            setTimeout(updatePreview, 0);
            setTimeout(function () {
                const imageName = document.getElementById('image-name');
                const bannerName = document.getElementById('banner-name');
                if (imageName) imageName.textContent = 'No file selected';
                if (bannerName) bannerName.textContent = 'No file selected';
            }, 0);
        });
    }

    updatePreview();
})();
</script>

</body>
</html>

