File Manager

✏️ n/activity_logs.php

<?php
// admin/activity_logs.php - Admin Audit Log Viewer
require_once '../includes/db.php';
require_once '../includes/auth.php';
requireModuleAccess('MAIN'); // Only MAIN admins can see audit logs

// Handle Filter/Search
$module_filter = $_GET['module'] ?? '';
$action_filter = $_GET['action'] ?? '';
$search = sanitize($_GET['search'] ?? '');

$where = [];
$params = [];

if ($module_filter) {
    $where[] = "module = ?";
    $params[] = $module_filter;
}
if ($action_filter) {
    $where[] = "action = ?";
    $params[] = $action_filter;
}
$date_from = $_GET['date_from'] ?? '';
$date_to   = $_GET['date_to'] ?? '';
if ($date_from && preg_match('/^\d{4}-\d{2}-\d{2}$/', $date_from)) {
    $where[] = "created_at >= ?";
    $params[] = $date_from . ' 00:00:00';
}
if ($date_to && preg_match('/^\d{4}-\d{2}-\d{2}$/', $date_to)) {
    $where[] = "created_at <= ?";
    $params[] = $date_to . ' 23:59:59';
}
// If search term is present, we don't filter SQL WHERE because description and IP address
// are encrypted at rest; we comprehensively filter all fields in PHP post-decryption.

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

// ── Pagination settings ───────────────────────────────────────────────────
$per_page_options = [10, 15, 25, 50, 100];
$per_page = (int)($_GET['per_page'] ?? 15);
if (!in_array($per_page, $per_page_options, true)) $per_page = 15;
$page = max(1, (int)($_GET['page'] ?? 1));

// Fetch matching rows (description is encrypted at rest, so the final
// search filtering happens in PHP after decryption)
$query = "SELECT * FROM activity_logs $where_clause ORDER BY created_at DESC LIMIT 2000";
$stmt = $pdo->prepare($query);
$stmt->execute($params);
$logs = decryptRowsForTable('activity_logs', $stmt->fetchAll());
if ($search) {
    $search_lower = strtolower($search);
    $logs = array_values(array_filter($logs, function ($log) use ($search_lower) {
        return strpos(strtolower((string)($log['description'] ?? '')), $search_lower) !== false
            || strpos(strtolower((string)($log['user_name'] ?? '')), $search_lower) !== false
            || strpos(strtolower((string)($log['target_name'] ?? '')), $search_lower) !== false
            || strpos(strtolower((string)($log['ip_address'] ?? '')), $search_lower) !== false
            || strpos(strtolower((string)($log['action'] ?? '')), $search_lower) !== false
            || strpos(strtolower((string)($log['module'] ?? '')), $search_lower) !== false;
    }));
}

$total_matching = count($logs);
$total_pages = max(1, (int)ceil($total_matching / $per_page));
$page = min($page, $total_pages);
$offset = ($page - 1) * $per_page;
$logs_page = array_slice($logs, $offset, $per_page);
$range_start = $total_matching > 0 ? $offset + 1 : 0;
$range_end = min($offset + $per_page, $total_matching);

/**
 * Renders compact numbered pagination controls for the audit table.
 */
function renderAuditPager($page, $total_pages) {
    if ($total_pages <= 1) return '';
    $btn = function ($p, $label, $active = false, $disabled = false) {
        $cls = 'audit-pager-btn' . ($active ? ' active' : '');
        if ($disabled) return '<button type="button" class="' . $cls . '" disabled style="opacity:0.4;cursor:not-allowed;">' . $label . '</button>';
        return '<button type="button" class="' . $cls . '" data-page="' . $p . '">' . $label . '</button>';
    };
    $html = '<div class="audit-pager" style="display:flex; justify-content:center; align-items:center; gap:6px; padding:16px; flex-wrap:wrap;">';
    $html .= $btn($page - 1, '<i class="fa-solid fa-chevron-left"></i>', false, $page <= 1);
    $start = max(1, $page - 2);
    $end = min($total_pages, $page + 2);
    if ($start > 1) {
        $html .= $btn(1, '1');
        if ($start > 2) $html .= '<span style="color:#94a3b8;">…</span>';
    }
    for ($i = $start; $i <= $end; $i++) {
        $html .= $btn($i, (string)$i, $i === $page);
    }
    if ($end < $total_pages) {
        if ($end < $total_pages - 1) $html .= '<span style="color:#94a3b8;">…</span>';
        $html .= $btn($total_pages, (string)$total_pages);
    }
    $html .= $btn($page + 1, '<i class="fa-solid fa-chevron-right"></i>', false, $page >= $total_pages);
    $html .= '</div>';
    return $html;
}

