hdflex-intelligence
Standalone Laravel reporting dashboard for Heartland HDflex dental staffing production data with RDO/RMO-level insights.
11 commits over 5 days
What it is
HDflex Intelligence is a dedicated reporting application for Heartland's dental staffing operations. It provides production dashboards, shift-by-RDO analysis, and RDO totals reports with filters, drill-downs, and Excel/CSV exports. The app reads from multiple MySQL databases (HDflex production, Kwikly marketplace, and its own app DB for user authentication) and maps shifts to organizational hierarchy (Regional Directors and Managers) using imported CSV data or Heartland's hierarchy exports.
Why I built it
Forked from KwiklyBI to create a focused, standalone reporting tool specifically for Heartland HDflex stakeholders (leadership/ops). The goal was to strip out unrelated multi-tenant BI features, replace Google OAuth with simple email/password auth (Laravel Breeze), and provide streamlined access to HDflex-specific metrics—particularly shift volume, fill rates, and cancellations grouped by RDO and RMO for operational visibility.
Tech stack
Laravel 12 (PHP 8.4), Laravel Breeze (Blade, email/password auth), MySQL (three connections: app DB for users/sessions, read-only HDflex production DB, read-only Kwikly marketplace DB), Tailwind CSS, Alpine.js, Vite, Maatwebsite/Laravel Excel for multi-sheet exports. Artisan commands for CSV import and RDO/RMO mapping generation.
Timeline & effort
Last active Jan 17, 2026 — 11 commits across 5 active days (spanning 91 days).
Development spanned 91 calendar days (March to June 2026) with 11 commits across 5 distinct active days. Activity was concentrated in March (6 commits), with follow-up work in April (3 commits) and June (2 commits), suggesting focused sprint-style work sessions rather than continuous daily development.
Did it turn out useful?
The application is deployed as a functional internal reporting tool for Heartland HDflex. It has structured documentation (PROJECT_CONTEXT, PRDs, testing guides), complete auth flows, multiple reporting endpoints with export capabilities, comprehensive cursor rules for ongoing development, CI/CD pipeline (GitHub Actions deploy workflow), and a clear stakeholder (Heartland leadership/ops). The lack of homepage/public deployment is expected for internal reporting tools. Test suite exists and reports are actively maintained.