Work

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