Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/rutzotech.com/public_html/ems/employee/hr

Free Space:

10 TB

🔧 Quick Actions

✏️ Editing: hr-dashboard.php

<?php 
include 'db.php';
session_start(); // ✅ Must be the first thing in the script

// Safely get session value
$user_id = $_SESSION['user_id'] ?? null;

if (!$user_id) {
    // Optional: redirect unauthorized access
    header("Location: /ems/index.php");
    exit();
}

// Fetch current user
$user_id = $_SESSION['user_id'];
$query = "SELECT * FROM users WHERE id = ?";
$stmt = $conn->prepare($query);
$stmt->bind_param("i", $user_id);
$stmt->execute();
$result = $stmt->get_result();
$user = $result->fetch_assoc();

?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <title>CRM | HR Dashboard</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta content="A fully featured admin theme which can be used to build CRM, CMS, etc." name="description">
    
    
    <link rel="shortcut icon" href="uploads/logo.jpeg">
    
    <script src="js/hyper-config.js"></script>
    
    
    <link href="css/app.min.css" rel="stylesheet" type="text/css" id="app-style">
    
    
    <link href="css/unicons.css" rel="stylesheet" type="text/css">
    <link href="css/remixicon.css" rel="stylesheet" type="text/css">
    <link href="css/materialdesignicons.min.css" rel="stylesheet" type="text/css">
     <link rel="shortcut icon" href="Uploads/logo.jpeg">
    
    
    <link href="css/vendor.min.css" rel="stylesheet" type="text/css">
    
    <style>
        :root {
            --bs-sidebar-bg: #313a46;
            --bs-sidebar-menu-item-color: #8391a2;
            --bs-sidebar-menu-item-active-color: #bccee4;
            --bs-sidebar-menu-item-active-bg: #2a313c;
            --bs-sidebar-menu-item-hover-color: #bccee4;
            --bs-sidebar-menu-item-hover-bg: #2a313c;
            --bs-sidebar-sub-bg: #2a313c;
        }
        
        .widget-flat .icon {
            font-size: 2rem;
            opacity: 0.3;
        }
        .card-title {
            font-weight: 600;
            color: #444;
        }
        .table th {
            font-weight: 600;
            background-color: #f8f9fa;
        }
        .alert-heading {
            font-size: 1rem;
            margin-bottom: 0.5rem;
        }
        .badge {
            font-size: 0.8em;
        }
        .progress {
            height: 6px;
        }
        .nav-tabs .nav-link {
            color: #6c757d;
        }
        .nav-tabs .nav-link.active {
            color: #727cf5;
            font-weight: 600;
        }
    </style>
</head>
<body>
    
    <div class="wrapper">
        <?php include 'hr-sidebar.php'; ?>
        <?php include 'hr-nav.php'; ?>

<div class="content-page">
            <div class="content">
                <div class="container-fluid">

<div class="row">
                        <div class="col-12">
                            <div class="page-title-box">
                                <div class="page-title-right">
                                    <ol class="breadcrumb m-0">
                                        <li class="breadcrumb-item"><a href="javascript: void(0);">Dashboard</a></li>
                                        <li class="breadcrumb-item active">Admin</li>
                                    </ol>
                                </div>
                                <h4 class="page-title"><i class="ri-dashboard-line"></i>  Dashboard</h4>
                            </div>
                        </div>
                    </div>

