FM / routes

/home/techb158/workloadmatch.com/api/routes/

/home/techb158/workloadmatch.com/api/routes

Name	Size	Mode	Actions
ai_generate.php	11642	0644	edit dl rm
assignments.php	9931	0644	edit dl rm
auth.php	6697	0644	edit dl rm
chat.php	9934	0644	edit dl rm
courses.php	7225	0644	edit dl rm
coursesessions.php	6705	0644	edit dl rm
dashboard.php	6232	0644	edit dl rm
groups.php	11099	0644	edit dl rm
logs.php	3587	0644	edit dl rm
managers.php	9612	0644	edit dl rm
masters.php	6685	0644	edit dl rm
notifications.php	5975	0644	edit dl rm
preferences.php	6487	0644	edit dl rm
programs.php	4882	0644	edit dl rm
reports.php	13696	0644	edit dl rm
roles.php	8516	0644	edit dl rm
schedules.php	11042	0644	edit dl rm
settings.php	4295	0644	edit dl rm
teachers.php	16013	0644	edit dl rm
timeslots.php	4807	0644	edit dl rm

Edit: /home/techb158/workloadmatch.com/api/routes/logs.php (3587B)

<?php

function listLogs(mysqli $mysqli): void
{
    Auth::requireAnyRole(['admin_profile', 'master_profile', 'manager_profile']);
    [$page, $perPage, $offset] = getPagination();
    [$sort, $dir] = getSort('created_at', 'DESC');

$allowedSort = ['id', 'created_at', 'user_id', 'action', 'target_type', 'status'];
    if (!in_array($sort, $allowedSort)) $sort = 'created_at';

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

if (!empty($_GET['user_id'])) {
        $wheres[] = 'user_id = ?';
        $params[] = $_GET['user_id'];
        $types   .= 's';
    }
    if (!empty($_GET['action'])) {
        $wheres[] = 'action = ?';
        $params[] = $_GET['action'];
        $types   .= 's';
    }
    if (!empty($_GET['target_type'])) {
        $wheres[] = 'target_type = ?';
        $params[] = $_GET['target_type'];
        $types   .= 's';
    }
    if (!empty($_GET['status'])) {
        $wheres[] = 'status = ?';
        $params[] = $_GET['status'];
        $types   .= 's';
    }

$whereClause = $wheres ? 'WHERE ' . implode(' AND ', $wheres) : '';

$total = 0;
    $sql = "SELECT COUNT(*) FROM activity_logs $whereClause";
    $stmt = $mysqli->prepare($sql);
    if ($params) $stmt->bind_param($types, ...$params);
    $stmt->execute();
    $stmt->bind_result($total);
    $stmt->fetch();
    $stmt->close();

$sql = "SELECT * FROM activity_logs $whereClause ORDER BY $sort $dir LIMIT ? OFFSET ?";
    $stmt = $mysqli->prepare($sql);
    $bindParams = array_merge($params, [$perPage, $offset]);
    $bindTypes = $types . 'ii';
    if ($bindParams) $stmt->bind_param($bindTypes, ...$bindParams);
    $stmt->execute();
    $result = $stmt->get_result();
    $items = $result->fetch_all(MYSQLI_ASSOC);
    $stmt->close();

Response::paginated($items, $total, $page, $perPage);
}

function getLog(string $id, mysqli $mysqli): void
{
    Auth::requireAnyRole(['admin_profile', 'master_profile']);
    $stmt = $mysqli->prepare("SELECT * FROM activity_logs WHERE id = ?");
    $stmt->bind_param('i', $id);
    $stmt->execute();
    $result = $stmt->get_result();
    $item = $result->fetch_assoc();
    $stmt->close();

if (!$item) Response::notFound('Log entry not found');
    Response::success($item);
}

function deleteLog(?string $id, mysqli $mysqli): void
{
    Auth::requireRole('admin_profile');
    if (!$id) Response::error('Log ID required');

$stmt = $mysqli->prepare("DELETE FROM activity_logs WHERE id = ?");
    $stmt->bind_param('i', $id);
    $stmt->execute();
    $stmt->close();

Response::success(null, 'Log entry deleted');
}

function clearLogs(mysqli $mysqli): void
{
    Auth::requireRole('admin_profile');

$before = $_GET['before'] ?? date('Y-m-d', strtotime('-30 days'));

$stmt = $mysqli->prepare("DELETE FROM activity_logs WHERE created_at < ?");
    $stmt->bind_param('s', $before);
    $stmt->execute();
    $deleted = $mysqli->affected_rows;
    $stmt->close();

Response::success(null, "Deleted $deleted log entries older than $before");
}

prepare($sql); if ($params) $stmt->bind_param($types, ...$params); $stmt->execute(); $stmt->bind_result($total); $stmt->fetch(); $stmt->close(); $sql = "SELECT * FROM activity_logs $whereClause ORDER BY $sort $dir LIMIT ? OFFSET ?"; $stmt = $mysqli->prepare($sql); $bindParams = array_merge($params, [$perPage, $offset]); $bindTypes = $types . 'ii'; if ($bindParams) $stmt->bind_param($bindTypes, ...$bindParams); $stmt->execute(); $result = $stmt->get_result(); $items = $result->fetch_all(MYSQLI_ASSOC); $stmt->close(); Response::paginated($items, $total, $page, $perPage); } function getLog(string $id, mysqli $mysqli): void { Auth::requireAnyRole(['admin_profile', 'master_profile']); $stmt = $mysqli->prepare("SELECT * FROM activity_logs WHERE id = ?"); $stmt->bind_param('i', $id); $stmt->execute(); $result = $stmt->get_result(); $item = $result->fetch_assoc(); $stmt->close(); if (!$item) Response::notFound('Log entry not found'); Response::success($item); } function deleteLog(?string $id, mysqli $mysqli): void { Auth::requireRole('admin_profile'); if (!$id) Response::error('Log ID required'); $stmt = $mysqli->prepare("DELETE FROM activity_logs WHERE id = ?"); $stmt->bind_param('i', $id); $stmt->execute(); $stmt->close(); Response::success(null, 'Log entry deleted'); } function clearLogs(mysqli $mysqli): void { Auth::requireRole('admin_profile'); $before = $_GET['before'] ?? date('Y-m-d', strtotime('-30 days')); $stmt = $mysqli->prepare("DELETE FROM activity_logs WHERE created_at < ?"); $stmt->bind_param('s', $before); $stmt->execute(); $deleted = $mysqli->affected_rows; $stmt->close(); Response::success(null, "Deleted $deleted log entries older than $before"); }