One Hat Cyber Team

View File Name : dashboard.php

<?php
// dashboard.php
require_once 'config.php';

if (!isLoggedIn()) {
    redirect('index.php');
}

// Get statistics
$stats = [];
$stats['total_members'] = $pdo->query("SELECT COUNT(*) as count FROM members WHERE membership_status = 'Active'")->fetch()['count'];
$stats['total_tithes'] = $pdo->query("SELECT COALESCE(SUM(amount), 0) as total FROM tithes WHERE MONTH(payment_date) = MONTH(CURDATE())")->fetch()['total'];
$stats['total_offerings'] = $pdo->query("SELECT COALESCE(SUM(amount), 0) as total FROM offerings WHERE MONTH(service_date) = MONTH(CURDATE())")->fetch()['total'];
$stats['total_cottages'] = $pdo->query("SELECT COUNT(*) as count FROM cottages WHERE status = 'Active'")->fetch()['count'];
$stats['pending_procurements'] = $pdo->query("SELECT COUNT(*) as count FROM procurement WHERE status = 'Pending'")->fetch()['count'];

// Recent activities
$recent_tithes = $pdo->query("SELECT t.*, m.first_name, m.last_name FROM tithes t JOIN members m ON t.member_id = m.id ORDER BY t.created_at DESC LIMIT 5")->fetchAll();
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Dashboard - Church Management System</title>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <style>
        :root {
            --primary: #4f46e5;
            --primary-dark: #4338ca;
            --secondary: #7c3aed;
            --success: #10b981;
            --warning: #f59e0b;
            --danger: #ef4444;
            --light: #f8fafc;
            --dark: #1e293b;
            --gray: #64748b;
        }
        
        * {
            margin: 0;
            padding: 0;
            box-sizing: border-box;
        }
        
        body {
            font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
            background: var(--light);
            color: var(--dark);
        }
        
        .dashboard-container {
            display: flex;
            min-height: 100vh;
        }
        
        /* Sidebar Styles */
        .sidebar {
            width: 250px;
            background: white;
            box-shadow: 0 0 20px rgba(0,0,0,0.1);
            position: fixed;
            height: 100vh;
            z-index: 1000;
        }
        
        .sidebar-header {
            padding: 25px;
            background: linear-gradient(135deg, var(--primary), var(--secondary));
            color: white;
            text-align: center;
        }
        
        .sidebar-header h2 {
            font-size: 22px;
            display: flex;
            align-items: center;
            justify-content: center;
            gap: 10px;
            margin-bottom: 5px;
        }
        
        .user-info {
            font-size: 14px;
            opacity: 0.9;
        }
        
        .sidebar-menu {
            padding: 20px 0;
        }
        
        .menu-item {
            display: flex;
            align-items: center;
            gap: 12px;
            padding: 15px 25px;
            color: var(--gray);
            text-decoration: none;
            transition: all 0.3s ease;
            border-left: 4px solid transparent;
        }
        
        .menu-item:hover, .menu-item.active {
            background: var(--light);
            color: var(--primary);
            border-left-color: var(--primary);
        }
        
        .menu-item i {
            width: 20px;
            text-align: center;
        }
        
        /* Main Content */
        .main-content {
            flex: 1;
            margin-left: 250px;
            padding: 20px;
        }
        
        .top-bar {
            background: white;
            padding: 20px;
            border-radius: 15px;
            box-shadow: 0 2px 10px rgba(0,0,0,0.05);
            margin-bottom: 30px;
            display: flex;
            justify-content: space-between;
            align-items: center;
        }
        
        .top-bar h1 {
            color: var(--dark);
            font-size: 24px;
        }
        
        .user-menu {
            display: flex;
            align-items: center;
            gap: 15px;
        }
        
        .logout-btn {
            background: var(--danger);
            color: white;
            border: none;
            padding: 10px 20px;
            border-radius: 10px;
            cursor: pointer;
            display: flex;
            align-items: center;
            gap: 8px;
            transition: all 0.3s ease;
        }
        
        .logout-btn:hover {
            background: #dc2626;
            transform: translateY(-2px);
        }
        
        /* Stats Cards */
        .stats-grid {
            display: grid;
            grid-template-columns: repeat(auto-fit, minmax(250px, 1fr));
            gap: 20px;
            margin-bottom: 30px;
        }
        
        .stat-card {
            background: white;
            padding: 25px;
            border-radius: 15px;
            box-shadow: 0 5px 15px rgba(0,0,0,0.05);
            transition: transform 0.3s ease;
            border-top: 5px solid;
        }
        
        .stat-card:hover {
            transform: translateY(-5px);
        }
        
        .stat-card.members { border-color: var(--primary); }
        .stat-card.tithes { border-color: var(--success); }
        .stat-card.offerings { border-color: var(--secondary); }
        .stat-card.cottages { border-color: var(--warning); }
        .stat-card.procurement { border-color: var(--danger); }
        
        .stat-icon {
            width: 60px;
            height: 60px;
            border-radius: 12px;
            display: flex;
            align-items: center;
            justify-content: center;
            font-size: 24px;
            margin-bottom: 15px;
        }
        
        .stat-card.members .stat-icon { background: rgba(79, 70, 229, 0.1); color: var(--primary); }
        .stat-card.tithes .stat-icon { background: rgba(16, 185, 129, 0.1); color: var(--success); }
        .stat-card.offerings .stat-icon { background: rgba(124, 58, 237, 0.1); color: var(--secondary); }
        .stat-card.cottages .stat-icon { background: rgba(245, 158, 11, 0.1); color: var(--warning); }
        .stat-card.procurement .stat-icon { background: rgba(239, 68, 68, 0.1); color: var(--danger); }
        
        .stat-value {
            font-size: 32px;
            font-weight: 700;
            margin-bottom: 5px;
        }
        
        .stat-label {
            color: var(--gray);
            font-size: 14px;
        }
        
        /* Recent Activity */
        .recent-activity {
            background: white;
            padding: 30px;
            border-radius: 15px;
            box-shadow: 0 5px 15px rgba(0,0,0,0.05);
        }
        
        .section-title {
            font-size: 20px;
            margin-bottom: 20px;
            color: var(--dark);
            display: flex;
            align-items: center;
            gap: 10px;
        }
        
        .activity-table {
            width: 100%;
            border-collapse: collapse;
        }
        
        .activity-table th {
            text-align: left;
            padding: 15px;
            background: var(--light);
            color: var(--gray);
            font-weight: 600;
            border-bottom: 2px solid var(--light);
        }
        
        .activity-table td {
            padding: 15px;
            border-bottom: 1px solid var(--light);
        }
        
        .activity-table tr:hover {
            background: var(--light);
        }
        
        .badge {
            padding: 5px 12px;
            border-radius: 20px;
            font-size: 12px;
            font-weight: 600;
        }
        
        .badge.success { background: rgba(16, 185, 129, 0.1); color: var(--success); }
        .badge.pending { background: rgba(245, 158, 11, 0.1); color: var(--warning); }
        
        /* Responsive */
        @media (max-width: 768px) {
            .sidebar {
                width: 100%;
                height: auto;
                position: relative;
            }
            
            .main-content {
                margin-left: 0;
            }
            
            .stats-grid {
                grid-template-columns: 1fr;
            }
        }
    </style>
