<?php require_once 'config.php'; require_once 'auth.php'; // Login kontrolü // Get statistics try { $newsCount = $pdo->query("SELECT COUNT(*) FROM cms_news")->fetchColumn(); $academyCount = $pdo->query("SELECT COUNT(*) FROM cms_academy")->fetchColumn(); $recentNews = $pdo->query("SELECT * FROM cms_news ORDER BY created_at DESC LIMIT 5")->fetchAll(); } catch (PDOException $e) { // Tablolar yoksa varsayılan değerler $newsCount = 0; $academyCount = 0; $recentNews = []; // Hata mesajı (geliştirme için) $dbError = "Database error: " . $e->getMessage(); } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>FraudActive CMS - Dashboard</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.5.1/css/all.min.css"> <style> body { background: #f8f9fa; } .sidebar { min-height: 100vh; background: #1e40af; color: white; } .sidebar a { color: rgba(255,255,255,0.8); text-decoration: none; padding: 12px 20px; display: block; transition: all 0.3s; } .sidebar a:hover, .sidebar a.active { background: rgba(255,255,255,0.1); color: white; } .stat-card { background: white; border-radius: 10px; padding: 20px; box-shadow: 0 2px 10px rgba(0,0,0,0.1); } .stat-card .icon { font-size: 48px; opacity: 0.3; } .navbar-custom { background: white; box-shadow: 0 2px 5px rgba(0,0,0,0.1); } </style> </head> <body> <div class="container-fluid"> <div class="row"> <!-- Sidebar --> <div class="col-md-2 sidebar p-0"> <div class="p-4"> <h4 class="mb-4"><i class="fas fa-shield-alt"></i> FraudActive</h4> </div> <nav> <a href="index.php" class="active"><i class="fas fa-home"></i> Dashboard</a> <a href="news.php"><i class="fas fa-newspaper"></i> News Management</a> <a href="academy.php"><i class="fas fa-graduation-cap"></i> Academy Content</a> <a href="api.php" target="_blank"><i class="fas fa-code"></i> API Endpoint</a> </nav> <div class="p-4 mt-5" style="position: absolute; bottom: 20px; width: 16.666667%;"> <small class="text-white-50 d-block mb-2"> 👤 <?php echo isset($_SESSION['email']) ? $_SESSION['email'] : $_SESSION['username']; ?> </small> <a href="logout.php" class="btn btn-sm btn-outline-light w-100"> <i class="fas fa-sign-out-alt"></i> Logout </a> </div> </div> <!-- Main Content --> <div class="col-md-10"> <!-- Top Navbar --> <nav class="navbar navbar-custom mb-4"> <div class="container-fluid"> <span class="navbar-brand mb-0 h1">Dashboard</span> <span class="text-muted"><i class="fas fa-clock"></i> <?php echo date('F j, Y'); ?></span> </div> </nav> <div class="container-fluid"> <?php if (isset($dbError)): ?> <div class="alert alert-warning alert-dismissible fade show"> <i class="fas fa-exclamation-triangle"></i> <strong>Database Issue:</strong> <?php echo htmlspecialchars($dbError); ?> <button type="button" class="btn-close" data-bs-dismiss="alert"></button> </div> <?php endif; ?> <!-- Statistics Cards --> <div class="row mb-4"> <div class="col-md-6 mb-3"> <div class="stat-card"> <div class="d-flex justify-content-between align-items-center"> <div> <h3 class="mb-0"><?php echo $newsCount; ?></h3> <p class="text-muted mb-0">News Articles</p> </div> <i class="fas fa-newspaper icon text-primary"></i> </div> </div> </div> <div class="col-md-6 mb-3"> <div class="stat-card"> <div class="d-flex justify-content-between align-items-center"> <div> <h3 class="mb-0"><?php echo $academyCount; ?></h3> <p class="text-muted mb-0">Academy Lessons</p> </div> <i class="fas fa-graduation-cap icon text-success"></i> </div> </div> </div> </div> <!-- Recent News --> <div class="card"> <div class="card-header bg-primary text-white"> <h5 class="mb-0"><i class="fas fa-newspaper"></i> Recent News</h5> </div> <div class="card-body"> <?php if (count($recentNews) > 0): ?> <div class="list-group"> <?php foreach ($recentNews as $news): ?> <a href="news.php?edit=<?php echo $news['id']; ?>" class="list-group-item list-group-item-action"> <div class="d-flex justify-content-between align-items-center"> <div> <h6 class="mb-1"><?php echo htmlspecialchars($news['title']); ?></h6> <small class="text-muted"> <i class="fas fa-calendar"></i> <?php echo date('M j, Y', strtotime($news['created_at'])); ?> </small> </div> <span class="badge bg-<?php echo $news['status'] == 'published' ? 'success' : 'warning'; ?>"> <?php echo ucfirst($news['status']); ?> </span> </div> </a> <?php endforeach; ?> </div> <?php else: ?> <p class="text-muted">No news articles yet. <a href="news.php">Create your first article</a></p> <?php endif; ?> </div> </div> <!-- Quick Actions --> <div class="row mt-4"> <div class="col-md-6"> <a href="news.php" class="btn btn-primary btn-lg w-100"> <i class="fas fa-plus"></i> Add News Article </a> </div> <div class="col-md-6"> <a href="academy.php" class="btn btn-success btn-lg w-100"> <i class="fas fa-plus"></i> Add Academy Content </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>