<div class="row">
                        <div class="col-xl-12">
                            <div class="card">
                                <div class="card-body">
                                    <h4 class="header-title mb-4"><i class="ri-group-line"></i> User Overview</h4>
                                    <div class="row">
                                        <?php
                                        $totalUsers = $conn->query("SELECT COUNT(*) as total FROM users")->fetch_assoc()['total'];
                                        $admins = $conn->query("SELECT COUNT(*) as total FROM users WHERE role='admin'")->fetch_assoc()['total'];
                                        $clients = $conn->query("SELECT COUNT(*) as total FROM users WHERE role='client'")->fetch_assoc()['total'];
                                        $employees = $conn->query("SELECT COUNT(*) as total FROM users WHERE role='employee'")->fetch_assoc()['total'];
                                        $designations = $conn->query("SELECT designation, COUNT(*) as count FROM users WHERE role='employee' AND designation IS NOT NULL GROUP BY designation");
                                        ?>
                                        <div class="col-md-3">
                                            <div class="card widget-flat bg-light">
                                                <div class="card-body">
                                                    <div class="float-end"><i class="ri-group-line text-primary icon"></i></div>
                                                    <h5 class="text-muted fw-normal mt-0">Total Users</h5>
                                                    <h3 class="mt-2 mb-0"><?php echo $totalUsers; ?></h3>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-3">
                                            <div class="card widget-flat bg-light">
                                                <div class="card-body">
                                                    <div class="float-end"><i class="ri-admin-line text-warning icon"></i></div>
                                                    <h5 class="text-muted fw-normal mt-0">Admins</h5>
                                                    <h3 class="mt-2 mb-0"><?php echo $admins; ?></h3>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-3">
                                            <div class="card widget-flat bg-light">
                                                <div class="card-body">
                                                    <div class="float-end"><i class="ri-user-star-line text-success icon"></i></div>
                                                    <h5 class="text-muted fw-normal mt-0">Clients</h5>
                                                    <h3 class="mt-2 mb-0"><?php echo $clients; ?></h3>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-3">
                                            <div class="card widget-flat bg-light">
                                                <div class="card-body">
                                                    <div class="float-end"><i class="ri-briefcase-4-line text-info icon"></i></div>
                                                    <h5 class="text-muted fw-normal mt-0">Employees</h5>
                                                    <h3 class="mt-2 mb-0"><?php echo $employees; ?></h3>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

<div class="row mt-4">
                                        <div class="col-md-6">
                                            <div class="card">
                                                <div class="card-body">
                                                    <h5 class="card-title"><i class="ri-briefcase-line"></i> Employee Designations</h5>
                                                    <div class="table-responsive">
                                                        <table class="table table-hover table-centered mb-0">
                                                            <thead class="table-light">
                                                                <tr>
                                                                    <th><i class="mdi mdi-briefcase-variant"></i> Designation</th>
                                                                    <th><i class="mdi mdi-counter"></i> Count</th>
                                                                </tr>
                                                            </thead>
                                                            <tbody>
                                                                <?php if ($designations->num_rows > 0): ?>
                                                                    <?php while ($row = $designations->fetch_assoc()): ?>
                                                                    <tr>
                                                                        <td><?php echo htmlspecialchars($row['designation']); ?></td>
                                                                        <td><span class="badge bg-primary"><?php echo $row['count']; ?></span></td>
                                                                    </tr>
                                                                    <?php endwhile; ?>
                                                                <?php else: ?>
                                                                    <tr>
                                                                        <td colspan="2" class="text-center text-muted"><i>No designations found</i></td>
                                                                    </tr>
                                                                <?php endif; ?>
                                                            </tbody>
                                                        </table>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>

