Platform & Data Systems
SIRAPAT
Kota Binjai
- Year
- 2026
- Role
- Full-stack developer
Parking-levy reporting for the Ikan Paus bus terminal in Binjai. Field transactions in cash or QRIS flow into one daily report per operator, up an approval chain, and out as signed leadership reports.
The problem
Levy records were written on a log sheet and then retyped into Excel. Money arrived as cash and QRIS with no reconciliation between them, tariff changes rewrote history instead of versioning it, and approvals travelled by word of mouth, so nobody could monitor collection in real time or produce an auditable report.
What I did
- Modelled the money path: field transactions in cash and QRIS, one revisable daily report per operator per day, then a confirm, verify, approve chain across koordinator, bendahara, and kepala UPT. An approved report locks that day's transactions.
- Made tariffs immutable and versioned: a new rate takes effect from a date and retires the old row instead of editing it, so the full rate history survives.
- Sent workflow events over WhatsApp through a self-hosted WAHA gateway, best-effort so a gateway outage never blocks a transaction.
- Generated the financial PDF with the signer's NIP electronic signature, plus Excel export, deposit reconciliation, and QR-code document verification.
- Replaced role if-checks with a 36-permission RBAC matrix across 6 roles, and run the app on Octane.
Impact
- 105
- commits
- 6
- roles on a 36-permission matrix
- Cash + QRIS
- reconciled in one daily report
Links
Stack
- Laravel 13
- PHP 8.5
- Octane
- Livewire 4
- Tailwind v4
- MySQL
- Pest
- Larastan
- Laravel Sail