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/vasancomputer.com/public_html/admin

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: activity_log.php

<?php
require_once '../config.php';
require_once '../config/database.php';
session_start();

if (!isset($_SESSION['user_id']) || $_SESSION['user_type'] !== 'admin') {
    header('Location: ../login.php');
    exit();
}

$page_title = 'Activity Log - Admin Panel';

$conn = getDBConnection();

// Pagination
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$limit = 50;
$offset = ($page - 1) * $limit;

// Filters
$user_filter = isset($_GET['user_id']) ? $_GET['user_id'] : '';
$action_filter = isset($_GET['action']) ? $_GET['action'] : '';
$date_from = isset($_GET['date_from']) ? $_GET['date_from'] : '';
$date_to = isset($_GET['date_to']) ? $_GET['date_to'] : '';

$where = [];
$params = [];
$types = '';

if ($user_filter) {
    $where[] = "user_id = ?";
    $params[] = $user_filter;
    $types .= 'i';
}
if ($action_filter) {
    $where[] = "action_type = ?";
    $params[] = $action_filter;
    $types .= 's';
}
if ($date_from) {
    $where[] = "DATE(created_at) >= ?";
    $params[] = $date_from;
    $types .= 's';
}
if ($date_to) {
    $where[] = "DATE(created_at) <= ?";
    $params[] = $date_to;
    $types .= 's';
}

$where_clause = $where ? 'WHERE ' . implode(' AND ', $where) : '';

// Get total count
$count_sql = "SELECT COUNT(*) as total FROM activity_log $where_clause";
$count_stmt = $conn->prepare($count_sql);
if ($params) {
    $count_stmt->bind_param($types, ...$params);
}
$count_stmt->execute();
$total = $count_stmt->get_result()->fetch_assoc()['total'];
$total_pages = ceil($total / $limit);

// Get activities
$sql = "SELECT a.*, u.username, u.full_name 
        FROM activity_log a 
        LEFT JOIN users u ON a.user_id = u.id 
        $where_clause 
        ORDER BY a.created_at DESC 
        LIMIT ? OFFSET ?";
$params[] = $limit;
$params[] = $offset;
$types .= 'ii';

$stmt = $conn->prepare($sql);
$stmt->bind_param($types, ...$params);
$stmt->execute();
$activities = $stmt->get_result();

// Get users for filter
$users = $conn->query("SELECT id, username, full_name FROM users ORDER BY full_name");

