[BE-51] Implement Reports module — GET /reports/summary for dashboard and reports page

[yusuftomilola]

Overview

This is the most urgently needed backend endpoint. The frontend dashboard (frontend/app/(dashboard)/dashboard/page.tsx) and reports page (frontend/app/(dashboard)/reports/page.tsx) both call GET /reports/summary. Without it, these pages show nothing. The dashboard is the first thing users see after login.

Context

• Frontend API: frontend/lib/api/reports.ts getSummary() calls GET /reports/summary
• Frontend React Query hook: frontend/lib/query/hooks/useReports.ts useReportsSummary
• Expected response shape (from frontend types): { total, byStatus: { ACTIVE, ASSIGNED, MAINTENANCE, RETIRED }, byCategory: [{ name, count }], byDepartment: [{ name, count }], recentAssets: Asset[], totalValue: number }
• All queries must use TypeORM aggregate functions — not multiple round-trips

Acceptance Criteria

• Create ReportsModule, ReportsController, ReportsService
• GET /reports/summary — single endpoint performing: total asset count, count grouped by status (all 4 statuses), count grouped by category.name (top 10), count grouped by department.name (all), sum of currentValue as totalValue, 10 most recently created assets with relations
• Apply RBAC scoping: MANAGER only sees their department's data; ADMIN sees all
• Apply Redis cache (CacheInterceptor) with 5-minute TTL; invalidate on any asset write operation
• Register ReportsModule in AppModule
• Protect with JwtAuthGuard

[Danielobito009]

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

i want to work on this issue, please assign me.

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

[walexjnr]

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

Hi can i work on this task?

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

[drips-wave]

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

🧑‍💻 @walexjnr: 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 🌊