<?php
declare(strict_types=1);

/**
 * Pure Chemical Admin
 *
 * File:
 * admin/menu_image.php
 *
 * Purpose:
 * Assign / remove existing Media Library images
 * from menu_items.image_id
 *
 * No new table required.
 */

require_once __DIR__ . '/includes/db.php';
require_once __DIR__ . '/includes/auth.php';
require_once __DIR__ . '/includes/functions.php';
require_once __DIR__ . '/includes/csrf.php';

requireAdmin();


/*
|--------------------------------------------------------------------------
| Helpers
|--------------------------------------------------------------------------
*/

function menuImageColumnExists(
    PDO $pdo,
    string $column
): bool {
    static $columns = null;

    if ($columns === null) {
        $stmt = $pdo->query("
            SHOW COLUMNS FROM `menu_items`
        ");

        $columns = [];

        foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
            if (isset($row['Field'])) {
                $columns[] = $row['Field'];
            }
        }
    }

    return in_array($column, $columns, true);
}


function mediaTableColumns(PDO $pdo): array
{
    static $columns = null;

    if ($columns !== null) {
        return $columns;
    }

    try {
        $stmt = $pdo->query("
            SHOW COLUMNS FROM `media`
        ");

        $columns = [];

        foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
            if (isset($row['Field'])) {
                $columns[] = $row['Field'];
            }
        }

    } catch (Throwable) {
        $columns = [];
    }

    return $columns;
}


function mediaValue(
    array $media,
    array $possibleColumns,
    string $default = ''
): string {

    foreach ($possibleColumns as $column) {
        if (
            array_key_exists($column, $media)
            && $media[$column] !== null
            && trim((string) $media[$column]) !== ''
        ) {
            return trim((string) $media[$column]);
        }
    }

    return $default;
}


function mediaUrl(array $media): string
{
    /*
     * First try complete URL/path columns.
     */
    $url = mediaValue(
        $media,
        [
            'url',
            'file_url',
            'public_url',
            'path',
            'file_path',
            'file',
        ]
    );

    if ($url !== '') {
        /*
         * If already absolute URL.
         */
        if (
            preg_match(
                '#^(https?:)?//#i',
                $url
            )
        ) {
            return $url;
        }

        /*
         * If root-relative.
         */
        if (str_starts_with($url, '/')) {
            return $url;
        }

        /*
         * Otherwise assume uploads path.
         */
        return '/' . ltrim($url, '/');
    }


    /*
     * Try filename.
     */
    $filename = mediaValue(
        $media,
        [
            'file_name',
            'filename',
            'name',
            'stored_name',
        ]
    );

    if ($filename !== '') {

        $directory = mediaValue(
            $media,
            [
                'directory',
                'folder_path',
                'upload_path',
                'path',
            ]
        );

        if ($directory !== '') {
            return '/' .
                trim($directory, '/') .
                '/' .
                ltrim($filename, '/');
        }

        return '/uploads/media/' .
            ltrim($filename, '/');
    }

    return '';
}


function mediaTitle(array $media): string
{
    return mediaValue(
        $media,
        [
            'title',
            'name',
            'original_name',
            'file_name',
            'filename',
        ],
        'Media #' . (int) ($media['id'] ?? 0)
    );
}


function isImageMedia(array $media): bool
{
    $mime = strtolower(
        mediaValue(
            $media,
            [
                'mime_type',
                'mime',
                'type',
                'media_type',
            ]
        )
    );

    if (str_starts_with($mime, 'image/')) {
        return true;
    }

    $filename = mediaValue(
        $media,
        [
            'file_name',
            'filename',
            'original_name',
            'name',
        ]
    );

    $extension = strtolower(
        pathinfo($filename, PATHINFO_EXTENSION)
    );

    return in_array(
        $extension,
        [
            'jpg',
            'jpeg',
            'png',
            'gif',
            'webp',
            'svg',
            'avif',
        ],
        true
    );
}


/*
|--------------------------------------------------------------------------
| AJAX: Assign Image
|--------------------------------------------------------------------------
*/

