OJT & Attendance Tracking System

A high-integrity Progressive Web App (PWA) featuring GPS geofencing, QR code validation, offline sync, and real-time administrative analytics.

Overview & Architecture

OJT Tracking & Attendance Management System is a full-stack Progressive Web App (PWA) built to modernize and streamline trainee attendance verification. Designed to replace manual logbooks with tamper-resistant validation, the platform enforces dual-layer attendance verification combining real-time GPS geofencing and dynamic QR code scanning.

The application is architected for mobile-first usability and includes an offline-first engine that allows trainees to clock in without active internet connectivity, automatically queuing and synchronizing timestamps and coordinates once reconnected.

Administrators are equipped with a real-time command dashboard featuring live activity feeds, visual attendance heatmap matrices, automated discrepancy audit resolution, and one-click PDF/Excel report generation for institutional compliance.

1. Dual-Layer Attendance Validation

Enforces exact GPS geofencing perimeters alongside dynamic cryptographic QR code scanning (@zxing) to eliminate remote check-in fraud and proxy attendance.

2. Offline-First PWA Architecture

Installable on iOS and Android devices via Workbox service workers with offline IndexedDB/LocalStorage queueing and background auto-synchronization upon network reconnection.

3. Real-Time Admin Dashboard & Subscriptions

Live subscriptions powered by Supabase Realtime WebSockets and PostgreSQL Change Data Capture (CDC) for instant request approvals, live activity tracking, and device session monitoring with Row Level Security (RLS).

4. Automated Discrepancy Diagnostics

Intelligent diagnostic engine that scans for missing check-ins or duplicate entries, allowing users to submit adjustment requests directly to administrators with verified audit trails.

5. Institutional Reporting & Document Export

Automated client-side generation of structured .xlsx workbooks (ExcelJS) and multi-page .pdf compliance reports (jsPDF) with custom data tables for institutional audits.