<div class="col-md-6">
                                            <div class="card">
                                                <div class="card-body">
                                                    <h5 class="card-title"><i class="ri-user-add-line"></i> Recently Added Users</h5>
                                                    <div class="table-responsive">
                                                        <table class="table table-hover table-centered mb-0">
                                                            <thead class="table-light">
                                                                <tr>
                                                                    <th>Name</th>
                                                                    <th>Role</th>
                                                                    <th>Join Date</th>
                                                                    <th>Status</th>
                                                                </tr>
                                                            </thead>
                                                            <tbody>
                                                                <?php
                                                                $recentUsers = $conn->query("SELECT name, role, join_date, status FROM users ORDER BY created_at DESC LIMIT 5");
                                                                while ($user = $recentUsers->fetch_assoc()):
                                                                ?>
                                                                <tr>
                                                                    <td><?php echo htmlspecialchars($user['name']); ?></td>
                                                                    <td><span class="badge bg-secondary"><?php echo ucfirst($user['role']); ?></span></td>
                                                                    <td>
                                                                        <?php echo !empty($user['join_date']) ? date('M d, Y', strtotime($user['join_date'])) : 'N/A'; ?>
                                                                    </td>
                                                                    <td>
                                                                        <span class="badge bg-<?php echo $user['status'] == 'active' ? 'success' : 'danger'; ?>">
                                                                            <?php echo ucfirst($user['status']); ?>
                                                                        </span>
                                                                    </td>
                                                                </tr>
                                                                <?php endwhile; ?>
                                                            </tbody>
                                                        </table>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="row">
                        <div class="col-xl-12">
                            <div class="card">
                                <div class="card-body">
                                    <h4 class="header-title mb-4"><i class="ri-projector-2-line"></i> Projects Summary</h4>
                                    <div class="row">
                                        <?php
                                        $totalProjects = $conn->query("SELECT COUNT(*) as total FROM projects")->fetch_assoc()['total'];
                                        $activeProjects = $conn->query("SELECT COUNT(*) as total FROM projects WHERE status='active'")->fetch_assoc()['total'];
                                        $completedProjects = $conn->query("SELECT COUNT(*) as total FROM projects WHERE status='completed'")->fetch_assoc()['total'];
                                        $onHoldProjects = $conn->query("SELECT COUNT(*) as total FROM projects WHERE status='on_hold'")->fetch_assoc()['total'];
                                        ?>
                                        <div class="col-md-3">
                                            <div class="card widget-flat bg-light">
                                                <div class="card-body">
                                                    <div class="float-end"><i class="ri-projector-2-line text-primary icon"></i></div>
                                                    <h5 class="text-muted fw-normal mt-0">Total Projects</h5>
                                                    <h3 class="mt-2 mb-0"><?php echo $totalProjects; ?></h3>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-3">
                                            <div class="card widget-flat bg-light">
                                                <div class="card-body">
                                                    <div class="float-end"><i class="ri-play-circle-line text-success icon"></i></div>
                                                    <h5 class="text-muted fw-normal mt-0">Active</h5>
                                                    <h3 class="mt-2 mb-0"><?php echo $activeProjects; ?></h3>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-3">
                                            <div class="card widget-flat bg-light">
                                                <div class="card-body">
                                                    <div class="float-end"><i class="ri-checkbox-circle-line text-info icon"></i></div>
                                                    <h5 class="text-muted fw-normal mt-0">Completed</h5>
                                                    <h3 class="mt-2 mb-0"><?php echo $completedProjects; ?></h3>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-3">
                                            <div class="card widget-flat bg-light">
                                                <div class="card-body">
                                                    <div class="float-end"><i class="ri-pause-circle-line text-warning icon"></i></div>
                                                    <h5 class="text-muted fw-normal mt-0">On Hold</h5>
                                                    <h3 class="mt-2 mb-0"><?php echo $onHoldProjects; ?></h3>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

