📁 File Manager
Editing:
/home/wvl7mof7402e/public_html/chem/admin/menu_description.php
<?php declare(strict_types=1); /** * Pure Chemical Admin * File: admin/menu_description.php * * Purpose: * - Manage menu descriptions * - Uses existing `menus.description` * - 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(); $page_title = 'Menu Descriptions'; $active_menu = 'menu_description'; $success = ''; $error = ''; /* |-------------------------------------------------------------------------- | Helper |-------------------------------------------------------------------------- */ if (!function_exists('e')) { function e(mixed $value): string { return htmlspecialchars((string)$value, ENT_QUOTES, 'UTF-8'); } } /* |-------------------------------------------------------------------------- | Load Menus |-------------------------------------------------------------------------- */ $stmt = $pdo->query(" SELECT id, name, slug, location, description, status, created_at, updated_at FROM menus ORDER BY CASE WHEN status = 1 THEN 0 ELSE 1 END, name ASC "); $menus = $stmt->fetchAll(); /* |-------------------------------------------------------------------------- | Selected Menu |-------------------------------------------------------------------------- */ $selectedMenuId = isset($_GET['menu_id']) ? (int)$_GET['menu_id'] : (isset($_POST['menu_id']) ? (int)$_POST['menu_id'] : 0); $selectedMenu = null; if ($selectedMenuId > 0) { $stmt = $pdo->prepare(" SELECT id, name, slug, location, description, status, created_at, updated_at FROM menus WHERE id = ? LIMIT 1 "); $stmt->execute([$selectedMenuId]); $selectedMenu = $stmt->fetch(); } /* |-------------------------------------------------------------------------- | Default First Menu |-------------------------------------------------------------------------- */ if (!$selectedMenu && !empty($menus)) { $selectedMenu = $menus[0]; $selectedMenuId = (int)$selectedMenu['id']; } /* |-------------------------------------------------------------------------- | Update Description |-------------------------------------------------------------------------- */ if ($_SERVER['REQUEST_METHOD'] === 'POST') { try { if (function_exists('requireCsrf')) { requireCsrf(); } $action = trim((string)($_POST['action'] ?? '')); if ($action === 'save_description') { $menuId = (int)($_POST['menu_id'] ?? 0); $description = trim( (string)($_POST['description'] ?? '') ); if ($menuId <= 0) { throw new RuntimeException('Please select a valid menu.'); } /* * Check menu exists */ $check = $pdo->prepare(" SELECT id FROM menus WHERE id = ? LIMIT 1 "); $check->execute([$menuId]); if (!$check->fetch()) { throw new RuntimeException('Selected menu was not found.'); } /* * Description length limit * * DB column is TEXT, but we keep a practical * frontend/admin limit. */ if (mb_strlen($description) > 5000) { throw new RuntimeException( 'Menu description cannot exceed 5000 characters.' ); } /* * Save description */ $update = $pdo->prepare(" UPDATE menus SET description = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ? LIMIT 1 "); $update->execute([ $description !== '' ? $description : null, $menuId ]); $success = 'Menu description updated successfully.'; $selectedMenuId = $menuId; /* * Reload selected menu */ $stmt = $pdo->prepare(" SELECT id, name, slug, location, description, status, created_at, updated_at FROM menus WHERE id = ? LIMIT 1 "); $stmt->execute([$selectedMenuId]); $selectedMenu = $stmt->fetch(); /* * Refresh menu list */ $stmt = $pdo->query(" SELECT id, name, slug, location, description, status, created_at, updated_at FROM menus ORDER BY CASE WHEN status = 1 THEN 0 ELSE 1 END, name ASC "); $menus = $stmt->fetchAll(); } } catch (Throwable $e) { $error = $e->getMessage(); } } require_once __DIR__ . '/header.php'; ?> <style> /* ========================================================= MENU DESCRIPTION PAGE ========================================================= */ .md-page { --md-primary: #0f766e; --md-primary-dark: #115e59; --md-primary-soft: #ecfdf5; --md-border: #e5e7eb; --md-text: #111827; --md-muted: #6b7280; --md-bg: #f6f8fb; --md-white: #ffffff; padding: 24px; background: var(--md-bg); min-height: calc(100vh - 70px); } .md-container { max-width: 1450px; margin: 0 auto; } /* ========================================================= HEADER ========================================================= */ .md-header { display: flex; align-items: flex-start; justify-content: space-between; gap: 20px; margin-bottom: 24px; } .md-title-wrap { min-width: 0; } .md-breadcrumb { display: flex; align-items: center; gap: 8px; margin-bottom: 8px; color: var(--md-muted); font-size: 13px; } .md-breadcrumb i { font-size: 10px; } .md-title { margin: 0; color: var(--md-text); font-size: 28px; font-weight: 800; letter-spacing: -0.7px; } .md-subtitle { margin: 7px 0 0; color: var(--md-muted); font-size: 14px; line-height: 1.6; } /* ========================================================= LAYOUT ========================================================= */ .md-layout { display: grid; grid-template-columns: 340px minmax(0, 1fr); gap: 20px; align-items: start; } /* ========================================================= CARDS ========================================================= */ .md-card { background: var(--md-white); border: 1px solid var(--md-border); border-radius: 18px; box-shadow: 0 8px 30px rgba(15, 23, 42, 0.055); overflow: hidden; } .md-card-header { padding: 18px 20px; border-bottom: 1px solid var(--md-border); } .md-card-header-row { display: flex; align-items: center; justify-content: space-between; gap: 12px; } .md-card-title { margin: 0; color: var(--md-text); font-size: 15px; font-weight: 800; } .md-card-subtitle { margin: 4px 0 0; color: var(--md-muted); font-size: 12px; } .md-card-body { padding: 20px; } /* ========================================================= MENU LIST ========================================================= */ .md-menu-list { display: flex; flex-direction: column; gap: 8px; } .md-menu-item { position: relative; display: block; padding: 13px 14px; border: 1px solid transparent; border-radius: 13px; text-decoration: none; color: var(--md-text); transition: 0.2s ease; } .md-menu-item:hover { background: #f8fafc; border-color: var(--md-border); transform: translateY(-1px); } .md-menu-item.active { background: var(--md-primary-soft); border-color: rgba(15, 118, 110, 0.22); } .md-menu-main { display: flex; align-items: center; gap: 11px; } .md-menu-icon { width: 36px; height: 36px; flex: 0 0 36px; display: flex; align-items: center; justify-content: center; border-radius: 10px; background: #f1f5f9; color: #64748b; } .md-menu-item.active .md-menu-icon { background: #d1fae5; color: var(--md-primary); } .md-menu-name { min-width: 0; flex: 1; } .md-menu-name strong { display: block; font-size: 13px; font-weight: 750; white-space: nowrap; overflow: hidden; text-overflow: ellipsis; } .md-menu-location { display: block; margin-top: 3px; color: var(--md-muted); font-size: 11px; text-transform: capitalize; } .md-menu-arrow { color: #94a3b8; font-size: 12px; } .md-menu-item.active .md-menu-arrow { color: var(--md-primary); } .md-status { display: inline-flex; align-items: center; gap: 5px; margin-top: 7px; padding: 3px 8px; border-radius: 999px; font-size: 10px; font-weight: 750; } .md-status.active { background: #dcfce7; color: #166534; } .md-status.inactive { background: #f1f5f9; color: #64748b; } /* ========================================================= FORM ========================================================= */ .md-editor-head { display: flex; align-items: center; justify-content: space-between; gap: 15px; margin-bottom: 18px; } .md-selected { display: flex; align-items: center; gap: 12px; } .md-selected-icon { width: 44px; height: 44px; display: flex; align-items: center; justify-content: center; border-radius: 13px; background: var(--md-primary-soft); color: var(--md-primary); font-size: 17px; } .md-selected-name { margin: 0; font-size: 17px; font-weight: 800; color: var(--md-text); } .md-selected-meta { margin: 3px 0 0; color: var(--md-muted); font-size: 12px; } .md-label { display: block; margin-bottom: 8px; color: var(--md-text); font-size: 13px; font-weight: 750; } .md-textarea-wrap { position: relative; } .md-textarea { width: 100%; min-height: 330px; resize: vertical; padding: 17px 18px 42px; border: 1px solid #dfe3e8; border-radius: 14px; outline: none; background: #fff; color: #1f2937; font-family: inherit; font-size: 14px; line-height: 1.75; transition: 0.2s ease; box-sizing: border-box; } .md-textarea:hover { border-color: #cbd5e1; } .md-textarea:focus { border-color: var(--md-primary); box-shadow: 0 0 0 4px rgba(15, 118, 110, 0.09); } .md-counter { position: absolute; right: 13px; bottom: 12px; color: #94a3b8; font-size: 11px; pointer-events: none; } .md-help { display: flex; align-items: flex-start; gap: 8px; margin-top: 10px; color: var(--md-muted); font-size: 12px; line-height: 1.55; } .md-help i { margin-top: 2px; color: var(--md-primary); } /* ========================================================= INFO ========================================================= */ .md-info-grid { display: grid; grid-template-columns: repeat(3, 1fr); gap: 10px; margin-top: 22px; } .md-info { padding: 13px; border: 1px solid var(--md-border); border-radius: 12px; background: #fafafa; } .md-info-label { display: block; color: #94a3b8; font-size: 10px; font-weight: 700; text-transform: uppercase; letter-spacing: .4px; } .md-info-value { display: block; margin-top: 5px; color: var(--md-text); font-size: 12px; font-weight: 700; word-break: break-word; } /* ========================================================= FOOTER ACTION ========================================================= */ .md-form-actions { display: flex; align-items: center; justify-content: space-between; gap: 15px; margin-top: 20px; padding-top: 18px; border-top: 1px solid var(--md-border); } .md-last-update { color: var(--md-muted); font-size: 11px; } .md-save-btn { display: inline-flex; align-items: center; justify-content: center; gap: 8px; min-height: 44px; padding: 0 20px; border: 0; border-radius: 11px; background: var(--md-primary); color: #fff; font-family: inherit; font-size: 13px; font-weight: 750; cursor: pointer; box-shadow: 0 7px 18px rgba(15, 118, 110, 0.18); transition: 0.2s ease; } .md-save-btn:hover { background: var(--md-primary-dark); transform: translateY(-1px); box-shadow: 0 10px 22px rgba(15, 118, 110, 0.23); } .md-save-btn:active { transform: translateY(0); } /* ========================================================= EMPTY ========================================================= */ .md-empty { padding: 60px 20px; text-align: center; } .md-empty-icon { width: 58px; height: 58px; margin: 0 auto 15px; display: flex; align-items: center; justify-content: center; border-radius: 16px; background: #f1f5f9; color: #94a3b8; font-size: 22px; } .md-empty h3 { margin: 0; color: var(--md-text); font-size: 16px; } .md-empty p { margin: 7px auto 0; max-width: 420px; color: var(--md-muted); font-size: 13px; } /* ========================================================= ALERTS ========================================================= */ .md-alert { display: flex; align-items: flex-start; gap: 11px; padding: 13px 15px; margin-bottom: 18px; border-radius: 12px; font-size: 13px; line-height: 1.5; } .md-alert i { margin-top: 2px; } .md-alert.success { background: #ecfdf5; color: #065f46; border: 1px solid #a7f3d0; } .md-alert.error { background: #fef2f2; color: #991b1b; border: 1px solid #fecaca; } /* ========================================================= RESPONSIVE ========================================================= */ @media (max-width: 1050px) { .md-layout { grid-template-columns: 280px minmax(0, 1fr); } } @media (max-width: 820px) { .md-page { padding: 17px; } .md-header { flex-direction: column; } .md-layout { grid-template-columns: 1fr; } .md-menu-list { display: grid; grid-template-columns: repeat(2, minmax(0, 1fr)); } } @media (max-width: 600px) { .md-page { padding: 12px; } .md-title { font-size: 23px; } .md-menu-list { grid-template-columns: 1fr; } .md-card-body, .md-card-header { padding: 15px; } .md-editor-head { align-items: flex-start; } .md-info-grid { grid-template-columns: 1fr; } .md-form-actions { align-items: stretch; flex-direction: column; } .md-save-btn { width: 100%; } .md-textarea { min-height: 270px; } } </style> <div class="md-page"> <div class="md-container"> <!-- ===================================================== PAGE HEADER ====================================================== --> <div class="md-header"> <div class="md-title-wrap"> <div class="md-breadcrumb"> <span>Website</span> <i class="fa-solid fa-chevron-right"></i> <span>Menu Management</span> <i class="fa-solid fa-chevron-right"></i> <span>Descriptions</span> </div> <h1 class="md-title"> Menu Descriptions </h1> <p class="md-subtitle"> Manage descriptions for your website navigation menus. These descriptions are stored directly with each menu. </p> </div> </div> <!-- ===================================================== ALERTS ====================================================== --> <?php if ($success !== ''): ?> <div class="md-alert success" id="successAlert"> <i class="fa-solid fa-circle-check"></i> <div> <?= e($success) ?> </div> </div> <?php endif; ?> <?php if ($error !== ''): ?> <div class="md-alert error"> <i class="fa-solid fa-circle-exclamation"></i> <div> <?= e($error) ?> </div> </div> <?php endif; ?> <?php if (empty($menus)): ?> <!-- ================================================= NO MENUS ================================================== --> <div class="md-card"> <div class="md-empty"> <div class="md-empty-icon"> <i class="fa-solid fa-bars"></i> </div> <h3>No menus found</h3> <p> Create a menu first from the Menu Management section before adding a description. </p> </div> </div> <?php else: ?> <div class="md-layout"> <!-- ================================================= LEFT MENU LIST ================================================== --> <div class="md-card"> <div class="md-card-header"> <div class="md-card-header-row"> <div> <h2 class="md-card-title"> Select Menu </h2> <p class="md-card-subtitle"> Choose a menu to edit </p> </div> <span style=" display:inline-flex; align-items:center; justify-content:center; width:30px; height:30px; border-radius:9px; background:#f1f5f9; color:#64748b; "> <i class="fa-solid fa-list"></i> </span> </div> </div> <div class="md-card-body"> <div class="md-menu-list"> <?php foreach ($menus as $menu): ?> <?php $isActive = (int)$menu['id'] === $selectedMenuId; $hasDescription = trim((string)$menu['description']) !== ''; ?> <a href="?menu_id=<?= (int)$menu['id'] ?>" class="md-menu-item <?= $isActive ? 'active' : '' ?>" > <div class="md-menu-main"> <div class="md-menu-icon"> <i class="fa-solid fa-bars-staggered"></i> </div> <div class="md-menu-name"> <strong> <?= e($menu['name']) ?> </strong> <span class="md-menu-location"> <?= e($menu['location'] ?: 'Not specified') ?> </span> <?php if ((int)$menu['status'] === 1): ?> <span class="md-status active"> <i class="fa-solid fa-circle" style="font-size:6px;"></i> Active </span> <?php else: ?> <span class="md-status inactive"> <i class="fa-solid fa-circle" style="font-size:6px;"></i> Inactive </span> <?php endif; ?> </div> <div class="md-menu-arrow"> <?php if ($isActive): ?> <i class="fa-solid fa-chevron-right"></i> <?php else: ?> <i class="fa-solid fa-angle-right"></i> <?php endif; ?> </div> </div> </a> <?php endforeach; ?> </div> </div> </div> <!-- ================================================= DESCRIPTION EDITOR ================================================== --> <div class="md-card"> <?php if ($selectedMenu): ?> <div class="md-card-header"> <div class="md-editor-head"> <div class="md-selected"> <div class="md-selected-icon"> <i class="fa-solid fa-align-left"></i> </div> <div> <h2 class="md-selected-name"> <?= e($selectedMenu['name']) ?> </h2> <p class="md-selected-meta"> <?= e($selectedMenu['slug']) ?> </p> </div> </div> <?php if ((int)$selectedMenu['status'] === 1): ?> <span class="md-status active"> <i class="fa-solid fa-circle" style="font-size:6px;"></i> Active </span> <?php else: ?> <span class="md-status inactive"> <i class="fa-solid fa-circle" style="font-size:6px;"></i> Inactive </span> <?php endif; ?> </div> </div> <div class="md-card-body"> <form method="POST" action="" id="descriptionForm" > <?php if (function_exists('csrf_field')): ?> <?= csrf_field() ?> <?php endif; ?> <input type="hidden" name="action" value="save_description" > <input type="hidden" name="menu_id" value="<?= (int)$selectedMenu['id'] ?>" > <label class="md-label" for="menuDescription" > Menu Description </label> <div class="md-textarea-wrap"> <textarea name="description" id="menuDescription" class="md-textarea" maxlength="5000" placeholder="Write a short description for this menu..." ><?= e($selectedMenu['description'] ?? '') ?></textarea> <span class="md-counter" id="charCounter" >0 / 5000</span> </div> <div class="md-help"> <i class="fa-solid fa-circle-info"></i> <span> Keep the description clear and concise. This description can be used wherever your frontend menu component displays menu information. </span> </div> <!-- ================================================= MENU INFORMATION ================================================== --> <div class="md-info-grid"> <div class="md-info"> <span class="md-info-label"> Menu ID </span> <span class="md-info-value"> #<?= (int)$selectedMenu['id'] ?> </span> </div> <div class="md-info"> <span class="md-info-label"> Location </span> <span class="md-info-value"> <?= e( $selectedMenu['location'] ?: 'Not specified' ) ?> </span> </div> <div class="md-info"> <span class="md-info-label"> Slug </span> <span class="md-info-value"> <?= e($selectedMenu['slug']) ?> </span> </div> </div> <!-- ================================================= ACTIONS ================================================== --> <div class="md-form-actions"> <div class="md-last-update"> <?php if (!empty($selectedMenu['updated_at'])): ?> Last updated: <?= e( date( 'd M Y, h:i A', strtotime( (string)$selectedMenu['updated_at'] ) ) ) ?> <?php else: ?> Not updated yet <?php endif; ?> </div> <button type="submit" class="md-save-btn" id="saveButton" > <i class="fa-solid fa-floppy-disk"></i> <span>Save Description</span> </button> </div> </form> </div> <?php else: ?> <div class="md-empty"> <div class="md-empty-icon"> <i class="fa-solid fa-align-left"></i> </div> <h3>Select a menu</h3> <p> Choose a menu from the left side to manage its description. </p> </div> <?php endif; ?> </div> </div> <?php endif; ?> </div> </div> <script> document.addEventListener('DOMContentLoaded', function () { const textarea = document.getElementById('menuDescription'); const counter = document.getElementById('charCounter'); const form = document.getElementById('descriptionForm'); const saveButton = document.getElementById('saveButton'); function updateCounter() { if (!textarea || !counter) { return; } const length = textarea.value.length; counter.textContent = length + ' / 5000'; if (length >= 4800) { counter.style.color = '#dc2626'; } else if (length >= 4500) { counter.style.color = '#d97706'; } else { counter.style.color = '#94a3b8'; } } if (textarea) { textarea.addEventListener('input', updateCounter); updateCounter(); textarea.addEventListener('keydown', function (event) { if ( (event.ctrlKey || event.metaKey) && event.key.toLowerCase() === 's' ) { event.preventDefault(); if (form) { form.requestSubmit(); } } }); } if (form && saveButton) { form.addEventListener('submit', function () { saveButton.disabled = true; saveButton.style.opacity = '0.7'; saveButton.style.cursor = 'wait'; saveButton.innerHTML = ` <i class="fa-solid fa-spinner fa-spin"></i> <span>Saving...</span> `; }); } /* * Auto hide success message */ const successAlert = document.getElementById('successAlert'); if (successAlert) { setTimeout(function () { successAlert.style.transition = 'opacity .3s ease, transform .3s ease'; successAlert.style.opacity = '0'; successAlert.style.transform = 'translateY(-5px)'; setTimeout(function () { successAlert.remove(); }, 350); }, 3500); } }); </script> <?php require_once __DIR__ . '/footer.php'; ?>
Save
Cancel