// Get unique modules and actions for filters
$modules = ['MAIN', 'EMPLOYEES', 'ATTENDANCE', 'LEAVES', 'FINANCE', 'OPERATIONS', 'LEARNING', 'SUPPORT', 'REPORTS'];
$actions = ['CREATE', 'UPDATE', 'DELETE', 'APPROVE', 'REJECT', 'LOGIN', 'LOGOUT'];

// Fetch Stats for top banner
$total_today = 0;
$critical_actions = 0;
$admin_actions = 0;
$unique_users = 0;
try {
    $total_today = $pdo->query("SELECT COUNT(*) FROM activity_logs WHERE DATE(created_at) = CURDATE()")->fetchColumn() ?: 0;
    $critical_actions = $pdo->query("SELECT COUNT(*) FROM activity_logs WHERE action IN ('DELETE', 'REJECT') AND DATE(created_at) = CURDATE()")->fetchColumn() ?: 0;
    $admin_actions = $pdo->query("SELECT COUNT(*) FROM activity_logs WHERE user_type = 'Admin' AND DATE(created_at) = CURDATE()")->fetchColumn() ?: 0;
    $unique_users = $pdo->query("SELECT COUNT(DISTINCT user_name) FROM activity_logs WHERE DATE(created_at) = CURDATE()")->fetchColumn() ?: 0;
} catch (Exception $e) {}

// Handle CSV Export (respects active filters)
if (isset($_GET['export']) && $_GET['export'] === 'csv') {
    $exp_stmt = $pdo->prepare("SELECT * FROM activity_logs $where_clause ORDER BY created_at DESC LIMIT 5000");
    $exp_stmt->execute($params);
    $export_rows = decryptRowsForTable('activity_logs', $exp_stmt->fetchAll());
    if ($search) {
        $search_lower = strtolower($search);
        $export_rows = array_values(array_filter($export_rows, function ($log) use ($search_lower) {
            return strpos(strtolower((string)($log['description'] ?? '')), $search_lower) !== false
                || strpos(strtolower((string)($log['user_name'] ?? '')), $search_lower) !== false
                || strpos(strtolower((string)($log['target_name'] ?? '')), $search_lower) !== false
                || strpos(strtolower((string)($log['ip_address'] ?? '')), $search_lower) !== false
                || strpos(strtolower((string)($log['action'] ?? '')), $search_lower) !== false
                || strpos(strtolower((string)($log['module'] ?? '')), $search_lower) !== false;
        }));
    }

header('Content-Type: text/csv; charset=utf-8');
    header('Content-Disposition: attachment; filename="audit_logs_' . date('Ymd_His') . '.csv"');
    $out = fopen('php://output', 'w');
    fwrite($out, "\xEF\xBB\xBF"); // UTF-8 BOM for Excel
    fputcsv($out, ['Date/Time', 'User Type', 'User', 'Action', 'Module', 'Description', 'IP Address']);
    foreach ($export_rows as $row) {
        fputcsv($out, [
            date('d M Y, h:i A', strtotime($row['created_at'])),
            $row['user_type'] ?? '',
            $row['user_name'] ?? '',
            $row['action'] ?? '',
            $row['module'] ?? '',
            $row['description'] ?? '',
            $row['ip_address'] ?? '',
        ]);
    }
    fclose($out);

logActivity('EXPORT', 'MAIN', 'Exported ' . count($export_rows) . ' audit log entries to CSV');
    exit;
}

