forked from BRETT/BRETT
kibiandClaude Opus 5.5
06ac414457
New audit_log table records actor, action, target and a JSON snapshot of the details, so entries stay readable after the target is deleted; the actor is set to NULL when the user is removed. logAudit() is called from upload delete (single and bulk), comment delete, tag removal, role create/delete, role permission changes, role assign/revoke and MOTD updates. Logging failures only warn and never fail the action itself. The admin page gets an audit card behind the new audit.view permission with action filter, click-to-filter by user, readable summaries per action and server-side pagination. Action catalog lives in shared/utils/audit.ts, labels under admin.auditActions (de/en). Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
45 lines
1.8 KiB
TypeScript
45 lines
1.8 KiB
TypeScript
import { eq, inArray } from 'drizzle-orm'
|
|
import { z } from 'zod'
|
|
import { PERMISSION_KEYS } from '../../../../../shared/utils/permissions'
|
|
import { permissions, rolePermissions, roles } from '../../../../db/schema'
|
|
|
|
const bodySchema = z.object({
|
|
permissions: z.array(z.string()).max(50),
|
|
})
|
|
|
|
export default defineEventHandler(async (event) => {
|
|
const actor = await requirePermission(event, 'roles.manage')
|
|
const id = Number(getRouterParam(event, 'id'))
|
|
if (!Number.isInteger(id) || id <= 0) {
|
|
throw createError({ statusCode: 400, statusMessage: 'Ungültige ID' })
|
|
}
|
|
const { permissions: keys } = await readValidatedBody(event, bodySchema.parse)
|
|
if (keys.some(k => !PERMISSION_KEYS.includes(k))) {
|
|
throw createError({ statusCode: 400, statusMessage: 'Unbekannte Berechtigung' })
|
|
}
|
|
|
|
const db = useDb()
|
|
const [role] = await db.select({ name: roles.name }).from(roles).where(eq(roles.id, id)).limit(1)
|
|
if (!role) {
|
|
throw createError({ statusCode: 404, statusMessage: 'Rolle nicht gefunden' })
|
|
}
|
|
if (role.name === 'admin') {
|
|
throw createError({ statusCode: 400, statusMessage: 'Die Admin-Rolle hat immer alle Berechtigungen' })
|
|
}
|
|
|
|
const previous = await getRolePermissions().then(m => m.get(id) ?? [])
|
|
await db.delete(rolePermissions).where(eq(rolePermissions.roleId, id))
|
|
if (keys.length) {
|
|
const rows = await db.select({ id: permissions.id }).from(permissions).where(inArray(permissions.key, keys))
|
|
if (rows.length) {
|
|
await db.insert(rolePermissions).values(rows.map(r => ({ roleId: id, permissionId: r.id })))
|
|
}
|
|
}
|
|
await logAudit(actor.id, 'update_role_permissions', { type: 'role', id }, {
|
|
name: role.name,
|
|
added: keys.filter(k => !previous.includes(k)),
|
|
removed: previous.filter(k => !keys.includes(k)),
|
|
})
|
|
return { ok: true }
|
|
})
|