<div class="row mt-4">
                                        <div class="col-md-6">
                                            <div class="card">
                                                <div class="card-body">
                                                    <h5 class="card-title"><i class="ri-timer-2-line"></i> Top 5 Ongoing Projects</h5>
                                                    <?php
                                                    $ongoingProjects = $conn->query("
                                                        SELECT p.id, p.name, p.end_date, 
                                                               (SELECT COUNT(*) FROM project_tasks WHERE project_id = p.id) as total_tasks,
                                                               (SELECT COUNT(*) FROM project_tasks WHERE project_id = p.id AND status = 'done') as completed_tasks
                                                        FROM projects p 
                                                        WHERE p.status = 'active' 
                                                        ORDER BY p.end_date ASC 
                                                        LIMIT 5
                                                    ");
                                                    while ($project = $ongoingProjects->fetch_assoc()):
                                                        $progress = $project['total_tasks'] > 0 ? round(($project['completed_tasks'] / $project['total_tasks']) * 100) : 0;
                                                    ?>
                                                    <div class="mb-3">
                                                        <h6><?php echo htmlspecialchars($project['name']); ?></h6>
                                                        <small class="text-muted">
                                                            Due: <?php echo !empty($project['end_date']) ? date('M d, Y', strtotime($project['end_date'])) : 'N/A'; ?>
                                                        </small>
                                                        <div class="progress mt-2">
                                                            <div class="progress-bar bg-success" role="progressbar" style="width: <?php echo $progress; ?>%" aria-valuenow="<?php echo $progress; ?>" aria-valuemin="0" aria-valuemax="100"></div>
                                                        </div>
                                                        <small class="text-muted float-end"><?php echo $progress; ?>% Complete</small>
                                                    </div>
                                                    <?php endwhile; ?>
                                                </div>
                                            </div>
                                        </div>

<div class="col-md-6">
                                            <div class="card">
                                                <div class="card-body">
                                                    <h5 class="card-title"><i class="ri-alarm-warning-line"></i> Project Deadline Alerts</h5>
                                                    <?php
                                                    $deadlineAlerts = $conn->query("
                                                        SELECT p.name, p.end_date 
                                                        FROM projects p 
                                                        WHERE p.status = 'active' 
                                                        AND p.end_date BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 7 DAY)
                                                        ORDER BY p.end_date ASC
                                                    ");
                                                    if ($deadlineAlerts->num_rows > 0) {
                                                        while ($alert = $deadlineAlerts->fetch_assoc()):
                                                            $daysLeft = round((strtotime($alert['end_date']) - time()) / (60 * 60 * 24));
                                                    ?>
                                                    <div class="alert alert-warning alert-dismissible fade show mb-2 p-2" role="alert">
                                                        <strong><?php echo htmlspecialchars($alert['name']); ?></strong> - Due in <b><?php echo $daysLeft; ?></b> days
                                                        <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                                                    </div>
                                                    <?php endwhile;
                                                    } else {
                                                        echo '<div class="alert alert-success">No projects ending in the next 7 days.</div>';
                                                    }
                                                    ?>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="row">
                        <div class="col-xl-12">
                            <div class="card">
                                <div class="card-body">
                                    <h4 class="header-title mb-4"><i class="ri-task-line"></i> Task Overview</h4>
                                    <div class="row">
                                        <div class="col-md-6">
                                            <div class="card">
                                                <div class="card-body">
                                                    <h5 class="card-title"><i class="mdi mdi-chart-pie"></i> Task Status Distribution</h5>
                                                    <div class="table-responsive">
                                                        <table class="table table-hover table-centered mb-0">
                                                            <thead class="table-light">
                                                                <tr>
                                                                    <th>Status</th>
                                                                    <th>Count</th>
                                                                </tr>
                                                            </thead>
                                                            <tbody>
                                                                <?php
                                                                $todo = $conn->query("SELECT COUNT(*) as count FROM project_tasks WHERE status='todo'")->fetch_assoc()['count'];
                                                                $inProgress = $conn->query("SELECT COUNT(*) as count FROM project_tasks WHERE status='in_progress'")->fetch_assoc()['count'];
                                                                $done = $conn->query("SELECT COUNT(*) as count FROM project_tasks WHERE status='done'")->fetch_assoc()['count'];
                                                                ?>
                                                                <tr>
                                                                    <td>To Do</td>
                                                                    <td><span class="badge bg-warning"><?php echo $todo; ?></span></td>
                                                                </tr>
                                                                <tr>
                                                                    <td>In Progress</td>
                                                                    <td><span class="badge bg-primary"><?php echo $inProgress; ?></span></td>
                                                                </tr>
                                                                <tr>
                                                                    <td>Done</td>
                                                                    <td><span class="badge bg-success"><?php echo $done; ?></span></td>
                                                                </tr>
                                                            </tbody>
                                                        </table>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>

<div class="col-md-6">
                                            <div class="card">
                                                <div class="card-body">
                                                    <h5 class="card-title"><i class="ri-calendar-event-line"></i> Upcoming Tasks</h5>
                                                    <ul class="nav nav-tabs nav-bordered mb-3">
                                                        <li class="nav-item">
                                                            <a href="#due-today" data-bs-toggle="tab" class="nav-link active">Due Today</a>
                                                        </li>
                                                        <li class="nav-item">
                                                            <a href="#due-week" data-bs-toggle="tab" class="nav-link">This Week</a>
                                                        </li>
                                                        <li class="nav-item">
                                                            <a href="#overdue" data-bs-toggle="tab" class="nav-link">Overdue</a>
                                                        </li>
                                                    </ul>
                                                    <div class="tab-content">
                                                        
                                                        <div class="tab-pane show active" id="due-today">
                                                            <?php
                                                            $dueToday = $conn->query("
                                                                SELECT t.task_name, t.due_date, p.name as project_name, u.name as assigned_to 
                                                                FROM project_tasks t
                                                                JOIN projects p ON t.project_id = p.id
                                                                JOIN users u ON t.assigned_to = u.id
                                                                WHERE t.due_date = CURDATE()
                                                                AND t.status != 'done'
                                                            ");
                                                            if ($dueToday->num_rows > 0) {
                                                                while ($task = $dueToday->fetch_assoc()):
                                                            ?>
                                                            <div class="d-flex justify-content-between align-items-center border-bottom py-2">
                                                                <div>
                                                                    <h6 class="my-0"><?php echo htmlspecialchars($task['task_name']); ?></h6>
                                                                    <small class="text-muted">Project: <?php echo htmlspecialchars($task['project_name']); ?></small>
                                                                </div>
                                                                <span class="badge bg-primary"><?php echo htmlspecialchars($task['assigned_to']); ?></span>
                                                            </div>
                                                            <?php endwhile;
                                                            } else {
                                                                echo '<div class="alert alert-success mb-0">No tasks due today.</div>';
                                                            }
                                                            ?>
                                                        </div>

<div class="tab-pane" id="due-week">
                                                            <?php
                                                            $dueWeek = $conn->query("
                                                                SELECT t.task_name, t.due_date, p.name as project_name, u.name as assigned_to 
                                                                FROM project_tasks t
                                                                JOIN projects p ON t.project_id = p.id
                                                                JOIN users u ON t.assigned_to = u.id
                                                                WHERE t.due_date BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 7 DAY)
                                                                AND t.status != 'done'
                                                            ");
                                                            if ($dueWeek->num_rows > 0) {
                                                                while ($task = $dueWeek->fetch_assoc()):
                                                            ?>
                                                            <div class="d-flex justify-content-between align-items-center border-bottom py-2">
                                                                <div>
                                                                    <h6 class="my-0"><?php echo htmlspecialchars($task['task_name']); ?></h6>
                                                                    <small class="text-muted">Due: <?php echo date('M d', strtotime($task['due_date'])); ?></small>
                                                                </div>
                                                                <span class="badge bg-primary"><?php echo htmlspecialchars($task['assigned_to']); ?></span>
                                                            </div>
                                                            <?php endwhile;
                                                            } else {
                                                                echo '<div class="alert alert-success mb-0">No tasks due this week.</div>';
                                                            }
                                                            ?>
                                                        </div>

<div class="tab-pane" id="overdue">
                                                            <?php
                                                            $overdue = $conn->query("
                                                                SELECT t.task_name, t.due_date, p.name as project_name, u.name as assigned_to 
                                                                FROM project_tasks t
                                                                JOIN projects p ON t.project_id = p.id
                                                                JOIN users u ON t.assigned_to = u.id
                                                                WHERE t.due_date < CURDATE()
                                                                AND t.status != 'done'
                                                            ");
                                                            if ($overdue->num_rows > 0) {
                                                                while ($task = $overdue->fetch_assoc()):
                                                                    $daysOverdue = round((time() - strtotime($task['due_date'])) / (60 * 60 * 24));
                                                            ?>
                                                            <div class="d-flex justify-content-between align-items-center border-bottom py-2">
                                                                <div>
                                                                    <h6 class="my-0"><?php echo htmlspecialchars($task['task_name']); ?></h6>
                                                                    <small class="text-danger">Overdue by <?php echo $daysOverdue; ?> days</small>
                                                                </div>
                                                                <span class="badge bg-danger"><?php echo htmlspecialchars($task['assigned_to']); ?></span>
                                                            </div>
                                                            <?php endwhile;
                                                            } else {
                                                                echo '<div class="alert alert-success mb-0">No overdue tasks.</div>';
                                                            }
                                                            ?>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="row">
                        <div class="col-xl-12">
                            <div class="card">
                                <div class="card-body">
                                    <h4 class="header-title mb-4"><i class="ri-notification-3-line"></i> Notifications</h4>
                                    <div class="row">
                                        <div class="col-md-4">
                                            <div class="card">
                                                <div class="card-body text-center">
                                                    <h5 class="card-title"><i class="ri-mail-check-line text-warning"></i> New Leave Requests</h5>
                                                    <?php
                                                    $newLeaves = $conn->query("
                                                        SELECT COUNT(*) as count 
                                                        FROM leave_requests 
                                                        WHERE status = 'pending'
                                                        AND DATE(created_at) = CURDATE()
                                                    ")->fetch_assoc()['count'];
                                                    ?>
                                                    <div class="alert alert-<?php echo $newLeaves > 0 ? 'warning' : 'success'; ?> p-2">
                                                        <h5 class="mb-1"><?php echo $newLeaves; ?></h5>
                                                        <small><?php echo $newLeaves == 1 ? 'New Request' : 'New Requests'; ?></small><br>
                                                        <button class="btn btn-sm btn-<?php echo $newLeaves > 0 ? 'warning' : 'success'; ?> mt-2" onclick="toggleTable('leaveRequestsTable')">
                                                            <i class="ri-eye-line"></i> View
                                                        </button>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-4">
                                            <div class="card">
                                                <div class="card-body text-center">
                                                    <h5 class="card-title"><i class="ri-timer-off-line text-danger"></i> Deadline Breaches</h5>
                                                    <?php
                                                    $deadlineBreaches = $conn->query("
                                                        SELECT COUNT(*) as count 
                                                        FROM project_tasks 
                                                        WHERE due_date < CURDATE()
                                                        AND status != 'done'
                                                    ")->fetch_assoc()['count'];
                                                    ?>
                                                    <div class="alert alert-<?php echo $deadlineBreaches > 0 ? 'danger' : 'success'; ?> p-2">
                                                        <h5 class="mb-1"><?php echo $deadlineBreaches; ?></h5>
                                                        <small><?php echo $deadlineBreaches == 1 ? 'Overdue Task' : 'Overdue Tasks'; ?></small><br>
                                                        <button class="btn btn-sm btn-<?php echo $deadlineBreaches > 0 ? 'danger' : 'success'; ?> mt-2" onclick="toggleTable('overdueTasksTable')">
                                                            <i class="ri-eye-line"></i> View
                                                        </button>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-4">
                                            <div class="card">
                                                <div class="card-body text-center">
                                                    <h5 class="card-title"><i class="ri-user-unfollow-line text-warning"></i> Inactive Users</h5>
                                                    <?php
                                                    $inactiveUsers = $conn->query("
                                                        SELECT COUNT(*) as count 
                                                        FROM users 
                                                        WHERE last_activity < DATE_SUB(CURDATE(), INTERVAL 7 DAY)
                                                        OR last_activity IS NULL
                                                    ")->fetch_assoc()['count'];
                                                    ?>
                                                    <div class="alert alert-<?php echo $inactiveUsers > 0 ? 'warning' : 'success'; ?> p-2">
                                                        <h5 class="mb-1"><?php echo $inactiveUsers; ?></h5>
                                                        <small><?php echo $inactiveUsers == 1 ? 'Inactive User' : 'Inactive Users'; ?></small><br>
                                                        <?php if ($inactiveUsers > 0): ?>
                                                        <button class="btn btn-sm btn-warning mt-2" onclick="toggleTable('inactiveUsersTable')">
                                                            <i class="ri-eye-line"></i> View
                                                        </button>
                                                        <?php endif; ?>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

<div id="leaveRequestsTable" class="mt-3" style="display: none;">
                                        <div class="card">
                                            <div class="card-body">
                                                <h5 class="card-title"><i class="ri-mail-line"></i> Pending Leave Requests</h5>
                                                <div class="table-responsive">
                                                    <table class="table table-hover table-centered mb-0">
                                                        <thead class="table-light">
                                                            <tr>
                                                                <th>Employee</th>
                                                                <th>Designation</th>
                                                                <th>Duration</th>
                                                                <th>Reason</th>
                                                                <th>Action</th>
                                                            </tr>
                                                        </thead>
                                                        <tbody>
                                                            <?php
                                                            $pendingLeaves = $conn->query("
                                                                SELECT l.id, l.start_date, l.end_date, l.reason, 
                                                                       u.name as employee_name, u.designation
                                                                FROM leave_requests l
                                                                JOIN users u ON l.employee_id = u.id
                                                                WHERE l.status = 'pending'
                                                                ORDER BY l.created_at DESC
                                                            ");
                                                            while ($leave = $pendingLeaves->fetch_assoc()):
                                                                $duration = round((strtotime($leave['end_date']) - strtotime($leave['start_date'])) / (60 * 60 * 24)) + 1;
                                                            ?>
                                                            <tr>
                                                                <td><?php echo htmlspecialchars($leave['employee_name']); ?></td>
                                                                <td><?php echo htmlspecialchars($leave['designation'] ?? 'N/A'); ?></td>
                                                                <td><?php echo $duration; ?> days</td>
                                                                <td><?php echo htmlspecialchars(substr($leave['reason'], 0, 50)) . '...'; ?></td>
                                                                <td>
                                                                    <a href="approve_leave.php?id=<?php echo $leave['id']; ?>" class="btn btn-sm btn-success">Approve</a>
                                                                    <a href="reject_leave.php?id=<?php echo $leave['id']; ?>" class="btn btn-sm btn-danger">Reject</a>
                                                                </td>
                                                            </tr>
                                                            <?php endwhile; ?>
                                                        </tbody>
                                                    </table>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

<div id="overdueTasksTable" class="mt-3" style="display: none;">
                                        <div class="card">
                                            <div class="card-body">
                                                <h5 class="card-title"><i class="ri-timer-off-line"></i> Overdue Tasks</h5>
                                                <div class="table-responsive">
                                                    <table class="table table-hover table-centered mb-0">
                                                        <thead class="table-light">
                                                            <tr>
                                                                <th>Task</th>
                                                                <th>Project</th>
                                                                <th>Assigned To</th>
                                                                <th>Due Date</th>
                                                                <th>Days Overdue</th>
                                                            </tr>
                                                        </thead>
                                                        <tbody>
                                                            <?php
                                                            $overdueTasks = $conn->query("
                                                                SELECT t.task_name, t.due_date, p.name as project_name, u.name as assigned_to
                                                                FROM project_tasks t
                                                                JOIN projects p ON t.project_id = p.id
                                                                JOIN users u ON t.assigned_to = u.id
                                                                WHERE t.due_date < CURDATE()
                                                                AND t.status != 'done'
                                                                ORDER BY t.due_date ASC
                                                            ");
                                                            while ($task = $overdueTasks->fetch_assoc()):
                                                                $daysOverdue = round((time() - strtotime($task['due_date'])) / (60 * 60 * 24));
                                                            ?>
                                                            <tr>
                                                                <td><?php echo htmlspecialchars($task['task_name']); ?></td>
                                                                <td><?php echo htmlspecialchars($task['project_name']); ?></td>
                                                                <td><?php echo htmlspecialchars($task['assigned_to']); ?></td>
                                                                <td><?php echo date('M d, Y', strtotime($task['due_date'])); ?></td>
                                                                <td><span class="badge bg-danger"><?php echo $daysOverdue; ?></span></td>
                                                            </tr>
                                                            <?php endwhile; ?>
                                                        </tbody>
                                                    </table>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

<div id="inactiveUsersTable" class="mt-3" style="display: none;">
                                        <div class="card">
                                            <div class="card-body">
                                                <h5 class="card-title"><i class="ri-user-unfollow-line"></i> Inactive Users</h5>
                                                <div class="table-responsive">
                                                    <table class="table table-hover table-centered mb-0">
                                                        <thead class="table-light">
                                                            <tr>
                                                                <th>Name</th>
                                                                <th>Role</th>
                                                                <th>Designation</th>
                                                                <th>Last Seen</th>
                                                                <th>Inactive For</th>
                                                            </tr>
                                                        </thead>
                                                        <tbody>
                                                            <?php
                                                            $inactiveUsersList = $conn->query("
                                                                SELECT name, role, designation, last_activity
                                                                FROM users 
                                                                WHERE last_activity < DATE_SUB(CURDATE(), INTERVAL 7 DAY)
                                                                OR last_activity IS NULL
                                                                ORDER BY last_activity ASC
                                                            ");
                                                            while ($user = $inactiveUsersList->fetch_assoc()):
                                                                $lastActive = $user['last_activity'] ? strtotime($user['last_activity']) : null;
                                                                $daysInactive = $lastActive ? round((time() - $lastActive) / (60 * 60 * 24)) : 'Never';
                                                            ?>
                                                            <tr>
                                                                <td><?php echo htmlspecialchars($user['name'] ?? 'N/A'); ?></td>
                                                                <td><span class="badge bg-secondary"><?php echo ucfirst($user['role'] ?? 'unknown'); ?></span></td>
                                                                <td><?php echo htmlspecialchars($user['designation'] ?? 'N/A'); ?></td>
                                                                <td><?php echo isset($lastActive) ? date('M d, Y', $lastActive) : 'Never'; ?></td>
                                                                <td><span class="badge bg-warning"><?php echo htmlspecialchars($daysInactive); ?></span></td>
                                                            </tr>
                                                            <?php endwhile; ?>
                                                        </tbody>
                                                    </table>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

</div> 
            </div> 
        </div> 
    </div>

<script src="js/vendor.min.js"></script>
    <script src="js/app.js"></script>

<script>
        function toggleTable(tableId) {
            // Hide all tables
            document.querySelectorAll('#leaveRequestsTable, #overdueTasksTable, #inactiveUsersTable').forEach(table => {
                table.style.display = 'none';
            });
            // Show selected
            const table = document.getElementById(tableId);
            if (table) {
                table.style.display = table.style.display === 'none' ? 'block' : 'none';
            }
        }
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: hr-dashboard.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation