<?php
session_start();
if (!isset($_SESSION['admin_id'])) {
    header('Location: login.php');
    exit;
}
require_once __DIR__ . '/../../config/db.php';

$database = new Database();
$db = $database->getConnection();

$action = $_GET['action'] ?? 'list';
$id = $_GET['id'] ?? null;
$message = '';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $name = $_POST['name'] ?? '';
    $url = $_POST['url'] ?? '';

    if ($action === 'add') {
        $stmt = $db->prepare("INSERT INTO cdn_links (name, url) VALUES (:name, :url)");
        $stmt->execute([':name' => $name, ':url' => $url]);
        $message = 'CDN link added successfully.';
        $action = 'list';
    } elseif ($action === 'edit' && $id) {
        $stmt = $db->prepare("UPDATE cdn_links SET name = :name, url = :url WHERE id = :id");
        $stmt->execute([':name' => $name, ':url' => $url, ':id' => $id]);
        $message = 'CDN link updated successfully.';
        $action = 'list';
    }
}

if ($action === 'delete' && $id) {
    $stmt = $db->prepare("DELETE FROM cdn_links WHERE id = :id");
    $stmt->execute([':id' => $id]);
    $message = 'CDN link deleted successfully.';
    $action = 'list';
}
?>
<!DOCTYPE html>
<html lang="ru">
<head>
    <meta charset="UTF-8">
    <title>CDN Management - Admin</title>
    <link rel="stylesheet" href="css/admin.css">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css">
</head>
<body>
    <div class="sidebar">
        <div class="sidebar-header">MYRIADONICA</div>
        <a href="index.php" class="nav-item"><i class="fas fa-home"></i> Панель</a>
        <a href="schedule.php" class="nav-item"><i class="fas fa-calendar-alt"></i> Расписание</a>
        <a href="cdn.php" class="nav-item active"><i class="fas fa-server"></i> CDN Серверы</a>
        <a href="info_blocks.php" class="nav-item"><i class="fas fa-info-circle"></i> Инфо-блоки</a>
        <a href="settings.php" class="nav-item"><i class="fas fa-cog"></i> Настройки</a>
        <a href="telegram.php" class="nav-item"><i class="fab fa-telegram"></i> Телеграм</a>
        <a href="database.php" class="nav-item"><i class="fas fa-database"></i> База данных</a>
        <a href="logout.php" class="nav-item" style="margin-top: auto;"><i class="fas fa-sign-out-alt"></i> Выход</a>
    </div>

    <div class="main-content">
        <div class="header">
            <h1>Управление CDN</h1>
            <?php if ($action === 'list'): ?>
                <a href="cdn.php?action=add" class="btn btn-primary">Добавить новый CDN</a>
            <?php endif; ?>
        </div>

        <?php if ($message): ?>
            <div class="card" style="color: var(--secondary-color);"><?php echo $message; ?></div>
        <?php endif; ?>

        <?php if ($action === 'list'): ?>
            <div class="card">
                <table style="width: 100%; border-collapse: collapse;">
                    <thead>
                        <tr style="text-align: left; border-bottom: 1px solid var(--border-color);">
                            <th style="padding: 10px;">ID</th>
                            <th style="padding: 10px;">Название</th>
                            <th style="padding: 10px;">URL</th>
                            <th style="padding: 10px;">Действия</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php
                        $stmt = $db->query("SELECT * FROM cdn_links ORDER BY id ASC");
                        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)):
                        ?>
                        <tr style="border-bottom: 1px solid var(--border-color);">
                            <td style="padding: 10px;"><?php echo $row['id']; ?></td>
                            <td style="padding: 10px;"><?php echo $row['name']; ?></td>
                            <td style="padding: 10px;"><?php echo $row['url']; ?></td>
                            <td style="padding: 10px;">
                                <a href="cdn.php?action=edit&id=<?php echo $row['id']; ?>" style="color: var(--accent-color); margin-right: 10px;"><i class="fas fa-edit"></i></a>
                                <a href="cdn.php?action=delete&id=<?php echo $row['id']; ?>" style="color: var(--error-color);" onclick="return confirm('Вы уверены?')"><i class="fas fa-trash"></i></a>
                            </td>
                        </tr>
                        <?php endwhile; ?>
                    </tbody>
                </table>
            </div>
        <?php elseif ($action === 'add' || $action === 'edit'): 
            $item = ['name' => '', 'url' => ''];
            if ($action === 'edit' && $id) {
                $stmt = $db->prepare("SELECT * FROM cdn_links WHERE id = :id");
                $stmt->execute([':id' => $id]);
                $item = $stmt->fetch(PDO::FETCH_ASSOC);
            }
        ?>
            <div class="card">
                <form method="POST">
                    <div class="form-group">
                        <label>Название</label>
                        <input type="text" name="name" value="<?php echo htmlspecialchars($item['name']); ?>" required>
                    </div>
                    <div class="form-group">
                        <label>URL</label>
                        <input type="text" name="url" value="<?php echo htmlspecialchars($item['url']); ?>" required>
                    </div>
                    <button type="submit" class="btn btn-primary"><?php echo $action === 'add' ? 'Добавить' : 'Сохранить'; ?></button>
                    <a href="cdn.php" class="btn btn-secondary">Отмена</a>
                </form>
            </div>
        <?php endif; ?>
    </div>
</body>
</html>
