[BE-67] Build Audit Log viewer endpoint — searchable, filterable history of all system changes

[yusuftomilola]

Overview

While AssetHistory records exist for asset-level changes, there is no unified audit trail covering all entity types (users, departments, roles, locations). Compliance and security teams need a single endpoint to query what changed, who changed it, and when.

Context

• An AuditLog entity may partially exist from prior PRs — verify before creating a new one
• Every write operation across all modules should append an audit record
• The endpoint must support pagination and multiple filter dimensions simultaneously

Acceptance Criteria

• Create (or verify) AuditLog entity: id, entityType (e.g., asset, user, department), entityId, action (CREATED, UPDATED, DELETED, STATUS_CHANGED, ROLE_CHANGED), actorId (FK → User), previousValue (JSON), newValue (JSON), ipAddress, userAgent, createdAt
• Create an AuditService.log() method and call it from AssetsService, UsersService, DepartmentsService, and AuthService on every mutating operation
• GET /audit-logs (ADMIN only): accepts query params — entityType, entityId, actorId, action, from (date), to (date), page, limit
• GET /audit-logs/:id — returns full detail of a single log entry including the JSON diff
• Response includes actor's firstName and lastName (not just ID)
• Apply caching with a short TTL (30 seconds) on the list endpoint

[Peolite001]

@Peolite001 has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

i would love to work on this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Peolite001 to this issue.

[SharifIbrahimDev]

@SharifIbrahimDev has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

Hi @maintainer, I'd like to work on [BE-67] Build Audit Log Viewer Endpoint. I have experience building NestJS backend services with pagination, filtering, caching, and audit logging. I'll verify the existing AuditLog implementation, extend it where necessary, create a reusable AuditService, integrate audit logging across all mutating operations, and implement secure, searchable endpoints with pagination, caching, and detailed responses that satisfy all the acceptance criteria.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @SharifIbrahimDev to this issue.

[KuchiMercy]

@KuchiMercy has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

Hi, I'd like to work on this issue. Kindly assign.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @KuchiMercy to this issue.

[drips-wave]

Congratulations, @KuchiMercy! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on July 30, 2026.

🧑‍💻 @KuchiMercy: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊

[grantfox-oss]

🎉 This issue has been marked as completed on GrantFox as part of the Official Campaign | FWC26 campaign!

@KuchiMercy's PR #1249 was approved and merged by @yusuftomilola.

🏆 @KuchiMercy: You earned 35 FoxPoints for this contribution! Your current tier: Explorer (452 total points). Track your full progress on GrantFox.

👏 Great work, @KuchiMercy! Keep contributing to DistinctCodes.

[drips-wave]

This issue has been completed by @KuchiMercy as part of the Stellar Wave Program's 7th Wave 🥳

😎 @KuchiMercy: You earned 200 Points for completing this issue! After the current Wave ends, you'll be eligible for a percentage of the Wave's reward pool based on the percentage of total points you've earned. Learn more here. You can also Leave a review to share your experience working on this issue.

🧑‍💻 Repo maintainers: How'd the contributor do? Leave a review to share your experience working with them.