// Get unique action types
$actions = $conn->query("SELECT DISTINCT action_type FROM activity_log ORDER BY action_type");
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <?php include '../includes/head.php'; ?>
    <style>
        .log-table {
            font-size: 0.9rem;
        }
        .log-details {
            max-width: 300px;
            white-space: nowrap;
            overflow: hidden;
            text-overflow: ellipsis;
        }
        .log-details:hover {
            white-space: normal;
            word-wrap: break-word;
        }
        .action-badge {
            padding: 0.25rem 0.75rem;
            border-radius: 50px;
            font-size: 0.75rem;
            font-weight: 500;
        }
        .action-add { background: #d1fae5; color: #065f46; }
        .action-update { background: #dbeafe; color: #1e40af; }
        .action-delete { background: #fee2e2; color: #991b1b; }
        .action-login { background: #f3e8ff; color: #6b21a8; }
    </style>
</head>
<body>
    <?php include '../sections/admin_header.php'; ?>
    
    <div class="container-fluid">
        <div class="row">
            <?php include '../sections/admin_sidebar.php'; ?>
            
            <main class="col-md-9 ms-sm-auto col-lg-10 px-md-4 py-4">
                <h1 class="h2 mb-4">Activity Log</h1>
                
                
                <div class="card border-0 shadow-sm rounded-4 mb-4">
                    <div class="card-body p-4">
                        <form method="GET" class="row g-3">
                            <div class="col-md-3">
                                <label class="form-label">User</label>
                                <select name="user_id" class="form-select">
                                    <option value="">All Users</option>
                                    <?php while($user = $users->fetch_assoc()): ?>
                                    <option value="<?php echo $user['id']; ?>" <?php echo $user_filter == $user['id'] ? 'selected' : ''; ?>>
                                        <?php echo $user['full_name']; ?> (<?php echo $user['username']; ?>)
                                    </option>
                                    <?php endwhile; ?>
                                </select>
                            </div>
                            <div class="col-md-3">
                                <label class="form-label">Action Type</label>
                                <select name="action" class="form-select">
                                    <option value="">All Actions</option>
                                    <?php while($action = $actions->fetch_assoc()): ?>
                                    <option value="<?php echo $action['action_type']; ?>" <?php echo $action_filter == $action['action_type'] ? 'selected' : ''; ?>>
                                        <?php echo ucfirst(str_replace('_', ' ', $action['action_type'])); ?>
                                    </option>
                                    <?php endwhile; ?>
                                </select>
                            </div>
                            <div class="col-md-2">
                                <label class="form-label">From Date</label>
                                <input type="date" name="date_from" class="form-control" value="<?php echo $date_from; ?>">
                            </div>
                            <div class="col-md-2">
                                <label class="form-label">To Date</label>
                                <input type="date" name="date_to" class="form-control" value="<?php echo $date_to; ?>">
                            </div>
                            <div class="col-md-2 d-flex align-items-end">
                                <button type="submit" class="btn btn-primary w-100">
                                    <i class="bi bi-funnel me-2"></i>Filter
                                </button>
                            </div>
                        </form>
                    </div>
                </div>
                
                
                <div class="card border-0 shadow-sm rounded-4">
                    <div class="card-body p-4">
                        <div class="table-responsive">
                            <table class="table log-table table-hover align-middle">
                                <thead>
                                    <tr>
                                        <th>Time</th>
                                        <th>User</th>
                                        <th>Action</th>
                                        <th>Description</th>
                                        <th>IP Address</th>
                                        <th>Page</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php while($log = $activities->fetch_assoc()): ?>
                                    <tr>
                                        <td>
                                            <small><?php echo date('d M Y', strtotime($log['created_at'])); ?></small>
                                            <br>
                                            <small class="text-secondary"><?php echo date('h:i A', strtotime($log['created_at'])); ?></small>
                                        </td>
                                        <td>
                                            <?php if($log['full_name']): ?>
                                            <span class="fw-semibold"><?php echo $log['full_name']; ?></span>
                                            <br>
                                            <small class="text-secondary">@<?php echo $log['username']; ?></small>
                                            <?php else: ?>
                                            <span class="text-secondary">System</span>
                                            <?php endif; ?>
                                        </td>
                                        <td>
                                            <span class="action-badge action-<?php 
                                                echo explode('_', $log['action_type'])[0]; 
                                            ?>">
                                                <?php echo ucfirst(str_replace('_', ' ', $log['action_type'])); ?>
                                            </span>
                                        </td>
                                        <td>
                                            <div class="log-details" title="<?php echo htmlspecialchars($log['description']); ?>">
                                                <?php echo htmlspecialchars($log['description']); ?>
                                            </div>
                                            <?php if($log['data_changes']): ?>
                                            <button class="btn btn-sm btn-link p-0" onclick="viewChanges(<?php echo htmlspecialchars($log['data_changes']); ?>)">
                                                <small>View changes</small>
                                            </button>
                                            <?php endif; ?>
                                        </td>
                                        <td>
                                            <small><?php echo $log['ip_address']; ?></small>
                                            <br>
                                            <small class="text-secondary"><?php echo $log['user_agent'] ? 'Browser' : ''; ?></small>
                                        </td>
                                        <td>
                                            <small class="text-secondary"><?php echo basename($log['page_url']); ?></small>
                                        </td>
                                    </tr>
                                    <?php endwhile; ?>
                                </tbody>
                            </table>
                        </div>
                        
                        
                        <?php if($total_pages > 1): ?>
                        <nav class="mt-4">
                            <ul class="pagination justify-content-center">
                                <li class="page-item <?php echo $page <= 1 ? 'disabled' : ''; ?>">
                                    <a class="page-link" href="?page=<?php echo $page-1; ?>&user_id=<?php echo $user_filter; ?>&action=<?php echo $action_filter; ?>&date_from=<?php echo $date_from; ?>&date_to=<?php echo $date_to; ?>">Previous</a>
                                </li>
                                <?php for($i = 1; $i <= $total_pages; $i++): ?>
                                <li class="page-item <?php echo $i == $page ? 'active' : ''; ?>">
                                    <a class="page-link" href="?page=<?php echo $i; ?>&user_id=<?php echo $user_filter; ?>&action=<?php echo $action_filter; ?>&date_from=<?php echo $date_from; ?>&date_to=<?php echo $date_to; ?>"><?php echo $i; ?></a>
                                </li>
                                <?php endfor; ?>
                                <li class="page-item <?php echo $page >= $total_pages ? 'disabled' : ''; ?>">
                                    <a class="page-link" href="?page=<?php echo $page+1; ?>&user_id=<?php echo $user_filter; ?>&action=<?php echo $action_filter; ?>&date_from=<?php echo $date_from; ?>&date_to=<?php echo $date_to; ?>">Next</a>
                                </li>
                            </ul>
                        </nav>
                        <?php endif; ?>
                    </div>
                </div>
            </main>
        </div>
    </div>
    
    
    <div class="modal fade" id="changesModal" tabindex="-1">
        <div class="modal-dialog">
            <div class="modal-content rounded-4">
                <div class="modal-header border-0">
                    <h5 class="modal-title fw-bold">Data Changes</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>
                <div class="modal-body p-4">
                    <pre id="changesData" class="bg-light p-3 rounded-3" style="max-height: 400px; overflow: auto;"></pre>
                </div>
            </div>
        </div>
    </div>
    
    <script>
    function viewChanges(data) {
        document.getElementById('changesData').textContent = JSON.stringify(data, null, 2);
        new bootstrap.Modal(document.getElementById('changesModal')).show();
    }
    </script>
    
    <?php include '../sections/footer.php'; ?>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: activity_log.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation