View Code - 20260722

user_activity_report.php | 20260722_120325.php Initial Domain Snapshot

<?php
require_once __DIR__ . '/modules/auth/page_acl.php';

$ctx = page_require_access('user_activity_report');

$u = $ctx['user'] ?? null;
$company_id = (int)($ctx['company_id'] ?? 0);
$pdo = $ctx['pdo'] ?? null;

require_once __DIR__ . '/partials/header.php';

if (!$pdo) {
    require_once __DIR__ . '/core/db.php';
}

function h($v)
{
    return htmlspecialchars((string)$v, ENT_QUOTES, 'UTF-8');
}

/* ============================================================
   FILTERS
   ============================================================ */

$from_date = trim($_GET['from_date'] ?? date('Y-m-d'));
$to_date   = trim($_GET['to_date'] ?? date('Y-m-d'));

$user_id   = (int)($_GET['user_id'] ?? 0);

$module    = trim($_GET['module'] ?? '');

$action    = trim($_GET['action'] ?? '');

/* ============================================================
   USERS
   ============================================================ */

$users = [];

$stmtUsers = $pdo->prepare("
    SELECT id, name
    FROM users
    WHERE company_id = ?
    AND is_active = 1
    ORDER BY name ASC
");

$stmtUsers->execute([$company_id]);

$users = $stmtUsers->fetchAll(PDO::FETCH_ASSOC);

/* ============================================================
   QUERY
   ============================================================ */

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

$where[] = "l.company_id = ?";
$params[] = $company_id;

$where[] = "DATE(l.created_at) >= ?";
$params[] = $from_date;

$where[] = "DATE(l.created_at) <= ?";
$params[] = $to_date;

if ($user_id > 0) {

$where[] = "l.user_id = ?";
    $params[] = $user_id;
}

if ($module !== '') {

$where[] = "l.module_name = ?";
    $params[] = $module;
}

if ($action !== '') {

$where[] = "l.activity_type = ?";
    $params[] = $action;
}

$where_sql = implode(' AND ', $where);

/* ============================================================
   FETCH LOGS
   ============================================================ */

$sql = "
SELECT
    l.*,
    u.name AS user_name,
    fr.role_name
FROM user_activity_logs l

LEFT JOIN users u
    ON u.id = l.user_id

LEFT JOIN functional_roles fr
    ON fr.id = l.functional_role_id

WHERE {$where_sql}

ORDER BY l.id DESC

LIMIT 500
";

$stmt = $pdo->prepare($sql);

$stmt->execute($params);

$logs = $stmt->fetchAll(PDO::FETCH_ASSOC);

/* ============================================================
   SUMMARY
   ============================================================ */

$total_logs = count($logs);

$create_count = 0;
$update_count = 0;
$delete_count = 0;
$export_count = 0;
$print_count  = 0;

foreach ($logs as $r) {

switch (strtolower($r['activity_type'])) {

case 'create':
            $create_count++;
            break;

case 'update':
            $update_count++;
            break;

case 'delete':
            $delete_count++;
            break;

case 'export':
            $export_count++;
            break;

case 'print':
            $print_count++;
            break;
    }
}
?>

<h4 class="mb-0">
                User Activity Report
            </h4>

</div>

</div>

</div>

<option value="">
                            All Users
                        </option>

<?php foreach ($users as $usr): ?>

<?php endforeach; ?>

</select>

</div>

<label class="form-label">
                        Module
                    </label>

<input
                        type="text"
                        name="module"
                        class="form-control"
                        value="<?= h($module) ?>"
                        placeholder="payment"
                    >

</div>

<label class="form-label">
                        Action
                    </label>

<?php
                        $actions = [
                            'create',
                            'update',
                            'delete',
                            'export',
                            'print',
                            'approve',
                            'status_change',
                        ];
                        ?>

<?php foreach ($actions as $ac): ?>

<?php endforeach; ?>

</select>

</div>

<button
                        type="submit"
                        class="btn btn-primary w-100"
                    >
                        Search
                    </button>

</div>

</form>

<h6>Total Logs</h6>

</div>

<h6>Create</h6>

</div>

<h6>Update</h6>

</div>

<h6>Delete</h6>

</div>

<h6>Export</h6>

</div>

<h6>Print</h6>

</div>

<tr>

<th>
                            Module
                        </th>

<th>
                            Action
                        </th>

<th>
                            Description
                        </th>

</tr>

</thead>

<tbody>

<?php if ($logs): ?>

<?php foreach ($logs as $row): ?>

<tr>

<td>

<?php
                                    $badge = 'secondary';

switch ($row['activity_type']) {

case 'create':
                                            $badge = 'success';
                                            break;

case 'update':
                                            $badge = 'warning';
                                            break;

case 'delete':
                                            $badge = 'danger';
                                            break;

case 'export':
                                            $badge = 'info';
                                            break;

case 'print':
                                            $badge = 'primary';
                                            break;
                                    }
                                    ?>

</td>

</tr>

<?php endforeach; ?>

<?php else: ?>

<tr>

<td
                                colspan="9"
                                class="text-center py-4"
                            >
                                No activity logs found.
                            </td>

</tr>

<?php endif; ?>

</tbody>

</table>

</div>

<?php require_once __DIR__ . '/partials/footer.php'; ?>