Working-time records from the access control system, with a fleet module
Automatic working-time reports from UniFi Access door events, trip logs and driver hours from the fleet tracker
- YEAR
- 2026
- CATEGORY
- Software
- STATUS
- LIVE
- CLIENT
- De-Glass and Feba 2000
- TECHNOLOGY
- PHP, JavaScript, UniFi Access webhook, HolaFleet API, Leaflet
The starting point
The sites of De-Glass and Feba 2000 in Miskolc use UniFi Access for access control, and working time had to be derived from the employees' door events: the first entry of the day is the start of work, the last one the end. At first the data was only available from the access log export. The company also uses a fleet tracker, from which they wanted trip logs and mileage records, a live fleet view, and working time for drivers who never badge in at a door. With several sites, these also had to be viewed together.
What we built
- Live data: the access control system sends every door event immediately, and the report refreshes every 5 minutes.
- Log import: the access log export can be loaded and merged with the live data without duplicates, so past data can be backfilled.
- Daily, weekly and monthly views: filtering by employee and period, a timeline within the day with work and break bands, a monthly calendar with public holidays and swapped working days.
- "Arrived today" panel: who has arrived today, by arrival time or alphabetically.
- Printable working-time record fitted to one A4 page.
- Several companies and sites: a separate data store per company, site groups with a combined view.
- Roles: the admin manages everything; a viewer sees only the companies assigned to them.
- Fleet module: live map and vehicle list, printable trip log, driving time, mileage and idle time per driver, one day's route on a map.
- Driver working time: drivers' trips appear in the working-time report as departure and arrival events.
- Privacy: employees' home addresses are masked in the trip log, with admin approval.
- Built-in help explaining both the calculation and the interface.
Integrations and technology
The access control system sends events over HTTPS through the UniFi Access alarm manager to a receiver protected by a separate key per company; the log export can also be loaded. Fleet data comes from the HolaFleet API with automatic daily collection. The front end is plain HTML and JavaScript with no build step, the back end is PHP with session-based login, with no database, using monthly data files. Maps are drawn with Leaflet served from our own hosting. More than 500 automated tests run.
How it went
The first version was built in June 2026, when live event delivery was also tested in production. A second big round came at the end of September: pagination, a monthly calendar, a Hungarian date picker, and the fleet module in two phases (data collection first, the interface the next day). In early October site groups, driver working time, the help pages and fleet permissions went live.
Where it stands
The system is live. Live event delivery, working-time reporting and the fleet module are working; the production setup of site groups and driver assignment is in progress.
