← All work
Client · Backoffice and IoT

Hubwater — Backoffice and reporting

Laravel backoffice for managing IoT water dispensers and producing sustainability reports.

Role
Full-stack development and infrastructure
Status
Active engagement
Stack
Laravel 11 · Filament · MariaDB · MongoDB · Redis · AWS · Puppeteer

The challenge

The report generation system, inherited from a previous team, had been down for months: zero-value data, unstable job queues and no staging environment to test fixes.

The solution

Rebuilt report generation: new multi-page PDF templates with dynamic monthly chunking, flexible period selection in Filament, fixed queries and aggregations, resolved queue issues. Set up a staging environment on AWS EC2.

How it works

  1. 01Dispenser data
  2. 02Aggregation by period
  3. 03PDF template
  4. 04Automatic delivery to the client

Outcome

  • Report generation restored after months of downtime.
  • Multi-page templates with free period selection.
  • Staging environment to test before release.
  • Client signature and automatic report delivery by email.

Have a similar problem?

Tell me about the workflow that costs you time. I reply within one business day.

Get in touch