| <?php
|
|
|
| session_start();
|
|
|
|
|
| if (!isset($_SESSION['user']) || !isset($_SESSION['session_token'])) {
|
| header('Location: login.php');
|
| exit;
|
| }
|
|
|
|
|
| require_once __DIR__ . '/vendor/autoload.php';
|
|
|
|
|
| if (file_exists(__DIR__ . '/.env')) {
|
| $dotenv = Dotenv\Dotenv::createImmutable(__DIR__);
|
| $dotenv->load();
|
| }
|
|
|
|
|
| $user = new \SoftEdge\User();
|
|
|
|
|
| $sessionUser = $user->validateSession($_SESSION['session_token']);
|
| if (!$sessionUser || $sessionUser['role'] !== 'admin') {
|
| session_destroy();
|
| header('Location: login.php');
|
| exit;
|
| }
|
|
|
|
|
| $stats = $user->getAdminStats();
|
|
|
|
|
| $user->logPageVisit($sessionUser['id'], 'admin_dashboard', $_SERVER['HTTP_USER_AGENT'] ?? '');
|
|
|
|
|
| if (isset($_POST['logout'])) {
|
|
|
| try {
|
| $db = new PDO("mysql:host={$_ENV['DB_HOST']};dbname={$_ENV['DB_NAME']}", $_ENV['DB_USER'], $_ENV['DB_PASS']);
|
| $stmt = $db->prepare("DELETE FROM user_sessions WHERE session_token = ?");
|
| $stmt->execute([$_SESSION['session_token']]);
|
| } catch (Exception $e) {
|
| error_log("Session cleanup failed: " . $e->getMessage());
|
| }
|
|
|
| session_destroy();
|
| header('Location: login.php');
|
| exit;
|
| }
|
| ?>
|
|
|
| <!DOCTYPE html>
|
| <html lang="pt-BR" class="scroll-smooth">
|
| <head>
|
| <meta charset="UTF-8" />
|
| <meta name="viewport" content="width=device-width, initial-scale=1.0" />
|
| <title>Painel Administrativo - SoftEdge Corporation</title>
|
|
|
| <!-- SEO -->
|
| <meta name="description" content="Painel administrativo SoftEdge Corporation">
|
| <meta name="robots" content="noindex, nofollow">
|
|
|
| <!-- Favicon -->
|
| <link rel="icon" href="/assets/placeholder.svg" type="image/svg+xml">
|
|
|
| <!-- Fonts -->
|
| <link rel="preconnect" href="https://fonts.googleapis.com">
|
| <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
|
| <link href="https://fonts.googleapis.com/css2?family=Inter:wght@300;400;500;600;700&display=swap" rel="stylesheet">
|
|
|
| <!-- Tailwind CSS -->
|
| <script src="https://cdn.tailwindcss.com"></script>
|
| <script>
|
| tailwind.config = {
|
| theme: {
|
| extend: {
|
| fontFamily: {
|
| sans: ['Inter', 'system-ui', 'sans-serif'],
|
| },
|
| colors: {
|
| primary: {
|
| 50: '#f8fafc',
|
| 100: '#f1f5f9',
|
| 200: '#e2e8f0',
|
| 300: '#cbd5e1',
|
| 400: '#94a3b8',
|
| 500: '#64748b',
|
| 600: '#475569',
|
| 700: '#334155',
|
| 800: '#1e293b',
|
| 900: '#0f172a',
|
| }
|
| }
|
| }
|
| }
|
| }
|
| </script>
|
|
|
| <!-- Lucide Icons -->
|
| <script src="https://unpkg.com/lucide@latest"></script>
|
|
|
| <!-- Chart.js for analytics -->
|
| <script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
|
|
|
| <style>
|
| .glass-card {
|
| background: rgba(30, 41, 59, 0.8);
|
| backdrop-filter: blur(20px);
|
| -webkit-backdrop-filter: blur(20px);
|
| border: 1px solid rgba(148, 163, 184, 0.1);
|
| }
|
|
|
| .stat-card {
|
| transition: all 0.3s ease;
|
| }
|
|
|
| .stat-card:hover {
|
| transform: translateY(-2px);
|
| box-shadow: 0 10px 25px rgba(0, 0, 0, 0.2);
|
| }
|
|
|
| .fade-in {
|
| animation: fadeIn 0.6s ease-out;
|
| }
|
|
|
| @keyframes fadeIn {
|
| from { opacity: 0; transform: translateY(20px); }
|
| to { opacity: 1; transform: translateY(0); }
|
| }
|
|
|
| .sidebar {
|
| transform: translateX(-100%);
|
| transition: transform 0.3s ease;
|
| }
|
|
|
| .sidebar.open {
|
| transform: translateX(0);
|
| }
|
|
|
| @media (min-width: 768px) {
|
| .sidebar {
|
| transform: translateX(0);
|
| }
|
| }
|
| </style>
|
| </head>
|
|
|
| <body class="bg-slate-950 min-h-screen">
|
| <!-- Sidebar -->
|
| <div class="sidebar fixed inset-y-0 left-0 z-50 w-64 bg-slate-900 border-r border-slate-700 md:relative md:translate-x-0">
|
| <div class="flex flex-col h-full">
|
| <!-- Logo -->
|
| <div class="flex items-center justify-center p-6 border-b border-slate-700">
|
| <div class="flex items-center space-x-3">
|
| <div class="w-8 h-8 rounded-lg overflow-hidden bg-slate-700 border border-slate-600">
|
| <img src="/assets/logo.jpeg" alt="SoftEdge Logo" class="w-full h-full object-cover">
|
| </div>
|
| <span class="text-lg font-semibold text-slate-200 tracking-tight">
|
| Admin Panel
|
| </span>
|
| </div>
|
| </div>
|
|
|
| <!-- Navigation -->
|
| <nav class="flex-1 px-4 py-6 space-y-2">
|
| <a href="#dashboard" class="nav-link flex items-center gap-3 px-4 py-3 text-slate-300 hover:text-white hover:bg-slate-800 rounded-lg transition-colors active">
|
| <i data-lucide="layout-dashboard" class="w-5 h-5"></i>
|
| <span>Dashboard</span>
|
| </a>
|
|
|
| <a href="#users" class="nav-link flex items-center gap-3 px-4 py-3 text-slate-400 hover:text-white hover:bg-slate-800 rounded-lg transition-colors">
|
| <i data-lucide="users" class="w-5 h-5"></i>
|
| <span>Usuários</span>
|
| </a>
|
|
|
| <a href="#analytics" class="nav-link flex items-center gap-3 px-4 py-3 text-slate-400 hover:text-white hover:bg-slate-800 rounded-lg transition-colors">
|
| <i data-lucide="bar-chart-3" class="w-5 h-5"></i>
|
| <span>Analytics</span>
|
| </a>
|
|
|
| <a href="#settings" class="nav-link flex items-center gap-3 px-4 py-3 text-slate-400 hover:text-white hover:bg-slate-800 rounded-lg transition-colors">
|
| <i data-lucide="settings" class="w-5 h-5"></i>
|
| <span>Configurações</span>
|
| </a>
|
| </nav>
|
|
|
| <!-- User Info & Logout -->
|
| <div class="p-4 border-t border-slate-700">
|
| <div class="flex items-center gap-3 mb-4">
|
| <div class="w-8 h-8 rounded-full bg-slate-700 flex items-center justify-center">
|
| <i data-lucide="user" class="w-4 h-4 text-slate-400"></i>
|
| </div>
|
| <div class="flex-1 min-w-0">
|
| <p class="text-sm font-medium text-slate-200 truncate">
|
| <?php echo htmlspecialchars($sessionUser['name']); ?>
|
| </p>
|
| <p class="text-xs text-slate-400">Administrador</p>
|
| </div>
|
| </div>
|
|
|
| <form method="POST" class="w-full">
|
| <button type="submit" name="logout" class="w-full flex items-center gap-3 px-4 py-2 text-slate-400 hover:text-white hover:bg-red-500/10 hover:border-red-500/20 border border-transparent rounded-lg transition-all">
|
| <i data-lucide="log-out" class="w-4 h-4"></i>
|
| <span class="text-sm">Sair</span>
|
| </button>
|
| </form>
|
| </div>
|
| </div>
|
| </div>
|
|
|
| <!-- Mobile Overlay -->
|
| <div class="sidebar-overlay fixed inset-0 bg-black/50 z-40 md:hidden opacity-0 pointer-events-none transition-opacity"></div>
|
|
|
| <!-- Main Content -->
|
| <div class="md:ml-64">
|
| <!-- Header -->
|
| <header class="bg-slate-900/50 backdrop-blur-xl border-b border-slate-700 p-4 md:p-6">
|
| <div class="flex items-center justify-between">
|
| <div class="flex items-center gap-4">
|
| <button class="md:hidden text-slate-400 hover:text-white p-2" id="sidebarToggle">
|
| <i data-lucide="menu" class="w-6 h-6"></i>
|
| </button>
|
| <div>
|
| <h1 class="text-2xl font-bold text-white">Dashboard Administrativo</h1>
|
| <p class="text-slate-400 text-sm">Bem-vindo de volta, <?php echo htmlspecialchars(explode(' ', $sessionUser['name'])[0]); ?>!</p>
|
| </div>
|
| </div>
|
|
|
| <div class="flex items-center gap-4">
|
| <div class="hidden md:flex items-center gap-2 text-slate-400 text-sm">
|
| <i data-lucide="clock" class="w-4 h-4"></i>
|
| <span><?php echo date('d/m/Y H:i'); ?></span>
|
| </div>
|
| </div>
|
| </div>
|
| </header>
|
|
|
| <!-- Dashboard Content -->
|
| <main class="p-4 md:p-6 space-y-6">
|
| <!-- Stats Cards -->
|
| <div class="grid grid-cols-1 md:grid-cols-2 lg:grid-cols-4 gap-6">
|
| <div class="stat-card glass-card p-6 rounded-xl">
|
| <div class="flex items-center justify-between">
|
| <div>
|
| <p class="text-slate-400 text-sm font-medium">Total de Usuários</p>
|
| <p class="text-2xl font-bold text-white"><?php echo number_format($stats['total_users'] ?? 0); ?></p>
|
| </div>
|
| <div class="w-12 h-12 bg-blue-500/20 rounded-lg flex items-center justify-center">
|
| <i data-lucide="users" class="w-6 h-6 text-blue-400"></i>
|
| </div>
|
| </div>
|
| </div>
|
|
|
| <div class="stat-card glass-card p-6 rounded-xl">
|
| <div class="flex items-center justify-between">
|
| <div>
|
| <p class="text-slate-400 text-sm font-medium">Total de Visitas</p>
|
| <p class="text-2xl font-bold text-white"><?php echo number_format($stats['total_visits'] ?? 0); ?></p>
|
| </div>
|
| <div class="w-12 h-12 bg-green-500/20 rounded-lg flex items-center justify-center">
|
| <i data-lucide="eye" class="w-6 h-6 text-green-400"></i>
|
| </div>
|
| </div>
|
| </div>
|
|
|
| <div class="stat-card glass-card p-6 rounded-xl">
|
| <div class="flex items-center justify-between">
|
| <div>
|
| <p class="text-slate-400 text-sm font-medium">Visitas (30 dias)</p>
|
| <p class="text-2xl font-bold text-white"><?php echo number_format($stats['recent_visits'] ?? 0); ?></p>
|
| </div>
|
| <div class="w-12 h-12 bg-purple-500/20 rounded-lg flex items-center justify-center">
|
| <i data-lucide="trending-up" class="w-6 h-6 text-purple-400"></i>
|
| </div>
|
| </div>
|
| </div>
|
|
|
| <div class="stat-card glass-card p-6 rounded-xl">
|
| <div class="flex items-center justify-between">
|
| <div>
|
| <p class="text-slate-400 text-sm font-medium">Taxa de Conversão</p>
|
| <p class="text-2xl font-bold text-white">
|
| <?php
|
| $conversion = $stats['total_users'] > 0 ? (($stats['total_visits'] ?? 0) / $stats['total_users']) : 0;
|
| echo number_format($conversion, 1);
|
| ?>x
|
| </p>
|
| </div>
|
| <div class="w-12 h-12 bg-orange-500/20 rounded-lg flex items-center justify-center">
|
| <i data-lucide="target" class="w-6 h-6 text-orange-400"></i>
|
| </div>
|
| </div>
|
| </div>
|
| </div>
|
|
|
| <!-- Charts and Tables -->
|
| <div class="grid grid-cols-1 lg:grid-cols-2 gap-6">
|
| <!-- Top Pages Chart -->
|
| <div class="glass-card p-6 rounded-xl">
|
| <h3 class="text-lg font-semibold text-white mb-4 flex items-center gap-2">
|
| <i data-lucide="bar-chart-3" class="w-5 h-5 text-slate-400"></i>
|
| Páginas Mais Visitadas
|
| </h3>
|
| <div class="space-y-3">
|
| <?php foreach (($stats['top_pages'] ?? []) as $page): ?>
|
| <div class="flex items-center justify-between p-3 bg-slate-800/50 rounded-lg">
|
| <span class="text-slate-300 capitalize"><?php echo htmlspecialchars($page['page']); ?></span>
|
| <span class="text-slate-400 text-sm"><?php echo number_format($page['visits']); ?> visitas</span>
|
| </div>
|
| <?php endforeach; ?>
|
| </div>
|
| </div>
|
|
|
| <!-- Recent Users -->
|
| <div class="glass-card p-6 rounded-xl">
|
| <h3 class="text-lg font-semibold text-white mb-4 flex items-center gap-2">
|
| <i data-lucide="user-plus" class="w-5 h-5 text-slate-400"></i>
|
| Usuários Recentes
|
| </h3>
|
| <div class="space-y-3">
|
| <?php foreach (($stats['recent_users'] ?? []) as $recentUser): ?>
|
| <div class="flex items-center gap-3 p-3 bg-slate-800/50 rounded-lg">
|
| <div class="w-8 h-8 rounded-full bg-slate-700 flex items-center justify-center">
|
| <i data-lucide="user" class="w-4 h-4 text-slate-400"></i>
|
| </div>
|
| <div class="flex-1 min-w-0">
|
| <p class="text-slate-300 text-sm font-medium truncate"><?php echo htmlspecialchars($recentUser['name']); ?></p>
|
| <p class="text-slate-400 text-xs"><?php echo date('d/m/Y', strtotime($recentUser['created_at'])); ?></p>
|
| </div>
|
| </div>
|
| <?php endforeach; ?>
|
| </div>
|
| </div>
|
| </div>
|
|
|
| <!-- System Info -->
|
| <div class="glass-card p-6 rounded-xl">
|
| <h3 class="text-lg font-semibold text-white mb-4 flex items-center gap-2">
|
| <i data-lucide="server" class="w-5 h-5 text-slate-400"></i>
|
| Informações do Sistema
|
| </h3>
|
| <div class="grid grid-cols-1 md:grid-cols-3 gap-4">
|
| <div class="p-4 bg-slate-800/50 rounded-lg">
|
| <p class="text-slate-400 text-sm">PHP Version</p>
|
| <p class="text-white font-medium"><?php echo PHP_VERSION; ?></p>
|
| </div>
|
| <div class="p-4 bg-slate-800/50 rounded-lg">
|
| <p class="text-slate-400 text-sm">Database</p>
|
| <p class="text-white font-medium">MySQL</p>
|
| </div>
|
| <div class="p-4 bg-slate-800/50 rounded-lg">
|
| <p class="text-slate-400 text-sm">Último Backup</p>
|
| <p class="text-white font-medium"><?php echo date('d/m/Y H:i'); ?></p>
|
| </div>
|
| </div>
|
| </div>
|
| </main>
|
| </div>
|
|
|
| <!-- Scripts -->
|
| <script src="https://unpkg.com/lucide@latest"></script>
|
| <script>
|
| document.addEventListener('DOMContentLoaded', () => {
|
|
|
| lucide.createIcons();
|
|
|
|
|
| const sidebar = document.querySelector('.sidebar');
|
| const overlay = document.querySelector('.sidebar-overlay');
|
| const sidebarToggle = document.getElementById('sidebarToggle');
|
|
|
| const toggleSidebar = () => {
|
| sidebar.classList.toggle('open');
|
| overlay.classList.toggle('opacity-0');
|
| overlay.classList.toggle('pointer-events-none');
|
| };
|
|
|
| sidebarToggle?.addEventListener('click', toggleSidebar);
|
| overlay?.addEventListener('click', toggleSidebar);
|
|
|
|
|
| const navLinks = document.querySelectorAll('.nav-link');
|
| navLinks.forEach(link => {
|
| link.addEventListener('click', function(e) {
|
| e.preventDefault();
|
|
|
| // Remove active class from all links
|
| navLinks.forEach(l => l.classList.remove('active', 'text-white'));
|
| navLinks.forEach(l => l.classList.add('text-slate-400'));
|
|
|
| // Add active class to clicked link
|
| this.classList.add('active', 'text-white');
|
| this.classList.remove('text-slate-400');
|
|
|
| // Close sidebar on mobile
|
| if (window.innerWidth < 768) {
|
| toggleSidebar();
|
| }
|
| });
|
| });
|
|
|
|
|
| setInterval(() => {
|
|
|
|
|
| console.log('Refreshing stats...');
|
| }, 30000);
|
| });
|
| </script>
|
| </body>
|
| </html>
|
|
|
