SCILAB RESERVE 3.0
2026
A unified Science Laboratory Inventory and Reservation platform consisting of a Professor & Student Web Portal (deployed on Vercel) and a cross-platform Flutter Windows Desktop Admin Application—powered by Supabase PostgreSQL, PL/pgSQL atomic RPC functions, and Supabase Realtime.
PROBLEM & GOAL
Managing laboratory rooms, chemical stock/expiration, glassware, and equipment across courses and student sections required a strict two-tier verification workflow (Professor endorsement followed by Laboratory Admin approval), atomic inventory holds to prevent double-booking, and full audit trail accountability.
END-TO-END EXECUTION
Architected a dual-app ecosystem backed by Supabase. Built the Student & Professor web portals with Vanilla JS and Supabase JS v2 (featuring SMTP Edge Function OTP signup, cart-based resource borrowing, and an interactive 30-minute time-slot scheduler), paired with a Flutter Material 3 Windows Desktop Admin app featuring fl_chart analytics, atomic PL/pgSQL inventory hold RPCs, real-time notifications, audit logs, and PDF/Excel report exports.
- Student & Professor Web Portals (JavaScript, Supabase JS v2, Vercel)
- Flutter Windows Desktop Admin Application (Dart, Material 3, Inno Setup)
- Supabase PostgreSQL Schema (12 Tables) & PL/pgSQL Inventory Hold RPCs
- Two-Tier Approval Engine (Professor Review → Admin Final Approval)
- Real-Time Notifications, Audit Trail Logging & Stock History
- fl_chart Analytics, PDF & Excel Export Reporting
ROLE MODULE 01 // PROFESSOR PORTAL (10 SCREENS)
Professor
portal.
Dedicated faculty interface for booking laboratory sessions, reviewing and approving student reservation requests, verifying advisory student accounts, and monitoring unreturned equipment.
Professor overview displaying reservation metrics, quick actions, upcoming sessions, and weekly schedule preview.
Live Supabase Realtime notification drawer alerting the professor to new student reservation requests.
Professor resource catalog for reserving Chemicals, Equipment, and Glassware for upcoming class sessions.
First-tier approval queue where professors review, approve, or decline student laboratory reservation requests.
Detailed modal showing student course/section, dual approval badges (Professor + Admin), and borrowed resources.
Confirmed student reservations endorsed by the professor with quick-view details.
Advisory verification table for approving newly registered students under the professor.
Accountability table tracking students with unreturned laboratory equipment or glassware.
Complete historical log of the professor’s past laboratory reservations and statuses.
Professor account settings, role badge, and password security management.
ROLE MODULE 02 // STUDENT PORTAL (14 SCREENS)
Student
portal.
Student experience featuring OTP registration, interactive Chemicals/Equipment/Glassware catalogs, cart drawer, 30-minute time-slot scheduler, and two-tier approval tracking.
Student portal home showing active reservations, pending requests, announcements, and weekly schedule timeline.
Real-time updates notifying the student when a Professor or Admin approves or declines their request.
Interactive laboratory resource browser for Chemicals with live stock counts and availability checks.
Equipment inventory catalog (Microscopes, Bunsen burners, Hot plates, Iron stands) with instant cart selection.
Glassware catalog (Erlenmeyer flasks, Beakers, Test tubes, Burettes) with floating reservation cart.
Slide-out resource cart allowing students to adjust item quantities before choosing their schedule.
Calendar date picker paired with an interactive 30-minute timeline selector (7:00 AM – 7:30 PM) and course/professor auto-fill.
Student pending approvals table tracking both Professor Approval and Admin Approval statuses in real time.
Full breakdown of a pending student request showing dual approval states and allocated items.
Confirmed student laboratory bookings ready for equipment and chemical release.
Historical log of completed, declined, and past laboratory reservations.
Student profile displaying Course, Year & Section, assigned Adviser Professor, and security settings.
Unified SciLabReserve 2.0 sign-in portal for Students and Professors.
Student registration with Year & Section, Course selection, Adviser Professor assignment, and email OTP verification.
ROLE MODULE 03 // FLUTTER WINDOWS DESKTOP ADMIN APP (17 SCREENS)
Admin Desktop
application.
Native Windows Desktop administration suite built with Flutter & Dart (Material 3) and Supabase—featuring fl_chart analytics, final reservation approvals, room & chemical stock management, audit trail logging, OTP account provisioning, and PDF/Excel report generation.
Central command overview with reservation totals, quick actions, Top Courses by Reservations bar chart (fl_chart), status breakdown, and recent activity feed.
Comprehensive audit trail tracking LOGIN, APPROVE, UPDATE, and LOGOUT actions across entities with filters and report generation.
Immediate-approval reservation builder allowing admins to book Laboratory Rooms, Chemicals, Equipment, and Glassware.
Resource cart dialog with quantity controls before assigning a room or schedule.
Interactive date and 30-minute time-slot grid displaying Available, Reserved, Past, and Selected states.
Complete history across Students and Professors with search, status filters, Export by Account, and Generate Report (PDF/Excel).
Dedicated admin review queue for pending faculty laboratory reservations.
Second-tier admin approval queue for student reservations already endorsed by their professor.
Live tracker monitoring Ongoing, Overdue, Due Soon, and Completed laboratory sessions.
Master schedule of upcoming approved Student and Professor bookings with resource summaries.
Real-time room status manager (Physics Lab, Lecture Room, Chemistry Lab) toggling Available and Maintenance states.
Full inventory control for Chemicals (with expiration dates and stock updates), Equipment, and Glassware plus report export.
Tracks unreturned equipment across students and professors with one-click Return processing and report generation.
Publishes system-wide laboratory announcements directly to the Student and Professor web portals.
Admin user management for provisioning new Professor accounts via OTP, editing profiles, or revoking access.
Student directory and OTP account creation linking students to their Course, Year & Section, and Adviser Professor.
Native Windows desktop sign-in screen for SciLabReserve 2.0 laboratory administrators.
NEXT CASE STUDY // 04
WATER METER BILLING & READING
ANDROID STUDIO + JAVAFX + ROBOFLOW VISION + POSTGRESQL
VIEW NEXT PROJECT →