Repository Public
1/**2 * =============================================================================3 * SP BOUCHER | ACADEMIC RESEARCH4 * ARTIFICIAL INTELLIGENCE • FINANCE • ENGINEERING5 * =============================================================================6 *7 * PROJECT METADATA8 * -----------------------------------------------------------------------------9 * Project : UQO Éval10 * File : src/app/api/metre/admin/audit/route.ts11 * Module : app12 * Repository : https://git.spboucher.ai/uqo-eval13 * Project Website : https://www.uqo-eval.app14 * Created : 2026-10-2815 * Last Modified : 2026-10-2816 *17 * =============================================================================18 * SOFTWARE MAINTAINER & AFFILIATION19 * =============================================================================20 *21 * Maintainer : Simon-Pierre Boucher22 * Position : Professor of Finance23 * Institution : Université du Québec en Outaouais (UQO)24 * Department : Département des sciences administratives25 * Website : https://spboucher.ai26 * Git : https://git.spboucher.ai27 *28 * Research Contact : research@spboucher.ai29 * Direct Contact : simon@spboucher.ai30 * Security/Admin : admin@spboucher.ai31 *32 * The affiliation is descriptive. It is not an institutional endorsement,33 * a license grant or a determination of ownership.34 *35 * =============================================================================36 * COPYRIGHT, AUTHORSHIP & DATA37 * =============================================================================38 *39 * Copyright (c) the author(s) of this work.40 * Ownership is not asserted by this notice; see the repository records.41 *42 * This header identifies the maintainer of the software. Scientific43 * authorship of any associated paper is stated in the paper itself and44 * is not changed by this notice. Datasets and third-party materials45 * remain the property of their respective owners and licensors.46 *47 * This file is governed by the applicable project license, copyright48 * notices, institutional agreements and relevant law.49 *50 * =============================================================================51 * LICENSE & MAINTENANCE52 * =============================================================================53 *54 * License : None specified (no license file in this repository)55 * Classification : Public56 *57 * =============================================================================58 * END OF SP BOUCHER SOURCE HEADER59 * =============================================================================60 */6162// UQO Éval — Métré : journal d'audit (admin : tout ; enseignant : ses projets et ceux de ses étudiants).63import { NextRequest, NextResponse } from "next/server";64import { handle, projectAccess, requireUser } from "@/lib/metre/auth";6566export const runtime = "nodejs";6768export async function GET(req: NextRequest) {69 return handle(() => {70 const ctx = requireUser(req, { roles: ["instructor", "admin"] });71 const sp = req.nextUrl.searchParams;72 const limit = Math.min(500, Number(sp.get("limit") ?? 200) || 200);73 const project = sp.get("project");74 let rows = ctx.db.prepare(`SELECT a.id, a.at, a.user_id userId, u.display_name userName, a.role, a.action, a.entity_type entityType, a.entity_id entityId, a.project_id projectId, a.details_json details, a.ip FROM metre_audit_events a LEFT JOIN metre_users u ON u.id=a.user_id ${project ? "WHERE a.project_id=?" : ""} ORDER BY a.id DESC LIMIT ?`).all(...(project ? [project, limit] : [limit])) as { projectId: string | null; ip: string | null }[];75 if (ctx.user.role !== "admin") rows = rows.filter((r) => r.projectId && projectAccess(ctx.db, ctx.user, r.projectId)).map((r) => ({ ...r, ip: null }));76 return NextResponse.json({ events: rows });77 });78}79