[BE-54] Implement scheduled report delivery — subscribe to automatic email reports on a cron schedule

[yusuftomilola]

Overview

Managers should receive automated report digests (weekly asset summary, monthly depreciation report) without needing to log in to the platform. Users subscribe to a report schedule and receive it by email on the configured frequency.

Context

• Depends on BE-40 (ScheduleModule), BE-07 (MailService), BE-51–53 (report data and export)
• Report schedules are per-user — each user configures their own subscriptions

Acceptance Criteria

• Create ReportSchedule entity: id, userId, reportType (enum: SUMMARY, WARRANTY_EXPIRING, MAINTENANCE_COSTS, DEPRECIATION), frequency (DAILY|WEEKLY|MONTHLY), format (PDF|EXCEL), isActive, lastSentAt, nextSendAt (computed from frequency), createdAt
• POST /reports/schedules — creates a subscription and sets nextSendAt
• GET /reports/schedules — current user's active schedules
• PATCH /reports/schedules/:id — toggle active, change frequency or format
• DELETE /reports/schedules/:id
• Add daily cron in TasksService: find schedules where nextSendAt <= now and isActive = true; generate the report via ExportService, email as attachment, update lastSentAt and nextSendAt

[teeschima]

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

Hi hi....good day Mr Suleiman, can I be handed the honour of working with this project sir. I have previous experience on this subject matter and repo as well sir.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @teeschima 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 🌊