Skip to content
All projects
In productionAttendance & workforce SaaS · 2025–2026

Docházka SaaS

Attendance, shifts and staff admin with QR check-in hardware, grown from one client's system into a multi-tenant SaaS.

🔒 Private repositorynasmene.cz ↗

01 The problem

A seasonal visitor attraction with many part-time workers tracked attendance on paper and in chat messages. Payroll, advances and shift checklists took manual work every month, and nobody had a reliable audit trail.

02 What it does

  • Check-in and check-out via QR code, with an ESP32 device that shows a rotating QR code on site.
  • Shift checklists, manual corrections with an audit log, announcements and wage advances.
  • Monthly exports for payroll; installable as a PWA on staff phones.
  • SaaS fork: tenant isolation through Postgres row-level security, per-tenant onboarding, backup and restore scripts.

03 Architecture

  1. 01 DeviceESP32 firmware rendering the check-in QR code
  2. 02 WebNext.js 16 + React 19, PWA
  3. 03 BackendSupabase: Postgres, auth, RLS policies scoped by tenant_id in the JWT
  4. 04 Data90+ SQL migrations, audit log tables
  5. 05 OpsDocker, Caddy per tenant, scripted onboarding and restores

04 Stack

Next.jsReactTypeScriptSupabasePostgreSQL RLSPWAESP32 / ArduinoDockerCaddy

05 How I worked with AI

The single-tenant version grew feature by feature with agents, driven by real feedback from staff. The move to multi-tenancy was planned up front: I wrote the tenancy model and the RLS rules, then agents migrated the queries in batches while CI and tests checked that no query could cross tenants.

06 What is verified

  • Single-tenant version runs in production for a client (confirmed from the production deployment copy).
  • SaaS fork: GitHub Actions CI, 12 test files, 94 migrations.
  • ESP32 QR display firmware is part of the repository.

07 Honest notes

  • The SaaS variant does not serve the original client yet; it is a parallel fork in active development.

08 Screenshots

Overview: who is at work now, live attendance, approvals and staffing for next week
Weekly shift planning by position, with shift cancellation requests
Daily checks: check-in, check-out and shift checklists
Payroll: hours, rates, advances and amounts to pay out
Employee view on a phone: current shift, checklist, advance request
Next projectNightshift