SIPASTI
Information system for reporting and repairing campus infrastructure
LaravelMySQL
Context
SIPASTI is an information system for repair and recording of infrastructure facilities, built with Laravel and MySQL. It was my fourth-semester final project, built with four teammates over roughly two months. The system is registered for Intellectual Property Rights under registration number 000910879.
The problem it solves is mundane and universal: on campus, broken facilities get reported by word of mouth, get lost, and never get fixed. SIPASTI replaces that with a tracked pipeline from report to repair.
Four roles, one pipeline
The system serves four distinct roles, each with a scoped view of the same pipeline:
- Admin : manages the system and facilities data.
- Civitas : students, staff, and lecturers. Report and request repairs of infrastructure facilities.
- Sarpras : reviews and verifies reports, then assigns a technician.
- Teknisi : performs the repair and closes the loop.
Features
Reporting
Civitas reports a problem; the report lands in Sarpras's review queue. The form is deliberately narrow — facility, location, description — because a report pipeline fails when reporting is friction.
Feedback
After a repair is closed, civitas rates how well the problem was resolved. That rating feeds back into Sarpras's queue as history, so repeat offenders surface.
Decision support
The feature I'm proudest of: a decision-support engine that ranks open reports by priority instead of arrival order. It scores each report on several variables using two weighted methods — SAW (Simple Additive Weighting) and MOORA (Multi-Objective Optimization by Ratio Analysis) — and outputs a ranked list.