// Handle AJAX filter request
if (isset($_GET['ajax'])) {
    header('Content-Type: application/json');
    ob_start();
    ?>
    <?php if (empty($logs)): ?>
        <div class="empty-state-wrapper">
            <i class="fa-solid fa-clipboard-list empty-state-icon"></i>
            <h4 class="empty-state-title">No Activity Logs Found</h4>
            <p class="empty-state-desc">There are no recorded actions matching your filters.</p>
        </div>
    <?php else: ?>
        <div class="audit-feed-head">
            <span>Showing <strong><?= number_format($range_start) ?>–<?= number_format($range_end) ?></strong> of <strong><?= number_format($total_matching) ?></strong> matching entries</span>
        </div>
        <?= render_audit_feed($logs_page) ?>
        <?= renderAuditPager($page, $total_pages) ?>
    <?php endif; ?>
    <?php
    $table_html = ob_get_clean();
    echo json_encode([
        'success' => true,
        'table_html' => $table_html,
        'stats' => [
            'total_today' => $total_today,
            'critical_actions' => $critical_actions,
            'admin_actions' => $admin_actions,
            'unique_users' => $unique_users
        ]
    ]);
    exit;
}

function getActionBadgeStyle($action) {
    switch(strtoupper($action)) {
        case 'CREATE': return 'background: #d1fae5; color: #065f46; border: 1px solid #a7f3d0;'; // Soft Green
        case 'UPDATE': return 'background: #fef3c7; color: #92400e; border: 1px solid #fde68a;'; // Soft Amber
        case 'DELETE': return 'background: #fee2e2; color: #991b1b; border: 1px solid #fecaca;'; // Soft Red
        case 'APPROVE': return 'background: #dbeafe; color: #1e40af; border: 1px solid #bfdbfe;'; // Soft Blue
        case 'REJECT': return 'background: #ffe4e6; color: #9f1239; border: 1px solid #fecdd3;'; // Soft Rose
        case 'LOGIN': return 'background: #ede9fe; color: #5b21b6; border: 1px solid #ddd6fe;'; // Soft Purple
        case 'LOGOUT': return 'background: #f3f4f6; color: #374151; border: 1px solid #e5e7eb;'; // Soft Gray
        default: return 'background: #f1f5f9; color: #475569; border: 1px solid #e2e8f0;'; // Soft Slate
    }
}

function audit_time_ago($datetime) {
    $diff = time() - strtotime($datetime);
    if ($diff < 60) return 'just now';
    if ($diff < 3600) return floor($diff / 60) . 'm ago';
    if ($diff < 86400) return floor($diff / 3600) . 'h ago';
    if ($diff < 604800) return floor($diff / 86400) . 'd ago';
    return date('d M Y', strtotime($datetime));
}

function audit_avatar_color($name) {
    $colors = ['#1e8731', '#0284c7', '#6d28d9', '#d97706', '#0f766e', '#be185d'];
    $h = 0;
    for ($i = 0; $i < strlen((string)$name); $i++) { $h = ($h * 31 + ord($name[$i])) % 100000; }
    return $colors[$h % count($colors)];
}

