Overview
SIPENA (Sistem Informasi Penataan dan Regulasi) is the regulation and organizational structuring system of the Sekretariat Daerah (Regional Secretariat) of Badung Regency, Bali. It brings regional legal products, regulation drafting, proposals for organizational change, and structured assessments of government units into one application.
I built this as a freelance project using Laravel 12 with React 18 via Inertia.js. It is live at sipena.badungkab.go.id.
Challenge
Several kinds of administrative work had to live in one place, each with its own users and rules. Government units needed to complete scored self-assessments and see how they ranked. Drafts of new regulations and proposals for organizational change needed review and approval with a record of every revision. And the regency's published legal products needed a catalog people could actually search.
Approach
I chose Laravel 12 with Inertia.js and React 18 for a single-codebase full-stack application, so there is no separate API to maintain. shadcn/ui provides accessible component primitives, and Recharts powers the dashboards for assessment results and unit rankings.
Each module has its own service layer. Assessment scores for organizational maturity and institutional evaluation are calculated in dedicated scoring services, which feed a ranking service and the public statistics pages. Drafts and proposals move through approval workflows that keep a revision history, and an audit log records changes. Users sign in through the regency's single sign-on, and access is split by role. An OpenAI-based extraction service reads uploaded PDF documents and suggests field values, which staff confirm before anything is saved.
The main flows are covered by 28 Playwright end-to-end specs.
Tech Stack
| Layer | Technology |
|---|---|
| Backend | Laravel 12 |
| Frontend | React 18, TypeScript, Inertia.js |
| Styling | Tailwind CSS |
| Components | shadcn/ui |
| Charting | Recharts |
| Reports | DomPDF, Excel export |
| AI | OpenAI API (document extraction, suggestions only) |
| Testing | Playwright |
Key Implementation Details
- Scored assessments of government units for organizational maturity and institutional evaluation, with unit rankings and public statistics
- Drafting and approval workflows for regulations and organizational change proposals, with revision history and an audit log
- Searchable catalog of regional legal products and a central document manager
- Sign-in through the regency's SSO, with role-based access for admins, operators, and other users
- PDF and Excel exports of assessment reports and data
- 28 Playwright end-to-end specs covering the main flows
Outcome
SIPENA is live at sipena.badungkab.go.id and in use by the Badung Regency regional secretariat for its assessment, regulation, and organizational structuring work.