if (
    $_SERVER['REQUEST_METHOD'] === 'POST'
    && ($_POST['action'] ?? '') === 'assign_image'
) {

    requireCsrf();

    $itemId = (int) ($_POST['item_id'] ?? 0);
    $mediaId = (int) ($_POST['media_id'] ?? 0);

    if ($itemId <= 0 || $mediaId <= 0) {
        jsonError(
            'Invalid menu item or media image.',
            422
        );
    }

    if (!menuImageColumnExists($pdo, 'image_id')) {
        jsonError(
            'The menu_items.image_id column is missing.',
            500
        );
    }

    /*
     * Confirm menu item exists.
     */
    $itemStmt = $pdo->prepare("
        SELECT
            id,
            menu_id,
            title,
            image_id
        FROM menu_items
        WHERE id = :id
        LIMIT 1
    ");

    $itemStmt->execute([
        ':id' => $itemId,
    ]);

    $item = $itemStmt->fetch(PDO::FETCH_ASSOC);

    if (!$item) {
        jsonError(
            'Menu item not found.',
            404
        );
    }


    /*
     * Confirm media exists.
     */
    $mediaStmt = $pdo->prepare("
        SELECT *
        FROM media
        WHERE id = :id
        LIMIT 1
    ");

    $mediaStmt->execute([
        ':id' => $mediaId,
    ]);

    $media = $mediaStmt->fetch(PDO::FETCH_ASSOC);

    if (!$media) {
        jsonError(
            'Selected media was not found.',
            404
        );
    }

    if (!isImageMedia($media)) {
        jsonError(
            'Please select an image file.',
            422
        );
    }


    /*
     * Update menu item image.
     */
    $update = $pdo->prepare("
        UPDATE menu_items
        SET
            image_id = :image_id,
            updated_at = CURRENT_TIMESTAMP
        WHERE id = :id
        LIMIT 1
    ");

    $update->execute([
        ':image_id' => $mediaId,
        ':id'       => $itemId,
    ]);


    jsonSuccess(
        'Menu image assigned successfully.',
        [
            'item_id' => $itemId,
            'media_id' => $mediaId,
            'image_url' => mediaUrl($media),
        ]
    );
}


/*
|--------------------------------------------------------------------------
| AJAX: Remove Image
|--------------------------------------------------------------------------
*/

if (
    $_SERVER['REQUEST_METHOD'] === 'POST'
    && ($_POST['action'] ?? '') === 'remove_image'
) {

    requireCsrf();

    $itemId = (int) ($_POST['item_id'] ?? 0);

    if ($itemId <= 0) {
        jsonError(
            'Invalid menu item.',
            422
        );
    }

    $stmt = $pdo->prepare("
        UPDATE menu_items
        SET
            image_id = NULL,
            updated_at = CURRENT_TIMESTAMP
        WHERE id = :id
        LIMIT 1
    ");

    $stmt->execute([
        ':id' => $itemId,
    ]);

    if ($stmt->rowCount() === 0) {

        /*
         * It may simply already be NULL.
         * Verify item existence.
         */
        $check = $pdo->prepare("
            SELECT id
            FROM menu_items
            WHERE id = :id
            LIMIT 1
        ");

        $check->execute([
            ':id' => $itemId,
        ]);

        if (!$check->fetch()) {
            jsonError(
                'Menu item not found.',
                404
            );
        }
    }

    jsonSuccess(
        'Menu image removed successfully.'
    );
}


/*
|--------------------------------------------------------------------------
| Filters
|--------------------------------------------------------------------------
*/

$menuId = (int) ($_GET['menu_id'] ?? 0);
$search = trim(
    (string) ($_GET['search'] ?? '')
);


/*
|--------------------------------------------------------------------------
| Load Menus
|--------------------------------------------------------------------------
*/

$menuStmt = $pdo->query("
    SELECT
        id,
        name,
        slug,
        location,
        status
    FROM menus
    ORDER BY
        CASE
            WHEN location = 'header' THEN 1
            WHEN location = 'footer' THEN 2
            ELSE 3
        END,
        name ASC
");

$menus = $menuStmt->fetchAll(PDO::FETCH_ASSOC);


/*
|--------------------------------------------------------------------------
| Load Menu Items
|--------------------------------------------------------------------------
*/

$sql = "
    SELECT
        mi.id,
        mi.menu_id,
        mi.parent_id,
        mi.title,
        mi.slug,
        mi.item_type,
        mi.reference_id,
        mi.url,
        mi.target,
        mi.icon,
        mi.image_id,
        mi.sort_order,
        mi.status,

        m.name AS menu_name

    FROM menu_items mi

    INNER JOIN menus m
        ON m.id = mi.menu_id

    WHERE 1 = 1
";

$params = [];

if ($menuId > 0) {
    $sql .= "
        AND mi.menu_id = :menu_id
    ";

    $params[':menu_id'] = $menuId;
}

if ($search !== '') {
    $sql .= "
        AND (
            mi.title LIKE :search
            OR mi.slug LIKE :search
        )
    ";

    $params[':search'] = '%' . $search . '%';
}

$sql .= "
    ORDER BY
        mi.menu_id ASC,
        mi.parent_id IS NOT NULL ASC,
        mi.parent_id ASC,
        mi.sort_order ASC,
        mi.id ASC
";

$stmt = $pdo->prepare($sql);
$stmt->execute($params);

$items = $stmt->fetchAll(PDO::FETCH_ASSOC);


/*
|--------------------------------------------------------------------------
| Load Media Library Images
|--------------------------------------------------------------------------
*/

$mediaImages = [];

try {

    $mediaStmt = $pdo->query("
        SELECT *
        FROM media
        ORDER BY id DESC
    ");

    $allMedia = $mediaStmt->fetchAll(PDO::FETCH_ASSOC);

    foreach ($allMedia as $media) {

        if (
            isset($media['id'])
            && isImageMedia($media)
        ) {
            $mediaImages[] = $media;
        }
    }

} catch (Throwable) {
    $mediaImages = [];
}


/*
|--------------------------------------------------------------------------
| Build Media Lookup
|--------------------------------------------------------------------------
*/

$mediaLookup = [];

foreach ($mediaImages as $media) {
    $mediaLookup[(int) $media['id']] = $media;
}


/*
|--------------------------------------------------------------------------
| Page
|--------------------------------------------------------------------------
*/

$page_title = 'Menu Images';
$active_menu = 'menu_images';

require_once __DIR__ . '/header.php';

?>

<style>

:root {
    --mi-primary: #2563eb;
    --mi-primary-dark: #1d4ed8;
    --mi-bg: #f6f8fc;
    --mi-card: #ffffff;
    --mi-border: #e5eaf2;
    --mi-text: #172033;
    --mi-muted: #6b7280;
    --mi-success: #059669;
    --mi-danger: #dc2626;
    --mi-shadow:
        0 18px 45px rgba(15, 23, 42, .07);
}

.menu-image-page {
    padding: 26px;
    background: var(--mi-bg);
    min-height: calc(100vh - 80px);
}

.mi-container {
    max-width: 1500px;
    margin: 0 auto;
}


/* Header */

.mi-page-header {
    display: flex;
    align-items: flex-end;
    justify-content: space-between;
    gap: 20px;
    margin-bottom: 24px;
}

.mi-title-wrap {
    display: flex;
    align-items: flex-start;
    gap: 14px;
}

.mi-title-icon {
    width: 50px;
    height: 50px;
    border-radius: 15px;
    display: grid;
    place-items: center;
    color: #fff;
    background:
        linear-gradient(
            135deg,
            #2563eb,
            #7c3aed
        );
    box-shadow:
        0 12px 25px rgba(37, 99, 235, .20);
    font-size: 21px;
}

.mi-title-wrap h1 {
    margin: 0 0 5px;
    color: var(--mi-text);
    font-size: 27px;
    font-weight: 800;
    letter-spacing: -.6px;
}

.mi-title-wrap p {
    margin: 0;
    color: var(--mi-muted);
    font-size: 14px;
}


/* Stats */

.mi-stats {
    display: flex;
    gap: 10px;
    flex-wrap: wrap;
}

.mi-stat {
    min-width: 125px;
    padding: 12px 15px;
    border: 1px solid var(--mi-border);
    border-radius: 13px;
    background: #fff;
}

.mi-stat strong {
    display: block;
    color: var(--mi-text);
    font-size: 18px;
    font-weight: 800;
}

.mi-stat span {
    display: block;
    margin-top: 2px;
    color: var(--mi-muted);
    font-size: 11px;
    font-weight: 700;
    text-transform: uppercase;
    letter-spacing: .4px;
}


/* Toolbar */

.mi-toolbar {
    display: grid;
    grid-template-columns:
        minmax(190px, .7fr)
        minmax(240px, 1fr)
        auto;
    gap: 12px;
    padding: 15px;
    margin-bottom: 18px;
    border: 1px solid var(--mi-border);
    border-radius: 17px;
    background: #fff;
    box-shadow: var(--mi-shadow);
}

.mi-input,
.mi-select {
    width: 100%;
    height: 46px;
    padding: 0 14px;
    border: 1px solid #dce2ec;
    border-radius: 11px;
    outline: none;
    color: var(--mi-text);
    background: #fbfcfe;
    font-size: 14px;
    transition: .2s ease;
}

.mi-input:focus,
.mi-select:focus {
    border-color: var(--mi-primary);
    box-shadow:
        0 0 0 4px rgba(37, 99, 235, .08);
}

.mi-btn {
    height: 46px;
    border: 0;
    border-radius: 11px;
    padding: 0 19px;
    cursor: pointer;
    font-weight: 750;
    font-size: 13px;
    transition: .2s ease;
}

.mi-btn-primary {
    color: #fff;
    background: var(--mi-primary);
}

.mi-btn-primary:hover {
    background: var(--mi-primary-dark);
    transform: translateY(-1px);
}


/* Main Card */

.mi-card {
    overflow: hidden;
    border: 1px solid var(--mi-border);
    border-radius: 18px;
    background: #fff;
    box-shadow: var(--mi-shadow);
}

.mi-card-head {
    display: flex;
    align-items: center;
    justify-content: space-between;
    gap: 15px;
    padding: 19px 21px;
    border-bottom: 1px solid var(--mi-border);
}

.mi-card-head h2 {
    margin: 0;
    color: var(--mi-text);
    font-size: 16px;
    font-weight: 800;
}

.mi-card-head span {
    color: var(--mi-muted);
    font-size: 12px;
}


/* Table */

.mi-table-wrap {
    width: 100%;
    overflow-x: auto;
}

.mi-table {
    width: 100%;
    min-width: 920px;
    border-collapse: collapse;
}

.mi-table th {
    padding: 13px 17px;
    text-align: left;
    color: #667085;
    background: #fafbfc;
    border-bottom: 1px solid var(--mi-border);
    font-size: 11px;
    font-weight: 800;
    text-transform: uppercase;
    letter-spacing: .5px;
}

.mi-table td {
    padding: 14px 17px;
    color: var(--mi-text);
    border-bottom: 1px solid #edf0f5;
    vertical-align: middle;
    font-size: 13px;
}

.mi-table tbody tr {
    transition: .16s ease;
}

.mi-table tbody tr:hover {
    background: #fafcff;
}


/* Item */

.mi-item {
    display: flex;
    align-items: center;
    gap: 11px;
}

.mi-item-icon {
    width: 37px;
    height: 37px;
    flex: 0 0 37px;
    display: grid;
    place-items: center;
    border-radius: 10px;
    color: #2563eb;
    background: #eff6ff;
}

.mi-item-name {
    font-weight: 750;
    color: var(--mi-text);
}

.mi-item-meta {
    margin-top: 3px;
    color: var(--mi-muted);
    font-size: 11px;
}


/* Preview */

.mi-preview {
    width: 64px;
    height: 48px;
    overflow: hidden;
    display: grid;
    place-items: center;
    border: 1px solid #e2e7ef;
    border-radius: 10px;
    background:
        linear-gradient(
            135deg,
            #f3f5f9,
            #eef2f7
        );
}

.mi-preview img {
    width: 100%;
    height: 100%;
    object-fit: cover;
}

.mi-no-image {
    color: #98a2b3;
    font-size: 11px;
    text-align: center;
}


/* Badge */

.mi-badge {
    display: inline-flex;
    align-items: center;
    gap: 5px;
    padding: 5px 9px;
    border-radius: 999px;
    font-size: 11px;
    font-weight: 750;
}

.mi-badge-active {
    color: #047857;
    background: #ecfdf5;
}

.mi-badge-inactive {
    color: #b42318;
    background: #fef3f2;
}


/* Actions */

.mi-actions {
    display: flex;
    align-items: center;
    gap: 7px;
}

.mi-action {
    height: 35px;
    padding: 0 11px;
    border: 1px solid #e0e5ed;
    border-radius: 9px;
    background: #fff;
    cursor: pointer;
    color: #344054;
    font-size: 12px;
    font-weight: 700;
    transition: .18s ease;
}

.mi-action:hover {
    border-color: #c7d0dd;
    background: #f8fafc;
}

.mi-action.assign {
    color: #1d4ed8;
    border-color: #dbeafe;
    background: #eff6ff;
}

.mi-action.remove {
    color: #b42318;
    border-color: #fee4e2;
    background: #fff5f4;
}


/* Empty */

.mi-empty {
    padding: 65px 25px;
    text-align: center;
}

.mi-empty-icon {
    width: 58px;
    height: 58px;
    margin: 0 auto 13px;
    display: grid;
    place-items: center;
    border-radius: 17px;
    background: #f1f5f9;
    color: #64748b;
    font-size: 23px;
}

.mi-empty h3 {
    margin: 0 0 6px;
    font-size: 16px;
}

.mi-empty p {
    margin: 0;
    color: var(--mi-muted);
    font-size: 13px;
}


/* Modal */

.mi-modal {
    position: fixed;
    inset: 0;
    z-index: 9999;
    display: none;
    align-items: center;
    justify-content: center;
    padding: 20px;
    background: rgba(15, 23, 42, .62);
    backdrop-filter: blur(7px);
}

.mi-modal.show {
    display: flex;
}

.mi-modal-box {
    width: min(940px, 100%);
    max-height: min(780px, 92vh);
    overflow: hidden;
    display: flex;
    flex-direction: column;
    border-radius: 20px;
    background: #fff;
    box-shadow:
        0 35px 100px rgba(0,0,0,.24);
}

.mi-modal-head {
    display: flex;
    align-items: center;
    justify-content: space-between;
    gap: 15px;
    padding: 18px 20px;
    border-bottom: 1px solid var(--mi-border);
}

.mi-modal-head h3 {
    margin: 0;
    font-size: 17px;
}

.mi-modal-close {
    width: 36px;
    height: 36px;
    border: 0;
    border-radius: 9px;
    cursor: pointer;
    background: #f2f4f7;
    color: #475467;
    font-size: 18px;
}

.mi-modal-body {
    overflow-y: auto;
    padding: 20px;
}

.mi-media-search {
    margin-bottom: 16px;
}

.mi-media-grid {
    display: grid;
    grid-template-columns:
        repeat(auto-fill, minmax(145px, 1fr));
    gap: 13px;
}

.mi-media-card {
    position: relative;
    overflow: hidden;
    border: 1px solid #e4e7ec;
    border-radius: 13px;
    background: #fff;
    cursor: pointer;
    transition: .18s ease;
}

.mi-media-card:hover {
    transform: translateY(-2px);
    border-color: #93c5fd;
    box-shadow:
        0 10px 25px rgba(37,99,235,.10);
}

.mi-media-card.current {
    border: 2px solid var(--mi-primary);
}

.mi-media-image {
    height: 105px;
    background: #f3f5f8;
}

.mi-media-image img {
    width: 100%;
    height: 100%;
    object-fit: cover;
}

.mi-media-info {
    padding: 9px 10px;
}

.mi-media-name {
    overflow: hidden;
    white-space: nowrap;
    text-overflow: ellipsis;
    color: var(--mi-text);
    font-size: 12px;
    font-weight: 750;
}

.mi-media-id {
    margin-top: 3px;
    color: var(--mi-muted);
    font-size: 10px;
}


/* Toast */

.mi-toast {
    position: fixed;
    right: 22px;
    bottom: 22px;
    z-index: 10000;
    min-width: 260px;
    max-width: 400px;
    padding: 14px 16px;
    border: 1px solid #dce2eb;
    border-radius: 12px;
    background: #fff;
    color: var(--mi-text);
    box-shadow:
        0 18px 45px rgba(15,23,42,.16);
    transform: translateY(25px);
    opacity: 0;
    pointer-events: none;
    transition: .25s ease;
    font-size: 13px;
    font-weight: 700;
}

.mi-toast.show {
    transform: translateY(0);
    opacity: 1;
}

.mi-toast.success {
    border-left: 4px solid var(--mi-success);
}

.mi-toast.error {
    border-left: 4px solid var(--mi-danger);
}


/* Responsive */

@media (max-width: 900px) {

    .menu-image-page {
        padding: 20px 15px;
    }

    .mi-page-header {
        align-items: flex-start;
        flex-direction: column;
    }

    .mi-toolbar {
        grid-template-columns: 1fr;
    }

    .mi-stats {
        width: 100%;
    }

    .mi-stat {
        flex: 1;
    }
}

@media (max-width: 600px) {

    .menu-image-page {
        padding: 14px 10px;
    }

    .mi-title-wrap h1 {
        font-size: 22px;
    }

    .mi-title-icon {
        width: 44px;
        height: 44px;
    }

    .mi-stats {
        display: grid;
        grid-template-columns: 1fr 1fr;
        width: 100%;
    }

    .mi-stat {
        min-width: 0;
    }

    .mi-modal {
        padding: 10px;
    }

    .mi-modal-body {
        padding: 13px;
    }

    .mi-media-grid {
        grid-template-columns:
            repeat(2, minmax(0, 1fr));
    }
}

</style>


<div class="menu-image-page">

    <div class="mi-container">

        <!-- PAGE HEADER -->

        <div class="mi-page-header">

            <div class="mi-title-wrap">

                <div class="mi-title-icon">
                    <i class="fa-solid fa-image"></i>
                </div>

                <div>
                    <h1>Menu Images</h1>

                    <p>
                        Assign Media Library images to your navigation menu items.
                    </p>
                </div>

            </div>


            <div class="mi-stats">

                <div class="mi-stat">
                    <strong><?= count($items) ?></strong>
                    <span>Menu Items</span>
                </div>

                <div class="mi-stat">
                    <strong><?= count($mediaImages) ?></strong>
                    <span>Images</span>
                </div>

                <div class="mi-stat">
                    <strong>
                        <?=
                        count(
                            array_filter(
                                $items,
                                static fn(array $item): bool =>
                                    !empty($item['image_id'])
                            )
                        )
                        ?>
                    </strong>
                    <span>Assigned</span>
                </div>

            </div>

        </div>


        <!-- FILTER -->

        <form
            method="GET"
            class="mi-toolbar"
        >

            <select
                name="menu_id"
                class="mi-select"
            >

                <option value="0">
                    All Menus
                </option>

                <?php foreach ($menus as $menu): ?>

                    <option
                        value="<?= (int) $menu['id'] ?>"
                        <?= selected(
                            $menuId,
                            $menu['id']
                        ) ?>
                    >
                        <?= e($menu['name']) ?>
                        — <?= e($menu['location']) ?>
                    </option>

                <?php endforeach; ?>

            </select>


            <input
                type="search"
                name="search"
                class="mi-input"
                value="<?= e($search) ?>"
                placeholder="Search menu item or slug..."
            >


            <button
                type="submit"
                class="mi-btn mi-btn-primary"
            >
                <i class="fa-solid fa-filter"></i>
                &nbsp; Filter
            </button>

        </form>


        <!-- MAIN CARD -->

        <div class="mi-card">

            <div class="mi-card-head">

                <div>
                    <h2>
                        Navigation Image Mapping
                    </h2>
                </div>

                <span>
                    <?= count($items) ?> item(s)
                </span>

            </div>


            <?php if (!$items): ?>

                <div class="mi-empty">

                    <div class="mi-empty-icon">
                        <i class="fa-regular fa-folder-open"></i>
                    </div>

                    <h3>
                        No menu items found
                    </h3>

                    <p>
                        Create menu items first from Menu Management.
                    </p>

                </div>

            <?php else: ?>

                <div class="mi-table-wrap">

                    <table class="mi-table">

                        <thead>

                            <tr>

                                <th>
                                    Menu Item
                                </th>

                                <th>
                                    Menu
                                </th>

                                <th>
                                    Current Image
                                </th>

                                <th>
                                    Status
                                </th>

                                <th>
                                    Actions
                                </th>

                            </tr>

                        </thead>


                        <tbody>

                        <?php foreach ($items as $item): ?>

                            <?php

                            $itemImage = null;

                            if (!empty($item['image_id'])) {

                                $itemImage =
                                    $mediaLookup[
                                        (int) $item['image_id']
                                    ]
                                    ?? null;
                            }

                            $itemImageUrl =
                                $itemImage
                                    ? mediaUrl($itemImage)
                                    : '';

                            ?>

                            <tr>

                                <td>

                                    <div class="mi-item">

                                        <div class="mi-item-icon">

                                            <i class="fa-solid fa-link"></i>

                                        </div>

                                        <div>

                                            <div class="mi-item-name">
                                                <?= e($item['title']) ?>
                                            </div>

                                            <div class="mi-item-meta">

                                                ID #<?= (int) $item['id'] ?>

                                                <?php if (!empty($item['slug'])): ?>

                                                    ·
                                                    <?= e($item['slug']) ?>

                                                <?php endif; ?>

                                            </div>

                                        </div>

                                    </div>

                                </td>


                                <td>

                                    <strong>
                                        <?= e($item['menu_name']) ?>
                                    </strong>

                                </td>


                                <td>

                                    <div class="mi-preview">

                                        <?php if ($itemImageUrl): ?>

                                            <img
                                                src="<?= e($itemImageUrl) ?>"
                                                alt="<?= e(
                                                    $itemImage
                                                        ? mediaTitle($itemImage)
                                                        : $item['title']
                                                ) ?>"
                                            >

                                        <?php else: ?>

                                            <div class="mi-no-image">
                                                No Image
                                            </div>

                                        <?php endif; ?>

                                    </div>

                                </td>


                                <td>

                                    <?php if ((int) $item['status'] === 1): ?>

                                        <span class="mi-badge mi-badge-active">
                                            <i class="fa-solid fa-circle-check"></i>
                                            Active
                                        </span>

                                    <?php else: ?>

                                        <span class="mi-badge mi-badge-inactive">
                                            <i class="fa-solid fa-circle-xmark"></i>
                                            Inactive
                                        </span>

                                    <?php endif; ?>

                                </td>


                                <td>

                                    <div class="mi-actions">

                                        <button
                                            type="button"
                                            class="mi-action assign"
                                            onclick="openMediaPicker(
                                                <?= (int) $item['id'] ?>,
                                                <?= (int) ($item['image_id'] ?? 0) ?>
                                            )"
                                        >
                                            <i class="fa-solid fa-image"></i>
                                            <?= $itemImage
                                                ? 'Change'
                                                : 'Assign'
                                            ?>
                                        </button>


                                        <?php if ($itemImage): ?>

                                            <button
                                                type="button"
                                                class="mi-action remove"
                                                onclick="removeImage(
                                                    <?= (int) $item['id'] ?>
                                                )"
                                            >
                                                <i class="fa-solid fa-xmark"></i>
                                                Remove
                                            </button>

                                        <?php endif; ?>

                                    </div>

                                </td>

                            </tr>

                        <?php endforeach; ?>

                        </tbody>

                    </table>

                </div>

            <?php endif; ?>

        </div>

    </div>

</div>


<!-- MEDIA PICKER MODAL -->

<div
    class="mi-modal"
    id="mediaModal"
    aria-hidden="true"
>

    <div class="mi-modal-box">

        <div class="mi-modal-head">

            <div>
                <h3>
                    Select Menu Image
                </h3>
            </div>

            <button
                type="button"
                class="mi-modal-close"
                onclick="closeMediaPicker()"
            >
                ×
            </button>

        </div>


        <div class="mi-modal-body">

            <?php if (!$mediaImages): ?>

                <div class="mi-empty">

                    <div class="mi-empty-icon">
                        <i class="fa-regular fa-images"></i>
                    </div>

                    <h3>
                        No images available
                    </h3>

                    <p>
                        Upload images from the Media Library first.
                    </p>

                </div>

            <?php else: ?>

                <input
                    type="search"
                    id="mediaSearch"
                    class="mi-input mi-media-search"
                    placeholder="Search images..."
                    autocomplete="off"
                >


                <div
                    class="mi-media-grid"
                    id="mediaGrid"
                >

                    <?php foreach ($mediaImages as $media): ?>

                        <?php

                        $mediaId = (int) $media['id'];

                        $mediaUrl = mediaUrl($media);

                        $mediaName = mediaTitle($media);

                        ?>

                        <button
                            type="button"
                            class="mi-media-card"
                            data-media-id="<?= $mediaId ?>"
                            data-media-name="<?= e(
                                strtolower($mediaName)
                            ) ?>"
                            onclick="selectMedia(
                                <?= $mediaId ?>
                            )"
                        >

                            <div class="mi-media-image">

                                <?php if ($mediaUrl): ?>

                                    <img
                                        src="<?= e($mediaUrl) ?>"
                                        alt="<?= e($mediaName) ?>"
                                        loading="lazy"
                                    >

                                <?php else: ?>

                                    <div class="mi-no-image">
                                        Preview unavailable
                                    </div>

                                <?php endif; ?>

                            </div>


                            <div class="mi-media-info">

                                <div class="mi-media-name">
                                    <?= e($mediaName) ?>
                                </div>

                                <div class="mi-media-id">
                                    Media #<?= $mediaId ?>
                                </div>

                            </div>

                        </button>

                    <?php endforeach; ?>

                </div>

            <?php endif; ?>

        </div>

    </div>

</div>


<div
    class="mi-toast"
    id="miToast"
></div>


<script>

const CSRF_TOKEN =
    <?= csrf_token_json() ?>;

let selectedItemId = 0;
let selectedCurrentMediaId = 0;


/*
|--------------------------------------------------------------------------
| Toast
|--------------------------------------------------------------------------
*/

function showToast(
    message,
    type = 'success'
) {

    const toast =
        document.getElementById('miToast');

    toast.textContent = message;

    toast.className =
        'mi-toast show ' + type;

    clearTimeout(
        window.__miToastTimer
    );

    window.__miToastTimer =
        setTimeout(() => {

            toast.classList.remove('show');

        }, 3200);
}


/*
|--------------------------------------------------------------------------
| Open Media Picker
|--------------------------------------------------------------------------
*/

function openMediaPicker(
    itemId,
    currentMediaId = 0
) {

    selectedItemId =
        Number(itemId);

    selectedCurrentMediaId =
        Number(currentMediaId);

    const modal =
        document.getElementById('mediaModal');

    modal.classList.add('show');

    modal.setAttribute(
        'aria-hidden',
        'false'
    );


    document
        .querySelectorAll('.mi-media-card')
        .forEach(card => {

            const mediaId =
                Number(
                    card.dataset.mediaId
                );

            card.classList.toggle(
                'current',
                mediaId === selectedCurrentMediaId
            );

        });


    const search =
        document.getElementById('mediaSearch');

    if (search) {

        search.value = '';

        filterMedia();

        setTimeout(() => {
            search.focus();
        }, 80);
    }
}


/*
|--------------------------------------------------------------------------
| Close Picker
|--------------------------------------------------------------------------
*/

function closeMediaPicker() {

    const modal =
        document.getElementById('mediaModal');

    modal.classList.remove('show');

    modal.setAttribute(
        'aria-hidden',
        'true'
    );

    selectedItemId = 0;
    selectedCurrentMediaId = 0;
}


/*
|--------------------------------------------------------------------------
| Search Media
|--------------------------------------------------------------------------
*/

function filterMedia() {

    const input =
        document.getElementById('mediaSearch');

    if (!input) {
        return;
    }

    const query =
        input.value
            .trim()
            .toLowerCase();

    document
        .querySelectorAll('.mi-media-card')
        .forEach(card => {

            const name =
                card.dataset.mediaName || '';

            card.style.display =
                !query || name.includes(query)
                    ? ''
                    : 'none';
        });
}


document
    .getElementById('mediaSearch')
    ?.addEventListener(
        'input',
        filterMedia
    );


/*
|--------------------------------------------------------------------------
| Select Media
|--------------------------------------------------------------------------
*/

async function selectMedia(
    mediaId
) {

    if (
        selectedItemId <= 0
        || mediaId <= 0
    ) {
        return;
    }


    const formData =
        new FormData();

    formData.append(
        'action',
        'assign_image'
    );

    formData.append(
        'item_id',
        selectedItemId
    );

    formData.append(
        'media_id',
        mediaId
    );

    formData.append(
        'csrf_token',
        CSRF_TOKEN
    );


    try {

        const response =
            await fetch(
                'menu_image.php',
                {
                    method: 'POST',
                    body: formData,
                    credentials: 'same-origin'
                }
            );

        const data =
            await response.json();

        if (!data.success) {

            throw new Error(
                data.message
                || 'Unable to assign image.'
            );
        }


        closeMediaPicker();

        showToast(
            data.message
            || 'Image assigned successfully.',
            'success'
        );


        setTimeout(() => {
            window.location.reload();
        }, 650);

    } catch (error) {

        showToast(
            error.message
            || 'Something went wrong.',
            'error'
        );
    }
}


/*
|--------------------------------------------------------------------------
| Remove Image
|--------------------------------------------------------------------------
*/

async function removeImage(
    itemId
) {

    if (
        !confirm(
            'Are you sure you want to remove this menu image?'
        )
    ) {
        return;
    }


    const formData =
        new FormData();

    formData.append(
        'action',
        'remove_image'
    );

    formData.append(
        'item_id',
        itemId
    );

    formData.append(
        'csrf_token',
        CSRF_TOKEN
    );


    try {

        const response =
            await fetch(
                'menu_image.php',
                {
                    method: 'POST',
                    body: formData,
                    credentials: 'same-origin'
                }
            );

        const data =
            await response.json();

        if (!data.success) {

            throw new Error(
                data.message
                || 'Unable to remove image.'
            );
        }


        showToast(
            data.message
            || 'Image removed successfully.',
            'success'
        );


        setTimeout(() => {
            window.location.reload();
        }, 650);

    } catch (error) {

        showToast(
            error.message
            || 'Something went wrong.',
            'error'
        );
    }
}


/*
|--------------------------------------------------------------------------
| Close modal on outside click
|--------------------------------------------------------------------------
*/

document
    .getElementById('mediaModal')
    ?.addEventListener(
        'click',
        function(event) {

            if (event.target === this) {
                closeMediaPicker();
            }

        }
    );


/*
|--------------------------------------------------------------------------
| Escape key
|--------------------------------------------------------------------------
*/

document.addEventListener(
    'keydown',
    function(event) {

        if (
            event.key === 'Escape'
        ) {
            closeMediaPicker();
        }

    }
);

</script>


<?php

require_once __DIR__ . '/footer.php';
?>