Back to All Projects
Showcase/Information System
Case Study / 21

SISARANA

A web-based school facilities information system for managing asset requests, verification, and inventory reporting in a centralized and real-time environment.

RoleFullstack Developer
Timeline2024
CategoryInformation System
Core Stack
ReactRedux Toolkit
SISARANA
[ 01 / The Challenge ]

Understanding the Problem & Core Constraints

SISARANA is a web-based school assets information system. It automates inventory logistics, requests, and approvals across different departments in school environments.

Key Constraint

Handling multi-role authorization levels (admin, operator, teacher) and generating dynamic PDF asset logistics reports.

[ 02 / The Solution ]

Architectural Decisions & Core Implementation

Utilized Supabase Row Level Security (RLS) policies for user data validation and created a client-side print wrapper stylesheet.

[ Performance & Results ]
1.

Zero auth security gaps identified

2.

Asset requests processed in under 1s

3.

Automated inventory verification