Overview
Industrial awards management system built for Police Federation of Australia through Osky Interactive. Allows union delegates and members to search complex industrial award clauses and manage hierarchical award documents. Built as part of a small development team at Osky.
Challenge
Union delegates needed to quickly look up complex industrial award clauses, replacing time-consuming manual searches through legal documents. The system had to model a deep document hierarchy (Awards > Sections > Clauses > Conditions) and provide full-text search across award provisions under Australian industrial law.
Approach
Built a Laravel 9 monolith with Vue.js 3 and Inertia.js for SPA-like navigation without a separate API layer. Used Laravel Scout for full-text search across award content so delegates can find relevant clauses quickly. Modeled the document hierarchy in MySQL with nested relationships.
Tech Stack
| Layer | Technology |
|---|---|
| Backend | Laravel 9 |
| Frontend | Vue.js 3 |
| Routing | Inertia.js |
| Auth | Laravel Sanctum |
| Search | Laravel Scout |
| Database | MySQL |
| DomPDF, Browsershot |
Key Implementation Details
- Searchable database of industrial award clauses with full-text search via Laravel Scout
- Hierarchical document management modeling Awards > Sections > Clauses > Conditions
- PDF generation for award documents using DomPDF and Browsershot
Outcome
Deployed and used by Police Federation of Australia delegates for award clause lookups. Replaced manual searches through industrial award documents with full-text clause search via Laravel Scout. Delegates generate PDF reports directly from the platform.