| <?php
|
| session_start();
|
| if (!isset($_SESSION['admin_logged_in'])) {
|
| header('Location: login.php');
|
| exit;
|
| }
|
| require '../db_connect.php';
|
|
|
| $section = $_GET['section'] ?? 'config';
|
| $valid_sections = ['config', 'stats', 'services', 'founders', 'cases', 'pricing', 'faq', 'solutions', 'goals', 'roadmap', 'bottom_stats', 'about_gallery'];
|
|
|
| if (!in_array($section, $valid_sections)) {
|
| die("Sezione non valida.");
|
| }
|
|
|
|
|
| if (isset($_GET['delete']) && $section !== 'config') {
|
| $id = (int)$_GET['delete'];
|
| $db->prepare("DELETE FROM $section WHERE id = ?")->execute([$id]);
|
| header("Location: manage.php?section=$section");
|
| exit;
|
| }
|
|
|
|
|
| $success = false;
|
| if ($_SERVER['REQUEST_METHOD'] === 'POST') {
|
| if ($section === 'config') {
|
| foreach ($_POST as $k => $v) {
|
| if ($k === 'admin_password' || $k === 'id') continue;
|
| $stmt = $db->prepare("INSERT OR REPLACE INTO config (key_name, value_text) VALUES (?, ?)");
|
| $stmt->execute([$k, $v]);
|
| }
|
|
|
| foreach ($_FILES as $key => $file) {
|
| if ($file['error'] === UPLOAD_ERR_OK) {
|
| $ext = pathinfo($file['name'], PATHINFO_EXTENSION);
|
| $filename = "uploads/" . $key . "_" . time() . "." . $ext;
|
| if (move_uploaded_file($file['tmp_name'], "../" . $filename)) {
|
| $db->prepare("INSERT OR REPLACE INTO config (key_name, value_text) VALUES (?, ?)")->execute([$key, $filename]);
|
| }
|
| }
|
| }
|
| $success = true;
|
| } else {
|
|
|
| $is_edit = isset($_POST['id']);
|
| $fields = [];
|
| $values = [];
|
|
|
|
|
| $expected_fields = [];
|
| if($section=='stats') $expected_fields=['label','value','unit','sort_order'];
|
| if($section=='services') $expected_fields=['title','icon','description','sort_order'];
|
| if($section=='founders') $expected_fields=['name','role','image_path','sort_order'];
|
| if($section=='cases') $expected_fields=['title','stats_text','role_text','tags','image_path','sort_order'];
|
| if($section=='pricing') $expected_fields=['name','price','features','is_recommended','sort_order'];
|
| if($section=='faq') $expected_fields=['question','answer','sort_order'];
|
| if($section=='solutions') $expected_fields=['title','description','sort_order'];
|
| if($section=='goals') $expected_fields=['title','description','sort_order'];
|
| if($section=='roadmap') $expected_fields=['phase','detail','sort_order'];
|
| if($section=='bottom_stats') $expected_fields=['value','label','sort_order'];
|
| if($section=='about_gallery') $expected_fields=['image_path','sort_order'];
|
|
|
| foreach ($expected_fields as $f) {
|
| if (isset($_POST[$f])) {
|
| $fields[] = $f;
|
| $values[] = $_POST[$f];
|
| }
|
| }
|
|
|
|
|
| if (in_array('image_path', $expected_fields) && isset($_FILES['image_path']) && $_FILES['image_path']['error'] === UPLOAD_ERR_OK) {
|
| $ext = pathinfo($_FILES['image_path']['name'], PATHINFO_EXTENSION);
|
| $filename = "uploads/" . $section . "_" . time() . "." . $ext;
|
| if (move_uploaded_file($_FILES['image_path']['tmp_name'], "../" . $filename)) {
|
| if(!in_array('image_path', $fields)) {
|
| $fields[] = 'image_path';
|
| $values[] = $filename;
|
| } else {
|
| $key = array_search('image_path', $fields);
|
| $values[$key] = $filename;
|
| }
|
| }
|
| }
|
|
|
| if ($is_edit) {
|
| $id = $_POST['id'];
|
| $set = [];
|
| foreach ($fields as $index => $field) {
|
| $set[] = "$field = ?";
|
| }
|
| $sql = "UPDATE $section SET " . implode(', ', $set) . " WHERE id = ?";
|
| $values[] = $id;
|
| $db->prepare($sql)->execute($values);
|
| } else {
|
| $placeholders = array_fill(0, count($fields), '?');
|
| $sql = "INSERT INTO $section (" . implode(', ', $fields) . ") VALUES (" . implode(', ', $placeholders) . ")";
|
| $db->prepare($sql)->execute($values);
|
| }
|
| }
|
| if ($section !== 'config') {
|
| header("Location: manage.php?section=$section");
|
| exit;
|
| }
|
| }
|
|
|
|
|
| if ($section === 'config') {
|
| $items = [];
|
| try {
|
| $rows = $db->query("SELECT key_name, value_text FROM config")->fetchAll(PDO::FETCH_KEY_PAIR);
|
| $items = $rows;
|
| } catch (Exception $e) {
|
| die("Errore database config: " . $e->getMessage());
|
| }
|
| } else {
|
| try {
|
| $items = $db->query("SELECT * FROM $section ORDER BY sort_order ASC")->fetchAll();
|
| } catch (Exception $e) {
|
| die("Errore database $section: " . $e->getMessage());
|
| }
|
| }
|
| ?>
|
| <!DOCTYPE html>
|
| <html lang="it">
|
| <head>
|
| <meta charset="UTF-8">
|
| <meta name="viewport" content="width=device-width, initial-scale=1.0">
|
| <title>Gestisci <?php echo ucfirst($section); ?> — OFT Admin</title>
|
| <link href="style.css" rel="stylesheet">
|
| <link href="https://fonts.googleapis.com/css2?family=Manrope:wght@400;600;700;800&family=Inter:wght@400;500;600&display=swap" rel="stylesheet">
|
| </head>
|
| <body>
|
|
|
| <div class="app-layout">
|
| <!-- Sidebar -->
|
| <aside class="sidebar">
|
| <div class="brand">
|
| <span>⚡</span> OFT Admin
|
| </div>
|
|
|
| <nav>
|
| <div class="nav-section">Contenuti</div>
|
| <a href="manage.php?section=config" class="nav-link <?php if($section=='config') echo 'active'; ?>">⚙️ Configurazione</a>
|
| <a href="manage.php?section=solutions" class="nav-link <?php if($section=='solutions') echo 'active'; ?>">💡 Soluzioni</a>
|
| <a href="manage.php?section=goals" class="nav-link <?php if($section=='goals') echo 'active'; ?>">🚀 Obiettivi</a>
|
| <a href="manage.php?section=roadmap" class="nav-link <?php if($section=='roadmap') echo 'active'; ?>">🗺️ Roadmap</a>
|
|
|
| <div class="nav-section">Liste</div>
|
| <a href="manage.php?section=services" class="nav-link <?php if($section=='services') echo 'active'; ?>">🛠️ Servizi</a>
|
| <a href="manage.php?section=cases" class="nav-link <?php if($section=='cases') echo 'active'; ?>">📂 Case Studies</a>
|
| <a href="manage.php?section=founders" class="nav-link <?php if($section=='founders') echo 'active'; ?>">👥 Team</a>
|
| <a href="manage.php?section=about_gallery" class="nav-link <?php if($section=='about_gallery') echo 'active'; ?>">🖼️ Gallery Chi Siamo</a>
|
| <a href="manage.php?section=pricing" class="nav-link <?php if($section=='pricing') echo 'active'; ?>">💎 Pricing</a>
|
| <a href="manage.php?section=faq" class="nav-link <?php if($section=='faq') echo 'active'; ?>">❓ FAQ</a>
|
|
|
| <div class="nav-section">Altro</div>
|
| <a href="manage.php?section=stats" class="nav-link <?php if($section=='stats') echo 'active'; ?>">📊 Statistiche</a>
|
| <a href="manage.php?section=bottom_stats" class="nav-link <?php if($section=='bottom_stats') echo 'active'; ?>">📈 Big Stats</a>
|
| </nav>
|
|
|
| <div style="margin-top:auto">
|
| <a href="index.php?logout=1" class="nav-link" style="color:var(--danger)">🚪 Logout</a>
|
| </div>
|
| </aside>
|
|
|
| <!-- Main Content -->
|
| <main class="main-content">
|
| <div class="page-header">
|
| <div>
|
| <a href="index.php" style="color:var(--muted); font-size:12px; font-weight:700; text-transform:uppercase;">← Dashboard</a>
|
| <h1 style="text-transform:capitalize">Gestisci <?php echo str_replace('_', ' ', $section); ?></h1>
|
| </div>
|
| </div>
|
|
|
| <?php if($section === 'config'): ?>
|
| <?php if($success): ?>
|
| <div style="background:rgba(16,185,129,0.1); color:var(--success); padding:16px; border-radius:8px; margin-bottom:24px; border:1px solid var(--success)">
|
| ✅ Configurazione salvata con successo!
|
| </div>
|
| <?php endif; ?>
|
| <div class="panel" style="padding:32px; max-width:800px">
|
| <form method="POST" enctype="multipart/form-data">
|
| <?php foreach($items as $key => $val): if($key=='admin_password' || $key=='id') continue; ?>
|
| <div class="form-group">
|
| <label><?php echo str_replace('_', ' ', $key); ?></label>
|
| <?php if(strpos($key, 'image') !== false): ?>
|
| <div style="display:flex; align-items:center; gap:12px; margin-bottom:12px; background:var(--bg); padding:10px; border-radius:8px; border:1px solid var(--border)">
|
| <img src="../<?php echo htmlspecialchars($val); ?>" style="height:60px; width:60px; object-fit:cover; border-radius:6px;">
|
| <div style="font-size:13px; color:var(--muted); word-break:break-all"><?php echo htmlspecialchars($val); ?></div>
|
| </div>
|
| <input type="file" name="<?php echo $key; ?>" accept="image/*">
|
| <input type="hidden" name="<?php echo $key; ?>" value="<?php echo htmlspecialchars($val); ?>">
|
| <?php else: ?>
|
| <input type="text" name="<?php echo $key; ?>" value="<?php echo htmlspecialchars($val); ?>">
|
| <?php endif; ?>
|
| </div>
|
| <?php endforeach; ?>
|
| <button type="submit" class="btn">Salva Modifiche</button>
|
| </form>
|
| </div>
|
|
|
| <?php else: ?>
|
| <!-- Add New -->
|
| <div style="margin-bottom:30px">
|
| <details>
|
| <summary class="btn" style="display:inline-flex; list-style:none">
|
| <span>+ Aggiungi Nuovo</span>
|
| </summary>
|
| <div class="panel" style="margin-top:20px; padding:32px; max-width:700px; animation: fadeIn 0.3s ease">
|
| <h3 style="margin-top:0">Nuovo Elemento</h3>
|
| <form method="POST" enctype="multipart/form-data">
|
| <!-- Fields based on section -->
|
| <?php
|
| $fields = [];
|
| if($section=='stats') $fields=['label','value','unit','sort_order'];
|
| if($section=='services') $fields=['title','icon','description','sort_order'];
|
| if($section=='founders') $fields=['name','role','image_path','sort_order'];
|
| if($section=='cases') $fields=['title','stats_text','role_text','tags','image_path','sort_order'];
|
| if($section=='pricing') $fields=['name','price','features','is_recommended','sort_order'];
|
| if($section=='faq') $fields=['question','answer','sort_order'];
|
| if($section=='solutions') $fields=['title','description','sort_order'];
|
| if($section=='goals') $fields=['title','description','sort_order'];
|
| if($section=='roadmap') $fields=['phase','detail','sort_order'];
|
| if($section=='bottom_stats') $fields=['value','label','sort_order'];
|
| if($section=='about_gallery') $fields=['image_path','sort_order'];
|
|
|
| foreach($fields as $f): ?>
|
| <div class="form-group">
|
| <label><?php echo str_replace('_', ' ', $f); ?></label>
|
| <?php if($f == 'description' || $f == 'answer' || $f == 'features'): ?>
|
| <textarea name="<?php echo $f; ?>" rows="4"></textarea>
|
| <?php elseif($f == 'image_path'): ?>
|
| <input type="file" name="<?php echo $f; ?>" accept="image/*">
|
| <?php else: ?>
|
| <input type="text" name="<?php echo $f; ?>" value="<?php echo ($f=='sort_order')?'0':''; ?>">
|
| <?php endif; ?>
|
| </div>
|
| <?php endforeach; ?>
|
| <button type="submit" class="btn">Aggiungi Elemento</button>
|
| </form>
|
| </div>
|
| </details>
|
| </div>
|
|
|
| <!-- List Panel -->
|
| <div class="panel">
|
| <?php foreach($items as $row): ?>
|
| <div class="list-item">
|
| <?php if(isset($row['image_path'])): ?>
|
| <img src="../<?php echo htmlspecialchars($row['image_path']); ?>" class="item-image">
|
| <?php endif; ?>
|
|
|
| <div class="item-content">
|
| <span class="item-title">
|
| <?php echo htmlspecialchars(reset($row)); // fallback ?>
|
| <?php echo isset($row['title']) ? $row['title'] : (isset($row['name']) ? $row['name'] : (isset($row['label']) ? $row['label'] : (isset($row['question']) ? $row['question'] : ''))); ?>
|
| </span>
|
| <div class="item-meta">
|
| Ordine: <?php echo $row['sort_order']; ?>
|
| </div>
|
| </div>
|
|
|
| <div style="display:flex; gap:10px; align-items:center">
|
| <details>
|
| <summary class="btn btn-outline" style="padding:6px 12px; font-size:12px">Modifica</summary>
|
| <div style="position:fixed; inset:0; background:rgba(0,0,0,0.8); z-index:999; display:flex; align-items:center; justify-content:center; padding:20px">
|
| <div class="panel" style="width:100%; max-width:600px; padding:32px; position:relative; max-height:90vh; overflow-y:auto">
|
| <div style="position:absolute; top:20px; right:20px; cursor:pointer" onclick="this.closest('details').removeAttribute('open')">✕</div>
|
| <h3 style="margin-top:0">Modifica Elemento</h3>
|
|
|
| <form method="POST" enctype="multipart/form-data">
|
| <input type="hidden" name="id" value="<?php echo $row['id']; ?>">
|
| <?php foreach($fields as $f): ?>
|
| <div class="form-group">
|
| <label><?php echo str_replace('_', ' ', $f); ?></label>
|
|
|
| <?php if($f == 'description' || $f == 'answer' || $f == 'features'): ?>
|
| <textarea name="<?php echo $f; ?>" rows="4"><?php echo htmlspecialchars($row[$f]); ?></textarea>
|
|
|
| <?php elseif($f == 'image_path'): ?>
|
| <div style="display:flex; align-items:center; gap:12px; margin-bottom:10px">
|
| <img src="../<?php echo htmlspecialchars($row[$f]); ?>" style="height:40px; border-radius:4px">
|
| </div>
|
| <input type="file" name="<?php echo $f; ?>" accept="image/*">
|
|
|
| <?php else: ?>
|
| <input type="text" name="<?php echo $f; ?>" value="<?php echo htmlspecialchars($row[$f]); ?>">
|
| <?php endif; ?>
|
| </div>
|
| <?php endforeach; ?>
|
| <button type="submit" class="btn">Salva Modifiche</button>
|
| </form>
|
| </div>
|
| </div>
|
| </details>
|
|
|
| <a href="?section=<?php echo $section; ?>&delete=<?php echo $row['id']; ?>" class="btn-danger" style="padding:8px 12px; border-radius:6px; font-size:12px; text-decoration:none" onclick="return confirm('Sicuro di voler eliminare?')">Elimina</a>
|
| </div>
|
| </div>
|
| <?php endforeach; ?>
|
|
|
| <?php if(empty($items)): ?>
|
| <div style="padding:40px; text-align:center; color:var(--muted)">
|
| Nessun elemento presente.
|
| </div>
|
| <?php endif; ?>
|
| </div>
|
| <?php endif; ?>
|
| </main>
|
| </div>
|
|
|
| </body>
|
| </html>
|
| |
