I have an ESSL biometric device already capturing punches at different locations; what I’m missing is a lightweight PHP-MySQL web application that can pull that raw data directly from the machine, store it centrally, and then let me view it in clean, tabular form. Core needs • Real-time data fetching: as soon as an employee clocks in or out, the record should appear in the database without manual imports. • Automated report generation: at the click of a button—or on a scheduled cron—I'd like to produce three specific reports: Daily Attendance, Monthly Attendance Summary, and an Employee Working Hours breakdown. Each report must be downloadable in both EXCEL and PDF. • User authentication & roles: at minimum, an Admin who manages users and settings, an HR role that views all reports, and a standard employee role limited to their own data. Display preferences All data and summaries will be shown in responsive HTML tables. If you structure the code cleanly, adding graphs or charts later should be straightforward, but for now tables are enough. Technical notes • Backend: PHP 8+ with PDO or mysqli. • Database: MySQL 5.7+ (existing server). • Device link: use the official ESSL/ZKTeco SDK or a proven open-source alternative so the app can poll the machine over LAN. • Frontend: vanilla PHP with Bootstrap or a simple CSS framework is fine; no heavy JS frameworks required. • Code should be modular and well-commented; I’ll host it on Apache. Deliverables 1. Complete source code and SQL schema. 2. Step-by-step deployment guide. 3. A short video or screenshots demonstrating real-time syncing and each report. Acceptance will be based on: accurate real-time pulls from the device, correct totals in all three reports, role-based access behaving as described, and clean, responsive tables across desktop and mobile.