{
  "═════ 1. БАЗА ДАННЫХ (УНИВЕРСАЛЬНАЯ) ═════": {
    "prefix": "db-skeleton",
    "body": [
      "-- ========== УНИВЕРСАЛЬНАЯ БД ДЛЯ ЭКЗАМЕНА ==========",
      "-- CREATE DATABASE exam_db;",
      "-- USE exam_db;",
      "",
      "-- 1. Таблица пользователей",
      "CREATE TABLE users (",
      "    id INT AUTO_INCREMENT PRIMARY KEY,",
      "    login VARCHAR(50) UNIQUE NOT NULL,",
      "    full_name VARCHAR(150) NOT NULL,",
      "    email VARCHAR(100) UNIQUE NOT NULL,",
      "    phone VARCHAR(20) NOT NULL,",
      "    address TEXT,",
      "    password VARCHAR(255) NOT NULL,",
      "    role ENUM('user', 'admin') DEFAULT 'user',",
      "    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP",
      ");",
      "",
      "-- 2. Таблица товаров/услуг (универсальная)",
      "CREATE TABLE items (",
      "    id INT AUTO_INCREMENT PRIMARY KEY,",
      "    name VARCHAR(200) NOT NULL,",
      "    description TEXT,",
      "    price DECIMAL(10,2) NOT NULL,",
      "    stock INT DEFAULT 0,",
      "    image VARCHAR(255),",
      "    category VARCHAR(100),",
      "    size VARCHAR(50),",
      "    color VARCHAR(50),",
      "    is_active BOOLEAN DEFAULT TRUE",
      ");",
      "",
      "-- 3. Таблица заказов/бронирований (универсальная)",
      "CREATE TABLE orders (",
      "    id INT AUTO_INCREMENT PRIMARY KEY,",
      "    user_id INT NOT NULL,",
      "    order_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,",
      "    total_amount DECIMAL(10,2) NOT NULL,",
      "    status ENUM('new', 'confirmed', 'processing', 'shipped', 'completed', 'cancelled') DEFAULT 'new',",
      "    delivery_address TEXT,",
      "    delivery_time VARCHAR(100),",
      "    payment_method VARCHAR(50),",
      "    notes TEXT,",
      "    FOREIGN KEY (user_id) REFERENCES users(id)",
      ");",
      "",
      "-- 4. Таблица позиций заказа",
      "CREATE TABLE order_items (",
      "    id INT AUTO_INCREMENT PRIMARY KEY,",
      "    order_id INT NOT NULL,",
      "    item_id INT NOT NULL,",
      "    quantity INT DEFAULT 1,",
      "    price DECIMAL(10,2) NOT NULL,",
      "    FOREIGN KEY (order_id) REFERENCES orders(id),",
      "    FOREIGN KEY (item_id) REFERENCES items(id)",
      ");",
      "",
      "-- 5. Таблица отзывов",
      "CREATE TABLE reviews (",
      "    id INT AUTO_INCREMENT PRIMARY KEY,",
      "    user_id INT NOT NULL,",
      "    item_id INT NOT NULL,",
      "    rating INT CHECK (rating BETWEEN 1 AND 5),",
      "    comment TEXT,",
      "    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,",
      "    FOREIGN KEY (user_id) REFERENCES users(id),",
      "    FOREIGN KEY (item_id) REFERENCES items(id)",
      ");",
      "",
      "-- ========== ТЕСТОВЫЕ ДАННЫЕ ==========",
      "-- Админ (пароль: admin123, логин: admin)",
      "-- INSERT INTO users (login, full_name, email, phone, password, role) VALUES",
      "-- ('admin', 'Администратор', 'admin@exam.ru', '+7(999)-000-00-00', MD5('admin123'), 'admin');",
      "",
      "-- Тестовые товары",
      "-- INSERT INTO items (name, description, price, stock, category) VALUES",
      "-- ('Товар 1', 'Описание товара 1', 1000.00, 10, 'Категория 1'),",
      "-- ('Товар 2', 'Описание товара 2', 2000.00, 5, 'Категория 1');"
    ],
    "description": "Универсальная структура БД (5 таблиц)"
  },

  "═════ 2. config.php (ПОДКЛЮЧЕНИЕ К БД + СЕССИИ) ═════": {
    "prefix": "config-skeleton",
    "body": [
      "<?php",
      "// ========== CONFIGURATION FILE ==========",
      "session_start();",
      "",
      "// Database connection",
      "define('DB_HOST', 'localhost');",
      "define('DB_NAME', 'exam_db');",
      "define('DB_USER', 'root');",
      "define('DB_PASS', '');",
      "",
      "try {",
      "    \\$pdo = new PDO('mysql:host=' . DB_HOST . ';dbname=' . DB_NAME . ';charset=utf8', DB_USER, DB_PASS);",
      "    \\$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);",
      "    \\$pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);",
      "} catch (PDOException \\$e) {",
      "    die('Ошибка подключения к БД: ' . \\$e->getMessage());",
      "}",
      "",
      "// Helper functions",
      "function isLoggedIn() {",
      "    return isset(\\$_SESSION['user_id']);",
      "}",
      "",
      "function isAdmin() {",
      "    return isset(\\$_SESSION['role']) && \\$_SESSION['role'] === 'admin';",
      "}",
      "",
      "function redirect(\\$url) {",
      "    header('Location: ' . \\$url);",
      "    exit();",
      "}",
      "?>"
    ],
    "description": "config.php - подключение к БД и сессии"
  },

  "═════ 3. РЕГИСТРАЦИЯ (с валидацией) ═════": {
    "prefix": "register-skeleton",
    "body": [
      "<?php",
      "require_once 'config.php';",
      "",
      "\\$errors = [];",
      "\\$success = false;",
      "",
      "if (\\$_SERVER['REQUEST_METHOD'] === 'POST') {",
      "    \\$login = trim(\\$_POST['login'] ?? '');",
      "    \\$full_name = trim(\\$_POST['full_name'] ?? '');",
      "    \\$email = trim(\\$_POST['email'] ?? '');",
      "    \\$phone = trim(\\$_POST['phone'] ?? '');",
      "    \\$password = \\$_POST['password'] ?? '';",
      "    \\$confirm = \\$_POST['confirm_password'] ?? '';",
      "",
      "    // Валидация",
      "    if (strlen(\\$login) < 4) \\$errors[] = 'Логин должен быть не менее 4 символов';",
      "    if (!preg_match('/^[а-яА-ЯёЁ\\s]+$/u', \\$full_name)) \\$errors[] = 'ФИО должно содержать только кириллицу и пробелы';",
      "    if (!filter_var(\\$email, FILTER_VALIDATE_EMAIL)) \\$errors[] = 'Некорректный email';",
      "    if (!preg_match('/^\\+7\\(\\d{3}\\)-\\d{3}-\\d{2}-\\d{2}$/', \\$phone)) \\$errors[] = 'Телефон должен быть в формате +7(XXX)-XXX-XX-XX';",
      "    if (strlen(\\$password) < 6) \\$errors[] = 'Пароль должен быть не менее 6 символов';",
      "    if (\\$password !== \\$confirm) \\$errors[] = 'Пароли не совпадают';",
      "",
      "    // Проверка уникальности",
      "    \\$stmt = \\$pdo->prepare('SELECT id FROM users WHERE login = ? OR email = ?');",
      "    \\$stmt->execute([\\$login, \\$email]);",
      "    if (\\$stmt->fetch()) \\$errors[] = 'Логин или email уже занят';",
      "",
      "    if (empty(\\$errors)) {",
      "        \\$hashed = password_hash(\\$password, PASSWORD_DEFAULT);",
      "        \\$stmt = \\$pdo->prepare('INSERT INTO users (login, full_name, email, phone, password) VALUES (?, ?, ?, ?, ?)');",
      "        \\$stmt->execute([\\$login, \\$full_name, \\$email, \\$phone, \\$hashed]);",
      "        \\$success = true;",
      "        \\$_SESSION['message'] = 'Регистрация успешна! Теперь войдите.';",
      "        header('Location: login.php');",
      "        exit();",
      "    }",
      "}",
      "?>",
      "<!DOCTYPE html>",
      "<html lang='ru'>",
      "<head>",
      "    <meta charset='UTF-8'>",
      "    <meta name='viewport' content='width=device-width, initial-scale=1'>",
      "    <title>Регистрация</title>",
      "    <link href='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css' rel='stylesheet'>",
      "    <style>",
      "        body { background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); min-height: 100vh; }",
      "        .card { animation: fadeIn 0.5s ease; }",
      "        @keyframes fadeIn { from { opacity: 0; transform: translateY(-20px); } to { opacity: 1; transform: translateY(0); } }",
      "    </style>",
      "</head>",
      "<body>",
      "    <div class='container mt-5'>",
      "        <div class='row justify-content-center'>",
      "            <div class='col-md-6'>",
      "                <div class='card shadow'>",
      "                    <div class='card-header bg-primary text-white text-center'>",
      "                        <h3>Регистрация</h3>",
      "                    </div>",
      "                    <div class='card-body'>",
      "                        <?php if (!empty(\\$errors)): ?>",
      "                            <div class='alert alert-danger'>",
      "                                <?php foreach (\\$errors as \\$error): ?>",
      "                                    <p class='mb-0'>• <?php echo \\$error; ?></p>",
      "                                <?php endforeach; ?>",
      "                            </div>",
      "                        <?php endif; ?>",
      "                        <form method='POST'>",
      "                            <div class='mb-3'>",
      "                                <label>Логин (мин. 4 символа)</label>",
      "                                <input type='text' name='login' class='form-control' required value='<?php echo \\$login ?? ''; ?>'>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>ФИО (кириллица)</label>",
      "                                <input type='text' name='full_name' class='form-control' required value='<?php echo \\$full_name ?? ''; ?>'>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>Email</label>",
      "                                <input type='email' name='email' class='form-control' required value='<?php echo \\$email ?? ''; ?>'>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>Телефон (формат: +7(XXX)-XXX-XX-XX)</label>",
      "                                <input type='tel' name='phone' class='form-control' placeholder='+7(999)-000-00-00' required value='<?php echo \\$phone ?? ''; ?>'>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>Пароль (мин. 6 символов)</label>",
      "                                <input type='password' name='password' class='form-control' required>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>Подтверждение пароля</label>",
      "                                <input type='password' name='confirm_password' class='form-control' required>",
      "                            </div>",
      "                            <button type='submit' class='btn btn-primary w-100'>Зарегистрироваться</button>",
      "                        </form>",
      "                        <div class='text-center mt-3'>",
      "                            <a href='login.php'>Уже есть аккаунт? Войти</a>",
      "                        </div>",
      "                    </div>",
      "                </div>",
      "            </div>",
      "        </div>",
      "    </div>",
      "    <script src='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js'></script>",
      "</body>",
      "</html>"
    ],
    "description": "Страница регистрации с полной валидацией"
  },

  "═════ 4. АВТОРИЗАЦИЯ ═════": {
    "prefix": "login-skeleton",
    "body": [
      "<?php",
      "require_once 'config.php';",
      "",
      "if (isLoggedIn()) {",
      "    redirect('index.php');",
      "}",
      "",
      "\\$error = '';",
      "",
      "if (\\$_SERVER['REQUEST_METHOD'] === 'POST') {",
      "    \\$login = trim(\\$_POST['login'] ?? '');",
      "    \\$password = \\$_POST['password'] ?? '';",
      "",
      "    \\$stmt = \\$pdo->prepare('SELECT * FROM users WHERE login = ? OR email = ?');",
      "    \\$stmt->execute([\\$login, \\$login]);",
      "    \\$user = \\$stmt->fetch();",
      "",
      "    if (\\$user && password_verify(\\$password, \\$user['password'])) {",
      "        \\$_SESSION['user_id'] = \\$user['id'];",
      "        \\$_SESSION['username'] = \\$user['login'];",
      "        \\$_SESSION['full_name'] = \\$user['full_name'];",
      "        \\$_SESSION['role'] = \\$user['role'];",
      "        \\$_SESSION['message'] = 'Добро пожаловать, ' . \\$user['full_name'] . '!';",
      "",
      "        if (\\$user['role'] === 'admin') {",
      "            redirect('admin.php');",
      "        } else {",
      "            redirect('index.php');",
      "        }",
      "    } else {",
      "        \\$error = 'Неверный логин или пароль';",
      "    }",
      "}",
      "?>",
      "<!DOCTYPE html>",
      "<html lang='ru'>",
      "<head>",
      "    <meta charset='UTF-8'>",
      "    <meta name='viewport' content='width=device-width, initial-scale=1'>",
      "    <title>Авторизация</title>",
      "    <link href='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css' rel='stylesheet'>",
      "    <style>",
      "        body { background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); min-height: 100vh; }",
      "        .card { animation: slideIn 0.5s ease; }",
      "        @keyframes slideIn { from { opacity: 0; transform: translateY(30px); } to { opacity: 1; transform: translateY(0); } }",
      "    </style>",
      "</head>",
      "<body>",
      "    <div class='container mt-5'>",
      "        <div class='row justify-content-center'>",
      "            <div class='col-md-5'>",
      "                <div class='card shadow'>",
      "                    <div class='card-header bg-success text-white text-center'>",
      "                        <h3>Вход в систему</h3>",
      "                    </div>",
      "                    <div class='card-body'>",
      "                        <?php if (\\$error): ?>",
      "                            <div class='alert alert-danger'><?php echo \\$error; ?></div>",
      "                        <?php endif; ?>",
      "                        <?php if (isset(\\$_SESSION['message'])): ?>",
      "                            <div class='alert alert-success'><?php echo \\$_SESSION['message']; unset(\\$_SESSION['message']); ?></div>",
      "                        <?php endif; ?>",
      "                        <form method='POST'>",
      "                            <div class='mb-3'>",
      "                                <label>Логин или Email</label>",
      "                                <input type='text' name='login' class='form-control' required autofocus>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>Пароль</label>",
      "                                <input type='password' name='password' class='form-control' required>",
      "                            </div>",
      "                            <button type='submit' class='btn btn-success w-100'>Войти</button>",
      "                        </form>",
      "                        <div class='text-center mt-3'>",
      "                            <a href='register.php'>Нет аккаунта? Зарегистрируйтесь</a>",
      "                        </div>",
      "                    </div>",
      "                </div>",
      "            </div>",
      "        </div>",
      "    </div>",
      "    <script src='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js'></script>",
      "</body>",
      "</html>"
    ],
    "description": "Страница авторизации с сообщениями об ошибках"
  },

  "═════ 5. КАТАЛОГ (с фильтрами и анимацией) ═════": {
    "prefix": "catalog-skeleton",
    "body": [
      "<?php",
      "require_once 'config.php';",
      "",
      "// Фильтрация",
      "\\$where = 'WHERE is_active = 1';",
      "\\$params = [];",
      "",
      "if (isset(\\$_GET['category']) && !empty(\\$_GET['category'])) {",
      "    \\$where .= ' AND category = ?';",
      "    \\$params[] = \\$_GET['category'];",
      "}",
      "",
      "if (isset(\\$_GET['search']) && !empty(\\$_GET['search'])) {",
      "    \\$where .= ' AND name LIKE ?';",
      "    \\$params[] = '%' . \\$_GET['search'] . '%';",
      "}",
      "",
      "\\$stmt = \\$pdo->prepare('SELECT * FROM items ' . \\$where . ' ORDER BY id DESC');",
      "\\$stmt->execute(\\$params);",
      "\\$items = \\$stmt->fetchAll();",
      "",
      "// Получение категорий для фильтра",
      "\\$categories = \\$pdo->query('SELECT DISTINCT category FROM items WHERE category IS NOT NULL')->fetchAll();",
      "?>",
      "<!DOCTYPE html>",
      "<html lang='ru'>",
      "<head>",
      "    <meta charset='UTF-8'>",
      "    <meta name='viewport' content='width=device-width, initial-scale=1'>",
      "    <title>Каталог</title>",
      "    <link href='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css' rel='stylesheet'>",
      "    <link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css'>",
      "    <style>",
      "        .navbar { background: #2c3e50 !important; }",
      "        .card { transition: transform 0.3s, box-shadow 0.3s; margin-bottom: 20px; }",
      "        .card:hover { transform: translateY(-10px); box-shadow: 0 10px 20px rgba(0,0,0,0.2); }",
      "        .card-img-top { height: 200px; object-fit: cover; }",
      "        .cart-badge { position: fixed; bottom: 20px; right: 20px; z-index: 1000; }",
      "        .fade-in { animation: fadeIn 0.5s ease; }",
      "        @keyframes fadeIn { from { opacity: 0; } to { opacity: 1; } }",
      "        .price { font-size: 1.5rem; color: #e67e22; font-weight: bold; }",
      "    </style>",
      "</head>",
      "<body>",
      "    <nav class='navbar navbar-expand-lg navbar-dark'>",
      "        <div class='container'>",
      "            <a class='navbar-brand' href='index.php'><i class='fas fa-store'></i> Мой Магазин</a>",
      "            <div class='navbar-nav ms-auto'>",
      "                <?php if (isLoggedIn()): ?>",
      "                    <span class='nav-link text-light'>Привет, <?php echo htmlspecialchars(\\$_SESSION['full_name']); ?>!</span>",
      "                    <a class='nav-link' href='cart.php'><i class='fas fa-shopping-cart'></i> Корзина</a>",
      "                    <a class='nav-link' href='orders.php'>Мои заказы</a>",
      "                    <?php if (isAdmin()): ?>",
      "                        <a class='nav-link text-warning' href='admin.php'><i class='fas fa-user-shield'></i> Админ</a>",
      "                    <?php endif; ?>",
      "                    <a class='nav-link' href='logout.php'>Выход</a>",
      "                <?php else: ?>",
      "                    <a class='nav-link' href='login.php'>Вход</a>",
      "                    <a class='nav-link' href='register.php'>Регистрация</a>",
      "                <?php endif; ?>",
      "            </div>",
      "        </div>",
      "    </nav>",
      "",
      "    <div class='container mt-4'>",
      "        <div class='row'>",
      "            <!-- Sidebar с фильтрами -->",
      "            <div class='col-md-3'>",
      "                <div class='card'>",
      "                    <div class='card-header bg-primary text-white'>",
      "                        <h5><i class='fas fa-filter'></i> Фильтры</h5>",
      "                    </div>",
      "                    <div class='card-body'>",
      "                        <form method='GET'>",
      "                            <div class='mb-3'>",
      "                                <label>Поиск</label>",
      "                                <input type='text' name='search' class='form-control' placeholder='Название...' value='<?php echo \\$_GET['search'] ?? ''; ?>'>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>Категория</label>",
      "                                <select name='category' class='form-select'>",
      "                                    <option value=''>Все</option>",
      "                                    <?php foreach (\\$categories as \\$cat): ?>",
      "                                        <option value='<?php echo \\$cat['category']; ?>' <?php echo (isset(\\$_GET['category']) && \\$_GET['category'] == \\$cat['category']) ? 'selected' : ''; ?>>",
      "                                            <?php echo \\$cat['category']; ?>",
      "                                        </option>",
      "                                    <?php endforeach; ?>",
      "                                </select>",
      "                            </div>",
      "                            <button type='submit' class='btn btn-primary w-100'><i class='fas fa-search'></i> Применить</button>",
      "                        </form>",
      "                    </div>",
      "                </div>",
      "            </div>",
      "",
      "            <!-- Каталог товаров -->",
      "            <div class='col-md-9'>",
      "                <h1 class='mb-4 fade-in'>Наш каталог</h1>",
      "                <div class='row'>",
      "                    <?php if (empty(\\$items)): ?>",
      "                        <div class='alert alert-info'>Товары не найдены</div>",
      "                    <?php else: ?>",
      "                        <?php foreach (\\$items as \\$item): ?>",
      "                            <div class='col-md-4 fade-in'>",
      "                                <div class='card h-100'>",
      "                                    <img src='images/<?php echo \\$item['image'] ?? 'placeholder.jpg'; ?>' class='card-img-top' alt='<?php echo \\$item['name']; ?>'>",
      "                                    <div class='card-body'>",
      "                                        <h5 class='card-title'><?php echo htmlspecialchars(\\$item['name']); ?></h5>",
      "                                        <p class='card-text'><?php echo mb_substr(htmlspecialchars(\\$item['description']), 0, 100); ?>...</p>",
      "                                        <p class='price'><?php echo number_format(\\$item['price'], 2); ?> ₽</p>",
      "                                        <p class='text-muted'>В наличии: <?php echo \\$item['stock']; ?></p>",
      "                                        <?php if (isLoggedIn()): ?>",
      "                                            <form action='add_to_cart.php' method='POST'>",
      "                                                <input type='hidden' name='item_id' value='<?php echo \\$item['id']; ?>'>",
      "                                                <div class='input-group'>",
      "                                                    <input type='number' name='quantity' value='1' min='1' max='<?php echo \\$item['stock']; ?>' class='form-control' style='width: 70px;'>",
      "                                                    <button type='submit' class='btn btn-primary'><i class='fas fa-cart-plus'></i> В корзину</button>",
      "                                                </div>",
      "                                            </form>",
      "                                        <?php else: ?>",
      "                                            <a href='login.php' class='btn btn-secondary'>Войдите для покупки</a>",
      "                                        <?php endif; ?>",
      "                                    </div>",
      "                                </div>",
      "                            </div>",
      "                        <?php endforeach; ?>",
      "                    <?php endif; ?>",
      "                </div>",
      "            </div>",
      "        </div>",
      "    </div>",
      "",
      "    <script src='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js'></script>",
      "</body>",
      "</html>"
    ],
    "description": "Каталог с фильтрацией по категориям и поиском"
  },

  "═════ 6. КОРЗИНА / БРОНИРОВАНИЕ ═════": {
    "prefix": "cart-skeleton",
    "body": [
      "<?php",
      "require_once 'config.php';",
      "",
      "if (!isLoggedIn()) {",
      "    redirect('login.php');",
      "}",
      "",
      "// Инициализация корзины в сессии",
      "if (!isset(\\$_SESSION['cart'])) {",
      "    \\$_SESSION['cart'] = [];",
      "}",
      "",
      "// Добавление в корзину",
      "if (isset(\\$_POST['add_to_cart'])) {",
      "    \\$item_id = \\$_POST['item_id'];",
      "    \\$quantity = (int)\\$_POST['quantity'];",
      "",
      "    if (isset(\\$_SESSION['cart'][\\$item_id])) {",
      "        \\$_SESSION['cart'][\\$item_id] += \\$quantity;",
      "    } else {",
      "        \\$_SESSION['cart'][\\$item_id] = \\$quantity;",
      "    }",
      "    redirect('cart.php');",
      "}",
      "",
      "// Обновление корзины",
      "if (isset(\\$_POST['update_cart'])) {",
      "    foreach (\\$_POST['quantity'] as \\$id => \\$qty) {",
      "        if (\\$qty <= 0) {",
      "            unset(\\$_SESSION['cart'][\\$id]);",
      "        } else {",
      "            \\$_SESSION['cart'][\\$id'] = (int)\\$qty;",
      "        }",
      "    }",
      "    redirect('cart.php');",
      "}",
      "",
      "// Удаление из корзины",
      "if (isset(\\$_GET['remove'])) {",
      "    unset(\\$_SESSION['cart'][\\$_GET['remove']]);",
      "    redirect('cart.php');",
      "}",
      "",
      "// Получение данных о товарах в корзине",
      "\\$cart_items = [];",
      "\\$total = 0;",
      "",
      "if (!empty(\\$_SESSION['cart'])) {",
      "    \\$ids = array_keys(\\$_SESSION['cart']);",
      "    \\$placeholders = implode(',', array_fill(0, count(\\$ids), '?'));",
      "    \\$stmt = \\$pdo->prepare('SELECT * FROM items WHERE id IN (' . \\$placeholders . ')');",
      "    \\$stmt->execute(\\$ids);",
      "    \\$products = \\$stmt->fetchAll();",
      "",
      "    foreach (\\$products as \\$product) {",
      "        \\$qty = \\$_SESSION['cart'][\\$product['id']];",
      "        \\$subtotal = \\$product['price'] * \\$qty;",
      "        \\$cart_items[] = [",
      "            'product' => \\$product,",
      "            'quantity' => \\$qty,",
      "            'subtotal' => \\$subtotal",
      "        ];",
      "        \\$total += \\$subtotal;",
      "    }",
      "}",
      "?>",
      "<!DOCTYPE html>",
      "<html lang='ru'>",
      "<head>",
      "    <meta charset='UTF-8'>",
      "    <meta name='viewport' content='width=device-width, initial-scale=1'>",
      "    <title>Корзина</title>",
      "    <link href='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css' rel='stylesheet'>",
      "    <link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css'>",
      "    <style>",
      "        .table img { width: 80px; height: 80px; object-fit: cover; }",
      "        .quantity-input { width: 80px; text-align: center; }",
      "        .total { font-size: 1.5rem; font-weight: bold; }",
      "        .checkout-btn { background: #28a745; color: white; padding: 12px 30px; font-size: 1.2rem; }",
      "    </style>",
      "</head>",
      "<body>",
      "    <div class='container mt-4'>",
      "        <h1><i class='fas fa-shopping-cart'></i> Моя корзина</h1>",
      "        <a href='catalog.php' class='btn btn-secondary mb-3'><i class='fas fa-arrow-left'></i> Продолжить покупки</a>",
      "",
      "        <?php if (empty(\\$cart_items)): ?>",
      "            <div class='alert alert-info'>Корзина пуста</div>",
      "        <?php else: ?>",
      "            <form method='POST'>",
      "                <div class='table-responsive'>",
      "                    <table class='table table-bordered'>",
      "                        <thead class='table-dark'>",
      "                            <tr><th>Товар</th><th>Цена</th><th>Кол-во</th><th>Сумма</th><th></th></tr>",
      "                        </thead>",
      "                        <tbody>",
      "                            <?php foreach (\\$cart_items as \\$item): ?>",
      "                                <tr>",
      "                                    <td>",
      "                                        <img src='images/<?php echo \\$item['product']['image'] ?? 'placeholder.jpg'; ?>' alt=''>",
      "                                        <?php echo htmlspecialchars(\\$item['product']['name']); ?>",
      "                                    </td>",
      "                                    <td><?php echo number_format(\\$item['product']['price'], 2); ?> ₽</td>",
      "                                    <td><input type='number' name='quantity[<?php echo \\$item['product']['id']; ?>]' value='<?php echo \\$item['quantity']; ?>' min='0' class='form-control quantity-input'></td>",
      "                                    <td><?php echo number_format(\\$item['subtotal'], 2); ?> ₽</td>",
      "                                    <td><a href='?remove=<?php echo \\$item['product']['id']; ?>' class='btn btn-sm btn-danger'><i class='fas fa-trash'></i></a></td>",
      "                                </tr>",
      "                            <?php endforeach; ?>",
      "                            <tr class='table-info'>",
      "                                <td colspan='3' class='text-end'><strong>Итого:</strong></td>",
      "                                <td colspan='2'><span class='total'><?php echo number_format(\\$total, 2); ?> ₽</span></td>",
      "                            </table>",
      "                        </tbody>",
      "                    </table>",
      "                </div>",
      "                <button type='submit' name='update_cart' class='btn btn-warning'><i class='fas fa-sync-alt'></i> Обновить корзину</button>",
      "                <a href='checkout.php' class='btn checkout-btn float-end'><i class='fas fa-check-circle'></i> Оформить заказ</a>",
      "            </form>",
      "        <?php endif; ?>",
      "    </div>",
      "    <script src='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js'></script>",
      "</body>",
      "</html>"
    ],
    "description": "Корзина с количеством и удалением"
  },

  "═════ 7. ОФОРМЛЕНИЕ ЗАКАЗА ═════": {
    "prefix": "checkout-skeleton",
    "body": [
      "<?php",
      "require_once 'config.php';",
      "",
      "if (!isLoggedIn()) {",
      "    redirect('login.php');",
      "}",
      "",
      "if (empty(\\$_SESSION['cart'])) {",
      "    redirect('catalog.php');",
      "}",
      "",
      "if (\\$_SERVER['REQUEST_METHOD'] === 'POST') {",
      "    \\$address = trim(\\$_POST['address']);",
      "    \\$delivery_time = \\$_POST['delivery_time'] ?? null;",
      "    \\$payment_method = \\$_POST['payment_method'] ?? 'cash';",
      "    \\$notes = trim(\\$_POST['notes'] ?? '');",
      "",
      "    // Расчет общей суммы",
      "    \\$total = 0;",
      "    \\$items_data = [];",
      "    \\$ids = array_keys(\\$_SESSION['cart']);",
      "    \\$placeholders = implode(',', array_fill(0, count(\\$ids), '?'));",
      "    \\$stmt = \\$pdo->prepare('SELECT * FROM items WHERE id IN (' . \\$placeholders . ')');",
      "    \\$stmt->execute(\\$ids);",
      "    \\$products = \\$stmt->fetchAll();",
      "",
      "    foreach (\\$products as \\$product) {",
      "        \\$qty = \\$_SESSION['cart'][\\$product['id']];",
      "        \\$subtotal = \\$product['price'] * \\$qty;",
      "        \\$total += \\$subtotal;",
      "        \\$items_data[] = [",
      "            'id' => \\$product['id'],",
      "            'quantity' => \\$qty,",
      "            'price' => \\$product['price']",
      "        ];",
      "    }",
      "",
      "    // Сохранение заказа",
      "    \\$pdo->beginTransaction();",
      "    try {",
      "        \\$stmt = \\$pdo->prepare('INSERT INTO orders (user_id, total_amount, status, delivery_address, delivery_time, payment_method, notes) VALUES (?, ?, ?, ?, ?, ?, ?)');",
      "        \\$stmt->execute([\\$_SESSION['user_id'], \\$total, 'new', \\$address, \\$delivery_time, \\$payment_method, \\$notes]);",
      "        \\$order_id = \\$pdo->lastInsertId();",
      "",
      "        foreach (\\$items_data as \\$item) {",
      "            \\$stmt = \\$pdo->prepare('INSERT INTO order_items (order_id, item_id, quantity, price) VALUES (?, ?, ?, ?)');",
      "            \\$stmt->execute([\\$order_id, \\$item['id'], \\$item['quantity'], \\$item['price']]);",
      "",
      "            // Уменьшение остатка на складе",
      "            \\$pdo->prepare('UPDATE items SET stock = stock - ? WHERE id = ?')->execute([\\$item['quantity'], \\$item['id']]);",
      "        }",
      "",
      "        \\$pdo->commit();",
      "        \\$_SESSION['cart'] = [];",
      "        \\$_SESSION['message'] = 'Заказ №' . \\$order_id . ' успешно оформлен!';",
      "        redirect('orders.php');",
      "    } catch (Exception \\$e) {",
      "        \\$pdo->rollBack();",
      "        \\$error = 'Ошибка при оформлении заказа: ' . \\$e->getMessage();",
      "    }",
      "}",
      "?>",
      "<!DOCTYPE html>",
      "<html lang='ru'>",
      "<head>",
      "    <meta charset='UTF-8'>",
      "    <meta name='viewport' content='width=device-width, initial-scale=1'>",
      "    <title>Оформление заказа</title>",
      "    <link href='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css' rel='stylesheet'>",
      "    <link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css'>",
      "</head>",
      "<body>",
      "    <div class='container mt-4'>",
      "        <h1><i class='fas fa-clipboard-list'></i> Оформление заказа</h1>",
      "        <div class='row'>",
      "            <div class='col-md-6'>",
      "                <div class='card'>",
      "                    <div class='card-header bg-primary text-white'>",
      "                        <h5>Данные для доставки</h5>",
      "                    </div>",
      "                    <div class='card-body'>",
      "                        <?php if (isset(\\$error)): ?>",
      "                            <div class='alert alert-danger'><?php echo \\$error; ?></div>",
      "                        <?php endif; ?>",
      "                        <form method='POST'>",
      "                            <div class='mb-3'>",
      "                                <label>Адрес доставки *</label>",
      "                                <textarea name='address' class='form-control' rows='3' required></textarea>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>Желаемое время доставки</label>",
      "                                <input type='text' name='delivery_time' class='form-control' placeholder='например, 09:00-18:00'>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>Способ оплаты *</label>",
      "                                <select name='payment_method' class='form-select'>",
      "                                    <option value='cash'>Наличными при получении</option>",
      "                                    <option value='card'>Картой при получении</option>",
      "                                    <option value='online'>Онлайн</option>",
      "                                </select>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>Комментарий к заказу</label>",
      "                                <textarea name='notes' class='form-control' rows='2'></textarea>",
      "                            </div>",
      "                            <button type='submit' class='btn btn-success'><i class='fas fa-check'></i> Подтвердить заказ</button>",
      "                            <a href='cart.php' class='btn btn-secondary'>Назад к корзине</a>",
      "                        </form>",
      "                    </div>",
      "                </div>",
      "            </div>",
      "        </div>",
      "    </div>",
      "    <script src='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js'></script>",
      "</body>",
      "</html>"
    ],
    "description": "Оформление заказа с адресом и оплатой"
  },

  "═════ 8. ПАНЕЛЬ АДМИНИСТРАТОРА (ПОЛНАЯ) ═════": {
  "prefix": "admin-skeleton",
  "body": [
    "<?php",
    "require_once 'config.php';",
    "",
    "if (!isAdmin()) {",
    "    redirect('login.php');",
    "}",
    "",
    "// ========== УПРАВЛЕНИЕ ЗАКАЗАМИ ==========",
    "if (isset(\\$_GET['change_status']) && isset(\\$_GET['status'])) {",
    "    \\$stmt = \\$pdo->prepare('UPDATE orders SET status = ? WHERE id = ?');",
    "    \\$stmt->execute([\\$_GET['status'], \\$_GET['change_status']]);",
    "    redirect('admin.php');",
    "}",
    "",
    "// ========== УПРАВЛЕНИЕ ТОВАРАМИ ==========",
    "// Добавление товара",
    "if (isset(\\$_POST['add_product'])) {",
    "    \\$name = \\$_POST['name'];",
    "    \\$description = \\$_POST['description'];",
    "    \\$price = \\$_POST['price'];",
    "    \\$stock = \\$_POST['stock'];",
    "    \\$category = \\$_POST['category'];",
    "    ",
    "    \\$image_name = null;",
    "    if (isset(\\$_FILES['image']) && \\$_FILES['image']['error'] == 0) {",
    "        \\$image_name = time() . '_' . \\$_FILES['image']['name'];",
    "        \\$upload_dir = 'images/';",
    "        if (!is_dir(\\$upload_dir)) mkdir(\\$upload_dir, 0777, true);",
    "        move_uploaded_file(\\$_FILES['image']['tmp_name'], \\$upload_dir . \\$image_name);",
    "    }",
    "    ",
    "    \\$stmt = \\$pdo->prepare('INSERT INTO items (name, description, price, stock, category, image) VALUES (?, ?, ?, ?, ?, ?)');",
    "    \\$stmt->execute([\\$name, \\$description, \\$price, \\$stock, \\$category, \\$image_name]);",
    "    \\$_SESSION['message'] = 'Товар добавлен!';",
    "    redirect('admin.php');",
    "}",
    "",
    "// Удаление товара",
    "if (isset(\\$_GET['delete_item'])) {",
    "    \\$stmt = \\$pdo->prepare('DELETE FROM items WHERE id = ?');",
    "    \\$stmt->execute([\\$_GET['delete_item']]);",
    "    \\$_SESSION['message'] = 'Товар удален!';",
    "    redirect('admin.php');",
    "}",
    "",
    "// Редактирование товара",
    "if (isset(\\$_POST['edit_product'])) {",
    "    \\$stmt = \\$pdo->prepare('UPDATE items SET name=?, description=?, price=?, stock=?, category=? WHERE id=?');",
    "    \\$stmt->execute([\\$_POST['name'], \\$_POST['description'], \\$_POST['price'], \\$_POST['stock'], \\$_POST['category'], \\$_POST['item_id']]);",
    "    \\$_SESSION['message'] = 'Товар обновлен!';",
    "    redirect('admin.php');",
    "}",
    "",
    "// ========== ПОЛУЧЕНИЕ ДАННЫХ ==========",
    "// Все заказы (всех пользователей)",
    "\\$stmt = \\$pdo->query('",
    "    SELECT o.*, u.full_name, u.email, u.phone ",
    "    FROM orders o ",
    "    JOIN users u ON o.user_id = u.id ",
    "    ORDER BY o.created_at DESC",
    "');",
    "\\$orders = \\$stmt->fetchAll();",
    "",
    "// Все товары",
    "\\$items = \\$pdo->query('SELECT * FROM items ORDER BY id DESC')->fetchAll();",
    "",
    "// Статистика",
    "\\$total_orders = \\$pdo->query('SELECT COUNT(*) FROM orders')->fetchColumn();",
    "\\$total_amount = \\$pdo->query('SELECT SUM(total_amount) FROM orders')->fetchColumn();",
    "\\$total_items = \\$pdo->query('SELECT COUNT(*) FROM items')->fetchColumn();",
    "\\$low_stock = \\$pdo->query('SELECT COUNT(*) FROM items WHERE stock < 5')->fetchColumn();",
    "",
    "\\$active_tab = \\$_GET['tab'] ?? 'orders';",
    "?>",
    "<!DOCTYPE html>",
    "<html lang='ru'>",
    "<head>",
    "    <meta charset='UTF-8'>",
    "    <meta name='viewport' content='width=device-width, initial-scale=1'>",
    "    <title>Панель администратора</title>",
    "    <link href='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css' rel='stylesheet'>",
    "    <link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css'>",
    "    <style>",
    "        .sidebar { background: #2c3e50; min-height: 100vh; }",
    "        .sidebar a { color: white; text-decoration: none; padding: 12px 20px; display: block; transition: 0.3s; }",
    "        .sidebar a:hover, .sidebar a.active { background: #1abc9c; }",
    "        .status-badge { padding: 5px 12px; border-radius: 20px; font-size: 0.75rem; font-weight: bold; }",
    "        .status-new { background: #17a2b8; color: white; }",
    "        .status-confirmed { background: #007bff; color: white; }",
    "        .status-processing { background: #ffc107; color: black; }",
    "        .status-completed { background: #28a745; color: white; }",
    "        .status-cancelled { background: #dc3545; color: white; }",
    "        .stat-card { transition: transform 0.3s; }",
    "        .stat-card:hover { transform: translateY(-5px); }",
    "        .product-img { width: 50px; height: 50px; object-fit: cover; border-radius: 5px; }",
    "    </style>",
    "</head>",
    "<body>",
    "    <div class='container-fluid'>",
    "        <div class='row'>",
    "            <!-- БОКОВАЯ ПАНЕЛЬ -->",
    "            <div class='col-md-2 sidebar p-0'>",
    "                <div class='text-center py-4 bg-dark'>",
    "                    <h4 class='text-white'><i class='fas fa-user-shield'></i> Админ</h4>",
    "                </div>",
    "                <a href='?tab=orders' class='<?php echo \\$active_tab == 'orders' ? 'active' : ''; ?>'>",
    "                    <i class='fas fa-shopping-cart'></i> Заказы",
    "                </a>",
    "                <a href='?tab=products' class='<?php echo \\$active_tab == 'products' ? 'active' : ''; ?>'>",
    "                    <i class='fas fa-boxes'></i> Товары",
    "                </a>",
    "                <a href='?tab=add' class='<?php echo \\$active_tab == 'add' ? 'active' : ''; ?>'>",
    "                    <i class='fas fa-plus-circle'></i> Добавить товар",
    "                </a>",
    "                <hr class='bg-light'>",
    "                <a href='logout.php' class='text-danger'><i class='fas fa-sign-out-alt'></i> Выход</a>",
    "            </div>",
    "",
    "            <!-- ОСНОВНОЕ СОДЕРЖИМОЕ -->",
    "            <div class='col-md-10 p-4'>",
    "                <?php if (isset(\\$_SESSION['message'])): ?>",
    "                    <div class='alert alert-success alert-dismissible fade show'>",
    "                        <?php echo \\$_SESSION['message']; unset(\\$_SESSION['message']); ?>",
    "                        <button type='button' class='btn-close' data-bs-dismiss='alert'></button>",
    "                    </div>",
    "                <?php endif; ?>",
    "",
    "                <!-- СТАТИСТИКА (видны всегда) -->",
    "                <div class='row mb-4'>",
    "                    <div class='col-md-3'>",
    "                        <div class='card stat-card text-white bg-primary'>",
    "                            <div class='card-body'>",
    "                                <h5>Всего заказов</h5>",
    "                                <h2><?php echo \\$total_orders; ?></h2>",
    "                            </div>",
    "                        </div>",
    "                    </div>",
    "                    <div class='col-md-3'>",
    "                        <div class='card stat-card text-white bg-success'>",
    "                            <div class='card-body'>",
    "                                <h5>Выручка</h5>",
    "                                <h2><?php echo number_format(\\$total_amount, 0); ?> ₽</h2>",
    "                            </div>",
    "                        </div>",
    "                    </div>",
    "                    <div class='col-md-3'>",
    "                        <div class='card stat-card text-white bg-info'>",
    "                            <div class='card-body'>",
    "                                <h5>Товаров</h5>",
    "                                <h2><?php echo \\$total_items; ?></h2>",
    "                            </div>",
    "                        </div>",
    "                    </div>",
    "                    <div class='col-md-3'>",
    "                        <div class='card stat-card text-white bg-warning'>",
    "                            <div class='card-body'>",
    "                                <h5>Товаров < 5 шт</h5>",
    "                                <h2><?php echo \\$low_stock; ?></h2>",
    "                            </div>",
    "                        </div>",
    "                    </div>",
    "                </div>",
    "",
    "                <!-- ВКЛАДКА: ЗАКАЗЫ -->",
    "                <?php if (\\$active_tab == 'orders'): ?>",
    "                <div class='card'>",
    "                    <div class='card-header bg-dark text-white'>",
    "                        <h5><i class='fas fa-list'></i> Все заказы клиентов</h5>",
    "                    </div>",
    "                    <div class='card-body'>",
    "                        <div class='table-responsive'>",
    "                            <table class='table table-striped'>",
    "                                <thead>",
    "                                    <tr><th>№</th><th>Клиент</th><th>Контакты</th><th>Сумма</th><th>Статус</th><th>Дата</th><th>Действия</th></tr>",
    "                                </thead>",
    "                                <tbody>",
    "                                    <?php foreach (\\$orders as \\$order): ?>",
    "                                        <tr>",
    "                                            <td><?php echo \\$order['id']; ?></td>",
    "                                            <td><?php echo htmlspecialchars(\\$order['full_name']); ?></td>",
    "                                            <td><?php echo \\$order['email']; ?><br><small><?php echo \\$order['phone']; ?></small></td>",
    "                                            <td><?php echo number_format(\\$order['total_amount'], 2); ?> ₽</td>",
    "                                            <td><span class='status-badge status-<?php echo \\$order['status']; ?>'>",
    "                                                <?php \\$statuses = ['new'=>'Новый','confirmed'=>'Подтвержден','processing'=>'В обработке','completed'=>'Выполнен','cancelled'=>'Отменен']; echo \\$statuses[\\$order['status']]; ?>",
    "                                            </span></td>",
    "                                            <td><?php echo date('d.m.Y H:i', strtotime(\\$order['created_at'])); ?></td>",
    "                                            <td>",
    "                                                <div class='btn-group btn-group-sm'>",
    "                                                    <a href='?change_status=<?php echo \\$order['id']; ?>&status=confirmed' class='btn btn-primary'>Подтвердить</a>",
    "                                                    <a href='?change_status=<?php echo \\$order['id']; ?>&status=processing' class='btn btn-warning'>В работу</a>",
    "                                                    <a href='?change_status=<?php echo \\$order['id']; ?>&status=completed' class='btn btn-success'>Завершить</a>",
    "                                                    <a href='?change_status=<?php echo \\$order['id']; ?>&status=cancelled' class='btn btn-danger'>Отменить</a>",
    "                                                </div>",
    "                                            </td>",
    "                                        </tr>",
    "                                    <?php endforeach; ?>",
    "                                </tbody>",
    "                            </table>",
    "                        </div>",
    "                    </div>",
    "                </div>",
    "                <?php endif; ?>",
    "",
    "                <!-- ВКЛАДКА: ТОВАРЫ (СПИСОК) -->",
    "                <?php if (\\$active_tab == 'products'): ?>",
    "                <div class='card'>",
    "                    <div class='card-header bg-dark text-white d-flex justify-content-between'>",
    "                        <h5><i class='fas fa-boxes'></i> Управление товарами</h5>",
    "                        <a href='?tab=add' class='btn btn-sm btn-success'>+ Добавить товар</a>",
    "                    </div>",
    "                    <div class='card-body'>",
    "                        <div class='table-responsive'>",
    "                            <table class='table table-striped'>",
    "                                <thead>",
    "                                    <tr><th>ID</th><th>Изобр.</th><th>Название</th><th>Категория</th><th>Цена</th><th>Остаток</th><th>Действия</th></tr>",
    "                                </thead>",
    "                                <tbody>",
    "                                    <?php foreach (\\$items as \\$item): ?>",
    "                                        <tr>",
    "                                            <td><?php echo \\$item['id']; ?></td>",
    "                                            <td><img src='images/<?php echo \\$item['image'] ?? 'placeholder.jpg'; ?>' class='product-img'>\n                                            </td>",
    "                                            <td><?php echo htmlspecialchars(\\$item['name']); ?></td>",
    "                                            <td><?php echo \\$item['category'] ?? '-'; ?></td>",
    "                                            <td><?php echo number_format(\\$item['price'], 2); ?> ₽</td>",
    "                                            <td>",
    "                                                <?php if (\\$item['stock'] < 5): ?>",
    "                                                    <span class='text-danger'><strong><?php echo \\$item['stock']; ?></strong></span>",
    "                                                <?php else: ?>",
    "                                                    <?php echo \\$item['stock']; ?>",
    "                                                <?php endif; ?>",
    "                                             </td>",
    "                                            <td>",
    "                                                <button class='btn btn-sm btn-warning' data-bs-toggle='modal' data-bs-target='#editModal'",
    "                                                        data-id='<?php echo \\$item['id']; ?>'",
    "                                                        data-name='<?php echo htmlspecialchars(\\$item['name']); ?>'",
    "                                                        data-desc='<?php echo htmlspecialchars(\\$item['description']); ?>'",
    "                                                        data-price='<?php echo \\$item['price']; ?>'",
    "                                                        data-stock='<?php echo \\$item['stock']; ?>'",
    "                                                        data-cat='<?php echo \\$item['category']; ?>'>",
    "                                                    <i class='fas fa-edit'></i>",
    "                                                </button>",
    "                                                <a href='?delete_item=<?php echo \\$item['id']; ?>' class='btn btn-sm btn-danger' onclick='return confirm(\"Удалить товар?\")'>",
    "                                                    <i class='fas fa-trash'></i>",
    "                                                </a>",
    "                                             </td>",
    "                                         </tr>",
    "                                    <?php endforeach; ?>",
    "                                </tbody>",
    "                            </table>",
    "                        </div>",
    "                    </div>",
    "                </div>",
    "                <?php endif; ?>",
    "",
    "                <!-- ВКЛАДКА: ДОБАВЛЕНИЕ ТОВАРА -->",
    "                <?php if (\\$active_tab == 'add'): ?>",
    "                <div class='card'>",
    "                    <div class='card-header bg-dark text-white'>",
    "                        <h5><i class='fas fa-plus'></i> Добавить новый товар</h5>",
    "                    </div>",
    "                    <div class='card-body'>",
    "                        <form method='POST' enctype='multipart/form-data'>",
    "                            <div class='row'>",
    "                                <div class='col-md-6 mb-3'>",
    "                                    <label>Название товара *</label>",
    "                                    <input type='text' name='name' class='form-control' required>",
    "                                </div>",
    "                                <div class='col-md-6 mb-3'>",
    "                                    <label>Категория</label>",
    "                                    <input type='text' name='category' class='form-control'>",
    "                                </div>",
    "                                <div class='col-md-12 mb-3'>",
    "                                    <label>Описание</label>",
    "                                    <textarea name='description' class='form-control' rows='3'></textarea>",
    "                                </div>",
    "                                <div class='col-md-4 mb-3'>",
    "                                    <label>Цена (₽) *</label>",
    "                                    <input type='number' name='price' step='0.01' class='form-control' required>",
    "                                </div>",
    "                                <div class='col-md-4 mb-3'>",
    "                                    <label>Количество на складе</label>",
    "                                    <input type='number' name='stock' value='0' class='form-control'>",
    "                                </div>",
    "                                <div class='col-md-4 mb-3'>",
    "                                    <label>Изображение</label>",
    "                                    <input type='file' name='image' class='form-control' accept='image/*'>",
    "                                </div>",
    "                                <div class='col-12'>",
    "                                    <button type='submit' name='add_product' class='btn btn-success'><i class='fas fa-save'></i> Сохранить</button>",
    "                                    <a href='?tab=products' class='btn btn-secondary'>Отмена</a>",
    "                                </div>",
    "                            </div>",
    "                        </form>",
    "                    </div>",
    "                </div>",
    "                <?php endif; ?>",
    "            </div>",
    "        </div>",
    "    </div>",
    "",
    "    <!-- МОДАЛЬНОЕ ОКНО РЕДАКТИРОВАНИЯ -->",
    "    <div class='modal fade' id='editModal' tabindex='-1'>",
    "        <div class='modal-dialog'>",
    "            <div class='modal-content'>",
    "                <form method='POST'>",
    "                    <div class='modal-header bg-warning'>",
    "                        <h5 class='modal-title'><i class='fas fa-edit'></i> Редактировать товар</h5>",
    "                        <button type='button' class='btn-close' data-bs-dismiss='modal'></button>",
    "                    </div>",
    "                    <div class='modal-body'>",
    "                        <input type='hidden' name='item_id' id='edit_id'>",
    "                        <div class='mb-2'><label>Название</label><input type='text' name='name' id='edit_name' class='form-control' required></div>",
    "                        <div class='mb-2'><label>Описание</label><textarea name='description' id='edit_desc' class='form-control' rows='2'></textarea></div>",
    "                        <div class='mb-2'><label>Категория</label><input type='text' name='category' id='edit_cat' class='form-control'></div>",
    "                        <div class='row'>",
    "                            <div class='col-6'><label>Цена</label><input type='number' name='price' id='edit_price' step='0.01' class='form-control' required></div>",
    "                            <div class='col-6'><label>Остаток</label><input type='number' name='stock' id='edit_stock' class='form-control'></div>",
    "                        </div>",
    "                    </div>",
    "                    <div class='modal-footer'>",
    "                        <button type='button' class='btn btn-secondary' data-bs-dismiss='modal'>Отмена</button>",
    "                        <button type='submit' name='edit_product' class='btn btn-primary'>Сохранить изменения</button>",
    "                    </div>",
    "                </form>",
    "            </div>",
    "        </div>",
    "    </div>",
    "",
    "    <script src='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js'></script>",
    "    <script>",
    "        const editModal = document.getElementById('editModal');",
    "        editModal.addEventListener('show.bs.modal', function(event) {",
    "            const button = event.relatedTarget;",
    "            document.getElementById('edit_id').value = button.dataset.id;",
    "            document.getElementById('edit_name').value = button.dataset.name;",
    "            document.getElementById('edit_desc').value = button.dataset.desc || '';",
    "            document.getElementById('edit_price').value = button.dataset.price;",
    "            document.getElementById('edit_stock').value = button.dataset.stock;",
    "            document.getElementById('edit_cat').value = button.dataset.cat || '';",
    "        });",
    "    </script>",
    "</body>",
    "</html>"
  ],
  "description": "ПОЛНАЯ админ-панель: заказы всех пользователей + управление товарами"
},

  "═════ 9. СТРАНИЦА ЗАКАЗОВ ПОЛЬЗОВАТЕЛЯ ═════": {
    "prefix": "orders-skeleton",
    "body": [
      "<?php",
      "require_once 'config.php';",
      "",
      "if (!isLoggedIn()) {",
      "    redirect('login.php');",
      "}",
      "",
      "\\$stmt = \\$pdo->prepare('SELECT * FROM orders WHERE user_id = ? ORDER BY created_at DESC');",
      "\\$stmt->execute([\\$_SESSION['user_id']]);",
      "\\$orders = \\$stmt->fetchAll();",
      "?>",
      "<!DOCTYPE html>",
      "<html lang='ru'>",
      "<head>",
      "    <meta charset='UTF-8'>",
      "    <meta name='viewport' content='width=device-width, initial-scale=1'>",
      "    <title>Мои заказы</title>",
      "    <link href='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css' rel='stylesheet'>",
      "    <link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css'>",
      "    <style>",
      "        .status-badge { padding: 5px 10px; border-radius: 20px; font-size: 0.8rem; }",
      "        .status-new { background: #17a2b8; color: white; }",
      "        .status-confirmed { background: #007bff; color: white; }",
      "        .status-processing { background: #ffc107; color: black; }",
      "        .status-completed { background: #28a745; color: white; }",
      "        .status-cancelled { background: #dc3545; color: white; }",
      "    </style>",
      "</head>",
      "<body>",
      "    <div class='container mt-4'>",
      "        <h1><i class='fas fa-box'></i> Мои заказы</h1>",
      "        <a href='catalog.php' class='btn btn-primary mb-3'><i class='fas fa-shopping-cart'></i> Новый заказ</a>",
      "",
      "        <?php if (isset(\\$_SESSION['message'])): ?>",
      "            <div class='alert alert-success'><?php echo \\$_SESSION['message']; unset(\\$_SESSION['message']); ?></div>",
      "        <?php endif; ?>",
      "",
      "        <?php if (empty(\\$orders)): ?>",
      "            <div class='alert alert-info'>У вас пока нет заказов</div>",
      "        <?php else: ?>",
      "            <div class='row'>",
      "                <?php foreach (\\$orders as \\$order): ?>",
      "                    <div class='col-md-6 mb-3'>",
      "                        <div class='card'>",
      "                            <div class='card-header d-flex justify-content-between'>",
      "                                <span><strong>Заказ №<?php echo \\$order['id']; ?></strong></span>",
      "                                <span class='status-badge status-<?php echo \\$order['status']; ?>'>",
      "                                    <?php",
      "                                        \\$statuses = ['new' => 'Новый', 'confirmed' => 'Подтвержден', 'processing' => 'В обработке', 'completed' => 'Завершен', 'cancelled' => 'Отменен'];",
      "                                        echo \\$statuses[\\$order['status']];",
      "                                    ?>",
      "                                </span>",
      "                            </div>",
      "                            <div class='card-body'>",
      "                                <p><strong>Сумма:</strong> <?php echo number_format(\\$order['total_amount'], 2); ?> ₽</p>",
      "                                <p><strong>Адрес:</strong> <?php echo htmlspecialchars(\\$order['delivery_address']); ?></p>",
      "                                <p><strong>Дата:</strong> <?php echo date('d.m.Y H:i', strtotime(\\$order['created_at'])); ?></p>",
      "                                <?php if (!empty(\\$order['notes'])): ?>",
      "                                    <p><strong>Комментарий:</strong> <?php echo htmlspecialchars(\\$order['notes']); ?></p>",
      "                                <?php endif; ?>",
      "                            </div>",
      "                        </div>",
      "                    </div>",
      "                <?php endforeach; ?>",
      "            </div>",
      "        <?php endif; ?>",
      "    </div>",
      "    <script src='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js'></script>",
      "</body>",
      "</html>"
    ],
    "description": "Страница заказов пользователя"
  },

  "═════ 10. add_to_cart.php (обработчик) ═════": {
    "prefix": "add-to-cart",
    "body": [
      "<?php",
      "require_once 'config.php';",
      "",
      "if (!isLoggedIn()) {",
      "    redirect('login.php');",
      "}",
      "",
      "if (!isset(\\$_SESSION['cart'])) {",
      "    \\$_SESSION['cart'] = [];",
      "}",
      "",
      "if (isset(\\$_POST['item_id'])) {",
      "    \\$item_id = (int)\\$_POST['item_id'];",
      "    \\$quantity = (int)(\\$_POST['quantity'] ?? 1);",
      "",
      "    if (isset(\\$_SESSION['cart'][\\$item_id])) {",
      "        \\$_SESSION['cart'][\\$item_id] += \\$quantity;",
      "    } else {",
      "        \\$_SESSION['cart'][\\$item_id] = \\$quantity;",
      "    }",
      "}",
      "",
      "redirect(\\$_SERVER['HTTP_REFERER'] ?? 'catalog.php');",
      "?>"
    ],
    "description": "Обработчик добавления в корзину"
  },

  "═════ 11. logout.php ═════": {
    "prefix": "logout-skeleton",
    "body": [
      "<?php",
      "session_start();",
      "session_destroy();",
      "header('Location: login.php');",
      "exit();",
      "?>"
    ],
    "description": "Выход из системы"
  },
"═════ 12. ГЛАВНАЯ СТРАНИЦА (index.php) ═════": {
  "prefix": "index-skeleton",
  "body": [
    "<?php",
    "require_once 'config.php';",
    "",
    "// Получение популярных товаров (по количеству заказов или просто последние 4)",
    "\\$stmt = \\$pdo->query('SELECT * FROM items WHERE is_active = 1 ORDER BY id DESC LIMIT 4');",
    "\\$popular_items = \\$stmt->fetchAll();",
    "",
    "// Получение категорий для навигации",
    "\\$categories = \\$pdo->query('SELECT DISTINCT category FROM items WHERE category IS NOT NULL LIMIT 6')->fetchAll();",
    "?>",
    "<!DOCTYPE html>",
    "<html lang='ru'>",
    "<head>",
    "    <meta charset='UTF-8'>",
    "    <meta name='viewport' content='width=device-width, initial-scale=1'>",
    "    <title><?php echo \\$site_name ?? 'Мой Магазин'; ?> - Главная</title>",
    "    <link href='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css' rel='stylesheet'>",
    "    <link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css'>",
    "    <style>",
    "        .hero { background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); color: white; padding: 80px 0; text-align: center; }",
    "        .hero h1 { font-size: 3rem; animation: fadeInDown 0.8s ease; }",
    "        .hero p { font-size: 1.2rem; animation: fadeInUp 0.8s ease; }",
    "        .card { transition: transform 0.3s, box-shadow 0.3s; margin-bottom: 20px; }",
    "        .card:hover { transform: translateY(-10px); box-shadow: 0 10px 20px rgba(0,0,0,0.2); }",
    "        .card-img-top { height: 200px; object-fit: cover; }",
    "        .category-link { transition: all 0.3s; display: inline-block; margin: 5px; }",
    "        .category-link:hover { transform: scale(1.05); }",
    "        @keyframes fadeInDown { from { opacity: 0; transform: translateY(-30px); } to { opacity: 1; transform: translateY(0); } }",
    "        @keyframes fadeInUp { from { opacity: 0; transform: translateY(30px); } to { opacity: 1; transform: translateY(0); } }",
    "        .navbar { background: #2c3e50 !important; }",
    "        .search-box { max-width: 400px; margin: 20px auto; }",
    "        .price { font-size: 1.3rem; color: #e67e22; font-weight: bold; }",
    "    </style>",
    "</head>",
    "<body>",
    "    <!-- Navigation -->",
    "    <nav class='navbar navbar-expand-lg navbar-dark'>",
    "        <div class='container'>",
    "            <a class='navbar-brand' href='index.php'><i class='fas fa-store'></i> Мой Магазин</a>",
    "            <button class='navbar-toggler' type='button' data-bs-toggle='collapse' data-bs-target='#navbarNav'>",
    "                <span class='navbar-toggler-icon'></span>",
    "            </button>",
    "            <div class='collapse navbar-collapse' id='navbarNav'>",
    "                <ul class='navbar-nav me-auto'>",
    "                    <li class='nav-item'><a class='nav-link' href='index.php'>Главная</a></li>",
    "                    <li class='nav-item'><a class='nav-link' href='catalog.php'>Каталог</a></li>",
    "                    <?php if (isLoggedIn()): ?>",
    "                        <li class='nav-item'><a class='nav-link' href='cart.php'><i class='fas fa-shopping-cart'></i> Корзина</a></li>",
    "                        <li class='nav-item'><a class='nav-link' href='orders.php'>Мои заказы</a></li>",
    "                        <?php if (isAdmin()): ?>",
    "                            <li class='nav-item'><a class='nav-link text-warning' href='admin.php'><i class='fas fa-user-shield'></i> Админ</a></li>",
    "                        <?php endif; ?>",
    "                        <li class='nav-item'><a class='nav-link' href='logout.php'>Выход</a></li>",
    "                    <?php else: ?>",
    "                        <li class='nav-item'><a class='nav-link' href='login.php'>Вход</a></li>",
    "                        <li class='nav-item'><a class='nav-link' href='register.php'>Регистрация</a></li>",
    "                    <?php endif; ?>",
    "                </ul>",
    "                <form class='d-flex' action='catalog.php' method='GET'>",
    "                    <input class='form-control me-2' type='search' name='search' placeholder='Поиск...' aria-label='Search'>",
    "                    <button class='btn btn-outline-light' type='submit'><i class='fas fa-search'></i></button>",
    "                </form>",
    "            </div>",
    "        </div>",
    "    </nav>",
    "",
    "    <!-- Hero Section -->",
    "    <div class='hero'>",
    "        <div class='container'>",
    "            <h1><i class='fas fa-gem'></i> Добро пожаловать!</h1>",
    "            <p>Лучшие товары по лучшим ценам. Быстрая доставка и отличное качество.</p>",
    "            <a href='catalog.php' class='btn btn-light btn-lg mt-3'>Перейти в каталог →</a>",
    "        </div>",
    "    </div>",
    "",
    "    <div class='container mt-4'>",
    "        <!-- Поиск по сайту (быстрый) -->",
    "        <div class='search-box'>",
    "            <form action='catalog.php' method='GET' class='input-group'>",
    "                <input type='text' name='search' class='form-control' placeholder='Найти товар...'>",
    "                <button class='btn btn-primary' type='submit'><i class='fas fa-search'></i> Найти</button>",
    "            </form>",
    "        </div>",
    "",
    "        <!-- Разделы / Категории -->",
    "        <div class='text-center mb-4'>",
    "            <h3><i class='fas fa-tags'></i> Популярные категории</h3>",
    "            <div>",
    "                <?php foreach (\\$categories as \\$cat): ?>",
    "                    <a href='catalog.php?category=<?php echo urlencode(\\$cat['category']); ?>' class='btn btn-outline-primary category-link'>",
    "                        <?php echo htmlspecialchars(\\$cat['category']); ?>",
    "                    </a>",
    "                <?php endforeach; ?>",
    "                <a href='catalog.php' class='btn btn-outline-secondary category-link'>Все товары</a>",
    "            </div>",
    "        </div>",
    "",
    "        <!-- Популярные товары -->",
    "        <div class='mt-5'>",
    "            <h3 class='text-center mb-4'><i class='fas fa-fire'></i> Популярные товары</h3>",
    "            <div class='row'>",
    "                <?php if (empty(\\$popular_items)): ?>",
    "                    <div class='col-12'><div class='alert alert-info'>Нет товаров для отображения</div></div>",
    "                <?php else: ?>",
    "                    <?php foreach (\\$popular_items as \\$item): ?>",
    "                        <div class='col-md-3'>",
    "                            <div class='card h-100'>",
    "                                <img src='images/<?php echo \\$item['image'] ?? 'placeholder.jpg'; ?>' class='card-img-top' alt='<?php echo \\$item['name']; ?>'>",
    "                                <div class='card-body'>",
    "                                    <h5 class='card-title'><?php echo htmlspecialchars(\\$item['name']); ?></h5>",
    "                                    <p class='card-text'><?php echo mb_substr(htmlspecialchars(\\$item['description']), 0, 80); ?>...</p>",
    "                                    <p class='price'><?php echo number_format(\\$item['price'], 2); ?> ₽</p>",
    "                                    <?php if (isLoggedIn()): ?>",
    "                                        <form action='add_to_cart.php' method='POST'>",
    "                                            <input type='hidden' name='item_id' value='<?php echo \\$item['id']; ?>'>",
    "                                            <button type='submit' class='btn btn-sm btn-primary w-100'><i class='fas fa-cart-plus'></i> В корзину</button>",
    "                                        </form>",
    "                                    <?php else: ?>",
    "                                        <a href='login.php' class='btn btn-sm btn-secondary w-100'>Войдите для покупки</a>",
    "                                    <?php endif; ?>",
    "                                </div>",
    "                            </div>",
    "                        </div>",
    "                    <?php endforeach; ?>",
    "                <?php endif; ?>",
    "            </div>",
    "        </div>",
    "",
    "        <!-- Дополнительный блок: описание магазина -->",
    "        <div class='row mt-5 mb-5 text-center'>",
    "            <div class='col-md-4'>",
    "                <i class='fas fa-truck fa-3x text-primary'></i>",
    "                <h5>Быстрая доставка</h5>",
    "                <p>Доставим за 1-3 дня</p>",
    "            </div>",
    "            <div class='col-md-4'>",
    "                <i class='fas fa-credit-card fa-3x text-success'></i>",
    "                <h5>Удобная оплата</h5>",
    "                <p>Наличными, картой, онлайн</p>",
    "            </div>",
    "            <div class='col-md-4'>",
    "                <i class='fas fa-headset fa-3x text-warning'></i>",
    "                <h5>Поддержка 24/7</h5>",
    "                <p>Всегда на связи</p>",
    "            </div>",
    "        </div>",
    "    </div>",
    "",
    "    <!-- Footer -->",
    "    <footer class='bg-dark text-white text-center py-3 mt-4'>",
    "        <p>&copy; <?php echo date('Y'); ?> Мой Магазин. Все права защищены.</p>",
    "    </footer>",
    "",
    "    <script src='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js'></script>",
    "</body>",
    "</html>"
  ],
  "description": "Главная страница с приветствием, категориями, поиском и популярными товарами"
}
}


{
  "name": "ui-snippets-pack",
  "displayName": "UI Snippets Pack",
  "description": "Ready-made UI snippets for web development",
  "version": "0.0.6",
  "publisher": "tvinnl",
  "engines": {
    "vscode": "^1.0.0"
  },
  "categories": ["Snippets"],
  "contributes": {
    "snippets": [
      {
        "path": "./snippets/snippets.code-snippets"
      }
    ]
  }
}