Project KNOT – System Milestones & Documentation

Team

Supervisor

Table of Contents

  1. Introduction
  2. Milestone Progress & Implemented Features
  3. Solution Architecture
  4. Software Designs
  5. Testing & System Validation
  6. Conclusion & Future Work
  7. Links

Introduction

The Problem

Universities and large educational institutions often suffer from highly fragmented administrative systems. Currently, the processes for booking academic resources (such as lecture halls, labs, and seminar rooms) and reporting infrastructure faults are disconnected. This leads to severe coordination issues between students, academic staff (lecturers), administrative registries (AR), and maintenance technicians. The real-world consequences include double-booked lecture halls, untracked maintenance requests that take weeks to resolve, and a general lack of transparency regarding request statuses.

The Solution

Project KNOT is a unified, centralized resource and maintenance management platform. It solves this fragmentation by offering a single, Role-Based Access Control (RBAC) ecosystem with specialized workflows for Students, Lecturers, Booking Admins, Maintenance Admins, and Field Technicians.

Milestone Progress & Implemented Features

🔹 Milestone 1: Core Foundation & Architecture

  1. Multi-Role Authentication & Role-Based Access Control (RBAC):
    • Built a secure login framework supporting Students, Lecturers, Booking Admins, Maintenance Admins, and Technicians.
  2. Resource Database Schema Normalization:
    • Initial database design for lecture halls, labs, and seminar rooms with capacity metrics and operational status tracking.
  3. UI Dashboard Framework:
    • Developed responsive Single Page Application (SPA) layouts using React.js and Tailwind CSS with glassmorphic elements and dark/light modes.

🔹 Milestone 2: Academic Booking Workflow & Maintenance Reporting

  1. Multi-Tier Academic Approval Workflow:
    • Implemented 3-stage reservation approval chain: Student Request ➡️ Lecturer Endorsement ➡️ Booking Admin Final Approval.
  2. Basic Fault Reporting Module:
    • Implemented issue submission features allowing campus users to report infrastructure faults with category tags and priority levels.

🌟 Milestone 3: Real-Time Availability Grid, Worker Portal, Bulk Schedule Import & System Integration

  1. Bulk Semester Schedule Import Implementation (Dean’s Requirement):
    • Master Timetable Ingestion Engine: Implemented specifically per the Dean’s requirement to handle pre-booked master semester timetables.
    • Automated Validation & Ingestion: Parses semester schedule files, extracts day/time/hall/lecturer attributes, automatically verifies conflicts against existing database reservations, skips overlapping slots, and bulk-populates recurring semester lectures into the system.
  2. Interactive Real-Time Hall Availability Grid:
    • Visual hourly slot selection grid (08:00 AM – 06:00 PM) replacing static dropdowns.
    • Real-time database queries displaying booked status badges (Available, Booked: [Purpose], Already Passed) and preventing double-booking over occupied ranges.
  3. Maintenance Worker Portal Integration & Admin Task Assignment:
    • Admin Task Assignment & Dispatch: Maintenance Admins review fault reports, assign specific technicians (Alex Johnson, Sam Carter), set priority levels, and attach technical directives.
    • Technician Task Queue (TechnicianDashboard): Technicians access a personal, real-time job queue filtering tickets assigned specifically to their ID.
    • Interactive Task Modal & Evidence Inspector: Technicians inspect location info, map coordinates, reporter notes, and user evidence photos.
    • Status Progression & Work Logs: Technicians update jobs in real-time (Open ➡️ In Progress ➡️ Resolved), add maintenance resolution notes, and upload proof-of-work photos upon completion.
  4. Booking Admin Portal Automated Approval System & Multi-Criteria Filtering:
    • Automated Reservation Approval Engine: Implemented an automated booking approval system in the Booking Admin Portal. When enabled (auto_booking: true), routine conflict-free hall booking requests are automatically validated against existing reservations and instantly approved (Approved) without administrative delay.
    • Configurable Control Panel: Configurable toggle in Booking Admin System Settings with persistent MySQL database state (settings table) allowing admins to toggle between automated approvals and manual AR office reviews.
    • Multi-Criteria Search & Filter: Filter by Search Text (matching room, lecturer name, user role, or purpose), Multi-Select Room badges (e.g., EOE Hall, DO1, Lecture Hall 1), Quick Date Presets (Today, Tomorrow, This Week, Future), Custom Date Ranges, and Status (Approved, Pending AR, Pending, Rejected).
    • Flexible Sorting: Sort table rows by Date (Newest/Oldest), Lecture Hall Name, or Status.
  5. Semester Timetable Calendar Enhancements:
    • Native HTML5 datepicker calendar integration.
    • Datepicker-filtered Agenda View displaying lectures strictly for selected dates.
    • Dedicated single-room grid timeline view when filtering by a specific hall.
    • Standardized 10 uniform lecture hall names across all UI elements and database schemas (EOE Hall, DO1, DO2, Lecture Hall 1, Lecture Hall 2, Seminar Room 1, Seminar Room 2, Computer Lab 1, Computer Lab 2, Main Auditorium).
  6. Maintenance Reporting & Admin Evidence Viewer:
    • Integrated OpenStreetMap (Leaflet) with reverse geocoding (Nominatim API) and map pin dropping.
    • High-resolution photo evidence upload support with 50MB JSON payload limits.
    • Maintenance Admin Ticket Details view with a dedicated Evidence Photo Viewer.

Solution Architecture

Project KNOT utilizes a modern, decoupled Client-Server Architecture to ensure scalability and maintainability.

Software Designs

3.1 User Interface (UI) Design

The system employs a “View-Based Navigation” architecture. Dashboards utilize dynamic component rendering and RBAC authentication guards to seamlessly mount appropriate interfaces for Students, Lecturers, Booking Admins, Maintenance Admins, and Technicians.

3.2 Database Schema Design

Normalized relational schema:

3.3 Business Logic & Workflow Designs

  1. Dean’s Bulk Timetable Ingestion: Booking Admin uploads master schedule file ➡️ Backend parses slots & validates conflicts ➡️ Bulk inserts valid semester lectures into database.
  2. Multi-Criteria Booking Filter & Sort: Booking Admin toggles room badges, date ranges, and status pills ➡️ Dynamic client-side filter engine updates “All Bookings” table instantly.
  3. Worker Task Assignment: Maintenance Admin assigns fault ticket ➡️ Assigned Technician views task on Worker Portal, updates status (In Progress ➡️ Resolved), logs work, and uploads proof photo.

Testing & System Validation

Testing was conducted across all system tiers to validate Milestone 1, 2, and 3 requirements:

Conclusion & Future Work

What Was Achieved

We successfully designed, developed, integrated, and validated all three Milestones of Project KNOT. The platform provides a complete academic resource booking system, Dean’s bulk semester timetable import, multi-criteria booking search and sorting, a complete Maintenance Worker Portal with admin task assignment, real-time conflict-free hall scheduling, map-integrated fault reporting, and admin evidence inspection.

Future Developments