// Shared feed-style renderer used by both the initial page and AJAX filters
function render_audit_feed($logs_page) {
    $html = '<div class="audit-feed">';
    foreach ($logs_page as $log) {
        $name = $log['user_name'] ?? 'System';
        $parts = preg_split('/\s+/', trim($name));
        $initials = strtoupper(substr($parts[0] ?? '?', 0, 1) . substr($parts[1] ?? '', 0, 1));
        $isAdmin = ($log['user_type'] ?? '') === 'Admin';
        $desc = htmlspecialchars($log['description'] ?? '-', ENT_QUOTES);
        $html .= '
        <div class="audit-row">
            <div class="audit-avatar" style="background:' . audit_avatar_color($name) . '">' . htmlspecialchars($initials) . '</div>
            <div class="audit-main">
                <div class="audit-top">
                    <span class="audit-name">' . htmlspecialchars($name) . '</span>
                    <span class="audit-utype ' . ($isAdmin ? 'is-admin' : 'is-emp') . '">' . htmlspecialchars($log['user_type'] ?? 'System') . '</span>
                    <span class="audit-badge" style="' . getActionBadgeStyle($log['action'] ?? '') . '">' . htmlspecialchars($log['action'] ?? '-') . '</span>
                    <span class="audit-module">' . htmlspecialchars($log['module'] ?? 'GENERAL') . '</span>
                </div>
                <div class="audit-desc" title="' . $desc . '">' . $desc . '</div>
            </div>
            <div class="audit-meta">
                <div class="audit-time"><i class="fa-regular fa-clock"></i> ' . audit_time_ago($log['created_at']) . '</div>
                <div class="audit-ip">' . date('d M Y, h:i A', strtotime($log['created_at'])) . '</div>
                <div class="audit-ip"><i class="fa-solid fa-globe"></i> ' . htmlspecialchars($log['ip_address'] ?? '—') . '</div>
            </div>
        </div>';
    }
    $html .= '</div>';
    return $html;
}
?>
<?php include_once '../includes/header.php'; ?>
    <style>
        .filters-card {
            background: var(--card-bg);
            border-radius: 12px;
            padding: 1.5rem;
            margin-bottom: 2rem;
            box-shadow: 0 4px 6px -1px rgba(0, 0, 0, 0.05);
            display: flex;
            gap: 1rem;
            align-items: center;
            flex-wrap: wrap;
        }
        
        .user-type-admin { color: #f59e0b; font-weight: 600; }
        .user-type-employee { color: var(--primary); font-weight: 600; }
        
        .description-cell {
            max-width: 300px;
            white-space: nowrap;
            overflow: hidden;
            text-overflow: ellipsis;
        }

@media (max-width: 768px) {
            .filters-card form {
                flex-direction: column !important;
                align-items: stretch !important;
                gap: 10px !important;
            }
            .filters-card select,
            .filters-card input,
            .filters-card button,
            .filters-card a {
                width: 100% !important;
                text-align: center !important;
                justify-content: center !important;
            }
            .page-header {
                flex-direction: column !important;
                align-items: flex-start !important;
                gap: 12px !important;
            }
            .page-header button {
                width: 100% !important;
            }
        }
        
        .pagination {
            display: flex;
            justify-content: center;
            gap: 0.5rem;
            padding: 1.5rem;
        }
        .page-link {
            padding: 0.5rem 1rem;
            border: 1px solid var(--border-color);
            border-radius: 6px;
            color: var(--text-dark);
            text-decoration: none;
            font-weight: 500;
            transition: all 0.2s ease;
        }
        .page-link:hover {
            background: #f1f5f9;
        }
        .page-link.active {
            background: var(--primary);
            color: white;
            border-color: var(--primary);
        }
        
        .empty-state {
            text-align: center;
            padding: 3rem;
            color: var(--text-muted);
        }
        .empty-state i {
            font-size: 3rem;
            margin-bottom: 1rem;
            color: #cbd5e1;
        }
        
        .btn-clear-filter {
            background: #ffffff;
            border: 1.5px solid #e5e7eb;
            color: #4b5563;
            text-decoration: none;
            padding: 0 18px;
            height: 42px;
            border-radius: 8px;
            font-weight: 600;
            display: inline-flex;
            align-items: center;
            gap: 5px;
            box-sizing: border-box;
            line-height: 42px;
            transition: all 0.2s ease;
            cursor: pointer;
        }
        .btn-clear-filter:hover {
            background: #f9fafb;
            border-color: #d1d5db;
            color: #1f2937 !important;
        }

/* Audit pagination buttons */
        .audit-pager-btn {
            padding: 6px 12px;
            border: 1px solid #e5e7eb;
            background: #fff;
            border-radius: 8px;
            cursor: pointer;
            font-weight: 600;
            font-size: 0.8rem;
            font-family: inherit;
            color: #374151;
            min-width: 34px;
            transition: all 0.15s ease;
        }
        .audit-pager-btn:hover:not(:disabled) { background: #f1f5f9; border-color: #cbd5e1; }
        .audit-pager-btn.active { background: #1e8731; color: #fff; border-color: #1e8731; }

/* ── Audit feed (MNC list UI) ── */
        .audit-feed-head {
            padding: 14px 22px 10px;
            font-size: 0.8rem;
            color: #64748b;
            border-bottom: 1px solid #f1f5f9;
        }
        .audit-feed-head strong { color: #1e8731; }
        .audit-row {
            display: flex; align-items: flex-start; gap: 14px;
            padding: 13px 22px;
            border-bottom: 1px solid #f5f7f5;
            transition: background .15s ease;
        }
        .audit-row:hover { background: #f8fdf8; }
        .audit-row:last-child { border-bottom: none; }
        .audit-avatar {
            flex: none; width: 38px; height: 38px; border-radius: 11px;
            color: #fff; font-size: 0.78rem; font-weight: 800;
            display: flex; align-items: center; justify-content: center;
            margin-top: 2px;
        }
        .audit-main { flex: 1; min-width: 0; }
        .audit-top { display: flex; align-items: center; gap: 8px; flex-wrap: wrap; }
        .audit-name { font-weight: 700; color: #0f172a; font-size: 0.88rem; }
        .audit-utype {
            font-size: 0.62rem; font-weight: 800; letter-spacing: .8px; text-transform: uppercase;
            padding: 2px 7px; border-radius: 999px;
        }
        .audit-utype.is-admin { background: #ede9fe; color: #6d28d9; }
        .audit-utype.is-emp { background: #e0f2fe; color: #0369a1; }
        .audit-badge {
            font-size: 0.68rem; font-weight: 800; padding: 3px 9px;
            border-radius: 999px; letter-spacing: .3px; display: inline-block;
        }
        .audit-module {
            font-size: 0.68rem; font-weight: 700; color: #64748b;
            background: #f8fafc; border: 1px solid #e2e8f0;
            padding: 2px 8px; border-radius: 999px;
        }
        .audit-desc {
            font-size: 0.84rem; color: #475569; line-height: 1.5; margin-top: 4px;
            overflow: hidden; text-overflow: ellipsis; white-space: nowrap;
        }
        .audit-meta { flex: none; text-align: right; }
        .audit-time { font-size: 0.75rem; font-weight: 600; color: #1e8731; white-space: nowrap; }
        .audit-ip { font-size: 0.7rem; color: #94a3b8; margin-top: 2px; white-space: nowrap; }
        .audit-ip i { width: 11px; }
        @media (max-width: 640px) {
            .audit-row { flex-wrap: wrap; }
            .audit-meta { text-align: left; width: 100%; display: flex; gap: 14px; }
        }
    </style>
        <div class="page-header">
            <div>
                <div class="breadcrumb" style="font-size:0.8rem; color:var(--text-muted); margin-bottom:4px; display:flex; align-items:center; gap:6px;">
                    <a href="<?= url('admin/dashboard') ?>" style="color:var(--text-muted); text-decoration:none;"><i class="fa-solid fa-house"></i> Home</a>
                    <span style="color:#cbd5e1;">/</span>
                    <span style="color:var(--primary-green); font-weight:600;">Audit Logs</span>
                </div>
                <h1>System Audit Logs</h1>
                <p class="page-header__description">Comprehensive immutable audit trail of administrative actions, data changes, and security events.</p>
            </div>
            <div style="display: flex; gap: 10px; flex-wrap: wrap;">
                <button class="btn btn-secondary" id="btnExportLogs"><i class="fa-solid fa-file-csv"></i> Export CSV</button>
                <button class="btn btn-primary" id="btnRefreshLogs"><i class="fa-solid fa-arrows-rotate"></i> Refresh Logs</button>
            </div>
        </div>

<div class="stats-grid">
            <div class="stat-card">
                <div class="stat-info">
                    <h3>Logs Today</h3>
                    <p id="stat-logs-today"><?= $total_today ?></p>
                </div>
                <div class="kpi-icon-container kpi-theme-info">
                    <i class="fa-solid fa-clipboard-list"></i>
                </div>
            </div>
            
            <div class="stat-card">
                <div class="stat-info">
                    <h3>Critical Today</h3>
                    <p id="stat-critical-actions" style="color: #d32f2f;"><?= $critical_actions ?></p>
                </div>
                <div class="kpi-icon-container kpi-theme-danger">
                    <i class="fa-solid fa-triangle-exclamation"></i>
                </div>
            </div>
            
            <div class="stat-card">
                <div class="stat-info">
                    <h3>Admin Actions Today</h3>
                    <p id="stat-admin-actions"><?= $admin_actions ?></p>
                </div>
                <div class="kpi-icon-container kpi-theme-success">
                    <i class="fa-solid fa-user-shield"></i>
                </div>
            </div>
            
            <div class="stat-card">
                <div class="stat-info">
                    <h3>Unique Users</h3>
                    <p id="stat-unique-users"><?= $unique_users ?></p>
                </div>
                <div class="kpi-icon-container kpi-theme-purple">
                    <i class="fa-solid fa-users"></i>
                </div>
            </div>
        </div>

<div class="form-group flex-1" style="margin-bottom:0; min-width:250px;">
                    <label>Search</label>
                    <div class="global-search-wrapper search-full">
                        <i class="fa-solid fa-magnifying-glass global-search-icon"></i>
                        <input type="text" id="auditSearchInput" name="search" class="global-search-input" placeholder="Search logs by user, action, or IP..." aria-label="Search logs by user, action, or IP" value="<?= htmlspecialchars($search) ?>">
                    </div>
                </div>

<div class="form-group" style="margin-bottom:0; min-width:160px; max-width:180px;">
                    <label>Module</label>
                    <select name="module" class="form-input cdd-no-search">
                        <option value="">All Modules</option>
                        <?php foreach ($modules as $mod): ?>
                            <option value="<?= htmlspecialchars($mod) ?>" <?= $module_filter === $mod ? 'selected' : '' ?>><?= htmlspecialchars($mod) ?></option>
                        <?php endforeach; ?>
                    </select>
                </div>

<div class="form-group" style="margin-bottom:0; min-width:140px; max-width:160px;">
                    <label>Action</label>
                    <select name="action" class="form-input cdd-no-search">
                        <option value="">All Actions</option>
                        <?php foreach ($actions as $act): ?>
                            <option value="<?= htmlspecialchars($act) ?>" <?= $action_filter === $act ? 'selected' : '' ?>><?= htmlspecialchars($act) ?></option>
                        <?php endforeach; ?>
                    </select>
                </div>

<div class="form-group" style="margin-bottom:0; min-width:150px; max-width:165px;">
                    <label>From Date</label>
                    <input type="date" name="date_from" class="form-input" value="<?= htmlspecialchars($date_from) ?>" max="<?= date('Y-m-d') ?>">
                </div>
                <div class="form-group" style="margin-bottom:0; min-width:150px; max-width:165px;">
                    <label>To Date</label>
                    <input type="date" name="date_to" class="form-input" value="<?= htmlspecialchars($date_to) ?>" max="<?= date('Y-m-d') ?>">
                </div>

<div class="form-group" style="margin-bottom:0; min-width:120px; max-width:140px;">
                    <label>Show</label>
                    <select name="per_page" class="form-input">
                        <?php foreach ($per_page_options as $opt): ?>
                            <option value="<?= $opt ?>" <?= $per_page === $opt ? 'selected' : '' ?>><?= $opt ?> entries</option>
                        <?php endforeach; ?>
                    </select>
                </div>

<div class="filter-btn-group" style="display:flex; gap:10px; padding-bottom:1px;">
                    <a href="activity_logs" class="btn btn-outline filter-btn btn-clear-filter" style="height:auto; line-height:normal; padding:10px 20px; border:1.5px solid var(--primary-green); color:var(--primary-green); background:transparent;"><i class="fa-solid fa-undo"></i> Reset</a>
                </div>
            </form>
        </div>

<div class="table-card">
            <?php if (empty($logs)): ?>
                <div class="empty-state-wrapper">
                    <i class="fa-solid fa-clipboard-list empty-state-icon"></i>
                    <h4 class="empty-state-title">No Activity Logs Found</h4>
                    <p class="empty-state-desc">There are no recorded actions matching your filters.</p>
                </div>
            <?php else: ?>
                <div class="audit-feed-head">
                    <span>Showing <strong><?= number_format($range_start) ?>–<?= number_format($range_end) ?></strong> of <strong><?= number_format($total_matching) ?></strong> matching entries</span>
                </div>
                <?= render_audit_feed($logs_page) ?>
                <?= renderAuditPager($page, $total_pages) ?>
            <?php endif; ?>
        </div>
<script>
$(document).ready(function() {
    // Dropdowns are auto-enhanced by the portal CDD system (search included).
    // AJAX Filter function
    var typingTimer;
    var _logsAjaxBusy = false;   // prevents overlapping requests / out-of-order table swaps
    var _logsPage = 1;           // current page for pagination
    function filterLogs(force, page) {
        if (_logsAjaxBusy && !force) return;
        if (page) _logsPage = parseInt(page, 10) || 1; else if (page === undefined) _logsPage = 1;
        _logsAjaxBusy = true;
        var search = $('#auditSearchInput').val();
        var module = $('select[name="module"]').val();
        var action = $('select[name="action"]').val();
        var dateFrom = $('input[name="date_from"]').val();
        var dateTo = $('input[name="date_to"]').val();
        var perPage = $('select[name="per_page"]').val() || 15;

// Show subtle loading state on the table container
        $('.table-card').css('opacity', '0.5');

$.ajax({
            url: 'activity_logs.php',
            method: 'GET',
            data: {
                ajax: 1,
                search: search,
                module: module,
                action: action,
                date_from: dateFrom,
                date_to: dateTo,
                per_page: perPage,
                page: _logsPage
            },
            dataType: 'json',
            success: function(response) {
                $('.table-card').css('opacity', '1');
                if (response.success) {
                    // Update table contents
                    $('.table-card').html(response.table_html);
                    
                    // Update stats counters dynamically
                    $('#stat-logs-today').text(response.stats.total_today);
                    $('#stat-critical-actions').text(response.stats.critical_actions);
                    $('#stat-admin-actions').text(response.stats.admin_actions);
                    $('#stat-unique-users').text(response.stats.unique_users);
                }
            },
            error: function() {
                $('.table-card').css('opacity', '1');
            },
            complete: function() {
                _logsAjaxBusy = false;
            }
        });
    }

// Automatically trigger AJAX filter when Select2 values change
    $('select[name="module"], select[name="action"]').on('change', function() {
        filterLogs();
    });

// Automatically trigger AJAX filter when date range changes
    $('input[name="date_from"], input[name="date_to"]').on('change', function() {
        filterLogs();
    });

// Entries-per-page change → back to page 1 and refetch
    $('select[name="per_page"]').on('change', function() {
        filterLogs();
    });

// Pagination clicks (delegated — table HTML is replaced on every AJAX refresh)
    $('.table-card').on('click', '.audit-pager-btn', function(e) {
        e.preventDefault();
        if ($(this).prop('disabled')) return;
        filterLogs(true, $(this).data('page'));
    });

// Debounce keyboard search inputs (filters automatically as the user types!)
    $('#auditSearchInput').on('input', function() {
        clearTimeout(typingTimer);
        typingTimer = setTimeout(filterLogs, 300);
    });

// Prevent default form submit (e.g. when pressing enter inside search field)
    $('.filters-card form').on('submit', function(e) {
        e.preventDefault();
        clearTimeout(typingTimer);
        filterLogs();
    });

// Handle AJAX Reset button action
    $('.btn-clear-filter').on('click', function(e) {
        e.preventDefault();
        $('select[name="module"]').val('').trigger('change');
        $('select[name="action"]').val('').trigger('change');
        $('#auditSearchInput').val('');
        $('input[name="date_from"]').val('');
        $('input[name="date_to"]').val('');
        clearTimeout(typingTimer);
        filterLogs(true);
    });

// Handle CSV Export — respects the currently active filters
    $('#btnExportLogs').on('click', function(e) {
        e.preventDefault();
        var params = new URLSearchParams();
        params.set('export', 'csv');
        if ($('#auditSearchInput').val()) params.set('search', $('#auditSearchInput').val());
        if ($('select[name="module"]').val()) params.set('module', $('select[name="module"]').val());
        if ($('select[name="action"]').val()) params.set('action', $('select[name="action"]').val());
        if ($('input[name="date_from"]').val()) params.set('date_from', $('input[name="date_from"]').val());
        if ($('input[name="date_to"]').val()) params.set('date_to', $('input[name="date_to"]').val());
        window.location.href = 'activity_logs.php?' + params.toString();
    });

// Handle AJAX Refresh Logs button action
    $('#btnRefreshLogs').on('click', function(e) {
        e.preventDefault();
        filterLogs(true);
    });

// Live auto-refresh: pull new audit entries every 30s so the trail reflects
    // recent actions without a manual reload. Pauses when the tab is hidden or
    // while the user is typing in the search box.
    var _logsAutoRefresh = setInterval(function() {
        // Page left via PJAX navigation — stop polling
        if ($('#btnRefreshLogs').length === 0) { clearInterval(_logsAutoRefresh); return; }
        if (document.hidden) return;
        if ($('#auditSearchInput').is(':focus')) return;
        filterLogs(true);
    }, 30000);

// 3. Typing animation on Audit Search Input
    var auditPlaceholders = [
        "Search by user (e.g. Admin)...",
        "Search by action (e.g. DELETE)...",
        "Search by description...",
        "Search by IP address..."
    ];
    var auditIdx = 0;
    var auditCharIdx = 0;
    var auditDeleting = false;
    var auditTimer = null;
    var isAuditFocused = false;

function typeAuditEffect() {
        if (isAuditFocused) return;
        var input = $('#auditSearchInput');
        if (input.length === 0) return;

var fullText = auditPlaceholders[auditIdx];
        if (auditDeleting) {
            input.attr('placeholder', fullText.substring(0, auditCharIdx - 1));
            auditCharIdx--;
            typeSpeed = 45;
        } else {
            input.attr('placeholder', fullText.substring(0, auditCharIdx + 1));
            auditCharIdx++;
            typeSpeed = 80;
        }

if (!auditDeleting && auditCharIdx === fullText.length) {
            auditDeleting = true;
            typeSpeed = 2200;
        } else if (auditDeleting && auditCharIdx === 0) {
            auditDeleting = false;
            auditIdx = (auditIdx + 1) % auditPlaceholders.length;
            typeSpeed = 400;
        }

auditTimer = setTimeout(typeAuditEffect, typeSpeed);
    }

// Start typing effect on search box
    setTimeout(typeAuditEffect, 800);

$('#auditSearchInput').on('focus', function() {
        isAuditFocused = true;
        clearTimeout(auditTimer);
        $(this).attr('placeholder', 'Type here to search and press Enter...');
    }).on('blur', function() {
        isAuditFocused = false;
        auditCharIdx = 0;
        auditDeleting = false;
        clearTimeout(auditTimer);
        typeAuditEffect();
    });
});
</script>
</div>
<?php include_once '../includes/footer.php'; ?>

Batal

⬅ public_html 28 item

Nama	Tipe	Ukuran	Diubah	Aksi
🐘activity_logs.php	php	32.4 KB	2026-09-10 03:24	✏️ 👁️
🐘announcements.php	php	37.4 KB	2026-09-10 03:24	✏️ 👁️
🐘asset_details.php	php	14 KB	2026-09-10 03:24	✏️ 👁️
🐘asset_issues.php	php	14.4 KB	2026-09-10 03:24	✏️ 👁️
🐘assets.php	php	33.7 KB	2026-09-10 03:24	✏️ 👁️
🐘attendance.php	php	76.2 KB	2026-09-10 03:24	✏️ 👁️
🐘dashboard.php	php	139.7 KB	2026-09-10 03:24	✏️ 👁️
🐘departments.php	php	41 KB	2026-09-10 03:24	✏️ 👁️
🐘documents.php	php	80.1 KB	2026-09-10 03:24	✏️ 👁️
🐘drive_allocations.php	php	25.3 KB	2026-09-10 03:24	✏️ 👁️
🐘employees.php	php	136.1 KB	2026-09-10 03:24	✏️ 👁️
🐘holidays.php	php	25.9 KB	2026-09-10 03:24	✏️ 👁️
🐘leave_types.php	php	7.5 KB	2026-09-10 03:24	✏️ 👁️
🐘leaves.php	php	29.9 KB	2026-09-10 03:24	✏️ 👁️
🐘login.php	php	125 B	2026-09-10 03:24	✏️ 👁️
🐘logout.php	php	125 B	2026-09-10 03:24	✏️ 👁️
🐘offboarding.php	php	37.6 KB	2026-09-10 03:24	✏️ 👁️
🐘password_wallet.php	php	118.1 KB	2026-09-10 03:24	✏️ 👁️
🐘process.php	php	28.6 KB	2026-09-10 03:24	✏️ 👁️
🐘profile.php	php	61.3 KB	2026-09-10 03:24	✏️ 👁️
🐘project_details.php	php	139.5 KB	2026-09-10 03:24	✏️ 👁️
🐘projects.php	php	137.3 KB	2026-09-10 03:24	✏️ 👁️
🐘reports.php	php	20.4 KB	2026-09-10 03:24	✏️ 👁️
🐘security_logs.php	php	44.7 KB	2026-09-10 03:24	✏️ 👁️
🐘shifts.php	php	38.8 KB	2026-09-10 03:24	✏️ 👁️
🐘team_hub.php	php	12.1 KB	2026-09-10 03:24	✏️ 👁️
🐘view-employee.php	php	159.6 KB	2026-09-10 03:24	✏️ 👁️
🐘work_hours.php	php	41.6 KB	2026-09-10 03:24	✏️ 👁️

✏️ Rename