index
Project · Paused

LEONAPP

A digital platform that replaced paper focaccine vouchers at Istituto Leone XIII with authenticated QR redemption, a verifiable consumption ledger, and a billing pipeline that reconciles into the school's tuition system.

Role
Co-author · co-founder
With
Niccolò Pagano
Status
Paused
License
Apache 2.0

Paper vouchers were losable, forgeable, dependent on students remembering them in the morning, and cost the secretariat real time every day. We rebuilt the whole workflow — from purchase to redemption to monthly billing — as a web platform authenticated against the school's own Google Workspace. The platform is currently on pause pending successor handover.

Three surfaces

Student · leonapp.it

  • Google Workspace sign-in
  • One-click block purchase (10 vouchers)
  • QR shown at the counter
  • Monthly cap · charged to tuition

Staff · scan.leonapp.it

  • Camera-based QR scan
  • Real-time validation
  • Last-5 scan history
  • Role-scoped access

Admin · amministrazione.leonapp.it

  • Enrolment & parental consent
  • Monthly billing export (xlsx)
  • Audit trail & access logs
  • Downloadable records

Stack

PHP · JavaScript · MySQL on Ubuntu 22.04 / Apache. Hosted on a small OVH VPS (2 vCore, 4 GB RAM) — ≈ €12/month all-in. TLS via ZeroSSL with an automated 90-day renewal. Mail routed through the school's domain. Eleven tables: users, tickets, purchases, consumptions, scanners, OAuth, accesses, downloadables, downloads, enablements, sent emails.

Governance

What I'm proudest of isn't the code — it's that the project was set up to outlive its founders. A written committee charter hands decision rights from graduating co-founders to a standing body of student representatives, an IT-department seat, and emergency-replacement provisions from the administration. LEONAPP will keep running when Niccolò and I are long gone.

On the roadmap

→ Public repo on GitHub