</head>
<body>
    <div class="dashboard-container">
        <!-- Sidebar -->
        <div class="sidebar">
            <div class="sidebar-header">
                <h2><i class="fas fa-church"></i> Church MS</h2>
                <div class="user-info">
                    <p>Welcome, <?php echo $_SESSION['full_name']; ?></p>
                    <p><?php echo $_SESSION['role']; ?></p>
                </div>
            </div>
            
            <nav class="sidebar-menu">
                <a href="dashboard.php" class="menu-item active">
                    <i class="fas fa-tachometer-alt"></i>
                    <span>Dashboard</span>
                </a>
                <a href="members.php" class="menu-item">
                    <i class="fas fa-users"></i>
                    <span>Members</span>
                </a>
                <a href="tithes.php" class="menu-item">
                    <i class="fas fa-hand-holding-usd"></i>
                    <span>Tithes</span>
                </a>
                <a href="offerings.php" class="menu-item">
                    <i class="fas fa-donate"></i>
                    <span>Offerings</span>
                </a>
                <a href="cottages.php" class="menu-item">
                    <i class="fas fa-home"></i>
                    <span>Cottages</span>
                </a>
                <a href="procurement.php" class="menu-item">
                    <i class="fas fa-shopping-cart"></i>
                    <span>Procurement</span>
                </a>
                <a href="reports.php" class="menu-item">
                    <i class="fas fa-chart-bar"></i>
                    <span>Reports</span>
                </a>
                <a href="users.php" class="menu-item">
                    <i class="fas fa-user-cog"></i>
                    <span>Users</span>
                </a>
            </nav>
        </div>
        
        <!-- Main Content -->
        <div class="main-content">
            <!-- Top Bar -->
            <div class="top-bar">
                <h1>Dashboard Overview</h1>
                <div class="user-menu">
                    <form action="logout.php" method="POST">
                        <button type="submit" class="logout-btn">
                            <i class="fas fa-sign-out-alt"></i> Logout
                        </button>
                    </form>
                </div>
            </div>
            
            <!-- Stats Grid -->
            <div class="stats-grid">
                <div class="stat-card members">
                    <div class="stat-icon">
                        <i class="fas fa-users"></i>
                    </div>
                    <div class="stat-value"><?php echo $stats['total_members']; ?></div>
                    <div class="stat-label">Active Members</div>
                </div>
                
                <div class="stat-card tithes">
                    <div class="stat-icon">
                        <i class="fas fa-hand-holding-usd"></i>
                    </div>
                    <div class="stat-value"><?php echo formatCurrency($stats['total_tithes']); ?></div>
                    <div class="stat-label">Monthly Tithes</div>
                </div>
                
                <div class="stat-card offerings">
                    <div class="stat-icon">
                        <i class="fas fa-donate"></i>
                    </div>
                    <div class="stat-value"><?php echo formatCurrency($stats['total_offerings']); ?></div>
                    <div class="stat-label">Monthly Offerings</div>
                </div>
                
                <div class="stat-card cottages">
                    <div class="stat-icon">
                        <i class="fas fa-home"></i>
                    </div>
                    <div class="stat-value"><?php echo $stats['total_cottages']; ?></div>
                    <div class="stat-label">Active Cottages</div>
                </div>
                
                <div class="stat-card procurement">
                    <div class="stat-icon">
                        <i class="fas fa-shopping-cart"></i>
                    </div>
                    <div class="stat-value"><?php echo $stats['pending_procurements']; ?></div>
                    <div class="stat-label">Pending Procurement</div>
                </div>
            </div>
            
            <!-- Recent Activity -->
            <div class="recent-activity">
                <h2 class="section-title">
                    <i class="fas fa-history"></i> Recent Tithe Payments
                </h2>
                
                <table class="activity-table">
                    <thead>
                        <tr>
                            <th>Member</th>
                            <th>Amount</th>
                            <th>Date</th>
                            <th>Method</th>
                            <th>Status</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php foreach ($recent_tithes as $tithe): ?>
                        <tr>
                            <td><?php echo $tithe['first_name'] . ' ' . $tithe['last_name']; ?></td>
                            <td><?php echo formatCurrency($tithe['amount']); ?></td>
                            <td><?php echo formatDate($tithe['payment_date']); ?></td>
                            <td><?php echo $tithe['payment_method']; ?></td>
                            <td>
                                <span class="badge success">Paid</span>
                            </td>
                        </tr>
                        <?php endforeach; ?>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</body>
</html>