PORTFOLIO / 2026 // V2.6 ONLINE
← BACK TO ARCHIVE CASE STUDY // 03 — WEB

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.

+ JavaScript (ES6+)+ Flutter & Dart (Windows Desktop)+ Supabase (PostgreSQL & Auth)+ PL/pgSQL RPC Functions+ Supabase Realtime & Edge Functions+ fl_chart / PDF & Excel Export+ Vercel
03 / SUPABASE + FLUTTER DESKTOP + WEB ECOSYSTEM ORG // Academic Science Laboratory (Confidential Institution)
WEB + DESKTOP
ECOSYSTEM
12 TABLES
DB TABLES
2-TIER RPC
APPROVAL FLOW
01 // THE CHALLENGE ROLE: Full-Stack Web & Flutter Desktop Developer

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.

02 // THE SOLUTION YEAR: 2026

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.

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.
STU 01 // STUDENT DASHBOARD ↗

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.
STU 02 // STUDENT NOTIFICATIONS DRAWER ↗

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.
STU 03 // CATALOG — CHEMICALS INVENTORY ↗

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.
STU 04 // CATALOG — LAB EQUIPMENT ↗

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.
STU 05 // CATALOG — GLASSWARE ↗

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.
STU 06 // RESERVATION CART DRAWER ↗

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.
STU 07 // INTERACTIVE DATE & TIME-SLOT SCHEDULER ↗

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.
STU 08 // TWO-TIER PENDING APPROVALS ↗

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.
STU 09 // PENDING RESERVATION DETAILS MODAL ↗

Full breakdown of a pending student request showing dual approval states and allocated items.

Confirmed student laboratory bookings ready for equipment and chemical release.
STU 10 // APPROVED RESERVATIONS ↗

Confirmed student laboratory bookings ready for equipment and chemical release.

Historical log of completed, declined, and past laboratory reservations.
STU 11 // STUDENT RESERVATION HISTORY ↗

Historical log of completed, declined, and past laboratory reservations.

Student profile displaying Course, Year & Section, assigned Adviser Professor, and security settings.
STU 12 // STUDENT PROFILE & ADVISER SETTINGS ↗

Student profile displaying Course, Year & Section, assigned Adviser Professor, and security settings.

Unified SciLabReserve 2.0 sign-in portal for Students and Professors.
STU 13 // AUTHENTICATION GATEWAY ↗

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.
STU 14 // OTP STUDENT REGISTRATION ↗

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.
ADM 01 // ADMIN DASHBOARD & ANALYTICS ↗

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.
ADM 02 // SYSTEM AUDIT TRAIL LOGS ↗

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.
ADM 03 // DIRECT ADMIN RESERVATION ↗

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.
ADM 04 // ADMIN RESOURCE CART MODAL ↗

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.
ADM 05 // ADMIN SCHEDULE & SLOT PICKER ↗

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).
ADM 06 // MASTER RESERVATION HISTORY & REPORTS ↗

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.
ADM 07 // PROFESSOR RESERVATIONS APPROVAL QUEUE ↗

Dedicated admin review queue for pending faculty laboratory reservations.

Second-tier admin approval queue for student reservations already endorsed by their professor.
ADM 08 // STUDENT RESERVATIONS APPROVAL QUEUE ↗

Second-tier admin approval queue for student reservations already endorsed by their professor.

Live tracker monitoring Ongoing, Overdue, Due Soon, and Completed laboratory sessions.
ADM 09 // ONGOING & OVERDUE MONITOR ↗

Live tracker monitoring Ongoing, Overdue, Due Soon, and Completed laboratory sessions.

Master schedule of upcoming approved Student and Professor bookings with resource summaries.
ADM 10 // UPCOMING RESERVATIONS SCHEDULE ↗

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.
ADM 11 // LABORATORY ROOM MONITOR ↗

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.
ADM 12 // INVENTORY & CHEMICAL EXPIRATION MANAGER ↗

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.
ADM 13 // UNRETURNED ITEMS & RETURN PROCESSING ↗

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.
ADM 14 // ANNOUNCEMENTS BROADCAST MANAGER ↗

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.
ADM 15 // MANAGE PROFESSOR ACCOUNTS ↗

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.
ADM 16 // MANAGE STUDENT ACCOUNTS ↗

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.
ADM 17 // WINDOWS DESKTOP AUTHENTICATION ↗

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 →